673: g_pkg_name constant VARCHAR2(50) := 'WMS_SELECTION_CRITERIA_PVT';
674: l_api_version CONSTANT NUMBER := 1.0;
675: l_api_name constant VARCHAR2(30) := 'SEARCH';
676:
677: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
678:
679:
680: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
681: l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1061: g_pkg_name constant VARCHAR2(50) := 'WMS_SELECTION_CRITERIA_PVT';
1062: l_api_version CONSTANT NUMBER := 1.0;
1063: l_api_name constant VARCHAR2(30) := 'CG_MMTT_SEARCH';
1064:
1065: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1066:
1067: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
1068: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1069:
1809:
1810: g_pkg_name constant VARCHAR2(50) := 'WMS_RULES_WORKBENCH_PVT';
1811: l_api_version CONSTANT NUMBER := 1.0;
1812: l_api_name constant VARCHAR2(30) := 'cross_dock_search';
1813: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1814:
1815: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
1816: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
1817: l_return_type_id wms_selection_criteria_txn.return_type_id%type;