APPS.INV_MWB_GRADE_TREE dependencies on INV_MWB_GLOBALS

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

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

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
33: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

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
33: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
34: make_common_queries('MSN_QUERY');
35: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');

Line 32: inv_mwb_globals.g_serial_to IS NOT NULL

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
33: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
34: make_common_queries('MSN_QUERY');
35: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
36: ELSE

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

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
33: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
34: make_common_queries('MSN_QUERY');
35: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
36: ELSE
37: make_common_queries('MOQD');

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

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

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

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

Line 71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

67: );
68:
69: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
70:
71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
72: inv_mwb_globals.g_serial_to IS NOT NULL
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.add_qf_where_onhand('ONHAND_MSN');

Line 72: inv_mwb_globals.g_serial_to IS NOT NULL

68:
69: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
70:
71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
72: inv_mwb_globals.g_serial_to IS NOT NULL
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.add_qf_where_onhand('ONHAND_MSN');
76: ELSE

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

69: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
70:
71: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
72: inv_mwb_globals.g_serial_to IS NOT NULL
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.add_qf_where_onhand('ONHAND_MSN');
76: ELSE
77: make_common_queries('MOQD');

Line 81: inv_mwb_query_manager.add_bind_variable('onh_tree_grade_code', inv_mwb_globals.g_tree_grade_code);

77: make_common_queries('MOQD');
78: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
79: END IF;
80: inv_mwb_query_manager.add_where_clause('mln.grade_code = :onh_tree_grade_code ', 'ONHAND');
81: inv_mwb_query_manager.add_bind_variable('onh_tree_grade_code', inv_mwb_globals.g_tree_grade_code);
82: inv_mwb_query_manager.execute_query;
83:
84: END IF;
85:

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

100: BEGIN
101:
102: l_procedure_name := 'ORG_NODE_EVENT';
103:
104: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
105:
106: inv_mwb_tree1.add_items(
107: x_node_value
108: , x_node_tbl

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

108: , x_node_tbl
109: , x_tbl_index
110: );
111:
112: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
113:
114: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
115: inv_mwb_globals.g_serial_to IS NOT NULL
116: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 114: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

110: );
111:
112: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
113:
114: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
115: inv_mwb_globals.g_serial_to IS NOT NULL
116: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
117: make_common_queries('MSN_QUERY');
118:

Line 115: inv_mwb_globals.g_serial_to IS NOT NULL

111:
112: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
113:
114: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
115: inv_mwb_globals.g_serial_to IS NOT NULL
116: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
117: make_common_queries('MSN_QUERY');
118:
119: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=

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

112: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
113:
114: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
115: inv_mwb_globals.g_serial_to IS NOT NULL
116: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
117: make_common_queries('MSN_QUERY');
118:
119: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
120: 'msn.inventory_item_id';

Line 173: inv_mwb_globals.g_tree_organization_id

169: );
170:
171: inv_mwb_query_manager.add_bind_variable(
172: 'onh_tree_organization_id',
173: inv_mwb_globals.g_tree_organization_id
174: );
175:
176: inv_mwb_query_manager.add_bind_variable(
177: 'onh_tree_grade_code',

Line 178: inv_mwb_globals.g_tree_grade_code

174: );
175:
176: inv_mwb_query_manager.add_bind_variable(
177: 'onh_tree_grade_code',
178: inv_mwb_globals.g_tree_grade_code
179: );
180:
181: inv_mwb_query_manager.execute_query;
182:

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

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

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

207: , x_node_tbl
208: , x_tbl_index
209: );
210:
211: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
212:
213: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
214: inv_mwb_globals.g_serial_to IS NOT NULL
215: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880

Line 213: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

209: );
210:
211: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
212:
213: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
214: inv_mwb_globals.g_serial_to IS NOT NULL
215: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
216: make_common_queries('MSN_QUERY');
217:

Line 214: inv_mwb_globals.g_serial_to IS NOT NULL

