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 508: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN

504: FOR l_wlc_cur IN wlc_cur LOOP
505: l_serial_controlled := 0;
506: l_serial_status_enabled := 0;
507: mdebug('in mass update of lpn '||p_onhand_status_id);
508: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
509: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
510: l_serial_controlled := 1; -- Item is serial controlled
511: END IF;
512: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

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

505: l_serial_controlled := 0;
506: l_serial_status_enabled := 0;
507: mdebug('in mass update of lpn '||p_onhand_status_id);
508: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
509: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
510: l_serial_controlled := 1; -- Item is serial controlled
511: END IF;
512: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
513: l_serial_status_enabled := 1;

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

508: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
509: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
510: l_serial_controlled := 1; -- Item is serial controlled
511: END IF;
512: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
513: l_serial_status_enabled := 1;
514: --bug 6952533
515: IF(l_serial_status_control = 2)THEN
516: x_status := 'E';

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

1201: mdebug('Item id is NULL so have to check for whole LPN case');
1202: FOR l_wlc_cur in wlc_cur loop
1203: l_serial_controlled := 0;
1204: l_serial_status_enabled := 0;
1205: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1206: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1207: l_serial_controlled := 1; -- Item is serial controlled
1208: END IF;
1209: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

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

1202: FOR l_wlc_cur in wlc_cur loop
1203: l_serial_controlled := 0;
1204: l_serial_status_enabled := 0;
1205: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1206: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1207: l_serial_controlled := 1; -- Item is serial controlled
1208: END IF;
1209: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1210: l_serial_status_enabled := 1;

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

1205: IF inv_cache.set_item_rec(p_organization_id, l_wlc_cur.inventory_item_id) THEN
1206: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1207: l_serial_controlled := 1; -- Item is serial controlled
1208: END IF;
1209: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1210: l_serial_status_enabled := 1;
1211: END IF;
1212: END IF;
1213: mdebug('Inventory item id from wlc_cur '||l_wlc_cur.inventory_item_id);

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

1253: OR l_wlc_item_cur.parent_lpn_id <> p_lpn_id
1254: )THEN
1255: l_serial_controlled := 0;
1256: l_serial_status_enabled := 0;
1257: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1258: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1259: l_serial_controlled := 1; -- Item is serial controlled
1260: END IF;
1261: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

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

1254: )THEN
1255: l_serial_controlled := 0;
1256: l_serial_status_enabled := 0;
1257: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1258: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1259: l_serial_controlled := 1; -- Item is serial controlled
1260: END IF;
1261: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1262: l_serial_status_enabled := 1;

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

1257: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1258: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1259: l_serial_controlled := 1; -- Item is serial controlled
1260: END IF;
1261: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1262: l_serial_status_enabled := 1;
1263: END IF;
1264: END IF;
1265: mdebug('Inventory item id from wlc_item_cur '||l_wlc_item_cur.inventory_item_id);

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

1341: FOR l_wlc_item_cur in wlc_item_cur loop
1342: l_return_mixed := 0;
1343: l_serial_controlled := 0;
1344: l_serial_status_enabled := 0;
1345: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1346: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1347: l_serial_controlled := 1; -- Item is serial controlled
1348: END IF;
1349: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

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

1342: l_return_mixed := 0;
1343: l_serial_controlled := 0;
1344: l_serial_status_enabled := 0;
1345: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1346: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1347: l_serial_controlled := 1; -- Item is serial controlled
1348: END IF;
1349: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1350: l_serial_status_enabled := 1;

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

1345: IF inv_cache.set_item_rec(p_organization_id, l_wlc_item_cur.inventory_item_id) THEN
1346: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1347: l_serial_controlled := 1; -- Item is serial controlled
1348: END IF;
1349: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
1350: l_serial_status_enabled := 1;
1351: END IF;
1352: END IF;
1353: mdebug('Inventory item id from wlc_item_cur '||l_wlc_item_cur.inventory_item_id);