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
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 -- Bug 6429880
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 -- Bug 6429880
34: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
35: THEN
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 -- Bug 6429880
34: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
35: THEN
36: make_common_queries('MSN_QUERY');
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 -- Bug 6429880
34: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
35: THEN
36: make_common_queries('MSN_QUERY');
37: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
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 -- Bug 6429880
34: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
35: THEN
36: make_common_queries('MSN_QUERY');
37: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
38: ELSE
59: BEGIN
60:
61: l_procedure_name := 'GRADE_NODE_EVENT';
62:
63: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
64:
65: inv_mwb_tree1.add_orgs(
66: x_node_value
67: , x_node_tbl
67: , x_node_tbl
68: , x_tbl_index
69: );
70:
71: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
72:
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
69: );
70:
71: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
72:
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
76: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
77: THEN
70:
71: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
72:
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
76: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
77: THEN
78: make_common_queries('MSN_QUERY');
71: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
72:
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
76: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
77: THEN
78: make_common_queries('MSN_QUERY');
79: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
72:
73: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
74: inv_mwb_globals.g_serial_to IS NOT NULL
75: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
76: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
77: THEN
78: make_common_queries('MSN_QUERY');
79: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
80: ELSE
81: make_common_queries('MOQD');
82: inv_mwb_query_manager.add_qf_where_onhand('ONHAND');
83: END IF;
84: inv_mwb_query_manager.add_where_clause('mln.grade_code = :onh_tree_grade_code ', 'ONHAND');
85: inv_mwb_query_manager.add_bind_variable('onh_tree_grade_code', inv_mwb_globals.g_tree_grade_code);
86: inv_mwb_query_manager.execute_query;
87:
88: END IF;
89:
104: BEGIN
105:
106: l_procedure_name := 'ORG_NODE_EVENT';
107:
108: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
109:
110: inv_mwb_tree1.add_items(
111: x_node_value
112: , x_node_tbl
112: , x_node_tbl
113: , x_tbl_index
114: );
115:
116: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
117:
118: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
119: inv_mwb_globals.g_serial_to IS NOT NULL
120: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
114: );
115:
116: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
117:
118: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
119: inv_mwb_globals.g_serial_to IS NOT NULL
120: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
121: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
122: THEN
115:
116: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
117:
118: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
119: inv_mwb_globals.g_serial_to IS NOT NULL
120: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
121: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
122: THEN
123: make_common_queries('MSN_QUERY');
116: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
117:
118: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
119: inv_mwb_globals.g_serial_to IS NOT NULL
120: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
121: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
122: THEN
123: make_common_queries('MSN_QUERY');
124:
117:
118: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
119: inv_mwb_globals.g_serial_to IS NOT NULL
120: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
121: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
122: THEN
123: make_common_queries('MSN_QUERY');
124:
125: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
175: );
176:
177: inv_mwb_query_manager.add_bind_variable(
178: 'onh_tree_organization_id',
179: inv_mwb_globals.g_tree_organization_id
180: );
181:
182: inv_mwb_query_manager.add_bind_variable(
183: 'onh_tree_grade_code',
180: );
181:
182: inv_mwb_query_manager.add_bind_variable(
183: 'onh_tree_grade_code',
184: inv_mwb_globals.g_tree_grade_code
185: );
186:
187: inv_mwb_query_manager.execute_query;
188:
205: BEGIN
206:
207: l_procedure_name := 'ITEM_NODE_EVENT';
208:
209: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
210:
211: inv_mwb_tree1.add_lots(
212: x_node_value
213: , x_node_tbl
213: , x_node_tbl
214: , x_tbl_index
215: );
216:
217: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
218:
219: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
220: inv_mwb_globals.g_serial_to IS NOT NULL
221: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
215: );
216:
217: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
218:
219: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
220: inv_mwb_globals.g_serial_to IS NOT NULL
221: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
222: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
223: THEN
216:
217: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
218:
219: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
220: inv_mwb_globals.g_serial_to IS NOT NULL
221: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
222: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
223: THEN
224: make_common_queries('MSN_QUERY');
217: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
218:
219: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
220: inv_mwb_globals.g_serial_to IS NOT NULL
221: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
222: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
223: THEN
224: make_common_queries('MSN_QUERY');
225:
218:
219: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
220: inv_mwb_globals.g_serial_to IS NOT NULL
221: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
222: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
223: THEN
224: make_common_queries('MSN_QUERY');
225:
226: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
293: );
294:
295: inv_mwb_query_manager.add_bind_variable(
296: 'onh_tree_organization_id',
297: inv_mwb_globals.g_tree_organization_id
298: );
299:
300: inv_mwb_query_manager.add_bind_variable(
301: 'onh_tree_inventory_item_id',
298: );
299:
300: inv_mwb_query_manager.add_bind_variable(
301: 'onh_tree_inventory_item_id',
302: inv_mwb_globals.g_tree_item_id
303: );
304:
305: inv_mwb_query_manager.add_bind_variable(
306: 'onh_tree_grade_code',
303: );
304:
305: inv_mwb_query_manager.add_bind_variable(
306: 'onh_tree_grade_code',
307: inv_mwb_globals.g_tree_grade_code
308: );
309:
310: inv_mwb_query_manager.execute_query;
311:
328: BEGIN
329:
330: l_procedure_name := 'LOT_NODE_EVENT';
331:
332: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED' THEN
333:
334: inv_mwb_tree1.add_serials(
335: x_node_value
336: , x_node_tbl
336: , x_node_tbl
337: , x_tbl_index
338: );
339:
340: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
341:
342: SELECT serial_number_control_code
343: INTO l_serial_control
344: FROM mtl_system_items
341:
342: SELECT serial_number_control_code
343: INTO l_serial_control
344: FROM mtl_system_items
345: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
346: AND organization_id = inv_mwb_globals.g_tree_organization_id;
347:
348: IF l_serial_control IN (2,5) THEN
349: make_common_queries('MSN');
342: SELECT serial_number_control_code
343: INTO l_serial_control
344: FROM mtl_system_items
345: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
346: AND organization_id = inv_mwb_globals.g_tree_organization_id;
347:
348: IF l_serial_control IN (2,5) THEN
349: make_common_queries('MSN');
350: inv_mwb_query_manager.add_where_clause(
360: 'ONHAND'
361: );
362: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
363: ELSE -- not serial controlled
364: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
365: inv_mwb_globals.g_serial_to IS NOT NULL
366: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
367: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
368: THEN
361: );
362: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
363: ELSE -- not serial controlled
364: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
365: inv_mwb_globals.g_serial_to IS NOT NULL
366: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
367: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
368: THEN
369: make_common_queries('MSN_QUERY');
362: inv_mwb_query_manager.add_qf_where_onhand('ONHAND_MSN');
363: ELSE -- not serial controlled
364: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
365: inv_mwb_globals.g_serial_to IS NOT NULL
366: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
367: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
368: THEN
369: make_common_queries('MSN_QUERY');
370:
363: ELSE -- not serial controlled
364: IF inv_mwb_globals.g_serial_from IS NOT NULL OR
365: inv_mwb_globals.g_serial_to IS NOT NULL
366: OR inv_mwb_globals.g_serial_attr_query IS NOT NULL -- Bug 6429880
367: OR inv_mwb_globals.g_unit_number IS NOT NULL -- Bug 9365452
368: THEN
369: make_common_queries('MSN_QUERY');
370:
371: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
455: );
456:
457: inv_mwb_query_manager.add_bind_variable(
458: 'onh_tree_organization_id',
459: inv_mwb_globals.g_tree_organization_id
460: );
461:
462: inv_mwb_query_manager.add_bind_variable(
463: 'onh_tree_inventory_item_id',
460: );
461:
462: inv_mwb_query_manager.add_bind_variable(
463: 'onh_tree_inventory_item_id',
464: inv_mwb_globals.g_tree_item_id
465: );
466:
467: inv_mwb_query_manager.add_bind_variable(
468: 'onh_tree_grade_code',
465: );
466:
467: inv_mwb_query_manager.add_bind_variable(
468: 'onh_tree_grade_code',
469: inv_mwb_globals.g_tree_grade_code
470: );
471: inv_mwb_query_manager.add_bind_variable(
472: 'onh_tree_lot_number',
473: inv_mwb_globals.g_tree_lot_number
469: inv_mwb_globals.g_tree_grade_code
470: );
471: inv_mwb_query_manager.add_bind_variable(
472: 'onh_tree_lot_number',
473: inv_mwb_globals.g_tree_lot_number
474: );
475:
476: inv_mwb_query_manager.execute_query;
477: END IF; --g_tree_event
493: BEGIN
494:
495: l_procedure_name := 'SERIAL_NODE_EVENT';
496:
497: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
498:
499: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
500: 'mln.grade_code';
501:
521: 'ONHAND'
522: );
523: inv_mwb_query_manager.add_bind_variable(
524: 'onh_tree_organization_id',
525: inv_mwb_globals.g_tree_organization_id
526: );
527:
528: inv_mwb_query_manager.add_bind_variable(
529: 'onh_tree_inventory_item_id',
526: );
527:
528: inv_mwb_query_manager.add_bind_variable(
529: 'onh_tree_inventory_item_id',
530: inv_mwb_globals.g_tree_item_id
531: );
532:
533: inv_mwb_query_manager.add_bind_variable(
534: 'onh_tree_grade_code',
531: );
532:
533: inv_mwb_query_manager.add_bind_variable(
534: 'onh_tree_grade_code',
535: inv_mwb_globals.g_tree_grade_code
536: );
537: inv_mwb_query_manager.add_bind_variable(
538: 'onh_tree_lot_number',
539: inv_mwb_globals.g_tree_lot_number
535: inv_mwb_globals.g_tree_grade_code
536: );
537: inv_mwb_query_manager.add_bind_variable(
538: 'onh_tree_lot_number',
539: inv_mwb_globals.g_tree_lot_number
540: );
541: inv_mwb_query_manager.add_bind_variable(
542: 'onh_tree_serial_number',
543: inv_mwb_globals.g_tree_serial_number
539: inv_mwb_globals.g_tree_lot_number
540: );
541: inv_mwb_query_manager.add_bind_variable(
542: 'onh_tree_serial_number',
543: inv_mwb_globals.g_tree_serial_number
544: );
545:
546: inv_mwb_query_manager.execute_query;
547:
745: BEGIN
746:
747: l_procedure_name := 'EVENT';
748:
749: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
750: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
751:
752: CASE inv_mwb_globals.g_tree_node_type
753:
746:
747: l_procedure_name := 'EVENT';
748:
749: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
750: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
751:
752: CASE inv_mwb_globals.g_tree_node_type
753:
754: WHEN 'APPTREE_OBJECT_TRUNK' THEN
748:
749: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_EXPANDED'
750: OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
751:
752: CASE inv_mwb_globals.g_tree_node_type
753:
754: WHEN 'APPTREE_OBJECT_TRUNK' THEN
755: root_node_event (
756: x_node_value