DBA Data[Home] [Help]

APPS.WMS_RETURN_SV dependencies on INV_CACHE

Line 1035: inv_cache to improve performance */

1031: print_debug('p_secondary_quantity =>' || p_secondary_quantity); -- 13399743
1032: END IF;
1033:
1034: /* bug 13011555, removed the block defined for bug 5068433 and used
1035: inv_cache to improve performance */
1036: IF (inv_cache.set_item_rec(p_organization_id,p_content_item_id)) THEN
1037: l_transactable_flag := INV_CACHE.item_rec.mtl_transactions_enabled_flag;
1038: l_sec_uom_code := INV_CACHE.item_rec.secondary_uom_code;
1039: ELSE

Line 1036: IF (inv_cache.set_item_rec(p_organization_id,p_content_item_id)) THEN

1032: END IF;
1033:
1034: /* bug 13011555, removed the block defined for bug 5068433 and used
1035: inv_cache to improve performance */
1036: IF (inv_cache.set_item_rec(p_organization_id,p_content_item_id)) THEN
1037: l_transactable_flag := INV_CACHE.item_rec.mtl_transactions_enabled_flag;
1038: l_sec_uom_code := INV_CACHE.item_rec.secondary_uom_code;
1039: ELSE
1040: l_transactable_flag := 'Y';

Line 1037: l_transactable_flag := INV_CACHE.item_rec.mtl_transactions_enabled_flag;

1033:
1034: /* bug 13011555, removed the block defined for bug 5068433 and used
1035: inv_cache to improve performance */
1036: IF (inv_cache.set_item_rec(p_organization_id,p_content_item_id)) THEN
1037: l_transactable_flag := INV_CACHE.item_rec.mtl_transactions_enabled_flag;
1038: l_sec_uom_code := INV_CACHE.item_rec.secondary_uom_code;
1039: ELSE
1040: l_transactable_flag := 'Y';
1041: l_sec_uom_code :=NULL;

Line 1038: l_sec_uom_code := INV_CACHE.item_rec.secondary_uom_code;

1034: /* bug 13011555, removed the block defined for bug 5068433 and used
1035: inv_cache to improve performance */
1036: IF (inv_cache.set_item_rec(p_organization_id,p_content_item_id)) THEN
1037: l_transactable_flag := INV_CACHE.item_rec.mtl_transactions_enabled_flag;
1038: l_sec_uom_code := INV_CACHE.item_rec.secondary_uom_code;
1039: ELSE
1040: l_transactable_flag := 'Y';
1041: l_sec_uom_code :=NULL;
1042: IF (l_debug = 1) THEN