1 PACKAGE CSTPPACQ AS
2 /* $Header: CSTPACQS.pls 120.1.12010000.1 2008/07/24 17:21:39 appldev ship $ */
3
4 PROCEDURE acq_cost_processor(
5 i_period IN NUMBER,
6 i_start_date IN DATE,
7 i_end_date IN DATE,
8 i_cost_type_id IN NUMBER,
9 i_cost_group_id IN NUMBER,
10 i_user_id IN NUMBER,
11 i_login_id IN NUMBER,
12 i_req_id IN NUMBER,
13 i_prog_id IN NUMBER,
14 i_prog_appl_id IN NUMBER,
15 o_err_num OUT NOCOPY NUMBER,
16 o_err_code OUT NOCOPY VARCHAR2,
17 o_err_msg OUT NOCOPY VARCHAR2,
18 i_source_flag IN NUMBER DEFAULT 1,
19 i_receipt_no IN NUMBER DEFAULT NULL,
20 i_invoice_no IN NUMBER DEFAULT NULL,
21 i_adj_account IN NUMBER DEFAULT NULL);
22
23 FUNCTION get_nqr(
24 i_transaction_id IN NUMBER,
25 i_source_flag IN NUMBER,
26 i_start_date IN DATE,
27 i_end_date IN DATE,
28 i_res_flag IN NUMBER,
29 o_err_num OUT NOCOPY NUMBER) RETURN NUMBER;
30
31 PROCEDURE get_charge_allocs (
32 i_hdr IN NUMBER,
33 i_item_dist IN NUMBER,
34 i_start_date IN DATE,
35 i_end_date IN DATE,
36 i_res_flag IN NUMBER,
37 i_user_id IN NUMBER,
38 i_login_id IN NUMBER,
39 i_req_id IN NUMBER,
40 i_prog_id IN NUMBER,
41 i_prog_appl_id IN NUMBER,
42 o_err_num OUT NOCOPY NUMBER,
43 o_err_code OUT NOCOPY VARCHAR2,
44 o_err_msg OUT NOCOPY VARCHAR2);
45
46 Procedure get_charge_allocs_for_acqadj(
47 i_hdr IN NUMBER,
48 i_item_dist IN NUMBER,
49 l_start_date IN DATE,
50 l_end_date IN DATE,
51 i_user_id IN NUMBER,
52 i_login_id IN NUMBER,
53 i_req_id IN NUMBER,
54 i_prog_id IN NUMBER,
55 i_prog_appl_id IN NUMBER,
56 o_err_num OUT NOCOPY NUMBER,
57 o_err_code OUT NOCOPY VARCHAR2,
58 o_err_msg OUT NOCOPY VARCHAR2);
59
60
61 PROCEDURE compute_acq_cost (
62 i_header IN NUMBER,
63 i_nqr IN NUMBER,
64 i_po_line_loc IN NUMBER,
65 i_po_price IN NUMBER,
66 i_primary_uom IN VARCHAR2,
67 i_rate IN NUMBER,
68 i_po_uom IN VARCHAR2,
69 i_item IN NUMBER,
70 i_user_id IN NUMBER,
71 i_login_id IN NUMBER,
72 i_req_id IN NUMBER,
73 i_prog_id IN NUMBER,
74 i_prog_appl_id IN NUMBER,
75 o_err_num OUT NOCOPY NUMBER,
76 o_err_code OUT NOCOPY VARCHAR2,
77 o_err_msg OUT NOCOPY VARCHAR2);
78
79 Procedure compute_acq_cost_acqadj(
80 i_header IN NUMBER,
81 i_nqr IN NUMBER,
82 i_po_line_loc IN NUMBER,
83 i_po_price IN NUMBER,
84 i_primary_uom IN VARCHAR2,
85 i_rate IN NUMBER,
86 i_po_uom IN VARCHAR2,
87 i_item IN NUMBER,
88 i_pac_period_id IN NUMBER,
89 i_cost_group_id IN NUMBER,
90 i_org_id IN NUMBER,
91 i_cost_type_id IN NUMBER,
92 i_adj_account IN NUMBER,
93 i_user_id IN NUMBER,
94 i_login_id IN NUMBER,
95 i_req_id IN NUMBER,
96 i_prog_id IN NUMBER,
97 i_prog_appl_id IN NUMBER,
98 o_err_num OUT NOCOPY NUMBER,
99 o_err_code OUT NOCOPY VARCHAR2,
100 o_err_msg OUT NOCOPY VARCHAR2);
101
102
103 PROCEDURE get_acq_cost (
104 i_cost_group_id IN NUMBER,
105 i_txn_id IN NUMBER,
106 i_cost_type_id IN NUMBER,
107 i_wip_inv_flag IN VARCHAR2,
108 o_acq_cost OUT NOCOPY NUMBER,
109 o_err_num OUT NOCOPY NUMBER,
110 o_err_code OUT NOCOPY VARCHAR2,
111 o_err_msg OUT NOCOPY VARCHAR2);
112
113 FUNCTION get_rcv_tax (
114 i_rcv_txn_id IN NUMBER)
115 RETURN NUMBER ;
116
117 FUNCTION get_po_rate (
118 i_rcv_txn_id IN NUMBER)
119 RETURN NUMBER ;
120
121 FUNCTION get_net_undel_qty(
122 i_transaction_id IN NUMBER,
123 i_end_date IN DATE)
124 RETURN NUMBER;
125
126 Procedure Insert_into_acqhdr_tables(
127 i_header_id IN NUMBER,
128 i_cost_group_id IN NUMBER,
129 i_cost_type_id IN NUMBER,
130 i_period_id IN NUMBER,
131 i_rcv_transaction_id IN NUMBER,
132 i_net_quantity_received IN NUMBER,
133 i_total_quantity_invoiced IN NUMBER,
134 i_quantity_at_po_price IN NUMBER,
135 i_total_invoice_amount IN NUMBER,
136 i_amount_at_po_price IN NUMBER,
137 i_total_amount IN NUMBER,
138 i_costed_quantity IN NUMBER,
139 i_acquisition_cost IN NUMBER,
140 i_po_line_location_id IN NUMBER,
141 i_po_unit_price IN NUMBER,
142 i_primary_uom IN VARCHAR2,
143 i_rec_exchg_rate IN NUMBER,
144 i_last_update_date IN DATE,
145 i_last_updated_by IN NUMBER,
146 i_creation_date IN DATE,
147 i_created_by IN NUMBER,
148 i_request_id IN NUMBER,
149 i_program_application_id IN NUMBER,
150 i_program_id IN NUMBER,
151 i_program_update_date IN DATE,
152 i_last_update_login IN NUMBER,
153 i_source_flag IN NUMBER,
154 o_err_num OUT NOCOPY NUMBER,
155 o_err_msg OUT NOCOPY VARCHAR2 );
156
157 Procedure Insert_into_acqdtls_tables (
158 i_header_id IN NUMBER,
159 i_detail_id IN NUMBER,
160 i_source_type IN VARCHAR2,
161 i_po_line_location_id IN NUMBER,
162 i_parent_distribution_id IN NUMBER,
163 i_distribution_num IN NUMBER,
164 i_level_num IN NUMBER,
165 i_invoice_distribution_id IN NUMBER,
166 i_parent_inv_distribution_id IN NUMBER,
167 i_allocated_amount IN NUMBER,
168 i_parent_amount IN NUMBER,
169 i_amount IN NUMBER,
170 i_quantity IN NUMBER,
171 i_price IN NUMBER,
172 i_line_type IN VARCHAR2,
173 i_last_update_date IN DATE,
174 i_last_updated_by IN NUMBER,
175 i_creation_date IN DATE,
176 i_created_by IN NUMBER,
177 i_request_id IN NUMBER,
178 i_program_application_id IN NUMBER,
179 i_program_id IN NUMBER,
180 i_program_update_date IN DATE,
181 i_last_update_login IN NUMBER,
182 i_source_flag IN NUMBER,
183 o_err_num OUT NOCOPY NUMBER,
184 o_err_msg OUT NOCOPY VARCHAR2);
185
186 Procedure Acquisition_cost_adj_processor(
187 ERRBUF OUT NOCOPY VARCHAR2,
188 RETCODE OUT NOCOPY NUMBER,
189 i_legal_entity IN NUMBER,
190 i_cost_type_id IN NUMBER,
191 i_period IN NUMBER,
192 i_end_date IN VARCHAR2,
193 i_cost_group_id IN NUMBER,
194 i_source_flag IN NUMBER,
195 i_run_option IN NUMBER,
196 i_receipt_dummy IN VARCHAR2,
197 i_receipt_no IN NUMBER,
198 i_invoice_dummy IN VARCHAR2,
199 i_invoice_no IN NUMBER,
200 i_chart_of_ac_id IN NUMBER,
201 i_adj_account_dummy IN NUMBER,
202 i_adj_account IN NUMBER
203 );
204
205
206 --pragma restrict_references(get_rcv_tax, WNDS, WNPS, RNPS);
207 --pragma restrict_references(get_po_rate, WNDS, WNPS, RNPS);
208
209 END CSTPPACQ;