[Home] [Help]
PACKAGE: APPS.WSH_GLBL_VAR_STRCT_GRP
Source
1 PACKAGE WSH_GLBL_VAR_STRCT_GRP AS
2 /* $Header: WSHGVSGS.pls 120.6 2008/01/08 01:32:30 mvudugul ship $ */
3
4
5 --
6 -- this is a temporarily constant to used while WMS code is not ready
7 c_wms_code_present VARCHAR2(2) := 'Y';
8 c_skip_miss_info VARCHAR2(22) := 'WMS_WSH_SKIP_MISS_INFO';
9 --
10 --
11 TYPE LPNRecordType is RECORD (
12 tare_weight NUMBER,
13 tare_weight_uom_code VARCHAR2(10),
14 filled_volume_uom_code VARCHAR2(10)
15 );
16
17 TYPE dd_default_parameters_rec_type IS RECORD
18 (
19 --
20 quantity_to_cc NUMBER,
21 quantity2_to_cc NUMBER,
22 detail_group_params wsh_delivery_autocreate.grp_attr_rec_type
23 );
24 --
25 TYPE v3_Tbl_Type is TABLE of VARCHAR2(3) index by binary_integer;
26
27 TYPE v10_Tbl_Type is TABLE of VARCHAR2(10) index by binary_integer;
28 TYPE v50_Tbl_Type is TABLE of VARCHAR2(50) index by binary_integer;
29
30 TYPE num_Tbl_Type is TABLE of NUMBER index by binary_integer;
31
32
33 TYPE ContInfoRectype IS RECORD (
34 Lpn_ids wsh_util_core.id_tab_type,
35 Container_names v50_Tbl_Type
36 );
37
38 TYPE dd_action_out_rec_type IS RECORD
39 (
40 valid_id_tab WSH_UTIL_CORE.id_tab_type,
41 selection_issue_flag VARCHAR2(1),
42 delivery_id_tab WSH_UTIL_CORE.id_tab_type,
43 result_id_tab WSH_UTIL_CORE.id_tab_type,
44 split_quantity NUMBER,
45 split_quantity2 NUMBER,
46 source_header_id_tab wsh_util_core.id_tab_type,
47 source_line_id_tab wsh_util_core.id_tab_type,
48 quantity_tab wsh_util_core.id_tab_type,
49 source_code_id_tab v3_tbl_type);
50
51 --
52
53 TYPE ddActionsInOutRecType IS RECORD
54 (
55 split_quantity NUMBER,
56 split_quantity2 NUMBER
57 );
58 --
59 TYPE ddSerialRangeRecType IS RECORD
60 (
61 delivery_detail_id NUMBER,
62 from_serial_number VARCHAR2(30),
63 to_serial_number VARCHAR2(30),
64 quantity NUMBER,
65 attribute_category VARCHAR2(30),
66 attribute1 VARCHAR2(150),
67 attribute2 VARCHAR2(150),
68 attribute3 VARCHAR2(150),
69 attribute4 VARCHAR2(150),
70 attribute5 VARCHAR2(150),
71 attribute6 VARCHAR2(150),
72 attribute7 VARCHAR2(150),
73 attribute8 VARCHAR2(150),
74 attribute9 VARCHAR2(150),
75 attribute10 VARCHAR2(150),
76 attribute11 VARCHAR2(150),
77 attribute12 VARCHAR2(150),
78 attribute13 VARCHAR2(150),
79 attribute14 VARCHAR2(150),
80 attribute15 VARCHAR2(150)
81 );
82 --
83
84 TYPE ddSerialRangeTabType IS TABLE OF ddSerialRangeRecType
85 INDEX BY BINARY_INTEGER;
86
87 TYPE detailInRecType IS RECORD
88 (
89 --
90 caller VARCHAR2(100),
91 action_code VARCHAR2(100),
92 phase NUMBER,
93 container_item_id NUMBER,
94 container_item_name VARCHAR2(2000),
95 container_item_seg FND_FLEX_EXT.SegmentArray,
96 organization_id NUMBER,
97 organization_code VARCHAR2(3),
98 name_prefix VARCHAR2(30),
99 name_suffix VARCHAR2(30),
100 base_number NUMBER,
101 num_digits NUMBER,
102 quantity NUMBER,
103 container_name VARCHAR2(30),
104 lpn_ids wsh_util_core.id_tab_type,
105 ucc_128_suffix_flag NUMBER := 2
106 );
107
108 --
109 TYPE detailOutRecType IS RECORD
110 (
111 --
112 detail_ids WSH_UTIL_CORE.Id_Tab_Type
113 );
114
115
116
117 TYPE Delivery_Details_Rec_Type IS RECORD
118 (delivery_detail_id NUMBER,
119 source_code VARCHAR2(30),
120 source_header_id NUMBER,
121 source_line_id NUMBER,
122 customer_id NUMBER,
123 sold_to_contact_id NUMBER,
124 inventory_item_id NUMBER,
125 item_description VARCHAR2(250),
126 hazard_class_id NUMBER,
127 country_of_origin VARCHAR2(50),
128 classification VARCHAR2(30),
129 ship_from_location_id NUMBER,
130 ship_to_location_id NUMBER,
131 ship_to_contact_id NUMBER,
132 ship_to_site_use_id NUMBER,
133 deliver_to_location_id NUMBER,
134 deliver_to_contact_id NUMBER,
135 deliver_to_site_use_id NUMBER,
136 intmed_ship_to_location_id NUMBER,
137 intmed_ship_to_contact_id NUMBER,
138 hold_code VARCHAR2(1),
139 ship_tolerance_above NUMBER,
140 ship_tolerance_below NUMBER,
141 requested_quantity NUMBER,
142 shipped_quantity NUMBER,
143 delivered_quantity NUMBER,
144 requested_quantity_uom VARCHAR2(3),
145 subinventory VARCHAR2(10),
146 revision VARCHAR2(3),
147 lot_number VARCHAR2(80),
148 customer_requested_lot_flag VARCHAR2(1),
149 serial_number VARCHAR2(30),
150 locator_id NUMBER,
151 date_requested DATE,
152 date_scheduled DATE,
153 master_container_item_id NUMBER,
154 detail_container_item_id NUMBER,
155 load_seq_number NUMBER,
156 ship_method_code VARCHAR2(30),
157 carrier_id NUMBER,
158 freight_terms_code VARCHAR2(30),
159 shipment_priority_code VARCHAR2(30),
160 fob_code VARCHAR2(30),
161 customer_item_id NUMBER,
162 dep_plan_required_flag VARCHAR2(1),
163 customer_prod_seq VARCHAR2(50),
164 customer_dock_code VARCHAR2(50),
165 cust_model_serial_number VARCHAR2(50),
166 customer_job VARCHAR2(50),
167 customer_production_line VARCHAR2(50),
168 net_weight NUMBER,
169 weight_uom_code VARCHAR2(3),
170 volume NUMBER,
171 volume_uom_code VARCHAR2(3),
172 tp_attribute_category VARCHAR2(240),
173 tp_attribute1 VARCHAR2(240),
174 tp_attribute2 VARCHAR2(240),
175 tp_attribute3 VARCHAR2(240),
176 tp_attribute4 VARCHAR2(240),
177 tp_attribute5 VARCHAR2(240),
178 tp_attribute6 VARCHAR2(240),
179 tp_attribute7 VARCHAR2(240),
180 tp_attribute8 VARCHAR2(240),
181 tp_attribute9 VARCHAR2(240),
182 tp_attribute10 VARCHAR2(240),
183 tp_attribute11 VARCHAR2(240),
184 tp_attribute12 VARCHAR2(240),
185 tp_attribute13 VARCHAR2(240),
186 tp_attribute14 VARCHAR2(240),
187 tp_attribute15 VARCHAR2(240),
188 attribute_category VARCHAR2(150),
189 attribute1 VARCHAR2(150),
190 attribute2 VARCHAR2(150),
191 attribute3 VARCHAR2(150),
192 attribute4 VARCHAR2(150),
193 attribute5 VARCHAR2(150),
194 attribute6 VARCHAR2(150),
195 attribute7 VARCHAR2(150),
196 attribute8 VARCHAR2(150),
197 attribute9 VARCHAR2(150),
198 attribute10 VARCHAR2(150),
199 attribute11 VARCHAR2(150),
200 attribute12 VARCHAR2(150),
201 attribute13 VARCHAR2(150),
202 attribute14 VARCHAR2(150),
203 attribute15 VARCHAR2(150),
204 created_by NUMBER,
205 creation_date DATE,
206 last_update_date DATE,
207 last_update_login NUMBER,
208 last_updated_by NUMBER,
209 program_application_id NUMBER,
210 program_id NUMBER,
211 program_update_date DATE,
212 request_id NUMBER,
213 mvt_stat_status VARCHAR2(30),
214 released_flag VARCHAR2(1),
215 organization_id NUMBER,
216 transaction_temp_id NUMBER,
217 ship_set_id NUMBER,
218 arrival_set_id NUMBER,
219 ship_model_complete_flag VARCHAR2(1),
220 top_model_line_id NUMBER,
221 source_header_number VARCHAR2(150),
222 source_header_type_id NUMBER,
223 source_header_type_name VARCHAR2(240),
224 cust_po_number VARCHAR2(50),
225 ato_line_id NUMBER,
226 src_requested_quantity NUMBER,
227 src_requested_quantity_uom VARCHAR2(3),
228 move_order_line_id NUMBER,
229 cancelled_quantity NUMBER,
230 quality_control_quantity NUMBER,
231 cycle_count_quantity NUMBER,
232 tracking_number VARCHAR2(30),
233 movement_id NUMBER,
234 shipping_instructions VARCHAR2(2000),
235 packing_instructions VARCHAR2(2000),
236 project_id NUMBER,
237 task_id NUMBER,
238 org_id NUMBER,
239 oe_interfaced_flag VARCHAR2(1),
240 split_from_detail_id NUMBER,
241 inv_interfaced_flag VARCHAR2(1),
242 source_line_number VARCHAR2(150),
243 inspection_flag VARCHAR2(1),
244 released_status VARCHAR2(1),
245 container_flag VARCHAR2(1),
246 container_type_code VARCHAR2(30),
247 container_name VARCHAR2(30),
248 fill_percent NUMBER,
249 gross_weight NUMBER,
250 master_serial_number VARCHAR2(30),
251 maximum_load_weight NUMBER,
252 maximum_volume NUMBER,
253 minimum_fill_percent NUMBER,
254 seal_code VARCHAR2(30),
255 unit_number VARCHAR2(30),
256 unit_price NUMBER,
257 currency_code VARCHAR2(15),
258 freight_class_cat_id NUMBER,
259 commodity_code_cat_id NUMBER,
260 preferred_grade VARCHAR2(150),
261 src_requested_quantity2 NUMBER,
262 src_requested_quantity_uom2 VARCHAR2(3),
263 requested_quantity2 NUMBER,
264 shipped_quantity2 NUMBER,
265 delivered_quantity2 NUMBER,
266 cancelled_quantity2 NUMBER,
267 quality_control_quantity2 NUMBER,
268 cycle_count_quantity2 NUMBER,
269 requested_quantity_uom2 VARCHAR2(3),
270 lpn_id NUMBER ,
271 pickable_flag VARCHAR2(1),
272 original_subinventory VARCHAR2(10),
273 to_serial_number VARCHAR2(30),
274 picked_quantity NUMBER,
275 picked_quantity2 NUMBER,
276 received_quantity NUMBER,
277 received_quantity2 NUMBER,
278 source_line_set_id NUMBER,
279 batch_id NUMBER,
280 ROWID VARCHAR2(4000),
281 transaction_id NUMBER,
282 VENDOR_ID NUMBER,
283 SHIP_FROM_SITE_ID NUMBER,
284 LINE_DIRECTION VARCHAR2(30),
285 PARTY_ID NUMBER,
286 ROUTING_REQ_ID NUMBER,
287 SHIPPING_CONTROL VARCHAR2(30),
288 SOURCE_BLANKET_REFERENCE_ID NUMBER,
289 SOURCE_BLANKET_REFERENCE_NUM NUMBER,
290 PO_SHIPMENT_LINE_ID NUMBER,
291 PO_SHIPMENT_LINE_NUMBER NUMBER,
292 RETURNED_QUANTITY NUMBER,
293 RETURNED_QUANTITY2 NUMBER,
294 RCV_SHIPMENT_LINE_ID NUMBER,
295 SOURCE_LINE_TYPE_CODE VARCHAR2(30),
296 SUPPLIER_ITEM_NUMBER VARCHAR2(50),
297 IGNORE_FOR_PLANNING VARCHAR2(1),
298 EARLIEST_PICKUP_DATE DATE,
299 LATEST_PICKUP_DATE DATE,
300 EARLIEST_DROPOFF_DATE DATE,
301 LATEST_DROPOFF_DATE DATE,
302 REQUEST_DATE_TYPE_CODE VARCHAR2(30),
303 tp_delivery_detail_id NUMBER,
304 source_document_type_id NUMBER,
305 unit_weight NUMBER,
306 unit_volume NUMBER,
307 filled_volume NUMBER,
308 wv_frozen_flag VARCHAR2(1),
309 mode_of_transport VARCHAR2(30),
310 service_level VARCHAR2(30),
311 po_revision_number NUMBER,
312 release_revision_number NUMBER,
313 --bug# 6689448 (replenishment project)
314 replenishment_status VARCHAR2(1)
315 );
316
317 TYPE Delivery_Details_Attr_Tbl_Type is TABLE of
318 Delivery_Details_Rec_Type index by binary_integer;
319 TYPE dd_action_parameters_rec_type IS RECORD
320 (
321 -- Generic
322 Caller VARCHAR2(100),
323 Action_Code VARCHAR2(100),
324 Phase NUMBER,
325 -- Assign/Unassign
326 delivery_id NUMBER ,
327 delivery_name VARCHAR2(30),
328 -- Calculate weight and volume
329 wv_override_flag VARCHAR2(10),
330 -- Cycle Count
331 quantity_to_split NUMBER,
332 quantity2_to_split NUMBER,
333 -- Pack, Unpack
334 container_name VARCHAR2(30),
335 container_instance_id NUMBER,
336 container_flag VARCHAR2(1),
337 delivery_flag VARCHAR2(1),
338 lpn_rec Delivery_Details_Rec_Type,
339
340 -- Autopack
341 group_id_tab wsh_util_core.id_tab_type,
342 -- Split Line
343 split_quantity NUMBER,
344 split_quantity2 NUMBER,
345 -- Process Deliveries
346 group_by_header_flag VARCHAR(1),
347 -- bug# 6719369 (replenishment project): batch_id attribute is used by WMS for pick releasing replenishment completed dds
348 -- in dynamic replenishment case.
349 batch_id NUMBER
350 );
351
352 TYPE lpn_sync_comm_in_rec_type IS RECORD
353 (
354 dummy1 NUMBER
355 );
356
357 TYPE lpn_sync_comm_out_rec_type IS RECORD
358 (
359 dummy1 NUMBER
360 );
361
362
363 TYPE sync_tmp_rec_type
364 IS
365 RECORD
366 (
367 delivery_detail_id NUMBER,
368 parent_delivery_detail_id NUMBER,
369 delivery_id NUMBER,
370 operation_type VARCHAR2(10),
371 call_level NUMBER
372 );
373
374 TYPE sync_tmp_recTbl_type
375 IS
376 RECORD
377 (
378 delivery_detail_id_tbl num_tbl_type,
379 parent_detail_id_tbl num_tbl_type,
380 delivery_id_tbl num_tbl_type,
381 operation_type_tbl v10_tbl_type,
382 call_level num_tbl_type
383 );
384
385 TYPE purgeInOutRecType IS Record (
386 lpn_ids wsh_util_core.id_tab_type
387 );
388
389
390
391
392 END WSH_GLBL_VAR_STRCT_GRP;
393
394