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