APPS.INV_RCV_INTEGRATION_PVT dependencies on INV_CACHE

Line 8497: IF inv_cache.set_item_rec(l_rti_rec.to_organization_id , l_rti_rec.item_id) THEN --15959206 start

8493: l_auto_unnest_empty_lpns := 1;
8494: /* Start 12610461 */
8495:
8496:
8497: IF inv_cache.set_item_rec(l_rti_rec.to_organization_id , l_rti_rec.item_id) THEN --15959206 start
8498: l_lot_code := inv_cache.item_rec.lot_control_code;
8499: END IF;
8500:
8501: IF l_lot_code = 2 THEN

Line 8498: l_lot_code := inv_cache.item_rec.lot_control_code;

8494: /* Start 12610461 */
8495:
8496:
8497: IF inv_cache.set_item_rec(l_rti_rec.to_organization_id , l_rti_rec.item_id) THEN --15959206 start
8498: l_lot_code := inv_cache.item_rec.lot_control_code;
8499: END IF;
8500:
8501: IF l_lot_code = 2 THEN
8502: l_ignore_item_controls := 1;

Line 11896: IF NOT (inv_cache.set_item_rec(l_mol_mmtt_ctnt_tb(i).organization_id,l_mol_mmtt_ctnt_tb(i).inventory_item_id)) THEN

11892: ' insect_status:'||l_rs_tb(l_rs_index).inspection_status
11893: ,4);
11894: END IF;
11895:
11896: IF NOT (inv_cache.set_item_rec(l_mol_mmtt_ctnt_tb(i).organization_id,l_mol_mmtt_ctnt_tb(i).inventory_item_id)) THEN
11897: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
11898: fnd_msg_pub.add;
11899: RAISE fnd_api.g_exc_unexpected_error;
11900: END IF;

Line 11906: nvl(inv_cache.item_rec.revision_qty_control_code,1) = 1) --BUG13562127

11902:
11903: IF (l_mol_mmtt_ctnt_tb(i).organization_id = l_rs_tb(l_rs_index).organization_id
11904: AND l_mol_mmtt_ctnt_tb(i).inventory_item_id = l_rs_tb(l_rs_index).inventory_item_id
11905: AND (Nvl(l_mol_mmtt_ctnt_tb(i).revision,'#$#') = Nvl(l_rs_tb(l_rs_index).revision,'#$#') OR
11906: nvl(inv_cache.item_rec.revision_qty_control_code,1) = 1) --BUG13562127
11907: AND Nvl(l_mol_mmtt_ctnt_tb(i).lot_number,'#$#') = Nvl(l_rs_tb(l_rs_index).lot_number,'#$#')
11908: AND Nvl(l_mol_mmtt_ctnt_tb(i).inspection_status,0) = Nvl(l_rs_tb(l_rs_index).inspection_status,0)
11909: AND Nvl(l_mol_mmtt_ctnt_tb(i).project_id,-1) = Nvl(l_rs_tb(l_rs_index).project_id,-1)
11910: AND Nvl(l_mol_mmtt_ctnt_tb(i).task_id,-1) = Nvl(l_rs_tb(l_rs_index).task_id,-1))

Line 13657: IF inv_cache.set_item_rec(l_lpn_contents.organization_id , l_lpn_contents.inventory_item_id) THEN --15959206

13653: ,wlc.lot_number
13654: )
13655: Loop
13656:
13657: IF inv_cache.set_item_rec(l_lpn_contents.organization_id , l_lpn_contents.inventory_item_id) THEN --15959206
13658: l_lot_code := inv_cache.item_rec.lot_control_code;
13659: END IF;
13660: -- THERE IS a PROBLEM HERE IF DIFFERENT UOM_CODES EXIST in WLC FOR THE SAME ITEM. ***********
13661: -- NOT YET CONVERTED UOM

Line 13658: l_lot_code := inv_cache.item_rec.lot_control_code;

13654: )
13655: Loop
13656:
13657: IF inv_cache.set_item_rec(l_lpn_contents.organization_id , l_lpn_contents.inventory_item_id) THEN --15959206
13658: l_lot_code := inv_cache.item_rec.lot_control_code;
13659: END IF;
13660: -- THERE IS a PROBLEM HERE IF DIFFERENT UOM_CODES EXIST in WLC FOR THE SAME ITEM. ***********
13661: -- NOT YET CONVERTED UOM
13662: IF l_lot_code = 1 THEN --15959206

Line 13998: l_return_val := INV_CACHE.set_item_rec(l_lpn_rec.item_id,l_lpn_rec.from_organization_id);

13994: -- added for bug 13938607
13995: IF(l_lpn_rec.validation_flag='Y' AND l_lpn_rec.mobile_txn='N' AND l_lpn_rec.lpn_id IS NOT NULL) THEN
13996: IF(l_lpn_rec.transaction_type IN('RETURN TO VENDOR', 'RETURN TO RECEIVING')) THEN
13997:
13998: l_return_val := INV_CACHE.set_item_rec(l_lpn_rec.item_id,l_lpn_rec.from_organization_id);
13999:
14000: WMS_RETURN_SV.mark_returns(
14001: v_return_status,
14002: v_msg_count,

Line 14011: INV_CACHE.item_rec.serial_number_control_code, --serial_control_code

14007: l_lpn_rec.item_id, --item_id
14008: l_lpn_rec.item_revision, --item_revision
14009: l_lpn_rec.quantity, --quantity
14010: l_lpn_rec.uom_code, --uom_code
14011: INV_CACHE.item_rec.serial_number_control_code, --serial_control_code
14012: INV_CACHE.item_rec.lot_control_code, --lot_control_code
14013: l_lpn_rec.from_organization_id, --organization_id
14014: l_lpn_rec.from_subinventory, --from_subinventory_code
14015: l_lpn_rec.from_locator_id); --from_locator_id

Line 14012: INV_CACHE.item_rec.lot_control_code, --lot_control_code

14008: l_lpn_rec.item_revision, --item_revision
14009: l_lpn_rec.quantity, --quantity
14010: l_lpn_rec.uom_code, --uom_code
14011: INV_CACHE.item_rec.serial_number_control_code, --serial_control_code
14012: INV_CACHE.item_rec.lot_control_code, --lot_control_code
14013: l_lpn_rec.from_organization_id, --organization_id
14014: l_lpn_rec.from_subinventory, --from_subinventory_code
14015: l_lpn_rec.from_locator_id); --from_locator_id
14016: IF x_return_status <> 'S' THEN

Line 19768: if inv_cache.set_org_rec(l_org_id) then

19764: /* Material Status Enhancement - Tracking bug: 13519864 */
19765:
19766: IF (L_MTLT_REC.status_id IS NOT NULL AND l_allow_status_entry = 'Y') THEN
19767:
19768: if inv_cache.set_org_rec(l_org_id) then
19769: l_default_status_id := inv_cache.org_rec.default_status_id;
19770: end if;
19771:
19772: IF (l_default_status_id is not null and l_serial_number_control_code NOT IN (2,5)) THEN /* Bug 13725126 */

Line 19769: l_default_status_id := inv_cache.org_rec.default_status_id;

19765:
19766: IF (L_MTLT_REC.status_id IS NOT NULL AND l_allow_status_entry = 'Y') THEN
19767:
19768: if inv_cache.set_org_rec(l_org_id) then
19769: l_default_status_id := inv_cache.org_rec.default_status_id;
19770: end if;
19771:
19772: IF (l_default_status_id is not null and l_serial_number_control_code NOT IN (2,5)) THEN /* Bug 13725126 */
19773: