16:
17: -- private prottypes
18:
19: FUNCTION inv_calc_info
20: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
23: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
24: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
17: -- private prottypes
18:
19: FUNCTION inv_calc_info
20: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
23: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
24: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
25: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
18:
19: FUNCTION inv_calc_info
20: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
23: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
24: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
25: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
19: FUNCTION inv_calc_info
20: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
23: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
24: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
25: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
27:
20: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
23: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
24: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
25: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
27:
28: FUNCTION process_invoice
21: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
22: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
23: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
24: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
25: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
27:
28: FUNCTION process_invoice
29: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
23: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
24: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
25: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
27:
28: FUNCTION process_invoice
29: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
25: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
27:
28: FUNCTION process_invoice
29: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
32: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
33: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
27:
28: FUNCTION process_invoice
29: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
32: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
33: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
34: p_mrc_sob_type_code IN VARCHAR2
27:
28: FUNCTION process_invoice
29: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
32: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
33: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
34: p_mrc_sob_type_code IN VARCHAR2
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
28: FUNCTION process_invoice
29: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
32: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
33: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
34: p_mrc_sob_type_code IN VARCHAR2
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
36:
29: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
30: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
31: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
32: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
33: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
34: p_mrc_sob_type_code IN VARCHAR2
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
36:
37: FUNCTION get_inv_rate
31: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
32: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
33: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
34: p_mrc_sob_type_code IN VARCHAR2
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
36:
37: FUNCTION get_inv_rate
38: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
39: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
34: p_mrc_sob_type_code IN VARCHAR2
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
36:
37: FUNCTION get_inv_rate
38: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
39: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
40: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
41: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
36:
37: FUNCTION get_inv_rate
38: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
39: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
40: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
41: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
43:
36:
37: FUNCTION get_inv_rate
38: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
39: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
40: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
41: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
43:
44: FUNCTION post_clearing
37: FUNCTION get_inv_rate
38: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
39: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
40: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
41: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
43:
44: FUNCTION post_clearing
45: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
38: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
39: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
40: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
41: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
43:
44: FUNCTION post_clearing
45: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
41: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
43:
44: FUNCTION post_clearing
45: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
48: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
49: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
43:
44: FUNCTION post_clearing
45: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
48: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
49: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
50: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
43:
44: FUNCTION post_clearing
45: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
48: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
49: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
50: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
51: p_payables_cost_tbl IN payables_cost_tbl_type,
44: FUNCTION post_clearing
45: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
48: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
49: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
50: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
51: p_payables_cost_tbl IN payables_cost_tbl_type,
52: p_payables_cost_mrc_tbl IN payables_cost_tbl_type
45: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
48: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
49: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
50: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
51: p_payables_cost_tbl IN payables_cost_tbl_type,
52: p_payables_cost_mrc_tbl IN payables_cost_tbl_type
53: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
46: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
47: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
48: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
49: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
50: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
51: p_payables_cost_tbl IN payables_cost_tbl_type,
52: p_payables_cost_mrc_tbl IN payables_cost_tbl_type
53: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
54:
49: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
50: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
51: p_payables_cost_tbl IN payables_cost_tbl_type,
52: p_payables_cost_mrc_tbl IN payables_cost_tbl_type
53: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
54:
55: -- public function
56:
57: FUNCTION invoice_engine
54:
55: -- public function
56:
57: FUNCTION invoice_engine
58: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
59: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
60: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
61: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
55: -- public function
56:
57: FUNCTION invoice_engine
58: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
59: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
60: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
61: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
56:
57: FUNCTION invoice_engine
58: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
59: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
60: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
61: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
57: FUNCTION invoice_engine
58: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
59: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
60: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
61: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
58: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
59: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
60: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
61: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
66: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
59: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
60: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
61: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
66: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
67: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
60: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
61: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
66: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
67: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
68: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
61: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
66: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
67: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
68: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
69: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
62: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
66: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
67: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
68: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
69: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
70: p_calling_fn IN varchar2
63: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
66: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
67: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
68: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
69: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
70: p_calling_fn IN varchar2
71: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
64: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
66: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
67: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
68: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
69: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
70: p_calling_fn IN varchar2
71: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
72:
65: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
66: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
67: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
68: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
69: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
70: p_calling_fn IN varchar2
71: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
72:
73: l_rowid varchar2(100); -- placeholder for table handlers
67: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type,
68: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
69: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
70: p_calling_fn IN varchar2
71: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
72:
73: l_rowid varchar2(100); -- placeholder for table handlers
74: l_row_count number := 0;
75: l_deprn_count number := 0;
79: l_current_source_line_id number;
80: l_inv_rec_fa_cost_primary number;
81:
82: -- local structs used for manipulation
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
84: l_inv_rec FA_API_TYPES.inv_rec_type;
85: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
86: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
87:
80: l_inv_rec_fa_cost_primary number;
81:
82: -- local structs used for manipulation
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
84: l_inv_rec FA_API_TYPES.inv_rec_type;
85: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
86: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
87:
88: l_count number;
81:
82: -- local structs used for manipulation
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
84: l_inv_rec FA_API_TYPES.inv_rec_type;
85: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
86: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
87:
88: l_count number;
89:
82: -- local structs used for manipulation
83: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
84: l_inv_rec FA_API_TYPES.inv_rec_type;
85: l_inv_rate_rec FA_API_TYPES.inv_rate_rec_type;
86: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
87:
88: l_count number;
89:
90: -- mrc checks
1285:
1286: ------------------------------------------------------------------------------------------
1287:
1288: FUNCTION inv_calc_info
1289: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1291: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1292: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1293: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1286: ------------------------------------------------------------------------------------------
1287:
1288: FUNCTION inv_calc_info
1289: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1291: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1292: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1293: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1294: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
1287:
1288: FUNCTION inv_calc_info
1289: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1291: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1292: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1293: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1294: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
1295: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1288: FUNCTION inv_calc_info
1289: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1291: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1292: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1293: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1294: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
1295: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1296:
1289: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1291: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1292: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1293: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1294: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
1295: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1296:
1297: error_found exception;
1290: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1291: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1292: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1293: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1294: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
1295: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1296:
1297: error_found exception;
1298:
1291: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1292: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1293: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1294: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type
1295: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1296:
1297: error_found exception;
1298:
1299: BEGIN
1472:
1473: ------------------------------------------------------------------------------------------
1474:
1475: FUNCTION process_invoice
1476: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1477: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1478: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1479: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1480: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1473: ------------------------------------------------------------------------------------------
1474:
1475: FUNCTION process_invoice
1476: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1477: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1478: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1479: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1480: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1481: p_mrc_sob_type_code IN VARCHAR2
1474:
1475: FUNCTION process_invoice
1476: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1477: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1478: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1479: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1480: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1481: p_mrc_sob_type_code IN VARCHAR2
1482: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1475: FUNCTION process_invoice
1476: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1477: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1478: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1479: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1480: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1481: p_mrc_sob_type_code IN VARCHAR2
1482: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1483:
1476: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1477: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
1478: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1479: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1480: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1481: p_mrc_sob_type_code IN VARCHAR2
1482: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1483:
1484: l_rowid varchar2(30);
1478: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1479: px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
1480: p_inv_rate_rec IN FA_API_TYPES.inv_rate_rec_type,
1481: p_mrc_sob_type_code IN VARCHAR2
1482: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1483:
1484: l_rowid varchar2(30);
1485: l_reporting_flag varchar2(1);
1486: error_found EXCEPTION;
1591:
1592: --------------------------------------------------------------------------------
1593:
1594: FUNCTION get_inv_rate
1595: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1597: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1598: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
1599: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1592: --------------------------------------------------------------------------------
1593:
1594: FUNCTION get_inv_rate
1595: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1597: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1598: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
1599: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1600:
1593:
1594: FUNCTION get_inv_rate
1595: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1597: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1598: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
1599: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1600:
1601: i number := 0;
1594: FUNCTION get_inv_rate
1595: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1597: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1598: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
1599: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1600:
1601: i number := 0;
1602: l_inv_rate_ctr number := 0;
1595: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1597: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1598: px_inv_tbl IN OUT NOCOPY FA_API_TYPES.inv_tbl_type
1599: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1600:
1601: i number := 0;
1602: l_inv_rate_ctr number := 0;
1603:
1668:
1669: --------------------------------------------------------------------------------
1670:
1671: FUNCTION post_clearing
1672: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1674: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1675: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1676: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1669: --------------------------------------------------------------------------------
1670:
1671: FUNCTION post_clearing
1672: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1674: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1675: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1676: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1677: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1670:
1671: FUNCTION post_clearing
1672: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1674: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1675: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1676: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1677: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1678: p_payables_cost_tbl IN payables_cost_tbl_type,
1671: FUNCTION post_clearing
1672: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1674: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1675: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1676: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1677: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1678: p_payables_cost_tbl IN payables_cost_tbl_type,
1679: p_payables_cost_mrc_tbl IN payables_cost_tbl_type
1672: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1674: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1675: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1676: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1677: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1678: p_payables_cost_tbl IN payables_cost_tbl_type,
1679: p_payables_cost_mrc_tbl IN payables_cost_tbl_type
1680: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1673: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1674: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1675: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1676: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1677: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1678: p_payables_cost_tbl IN payables_cost_tbl_type,
1679: p_payables_cost_mrc_tbl IN payables_cost_tbl_type
1680: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1681:
1676: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1677: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1678: p_payables_cost_tbl IN payables_cost_tbl_type,
1679: p_payables_cost_mrc_tbl IN payables_cost_tbl_type
1680: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1681:
1682: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1683:
1684: i number;