1829: and adjustment_period_flag='N';
1830:
1831: ELSE
1832: --Incremental run
1833: select period_year into l_period_year from gl_periods where (select nvl(min(start_date), l_from_date) from HRI_time_ent_year)
1834: between start_date and end_date
1835: and period_set_name = g_period_set_name
1836: and period_type = g_period_type
1837: and adjustment_period_flag='N';
1844: from HRI_time_ent_period
1845: where end_date < g_unassigned_day;
1846:
1847: -- Bug 5624487
1848: delete from HRI_TIME_ENT_YEAR where ent_year_id in
1849: (select period_year
1850: from gl_periods
1851: where period_set_name = g_period_set_name
1852: and period_type = g_period_type
1857:
1858: -- ----------------------
1859: -- Populate Enterprise Year Level
1860: -- ----------------------
1861: insert into HRI_time_ent_year
1862: (ent_year_id,
1863: period_set_name,
1864: period_type,
1865: sequence,
1908: HRI_util.put_line('LOAD_ENT_YEAR : '||to_char(l_year_row)||' records has been populated to Enterprise Year Level');
1909: end if;
1910:
1911: -- Bug 5624487
1912: insert into HRI_time_ent_year
1913: (ent_year_id,
1914: period_set_name,
1915: period_type,
1916: sequence,
2723: truncate_table('HRI_TIME_P445');
2724: truncate_table('HRI_TIME_YEAR445');
2725: truncate_table('HRI_TIME_ENT_PERIOD');
2726: truncate_table('HRI_TIME_ENT_QTR');
2727: truncate_table('HRI_TIME_ENT_YEAR');
2728: truncate_table('HRI_TIME_CAL_NAME');
2729: truncate_table('HRI_TIME_CAL_PERIOD');
2730: truncate_table('HRI_TIME_CAL_QTR');
2731: truncate_table('HRI_TIME_CAL_YEAR');
2755: -- If there is a new period added to a quarter, then requires the end date of that quarter to be updated
2756: -- function period_updated is not able to indicate that, that's why we choose to always truncate the
2757: -- tables to avoid any further unique constraint violation
2758: truncate_table('HRI_TIME_ENT_QTR');
2759: truncate_table('HRI_TIME_ENT_YEAR');
2760: end if;
2761: end if;
2762:
2763: g_phase := 'Load Day Level';
3115: truncate_table('HRI_TIME_P445');
3116: truncate_table('HRI_TIME_YEAR445');
3117: truncate_table('HRI_TIME_ENT_PERIOD');
3118: truncate_table('HRI_TIME_ENT_QTR');
3119: truncate_table('HRI_TIME_ENT_YEAR');
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');
3669: sysdate,
3670: g_user_id,
3671: g_user_id,
3672: g_login_id
3673: from HRI_TIME_ENT_YEAR
3674: where c1_rec.report_date between start_date and end_date;
3675:
3676: l_row := l_row + sql%rowcount;
3677:
3701: sysdate,
3702: g_user_id,
3703: g_user_id,
3704: g_login_id
3705: from HRI_TIME_ENT_YEAR
3706: where end_date >= g_global_start_date -- should we use start_date?
3707: and end_date < c1_rec.report_date;
3708:
3709: l_row := l_row + sql%rowcount;