APPS.WMS_RULE_PVT dependencies on INV_VALIDATE

Line 40: g_locator INV_VALIDATE.locator;

36: g_qty_tree_api_version CONSTANT NUMBER := 1.0; -- INV_Quantity_Tree_PVT
37: --
38: -- Caching locator record in DoProjectCheck
39: g_locator_id NUMBER;
40: g_locator INV_VALIDATE.locator;
41: g_transaction_type_id NUMBER;
42: g_organization_id NUMBER;
43: g_inventory_item_id NUMBER;
44: g_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE;

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

6358: log_procedure(l_api_name, 'end', 'End Invalidate_Lpn_Group');
6359: END IF;
6360: END invalidate_lpn_group;
6361:
6362: --bug 2349283 - the INV_Validate function updates the locator table,
6363: --thus locking the table. The UpdateLocCapacity function called in
6364: --Apply for putaway rules also updates the locator table, but in a
6365: -- different session. It tries to get a lock on the table, but
6366: --can't. So, we get a deadlock. To resolve this, we make this

Line 6378: /*l_locator inv_validate.LOCATOR;

6374: , x_exist_locator_id OUT NOCOPY NUMBER --Added bug3237702
6375: )
6376: RETURN BOOLEAN IS
6377: PRAGMA AUTONOMOUS_TRANSACTION;
6378: /*l_locator inv_validate.LOCATOR;
6379: l_org inv_validate.org;
6380: l_sub inv_validate.sub;*/
6381: success NUMBER;
6382: retval BOOLEAN;

Line 6379: l_org inv_validate.org;

6375: )
6376: RETURN BOOLEAN IS
6377: PRAGMA AUTONOMOUS_TRANSACTION;
6378: /*l_locator inv_validate.LOCATOR;
6379: l_org inv_validate.org;
6380: l_sub inv_validate.sub;*/
6381: success NUMBER;
6382: retval BOOLEAN;
6383: BEGIN

Line 6380: l_sub inv_validate.sub;*/

6376: RETURN BOOLEAN IS
6377: PRAGMA AUTONOMOUS_TRANSACTION;
6378: /*l_locator inv_validate.LOCATOR;
6379: l_org inv_validate.org;
6380: l_sub inv_validate.sub;*/
6381: success NUMBER;
6382: retval BOOLEAN;
6383: BEGIN
6384: x_exist_locator_id := NULL;

Line 6437: success := INV_Validate.ValidateLocator(

6433: from mtl_secondary_inventories
6434: where secondary_inventory_name = l_locator.subinventory_code
6435: and organization_id = l_locator.organization_id;
6436: */
6437: success := INV_Validate.ValidateLocator(
6438: p_locator => g_locator,
6439: p_org => inv_cache.org_rec,
6440: p_sub => inv_cache.tosub_rec,
6441: p_validation_mode => INV_Validate.EXISTS_OR_CREATE,

Line 6441: p_validation_mode => INV_Validate.EXISTS_OR_CREATE,

6437: success := INV_Validate.ValidateLocator(
6438: p_locator => g_locator,
6439: p_org => inv_cache.org_rec,
6440: p_sub => inv_cache.tosub_rec,
6441: p_validation_mode => INV_Validate.EXISTS_OR_CREATE,
6442: p_value_or_id => 'I');
6443:
6444: COMMIT;
6445:

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

6443:
6444: COMMIT;
6445:
6446: x_new_locator_id := g_locator.inventory_location_id;
6447: if( success = INV_Validate.T and FND_FLEX_KEYVAL.new_combination) then
6448: return TRUE;
6449: END IF;
6450:
6451: x_exist_locator_id := g_locator.inventory_location_id;