DBA Data[Home] [Help]

APPS.CSD_RECEIVE_UTIL dependencies on RCV_TRANSACTIONS_INTERFACE

Line 516: -- rcv_transactions_interface for the given request group id.

512: l_order_header_id NUMBER;
513: l_order_line_id NUMBER;
514:
515: -- Cursor which gets the header interface transaction id from the
516: -- rcv_transactions_interface for the given request group id.
517: CURSOR cur_rcv_headers (
518: p_group_id NUMBER
519: )
520: IS

Line 526: -- rcv_transactions_interface for the given request group id.

522: FROM rcv_headers_interface
523: WHERE GROUP_ID = p_group_id;
524:
525: -- Cursor which gets the interface transaction id from the
526: -- rcv_transactions_interface for the given request group id.
527: CURSOR cur_rcv_lines (
528: p_group_id NUMBER
529: )
530: IS

Line 532: FROM rcv_transactions_interface

528: p_group_id NUMBER
529: )
530: IS
531: SELECT interface_transaction_id
532: FROM rcv_transactions_interface
533: WHERE GROUP_ID = p_group_id;
534:
535:
536: -- Cursor to select the receiving errors from po_interface_errors table

Line 551: FROM rcv_transactions_interface

547: -- Cursor to derive the transaction_details
548: CURSOR cur_get_txn_details ( p_interface_transaction_id NUMBER) IS
549: SELECT oe_order_header_id,
550: oe_order_line_id
551: FROM rcv_transactions_interface
552: WHERE interface_transaction_id = p_interface_transaction_id;
553:
554: BEGIN
555: