1 PACKAGE WSH_OTM_REF_DATA_GEN_PKG as
2 /* $Header: WSHTMRGS.pls 120.0.12010000.1 2008/07/29 06:19:05 appldev ship $ */
3
4 --
5 --===================
6 -- PROCEDURES
7 --===================
8
9 --========================================================================
10 -- PROCEDURE : Send_Locations This procedure is called only from
11 -- the Inbound Reconciliation UI
12 -- when the user performs the revert
13 -- matching of a matched or
14 -- partially matched receipt.
15 --
16 -- PARAMETERS: p_shipment_header_id Shipment Header Id of the transaction
17 -- p_transaction_type transaction type (ASN or RECEIPT)
18 -- x_return_status return status of the API
19 --========================================================================
20
21 procedure SEND_LOCATIONS
22 (
23 p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
24 x_loc_xmission_rec OUT NOCOPY WSH_OTM_LOC_XMISSION_REC_TYPE,
25 x_transmission_id OUT NOCOPY NUMBER,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_data OUT NOCOPY VARCHAR2
28 );
29 function GET_STOP_LOCATION_XID
30 (
31 p_stop_id IN NUMBER
32 ) RETURN VARCHAR2;
33
34 procedure VALIDATE_TKT
35 (
36 p_operation IN VARCHAR2,
37 p_argument IN VARCHAR2,
38 p_ticket IN VARCHAR2,
39 x_tkt_valid OUT NOCOPY VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 procedure GET_INT_LOCATION_XID
45 (
46 p_location_id IN NUMBER,
47 x_location_xid OUT NOCOPY VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2
49 );
50
51 END WSH_OTM_REF_DATA_GEN_PKG;