APPS.RCV_INSERT_FROM_INL dependencies on RCV_HEADERS_INTERFACE

Line 93: from rcv_headers_interface rhi

89: /*
90: update RCV_TRANSACTIONS_INTERFACE RTI
91: set PROCESSING_STATUS_CODE = 'PENDING'
92: where RTI.header_interface_id = ( select rhi.header_interface_id
93: from rcv_headers_interface rhi
94: where rhi.header_interface_id = rti.header_interface_id
95: and rhi.group_id = rti.group_id
96: and rhi.receipt_header_id = p_int_rec(i).shipment_header_id)
97: and RTI.PROCESSING_STATUS_CODE = 'INSERTING';

Line 101: update rcv_headers_interface

97: and RTI.PROCESSING_STATUS_CODE = 'INSERTING';
98:
99: asn_debug.put_line ('no of rows updated: '|| SQL%ROWCOUNT);
100:
101: update rcv_headers_interface
102: set receipt_header_id = NULL
103: where receipt_header_id = p_int_rec(i).shipment_header_id;
104:
105: */

Line 136: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL

132: end if;
133:
134: asn_debug.put_line ('ship line group id: '||p_int_rec(i).ship_line_group_id);
135:
136: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL
137: INTO l_header_interface_id
138: FROM dual;
139:
140: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL

Line 184: INSERT INTO RCV_HEADERS_INTERFACE

180: WHERE ph.po_header_id = pll.po_header_id
181: AND pll.line_location_id = p_int_rec(i).ship_line_source_id;
182:
183:
184: INSERT INTO RCV_HEADERS_INTERFACE
185: (header_interface_id,
186: group_id,
187: processing_status_code,
188: receipt_source_code,