92: BEGIN
93:
94: l_procedure_name := 'PROCESS_QUERY';
95:
96: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered' );
97:
98: inv_mwb_globals.g_organization_id := p_organization_id;
99: inv_mwb_globals.g_subinventory_code := p_subinventory_code;
100: inv_mwb_globals.g_locator_id := p_locator_id;
94: l_procedure_name := 'PROCESS_QUERY';
95:
96: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered' );
97:
98: inv_mwb_globals.g_organization_id := p_organization_id;
99: inv_mwb_globals.g_subinventory_code := p_subinventory_code;
100: inv_mwb_globals.g_locator_id := p_locator_id;
101: inv_mwb_globals.g_client_code := p_client_code; -- ER(9158529 client)
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
95:
96: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered' );
97:
98: inv_mwb_globals.g_organization_id := p_organization_id;
99: inv_mwb_globals.g_subinventory_code := p_subinventory_code;
100: inv_mwb_globals.g_locator_id := p_locator_id;
101: inv_mwb_globals.g_client_code := p_client_code; -- ER(9158529 client)
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
103: inv_mwb_globals.g_revision := p_revision;
96: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered' );
97:
98: inv_mwb_globals.g_organization_id := p_organization_id;
99: inv_mwb_globals.g_subinventory_code := p_subinventory_code;
100: inv_mwb_globals.g_locator_id := p_locator_id;
101: inv_mwb_globals.g_client_code := p_client_code; -- ER(9158529 client)
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
103: inv_mwb_globals.g_revision := p_revision;
104: inv_mwb_globals.g_status_id := p_status_id;
97:
98: inv_mwb_globals.g_organization_id := p_organization_id;
99: inv_mwb_globals.g_subinventory_code := p_subinventory_code;
100: inv_mwb_globals.g_locator_id := p_locator_id;
101: inv_mwb_globals.g_client_code := p_client_code; -- ER(9158529 client)
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
103: inv_mwb_globals.g_revision := p_revision;
104: inv_mwb_globals.g_status_id := p_status_id;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
98: inv_mwb_globals.g_organization_id := p_organization_id;
99: inv_mwb_globals.g_subinventory_code := p_subinventory_code;
100: inv_mwb_globals.g_locator_id := p_locator_id;
101: inv_mwb_globals.g_client_code := p_client_code; -- ER(9158529 client)
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
103: inv_mwb_globals.g_revision := p_revision;
104: inv_mwb_globals.g_status_id := p_status_id;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
99: inv_mwb_globals.g_subinventory_code := p_subinventory_code;
100: inv_mwb_globals.g_locator_id := p_locator_id;
101: inv_mwb_globals.g_client_code := p_client_code; -- ER(9158529 client)
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
103: inv_mwb_globals.g_revision := p_revision;
104: inv_mwb_globals.g_status_id := p_status_id;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
100: inv_mwb_globals.g_locator_id := p_locator_id;
101: inv_mwb_globals.g_client_code := p_client_code; -- ER(9158529 client)
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
103: inv_mwb_globals.g_revision := p_revision;
104: inv_mwb_globals.g_status_id := p_status_id;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
101: inv_mwb_globals.g_client_code := p_client_code; -- ER(9158529 client)
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
103: inv_mwb_globals.g_revision := p_revision;
104: inv_mwb_globals.g_status_id := p_status_id;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
102: inv_mwb_globals.g_inventory_item_id := p_inventory_item_id;
103: inv_mwb_globals.g_revision := p_revision;
104: inv_mwb_globals.g_status_id := p_status_id;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
103: inv_mwb_globals.g_revision := p_revision;
104: inv_mwb_globals.g_status_id := p_status_id;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
104: inv_mwb_globals.g_status_id := p_status_id;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
112: inv_mwb_globals.g_lot_from := p_lot_from;
105: inv_mwb_globals.g_cost_group_id := p_cost_group_id;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
112: inv_mwb_globals.g_lot_from := p_lot_from;
113: inv_mwb_globals.g_lot_to := p_lot_to;
106: inv_mwb_globals.g_category_set_id := p_category_set_id; -- ER(9158529)
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
112: inv_mwb_globals.g_lot_from := p_lot_from;
113: inv_mwb_globals.g_lot_to := p_lot_to;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
107: inv_mwb_globals.g_category_id := p_category_id; -- ER(9158529)
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
112: inv_mwb_globals.g_lot_from := p_lot_from;
113: inv_mwb_globals.g_lot_to := p_lot_to;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
108: inv_mwb_globals.g_lpn_from := p_lpn_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
112: inv_mwb_globals.g_lot_from := p_lot_from;
113: inv_mwb_globals.g_lot_to := p_lot_to;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
116: inv_mwb_globals.g_serial_from := p_serial_from;
109: inv_mwb_globals.g_lpn_from_id := p_lpn_from_id;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
112: inv_mwb_globals.g_lot_from := p_lot_from;
113: inv_mwb_globals.g_lot_to := p_lot_to;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
116: inv_mwb_globals.g_serial_from := p_serial_from;
117: inv_mwb_globals.g_serial_to := p_serial_to;
110: inv_mwb_globals.g_lpn_to := p_lpn_to;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
112: inv_mwb_globals.g_lot_from := p_lot_from;
113: inv_mwb_globals.g_lot_to := p_lot_to;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
116: inv_mwb_globals.g_serial_from := p_serial_from;
117: inv_mwb_globals.g_serial_to := p_serial_to;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
111: inv_mwb_globals.g_lpn_to_id := p_lpn_to_id;
112: inv_mwb_globals.g_lot_from := p_lot_from;
113: inv_mwb_globals.g_lot_to := p_lot_to;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
116: inv_mwb_globals.g_serial_from := p_serial_from;
117: inv_mwb_globals.g_serial_to := p_serial_to;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
119: inv_mwb_globals.g_prepacked := p_prepacked;
112: inv_mwb_globals.g_lot_from := p_lot_from;
113: inv_mwb_globals.g_lot_to := p_lot_to;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
116: inv_mwb_globals.g_serial_from := p_serial_from;
117: inv_mwb_globals.g_serial_to := p_serial_to;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
119: inv_mwb_globals.g_prepacked := p_prepacked;
120: inv_mwb_globals.g_project_id := p_project_id;
113: inv_mwb_globals.g_lot_to := p_lot_to;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
116: inv_mwb_globals.g_serial_from := p_serial_from;
117: inv_mwb_globals.g_serial_to := p_serial_to;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
119: inv_mwb_globals.g_prepacked := p_prepacked;
120: inv_mwb_globals.g_project_id := p_project_id;
121: inv_mwb_globals.g_task_id := p_task_id;
114: inv_mwb_globals.g_supplier_lot_from := p_supplier_lot_from; -- Bug 8396954
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
116: inv_mwb_globals.g_serial_from := p_serial_from;
117: inv_mwb_globals.g_serial_to := p_serial_to;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
119: inv_mwb_globals.g_prepacked := p_prepacked;
120: inv_mwb_globals.g_project_id := p_project_id;
121: inv_mwb_globals.g_task_id := p_task_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
115: inv_mwb_globals.g_supplier_lot_to := p_supplier_lot_to; -- Bug 8396954
116: inv_mwb_globals.g_serial_from := p_serial_from;
117: inv_mwb_globals.g_serial_to := p_serial_to;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
119: inv_mwb_globals.g_prepacked := p_prepacked;
120: inv_mwb_globals.g_project_id := p_project_id;
121: inv_mwb_globals.g_task_id := p_task_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
123: inv_mwb_globals.g_planning_org := p_planning_org;
116: inv_mwb_globals.g_serial_from := p_serial_from;
117: inv_mwb_globals.g_serial_to := p_serial_to;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
119: inv_mwb_globals.g_prepacked := p_prepacked;
120: inv_mwb_globals.g_project_id := p_project_id;
121: inv_mwb_globals.g_task_id := p_task_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
123: inv_mwb_globals.g_planning_org := p_planning_org;
124: inv_mwb_globals.g_owning_org := p_owning_org;
117: inv_mwb_globals.g_serial_to := p_serial_to;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
119: inv_mwb_globals.g_prepacked := p_prepacked;
120: inv_mwb_globals.g_project_id := p_project_id;
121: inv_mwb_globals.g_task_id := p_task_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
123: inv_mwb_globals.g_planning_org := p_planning_org;
124: inv_mwb_globals.g_owning_org := p_owning_org;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
118: inv_mwb_globals.g_workbench_vb := p_workbench_vb;
119: inv_mwb_globals.g_prepacked := p_prepacked;
120: inv_mwb_globals.g_project_id := p_project_id;
121: inv_mwb_globals.g_task_id := p_task_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
123: inv_mwb_globals.g_planning_org := p_planning_org;
124: inv_mwb_globals.g_owning_org := p_owning_org;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
119: inv_mwb_globals.g_prepacked := p_prepacked;
120: inv_mwb_globals.g_project_id := p_project_id;
121: inv_mwb_globals.g_task_id := p_task_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
123: inv_mwb_globals.g_planning_org := p_planning_org;
124: inv_mwb_globals.g_owning_org := p_owning_org;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
120: inv_mwb_globals.g_project_id := p_project_id;
121: inv_mwb_globals.g_task_id := p_task_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
123: inv_mwb_globals.g_planning_org := p_planning_org;
124: inv_mwb_globals.g_owning_org := p_owning_org;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
121: inv_mwb_globals.g_task_id := p_task_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
123: inv_mwb_globals.g_planning_org := p_planning_org;
124: inv_mwb_globals.g_owning_org := p_owning_org;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
122: inv_mwb_globals.g_unit_number := p_unit_number;
123: inv_mwb_globals.g_planning_org := p_planning_org;
124: inv_mwb_globals.g_owning_org := p_owning_org;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
123: inv_mwb_globals.g_planning_org := p_planning_org;
124: inv_mwb_globals.g_owning_org := p_owning_org;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
124: inv_mwb_globals.g_owning_org := p_owning_org;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
125: inv_mwb_globals.g_po_header_id := p_po_header_id;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
126: inv_mwb_globals.g_po_release_id := p_po_release_id;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
127: inv_mwb_globals.g_shipment_header_id_asn := p_shipment_header_id_asn;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
128: inv_mwb_globals.g_shipment_header_id_interorg := p_shipment_header_id_interorg;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
129: inv_mwb_globals.g_req_header_id := p_req_header_id;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
130: inv_mwb_globals.g_vendor_id := p_vendor_id;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
131: inv_mwb_globals.g_vendor_site_id := p_vendor_site_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
132: inv_mwb_globals.g_source_org_id := p_source_org_id;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
133: inv_mwb_globals.g_chk_inbound := p_chk_inbound;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
134: inv_mwb_globals.g_chk_receiving := p_chk_receiving;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
135: inv_mwb_globals.g_chk_onhand := p_chk_onhand;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
136: inv_mwb_globals.g_include_po_without_asn := p_include_po_without_asn;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
137: inv_mwb_globals.g_expected_from_date := p_expected_from_date;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
138: inv_mwb_globals.g_expected_to_date := p_expected_to_date;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
139: inv_mwb_globals.g_internal_order_id := p_internal_order_id;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
147: inv_mwb_globals.g_detailed := p_detailed;
140: inv_mwb_globals.g_vendor_item := p_vendor_item;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
147: inv_mwb_globals.g_detailed := p_detailed;
148: inv_mwb_globals.g_item_description := p_item_description;
141: inv_mwb_globals.g_grade_from_code := p_grade_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
147: inv_mwb_globals.g_detailed := p_detailed;
148: inv_mwb_globals.g_item_description := p_item_description;
149: inv_mwb_globals.g_qty_from := p_qty_from;
142: inv_mwb_globals.g_planning_query_mode := p_planning_query_mode;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
147: inv_mwb_globals.g_detailed := p_detailed;
148: inv_mwb_globals.g_item_description := p_item_description;
149: inv_mwb_globals.g_qty_from := p_qty_from;
150: inv_mwb_globals.g_qty_to := p_qty_to;
143: inv_mwb_globals.g_owning_qry_mode := p_owning_query_mode;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
147: inv_mwb_globals.g_detailed := p_detailed;
148: inv_mwb_globals.g_item_description := p_item_description;
149: inv_mwb_globals.g_qty_from := p_qty_from;
150: inv_mwb_globals.g_qty_to := p_qty_to;
151: inv_mwb_globals.g_view_by := p_view_by;
144: inv_mwb_globals.g_wms_enabled_flag := p_wms_enabled_flag;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
147: inv_mwb_globals.g_detailed := p_detailed;
148: inv_mwb_globals.g_item_description := p_item_description;
149: inv_mwb_globals.g_qty_from := p_qty_from;
150: inv_mwb_globals.g_qty_to := p_qty_to;
151: inv_mwb_globals.g_view_by := p_view_by;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
145: inv_mwb_globals.g_sub_type := p_subinventory_type;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
147: inv_mwb_globals.g_detailed := p_detailed;
148: inv_mwb_globals.g_item_description := p_item_description;
149: inv_mwb_globals.g_qty_from := p_qty_from;
150: inv_mwb_globals.g_qty_to := p_qty_to;
151: inv_mwb_globals.g_view_by := p_view_by;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
146: inv_mwb_globals.g_rcv_query_mode := p_rcv_query_mode;
147: inv_mwb_globals.g_detailed := p_detailed;
148: inv_mwb_globals.g_item_description := p_item_description;
149: inv_mwb_globals.g_qty_from := p_qty_from;
150: inv_mwb_globals.g_qty_to := p_qty_to;
151: inv_mwb_globals.g_view_by := p_view_by;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
154: inv_mwb_globals.g_check := p_check;
147: inv_mwb_globals.g_detailed := p_detailed;
148: inv_mwb_globals.g_item_description := p_item_description;
149: inv_mwb_globals.g_qty_from := p_qty_from;
150: inv_mwb_globals.g_qty_to := p_qty_to;
151: inv_mwb_globals.g_view_by := p_view_by;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
154: inv_mwb_globals.g_check := p_check;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
148: inv_mwb_globals.g_item_description := p_item_description;
149: inv_mwb_globals.g_qty_from := p_qty_from;
150: inv_mwb_globals.g_qty_to := p_qty_to;
151: inv_mwb_globals.g_view_by := p_view_by;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
154: inv_mwb_globals.g_check := p_check;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
149: inv_mwb_globals.g_qty_from := p_qty_from;
150: inv_mwb_globals.g_qty_to := p_qty_to;
151: inv_mwb_globals.g_view_by := p_view_by;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
154: inv_mwb_globals.g_check := p_check;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
150: inv_mwb_globals.g_qty_to := p_qty_to;
151: inv_mwb_globals.g_view_by := p_view_by;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
154: inv_mwb_globals.g_check := p_check;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
151: inv_mwb_globals.g_view_by := p_view_by;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
154: inv_mwb_globals.g_check := p_check;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
152: inv_mwb_globals.g_locator_control_code := p_locator_control_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
154: inv_mwb_globals.g_check := p_check;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
160: inv_mwb_globals.g_organization_code := p_organization_code;
153: inv_mwb_globals.g_wms_installed_flag := p_wms_installed_flag;
154: inv_mwb_globals.g_check := p_check;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
160: inv_mwb_globals.g_organization_code := p_organization_code;
161: inv_mwb_globals.g_locator_name := p_locator_name;
154: inv_mwb_globals.g_check := p_check;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
160: inv_mwb_globals.g_organization_code := p_organization_code;
161: inv_mwb_globals.g_locator_name := p_locator_name;
162: inv_mwb_globals.g_item_name := p_item_name;
155: inv_mwb_globals.g_serial_attr_query := p_serial_attr_query; -- Bug 6429880
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
160: inv_mwb_globals.g_organization_code := p_organization_code;
161: inv_mwb_globals.g_locator_name := p_locator_name;
162: inv_mwb_globals.g_item_name := p_item_name;
163: inv_mwb_globals.g_cost_group := p_cost_group;
156: inv_mwb_globals.g_lot_attr_query := p_lot_attr_query; -- Bug 7566588
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
160: inv_mwb_globals.g_organization_code := p_organization_code;
161: inv_mwb_globals.g_locator_name := p_locator_name;
162: inv_mwb_globals.g_item_name := p_item_name;
163: inv_mwb_globals.g_cost_group := p_cost_group;
164: inv_mwb_globals.g_project_number := p_project_number;
157: inv_mwb_globals.g_responsibility_id := p_responsibility_id;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
160: inv_mwb_globals.g_organization_code := p_organization_code;
161: inv_mwb_globals.g_locator_name := p_locator_name;
162: inv_mwb_globals.g_item_name := p_item_name;
163: inv_mwb_globals.g_cost_group := p_cost_group;
164: inv_mwb_globals.g_project_number := p_project_number;
165: inv_mwb_globals.g_task_number := p_task_number;
158: inv_mwb_globals.g_resp_application_id := p_resp_application_id;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
160: inv_mwb_globals.g_organization_code := p_organization_code;
161: inv_mwb_globals.g_locator_name := p_locator_name;
162: inv_mwb_globals.g_item_name := p_item_name;
163: inv_mwb_globals.g_cost_group := p_cost_group;
164: inv_mwb_globals.g_project_number := p_project_number;
165: inv_mwb_globals.g_task_number := p_task_number;
166: inv_mwb_globals.g_owning_party := p_owning_party;
159: inv_mwb_globals.g_is_projects_enabled_org := p_is_projects_enabled_org;
160: inv_mwb_globals.g_organization_code := p_organization_code;
161: inv_mwb_globals.g_locator_name := p_locator_name;
162: inv_mwb_globals.g_item_name := p_item_name;
163: inv_mwb_globals.g_cost_group := p_cost_group;
164: inv_mwb_globals.g_project_number := p_project_number;
165: inv_mwb_globals.g_task_number := p_task_number;
166: inv_mwb_globals.g_owning_party := p_owning_party;
167: inv_mwb_globals.g_planning_party := p_planning_party;
160: inv_mwb_globals.g_organization_code := p_organization_code;
161: inv_mwb_globals.g_locator_name := p_locator_name;
162: inv_mwb_globals.g_item_name := p_item_name;
163: inv_mwb_globals.g_cost_group := p_cost_group;
164: inv_mwb_globals.g_project_number := p_project_number;
165: inv_mwb_globals.g_task_number := p_task_number;
166: inv_mwb_globals.g_owning_party := p_owning_party;
167: inv_mwb_globals.g_planning_party := p_planning_party;
168: inv_mwb_globals.g_lpn_state := p_lpn_state;
161: inv_mwb_globals.g_locator_name := p_locator_name;
162: inv_mwb_globals.g_item_name := p_item_name;
163: inv_mwb_globals.g_cost_group := p_cost_group;
164: inv_mwb_globals.g_project_number := p_project_number;
165: inv_mwb_globals.g_task_number := p_task_number;
166: inv_mwb_globals.g_owning_party := p_owning_party;
167: inv_mwb_globals.g_planning_party := p_planning_party;
168: inv_mwb_globals.g_lpn_state := p_lpn_state;
169: inv_mwb_globals.g_status := p_status;
162: inv_mwb_globals.g_item_name := p_item_name;
163: inv_mwb_globals.g_cost_group := p_cost_group;
164: inv_mwb_globals.g_project_number := p_project_number;
165: inv_mwb_globals.g_task_number := p_task_number;
166: inv_mwb_globals.g_owning_party := p_owning_party;
167: inv_mwb_globals.g_planning_party := p_planning_party;
168: inv_mwb_globals.g_lpn_state := p_lpn_state;
169: inv_mwb_globals.g_status := p_status;
170: --KMOTUPAL ME # 3922793
163: inv_mwb_globals.g_cost_group := p_cost_group;
164: inv_mwb_globals.g_project_number := p_project_number;
165: inv_mwb_globals.g_task_number := p_task_number;
166: inv_mwb_globals.g_owning_party := p_owning_party;
167: inv_mwb_globals.g_planning_party := p_planning_party;
168: inv_mwb_globals.g_lpn_state := p_lpn_state;
169: inv_mwb_globals.g_status := p_status;
170: --KMOTUPAL ME # 3922793
171: inv_mwb_globals.g_expired_lots := p_expired_lots;
164: inv_mwb_globals.g_project_number := p_project_number;
165: inv_mwb_globals.g_task_number := p_task_number;
166: inv_mwb_globals.g_owning_party := p_owning_party;
167: inv_mwb_globals.g_planning_party := p_planning_party;
168: inv_mwb_globals.g_lpn_state := p_lpn_state;
169: inv_mwb_globals.g_status := p_status;
170: --KMOTUPAL ME # 3922793
171: inv_mwb_globals.g_expired_lots := p_expired_lots;
172: inv_mwb_globals.g_expiration_date := p_expiration_date;
165: inv_mwb_globals.g_task_number := p_task_number;
166: inv_mwb_globals.g_owning_party := p_owning_party;
167: inv_mwb_globals.g_planning_party := p_planning_party;
168: inv_mwb_globals.g_lpn_state := p_lpn_state;
169: inv_mwb_globals.g_status := p_status;
170: --KMOTUPAL ME # 3922793
171: inv_mwb_globals.g_expired_lots := p_expired_lots;
172: inv_mwb_globals.g_expiration_date := p_expiration_date;
173: inv_mwb_globals.g_parent_lot := p_parent_lot; -- BUG 7556505
167: inv_mwb_globals.g_planning_party := p_planning_party;
168: inv_mwb_globals.g_lpn_state := p_lpn_state;
169: inv_mwb_globals.g_status := p_status;
170: --KMOTUPAL ME # 3922793
171: inv_mwb_globals.g_expired_lots := p_expired_lots;
172: inv_mwb_globals.g_expiration_date := p_expiration_date;
173: inv_mwb_globals.g_parent_lot := p_parent_lot; -- BUG 7556505
174: inv_mwb_globals.g_shipment_header_id := p_shipment_header_id; -- Bug 6633612
175:
168: inv_mwb_globals.g_lpn_state := p_lpn_state;
169: inv_mwb_globals.g_status := p_status;
170: --KMOTUPAL ME # 3922793
171: inv_mwb_globals.g_expired_lots := p_expired_lots;
172: inv_mwb_globals.g_expiration_date := p_expiration_date;
173: inv_mwb_globals.g_parent_lot := p_parent_lot; -- BUG 7556505
174: inv_mwb_globals.g_shipment_header_id := p_shipment_header_id; -- Bug 6633612
175:
176:
169: inv_mwb_globals.g_status := p_status;
170: --KMOTUPAL ME # 3922793
171: inv_mwb_globals.g_expired_lots := p_expired_lots;
172: inv_mwb_globals.g_expiration_date := p_expiration_date;
173: inv_mwb_globals.g_parent_lot := p_parent_lot; -- BUG 7556505
174: inv_mwb_globals.g_shipment_header_id := p_shipment_header_id; -- Bug 6633612
175:
176:
177: IF (inv_mwb_globals.g_chk_onhand = 1
170: --KMOTUPAL ME # 3922793
171: inv_mwb_globals.g_expired_lots := p_expired_lots;
172: inv_mwb_globals.g_expiration_date := p_expiration_date;
173: inv_mwb_globals.g_parent_lot := p_parent_lot; -- BUG 7556505
174: inv_mwb_globals.g_shipment_header_id := p_shipment_header_id; -- Bug 6633612
175:
176:
177: IF (inv_mwb_globals.g_chk_onhand = 1
178: AND inv_mwb_globals.g_chk_receiving = 1)
173: inv_mwb_globals.g_parent_lot := p_parent_lot; -- BUG 7556505
174: inv_mwb_globals.g_shipment_header_id := p_shipment_header_id; -- Bug 6633612
175:
176:
177: IF (inv_mwb_globals.g_chk_onhand = 1
178: AND inv_mwb_globals.g_chk_receiving = 1)
179: OR (inv_mwb_globals.g_chk_onhand = 1
180: AND inv_mwb_globals.g_chk_inbound = 1)
181: OR (inv_mwb_globals.g_chk_receiving = 1
174: inv_mwb_globals.g_shipment_header_id := p_shipment_header_id; -- Bug 6633612
175:
176:
177: IF (inv_mwb_globals.g_chk_onhand = 1
178: AND inv_mwb_globals.g_chk_receiving = 1)
179: OR (inv_mwb_globals.g_chk_onhand = 1
180: AND inv_mwb_globals.g_chk_inbound = 1)
181: OR (inv_mwb_globals.g_chk_receiving = 1
182: AND inv_mwb_globals.g_chk_inbound = 1)
175:
176:
177: IF (inv_mwb_globals.g_chk_onhand = 1
178: AND inv_mwb_globals.g_chk_receiving = 1)
179: OR (inv_mwb_globals.g_chk_onhand = 1
180: AND inv_mwb_globals.g_chk_inbound = 1)
181: OR (inv_mwb_globals.g_chk_receiving = 1
182: AND inv_mwb_globals.g_chk_inbound = 1)
183: THEN
176:
177: IF (inv_mwb_globals.g_chk_onhand = 1
178: AND inv_mwb_globals.g_chk_receiving = 1)
179: OR (inv_mwb_globals.g_chk_onhand = 1
180: AND inv_mwb_globals.g_chk_inbound = 1)
181: OR (inv_mwb_globals.g_chk_receiving = 1
182: AND inv_mwb_globals.g_chk_inbound = 1)
183: THEN
184: inv_mwb_globals.g_multiple_loc_selected := 'TRUE';
177: IF (inv_mwb_globals.g_chk_onhand = 1
178: AND inv_mwb_globals.g_chk_receiving = 1)
179: OR (inv_mwb_globals.g_chk_onhand = 1
180: AND inv_mwb_globals.g_chk_inbound = 1)
181: OR (inv_mwb_globals.g_chk_receiving = 1
182: AND inv_mwb_globals.g_chk_inbound = 1)
183: THEN
184: inv_mwb_globals.g_multiple_loc_selected := 'TRUE';
185: ELSE
178: AND inv_mwb_globals.g_chk_receiving = 1)
179: OR (inv_mwb_globals.g_chk_onhand = 1
180: AND inv_mwb_globals.g_chk_inbound = 1)
181: OR (inv_mwb_globals.g_chk_receiving = 1
182: AND inv_mwb_globals.g_chk_inbound = 1)
183: THEN
184: inv_mwb_globals.g_multiple_loc_selected := 'TRUE';
185: ELSE
186: inv_mwb_globals.g_multiple_loc_selected := 'FALSE';
180: AND inv_mwb_globals.g_chk_inbound = 1)
181: OR (inv_mwb_globals.g_chk_receiving = 1
182: AND inv_mwb_globals.g_chk_inbound = 1)
183: THEN
184: inv_mwb_globals.g_multiple_loc_selected := 'TRUE';
185: ELSE
186: inv_mwb_globals.g_multiple_loc_selected := 'FALSE';
187: END IF;
188:
182: AND inv_mwb_globals.g_chk_inbound = 1)
183: THEN
184: inv_mwb_globals.g_multiple_loc_selected := 'TRUE';
185: ELSE
186: inv_mwb_globals.g_multiple_loc_selected := 'FALSE';
187: END IF;
188:
189:
190: inv_mwb_globals.print_parameters;
186: inv_mwb_globals.g_multiple_loc_selected := 'FALSE';
187: END IF;
188:
189:
190: inv_mwb_globals.print_parameters;
191:
192: END PROCESS_QUERY;
193:
194: PROCEDURE SET_TREE_GLOBALS(
226: l_procedure_name CONSTANT VARCHAR2(30) := 'SET_TREE_GLOBALS';
227:
228: BEGIN
229:
230: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered' );
231:
232: inv_mwb_globals.g_tree_organization_id := p_tree_organization_id;
233: inv_mwb_globals.g_tree_loc_id := p_tree_loc_id;
234: inv_mwb_globals.g_tree_subinventory_code := p_tree_subinventory_code;
228: BEGIN
229:
230: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered' );
231:
232: inv_mwb_globals.g_tree_organization_id := p_tree_organization_id;
233: inv_mwb_globals.g_tree_loc_id := p_tree_loc_id;
234: inv_mwb_globals.g_tree_subinventory_code := p_tree_subinventory_code;
235: inv_mwb_globals.g_tree_item_id := p_tree_item_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
229:
230: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered' );
231:
232: inv_mwb_globals.g_tree_organization_id := p_tree_organization_id;
233: inv_mwb_globals.g_tree_loc_id := p_tree_loc_id;
234: inv_mwb_globals.g_tree_subinventory_code := p_tree_subinventory_code;
235: inv_mwb_globals.g_tree_item_id := p_tree_item_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
230: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered' );
231:
232: inv_mwb_globals.g_tree_organization_id := p_tree_organization_id;
233: inv_mwb_globals.g_tree_loc_id := p_tree_loc_id;
234: inv_mwb_globals.g_tree_subinventory_code := p_tree_subinventory_code;
235: inv_mwb_globals.g_tree_item_id := p_tree_item_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
231:
232: inv_mwb_globals.g_tree_organization_id := p_tree_organization_id;
233: inv_mwb_globals.g_tree_loc_id := p_tree_loc_id;
234: inv_mwb_globals.g_tree_subinventory_code := p_tree_subinventory_code;
235: inv_mwb_globals.g_tree_item_id := p_tree_item_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
232: inv_mwb_globals.g_tree_organization_id := p_tree_organization_id;
233: inv_mwb_globals.g_tree_loc_id := p_tree_loc_id;
234: inv_mwb_globals.g_tree_subinventory_code := p_tree_subinventory_code;
235: inv_mwb_globals.g_tree_item_id := p_tree_item_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
233: inv_mwb_globals.g_tree_loc_id := p_tree_loc_id;
234: inv_mwb_globals.g_tree_subinventory_code := p_tree_subinventory_code;
235: inv_mwb_globals.g_tree_item_id := p_tree_item_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
234: inv_mwb_globals.g_tree_subinventory_code := p_tree_subinventory_code;
235: inv_mwb_globals.g_tree_item_id := p_tree_item_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
235: inv_mwb_globals.g_tree_item_id := p_tree_item_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
236: inv_mwb_globals.g_tree_parent_lpn_id := p_tree_plpn_id;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
237: inv_mwb_globals.g_tree_mat_loc_id := p_tree_mat_loc_id;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
238: inv_mwb_globals.g_tree_doc_type_id := p_tree_doc_type_id;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
239: inv_mwb_globals.g_tree_doc_num := p_tree_doc_num;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
240: inv_mwb_globals.g_tree_doc_header_id := p_tree_doc_header_id;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
241: inv_mwb_globals.g_tree_st_id := p_tree_st_id;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
242: inv_mwb_globals.g_tree_rev := p_tree_rev;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
243: inv_mwb_globals.g_tree_cg_id := p_tree_cg_id;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
244: inv_mwb_globals.g_tree_grade_code := p_tree_grade;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
252: inv_mwb_globals.g_view_by := p_view_by;
245: inv_mwb_globals.g_tree_lot_number := p_tree_lot;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
252: inv_mwb_globals.g_view_by := p_view_by;
253: inv_mwb_globals.g_tree_event := p_tree_event;
246: inv_mwb_globals.g_tree_serial_number := p_tree_serial;
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
252: inv_mwb_globals.g_view_by := p_view_by;
253: inv_mwb_globals.g_tree_event := p_tree_event;
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
247: inv_mwb_globals.g_tree_node_type := p_tree_node_type;
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
252: inv_mwb_globals.g_view_by := p_view_by;
253: inv_mwb_globals.g_tree_event := p_tree_event;
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
248: inv_mwb_globals.g_tree_node_state := p_tree_node_state;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
252: inv_mwb_globals.g_view_by := p_view_by;
253: inv_mwb_globals.g_tree_event := p_tree_event;
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
249: inv_mwb_globals.g_tree_node_high_value := p_tree_node_high_value;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
252: inv_mwb_globals.g_view_by := p_view_by;
253: inv_mwb_globals.g_tree_event := p_tree_event;
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
257: inv_mwb_globals.g_tree_attribute_qf_serial := p_attribute_qf_serial;
250: inv_mwb_globals.g_tree_node_low_value := p_tree_node_low_value;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
252: inv_mwb_globals.g_view_by := p_view_by;
253: inv_mwb_globals.g_tree_event := p_tree_event;
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
257: inv_mwb_globals.g_tree_attribute_qf_serial := p_attribute_qf_serial;
258: inv_mwb_globals.g_tree_query_lot_attr := p_query_lot_attr;
251: inv_mwb_globals.g_tree_node_value := p_tree_node_value;
252: inv_mwb_globals.g_view_by := p_view_by;
253: inv_mwb_globals.g_tree_event := p_tree_event;
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
257: inv_mwb_globals.g_tree_attribute_qf_serial := p_attribute_qf_serial;
258: inv_mwb_globals.g_tree_query_lot_attr := p_query_lot_attr;
259: inv_mwb_globals.g_tree_query_serial_attr := p_query_serial_attr;
252: inv_mwb_globals.g_view_by := p_view_by;
253: inv_mwb_globals.g_tree_event := p_tree_event;
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
257: inv_mwb_globals.g_tree_attribute_qf_serial := p_attribute_qf_serial;
258: inv_mwb_globals.g_tree_query_lot_attr := p_query_lot_attr;
259: inv_mwb_globals.g_tree_query_serial_attr := p_query_serial_attr;
260: inv_mwb_globals.g_containerized := p_is_containerized;
253: inv_mwb_globals.g_tree_event := p_tree_event;
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
257: inv_mwb_globals.g_tree_attribute_qf_serial := p_attribute_qf_serial;
258: inv_mwb_globals.g_tree_query_lot_attr := p_query_lot_attr;
259: inv_mwb_globals.g_tree_query_serial_attr := p_query_serial_attr;
260: inv_mwb_globals.g_containerized := p_is_containerized;
261: -- Bug 9865190 Start
254: inv_mwb_globals.g_tree_serial_attr_query := p_tree_serial_attr_query; -- Bug 6429880
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
257: inv_mwb_globals.g_tree_attribute_qf_serial := p_attribute_qf_serial;
258: inv_mwb_globals.g_tree_query_lot_attr := p_query_lot_attr;
259: inv_mwb_globals.g_tree_query_serial_attr := p_query_serial_attr;
260: inv_mwb_globals.g_containerized := p_is_containerized;
261: -- Bug 9865190 Start
262: IF (NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id) IS NOT NULL) THEN
255: inv_mwb_globals.g_tree_lot_attr_query := p_tree_lot_attr_query; -- Bug 7566588
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
257: inv_mwb_globals.g_tree_attribute_qf_serial := p_attribute_qf_serial;
258: inv_mwb_globals.g_tree_query_lot_attr := p_query_lot_attr;
259: inv_mwb_globals.g_tree_query_serial_attr := p_query_serial_attr;
260: inv_mwb_globals.g_containerized := p_is_containerized;
261: -- Bug 9865190 Start
262: IF (NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id) IS NOT NULL) THEN
263: SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
256: inv_mwb_globals.g_tree_attribute_qf_lot := p_tree_attribute_qf_lot;
257: inv_mwb_globals.g_tree_attribute_qf_serial := p_attribute_qf_serial;
258: inv_mwb_globals.g_tree_query_lot_attr := p_query_lot_attr;
259: inv_mwb_globals.g_tree_query_serial_attr := p_query_serial_attr;
260: inv_mwb_globals.g_containerized := p_is_containerized;
261: -- Bug 9865190 Start
262: IF (NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id) IS NOT NULL) THEN
263: SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
264: INTO inv_mwb_globals.g_wms_enabled_flag
258: inv_mwb_globals.g_tree_query_lot_attr := p_query_lot_attr;
259: inv_mwb_globals.g_tree_query_serial_attr := p_query_serial_attr;
260: inv_mwb_globals.g_containerized := p_is_containerized;
261: -- Bug 9865190 Start
262: IF (NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id) IS NOT NULL) THEN
263: SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
264: INTO inv_mwb_globals.g_wms_enabled_flag
265: FROM mtl_parameters
266: WHERE organization_id = NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id);
260: inv_mwb_globals.g_containerized := p_is_containerized;
261: -- Bug 9865190 Start
262: IF (NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id) IS NOT NULL) THEN
263: SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
264: INTO inv_mwb_globals.g_wms_enabled_flag
265: FROM mtl_parameters
266: WHERE organization_id = NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id);
267: END IF;
268: -- Bug 9865190 End
262: IF (NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id) IS NOT NULL) THEN
263: SELECT DECODE(wms_enabled_flag, 'Y', 1, 0)
264: INTO inv_mwb_globals.g_wms_enabled_flag
265: FROM mtl_parameters
266: WHERE organization_id = NVL(p_tree_organization_id, inv_mwb_globals.g_organization_id);
267: END IF;
268: -- Bug 9865190 End
269: /*
270: * Temp changes for testing
268: -- Bug 9865190 End
269: /*
270: * Temp changes for testing
271: */
272: inv_mwb_globals.print_parameters;
273:
274:
275: END SET_TREE_GLOBALS;
276:
283:
284: l_procedure_name CONSTANT VARCHAR2(30) := 'EVENT';
285: BEGIN
286:
287: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
288:
289: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, inv_mwb_globals.g_view_by );
290:
291: /*
285: BEGIN
286:
287: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
288:
289: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, inv_mwb_globals.g_view_by );
290:
291: /*
292: * Initialize engine
293: * -- Truncate table
292: * Initialize engine
293: * -- Truncate table
294: * -- Initialize/reset the query engine..
295: */
296: inv_mwb_globals.g_revision_controlled := 0;
297: inv_mwb_globals.g_lot_controlled := 0;
298: inv_mwb_globals.g_locator_controlled := 0;
299: inv_mwb_globals.g_inserted_under_org := 'N';
300:
293: * -- Truncate table
294: * -- Initialize/reset the query engine..
295: */
296: inv_mwb_globals.g_revision_controlled := 0;
297: inv_mwb_globals.g_lot_controlled := 0;
298: inv_mwb_globals.g_locator_controlled := 0;
299: inv_mwb_globals.g_inserted_under_org := 'N';
300:
301: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
294: * -- Initialize/reset the query engine..
295: */
296: inv_mwb_globals.g_revision_controlled := 0;
297: inv_mwb_globals.g_lot_controlled := 0;
298: inv_mwb_globals.g_locator_controlled := 0;
299: inv_mwb_globals.g_inserted_under_org := 'N';
300:
301: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
302: initialize;
295: */
296: inv_mwb_globals.g_revision_controlled := 0;
297: inv_mwb_globals.g_lot_controlled := 0;
298: inv_mwb_globals.g_locator_controlled := 0;
299: inv_mwb_globals.g_inserted_under_org := 'N';
300:
301: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
302: initialize;
303: END IF;
297: inv_mwb_globals.g_lot_controlled := 0;
298: inv_mwb_globals.g_locator_controlled := 0;
299: inv_mwb_globals.g_inserted_under_org := 'N';
300:
301: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
302: initialize;
303: END IF;
304:
305: CASE inv_mwb_globals.g_view_by
301: IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
302: initialize;
303: END IF;
304:
305: CASE inv_mwb_globals.g_view_by
306:
307: WHEN 'LOCATION' THEN
308: inv_mwb_location_tree.event(
309: x_node_value
357: END CASE;
358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: inv_mwb_globals.print_msg(
362: g_pkg_name,
363: l_procedure_name,
364: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE
365: );
362: g_pkg_name,
363: l_procedure_name,
364: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE
365: );
366: inv_mwb_globals.print_msg(
367: g_pkg_name,
368: l_procedure_name,
369: DBMS_UTILITY.FORMAT_ERROR_STACK
370: );
391: FUNCTION GET_LAST_QUERY RETURN LONG
392: IS
393: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_LAST_QUERY';
394: BEGIN
395: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');
396: return inv_mwb_globals.g_last_query;
397: END;
398:
399: END INV_MWB_CONTROLLER;
392: IS
393: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_LAST_QUERY';
394: BEGIN
395: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered');
396: return inv_mwb_globals.g_last_query;
397: END;
398:
399: END INV_MWB_CONTROLLER;