1 PACKAGE WSH_MAPPING_DATA AUTHID CURRENT_USER AS
2 /* $Header: WSHMAPDS.pls 120.1.12010000.5 2010/02/25 16:10:12 sankarun ship $ */
3
4 C_SDEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL1;
5 C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
6
7
8 PROCEDURE Get_Delivery_Info ( p_delivery_id IN NUMBER,
9 p_document_type IN VARCHAR2,
10 x_name OUT NOCOPY VARCHAR2,
11 x_arrival_date OUT NOCOPY DATE,
12 x_departure_date OUT NOCOPY DATE,
13 x_vehicle_num_prefix OUT NOCOPY VARCHAR2,
14 x_vehicle_number OUT NOCOPY VARCHAR2,
15 x_route_id OUT NOCOPY VARCHAR2,
16 x_routing_instructions OUT NOCOPY VARCHAR2,
17 x_departure_seal_code OUT NOCOPY VARCHAR2,
18 x_customer_name OUT NOCOPY VARCHAR2,
19 x_customer_number OUT NOCOPY VARCHAR2,
20 x_warehouse_type OUT NOCOPY VARCHAR2,
21 --Bug 3458160
22 x_operator OUT NOCOPY VARCHAR2,
23 x_ship_to_loc_code OUT NOCOPY VARCHAR2,
24 x_cnsgn_cont_per_name OUT NOCOPY VARCHAR2, --4227777
25 x_cnsgn_cont_per_ph OUT NOCOPY VARCHAR2, --4227777
26 x_return_status OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE get_part_addr_info(
30 p_partner_type IN VARCHAR2,
31 p_delivery_id IN NUMBER,
32 x_party_name OUT NOCOPY VARCHAR2,
33 x_partner_location OUT NOCOPY VARCHAR2,
34 x_currency OUT NOCOPY VARCHAR2,
35 x_duns_number OUT NOCOPY VARCHAR2,
36 x_intmed_ship_to_location OUT NOCOPY VARCHAR2,
37 x_pooled_ship_to_location OUT NOCOPY VARCHAR2,
38 x_address1 OUT NOCOPY VARCHAR2,
39 x_address2 OUT NOCOPY VARCHAR2,
40 x_address3 OUT NOCOPY VARCHAR2,
41 x_address4 OUT NOCOPY VARCHAR2,
42 x_city OUT NOCOPY VARCHAR2,
43 x_country OUT NOCOPY VARCHAR2,
44 x_county OUT NOCOPY VARCHAR2,
45 x_postal_code OUT NOCOPY VARCHAR2,
46 x_region OUT NOCOPY VARCHAR2,
47 x_state OUT NOCOPY VARCHAR2,
48 x_fax_number OUT NOCOPY VARCHAR2,
49 x_telephone OUT NOCOPY VARCHAR2,
50 x_url OUT NOCOPY VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2);
52
53 PROCEDURE get_ship_method_code(
54 p_carrier_name IN VARCHAR2,
55 p_service_level IN VARCHAR2 DEFAULT NULL,
56 p_mode_of_transport IN VARCHAR2 DEFAULT NULL,
57 p_doc_type IN VARCHAR2,
58 p_delivery_name IN VARCHAR2 DEFAULT NULL,
59 x_ship_method_code OUT NOCOPY VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2);
61
62
63 -- ---------------------------------------------------------------------
64 -- Procedure: Get_Locn_Cust_Info
65 --
66 -- Parameters:
67 --
68 -- Description: This procedure gets the location, party_name, party_number
69 -- that are required for SHIPITEM and SHIPUNIT during
70 -- 940/945 outbound
71 -- Created: Locations Project. Patchset I. KVENKATE
72 -- -----------------------------------------------------------------------
73 PROCEDURE get_locn_cust_info(
74 p_location_id IN NUMBER,
75 p_org_id IN NUMBER,
76 p_customer_id IN NUMBER,
77 x_location OUT NOCOPY VARCHAR2,
78 x_party_name OUT NOCOPY VARCHAR2,
79 x_party_number OUT NOCOPY VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2,
81 p_delivery_detail_id IN NUMBER,
82 p_wsn_rowid IN VARCHAR2,
83 p_requested_quantity IN NUMBER,
84 p_fm_serial_number IN VARCHAR2,
85 p_to_serial_number IN VARCHAR2,
86 x_requested_quantity OUT NOCOPY NUMBER,
87 x_shipped_quantity OUT NOCOPY NUMBER,
88 p_site_use_id IN NUMBER,
89 --bug 4227777
90 p_entity_type IN VARCHAR2,
91 x_cnsgn_cont_per_name OUT NOCOPY VARCHAR2,
92 x_cnsgn_cont_per_ph OUT NOCOPY VARCHAR2
93 );
94
95 --R12.1.1 STANDALONE PROJECT NEW API
96 PROCEDURE Get_Stnd_Delivery_Info ( p_delivery_id IN NUMBER ,
97 x_name OUT NOCOPY VARCHAR2 ,
98 x_org_id OUT NOCOPY NUMBER ,
99 x_arrival_date OUT NOCOPY DATE ,
100 x_departure_date OUT NOCOPY DATE ,
101 x_vehicle_num_prefix OUT NOCOPY VARCHAR2 ,
102 x_vehicle_number OUT NOCOPY VARCHAR2 ,
103 x_route_id OUT NOCOPY VARCHAR2 ,
104 x_routing_instructions OUT NOCOPY VARCHAR2 ,
105 x_departure_seal_code OUT NOCOPY VARCHAR2 ,
106 x_operator OUT NOCOPY VARCHAR2 ,
107 x_ship_to_loc_code OUT NOCOPY VARCHAR2 ,
108 x_pack_slip_num OUT NOCOPY VARCHAR2 ,
109 x_bill_of_lading_num OUT NOCOPY VARCHAR2 ,
110 -- Distributed - TPW Changes
111 x_customer_name OUT NOCOPY VARCHAR2 ,
112 x_return_status OUT NOCOPY VARCHAR2
113 );
114
115 --R12.1.1 STANDALONE PROJECT NEW API
116 PROCEDURE Get_Delivery_Detail_Info(
117 p_src_line_id IN NUMBER ,
118 p_delivery_detail_id IN NUMBER ,
119 p_detail_seq_number IN NUMBER ,
120 p_locator_id IN NUMBER ,
121 -- Distributed - TPW Changes
122 p_wsn_rowid IN VARCHAR2,
123 p_serial_type IN VARCHAR2 ,
124 p_requested_quantity IN NUMBER,
125 x_requested_quantity OUT NOCOPY NUMBER,
126 x_shipped_quantity OUT NOCOPY NUMBER,
127 x_open_quantity OUT NOCOPY NUMBER ,
128 x_bo_quantity OUT NOCOPY NUMBER ,
129 x_locator_code OUT NOCOPY VARCHAR2,
130 x_shipto_cont_per_name OUT NOCOPY VARCHAR2,
131 x_shipto_cont_per_ph OUT NOCOPY VARCHAR2,
132 x_shipto_cont_per_id OUT NOCOPY NUMBER ,
133 x_document_type OUT NOCOPY VARCHAR2,
134 x_document_id OUT NOCOPY NUMBER ,
135 x_line_number OUT NOCOPY NUMBER ,
136 x_return_status OUT NOCOPY VARCHAR2
137 );
138
139 --R12.1.1 STANDALONE PROJECT NEW API
140 PROCEDURE get_detail_part_addr_info(
141 p_delivery_detail_id IN NUMBER ,
142 p_entity_type IN VARCHAR2,
143 p_org_id IN NUMBER ,
144 p_partner_type IN VARCHAR2,
145 x_partner_id OUT NOCOPY NUMBER ,
146 x_partner_name OUT NOCOPY VARCHAR2,
147 x_partner_location OUT NOCOPY VARCHAR2,
148 x_duns_number OUT NOCOPY VARCHAR2,
149 x_address_id OUT NOCOPY NUMBER ,
150 x_address1 OUT NOCOPY VARCHAR2,
151 x_address2 OUT NOCOPY VARCHAR2,
152 x_address3 OUT NOCOPY VARCHAR2,
153 x_address4 OUT NOCOPY VARCHAR2,
154 x_city OUT NOCOPY VARCHAR2,
155 x_country OUT NOCOPY VARCHAR2,
156 x_county OUT NOCOPY VARCHAR2,
157 x_postal_code OUT NOCOPY VARCHAR2,
158 x_region OUT NOCOPY VARCHAR2,
159 x_state OUT NOCOPY VARCHAR2,
160 x_contact_id OUT NOCOPY NUMBER ,
161 x_contact_name OUT NOCOPY VARCHAR2,
162 x_contact_telephone OUT NOCOPY VARCHAR2,
163 x_return_status OUT NOCOPY VARCHAR2
164 );
165
166 --R12.1.1 STANDALONE PROJECT NEW API
167 PROCEDURE Get_Cust_addr_Info (
168 p_site_id IN NUMBER ,
169 p_contact_id IN NUMBER ,
170 p_org_id IN NUMBER ,
171 x_partner_id OUT NOCOPY NUMBER ,
172 x_partner_name OUT NOCOPY VARCHAR2,
173 x_partner_location OUT NOCOPY VARCHAR2,
174 x_duns_number OUT NOCOPY VARCHAR2,
175 x_address_id OUT NOCOPY NUMBER ,
176 x_address1 OUT NOCOPY VARCHAR2,
177 x_address2 OUT NOCOPY VARCHAR2,
178 x_address3 OUT NOCOPY VARCHAR2,
179 x_address4 OUT NOCOPY VARCHAR2,
180 x_city OUT NOCOPY VARCHAR2,
181 x_country OUT NOCOPY VARCHAR2,
182 x_county OUT NOCOPY VARCHAR2,
183 x_postal_code OUT NOCOPY VARCHAR2,
184 x_region OUT NOCOPY VARCHAR2,
185 x_state OUT NOCOPY VARCHAR2,
186 x_contact_name OUT NOCOPY VARCHAR2,
187 x_contact_telephone OUT NOCOPY VARCHAR2,
188 x_return_status OUT NOCOPY VARCHAR2
189 );
190
191 --R12.1.1 STANDALONE PROJECT NEW API
192 PROCEDURE Get_Del_Part_Addr_Info(
193 p_partner_type IN VARCHAR2,
194 p_delivery_id IN NUMBER ,
195 p_org_id IN NUMBER ,
196 x_partner_id OUT NOCOPY NUMBER ,
197 x_partner_name OUT NOCOPY VARCHAR2,
198 x_partner_location OUT NOCOPY VARCHAR2,
199 x_duns_number OUT NOCOPY VARCHAR2,
200 x_intmed_ship_to_location OUT NOCOPY VARCHAR2,
201 x_pooled_ship_to_location OUT NOCOPY VARCHAR2,
202 x_address_id OUT NOCOPY NUMBER ,
203 x_address1 OUT NOCOPY VARCHAR2,
204 x_address2 OUT NOCOPY VARCHAR2,
205 x_address3 OUT NOCOPY VARCHAR2,
206 x_address4 OUT NOCOPY VARCHAR2,
207 x_city OUT NOCOPY VARCHAR2,
208 x_country OUT NOCOPY VARCHAR2,
209 x_county OUT NOCOPY VARCHAR2,
210 x_postal_code OUT NOCOPY VARCHAR2,
211 x_region OUT NOCOPY VARCHAR2,
212 x_state OUT NOCOPY VARCHAR2,
213 x_contact_id OUT NOCOPY NUMBER ,
214 x_contact_name OUT NOCOPY VARCHAR2,
215 x_telephone OUT NOCOPY VARCHAR2,
216 x_return_status OUT NOCOPY VARCHAR2
217 );
218
219
220 -- TPW - Distributed Organization Changes
221 PROCEDURE get_ship_method_details(
222 p_ship_method_code IN VARCHAR2,
223 x_carrier_code OUT NOCOPY VARCHAR2,
224 x_service_level OUT NOCOPY VARCHAR2,
225 x_mode_of_transport OUT NOCOPY VARCHAR2,
226 x_return_status OUT NOCOPY VARCHAR2 );
227
228 PROCEDURE get_batch_addr_info (
229 p_partner_type IN VARCHAR2,
230 p_batch_id IN NUMBER,
231 x_partner_id OUT NOCOPY NUMBER,
232 x_partner_name OUT NOCOPY VARCHAR2,
233 x_address_id OUT NOCOPY NUMBER,
234 x_address1 OUT NOCOPY VARCHAR2,
235 x_address2 OUT NOCOPY VARCHAR2,
236 x_address3 OUT NOCOPY VARCHAR2,
237 x_address4 OUT NOCOPY VARCHAR2,
238 x_city OUT NOCOPY VARCHAR2,
239 x_country OUT NOCOPY VARCHAR2,
240 x_county OUT NOCOPY VARCHAR2,
241 x_postal_code OUT NOCOPY VARCHAR2,
242 x_region OUT NOCOPY VARCHAR2,
243 x_state OUT NOCOPY VARCHAR2,
244 x_contact_id OUT NOCOPY NUMBER,
245 x_contact_name OUT NOCOPY VARCHAR2,
246 x_telephone OUT NOCOPY VARCHAR2,
247 x_return_status OUT NOCOPY VARCHAR2 );
248
249 PROCEDURE get_detail_line_info (
250 p_reference_line_id IN NUMBER,
251 x_line_number OUT NOCOPY NUMBER,
252 x_line_quantity OUT NOCOPY VARCHAR2,
253 x_line_quantity_uom OUT NOCOPY VARCHAR2,
254 x_item_number OUT NOCOPY VARCHAR2,
255 x_item_description OUT NOCOPY VARCHAR2,
256 x_unit_selling_price OUT NOCOPY NUMBER,
257 x_packing_instructions OUT NOCOPY VARCHAR2,
258 x_shipping_instructions OUT NOCOPY VARCHAR2,
259 x_request_date OUT NOCOPY DATE,
260 x_schedule_date OUT NOCOPY DATE,
261 x_shipment_priority_code OUT NOCOPY VARCHAR2,
262 x_ship_tolerance_above OUT NOCOPY NUMBER,
263 x_ship_tolerance_below OUT NOCOPY NUMBER,
264 x_set_name OUT NOCOPY VARCHAR2,
265 x_customer_item_number OUT NOCOPY VARCHAR2,
266 x_cust_po_number OUT NOCOPY VARCHAR2,
267 x_subinventory OUT NOCOPY VARCHAR2,
268 x_return_status OUT NOCOPY VARCHAR2);
269
270 END WSH_MAPPING_DATA;