APPS.HRI_TIME_C dependencies on HRI_TIME_CAL_PERIOD

Line 2002: HRI_time_cal_period

1998: , name
1999: , start_date
2000: , end_date
2001: from
2002: HRI_time_cal_period
2003: )
2004: union all
2005: (select
2006: cal_period_id

Line 2014: HRI_time_cal_period

2010: , name
2011: , start_date
2012: , end_date
2013: from
2014: HRI_time_cal_period
2015: minus
2016: select
2017: to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year||glp.quarter_num||decode(length(glp.period_num),1,'0'||glp.period_num, glp.period_num))
2018: -- lpad(gl.period_num,2,'0')) bug 3370185

Line 2041: --For Bug 3543939. If there is a difference then truncate and repopulate HRI_TIME_CAL_PERIOD

2037: if g_debug_flag = 'Y' then
2038: HRI_util.put_line('LOAD_CAL_PERIOD : '||to_char(l_period_changed)||' Calendars have changed in GL');
2039: end if;
2040:
2041: --For Bug 3543939. If there is a difference then truncate and repopulate HRI_TIME_CAL_PERIOD
2042:
2043: -- Bug 4966868: Changed not to count rows
2044: BEGIN
2045: select 1 into l_diff_rows

Line 2065: truncate_table('HRI_TIME_CAL_PERIOD');

2061: return;
2062:
2063: end if;
2064:
2065: truncate_table('HRI_TIME_CAL_PERIOD');
2066:
2067: -- ---------------------------------------------------------
2068: -- Variable initialization
2069: -- ---------------------------------------------------------

Line 2075: insert into HRI_time_cal_period

2071:
2072: -- ----------------------
2073: -- Populate Financial Period Level
2074: -- ----------------------
2075: insert into HRI_time_cal_period
2076: (cal_period_id,
2077: cal_qtr_id,
2078: calendar_id,
2079: sequence,

Line 2114: gather_table_stats('HRI_TIME_CAL_PERIOD');

2110: if g_debug_flag = 'Y' then
2111: HRI_util.put_line('LOAD_CAL_PERIOD : '||to_char(l_period_row)||' records has been populated to Financial Period Level');
2112: end if;
2113:
2114: gather_table_stats('HRI_TIME_CAL_PERIOD');
2115:
2116: if g_debug_flag = 'Y' then
2117: HRI_util.put_line('LOAD_CAL_PERIOD : '||'Gathered statistics for Financial Period Level');
2118: end if;

Line 2729: truncate_table('HRI_TIME_CAL_PERIOD');

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');
2732: truncate_table('HRI_TIME_RPT_STRUCT');
2733: truncate_table('HRI_TIME_CAL_RPT_STRUCT');

Line 3120: truncate_table('HRI_TIME_CAL_PERIOD');

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');
3124: truncate_table('HRI_TIME_CAL_RPT_STRUCT');

Line 4010: FROM HRI_TIME_CAL_PERIOD

4006: , SYSDATE
4007: , g_user_id
4008: , g_user_id
4009: , g_login_id
4010: FROM HRI_TIME_CAL_PERIOD
4011: WHERE start_date >= cur_Fiscal_Days.qtr_start_date
4012: AND start_date <= cur_Fiscal_Days.period_start_date
4013: AND end_date < cur_Fiscal_Days.report_date
4014: AND calendar_id = cur_Fiscal_Days.calendar_id

Line 4028: FROM HRI_TIME_CAL_PERIOD

4024: , SYSDATE
4025: , g_user_id
4026: , g_user_id
4027: , g_login_id
4028: FROM HRI_TIME_CAL_PERIOD
4029: WHERE start_date >= cur_Fiscal_Days.qtr_start_date
4030: AND start_date <= cur_Fiscal_Days.period_start_date
4031: AND end_date >= cur_Fiscal_Days.report_date
4032: AND calendar_id = cur_Fiscal_Days.calendar_id;