APPS.FII_TIME_STRUCTURE_C SQL Statements

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

Line: 91

PROCEDURE INSERT_ROW(p_report_date    DATE,
                     p_time_id        NUMBER,
                     p_period_type_id NUMBER,
                     p_record_type_id NUMBER,
                     p_xtd_flag       VARCHAR2 ) IS
BEGIN

  INSERT INTO FII_TIME_STRUCTURES
    ( report_date,
      time_id,
      period_type_id,
      record_type_id,
      xtd_flag,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login )
  VALUES
    ( p_report_date,
      p_time_id,
      p_period_type_id,
      p_record_type_id,
      p_xtd_flag,
      sysdate,
      fnd_global.user_id,
      sysdate,
      fnd_global.user_id,
      fnd_global.login_id);

Line: 121

END INSERT_ROW;

Line: 207

      SELECT
        report_date,
        week_start_date,
        week_end_date,
        ent_period_start_date,
        ent_period_end_date,
        ent_qtr_start_date,
        ent_qtr_end_date,
        ent_year_start_date,
        ent_year_end_date,
        report_date_julian day_id,
        week_id,
        ent_period_id,
        ent_qtr_id,
        ent_year_id
      FROM
        fii_time_day
      where report_date <> g_unassigned_day;

Line: 225

/*      SELECT
        d.report_date,
        d.week_start_date,
        d.week_start_date+6 week_end_date,
        m.start_date ent_period_start_date,
        m.end_date ent_period_end_date,
        q.start_date ent_qtr_start_date,
        q.end_date ent_qtr_end_date,
        y.start_date ent_year_start_date,
        y.end_date ent_year_end_date,
        d.report_date_julian day_id,
        d.week_id,
        m.ent_period_id,
        m.ent_qtr_id,
        m.ent_year_id,
        m.next_start_date next_ent_period_start_date,
        m.next_end_date next_ent_period_end_date
      FROM
        fii_time_day d,
        ( select
            start_date
          , end_date
          , ent_period_id
          , ent_qtr_id
          , ent_year_id
          , lead(start_date,1) over(order by start_date) next_start_date
          , lead(end_date,1) over(order by start_date) next_end_date
          from
            fii_time_ent_period
        ) m,
        fii_time_ent_qtr q,
        fii_time_ent_year y
      WHERE
          d.ent_period_id = m.ent_period_id
      AND m.ent_qtr_id    = q.ent_qtr_id
      AND q.ent_year_id   = y.ent_year_id; */

Line: 264

      SELECT max(report_date) max_report_date
      FROM fii_time_day
      where report_date <> g_unassigned_day;

Line: 294

   select
     ent_year_id
   , end_date
   bulk collect into
     l_ent_year_id_tbl
   , l_ent_year_date_tbl
   from fii_time_ent_year
   where end_date < g_unassigned_day;

Line: 1194

            insert_row(l_current_day, l_ent_year_id, l_nested_ent_year,
                       l_year_sum, INCLUDES_XTD(l_year_sum,l_rolling_week));

Line: 1200

            insert_row(l_current_day, l_ent_qtr_id, l_nested_ent_qtr,
                       l_qtr_sum, INCLUDES_XTD(l_qtr_sum,l_rolling_week));

Line: 1206

            insert_row(l_current_day, l_ent_period_id, l_nested_ent_period,
                       l_month_sum, INCLUDES_XTD(l_month_sum,l_rolling_week));

Line: 1212

            insert_row(l_current_day, l_week_id, l_nested_week,
                      l_week_sum, INCLUDES_XTD(l_week_sum,l_rolling_week));

Line: 1218

            insert_row(l_current_day, l_day_id, l_nested_day,
                      l_day_sum, INCLUDES_XTD(l_day_sum,l_rolling_week));

Line: 1289

         insert_row(d.report_date, l_ent_year_id, l_nested_ent_year, l_year_sum, 'Y');

Line: 1294

         insert_row(d.report_date, l_ent_qtr_id, l_nested_ent_qtr, l_qtr_sum, 'Y');

Line: 1299

         insert_row(d.report_date, l_ent_period_id, l_nested_ent_period,
                    l_month_sum, 'Y');

Line: 1305

         insert_row(d.report_date, l_week_id, l_nested_week, l_week_sum, 'Y');

Line: 1310

         insert_row(d.report_date, l_day_id, l_nested_day, l_day_sum, 'Y');

Line: 1325

            insert_row(d.report_date, l_ent_year_id_tbl(y), l_nested_ent_year,
                       l_itd_year, 'Y');