eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_RETURN dependencies on RCV_TRANSACTIONS_INTERFACE

Line 199: rcv_transactions_interface_sv.get_reason_id(reason_id_record);

195: IF (g_asn_debug = 'Y') THEN
196: asn_debug.put_line('Derive Reason_id');
197: END IF;
198:
199: rcv_transactions_interface_sv.get_reason_id(reason_id_record);
200: x_cascaded_table(n).reason_id := reason_id_record.reason_id;
201: x_cascaded_table(n).error_status := reason_id_record.error_record.error_status;
202: x_cascaded_table(n).error_message := reason_id_record.error_record.error_message;
203: END IF;

Line 361: FROM rcv_transactions_interface rti

357: rti.primary_unit_of_measure,
358: rti.quantity,
359: rti.interface_transaction_id transaction_id,
360: rti.unit_of_measure
361: FROM rcv_transactions_interface rti
362: WHERE interface_transaction_id = v_parent_interface_txn_id;
363:
364: x_derive_returnrec derive_return%ROWTYPE;
365: x_temp_parent_trx_qty NUMBER := 0;

Line 436: /* 2119137 : If the user populates rcv_transactions_interface

432: -- the asn is consumed. (Cascade)
433: -- For return, there will be no cascade since there's only 1 parent txn per
434: -- return, the temp_cascade_table will be deprecated in phase 2 -pjiang
435:
436: /* 2119137 : If the user populates rcv_transactions_interface
437: with po_line_id, then ROI errors out with
438: RCV_ASN_NO_PO_LINE_LOCATION_ID when the document_line_num
439: is not provided for one time items. Modified the "if" criteria in
440: such a way that the ROI validation does'nt error out when

Line 680: x_remaining_qty_parent_uom := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

676: END IF; /* if already_allocated_qty is >0 for return */ --}
677: END IF; /*derive_values_from_rti is false */--}
678: END IF; --} interface_available_qty is 0.
679:
680: x_remaining_qty_parent_uom := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
681: temp_cascaded_table(1).unit_of_measure,
682: temp_cascaded_table(1).item_id,
683: x_derive_returnrec.unit_of_measure
684: );

Line 709: x_remaining_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_qty_parent_uom,

705: */
706: x_remaining_qty_parent_uom := x_remaining_qty_parent_uom - x_converted_parent_trx_qty;
707:
708: IF (temp_cascaded_table(current_n).unit_of_measure <> x_derive_returnrec.unit_of_measure) THEN
709: x_remaining_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_qty_parent_uom,
710: x_derive_returnrec.unit_of_measure,
711: temp_cascaded_table(1).item_id,
712: temp_cascaded_table(1).unit_of_measure
713: );

Line 780: temp_cascaded_table(current_n).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_parent_trx_qty,

776: temp_cascaded_table(current_n).primary_unit_of_measure := x_derive_returnrec.primary_unit_of_measure;
777: temp_cascaded_table(current_n).quantity := x_converted_parent_trx_qty;
778:
779: IF (temp_cascaded_table(current_n).primary_unit_of_measure <> x_derive_returnrec.unit_of_measure) THEN
780: temp_cascaded_table(current_n).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_parent_trx_qty,
781: x_derive_returnrec.unit_of_measure,
782: temp_cascaded_table(current_n).item_id,
783: temp_cascaded_table(current_n).primary_unit_of_measure
784: );

Line 1280: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,

1276: * the parameters here so that this can be called from the client side
1277: * library for the Enter returns and Enter corrections forms also.
1278: */
1279: PROCEDURE derive_inv_qty_1(
1280: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1281: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1282: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,

Line 1281: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,

1277: * library for the Enter returns and Enter corrections forms also.
1278: */
1279: PROCEDURE derive_inv_qty_1(
1280: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1281: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1282: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,

Line 1282: p_quantity IN rcv_transactions_interface.quantity%TYPE,

1278: */
1279: PROCEDURE derive_inv_qty_1(
1280: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1281: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1282: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,

Line 1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,

1279: PROCEDURE derive_inv_qty_1(
1280: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1281: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1282: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,

Line 1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,

1280: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1281: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1282: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,

Line 1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,

1281: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1282: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,

Line 1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,

1282: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,

Line 1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,

1283: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,

Line 1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,

1284: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1292: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,

Line 1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,

1285: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1292: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1293: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,

Line 1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,

1286: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1292: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1293: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1294: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,

Line 1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,

1287: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1292: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1293: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1294: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,
1295: x_error_status IN OUT NOCOPY VARCHAR2,

Line 1292: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,

1288: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1292: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1293: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1294: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,
1295: x_error_status IN OUT NOCOPY VARCHAR2,
1296: x_error_message IN OUT NOCOPY VARCHAR2

Line 1293: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,

1289: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1292: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1293: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1294: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,
1295: x_error_status IN OUT NOCOPY VARCHAR2,
1296: x_error_message IN OUT NOCOPY VARCHAR2
1297: ) IS

Line 1294: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,

1290: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1291: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1292: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1293: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1294: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,
1295: x_error_status IN OUT NOCOPY VARCHAR2,
1296: x_error_message IN OUT NOCOPY VARCHAR2
1297: ) IS
1298: CURSOR lot_rows(

Line 1312: FROM rcv_transactions_interface

1308: CURSOR rti_rows(
1309: l_interface_id NUMBER
1310: ) IS
1311: SELECT quantity
1312: FROM rcv_transactions_interface
1313: WHERE interface_transaction_id = l_interface_id;
1314:
1315: l_rti rti_rows%ROWTYPE;
1316: l_negative_inv_receipt_code NUMBER;

Line 1338: l_revision rcv_transactions_interface.item_revision%TYPE;

1334: l_atr NUMBER;
1335: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1336: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;
1337: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;
1338: l_revision rcv_transactions_interface.item_revision%TYPE;
1339: l_primary_qty NUMBER;
1340: l_table_name po_interface_errors.table_name%TYPE;
1341: BEGIN
1342: /* We need to do this only for returns and -ve corrections.

Line 1427: l_primary_qty := ABS(rcv_transactions_interface_sv.convert_into_correct_qty(l_lot.transaction_quantity,

1423: asn_debug.put_line('lot_number ' || l_lot.lot_number);
1424: END IF;
1425:
1426: l_lot_number := l_lot.lot_number;
1427: l_primary_qty := ABS(rcv_transactions_interface_sv.convert_into_correct_qty(l_lot.transaction_quantity,
1428: p_unit_of_measure,
1429: p_item_id,
1430: p_primary_unit_of_measure
1431: ));

Line 1436: l_primary_qty := ABS(rcv_transactions_interface_sv.convert_into_correct_qty(l_rti.quantity,

1432: ELSIF(rti_rows%ISOPEN) THEN --}{
1433: FETCH rti_rows INTO l_rti;
1434: EXIT WHEN rti_rows%NOTFOUND;
1435: l_lot_number := NULL;
1436: l_primary_qty := ABS(rcv_transactions_interface_sv.convert_into_correct_qty(l_rti.quantity,
1437: p_unit_of_measure,
1438: p_item_id,
1439: p_primary_unit_of_measure
1440: ));

Line 1479: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';

1475:
1476: IF (lot_rows%ISOPEN) THEN
1477: l_table_name := 'MTL_TRANSACTION_LOTS_INTERFACE';
1478: ELSE
1479: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';
1480: END IF;
1481:
1482: IF (l_return_status = 'S') THEN --{
1483: x_error_status := 'S';