APPS.GL_EBI_PUB SQL Statements

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

Line: 39

      SELECT count(1) INTO l_count
      FROM GL_DAILY_RATES_INTERFACE
      WHERE FROM_CURRENCY = p_daily_rates_tbl(i).TO_CURRENCY
        AND TO_CURRENCY = p_daily_rates_tbl(i).FROM_CURRENCY
        AND FROM_CONVERSION_DATE = p_daily_rates_tbl(i).FROM_CONVERSION_DATE
        AND TO_CONVERSION_DATE = p_daily_rates_tbl(i).TO_CONVERSION_DATE
        AND USER_CONVERSION_TYPE = p_daily_rates_tbl(i).USER_CONVERSION_TYPE
        AND BATCH_NUMBER = p_integration_id;

Line: 49

        UPDATE GL_DAILY_RATES_INTERFACE
        SET INVERSE_CONVERSION_RATE = p_daily_rates_tbl(i).CONVERSION_RATE
        WHERE FROM_CURRENCY = p_daily_rates_tbl(i).TO_CURRENCY
        AND TO_CURRENCY = p_daily_rates_tbl(i).FROM_CURRENCY
        AND FROM_CONVERSION_DATE = p_daily_rates_tbl(i).FROM_CONVERSION_DATE
        AND TO_CONVERSION_DATE = p_daily_rates_tbl(i).TO_CONVERSION_DATE
        AND USER_CONVERSION_TYPE = p_daily_rates_tbl(i).USER_CONVERSION_TYPE
        AND BATCH_NUMBER = p_integration_id;

Line: 59

        INSERT INTO GL_DAILY_RATES_INTERFACE(
             FROM_CURRENCY,
             TO_CURRENCY,
             FROM_CONVERSION_DATE,
             TO_CONVERSION_DATE,
             USER_CONVERSION_TYPE,
             CONVERSION_RATE,
             MODE_FLAG,
             INVERSE_CONVERSION_RATE,
             USER_ID,
             LAUNCH_RATE_CHANGE,
             ERROR_CODE,
             CONTEXT,
             ATTRIBUTE1,
             ATTRIBUTE2,
             ATTRIBUTE3,
             ATTRIBUTE4,
             ATTRIBUTE5,
             ATTRIBUTE6,
             ATTRIBUTE7,
             ATTRIBUTE8,
             ATTRIBUTE9,
             ATTRIBUTE10,
             ATTRIBUTE11,
             ATTRIBUTE12,
             ATTRIBUTE13,
             ATTRIBUTE14,
             USED_FOR_AB_TRANSLATION,
             ATTRIBUTE15,
             BATCH_NUMBER
            )
            VALUES(
             p_daily_rates_tbl(i).FROM_CURRENCY,
             p_daily_rates_tbl(i).TO_CURRENCY,
             p_daily_rates_tbl(i).FROM_CONVERSION_DATE,
             p_daily_rates_tbl(i).TO_CONVERSION_DATE,
             p_daily_rates_tbl(i).USER_CONVERSION_TYPE,
             p_daily_rates_tbl(i).CONVERSION_RATE,
             nvl(p_daily_rates_tbl(i).MODE_FLAG,'I'),
             p_daily_rates_tbl(i).INVERSE_CONVERSION_RATE,
             fnd_global.user_id,
             p_daily_rates_tbl(i).LAUNCH_RATE_CHANGE,
             p_daily_rates_tbl(i).ERROR_CODE,
             p_daily_rates_tbl(i).CONTEXT,
             p_daily_rates_tbl(i).ATTRIBUTE1,
             p_daily_rates_tbl(i).ATTRIBUTE2,
             p_daily_rates_tbl(i).ATTRIBUTE3,
             p_daily_rates_tbl(i).ATTRIBUTE4,
             p_daily_rates_tbl(i).ATTRIBUTE5,
             p_daily_rates_tbl(i).ATTRIBUTE6,
             p_daily_rates_tbl(i).ATTRIBUTE7,
             p_daily_rates_tbl(i).ATTRIBUTE8,
             p_daily_rates_tbl(i).ATTRIBUTE9,
             p_daily_rates_tbl(i).ATTRIBUTE10,
             p_daily_rates_tbl(i).ATTRIBUTE11,
             p_daily_rates_tbl(i).ATTRIBUTE12,
             p_daily_rates_tbl(i).ATTRIBUTE13,
             p_daily_rates_tbl(i).ATTRIBUTE14,
             p_daily_rates_tbl(i).USED_FOR_AB_TRANSLATION,
             p_daily_rates_tbl(i).ATTRIBUTE15,
             p_integration_id
            );

