6: G_PKG_NAME CONSTANT varchar2(30) := 'FA_ADJUSTMENT_PUB';
7: G_API_NAME CONSTANT varchar2(30) := 'Adjustment API';
8: G_API_VERSION CONSTANT number := 1.0;
9:
10: g_log_level_rec fa_api_types.log_level_rec_type;
11: g_release number := fa_cache_pkg.fazarel_release;
12:
13: --*********************** Private functions ******************************--
14:
19: g_last_invoice_thid number;
20: g_last_group_asset_id number;
21:
22: FUNCTION do_all_books
23: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
24: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
25: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
26: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
20: g_last_group_asset_id number;
21:
22: FUNCTION do_all_books
23: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
24: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
25: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
26: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
21:
22: FUNCTION do_all_books
23: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
24: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
25: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
26: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
22: FUNCTION do_all_books
23: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
24: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
25: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
26: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
30: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
23: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
24: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
25: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
26: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
30: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
31: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
24: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
25: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
26: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
30: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
31: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
32: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type,
25: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
26: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
30: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
31: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
32: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type,
33: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
26: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
30: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
31: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
32: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type,
33: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
34: ) RETURN BOOLEAN;
27: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
30: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
31: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
32: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type,
33: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
34: ) RETURN BOOLEAN;
35:
28: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
30: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
31: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
32: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type,
33: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
34: ) RETURN BOOLEAN;
35:
36:
29: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
30: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
31: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
32: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type,
33: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
34: ) RETURN BOOLEAN;
35:
36:
37: --*********************** Public procedures ******************************--
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48:
49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
52: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48:
49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
52: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
47: x_msg_data OUT NOCOPY VARCHAR2,
48:
49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
52: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
48:
49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
52: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
56: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
49: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
52: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
56: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
57: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
50: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
51: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
52: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
56: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
57: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
58: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
51: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
52: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
56: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
57: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
58: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
59: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type) IS
52: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
56: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
57: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
58: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
59: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type) IS
60:
53: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
56: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
57: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
58: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
59: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type) IS
60:
61: l_reporting_flag varchar2(1);
54: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
56: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
57: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
58: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
59: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type) IS
60:
61: l_reporting_flag varchar2(1);
62: l_inv_count number := 0;
55: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
56: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
57: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
58: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
59: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type) IS
60:
61: l_reporting_flag varchar2(1);
62: l_inv_count number := 0;
63: l_rate_count number := 0;
63: l_rate_count number := 0;
64: l_deprn_count number := 0;
65: l_count number := 0;
66:
67: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
68: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
69: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
71:
64: l_deprn_count number := 0;
65: l_count number := 0;
66:
67: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
68: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
69: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
71:
72: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
65: l_count number := 0;
66:
67: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
68: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
69: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
71:
72: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
73: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
66:
67: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
68: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
69: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
71:
72: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
73: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
74: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
68: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
69: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
71:
72: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
73: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
74: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
75: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
76:
69: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
70: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
71:
72: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
73: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
74: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
75: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
76:
77: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
70: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
71:
72: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
73: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
74: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
75: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
76:
77: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
78: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
71:
72: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type := p_asset_fin_rec_adj;
73: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
74: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
75: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
76:
77: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
78: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
79: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
73: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
74: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
75: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
76:
77: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
78: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
79: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
80:
81: -- used for tax books when doing cip-in-tax or autocopy
74: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
75: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
76:
77: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
78: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
79: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
80:
81: -- used for tax books when doing cip-in-tax or autocopy
82: l_trans_rec FA_API_TYPES.trans_rec_type;
75: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
76:
77: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
78: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
79: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
80:
81: -- used for tax books when doing cip-in-tax or autocopy
82: l_trans_rec FA_API_TYPES.trans_rec_type;
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
78: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
79: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
80:
81: -- used for tax books when doing cip-in-tax or autocopy
82: l_trans_rec FA_API_TYPES.trans_rec_type;
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
84: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
85: l_tax_index NUMBER; -- index for tax loop
86: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type; /* Added for Bug 12380342 */
79: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
80:
81: -- used for tax books when doing cip-in-tax or autocopy
82: l_trans_rec FA_API_TYPES.trans_rec_type;
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
84: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
85: l_tax_index NUMBER; -- index for tax loop
86: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type; /* Added for Bug 12380342 */
87:
82: l_trans_rec FA_API_TYPES.trans_rec_type;
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
84: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
85: l_tax_index NUMBER; -- index for tax loop
86: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type; /* Added for Bug 12380342 */
87:
88: -- Bug:5930979:Japan Tax Reform Project
89: l_deprn_method_code varchar2(12);
90: l_life_in_months Number(4);
130: raise adj_err;
131: end if;
132: /*bug#16426081 */
133: declare
134: l1_dist_trans_rec fa_api_types.trans_rec_type;
135: l1_asset_desc_rec fa_api_types.asset_desc_rec_type;
136: l1_asset_type_rec fa_api_types.asset_type_rec_type;
137: l1_asset_cat_rec fa_api_types.asset_cat_rec_type;
138: l1_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
131: end if;
132: /*bug#16426081 */
133: declare
134: l1_dist_trans_rec fa_api_types.trans_rec_type;
135: l1_asset_desc_rec fa_api_types.asset_desc_rec_type;
136: l1_asset_type_rec fa_api_types.asset_type_rec_type;
137: l1_asset_cat_rec fa_api_types.asset_cat_rec_type;
138: l1_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
139: l1_asset_fin_rec fa_api_types.asset_fin_rec_type;
132: /*bug#16426081 */
133: declare
134: l1_dist_trans_rec fa_api_types.trans_rec_type;
135: l1_asset_desc_rec fa_api_types.asset_desc_rec_type;
136: l1_asset_type_rec fa_api_types.asset_type_rec_type;
137: l1_asset_cat_rec fa_api_types.asset_cat_rec_type;
138: l1_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
139: l1_asset_fin_rec fa_api_types.asset_fin_rec_type;
140: l1_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
133: declare
134: l1_dist_trans_rec fa_api_types.trans_rec_type;
135: l1_asset_desc_rec fa_api_types.asset_desc_rec_type;
136: l1_asset_type_rec fa_api_types.asset_type_rec_type;
137: l1_asset_cat_rec fa_api_types.asset_cat_rec_type;
138: l1_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
139: l1_asset_fin_rec fa_api_types.asset_fin_rec_type;
140: l1_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
141: l1_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
134: l1_dist_trans_rec fa_api_types.trans_rec_type;
135: l1_asset_desc_rec fa_api_types.asset_desc_rec_type;
136: l1_asset_type_rec fa_api_types.asset_type_rec_type;
137: l1_asset_cat_rec fa_api_types.asset_cat_rec_type;
138: l1_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
139: l1_asset_fin_rec fa_api_types.asset_fin_rec_type;
140: l1_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
141: l1_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
142:
135: l1_asset_desc_rec fa_api_types.asset_desc_rec_type;
136: l1_asset_type_rec fa_api_types.asset_type_rec_type;
137: l1_asset_cat_rec fa_api_types.asset_cat_rec_type;
138: l1_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
139: l1_asset_fin_rec fa_api_types.asset_fin_rec_type;
140: l1_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
141: l1_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
142:
143: begin
136: l1_asset_type_rec fa_api_types.asset_type_rec_type;
137: l1_asset_cat_rec fa_api_types.asset_cat_rec_type;
138: l1_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
139: l1_asset_fin_rec fa_api_types.asset_fin_rec_type;
140: l1_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
141: l1_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
142:
143: begin
144: If not FA_ADJUSTMENT_PVT.process_trx_stack (
137: l1_asset_cat_rec fa_api_types.asset_cat_rec_type;
138: l1_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
139: l1_asset_fin_rec fa_api_types.asset_fin_rec_type;
140: l1_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
141: l1_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
142:
143: begin
144: If not FA_ADJUSTMENT_PVT.process_trx_stack (
145: p_orig_trx_type => 'ADJ',
567: -- book calling the private api for each.
568:
569:
570: FUNCTION do_all_books
571: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
572: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
573: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
574: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
568:
569:
570: FUNCTION do_all_books
571: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
572: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
573: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
574: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
569:
570: FUNCTION do_all_books
571: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
572: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
573: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
574: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
570: FUNCTION do_all_books
571: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
572: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
573: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
574: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
578: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
571: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
572: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
573: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
574: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
578: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
579: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
572: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
573: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
574: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
578: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
579: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
580: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
573: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
574: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
578: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
579: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
580: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
581: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
574: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
578: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
579: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
580: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
581: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
582: ) RETURN BOOLEAN IS
575: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
578: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
579: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
580: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
581: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
582: ) RETURN BOOLEAN IS
583:
576: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
578: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
579: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
580: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
581: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
582: ) RETURN BOOLEAN IS
583:
584: -- used for calling private api for reporting books
577: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
578: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
579: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
580: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
581: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
582: ) RETURN BOOLEAN IS
583:
584: -- used for calling private api for reporting books
585: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
581: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
582: ) RETURN BOOLEAN IS
583:
584: -- used for calling private api for reporting books
585: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
586: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
587: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
588: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
589: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
582: ) RETURN BOOLEAN IS
583:
584: -- used for calling private api for reporting books
585: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
586: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
587: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
588: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
589: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
590:
583:
584: -- used for calling private api for reporting books
585: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
586: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
587: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
588: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
589: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
590:
591: -- used to store the primary info for later use in mrc calcs
584: -- used for calling private api for reporting books
585: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
586: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
587: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
588: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
589: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
590:
591: -- used to store the primary info for later use in mrc calcs
592: -- initially to store the incoming adj upon invoice engine call
585: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
586: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
587: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
588: l_asset_fin_mrc_tbl_adj FA_API_TYPES.asset_fin_tbl_type;
589: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
590:
591: -- used to store the primary info for later use in mrc calcs
592: -- initially to store the incoming adj upon invoice engine call
593: l_asset_fin_rec_adj_init FA_API_TYPES.asset_fin_rec_type;
589: l_asset_deprn_mrc_tbl_adj FA_API_TYPES.asset_deprn_tbl_type;
590:
591: -- used to store the primary info for later use in mrc calcs
592: -- initially to store the incoming adj upon invoice engine call
593: l_asset_fin_rec_adj_init FA_API_TYPES.asset_fin_rec_type;
594: l_asset_deprn_rec_adj_init FA_API_TYPES.asset_deprn_rec_type;
595: l_group_rcl_options_rec_init FA_API_TYPES.group_reclass_options_rec_type;
596:
597: -- used for retrieving "old" and "new" structs from private api calls
590:
591: -- used to store the primary info for later use in mrc calcs
592: -- initially to store the incoming adj upon invoice engine call
593: l_asset_fin_rec_adj_init FA_API_TYPES.asset_fin_rec_type;
594: l_asset_deprn_rec_adj_init FA_API_TYPES.asset_deprn_rec_type;
595: l_group_rcl_options_rec_init FA_API_TYPES.group_reclass_options_rec_type;
596:
597: -- used for retrieving "old" and "new" structs from private api calls
598: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
591: -- used to store the primary info for later use in mrc calcs
592: -- initially to store the incoming adj upon invoice engine call
593: l_asset_fin_rec_adj_init FA_API_TYPES.asset_fin_rec_type;
594: l_asset_deprn_rec_adj_init FA_API_TYPES.asset_deprn_rec_type;
595: l_group_rcl_options_rec_init FA_API_TYPES.group_reclass_options_rec_type;
596:
597: -- used for retrieving "old" and "new" structs from private api calls
598: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
599: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
594: l_asset_deprn_rec_adj_init FA_API_TYPES.asset_deprn_rec_type;
595: l_group_rcl_options_rec_init FA_API_TYPES.group_reclass_options_rec_type;
596:
597: -- used for retrieving "old" and "new" structs from private api calls
598: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
599: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
600: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
601: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
602:
595: l_group_rcl_options_rec_init FA_API_TYPES.group_reclass_options_rec_type;
596:
597: -- used for retrieving "old" and "new" structs from private api calls
598: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
599: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
600: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
601: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
602:
603: -- used for group reclass api call
596:
597: -- used for retrieving "old" and "new" structs from private api calls
598: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
599: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
600: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
601: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
602:
603: -- used for group reclass api call
604: l_group_rcl_trans_rec FA_API_TYPES.trans_rec_type;
597: -- used for retrieving "old" and "new" structs from private api calls
598: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
599: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
600: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
601: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
602:
603: -- used for group reclass api call
604: l_group_rcl_trans_rec FA_API_TYPES.trans_rec_type;
605: l_group_rcl_options_rec FA_API_TYPES.group_reclass_options_rec_type;
600: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
601: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
602:
603: -- used for group reclass api call
604: l_group_rcl_trans_rec FA_API_TYPES.trans_rec_type;
605: l_group_rcl_options_rec FA_API_TYPES.group_reclass_options_rec_type;
606:
607: l_reporting_flag varchar2(1);
608:
601: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
602:
603: -- used for group reclass api call
604: l_group_rcl_trans_rec FA_API_TYPES.trans_rec_type;
605: l_group_rcl_options_rec FA_API_TYPES.group_reclass_options_rec_type;
606:
607: l_reporting_flag varchar2(1);
608:
609: l_period_rec FA_API_TYPES.period_rec_type;
605: l_group_rcl_options_rec FA_API_TYPES.group_reclass_options_rec_type;
606:
607: l_reporting_flag varchar2(1);
608:
609: l_period_rec FA_API_TYPES.period_rec_type;
610: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
611:
612: -- used for local runs
613: l_responsibility_id number;
642:
643: adj_row FA_ADJUST_TYPE_PKG.fa_adj_row_struct;
644:
645: -- used for new group stuff
646: l_src_trans_rec fa_api_types.trans_rec_type;
647: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
648: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
649: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
643: adj_row FA_ADJUST_TYPE_PKG.fa_adj_row_struct;
644:
645: -- used for new group stuff
646: l_src_trans_rec fa_api_types.trans_rec_type;
647: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
648: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
649: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
644:
645: -- used for new group stuff
646: l_src_trans_rec fa_api_types.trans_rec_type;
647: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
648: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
649: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
645: -- used for new group stuff
646: l_src_trans_rec fa_api_types.trans_rec_type;
647: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
648: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
649: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
653: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
646: l_src_trans_rec fa_api_types.trans_rec_type;
647: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
648: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
649: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
653: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
654: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
647: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
648: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
649: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
653: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
654: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
655: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
648: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
649: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
653: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
654: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
655: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
656: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
649: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
653: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
654: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
655: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
656: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
657:
650: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
653: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
654: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
655: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
656: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
657:
658: l_dest_trans_rec fa_api_types.trans_rec_type;
651: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
653: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
654: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
655: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
656: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
657:
658: l_dest_trans_rec fa_api_types.trans_rec_type;
659: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
652: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
653: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
654: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
655: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
656: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
657:
658: l_dest_trans_rec fa_api_types.trans_rec_type;
659: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
660: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
654: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
655: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
656: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
657:
658: l_dest_trans_rec fa_api_types.trans_rec_type;
659: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
660: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
661: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
655: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
656: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
657:
658: l_dest_trans_rec fa_api_types.trans_rec_type;
659: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
660: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
661: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
656: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
657:
658: l_dest_trans_rec fa_api_types.trans_rec_type;
659: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
660: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
661: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
657:
658: l_dest_trans_rec fa_api_types.trans_rec_type;
659: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
660: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
661: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
665: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
658: l_dest_trans_rec fa_api_types.trans_rec_type;
659: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
660: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
661: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
665: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
666: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
659: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
660: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
661: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
665: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
666: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
667: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
660: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
661: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
665: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
666: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
667: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
668: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
661: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
665: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
666: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
667: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
668: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
669:
662: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
665: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
666: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
667: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
668: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
669:
670: l_max_reclass_date DATE;
663: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
665: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
666: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
667: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
668: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
669:
670: l_max_reclass_date DATE;
671: l_max_ret_date DATE;
664: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
665: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
666: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
667: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
668: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
669:
670: l_max_reclass_date DATE;
671: l_max_ret_date DATE;
672:
819: DEST_EOFY_RESERVE
820: from fa_trx_references
821: where TRX_REFERENCE_ID = px_trans_rec.trx_reference_id;
822:
823: l_trx_ref_rec fa_api_types.trx_ref_rec_type; --Bug 8941132
824: l_group_reclass boolean := FALSE; --Bug 8941132
825:
826: l_trx_date date;
827: --Bug# 7715678 end