APPS.HRI_TIME_C dependencies on HRI_TIME_YEAR

Line 985: select min(start_date) into l_min_date from HRI_time_year;

981: --Used a decode for the same
982: l_min_date := p_from_date;
983: ELSE
984: -- Incremental run
985: select min(start_date) into l_min_date from HRI_time_year;
986: END IF;
987:
988: -- Bug 5624487
989: -- delete from HRI_TIME_YEAR where start_date <= l_to_date and end_date >= l_from_date;

Line 989: -- delete from HRI_TIME_YEAR where start_date <= l_to_date and end_date >= l_from_date;

985: select min(start_date) into l_min_date from HRI_time_year;
986: END IF;
987:
988: -- Bug 5624487
989: -- delete from HRI_TIME_YEAR where start_date <= l_to_date and end_date >= l_from_date;
990: delete from HRI_TIME_YEAR
991: where start_date <= l_to_date and end_date >= l_from_date
992: or end_date >= g_unassigned_day;
993:

Line 990: delete from HRI_TIME_YEAR

986: END IF;
987:
988: -- Bug 5624487
989: -- delete from HRI_TIME_YEAR where start_date <= l_to_date and end_date >= l_from_date;
990: delete from HRI_TIME_YEAR
991: where start_date <= l_to_date and end_date >= l_from_date
992: or end_date >= g_unassigned_day;
993:
994: -- ----------------------

Line 1006: insert into HRI_time_year

1002: end if;
1003: while l_year <= l_to_date or l_year_end = g_unassigned_day loop
1004:
1005: -- Bug 5624487
1006: insert into HRI_time_year
1007: (year_id,
1008: name,
1009: start_date,
1010: end_date,

Line 1371: -- delete from HRI_TIME_YEAR445 where start_date <= l_to_date and end_date >= l_from_date;

1367:
1368: l_year_row := 0;
1369:
1370: -- Bug 5624487
1371: -- delete from HRI_TIME_YEAR445 where start_date <= l_to_date and end_date >= l_from_date;
1372: delete from HRI_TIME_YEAR445
1373: where start_date <= l_to_date and end_date >= l_from_date
1374: or end_date >= g_unassigned_day;
1375:

Line 1372: delete from HRI_TIME_YEAR445

1368: l_year_row := 0;
1369:
1370: -- Bug 5624487
1371: -- delete from HRI_TIME_YEAR445 where start_date <= l_to_date and end_date >= l_from_date;
1372: delete from HRI_TIME_YEAR445
1373: where start_date <= l_to_date and end_date >= l_from_date
1374: or end_date >= g_unassigned_day;
1375:
1376: -- ----------------------

Line 1385: insert into HRI_time_year445

1381: -- while l_year <= l_to_date loop
1382: while l_year <= l_to_date or l_year_end = g_unassigned_day loop
1383:
1384: -- Bug 5624487
1385: insert into HRI_time_year445
1386: (year445_id,
1387: name,
1388: start_date,
1389: end_date,

Line 2721: truncate_table('HRI_TIME_YEAR');

2717:
2718: truncate_table('HRI_TIME_DAY');
2719: truncate_table('HRI_TIME_MONTH');
2720: truncate_table('HRI_TIME_QTR');
2721: truncate_table('HRI_TIME_YEAR');
2722: truncate_table('HRI_TIME_WEEK');
2723: truncate_table('HRI_TIME_P445');
2724: truncate_table('HRI_TIME_YEAR445');
2725: truncate_table('HRI_TIME_ENT_PERIOD');

Line 2724: truncate_table('HRI_TIME_YEAR445');

2720: truncate_table('HRI_TIME_QTR');
2721: truncate_table('HRI_TIME_YEAR');
2722: truncate_table('HRI_TIME_WEEK');
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');

Line 3098: gather_table_stats('HRI_TIME_YEAR445');

3094: if g_debug_flag = 'Y' then
3095: HRI_util.put_line('Gathered statistics for Quarter Level');
3096: end if;
3097:
3098: gather_table_stats('HRI_TIME_YEAR445');
3099:
3100: if g_debug_flag = 'Y' then
3101: HRI_util.put_line('Gathered statistics for Period 445 Level');
3102: end if;

Line 3116: truncate_table('HRI_TIME_YEAR445');

3112: else
3113:
3114: truncate_table('HRI_TIME_WEEK');
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');