[Home] [Help]
29: X_impairment_reserve NUMBER DEFAULT NULL,
30: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
31: X_set_of_books_id NUMBER ,
32: X_Calling_Fn VARCHAR2
33: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
34:
35: CURSOR C_ds IS SELECT rowid FROM fa_deprn_summary
36: WHERE asset_id = X_Asset_Id
37: AND book_type_code = X_Book_Type_Code
206: X_Reval_Reserve NUMBER DEFAULT NULL,
207: X_Ytd_Production NUMBER DEFAULT NULL,
208: X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
209: X_Calling_Fn VARCHAR2
210: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
211: CURSOR C IS
212: SELECT book_type_code,
213: asset_id,
214: deprn_run_date,
321: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
322: X_set_of_books_id NUMBER ,
323: X_Calling_Fn VARCHAR2
324:
325: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
326:
327: BEGIN
328:
329: if (X_rowid is not null) then
759: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
760: X_Asset_Id NUMBER DEFAULT NULL,
761: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
762: X_set_of_books_id NUMBER ,
763: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
764:
765: BEGIN
766:
767: if (X_mrc_sob_type_code = 'R') then
804:
805:
806: PROCEDURE Lock_B_Row(X_Book_Type_Code VARCHAR2 DEFAULT NULL,
807: X_Asset_Id NUMBER,
808: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
809: CURSOR C_Books IS
810: SELECT book_type_code,
811: asset_id,
812: date_placed_in_service,
1024: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1025: END Lock_B_Row;
1026:
1027:
1028: PROCEDURE UnLock_B_Row(X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1029: BEGIN
1030:
1031: rollback;
1032: