APPS.CSP_RECEIVE_PVT dependencies on RCV_HEADERS_INTERFACE

Line 595: SELECT rcv_headers_interface_s.NEXTVAL

591:
592:
593: l_header_interface_id := p_header_interface_id;
594: If (l_header_interface_id IS NULL) THEN
595: SELECT rcv_headers_interface_s.NEXTVAL
596: INTO l_header_interface_id
597: FROM sys.dual;
598: End If;
599:

Line 627: INSERT INTO RCV_HEADERS_INTERFACE (

623: l_receipt_header_id := NULL;
624: l_shipment_num := NULL;
625: END IF;
626:
627: INSERT INTO RCV_HEADERS_INTERFACE (
628: header_interface_id
629: , group_id
630: , processing_status_code
631: , transaction_type

Line 2163: RCV_HEADERS_INTERFACE rhi

2159: (l_outcome IN ('WARNING', 'ERROR'))) THEN
2160: BEGIN
2161: select ERROR_MESSAGE INTO po_message
2162: from po_interface_errors pie,
2163: RCV_HEADERS_INTERFACE rhi
2164: where BATCH_ID = p_group_id
2165: and TABLE_NAME = 'RCV_HEADERS_INTERFACE'
2166: and pie.interface_header_id = rhi.header_interface_id
2167: and PROCESSING_STATUS_CODE = 'ERROR' ;

Line 2165: and TABLE_NAME = 'RCV_HEADERS_INTERFACE'

2161: select ERROR_MESSAGE INTO po_message
2162: from po_interface_errors pie,
2163: RCV_HEADERS_INTERFACE rhi
2164: where BATCH_ID = p_group_id
2165: and TABLE_NAME = 'RCV_HEADERS_INTERFACE'
2166: and pie.interface_header_id = rhi.header_interface_id
2167: and PROCESSING_STATUS_CODE = 'ERROR' ;
2168: FND_MESSAGE.set_name('CSP','CSP_PO_RECEIVE_ERROR');
2169: fnd_message.set_token('ERROR_MESSAGE', po_message );