eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_QUANTITY_TREE_PVT dependencies on INV_CACHE

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

1731:
1732: g_nodes(l_item_node_index).is_reservable_sub := l_is_reservable_item;
1733: */
1734:
1735: l_return_value := INV_CACHE.set_org_rec(p_organization_id);
1736: IF NOT l_return_value THEN
1737: RAISE fnd_api.g_exc_unexpected_error;
1738: END IF;
1739: l_negative_inv_receipt_code := INV_CACHE.org_rec.negative_inv_receipt_code;

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

1735: l_return_value := INV_CACHE.set_org_rec(p_organization_id);
1736: IF NOT l_return_value THEN
1737: RAISE fnd_api.g_exc_unexpected_error;
1738: END IF;
1739: l_negative_inv_receipt_code := INV_CACHE.org_rec.negative_inv_receipt_code;
1740: l_default_org_status_id := INV_CACHE.org_rec.default_status_id; --Bug 9150005
1741:
1742: print_debug('In new_tree l_negative_inv_receipt_code: '||l_negative_inv_receipt_code ||' l_default_org_status_id: ' ||l_default_org_status_id);
1743:

Line 1740: l_default_org_status_id := INV_CACHE.org_rec.default_status_id; --Bug 9150005

1736: IF NOT l_return_value THEN
1737: RAISE fnd_api.g_exc_unexpected_error;
1738: END IF;
1739: l_negative_inv_receipt_code := INV_CACHE.org_rec.negative_inv_receipt_code;
1740: l_default_org_status_id := INV_CACHE.org_rec.default_status_id; --Bug 9150005
1741:
1742: print_debug('In new_tree l_negative_inv_receipt_code: '||l_negative_inv_receipt_code ||' l_default_org_status_id: ' ||l_default_org_status_id);
1743:
1744: IF (l_negative_inv_receipt_code = 1) THEN

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

1760: l_unit_effective := pjm_unit_eff.unit_effective_item(
1761: x_item_id => p_inventory_item_id
1762: ,x_organization_id => p_organization_id);
1763: */
1764: l_return_value := INV_CACHE.set_item_rec(p_organization_id, p_inventory_item_id);
1765: IF NOT l_return_value THEN
1766: RAISE fnd_api.g_exc_unexpected_error;
1767: END IF;
1768: l_unit_effective := INV_CACHE.item_rec.effectivity_control;

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

1764: l_return_value := INV_CACHE.set_item_rec(p_organization_id, p_inventory_item_id);
1765: IF NOT l_return_value THEN
1766: RAISE fnd_api.g_exc_unexpected_error;
1767: END IF;
1768: l_unit_effective := INV_CACHE.item_rec.effectivity_control;
1769:
1770: /*Bug#5352407. All EAM asset group items are unit effective. Though they are unit
1771: effective, unit number is not required to perform transactions. So,
1772: they should be treated as non-unit effective otherwise the quantity

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

1774: available (Since it calls PJM API for getting onhand qty for
1775: unit effective items and the PJM API returns 0 if the item is of EAM asset group
1776: type).*/
1777: IF l_unit_effective = 2 THEN
1778: IF INV_CACHE.item_rec.eam_item_type = 1 THEN
1779: l_unit_effective := 1;
1780: END IF;
1781: END IF;
1782:

Line 10041: l_return_org_value := INV_CACHE.set_org_rec(g_rootinfos(l_root_id).organization_id);

10037: END IF; -- l_is_reservable_sub
10038: */
10039:
10040: --bug 16428282 start
10041: l_return_org_value := INV_CACHE.set_org_rec(g_rootinfos(l_root_id).organization_id);
10042: IF NOT l_return_org_value THEN
10043: RAISE fnd_api.g_exc_unexpected_error;
10044: END IF;
10045: l_wms_enabled := INV_CACHE.org_rec.WMS_ENABLED_FLAG;

Line 10045: l_wms_enabled := INV_CACHE.org_rec.WMS_ENABLED_FLAG;

10041: l_return_org_value := INV_CACHE.set_org_rec(g_rootinfos(l_root_id).organization_id);
10042: IF NOT l_return_org_value THEN
10043: RAISE fnd_api.g_exc_unexpected_error;
10044: END IF;
10045: l_wms_enabled := INV_CACHE.org_rec.WMS_ENABLED_FLAG;
10046:
10047: --l_allocate_lot_flag := INV_CACHE.org_rec.ALLOCATE_LOT_FLAG;
10048: l_allocate_lot_flag := inv_flex_lot_allocation_pub.get_allocate_lot_flag(
10049: p_organization_id => g_rootinfos(l_root_id).organization_id

Line 10047: --l_allocate_lot_flag := INV_CACHE.org_rec.ALLOCATE_LOT_FLAG;

10043: RAISE fnd_api.g_exc_unexpected_error;
10044: END IF;
10045: l_wms_enabled := INV_CACHE.org_rec.WMS_ENABLED_FLAG;
10046:
10047: --l_allocate_lot_flag := INV_CACHE.org_rec.ALLOCATE_LOT_FLAG;
10048: l_allocate_lot_flag := inv_flex_lot_allocation_pub.get_allocate_lot_flag(
10049: p_organization_id => g_rootinfos(l_root_id).organization_id
10050: , p_inventory_item_id => g_rootinfos(l_root_id).inventory_item_id
10051: , p_subinventory_code => p_subinventory_code

Line 10060: l_return_value := INV_CACHE.set_item_rec(g_rootinfos(l_root_id).organization_id, g_rootinfos(l_root_id).inventory_item_id);

10056: print_debug('In query_tree-: WMS Org:'|| l_wms_enabled ||' ALLOCATE_LOT_FLAG: ' ||l_allocate_lot_flag);
10057: --bug 16428282 end
10058:
10059: --bug 13961830 start
10060: l_return_value := INV_CACHE.set_item_rec(g_rootinfos(l_root_id).organization_id, g_rootinfos(l_root_id).inventory_item_id);
10061: IF NOT l_return_value THEN
10062: RAISE fnd_api.g_exc_unexpected_error;
10063: END IF;
10064: l_lot_divisible_flag := INV_CACHE.item_rec.LOT_DIVISIBLE_FLAG;

Line 10064: l_lot_divisible_flag := INV_CACHE.item_rec.LOT_DIVISIBLE_FLAG;

10060: l_return_value := INV_CACHE.set_item_rec(g_rootinfos(l_root_id).organization_id, g_rootinfos(l_root_id).inventory_item_id);
10061: IF NOT l_return_value THEN
10062: RAISE fnd_api.g_exc_unexpected_error;
10063: END IF;
10064: l_lot_divisible_flag := INV_CACHE.item_rec.LOT_DIVISIBLE_FLAG;
10065:
10066: IF NVL(l_lot_divisible_flag,'Y') = 'N' THEN
10067: print_debug('l_lot_divisible_flag=N');
10068: ELSE

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

10898: IF fnd_api.to_boolean(p_init_msg_lst) THEN
10899: fnd_msg_pub.initialize;
10900: END IF;
10901:
10902: g_is_pickrelease := nvl(inv_cache.is_pickrelease,FALSE);
10903:
10904: g_empty_root_index := NULL;
10905: g_hash_string := NULL;
10906: