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_LOT_TREE dependencies on INV_MWB_GLOBALS

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

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

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

25: , x_node_tbl
26: , x_tbl_index
27: );
28:
29: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

27: );
28:
29: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
35: make_common_queries('MSN_QUERY');

Line 32: inv_mwb_globals.g_serial_to IS NOT NULL OR

28:
29: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
35: make_common_queries('MSN_QUERY');
36: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

29: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
35: make_common_queries('MSN_QUERY');
36: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
37: ELSE

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

30:
31: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
32: inv_mwb_globals.g_serial_to IS NOT NULL OR
33: inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
34: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
35: make_common_queries('MSN_QUERY');
36: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
37: ELSE
38: make_common_queries('MOQD');

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

56: BEGIN
57:
58: l_procedure_name := 'ORG_NODE_EVENT';
59:
60: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
61:
62: inv_mwb_tree1.add_lots(
63: x_node_value
64: , x_node_tbl

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

64: , x_node_tbl
65: , x_tbl_index
66: );
67:
68: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
69:
70: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
71: inv_mwb_globals.g_serial_to IS NOT NULL
72: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 70: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

66: );
67:
68: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
69:
70: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
71: inv_mwb_globals.g_serial_to IS NOT NULL
72: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
73: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
74: make_common_queries('MSN_QUERY');

Line 71: inv_mwb_globals.g_serial_to IS NOT NULL

67:
68: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
69:
70: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
71: inv_mwb_globals.g_serial_to IS NOT NULL
72: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
73: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
74: make_common_queries('MSN_QUERY');
75: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 72: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

68: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
69:
70: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
71: inv_mwb_globals.g_serial_to IS NOT NULL
72: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
73: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
74: make_common_queries('MSN_QUERY');
75: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
76: 'msn.lot_number';

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

69:
70: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
71: inv_mwb_globals.g_serial_to IS NOT NULL
72: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
73: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
74: make_common_queries('MSN_QUERY');
75: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
76: 'msn.lot_number';
77: inv_mwb_query_manager.add_where_clause(

Line 102: inv_mwb_globals.g_tree_organization_id

98: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
99: END IF; -- serial
100: inv_mwb_query_manager.add_bind_variable(
101: 'onh_tree_organization_id',
102: inv_mwb_globals.g_tree_organization_id
103: );
104: inv_mwb_query_manager.execute_query;
105:
106: END IF; -- g_tree_event

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

120:
121: BEGIN
122:
123: l_procedure_name := 'LOT_NODE_EVENT';
124: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
125: inv_mwb_tree1.add_items(
126: x_node_value
127: , x_node_tbl
128: , x_tbl_index

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

127: , x_node_tbl
128: , x_tbl_index
129: );
130:
131: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
132:
133: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
134: inv_mwb_globals.g_serial_to IS NOT NULL
135: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

Line 133: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

129: );
130:
131: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
132:
133: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
134: inv_mwb_globals.g_serial_to IS NOT NULL
135: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
136: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
137: make_common_queries('MSN_QUERY');

Line 134: inv_mwb_globals.g_serial_to IS NOT NULL

130:
131: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
132:
133: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
134: inv_mwb_globals.g_serial_to IS NOT NULL
135: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
136: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
137: make_common_queries('MSN_QUERY');
138: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 135: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

131: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
132:
133: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
134: inv_mwb_globals.g_serial_to IS NOT NULL
135: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
136: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
137: make_common_queries('MSN_QUERY');
138: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
139: 'msn.lot_number';

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

