15: );
16:
17:
18: procedure create_inv_ae_lines(
19: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
20: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
21: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
22: ) ;
23:
16:
17:
18: procedure create_inv_ae_lines(
19: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
20: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
21: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
22: ) ;
23:
24: procedure wip_cost_txn(
17:
18: procedure create_inv_ae_lines(
19: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
20: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
21: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
22: ) ;
23:
24: procedure wip_cost_txn(
25: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
21: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
22: ) ;
23:
24: procedure wip_cost_txn(
25: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
26: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
27: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
28: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
29: ) ;
22: ) ;
23:
24: procedure wip_cost_txn(
25: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
26: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
27: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
28: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
29: ) ;
30:
23:
24: procedure wip_cost_txn(
25: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
26: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
27: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
28: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
29: ) ;
30:
31: procedure sub_cost_txn(
24: procedure wip_cost_txn(
25: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
26: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
27: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
28: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
29: ) ;
30:
31: procedure sub_cost_txn(
32: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
28: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
29: ) ;
30:
31: procedure sub_cost_txn(
32: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
33: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
34: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
35: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
36: ) ;
29: ) ;
30:
31: procedure sub_cost_txn(
32: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
33: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
34: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
35: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
36: ) ;
37:
30:
31: procedure sub_cost_txn(
32: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
33: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
34: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
35: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
36: ) ;
37:
38: procedure interorg_cost_txn(
31: procedure sub_cost_txn(
32: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
33: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
34: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
35: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
36: ) ;
37:
38: procedure interorg_cost_txn(
39: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
35: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
36: ) ;
37:
38: procedure interorg_cost_txn(
39: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
40: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
41: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
42: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
43: ) ;
36: ) ;
37:
38: procedure interorg_cost_txn(
39: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
40: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
41: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
42: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
43: ) ;
44:
37:
38: procedure interorg_cost_txn(
39: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
40: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
41: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
42: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
43: ) ;
44:
45: procedure pcu_cost_txn(
38: procedure interorg_cost_txn(
39: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
40: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
41: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
42: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
43: ) ;
44:
45: procedure pcu_cost_txn(
46: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
42: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
43: ) ;
44:
45: procedure pcu_cost_txn(
46: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
47: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
48: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
49: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
50: ) ;
43: ) ;
44:
45: procedure pcu_cost_txn(
46: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
47: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
48: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
49: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
50: ) ;
51:
44:
45: procedure pcu_cost_txn(
46: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
47: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
48: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
49: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
50: ) ;
51:
52: procedure inv_cost_txn(
45: procedure pcu_cost_txn(
46: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
47: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
48: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
49: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
50: ) ;
51:
52: procedure inv_cost_txn(
53: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
49: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
50: ) ;
51:
52: procedure inv_cost_txn(
53: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
54: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
55: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
56: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
57: ) ;
50: ) ;
51:
52: procedure inv_cost_txn(
53: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
54: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
55: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
56: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
57: ) ;
58:
51:
52: procedure inv_cost_txn(
53: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
54: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
55: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
56: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
57: ) ;
58:
59: procedure cost_logical_txn(
52: procedure inv_cost_txn(
53: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
54: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
55: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
56: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
57: ) ;
58:
59: procedure cost_logical_txn(
60: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
56: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
57: ) ;
58:
59: procedure cost_logical_txn(
60: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
61: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
62: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
63: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
64: ) ;
57: ) ;
58:
59: procedure cost_logical_txn(
60: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
61: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
62: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
63: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
64: ) ;
65:
58:
59: procedure cost_logical_txn(
60: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
61: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
62: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
63: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
64: ) ;
65:
66: procedure cost_consigned_update_txn(
59: procedure cost_logical_txn(
60: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
61: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
62: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
63: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
64: ) ;
65:
66: procedure cost_consigned_update_txn(
67: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
63: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
64: ) ;
65:
66: procedure cost_consigned_update_txn(
67: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
68: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
69: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
70: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
71: ) ;
64: ) ;
65:
66: procedure cost_consigned_update_txn(
67: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
68: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
69: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
70: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
71: ) ;
72:
65:
66: procedure cost_consigned_update_txn(
67: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
68: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
69: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
70: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
71: ) ;
72:
73: procedure inventory_accounts(
66: procedure cost_consigned_update_txn(
67: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
68: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
69: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
70: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
71: ) ;
72:
73: procedure inventory_accounts(
74: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
70: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
71: ) ;
72:
73: procedure inventory_accounts(
74: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
75: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
76: i_exp_flag IN BOOLEAN,
77: i_exp_account IN NUMBER,
78: i_dr_flag IN BOOLEAN,
71: ) ;
72:
73: procedure inventory_accounts(
74: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
75: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
76: i_exp_flag IN BOOLEAN,
77: i_exp_account IN NUMBER,
78: i_dr_flag IN BOOLEAN,
79: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
75: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
76: i_exp_flag IN BOOLEAN,
77: i_exp_account IN NUMBER,
78: i_dr_flag IN BOOLEAN,
79: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
80: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
81: i_intransit_flag IN NUMBER DEFAULT 0
82: ) ;
83:
76: i_exp_flag IN BOOLEAN,
77: i_exp_account IN NUMBER,
78: i_dr_flag IN BOOLEAN,
79: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
80: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
81: i_intransit_flag IN NUMBER DEFAULT 0
82: ) ;
83:
84: procedure encumbrance_account(
81: i_intransit_flag IN NUMBER DEFAULT 0
82: ) ;
83:
84: procedure encumbrance_account(
85: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
86: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
87: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
88: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
89: );
82: ) ;
83:
84: procedure encumbrance_account(
85: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
86: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
87: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
88: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
89: );
90: procedure offset_accounts(
83:
84: procedure encumbrance_account(
85: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
86: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
87: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
88: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
89: );
90: procedure offset_accounts(
91: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
84: procedure encumbrance_account(
85: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
86: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
87: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
88: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
89: );
90: procedure offset_accounts(
91: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
92: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
87: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
88: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
89: );
90: procedure offset_accounts(
91: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
92: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
93: i_acct_line_type IN NUMBER,
94: i_elemental IN NUMBER,
95: i_ovhd_absp IN NUMBER,
88: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
89: );
90: procedure offset_accounts(
91: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
92: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
93: i_acct_line_type IN NUMBER,
94: i_elemental IN NUMBER,
95: i_ovhd_absp IN NUMBER,
96: i_dr_flag IN BOOLEAN,
93: i_acct_line_type IN NUMBER,
94: i_elemental IN NUMBER,
95: i_ovhd_absp IN NUMBER,
96: i_dr_flag IN BOOLEAN,
97: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
98: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
99: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
100: );
101:
94: i_elemental IN NUMBER,
95: i_ovhd_absp IN NUMBER,
96: i_dr_flag IN BOOLEAN,
97: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
98: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
99: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
100: );
101:
102: procedure ovhd_accounts(
95: i_ovhd_absp IN NUMBER,
96: i_dr_flag IN BOOLEAN,
97: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
98: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
99: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
100: );
101:
102: procedure ovhd_accounts(
103: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
99: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
100: );
101:
102: procedure ovhd_accounts(
103: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
104: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
105: i_dr_flag IN BOOLEAN,
106: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
107: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
100: );
101:
102: procedure ovhd_accounts(
103: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
104: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
105: i_dr_flag IN BOOLEAN,
106: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
107: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
108: );
102: procedure ovhd_accounts(
103: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
104: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
105: i_dr_flag IN BOOLEAN,
106: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
107: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
108: );
109:
110: PROCEDURE insert_account(
103: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
104: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
105: i_dr_flag IN BOOLEAN,
106: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
107: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
108: );
109:
110: PROCEDURE insert_account(
111: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
107: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
108: );
109:
110: PROCEDURE insert_account(
111: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
112: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
113: i_dr_flag IN BOOLEAN,
114: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
115: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
108: );
109:
110: PROCEDURE insert_account(
111: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
112: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
113: i_dr_flag IN BOOLEAN,
114: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
115: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
116: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
110: PROCEDURE insert_account(
111: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
112: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
113: i_dr_flag IN BOOLEAN,
114: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
115: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
116: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
117: );
118:
111: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
112: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
113: i_dr_flag IN BOOLEAN,
114: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
115: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
116: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
117: );
118:
119: procedure balance_account (
112: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
113: i_dr_flag IN BOOLEAN,
114: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
115: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
116: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
117: );
118:
119: procedure balance_account (
120: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
116: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
117: );
118:
119: procedure balance_account (
120: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
121: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
122: );
123:
124:
117: );
118:
119: procedure balance_account (
120: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
121: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
122: );
123:
124:
125: procedure create_wip_ae_lines(
122: );
123:
124:
125: procedure create_wip_ae_lines(
126: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
127: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
128: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
129: ) ;
130:
123:
124:
125: procedure create_wip_ae_lines(
126: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
127: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
128: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
129: ) ;
130:
131: procedure get_accts(
124:
125: procedure create_wip_ae_lines(
126: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
127: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
128: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
129: ) ;
130:
131: procedure get_accts(
132: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
128: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
129: ) ;
130:
131: procedure get_accts(
132: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
133: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
134: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
135: o_acct_id1 OUT NOCOPY NUMBER,
136: o_acct_id2 OUT NOCOPY NUMBER,
129: ) ;
130:
131: procedure get_accts(
132: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
133: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
134: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
135: o_acct_id1 OUT NOCOPY NUMBER,
136: o_acct_id2 OUT NOCOPY NUMBER,
137: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
130:
131: procedure get_accts(
132: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
133: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
134: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
135: o_acct_id1 OUT NOCOPY NUMBER,
136: o_acct_id2 OUT NOCOPY NUMBER,
137: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
138: );
133: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
134: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
135: o_acct_id1 OUT NOCOPY NUMBER,
136: o_acct_id2 OUT NOCOPY NUMBER,
137: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
138: );
139:
140: procedure WIP_accounts(
141: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
137: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
138: );
139:
140: procedure WIP_accounts(
141: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
142: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
143: i_acct_line_type IN NUMBER,
144: i_ovhd_absp IN NUMBER,
145: i_dr_flag IN BOOLEAN,
138: );
139:
140: procedure WIP_accounts(
141: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
142: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
143: i_acct_line_type IN NUMBER,
144: i_ovhd_absp IN NUMBER,
145: i_dr_flag IN BOOLEAN,
146: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
142: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
143: i_acct_line_type IN NUMBER,
144: i_ovhd_absp IN NUMBER,
145: i_dr_flag IN BOOLEAN,
146: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
147: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
148: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type);
149:
150: Function Get_Intercompany_account(
143: i_acct_line_type IN NUMBER,
144: i_ovhd_absp IN NUMBER,
145: i_dr_flag IN BOOLEAN,
146: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
147: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
148: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type);
149:
150: Function Get_Intercompany_account(
151: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
144: i_ovhd_absp IN NUMBER,
145: i_dr_flag IN BOOLEAN,
146: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
147: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
148: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type);
149:
150: Function Get_Intercompany_account(
151: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
152: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
147: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
148: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type);
149:
150: Function Get_Intercompany_account(
151: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
152: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
153: RETURN NUMBER;
154:
155: PROCEDURE cost_internal_order_exp_txn(
148: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type);
149:
150: Function Get_Intercompany_account(
151: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
152: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
153: RETURN NUMBER;
154:
155: PROCEDURE cost_internal_order_exp_txn(
156: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
152: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
153: RETURN NUMBER;
154:
155: PROCEDURE cost_internal_order_exp_txn(
156: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
157: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
158: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
159: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
160: ) ;
153: RETURN NUMBER;
154:
155: PROCEDURE cost_internal_order_exp_txn(
156: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
157: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
158: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
159: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
160: ) ;
161:
154:
155: PROCEDURE cost_internal_order_exp_txn(
156: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
157: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
158: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
159: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
160: ) ;
161:
162: Procedure get_pacp_priorPrd_mta_cost (
155: PROCEDURE cost_internal_order_exp_txn(
156: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
157: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
158: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
159: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
160: ) ;
161:
162: Procedure get_pacp_priorPrd_mta_cost (
163: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
159: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
160: ) ;
161:
162: Procedure get_pacp_priorPrd_mta_cost (
163: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
164: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
165: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
166: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
167: o_pacp_flag OUT NOCOPY NUMBER,
160: ) ;
161:
162: Procedure get_pacp_priorPrd_mta_cost (
163: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
164: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
165: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
166: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
167: o_pacp_flag OUT NOCOPY NUMBER,
168: o_pacp_pwac_cost OUT NOCOPY NUMBER,
161:
162: Procedure get_pacp_priorPrd_mta_cost (
163: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
164: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
165: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
166: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
167: o_pacp_flag OUT NOCOPY NUMBER,
168: o_pacp_pwac_cost OUT NOCOPY NUMBER,
169: o_prev_period_flag OUT NOCOPY NUMBER,
162: Procedure get_pacp_priorPrd_mta_cost (
163: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
164: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
165: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
166: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
167: o_pacp_flag OUT NOCOPY NUMBER,
168: o_pacp_pwac_cost OUT NOCOPY NUMBER,
169: o_prev_period_flag OUT NOCOPY NUMBER,
170: o_prev_period_pwac_cost OUT NOCOPY NUMBER,
182: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
183: p_total_primary_qty IN NUMBER,
184: x_encumbrance_amount OUT NOCOPY NUMBER,
185: x_encumbrance_account OUT NOCOPY NUMBER,
186: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
187: ) ;
188:
189: PROCEDURE CompEncumbrance_IntOrdersExp (
190: p_api_version IN NUMBER,
190: p_api_version IN NUMBER,
191: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
192: x_encumbrance_amount OUT NOCOPY NUMBER,
193: x_encumbrance_account OUT NOCOPY NUMBER,
194: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
195: );
196:
197: end CSTPAPBR;