APPS.MSC_PHUB_PKG dependencies on MSC_CALENDAR_DTL

Line 140: insert into msc_calendar_dtl (year_start_date, year_end_date, year_name,

136: l_month_end_date := ADD_MONTHS(to_date(to_char(l_detail_date,'MM') || '/01' || to_char(l_detail_date,'YYYY'), 'mm/dd/yyyy'), 1) - 1;
137: l_month_name := to_char(l_detail_date,'MON');
138: l_month_seq := to_char(l_detail_date,'MM');
139:
140: insert into msc_calendar_dtl (year_start_date, year_end_date, year_name,
141: month_start_date, month_end_date, month_name, month_seq, detail_date,
142: created_by, creation_date, last_update_date, last_updated_by, last_update_login)
143: values (l_year_start_date, l_year_end_date, l_year_name,
144: l_month_start_date, l_month_end_date, l_month_name, l_month_seq, l_detail_date,

Line 156: from msc_calendar_dtl;

152: procedure flush_greg_calendar(p_return_status out nocopy number, p_error_message out nocopy varchar2) is
153: cursor c_get_minmax_dates is
154: select min(detail_date) min_date,
155: max(detail_date) max_date
156: from msc_calendar_dtl;
157: l_min_date date;
158: l_max_date date;
159:
160: cursor c_get_mfg_minmax_dates is

Line 185: println('populating msc_calendar_dtl starts');

181: l_cal_min_date date;
182: l_cal_max_date date;
183:
184: begin
185: println('populating msc_calendar_dtl starts');
186: p_return_status := 1;
187:
188: open c_get_minmax_dates;
189: fetch c_get_minmax_dates into l_min_date, l_max_date;

Line 257: println('populating msc_calendar_dtl ends');

253: end if;
254: end if;
255: end if;
256: commit;
257: println('populating msc_calendar_dtl ends');
258: exception
259: when others then
260: p_return_status := -3;
261: fnd_message.set_name('MSC', 'MSC_HUB_GREG_CAL_ERROR');