1 PACKAGE JMF_SHIKYU_WIP_PVT AS
2 -- $Header: JMFVSKWS.pls 120.0 2005/07/05 15:35 rajkrish noship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JMFWSHKS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package contains WIP 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_WIP_Job PUBLIC
25 -- PARAMETERS: p_action Action
26 -- 'C'- Create new job
27 -- 'D'- Delete Job
28 -- 'U'- Update Job
29 -- 'R'- Assembly Return
30 -- x_return_status Return Status
31 -- COMMENT : This procedure populates data in the interface table
32 -- to process the WIP job. The WIP load procedure is invoked
33 -- which creates the WIP job.
34 --========================================================================
35 PROCEDURE Process_WIP_Job
36 ( p_action IN VARCHAR2
37 , p_subcontract_po_shipment_id IN NUMBER
38 , p_need_by_date IN DATE
39 , p_quantity IN NUMBER
40 , x_return_status OUT NOCOPY VARCHAR2
41 );
42 --========================================================================
43 -- PROCEDURE : Compute_Start_Date PUBLIC
44 -- PARAMETERS:
45 -- p_need_by_Date Need By Date
46 -- p_item_id Item
47 -- p_organization Organization
48 -- p_quantity Quantity
49 -- COMMENT : This procedure computes the planned start date for the WIP job
50 -- based on the need_by_date
51 --========================================================================
52 PROCEDURE Compute_Start_Date
53 ( p_need_by_date IN DATE
54 , p_item_id IN NUMBER
55 , p_oem_organization IN NUMBER
56 , p_tp_organization IN NUMBER
57 , p_quantity IN NUMBER
58 , x_start_date OUT NOCOPY DATE
59 );
60
61 --========================================================================
62 -- FUNCTION : Get_Component_Quantity PUBLIC
63 -- PARAMETERS:
64 -- p_item_id Item
65 -- p_organization_id Organization
66 -- COMMENT : This procedure computes the quantity of the component
67 -- as defined in the BOM in primary UOM
68 --========================================================================
69 FUNCTION Get_Component_Quantity
70 ( p_item_id IN NUMBER
71 , p_organization_id IN NUMBER
72 , p_subcontract_po_shipment_id IN NUMBER
73 ) RETURN NUMBER;
74
75 END JMF_SHIKYU_WIP_PVT;