APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on INV_MATERIAL_STATUS_GRP

Line 7279: AND inv_material_status_grp.is_status_applicable(

7275: wlpn.lpn_context = 1
7276: AND NVL(wlpn.subinventory_code, '@') = NVL(p_sub, NVL(wlpn.subinventory_code, '@'))
7277: AND NVL(wlpn.locator_id, '0') = NVL(p_loc_id, NVL(wlpn.locator_id, '0'))
7278: AND NOT wlpn.license_plate_number = NVL(p_from_lpn, -999)
7279: AND inv_material_status_grp.is_status_applicable(
7280: 'TRUE'
7281: , NULL
7282: , inv_globals.g_type_container_pack
7283: , NULL

Line 7293: AND inv_material_status_grp.is_status_applicable(

7289: , NULL
7290: , NULL
7291: , 'Z'
7292: ) = 'Y'
7293: AND inv_material_status_grp.is_status_applicable(
7294: 'TRUE'
7295: , NULL
7296: , inv_globals.g_type_container_pack
7297: , NULL

Line 7534: IF inv_material_status_grp.is_status_applicable(

7530: LOOP
7531: FETCH ser_csr INTO l_serial_number;
7532: EXIT WHEN ser_csr%NOTFOUND;
7533:
7534: IF inv_material_status_grp.is_status_applicable(
7535: p_wms_installed => 'TRUE'
7536: , p_trx_status_enabled => NULL
7537: , p_trx_type_id => l_txn_type_id
7538: , p_lot_status_enabled => NULL

Line 7559: IF inv_material_status_grp.is_status_applicable(

7555: END LOOP;
7556:
7557: CLOSE ser_csr;
7558: ELSE
7559: IF inv_material_status_grp.is_status_applicable(
7560: p_wms_installed => 'TRUE'
7561: , p_trx_status_enabled => NULL
7562: , p_trx_type_id => l_txn_type_id
7563: , p_lot_status_enabled => NULL

Line 7598: IF inv_material_status_grp.is_status_applicable(

7594: LOOP
7595: FETCH ser_csr INTO l_serial_number;
7596: EXIT WHEN ser_csr%NOTFOUND;
7597:
7598: IF inv_material_status_grp.is_status_applicable(
7599: p_wms_installed => 'TRUE'
7600: , p_trx_status_enabled => NULL
7601: , p_trx_type_id => l_txn_type_id
7602: , p_lot_status_enabled => NULL

Line 7627: IF inv_material_status_grp.is_status_applicable(

7623: IF (l_debug = 1) THEN
7624: mydebug('check_mmtt_mtl_status: No controls');
7625: END IF;
7626:
7627: IF inv_material_status_grp.is_status_applicable(
7628: p_wms_installed => 'TRUE'
7629: , p_trx_status_enabled => NULL
7630: , p_trx_type_id => l_txn_type_id
7631: , p_lot_status_enabled => NULL

Line 9102: inv_material_status_grp.is_status_applicable(

9098: l_progress := '30';
9099: -- Check if the lot material status is valid
9100: -- for the current move order line's transaction type
9101: l_return :=
9102: inv_material_status_grp.is_status_applicable(
9103: p_wms_installed => 'TRUE'
9104: , p_trx_status_enabled => NULL
9105: , p_trx_type_id => l_transaction_type
9106: , p_lot_status_enabled => NULL

Line 9148: inv_material_status_grp.is_status_applicable(

9144: l_progress := '50';
9145: -- Check if the serial material status is valid
9146: -- for the current move order line's transaction type
9147: l_return :=
9148: inv_material_status_grp.is_status_applicable(
9149: p_wms_installed => 'TRUE'
9150: , p_trx_status_enabled => NULL
9151: , p_trx_type_id => l_transaction_type
9152: , p_lot_status_enabled => NULL