eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_TIME_C dependencies on HRI_TIME_CAL_QTR

Line 2192: HRI_time_cal_qtr

2188: , name
2189: , start_date
2190: , end_date
2191: from
2192: HRI_time_cal_qtr
2193: )
2194: union all
2195: (select
2196: cal_qtr_id

Line 2204: HRI_time_cal_qtr

2200: , name
2201: , start_date
2202: , end_date
2203: from
2204: HRI_time_cal_qtr
2205: minus
2206: select
2207: distinct to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year||glp.quarter_num)
2208: , to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year)

Line 2265: truncate_table('HRI_TIME_CAL_QTR');

2261: return;
2262:
2263: end if;
2264:
2265: truncate_table('HRI_TIME_CAL_QTR');
2266:
2267: -- ---------------------------------------------------------
2268: -- Variable initialization
2269: -- ---------------------------------------------------------

Line 2275: insert into HRI_time_cal_qtr

2271:
2272: -- ----------------------
2273: -- Populate Financial Quarter Level
2274: -- ----------------------
2275: insert into HRI_time_cal_qtr
2276: (cal_qtr_id,
2277: cal_year_id,
2278: calendar_id,
2279: sequence,

Line 2326: gather_table_stats('HRI_TIME_CAL_QTR');

2322: if g_debug_flag = 'Y' then
2323: HRI_util.put_line('LOAD_CAL_QUARTER : '||to_char(l_qtr_row)||' records has been populated to Financial Quarter Level');
2324: end if;
2325:
2326: gather_table_stats('HRI_TIME_CAL_QTR');
2327:
2328: if g_debug_flag = 'Y' then
2329: HRI_util.put_line('LOAD_CAL_QUARTER : '||'Gathered statistics for Financial Quarter Level');
2330: end if;

Line 2730: truncate_table('HRI_TIME_CAL_QTR');

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');
2734: truncate_table('HRI_TIME_STRUCTURES');

Line 3121: truncate_table('HRI_TIME_CAL_QTR');

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');
3125:

Line 4062: FROM HRI_TIME_CAL_QTR

4058: , SYSDATE
4059: , g_user_id
4060: , g_user_id
4061: , g_login_id
4062: FROM HRI_TIME_CAL_QTR
4063: WHERE start_date >= cur_Fiscal_Days.year_start_date
4064: AND start_date <= cur_Fiscal_Days.qtr_start_date
4065: AND end_date < cur_Fiscal_Days.report_date
4066: AND calendar_id = cur_Fiscal_Days.calendar_id

Line 4080: FROM HRI_TIME_CAL_QTR

4076: , SYSDATE
4077: , g_user_id
4078: , g_user_id
4079: , g_login_id
4080: FROM HRI_TIME_CAL_QTR
4081: WHERE start_date >= cur_Fiscal_Days.year_start_date
4082: AND start_date <= cur_Fiscal_Days.qtr_start_date
4083: AND end_date >= cur_Fiscal_Days.report_date
4084: AND calendar_id = cur_Fiscal_Days.calendar_id;