19:
20: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
21:
22: FUNCTION inv_calc_info
23: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
26: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
27: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
21:
22: FUNCTION inv_calc_info
23: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
26: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
27: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
28: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
21:
22: FUNCTION inv_calc_info
23: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
26: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
27: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
28: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
29: p_log_level_rec IN fa_api_types.log_level_rec_type default null
22: FUNCTION inv_calc_info
23: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
26: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
27: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
28: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
29: p_log_level_rec IN fa_api_types.log_level_rec_type default null
30: ) RETURN BOOLEAN;
23: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
26: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
27: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
28: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
29: p_log_level_rec IN fa_api_types.log_level_rec_type default null
30: ) RETURN BOOLEAN;
31:
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
26: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
27: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
28: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
29: p_log_level_rec IN fa_api_types.log_level_rec_type default null
30: ) RETURN BOOLEAN;
31:
32: FUNCTION process_invoice
25: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
26: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
27: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
28: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
29: p_log_level_rec IN fa_api_types.log_level_rec_type default null
30: ) RETURN BOOLEAN;
31:
32: FUNCTION process_invoice
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
29: p_log_level_rec IN fa_api_types.log_level_rec_type default null
30: ) RETURN BOOLEAN;
31:
32: FUNCTION process_invoice
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
36: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
37: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
30: ) RETURN BOOLEAN;
31:
32: FUNCTION process_invoice
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
36: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
37: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
38: p_mrc_sob_type_code IN VARCHAR2,
31:
32: FUNCTION process_invoice
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
36: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
37: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
38: p_mrc_sob_type_code IN VARCHAR2,
39: p_log_level_rec in fa_api_types.log_level_rec_type default null
32: FUNCTION process_invoice
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
36: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
37: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
38: p_mrc_sob_type_code IN VARCHAR2,
39: p_log_level_rec in fa_api_types.log_level_rec_type default null
40: ) RETURN BOOLEAN;
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
36: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
37: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
38: p_mrc_sob_type_code IN VARCHAR2,
39: p_log_level_rec in fa_api_types.log_level_rec_type default null
40: ) RETURN BOOLEAN;
41:
35: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
36: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
37: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
38: p_mrc_sob_type_code IN VARCHAR2,
39: p_log_level_rec in fa_api_types.log_level_rec_type default null
40: ) RETURN BOOLEAN;
41:
42: FUNCTION get_inv_rate
43: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
39: p_log_level_rec in fa_api_types.log_level_rec_type default null
40: ) RETURN BOOLEAN;
41:
42: FUNCTION get_inv_rate
43: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
44: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
45: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
46: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
47: p_log_level_rec in fa_api_types.log_level_rec_type default null
40: ) RETURN BOOLEAN;
41:
42: FUNCTION get_inv_rate
43: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
44: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
45: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
46: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
47: p_log_level_rec in fa_api_types.log_level_rec_type default null
48: ) RETURN BOOLEAN;
41:
42: FUNCTION get_inv_rate
43: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
44: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
45: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
46: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
47: p_log_level_rec in fa_api_types.log_level_rec_type default null
48: ) RETURN BOOLEAN;
49:
42: FUNCTION get_inv_rate
43: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
44: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
45: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
46: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
47: p_log_level_rec in fa_api_types.log_level_rec_type default null
48: ) RETURN BOOLEAN;
49:
50: FUNCTION post_clearing
43: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
44: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
45: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
46: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
47: p_log_level_rec in fa_api_types.log_level_rec_type default null
48: ) RETURN BOOLEAN;
49:
50: FUNCTION post_clearing
51: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
47: p_log_level_rec in fa_api_types.log_level_rec_type default null
48: ) RETURN BOOLEAN;
49:
50: FUNCTION post_clearing
51: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
54: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
55: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
48: ) RETURN BOOLEAN;
49:
50: FUNCTION post_clearing
51: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
54: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
55: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
56: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
49:
50: FUNCTION post_clearing
51: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
54: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
55: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
56: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
57: p_payables_cost_tbl IN payables_cost_tbl_type,
50: FUNCTION post_clearing
51: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
54: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
55: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
56: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
57: p_payables_cost_tbl IN payables_cost_tbl_type,
58: p_payables_cost_mrc_tbl IN payables_cost_tbl_type,
51: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
54: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
55: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
56: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
57: p_payables_cost_tbl IN payables_cost_tbl_type,
58: p_payables_cost_mrc_tbl IN payables_cost_tbl_type,
59: p_log_level_rec in fa_api_types.log_level_rec_type default null
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
54: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
55: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
56: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
57: p_payables_cost_tbl IN payables_cost_tbl_type,
58: p_payables_cost_mrc_tbl IN payables_cost_tbl_type,
59: p_log_level_rec in fa_api_types.log_level_rec_type default null
60: ) RETURN BOOLEAN;
55: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
56: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
57: p_payables_cost_tbl IN payables_cost_tbl_type,
58: p_payables_cost_mrc_tbl IN payables_cost_tbl_type,
59: p_log_level_rec in fa_api_types.log_level_rec_type default null
60: ) RETURN BOOLEAN;
61:
62: -- public function
63:
61:
62: -- public function
63:
64: FUNCTION invoice_engine
65: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
66: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
67: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
68: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
62: -- public function
63:
64: FUNCTION invoice_engine
65: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
66: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
67: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
68: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
63:
64: FUNCTION invoice_engine
65: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
66: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
67: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
68: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
64: FUNCTION invoice_engine
65: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
66: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
67: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
68: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
65: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
66: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
67: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
68: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
73: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
66: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
67: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
68: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
73: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
74: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
67: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
68: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
73: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
74: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
75: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
68: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
73: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
74: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
75: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
76: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
69: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
73: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
74: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
75: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
76: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
77: p_calling_fn IN VARCHAR2,
70: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
73: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
74: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
75: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
76: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
77: p_calling_fn IN VARCHAR2,
78: p_log_level_rec in fa_api_types.log_level_rec_type default null
71: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
73: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
74: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
75: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
76: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
77: p_calling_fn IN VARCHAR2,
78: p_log_level_rec in fa_api_types.log_level_rec_type default null
79: ) RETURN BOOLEAN IS
72: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
73: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
74: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
75: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
76: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
77: p_calling_fn IN VARCHAR2,
78: p_log_level_rec in fa_api_types.log_level_rec_type default null
79: ) RETURN BOOLEAN IS
80:
74: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
75: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
76: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
77: p_calling_fn IN VARCHAR2,
78: p_log_level_rec in fa_api_types.log_level_rec_type default null
79: ) RETURN BOOLEAN IS
80:
81: l_rowid varchar2(100); -- placeholder for table handlers
82: l_row_count number := 0;
87: l_current_source_line_id number;
88: l_inv_rec_fa_cost_primary number;
89:
90: -- local structs used for manipulation
91: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
92: l_inv_rec FA_API_TYPES.inv_rec_type;
93: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
94: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
95:
88: l_inv_rec_fa_cost_primary number;
89:
90: -- local structs used for manipulation
91: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
92: l_inv_rec FA_API_TYPES.inv_rec_type;
93: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
94: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
95:
96: l_count number;
89:
90: -- local structs used for manipulation
91: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
92: l_inv_rec FA_API_TYPES.inv_rec_type;
93: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
94: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
95:
96: l_count number;
97:
90: -- local structs used for manipulation
91: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
92: l_inv_rec FA_API_TYPES.inv_rec_type;
93: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
94: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
95:
96: l_count number;
97:
98: -- mrc checks
1316:
1317: ------------------------------------------------------------------------------------------
1318:
1319: FUNCTION inv_calc_info
1320: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1321: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1322: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1323: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1324: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1317: ------------------------------------------------------------------------------------------
1318:
1319: FUNCTION inv_calc_info
1320: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1321: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1322: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1323: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1324: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1325: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1318:
1319: FUNCTION inv_calc_info
1320: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1321: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1322: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1323: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1324: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1325: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1326: p_log_level_rec in fa_api_types.log_level_rec_type default null
1319: FUNCTION inv_calc_info
1320: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1321: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1322: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1323: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1324: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1325: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1326: p_log_level_rec in fa_api_types.log_level_rec_type default null
1327: ) RETURN BOOLEAN IS
1320: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1321: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1322: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1323: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1324: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1325: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1326: p_log_level_rec in fa_api_types.log_level_rec_type default null
1327: ) RETURN BOOLEAN IS
1328:
1321: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1322: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1323: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1324: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1325: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1326: p_log_level_rec in fa_api_types.log_level_rec_type default null
1327: ) RETURN BOOLEAN IS
1328:
1329: l_calling_fn varchar2(35) := 'fa_inv_pvt.inv_calc_info';
1322: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1323: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1324: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1325: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1326: p_log_level_rec in fa_api_types.log_level_rec_type default null
1327: ) RETURN BOOLEAN IS
1328:
1329: l_calling_fn varchar2(35) := 'fa_inv_pvt.inv_calc_info';
1330:
1475:
1476: ------------------------------------------------------------------------------------------
1477:
1478: FUNCTION process_invoice
1479: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1480: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1481: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1482: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1483: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1476: ------------------------------------------------------------------------------------------
1477:
1478: FUNCTION process_invoice
1479: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1480: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1481: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1482: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1483: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1484: p_mrc_sob_type_code IN VARCHAR2,
1477:
1478: FUNCTION process_invoice
1479: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1480: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1481: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1482: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1483: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1484: p_mrc_sob_type_code IN VARCHAR2,
1485: p_log_level_rec in fa_api_types.log_level_rec_type default null
1478: FUNCTION process_invoice
1479: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1480: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1481: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1482: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1483: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1484: p_mrc_sob_type_code IN VARCHAR2,
1485: p_log_level_rec in fa_api_types.log_level_rec_type default null
1486: ) RETURN BOOLEAN IS
1479: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1480: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1481: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1482: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1483: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1484: p_mrc_sob_type_code IN VARCHAR2,
1485: p_log_level_rec in fa_api_types.log_level_rec_type default null
1486: ) RETURN BOOLEAN IS
1487:
1481: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1482: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1483: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1484: p_mrc_sob_type_code IN VARCHAR2,
1485: p_log_level_rec in fa_api_types.log_level_rec_type default null
1486: ) RETURN BOOLEAN IS
1487:
1488: l_rowid varchar2(30);
1489: l_reporting_flag varchar2(1);
1595:
1596: --------------------------------------------------------------------------------
1597:
1598: FUNCTION get_inv_rate
1599: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1600: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1601: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1602: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
1603: p_log_level_rec in fa_api_types.log_level_rec_type default null
1596: --------------------------------------------------------------------------------
1597:
1598: FUNCTION get_inv_rate
1599: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1600: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1601: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1602: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
1603: p_log_level_rec in fa_api_types.log_level_rec_type default null
1604: ) RETURN BOOLEAN IS
1597:
1598: FUNCTION get_inv_rate
1599: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1600: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1601: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1602: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
1603: p_log_level_rec in fa_api_types.log_level_rec_type default null
1604: ) RETURN BOOLEAN IS
1605:
1598: FUNCTION get_inv_rate
1599: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1600: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1601: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1602: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
1603: p_log_level_rec in fa_api_types.log_level_rec_type default null
1604: ) RETURN BOOLEAN IS
1605:
1606: i number := 0;
1599: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1600: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1601: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1602: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
1603: p_log_level_rec in fa_api_types.log_level_rec_type default null
1604: ) RETURN BOOLEAN IS
1605:
1606: i number := 0;
1607: l_inv_rate_ctr number := 0;
1671:
1672: --------------------------------------------------------------------------------
1673:
1674: FUNCTION post_clearing
1675: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1676: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1677: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1678: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1679: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1672: --------------------------------------------------------------------------------
1673:
1674: FUNCTION post_clearing
1675: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1676: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1677: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1678: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1679: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1680: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1673:
1674: FUNCTION post_clearing
1675: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1676: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1677: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1678: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1679: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1680: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1681: p_payables_cost_tbl IN payables_cost_tbl_type,
1674: FUNCTION post_clearing
1675: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1676: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1677: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1678: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1679: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1680: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1681: p_payables_cost_tbl IN payables_cost_tbl_type,
1682: p_payables_cost_mrc_tbl IN payables_cost_tbl_type,
1675: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1676: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1677: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1678: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1679: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1680: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1681: p_payables_cost_tbl IN payables_cost_tbl_type,
1682: p_payables_cost_mrc_tbl IN payables_cost_tbl_type,
1683: p_log_level_rec in fa_api_types.log_level_rec_type default null
1676: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1677: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1678: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1679: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1680: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1681: p_payables_cost_tbl IN payables_cost_tbl_type,
1682: p_payables_cost_mrc_tbl IN payables_cost_tbl_type,
1683: p_log_level_rec in fa_api_types.log_level_rec_type default null
1684: ) RETURN BOOLEAN IS
1679: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1680: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1681: p_payables_cost_tbl IN payables_cost_tbl_type,
1682: p_payables_cost_mrc_tbl IN payables_cost_tbl_type,
1683: p_log_level_rec in fa_api_types.log_level_rec_type default null
1684: ) RETURN BOOLEAN IS
1685:
1686: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1687: