APPS.RCV_RMA_RCPT_PURGE dependencies on RCV_TRANSACTIONS

Line 17: from rcv_transactions_interface

13: x_progress := '010';
14:
15: --Bugfix5216533: Rewritten the query for performance issues.
16: select count(*) into x_interface_ct
17: from rcv_transactions_interface
18: where oe_order_line_id = x_order_line_id
19: and processing_status_code in ('PENDING','ERROR');
20:
21: x_progress := '020';

Line 109: /* delete from rcv_transactions */

105: end if;
106:
107: x_progress := '060';
108:
109: /* delete from rcv_transactions */
110: delete from rcv_transactions
111: where shipment_line_id = x_ship_line_id;
112:
113: END LOOP;

Line 110: delete from rcv_transactions

106:
107: x_progress := '060';
108:
109: /* delete from rcv_transactions */
110: delete from rcv_transactions
111: where shipment_line_id = x_ship_line_id;
112:
113: END LOOP;
114: CLOSE c1;