In order to Amend or create a line in Lease Options of Property Management module in Oracle Apps r12 through API:
Sample code:
DECLARE
V_ROWID VARCHAR2 (500);
V_LEASE_CHANGE_ROWID VARCHAR2 (500);
V_LEASE_CHANGE_ID NUMBER;
V_LEASE_CHANGE_NUMBER NUMBER;
V_OPTION_ID NUMBER;
V_OPTION_NUM VARCHAR2 (50);
BEGIN
BEGIN
PN_LEASE_CHANGES_PKG.Insert_Row (
X_ROWID => V_LEASE_CHANGE_ROWID,
X_LEASE_CHANGE_ID => V_LEASE_CHANGE_ID,
X_LEASE_ID => 413335,
X_LEASE_CHANGE_NUMBER => V_LEASE_CHANGE_NUMBER,
X_LEASE_CHANGE_NAME => 'EDIT',
X_RESPONSIBLE_USER => NULL,
X_CHANGE_COMMENCEMENT_DATE => NULL,
X_CHANGE_TERMINATION_DATE => NULL,
X_CHANGE_TYPE_LOOKUP_CODE => 'EDIT',
X_CHANGE_EXECUTION_DATE => NULL,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_ABSTRACTED_BY_USER => NULL,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => -1,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => -1,
X_LAST_UPDATE_LOGIN => NULL,
x_org_id => 27775,
x_cutoff_date => NULL);
COMMIT;
DBMS_OUTPUT.put_line (
'X_LEASE_CHANGE_ID:'
|| V_LEASE_CHANGE_ID
|| 'X_LEASE_CHANGE_NUMBER:'
|| V_LEASE_CHANGE_NUMBER);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (
'In PN_LEASE_CHANGES_PKG Exception:' || SQLERRM);
END;
pn_options_pkg.insert_row (x_rowid => V_ROWID,
x_option_id => V_OPTION_ID,
x_option_num => V_OPTION_NUM,
x_lease_id => 413335,
x_lease_change_id => V_LEASE_CHANGE_ID,
x_option_type_code => 'TERM', /*Input Option type Code from ‘PN_LEASE_OPTION_TYPE’ */
x_start_date => '15-Jun-2010',
x_expiration_date => '15-Jun-2010',
x_option_size => NULL,
x_uom_code => NULL,
x_option_status_lookup_code => 'OPEN',
x_attribute_category => NULL,
x_attribute1 => NULL,
x_attribute2 => NULL,
x_attribute3 => NULL,
x_attribute4 => NULL,
x_attribute5 => NULL,
x_attribute6 => NULL,
x_attribute7 => NULL,
x_attribute8 => NULL,
x_attribute9 => NULL,
x_attribute10 => NULL,
x_attribute11 => NULL,
x_attribute12 => NULL,
x_attribute13 => NULL,
x_attribute14 => NULL,
x_attribute15 => NULL, /*WHO columns*/
x_creation_date => SYSDATE,
x_created_by => -1,
x_last_update_date => SYSDATE,
x_last_updated_by => -1,
x_last_update_login => NULL,
x_option_exer_start_date => NULL,
x_option_exer_end_date => NULL,
x_option_action_date => NULL,
x_option_cost => NULL,
x_option_area_change => NULL,
x_option_reference => NULL,
x_option_notice_reqd => 'N',
x_option_comments => NULL,
x_org_id => 27775
-- x_option_frequency_code => 'OT',
-- x_VENDOR_ID => 7572437,
-- x_vendor_site_id => 2506534,
-- X_CURRENCY_CODE => 'BDT' ,
-- X_RATE => null,
-- x_ACTUAL_AMOUNT => 42105.26,
-- X_ESCALATION_AMOUNT => null,
-- X_SCHEDULE_DAY => 14 ,
-- X_ROU_ASSET_FLAG => null
);
COMMIT;
DBMS_OUTPUT.put_line (
'V_OPTION_ID:' || V_OPTION_ID || 'V_OPTION_NUM:' || V_OPTION_ID);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('In Exception:' || SQLERRM);
END;
