DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on INV_CONVERT

Line 223: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,

219: v_ReceiptQtyAvailable := nvl(rg23d_entry.qty_to_adjust,0) - nvl(v_QtyAppliedOnReceipt,0); -- cbabu for Bug# 2689425
220:
221: IF v_ReceiptQtyAvailable > 0 THEN --xyz
222:
223: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,
224: match_detail.requested_quantity_uom, rg23d_entry.Inventory_item_id, v_UomConversion);
225: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,
226: match_detail.requested_quantity_uom, rg23d_entry.Inventory_item_id, v_UomConversion);
227: IF nvl(v_UomConversion, 0) <= 0 THEN

Line 225: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,

221: IF v_ReceiptQtyAvailable > 0 THEN --xyz
222:
223: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,
224: match_detail.requested_quantity_uom, rg23d_entry.Inventory_item_id, v_UomConversion);
225: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,
226: match_detail.requested_quantity_uom, rg23d_entry.Inventory_item_id, v_UomConversion);
227: IF nvl(v_UomConversion, 0) <= 0 THEN
228: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,
229: match_detail.requested_quantity_uom, 0, v_UomConversion);

Line 228: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,

224: match_detail.requested_quantity_uom, rg23d_entry.Inventory_item_id, v_UomConversion);
225: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,
226: match_detail.requested_quantity_uom, rg23d_entry.Inventory_item_id, v_UomConversion);
227: IF nvl(v_UomConversion, 0) <= 0 THEN
228: Inv_Convert.Inv_Um_Conversion( rg23d_entry.primary_uom_code,
229: match_detail.requested_quantity_uom, 0, v_UomConversion);
230: END IF;
231: IF nvl(v_UomConversion, 0) <= 0 THEN
232: v_UomConversion := 1;

Line 831: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);

827: row_count := row_count + 1;
828:
829: IF tax_rate_tab(rec.lno) = 0 THEN
830: FOR uom_cls IN uom_class_cur(v_unit_code, rec.uom) LOOP
831: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);
832: IF nvl(v_conversion_rate, 0) <= 0 THEN
833: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);
834: IF nvl(v_conversion_rate, 0) <= 0 THEN
835: v_conversion_rate := 0;

Line 833: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);

829: IF tax_rate_tab(rec.lno) = 0 THEN
830: FOR uom_cls IN uom_class_cur(v_unit_code, rec.uom) LOOP
831: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);
832: IF nvl(v_conversion_rate, 0) <= 0 THEN
833: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);
834: IF nvl(v_conversion_rate, 0) <= 0 THEN
835: v_conversion_rate := 0;
836: END IF;
837: END IF;

Line 2361: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);

2357: /*commented the above if and added the below if condition
2358: for bug#16082873 ,to consider the UOM based taxes*/
2359: if rec.tax_rate is null and nvl(rec.qty_rate,0)<>0 then
2360: FOR uom_cls IN uom_class_cur(v_unit_code, rec.uom) LOOP
2361: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);
2362: IF nvl(v_conversion_rate, 0) <= 0 THEN
2363: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);
2364: IF nvl(v_conversion_rate, 0) <= 0 THEN
2365: v_conversion_rate := 0;

Line 2363: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);

2359: if rec.tax_rate is null and nvl(rec.qty_rate,0)<>0 then
2360: FOR uom_cls IN uom_class_cur(v_unit_code, rec.uom) LOOP
2361: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);
2362: IF nvl(v_conversion_rate, 0) <= 0 THEN
2363: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);
2364: IF nvl(v_conversion_rate, 0) <= 0 THEN
2365: v_conversion_rate := 0;
2366: END IF;
2367: END IF;

Line 2728: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);

2724: if rec.tax_rate is null and nvl(rec.qty_rate,0)<>0 then
2725:
2726:
2727: FOR uom_cls IN uom_class_cur(v_unit_code, rec.uom) LOOP
2728: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);
2729: IF nvl(v_conversion_rate, 0) <= 0 THEN
2730: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);
2731: IF nvl(v_conversion_rate, 0) <= 0 THEN
2732: v_conversion_rate := 0;

Line 2730: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);

2726:
2727: FOR uom_cls IN uom_class_cur(v_unit_code, rec.uom) LOOP
2728: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);
2729: IF nvl(v_conversion_rate, 0) <= 0 THEN
2730: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);
2731: IF nvl(v_conversion_rate, 0) <= 0 THEN
2732: v_conversion_rate := 0;
2733: END IF;
2734: END IF;

Line 3070: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);

3066: --added if condition for bug#16082873
3067: IF rec.tax_rate is null AND nvl(rec.qty_rate,0) <>0 THEN
3068: /*added if condition for bug#16082873*/
3069: FOR uom_cls IN uom_class_cur(v_unit_code, rec.uom) LOOP
3070: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);
3071: IF nvl(v_conversion_rate, 0) <= 0 THEN
3072: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);
3073: IF nvl(v_conversion_rate, 0) <= 0 THEN
3074: v_conversion_rate := 0;

Line 3072: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);

3068: /*added if condition for bug#16082873*/
3069: FOR uom_cls IN uom_class_cur(v_unit_code, rec.uom) LOOP
3070: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, v_inventory_item_id, v_conversion_rate);
3071: IF nvl(v_conversion_rate, 0) <= 0 THEN
3072: INV_CONVERT.inv_um_conversion(v_unit_code, rec.uom, 0, v_conversion_rate);
3073: IF nvl(v_conversion_rate, 0) <= 0 THEN
3074: v_conversion_rate := 0;
3075: END IF;
3076: END IF;