5: G_PKG_NAME CONSTANT varchar2(30) := 'FA_ADDITION_PUB';
6: G_API_NAME CONSTANT varchar2(30) := 'Addition API';
7: G_API_VERSION CONSTANT number := 1.0;
8:
9: g_log_level_rec fa_api_types.log_level_rec_type;
10:
11: --*********************** Private procedures *****************************--
12:
13: function do_all_books (
10:
11: --*********************** Private procedures *****************************--
12:
13: function do_all_books (
14: p_trans_rec IN fa_api_types.trans_rec_type,
15: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
16: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
17: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
11: --*********************** Private procedures *****************************--
12:
13: function do_all_books (
14: p_trans_rec IN fa_api_types.trans_rec_type,
15: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
16: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
17: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
12:
13: function do_all_books (
14: p_trans_rec IN fa_api_types.trans_rec_type,
15: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
16: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
17: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
20: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
13: function do_all_books (
14: p_trans_rec IN fa_api_types.trans_rec_type,
15: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
16: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
17: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
20: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
21: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
14: p_trans_rec IN fa_api_types.trans_rec_type,
15: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
16: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
17: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
20: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
21: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
22: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
15: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
16: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
17: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
20: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
21: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
22: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type,
16: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
17: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
20: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
21: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
22: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type,
24: x_exchange_rate OUT NOCOPY NUMBER,
17: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
20: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
21: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
22: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type,
24: x_exchange_rate OUT NOCOPY NUMBER,
25: x_return_status OUT NOCOPY VARCHAR2,
18: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
20: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
21: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
22: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type,
24: x_exchange_rate OUT NOCOPY NUMBER,
25: x_return_status OUT NOCOPY VARCHAR2,
26: p_calling_fn IN VARCHAR2,
19: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
20: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
21: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
22: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type,
24: x_exchange_rate OUT NOCOPY NUMBER,
25: x_return_status OUT NOCOPY VARCHAR2,
26: p_calling_fn IN VARCHAR2,
27: p_log_level_rec IN fa_api_types.log_level_rec_type default null) return boolean;
23: p_inv_tbl IN fa_api_types.inv_tbl_type,
24: x_exchange_rate OUT NOCOPY NUMBER,
25: x_return_status OUT NOCOPY VARCHAR2,
26: p_calling_fn IN VARCHAR2,
27: p_log_level_rec IN fa_api_types.log_level_rec_type default null) return boolean;
28:
29: --*********************** Public procedures ******************************--
30: procedure do_addition (
31: -- Standard Parameters --
37: x_msg_count OUT NOCOPY NUMBER,
38: x_msg_data OUT NOCOPY VARCHAR2,
39: p_calling_fn IN VARCHAR2,
40: -- Transaction Object --
41: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
42: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
43: -- Asset Object --
44: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
45: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
38: x_msg_data OUT NOCOPY VARCHAR2,
39: p_calling_fn IN VARCHAR2,
40: -- Transaction Object --
41: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
42: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
43: -- Asset Object --
44: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
45: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
46: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
40: -- Transaction Object --
41: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
42: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
43: -- Asset Object --
44: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
45: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
46: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
47: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
48: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
41: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
42: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
43: -- Asset Object --
44: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
45: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
46: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
47: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
48: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
49: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
42: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
43: -- Asset Object --
44: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
45: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
46: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
47: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
48: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
49: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
50: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
43: -- Asset Object --
44: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
45: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
46: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
47: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
48: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
49: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
50: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
51: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
44: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
45: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
46: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
47: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
48: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
49: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
50: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
51: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
52: -- Invoice Object --
45: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
46: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
47: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
48: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
49: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
50: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
51: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
52: -- Invoice Object --
53: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type) as
46: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
47: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
48: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
49: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
50: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
51: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
52: -- Invoice Object --
53: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type) as
54:
47: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
48: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
49: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
50: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
51: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
52: -- Invoice Object --
53: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type) as
54:
55: add_err1 exception; -- sets return status
49: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
50: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
51: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
52: -- Invoice Object --
53: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type) as
54:
55: add_err1 exception; -- sets return status
56: add_err2 exception; -- does not set return status
57: add_err3 exception; --Bug6391045
55: add_err1 exception; -- sets return status
56: add_err2 exception; -- does not set return status
57: add_err3 exception; --Bug6391045
58: -- For corporate and tax books
59: l_trans_rec fa_api_types.trans_rec_type;
60: l_dist_trans_rec fa_api_types.trans_rec_type;
61: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
62: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
56: add_err2 exception; -- does not set return status
57: add_err3 exception; --Bug6391045
58: -- For corporate and tax books
59: l_trans_rec fa_api_types.trans_rec_type;
60: l_dist_trans_rec fa_api_types.trans_rec_type;
61: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
62: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
57: add_err3 exception; --Bug6391045
58: -- For corporate and tax books
59: l_trans_rec fa_api_types.trans_rec_type;
60: l_dist_trans_rec fa_api_types.trans_rec_type;
61: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
62: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
65: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
58: -- For corporate and tax books
59: l_trans_rec fa_api_types.trans_rec_type;
60: l_dist_trans_rec fa_api_types.trans_rec_type;
61: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
62: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
65: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
66: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
59: l_trans_rec fa_api_types.trans_rec_type;
60: l_dist_trans_rec fa_api_types.trans_rec_type;
61: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
62: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
65: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
66: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
67: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
60: l_dist_trans_rec fa_api_types.trans_rec_type;
61: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
62: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
65: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
66: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
67: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
68: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
61: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
62: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
65: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
66: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
67: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
68: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
69:
62: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
65: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
66: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
67: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
68: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
69:
70: l_inv_rec fa_api_types.inv_rec_type;
63: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
65: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
66: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
67: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
68: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
69:
70: l_inv_rec fa_api_types.inv_rec_type;
71: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
64: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
65: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
66: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
67: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
68: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
69:
70: l_inv_rec fa_api_types.inv_rec_type;
71: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
72: l_period_rec fa_api_types.period_rec_type;
66: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
67: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
68: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
69:
70: l_inv_rec fa_api_types.inv_rec_type;
71: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
72: l_period_rec fa_api_types.period_rec_type;
73:
74: l_tax_book_tbl fa_cache_pkg.fazctbk_tbl_type;
67: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
68: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
69:
70: l_inv_rec fa_api_types.inv_rec_type;
71: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
72: l_period_rec fa_api_types.period_rec_type;
73:
74: l_tax_book_tbl fa_cache_pkg.fazctbk_tbl_type;
75: l_initial_book boolean := TRUE;
68: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
69:
70: l_inv_rec fa_api_types.inv_rec_type;
71: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
72: l_period_rec fa_api_types.period_rec_type;
73:
74: l_tax_book_tbl fa_cache_pkg.fazctbk_tbl_type;
75: l_initial_book boolean := TRUE;
76:
76:
77: -- For primary and reporting books
78: l_reporting_flag varchar2(1) := 'P';
79: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
80: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
81: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
82: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
83: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
84: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
77: -- For primary and reporting books
78: l_reporting_flag varchar2(1) := 'P';
79: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
80: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
81: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
82: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
83: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
84: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
85: l_exchange_rate number;
78: l_reporting_flag varchar2(1) := 'P';
79: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
80: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
81: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
82: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
83: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
84: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
85: l_exchange_rate number;
86: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
79: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
80: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
81: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
82: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
83: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
84: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
85: l_exchange_rate number;
86: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
87: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
80: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
81: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
82: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
83: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
84: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
85: l_exchange_rate number;
86: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
87: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
88:
82: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
83: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
84: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
85: l_exchange_rate number;
86: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
87: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
88:
89: -- used to store original sob info upon entry into api
90: l_orig_set_of_books_id number;
83: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
84: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
85: l_exchange_rate number;
86: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
87: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
88:
89: -- used to store original sob info upon entry into api
90: l_orig_set_of_books_id number;
91: l_orig_currency_context varchar2(64);
90: l_orig_set_of_books_id number;
91: l_orig_currency_context varchar2(64);
92:
93: -- used for new group code
94: l_group_trans_rec fa_api_types.trans_rec_type;
95: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
96: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
97: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
91: l_orig_currency_context varchar2(64);
92:
93: -- used for new group code
94: l_group_trans_rec fa_api_types.trans_rec_type;
95: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
96: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
97: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
92:
93: -- used for new group code
94: l_group_trans_rec fa_api_types.trans_rec_type;
95: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
96: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
97: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
93: -- used for new group code
94: l_group_trans_rec fa_api_types.trans_rec_type;
95: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
96: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
97: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
101: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
94: l_group_trans_rec fa_api_types.trans_rec_type;
95: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
96: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
97: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
101: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
102: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
95: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
96: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
97: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
101: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
102: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
96: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
97: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
101: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
102: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
104: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
97: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
101: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
102: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
104: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
105:
98: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
101: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
102: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
104: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
105:
106: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
99: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
101: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
102: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
104: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
105:
106: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
107:
100: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
101: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
102: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
104: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
105:
106: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
107:
108: l_cip_cost number := 0;
102: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
104: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
105:
106: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
107:
108: l_cip_cost number := 0;
109: l_calling_fn varchar2(30) := 'fa_addition_pub.do_addition';
110:
987:
988: end do_addition;
989:
990: function do_all_books (
991: p_trans_rec IN fa_api_types.trans_rec_type,
992: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
993: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
994: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
988: end do_addition;
989:
990: function do_all_books (
991: p_trans_rec IN fa_api_types.trans_rec_type,
992: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
993: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
994: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
989:
990: function do_all_books (
991: p_trans_rec IN fa_api_types.trans_rec_type,
992: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
993: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
994: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
997: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
990: function do_all_books (
991: p_trans_rec IN fa_api_types.trans_rec_type,
992: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
993: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
994: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
997: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
998: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
991: p_trans_rec IN fa_api_types.trans_rec_type,
992: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
993: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
994: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
997: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
998: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
999: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
992: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
993: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
994: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
997: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
998: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
999: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1000: p_inv_tbl IN fa_api_types.inv_tbl_type,
993: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
994: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
997: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
998: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
999: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1000: p_inv_tbl IN fa_api_types.inv_tbl_type,
1001: x_exchange_rate OUT NOCOPY NUMBER,
994: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
997: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
998: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
999: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1000: p_inv_tbl IN fa_api_types.inv_tbl_type,
1001: x_exchange_rate OUT NOCOPY NUMBER,
1002: x_return_status OUT NOCOPY VARCHAR2,
995: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
997: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
998: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
999: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1000: p_inv_tbl IN fa_api_types.inv_tbl_type,
1001: x_exchange_rate OUT NOCOPY NUMBER,
1002: x_return_status OUT NOCOPY VARCHAR2,
1003: p_calling_fn IN VARCHAR2,
996: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
997: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
998: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
999: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1000: p_inv_tbl IN fa_api_types.inv_tbl_type,
1001: x_exchange_rate OUT NOCOPY NUMBER,
1002: x_return_status OUT NOCOPY VARCHAR2,
1003: p_calling_fn IN VARCHAR2,
1004: p_log_level_rec IN fa_api_types.log_level_rec_type default null) return boolean as
1000: p_inv_tbl IN fa_api_types.inv_tbl_type,
1001: x_exchange_rate OUT NOCOPY NUMBER,
1002: x_return_status OUT NOCOPY VARCHAR2,
1003: p_calling_fn IN VARCHAR2,
1004: p_log_level_rec IN fa_api_types.log_level_rec_type default null) return boolean as
1005:
1006: l_count number;
1007: l_mrc_populated boolean := FALSE;
1008: l_exchange_date date;