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: g_release number := fa_cache_pkg.fazarel_release;
12:
13: --*********************** Private procedures *****************************--
12:
13: --*********************** Private procedures *****************************--
14:
15: function do_all_books (
16: p_trans_rec IN fa_api_types.trans_rec_type,
17: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
18: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
19: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
13: --*********************** Private procedures *****************************--
14:
15: function do_all_books (
16: p_trans_rec IN fa_api_types.trans_rec_type,
17: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
18: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
19: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
14:
15: function do_all_books (
16: p_trans_rec IN fa_api_types.trans_rec_type,
17: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
18: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
19: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
22: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
15: function do_all_books (
16: p_trans_rec IN fa_api_types.trans_rec_type,
17: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
18: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
19: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
22: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
23: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
16: p_trans_rec IN fa_api_types.trans_rec_type,
17: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
18: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
19: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
22: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
23: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
24: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
17: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
18: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
19: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
22: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
23: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
24: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
25: p_inv_tbl IN fa_api_types.inv_tbl_type,
18: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
19: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
22: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
23: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
24: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
25: p_inv_tbl IN fa_api_types.inv_tbl_type,
26: x_exchange_rate OUT NOCOPY NUMBER,
19: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
22: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
23: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
24: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
25: p_inv_tbl IN fa_api_types.inv_tbl_type,
26: x_exchange_rate OUT NOCOPY NUMBER,
27: x_return_status OUT NOCOPY VARCHAR2,
20: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
22: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
23: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
24: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
25: p_inv_tbl IN fa_api_types.inv_tbl_type,
26: x_exchange_rate OUT NOCOPY NUMBER,
27: x_return_status OUT NOCOPY VARCHAR2,
28: p_calling_fn IN VARCHAR2,
21: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
22: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
23: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
24: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
25: p_inv_tbl IN fa_api_types.inv_tbl_type,
26: x_exchange_rate OUT NOCOPY NUMBER,
27: x_return_status OUT NOCOPY VARCHAR2,
28: p_calling_fn IN VARCHAR2,
29: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
25: p_inv_tbl IN fa_api_types.inv_tbl_type,
26: x_exchange_rate OUT NOCOPY NUMBER,
27: x_return_status OUT NOCOPY VARCHAR2,
28: p_calling_fn IN VARCHAR2,
29: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
30: p_log_level_rec IN fa_api_types.log_level_rec_type) return boolean;
31:
32: --*********************** Public procedures ******************************--
33: procedure do_addition (
26: x_exchange_rate OUT NOCOPY NUMBER,
27: x_return_status OUT NOCOPY VARCHAR2,
28: p_calling_fn IN VARCHAR2,
29: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
30: p_log_level_rec IN fa_api_types.log_level_rec_type) return boolean;
31:
32: --*********************** Public procedures ******************************--
33: procedure do_addition (
34: -- Standard Parameters --
40: x_msg_count OUT NOCOPY NUMBER,
41: x_msg_data OUT NOCOPY VARCHAR2,
42: p_calling_fn IN VARCHAR2,
43: -- Transaction Object --
44: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
45: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
46: -- Asset Object --
47: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
48: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
41: x_msg_data OUT NOCOPY VARCHAR2,
42: p_calling_fn IN VARCHAR2,
43: -- Transaction Object --
44: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
45: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
46: -- Asset Object --
47: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
48: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
49: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
43: -- Transaction Object --
44: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
45: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
46: -- Asset Object --
47: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
48: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
49: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
50: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
51: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
44: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
45: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
46: -- Asset Object --
47: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
48: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
49: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
50: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
51: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
52: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
45: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
46: -- Asset Object --
47: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
48: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
49: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
50: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
51: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
52: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
53: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
46: -- Asset Object --
47: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
48: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
49: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
50: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
51: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
52: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
53: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
54: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
47: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
48: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
49: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
50: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
51: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
52: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
53: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
54: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
55: -- Invoice Object --
48: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
49: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
50: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
51: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
52: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
53: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
54: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
55: -- Invoice Object --
56: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type) is
49: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
50: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
51: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
52: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
53: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
54: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
55: -- Invoice Object --
56: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type) is
57:
50: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
51: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
52: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
53: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
54: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
55: -- Invoice Object --
56: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type) is
57:
58: add_err1 exception; -- sets return status
52: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
53: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
54: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
55: -- Invoice Object --
56: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type) is
57:
58: add_err1 exception; -- sets return status
59: add_err2 exception; -- does not set return status
60:
58: add_err1 exception; -- sets return status
59: add_err2 exception; -- does not set return status
60:
61: -- For corporate and tax books
62: l_trans_rec fa_api_types.trans_rec_type;
63: l_dist_trans_rec fa_api_types.trans_rec_type;
64: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
65: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
59: add_err2 exception; -- does not set return status
60:
61: -- For corporate and tax books
62: l_trans_rec fa_api_types.trans_rec_type;
63: l_dist_trans_rec fa_api_types.trans_rec_type;
64: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
65: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
60:
61: -- For corporate and tax books
62: l_trans_rec fa_api_types.trans_rec_type;
63: l_dist_trans_rec fa_api_types.trans_rec_type;
64: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
65: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
68: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
61: -- For corporate and tax books
62: l_trans_rec fa_api_types.trans_rec_type;
63: l_dist_trans_rec fa_api_types.trans_rec_type;
64: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
65: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
68: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
69: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
62: l_trans_rec fa_api_types.trans_rec_type;
63: l_dist_trans_rec fa_api_types.trans_rec_type;
64: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
65: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
68: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
69: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
70: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
63: l_dist_trans_rec fa_api_types.trans_rec_type;
64: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
65: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
68: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
69: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
70: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
71: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
64: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
65: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
68: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
69: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
70: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
71: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
72:
65: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
68: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
69: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
70: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
71: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
72:
73: l_inv_rec fa_api_types.inv_rec_type;
66: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
68: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
69: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
70: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
71: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
72:
73: l_inv_rec fa_api_types.inv_rec_type;
74: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
67: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
68: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
69: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
70: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
71: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
72:
73: l_inv_rec fa_api_types.inv_rec_type;
74: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
75: l_period_rec fa_api_types.period_rec_type;
69: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
70: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
71: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
72:
73: l_inv_rec fa_api_types.inv_rec_type;
74: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
75: l_period_rec fa_api_types.period_rec_type;
76:
77: l_tax_book_tbl fa_cache_pkg.fazctbk_tbl_type;
70: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
71: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
72:
73: l_inv_rec fa_api_types.inv_rec_type;
74: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
75: l_period_rec fa_api_types.period_rec_type;
76:
77: l_tax_book_tbl fa_cache_pkg.fazctbk_tbl_type;
78: l_initial_book boolean := TRUE;
71: l_asset_deprn_mrc_tbl fa_api_types.asset_deprn_tbl_type;
72:
73: l_inv_rec fa_api_types.inv_rec_type;
74: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
75: l_period_rec fa_api_types.period_rec_type;
76:
77: l_tax_book_tbl fa_cache_pkg.fazctbk_tbl_type;
78: l_initial_book boolean := TRUE;
79:
79:
80: -- For primary and reporting books
81: l_reporting_flag varchar2(1) := 'P';
82: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
83: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
84: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
85: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
86: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
87: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
80: -- For primary and reporting books
81: l_reporting_flag varchar2(1) := 'P';
82: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
83: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
84: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
85: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
86: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
87: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
88: l_exchange_rate number;
81: l_reporting_flag varchar2(1) := 'P';
82: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
83: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
84: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
85: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
86: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
87: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
88: l_exchange_rate number;
89: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
82: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;
83: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
84: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
85: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
86: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
87: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
88: l_exchange_rate number;
89: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
90: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
83: l_mrc_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
84: l_mrc_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
85: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
86: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
87: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
88: l_exchange_rate number;
89: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
90: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
91:
85: l_mrc_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
86: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
87: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
88: l_exchange_rate number;
89: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
90: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
91:
92: -- used for new group code
93: l_group_trans_rec fa_api_types.trans_rec_type;
86: l_mrc_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
87: l_mrc_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
88: l_exchange_rate number;
89: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
90: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
91:
92: -- used for new group code
93: l_group_trans_rec fa_api_types.trans_rec_type;
94: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
89: l_asset_hr_attr_rec_old FA_API_TYPES.asset_hr_attr_rec_type;
90: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
91:
92: -- used for new group code
93: l_group_trans_rec fa_api_types.trans_rec_type;
94: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
95: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
96: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
90: l_asset_hr_attr_rec_new FA_API_TYPES.asset_hr_attr_rec_type;
91:
92: -- used for new group code
93: l_group_trans_rec fa_api_types.trans_rec_type;
94: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
95: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
96: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
91:
92: -- used for new group code
93: l_group_trans_rec fa_api_types.trans_rec_type;
94: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
95: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
96: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
92: -- used for new group code
93: l_group_trans_rec fa_api_types.trans_rec_type;
94: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
95: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
96: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
93: l_group_trans_rec fa_api_types.trans_rec_type;
94: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
95: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
96: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
101: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
94: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
95: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
96: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
101: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
102: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
95: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
96: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
101: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
102: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
96: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
101: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
102: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
104:
97: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
101: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
102: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
104:
105: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
98: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
101: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
102: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
104:
105: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
106:
99: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
100: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
101: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
102: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
104:
105: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
106:
107: l_cip_cost number := 0;
101: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
102: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
103: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
104:
105: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
106:
107: l_cip_cost number := 0;
108: l_calling_fn varchar2(30) := 'fa_addition_pub.do_addition';
109: l_japan_tax_reform varchar2(1) := fnd_profile.value('FA_JAPAN_TAX_REFORMS'); --bug 13022905
145: end if;
146:
147: /*bug#16426081 */
148: declare
149: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
150: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
151: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
152: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
153: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
146:
147: /*bug#16426081 */
148: declare
149: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
150: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
151: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
152: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
153: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
154: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
147: /*bug#16426081 */
148: declare
149: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
150: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
151: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
152: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
153: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
154: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
155: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
148: declare
149: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
150: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
151: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
152: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
153: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
154: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
155: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
156: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
149: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
150: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
151: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
152: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
153: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
154: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
155: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
156: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
157: begin
150: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
151: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
152: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
153: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
154: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
155: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
156: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
157: begin
158: If not FA_ADJUSTMENT_PVT.process_trx_stack (
151: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
152: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
153: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
154: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
155: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
156: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
157: begin
158: If not FA_ADJUSTMENT_PVT.process_trx_stack (
159: p_orig_trx_type => 'ADD',
152: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
153: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
154: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
155: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
156: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
157: begin
158: If not FA_ADJUSTMENT_PVT.process_trx_stack (
159: p_orig_trx_type => 'ADD',
160: x_trx_stack => l_trx_stack,
1012:
1013: end do_addition;
1014:
1015: function do_all_books (
1016: p_trans_rec IN fa_api_types.trans_rec_type,
1017: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1018: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
1019: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1013: end do_addition;
1014:
1015: function do_all_books (
1016: p_trans_rec IN fa_api_types.trans_rec_type,
1017: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1018: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
1019: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1014:
1015: function do_all_books (
1016: p_trans_rec IN fa_api_types.trans_rec_type,
1017: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1018: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
1019: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1015: function do_all_books (
1016: p_trans_rec IN fa_api_types.trans_rec_type,
1017: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1018: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
1019: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1023: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
1016: p_trans_rec IN fa_api_types.trans_rec_type,
1017: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1018: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
1019: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1023: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
1024: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1017: p_primary_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1018: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
1019: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1023: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
1024: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1025: p_inv_tbl IN fa_api_types.inv_tbl_type,
1018: p_primary_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
1019: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1023: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
1024: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1025: p_inv_tbl IN fa_api_types.inv_tbl_type,
1026: x_exchange_rate OUT NOCOPY NUMBER,
1019: p_primary_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1023: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
1024: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1025: p_inv_tbl IN fa_api_types.inv_tbl_type,
1026: x_exchange_rate OUT NOCOPY NUMBER,
1027: x_return_status OUT NOCOPY VARCHAR2,
1020: p_report_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1023: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
1024: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1025: p_inv_tbl IN fa_api_types.inv_tbl_type,
1026: x_exchange_rate OUT NOCOPY NUMBER,
1027: x_return_status OUT NOCOPY VARCHAR2,
1028: p_calling_fn IN VARCHAR2,
1021: x_report_asset_fin_rec OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: x_report_asset_deprn_rec OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1023: p_asset_fin_mrc_tbl IN fa_api_types.asset_fin_tbl_type,
1024: p_asset_deprn_mrc_tbl IN fa_api_types.asset_deprn_tbl_type,
1025: p_inv_tbl IN fa_api_types.inv_tbl_type,
1026: x_exchange_rate OUT NOCOPY NUMBER,
1027: x_return_status OUT NOCOPY VARCHAR2,
1028: p_calling_fn IN VARCHAR2,
1029: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1025: p_inv_tbl IN fa_api_types.inv_tbl_type,
1026: x_exchange_rate OUT NOCOPY NUMBER,
1027: x_return_status OUT NOCOPY VARCHAR2,
1028: p_calling_fn IN VARCHAR2,
1029: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1030: p_log_level_rec IN fa_api_types.log_level_rec_type) return boolean as
1031:
1032: l_count number;
1033: l_mrc_populated boolean := FALSE;
1026: x_exchange_rate OUT NOCOPY NUMBER,
1027: x_return_status OUT NOCOPY VARCHAR2,
1028: p_calling_fn IN VARCHAR2,
1029: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1030: p_log_level_rec IN fa_api_types.log_level_rec_type) return boolean as
1031:
1032: l_count number;
1033: l_mrc_populated boolean := FALSE;
1034: l_exchange_date date;