[Home] [Help]
2729: truncate_table('HRI_TIME_CAL_PERIOD');
2730: truncate_table('HRI_TIME_CAL_QTR');
2731: truncate_table('HRI_TIME_CAL_YEAR');
2732: truncate_table('HRI_TIME_RPT_STRUCT');
2733: truncate_table('HRI_TIME_CAL_RPT_STRUCT');
2734: truncate_table('HRI_TIME_STRUCTURES');
2735: truncate_table('HRI_TIME_ROLLING_OFFSETS');
2736: else
2737: -- if it is incremental loading, check if there is any modified period
3120: truncate_table('HRI_TIME_CAL_PERIOD');
3121: truncate_table('HRI_TIME_CAL_QTR');
3122: truncate_table('HRI_TIME_CAL_YEAR');
3123: truncate_table('HRI_TIME_RPT_STRUCT');
3124: truncate_table('HRI_TIME_CAL_RPT_STRUCT');
3125:
3126: if g_debug_flag = 'Y' then
3127: HRI_util.put_line(' ');
3128: end if;
3749:
3750: --Bug 3543939. Get the minimum from date and maximum to date
3751: SELECT nvl(least(min(report_date),l_from_date),l_from_date),nvl(greatest(max(report_date),l_to_date),l_to_date)
3752: INTO l_min_date,l_max_date
3753: from HRI_TIME_CAL_RPT_STRUCT;
3754:
3755: --Bug 3543939. The Calendar id's to be picked from the temporary table populated in Load_Cal_Period
3756:
3757: For cur_Fiscal_Calendar IN (
3768: BEGIN
3769:
3770: SELECT 'T'
3771: INTO l_full_extraction_flag
3772: FROM HRI_TIME_CAL_RPT_STRUCT
3773: WHERE REPORT_DATE >= p_from_date
3774: AND CALENDAR_ID = cur_Fiscal_Calendar.CALENDAR_ID
3775: AND ROWNUM <= 1;
3776: EXCEPTION
3784: -- Delete all records for the calendar
3785: -- and reset the from and to date for
3786: -- extraction
3787:
3788: DELETE HRI_TIME_CAL_RPT_STRUCT
3789: WHERE CALENDAR_ID = cur_Fiscal_Calendar.CALENDAR_ID;
3790: l_from_date := l_min_date;
3791: l_to_date := l_max_date;
3792:
3801: FROM HRI_time_cal_day_mv
3802: WHERE calendar_id = cur_Fiscal_Calendar.calendar_id
3803: AND report_date BETWEEN l_from_date AND l_to_date) LOOP
3804:
3805: INSERT INTO HRI_TIME_CAL_RPT_STRUCT
3806: ( calendar_id
3807: , calendar_type
3808: , report_date
3809: , time_id
3854: AND start_date < l_Week_Start_Date;
3855:
3856: WHILE l_Day >= cur_Fiscal_Days.period_start_date LOOP
3857: IF l_Day >= l_Week_Start_Date THEN
3858: INSERT INTO HRI_TIME_CAL_RPT_STRUCT
3859: ( calendar_id
3860: , calendar_type
3861: , report_date
3862: , time_id
3882:
3883: l_Row := l_Row + SQL%ROWCOUNT;
3884:
3885: ELSIF l_Day >= cur_Fiscal_Days.period_start_date AND l_Day < l_Earliest_Week THEN
3886: INSERT INTO HRI_TIME_CAL_RPT_STRUCT
3887: ( calendar_id
3888: , calendar_type
3889: , report_date
3890: , time_id
3916: END LOOP;
3917:
3918: COMMIT;
3919:
3920: INSERT INTO HRI_TIME_CAL_RPT_STRUCT
3921: ( calendar_id
3922: , calendar_type
3923: , report_date
3924: , time_id
3949:
3950: COMMIT;
3951:
3952: ELSE
3953: INSERT INTO HRI_TIME_CAL_RPT_STRUCT
3954: ( calendar_id
3955: , calendar_type
3956: , report_date
3957: , time_id
3982:
3983: COMMIT;
3984: END IF;
3985:
3986: INSERT INTO HRI_TIME_CAL_RPT_STRUCT
3987: ( calendar_id
3988: , calendar_type
3989: , report_date
3990: , time_id
4034: l_Row := l_Row + SQL%ROWCOUNT;
4035:
4036: COMMIT;
4037:
4038: INSERT INTO HRI_TIME_CAL_RPT_STRUCT
4039: ( calendar_id
4040: , calendar_type
4041: , report_date
4042: , time_id
4086: l_Row := l_Row + SQL%ROWCOUNT;
4087:
4088: COMMIT;
4089:
4090: INSERT INTO HRI_TIME_CAL_RPT_STRUCT
4091: ( calendar_id
4092: , calendar_type
4093: , report_date
4094: , time_id
4145: END IF;
4146:
4147: if l_row > 0 then
4148:
4149: gather_table_stats('HRI_TIME_CAL_RPT_STRUCT');
4150:
4151: if g_debug_flag = 'Y' then
4152: HRI_util.put_line('LOAD_TIME_CAL_RPT_STRUCT :'||'Gathered statistics for Financial Calendars');
4153: end if;