APPS.QPR_COLLECT_TIME_DATA dependencies on FND_DATE

Line 296: r_time_data.YEAR_STDT(l_rec_ctr) := fnd_date.string_to_date(

292: s_year := to_char(date_ref,'YYYY', NLS_DATE_LANG);
293: r_time_data.CALENDAR_CODE(l_rec_ctr) := 'Gregorian';
294: r_time_data.YEAR(l_rec_ctr) := s_year;
295: r_time_data.YEAR_DESC(l_rec_ctr) := s_year;
296: r_time_data.YEAR_STDT(l_rec_ctr) := fnd_date.string_to_date(
297: '01-JAN-'|| s_year,GREG_CAL_DATE_FMT);
298: r_time_data.YEAR_ENDT(l_rec_ctr) := fnd_date.string_to_date(
299: '31-DEC-'||s_year,GREG_CAL_DATE_FMT);
300:

Line 298: r_time_data.YEAR_ENDT(l_rec_ctr) := fnd_date.string_to_date(

294: r_time_data.YEAR(l_rec_ctr) := s_year;
295: r_time_data.YEAR_DESC(l_rec_ctr) := s_year;
296: r_time_data.YEAR_STDT(l_rec_ctr) := fnd_date.string_to_date(
297: '01-JAN-'|| s_year,GREG_CAL_DATE_FMT);
298: r_time_data.YEAR_ENDT(l_rec_ctr) := fnd_date.string_to_date(
299: '31-DEC-'||s_year,GREG_CAL_DATE_FMT);
300:
301: s_month := to_char(date_ref,'MM', NLS_DATE_LANG);
302: decode_quarter(s_month,s_year, s_qtr, s_stdt, s_etdt);

Line 305: r_time_data.QUARTER_STDT(l_rec_ctr) := fnd_date.string_to_date(s_stdt,

301: s_month := to_char(date_ref,'MM', NLS_DATE_LANG);
302: decode_quarter(s_month,s_year, s_qtr, s_stdt, s_etdt);
303: r_time_data.QUARTER(l_rec_ctr) := s_qtr;
304: r_time_data.QUARTER_DESC(l_rec_ctr) := s_qtr;
305: r_time_data.QUARTER_STDT(l_rec_ctr) := fnd_date.string_to_date(s_stdt,
306: GREG_CAL_DATE_FMT);
307: r_time_data.QUARTER_ENDT(l_rec_ctr) := fnd_date.string_to_date(s_etdt,
308: GREG_CAL_DATE_FMT);
309:

Line 307: r_time_data.QUARTER_ENDT(l_rec_ctr) := fnd_date.string_to_date(s_etdt,

303: r_time_data.QUARTER(l_rec_ctr) := s_qtr;
304: r_time_data.QUARTER_DESC(l_rec_ctr) := s_qtr;
305: r_time_data.QUARTER_STDT(l_rec_ctr) := fnd_date.string_to_date(s_stdt,
306: GREG_CAL_DATE_FMT);
307: r_time_data.QUARTER_ENDT(l_rec_ctr) := fnd_date.string_to_date(s_etdt,
308: GREG_CAL_DATE_FMT);
309:
310: s_mon_name := to_char(date_ref,'MON', NLS_DATE_LANG) || ' ' || s_year;
311: decode_month(s_month, s_year, s_stdt, s_etdt);

Line 314: r_time_data.MONTH_STDT(l_rec_ctr) := fnd_date.string_to_date(s_stdt,

310: s_mon_name := to_char(date_ref,'MON', NLS_DATE_LANG) || ' ' || s_year;
311: decode_month(s_month, s_year, s_stdt, s_etdt);
312: r_time_data.MONTH(l_rec_ctr) := s_mon_name;
313: r_time_data.MONTH_DESC(l_rec_ctr) := s_mon_name;
314: r_time_data.MONTH_STDT(l_rec_ctr) := fnd_date.string_to_date(s_stdt,
315: GREG_CAL_DATE_FMT);
316: r_time_data.MONTH_ENDT(l_rec_ctr) := fnd_date.string_to_date(s_etdt,
317: GREG_CAL_DATE_FMT);
318:

Line 316: r_time_data.MONTH_ENDT(l_rec_ctr) := fnd_date.string_to_date(s_etdt,

312: r_time_data.MONTH(l_rec_ctr) := s_mon_name;
313: r_time_data.MONTH_DESC(l_rec_ctr) := s_mon_name;
314: r_time_data.MONTH_STDT(l_rec_ctr) := fnd_date.string_to_date(s_stdt,
315: GREG_CAL_DATE_FMT);
316: r_time_data.MONTH_ENDT(l_rec_ctr) := fnd_date.string_to_date(s_etdt,
317: GREG_CAL_DATE_FMT);
318:
319: r_time_data.DAY(l_rec_ctr) := date_ref;
320: r_time_data.DAY_DESC(l_rec_ctr) := to_char(date_ref, GREG_CAL_DATE_FMT,

Line 354: date_from := FND_DATE.canonical_to_date(p_date_from);

350: fnd_profile.get('CONC_REQUEST_ID', request_id);
351:
352: -- Note: the date inputs are mandatory if not null condition needs to be
353: -- handled
354: date_from := FND_DATE.canonical_to_date(p_date_from);
355: date_to := FND_DATE.canonical_to_date(p_date_to);
356:
357:
358: if p_calendar_type = GREGORIAN_CALENDAR then

Line 355: date_to := FND_DATE.canonical_to_date(p_date_to);

351:
352: -- Note: the date inputs are mandatory if not null condition needs to be
353: -- handled
354: date_from := FND_DATE.canonical_to_date(p_date_from);
355: date_to := FND_DATE.canonical_to_date(p_date_to);
356:
357:
358: if p_calendar_type = GREGORIAN_CALENDAR then
359: delete QPR_TIME