APPS.WMS_TASK_LOAD dependencies on INV_MATERIAL_STATUS_GRP

Line 8434: AND inv_material_status_grp.is_status_applicable(

8430: , mtlt.lot_number
8431: FROM mtl_transaction_lots_temp mtlt
8432: WHERE mtlt.transaction_temp_id = p_temp_id
8433: --added material status check for lot under bug8398578
8434: AND inv_material_status_grp.is_status_applicable(
8435: p_wms_installed
8436: , NULL
8437: , p_transaction_type_id
8438: , NULL

Line 11393: IF inv_material_status_grp.is_status_applicable(

11389: LOOP
11390: FETCH ser_csr INTO l_serial_number;
11391: EXIT WHEN ser_csr%NOTFOUND;
11392:
11393: IF inv_material_status_grp.is_status_applicable(
11394: p_wms_installed => p_wms_installed
11395: , p_trx_status_enabled => NULL
11396: , p_trx_type_id => p_transaction_type_id
11397: , p_lot_status_enabled => NULL

Line 11425: IF inv_material_status_grp.is_status_applicable(

11421: ELSE
11422: l_serial_number := NULL;
11423:
11424: -- Check whether the LPN status is applicable for this transaction
11425: IF inv_material_status_grp.is_status_applicable(
11426: p_wms_installed => p_wms_installed
11427: , p_trx_status_enabled => NULL
11428: , p_trx_type_id => p_transaction_type_id
11429: , p_lot_status_enabled => NULL

Line 12067: AND inv_material_status_grp.is_status_applicable(

12063: , mtlt.lot_number
12064: FROM mtl_transaction_lots_temp mtlt
12065: WHERE mtlt.transaction_temp_id = p_temp_id
12066: --added material status check for lot under bug8398578
12067: AND inv_material_status_grp.is_status_applicable(
12068: NULL
12069: , NULL
12070: , p_transaction_type_id
12071: , NULL

Line 14164: IF inv_material_status_grp.is_status_applicable(

14160: , l_item_id
14161: FROM mtl_material_transactions_temp mmtt
14162: WHERE mmtt.transaction_temp_id = p_temp_id;
14163:
14164: IF inv_material_status_grp.is_status_applicable(
14165: p_wms_installed => p_wms_installed
14166: , p_trx_status_enabled => NULL
14167: , p_trx_type_id => l_transaction_type_id
14168: , p_lot_status_enabled => NULL

Line 14178: AND inv_material_status_grp.is_status_applicable(

14174: , p_lot_number => NULL
14175: , p_serial_number => NULL
14176: , p_object_type => 'Z'
14177: ) = 'Y'
14178: AND inv_material_status_grp.is_status_applicable(
14179: p_wms_installed => p_wms_installed
14180: , p_trx_status_enabled => NULL
14181: , p_trx_type_id => l_transaction_type_id
14182: , p_lot_status_enabled => NULL