APPS.RCV_INSERT_FROM_INL dependencies on RCV_HEADERS_INTERFACE

Line 92: from rcv_headers_interface rhi

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

Line 100: update rcv_headers_interface

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

Line 134: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL

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

Line 171: INSERT INTO RCV_HEADERS_INTERFACE

167: WHERE aps.party_site_id = l_rcv_header.party_site_id
168: AND apv.party_id = l_rcv_header.party_id
169: AND aps.org_id = l_rcv_header.org_id;
170:
171: INSERT INTO RCV_HEADERS_INTERFACE
172: (header_interface_id,
173: group_id,
174: processing_status_code,
175: receipt_source_code,