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.

[Home] [Help]

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 -- 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 -- Bug 6429880
220: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
221: THEN

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 -- Bug 6429880
220: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
221: THEN
222: make_common_queries('MSN_QUERY');

Line 219: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- 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 -- Bug 6429880
220: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
221: THEN
222: make_common_queries('MSN_QUERY');
223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 220: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

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 -- Bug 6429880
220: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
221: THEN
222: make_common_queries('MSN_QUERY');
223: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
224: 'msn.current_subinventory_code';

Line 265: inv_mwb_globals.g_tree_st_id

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

Line 269: inv_mwb_globals.g_tree_organization_id

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

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

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

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

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

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

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

Line 302: inv_mwb_globals.g_serial_to IS NOT NULL )

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

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

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

Line 304: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

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

Line 357: inv_mwb_globals.g_tree_st_id

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

Line 361: inv_mwb_globals.g_tree_organization_id

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

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

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

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

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

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

388: );
389:
390: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
391:
392: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
393: inv_mwb_globals.g_serial_to IS NOT NULL )
394: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
395: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
396: THEN

Line 393: inv_mwb_globals.g_serial_to IS NOT NULL )

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

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

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

Line 395: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

391:
392: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
393: inv_mwb_globals.g_serial_to IS NOT NULL )
394: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
395: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
396: THEN
397: make_common_queries('MSN_QUERY');
398: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
399: 'msn.lot_number';

Line 454: inv_mwb_globals.g_tree_st_id

450: 'ONHAND'
451: );
452: inv_mwb_query_manager.add_bind_variable(
453: 'onh_tree_status_id',
454: inv_mwb_globals.g_tree_st_id
455: );
456: inv_mwb_query_manager.add_bind_variable(
457: 'onh_tree_organization_id',
458: inv_mwb_globals.g_tree_organization_id

Line 458: inv_mwb_globals.g_tree_organization_id

454: inv_mwb_globals.g_tree_st_id
455: );
456: inv_mwb_query_manager.add_bind_variable(
457: 'onh_tree_organization_id',
458: inv_mwb_globals.g_tree_organization_id
459: );
460: inv_mwb_query_manager.execute_query;
461:
462: END IF;

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

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

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

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

Line 501: inv_mwb_globals.g_tree_st_id

497: 'ONHAND'
498: );
499: inv_mwb_query_manager.add_bind_variable(
500: 'onh_tree_status_id',
501: inv_mwb_globals.g_tree_st_id
502: );
503: inv_mwb_query_manager.add_bind_variable(
504: 'onh_tree_organization_id',
505: inv_mwb_globals.g_tree_organization_id

Line 505: inv_mwb_globals.g_tree_organization_id

501: inv_mwb_globals.g_tree_st_id
502: );
503: inv_mwb_query_manager.add_bind_variable(
504: 'onh_tree_organization_id',
505: inv_mwb_globals.g_tree_organization_id
506: );
507: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
508: inv_mwb_query_manager.execute_query;
509:

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

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

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

527: l_procedure_name := 'SUB_NODE_EVENT';
528:
529: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
530:
531: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
532: inv_mwb_globals.g_serial_to IS NOT NULL )
533: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
534: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
535: THEN

Line 532: inv_mwb_globals.g_serial_to IS NOT NULL )

528:
529: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
530:
531: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
532: inv_mwb_globals.g_serial_to IS NOT NULL )
533: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
534: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
535: THEN
536:

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

529: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
530:
531: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
532: inv_mwb_globals.g_serial_to IS NOT NULL )
533: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
534: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
535: THEN
536:
537: make_common_queries('MSN_QUERY');

Line 534: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

530:
531: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
532: inv_mwb_globals.g_serial_to IS NOT NULL )
533: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
534: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
535: THEN
536:
537: make_common_queries('MSN_QUERY');
538: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=

Line 584: inv_mwb_globals.g_tree_st_id

