DBA Data[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on INV_CACHE

Line 864: l_serialTaggedCode := inv_cache.get_serial_tagged(p_orgID, l_itemRecTbl.itemID(i), getTxnType(l_itemRecTbl.txnActionID(i)));

860: if (l_logLevel <= wip_constants.full_logging) then
861: wip_logger.log('adding item ' || l_itemRecTbl.itemName(i) || ';' || l_itemRecTbl.itemID(i), l_returnStatus);
862: end if;
863:
864: l_serialTaggedCode := inv_cache.get_serial_tagged(p_orgID, l_itemRecTbl.itemID(i), getTxnType(l_itemRecTbl.txnActionID(i)));
865:
866: if(l_itemRecTbl.lotControlCode(i) = wip_constants.lot) then
867: if(l_itemRecTbl.movTxnID(i) is not null) then
868: l_supType := wip_constants.op_pull;

Line 1786: inv_cache.get_serial_tagged(p_orgID, -- Bug 9907143: added for serial tagging enhancement for SUN

1782: end if;
1783:
1784: l_TxnTypeID := getTxnType(l_item.transaction_action_id);
1785: select lot_control_code, serial_number_control_code,
1786: inv_cache.get_serial_tagged(p_orgID, -- Bug 9907143: added for serial tagging enhancement for SUN
1787: l_item.inventory_item_id,
1788: l_TxnTypeID) serial_tagged_code
1789: into l_lotControlCode, l_serialControlCode, l_serialTaggedCode
1790: from mtl_system_items