1 PACKAGE JMF_SHIKYU_RCV_PVT AS
2 --$Header: JMFVSKVS.pls 120.3 2006/10/11 15:02:07 vmutyala noship $
3 --+===========================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, California, USA |
6 --| All rights reserved. |
7 --+===========================================================================+
8 --| |
9 --| FILENAME : JMFVSKVS.pls |
10 --| |
11 --| DESCRIPTION: Specification file of the Process Receiving |
12 --| Transactions package. |
13 --| |
14 --| HISTORY: |
15 --| 10-JUN-2005 jizheng Created. |
16 --| 15-JUN-2005 THE2 Add locator_id process logic |
17 --| 27-JUN-2005 THE2 Add project_id process logic |
18 --| 27-JUN-2005 VMUTYALA Add from_subinventory and from_locator_id |
19 --| process logic |
20 --| 27-JUN-2005 THE2 Add replenish_order_line_id process logic |
21 --| |
22 --| 11/10/2006 vmutyala Bug 5592230 adding parameter |
23 --| p_vendor_site_id to the procedure |
24 --| process_rcv_header |
25 --+===========================================================================+
26
27 --========================================================================
28 -- PROCEDURE : process_rcv_header PUBLIC
29 -- PARAMETERS: p_vendor_id IN NUMBER
30 -- p_ship_to_org_id IN NUMBER
31 -- x_rcv_header_id OUT NOCOPY NUMBER
32 -- x_group_id OUT NOCOPY NUMBER
33
34 -- COMMENT : This procedure inserts records in rev_header_interface for auto_receive
35 --========================================================================
36 PROCEDURE Process_Rcv_Header
37 ( p_vendor_id IN NUMBER
38 , p_vendor_site_id IN NUMBER
39 , p_ship_to_org_id IN NUMBER
40 , x_rcv_header_id OUT NOCOPY NUMBER
41 , x_group_id OUT NOCOPY NUMBER
42 );
43
44 --========================================================================
45 -- PROCEDURE : process_rcv_trx PUBLIC
46 -- PARAMETERS: p_rcv_header_id IN NUMBER
47 -- p_group_id IN NUMBER
48 -- p_quantity IN NUMBER
49 -- p_unit_of_measure IN VARCHAR2
50 -- p_po_header_id IN NUMBER
51 -- p_po_line_id IN NUMBER
52 -- p_po_line_location_id IN NUMBER
53 -- p_po_distribution_id IN NUMBER
54 -- p_subinventory IN VARCHAR2
55 -- p_transaction_type IN VARCHAR2
56 -- p_auto_transact_code IN VARCHAR2
57 -- p_parent_transaction_id IN NUMBER
58
59 -- COMMENT : This procedure inserts records in rev_transactions_interface for auto_receive
60 --========================================================================
61 PROCEDURE Process_Rcv_Trx
62 ( p_rcv_header_id IN NUMBER
63 , p_group_id IN NUMBER
64 , p_quantity IN NUMBER
65 , p_unit_of_measure IN VARCHAR2
66 , p_po_header_id IN NUMBER
67 , p_po_line_id IN NUMBER
68 , p_subinventory IN VARCHAR2 DEFAULT NULL
69 , p_transaction_type IN VARCHAR2
70 , p_auto_transact_code IN VARCHAR2 DEFAULT NULL
71 , p_parent_transaction_id IN NUMBER
72 , p_po_line_location_id IN NUMBER
73 , p_locator_id IN NUMBER DEFAULT NULL
74 , p_project_id IN NUMBER DEFAULT NULL
75 , p_from_subinventory IN VARCHAR2 DEFAULT NULL
76 , p_from_locator_id IN NUMBER DEFAULT NULL
77 , p_replenish_order_line_id IN NUMBER DEFAULT NULL
78 );
79
80 G_MODULE_PREFIX VARCHAR2(100) := 'JMF.plsql.JMF_SHIKYU_RCV_PVT.';
81
82 END JMF_SHIKYU_RCV_PVT;