APPS.WMS_RULE_PVT dependencies on INV_VALIDATE

Line 57: g_locator INV_VALIDATE.locator;

53: g_qty_tree_api_version CONSTANT NUMBER := 1.0; -- INV_Quantity_Tree_PVT
54: --
55: -- Caching locator record in DoProjectCheck
56: g_locator_id NUMBER;
57: g_locator INV_VALIDATE.locator;
58: g_transaction_type_id NUMBER;
59: g_organization_id NUMBER;
60: g_inventory_item_id NUMBER;
61: g_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

Line 8325: --bug 2349283 - the INV_Validate function updates the locator table,

8321: log_procedure(l_api_name, 'end', 'End Invalidate_Lpn_Group');
8322: END IF;
8323: END invalidate_lpn_group;
8324:
8325: --bug 2349283 - the INV_Validate function updates the locator table,
8326: --thus locking the table. The UpdateLocCapacity function called in
8327: --Apply for putaway rules also updates the locator table, but in a
8328: -- different session. It tries to get a lock on the table, but
8329: --can't. So, we get a deadlock. To resolve this, we make this

Line 8341: /*l_locator inv_validate.LOCATOR;

8337: , x_exist_locator_id OUT NOCOPY NUMBER --Added bug3237702
8338: )
8339: RETURN BOOLEAN IS
8340: PRAGMA AUTONOMOUS_TRANSACTION;
8341: /*l_locator inv_validate.LOCATOR;
8342: l_org inv_validate.org;
8343: l_sub inv_validate.sub;*/
8344: success NUMBER;
8345: retval BOOLEAN;

Line 8342: l_org inv_validate.org;

8338: )
8339: RETURN BOOLEAN IS
8340: PRAGMA AUTONOMOUS_TRANSACTION;
8341: /*l_locator inv_validate.LOCATOR;
8342: l_org inv_validate.org;
8343: l_sub inv_validate.sub;*/
8344: success NUMBER;
8345: retval BOOLEAN;
8346: BEGIN

Line 8343: l_sub inv_validate.sub;*/

8339: RETURN BOOLEAN IS
8340: PRAGMA AUTONOMOUS_TRANSACTION;
8341: /*l_locator inv_validate.LOCATOR;
8342: l_org inv_validate.org;
8343: l_sub inv_validate.sub;*/
8344: success NUMBER;
8345: retval BOOLEAN;
8346: BEGIN
8347: x_exist_locator_id := NULL;

Line 8400: success := INV_Validate.ValidateLocator(

8396: from mtl_secondary_inventories
8397: where secondary_inventory_name = l_locator.subinventory_code
8398: and organization_id = l_locator.organization_id;
8399: */
8400: success := INV_Validate.ValidateLocator(
8401: p_locator => g_locator,
8402: p_org => inv_cache.org_rec,
8403: p_sub => inv_cache.tosub_rec,
8404: p_validation_mode => INV_Validate.EXISTS_OR_CREATE,

Line 8404: p_validation_mode => INV_Validate.EXISTS_OR_CREATE,

8400: success := INV_Validate.ValidateLocator(
8401: p_locator => g_locator,
8402: p_org => inv_cache.org_rec,
8403: p_sub => inv_cache.tosub_rec,
8404: p_validation_mode => INV_Validate.EXISTS_OR_CREATE,
8405: p_value_or_id => 'I');
8406:
8407: COMMIT;
8408:

Line 8410: if( success = INV_Validate.T and FND_FLEX_KEYVAL.new_combination) then

8406:
8407: COMMIT;
8408:
8409: x_new_locator_id := g_locator.inventory_location_id;
8410: if( success = INV_Validate.T and FND_FLEX_KEYVAL.new_combination) then
8411: return TRUE;
8412: END IF;
8413:
8414: x_exist_locator_id := g_locator.inventory_location_id;