eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_CEFPURGE_XMLP_PKG SQL Statements

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

Line: 12


        SELECT
          NAME
        INTO
          C_TEMP_NAME
        FROM
          CE_FORECAST_HEADERS
        WHERE FORECAST_HEADER_ID = P_FORECAST_HEADER_ID;

Line: 32


        SELECT
          count(*)
        INTO
          C_COUNT
        FROM
          CE_FORECASTS
        WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
           ,FORECAST_HEADER_ID)
          AND START_DATE is not null
          AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1
           ,TRUNC(START_DATE))
          AND TRUNC(START_DATE) <= NVL(P_FORECAST_END_DATE_1
           ,TRUNC(START_DATE));

Line: 47


        SELECT
          count(*) + NVL(C_COUNT
             ,0)
        INTO
          C_COUNT
        FROM
          CE_FORECASTS CF
        WHERE CF.FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
           ,CF.FORECAST_HEADER_ID)
          AND START_PERIOD in (
          SELECT
            GLP.PERIOD_NAME
          FROM
            GL_PERIODS GLP
          WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
            AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
             ,TRUNC(GLP.START_DATE))
            AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1
             ,TRUNC(GLP.START_DATE)) );

Line: 78


        DELETE FROM CE_FORECAST_CELLS
         WHERE FORECAST_ID in (
           SELECT
             FORECAST_ID
           FROM
             CE_FORECASTS
           WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
              ,FORECAST_HEADER_ID)
             AND START_DATE is not null
             AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1
              ,TRUNC(START_DATE))
             AND TRUNC(START_DATE) <= NVL(P_FORECAST_END_DATE_1
              ,TRUNC(START_DATE)) );

Line: 91


        DELETE FROM CE_FORECAST_TRX_CELLS
         WHERE FORECAST_ID in (
           SELECT
             FORECAST_ID
           FROM
             CE_FORECASTS
           WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
              ,FORECAST_HEADER_ID)
             AND START_DATE is not null
             AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1
              ,TRUNC(START_DATE))
             AND TRUNC(START_DATE) <= NVL(P_FORECAST_END_DATE_1
              ,TRUNC(START_DATE)) );

Line: 104


        DELETE FROM CE_FORECAST_OPENING_BAL
         WHERE FORECAST_ID in (
           SELECT
             FORECAST_ID
           FROM
             CE_FORECASTS
           WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
              ,FORECAST_HEADER_ID)
             AND START_DATE is not null
             AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1
              ,TRUNC(START_DATE))
             AND TRUNC(START_DATE) <= NVL(P_FORECAST_END_DATE_1
              ,TRUNC(START_DATE)) );

Line: 117


        DELETE FROM CE_FORECAST_ERRORS
         WHERE FORECAST_ID in (
           SELECT
             FORECAST_ID
           FROM
             CE_FORECASTS
           WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
              ,FORECAST_HEADER_ID)
             AND START_DATE is not null
             AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1
              ,TRUNC(START_DATE))
             AND TRUNC(START_DATE) <= NVL(P_FORECAST_END_DATE_1
              ,TRUNC(START_DATE)) );

Line: 130


        DELETE FROM CE_FORECASTS
         WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
            ,FORECAST_HEADER_ID)
           AND START_DATE is not null
           AND TRUNC(START_DATE) >= NVL(P_FORECAST_START_DATE_1
            ,TRUNC(START_DATE))
           AND TRUNC(START_DATE) <= NVL(P_FORECAST_END_DATE_1
            ,TRUNC(START_DATE));

Line: 140


        DELETE FROM CE_FORECAST_CELLS
         WHERE FORECAST_ID in (
           SELECT
             FORECAST_ID
           FROM
             CE_FORECASTS CF
           WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
              ,FORECAST_HEADER_ID)
             AND START_PERIOD in (
             SELECT
               GLP.PERIOD_NAME
             FROM
               GL_PERIODS GLP
             WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
               AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
                ,TRUNC(GLP.START_DATE))
               AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1
                ,TRUNC(GLP.START_DATE)) ) );

Line: 158


        DELETE FROM CE_FORECAST_TRX_CELLS
         WHERE FORECAST_ID in (
           SELECT
             FORECAST_ID
           FROM
             CE_FORECASTS CF
           WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
              ,FORECAST_HEADER_ID)
             AND START_PERIOD in (
             SELECT
               GLP.PERIOD_NAME
             FROM
               GL_PERIODS GLP
             WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
               AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
                ,TRUNC(GLP.START_DATE))
               AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1
                ,TRUNC(GLP.START_DATE)) ) );

Line: 176


        DELETE FROM CE_FORECAST_OPENING_BAL
         WHERE FORECAST_ID in (
           SELECT
             FORECAST_ID
           FROM
             CE_FORECASTS CF
           WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
              ,FORECAST_HEADER_ID)
             AND START_PERIOD in (
             SELECT
               GLP.PERIOD_NAME
             FROM
               GL_PERIODS GLP
             WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
               AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
                ,TRUNC(GLP.START_DATE))
               AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1
                ,TRUNC(GLP.START_DATE)) ) );

Line: 194


        DELETE FROM CE_FORECAST_ERRORS
         WHERE FORECAST_ID in (
           SELECT
             FORECAST_ID
           FROM
             CE_FORECASTS CF
           WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
              ,FORECAST_HEADER_ID)
             AND START_PERIOD in (
             SELECT
               GLP.PERIOD_NAME
             FROM
               GL_PERIODS GLP
             WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
               AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
                ,TRUNC(GLP.START_DATE))
               AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1
                ,TRUNC(GLP.START_DATE)) ) );

Line: 212


        DELETE FROM CE_FORECASTS CF
         WHERE FORECAST_HEADER_ID = NVL(P_FORECAST_HEADER_ID
            ,FORECAST_HEADER_ID)
           AND START_PERIOD in (
           SELECT
             GLP.PERIOD_NAME
           FROM
             GL_PERIODS GLP
           WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
             AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
              ,TRUNC(GLP.START_DATE))
             AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1
              ,TRUNC(GLP.START_DATE)) );