133: X_prior_life_in_months NUMBER DEFAULT NULL,
134: X_prior_basic_rate NUMBER DEFAULT NULL,
135: X_prior_adjusted_rate NUMBER DEFAULT NULL, -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
136: X_period_counter_fully_extend NUMBER DEFAULT NULL -- Bug 7576755
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type ) IS
138: CURSOR C_bk IS SELECT rowid FROM fa_books
139: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
140:
141: CURSOR C_bk_mc IS SELECT rowid FROM fa_mc_books
727: X_Period_Counter_Life_Complete NUMBER DEFAULT NULL,
728: X_Adjusted_Recoverable_Cost NUMBER DEFAULT NULL,
729: X_Cash_Generating_Unit_Id NUMBER DEFAULT NULL,
730: X_Calling_Fn VARCHAR2
731: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
732: CURSOR C IS
733: SELECT book_type_code,
734: asset_id,
735: date_placed_in_service,
1057: X_prior_deprn_method VARCHAR2 DEFAULT NULL,
1058: X_prior_life_in_months NUMBER DEFAULT NULL,
1059: X_prior_basic_rate NUMBER DEFAULT NULL,
1060: X_prior_adjusted_rate NUMBER DEFAULT NULL -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
1061: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1062:
1063: BEGIN
1064:
1065: if (X_mrc_sob_type_code = 'R') then
2462: X_Transaction_Header_Id_In NUMBER DEFAULT NULL,
2463: X_Asset_Id NUMBER DEFAULT NULL,
2464: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
2465: X_set_of_books_id NUMBER ,
2466: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
2467: BEGIN
2468:
2469: if (X_mrc_sob_type_code = 'R') then
2470: if X_Rowid is not null then
2511:
2512: PROCEDURE Reactivate_Row(X_Transaction_Header_Id_Out NUMBER,
2513: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
2514: X_set_of_books_id NUMBER ,
2515: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
2516:
2517: BEGIN
2518:
2519: if (X_mrc_sob_type_code = 'R') then
2550: X_transaction_header_id_out NUMBER,
2551: X_date_ineffective DATE DEFAULT SYSDATE,
2552: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
2553: X_set_of_books_id NUMBER ,
2554: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
2555:
2556: BEGIN
2557:
2558: if (X_mrc_sob_type_code = 'R') then