APPS.PA_PAXTRTRX_XMLP_PKG SQL Statements

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

Line: 34

        SELECT
          L.MEANING
        INTO NDF
        FROM
          PA_LOOKUPS L
        WHERE L.LOOKUP_TYPE = 'MESSAGE'
          AND L.LOOKUP_CODE = 'NO_DATA_FOUND';

Line: 47

        SELECT
          PURGEABLE_FLAG
        INTO X_PURGEABLE
        FROM
          PA_TRANSACTION_SOURCES
        WHERE TRANSACTION_SOURCE = P_TRX_SOURCE;

Line: 59

        SELECT
          PA_INTERFACE_ID_S.NEXTVAL
        INTO XFACE_ID
        FROM
          SYS.DUAL;

Line: 78

        SELECT
          MEANING
        INTO X_ERROR_MSG
        FROM
          PA_LOOKUPS
        WHERE LOOKUP_TYPE = 'TRANSACTION REJECTION REASON'
          AND LOOKUP_CODE = 'INVALID_TRX_SOURCE';

Line: 99

    SELECT
      GL.NAME
    INTO L_NAME
    FROM
      GL_SETS_OF_BOOKS GL,
      PA_IMPLEMENTATIONS PI
    WHERE GL.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;

Line: 118

          DELETE FROM PA_MC_TXN_INTERFACE_ALL
           WHERE TXN_INTERFACE_ID in (
             SELECT
               TXN_INTERFACE_ID
             FROM
               PA_TRANSACTION_INTERFACE
             WHERE INTERFACE_ID = P_XFACE_ID
               AND ( ( TRANSACTION_STATUS_CODE = 'A' )
             OR ( TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR' ) ) );

Line: 131

        DELETE FROM PA_TRANSACTION_INTERFACE
         WHERE INTERFACE_ID = P_XFACE_ID
           AND ( ( TRANSACTION_STATUS_CODE = 'A' )
         OR ( TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR' ) );

Line: 136

      DELETE FROM PA_TRANSACTION_XFACE_CONTROL
       WHERE INTERFACE_ID = P_XFACE_ID
         AND STATUS = 'PROCESSED';