5: TYPE date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
6: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
7:
8: FUNCTION do_group_reclass
9: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
10: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
11: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
12: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
6: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
7:
8: FUNCTION do_group_reclass
9: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
10: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
11: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
12: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7:
8: FUNCTION do_group_reclass
9: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
10: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
11: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
12: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
8: FUNCTION do_group_reclass
9: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
10: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
11: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
12: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
9: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
10: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
11: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
12: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
11: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
12: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
12: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
12: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
13: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14: px_src_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15: px_src_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
16: p_src_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
17: p_src_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
18: p_src_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
19: px_dest_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
20: px_dest_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
28: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
21: p_dest_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
28: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
29: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
22: p_dest_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
28: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
29: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
30: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
23: p_dest_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
28: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
29: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
30: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
31: p_period_rec IN FA_API_TYPES.period_rec_type,
24: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
28: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
29: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
30: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
31: p_period_rec IN FA_API_TYPES.period_rec_type,
32: p_mrc_sob_type_code IN VARCHAR2,
25: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
28: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
29: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
30: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
31: p_period_rec IN FA_API_TYPES.period_rec_type,
32: p_mrc_sob_type_code IN VARCHAR2,
33: p_calling_fn IN VARCHAR2,
26: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
28: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
29: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
30: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
31: p_period_rec IN FA_API_TYPES.period_rec_type,
32: p_mrc_sob_type_code IN VARCHAR2,
33: p_calling_fn IN VARCHAR2,
34: p_log_level_rec IN fa_api_types.log_level_rec_type default null
27: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
28: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
29: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
30: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
31: p_period_rec IN FA_API_TYPES.period_rec_type,
32: p_mrc_sob_type_code IN VARCHAR2,
33: p_calling_fn IN VARCHAR2,
34: p_log_level_rec IN fa_api_types.log_level_rec_type default null
35: ) RETURN BOOLEAN IS
30: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
31: p_period_rec IN FA_API_TYPES.period_rec_type,
32: p_mrc_sob_type_code IN VARCHAR2,
33: p_calling_fn IN VARCHAR2,
34: p_log_level_rec IN fa_api_types.log_level_rec_type default null
35: ) RETURN BOOLEAN IS
36:
37:
38: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
34: p_log_level_rec IN fa_api_types.log_level_rec_type default null
35: ) RETURN BOOLEAN IS
36:
37:
38: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
39: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
40: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
41: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
35: ) RETURN BOOLEAN IS
36:
37:
38: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
39: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
40: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
41: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
36:
37:
38: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
39: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
40: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
41: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
44: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
37:
38: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
39: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
40: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
41: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
44: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
45: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
38: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
39: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
40: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
41: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
44: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
45: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
46: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
39: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
40: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
41: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
44: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
45: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
46: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
47: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
40: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
41: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
44: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
45: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
46: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
47: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
48:
41: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
44: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
45: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
46: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
47: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
48:
49: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
42: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
44: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
45: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
46: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
47: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
48:
49: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
50: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
43: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
44: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
45: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
46: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
47: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
48:
49: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
50: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
51: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
45: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
46: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
47: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
48:
49: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
50: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
51: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
52: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
46: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
47: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
48:
49: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
50: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
51: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
52: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
47: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
48:
49: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
50: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
51: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
52: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
55: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
48:
49: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
50: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
51: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
52: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
55: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
56: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
49: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
50: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
51: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
52: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
55: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
56: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
57: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
50: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
51: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
52: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
55: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
56: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
57: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
58: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
51: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
52: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
55: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
56: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
57: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
58: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
59:
52: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
55: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
56: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
57: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
58: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
59:
60: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
53: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
55: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
56: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
57: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
58: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
59:
60: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
61: l_null_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
54: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
55: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
56: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
57: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
58: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
59:
60: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
61: l_null_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
62:
56: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
57: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
58: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
59:
60: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
61: l_null_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
62:
63: l_transaction_date date;
64: l_group_reclass_code varchar2(20);
57: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
58: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
59:
60: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
61: l_null_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
62:
63: l_transaction_date date;
64: l_group_reclass_code varchar2(20);
65:
76: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
77: l_return_status2 VARCHAR2(1);
78: l_msg_count NUMBER;
79: l_msg_data VARCHAR2(2000);
80: l_trans_rec FA_API_TYPES.trans_rec_type;
81: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type :=
82: p_asset_hdr_rec;
83: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
84:
77: l_return_status2 VARCHAR2(1);
78: l_msg_count NUMBER;
79: l_msg_data VARCHAR2(2000);
80: l_trans_rec FA_API_TYPES.trans_rec_type;
81: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type :=
82: p_asset_hdr_rec;
83: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
84:
85: l_distribution_id num_tbl;
79: l_msg_data VARCHAR2(2000);
80: l_trans_rec FA_API_TYPES.trans_rec_type;
81: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type :=
82: p_asset_hdr_rec;
83: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
84:
85: l_distribution_id num_tbl;
86: l_units_assigned num_tbl;
87: l_code_combination_id num_tbl;
1169:
1170: ---------------------------------------------------------------------------------------
1171:
1172: FUNCTION do_adjustment
1173: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1176: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1170: ---------------------------------------------------------------------------------------
1171:
1172: FUNCTION do_adjustment
1173: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1176: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1171:
1172: FUNCTION do_adjustment
1173: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1176: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1172: FUNCTION do_adjustment
1173: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1176: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1173: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1176: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1174: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1175: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1176: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1175: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1176: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1176: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1177: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1185: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1178: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1185: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1186: p_mem_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1179: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1185: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1186: p_mem_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1187: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
1180: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1185: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1186: p_mem_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1187: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
1188: p_period_rec IN fa_api_types.period_rec_type,
1181: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1185: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1186: p_mem_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1187: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
1188: p_period_rec IN fa_api_types.period_rec_type,
1189: p_mrc_sob_type_code IN VARCHAR2,
1182: p_mem_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1185: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1186: p_mem_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1187: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
1188: p_period_rec IN fa_api_types.period_rec_type,
1189: p_mrc_sob_type_code IN VARCHAR2,
1190: p_src_dest IN VARCHAR2,
1183: p_mem_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1185: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1186: p_mem_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1187: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
1188: p_period_rec IN fa_api_types.period_rec_type,
1189: p_mrc_sob_type_code IN VARCHAR2,
1190: p_src_dest IN VARCHAR2,
1191: p_log_level_rec IN fa_api_types.log_level_rec_type default null
1184: p_mem_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1185: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1186: p_mem_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1187: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
1188: p_period_rec IN fa_api_types.period_rec_type,
1189: p_mrc_sob_type_code IN VARCHAR2,
1190: p_src_dest IN VARCHAR2,
1191: p_log_level_rec IN fa_api_types.log_level_rec_type default null
1192: ) RETURN BOOLEAN IS
1187: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
1188: p_period_rec IN fa_api_types.period_rec_type,
1189: p_mrc_sob_type_code IN VARCHAR2,
1190: p_src_dest IN VARCHAR2,
1191: p_log_level_rec IN fa_api_types.log_level_rec_type default null
1192: ) RETURN BOOLEAN IS
1193:
1194: -- used for faxinaj calls
1195: l_exp_adj FA_ADJUST_TYPE_PKG.fa_adj_row_struct;
1202: l_bonus_exp_amount number := 0;
1203:
1204:
1205: -- used for temporary storage for calls to faxama
1206: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1207: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1208: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type; --bug6983091
1209: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1210: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1203:
1204:
1205: -- used for temporary storage for calls to faxama
1206: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1207: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1208: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type; --bug6983091
1209: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1210: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1211: l_trans_rec FA_API_TYPES.trans_rec_type;
1204:
1205: -- used for temporary storage for calls to faxama
1206: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1207: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1208: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type; --bug6983091
1209: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1210: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1211: l_trans_rec FA_API_TYPES.trans_rec_type;
1212: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1205: -- used for temporary storage for calls to faxama
1206: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1207: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1208: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type; --bug6983091
1209: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1210: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1211: l_trans_rec FA_API_TYPES.trans_rec_type;
1212: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1213: l_deprn_exp number;
1206: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1207: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1208: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type; --bug6983091
1209: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1210: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1211: l_trans_rec FA_API_TYPES.trans_rec_type;
1212: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1213: l_deprn_exp number;
1214: l_bonus_deprn_exp number;
1207: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1208: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type; --bug6983091
1209: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1210: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1211: l_trans_rec FA_API_TYPES.trans_rec_type;
1212: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1213: l_deprn_exp number;
1214: l_bonus_deprn_exp number;
1215:
1208: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type; --bug6983091
1209: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1210: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1211: l_trans_rec FA_API_TYPES.trans_rec_type;
1212: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1213: l_deprn_exp number;
1214: l_bonus_deprn_exp number;
1215:
1216: l_difference_eofy_reserve number;
2081: -- tables.
2082: ----------------------------------------------
2083:
2084: FUNCTION populate_member_amounts
2085: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2086: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2087: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2088: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2089: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2082: ----------------------------------------------
2083:
2084: FUNCTION populate_member_amounts
2085: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2086: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2087: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2088: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2089: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2090: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
2083:
2084: FUNCTION populate_member_amounts
2085: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2086: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2087: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2088: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2089: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2090: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
2091: p_period_rec IN fa_api_types.period_rec_type,
2084: FUNCTION populate_member_amounts
2085: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2086: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2087: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2088: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2089: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2090: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
2091: p_period_rec IN fa_api_types.period_rec_type,
2092: p_mrc_sob_type_code IN VARCHAR2,
2085: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2086: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2087: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2088: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2089: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2090: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
2091: p_period_rec IN fa_api_types.period_rec_type,
2092: p_mrc_sob_type_code IN VARCHAR2,
2093: p_src_dest IN VARCHAR2,
2086: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2087: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2088: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2089: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2090: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
2091: p_period_rec IN fa_api_types.period_rec_type,
2092: p_mrc_sob_type_code IN VARCHAR2,
2093: p_src_dest IN VARCHAR2,
2094: p_log_level_rec IN fa_api_types.log_level_rec_type default null
2087: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2088: p_mem_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2089: p_mem_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
2090: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
2091: p_period_rec IN fa_api_types.period_rec_type,
2092: p_mrc_sob_type_code IN VARCHAR2,
2093: p_src_dest IN VARCHAR2,
2094: p_log_level_rec IN fa_api_types.log_level_rec_type default null
2095: ) RETURN BOOLEAN IS
2090: px_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
2091: p_period_rec IN fa_api_types.period_rec_type,
2092: p_mrc_sob_type_code IN VARCHAR2,
2093: p_src_dest IN VARCHAR2,
2094: p_log_level_rec IN fa_api_types.log_level_rec_type default null
2095: ) RETURN BOOLEAN IS
2096:
2097: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2098:
2093: p_src_dest IN VARCHAR2,
2094: p_log_level_rec IN fa_api_types.log_level_rec_type default null
2095: ) RETURN BOOLEAN IS
2096:
2097: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2098:
2099: h_book_type_code varchar2(15);
2100: h_member_asset_id number(15);
2101: h_group_asset_id number(15);