APPS.QPR_COLLECT_TIME_DATA dependencies on QPR_TIME

Line 93: insert into QPR_TIME(TIME_ID,INSTANCE_ID,CALENDAR_TYPE, CALENDAR_CODE,

89: procedure insert_time_data(p_instance_id in number,
90: p_cal_type in number) is
91: begin
92: forall i in r_time_data.YEAR.first..r_time_data.YEAR.last
93: insert into QPR_TIME(TIME_ID,INSTANCE_ID,CALENDAR_TYPE, CALENDAR_CODE,
94: YEAR,YEAR_DESCRIPTION,YEAR_START_DATE,
95: YEAR_END_DATE,QUARTER,QUARTER_DESCRIPTION,
96: QUARTER_START_DATE,QUARTER_END_DATE,MONTH,
97: MONTH_DESCRIPTION,MONTH_START_DATE,MONTH_END_DATE, DAY,

Line 101: values(QPR_TIME_S.nextval, p_instance_id, p_cal_type,

97: MONTH_DESCRIPTION,MONTH_START_DATE,MONTH_END_DATE, DAY,
98: DAY_DESCRIPTION,CREATION_DATE, CREATED_BY,
99: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
100: PROGRAM_APPLICATION_ID,PROGRAM_ID,REQUEST_ID)
101: values(QPR_TIME_S.nextval, p_instance_id, p_cal_type,
102: r_time_data.CALENDAR_CODE(i), r_time_data.YEAR(i),
103: r_time_data.YEAR_DESC(i),
104: r_time_data.YEAR_STDT(i),
105: r_time_data.YEAR_ENDT(i),

Line 359: delete QPR_TIME

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
360: where CALENDAR_TYPE = GREGORIAN_CALENDAR
361: and day between date_from and date_to;
362:
363: build_gregorian_cal(date_from, date_to);

Line 387: delete QPR_TIME

383: -- End of modification to handle bug 5920571
384:
385: -- delete the old data from target table.
386: if p_calendar_code is null then
387: delete QPR_TIME
388: where INSTANCE_ID = p_instance_id
389: and CALENDAR_TYPE = FISCAL_CALENDAR
390: and day between date_from and date_to;
391: else

Line 392: delete QPR_TIME

388: where INSTANCE_ID = p_instance_id
389: and CALENDAR_TYPE = FISCAL_CALENDAR
390: and day between date_from and date_to;
391: else
392: delete QPR_TIME
393: where INSTANCE_ID = p_instance_id
394: and CALENDAR_TYPE = FISCAL_CALENDAR
395: and CALENDAR_CODE = p_calendar_code
396: and day between date_from and date_to;