eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MWB_STATUS_TREE dependencies on INV_MWB_GLOBALS

Line 23: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

19: BEGIN
20:
21: l_procedure_name := 'ROOT_NODE_EVENT';
22:
23: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
24: inv_mwb_tree1.add_statuses(
25: x_node_value
26: , x_node_tbl
27: , x_tbl_index

Line 48: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

44: BEGIN
45:
46: l_procedure_name := 'STATUS_NODE_EVENT';
47:
48: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
49: inv_mwb_tree1.add_orgs(
50: x_node_value
51: , x_node_tbl
52: , x_tbl_index

Line 74: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

70: BEGIN
71:
72: l_procedure_name := 'ONHAND_NODE_EVENT';
73:
74: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
75: make_common_queries('MOQD');
76: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
77: 'moqd.inventory_item_id';
78: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=

Line 106: inv_mwb_globals.g_tree_st_id

102: 'ONHAND'
103: );
104: inv_mwb_query_manager.add_bind_variable(
105: 'onh_tree_status_id',
106: inv_mwb_globals.g_tree_st_id
107: );
108: inv_mwb_query_manager.execute_query;
109:
110: END IF;

Line 131: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

127: BEGIN
128:
129: l_procedure_name := 'ORG_NODE_EVENT';
130:
131: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
132: l_default_status_id := inv_cache.org_rec.default_status_id;
133: end if;
134:
135: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'default org status id: '||l_default_status_id);

Line 135: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'default org status id: '||l_default_status_id);

131: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
132: l_default_status_id := inv_cache.org_rec.default_status_id;
133: end if;
134:
135: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'default org status id: '||l_default_status_id);
136:
137: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
138:
139: If l_default_status_id is not null then -- Onhand Material Status Support

Line 137: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

133: end if;
134:
135: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'default org status id: '||l_default_status_id);
136:
137: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
138:
139: If l_default_status_id is not null then -- Onhand Material Status Support
140: x_node_tbl(i).state := -1;
141: x_node_tbl(i).depth := 1;

Line 186: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

182: x_node_tbl(i).icon := 'affldhdr';
183: x_node_tbl(i).value := 'SERIAL_FOLDER';
184: x_node_tbl(i).type := 'SERIAL_FOLDER';
185: END IF;
186: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
187:
188: NULL;
189:
190: END IF;

Line 208: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

204: BEGIN
205:
206: l_procedure_name := 'SUB_FOLDER_NODE_EVENT';
207:
208: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
209: inv_mwb_tree1.add_subs(
210: x_node_value
211: , x_node_tbl
212: , x_tbl_index

Line 215: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

211: , x_node_tbl
212: , x_tbl_index
213: );
214:
215: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
216:
217: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
218: inv_mwb_globals.g_serial_to IS NOT NULL )
219: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 217: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND

213: );
214:
215: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
216:
217: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
218: inv_mwb_globals.g_serial_to IS NOT NULL )
219: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
220:
221: make_common_queries('MSN_QUERY');

Line 218: inv_mwb_globals.g_serial_to IS NOT NULL )

214:
215: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
216:
217: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
218: inv_mwb_globals.g_serial_to IS NOT NULL )
219: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
220:
221: make_common_queries('MSN_QUERY');
222: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 219: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

215: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
216:
217: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
218: inv_mwb_globals.g_serial_to IS NOT NULL )
219: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
220:
221: make_common_queries('MSN_QUERY');
222: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
223: 'msn.current_subinventory_code';

Line 264: inv_mwb_globals.g_tree_st_id

260: 'ONHAND'
261: );
262: inv_mwb_query_manager.add_bind_variable(
263: 'onh_tree_status_id',
264: inv_mwb_globals.g_tree_st_id
265: );
266: inv_mwb_query_manager.add_bind_variable(
267: 'onh_tree_organization_id',
268: inv_mwb_globals.g_tree_organization_id

Line 268: inv_mwb_globals.g_tree_organization_id

264: inv_mwb_globals.g_tree_st_id
265: );
266: inv_mwb_query_manager.add_bind_variable(
267: 'onh_tree_organization_id',
268: inv_mwb_globals.g_tree_organization_id
269: );
270: inv_mwb_query_manager.execute_query;
271:
272: END IF;

Line 291: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

287: BEGIN
288:
289: l_procedure_name := 'LOC_FOLDER_NODE_EVENT';
290:
291: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
292: inv_mwb_tree1.add_locs(
293: x_node_value
294: , x_node_tbl
295: , x_tbl_index

Line 298: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

294: , x_node_tbl
295: , x_tbl_index
296: );
297:
298: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
299:
300: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
301: inv_mwb_globals.g_serial_to IS NOT NULL )
302: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 300: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND

