[Home] [Help]
PACKAGE BODY: APPS.INV_MWB_GLOBALS
Source
1 PACKAGE BODY inv_mwb_globals AS
2 /* $Header: INVMWGLB.pls 120.14.12010000.5 2009/11/30 14:44:27 ksaripal ship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MWB_GLOBALS';
5
6 PROCEDURE mdebug(msg IN VARCHAR2) IS
7 BEGIN
8 INV_TRX_UTIL_PUB.TRACE( msg, g_pkg_name, 4 );
9 END mdebug;
10
11
12 PROCEDURE print_parameters IS
13 BEGIN
14
15 mdebug(' g_organization_id = '|| g_organization_id );
16 mdebug(' g_organization_code = '|| g_organization_code );
17 mdebug(' g_locator_id = '|| g_locator_id );
18 mdebug(' g_locator_name = '|| g_locator_name );
19 mdebug(' g_subinventory_code = '|| g_subinventory_code );
20 mdebug(' g_client_code = '|| g_client_code ); -- ER(9158529 client)
21 mdebug(' g_inventory_item_id = '|| g_inventory_item_id );
22 mdebug(' g_item_name = '|| g_item_name );
23 mdebug(' g_item_description = '|| g_item_description );
24
25 mdebug(' g_revision = '|| g_revision );
26 mdebug(' g_status_id = '|| g_status_id );
27 mdebug(' g_cost_group_id = '|| g_cost_group_id );
28 mdebug(' g_cost_group = '|| g_cost_group );
29 mdebug(' g_category_set_id = '|| g_category_set_id ); -- ER(9158529)
30 mdebug(' g_category_id = '|| g_category_id ); -- ER(9158529)
31 mdebug(' g_lpn_from = '|| g_lpn_from );
32 mdebug(' g_lpn_to = '|| g_lpn_to );
33 mdebug(' g_lpn_from_id = '|| g_lpn_from_id );
34 mdebug(' g_lpn_to_id = '|| g_lpn_to_id );
35 mdebug(' g_lot_from = '|| g_lot_from );
36 mdebug(' g_lot_to = '|| g_lot_to );
37 mdebug(' g_supplier_lot_from = '|| g_supplier_lot_from ); -- Bug 8396954
38 mdebug(' g_supplier_lot_to = '|| g_supplier_lot_to ); -- Bug 8396954
39 mdebug(' g_serial_from = '|| g_serial_from );
40 mdebug(' g_serial_to = '|| g_serial_to );
41 mdebug(' g_workbench_vb = '|| g_workbench_vb );
42 mdebug(' g_prepacked = '|| g_prepacked );
43 mdebug(' g_lpn_state = '|| g_lpn_state );
44 mdebug(' g_project_id = '|| g_project_id );
45 mdebug(' g_project_number = '|| g_project_number );
46 mdebug(' g_task_id = '|| g_task_id );
47 mdebug(' g_task_number = '|| g_task_number );
48 mdebug(' g_unit_number = '|| g_unit_number );
49 mdebug(' g_owning_party = '|| g_owning_party );
50 mdebug(' g_planning_party = '|| g_planning_party );
51 mdebug(' g_planning_org = '|| g_planning_org );
52 mdebug(' g_owning_org = '|| g_owning_org );
53 mdebug(' g_po_header_id = '|| g_po_header_id );
54 mdebug(' g_po_release_id = '|| g_po_release_id );
55 mdebug(' g_shipment_header_id_asn = '|| g_shipment_header_id_asn );
56 mdebug(' g_shipment_header_id_interorg = '|| g_shipment_header_id_interorg);
57 mdebug(' g_req_header_id = '|| g_req_header_id );
58 mdebug(' g_vendor_id = '|| g_vendor_id );
59 mdebug(' g_vendor_site_id = '|| g_vendor_site_id );
60 mdebug(' g_source_org_id = '|| g_source_org_id );
61 mdebug(' g_chk_inbound = '|| g_chk_inbound );
62 mdebug(' g_chk_receiving = '|| g_chk_receiving );
63 mdebug(' g_chk_onhand = '|| g_chk_onhand );
64 mdebug(' g_include_po_without_asn = '|| g_include_po_without_asn );
65 mdebug(' g_expected_from_date = '|| g_expected_from_date );
66 mdebug(' g_expected_to_date = '|| g_expected_to_date );
67 mdebug(' g_internal_order_id = '|| g_internal_order_id );
68 mdebug(' g_vendor_item = '|| g_vendor_item );
69 mdebug(' g_grade_from_code = '|| g_grade_from_code );
70 mdebug(' g_planning_query_mode = '|| g_planning_query_mode );
71 mdebug(' g_owning_qry_mode = '|| g_owning_qry_mode );
72 mdebug(' g_wms_enabled_flag = '|| g_wms_enabled_flag );
73 mdebug(' g_sub_type = '|| g_sub_type );
74 mdebug(' g_rcv_query_mode = '|| g_rcv_query_mode );
75 mdebug(' g_detailed = '|| g_detailed );
76 mdebug(' g_qty_from = '|| g_qty_from );
77 mdebug(' g_qty_to = '|| g_qty_to );
78 mdebug(' g_locator_control_code = '|| g_locator_control_code );
79 mdebug(' g_wms_installed_flag = '|| g_wms_installed_flag );
80 mdebug(' g_check = '|| g_check );
81 mdebug(' g_serial_attr_query = '|| g_serial_attr_query ); -- Bug 6429880
82 mdebug(' g_lot_attr_query = '|| g_lot_attr_query ); -- Bug 7566588
83 mdebug(' g_responsibility_id = '|| g_responsibility_id );
84 mdebug(' g_resp_application_id = '|| g_resp_application_id );
85 mdebug(' g_mln_context_code = '|| g_mln_context_code );
86 mdebug(' g_msn_context_code = '|| g_msn_context_code );
87 mdebug(' g_grade_controlled = '|| g_grade_controlled );
88 mdebug(' g_serial_controlled = '|| g_serial_controlled );
89 mdebug(' g_lot_controlled = '|| g_lot_controlled );
90 mdebug(' g_only_locator_status = '|| g_only_locator_status );
91 mdebug(' g_only_subinventory_status = '|| g_only_subinventory_status );
92 mdebug(' g_containerized = '|| g_containerized );
93 mdebug(' g_locator_controlled = '|| g_locator_controlled );
94 mdebug(' g_inserted_under_org = '|| g_inserted_under_org );
95 mdebug(' g_revision_controlled = '|| g_revision_controlled );
96 mdebug(' g_only_lot_status = '|| g_only_lot_status );
97 mdebug(' g_only_serial_status = '|| g_only_serial_status );
98 mdebug(' g_view_by = '|| g_view_by );
99 mdebug(' g_status = '|| g_status );
100 mdebug(' g_tree_organization_id = '|| g_tree_organization_id );
101 mdebug(' g_tree_loc_id = '|| g_tree_loc_id );
102 mdebug(' g_tree_item_id = '|| g_tree_item_id );
103 mdebug(' g_tree_subinventory_code = '|| g_tree_subinventory_code );
104 mdebug(' g_tree_parent_lpn_id = '|| g_tree_parent_lpn_id );
105 mdebug(' g_tree_mat_loc_id = '|| g_tree_mat_loc_id );
106 mdebug(' g_tree_doc_type_id = '|| g_tree_doc_type_id );
107 mdebug(' g_tree_doc_num = '|| g_tree_doc_num );
108 mdebug(' g_tree_doc_header_id = '|| g_tree_doc_header_id );
109 mdebug(' g_tree_st_id = '|| g_tree_st_id );
110 mdebug(' g_tree_rev = '|| g_tree_rev );
111 mdebug(' g_tree_cg_id = '|| g_tree_cg_id );
112 mdebug(' g_tree_grade_code = '|| g_tree_grade_code );
113 mdebug(' g_tree_serial_number = '|| g_tree_serial_number );
114 mdebug(' g_tree_lot_number = '|| g_tree_lot_number );
115 mdebug(' g_tree_node_type = '|| g_tree_node_type );
116 mdebug(' g_tree_node_value = '|| g_tree_node_value );
117 mdebug(' g_tree_node_state = '|| g_tree_node_state );
118 mdebug(' g_tree_node_high_value = '|| g_tree_node_high_value );
119 mdebug(' g_tree_node_low_value = '|| g_tree_node_low_value );
120 mdebug(' g_tree_serial_attr_query = '|| g_tree_serial_attr_query );
121 mdebug(' g_tree_attribute_qf_lot = '|| g_tree_attribute_qf_lot );
122 mdebug(' g_tree_attribute_qf_serial = '|| g_tree_attribute_qf_serial );
123 mdebug(' g_tree_query_lot_attr = '|| g_tree_query_lot_attr );
124 mdebug(' g_tree_query_serial_attr = '|| g_tree_query_serial_attr );
125 mdebug(' g_tree_lot_attr_query = '|| g_tree_lot_attr_query );
126 mdebug(' g_tree_event = '|| g_tree_event );
127 mdebug(' g_lot_context = '|| g_lot_context );
128 mdebug(' g_serial_context = '|| g_serial_context );
129 mdebug(' g_is_projects_enabled_org = '|| g_is_projects_enabled_org );
130 mdebug(' g_multiple_loc_selected = '|| g_multiple_loc_selected );
131 --KMOTUPAL ME # 3922793
132 mdebug(' g_expired_lots = '|| g_expired_lots );
133 mdebug(' g_expiration_date = '|| g_expiration_date );
134 mdebug(' g_parent_lot = '|| g_parent_lot ); -- BUG 7556505
135 mdebug(' g_shipment_header_id = '|| g_shipment_header_id ); -- BUG 6633612
136
137 END print_parameters;
138
139 PROCEDURE print_msg(
140 p_package IN VARCHAR2
141 , p_procedure IN VARCHAR2
142 , p_msg IN VARCHAR2
143 ) IS
144 BEGIN
145
146 INV_TRX_UTIL_PUB.TRACE( p_msg, p_package||'.'||p_procedure, 4 );
147
148 END print_msg;
149
150 PROCEDURE dump_parameters IS
151 PRAGMA AUTONOMOUS_TRANSACTION;
152
153 sql_stmt LONG;
154 BEGIN
155 null;
156
157 /* sql_stmt := ' INSERT into inv_mwb_test_set(
158 g_id
159 , g_organization_code
160 , g_locator_name
161 , g_item_name
162 , g_cost_group
163 , g_project_number
164 , g_task_number
165 , g_owning_party
166 , g_planning_party
167 , g_lpn_state
168 , g_status
169 , g_last_query
170 , g_organization_id
171 , g_locator_id
172 , g_subinventory_code
173 , g_inventory_item_id
174 , g_revision
175 , g_status_id
176 , g_cost_group_id
177 , g_lpn_from
178 , g_lpn_to
179 , g_lpn_from_id
180 , g_lpn_to_id
181 , g_lot_from
182 , g_lot_to
183 , g_serial_from
184 , g_serial_to
185 , g_workbench_vb
186 , g_prepacked
187 , g_project_id
188 , g_task_id
189 , g_unit_number
190 , g_planning_org
191 , g_owning_org
192 , g_po_header_id
193 , g_po_release_id
194 , g_shipment_header_id_asn
195 , g_shipment_header_id_interorg
196 , g_req_header_id
197 , g_vendor_id
198 , g_vendor_site_id
199 , g_source_org_id
200 , g_chk_inbound
201 , g_chk_receiving
202 , g_chk_onhand
203 , g_include_po_without_asn
204 , g_expected_from_date
205 , g_expected_to_date
206 , g_internal_order_id
207 , g_vendor_item
208 , g_grade_from_code
209 , g_planning_query_mode
210 , g_owning_qry_mode
211 , g_wms_enabled_flag
212 , g_sub_type
213 , g_rcv_query_mode
214 , g_detailed
215 , g_item_description
216 , g_qty_from
217 , g_qty_to
218 , g_locator_control_code
219 , g_wms_installed_flag
220 , g_check
221 , g_responsibility_id
222 , g_resp_application_id
223 , g_mln_context_code
224 , g_msn_context_code
225 , g_grade_controlled
226 , g_serial_controlled
227 , g_lot_controlled
228 , g_only_locator_status
229 , g_only_subinventory_status
230 , g_containerized
231 , g_locator_controlled
232 , g_inserted_under_org
233 , g_revision_controlled
234 , g_only_lot_status
235 , g_only_serial_status
236 , g_view_by
237 , g_multiple_loc_selected
238 , g_tree_organization_id
239 , g_tree_loc_id
240 , g_tree_item_id
241 , g_tree_subinventory_code
242 , g_tree_parent_lpn_id
243 , g_tree_mat_loc_id
244 , g_tree_doc_type_id
245 , g_tree_doc_num
246 , g_tree_doc_header_id
247 , g_tree_st_id
248 , g_tree_rev
249 , g_tree_cg_id
250 , g_tree_grade_code
251 , g_tree_serial_number
252 , g_tree_lot_number
253 , g_tree_node_type
254 , g_tree_node_value
255 , g_tree_node_state
256 , g_tree_node_high_value
257 , g_tree_node_low_value
258 , g_tree_serial_attr_query
259 , g_tree_attribute_qf_lot
260 , g_tree_attribute_qf_serial
261 , g_tree_query_lot_attr
262 , g_tree_query_serial_attr
263 , g_tree_lot_attr_query
264 , g_tree_event
265 , g_lot_context
266 , g_serial_context
267 , g_is_projects_enabled_org
268 , g_is_nested_lpn
269 ) VALUES (
270 inv_mwb_test_set_s.NEXTVAL
271 :g_organization_code
272 :g_locator_name
273 :g_item_name
274 :g_cost_group
275 :g_project_number
276 :g_task_number
277 :g_owning_party
278 :g_planning_party
279 :g_lpn_state
280 :g_status
281 :g_last_query
282 :g_organization_id
283 :g_locator_id
284 :g_subinventory_code
285 :g_inventory_item_id
286 :g_revision
287 :g_status_id
288 :g_cost_group_id
289 :g_lpn_from
290 :g_lpn_to
291 :g_lpn_from_id
292 :g_lpn_to_id
293 :g_lot_from
294 :g_lot_to
295 :g_serial_from
296 :g_serial_to
297 :g_workbench_vb
298 :g_prepacked
299 :g_project_id
300 :g_task_id
301 :g_unit_number
302 :g_planning_org
303 :g_owning_org
304 :g_po_header_id
305 :g_po_release_id
306 :g_shipment_header_id_asn
307 :g_shipment_header_id_interorg
308 :g_req_header_id
309 :g_vendor_id
310 :g_vendor_site_id
311 :g_source_org_id
312 :g_chk_inbound
313 :g_chk_receiving
314 :g_chk_onhand
315 :g_include_po_without_asn
316 :g_expected_from_date
317 :g_expected_to_date
318 :g_internal_order_id
322 :g_owning_qry_mode
319 :g_vendor_item
320 :g_grade_from_code
321 :g_planning_query_mode
323 :g_wms_enabled_flag
324 :g_sub_type
325 :g_rcv_query_mode
326 :g_detailed
327 :g_item_description
328 :g_qty_from
329 :g_qty_to
330 :g_locator_control_code
331 :g_wms_installed_flag
332 :g_check
333 :g_responsibility_id
334 :g_resp_application_id
335 :g_mln_context_code
336 :g_msn_context_code
337 :g_grade_controlled
338 :g_serial_controlled
339 :g_lot_controlled
340 :g_only_locator_status
341 :g_only_subinventory_status
342 :g_containerized
343 :g_locator_controlled
344 :g_inserted_under_org
345 :g_revision_controlled
346 :g_only_lot_status
347 :g_only_serial_status
348 :g_view_by
349 :g_multiple_loc_selected
350 :g_tree_organization_id
351 :g_tree_loc_id
352 :g_tree_item_id
353 :g_tree_subinventory_code
354 :g_tree_parent_lpn_id
355 :g_tree_mat_loc_id
356 :g_tree_doc_type_id
357 :g_tree_doc_num
358 :g_tree_doc_header_id
359 :g_tree_st_id
360 :g_tree_rev
361 :g_tree_cg_id
362 :g_tree_grade_code
363 :g_tree_serial_number
364 :g_tree_lot_number
365 :g_tree_node_type
366 :g_tree_node_value
367 :g_tree_node_state
368 :g_tree_node_high_value
369 :g_tree_node_low_value
370 :g_tree_serial_attr_query
371 :g_tree_attribute_qf_lot
372 :g_tree_attribute_qf_serial
373 :g_tree_query_lot_attr
374 :g_tree_query_serial_attr
375 :g_tree_lot_attr_query
376 :g_tree_event
377 :g_lot_context
378 :g_serial_context
379 :g_is_projects_enabled_org
380 :g_is_nested_lpn
381 ) ';
382
383
384
385 EXECUTE IMMEDIATE sql_stmt USING
386 g_organization_code
387 , g_locator_name
388 , g_item_name
389 , g_cost_group
390 , g_project_number
391 , g_task_number
392 , g_owning_party
393 , g_planning_party
394 , g_lpn_state
395 , g_status
396 , g_last_query
397 , g_organization_id
398 , g_locator_id
399 , g_subinventory_code
400 , g_inventory_item_id
401 , g_revision
402 , g_status_id
403 , g_cost_group_id
404 , g_lpn_from
405 , g_lpn_to
406 , g_lpn_from_id
407 , g_lpn_to_id
408 , g_lot_from
409 , g_lot_to
410 , g_serial_from
411 , g_serial_to
412 , g_workbench_vb
413 , g_prepacked
414 , g_project_id
415 , g_task_id
416 , g_unit_number
417 , g_planning_org
418 , g_owning_org
419 , g_po_header_id
420 , g_po_release_id
421 , g_shipment_header_id_asn
422 , g_shipment_header_id_interorg
423 , g_req_header_id
424 , g_vendor_id
425 , g_vendor_site_id
426 , g_source_org_id
427 , g_chk_inbound
428 , g_chk_receiving
429 , g_chk_onhand
430 , g_include_po_without_asn
431 , g_expected_from_date
432 , g_expected_to_date
433 , g_internal_order_id
434 , g_vendor_item
435 , g_grade_from_code
436 , g_planning_query_mode
437 , g_owning_qry_mode
438 , g_wms_enabled_flag
439 , g_sub_type
440 , g_rcv_query_mode
441 , g_detailed
442 , g_item_description
443 , g_qty_from
444 , g_qty_to
445 , g_locator_control_code
446 , g_wms_installed_flag
447 , g_check
448 , g_responsibility_id
449 , g_resp_application_id
450 , g_mln_context_code
451 , g_msn_context_code
452 , g_grade_controlled
453 , g_serial_controlled
454 , g_lot_controlled
455 , g_only_locator_status
456 , g_only_subinventory_status
457 , g_containerized
458 , g_locator_controlled
459 , g_inserted_under_org
460 , g_revision_controlled
461 , g_only_lot_status
462 , g_only_serial_status
463 , g_view_by
464 , g_multiple_loc_selected
465 , g_tree_organization_id
466 , g_tree_loc_id
467 , g_tree_item_id
468 , g_tree_subinventory_code
469 , g_tree_parent_lpn_id
470 , g_tree_mat_loc_id
471 , g_tree_doc_type_id
472 , g_tree_doc_num
473 , g_tree_doc_header_id
474 , g_tree_st_id
475 , g_tree_rev
479 , g_tree_lot_number
476 , g_tree_cg_id
477 , g_tree_grade_code
478 , g_tree_serial_number
480 , g_tree_node_type
481 , g_tree_node_value
482 , g_tree_node_state
483 , g_tree_node_high_value
484 , g_tree_node_low_value
485 , g_tree_serial_attr_query
486 , g_tree_attribute_qf_lot
487 , g_tree_attribute_qf_serial
488 , g_tree_query_lot_attr
489 , g_tree_query_serial_attr
490 , g_tree_lot_attr_query
491 , g_tree_event
492 , g_lot_context
493 , g_serial_context
494 , g_is_projects_enabled_org
495 , g_is_nested_lpn;
496 */
497
498 /* INSERT INTO inv_mwb_test_set (
499 g_id ,
500 g_organization_code ,
501 g_locator_name ,
502 g_item_name ,
503 g_cost_group ,
504 g_project_number ,
505 g_task_number ,
506 g_owning_party ,
507 g_planning_party ,
508 g_lpn_state ,
509 g_status ,
510 g_last_query ,
511 g_organization_id ,
512 g_locator_id ,
513 g_subinventory_code ,
514 g_inventory_item_id ,
515 g_revision ,
516 g_status_id ,
517 g_cost_group_id ,
518 g_lpn_from ,
519 g_lpn_to ,
520 g_lpn_from_id ,
521 g_lpn_to_id ,
522 g_lot_from ,
523 g_lot_to ,
524 g_serial_from ,
525 g_serial_to ,
526 g_workbench_vb ,
527 g_prepacked ,
528 g_project_id ,
529 g_task_id ,
530 g_unit_number ,
531 g_planning_org ,
532 g_owning_org ,
533 g_po_header_id ,
534 g_po_release_id ,
535 g_shipment_header_id_asn ,
536 g_shipment_header_id_interorg ,
537 g_req_header_id ,
538 g_vendor_id ,
539 g_vendor_site_id ,
540 g_source_org_id ,
541 g_chk_inbound ,
542 g_chk_receiving ,
543 g_chk_onhand ,
544 g_include_po_without_asn ,
545 g_expected_from_date ,
546 g_expected_to_date ,
547 g_internal_order_id ,
548 g_vendor_item ,
549 g_grade_from_code ,
550 g_planning_query_mode ,
551 g_owning_qry_mode ,
552 g_wms_enabled_flag ,
553 g_sub_type ,
554 g_rcv_query_mode ,
555 g_detailed ,
556 g_item_description ,
557 g_qty_from ,
558 g_qty_to ,
559 g_locator_control_code ,
560 g_wms_installed_flag ,
561 g_check ,
562 g_responsibility_id ,
563 g_resp_application_id ,
564 g_mln_context_code ,
565 g_msn_context_code ,
566 g_grade_controlled ,
567 g_serial_controlled ,
568 g_lot_controlled ,
569 g_only_locator_status ,
570 g_only_subinventory_status ,
571 g_containerized ,
572 g_locator_controlled ,
573 g_inserted_under_org ,
574 g_revision_controlled ,
575 g_only_lot_status ,
576 g_only_serial_status ,
577 g_view_by ,
578 g_multiple_loc_selected ,
579 g_tree_organization_id ,
580 g_tree_loc_id ,
581 g_tree_item_id ,
582 g_tree_subinventory_code ,
583 g_tree_parent_lpn_id ,
584 g_tree_mat_loc_id ,
585 g_tree_doc_type_id ,
586 g_tree_doc_num ,
587 g_tree_doc_header_id ,
591 g_tree_grade_code ,
588 g_tree_st_id ,
589 g_tree_rev ,
590 g_tree_cg_id ,
592 g_tree_serial_number ,
593 g_tree_lot_number ,
594 g_tree_node_type ,
595 g_tree_node_value ,
596 g_tree_node_state ,
597 g_tree_node_high_value ,
598 g_tree_node_low_value ,
599 g_tree_serial_attr_query ,
600 g_tree_attribute_qf_lot ,
601 g_tree_attribute_qf_serial ,
602 g_tree_query_lot_attr ,
603 g_tree_query_serial_attr ,
604 g_tree_lot_attr_query ,
605 g_tree_event ,
606 g_lot_context ,
607 g_serial_context ,
608 g_is_projects_enabled_org ,
609 g_is_nested_lpn
610 )
611 VALUES (
612 inv_mwb_test_set_s.nextval ,
613 g_organization_code ,
614 g_locator_name ,
615 g_item_name ,
616 g_cost_group ,
617 g_project_number ,
618 g_task_number ,
619 g_owning_party ,
620 g_planning_party ,
621 g_lpn_state ,
622 g_status ,
623 g_last_query ,
624 g_organization_id ,
625 g_locator_id ,
626 g_subinventory_code ,
627 g_inventory_item_id ,
628 g_revision ,
629 g_status_id ,
630 g_cost_group_id ,
631 g_lpn_from ,
632 g_lpn_to ,
633 g_lpn_from_id ,
634 g_lpn_to_id ,
635 g_lot_from ,
636 g_lot_to ,
637 g_serial_from ,
638 g_serial_to ,
639 g_workbench_vb ,
640 g_prepacked ,
641 g_project_id ,
642 g_task_id ,
643 g_unit_number ,
644 g_planning_org ,
645 g_owning_org ,
646 g_po_header_id ,
647 g_po_release_id ,
648 g_shipment_header_id_asn ,
649 g_shipment_header_id_interorg ,
650 g_req_header_id ,
651 g_vendor_id ,
652 g_vendor_site_id ,
653 g_source_org_id ,
654 g_chk_inbound ,
655 g_chk_receiving ,
656 g_chk_onhand ,
657 g_include_po_without_asn ,
658 g_expected_from_date ,
659 g_expected_to_date ,
660 g_internal_order_id ,
661 g_vendor_item ,
662 g_grade_from_code ,
663 g_planning_query_mode ,
664 g_owning_qry_mode ,
665 g_wms_enabled_flag ,
666 g_sub_type ,
667 g_rcv_query_mode ,
668 g_detailed ,
669 g_item_description ,
670 g_qty_from ,
671 g_qty_to ,
672 g_locator_control_code ,
673 g_wms_installed_flag ,
674 g_check ,
675 g_responsibility_id ,
676 g_resp_application_id ,
677 g_mln_context_code ,
678 g_msn_context_code ,
679 g_grade_controlled ,
680 g_serial_controlled ,
681 g_lot_controlled ,
682 g_only_locator_status ,
683 g_only_subinventory_status ,
684 g_containerized ,
685 g_locator_controlled ,
686 g_inserted_under_org ,
687 g_revision_controlled ,
688 g_only_lot_status ,
689 g_only_serial_status ,
690 g_view_by ,
691 g_multiple_loc_selected ,
692 g_tree_organization_id ,
693 g_tree_loc_id ,
694 g_tree_item_id ,
695 g_tree_subinventory_code ,
696 g_tree_parent_lpn_id ,
697 g_tree_mat_loc_id ,
698 g_tree_doc_type_id ,
699 g_tree_doc_num ,
700 g_tree_doc_header_id ,
701 g_tree_st_id ,
702 g_tree_rev ,
703 g_tree_cg_id ,
704 g_tree_grade_code ,
705 g_tree_serial_number ,
706 g_tree_lot_number ,
707 g_tree_node_type ,
708 g_tree_node_value ,
709 g_tree_node_state ,
710 g_tree_node_high_value ,
711 g_tree_node_low_value ,
712 g_tree_serial_attr_query ,
713 g_tree_attribute_qf_lot ,
714 g_tree_attribute_qf_serial ,
715 g_tree_query_lot_attr ,
716 g_tree_query_serial_attr ,
717 g_tree_lot_attr_query ,
718 g_tree_event ,
719 g_lot_context ,
720 g_serial_context ,
721 g_is_projects_enabled_org ,
722 g_is_nested_lpn
723 );
724
725
726 COMMIT;
727 EXCEPTION
728 WHEN OTHERS THEN
729 RAISE;
730 --null;
731 */
732 END dump_parameters;
733
734 end inv_mwb_globals;