1 PACKAGE WSH_INBOUND_UTIL_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHIBUTS.pls 120.1 2005/07/04 23:32:35 ragarg noship $ */
3
4 -- HW OPMCONV no need for OPM variable
5 --LIMITED_PRECISION_OPM CONSTANT NUMBER := 9;
6
7 -- { IB-Phase-2
8 -- This global variable will determine whether a ASN / Receipt being matched,
9 -- is being matched Automatically or manually from the Inbound Reconcillation UI.
10 -- This information will be used to determine whether inline or asynchronous
11 -- rating of Trips will be done.
12 G_ASN_RECEIPT_MATCH_TYPE VARCHAR2(30);
13 -- } IB-Phase-2
14
15 --========================================================================
16 -- PROCEDURE : get_po_rcv_attributes This procedure derives the
17 -- x_line_rec based on the inputs
18 -- p_po_line_location_id and
19 -- p_rcv_shipment_line_id.
20 --
21 -- PARAMETERS: p_po_line_location_id po_line_location_id of
22 -- po_line_locations_all
23 -- p_rcv_shipment_line_id shipment_line_id of rcv_shipment_lines
24 -- x_line_rec Out parameter of type
25 -- OE_WSH_BULK_GRP.line_rec_type
26 -- x_return_status Return status of the API.
27 --
28 -- COMMENT : This procedure derives the x_line_rec based on the inputs
29 -- p_po_line_location_id and p_rcv_shipment_line_id
30 --========================================================================
31 PROCEDURE get_po_rcv_attributes(
32 p_po_line_location_id IN NUMBER,
33 p_rcv_shipment_line_id IN NUMBER DEFAULT NULL,
34 x_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
35 x_return_status OUT NOCOPY VARCHAR2);
36
37 --========================================================================
38 -- PROCEDURE : get_drop_ship_info
39 --
40 -- PARAMETERS: p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
41 -- p_index IN NUMBER
42 -- x_return_status return status
43 --
44 -- COMMENT : This API derives the value for all the drop ship fields
45 -- and populates the same into the p_line_rec sructure.
46 --========================================================================
47 PROCEDURE get_drop_ship_info(
48 p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
49 p_index IN NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2
51 );
52
53 --========================================================================
54
55 PROCEDURE split_inbound_delivery
56 (
57 p_delivery_detail_id_tbl IN wsh_util_core.id_tab_type,
58 p_delivery_id IN NUMBER,
59 x_delivery_id IN OUT NOCOPY NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2,
61 p_caller IN VARCHAR2 DEFAULT 'WSH_ASN_RECEIPT'
62 ) ;
63 PROCEDURE reRateDeliveries
64 (
65 p_delivery_id_tab IN wsh_util_core.id_tab_type,
66 x_return_status OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE setTripStopStatus
70 (
71 p_transaction_code IN VARCHAR2 DEFAULT 'RECEIPT',
72 p_action_code IN VARCHAR2 DEFAULT 'APPLY',
73 p_delivery_id_tab IN wsh_util_core.id_tab_type,
74 x_return_status OUT NOCOPY VARCHAR2
75 );
76
77 --========================================================================
78 -- PROCEDURE : convert_quantity
79 --
80 -- PARAMETERS: p_inv_item_id IN NUMBER DEFAULT NULL
81 -- p_organization_id IN NUMBER
82 -- p_primary_uom_code IN OUT NOCOPY VARCHAR2
83 -- p_quantity IN NUMBER
84 -- p_qty_uom_code IN VARCHAR2
85 -- x_conv_qty OUT NOCOPY NUMBER
86 -- x_return_status IN OUT NOCOPY VARCHAR2
87 --
88 -- COMMENT : This API is used to convert the quantity of an item
89 -- from one UOM code to another.Like 'DOZ' to 'EA'.
90 -- p_primary_uom_code is the uom code into which the quantity has to be
91 -- converted.
92 -- p_quantity is the quantity to be converted.
93 -- p_qty_uom_code is the code which represents the curent uom code
94 -- of the input p_quantity.
95 -- x_conv_qty will have the converted quantity in case of successfull
96 -- conversion.
97 --========================================================================
98
99 PROCEDURE convert_quantity
100 (
101 p_inv_item_id IN NUMBER DEFAULT NULL,
102 p_organization_id IN NUMBER,
103 p_primary_uom_code IN OUT NOCOPY VARCHAR2,
104 p_quantity IN NUMBER ,
105 p_qty_uom_code IN VARCHAR2,
106 x_conv_qty OUT NOCOPY NUMBER,
107 x_return_status IN OUT NOCOPY VARCHAR2
108 );
109
110 --=============================================================================
111 -- API name : GET_OUTERMOST_LPN
112 -- Type : Public.
113 -- Function :
114 -- Pre-reqs : None.
115 -- Parameters :
116 -- p_lpn_id IN NUMBER
117 -- p_shipment_header_id IN NUMBER
118 -- p_lpn_context IN NUMBER
119 -- x_outermost_lpn OUT NOCOPY NUMBER
120 -- x_return_status OUT NOCOPY VARCHAR2
121 -- ============================================================================
122 PROCEDURE GET_OUTERMOST_LPN(
123 p_lpn_id IN NUMBER,
124 p_shipment_header_id IN NUMBER,
125 p_lpn_context IN NUMBER,
126 x_outermost_lpn OUT NOCOPY NUMBER,
127 x_outermost_lpn_name OUT NOCOPY VARCHAR2,
128 x_return_status OUT NOCOPY VARCHAR2);
129
130
131 --=============================================================================
132 -- API name : Is_Routing_Response_Send
133 -- Type : Public.
134 -- Function : Determine if routing response has been send for detail line.
135 -- Pre-reqs : None.
136 --=============================================================================
137 --HACMS {
138 FUNCTION Is_Routing_Response_Send(p_delivery_detail_id NUMBER,
139 x_routing_response_id OUT NOCOPY NUMBER) RETURN boolean;
140
141 --HACMS }
142
143 END WSH_INBOUND_UTIL_PKG;