1 PACKAGE INV_RCV_STD_TRANSFER_APIS AUTHID CURRENT_USER AS
2 /* $Header: INVSTDTS.pls 120.1.12020000.3 2012/08/10 10:01:15 rdudani ship $ */
3
4 /** PROCEDURE: create_transfer_rcvtxn_rec
5 * Description:
6 * Specification of the stub procedure
7 *
8 * @param x_return_status
9 * Return status indicating Success (S), Error (E), Unexpected Error (U)
10 * @param x_msg_count
11 * Number of messages in message list
12 * @param x_msg_data
13 * Stacked messages text
14 * @param p_organization_id - Organization ID
15 * @param p_parent_txn_id - Transaction ID of the parent transaction
16 * @param p_reference_id - Reference ID of the move order line
17 * @param p_reference - Reference Indicator for the source doc
18 * @param p_reference_type_code - Reference Type Code
19 * @param p_item_id - Item Being transferred
20 * @param p_revision - Item Revision
21 * @param p_subinventory_code - Destination receiving subinventory code
22 * @param p_locator_id - Destination receiving locator ID
23 * @param p_transfer_quantity - Quantity to be transferred
24 * @param p_transfer_uom_code - UOM code of the quantity being tranferred
25 * @param p_lot_control_code - Lot Control Code of the item
26 * @param p_serial_control_code - Serial Control Code of the item
27 * @param p_original_rti_id - Original RTI ID for lot/serial split
28 * @param p_original_temp_id - Transaction Temp ID of the putaway MMTT
29 * @param p_lot_number - Lot Number on the move order line
30 * @param p_lpn_id - LPN ID of the move order line
31 * @param p_transfer_lpn_id - Transfer LPN ID (LPN being dropped into)
32 *
33 * @ return: NONE
34 *---------------------------------------------------------------------------*/
35
36 PROCEDURE create_transfer_rcvtxn_rec(
37 x_return_status OUT NOCOPY VARCHAR2
38 , x_msg_count OUT NOCOPY NUMBER
39 , x_msg_data OUT NOCOPY VARCHAR2
40 , p_organization_id IN NUMBER
41 , p_parent_txn_id IN NUMBER
42 , p_reference_id IN NUMBER
43 , p_reference IN VARCHAR2
44 , p_reference_type_code IN NUMBER
45 , p_item_id IN NUMBER
46 , p_revision IN VARCHAR2
47 , p_subinventory_code IN VARCHAR2
48 , p_locator_id IN NUMBER
49 , p_transfer_quantity IN NUMBER
50 , p_transfer_uom_code IN VARCHAR2
51 , p_lot_control_code IN NUMBER
52 , p_serial_control_code IN NUMBER
53 , p_original_rti_id IN NUMBER DEFAULT NULL
54 , p_original_temp_id IN NUMBER DEFAULT NULL
55 , p_lot_number IN VARCHAR2 DEFAULT NULL
56 , p_lpn_id IN NUMBER DEFAULT NULL
57 , p_transfer_lpn_id IN NUMBER DEFAULT NULL
58 , p_sec_transfer_quantity IN NUMBER DEFAULT NULL --OPM Convergence
59 , p_sec_transfer_uom_code IN VARCHAR2 DEFAULT NULL ); --OPM Convergence
60
61 PROCEDURE Match_transfer_rcvtxn_rec(
62 x_return_status OUT NOCOPY VARCHAR2
63 , x_msg_count OUT NOCOPY NUMBER
64 , x_msg_data OUT NOCOPY VARCHAR2
65 , p_organization_id IN NUMBER
66 , p_parent_txn_id IN NUMBER
67 , p_reference_id IN NUMBER
68 , p_reference IN VARCHAR2
69 , p_reference_type_code IN NUMBER
70 , p_item_id IN NUMBER
71 , p_revision IN VARCHAR2
72 , p_subinventory_code IN VARCHAR2
73 , p_locator_id IN NUMBER
74 , p_transfer_quantity IN NUMBER
75 , p_transfer_uom_code IN VARCHAR2
76 , p_lot_control_code IN NUMBER
77 , p_serial_control_code IN NUMBER
78 , p_original_rti_id IN NUMBER DEFAULT NULL
79 , p_original_temp_id IN NUMBER DEFAULT NULL
80 , p_lot_number IN VARCHAR2 DEFAULT NULL
81 , p_lpn_id IN NUMBER DEFAULT NULL
82 , p_transfer_lpn_id IN NUMBER DEFAULT NULL
83 , p_sec_transfer_quantity IN NUMBER DEFAULT NULL --OPM Convergence
84 , p_sec_transfer_uom_code IN VARCHAR2 DEFAULT NULL --OPM Convergence
85 , p_inspection_status IN NUMBER DEFAULT NULL
86 , p_primary_uom_code IN VARCHAR2
87 , p_from_sub IN VARCHAR2 DEFAULT NULL --Needed for matching non-lpn materials
88 , p_from_loc IN NUMBER DEFAULT NULL --Needed for matching non-lpn materials
89 , p_shipment_header_id IN NUMBER DEFAULT NULL); -- added for bug 14269755
90
91 END INV_RCV_STD_TRANSFER_APIS;
92