Line: 126

    SELECT gl_ebi_daily_rates_obj(FROM_CURRENCY,
             TO_CURRENCY,
             FROM_CONVERSION_DATE,
             TO_CONVERSION_DATE,
             USER_CONVERSION_TYPE,
             CONVERSION_RATE,
             MODE_FLAG,
             INVERSE_CONVERSION_RATE,
             USER_ID,
             LAUNCH_RATE_CHANGE,
             ERROR_CODE,
             CONTEXT,
             ATTRIBUTE1,
             ATTRIBUTE2,
             ATTRIBUTE3,
             ATTRIBUTE4,
             ATTRIBUTE5,
             ATTRIBUTE6,
             ATTRIBUTE7,
             ATTRIBUTE8,
             ATTRIBUTE9,
             ATTRIBUTE10,
             ATTRIBUTE11,
             ATTRIBUTE12,
             ATTRIBUTE13,
             ATTRIBUTE14,
             USED_FOR_AB_TRANSLATION,
             ATTRIBUTE15)
             BULK COLLECT INTO l_sorted_table
    FROM GL_DAILY_RATES_INTERFACE
    WHERE BATCH_NUMBER = p_integration_id
    ORDER BY FROM_CURRENCY,TO_CURRENCY,USER_CONVERSION_TYPE,FROM_CONVERSION_DATE;

Line: 165

           UPDATE GL_DAILY_RATES_INTERFACE
           SET TO_CONVERSION_DATE = l_sorted_table(i+1).FROM_CONVERSION_DATE-1
           WHERE FROM_CURRENCY = l_sorted_table(i).FROM_CURRENCY
           AND TO_CURRENCY = l_sorted_table(i).TO_CURRENCY
           AND FROM_CONVERSION_DATE = l_sorted_table(i).FROM_CONVERSION_DATE
           AND TO_CONVERSION_DATE = l_sorted_table(i).TO_CONVERSION_DATE
           AND USER_CONVERSION_TYPE = l_sorted_table(i).USER_CONVERSION_TYPE
           AND BATCH_NUMBER = p_integration_id;

Line: 224

  SELECT gl_ebi_daily_rates_obj(FROM_CURRENCY,
   TO_CURRENCY,
   FROM_CONVERSION_DATE,
   TO_CONVERSION_DATE,
   USER_CONVERSION_TYPE,
   CONVERSION_RATE,
   MODE_FLAG,
   INVERSE_CONVERSION_RATE,
   USER_ID,
   LAUNCH_RATE_CHANGE,
   ERROR_CODE,
   CONTEXT,
   ATTRIBUTE1,
   ATTRIBUTE2,
   ATTRIBUTE3,
   ATTRIBUTE4,
   ATTRIBUTE5,
   ATTRIBUTE6,
   ATTRIBUTE7,
   ATTRIBUTE8,
   ATTRIBUTE9,
   ATTRIBUTE10,
   ATTRIBUTE11,
   ATTRIBUTE12,
   ATTRIBUTE13,
   ATTRIBUTE14,
   USED_FOR_AB_TRANSLATION,
   ATTRIBUTE15)
  FROM GL_DAILY_RATES_INTERFACE
  WHERE
    BATCH_NUMBER = p_integration_id;

Line: 281

    DELETE FROM gl_daily_rates_interface WHERE batch_number = p_integration_id;

Line: 311

SELECT  responsibility_id
FROM fnd_responsibility_vl
WHERE (responsibility_name = trim(cp_resp_name));