DBA Data[Home] [Help]

APPS.INV_RCV_STD_TRANSFER_APIS dependencies on INV_RCV_STD_DELIVER_APIS

Line 37: p_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.RCVTXN_TRANSACTION_REC_TP

33: * Returns: NUMBER - transaction_interface_id
34: *---------------------------------------------------------------------------*/
35:
36: FUNCTION insert_interface_code (
37: p_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.RCVTXN_TRANSACTION_REC_TP
38: )
39: RETURN NUMBER IS
40: l_interface_transaction_id NUMBER;
41: l_destination_context RCV_TRANSACTIONS_INTERFACE.DESTINATION_CONTEXT%TYPE := 'RECEIVING';

Line 447: , p_rcv_transaction_rec IN OUT NOCOPY INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp

443: PROCEDURE populate_transfer_rti_values (
444: x_return_status OUT NOCOPY VARCHAR2
445: , x_msg_count OUT NOCOPY NUMBER
446: , x_msg_data OUT NOCOPY VARCHAR2
447: , p_rcv_transaction_rec IN OUT NOCOPY INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp
448: , p_rcvtxn_rec IN OUT NOCOPY INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec
449: , p_parent_txn_id IN NUMBER
450: , p_organization_id IN NUMBER
451: , p_item_id IN NUMBER

Line 448: , p_rcvtxn_rec IN OUT NOCOPY INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec

444: x_return_status OUT NOCOPY VARCHAR2
445: , x_msg_count OUT NOCOPY NUMBER
446: , x_msg_data OUT NOCOPY VARCHAR2
447: , p_rcv_transaction_rec IN OUT NOCOPY INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp
448: , p_rcvtxn_rec IN OUT NOCOPY INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec
449: , p_parent_txn_id IN NUMBER
450: , p_organization_id IN NUMBER
451: , p_item_id IN NUMBER
452: , p_revision IN VARCHAR2

Line 1217: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;

1213: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1214: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1215: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1216: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1217: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1218: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1219: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1220: l_parent_txn_id NUMBER;
1221: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM

Line 1218: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;

1214: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1215: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1216: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1217: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1218: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1219: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1220: l_parent_txn_id NUMBER;
1221: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
1222:

Line 1650: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;

1646: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1647: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1648: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1649: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1650: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1651: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1652: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1653: l_parent_txn_id NUMBER;
1654: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM

Line 1651: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;

1647: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
1648: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1649: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
1650: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
1651: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
1652: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1653: l_parent_txn_id NUMBER;
1654: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
1655: l_progress NUMBER; --Index to track progress and log error

Line 2066: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;

2062: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2063: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2064: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
2065: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
2066: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
2067: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
2068: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
2069: l_parent_txn_id NUMBER;
2070: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM

Line 2067: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;

2063: l_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2064: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
2065: l_transfer_uom_code mtl_units_of_measure.uom_code%TYPE;
2066: l_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_transaction_rec_tp;
2067: l_rcvtxn_rec INV_RCV_STD_DELIVER_APIS.rcvtxn_enter_rec_cursor_rec;
2068: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
2069: l_parent_txn_id NUMBER;
2070: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
2071: