DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on PO_UOM_S

Line 5128: /*x_remaining_qty_po_uom := x_remaining_quantity * po_uom_s.po_uom_convert(temp_cascaded_table(1).unit_of_measure,

5124: );
5125: else --}{
5126: -- For bug 8625167, to handle exception while converting uom
5127: -- Bug 4898703 - START {
5128: /*x_remaining_qty_po_uom := x_remaining_quantity * po_uom_s.po_uom_convert(temp_cascaded_table(1).unit_of_measure,
5129: x_shipmentdistributionrec.unit_meas_lookup_code,
5130: temp_cascaded_table(1).item_id
5131: );
5132: -- using arbit qty for PO->ASN, PO->PRIMARY UOM conversion as this is just a check

Line 5134: po_asn_uom_qty := 1000 * po_uom_s.po_uom_convert( x_shipmentdistributionrec.unit_meas_lookup_code,

5130: temp_cascaded_table(1).item_id
5131: );
5132: -- using arbit qty for PO->ASN, PO->PRIMARY UOM conversion as this is just a check
5133:
5134: po_asn_uom_qty := 1000 * po_uom_s.po_uom_convert( x_shipmentdistributionrec.unit_meas_lookup_code,
5135: temp_cascaded_table(1).unit_of_measure,
5136: temp_cascaded_table(1).item_id
5137: );
5138: po_primary_uom_qty := 1000 * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,

Line 5138: po_primary_uom_qty := 1000 * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,

5134: po_asn_uom_qty := 1000 * po_uom_s.po_uom_convert( x_shipmentdistributionrec.unit_meas_lookup_code,
5135: temp_cascaded_table(1).unit_of_measure,
5136: temp_cascaded_table(1).item_id
5137: );
5138: po_primary_uom_qty := 1000 * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
5139: temp_cascaded_table(1).primary_unit_of_measure,
5140: temp_cascaded_table(1).item_id
5141: );*/
5142: -- Bug 4898703 - END }

Line 5146: x_remaining_qty_po_uom := x_remaining_quantity * po_uom_s.po_uom_convert(temp_cascaded_table(1).unit_of_measure,

5142: -- Bug 4898703 - END }
5143:
5144: -- Bug 4898703 - START {
5145: BEGIN
5146: x_remaining_qty_po_uom := x_remaining_quantity * po_uom_s.po_uom_convert(temp_cascaded_table(1).unit_of_measure,
5147: x_shipmentdistributionrec.unit_meas_lookup_code,
5148: temp_cascaded_table(1).item_id
5149: );
5150: EXCEPTION

Line 5161: po_asn_uom_qty := 1000 * po_uom_s.po_uom_convert( x_shipmentdistributionrec.unit_meas_lookup_code,

5157:
5158: BEGIN
5159: -- using arbit qty for PO->ASN, PO->PRIMARY UOM conversion as this is just a check
5160:
5161: po_asn_uom_qty := 1000 * po_uom_s.po_uom_convert( x_shipmentdistributionrec.unit_meas_lookup_code,
5162: temp_cascaded_table(1).unit_of_measure,
5163: temp_cascaded_table(1).item_id
5164: );
5165: EXCEPTION

Line 5174: po_primary_uom_qty := 1000 * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,

5170: po_asn_uom_qty := 0;
5171: END;
5172:
5173: BEGIN
5174: po_primary_uom_qty := 1000 * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
5175: temp_cascaded_table(1).primary_unit_of_measure,
5176: temp_cascaded_table(1).item_id
5177: );
5178: -- Bug 4898703 - END }

Line 5283: x_remaining_quantity := x_remaining_qty_po_uom * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,

5279: temp_cascaded_table(1).unit_of_measure);
5280:
5281: else --}{
5282: -- Bug 4898703
5283: x_remaining_quantity := x_remaining_qty_po_uom * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
5284: temp_cascaded_table(1).unit_of_measure,
5285: temp_cascaded_table(1).item_id );
5286: end if; -- 5203841 }
5287: insert_into_table := TRUE;

Line 5363: - (x_bkp_qty * po_uom_s.po_uom_convert(temp_cascaded_table(current_n).unit_of_measure,

5359:
5360: else --}{
5361: -- Bug 4898703
5362: temp_cascaded_table(current_n).vendor_cum_shipped_qty := temp_cascaded_table(current_n).vendor_cum_shipped_qty
5363: - (x_bkp_qty * po_uom_s.po_uom_convert(temp_cascaded_table(current_n).unit_of_measure,
5364: temp_cascaded_table(current_n).primary_unit_of_measure,
5365: temp_cascaded_table(current_n).item_id
5366: ));
5367: end if; -- 5203841 }

Line 5415: temp_cascaded_table(current_n).quantity := x_converted_trx_qty * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,

5411: ); -- in asn uom
5412: --END IF; --}
5413: else --}{
5414: -- Bug 4898703 - START {
5415: temp_cascaded_table(current_n).quantity := x_converted_trx_qty * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
5416: temp_cascaded_table(current_n).unit_of_measure,
5417: temp_cascaded_table(current_n).item_id
5418: ); -- in asn uom
5419: --END IF; --}

Line 5448: temp_cascaded_table(current_n).primary_quantity := x_converted_trx_qty * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,

5444:
5445:
5446:
5447: else -- }{
5448: temp_cascaded_table(current_n).primary_quantity := x_converted_trx_qty * po_uom_s.po_uom_convert(x_shipmentdistributionrec.unit_meas_lookup_code,
5449: temp_cascaded_table(current_n).primary_unit_of_measure,
5450: temp_cascaded_table(current_n).item_id
5451: );
5452: if ( x_shipmentdistributionrec.unit_meas_lookup_code <> temp_cascaded_table(current_n).primary_unit_of_measure) then -- Bug 9701360

Line 12649: PO_UOM_S.UOM_CONVERT (x_converted_trx_qty,

12645: END IF;
12646: END IF; --}
12647: /* Get the available qty in PRIMARY UOM */
12648: /*
12649: PO_UOM_S.UOM_CONVERT (x_converted_trx_qty,
12650: l_uom,
12651: x_item_id,
12652: x_primary_uom,
12653: l_primary_available_qty );

Line 14263: po_uom_s.uom_convert(l_interface_quantity, l_primary_uom, l_item_id,

14259: asn_debug.put_line('l_transaction_uom' || l_transaction_uom);
14260: asn_debug.put_line('l_item_id' || l_item_id);
14261: END IF;
14262:
14263: po_uom_s.uom_convert(l_interface_quantity, l_primary_uom, l_item_id,
14264: l_transaction_uom, l_interface_qty_in_trx_uom);
14265:
14266: END IF;
14267:

Line 14431: PO_UOM_S.UOM_CONVERT (x_converted_trx_qty,

14427: END IF;
14428: END IF; --}
14429: /* Get the available qty in PRIMARY UOM */
14430: /*
14431: PO_UOM_S.UOM_CONVERT (x_converted_trx_qty,
14432: l_uom,
14433: x_item_id,
14434: x_primary_uom,
14435: l_primary_available_qty );

Line 15944: po_uom_s.uom_convert(source_qty,

15940: RETURN NUMBER IS
15941: correct_qty NUMBER;
15942: BEGIN
15943: IF source_uom <> dest_uom THEN
15944: po_uom_s.uom_convert(source_qty,
15945: source_uom,
15946: item_id,
15947: dest_uom,
15948: correct_qty