DBA Data[Home] [Help]

APPS.RCV_CHARGES_GRP dependencies on RCV_TRANSACTIONS_INTERFACE

Line 957: , p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

953: , x_return_status OUT NOCOPY VARCHAR2
954: , x_msg_count OUT NOCOPY NUMBER
955: , x_msg_data OUT NOCOPY VARCHAR2
956: , p_rhi_id IN RCV_HEADERS_INTERFACE.header_interface_id%TYPE
957: , p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
958: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
959: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
960: ) IS
961: l_charge_interface_table charge_interface_table_type;

Line 982: FROM rcv_transactions_interface

978: OR ( parent_header_interface_id = p_rhi_id
979: AND parent_interface_id IS NULL
980: AND NOT EXISTS (
981: SELECT NULL
982: FROM rcv_transactions_interface
983: WHERE header_interface_id = p_rhi_id
984: AND interface_transaction_id <> p_rti_id)
985: )
986: )