DBA Data[Home] [Help]

APPS.INV_RCV_RESERVATION_UTIL dependencies on INV_RCV_CACHE

Line 734: and ( p_prim_qty = round(Inv_Rcv_Cache.Convert_Qty(P_Orig_Rcpt_Rec.Inventory_Item_Id ,

730: --Bug10036172-Avoid conversion if we know the txn qty already -- Bug 13938576 added conditon for negative correction as well
731: If ((Nvl(P_Orig_Rcpt_Rec.Quantity,0) > 0 OR ((p_orig_rcpt_rec.transaction_type IN ('CORRECT')
732: AND p_orig_rcpt_rec.primary_qty < 0
733: AND p_orig_rcpt_rec.parent_txn_type = 'DELIVER')))
734: and ( p_prim_qty = round(Inv_Rcv_Cache.Convert_Qty(P_Orig_Rcpt_Rec.Inventory_Item_Id ,
735: P_Orig_Rcpt_Rec.Quantity ,
736: p_orig_rcpt_rec.uom_code,
737: P_Orig_Rcpt_Rec.Primary_Uom_Code
738: ),5) ))

Line 743: L_Txn_Qty := Inv_Rcv_Cache.Convert_Qty(P_Orig_Rcpt_Rec.Inventory_Item_Id ,

739: then
740: l_txn_qty := p_orig_rcpt_rec.quantity;
741: Else
742: IF p_orig_rcpt_rec.uom_code <> p_orig_rcpt_rec.primary_uom_code THEN
743: L_Txn_Qty := Inv_Rcv_Cache.Convert_Qty(P_Orig_Rcpt_Rec.Inventory_Item_Id ,
744: p_prim_qty ,
745: p_orig_rcpt_rec.primary_uom_code,
746: p_orig_rcpt_rec.uom_code);
747: Else

Line 775: inv_rcv_cache.g_conversion_precision);

771: -- bug 11887302,12539886,Bug 13938576 changes end .Added conditon for negative correction as well
772:
773: IF (Nvl(p_orig_rcpt_rec.secondary_quantity,0) <> 0) THEN
774: l_sec_qty := Round((p_prim_qty*p_orig_rcpt_rec.secondary_quantity)/p_orig_rcpt_rec.primary_qty,
775: inv_rcv_cache.g_conversion_precision);
776: END IF;
777:
778: IF p_cas_mol_rec_tb.exists(Nvl(p_wdd_id,-1)) THEN
779: p_cas_mol_rec_tb(Nvl(p_wdd_id,-1)).primary_qty := p_cas_mol_rec_tb(Nvl(p_wdd_id,-1)).primary_qty+p_prim_qty;

Line 942: l_rsv_update_rec.reservation_quantity := inv_rcv_cache.convert_qty(p_cas_mol_rec_tb(1).inventory_item_id

938: l_module_name,4);
939: END IF;
940:
941: l_rsv_update_rec.primary_reservation_quantity := l_remaining_prim_qty;
942: l_rsv_update_rec.reservation_quantity := inv_rcv_cache.convert_qty(p_cas_mol_rec_tb(1).inventory_item_id
943: ,l_remaining_prim_qty
944: ,l_rsv_results_tbl(i).primary_uom_code
945: ,l_rsv_results_tbl(i).reservation_uom_code);
946:

Line 1559: l_rsv_update_rec.reservation_quantity := inv_rcv_cache.convert_qty(p_cas_mol_rec_tb(1).inventory_item_id

1555: END IF;
1556:
1557: l_rsv_update_rec.primary_reservation_quantity := l_remaining_prim_qty;
1558: l_rsv_update_rec.secondary_reservation_quantity := l_remaining_sec_qty; -- Bug: 9846574
1559: l_rsv_update_rec.reservation_quantity := inv_rcv_cache.convert_qty(p_cas_mol_rec_tb(1).inventory_item_id
1560: ,l_remaining_prim_qty
1561: ,l_rsv_results_tbl(i).primary_uom_code
1562: ,l_rsv_results_tbl(i).reservation_uom_code);
1563: -- Bug 9468018

Line 2130: l_rsv_update_rec.reservation_quantity := inv_rcv_cache.convert_qty

2126: l_module_name,4);
2127: END IF;
2128:
2129: l_rsv_update_rec.primary_reservation_quantity := l_remaining_prim_qty;
2130: l_rsv_update_rec.reservation_quantity := inv_rcv_cache.convert_qty
2131: (p_cas_mol_rec_tb(1).inventory_item_id
2132: ,l_remaining_prim_qty
2133: ,l_rsv_results_tbl(i).primary_uom_code
2134: ,l_rsv_results_tbl(i).reservation_uom_code);

Line 2708: l_rsv_update_rec.reservation_quantity := inv_rcv_cache.convert_qty(p_cas_mol_rec_tb(1).inventory_item_id

2704:
2705: IF (l_rsv_results.primary_reservation_quantity > l_remaining_prim_qty) THEN
2706: l_loose_qty_to_splt := l_loose_qty_to_splt + l_remaining_prim_qty;
2707: l_rsv_update_rec.primary_reservation_quantity := l_remaining_prim_qty;
2708: l_rsv_update_rec.reservation_quantity := inv_rcv_cache.convert_qty(p_cas_mol_rec_tb(1).inventory_item_id
2709: ,l_remaining_prim_qty
2710: ,l_rsv_results.primary_uom_code
2711: ,l_rsv_results.reservation_uom_code);
2712: l_remaining_prim_qty := 0;

Line 3148: l_mol_qty_in_puom := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id,

3144: END IF;
3145: */
3146:
3147:
3148: l_mol_qty_in_puom := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id,
3149: l_mol_rec.quantity,
3150: l_mol_rec.uom_code,
3151: p_cas_mol_tb(1).primary_uom_code);
3152: