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