APPS.INV_RCV_TXN_INTERFACE dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1326: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;

1322: x_bkp_qty number := 0;
1323: x_progress varchar2(3);
1324: x_converted_trx_qty number := 0;
1325: transaction_ok boolean := FALSE;
1326: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;
1327: high_range_date DATE;
1328: low_range_date DATE;
1329: rows_fetched number := 0;
1330: x_tolerable_qty number := 0;

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

2109: /* Bug 4004656 -Commented the following statement
2110: if (lastrecord or x_remaining_quantity <= 0) then */
2111: /* Bug 4747997: We have to compare the rounded off values by 5 decimal places,
2112: as the value hold by this variable is non-rounded value returned
2113: from the API rcv_transactions_interface_sv.convert_into_correct_qty() */
2114:
2115: if (lastrecord or round(l_rem_qty_trans_uom,5) <= 0) then --Bug 4747997
2116: --End of fix for Bug 4004656
2117: IF l_print_debug = 1 THEN

Line 2338: rcv_transactions_interface_sv.convert_into_correct_qty(

2334: END IF;
2335: temp_cascaded_table(current_n).primary_quantity :=
2336: temp_cascaded_table(current_n).primary_quantity +
2337: /* Bug 4004656
2338: rcv_transactions_interface_sv.convert_into_correct_qty(
2339: x_remaining_quantity,
2340: temp_cascaded_table(1).unit_of_measure,
2341: temp_cascaded_table(1).item_id,
2342: temp_cascaded_table(1).primary_unit_of_measure); */

Line 2343: rcv_transactions_interface_sv.convert_into_correct_qty(

2339: x_remaining_quantity,
2340: temp_cascaded_table(1).unit_of_measure,
2341: temp_cascaded_table(1).item_id,
2342: temp_cascaded_table(1).primary_unit_of_measure); */
2343: rcv_transactions_interface_sv.convert_into_correct_qty(
2344: l_rem_qty_trans_uom,
2345: temp_cascaded_table(1).unit_of_measure,
2346: temp_cascaded_table(1).item_id,
2347: temp_cascaded_table(1).primary_unit_of_measure);

Line 2929: rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

2925: Retained it in the transaction uom through the variable l_rcv_qty_trans_uom
2926: by assigning the value of the remaining quantity l_rem_qty_trans_uom
2927: which is already in the transaciton uom */
2928: /* x_remaining_qty_po_uom :=
2929: rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
2930: temp_cascaded_table(1).unit_of_measure,
2931: temp_cascaded_table(1).item_id,
2932: x_ShipmentDistributionRec.unit_meas_lookup_code); */
2933:

Line 3001: rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_qty_po_uom,

2997:
2998: -- change asn uom qty so both qtys are in sync
2999:
3000: x_remaining_quantity :=
3001: rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_qty_po_uom,
3002: x_ShipmentDistributionRec.unit_meas_lookup_code,
3003: temp_cascaded_table(1).item_id,
3004: temp_cascaded_table(1).unit_of_measure);
3005:

Line 3057: rcv_transactions_interface_sv.convert_into_correct_qty

3053: end if; */
3054: if l_trx_qty_po_uom > 0 then
3055: --Added the following code
3056: l_trx_qty_trans_uom:=
3057: rcv_transactions_interface_sv.convert_into_correct_qty
3058: (l_trx_qty_po_uom,
3059: x_ShipmentDistributionRec.unit_meas_lookup_code,
3060: temp_cascaded_table(1).item_id,
3061: temp_cascaded_table(1).unit_of_measure);

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

3069:
3070: if (round(l_trx_qty_trans_uom,5) < round(l_rcv_qty_trans_uom,5)) then --Bug 4747997
3071: -- compare like uoms which is the transaction uom
3072: l_rcv_qty_trans_uom := l_rcv_qty_trans_uom - l_trx_qty_trans_uom;
3073: l_rcv_qty_po_uom:= rcv_transactions_interface_sv.convert_into_correct_qty(l_rcv_qty_trans_uom,
3074: temp_cascaded_table(1).unit_of_measure,
3075: temp_cascaded_table(1).item_id,
3076: x_ShipmentDistributionRec.unit_meas_lookup_code);
3077:

Line 3154: rcv_transactions_interface_sv.convert_into_correct_qty(

3150: -- quantity,quantity_shipped -> in ASN uom
3151:
3152: temp_cascaded_table(current_n).source_doc_quantity :=
3153: -- x_converted_trx_qty; -- in po uom --Bug 4004656
3154: rcv_transactions_interface_sv.convert_into_correct_qty(
3155: l_trx_qty_trans_uom ,
3156: temp_cascaded_table(current_n).unit_of_measure,
3157: temp_cascaded_table(current_n).item_id,
3158: x_ShipmentDistributionRec.unit_meas_lookup_code);

Line 3166: rcv_transactions_interface_sv.convert_into_correct_qty(

3162: x_ShipmentDistributionRec.unit_meas_lookup_code;
3163:
3164: temp_cascaded_table(current_n).quantity :=
3165: /* Bug 4004656
3166: rcv_transactions_interface_sv.convert_into_correct_qty(
3167: x_converted_trx_qty,
3168: x_ShipmentDistributionRec.unit_meas_lookup_code,
3169: temp_cascaded_table(current_n).item_id,
3170: temp_cascaded_table(current_n).unit_of_measure); -- in asn uom */

Line 3184: rcv_transactions_interface_sv.convert_into_correct_qty(

3180: x_ShipmentDistributionRec.unit_meas_lookup_code;
3181: END IF;
3182: temp_cascaded_table(current_n).primary_quantity :=
3183: /* Bug 4004656
3184: rcv_transactions_interface_sv.convert_into_correct_qty(
3185: x_converted_trx_qty,
3186: x_ShipmentDistributionRec.unit_meas_lookup_code,
3187: temp_cascaded_table(current_n).item_id,
3188: temp_cascaded_table(current_n).primary_unit_of_measure); */

Line 3190: rcv_transactions_interface_sv.convert_into_correct_qty(

3186: x_ShipmentDistributionRec.unit_meas_lookup_code,
3187: temp_cascaded_table(current_n).item_id,
3188: temp_cascaded_table(current_n).primary_unit_of_measure); */
3189:
3190: rcv_transactions_interface_sv.convert_into_correct_qty(
3191: l_trx_qty_trans_uom,
3192: temp_cascaded_table(current_n).unit_of_measure,
3193: temp_cascaded_table(current_n).item_id,
3194: temp_cascaded_table(current_n).primary_unit_of_measure);