APPS.INV_RCV_TXN_MATCH dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1723: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;

1719: x_bkp_qty NUMBER := 0;
1720: x_progress VARCHAR2(3);
1721: x_converted_trx_qty NUMBER := 0;
1722: transaction_ok BOOLEAN := FALSE;
1723: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;
1724: high_range_date DATE;
1725: low_range_date DATE;
1726: rows_fetched NUMBER := 0;
1727: x_tolerable_qty NUMBER := 0;

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

2484: /* Bug 4004656 -Commented the following statement
2485: IF (lastrecord OR x_remaining_quantity <= 0) THEN */
2486: /* Bug 4747997: We have to compare the rounded off values by 5 decimal places,
2487: as the value hold by this variable is non-rounded value returned
2488: from the API rcv_transactions_interface_sv.convert_into_correct_qty() */
2489: IF (lastrecord OR round(l_rem_qty_trans_uom,5) <=0) THEN --Bug 4004656, Bug:4747997
2490: IF (l_debug = 1) THEN
2491: print_debug('No more rows or the remaining qty is less than zero',4);
2492: END IF;

Line 2626: l_rcv_tolerance_qty_txn_uom := rcv_transactions_interface_sv.convert_into_correct_qty(

2622: is getting calculated in RMA uom instead of transaction uom.
2623: So, We need to convert the tolerance qty for RMA to transaction uom. */
2624: l_rcv_tolerance_qty_rma_uom := x_oe_line_qty * (x_qty_rcv_tolerance/100);
2625:
2626: l_rcv_tolerance_qty_txn_uom := rcv_transactions_interface_sv.convert_into_correct_qty(
2627: l_rcv_tolerance_qty_rma_uom,
2628: x_MatchedRec.unit_of_measure,
2629: temp_cascaded_table(1).item_id,
2630: temp_cascaded_table(1).unit_of_measure);

Line 3084: rcv_transactions_interface_sv.convert_into_correct_qty

3080: Retained it in the transaction uom through the variable l_rcv_qty_trans_uom
3081: by assigning the value of the remaining quantity l_rem_qty_trans_uom
3082: which is already in the transaciton uom */
3083: /* x_remaining_qty_po_uom :=
3084: rcv_transactions_interface_sv.convert_into_correct_qty
3085: (x_remaining_quantity,
3086: temp_cascaded_table(1).unit_of_measure,
3087: temp_cascaded_table(1).item_id,
3088: x_MatchedRec.unit_of_measure); */

Line 3116: rcv_transactions_interface_sv.convert_into_correct_qty

3112: x_converted_trx_qty;
3113:
3114: -- change asn uom qty so both qtys are in sync
3115: x_remaining_quantity :=
3116: rcv_transactions_interface_sv.convert_into_correct_qty
3117: (x_remaining_qty_po_uom,
3118: x_MatchedRec.unit_of_measure,
3119: temp_cascaded_table(1).item_id,
3120: temp_cascaded_table(1).unit_of_measure);

Line 3168: rcv_transactions_interface_sv.convert_into_correct_qty

3164: IF round(l_rcv_qty_trans_uom,5) <> 0 THEN --Bug 4747997
3165: if l_trx_qty_po_uom > 0 then
3166: --Added the following code
3167: l_trx_qty_trans_uom:=
3168: rcv_transactions_interface_sv.convert_into_correct_qty
3169: (l_trx_qty_po_uom,
3170: x_MatchedRec.unit_of_measure,
3171: temp_cascaded_table(1).item_id,
3172: temp_cascaded_table(1).unit_of_measure);

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

3177:
3178: IF (round(l_trx_qty_trans_uom,5) < round(l_rcv_qty_trans_uom,5)) THEN --Bug: 4747997
3179: -- compare like uoms which is the transaction uom
3180: l_rcv_qty_trans_uom := l_rcv_qty_trans_uom - l_trx_qty_trans_uom;
3181: l_rcv_qty_po_uom:= rcv_transactions_interface_sv.convert_into_correct_qty(l_rcv_qty_trans_uom,
3182: temp_cascaded_table(1).unit_of_measure,
3183: temp_cascaded_table(1).item_id,
3184: x_MatchedRec.unit_of_measure);
3185:

Line 3244: rcv_transactions_interface_sv.convert_into_correct_qty(

3240: END IF;
3241:
3242: temp_cascaded_table(current_n).source_doc_quantity :=
3243: -- x_converted_trx_qty; -- in po uom --Bug 4004656
3244: rcv_transactions_interface_sv.convert_into_correct_qty(
3245: l_trx_qty_trans_uom ,
3246: temp_cascaded_table(current_n).unit_of_measure,
3247: temp_cascaded_table(current_n).item_id,
3248: x_MatchedRec.unit_of_measure);

Line 3261: rcv_transactions_interface_sv.convert_into_correct_qty

3257: END IF;
3258:
3259: temp_cascaded_table(current_n).quantity :=
3260: /* Bug 4004656
3261: rcv_transactions_interface_sv.convert_into_correct_qty
3262: (x_converted_trx_qty,
3263: x_MatchedRec.unit_of_measure,
3264: temp_cascaded_table(current_n).item_id,
3265: temp_cascaded_table(current_n).unit_of_measure); -- in asn uom */

Line 3275: rcv_transactions_interface_sv.convert_into_correct_qty

3271:
3272: -- Primary qty in Primary UOM
3273: temp_cascaded_table(current_n).primary_quantity :=
3274: /* Bug 4004656
3275: rcv_transactions_interface_sv.convert_into_correct_qty
3276: (x_converted_trx_qty,
3277: x_MatchedRec.unit_of_measure,
3278: temp_cascaded_table(current_n).item_id,
3279: temp_cascaded_table(current_n).primary_unit_of_measure); */

Line 3281: rcv_transactions_interface_sv.convert_into_correct_qty(

3277: x_MatchedRec.unit_of_measure,
3278: temp_cascaded_table(current_n).item_id,
3279: temp_cascaded_table(current_n).primary_unit_of_measure); */
3280:
3281: rcv_transactions_interface_sv.convert_into_correct_qty(
3282: l_trx_qty_trans_uom,
3283: temp_cascaded_table(current_n).unit_of_measure,
3284: temp_cascaded_table(current_n).item_id,
3285: temp_cascaded_table(current_n).primary_unit_of_measure);