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) IS
50: CURSOR C IS SELECT rowid FROM fa_leases
51: WHERE lease_id = X_Lease_Id;
52: BEGIN
53:
186: X_CURRENCY_CODE VARCHAR2,
187: X_Calling_Fn VARCHAR2
188:
189:
190: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
191:
192: CURSOR C IS
193: SELECT *
194: FROM fa_leases
346: X_DIST_CODE_COMBINATION_ID NUMBER,
347: X_TERMS_ID NUMBER,
348: X_Calling_Fn VARCHAR2
349:
350: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
351: BEGIN
352: UPDATE fa_leases
353: SET
354: lease_id = X_lease_id,
403: END Update_Row;
404: --
405: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
406: X_Lease_Id NUMBER DEFAULT NULL,
407: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
408: BEGIN
409: if X_Rowid is not null then
410: DELETE FROM fa_leases
411: WHERE rowid = X_Rowid;