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_STATUS_PKG dependencies on INV_CACHE

Line 1031: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN

1027: FOR l_wlc_cur IN wlc_cur LOOP
1028: l_serial_controlled := 0;
1029: l_serial_status_enabled := 0;
1030: mdebug('in mass update of lpn '||p_onhand_status_id);
1031: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1032: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1033: l_serial_controlled := 1; -- Item is serial controlled
1034: END IF;
1035: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

Line 1032: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

1028: l_serial_controlled := 0;
1029: l_serial_status_enabled := 0;
1030: mdebug('in mass update of lpn '||p_onhand_status_id);
1031: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1032: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1033: l_serial_controlled := 1; -- Item is serial controlled
1034: END IF;
1035: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1036: l_serial_status_enabled := 1;

Line 1035: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

1031: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1032: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1033: l_serial_controlled := 1; -- Item is serial controlled
1034: END IF;
1035: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1036: l_serial_status_enabled := 1;
1037: --bug 6952533
1038: IF(l_serial_status_control = 2)THEN
1039: x_status := 'E';

Line 1827: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN

1823: mdebug('Item id is NULL so have to check for whole LPN case');
1824: FOR l_wlc_cur in wlc_cur loop
1825: l_serial_controlled := 0;
1826: l_serial_status_enabled := 0;
1827: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1828: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1829: l_serial_controlled := 1; -- Item is serial controlled
1830: END IF;
1831: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

Line 1828: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

1824: FOR l_wlc_cur in wlc_cur loop
1825: l_serial_controlled := 0;
1826: l_serial_status_enabled := 0;
1827: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1828: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1829: l_serial_controlled := 1; -- Item is serial controlled
1830: END IF;
1831: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1832: l_serial_status_enabled := 1;

Line 1831: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

1827: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1828: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1829: l_serial_controlled := 1; -- Item is serial controlled
1830: END IF;
1831: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1832: l_serial_status_enabled := 1;
1833: END IF;
1834: END IF;
1835: mdebug('Inventory item id from wlc_cur '||l_wlc_cur.inventory_item_id);

Line 1879: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN

1875: OR l_wlc_item_cur.parent_lpn_id <> p_lpn_id
1876: )THEN
1877: l_serial_controlled := 0;
1878: l_serial_status_enabled := 0;
1879: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1880: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1881: l_serial_controlled := 1; -- Item is serial controlled
1882: END IF;
1883: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

Line 1880: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

1876: )THEN
1877: l_serial_controlled := 0;
1878: l_serial_status_enabled := 0;
1879: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1880: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1881: l_serial_controlled := 1; -- Item is serial controlled
1882: END IF;
1883: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1884: l_serial_status_enabled := 1;

Line 1883: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

1879: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1880: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1881: l_serial_controlled := 1; -- Item is serial controlled
1882: END IF;
1883: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1884: l_serial_status_enabled := 1;
1885: END IF;
1886: END IF;
1887: mdebug('Inventory item id from wlc_item_cur '||l_wlc_item_cur.inventory_item_id);

Line 1967: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN

1963: FOR l_wlc_item_cur in wlc_item_cur loop
1964: l_return_mixed := 0;
1965: l_serial_controlled := 0;
1966: l_serial_status_enabled := 0;
1967: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1968: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1969: l_serial_controlled := 1; -- Item is serial controlled
1970: END IF;
1971: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

Line 1968: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

1964: l_return_mixed := 0;
1965: l_serial_controlled := 0;
1966: l_serial_status_enabled := 0;
1967: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1968: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1969: l_serial_controlled := 1; -- Item is serial controlled
1970: END IF;
1971: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1972: l_serial_status_enabled := 1;

Line 1971: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

1967: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1968: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1969: l_serial_controlled := 1; -- Item is serial controlled
1970: END IF;
1971: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1972: l_serial_status_enabled := 1;
1973: END IF;
1974: END IF;
1975: mdebug('Inventory item id from wlc_item_cur '||l_wlc_item_cur.inventory_item_id);