210:
211: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
212:
213: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
214: inv_mwb_globals.g_serial_to IS NOT NULL
215: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
216: make_common_queries('MSN_QUERY');
217:
218: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

211: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
212:
213: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
214: inv_mwb_globals.g_serial_to IS NOT NULL
215: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
216: make_common_queries('MSN_QUERY');
217:
218: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
219: 'msn.lot_number';

Line 289: inv_mwb_globals.g_tree_organization_id

285: );
286:
287: inv_mwb_query_manager.add_bind_variable(
288: 'onh_tree_organization_id',
289: inv_mwb_globals.g_tree_organization_id
290: );
291:
292: inv_mwb_query_manager.add_bind_variable(
293: 'onh_tree_inventory_item_id',

Line 294: inv_mwb_globals.g_tree_item_id

290: );
291:
292: inv_mwb_query_manager.add_bind_variable(
293: 'onh_tree_inventory_item_id',
294: inv_mwb_globals.g_tree_item_id
295: );
296:
297: inv_mwb_query_manager.add_bind_variable(
298: 'onh_tree_grade_code',

Line 299: inv_mwb_globals.g_tree_grade_code

295: );
296:
297: inv_mwb_query_manager.add_bind_variable(
298: 'onh_tree_grade_code',
299: inv_mwb_globals.g_tree_grade_code
300: );
301:
302: inv_mwb_query_manager.execute_query;
303:

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

320: BEGIN
321:
322: l_procedure_name := 'LOT_NODE_EVENT';
323:
324: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
325:
326: inv_mwb_tree1.add_serials(
327: x_node_value
328: , x_node_tbl

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

328: , x_node_tbl
329: , x_tbl_index
330: );
331:
332: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
333:
334: SELECT serial_number_control_code
335: INTO l_serial_control
336: FROM mtl_system_items

Line 337: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id

333:
334: SELECT serial_number_control_code
335: INTO l_serial_control
336: FROM mtl_system_items
337: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
338: AND organization_id = inv_mwb_globals.g_tree_organization_id;
339:
340: IF l_serial_control IN (2,5) THEN
341: make_common_queries('MSN');

Line 338: AND organization_id = inv_mwb_globals.g_tree_organization_id;

334: SELECT serial_number_control_code
335: INTO l_serial_control
336: FROM mtl_system_items
337: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
338: AND organization_id = inv_mwb_globals.g_tree_organization_id;
339:
340: IF l_serial_control IN (2,5) THEN
341: make_common_queries('MSN');
342: inv_mwb_query_manager.add_where_clause(

Line 356: IF inv_mwb_globals.g_serial_from IS NOT NULL OR

352: 'ONHAND'
353: );
354: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
355: ELSE -- not serial controlled
356: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
357: inv_mwb_globals.g_serial_to IS NOT NULL
358: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
359: make_common_queries('MSN_QUERY');
360:

Line 357: inv_mwb_globals.g_serial_to IS NOT NULL

353: );
354: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
355: ELSE -- not serial controlled
356: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
357: inv_mwb_globals.g_serial_to IS NOT NULL
358: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
359: make_common_queries('MSN_QUERY');
360:
361: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=

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

354: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
355: ELSE -- not serial controlled
356: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
357: inv_mwb_globals.g_serial_to IS NOT NULL
358: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN -- Bug 6429880
359: make_common_queries('MSN_QUERY');
360:
361: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
362: 'msn.lot_number';

Line 449: inv_mwb_globals.g_tree_organization_id

445: );
446:
447: inv_mwb_query_manager.add_bind_variable(
448: 'onh_tree_organization_id',
449: inv_mwb_globals.g_tree_organization_id
450: );
451:
452: inv_mwb_query_manager.add_bind_variable(
453: 'onh_tree_inventory_item_id',

Line 454: inv_mwb_globals.g_tree_item_id

450: );
451:
452: inv_mwb_query_manager.add_bind_variable(
453: 'onh_tree_inventory_item_id',
454: inv_mwb_globals.g_tree_item_id
455: );
456:
457: inv_mwb_query_manager.add_bind_variable(
458: 'onh_tree_grade_code',

Line 459: inv_mwb_globals.g_tree_grade_code

455: );
456:
457: inv_mwb_query_manager.add_bind_variable(
458: 'onh_tree_grade_code',
459: inv_mwb_globals.g_tree_grade_code
460: );
461: inv_mwb_query_manager.add_bind_variable(
462: 'onh_tree_lot_number',
463: inv_mwb_globals.g_tree_lot_number

Line 463: inv_mwb_globals.g_tree_lot_number

459: inv_mwb_globals.g_tree_grade_code
460: );
461: inv_mwb_query_manager.add_bind_variable(
462: 'onh_tree_lot_number',
463: inv_mwb_globals.g_tree_lot_number
464: );
465:
466: inv_mwb_query_manager.execute_query;
467: END IF; --g_tree_event

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

483: BEGIN
484:
485: l_procedure_name := 'SERIAL_NODE_EVENT';
486:
487: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
488:
489: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
490: 'mln.grade_code';
491:

Line 515: inv_mwb_globals.g_tree_organization_id

511: 'ONHAND'
512: );
513: inv_mwb_query_manager.add_bind_variable(
514: 'onh_tree_organization_id',
515: inv_mwb_globals.g_tree_organization_id
516: );
517:
518: inv_mwb_query_manager.add_bind_variable(
519: 'onh_tree_inventory_item_id',

Line 520: inv_mwb_globals.g_tree_item_id

516: );
517:
518: inv_mwb_query_manager.add_bind_variable(
519: 'onh_tree_inventory_item_id',
520: inv_mwb_globals.g_tree_item_id
521: );
522:
523: inv_mwb_query_manager.add_bind_variable(
524: 'onh_tree_grade_code',

Line 525: inv_mwb_globals.g_tree_grade_code

521: );
522:
523: inv_mwb_query_manager.add_bind_variable(
524: 'onh_tree_grade_code',
525: inv_mwb_globals.g_tree_grade_code
526: );
527: inv_mwb_query_manager.add_bind_variable(
528: 'onh_tree_lot_number',
529: inv_mwb_globals.g_tree_lot_number

Line 529: inv_mwb_globals.g_tree_lot_number

525: inv_mwb_globals.g_tree_grade_code
526: );
527: inv_mwb_query_manager.add_bind_variable(
528: 'onh_tree_lot_number',
529: inv_mwb_globals.g_tree_lot_number
530: );
531: inv_mwb_query_manager.add_bind_variable(
532: 'onh_tree_serial_number',
533: inv_mwb_globals.g_tree_serial_number

Line 533: inv_mwb_globals.g_tree_serial_number

529: inv_mwb_globals.g_tree_lot_number
530: );
531: inv_mwb_query_manager.add_bind_variable(
532: 'onh_tree_serial_number',
533: inv_mwb_globals.g_tree_serial_number
534: );
535:
536: inv_mwb_query_manager.execute_query;
537:

Line 739: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'

735: BEGIN
736:
737: l_procedure_name := 'EVENT';
738:
739: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
740: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
741:
742: CASE inv_mwb_globals.g_tree_node_type
743:

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

736:
737: l_procedure_name := 'EVENT';
738:
739: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
740: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
741:
742: CASE inv_mwb_globals.g_tree_node_type
743:
744: WHEN 'APPTREE_OBJECT_TRUNK' THEN

Line 742: CASE inv_mwb_globals.g_tree_node_type

738:
739: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
740: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
741:
742: CASE inv_mwb_globals.g_tree_node_type
743:
744: WHEN 'APPTREE_OBJECT_TRUNK' THEN
745: root_node_event (
746: x_node_value