DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_API_TYPES

Line 4: g_log_level_rec fa_api_types.log_level_rec_type;

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,

Line 13: x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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

Line 36: x_life NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return date is

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

Line 75: x_err_stack in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) 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

Line 228: x_err_stack in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) 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);

Line 350: x_err_stack in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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;

Line 372: l_trans_rec FA_API_TYPES.trans_rec_type;

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;

Line 373: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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);

Line 374: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;

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;

Line 375: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;

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);

Line 439: x_err_code out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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,

Line 479: l_trans_rec fa_api_types.trans_rec_type;

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;

Line 480: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

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;

Line 482: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

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:

Line 537: PROCEDURE do_adjustment( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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

Line 538: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

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:

Line 541: x_err_code OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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;

Line 543: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_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;
546: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
547: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 544: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_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;

Line 545: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_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;

Line 546: l_inv_trans_rec FA_API_TYPES.inv_trans_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;

Line 547: l_inv_tbl FA_API_TYPES.inv_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;

Line 548: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_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;

Line 549: l_asset_deprn_rec_new 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;

Line 550: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_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;
554:

Line 551: l_inv_rec FA_API_TYPES.inv_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:
555: l_return_status VARCHAR2(1);

Line 552: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_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);
556: l_mesg_count number := 0;

Line 553: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_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;
557: l_mesg_len number;

Line 660: l_trans_rec FA_API_TYPES.trans_rec_type;

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';

Line 795: PROCEDURE process_batch( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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);

Line 797: p_amortize_flag IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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;

Line 984: PROCEDURE process_asset( px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

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,

Line 990: x_err_attr_name OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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;

Line 1036: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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;

Line 1037: l_asset_cat_rec_new FA_API_TYPES.asset_cat_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;

Line 1038: l_recl_opt_rec FA_API_TYPES.reclass_options_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;

Line 1040: l_asset_desc_rec FA_API_TYPES.asset_desc_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:

Line 1041: l_asset_type_rec FA_API_TYPES.asset_type_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:
1045: -- Adjustment parameters

Line 1042: l_asset_cat_rec 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
1046: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

Line 1043: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_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;

Line 1046: l_asset_fin_rec_adj 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;

Line 1047: l_asset_fin_rec_new FA_API_TYPES.asset_fin_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;
1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 1048: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_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;
1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 1049: l_inv_trans_rec FA_API_TYPES.inv_trans_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;

Line 1050: l_inv_tbl FA_API_TYPES.inv_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;

Line 1051: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_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;

Line 1052: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_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:

Line 1053: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_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:
1057: l_request_id number(15);

Line 1054: l_inv_rec FA_API_TYPES.inv_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);
1058:

Line 1055: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_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:
1059: l_update_attribute varchar2(1):= 'N';