1 PACKAGE CSTPPWAC AUTHID CURRENT_USER AS
2 /* $Header: CSTPWACS.pls 120.4.12010000.3 2008/11/10 13:35:14 anjha ship $ */
3
4 -- PROCEDURE
5 -- cost_processor Costs inventory transactions
6 --
7 procedure cost_processor(
8 I_LEGAL_ENTITY IN NUMBER,
9 I_PAC_PERIOD_ID IN NUMBER,
10 I_ORG_ID IN NUMBER,
11 I_COST_GROUP_ID IN NUMBER,
12 I_TXN_COST_GROUP_ID IN NUMBER,
13 I_TXFR_COST_GROUP_ID IN NUMBER,
14 I_COST_TYPE_ID IN NUMBER,
15 I_COST_METHOD IN NUMBER,
16 I_PROCESS_GROUP IN NUMBER,
17 I_TXN_ID IN NUMBER,
18 I_QTY_LAYER_ID IN NUMBER,
19 I_COST_LAYER_ID IN NUMBER,
20 I_PAC_RATES_ID IN NUMBER,
21 I_ITEM_ID IN NUMBER,
22 I_TXN_QTY IN NUMBER,
23 I_TXN_ACTION_ID IN NUMBER,
24 I_TXN_SRC_TYPE_ID IN NUMBER,
25 I_FOB_POINT IN NUMBER,
26 I_EXP_ITEM IN NUMBER,
27 I_EXP_FLAG IN NUMBER,
28 I_COST_HOOK_USED IN NUMBER,
29 I_USER_ID IN NUMBER,
30 I_LOGIN_ID IN NUMBER,
31 I_REQ_ID IN NUMBER,
32 I_PRG_APPL_ID IN NUMBER,
33 I_PRG_ID IN NUMBER,
34 I_TXN_CATEGORY IN NUMBER,
35 O_Err_Num OUT NOCOPY NUMBER,
36 O_Err_Code OUT NOCOPY VARCHAR2,
37 O_Err_Msg OUT NOCOPY VARCHAR2
38 );
39
40
41
42 -- PROCEDURE
43 -- sub_transfer
44 --
45 procedure sub_transfer(
46 I_PAC_PERIOD_ID IN NUMBER,
47 I_ORG_ID IN NUMBER,
48 I_COST_GROUP_ID IN NUMBER,
49 I_COST_TYPE_ID IN NUMBER,
50 I_TXN_ID IN NUMBER,
51 I_COST_LAYER_ID IN NUMBER,
52 I_QTY_LAYER_ID IN NUMBER,
53 I_PAC_RATES_ID IN NUMBER,
54 I_ITEM_ID IN NUMBER,
55 I_TXN_QTY IN NUMBER,
56 I_TXN_ACTION_ID IN NUMBER,
57 I_TXN_SRC_TYPE_ID IN NUMBER,
58 I_EXP_FLAG IN NUMBER,
59 I_NO_UPDATE_QTY IN NUMBER,
60 I_COST_METHOD IN NUMBER,
61 I_USER_ID IN NUMBER,
62 I_LOGIN_ID IN NUMBER,
63 I_REQ_ID IN NUMBER,
64 I_PRG_APPL_ID IN NUMBER,
65 I_PRG_ID IN NUMBER,
66 I_TXN_CATEGORY IN NUMBER,
67 O_Err_Num OUT NOCOPY NUMBER,
68 O_Err_Code OUT NOCOPY VARCHAR2,
69 O_Err_Msg OUT NOCOPY VARCHAR2
70 );
71
72
73
74 -- PROCEDURE
75 -- interorg
76 --
77 procedure interorg(
78 I_PAC_PERIOD_ID IN NUMBER,
79 I_ORG_ID IN NUMBER,
80 I_COST_GROUP_ID IN NUMBER,
81 I_TXFR_COST_GROUP_ID IN NUMBER,
82 I_COST_TYPE_ID IN NUMBER,
83 I_COST_METHOD IN NUMBER,
84 I_TXN_ID IN NUMBER,
85 I_COST_LAYER_ID IN NUMBER,
86 I_QTY_LAYER_ID IN NUMBER,
87 I_ITEM_ID IN NUMBER,
88 I_TXN_QTY IN NUMBER,
89 I_ISSUE_QTY IN NUMBER,
90 I_BUY_QTY IN NUMBER,
91 I_MAKE_QTY IN NUMBER,
92 I_TXN_ACTION_ID IN NUMBER,
93 I_TXN_SRC_TYPE_ID IN NUMBER,
94 I_EXP_FLAG IN NUMBER,
95 I_INTERORG_REC IN NUMBER,
96 I_USER_ID IN NUMBER,
97 I_LOGIN_ID IN NUMBER,
98 I_REQ_ID IN NUMBER,
99 I_PRG_APPL_ID IN NUMBER,
100 I_PRG_ID IN NUMBER,
101 I_TXN_CATEGORY IN NUMBER,
102 O_Err_Num OUT NOCOPY NUMBER,
103 O_Err_Code OUT NOCOPY VARCHAR2,
104 O_Err_Msg OUT NOCOPY VARCHAR2
105 );
106
107
108
109 -- PROCEDURE
110 -- cost_owned_txns
111 --
112 procedure cost_owned_txns(
113 I_PAC_PERIOD_ID IN NUMBER,
114 I_COST_GROUP_ID IN NUMBER,
115 I_COST_TYPE_ID IN NUMBER,
116 I_TXN_ID IN NUMBER,
117 I_COST_LAYER_ID IN NUMBER,
118 I_QTY_LAYER_ID IN NUMBER,
119 I_ITEM_ID IN NUMBER,
120 I_TXN_QTY IN NUMBER,
121 I_ISSUE_QTY IN NUMBER,
122 I_BUY_QTY IN NUMBER,
123 I_MAKE_QTY IN NUMBER,
124 I_TXN_ACTION_ID IN NUMBER,
125 I_COST_METHOD IN NUMBER,
126 I_USER_ID IN NUMBER,
127 I_LOGIN_ID IN NUMBER,
128 I_REQ_ID IN NUMBER,
129 I_PRG_APPL_ID IN NUMBER,
130 I_PRG_ID IN NUMBER,
131 I_TXN_CATEGORY IN NUMBER,
132 O_Err_Num OUT NOCOPY NUMBER,
133 O_Err_Code OUT NOCOPY VARCHAR2,
134 O_Err_Msg OUT NOCOPY VARCHAR2
135 );
136
137
138
139 -- PROCEDURE
140 -- cost_derived_txns
141 --
142 procedure cost_derived_txns(
143 I_PAC_PERIOD_ID IN NUMBER,
144 I_COST_GROUP_ID IN NUMBER,
145 I_COST_TYPE_ID IN NUMBER,
146 I_TXN_ID IN NUMBER,
147 I_COST_LAYER_ID IN NUMBER,
148 I_QTY_LAYER_ID IN NUMBER,
149 I_ITEM_ID IN NUMBER,
150 I_TXN_QTY IN NUMBER,
151 I_ISSUE_QTY IN NUMBER,
152 I_BUY_QTY IN NUMBER,
153 I_MAKE_QTY IN NUMBER,
154 I_TXN_ACTION_ID IN NUMBER,
155 I_TXN_SRC_TYPE_ID IN NUMBER,
156 I_EXP_FLAG IN NUMBER,
157 I_NO_UPDATE_QTY IN NUMBER,
158 I_COST_METHOD IN NUMBER,
159 I_USER_ID IN NUMBER,
160 I_LOGIN_ID IN NUMBER,
161 I_REQ_ID IN NUMBER,
162 I_PRG_APPL_ID IN NUMBER,
163 I_PRG_ID IN NUMBER,
164 I_TXN_CATEGORY IN NUMBER,
165 O_Err_Num OUT NOCOPY NUMBER,
166 O_Err_Code OUT NOCOPY VARCHAR2,
167 O_Err_Msg OUT NOCOPY VARCHAR2
168 );
169
170
171
172 -- FUNCTION
173 -- compute_pwac_cost
174 --
175 function compute_pwac_cost(
176 I_PAC_PERIOD_ID IN NUMBER,
177 I_ORG_ID IN NUMBER,
178 I_COST_GROUP_ID IN NUMBER,
179 I_COST_TYPE_ID IN NUMBER,
180 I_TXN_ID IN NUMBER,
181 I_COST_LAYER_ID IN NUMBER,
182 I_PAC_RATES_ID IN NUMBER,
183 I_ITEM_ID IN NUMBER,
184 I_TXN_QTY IN NUMBER,
185 I_TXN_ACTION_ID IN NUMBER,
186 I_TXN_SRC_TYPE_ID IN NUMBER,
187 I_INTERORG_REC IN NUMBER,
188 I_ACROSS_CGS IN NUMBER,
189 I_EXP_FLAG IN NUMBER,
190 I_USER_ID IN NUMBER,
191 I_LOGIN_ID IN NUMBER,
192 I_REQ_ID IN NUMBER,
193 I_PRG_APPL_ID IN NUMBER,
194 I_PRG_ID IN NUMBER,
195 I_TXN_CATEGORY IN NUMBER,
196 O_Err_Num OUT NOCOPY NUMBER,
197 O_Err_Code OUT NOCOPY VARCHAR2,
198 O_Err_Msg OUT NOCOPY VARCHAR2
199 )
200 return integer;
201
202
203
204 -- PROCEDURE
205 -- apply_material_ovhd Applying this level material overhead based
206 -- on the pre-defined rates in the material
207 --
208 procedure apply_material_ovhd(
209 I_PAC_PERIOD_ID IN NUMBER,
210 I_ORG_ID IN NUMBER,
211 I_COST_GROUP_ID IN NUMBER,
212 I_COST_TYPE_ID IN NUMBER,
213 I_TXN_ID IN NUMBER,
214 I_COST_LAYER_ID IN NUMBER,
215 I_PAC_RATES_ID IN NUMBER,
216 I_ITEM_ID IN NUMBER,
217 I_TXN_QTY IN NUMBER,
218 I_LEVEL IN NUMBER,
219 I_USER_ID IN NUMBER,
220 I_LOGIN_ID IN NUMBER,
221 I_REQ_ID IN NUMBER,
222 I_PRG_APPL_ID IN NUMBER,
223 I_PRG_ID IN NUMBER,
224 I_TXN_CATEGORY IN NUMBER,
225 O_Err_Num OUT NOCOPY NUMBER,
226 O_Err_Code OUT NOCOPY VARCHAR2,
227 O_Err_Msg OUT NOCOPY VARCHAR2
228 );
229
230
231
232 -- PROCEDURE
233 -- current_pwac_cost
234 --
235 procedure current_pwac_cost(
236 I_COST_LAYER_ID IN NUMBER,
237 I_QTY_LAYER_ID IN NUMBER,
238 I_TXN_QTY IN NUMBER,
239 I_ISSUE_QTY IN NUMBER,
240 I_BUY_QTY IN NUMBER,
241 I_MAKE_QTY IN NUMBER,
242 I_TXN_ACTION_ID IN NUMBER,
243 I_EXP_FLAG IN NUMBER,
244 I_NO_UPDATE_QTY IN NUMBER,
245 I_USER_ID IN NUMBER,
246 I_LOGIN_ID IN NUMBER,
247 I_REQ_ID IN NUMBER,
248 I_PRG_APPL_ID IN NUMBER,
249 I_PRG_ID IN NUMBER,
250 I_TXN_CATEGORY IN NUMBER,
251 I_TXN_ID IN NUMBER,
252 I_ITEM_ID IN NUMBER,
253 O_Err_Num OUT NOCOPY NUMBER,
254 O_Err_Code OUT NOCOPY VARCHAR2,
255 O_Err_Msg OUT NOCOPY VARCHAR2
256 );
257
258
259
260 -- PROCEDURE
261 -- calc_pwac_cost
262 --
263 procedure calc_pwac_cost(
264 I_PAC_PERIOD_ID IN NUMBER,
265 I_COST_GROUP_ID IN NUMBER,
266 I_COST_TYPE_ID IN NUMBER,
267 I_TXN_ID IN NUMBER,
268 I_COST_LAYER_ID IN NUMBER,
269 I_QTY_LAYER_ID IN NUMBER,
270 I_ITEM_ID IN NUMBER,
271 I_TXN_QTY IN NUMBER,
272 I_ISSUE_QTY IN NUMBER,
273 I_BUY_QTY IN NUMBER,
274 I_MAKE_QTY IN NUMBER,
275 I_USER_ID IN NUMBER,
276 I_LOGIN_ID IN NUMBER,
277 I_REQ_ID IN NUMBER,
278 I_PRG_APPL_ID IN NUMBER,
279 I_PRG_ID IN NUMBER,
280 I_TXN_CATEGORY IN NUMBER,
281 O_Err_Num OUT NOCOPY NUMBER,
282 O_Err_Code OUT NOCOPY VARCHAR2,
283 O_Err_Msg OUT NOCOPY VARCHAR2
284 );
285
286 PROCEDURE periodic_cost_update (
287 I_PAC_PERIOD_ID IN NUMBER,
288 I_COST_GROUP_ID IN NUMBER,
289 I_COST_TYPE_ID IN NUMBER,
290 I_TXN_ID IN NUMBER,
291 I_COST_LAYER_ID IN NUMBER,
292 I_QTY_LAYER_ID IN NUMBER,
293 I_ITEM_ID IN NUMBER,
294 I_USER_ID IN NUMBER,
295 I_LOGIN_ID IN NUMBER,
296 I_REQ_ID IN NUMBER,
297 I_PRG_APPL_ID IN NUMBER,
298 I_PRG_ID IN NUMBER,
299 I_TXN_CATEGORY IN NUMBER,
300 I_TXN_QTY IN NUMBER,
301 O_Err_Num OUT NOCOPY NUMBER,
302 O_Err_Code OUT NOCOPY VARCHAR2,
303 O_Err_Msg OUT NOCOPY VARCHAR2
304 );
305
306 /*
307 PROCEDURE insert_txn_history (
308 I_PAC_PERIOD_ID IN NUMBER,
309 I_COST_GROUP_ID IN NUMBER,
310 I_TXN_ID IN NUMBER,
311 I_PROCESS_GROUP IN NUMBER,
312 I_ITEM_ID IN NUMBER,
313 I_QTY_LAYER_ID IN NUMBER,
314 I_TXN_QTY IN NUMBER,
315 I_USER_ID IN NUMBER,
316 I_LOGIN_ID IN NUMBER,
317 I_REQ_ID IN NUMBER,
318 I_PRG_APPL_ID IN NUMBER,
319 I_PRG_ID IN NUMBER,
320 I_TXN_CATEGORY IN NUMBER,
321 O_Err_Num OUT NOCOPY NUMBER,
322 O_Err_Code OUT NOCOPY VARCHAR2,
323 O_Err_Msg OUT NOCOPY VARCHAR2
324 );
325 */
326
327 /*
328 PROCEDURE update_txn_history (
329 I_PAC_PERIOD_ID IN NUMBER,
330 I_COST_GROUP_ID IN NUMBER,
331 I_TXN_ID IN NUMBER,
332 I_USER_ID IN NUMBER,
333 I_LOGIN_ID IN NUMBER,
334 I_REQ_ID IN NUMBER,
335 I_PRG_APPL_ID IN NUMBER,
336 I_PRG_ID IN NUMBER,
337 O_Err_Num OUT NOCOPY NUMBER,
338 O_Err_Code OUT NOCOPY VARCHAR2,
339 O_Err_Msg OUT NOCOPY VARCHAR2
340 );
341 */
342
343 PROCEDURE calculate_periodic_cost
344 (i_pac_period_id IN NUMBER,
345 i_cost_group_id IN NUMBER,
346 i_cost_type_id IN NUMBER,
347 i_low_level_code IN NUMBER,
348 i_item_id IN NUMBER,
349 i_user_id IN NUMBER,
350 i_login_id IN NUMBER,
351 i_request_id IN NUMBER,
352 i_prog_id IN NUMBER,
353 i_prog_appl_id IN NUMBER,
354 o_err_num OUT NOCOPY NUMBER,
355 o_err_code OUT NOCOPY VARCHAR2,
356 o_err_msg OUT NOCOPY VARCHAR2);
357
358 PROCEDURE insert_into_cppb
359 (i_pac_period_id IN NUMBER,
360 i_cost_group_id IN NUMBER,
361 i_txn_category IN NUMBER,
362 i_user_id IN NUMBER,
363 i_login_id IN NUMBER,
364 i_request_id IN NUMBER,
365 i_prog_id IN NUMBER,
366 i_prog_appl_id IN NUMBER,
367 o_err_num OUT NOCOPY NUMBER,
368 o_err_code OUT NOCOPY VARCHAR2,
369 o_err_msg OUT NOCOPY VARCHAR2);
370
371 PROCEDURE update_cppb
372 (i_pac_period_id IN NUMBER,
373 i_cost_group_id IN NUMBER,
374 i_txn_category IN NUMBER,
375 i_low_level_code IN NUMBER,
376 i_user_id IN NUMBER,
377 i_login_id IN NUMBER,
378 i_request_id IN NUMBER,
379 i_prog_id IN NUMBER,
380 i_prog_appl_id IN NUMBER,
381 o_err_num OUT NOCOPY NUMBER,
382 o_err_code OUT NOCOPY VARCHAR2,
383 o_err_msg OUT NOCOPY VARCHAR2);
384
385 PROCEDURE update_item_cppb
386 (i_pac_period_id IN NUMBER,
387 i_cost_group_id IN NUMBER,
388 i_txn_category IN NUMBER,
389 i_item_id IN NUMBER,
390 i_user_id IN NUMBER,
391 i_login_id IN NUMBER,
392 i_request_id IN NUMBER,
393 i_prog_id IN NUMBER,
394 i_prog_appl_id IN NUMBER,
395 o_err_num OUT NOCOPY NUMBER,
396 o_err_code OUT NOCOPY VARCHAR2,
397 o_err_msg OUT NOCOPY VARCHAR2);
398
399 PROCEDURE insert_ending_balance
400 (i_pac_period_id IN NUMBER,
401 i_cost_group_id IN NUMBER,
402 i_user_id IN NUMBER,
403 i_login_id IN NUMBER,
404 i_request_id IN NUMBER,
405 i_prog_id IN NUMBER,
406 i_prog_appl_id IN NUMBER,
407 o_err_num OUT NOCOPY NUMBER,
408 o_err_code OUT NOCOPY VARCHAR2,
409 o_err_msg OUT NOCOPY VARCHAR2);
410
411 END CSTPPWAC;