1 PACKAGE JMF_SHIKYU_INV_PVT AS
2 -- $Header: JMFVSKIS.pls 120.1 2005/07/12 17:32 vchu noship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JMFISHKS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package contains INV related calls that the Interlock |
13 --| accesses when processing SHIKYU transactions |
14 --| HISTORY |
15 --| 05/09/2005 pseshadr Created |
16 --+========================================================================
17
18
19 --===================
20 -- PROCEDURES AND FUNCTIONS
21 --===================
22
23 --========================================================================
24 -- PROCEDURE : Process_Misc_Rcpt PUBLIC
25 -- PARAMETERS: p_subcontract_po_shipment_id OSA PO Shipment Id
26 -- p_quantity Quantity
27 -- x_return_status Return Status
28 -- COMMENT : This procedure invokes the Process_Transaction
29 -- with the appropriate transaction type to process
30 -- the Misc. rcpt transaction into Inventory.
31 --========================================================================
32 PROCEDURE Process_Misc_Rcpt
33 ( p_subcontract_po_shipment_id IN NUMBER
34 , p_osa_quantity IN NUMBER
35 , p_uom IN VARCHAR2
36 , x_return_status OUT NOCOPY VARCHAR2
37 );
38
39 --========================================================================
40 -- PROCEDURE : Process_Misc_Issue PUBLIC
41 -- PARAMETERS: p_subcontract_po_shipment_id OSA PO Shipment Id
42 -- p_quantity Quantity
43 -- x_return_status Return Status
44 -- COMMENT : This procedure invokes the Process_Transaction
45 -- with the appropriate transaction type to process
46 -- the Misc. issue transaction into Inventory.
47 --========================================================================
48 PROCEDURE Process_Misc_Issue
49 ( p_subcontract_po_shipment_id IN NUMBER
50 , p_osa_quantity IN NUMBER
51 , p_uom IN VARCHAR2
52 , x_return_status OUT NOCOPY VARCHAR2
53 );
54
55 --========================================================================
56 -- PROCEDURE : Process_WIP_Completion PUBLIC
57 -- PARAMETERS: p_subcontract_po_shipment_id OSA PO Shipment Id
58 -- p_quantity Quantity
59 -- x_return_status Return Status
60 -- COMMENT : This procedure invokes the Process_Transaction
61 -- with the appropriate transaction type to process
62 -- the WIP completion transaction into Inventory.
63 --========================================================================
64 PROCEDURE Process_WIP_Completion
65 ( p_subcontract_po_shipment_id IN NUMBER
66 , p_osa_quantity IN NUMBER
67 , p_uom IN VARCHAR2
68 , x_return_status OUT NOCOPY VARCHAR2
69 );
70
71 --========================================================================
72 -- PROCEDURE : Process_WIP_Assy_Return PUBLIC
73 -- PARAMETERS: p_subcontract_po_shipment_id OSA PO Shipment Id
74 -- p_quantity Quantity
75 -- x_return_status Return Status
76 -- COMMENT : This procedure invokes the Process_Transaction
77 -- with the appropriate transaction type to process
78 -- the WIP Assembly return transaction into Inventory.
79 --========================================================================
80 PROCEDURE Process_WIP_Assy_Return
81 ( p_subcontract_po_shipment_id IN NUMBER
82 , p_osa_quantity IN NUMBER
83 , p_uom IN VARCHAR2
84 , x_return_status OUT NOCOPY VARCHAR2
85 );
86
87 --========================================================================
88 -- PROCEDURE : Process_WIP_Component_Return PUBLIC
89 -- PARAMETERS: p_subcontract_po_shipment_id OSA PO Shipment Id
90 -- p_quantity Quantity
91 -- p_component_id SUbcontract assembly component
92 -- x_return_status Return Status
93 -- COMMENT : This procedure invokes the Process_Transaction
94 -- with the appropriate transaction type to process
95 -- the WIP Component_Return transaction into Inventory.
96 --========================================================================
97 PROCEDURE Process_WIP_Component_Return
98 ( p_subcontract_po_shipment_id IN NUMBER
99 , p_quantity IN NUMBER
100 , p_component_id IN NUMBER
101 , p_uom IN VARCHAR2
102 , x_return_status OUT NOCOPY VARCHAR2
103 );
104
105 --========================================================================
106 -- PROCEDURE : Process_WIP_Component_Issue PUBLIC
107 -- PARAMETERS: p_subcontract_po_shipment_id OSA PO Shipment Id
108 -- p_quantity Quantity
109 -- p_component_id SUbcontract assembly component
110 -- x_return_status Return Status
111 -- COMMENT : This procedure invokes the Process_Transaction
112 -- with the appropriate transaction type to process
113 -- the WIP Component Issue transaction into Inventory.
114 --========================================================================
115 PROCEDURE Process_WIP_Component_Issue
116 ( p_subcontract_po_shipment_id IN NUMBER
117 , p_quantity IN NUMBER
118 , p_component_id IN NUMBER
119 , p_uom IN VARCHAR2
120 , x_return_status OUT NOCOPY VARCHAR2
121 );
122
123 --========================================================================
124 -- PROCEDURE : Process_Transaction PUBLIC
125 -- PARAMETERS: p_subcontract_po_shipment_id OSA PO Shipment Id
126 -- p_quantity Quantity
127 -- p_item_id SUbcontract assembly component
128 -- p_transaction_type_id Transaction Type
129 -- p_transaction_action_id Transaction Action
133 --========================================================================
130 -- x_return_status Return Status
131 -- COMMENT : This procedure inserts records in inventory interface
132 -- tables and invokes the Inventory TM to insert into MMT
134 PROCEDURE Process_Transaction
135 ( p_subcontract_po_shipment_id IN NUMBER
136 , p_quantity IN NUMBER
137 , p_item_id IN NUMBER
138 , p_transaction_type_id IN NUMBER
139 , p_transaction_action_id IN NUMBER
140 , p_uom IN VARCHAR2
141 , x_return_status OUT NOCOPY VARCHAR2
142 );
143
144 END JMF_SHIKYU_INV_PVT;