APPS.HRI_TIME_C dependencies on HRI_TIME_GL_PERIODS

Line 204: insert into HRI_TIME_GL_PERIODS

200: l_updated varchar2(1);
201:
202: begin
203:
204: insert into HRI_TIME_GL_PERIODS
205: (ent_period_id,
206: ent_qtr_id,
207: ent_year_id,
208: sequence,

Line 260: from HRI_TIME_GL_PERIODS)

256: --sequence,
257: name,
258: start_date,
259: end_date
260: from HRI_TIME_GL_PERIODS)
261: where rownum = 1;
262: EXCEPTION
263: WHEN NO_DATA_FOUND THEN
264: l_updated := 'N';

Line 2648: truncate_table('HRI_TIME_GL_PERIODS');

2644: -- This is necessary because once initial load is over, there can be some changes in the already defined calendar
2645: -- which may result in a calendar not complying with the no. of days range allowed (365 +/- 14)
2646:
2647: IF l_validated = 'Y' THEN
2648: truncate_table('HRI_TIME_GL_PERIODS');
2649: l_period_updated := period_updated(l_min_date, l_max_date);
2650: IF (l_period_updated = 'Y' and p_load_mode <> 'INIT') THEN
2651: l_start_date := l_min_date;
2652: END IF; --l_period_updated

Line 2744: --truncate_table('HRI_TIME_GL_PERIODS');

2740: HRI_util.put_line('LOAD : '||'l_validated='||l_validated);
2741: HRI_util.put_line('');
2742: end if;
2743: if l_validated = 'Y' then
2744: --truncate_table('HRI_TIME_GL_PERIODS');
2745: --l_period_updated := period_updated(l_min_date, l_max_date);
2746: if g_debug_flag = 'Y' then
2747: HRI_util.put_line('LOAD : '||'l_period_updated='||l_period_updated);
2748: HRI_util.put_line('');