296: );
297:
298: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
299:
300: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
301: inv_mwb_globals.g_serial_to IS NOT NULL )
302: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
303:
304: make_common_queries('MSN_QUERY');

Line 301: inv_mwb_globals.g_serial_to IS NOT NULL )

297:
298: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
299:
300: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
301: inv_mwb_globals.g_serial_to IS NOT NULL )
302: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
303:
304: make_common_queries('MSN_QUERY');
305: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 302: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

298: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
299:
300: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
301: inv_mwb_globals.g_serial_to IS NOT NULL )
302: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
303:
304: make_common_queries('MSN_QUERY');
305: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
306: 'msn.current_locator_id';

Line 355: inv_mwb_globals.g_tree_st_id

351: 'ONHAND'
352: );
353: inv_mwb_query_manager.add_bind_variable(
354: 'onh_tree_status_id',
355: inv_mwb_globals.g_tree_st_id
356: );
357: inv_mwb_query_manager.add_bind_variable(
358: 'onh_tree_organization_id',
359: inv_mwb_globals.g_tree_organization_id

Line 359: inv_mwb_globals.g_tree_organization_id

355: inv_mwb_globals.g_tree_st_id
356: );
357: inv_mwb_query_manager.add_bind_variable(
358: 'onh_tree_organization_id',
359: inv_mwb_globals.g_tree_organization_id
360: );
361: inv_mwb_query_manager.execute_query;
362:
363: END IF;

Line 381: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

377: BEGIN
378:
379: l_procedure_name := 'LOT_FOLDER_NODE_EVENT';
380:
381: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
382: inv_mwb_tree1.add_lots(
383: x_node_value
384: , x_node_tbl
385: , x_tbl_index

Line 388: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

384: , x_node_tbl
385: , x_tbl_index
386: );
387:
388: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
389:
390: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
391: inv_mwb_globals.g_serial_to IS NOT NULL )
392: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 390: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND

386: );
387:
388: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
389:
390: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
391: inv_mwb_globals.g_serial_to IS NOT NULL )
392: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
393:
394: make_common_queries('MSN_QUERY');

Line 391: inv_mwb_globals.g_serial_to IS NOT NULL )

387:
388: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
389:
390: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
391: inv_mwb_globals.g_serial_to IS NOT NULL )
392: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
393:
394: make_common_queries('MSN_QUERY');
395: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 392: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

388: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
389:
390: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
391: inv_mwb_globals.g_serial_to IS NOT NULL )
392: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
393:
394: make_common_queries('MSN_QUERY');
395: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
396: 'msn.lot_number';

Line 451: inv_mwb_globals.g_tree_st_id

447: 'ONHAND'
448: );
449: inv_mwb_query_manager.add_bind_variable(
450: 'onh_tree_status_id',
451: inv_mwb_globals.g_tree_st_id
452: );
453: inv_mwb_query_manager.add_bind_variable(
454: 'onh_tree_organization_id',
455: inv_mwb_globals.g_tree_organization_id

Line 455: inv_mwb_globals.g_tree_organization_id

451: inv_mwb_globals.g_tree_st_id
452: );
453: inv_mwb_query_manager.add_bind_variable(
454: 'onh_tree_organization_id',
455: inv_mwb_globals.g_tree_organization_id
456: );
457: inv_mwb_query_manager.execute_query;
458:
459: END IF;

Line 478: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN

474: BEGIN
475:
476: l_procedure_name := 'SERIAL_FOLDER_NODE_EVENT';
477:
478: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
479: inv_mwb_tree1.add_serials(
480: x_node_value
481: , x_node_tbl
482: , x_tbl_index

Line 485: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

481: , x_node_tbl
482: , x_tbl_index
483: );
484:
485: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
486:
487: make_common_queries('MSN');
488: inv_mwb_query_manager.add_where_clause(
489: 'msn.current_organization_id = :onh_tree_organization_id',

Line 498: inv_mwb_globals.g_tree_st_id

494: 'ONHAND'
495: );
496: inv_mwb_query_manager.add_bind_variable(
497: 'onh_tree_status_id',
498: inv_mwb_globals.g_tree_st_id
499: );
500: inv_mwb_query_manager.add_bind_variable(
501: 'onh_tree_organization_id',
502: inv_mwb_globals.g_tree_organization_id

Line 502: inv_mwb_globals.g_tree_organization_id

498: inv_mwb_globals.g_tree_st_id
499: );
500: inv_mwb_query_manager.add_bind_variable(
501: 'onh_tree_organization_id',
502: inv_mwb_globals.g_tree_organization_id
503: );
504: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
505: inv_mwb_query_manager.execute_query;
506:

