DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on RCV_TRANSACTIONS_INTERFACE_SV

Line 2720: from the API rcv_transactions_interface_sv.convert_into_correct_qty() */

2716: /* Bug 4004656 -Commented the following statement
2717: IF (lastrecord OR x_remaining_quantity <= 0) THEN */
2718: /* Bug 4747997: We have to compare the rounded off values by 5 decimal places,
2719: as the value hold by this variable is non-rounded value returned
2720: from the API rcv_transactions_interface_sv.convert_into_correct_qty() */
2721: IF (lastrecord OR round(l_rem_qty_trans_uom,5) <=0) THEN --Bug 4004656, Bug:4747997
2722: IF (l_debug = 1) THEN
2723: print_debug('No more rows or the remaining qty is less than zero',4);
2724: END IF;

Line 2889: l_rcv_tolerance_qty_txn_uom := rcv_transactions_interface_sv.convert_into_correct_qty(

2885: is getting calculated in RMA uom instead of transaction uom.
2886: So, We need to convert the tolerance qty for RMA to transaction uom. */
2887: l_rcv_tolerance_qty_rma_uom := x_oe_line_qty * (x_qty_rcv_tolerance/100);
2888:
2889: l_rcv_tolerance_qty_txn_uom := rcv_transactions_interface_sv.convert_into_correct_qty(
2890: l_rcv_tolerance_qty_rma_uom,
2891: x_MatchedRec.unit_of_measure,
2892: temp_cascaded_table(1).item_id,
2893: temp_cascaded_table(1).unit_of_measure);

Line 3392: rcv_transactions_interface_sv.convert_into_correct_qty

3388: Retained it in the transaction uom through the variable l_rcv_qty_trans_uom
3389: by assigning the value of the remaining quantity l_rem_qty_trans_uom
3390: which is already in the transaciton uom */
3391: /* x_remaining_qty_po_uom :=
3392: rcv_transactions_interface_sv.convert_into_correct_qty
3393: (x_remaining_quantity,
3394: temp_cascaded_table(1).unit_of_measure,
3395: temp_cascaded_table(1).item_id,
3396: x_MatchedRec.unit_of_measure); */

Line 3424: rcv_transactions_interface_sv.convert_into_correct_qty

3420: x_converted_trx_qty;
3421:
3422: -- change asn uom qty so both qtys are in sync
3423: x_remaining_quantity :=
3424: rcv_transactions_interface_sv.convert_into_correct_qty
3425: (x_remaining_qty_po_uom,
3426: x_MatchedRec.unit_of_measure,
3427: temp_cascaded_table(1).item_id,
3428: temp_cascaded_table(1).unit_of_measure);

Line 3476: rcv_transactions_interface_sv.convert_into_correct_qty

3472: IF round(l_rcv_qty_trans_uom,5) <> 0 THEN --Bug 4747997
3473: if l_trx_qty_po_uom > 0 then
3474: --Added the following code
3475: l_trx_qty_trans_uom:=
3476: rcv_transactions_interface_sv.convert_into_correct_qty
3477: (l_trx_qty_po_uom,
3478: x_MatchedRec.unit_of_measure,
3479: temp_cascaded_table(1).item_id,
3480: temp_cascaded_table(1).unit_of_measure);

Line 3493: l_rcv_qty_po_uom:= rcv_transactions_interface_sv.convert_into_correct_qty(l_rcv_qty_trans_uom,

3489:
3490: IF ((round(l_rcv_qty_trans_uom,5) - round(l_trx_qty_trans_uom,5)) > 0.00005) THEN --Bug: 4747997 /BUG13591755
3491: -- compare like uoms which is the transaction uom
3492: l_rcv_qty_trans_uom := l_rcv_qty_trans_uom - l_trx_qty_trans_uom;
3493: l_rcv_qty_po_uom:= rcv_transactions_interface_sv.convert_into_correct_qty(l_rcv_qty_trans_uom,
3494: temp_cascaded_table(1).unit_of_measure,
3495: temp_cascaded_table(1).item_id,
3496: x_MatchedRec.unit_of_measure);
3497:

Line 3555: rcv_transactions_interface_sv.convert_into_correct_qty(

3551: END IF;
3552:
3553: temp_cascaded_table(current_n).source_doc_quantity :=
3554: -- x_converted_trx_qty; -- in po uom --Bug 4004656
3555: rcv_transactions_interface_sv.convert_into_correct_qty(
3556: l_trx_qty_trans_uom ,
3557: temp_cascaded_table(current_n).unit_of_measure,
3558: temp_cascaded_table(current_n).item_id,
3559: x_MatchedRec.unit_of_measure);

Line 3572: rcv_transactions_interface_sv.convert_into_correct_qty

3568: END IF;
3569:
3570: temp_cascaded_table(current_n).quantity :=
3571: /* Bug 4004656
3572: rcv_transactions_interface_sv.convert_into_correct_qty
3573: (x_converted_trx_qty,
3574: x_MatchedRec.unit_of_measure,
3575: temp_cascaded_table(current_n).item_id,
3576: temp_cascaded_table(current_n).unit_of_measure); -- in asn uom */

Line 3586: rcv_transactions_interface_sv.convert_into_correct_qty

3582:
3583: -- Primary qty in Primary UOM
3584: temp_cascaded_table(current_n).primary_quantity :=
3585: /* Bug 4004656
3586: rcv_transactions_interface_sv.convert_into_correct_qty
3587: (x_converted_trx_qty,
3588: x_MatchedRec.unit_of_measure,
3589: temp_cascaded_table(current_n).item_id,
3590: temp_cascaded_table(current_n).primary_unit_of_measure); */

Line 3592: rcv_transactions_interface_sv.convert_into_correct_qty(

3588: x_MatchedRec.unit_of_measure,
3589: temp_cascaded_table(current_n).item_id,
3590: temp_cascaded_table(current_n).primary_unit_of_measure); */
3591:
3592: rcv_transactions_interface_sv.convert_into_correct_qty(
3593: l_trx_qty_trans_uom,
3594: temp_cascaded_table(current_n).unit_of_measure,
3595: temp_cascaded_table(current_n).item_id,
3596: temp_cascaded_table(current_n).primary_unit_of_measure);