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.FII_POPULATE_TIME SQL Statements

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

Line: 4


PROCEDURE PUSH(Errbuf out NOCOPY varchar2, retcode out NOCOPY Varchar2, rows_inserted out NOCOPY number,
		p_from_date in date,
		p_to_date in date) IS

-- ---------------------------------------------------------
-- Define local variables
-- ---------------------------------------------------------
   l_instance		Varchar2(40);

Line: 100


   Select substrb(edw_instance.get_code,1,40)
   into l_instance
   from dual;

Line: 108


   rows_inserted:=0;

Line: 248


     insert into edw_time_day_lstg
     (day_pk,
	  half_month_fk,
	  week_fk,
	  day,
	  name,
	  julian_day,
	  day_of_week,
	  day_of_year,
      start_date,
      end_date,
	  weekend_flag,
	  timespan,
      instance,
	  collection_status)
     values(
      -- day_pk
	  to_char(l_days_running_date,'dd-mm-yyyy'),
	  -- half month fk
	  to_char(l_days_half_month_start_date,'dd-mm-yyyy'),
	  -- week fk
	  to_char(l_days_week_start_date, 'dd-mm-yyyy'),
	  -- day
	  to_char(l_days_running_date,'dd-MON-yyyy'),
	  -- name
	  to_char(l_days_running_date,'fmdd Month yyyy'),
	  -- julian day
	  to_number(to_char(l_days_running_date,'J')),
	  -- day of week
	  to_char(l_days_running_date,'fmDay'),
	  -- day of year
	  to_char(l_days_running_date,'fmddd'),
      -- start date
	  l_days_running_date,
	  -- end date
	  l_days_running_date,
	  -- weekend flag
	  decode(upper(to_char(l_days_running_date,'fmDay')),'SATURDAY','Y','SUNDAY','Y','N'),
	  -- timespan
	  1,
      -- instance
      l_instance,
      'READY');

