APPS.POS_ASN dependencies on RCV_HEADERS_INTERFACE

Line 1018: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_header_id from dual;

1014: BEGIN
1015:
1016: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_request_id from dual;
1017:
1018: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_header_id from dual;
1019:
1020: insert into rcv_headers_interface
1021: (HEADER_INTERFACE_ID ,
1022: GROUP_ID ,

Line 1020: insert into rcv_headers_interface

1016: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_request_id from dual;
1017:
1018: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_header_id from dual;
1019:
1020: insert into rcv_headers_interface
1021: (HEADER_INTERFACE_ID ,
1022: GROUP_ID ,
1023: PROCESSING_STATUS_CODE ,
1024: PROCESSING_REQUEST_ID ,

Line 1387: -- delete from rcv_headers_interface where header_interface_id = l_header_id;

1383: * dreddy - instead of deleting from the header set the processing status_code
1384: * to success so that the pre-processor does not run again. This is because the
1385: * the data in this table is needed by the receiving transaction processor.
1386: */
1387: -- delete from rcv_headers_interface where header_interface_id = l_header_id;
1388: update rcv_headers_interface set
1389: validation_flag = 'N',
1390: processing_status_code = 'SUCCESS'
1391: where header_interface_id = l_header_id;

Line 1388: update rcv_headers_interface set

1384: * to success so that the pre-processor does not run again. This is because the
1385: * the data in this table is needed by the receiving transaction processor.
1386: */
1387: -- delete from rcv_headers_interface where header_interface_id = l_header_id;
1388: update rcv_headers_interface set
1389: validation_flag = 'N',
1390: processing_status_code = 'SUCCESS'
1391: where header_interface_id = l_header_id;
1392: