[Home] [Help]
45: X_LESSOR_SITE_ID NUMBER,
46: X_DIST_CODE_COMBINATION_ID NUMBER,
47: X_TERMS_ID NUMBER,
48: X_Calling_Fn VARCHAR2,
49: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
50: CURSOR C IS SELECT rowid FROM fa_leases
51: WHERE lease_id = X_Lease_Id;
52: BEGIN
53:
185: X_LEASE_TERM NUMBER,
186: X_ASSET_LIFE NUMBER,
187: X_CURRENCY_CODE VARCHAR2,
188: X_Calling_Fn VARCHAR2,
189: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
190:
191: CURSOR C IS
192: SELECT *
193: FROM fa_leases
343: X_LESSOR_SITE_ID NUMBER,
344: X_DIST_CODE_COMBINATION_ID NUMBER,
345: X_TERMS_ID NUMBER,
346: X_Calling_Fn VARCHAR2,
347: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
348: BEGIN
349: UPDATE fa_leases
350: SET
351: lease_id = X_lease_id,
402: --
403: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
404: X_Lease_Id NUMBER DEFAULT NULL,
405: X_Calling_Fn VARCHAR2,
406: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
407: BEGIN
408: if X_Rowid is not null then
409: DELETE FROM fa_leases
410: WHERE rowid = X_Rowid;