APPS.BIL_BI_PURGE_OBJ_PKG SQL Statements

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

Line: 79

         BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );

Line: 91

        BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );

Line: 106

        BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');

Line: 108

        BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');

Line: 116

        BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'OPDTL_F');

Line: 125

        BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');

Line: 136

        BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');

Line: 138

        BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');

Line: 317

      SELECT COUNT(1)
    INTO l_cnt
        FROM bil_bi_opdtl_stg;

Line: 322

     DELETE FROM bil_bi_opdtl_stg
    WHERE opty_creation_date <= g_end_date
      AND effective_date <= g_end_date
      AND (opty_ld_conversion_date <= g_end_date
          OR opty_ld_conversion_date IS NULL)
      AND close_date <= g_end_date; -- added asolaiy after forecast date changes.

Line: 333

                p_msg => ' Opdtl Stg Tbl records Deleted :'||SQL%ROWCOUNT);

Line: 339

   DELETE FROM bil_bi_opdtl_f
  WHERE opty_creation_time_id <= g_end_date_timeid
    AND opty_close_time_id <= g_end_date_timeid
    AND (opty_ld_conversion_time_id <= g_end_date_timeid
        OR opty_ld_conversion_time_id IS NULL)
    AND opty_effective_time_id <= g_end_date_timeid; -- added asolaiy for forecast date changes.

Line: 349

                p_msg => ' Opdtl_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);

Line: 426

    SELECT COUNT(1)
    INTO l_cnt
    FROM bil_bi_pipeline_stg;

Line: 431

      DELETE FROM bil_bi_pipeline_stg
      WHERE snap_date <= g_end_date;

Line: 438

        p_msg => ' Pipeline Stg Tbl records Deleted :'||SQL%ROWCOUNT);

Line: 443

    DELETE FROM bil_bi_pipeline_f
    WHERE snap_date <= g_end_date;

Line: 450

        p_msg => ' Pipeline_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);

Line: 456

    DELETE FROM bil_bi_pipec_f
    WHERE snap_date <= g_end_date;

Line: 463

        p_msg => ' Pipec_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);

Line: 605

      SELECT ent_year_id
        INTO l_end_dt_ent_year_id
        FROM fii_time_ent_year
        WHERE start_date <= g_end_date
             AND end_date >= g_end_date;

Line: 611

           DELETE bil_bi_fst_dtl_f sumry
            WHERE forecast_time_id <= l_end_dt_ent_year_id
              AND forecast_period_type_id = 128;

Line: 616

      SELECT ent_qtr_id
          INTO l_end_dt_ent_qtr_id
          FROM fii_time_ent_qtr
        WHERE start_date <= g_end_date
             AND end_date >= g_end_date;

Line: 622

           DELETE bil_bi_fst_dtl_f sumry
            WHERE forecast_time_id <= l_end_dt_ent_qtr_id
              AND forecast_period_type_id = 64;

Line: 628

      SELECT ent_period_id
          INTO l_end_dt_ent_per_id
          FROM fii_time_ent_period
        WHERE start_date <= g_end_date
            AND end_date >= g_end_date;

Line: 634

           DELETE bil_bi_fst_dtl_f sumry
            WHERE  forecast_time_id <= l_end_dt_ent_per_id
              AND forecast_period_type_id = 32;

Line: 639

      SELECT week_id
          INTO l_end_dt_week_id
          FROM fii_time_week
        WHERE start_date <= g_end_date
            AND end_date >= g_end_date;

Line: 645

           DELETE bil_bi_fst_dtl_f sumry
            WHERE  forecast_time_id <= l_end_dt_week_id
              AND forecast_period_type_id = 16;

Line: 653

    SELECT ent_year_id
      INTO l_end_dt_ent_year_id
        FROM fii_time_ent_year
     WHERE start_date <= g_end_date
       AND end_date >= g_end_date;

Line: 659

    SELECT ent_qtr_id
      INTO l_end_dt_ent_qtr_id
      FROM fii_time_ent_qtr
     WHERE start_date <= g_end_date
       AND end_date >= g_end_date;

Line: 665

    SELECT ent_period_id
      INTO l_end_dt_ent_per_id
      FROM fii_time_ent_period
     WHERE start_date <= g_end_date
       AND end_date >= g_end_date;

Line: 671

    SELECT week_id
      INTO l_end_dt_week_id
      FROM fii_time_week
     WHERE start_date <= g_end_date
       AND end_date >= g_end_date;

Line: 690

        DELETE bil_bi_fst_dtl_f sumry
         WHERE  ((forecast_time_id <= l_end_dt_week_id
                  AND forecast_period_type_id = 16)
            OR  (forecast_time_id <= l_end_dt_ent_per_id
                 AND forecast_period_type_id = 32)
        OR  (forecast_time_id <= l_end_dt_ent_qtr_id
                 AND forecast_period_type_id = 64)
            OR  (forecast_time_id <= l_end_dt_ent_year_id
                AND forecast_period_type_id = 128));

Line: 700

        l_stmt := ' Summary Tbl records Eff Dt < End Dt Deleted';

Line: 725

  DELETE FROM bil_bi_processed_fst_id
  WHERE forecast_id in ( SELECT intrnl.forecast_id f
                         FROM as_internal_forecasts intrnl,
                    gl_periods gl
               WHERE gl.period_name = intrnl.period_name
               AND gl.period_set_name = l_val(3)
                 AND gl.end_date <= g_end_date
             );

Line: 733

      l_stmt := ' Rows deleted from processed_fst_id table ';

Line: 814

    BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name || '_PURGE');