DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on INV_MATERIAL_STATUS_GRP

Line 6056: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,

6052: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
6053: l_locator MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
6054: BEGIN
6055: IF (p_inventory_item_id IS NOT NULL and p_sub_code IS NOT NULL) THEN
6056: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,
6057: p_trx_status_enabled => p_trx_status_enabled ,
6058: p_trx_type_id => p_trx_type_id ,
6059: p_lot_status_enabled => p_lot_status_enabled ,
6060: p_serial_status_enabled => p_serial_status_enabled,

Line 6080: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,

6076: return l_status_applicable;
6077: END IF;
6078:
6079: IF (p_locator_id IS NOT NULL) THEN
6080: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,
6081: p_trx_status_enabled => p_trx_status_enabled ,
6082: p_trx_type_id => p_trx_type_id ,
6083: p_lot_status_enabled => p_lot_status_enabled ,
6084: p_serial_status_enabled => p_serial_status_enabled,

Line 6108: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,

6104: return l_status_applicable;
6105: END IF;
6106:
6107: IF (p_lot_number IS NOT NULL) THEN
6108: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,
6109: p_trx_status_enabled => p_trx_status_enabled ,
6110: p_trx_type_id => p_trx_type_id ,
6111: p_lot_status_enabled => p_lot_status_enabled ,
6112: p_serial_status_enabled => p_serial_status_enabled,

Line 6137: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,

6133: return l_status_applicable;
6134: END IF;
6135:
6136: IF (p_serial_number IS NOT NULL) THEN
6137: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,
6138: p_trx_status_enabled => p_trx_status_enabled ,
6139: p_trx_type_id => p_trx_type_id ,
6140: p_lot_status_enabled => p_lot_status_enabled ,
6141: p_serial_status_enabled => p_serial_status_enabled,