APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on INV_MATERIAL_STATUS_GRP

Line 6952: AND inv_material_status_grp.is_status_applicable(

6948: wlpn.lpn_context = 1
6949: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(wlpn.subinventory_code, '@'))
6950: AND NVL(wlpn.locator_id, '0') = NVL(p_loc_id, NVL(wlpn.locator_id, '0'))
6951: AND NOT wlpn.license_plate_number = NVL(p_from_lpn, -999)
6952: AND inv_material_status_grp.is_status_applicable(
6953: 'TRUE'
6954: , NULL
6955: , inv_globals.g_type_container_pack
6956: , NULL

Line 6966: AND inv_material_status_grp.is_status_applicable(

6962: , NULL
6963: , NULL
6964: , 'Z'
6965: ) = 'Y'
6966: AND inv_material_status_grp.is_status_applicable(
6967: 'TRUE'
6968: , NULL
6969: , inv_globals.g_type_container_pack
6970: , NULL

Line 7207: IF inv_material_status_grp.is_status_applicable(

7203: LOOP
7204: FETCH ser_csr INTO l_serial_number;
7205: EXIT WHEN ser_csr%NOTFOUND;
7206:
7207: IF inv_material_status_grp.is_status_applicable(
7208: p_wms_installed => 'TRUE'
7209: , p_trx_status_enabled => NULL
7210: , p_trx_type_id => l_txn_type_id
7211: , p_lot_status_enabled => NULL

Line 7232: IF inv_material_status_grp.is_status_applicable(

7228: END LOOP;
7229:
7230: CLOSE ser_csr;
7231: ELSE
7232: IF inv_material_status_grp.is_status_applicable(
7233: p_wms_installed => 'TRUE'
7234: , p_trx_status_enabled => NULL
7235: , p_trx_type_id => l_txn_type_id
7236: , p_lot_status_enabled => NULL

Line 7271: IF inv_material_status_grp.is_status_applicable(

7267: LOOP
7268: FETCH ser_csr INTO l_serial_number;
7269: EXIT WHEN ser_csr%NOTFOUND;
7270:
7271: IF inv_material_status_grp.is_status_applicable(
7272: p_wms_installed => 'TRUE'
7273: , p_trx_status_enabled => NULL
7274: , p_trx_type_id => l_txn_type_id
7275: , p_lot_status_enabled => NULL

Line 7300: IF inv_material_status_grp.is_status_applicable(

7296: IF (l_debug = 1) THEN
7297: mydebug('check_mmtt_mtl_status: No controls');
7298: END IF;
7299:
7300: IF inv_material_status_grp.is_status_applicable(
7301: p_wms_installed => 'TRUE'
7302: , p_trx_status_enabled => NULL
7303: , p_trx_type_id => l_txn_type_id
7304: , p_lot_status_enabled => NULL

Line 8745: inv_material_status_grp.is_status_applicable(

8741: l_progress := '30';
8742: -- Check if the lot material status is valid
8743: -- for the current move order line's transaction type
8744: l_return :=
8745: inv_material_status_grp.is_status_applicable(
8746: p_wms_installed => 'TRUE'
8747: , p_trx_status_enabled => NULL
8748: , p_trx_type_id => l_transaction_type
8749: , p_lot_status_enabled => NULL

Line 8791: inv_material_status_grp.is_status_applicable(

8787: l_progress := '50';
8788: -- Check if the serial material status is valid
8789: -- for the current move order line's transaction type
8790: l_return :=
8791: inv_material_status_grp.is_status_applicable(
8792: p_wms_installed => 'TRUE'
8793: , p_trx_status_enabled => NULL
8794: , p_trx_type_id => l_transaction_type
8795: , p_lot_status_enabled => NULL