580: 'ONHAND'
581: );
582: inv_mwb_query_manager.add_bind_variable(
583: 'onh_tree_status_id',
584: inv_mwb_globals.g_tree_st_id
585: );
586: inv_mwb_query_manager.add_bind_variable(
587: 'onh_tree_organization_id',
588: inv_mwb_globals.g_tree_organization_id

Line 588: inv_mwb_globals.g_tree_organization_id

584: inv_mwb_globals.g_tree_st_id
585: );
586: inv_mwb_query_manager.add_bind_variable(
587: 'onh_tree_organization_id',
588: inv_mwb_globals.g_tree_organization_id
589: );
590: inv_mwb_query_manager.add_bind_variable(
591: 'onh_tree_subinventory_code',
592: inv_mwb_globals.g_tree_subinventory_code

Line 592: inv_mwb_globals.g_tree_subinventory_code

588: inv_mwb_globals.g_tree_organization_id
589: );
590: inv_mwb_query_manager.add_bind_variable(
591: 'onh_tree_subinventory_code',
592: inv_mwb_globals.g_tree_subinventory_code
593: );
594: inv_mwb_query_manager.execute_query;
595:
596: END IF;

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

611: BEGIN
612:
613: l_procedure_name := 'LOC_NODE_EVENT';
614:
615: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
616:
617: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
618: inv_mwb_globals.g_serial_to IS NOT NULL )
619: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

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

613: l_procedure_name := 'LOC_NODE_EVENT';
614:
615: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
616:
617: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
618: inv_mwb_globals.g_serial_to IS NOT NULL )
619: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
620: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
621: THEN

Line 618: inv_mwb_globals.g_serial_to IS NOT NULL )

614:
615: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
616:
617: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
618: inv_mwb_globals.g_serial_to IS NOT NULL )
619: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
620: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
621: THEN
622:

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

615: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
616:
617: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
618: inv_mwb_globals.g_serial_to IS NOT NULL )
619: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
620: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
621: THEN
622:
623: make_common_queries('MSN_QUERY');

Line 620: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

616:
617: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
618: inv_mwb_globals.g_serial_to IS NOT NULL )
619: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
620: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
621: THEN
622:
623: make_common_queries('MSN_QUERY');
624: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=

Line 678: inv_mwb_globals.g_tree_st_id

674: 'ONHAND'
675: );
676: inv_mwb_query_manager.add_bind_variable(
677: 'onh_tree_status_id',
678: inv_mwb_globals.g_tree_st_id
679: );
680: inv_mwb_query_manager.add_bind_variable(
681: 'onh_tree_organization_id',
682: inv_mwb_globals.g_tree_organization_id

Line 682: inv_mwb_globals.g_tree_organization_id

678: inv_mwb_globals.g_tree_st_id
679: );
680: inv_mwb_query_manager.add_bind_variable(
681: 'onh_tree_organization_id',
682: inv_mwb_globals.g_tree_organization_id
683: );
684: inv_mwb_query_manager.add_bind_variable(
685: 'onh_tree_locator_id',
686: inv_mwb_globals.g_tree_loc_id

Line 686: inv_mwb_globals.g_tree_loc_id

682: inv_mwb_globals.g_tree_organization_id
683: );
684: inv_mwb_query_manager.add_bind_variable(
685: 'onh_tree_locator_id',
686: inv_mwb_globals.g_tree_loc_id
687: );
688: inv_mwb_query_manager.execute_query;
689:
690: END IF;

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

705: BEGIN
706:
707: l_procedure_name := 'LOT_NODE_EVENT';
708:
709: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
710:
711: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
712: inv_mwb_globals.g_serial_to IS NOT NULL )
713: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880

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

707: l_procedure_name := 'LOT_NODE_EVENT';
708:
709: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
710:
711: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
712: inv_mwb_globals.g_serial_to IS NOT NULL )
713: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
714: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
715: THEN

Line 712: inv_mwb_globals.g_serial_to IS NOT NULL )

708:
709: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
710:
711: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
712: inv_mwb_globals.g_serial_to IS NOT NULL )
713: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
714: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
715: THEN
716:

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

