1 PACKAGE CSTPACDP AS
2 /* $Header: CSTACDPS.pls 120.2.12010000.4 2009/01/24 03:22:04 ipineda ship $ */
3
4 TYPE number_table IS TABLE OF NUMBER
5 INDEX BY BINARY_INTEGER;
6
7 -- PROCEDURE
8 -- cost_txn This processor writes cost distributions.
9 --
10 -- INPUT PARAMETERS
11 -- I_ORG_ID Organization id of associated with the actual
12 -- cost worker.
13 -- I_TXN_ID The transaction to be processed.
14 -- I_FOB_POINT
15 -- I_EXP_ITEM
16 -- I_USER_ID
17 -- I_LOGIN_ID
18 -- I_REQ_ID
19 -- I_PRG_APPL_ID
20 -- I_PRG_ID
21 -- O_Error_Num
22 -- O_Error_Code
23 -- O_Error_Message
24 --
25 --
26 procedure cost_txn(
27 I_ORG_ID IN NUMBER,
28 I_TXN_ID IN NUMBER,
29 I_LAYER_ID IN NUMBER,
30 I_FOB_POINT IN NUMBER,
31 I_EXP_ITEM IN NUMBER,
32 I_COMM_ISS_FLAG IN NUMBER,
33 I_FLOW_SCHEDULE IN NUMBER,
34 I_USER_ID IN NUMBER,
35 I_LOGIN_ID IN NUMBER,
36 I_REQ_ID IN NUMBER,
37 I_PRG_APPL_ID IN NUMBER,
38 I_PRG_ID IN NUMBER,
39 I_TPRICE_OPTION IN NUMBER,
40 I_TXF_PRICE IN NUMBER,
41 O_Error_Num OUT NOCOPY NUMBER,
42 O_Error_Code OUT NOCOPY VARCHAR2,
43 O_Error_Message OUT NOCOPY VARCHAR2
44 );
45
46 procedure comm_iss_to_wip(
47 I_TXN_ID IN NUMBER,
48 I_COMM_ISS_FLAG IN NUMBER,
49 I_FLOW_SCHEDULE IN NUMBER,
50 I_ORG_ID IN NUMBER,
51 I_ITEM_ID IN NUMBER,
52 I_COST_GRP_ID IN NUMBER,
53 I_TXFR_COST_GRP IN NUMBER,
54 I_TXN_DATE IN DATE,
55 I_P_QTY IN NUMBER,
56 I_SUBINV IN VARCHAR2,
57 I_SOB_ID IN NUMBER,
58 I_PRI_CURR IN VARCHAR2,
59 I_ALT_CURR IN VARCHAR2,
60 I_CONV_DATE IN DATE,
61 I_CONV_RATE IN NUMBER,
62 I_CONV_TYPE IN VARCHAR2,
63 I_EXP_ITEM IN NUMBER,
64 I_TXF_SUBINV IN VARCHAR2,
65 I_TXN_ACT_ID IN NUMBER,
66 I_TXN_SRC_ID IN NUMBER,
67 I_SRC_TYPE_ID IN NUMBER,
68 I_USER_ID IN NUMBER,
69 I_LOGIN_ID IN NUMBER,
70 I_REQ_ID IN NUMBER,
71 I_PRG_APPL_ID IN NUMBER,
72 I_PRG_ID IN NUMBER,
73 O_Error_Num OUT NOCOPY NUMBER,
74 O_Error_Code OUT NOCOPY VARCHAR2,
75 O_Error_Message OUT NOCOPY VARCHAR2
76 );
77
78 -- PROCEDURE
79 -- wip_cost_txn This processor writes wip related
80 -- cost distributions.
81 --
82 -- INPUT PARAMETERS
83 -- I_ORG_ID Organization id of associated with the actual
84 -- cost worker.
85 -- I_TXN_ID The transaction to be processed.
86 -- I_ITEM_ID
87 -- I_TXN_DATE
88 -- I_P_QTY Tramnsaction quantity.
89 -- I_SUBINV
90 -- I_TXN_ACT_ID
91 -- I_TXN_SRC_ID
92 -- I_SRC_TYPE_ID
93 -- I_DIST_ACCT
94 -- I_SOB_ID The set of books id.
95 -- I_PRI_CURR The primary currency.
96 -- I_EXP_ITEM
97 -- I_USER_ID
98 -- I_LOGIN_ID
99 -- I_REQ_ID
100 -- I_PRG_APPL_ID
101 -- I_PRG_ID
102 -- O_Error_Num
103 -- O_Error_Code
104 -- O_Error_Message
105 --
106 --
107 procedure wip_cost_txn(
108 I_ORG_ID IN NUMBER,
109 I_TXN_ID IN NUMBER,
110 I_COST_GRP_ID IN NUMBER,
111 I_ITEM_ID IN NUMBER,
112 I_TXN_DATE IN DATE,
113 I_P_QTY IN NUMBER,
114 I_SUBINV IN VARCHAR2,
115 I_TXN_ACT_ID IN NUMBER,
116 I_TXN_SRC_ID IN NUMBER,
117 I_SRC_TYPE_ID IN NUMBER,
118 I_DIST_ACCT IN NUMBER,
119 I_SOB_ID IN NUMBER,
120 I_PRI_CURR IN VARCHAR2,
121 I_EXP_ITEM IN NUMBER,
122 I_FLOW_SCHEDULE IN NUMBER,
123 I_USER_ID IN NUMBER,
124 I_LOGIN_ID IN NUMBER,
125 I_REQ_ID IN NUMBER,
126 I_PRG_APPL_ID IN NUMBER,
127 I_PRG_ID IN NUMBER,
128 O_Error_Num OUT NOCOPY NUMBER,
129 O_Error_Code OUT NOCOPY VARCHAR2,
130 O_Error_Message OUT NOCOPY VARCHAR2
131 );
132
133
134 -- PROCEDURE
135 -- sub_cost_txn This processor writes subinventory transfer
136 -- cost distributions.
137 --
138 -- INPUT PARAMETERS
139 -- I_ORG_ID Organization id of associated with the actual
140 -- cost worker.
141 -- I_TXN_ID The transaction to be processed.
142 -- I_ITEM_ID
143 -- I_TXN_DATE
144 -- I_P_QTY Transaction quantity.
145 -- I_SUBINV
146 -- I_TXF_TXN_ID
147 -- I_TXN_ACT_ID
148 -- I_TXN_SRC_ID
149 -- I_SRC_TYPE_ID
150 -- I_SOB_ID The set of books id.
151 -- I_PRI_CURR The primary currency.
152 -- I_ALT_CURR The currency used on the trasaction.
153 -- I_CONV_DATE
154 -- I_CONV_RATE
155 -- I_CONV_TYPE
156 -- I_EXP_ITEM
157 -- I_USER_ID
158 -- I_LOGIN_ID
159 -- I_REQ_ID
160 -- I_PRG_APPL_ID
161 -- I_PRG_ID
162 -- O_Error_Num
163 -- O_Error_Code
164 -- O_Error_Message
165 --
166 --
167 procedure sub_cost_txn(
168 I_ORG_ID IN NUMBER,
169 I_TXN_ID IN NUMBER,
170 I_COST_GRP_ID IN NUMBER,
171 I_TXFR_COST_GRP IN NUMBER,
172 I_ITEM_ID IN NUMBER,
173 I_TXN_DATE IN DATE,
174 I_P_QTY IN NUMBER,
175 I_SUBINV IN VARCHAR2,
176 I_TXF_SUBINV IN VARCHAR2,
177 I_TXF_TXN_ID IN NUMBER,
178 I_TXN_ACT_ID IN NUMBER,
179 I_TXN_SRC_ID IN NUMBER,
180 I_SRC_TYPE_ID IN NUMBER,
181 I_SOB_ID IN NUMBER,
182 I_PRI_CURR IN VARCHAR2,
183 I_ALT_CURR IN VARCHAR2,
184 I_CONV_DATE IN DATE,
185 I_CONV_RATE IN NUMBER,
186 I_CONV_TYPE IN VARCHAR2,
187 I_EXP_ITEM IN NUMBER,
188 I_USER_ID IN NUMBER,
189 I_LOGIN_ID IN NUMBER,
190 I_REQ_ID IN NUMBER,
191 I_PRG_APPL_ID IN NUMBER,
192 I_PRG_ID IN NUMBER,
193 O_Error_Num OUT NOCOPY NUMBER,
194 O_Error_Code OUT NOCOPY VARCHAR2,
195 O_Error_Message OUT NOCOPY VARCHAR2
196 );
197
198 -- PROCEDURE
199 -- inv_cost_txn This processor processes distributions
200 -- for inventory related transactions.
201 --
202 -- INPUT PARAMETERS
203 -- I_ORG_ID Organization id of associated with the actual
204 -- cost worker.
205 -- I_TXN_ID The transaction to be processed.
206 -- I_ITEM_ID
207 -- I_TXN_DATE
208 -- I_P_QTY Transaction quantity.
209 -- I_SUBINV
210 -- I_TXN_ACT_ID
211 -- I_TXN_SRC_ID
212 -- I_SRC_TYPE_ID
213 -- I_DIST_ACCT
214 -- I_SOB_ID The set of books id.
215 -- I_PRI_CURR The primary currency.
216 -- I_ALT_CURR The currency used on the trasaction.
217 -- I_CONV_DATE
218 -- I_CONV_RATE
219 -- I_CONV_TYPE
220 -- I_SO_ACCOUNTING Added for Revenue / COGS Matching: 1=COGS, 2=Def COGS
221 -- I_COGS_PERCENTAGE Added for Revenue / COGS Matching
222 -- I_COGS_OM_LINE_ID Added for Revenue / COGS Matching
223 -- I_EXP_ITEM
224 -- I_USER_ID
225 -- I_LOGIN_ID
226 -- I_REQ_ID
227 -- I_PRG_APPL_ID
228 -- I_PRG_ID
229 -- O_Error_Num
230 -- O_Error_Code
231 -- O_Error_Message
232 --
233 --
234 procedure inv_cost_txn(
235 I_ORG_ID IN NUMBER,
236 I_TXN_ID IN NUMBER,
237 I_COST_GRP_ID IN NUMBER,
238 I_ITEM_ID IN NUMBER,
239 I_TXN_DATE IN DATE,
240 I_P_QTY IN NUMBER,
241 I_SUBINV IN VARCHAR2,
242 I_TXN_ACT_ID IN NUMBER,
243 I_TXN_SRC_ID IN NUMBER,
244 I_SRC_TYPE_ID IN NUMBER,
245 I_DIST_ACCT IN NUMBER,
246 I_SOB_ID IN NUMBER,
247 I_PRI_CURR IN VARCHAR2,
248 I_ALT_CURR IN VARCHAR2,
249 I_CONV_DATE IN DATE,
250 I_CONV_RATE IN NUMBER,
251 I_CONV_TYPE IN VARCHAR2,
252 I_SO_ACCOUNTING IN NUMBER,
253 I_COGS_PERCENTAGE IN NUMBER,
254 I_COGS_OM_LINE_ID IN NUMBER,
255 I_EXP_ITEM IN NUMBER,
256 I_USER_ID IN NUMBER,
257 I_LOGIN_ID IN NUMBER,
258 I_REQ_ID IN NUMBER,
259 I_PRG_APPL_ID IN NUMBER,
260 I_PRG_ID IN NUMBER,
261 O_Error_Num OUT NOCOPY NUMBER,
262 O_Error_Code OUT NOCOPY VARCHAR2,
263 O_Error_Message OUT NOCOPY VARCHAR2
264 );
265
266 -- PROCEDURE
267 -- interorg_cost_txn This processor processes distributions
268 -- for interorg transactions.
269 --
270 -- INPUT PARAMETERS
271 -- I_ORG_ID Organization id of associated with the actual
272 -- cost worker.
273 -- I_TXN_ID The transaction to be processed.
274 -- I_ITEM_ID
275 -- I_TXN_DATE
276 -- I_P_QTY Transaction quantity.
277 -- I_SUBINV
278 -- I_TXN_ORG_ID Org id associated with this transaction.
279 -- I_TXF_ORG_ID The transfer org id.
280 -- I_TXF_COST
281 -- I_TRP_COST
282 -- I_TXN_ACT_ID
283 -- I_TXN_SRC_ID
284 -- I_SRC_TYPE_ID
285 -- I_EXP_ITEM
286 -- I_USER_ID
287 -- I_LOGIN_ID
288 -- I_REQ_ID
289 -- I_PRG_APPL_ID
290 -- I_PRG_ID
291 -- O_Error_Num
292 -- O_Error_Code
293 -- O_Error_Message
294 --
295 --
296 -- OPM INVCONV umoogala Process-Discrete Xfer Enh.
297 -- Added new parameter for transfer price
298 procedure interorg_cost_txn(
299 I_ORG_ID IN NUMBER,
300 I_TXN_ID IN NUMBER,
301 I_COST_GRP_ID IN NUMBER,
302 I_TXFR_COST_GRP IN NUMBER,
303 I_ITEM_ID IN NUMBER,
304 I_TXN_DATE IN DATE,
305 I_TXN_QTY IN NUMBER,
306 I_SUBINV IN VARCHAR2,
307 I_TXN_ORG_ID IN NUMBER,
308 I_TXF_ORG_ID IN NUMBER,
309 I_TXF_TXN_ID IN NUMBER,
310 I_TXF_COST IN NUMBER,
311 I_TRP_COST IN NUMBER,
312 I_TRP_ACCT IN NUMBER,
313 I_TXN_ACT_ID IN NUMBER,
314 I_TXN_SRC_ID IN NUMBER,
315 I_SRC_TYPE_ID IN NUMBER,
316 I_FOB_POINT IN NUMBER,
317 I_EXP_ITEM IN NUMBER,
318 I_TXF_PRICE IN NUMBER, -- OPM INVCONV umoogala
319 I_USER_ID IN NUMBER,
320 I_LOGIN_ID IN NUMBER,
321 I_REQ_ID IN NUMBER,
322 I_PRG_APPL_ID IN NUMBER,
323 I_PRG_ID IN NUMBER,
324 O_Error_Num OUT NOCOPY NUMBER,
325 O_Error_Code OUT NOCOPY VARCHAR2,
326 O_Error_Message OUT NOCOPY VARCHAR2
327 );
328
329
330 -- PROCEDURE
331 -- avcu_cost_txn This processor processes distributions
332 -- for average cost update transactions.
333 --
334 -- INPUT PARAMETERS
335 -- I_ORG_ID Organization id of associated with the actual
336 -- cost worker.
337 -- I_TXN_ID The transaction to be processed.
338 -- I_ITEM_ID
339 -- I_TXN_DATE
340 -- I_QTY Quantity adjusted.
341 -- I_TXN_ACT_ID
342 -- I_TXN_SRC_ID
343 -- I_SRC_TYPE_ID
344 -- I_MAT_ACCT
345 -- I_MAT_OVHD_ACCT
346 -- I_RES_ACCT
347 -- I_OSP_ACCT
348 -- I_OVHD_ACCT
349 -- I_SOB_ID The set of books id.
350 -- I_PRI_CURR The primary currency.
351 -- I_ALT_CURR The currency used on the trasaction.
352 -- I_CONV_DATE
353 -- I_CONV_RATE
354 -- I_CONV_TYPE
355 -- I_EXP_ITEM
356 -- I_USER_ID
357 -- I_LOGIN_ID
358 -- I_REQ_ID
359 -- I_PRG_APPL_ID
360 -- I_PRG_ID
361 -- O_Error_Num
362 -- O_Error_Code
363 -- O_Error_Message
364 --
365 --
366 procedure avcu_cost_txn(
367 I_ORG_ID IN NUMBER,
368 I_TXN_ID IN NUMBER,
369 I_COST_GRP_ID IN NUMBER,
370 I_ITEM_ID IN NUMBER,
371 I_TXN_DATE IN DATE,
372 I_QTY IN NUMBER,
373 I_TXN_ACT_ID IN NUMBER,
374 I_TXN_SRC_ID IN NUMBER,
375 I_SRC_TYPE_ID IN NUMBER,
376 I_MAT_ACCT IN NUMBER,
377 I_MAT_OVHD_ACCT IN NUMBER,
378 I_RES_ACCT IN NUMBER,
379 I_OSP_ACCT IN NUMBER,
380 I_OVHD_ACCT IN NUMBER,
381 I_SOB_ID IN NUMBER,
382 I_PRI_CURR IN VARCHAR2,
383 I_ALT_CURR IN VARCHAR2,
384 I_CONV_DATE IN DATE,
385 I_CONV_RATE IN NUMBER,
386 I_CONV_TYPE IN VARCHAR2,
387 I_EXP_ITEM IN NUMBER,
388 I_ONHAND_VAR_ACCT IN NUMBER,
389 I_USER_ID IN NUMBER,
390 I_LOGIN_ID IN NUMBER,
391 I_REQ_ID IN NUMBER,
392 I_PRG_APPL_ID IN NUMBER,
393 I_PRG_ID IN NUMBER,
394 O_Error_Num OUT NOCOPY NUMBER,
395 O_Error_Code OUT NOCOPY VARCHAR2,
396 O_Error_Message OUT NOCOPY VARCHAR2
397 );
398
399 -- PROCEDURE
400 -- inventory_accounts Inserts inventory debits/credits
401 -- to mtl_transaction_accounts.
402 --
403 -- INPUT PARAMETERS
404 -- I_ORG_ID Organization id of associated with the actual
405 -- cost worker.
406 -- I_TXN_ID The transaction to be processed.
407 -- I_ITEM_ID
408 -- I_P_QTY Quantity from the prespective of inventory.
409 -- I_SOB_ID The set of books id.
410 -- I_TXN_DATE
411 -- I_TXN_SRC_ID
412 -- I_SRC_TYPE_ID
413 -- I_EXP_ITEM
414 -- I_EXP_SUBINV 1 if the subinventory involved here is an
415 -- expense sub. 0 otherwise.
416 -- I_EXP_ACCT expense account.
417 -- I_SUBINV
418 -- I_INTRANSIT In average costing the intransit accounts
419 -- are the same as the inventory valuation
420 -- account. Adding this flag only makes
421 -- it easier later if we do decide to use
422 -- different code.
423 -- I_SND_RCV For interorg transactions, determines the
424 -- sending or receiving org.
425 -- I_PRI_CURR The primary currency.
426 -- I_ALT_CURR The currency used on the trasaction.
427 -- I_CONV_DATE
428 -- I_CONV_RATE
429 -- I_CONV_TYPE
430 -- I_USER_ID
431 -- I_LOGIN_ID
432 -- I_REQ_ID
433 -- I_PRG_APPL_ID
434 -- I_PRG_ID
435 -- O_Error_Num
436 -- O_Error_Code
437 -- O_Error_Message
438 --
439 --
440 procedure inventory_accounts(
441 I_ORG_ID IN NUMBER,
442 I_TXN_ID IN NUMBER,
443 I_COMM_ISS_FLAG IN NUMBER,
444 I_COST_TXN_ACTION_ID IN NUMBER,
445 I_COST_GRP_ID IN NUMBER,
446 I_ITEM_ID IN NUMBER,
447 I_P_QTY IN NUMBER,
448 I_SOB_ID IN NUMBER,
449 I_TXN_DATE IN DATE,
450 I_TXN_SRC_ID IN NUMBER,
451 I_SRC_TYPE_ID IN NUMBER,
452 I_EXP_ITEM IN NUMBER,
453 I_EXP_SUBINV IN NUMBER,
454 I_EXP_ACCT IN NUMBER,
455 I_SUBINV IN VARCHAR2,
456 I_INTRANSIT IN NUMBER,
457 I_SND_RCV IN NUMBER,
458 I_PRI_CURR IN VARCHAR2,
459 I_ALT_CURR IN VARCHAR2,
460 I_CONV_DATE IN DATE,
461 I_CONV_RATE IN NUMBER,
462 I_CONV_TYPE IN VARCHAR2,
463 I_USER_ID IN NUMBER,
464 I_LOGIN_ID IN NUMBER,
465 I_REQ_ID IN NUMBER,
466 I_PRG_APPL_ID IN NUMBER,
467 I_PRG_ID IN NUMBER,
468 O_Error_Num OUT NOCOPY NUMBER,
469 O_Error_Code OUT NOCOPY VARCHAR2,
470 O_Error_Message OUT NOCOPY VARCHAR2
471 );
472
473 -- PROCEDURE
474 -- distribute_accounts Insert elemental or one row in mtl
475 -- transaction_accounts using the costs
476 -- in mtl_cst_actual_cost_details.
477 --
478 -- INPUT PARAMETERS
479 -- I_ORG_ID Organization id of associated with the actual
480 -- cost worker.
481 -- I_TXN_ID The transaction to be processed.
482 -- I_ITEM_ID
483 -- I_P_QTY Quantity from the perspective of the account
484 -- we are posting to.
485 -- I_ACCT_LINE_TYPE
486 -- I_ELEMENTAL 1 - post elementally
487 -- 0 - post as 1 lump sum
488 -- I_OVHD_ABSP 1 - materail overhead is absorbed on this
489 -- transaction. So exclude this level material
490 -- overhead costs.
491 -- 2 - Exclude both this and previous level
492 -- material costs.
493 -- I_ACCT
494 -- I_MAT_ACCT
495 -- I_MAT_OVHD_ACCT
496 -- I_RES_ACCT
497 -- I_OSP_ACCT
498 -- I_OVHD_ACCT
499 -- I_SOB_ID The set of books id.
500 -- I_TXN_DATE
501 -- I_TXN_SRC_ID
505 -- sending or receiving org.
502 -- I_SRC_TYPE_ID
503 -- I_SUBINV
504 -- I_SND_RCV For interorg transactions, determines the
506 -- I_PRI_CURR The primary currency.
507 -- I_ALT_CURR The currency used on the trasaction.
508 -- I_CONV_DATE
509 -- I_CONV_RATE
510 -- I_CONV_TYPE
511 -- I_USER_ID
512 -- I_LOGIN_ID
513 -- I_REQ_ID
514 -- I_PRG_APPL_ID
515 -- I_PRG_ID
516 -- O_Error_Num
517 -- O_Error_Code
518 -- O_Error_Message
519 -- I_COGS_OM_LINE_ID Added for Revenue / COGS Matching
520 --
521 --
522 procedure distribute_accounts(
523 I_ORG_ID IN NUMBER,
524 I_TXN_ID IN NUMBER,
525 I_COMM_ISS_FLAG IN NUMBER,
526 I_COST_GRP_ID IN NUMBER,
527 I_COST_TXN_ACTION_ID IN NUMBER,
528 I_ITEM_ID IN NUMBER,
529 I_P_QTY IN NUMBER,
530 I_ACCT_LINE_TYPE IN NUMBER,
531 I_ELEMENTAL IN NUMBER,
532 I_OVHD_ABSP IN NUMBER,
533 I_ACCT IN NUMBER,
534 I_MAT_ACCT IN NUMBER,
535 I_MAT_OVHD_ACCT IN NUMBER,
536 I_RES_ACCT IN NUMBER,
537 I_OSP_ACCT IN NUMBER,
538 I_OVHD_ACCT IN NUMBER,
539 I_SOB_ID IN NUMBER,
540 I_TXN_DATE IN DATE,
541 I_TXN_SRC_ID IN NUMBER,
542 I_SRC_TYPE_ID IN NUMBER,
543 I_SUBINV IN VARCHAR2,
544 I_SND_RCV IN NUMBER,
545 I_PRI_CURR IN VARCHAR2,
546 I_ALT_CURR IN VARCHAR2,
547 I_CONV_DATE IN DATE,
548 I_CONV_RATE IN NUMBER,
549 I_CONV_TYPE IN VARCHAR2,
550 I_USER_ID IN NUMBER,
551 I_LOGIN_ID IN NUMBER,
552 I_REQ_ID IN NUMBER,
553 I_PRG_APPL_ID IN NUMBER,
554 I_PRG_ID IN NUMBER,
555 O_Error_Num OUT NOCOPY NUMBER,
556 O_Error_Code OUT NOCOPY VARCHAR2,
557 O_Error_Message OUT NOCOPY VARCHAR2,
558 I_COGS_OM_LINE_ID IN NUMBER := 0
559 );
560
561 -- PROCEDURE
562 -- cfm_scrap_dist_accounts Insert elemental or one row in mtl
563 -- transaction_accounts using the costs
564 -- in mtl_cst_actual_cost_details.
565 --
566 -- INPUT PARAMETERS
567 -- I_ORG_ID Organization id of associated with the actual
568 -- cost worker.
569 -- I_TXN_ID The transaction to be processed.
570 -- I_ITEM_ID
571 -- I_P_QTY Quantity from the perspective of the account
572 -- we are posting to.
573 -- I_ACCT_LINE_TYPE
574 -- I_ELEMENTAL Don't use 1 - post elementally
575 -- 0 - post as 1 lump sum
576 -- I_OVHD_ABSP Don't use 1 - materail overhead is absorbed on this
577 -- transaction. So exclude this level material
578 -- overhead costs.
579 -- 2 - Exclude both this and previous level
580 -- material costs.
581 -- I_ACCT
582 -- I_MAT_ACCT
583 -- I_MAT_OVHD_ACCT
584 -- I_RES_ACCT
585 -- I_OSP_ACCT
586 -- I_OVHD_ACCT
587 -- I_SOB_ID The set of books id.
588 -- I_TXN_DATE
589 -- I_TXN_SRC_ID
590 -- I_SRC_TYPE_ID
591 -- I_SUBINV
592 -- I_SND_RCV For interorg transactions, determines the
593 -- sending or receiving org.
594 -- I_PRI_CURR The primary currency.
595 -- I_ALT_CURR The currency used on the trasaction.
596 -- I_CONV_DATE
597 -- I_CONV_RATE
598 -- I_CONV_TYPE
599 -- I_USER_ID
600 -- I_LOGIN_ID
601 -- I_REQ_ID
602 -- I_PRG_APPL_ID
603 -- I_PRG_ID
604 -- O_Error_Num
605 -- O_Error_Code
606 -- O_Error_Message
607 --
608 --
609 procedure cfm_scrap_dist_accounts(
610 I_ORG_ID IN NUMBER,
611 I_TXN_ID IN NUMBER,
612 I_COMM_ISS_FLAG IN NUMBER,
613 I_COST_GRP_ID IN NUMBER,
614 I_COST_TXN_ACTION_ID IN NUMBER,
615 I_ITEM_ID IN NUMBER,
616 I_P_QTY IN NUMBER,
617 I_ACCT_LINE_TYPE IN NUMBER,
618 I_ELEMENTAL IN NUMBER,
619 I_OVHD_ABSP IN NUMBER,
620 I_ACCT IN NUMBER,
621 I_MAT_ACCT IN NUMBER,
622 I_MAT_OVHD_ACCT IN NUMBER,
623 I_RES_ACCT IN NUMBER,
624 I_OSP_ACCT IN NUMBER,
625 I_OVHD_ACCT IN NUMBER,
626 I_SOB_ID IN NUMBER,
627 I_TXN_DATE IN DATE,
628 I_TXN_SRC_ID IN NUMBER,
629 I_SRC_TYPE_ID IN NUMBER,
630 I_SUBINV IN VARCHAR2,
631 I_SND_RCV IN NUMBER,
632 I_PRI_CURR IN VARCHAR2,
633 I_ALT_CURR IN VARCHAR2,
634 I_CONV_DATE IN DATE,
635 I_CONV_RATE IN NUMBER,
636 I_CONV_TYPE IN VARCHAR2,
637 I_USER_ID IN NUMBER,
638 I_LOGIN_ID IN NUMBER,
639 I_REQ_ID IN NUMBER,
640 I_PRG_APPL_ID IN NUMBER,
641 I_PRG_ID IN NUMBER,
642 O_Error_Num OUT NOCOPY NUMBER,
643 O_Error_Code OUT NOCOPY VARCHAR2,
644 O_Error_Message OUT NOCOPY VARCHAR2
645 );
646
647 -- PROCEDURE
648 -- ovhd_accounts Do distribution for material overhead
649 -- absorption.
650 --
651 -- INPUT PARAMETERS
652 -- I_ORG_ID Organization id of associated with the actual
653 -- cost worker.
654 -- I_TXN_ID The transaction to be processed.
655 -- I_ITEM_ID
656 -- I_P_QTY Quantity from the perspective of the material
657 -- overhead subelement account.
658 -- I_SOB_ID The set of books id.
659 -- I_TXN_DATE
660 -- I_TXN_SRC_ID
661 -- I_SRC_TYPE_ID
662 -- I_SUBINV
666 -- I_ALT_CURR The currency used on the trasaction.
663 -- I_SND_RCV For interorg transactions, determines the
664 -- sending or receiving org.
665 -- I_PRI_CURR The primary currency.
667 -- I_CONV_DATE
668 -- I_CONV_RATE
669 -- I_CONV_TYPE
670 -- I_USER_ID
671 -- I_LOGIN_ID
672 -- I_REQ_ID
673 -- I_PRG_APPL_ID
674 -- I_PRG_ID
675 -- O_Error_Num
676 -- O_Error_Code
677 -- O_Error_Message
678 --
679 --
680 procedure ovhd_accounts(
681 I_ORG_ID IN NUMBER,
682 I_TXN_ID IN NUMBER,
683 I_ITEM_ID IN NUMBER,
684 I_P_QTY IN NUMBER,
685 I_SOB_ID IN NUMBER,
686 I_TXN_DATE IN DATE,
687 I_TXN_SRC_ID IN NUMBER,
688 I_SRC_TYPE_ID IN NUMBER,
689 I_SUBINV IN VARCHAR2,
690 I_SND_RCV IN NUMBER,
691 I_PRI_CURR IN VARCHAR2,
692 I_ALT_CURR IN VARCHAR2,
693 I_CONV_DATE IN DATE,
694 I_CONV_RATE IN NUMBER,
695 I_CONV_TYPE IN VARCHAR2,
696 I_USER_ID IN NUMBER,
697 I_LOGIN_ID IN NUMBER,
698 I_REQ_ID IN NUMBER,
699 I_PRG_APPL_ID IN NUMBER,
700 I_PRG_ID IN NUMBER,
701 O_Error_Num OUT NOCOPY NUMBER,
702 O_Error_Code OUT NOCOPY VARCHAR2,
703 O_Error_Message OUT NOCOPY VARCHAR2
704 );
705
706 -- PROCEDURE
707 -- encumbrance_account Do distribution for encumbrance amount
708 --
709 --
710 procedure encumbrance_account(
711 I_ORG_ID IN NUMBER,
712 I_TXN_ID IN NUMBER,
713 I_ITEM_ID IN NUMBER,
714 I_ENC_AMOUNT IN NUMBER,
715 I_P_QTY IN NUMBER,
716 I_ENC_ACCT IN NUMBER,
717 I_SOB_ID IN NUMBER,
718 I_TXN_DATE IN DATE,
719 I_TXN_SRC_ID IN NUMBER,
720 I_SRC_TYPE_ID IN NUMBER,
721 I_PRI_CURR IN VARCHAR2,
722 I_ALT_CURR IN VARCHAR2,
723 I_CONV_DATE IN DATE,
724 I_CONV_RATE IN NUMBER,
725 I_CONV_TYPE IN VARCHAR2,
726 I_USER_ID IN NUMBER,
727 I_LOGIN_ID IN NUMBER,
728 I_REQ_ID IN NUMBER,
729 I_PRG_APPL_ID IN NUMBER,
730 I_PRG_ID IN NUMBER,
731 O_Error_Num OUT NOCOPY NUMBER,
732 O_Error_Code OUT NOCOPY VARCHAR2,
733 O_Error_Message OUT NOCOPY VARCHAR2
734 );
735
736 -- PROCEDURE
737 -- insert_account Inserts one row in mtl_transaction_accounts
738 -- for the specified account and value.
739 --
740 -- INPUT PARAMETERS
741 -- I_ORG_ID Organization id of associated with the actual
742 -- cost worker.
743 -- I_TXN_ID The transaction to be processed.
744 -- I_ITEM_ID
745 -- I_VALUE
746 -- I_QTY
747 -- I_SOB_ID The set of books id.
748 -- I_ACCT_LINE_TYPE
749 -- I_COST_ELEMENT_ID
750 -- I_RESOURCE_ID
751 -- I_TXN_DATE
752 -- I_TXN_SRC_ID
753 -- I_SRC_TYPE_ID
754 -- I_PRI_CURR The primary currency.
755 -- I_ALT_CURR The currency used on the trasaction.
756 -- I_CONV_DATE
757 -- I_CONV_RATE
758 -- I_CONV_TYPE
759 -- I_ACT_FLAG To indicate if encumbrance is used
760 -- I_USER_ID
761 -- I_LOGIN_ID
762 -- I_REQ_ID
763 -- I_PRG_APPL_ID
764 -- I_PRG_ID
765 -- O_Error_Num
766 -- O_Error_Code
767 -- O_Error_Message
768 --
769 --
770 PROCEDURE insert_account(
771 I_ORG_ID IN NUMBER,
772 I_TXN_ID IN NUMBER,
773 I_ITEM_ID IN NUMBER,
774 I_VALUE IN NUMBER,
775 I_QTY IN NUMBER,
776 I_ACCT IN NUMBER,
777 I_SOB_ID IN NUMBER,
778 I_ACCT_LINE_TYPE IN NUMBER,
779 I_COST_ELEMENT_ID IN NUMBER,
780 I_RESOURCE_ID IN NUMBER,
781 I_TXN_DATE IN DATE,
782 I_TXN_SRC_ID IN NUMBER,
783 I_SRC_TYPE_ID IN NUMBER,
784 I_PRI_CURR IN VARCHAR2,
785 I_ALT_CURR IN VARCHAR2,
786 I_CONV_DATE IN DATE,
787 I_CONV_RATE IN NUMBER,
788 I_CONV_TYPE IN VARCHAR2,
789 I_ACT_FLAG IN NUMBER,
790 I_USER_ID IN NUMBER,
791 I_LOGIN_ID IN NUMBER,
792 I_REQ_ID IN NUMBER,
793 I_PRG_APPL_ID IN NUMBER,
794 I_PRG_ID IN NUMBER,
795 O_Error_Num OUT NOCOPY NUMBER,
796 O_Error_Code OUT NOCOPY VARCHAR2,
797 O_Error_Message OUT NOCOPY VARCHAR2
798 );
799
800 -- PROCEDURE
801 -- insert_accounts Inserts one row in mtl_transaction_accounts
802 -- for the specified account and value.
803 --
804 -- INPUT PARAMETERS
805 -- I_ORG_ID Organization id of associated with the actual
806 -- cost worker.
807 -- I_TXN_ID
808 -- O_Error_Num
809 -- O_Error_Code
810 -- O_Error_Message
811 --
812 --
813 procedure balance_account(
814 I_ORG_ID IN NUMBER,
815 I_TXN_ID IN NUMBER,
816 O_Error_Num OUT NOCOPY NUMBER,
817 O_Error_Code OUT NOCOPY VARCHAR2,
818 O_Error_Message OUT NOCOPY VARCHAR2
819 );
820
821 -----------------------------------------------------------------------------
822 -- Start of comments --
823 -- --
824 -- PROCEDURE --
825 -- logical_cost_txn This procedure is added for the 11i10 dropshipment --
826 -- project. It is called only for logical transactions --
827 -- to create the distributions. It has the same set of --
828 -- parameters as inv_cost_txn. --
829 -- --
830 -- End of comments --
831 -----------------------------------------------------------------------------
832 procedure logical_cost_txn(
833 I_ORG_ID IN NUMBER,
834 I_TXN_ID IN NUMBER,
835 I_COST_GRP_ID IN NUMBER,
836 I_ITEM_ID IN NUMBER,
837 I_TXN_DATE IN DATE,
838 I_P_QTY IN NUMBER,
839 I_SUBINV IN VARCHAR2,
840 I_TXN_ACT_ID IN NUMBER,
841 I_TXN_SRC_ID IN NUMBER,
842 I_SRC_TYPE_ID IN NUMBER,
843 I_TXN_TYPE_ID IN NUMBER,
844 I_DIST_ACCT IN NUMBER,
845 I_SOB_ID IN NUMBER,
846 I_PRI_CURR IN VARCHAR2,
847 I_ALT_CURR IN VARCHAR2,
848 I_CONV_DATE IN DATE,
849 I_CONV_RATE IN NUMBER,
850 I_CONV_TYPE IN VARCHAR2,
851 I_SO_ACCOUNTING IN NUMBER,
852 I_COGS_PERCENTAGE IN NUMBER,
853 I_COGS_OM_LINE_ID IN NUMBER,
854 I_EXP_ITEM IN NUMBER,
855 I_USER_ID IN NUMBER,
856 I_LOGIN_ID IN NUMBER,
857 I_REQ_ID IN NUMBER,
858 I_PRG_APPL_ID IN NUMBER,
859 I_PRG_ID IN NUMBER,
860 O_Error_Num OUT NOCOPY NUMBER,
861 O_Error_Code OUT NOCOPY VARCHAR2,
862 O_Error_Message OUT NOCOPY VARCHAR2
863 );
864
865 -----------------------------------------------------------------------------
866 -- Start of comments --
867 -- --
868 -- PROCEDURE --
869 -- consigned_update_cost_txn This procedure is added for the 11i10 --
870 -- dropshipment project to cost the new consigned price update--
871 -- transaction for retropricing. It has the same set of --
872 -- input parameters as inv_cost_txn. --
873 -- --
874 -- End of comments --
875 -----------------------------------------------------------------------------
876 procedure consigned_update_cost_txn(
877 I_ORG_ID IN NUMBER,
878 I_TXN_ID IN NUMBER,
879 I_COST_GRP_ID IN NUMBER,
880 I_ITEM_ID IN NUMBER,
884 I_TXN_ACT_ID IN NUMBER,
881 I_TXN_DATE IN DATE,
882 I_P_QTY IN NUMBER,
883 I_SUBINV IN VARCHAR2,
885 I_TXN_SRC_ID IN NUMBER,
886 I_SRC_TYPE_ID IN NUMBER,
887 I_DIST_ACCT IN NUMBER,
888 I_SOB_ID IN NUMBER,
889 I_PRI_CURR IN VARCHAR2,
890 I_ALT_CURR IN VARCHAR2,
891 I_CONV_DATE IN DATE,
892 I_CONV_RATE IN NUMBER,
893 I_CONV_TYPE IN VARCHAR2,
894 I_EXP_ITEM IN NUMBER,
895 I_USER_ID IN NUMBER,
896 I_LOGIN_ID IN NUMBER,
897 I_REQ_ID IN NUMBER,
898 I_PRG_APPL_ID IN NUMBER,
899 I_PRG_ID IN NUMBER,
900 O_Error_Num OUT NOCOPY NUMBER,
901 O_Error_Code OUT NOCOPY VARCHAR2,
902 O_Error_Message OUT NOCOPY VARCHAR2
903 );
904
905 -----------------------------------------------------------------------------
906 -- Start of comments --
907 -- --
908 -- PROCEDURE --
909 -- inventory_accounts_std This procedure is very similar to the basic --
910 -- inventory_accounts() procedure. It was necessary to add it for --
911 -- the 11i10 dropshipment project because standard and average --
912 -- organizations both use the same cost processor for the logical --
913 -- transactions. Because there would have been substantial changes --
914 -- to inventory_accounts() to accommodate standard costing, it made --
915 -- more sense to just add this new procedure. --
916 -- --
917 -- End of comments --
918 -----------------------------------------------------------------------------
919 procedure inventory_accounts_std(
920 I_ORG_ID IN NUMBER,
921 I_TXN_ID IN NUMBER,
922 I_COMM_ISS_FLAG IN NUMBER,
923 I_COST_TXN_ACTION_ID IN NUMBER,
924 I_COST_GRP_ID IN NUMBER,
925 I_ITEM_ID IN NUMBER,
926 I_P_QTY IN NUMBER,
927 I_SOB_ID IN NUMBER,
928 I_TXN_DATE IN DATE,
929 I_TXN_SRC_ID IN NUMBER,
930 I_SRC_TYPE_ID IN NUMBER,
931 I_EXP_ITEM IN NUMBER,
932 I_EXP_SUBINV IN NUMBER,
933 I_EXP_ACCT IN NUMBER,
934 I_SUBINV IN VARCHAR2,
935 I_INTRANSIT IN NUMBER,
936 I_SND_RCV IN NUMBER,
937 I_PRI_CURR IN VARCHAR2,
938 I_ALT_CURR IN VARCHAR2,
939 I_CONV_DATE IN DATE,
940 I_CONV_RATE IN NUMBER,
941 I_CONV_TYPE IN VARCHAR2,
942 I_USER_ID IN NUMBER,
943 I_LOGIN_ID IN NUMBER,
944 I_REQ_ID IN NUMBER,
945 I_PRG_APPL_ID IN NUMBER,
946 I_PRG_ID IN NUMBER,
947 O_Error_Num OUT NOCOPY NUMBER,
948 O_Error_Code OUT NOCOPY VARCHAR2,
949 O_Error_Message OUT NOCOPY VARCHAR2
950 );
951
952 -----------------------------------------------------------------------------
953 -- Start of comments --
954 -- --
955 -- PROCEDURE --
956 -- cost_process_discrete_trx
957 -- This process is called from cmlmcw.lpc for process-discrete xfers --
958 -- across process and discrete standard costing organizations. --
959 -- Process Mfg. orgs are always marked as Standard Costing orgs. --
960 -- This new procesure will only be called for these transactions. --
961 -- --
962 -- Bug 4432078 OPM INVCONV umoogala 15-Apr-2005 --
963 -- End of comments --
964 -----------------------------------------------------------------------------
965
969 , prg_id IN BINARY_INTEGER
966 PROCEDURE cost_process_discrete_trx(
967 trans_id IN BINARY_INTEGER
968 , prg_appid IN BINARY_INTEGER
970 , req_id IN BINARY_INTEGER
971 , user_id IN BINARY_INTEGER
972 , login_id IN BINARY_INTEGER
973
974 , O_Error_Num OUT NOCOPY VARCHAR2
975 , O_Error_Code OUT NOCOPY VARCHAR2
976 , O_Error_Message OUT NOCOPY VARCHAR2
977 );
978
979 END CSTPACDP;