APPS.MSD_TRANSLATE_TIME_DATA dependencies on MSD_TIME

Line 86: /* DWK Delete existing data from MSD_TIME before collection */

82: ELSE
83: l_calendar_code := p_calendar_code;
84: END IF;
85:
86: /* DWK Delete existing data from MSD_TIME before collection */
87:
88: if (l_calendar_code is null) then
89: delete from msd_time
90: where calendar_type = p_calendar_type_id;

Line 89: delete from msd_time

85:
86: /* DWK Delete existing data from MSD_TIME before collection */
87:
88: if (l_calendar_code is null) then
89: delete from msd_time
90: where calendar_type = p_calendar_type_id;
91: else
92: delete from msd_time
93: where calendar_code = l_calendar_code

Line 92: delete from msd_time

88: if (l_calendar_code is null) then
89: delete from msd_time
90: where calendar_type = p_calendar_type_id;
91: else
92: delete from msd_time
93: where calendar_code = l_calendar_code
94: and calendar_type = p_calendar_type_id;
95: end if;
96:

Line 352: insert into msd_time (

348: For v_num_of_days in 0..(p_month_end_date - p_month_start_date) LOOP
349:
350: g_seq_num := g_seq_num + 1 ;
351:
352: insert into msd_time (
353: instance,
354: calendar_type,
355: calendar_code,
356: seq_num,

Line 497: insert into msd_time (

493: For v_num_of_days in 0..x_count LOOP
494:
495: v_seq := v_num_of_days + 1 ;
496:
497: insert into msd_time (
498: instance,
499: calendar_type,
500: calendar_code,
501: seq_num,

Line 661: from msd_time

657: calendar_code,
658: month_start_date,
659: month_end_date,
660: instance
661: from msd_time
662: where calendar_type = 2
663: and calendar_code = nvl(p_cal_code, calendar_code);
664:
665: begin

Line 672: insert into msd_time(INSTANCE, CALENDAR_TYPE, CALENDAR_CODE, SEQ_NUM,

668:
669: for week in weeks loop
670:
671: -- insert missing days in this week
672: insert into msd_time(INSTANCE, CALENDAR_TYPE, CALENDAR_CODE, SEQ_NUM,
673: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
674: CREATED_BY, LAST_UPDATE_LOGIN,
675: MONTH, MONTH_DESCRIPTION,
676: MONTH_START_DATE, MONTH_END_DATE,

Line 692: from msd_time

688: 'NO'
689: from
690: (
691: select week.sd+rownum-1 day
692: from msd_time
693: where rownum < week.ed-week.sd+2
694: MINUS
695: select day
696: from msd_time

Line 696: from msd_time

692: from msd_time
693: where rownum < week.ed-week.sd+2
694: MINUS
695: select day
696: from msd_time
697: where calendar_type = 2
698: and calendar_code = week.calendar_code
699: and week_start_date = week.sd
700: and week_end_date = week.ed