[Home] [Help]
PACKAGE: APPS.OE_WSH_BULK_GRP
Source
1 PACKAGE OE_WSH_BULK_GRP AUTHID CURRENT_USER AS
2 /* $Header: OEBGWSHS.pls 120.4.12020000.2 2013/01/11 02:09:49 gabhatia ship $ */
3
4
5 -----------------------------------------------------------------
6 -- DATA TYPES (RECORD/TABLE TYPES)
7 -----------------------------------------------------------------
8
9 TYPE T_DATE is TABLE OF DATE;
10 TYPE T_NUM is TABLE OF NUMBER;
11 TYPE T_B_INT is TABLE OF BINARY_INTEGER;
12 TYPE T_V1 is TABLE OF VARCHAR(01);
13 TYPE T_V3 is TABLE OF VARCHAR(03);
14 TYPE T_V4 is TABLE OF VARCHAR(04);
15 TYPE T_V10 is TABLE OF VARCHAR(10);
16 TYPE T_V15 is TABLE OF VARCHAR(15);
17 TYPE T_V25 is TABLE OF VARCHAR(25);
18 TYPE T_V30 is TABLE OF VARCHAR(30);
19 TYPE T_V40 is TABLE OF VARCHAR(40);
20 TYPE T_V50 is TABLE OF VARCHAR(50);
21 TYPE T_V80 is TABLE OF VARCHAR(80);
22 TYPE T_V150 is TABLE OF VARCHAR(150);
23 TYPE T_V240 is TABLE OF VARCHAR(240);
24 TYPE T_V250 is TABLE OF VARCHAR(250);
25 TYPE T_V1000 is TABLE OF VARCHAR(1000);
26 TYPE T_V2000 is TABLE OF VARCHAR(2000);
27
28 -----------------------------------------------------------------
29 -- Line record type
30 -----------------------------------------------------------------
31 TYPE Line_Rec_Type IS RECORD
32 ( accounting_rule_id T_NUM := T_NUM()
33 ,accounting_rule_duration T_NUM := T_NUM()
34 ,actual_arrival_date T_DATE := T_DATE()
35 ,agreement_id T_NUM := T_NUM()
36 ,arrival_set_id T_NUM := T_NUM()
37 ,ato_line_id T_NUM := T_NUM()
38 ,ato_line_index T_NUM := T_NUM()
39 ,attribute1 T_V240 := T_V240()
40 ,attribute10 T_V240 := T_V240()
41 ,attribute11 T_V240 := T_V240()
42 ,attribute12 T_V240 := T_V240()
43 ,attribute13 T_V240 := T_V240()
44 ,attribute14 T_V240 := T_V240()
45 ,attribute15 T_V240 := T_V240()
46 ,attribute16 T_V240 := T_V240() --For bug 2184255
47 ,attribute17 T_V240 := T_V240()
48 ,attribute18 T_V240 := T_V240()
49 ,attribute19 T_V240 := T_V240()
50 ,attribute2 T_V240 := T_V240()
51 ,attribute20 T_V240 := T_V240()
52 ,attribute3 T_V240 := T_V240()
53 ,attribute4 T_V240 := T_V240()
54 ,attribute5 T_V240 := T_V240()
55 ,attribute6 T_V240 := T_V240()
56 ,attribute7 T_V240 := T_V240()
57 ,attribute8 T_V240 := T_V240()
58 ,attribute9 T_V240 := T_V240()
59 ,authorized_to_ship_flag T_V1 := T_V1()
60 ,auto_selected_quantity T_NUM := T_NUM()
61 ,booked_flag T_V1 := T_V1()
62 ,cancelled_flag T_V1 := T_V1()
63 ,cancelled_quantity T_NUM := T_NUM()
64 ,cancelled_quantity2 T_NUM := T_NUM()
65 ,commitment_id T_NUM := T_NUM()
66 ,component_code T_V1000 := T_V1000()
67 ,component_number T_NUM := T_NUM()
68 ,component_sequence_id T_NUM := T_NUM()
69 ,top_bill_sequence_id T_NUM := T_NUM()
70 ,cz_qty_match_flag T_V1 := T_V1()
71 ,config_header_id T_NUM := T_NUM()
72 ,config_rev_nbr T_NUM := T_NUM()
73 ,config_display_sequence T_NUM := T_NUM()
74 ,configuration_id T_NUM := T_NUM()
75 ,context T_V30 := T_V30()
76 --,created_by T_NUM := T_NUM()
77 --,creation_date T_DATE := T_DATE()
78 ,credit_invoice_line_id T_NUM := T_NUM()
79 ,customer_dock_code T_V50 := T_V50()
80 ,customer_job T_V50 := T_V50()
81 ,customer_production_line T_V50 := T_V50()
82 --,customer_trx_line_id T_NUM := T_NUM()
83 ,cust_model_serial_number T_V50 := T_V50()
84 ,cust_po_number T_V50 := T_V50()
85 ,cust_trx_type_id T_NUM := T_NUM()
86 ,cust_production_seq_num T_V50 := T_V50()
87 ,delivery_lead_time T_NUM := T_NUM()
88 ,deliver_to_contact_id T_NUM := T_NUM()
89 ,deliver_to_org_id T_NUM := T_NUM()
90 ,demand_bucket_type_code T_V30 := T_V30()
91 ,demand_class_code T_V30 := T_V30()
92 ,dep_plan_required_flag T_V1 := T_V1()
93 ,earliest_acceptable_date T_DATE := T_DATE()
94 ,end_item_unit_number T_V30 := T_V30()
95 ,explosion_date T_DATE := T_DATE()
96 ,fob_point_code T_V30 := T_V30()
97 ,freight_carrier_code T_V30 := T_V30()
98 ,freight_terms_code T_V30 := T_V30()
99 ,fulfilled_quantity T_NUM := T_NUM()
100 ,fulfilled_quantity2 T_NUM := T_NUM()
101 ,global_attribute1 T_V240 := T_V240()
102 ,global_attribute10 T_V240 := T_V240()
103 ,global_attribute11 T_V240 := T_V240()
104 ,global_attribute12 T_V240 := T_V240()
105 ,global_attribute13 T_V240 := T_V240()
106 ,global_attribute14 T_V240 := T_V240()
107 ,global_attribute15 T_V240 := T_V240()
108 ,global_attribute16 T_V240 := T_V240()
109 ,global_attribute17 T_V240 := T_V240()
110 ,global_attribute18 T_V240 := T_V240()
111 ,global_attribute19 T_V240 := T_V240()
112 ,global_attribute2 T_V240 := T_V240()
113 ,global_attribute20 T_V240 := T_V240()
114 ,global_attribute3 T_V240 := T_V240()
115 ,global_attribute4 T_V240 := T_V240()
116 ,global_attribute5 T_V240 := T_V240()
117 ,global_attribute6 T_V240 := T_V240()
118 ,global_attribute7 T_V240 := T_V240()
119 ,global_attribute8 T_V240 := T_V240()
120 ,global_attribute9 T_V240 := T_V240()
121 ,global_attribute_category T_V30 := T_V30()
122 ,header_id T_NUM := T_NUM()
123 ,industry_attribute1 T_V240 := T_V240()
124 ,industry_attribute10 T_V240 := T_V240()
125 ,industry_attribute11 T_V240 := T_V240()
126 ,industry_attribute12 T_V240 := T_V240()
127 ,industry_attribute13 T_V240 := T_V240()
128 ,industry_attribute14 T_V240 := T_V240()
129 ,industry_attribute15 T_V240 := T_V240()
130 ,industry_attribute16 T_V240 := T_V240()
131 ,industry_attribute17 T_V240 := T_V240()
132 ,industry_attribute18 T_V240 := T_V240()
133 ,industry_attribute19 T_V240 := T_V240()
134 ,industry_attribute20 T_V240 := T_V240()
135 ,industry_attribute21 T_V240 := T_V240()
136 ,industry_attribute22 T_V240 := T_V240()
137 ,industry_attribute23 T_V240 := T_V240()
138 ,industry_attribute24 T_V240 := T_V240()
139 ,industry_attribute25 T_V240 := T_V240()
140 ,industry_attribute26 T_V240 := T_V240()
141 ,industry_attribute27 T_V240 := T_V240()
142 ,industry_attribute28 T_V240 := T_V240()
143 ,industry_attribute29 T_V240 := T_V240()
144 ,industry_attribute30 T_V240 := T_V240()
145 ,industry_attribute2 T_V240 := T_V240()
146 ,industry_attribute3 T_V240 := T_V240()
147 ,industry_attribute4 T_V240 := T_V240()
148 ,industry_attribute5 T_V240 := T_V240()
149 ,industry_attribute6 T_V240 := T_V240()
150 ,industry_attribute7 T_V240 := T_V240()
151 ,industry_attribute8 T_V240 := T_V240()
152 ,industry_attribute9 T_V240 := T_V240()
153 ,industry_context T_V30 := T_V30()
154 ,TP_CONTEXT T_V30 := T_V30()
155 ,TP_ATTRIBUTE1 T_V240 := T_V240()
156 ,TP_ATTRIBUTE2 T_V240 := T_V240()
157 ,TP_ATTRIBUTE3 T_V240 := T_V240()
158 ,TP_ATTRIBUTE4 T_V240 := T_V240()
159 ,TP_ATTRIBUTE5 T_V240 := T_V240()
160 ,TP_ATTRIBUTE6 T_V240 := T_V240()
161 ,TP_ATTRIBUTE7 T_V240 := T_V240()
162 ,TP_ATTRIBUTE8 T_V240 := T_V240()
163 ,TP_ATTRIBUTE9 T_V240 := T_V240()
164 ,TP_ATTRIBUTE10 T_V240 := T_V240()
165 ,TP_ATTRIBUTE11 T_V240 := T_V240()
166 ,TP_ATTRIBUTE12 T_V240 := T_V240()
167 ,TP_ATTRIBUTE13 T_V240 := T_V240()
168 ,TP_ATTRIBUTE14 T_V240 := T_V240()
169 ,TP_ATTRIBUTE15 T_V240 := T_V240()
170 ,inventory_item_id T_NUM := T_NUM()
171 --,invoice_interface_status_code T_V30 := T_V30()
172 ,invoice_to_contact_id T_NUM := T_NUM()
173 ,invoice_to_org_id T_NUM := T_NUM()
174 ,invoicing_rule_id T_NUM := T_NUM()
175 ,ordered_item T_V2000 := T_V2000()
176 ,item_revision T_V3 := T_V3()
177 ,item_type_code T_V30 := T_V30()
178 --,last_updated_by T_NUM := T_NUM()
179 --,last_update_date T_DATE := T_DATE()
180 --,last_update_login T_NUM := T_NUM()
181 ,latest_acceptable_date T_DATE := T_DATE()
182 ,line_category_code T_V30 := T_V30()
183 ,line_id T_NUM := T_NUM()
184 ,line_number T_NUM := T_NUM()
185 ,line_type_id T_NUM := T_NUM()
186 ,link_to_line_ref T_V50 := T_V50()
187 ,link_to_line_id T_NUM := T_NUM()
188 --,link_to_line_index T_NUM := T_NUM()
189 ,model_group_number T_NUM := T_NUM()
190 --,mfg_component_sequence_id T_NUM := T_NUM()
191 ,mfg_lead_time T_NUM := T_NUM()
192 --,open_flag T_V1 := T_V1()
193 ,option_flag T_V1 := T_V1()
194 ,option_number T_NUM := T_NUM()
195 ,ordered_quantity T_NUM := T_NUM()
196 ,ordered_quantity2 T_NUM := T_NUM()
197 ,order_quantity_uom T_V3 := T_V3()
198 ,ordered_quantity_uom2 T_V3 := T_V3()
199 --,org_id T_NUM := T_NUM()
200 ,orig_sys_document_ref T_V50 := T_V50()
201 ,orig_sys_line_ref T_V50 := T_V50()
202 ,over_ship_reason_code T_V30 := T_V30()
203 ,over_ship_resolved_flag T_V1 := T_V1()
204 ,payment_term_id T_NUM := T_NUM()
205 ,price_list_id T_NUM := T_NUM()
206 ,pricing_attribute1 T_V240 := T_V240()
207 ,pricing_attribute10 T_V240 := T_V240()
208 ,pricing_attribute2 T_V240 := T_V240()
209 ,pricing_attribute3 T_V240 := T_V240()
210 ,pricing_attribute4 T_V240 := T_V240()
211 ,pricing_attribute5 T_V240 := T_V240()
212 ,pricing_attribute6 T_V240 := T_V240()
213 ,pricing_attribute7 T_V240 := T_V240()
214 ,pricing_attribute8 T_V240 := T_V240()
215 ,pricing_attribute9 T_V240 := T_V240()
216 ,pricing_context T_V240 := T_V240()
217 ,pricing_date T_DATE := T_DATE()
218 ,pricing_quantity T_NUM := T_NUM()
219 ,pricing_quantity_uom T_V3 := T_V3()
220 --,program_application_id T_NUM := T_NUM()
221 --,program_id T_NUM := T_NUM()
222 --,program_update_date T_DATE := T_DATE()
223 ,project_id T_NUM := T_NUM()
224 ,promise_date T_DATE := T_DATE()
225 ,re_source_flag T_V1 := T_V1()
226 --,reference_customer_trx_line_id T_NUM := T_NUM()
227 ,reference_header_id T_NUM := T_NUM()
228 ,reference_line_id T_NUM := T_NUM()
229 ,reference_type T_V30 := T_V30()
230 ,request_date T_DATE := T_DATE()
231 ,request_id T_NUM := T_NUM()
232 ,reserved_quantity T_NUM := T_NUM()
233 ,return_attribute1 T_V240 := T_V240()
234 ,return_attribute10 T_V240 := T_V240()
235 ,return_attribute11 T_V240 := T_V240()
236 ,return_attribute12 T_V240 := T_V240()
240 ,return_attribute2 T_V240 := T_V240()
237 ,return_attribute13 T_V240 := T_V240()
238 ,return_attribute14 T_V240 := T_V240()
239 ,return_attribute15 T_V240 := T_V240()
241 ,return_attribute3 T_V240 := T_V240()
242 ,return_attribute4 T_V240 := T_V240()
243 ,return_attribute5 T_V240 := T_V240()
244 ,return_attribute6 T_V240 := T_V240()
245 ,return_attribute7 T_V240 := T_V240()
246 ,return_attribute8 T_V240 := T_V240()
247 ,return_attribute9 T_V240 := T_V240()
248 ,return_context T_V30 := T_V30()
249 ,return_reason_code T_V30 := T_V30()
250 --,rla_schedule_type_code T_V30 := T_V30()
251 ,salesrep_id T_NUM := T_NUM()
252 ,schedule_arrival_date T_DATE := T_DATE()
253 ,schedule_ship_date T_DATE := T_DATE()
254 --,schedule_action_code T_V30 := T_V30()
255 ,schedule_status_code T_V30 := T_V30()
256 ,shipment_number T_NUM := T_NUM()
257 ,shipment_priority_code T_V30 := T_V30()
258 ,shipped_quantity T_NUM := T_NUM()
259 ,shipped_quantity2 T_NUM := T_NUM()
260 ,shipping_method_code T_V30 := T_V30()
261 ,shipping_quantity T_NUM := T_NUM()
262 ,shipping_quantity2 T_NUM := T_NUM()
263 ,shipping_quantity_uom T_V3 := T_V3()
264 ,shipping_quantity_uom2 T_V3 := T_V3()
265 ,ship_from_org_id T_NUM := T_NUM()
266 ,ship_model_complete_flag T_V30 := T_V30()
267 ,ship_set_id T_NUM := T_NUM()
268 ,fulfillment_set_id T_NUM := T_NUM()
269 ,ship_tolerance_above T_NUM := T_NUM()
270 ,ship_tolerance_below T_NUM := T_NUM()
271 ,ship_to_contact_id T_NUM := T_NUM()
272 ,ship_to_org_id T_NUM := T_NUM()
273 ,sold_to_org_id T_NUM := T_NUM()
274 ,sold_from_org_id T_NUM := T_NUM()
275 ,sort_order T_V2000 := T_V2000() -- 4336446
276 ,source_document_id T_NUM := T_NUM()
277 ,source_document_line_id T_NUM := T_NUM()
278 ,source_document_type_id T_NUM := T_NUM()
279 ,source_type_code T_V30 := T_V30()
280 ,split_from_line_id T_NUM := T_NUM()
281 ,task_id T_NUM := T_NUM()
282 ,tax_calculation_flag T_V1 := T_V1()
283 ,tax_code T_V50 := T_V50()
284 ,tax_date T_DATE := T_DATE()
285 ,tax_exempt_flag T_V30 := T_V30()
286 ,tax_exempt_number T_V50 := T_V50()
287 ,tax_exempt_reason_code T_V30 := T_V30()
288 ,tax_point_code T_V30 := T_V30()
289 ,tax_rate T_NUM := T_NUM()
290 ,tax_value T_NUM := T_NUM()
291 ,top_model_line_ref T_V50 := T_V50()
292 ,top_model_line_id T_NUM := T_NUM()
293 ,top_model_line_index T_NUM := T_NUM()
294 ,unit_list_price T_NUM := T_NUM()
295 ,unit_list_price_per_pqty T_NUM := T_NUM()
296 ,unit_selling_price T_NUM := T_NUM()
297 ,unit_selling_price_per_pqty T_NUM := T_NUM()
298 ,veh_cus_item_cum_key_id T_NUM := T_NUM()
299 ,visible_demand_flag T_V1 := T_V1()
300 --,return_status T_V1 := T_V1()
301 --,db_flag T_V1 := T_V1()
302 --,operation T_V30 := T_V30()
303 ,first_ack_code T_V30 := T_V30()
304 ,first_ack_date T_DATE := T_DATE()
305 ,last_ack_code T_V30 := T_V30()
306 ,last_ack_date T_DATE := T_DATE()
307 ,override_atp_date_code T_V30 := T_V30()
308 ,change_reason T_V30 := T_V30()
309 ,change_comments T_V2000 := T_V2000()
310 ,order_source_id T_NUM := T_NUM()
311 ,orig_sys_shipment_ref T_V50 := T_V50()
312 ,change_sequence T_V50 := T_V50()
313 ,change_request_code T_V30 := T_V30()
314 ,status_flag T_V1 := T_V1()
315 ,drop_ship_flag T_V1 := T_V1()
316 ,customer_line_number T_V50 := T_V50()
317 ,customer_shipment_number T_V50 := T_V50()
318 ,customer_item_net_price T_NUM := T_NUM()
319 ,customer_payment_term_id T_NUM := T_NUM()
320 ,ordered_item_id T_NUM := T_NUM()
321 ,item_identifier_type T_V25 := T_V25()
322 ,shipping_instructions T_V2000 := T_V2000()
323 ,packing_instructions T_V2000 := T_V2000()
324 ,calculate_price_flag T_V1 := T_V1()
325 ,invoiced_quantity T_NUM := T_NUM()
326 ,service_txn_reason_code T_V30 := T_V30()
327 ,service_txn_comments T_V2000 := T_V2000()
328 ,service_duration T_NUM := T_NUM()
329 ,service_period T_V3 := T_V3()
330 ,service_start_date T_DATE := T_DATE()
331 ,service_end_date T_DATE := T_DATE()
332 ,service_coterminate_flag T_V1 := T_V1()
333 ,unit_list_percent T_NUM := T_NUM()
334 ,unit_selling_percent T_NUM := T_NUM()
335 ,unit_percent_base_price T_NUM := T_NUM()
336 ,service_number T_NUM := T_NUM()
337 ,service_reference_type_code T_V30 := T_V30()
338 ,service_reference_line_id T_NUM := T_NUM()
339 --,service_reference_system_id T_NUM := T_NUM()
340 --,service_ref_order_number T_NUM := T_NUM()
341 --,service_ref_line_number T_NUM := T_NUM()
342 ,service_reference_order T_V50 := T_V50()
343 ,service_reference_line T_V50 := T_V50()
344 ,service_reference_system T_V50 := T_V50()
345 --,service_ref_shipment_number T_NUM := T_NUM()
346 --,service_ref_option_number T_NUM := T_NUM()
347 --,service_line_index T_NUM := T_NUM()
351 ,fulfilled_flag T_V1 := T_V1()
348 ,split_by T_V240 := T_V240()
349 ,Split_Action_Code T_V30 := T_V30()
350 ,shippable_flag T_V1 := T_V1()
352 --,revenue_amount T_NUM := T_NUM()
353 --,marketing_source_code_id T_NUM := T_NUM()
354 --,fulfillment_date T_DATE := T_DATE()
355 --,semi_processed_flag BOOLEAN := BOOLEAN()
356 --,upgraded_flag T_V1 := T_V1()
357 ,lock_control T_NUM := T_NUM()
358 ,subinventory T_V10 := T_V10()
359 ,split_from_line_ref T_V50 := T_V50()
360 , wf_process_name T_V30 := T_V30()
361 , ii_count T_NUM := T_NUM()
362 , ii_start_index T_NUM := T_NUM()
363 , user_item_description T_V1000 := T_V1000()
364 , parent_line_index T_NUM := T_NUM()
365 --PIB {
366 , line_index T_NUM := T_NUM()
367 , header_index T_NUM := T_NUM()
368 --PIB }
369 ----------------- hvop wsh new additions -------------
370 ,shipping_eligible_flag T_V1 := T_V1()
371 ,error_message_count T_NUM := T_NUM()
372 ,actual_shipment_date T_DATE := T_DATE()
373 ,intermed_ship_to_org_id T_NUM := T_NUM()
374 ,intermed_ship_to_contact_id T_NUM := T_NUM()
375 ,planning_priority T_NUM := T_NUM()
376 ,preferred_grade T_V150 := T_V150() -- INVCONV
377 ,shipping_interfaced_flag T_V1 := T_V1()
378 ,Line_set_id T_NUM := T_NUM()
379 ,model_remnant_flag T_V1 := T_V1()
380 ,flow_status_code T_V30 := T_V30()
381 ,fulfillment_method_code T_V30 := T_V30()-- ???
382 ,ship_to_edi_location_code T_V40 := T_V40()
383 ,sold_to_contact_id T_NUM := T_NUM()
384 ,item_description T_V250 := T_V250()
385 ,hazard_class_id T_NUM := T_NUM()
386 ,weight_uom_code T_V3 := T_V3()
387 ,volume T_NUM := T_NUM()
388 ,volume_uom_code T_V3 := T_V3()
389 ,source_header_number T_V150 := T_V150()
390 ,source_header_type_id T_NUM := T_NUM()
391 ,source_header_type_name T_V240 := T_V240()
392 ,source_line_number T_V150 := T_V150()
393 ,requested_quantity_uom T_V3 := T_V3()
394 ,mtl_unit_weight T_V150 := T_V150()
395 ,mtl_unit_volume T_NUM := T_NUM()
396 ,currency_code T_V15 := T_V15()
397 ,master_container_item_id T_NUM := T_NUM()
398 ,detail_container_item_id T_NUM := T_NUM()
399 ,country_of_origin T_V50 := T_V50()
400 ,ship_from_location_id T_NUM := T_NUM()
401 ,ship_to_location_id T_NUM := T_NUM()
402 ,deliver_to_location_id T_NUM := T_NUM()
403 ,intmed_ship_to_location_id T_NUM := T_NUM()
404 ,customer_item_id T_NUM := T_NUM()
405 ,net_weight T_NUM := T_NUM()
406 ,mvt_stat_status T_V30 := T_V30()
407 ,delivery_detail_id T_NUM := T_NUM()
408 ,inspection_flag T_V1 := T_V1()
409 ,container_flag T_V1 := T_V1()
410 ,container_type_code T_V30 := T_V30()
411 ,container_name T_V30 := T_V30()
412 ,gross_weight T_NUM := T_NUM()
413 ,seal_code T_V3 := T_V3()
414 ,freight_class_cat_id T_NUM := T_NUM()
415 ,commodity_code_cat_id T_NUM := T_NUM()
416 ,pickable_flag T_V1 := T_V1()
417 ,original_subinventory T_V10 := T_V10()
418 ,source_line_set_id T_NUM := T_NUM()
419 ,requested_quantity T_NUM := T_NUM()
420 ,requested_quantity2 T_NUM := T_NUM()
421 ,requested_quantity_uom2 T_V3 := T_V3()
422 ,revision T_V3 := T_V3()
423 ,carrier_id T_NUM := T_NUM()
424 ,tracking_number T_V30 := T_V30()
425 ,received_quantity T_NUM := T_NUM()
426 ,received_quantity2 T_NUM := T_NUM()
427 ,org_id T_NUM := T_NUM()
428 ,organization_id T_NUM := T_NUM()
429 /*added for inbound logistics*/
430 ,bill_of_lading T_V25 := T_V25()
431 ,days_early_receipt_allowed T_NUM := T_NUM()
432 ,days_late_receipt_allowed T_NUM := T_NUM()
433 ,delivered_quantity2 T_NUM := T_NUM()
434 ,expected_receipt_date T_DATE := T_DATE()
435 ,hold_code T_V1 := T_V1()
436 ,locator_id T_NUM := T_NUM()
437 ,lpn_id T_NUM := T_NUM()
438 ,num_of_containers T_NUM := T_NUM()
439 ,packing_slip_number T_V250 := T_V250()
440 ,po_shipment_line_id T_NUM := T_NUM()
441 ,po_shipment_line_number T_NUM := T_NUM()
442 ,qty_rcv_exception_code T_V30 := T_V30()
443 ,rcv_gross_weight T_NUM := T_NUM()
444 ,rcv_gross_weight_uom_code T_V3 := T_V3()
445 ,rcv_net_weight T_NUM := T_NUM()
446 ,rcv_net_weight_uom_code T_V3 := T_V3()
447 ,rcv_Tare_weight T_NUM := T_NUM()
448 ,rcv_Tare_weight_uom_code T_V3 := T_V3()
449 ,receipt_num T_V30 := T_V30()
450 ,received_quantity_uom T_V3 := T_V3()
451 ,received_quantity2_uom T_V3 := T_V3()
452 ,ship_from_site_id T_NUM := T_NUM()
453 ,shipment_header_id T_NUM := T_NUM()
454 ,shipment_line_id T_NUM := T_NUM()
455 ,shipment_num T_V30 := T_V30()
456 ,shipped_date T_DATE := T_DATE()
457 ,shipping_control T_V30 := T_V30()
458 ,source_blanket_reference_id T_NUM := T_NUM()
459 ,source_blanket_reference_num T_NUM := T_NUM()
460 ,source_code T_V30 := T_V30()
461 ,supplier_item_num T_V50 := T_V50()
462 ,vendor_id T_NUM := T_NUM()
463 ,vendor_party_id T_NUM := T_NUM()
464 ,rcv_transaction_id T_NUM := T_NUM()
465 ,rcv_parent_shipment_line_id T_NUM := T_NUM()
466 ,rcv_parent_shipment_header_id T_NUM := T_NUM()
467 ,status_code T_V30 := T_V30()
468 ,closed_flag T_V1 := T_V1()
469 ,closed_code T_V30 := T_V30()
470 ,source_line_type_code T_V30 := T_V30()
471 ,receipt_days_exception_code T_V25 := T_V25()
472 ,enforce_ship_to_location_code T_V25 := T_V25()
473 ,po_revision T_NUM := T_NUM()
474 ,release_revision T_NUM := T_NUM()
475 ,shipping_details_updated_on T_DATE := T_DATE()
476 ,rcv_ship_to_location_id T_NUM := T_NUM()
477 ,rcv_inventory_item_id T_NUM := T_NUM()
478 ,rcv_item_description T_V240 := T_V240()
479 ,rcv_country_of_origin T_V50 := T_V50()
480 ,rcv_revision T_V3 := T_V3()
481 ,rcv_carrier_id T_NUM := T_NUM()
482 ,rcv_freight_terms_code T_V30 := T_V30()
483 ,rcv_supplier_item_num T_V30 := T_V30()
484 ,rcv_preferred_grade T_V150 := T_V150() -- INVCONV
485 ,asn_type T_V30 := T_V30()
486 ,consolidate_quantity T_NUM := T_NUM()
487 ,truck_num T_V50 := T_V50()
488 ,container_num T_V50 := T_V50()
489 ,firm_demand_flag T_V1 := T_V1()
490 ,order_date_type_code T_V30 := T_V30()
491 ,xml_transaction_type_code T_V30 := T_V30()
492 -- added for end customer (bug 5054618)
493 , End_customer_contact_id T_NUM := T_NUM()
494 , End_customer_id T_NUM := T_NUM()
495 , End_customer_site_use_id T_NUM := T_NUM()
496 , IB_owner T_V30 := T_V30()
497 , IB_current_location T_V30 := T_V30()
498 , IB_Installed_at_Location T_V30 := T_V30()
499 , FULFILLMENT_BASE T_V1 := T_V1() --ER#14763609
500 );
501
502 -----------------------------------------------------------------
503 -- Global Line Record do these global and datatypes need to be here
504 -----------------------------------------------------------------
505 G_LINE_REC Line_Rec_Type;
506
507
508 END OE_WSH_BULK_GRP;