Line 526: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

522: BEGIN
523:
524: l_procedure_name := 'SUB_NODE_EVENT';
525:
526: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
527:
528: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
529: inv_mwb_globals.g_serial_to IS NOT NULL )
530: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 528: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND

524: l_procedure_name := 'SUB_NODE_EVENT';
525:
526: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
527:
528: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
529: inv_mwb_globals.g_serial_to IS NOT NULL )
530: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
531:
532: make_common_queries('MSN_QUERY');

Line 529: inv_mwb_globals.g_serial_to IS NOT NULL )

525:
526: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
527:
528: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
529: inv_mwb_globals.g_serial_to IS NOT NULL )
530: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
531:
532: make_common_queries('MSN_QUERY');
533: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 530: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

526: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
527:
528: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
529: inv_mwb_globals.g_serial_to IS NOT NULL )
530: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
531:
532: make_common_queries('MSN_QUERY');
533: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
534: 'msn.current_subinventory_code';

Line 579: inv_mwb_globals.g_tree_st_id

575: 'ONHAND'
576: );
577: inv_mwb_query_manager.add_bind_variable(
578: 'onh_tree_status_id',
579: inv_mwb_globals.g_tree_st_id
580: );
581: inv_mwb_query_manager.add_bind_variable(
582: 'onh_tree_organization_id',
583: inv_mwb_globals.g_tree_organization_id

Line 583: inv_mwb_globals.g_tree_organization_id

579: inv_mwb_globals.g_tree_st_id
580: );
581: inv_mwb_query_manager.add_bind_variable(
582: 'onh_tree_organization_id',
583: inv_mwb_globals.g_tree_organization_id
584: );
585: inv_mwb_query_manager.add_bind_variable(
586: 'onh_tree_subinventory_code',
587: inv_mwb_globals.g_tree_subinventory_code

Line 587: inv_mwb_globals.g_tree_subinventory_code

583: inv_mwb_globals.g_tree_organization_id
584: );
585: inv_mwb_query_manager.add_bind_variable(
586: 'onh_tree_subinventory_code',
587: inv_mwb_globals.g_tree_subinventory_code
588: );
589: inv_mwb_query_manager.execute_query;
590:
591: END IF;

Line 610: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

606: BEGIN
607:
608: l_procedure_name := 'LOC_NODE_EVENT';
609:
610: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
611:
612: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
613: inv_mwb_globals.g_serial_to IS NOT NULL )
614: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 612: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND

608: l_procedure_name := 'LOC_NODE_EVENT';
609:
610: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
611:
612: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
613: inv_mwb_globals.g_serial_to IS NOT NULL )
614: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
615:
616: make_common_queries('MSN_QUERY');

Line 613: inv_mwb_globals.g_serial_to IS NOT NULL )

609:
610: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
611:
612: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
613: inv_mwb_globals.g_serial_to IS NOT NULL )
614: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
615:
616: make_common_queries('MSN_QUERY');
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 614: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

610: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
611:
612: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
613: inv_mwb_globals.g_serial_to IS NOT NULL )
614: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
615:
616: make_common_queries('MSN_QUERY');
617: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
618: 'msn.current_locator_id';

Line 671: inv_mwb_globals.g_tree_st_id

667: 'ONHAND'
668: );
669: inv_mwb_query_manager.add_bind_variable(
670: 'onh_tree_status_id',
671: inv_mwb_globals.g_tree_st_id
672: );
673: inv_mwb_query_manager.add_bind_variable(
674: 'onh_tree_organization_id',
675: inv_mwb_globals.g_tree_organization_id

Line 675: inv_mwb_globals.g_tree_organization_id

671: inv_mwb_globals.g_tree_st_id
672: );
673: inv_mwb_query_manager.add_bind_variable(
674: 'onh_tree_organization_id',
675: inv_mwb_globals.g_tree_organization_id
676: );
677: inv_mwb_query_manager.add_bind_variable(
678: 'onh_tree_locator_id',
679: inv_mwb_globals.g_tree_loc_id

Line 679: inv_mwb_globals.g_tree_loc_id

675: inv_mwb_globals.g_tree_organization_id
676: );
677: inv_mwb_query_manager.add_bind_variable(
678: 'onh_tree_locator_id',
679: inv_mwb_globals.g_tree_loc_id
680: );
681: inv_mwb_query_manager.execute_query;
682:
683: END IF;

