DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PVT dependencies on INV_CACHE

Line 1999: l_return_value := INV_CACHE.set_org_rec(p_organization_id);

1995: End IF;
1996:
1997: g_rootinfos(l_tree_index).item_node_index := l_item_node_index;
1998:
1999: l_return_value := INV_CACHE.set_org_rec(p_organization_id);
2000: IF NOT l_return_value THEN
2001: RAISE fnd_api.g_exc_unexpected_error;
2002: END IF;
2003: l_negative_inv_receipt_code := INV_CACHE.org_rec.negative_inv_receipt_code;

Line 2003: l_negative_inv_receipt_code := INV_CACHE.org_rec.negative_inv_receipt_code;

1999: l_return_value := INV_CACHE.set_org_rec(p_organization_id);
2000: IF NOT l_return_value THEN
2001: RAISE fnd_api.g_exc_unexpected_error;
2002: END IF;
2003: l_negative_inv_receipt_code := INV_CACHE.org_rec.negative_inv_receipt_code;
2004:
2005: IF (l_negative_inv_receipt_code = 1) THEN
2006: g_rootinfos(l_tree_index).neg_inv_allowed := TRUE;
2007: ELSE

Line 2018: l_return_value := INV_CACHE.set_item_rec(p_organization_id, p_inventory_item_id);

2014: l_unit_effective := pjm_unit_eff.unit_effective_item(
2015: x_item_id => p_inventory_item_id
2016: ,x_organization_id => p_organization_id);
2017: */
2018: l_return_value := INV_CACHE.set_item_rec(p_organization_id, p_inventory_item_id);
2019: IF NOT l_return_value THEN
2020: RAISE fnd_api.g_exc_unexpected_error;
2021: END IF;
2022: l_unit_effective := INV_CACHE.item_rec.effectivity_control;

Line 2022: l_unit_effective := INV_CACHE.item_rec.effectivity_control;

2018: l_return_value := INV_CACHE.set_item_rec(p_organization_id, p_inventory_item_id);
2019: IF NOT l_return_value THEN
2020: RAISE fnd_api.g_exc_unexpected_error;
2021: END IF;
2022: l_unit_effective := INV_CACHE.item_rec.effectivity_control;
2023:
2024: /*Bug#5352407. All EAM asset group items are unit effective. Though they are unit
2025: effective, unit number is not required to perform transactions. So,
2026: they should be treated as non-unit effective otherwise the quantity

Line 2032: IF INV_CACHE.item_rec.eam_item_type = 1 THEN

2028: available (Since it calls PJM API for getting onhand qty for
2029: unit effective items and the PJM API returns 0 if the item is of EAM asset group
2030: type).*/
2031: IF l_unit_effective = 2 THEN
2032: IF INV_CACHE.item_rec.eam_item_type = 1 THEN
2033: l_unit_effective := 1;
2034: END IF;
2035: END IF;
2036:

Line 2609: IF inv_cache.set_org_rec(p_organization_id) THEN

2605:
2606: ELSE
2607:
2608: -- Onhand Material Status Support
2609: IF inv_cache.set_org_rec(p_organization_id) THEN
2610: l_default_onhand_status_id := inv_cache.org_rec.default_status_id;
2611: END IF;
2612:
2613: print_debug('in check_is_rsv, default org status id='||l_default_onhand_status_id||', for org id='||p_organization_id);

Line 2610: l_default_onhand_status_id := inv_cache.org_rec.default_status_id;

2606: ELSE
2607:
2608: -- Onhand Material Status Support
2609: IF inv_cache.set_org_rec(p_organization_id) THEN
2610: l_default_onhand_status_id := inv_cache.org_rec.default_status_id;
2611: END IF;
2612:
2613: print_debug('in check_is_rsv, default org status id='||l_default_onhand_status_id||', for org id='||p_organization_id);
2614:

Line 10386: g_is_pickrelease := nvl(inv_cache.is_pickrelease,FALSE);

10382: IF fnd_api.to_boolean(p_init_msg_lst) THEN
10383: fnd_msg_pub.initialize;
10384: END IF;
10385:
10386: g_is_pickrelease := nvl(inv_cache.is_pickrelease,FALSE);
10387:
10388: IF g_debug IS NULL THEN
10389: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10390: END IF;