APPS.PA_PAXALRUN_XMLP_PKG SQL Statements

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

Line: 37

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

Line: 68

        SELECT
          RULE_NAME
        INTO
          C_RULE_NAME
        FROM
          PA_ALLOC_RULES
        WHERE RULE_ID = P_RULE_ID;

Line: 80

        SELECT
          DECODE(P_RUN_MODE
                ,'G'
                ,DRAFT_REQUEST_ID
                ,'R'
                ,RELEASE_REQUEST_ID
                ,DRAFT_REQUEST_ID),
          RUN_STATUS_CODE,
          RUN_STATUS,
          EXPND_ITEM_DATE,
          RUN_PERIOD
        INTO
          C_REQUEST_ID
          ,P_RUN_STATUS_CODE
          ,C_RUN_STATUS
          ,C_EXPND_ITEM_DATE
          ,C_RUN_PERIOD
        FROM
          PA_ALLOC_RUNS_V
        WHERE RUN_ID = P_RUN_ID;

Line: 106

            SELECT
              MEANING
            INTO
              C_RUN_STATUS
            FROM
              PA_LOOKUPS
            WHERE LOOKUP_TYPE = 'ALLOC_RUN_STATUS'
              AND LOOKUP_CODE = 'DF';

Line: 121

        SELECT
          PURGEABLE_FLAG
        INTO
          X_PURGEABLE
        FROM
          PA_TRANSACTION_SOURCES
        WHERE TRANSACTION_SOURCE = 'ALLOCATIONS';

Line: 135

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

Line: 164

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

          DELETE FROM PA_TRANSACTION_INTERFACE
           WHERE TRANSACTION_SOURCE = 'ALLOCATIONS'
             AND BATCH_NAME = TO_CHAR(P_RUN_ID);

Line: 203

        DELETE FROM PA_TRANSACTION_XFACE_CONTROL
         WHERE TRANSACTION_SOURCE = 'ALLOCATIONS'
           AND BATCH_NAME = TO_CHAR(P_RUN_ID);

Line: 221

    SELECT
      1
    INTO
      DUMMY
    FROM
      DUAL
    WHERE exists (
      SELECT
        1
      FROM
        PA_ALLOC_EXCEPTIONS
      WHERE RUN_ID = P_RUN_ID );

Line: 242

    SELECT
      1
    INTO
      DUMMY
    FROM
      DUAL
    WHERE exists (
      SELECT
        1
      FROM
        PA_ALLOC_TRANSACTIONS_V
      WHERE RUN_ID = P_RUN_ID );

Line: 263

    SELECT
      1
    INTO
      DUMMY
    FROM
      DUAL
    WHERE exists (
      SELECT
        1
      FROM
        PA_ALLOC_TRANSACTIONS_V
      WHERE RUN_ID = P_RUN_ID
        AND REJECTION_CODE is not null );