DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on INV_CACHE

Line 915: l_return_value := INV_CACHE.set_mol_rec(p_transaction_temp_id);

911: x_return_status := fnd_api.g_ret_sts_success;
912:
913: -- Bug 5264987 - Fetching the MO_lines from the Cache instead of querying ,
914:
915: l_return_value := INV_CACHE.set_mol_rec(p_transaction_temp_id);
916: IF NOT l_return_value THEN
917: If l_debug = 1 THEN
918: log_event(l_api_name,'','Move order line cursor not found ');
919: End If;

Line 923: l_rec_mtrl := INV_CACHE.mol_rec;

919: End If;
920: raise fnd_api.g_exc_unexpected_error;
921: END IF;
922: log_event(l_api_name,'','test:Move order line fetched from cache');
923: l_rec_mtrl := INV_CACHE.mol_rec;
924:
925:
926: if l_debug = 1 then
927: log_event(l_api_name,'','fetching move order line');

Line 1634: l_return_value := inv_cache.set_item_rec(p_org_id,p_inventory_item_id);

1630: log_event(l_api_name,' Enter' ,l_api_name);
1631: end if;
1632:
1633: -- 8809951 start
1634: l_return_value := inv_cache.set_item_rec(p_org_id,p_inventory_item_id);
1635: IF NOT l_return_value THEN
1636: If l_debug = 1 THEN
1637: log_event(l_api_name,'','Item not found ');
1638: END IF;

Line 1642: l_item_type:=inv_cache.item_rec.item_type;

1638: END IF;
1639: RAISE fnd_api.g_exc_unexpected_error;
1640: END IF;
1641:
1642: l_item_type:=inv_cache.item_rec.item_type;
1643: -- 8809951 end
1644:
1645: if l_debug = 1 then
1646: log_event(l_api_name,'End','get_item_type');

Line 1863: l_return_value := inv_cache.set_mol_rec(p_move_order_line_id);

1859: log_event(l_api_name,' Move order Line :' , p_move_order_line_id);
1860: end if;
1861:
1862: --8809951 start
1863: l_return_value := inv_cache.set_mol_rec(p_move_order_line_id);
1864: IF NOT l_return_value THEN
1865: IF l_debug = 1 THEN
1866: log_event(l_api_name,'','Move order line not found ');
1867: END IF;

Line 1877: l_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;

1873: into l_transaction_source_type_id, l_reference_id
1874: from mtl_txn_request_lines mtrl
1875: where mtrl.line_id = p_move_order_line_id; */
1876:
1877: l_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
1878: l_reference_id := inv_cache.mol_rec.reference_id;
1879:
1880: --8809951 end
1881: if l_debug = 1 then

Line 1878: l_reference_id := inv_cache.mol_rec.reference_id;

1874: from mtl_txn_request_lines mtrl
1875: where mtrl.line_id = p_move_order_line_id; */
1876:
1877: l_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
1878: l_reference_id := inv_cache.mol_rec.reference_id;
1879:
1880: --8809951 end
1881: if l_debug = 1 then
1882: log_event(l_api_name,' Txn_source_type_id ' ,l_transaction_source_type_id);