709: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
710:
711: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
712: inv_mwb_globals.g_serial_to IS NOT NULL )
713: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
714: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
715: THEN
716:
717: make_common_queries('MSN_QUERY');

Line 714: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070

710:
711: IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
712: inv_mwb_globals.g_serial_to IS NOT NULL )
713: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
714: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9486070
715: THEN
716:
717: make_common_queries('MSN_QUERY');
718: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 800: inv_mwb_globals.g_tree_st_id

796: 'ONHAND'
797: );
798: inv_mwb_query_manager.add_bind_variable(
799: 'onh_tree_status_id',
800: inv_mwb_globals.g_tree_st_id
801: );
802: inv_mwb_query_manager.add_bind_variable(
803: 'onh_tree_organization_id',
804: inv_mwb_globals.g_tree_organization_id

Line 804: inv_mwb_globals.g_tree_organization_id

800: inv_mwb_globals.g_tree_st_id
801: );
802: inv_mwb_query_manager.add_bind_variable(
803: 'onh_tree_organization_id',
804: inv_mwb_globals.g_tree_organization_id
805: );
806: inv_mwb_query_manager.add_bind_variable(
807: 'onh_tree_lot_number',
808: inv_mwb_globals.g_tree_lot_number

Line 808: inv_mwb_globals.g_tree_lot_number

804: inv_mwb_globals.g_tree_organization_id
805: );
806: inv_mwb_query_manager.add_bind_variable(
807: 'onh_tree_lot_number',
808: inv_mwb_globals.g_tree_lot_number
809: );
810: inv_mwb_query_manager.execute_query;
811:
812: END IF;

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

827: BEGIN
828:
829: l_procedure_name := 'SERIAL_NODE_EVENT';
830:
831: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
832:
833: make_common_queries('MSN');
834: inv_mwb_query_manager.add_where_clause(
835: 'msn.current_organization_id = :onh_tree_organization_id',

Line 848: inv_mwb_globals.g_tree_st_id

844: 'ONHAND'
845: );
846: inv_mwb_query_manager.add_bind_variable(
847: 'onh_tree_status_id',
848: inv_mwb_globals.g_tree_st_id
849: );
850: inv_mwb_query_manager.add_bind_variable(
851: 'onh_tree_organization_id',
852: inv_mwb_globals.g_tree_organization_id

Line 852: inv_mwb_globals.g_tree_organization_id

848: inv_mwb_globals.g_tree_st_id
849: );
850: inv_mwb_query_manager.add_bind_variable(
851: 'onh_tree_organization_id',
852: inv_mwb_globals.g_tree_organization_id
853: );
854: inv_mwb_query_manager.add_bind_variable(
855: 'onh_tree_serial_number',
856: inv_mwb_globals.g_tree_serial_number

Line 856: inv_mwb_globals.g_tree_serial_number

852: inv_mwb_globals.g_tree_organization_id
853: );
854: inv_mwb_query_manager.add_bind_variable(
855: 'onh_tree_serial_number',
856: inv_mwb_globals.g_tree_serial_number
857: );
858: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
859: inv_mwb_query_manager.execute_query;
860:

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

976: BEGIN
977:
978: l_procedure_name := 'EVENT';
979:
980: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');
981:
982: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
983: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
984:

Line 982: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'

978: l_procedure_name := 'EVENT';
979:
980: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');
981:
982: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
983: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
984:
985: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);
986:

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

979:
980: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');
981:
982: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
983: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
984:
985: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);
986:
987: CASE inv_mwb_globals.g_tree_node_type

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

981:
982: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
983: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
984:
985: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);
986:
987: CASE inv_mwb_globals.g_tree_node_type
988:
989: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 987: CASE inv_mwb_globals.g_tree_node_type

983: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
984:
985: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);
986:
987: CASE inv_mwb_globals.g_tree_node_type
988:
989: WHEN 'APPTREE_OBJECT_TRUNK' THEN
990: root_node_event (
991: x_node_value