1: PACKAGE BODY FA_CUA_MASS_UPDATE1_PKG as
2: /* $Header: FACMUP1MB.pls 120.6 2009/08/20 14:18:04 bridgway ship $*/
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: ----------------------------------------------------------------
7: PROCEDURE CALC_LIFE_ENDDATE( x_prorate_date DATE,
8: x_end_date IN OUT NOCOPY DATE,
9: x_prorate_convention_code IN VARCHAR2,
10: x_life IN NUMBER,
11: x_err_code IN OUT NOCOPY VARCHAR2,
12: x_err_stage IN OUT NOCOPY VARCHAR2,
13: x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
14: /*
15: CURSOR C IS
16: select conv.prorate_date
17: from fa_conventions conv
32:
33: ----------------------------------------------------------------
34: FUNCTION GET_END_DATE(x_book_type_code VARCHAR2,
35: x_prorate_date DATE,
36: x_life NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return date is
37: /** commneted for bugfix 1055453 */
38: /* this cursor displays life_end_date incorrectly ( to the last period_date defined )
39: if the life fell beyond existing calendar periods
40: CURSOR C IS
71: x_deprn_method IN VARCHAR2,
72: x_life IN OUT NOCOPY number,
73: x_err_code in out nocopy varchar2 ,
74: x_err_stage in out nocopy varchar2 ,
75: x_err_stack in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
76: -- bugfix 1210531
77: -- to improve peroformance do not use this cursor
78:
79: CURSOR GET_LIFE IS
224: X_New_Cat_Type IN OUT NOCOPY VARCHAR2,
225: X_Lease_Id NUMBER,
226: x_err_code in out nocopy varchar2 ,
227: x_err_stage in out nocopy varchar2 ,
228: x_err_stack in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
229:
230: ll_corp_book varchar2(30);
231: ll_count number;
232: ll_mesg varchar2(50);
346: x_old_cat_id in number,
347: x_new_cat_id in number,
348: x_err_code in out nocopy varchar2 ,
349: x_err_stage in out nocopy varchar2 ,
350: x_err_stack in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
351:
352: --l_status Boolean := TRUE;
353: l_old_stack varchar2(600);
354: --l_thid number;
368: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
369: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
370: l_calling_fn VARCHAR2(20) := 'update_category';
371:
372: l_trans_rec FA_API_TYPES.trans_rec_type;
373: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
374: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
375: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
376: l_count NUMBER;
369: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
370: l_calling_fn VARCHAR2(20) := 'update_category';
371:
372: l_trans_rec FA_API_TYPES.trans_rec_type;
373: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
374: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
375: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
376: l_count NUMBER;
377: l_return_status VARCHAR2(100);
370: l_calling_fn VARCHAR2(20) := 'update_category';
371:
372: l_trans_rec FA_API_TYPES.trans_rec_type;
373: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
374: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
375: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
376: l_count NUMBER;
377: l_return_status VARCHAR2(100);
378: l_msg_count NUMBER := 0;
371:
372: l_trans_rec FA_API_TYPES.trans_rec_type;
373: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
374: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
375: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
376: l_count NUMBER;
377: l_return_status VARCHAR2(100);
378: l_msg_count NUMBER := 0;
379: l_msg_data VARCHAR2(4000);
435: p_asset_id in number,
436: p_book_type_code in varchar2,
437: p_new_hr_dist_set_id in number,
438: p_transaction_date in date,
439: x_err_code out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
440:
441: CURSOR GET_DIST_HIST IS
442: SELECT
443: DH.ROWID,
475: l_return_status varchar2(1);
476: l_msg_count number:= 0;
477: l_msg_data varchar2(4000);
478:
479: l_trans_rec fa_api_types.trans_rec_type;
480: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
481:
482: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
483: i binary_integer;
476: l_msg_count number:= 0;
477: l_msg_data varchar2(4000);
478:
479: l_trans_rec fa_api_types.trans_rec_type;
480: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
481:
482: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
483: i binary_integer;
484: tfr_error EXCEPTION;
478:
479: l_trans_rec fa_api_types.trans_rec_type;
480: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
481:
482: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
483: i binary_integer;
484: tfr_error EXCEPTION;
485: Begin
486:
533: End;
534:
535:
536: -- ------------------------------------------
537: PROCEDURE do_adjustment( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
538: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
539: x_new_life IN NUMBER,
540: p_amortize_flag IN VARCHAR2,
541: x_err_code OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
534:
535:
536: -- ------------------------------------------
537: PROCEDURE do_adjustment( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
538: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
539: x_new_life IN NUMBER,
540: p_amortize_flag IN VARCHAR2,
541: x_err_code OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
542:
537: PROCEDURE do_adjustment( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
538: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
539: x_new_life IN NUMBER,
540: p_amortize_flag IN VARCHAR2,
541: x_err_code OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
542:
543: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
544: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
539: x_new_life IN NUMBER,
540: p_amortize_flag IN VARCHAR2,
541: x_err_code OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
542:
543: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
544: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
540: p_amortize_flag IN VARCHAR2,
541: x_err_code OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
542:
543: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
544: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
541: x_err_code OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
542:
543: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
544: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
542:
543: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
544: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
543: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
544: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
551: l_inv_rec FA_API_TYPES.inv_rec_type;
544: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
551: l_inv_rec FA_API_TYPES.inv_rec_type;
552: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
551: l_inv_rec FA_API_TYPES.inv_rec_type;
552: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
553: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
551: l_inv_rec FA_API_TYPES.inv_rec_type;
552: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
553: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
554:
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
551: l_inv_rec FA_API_TYPES.inv_rec_type;
552: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
553: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
554:
555: l_return_status VARCHAR2(1);
548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
551: l_inv_rec FA_API_TYPES.inv_rec_type;
552: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
553: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
554:
555: l_return_status VARCHAR2(1);
556: l_mesg_count number := 0;
549: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
551: l_inv_rec FA_API_TYPES.inv_rec_type;
552: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
553: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
554:
555: l_return_status VARCHAR2(1);
556: l_mesg_count number := 0;
557: l_mesg_len number;
656: AND batch_number <= nvl(X_to_batch_number,batch_number)
657: order by creation_date;
658: --FOR UPDATE NOWAIT;
659:
660: l_trans_rec FA_API_TYPES.trans_rec_type;
661:
662: BEGIN
663:
664: retcode := '0';
791: -- Set to Rejected and changes for accepted assets is rolled back
792: -- as if they had not been processed at all
793: -- -------------------------------------------------------------
794:
795: PROCEDURE process_batch( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
796: p_batch_id IN NUMBER ,
797: p_amortize_flag IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
798: l_asset_id number;
799: l_book varchar2(30);
793: -- -------------------------------------------------------------
794:
795: PROCEDURE process_batch( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
796: p_batch_id IN NUMBER ,
797: p_amortize_flag IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
798: l_asset_id number;
799: l_book varchar2(30);
800: l_dummy varchar2(1);
801: l_status boolean;
980:
981: End;
982:
983:
984: PROCEDURE process_asset( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
985: p_batch_id IN NUMBER,
986: p_asset_id IN NUMBER,
987: p_book IN VARCHAR2,
988: p_amortize_flag IN VARCHAR2,
986: p_asset_id IN NUMBER,
987: p_book IN VARCHAR2,
988: p_amortize_flag IN VARCHAR2,
989: x_err_code OUT NOCOPY VARCHAR2,
990: x_err_attr_name OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
991:
992: l_asset_id number;
993: l_new_life number;
994: l_old_life number;
1032: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
1033: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1034: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1035:
1036: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1037: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1038: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1039:
1040: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1033: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1034: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1035:
1036: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1037: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1038: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1039:
1040: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1041: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1034: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1035:
1036: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1037: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1038: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1039:
1040: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1041: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1042: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1036: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1037: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1038: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1039:
1040: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1041: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1042: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1043: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1044:
1037: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1038: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1039:
1040: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1041: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1042: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1043: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1044:
1045: -- Adjustment parameters
1038: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
1039:
1040: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1041: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1042: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1043: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1044:
1045: -- Adjustment parameters
1046: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1039:
1040: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1041: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1042: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1043: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1044:
1045: -- Adjustment parameters
1046: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1047: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1042: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1043: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1044:
1045: -- Adjustment parameters
1046: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1047: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1048: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1049: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1043: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1044:
1045: -- Adjustment parameters
1046: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1047: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1048: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1049: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1044:
1045: -- Adjustment parameters
1046: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1047: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1048: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1049: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1045: -- Adjustment parameters
1046: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1047: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1048: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1049: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1053: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1046: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1047: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1048: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1049: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1053: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1054: l_inv_rec FA_API_TYPES.inv_rec_type;
1047: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1048: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1049: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1053: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1054: l_inv_rec FA_API_TYPES.inv_rec_type;
1055: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1048: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1049: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1053: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1054: l_inv_rec FA_API_TYPES.inv_rec_type;
1055: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1056:
1049: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1053: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1054: l_inv_rec FA_API_TYPES.inv_rec_type;
1055: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1056:
1057: l_request_id number(15);
1050: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1053: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1054: l_inv_rec FA_API_TYPES.inv_rec_type;
1055: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1056:
1057: l_request_id number(15);
1058:
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1053: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1054: l_inv_rec FA_API_TYPES.inv_rec_type;
1055: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1056:
1057: l_request_id number(15);
1058:
1059: l_update_attribute varchar2(1):= 'N';