Line 702: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

698: BEGIN
699:
700: l_procedure_name := 'LOT_NODE_EVENT';
701:
702: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
703:
704: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
705: inv_mwb_globals.g_serial_to IS NOT NULL )
706: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 704: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND

700: l_procedure_name := 'LOT_NODE_EVENT';
701:
702: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
703:
704: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
705: inv_mwb_globals.g_serial_to IS NOT NULL )
706: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
707:
708: make_common_queries('MSN_QUERY');

Line 705: inv_mwb_globals.g_serial_to IS NOT NULL )

701:
702: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
703:
704: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
705: inv_mwb_globals.g_serial_to IS NOT NULL )
706: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
707:
708: make_common_queries('MSN_QUERY');
709: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 706: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

702: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
703:
704: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
705: inv_mwb_globals.g_serial_to IS NOT NULL )
706: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
707:
708: make_common_queries('MSN_QUERY');
709: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
710: 'msn.lot_number';

Line 791: inv_mwb_globals.g_tree_st_id

787: 'ONHAND'
788: );
789: inv_mwb_query_manager.add_bind_variable(
790: 'onh_tree_status_id',
791: inv_mwb_globals.g_tree_st_id
792: );
793: inv_mwb_query_manager.add_bind_variable(
794: 'onh_tree_organization_id',
795: inv_mwb_globals.g_tree_organization_id

Line 795: inv_mwb_globals.g_tree_organization_id

791: inv_mwb_globals.g_tree_st_id
792: );
793: inv_mwb_query_manager.add_bind_variable(
794: 'onh_tree_organization_id',
795: inv_mwb_globals.g_tree_organization_id
796: );
797: inv_mwb_query_manager.add_bind_variable(
798: 'onh_tree_lot_number',
799: inv_mwb_globals.g_tree_lot_number

Line 799: inv_mwb_globals.g_tree_lot_number

795: inv_mwb_globals.g_tree_organization_id
796: );
797: inv_mwb_query_manager.add_bind_variable(
798: 'onh_tree_lot_number',
799: inv_mwb_globals.g_tree_lot_number
800: );
801: inv_mwb_query_manager.execute_query;
802:
803: END IF;

Line 822: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

818: BEGIN
819:
820: l_procedure_name := 'SERIAL_NODE_EVENT';
821:
822: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
823:
824: make_common_queries('MSN');
825: inv_mwb_query_manager.add_where_clause(
826: 'msn.current_organization_id = :onh_tree_organization_id',

Line 839: inv_mwb_globals.g_tree_st_id

835: 'ONHAND'
836: );
837: inv_mwb_query_manager.add_bind_variable(
838: 'onh_tree_status_id',
839: inv_mwb_globals.g_tree_st_id
840: );
841: inv_mwb_query_manager.add_bind_variable(
842: 'onh_tree_organization_id',
843: inv_mwb_globals.g_tree_organization_id

Line 843: inv_mwb_globals.g_tree_organization_id

839: inv_mwb_globals.g_tree_st_id
840: );
841: inv_mwb_query_manager.add_bind_variable(
842: 'onh_tree_organization_id',
843: inv_mwb_globals.g_tree_organization_id
844: );
845: inv_mwb_query_manager.add_bind_variable(
846: 'onh_tree_serial_number',
847: inv_mwb_globals.g_tree_serial_number

Line 847: inv_mwb_globals.g_tree_serial_number

843: inv_mwb_globals.g_tree_organization_id
844: );
845: inv_mwb_query_manager.add_bind_variable(
846: 'onh_tree_serial_number',
847: inv_mwb_globals.g_tree_serial_number
848: );
849: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
850: inv_mwb_query_manager.execute_query;
851:

Line 971: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');

967: BEGIN
968:
969: l_procedure_name := 'EVENT';
970:
971: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');
972:
973: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
974: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
975:

Line 973: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'

969: l_procedure_name := 'EVENT';
970:
971: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');
972:
973: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
974: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
975:
976: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);
977:

Line 974: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

970:
971: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');
972:
973: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
974: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
975:
976: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);
977:
978: CASE inv_mwb_globals.g_tree_node_type

Line 976: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);

972:
973: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
974: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
975:
976: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);
977:
978: CASE inv_mwb_globals.g_tree_node_type
979:
980: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 978: CASE inv_mwb_globals.g_tree_node_type

974: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
975:
976: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);
977:
978: CASE inv_mwb_globals.g_tree_node_type
979:
980: WHEN 'APPTREE_OBJECT_TRUNK' THEN
981: root_node_event (
982: x_node_value