APPS.MSD_DEM_TIME_DATA dependencies on MSD_DEM_TIME

Line 1: PACKAGE BODY MSD_DEM_TIME_DATA AS

1: PACKAGE BODY MSD_DEM_TIME_DATA AS
2: /* $Header: msddemcalb.pls 120.2.12000000.2 2007/09/25 06:07:13 syenamar noship $ $ */
3:
4: Procedure msd_dem_fix_manufacturing(
5: p_cal_code in varchar2) is

Line 20: from msd_dem_time

16: calendar_code,
17: month_start_date,
18: month_end_date,
19: instance
20: from msd_dem_time
21: where calendar_type = 2
22: and calendar_code = nvl(p_cal_code, calendar_code);
23:
24: begin

Line 34: insert into msd_dem_time(INSTANCE, CALENDAR_TYPE, CALENDAR_CODE,

30:
31: for week in weeks loop
32:
33: -- insert missing days in this week
34: insert into msd_dem_time(INSTANCE, CALENDAR_TYPE, CALENDAR_CODE,
35: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
36: CREATED_BY, LAST_UPDATE_LOGIN,
37: MONTH, MONTH_DESCRIPTION,
38: MONTH_START_DATE, MONTH_END_DATE,

Line 52: from msd_dem_time

48: day, to_char(day)
49: from
50: (
51: select week.sd+rownum-1 day
52: from msd_dem_time
53: where rownum < week.ed-week.sd+2
54: MINUS
55: select day
56: from msd_dem_time

Line 56: from msd_dem_time

52: from msd_dem_time
53: where rownum < week.ed-week.sd+2
54: MINUS
55: select day
56: from msd_dem_time
57: where calendar_type = 2
58: and calendar_code = week.calendar_code
59: and week_start_date = week.sd
60: and week_end_date = week.ed

Line 145: l_stmt := 'truncate table '|| g_msd_schema_name||'.msd_dem_time';

141: EXECUTE IMMEDIATE x_sql USING OUT g_msd_schema_name;
142:
143: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
144:
145: l_stmt := 'truncate table '|| g_msd_schema_name||'.msd_dem_time';
146:
147: msd_dem_common_utilities.log_debug(l_stmt);
148: execute immediate l_stmt ;
149:

Line 169: insert into msd_dem_time(instance,

165:
166: For v_num_of_days in 0..(l_fiscal_cal_data.month_end_date - l_fiscal_cal_data.month_start_date)
167: loop
168:
169: insert into msd_dem_time(instance,
170: calendar_type,
171: calendar_code,
172: YEAR,
173: YEAR_DESCRIPTION,

Line 226: insert into msd_dem_time(instance,

222: end loop ;
223:
224: else
225:
226: insert into msd_dem_time(instance,
227: calendar_type,
228: calendar_code,
229: YEAR,
230: YEAR_DESCRIPTION,

Line 332: END MSD_DEM_TIME_DATA;

328: retcode := -1 ;
329:
330: end collect_time_data;
331:
332: END MSD_DEM_TIME_DATA;
333: