APPS.PA_PAAPIMPR_XMLP_PKG SQL Statements

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

Line: 32

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

Line: 48

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

Line: 70

    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: 88

        SELECT
          PTS.TRANSACTION_SOURCE,
          PTS.PURGEABLE_FLAG
        FROM
          PA_TRANSACTION_SOURCES PTS
        WHERE PTS.TRANSACTION_SOURCE in (
          SELECT
            PTI.TRANSACTION_SOURCE
          FROM
            PA_TRANSACTION_INTERFACE PTI
          WHERE PTI.ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE );

Line: 101

        DELETE FROM PA_TRANSACTION_XFACE_CONTROL
         WHERE INTERFACE_ID IN (
           SELECT
             INTERFACE_ID
           FROM
             PA_TRANSACTION_INTERFACE
           WHERE TRANSACTION_SOURCE = REC_C1.TRANSACTION_SOURCE
             AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME
              ,BATCH_NAME)
             AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE
             AND ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE )
           AND STATUS = 'PROCESSED';

Line: 114

          DELETE FROM PA_TRANSACTION_INTERFACE
           WHERE TRANSACTION_SOURCE = REC_C1.TRANSACTION_SOURCE
             AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME
              ,BATCH_NAME)
             AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE
             AND ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE
             AND ( NVL(TRANSACTION_REJECTION_CODE
              ,'-99') not in ( 'GMS_EXP_ITEM_DT_BEFORE_AWD_ST' , 'GMS_EXP_ITEM_DT_AFTER_AWD_END' , 'GMS_AWARD_IS_CLOSED' , 'EXP_TYPE_INACTIVE'
	      , 'ETYPE_SLINK_INACTIVE' , 'PA_EX_PROJECT_DATE' , 'PA_EXP_TASK_EFF' , 'PA_EXP_ORG_NOT_ACTIVE' , 'NO_ASSIGNMENT' , 'PA_REJECTED_PARENT_RECORD' )
           OR SYSTEM_LINKAGE = 'ER' );