APPS.RCV_RMA_RCPT_PURGE dependencies on RCV_SHIPMENT_LINES

Line 53: from rcv_shipment_lines

49: x_line_count number;
50:
51: CURSOR c1(x_order_line_id number) IS
52: select shipment_line_id,shipment_header_id
53: from rcv_shipment_lines
54: where oe_order_line_id = x_order_line_id;
55:
56: BEGIN
57: x_progress := '010';

Line 91: /* delete from rcv_shipment_lines */

87: delete from rcv_serial_transactions
88: where shipment_line_id = x_ship_line_id;
89:
90: x_progress := '050';
91: /* delete from rcv_shipment_lines */
92: delete from rcv_shipment_lines
93: where shipment_line_id = x_ship_line_id;
94:
95: /* if the shipment header for this line does not have any more lines

Line 92: delete from rcv_shipment_lines

88: where shipment_line_id = x_ship_line_id;
89:
90: x_progress := '050';
91: /* delete from rcv_shipment_lines */
92: delete from rcv_shipment_lines
93: where shipment_line_id = x_ship_line_id;
94:
95: /* if the shipment header for this line does not have any more lines
96: * then delete the header .

Line 99: from rcv_shipment_lines

95: /* if the shipment header for this line does not have any more lines
96: * then delete the header .
97: */
98: select count(*) into x_line_count
99: from rcv_shipment_lines
100: where shipment_header_id = x_ship_header_id;
101:
102: if x_line_count = 0 then
103: delete from rcv_shipment_headers