132:
133: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
134: inv_mwb_globals.g_serial_to IS NOT NULL
135: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
136: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
137: make_common_queries('MSN_QUERY');
138: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
139: 'msn.lot_number';
140: inv_mwb_query_manager.add_where_clause(

Line 174: inv_mwb_globals.g_tree_organization_id

170: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
171: END IF; -- serial
172: inv_mwb_query_manager.add_bind_variable(
173: 'onh_tree_organization_id',
174: inv_mwb_globals.g_tree_organization_id
175: );
176: inv_mwb_query_manager.add_bind_variable(
177: 'onh_tree_lot_number',
178: inv_mwb_globals.g_tree_lot_number

Line 178: inv_mwb_globals.g_tree_lot_number

174: inv_mwb_globals.g_tree_organization_id
175: );
176: inv_mwb_query_manager.add_bind_variable(
177: 'onh_tree_lot_number',
178: inv_mwb_globals.g_tree_lot_number
179: );
180: inv_mwb_query_manager.execute_query;
181:
182: END IF;

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

198:
199: BEGIN
200:
201: l_procedure_name := 'ITEM_NODE_EVENT';
202: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
203: inv_mwb_tree1.add_revs(
204: x_node_value
205: , x_node_tbl
206: , x_tbl_index

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

213: , x_tbl_index
214: );
215: END IF;
216:
217: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
218:
219: SELECT revision_qty_control_code,
220: serial_number_control_code
221: INTO l_rev_control,

Line 224: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

220: serial_number_control_code
221: INTO l_rev_control,
222: l_serial_control
223: FROM mtl_system_items
224: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
225: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
226:
227: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN
228: make_common_queries('MSN');

Line 225: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

221: INTO l_rev_control,
222: l_serial_control
223: FROM mtl_system_items
224: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
225: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
226:
227: IF NVL(l_rev_control, 1) = 1 AND l_serial_control IN (2,5) THEN
228: make_common_queries('MSN');
229: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 247: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

243: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
244:
245: ELSE -- item is not serial controlled
246:
247: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
248: inv_mwb_globals.g_serial_to IS NOT NULL
249: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
250: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
251: make_common_queries('MSN_QUERY');

Line 248: inv_mwb_globals.g_serial_to IS NOT NULL

244:
245: ELSE -- item is not serial controlled
246:
247: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
248: inv_mwb_globals.g_serial_to IS NOT NULL
249: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
250: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
251: make_common_queries('MSN_QUERY');
252: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 249: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233

245: ELSE -- item is not serial controlled
246:
247: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
248: inv_mwb_globals.g_serial_to IS NOT NULL
249: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
250: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
251: make_common_queries('MSN_QUERY');
252: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
253: 'msn.lot_number';

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

246:
247: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
248: inv_mwb_globals.g_serial_to IS NOT NULL
249: OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
250: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
251: make_common_queries('MSN_QUERY');
252: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
253: 'msn.lot_number';
254: IF l_rev_control = 2 THEN

Line 314: inv_mwb_globals.g_tree_organization_id

310:
311: END IF; -- item is not serial controlled
312: inv_mwb_query_manager.add_bind_variable(
313: 'onh_tree_organization_id',
314: inv_mwb_globals.g_tree_organization_id
315: );
316: inv_mwb_query_manager.add_bind_variable(
317: 'onh_tree_lot_number',
318: inv_mwb_globals.g_tree_lot_number

Line 318: inv_mwb_globals.g_tree_lot_number

314: inv_mwb_globals.g_tree_organization_id
315: );
316: inv_mwb_query_manager.add_bind_variable(
317: 'onh_tree_lot_number',
318: inv_mwb_globals.g_tree_lot_number
319: );
320: inv_mwb_query_manager.add_bind_variable(
321: 'onh_tree_inventory_item_id',
322: inv_mwb_globals.g_tree_item_id

Line 322: inv_mwb_globals.g_tree_item_id

318: inv_mwb_globals.g_tree_lot_number
319: );
320: inv_mwb_query_manager.add_bind_variable(
321: 'onh_tree_inventory_item_id',
322: inv_mwb_globals.g_tree_item_id
323: );
324: inv_mwb_query_manager.execute_query;
325:
326: END IF; -- g_tree_Event

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

341: BEGIN
342:
343: l_procedure_name := 'REV_NODE_EVENT';
344:
345: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
346:
347: inv_mwb_tree1.add_serials(
348: x_node_value
349: , x_node_tbl

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

349: , x_node_tbl
350: , x_tbl_index
351: );
352:
353: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
354:
355: SELECT serial_number_control_code
356: INTO l_serial_control
357: FROM mtl_system_items

Line 358: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

354:
355: SELECT serial_number_control_code
356: INTO l_serial_control
357: FROM mtl_system_items
358: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
359: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
360:
361: IF l_serial_control in ( 2,5 ) THEN
362: make_common_queries('MSN');

Line 359: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

355: SELECT serial_number_control_code
356: INTO l_serial_control
357: FROM mtl_system_items
358: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
359: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
360:
361: IF l_serial_control in ( 2,5 ) THEN
362: make_common_queries('MSN');
363: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 422: inv_mwb_globals.g_tree_organization_id

418: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
419: END IF;
420: inv_mwb_query_manager.add_bind_variable(
421: 'onh_tree_organization_id',
422: inv_mwb_globals.g_tree_organization_id
423: );
424: inv_mwb_query_manager.add_bind_variable(
425: 'onh_tree_lot_number',
426: inv_mwb_globals.g_tree_lot_number

Line 426: inv_mwb_globals.g_tree_lot_number

422: inv_mwb_globals.g_tree_organization_id
423: );
424: inv_mwb_query_manager.add_bind_variable(
425: 'onh_tree_lot_number',
426: inv_mwb_globals.g_tree_lot_number
427: );
428: inv_mwb_query_manager.add_bind_variable(
429: 'onh_tree_inventory_item_id',
430: inv_mwb_globals.g_tree_item_id

Line 430: inv_mwb_globals.g_tree_item_id

426: inv_mwb_globals.g_tree_lot_number
427: );
428: inv_mwb_query_manager.add_bind_variable(
429: 'onh_tree_inventory_item_id',
430: inv_mwb_globals.g_tree_item_id
431: );
432: inv_mwb_query_manager.add_bind_variable(
433: 'onh_tree_revision',
434: inv_mwb_globals.g_tree_rev

Line 434: inv_mwb_globals.g_tree_rev

430: inv_mwb_globals.g_tree_item_id
431: );
432: inv_mwb_query_manager.add_bind_variable(
433: 'onh_tree_revision',
434: inv_mwb_globals.g_tree_rev
435: );
436: inv_mwb_query_manager.execute_query;
437:
438: END IF; -- g_tree

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

454: BEGIN
455:
456: l_procedure_name := 'SERIAL_NODE_EVENT';
457:
458: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
459:
460: SELECT revision_qty_control_code
461: INTO l_rev_control
462: FROM mtl_system_items

Line 463: WHERE organization_id = inv_mwb_globals.g_tree_organization_id

459:
460: SELECT revision_qty_control_code
461: INTO l_rev_control
462: FROM mtl_system_items
463: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
464: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
465:
466: make_common_queries('MSN');
467: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

Line 464: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;

460: SELECT revision_qty_control_code
461: INTO l_rev_control
462: FROM mtl_system_items
463: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
464: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
465:
466: make_common_queries('MSN');
467: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
468: 'msn.lot_number';

Line 480: inv_mwb_globals.g_tree_rev

476: 'ONHAND'
477: );
478: inv_mwb_query_manager.add_bind_variable(
479: 'onh_tree_revision',
480: inv_mwb_globals.g_tree_rev
481: );
482: END IF;
483: inv_mwb_query_manager.add_where_clause(
484: 'msn.current_organization_id = :onh_tree_organization_id' ,

Line 502: inv_mwb_globals.g_tree_organization_id

498: );
499: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
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_bind_variable(
505: 'onh_tree_lot_number',
506: inv_mwb_globals.g_tree_lot_number

Line 506: inv_mwb_globals.g_tree_lot_number

502: inv_mwb_globals.g_tree_organization_id
503: );
504: inv_mwb_query_manager.add_bind_variable(
505: 'onh_tree_lot_number',
506: inv_mwb_globals.g_tree_lot_number
507: );
508: inv_mwb_query_manager.add_bind_variable(
509: 'onh_tree_inventory_item_id',
510: inv_mwb_globals.g_tree_item_id

Line 510: inv_mwb_globals.g_tree_item_id

506: inv_mwb_globals.g_tree_lot_number
507: );
508: inv_mwb_query_manager.add_bind_variable(
509: 'onh_tree_inventory_item_id',
510: inv_mwb_globals.g_tree_item_id
511: );
512: inv_mwb_query_manager.add_bind_variable(
513: 'onh_tree_serial_number',
514: inv_mwb_globals.g_tree_serial_number

Line 514: inv_mwb_globals.g_tree_serial_number

510: inv_mwb_globals.g_tree_item_id
511: );
512: inv_mwb_query_manager.add_bind_variable(
513: 'onh_tree_serial_number',
514: inv_mwb_globals.g_tree_serial_number
515: );
516: inv_mwb_query_manager.execute_query;
517:
518: END IF; -- g_tree

Line 644: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'

640: BEGIN
641:
642: l_procedure_name := 'EVENT';
643:
644: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
645: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
646:
647: CASE inv_mwb_globals.g_tree_node_type
648:

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

641:
642: l_procedure_name := 'EVENT';
643:
644: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
645: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
646:
647: CASE inv_mwb_globals.g_tree_node_type
648:
649: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 647: CASE inv_mwb_globals.g_tree_node_type

643:
644: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
645: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
646:
647: CASE inv_mwb_globals.g_tree_node_type
648:
649: WHEN 'APPTREE_OBJECT_TRUNK' THEN
650: root_node_event (
651: x_node_value