APPS.RLM_RLMDPPSR_XMLP_PKG SQL Statements

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

Line: 44

      DELETE FROM RLM_DEMAND_EXCEPTIONS
       WHERE REQUEST_ID = P_REQUEST_ID
         AND PURGE_STATUS is not null;

Line: 57

      SELECT
        MEANING
      INTO X_SCHEDULE_TYPE
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
        AND LOOKUP_CODE = SCHEDULE_TYPE;

Line: 79

        SELECT
          MEANING
        INTO X_YES
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'YES_NO'
          AND LOOKUP_CODE = 'N';

Line: 88

        SELECT
          MEANING
        INTO X_YES
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'YES_NO'
          AND LOOKUP_CODE = PURGE_STATUS;

Line: 108

      SELECT
        count(distinct SCHEDULE_HEADER_ID)
      INTO V_COUNT1
      FROM
        RLM_DEMAND_EXCEPTIONS
      WHERE REQUEST_ID = P_REQUEST_ID
        AND ( MESSAGE_NAME like '%SUCCESS%'
      OR MESSAGE_NAME like '%PURGABLE%'
      OR MESSAGE_NAME IS NULL );

Line: 117

      SELECT
        count(distinct SCHEDULE_HEADER_ID)
      INTO V_COUNT2
      FROM
        RLM_DEMAND_EXCEPTIONS
      WHERE REQUEST_ID = P_REQUEST_ID
        AND MESSAGE_NAME NOT like '%SUCCESS%'
        AND MESSAGE_NAME NOT like '%PURGABLE%'
        AND MESSAGE_NAME IS NOT NULL;

Line: 137

      SELECT
        count(distinct SCHEDULE_HEADER_ID)
      INTO V_COUNT
      FROM
        RLM_DEMAND_EXCEPTIONS
      WHERE REQUEST_ID = P_REQUEST_ID
        AND ( MESSAGE_NAME like '%SUCCESS%'
      OR MESSAGE_NAME like '%PURGABLE%'
      OR MESSAGE_NAME IS NULL );

Line: 156

      SELECT
        count(distinct SCHEDULE_HEADER_ID)
      INTO V_COUNT
      FROM
        RLM_DEMAND_EXCEPTIONS
      WHERE REQUEST_ID = P_REQUEST_ID
        AND MESSAGE_NAME NOT like '%SUCCESS%'
        AND MESSAGE_NAME NOT like '%PURGABLE%'
        AND MESSAGE_NAME IS NOT NULL;

Line: 176

        SELECT
          DISTINCT
          SCHEDULE_REFERENCE_NUM
        INTO V_REF
        FROM
          RLM_DEMAND_EXCEPTIONS
        WHERE REQUEST_ID = P_REQUEST_ID;

Line: 200

        SELECT
          ACCT_SITE.ECE_TP_LOCATION_CODE
        INTO V_REF
        FROM
          HZ_CUST_ACCT_SITES ACCT_SITE
        WHERE ACCT_SITE.CUST_ACCT_SITE_ID = P_SHIP_TO_ADDRESS_ID_FROM;

Line: 223

        SELECT
          ACCT_SITE.ECE_TP_LOCATION_CODE
        INTO V_REF
        FROM
          HZ_CUST_ACCT_SITES ACCT_SITE
        WHERE ACCT_SITE.CUST_ACCT_SITE_ID = P_SHIP_TO_ADDRESS_ID_TO;

Line: 248

        SELECT
          MEANING
        INTO X_SCHEDULE_TYPE
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
          AND LOOKUP_CODE = P_SCHEDULE_TYPE;

Line: 269

      SELECT
        MEANING
      INTO X_EXEC
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'RLM_EXECUTION_MODE'
        AND LOOKUP_CODE = P_EXECUTION_MODE;

Line: 289

      SELECT
        MEANING
      INTO X_YES
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_AUTHORIZATION;

Line: 310

      SELECT
        MEANING
      INTO X_YES
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = PURGE_STATUS;

Line: 327

      SELECT
        MEANING
      INTO X_STATUS
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'RLM_STATUS'
        AND LOOKUP_CODE = P_STATUS;

Line: 348

        SELECT
          SUBSTRB(PARTY.PARTY_NAME
                 ,1
                 ,50) CUSTOMER_NAME
        INTO V_CUSTOMER_NAME
        FROM
          HZ_PARTIES PARTY,
          HZ_CUST_ACCOUNTS CUST_ACCT
        WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER
          AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID;

Line: 380

   SELECT COUNT(*) INTO V_COUNT FROM RLM_DEMAND_EXCEPTIONS
   WHERE REQUEST_ID = P_REQUEST_ID;