Line: 293


     insert into edw_time_cal_day_lstg
     (cal_day_pk,
      day_fk,
      fa_period_fk,
      pa_period_fk,
      cal_period_fk,
      ep_cal_period_fk,
      cal_day,
      name,
      calendar_date,
      end_date,
      timespan,
      instance,
      collection_status)
     values(
      -- cal_day_pk
      to_char(l_days_running_date,'dd-mm-yyyy')||'-DAY',
      -- day fk
      to_char(l_days_running_date,'dd-mm-yyyy'),
      -- fa_period fk , pa_period_fk, cal_period_fk
      'NA_EDW', 'NA_EDW', 'NA_EDW',
      -- ep_cal_period_fk
      'oracle_source',
      -- day
      l_days_running_date,
      -- name ( Added the level prefix name in the begin as per the standard #1964070)
      'DAY-'||to_char(l_days_running_date,'fmdd Month yyyy'),
      -- calendar date
      l_days_running_date,
      -- end date
      l_days_running_date,
      -- timespan
      1,
      -- instance
      l_instance,
      'READY');

Line: 368


     insert into edw_time_month_lstg
     (month_pk,
	  qtr_fk,
	  month,
      name,
	  start_date,
	  end_date,
	  timespan,
      instance,
	  collection_status)
	 values(
	  -- month_pk
	  to_char(l_mon_month_start_date, 'dd-mm-yyyy'),
   	  -- qtr fk
  	  to_char(l_mon_quarter_date,'dd-mm-yyyy'),
	  -- month
	  to_char(l_mon_month_start_date,'MM')||','||to_char(l_mon_month_start_date,'YYYY'),
	  -- name
      to_char(l_mon_month_start_date,'fmMonth yyyy'),
	  -- month_start_date
	  l_mon_month_start_date,
	  -- month_end_date
	  last_day(l_mon_month_start_date),
	  -- month_time_span
	  last_day(l_mon_month_start_date)-l_mon_month_start_date + 1,
      -- instance
      l_instance,
	  'READY');

Line: 398


     insert into edw_time_half_month_lstg
     (half_month_pk,
      month_fk,
      half_month,
      name,
      start_date,
      end_date,
      timespan,
      instance,
      collection_status)
     values(
      -- half_month_pk
      to_char(l_mon_month_start_date, 'dd-mm-yyyy')||'-MON',
      -- month fk
      to_char(l_mon_month_start_date,'dd-mm-yyyy'),
      -- half_month
      to_char(l_mon_month_start_date,'MM')||','||to_char(l_mon_month_start_date,'YYYY'),
      -- name ( Added the level prefix name in the begin as per the standard #1964070)
      'MNTH-'||to_char(l_mon_month_start_date,'fmMonth yyyy'),
      -- month_start_date
      l_mon_month_start_date,
      -- month_end_date
      last_day(l_mon_month_start_date),
      -- month_time_span
      last_day(l_mon_month_start_date)-l_mon_month_start_date + 1,
      -- instance
      l_instance,
      'READY');

Line: 427


     insert into edw_time_day_lstg
     (day_pk,
      name,
      half_month_fk,
      week_fk,
      start_date,
      end_date,
      timespan,
      instance,
      collection_status)
     values(
      -- day_pk
      to_char(l_mon_month_start_date, 'dd-mm-yyyy')||'-MON',
      -- name
      to_char(l_mon_month_start_date, 'fmMonth yyyy'),
      -- half_month fk
      to_char(l_mon_month_start_date, 'dd-mm-yyyy')||'-MON',
      -- week_fk
      'NA_EDW',
      -- month_start_date
      l_mon_month_start_date,
      -- month_end_date
      last_day(l_mon_month_start_date),
      -- month_time_span
      last_day(l_mon_month_start_date)-l_mon_month_start_date + 1,
      -- instance
      l_instance,
      'READY');

Line: 456


     insert into edw_time_cal_day_lstg
     (cal_day_pk,
      name,
      fa_period_fk,
	  pa_period_fk,
	  day_fk,
      cal_period_fk,
      ep_cal_period_fk,
      calendar_date,
      end_date,
      timespan,
      instance,
      collection_status)
     values(
      -- calendar_day_pk
      to_char(l_mon_month_start_date, 'dd-mm-yyyy')||'-MNTH',
      -- name ( Added the level prefix name in the begin as per the standard #1964070)
      'DAY-'||to_char(l_mon_month_start_date, 'fmMonth yyyy'),
      -- fa_period_fk
      'NA_EDW',
      -- pa_period_fk,
	  'NA_EDW',
      -- day_fk,
      to_char(l_mon_month_start_date, 'dd-mm-yyyy')||'-MON',
      -- cal_period_fk
      'NA_EDW',
      -- ep_cal_period_fk
      'oracle_source',
      -- month_start_date
      l_mon_month_start_date,
      -- month_end_date
      last_day(l_mon_month_start_date),
      -- month_time_span
      last_day(l_mon_month_start_date)-l_mon_month_start_date + 1,
      -- instance
      l_instance,
      'READY');

Line: 516


     insert into edw_time_qtr_lstg
     (qtr_pk,
      half_year_fk,
      qtr,
      name,
      start_date,
      end_date,
      timespan,
      instance,
      collection_status)
     values(
      -- qtr_pk
      to_char(l_start_date_quarter, 'dd-mm-yyyy'),
      -- half_year_fk
      decode(to_char(l_start_date_quarter, 'Q'),1, to_char(trunc(l_start_date_quarter, 'YYYY'), 'dd-mm-yyyy'), 2, to_char(trunc(l_start_date_quarter, 'YYYY'), 'dd-mm-yyyy'), to_char(add_months(trunc(l_start_date_quarter, 'YYYY'),6), 'dd-mm-yyyy')),
      -- qtr
      l_quarter||' '||to_char(l_start_date_quarter,'Q, yyyy'),
      -- name
      l_quarter||' '||to_char(l_start_date_quarter,'Q, yyyy'),
      -- start_date
      l_start_date_quarter,
      -- end_date
      add_months(l_start_date_quarter, 3)-1,
      -- time_span
      add_months(l_start_date_quarter, 3) - 1 - l_start_date_quarter + 1,
      -- instance
      l_instance,
      'READY');

Line: 564


     insert into edw_time_half_year_lstg
     (half_year_pk,
      year_fk,
      half_year,
      name,
      start_date,
      end_date,
      timespan,
      instance,
      collection_status)
     values(
      -- half_year_pk
      to_char(l_half_year_start_date, 'dd-mm-yyyy'),
      -- year_fk
      to_char(trunc(l_half_year_start_date, 'YYYY'), 'dd-mm-yyyy'),
      -- half_year
      decode(l_half_year_counter,0,l_first_half||' '||to_char(l_half_year_start_date, 'YYYY'),1, l_second_half||' '||to_char(l_half_year_start_date, 'YYYY')),
      -- name
      decode(l_half_year_counter,0,l_first_half||', '||to_char(l_half_year_start_date, 'YYYY'),1, l_second_half||', '||to_char(l_half_year_start_date, 'YYYY')),
      -- start_date
      l_half_year_start_date,
      -- end_date
      add_months(l_half_year_start_date, 6)-1,
      -- time_span
      add_months(l_half_year_start_date, 6) -1 - l_half_year_start_date + 1,
      -- instance
      l_instance,
      'READY');

Line: 617


	 insert into edw_time_year_lstg
     (year_pk,
	  all_fk,
	  year,
	  name,
	  start_date,
	  end_date,
	  timespan,
      instance,
	  collection_status)
	 values(
	  -- year_pk
	  to_char(l_year_year_start_date, 'dd-mm-yyyy'),
	  -- all_fk
	  'ALL',
	  -- year
	  to_char(l_year_year_start_date,'YYYY'),
	  -- name
	  to_char(l_year_year_start_date,'YYYY'),
	  -- year_start_date
	  l_year_year_start_date,
	  -- year_end_date
      last_day(l_year_year_start_date+360),
      -- year_time_span
	  last_day(l_year_year_start_date+360)-l_year_year_start_date + 1,
      -- instance
      l_instance,
      'READY');

Line: 665


     insert into edw_time_week_lstg
     (week_pk,
      name,
	  period_445_fk,
	  week_number,
	  start_date,
	  end_date,
	  timespan,
      instance,
	  collection_status)
	 values(
	  -- week_pk
	  to_char(l_weeks_week_start_date,'dd-mm-yyyy'),
	  -- name
      l_week||' '||to_char(l_weeks_counter)||', '||l_weeks_year,
	  -- period_445_fk
	  to_char(l_weeks_445_date, 'dd-mm-yyyy'),
	  -- week number
	  to_char(l_weeks_counter),
	  -- week_start_date
	  l_weeks_week_start_date,
	  -- week_end_date
	  l_weeks_week_start_date+6,
	  -- week_time_span
	  7,
      -- instance
      l_instance,
      'READY');

Line: 721


     INSERT INTO edw_time_period_445_lstg
     (period_445_pk,
      name,
      all_fk,
      period445_number,
      start_date,
      end_date,
      timespan,
      instance,
      collection_status)
     VALUES(
      to_char(l_445_445_start_date, 'dd-mm-yyyy'),
      l_period||' '||to_char(l_counter)||', '||to_char(l_445_445_start_date,'iyyy'),
      'ALL',
      l_counter,
      l_445_445_start_date,
      l_445_445_end_date,
      l_445_445_end_date-l_445_445_start_date + 1,
      l_instance,
      'READY');

Line: 780


	 insert into edw_time_half_month_lstg
     (half_month_pk,
	  month_fk,
	  half_month,
      name,
	  start_date,
	  end_date,
	  timespan,
      instance,
	  collection_status)
	 values(
	  -- half_month_pk
	  to_char(l_hm_running_date,'dd-mm-yyyy'),
	  -- month_fk
	  to_char(trunc(l_hm_running_date,'mm'),'dd-mm-yyyy'),
	  -- half_month
	  decode(l_hm_counter,0,l_first_half||' '||to_char(l_hm_running_date,'MM-YYYY'),1,l_second_half||' '||to_char(l_hm_running_date,'MM-YYYY')),
	  -- name
      decode(l_hm_counter,0,l_first_half||', '||to_char(l_hm_running_date,'fmMonth YYYY'),1,l_second_half||', '||to_char(l_hm_running_date,'fmMonth YYYY')),
	  -- half month start date
	  l_hm_running_date,
	  -- half_month_end_date
	  decode(l_hm_counter,0,l_hm_running_date+14,last_day(l_hm_running_date)),
	  -- half_month_time_span
	  decode(l_hm_counter,0,l_hm_running_date+14,last_day(l_hm_running_date)) - l_hm_running_date + 1,
      -- instance
      l_instance,
      'READY');

Line: 811


	    insert into edw_time_day_lstg
	    (
            day_pk,
            half_month_fk,
	    week_fk,
            day,
            name,
            start_date,
            end_date,
            timespan,
            collection_status)
            values(
                -- day_pk
            to_char(l_hm_running_date,'dd-mm-yyyy')||'-HMON',
                --half_month_fk
	    to_char(l_hm_running_date,'dd-mm-yyyy'),
	    	--week fk
	    'NA_EDW',
                -- day
            decode(l_hm_counter,0,'FIRST HALF '||to_char(l_hm_running_date,'MM-YYYY'),1,'SECOND HALF '||to_char(l_hm_running_date,'MM-YYYY')),
                -- name
            decode(l_hm_counter,0,'FIRST HALF '||to_char(l_hm_running_date,'MM-YYYY'),1,'SECOND HALF '||to_char(l_hm_running_date,'MM-YYYY')),
                -- half month start date
            l_hm_running_date,
                -- half_month_end_date
            decode(l_hm_counter,0,l_hm_running_date+14,last_day(l_hm_running_date)),
                -- half_month_time_span
            decode(l_hm_counter,0,l_hm_running_date+14,last_day(l_hm_running_date)) -
					l_hm_running_date,
             'READY');*/

Line: 866


rows_inserted:=l_row_cday;