APPS.MSD_DEM_TIME_DATA SQL Statements

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

Line: 9

   select distinct
    week_start_date sd,
    week_end_date ed,
    week,
    week_description,
    month,
    month_description,
    calendar_code,
    month_start_date,
    month_end_date,
    instance
    from msd_dem_time
    where calendar_type = 2
      and calendar_code = nvl(p_cal_code, calendar_code);

Line: 34

    insert into msd_dem_time(INSTANCE, CALENDAR_TYPE, CALENDAR_CODE,
                         LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
                         CREATED_BY, LAST_UPDATE_LOGIN,
                         MONTH, MONTH_DESCRIPTION,
                         MONTH_START_DATE, MONTH_END_DATE,
                         WEEK, WEEK_DESCRIPTION,
                         WEEK_START_DATE, WEEK_END_DATE,
                         DAY, DAY_DESCRIPTION)
    select week.instance, 2, week.calendar_code,
           sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.user_id,
           week.month, week.month_description,
           week.month_start_date, week.month_end_date,
           week.week, week.week_description,
           week.sd, week.ed,
           day, to_char(day)
    from
    (
      select week.sd+rownum-1 day
       from msd_dem_time
       where rownum < week.ed-week.sd+2
     MINUS
     select day
     from msd_dem_time
     where calendar_type = 2
       and calendar_code = week.calendar_code
       and week_start_date = week.sd
       and week_end_date = week.ed
    );

Line: 80

select mai.instance_id instance, mdc.calendar_type calendar_type, mdc.calendar_code calendar_code
from msd_dem_calendars mdc,
		 msc_apps_instances mai
where mdc.instance = mai.instance_code;

Line: 86

select
	SR_INSTANCE_ID,
	calendar_code,
	YEAR,
	YEAR_START_DATE,
	YEAR_END_DATE,
	QUARTER,
	QUARTER_START_DATE,
	QUARTER_END_DATE,
	MONTH,
	MONTH_START_DATE,
	MONTH_END_DATE
from 	msc_calendar_months
where 	sr_instance_id = p_instance_id
and   	calendar_code = p_calendar_code;

Line: 103

select msd_dem_common_utilities.dm_time_level
from dual;

Line: 126

		msd_dem_common_utilities.log_message('Calendars Download Not Selected');

Line: 127

		msd_dem_common_utilities.log_debug('Calendars Download Not Selected');

Line: 169

	     				insert into msd_dem_time(instance,
                        							 calendar_type,
                        							 calendar_code,
                        							 YEAR,
                                       YEAR_DESCRIPTION,
                                       YEAR_START_DATE,
                                       YEAR_END_DATE,
                                       QUARTER,
                                       QUARTER_DESCRIPTION,
                                       QUARTER_START_DATE,
                                       QUARTER_END_DATE,
                                       MONTH,
                                       MONTH_DESCRIPTION,
                                       MONTH_START_DATE,
                                       MONTH_END_DATE,
                                       DAY,
                                       DAY_DESCRIPTION,
                                       LAST_UPDATE_DATE,
                                       last_updated_by,
                                       creation_date,
                                       created_by,
                                       LAST_UPDATE_LOGIN )
            			values (l_fiscal_cal_data.sr_instance_id,
                        3,
                        l_fiscal_cal_data.calendar_code,
/* Bug# 5859307
                        l_fiscal_cal_data.YEAR,
*/                      to_char(l_fiscal_cal_data.YEAR_START_DATE, 'YYYY/MM/DD'),
                        l_fiscal_cal_data.YEAR,
                        l_fiscal_cal_data.YEAR_START_DATE,
                        l_fiscal_cal_data.YEAR_END_DATE,
/* Bug# 5859307
                        l_fiscal_cal_data.QUARTER,
*/                      to_char(l_fiscal_cal_data.QUARTER_START_DATE, 'YYYY/MM/DD'),
                        l_fiscal_cal_data.QUARTER,
                        l_fiscal_cal_data.QUARTER_START_DATE,
                        l_fiscal_cal_data.QUARTER_END_DATE,
/* Bug# 5859307
                        l_fiscal_cal_data.MONTH,
*/                      to_char(l_fiscal_cal_data.MONTH_START_DATE, 'YYYY/MM/DD'),
                        l_fiscal_cal_data.MONTH,
                        l_fiscal_cal_data.MONTH_START_DATE,
                        l_fiscal_cal_data.MONTH_END_DATE,
			                  l_fiscal_cal_data.MONTH_START_DATE + v_num_of_days,
			                  l_fiscal_cal_data.MONTH_START_DATE + v_num_of_days,
			                  sysdate,
			                  FND_GLOBAL.USER_ID ,
			                  sysdate,
			                  FND_GLOBAL.USER_ID ,
			                  FND_GLOBAL.USER_ID
		 								) ;

Line: 226

	      	insert into msd_dem_time(instance,
                        							 calendar_type,
                        							 calendar_code,
                        							 YEAR,
                                       YEAR_DESCRIPTION,
                                       YEAR_START_DATE,
                                       YEAR_END_DATE,
                                       QUARTER,
                                       QUARTER_DESCRIPTION,
                                       QUARTER_START_DATE,
                                       QUARTER_END_DATE,
                                       MONTH,
                                       MONTH_DESCRIPTION,
                                       MONTH_START_DATE,
                                       MONTH_END_DATE,
                                       LAST_UPDATE_DATE,
                                       last_updated_by,
                                       creation_date,
                                       created_by,
                                       LAST_UPDATE_LOGIN )
            			values (l_fiscal_cal_data.sr_instance_id,
                        3,
                        l_fiscal_cal_data.calendar_code,
/* Bug# 5859307
                        l_fiscal_cal_data.YEAR,
*/                      to_char(l_fiscal_cal_data.YEAR_START_DATE, 'YYYY/MM/DD'),
                        l_fiscal_cal_data.YEAR,
                        l_fiscal_cal_data.YEAR_START_DATE,
                        l_fiscal_cal_data.YEAR_END_DATE,
/* Bug# 5859307
                        l_fiscal_cal_data.QUARTER,
*/                      to_char(l_fiscal_cal_data.QUARTER_START_DATE, 'YYYY/MM/DD'),
                        l_fiscal_cal_data.QUARTER,
                        l_fiscal_cal_data.QUARTER_START_DATE,
                        l_fiscal_cal_data.QUARTER_END_DATE,
/* Bug# 5859307
                        l_fiscal_cal_data.MONTH,
*/                      to_char(l_fiscal_cal_data.MONTH_START_DATE, 'YYYY/MM/DD'),
                        l_fiscal_cal_data.MONTH,
                        l_fiscal_cal_data.MONTH_START_DATE,
                        l_fiscal_cal_data.MONTH_END_DATE,
			                  sysdate,
			                  FND_GLOBAL.USER_ID ,
			                  sysdate,
			                  FND_GLOBAL.USER_ID ,
			                  FND_GLOBAL.USER_ID
		 								) ;