APPS.PO_RCVIERR_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

          DELETE FROM PO_INTERFACE_ERRORS POI
           WHERE POI.INTERFACE_HEADER_ID in (
             SELECT
               RHI.HEADER_INTERFACE_ID
             FROM
               PO_INTERFACE_ERRORS POI,
               RCV_HEADERS_INTERFACE RHI
             WHERE POI.INTERFACE_HEADER_ID = RHI.HEADER_INTERFACE_ID
               AND ( ( TO_DATE(TO_CHAR(TRUNC(POI.CREATION_DATE)
                            ,'DD-MON-YYYY')
                    ,'DD-MON-YYYY') between TRUNC(NVL(P_START_DATE
                      ,POI.CREATION_DATE))
               AND TRUNC(NVL(P_END_DATE
                      ,SYSDATE))
               AND ( P_START_DATE is not null
             OR P_END_DATE is not null ) )
             OR ( P_START_DATE is null
               AND P_END_DATE is null
               AND RHI.PROCESSING_STATUS_CODE NOT IN ( 'PENDING' ) ) ) );

Line: 30

          DELETE FROM PO_INTERFACE_ERRORS POI
           WHERE POI.INTERFACE_LINE_ID in (
             SELECT
               RTI.INTERFACE_TRANSACTION_ID
             FROM
               PO_INTERFACE_ERRORS POI,
               RCV_TRANSACTIONS_INTERFACE RTI
             WHERE POI.INTERFACE_LINE_ID = RTI.INTERFACE_TRANSACTION_ID
               AND POI.INTERFACE_TYPE = 'RCV-856'
               AND ( ( TRUNC(TO_DATE(TO_CHAR(POI.CREATION_DATE
                                  ,'DD-MON-YYYY')
                          ,'DD-MON-YYYY')) between TRUNC(NVL(P_START_DATE
                      ,POI.CREATION_DATE))
               AND TRUNC(NVL(P_END_DATE
                      ,SYSDATE))
               AND ( P_START_DATE is not null
             OR P_END_DATE is not null ) )
             OR ( P_START_DATE is null
               AND P_END_DATE is null
               AND RTI.PROCESSING_STATUS_CODE NOT IN ( 'PENDING' ) ) ) );

Line: 50

          DELETE FROM PO_INTERFACE_ERRORS POI
           WHERE POI.INTERFACE_TRANSACTION_ID in (
             SELECT
               RTI.INTERFACE_TRANSACTION_ID
             FROM
               PO_INTERFACE_ERRORS POI,
               RCV_TRANSACTIONS_INTERFACE RTI
             WHERE POI.INTERFACE_TRANSACTION_ID = RTI.INTERFACE_TRANSACTION_ID
               AND POI.INTERFACE_TYPE in ( 'RECEIVE' , 'DELIVER' )
               AND ( ( TRUNC(TO_DATE(TO_CHAR(POI.CREATION_DATE
                                  ,'DD-MON-YYYY')
                          ,'DD-MON-YYYY')) between TRUNC(NVL(P_START_DATE
                      ,POI.CREATION_DATE))
               AND TRUNC(NVL(P_END_DATE
                      ,SYSDATE))
               AND ( P_START_DATE is not null
             OR P_END_DATE is not null ) )
             OR ( P_START_DATE is null
               AND P_END_DATE is null
               AND RTI.PROCESSING_STATUS_CODE NOT IN ( 'PENDING' ) ) ) );