1 PACKAGE JMF_SHIKYU_ONT_PVT AS
2 -- $Header: JMFVSKOS.pls 120.2 2006/02/15 16:38 vchu noship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JMFOSHKS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package contains ONT related calls that the Interlock |
13 --| accesses when processing SHIKYU transactions |
14 --| HISTORY |
15 --| 05/09/2005 pseshadr Created |
16 --| 10/17/2005 vchu Modified signatures for |
17 --| Calculate_Ship_Date and |
18 --| Process_Replenishment_SO to fix an |
19 --| issue with calculation of scheduled |
20 --| ship dates. |
21 --| 02/15/2006 vchu Added Calculate_Ship_Date to the |
22 --| specification. |
23 --+=======================================================================+
24
25
26 --===================
27 -- PROCEDURES AND FUNCTIONS
28 --===================
29
30 --========================================================================
31 -- PROCEDURE : Calculate_Ship_Date PUBLIC
32 -- PARAMETERS:
33 -- p_subcontract_po_shipment_id Subcontracting Order Shipment ID
34 -- p_component_item_id SHIKYU Component to be shipped
35 -- p_oem_organization_id OEM Organization
36 -- p_tp_organization_id TP Organization
37 -- p_need_by_date Need By Date of the corresponding
38 -- Replenishment PO Shipment
39 -- x_ship_date Ship Date calculated to meet the
40 -- passed in Need_By_Date
41 -- COMMENT : This procedure computes the scheduled ship date for the component
42 -- based on the WIP start date and item lead times.
43 --========================================================================
44 PROCEDURE Calculate_Ship_Date
45 ( p_subcontract_po_shipment_id IN NUMBER
46 , p_component_item_id IN NUMBER
47 , p_oem_organization_id IN NUMBER
48 , p_tp_organization_id IN NUMBER
49 , p_quantity IN NUMBER
50 , p_need_by_date IN DATE
51 , x_ship_date OUT NOCOPY DATE
52 );
53
54 --========================================================================
55 -- PROCEDURE : Process_Replenishment_SO PUBLIC
56 -- PARAMETERS: p_action Action
57 -- 'C'- Create new job
58 -- 'D'- Delete Job
59 -- 'U'- Update Job
60 -- x_return_status Return Status
61 -- COMMENT : This procedure populates data in the interface table
62 -- and creates a replenishment SO for the subcontracting
63 -- order shipment line
64 --========================================================================
65 PROCEDURE Process_Replenishment_SO
66 ( p_action IN VARCHAR2
67 , p_subcontract_po_shipment_id IN NUMBER
68 , p_quantity IN NUMBER
69 , p_item_id IN NUMBER
70 , p_replen_po_shipment_id IN NUMBER
71 , p_oem_organization_id IN NUMBER
72 , p_tp_organization_id IN NUMBER
73 , x_order_line_id OUT NOCOPY NUMBER
74 , x_return_status OUT NOCOPY VARCHAR2
75 );
76
77 END JMF_SHIKYU_ONT_PVT;