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_ENT_PERIOD

Line 250: from hri_time_ent_period

246: --sequence,
247: name,
248: start_date,
249: end_date
250: from hri_time_ent_period
251: where end_date < g_unassigned_day
252: minus
253: select ent_period_id,
254: ent_qtr_id,

Line 1468: from HRI_time_ent_period

1464: l_period_year number;
1465:
1466: cursor get_years is
1467: select distinct ent_year_id
1468: from HRI_time_ent_period
1469: where start_date <= p_to_date
1470: and end_date >= p_from_date;
1471:
1472: cursor get_periods (p_year number) is

Line 1474: from HRI_time_ent_period

1470: and end_date >= p_from_date;
1471:
1472: cursor get_periods (p_year number) is
1473: select ent_period_id
1474: from HRI_time_ent_period
1475: where ent_year_id = p_year
1476: order by start_date;
1477:
1478: begin

Line 1499: where (select nvl(min(start_date), l_from_date) from HRI_time_ent_period) between start_date and end_date

1495:
1496: ELSE
1497: --Incremental run
1498: select period_year into l_period_year from gl_periods
1499: where (select nvl(min(start_date), l_from_date) from HRI_time_ent_period) between start_date and end_date
1500: and period_set_name = g_period_set_name
1501: and period_type = g_period_type
1502: and adjustment_period_flag='N';
1503: END IF;

Line 1506: -- delete from HRI_TIME_ENT_PERIOD where start_date <= l_to_date and end_date >= l_from_date;

1502: and adjustment_period_flag='N';
1503: END IF;
1504:
1505: -- Bug 5624487
1506: -- delete from HRI_TIME_ENT_PERIOD where start_date <= l_to_date and end_date >= l_from_date;
1507: delete from HRI_TIME_ENT_PERIOD
1508: where start_date <= l_to_date and end_date >= l_from_date
1509: or end_date >= g_unassigned_day;
1510:

Line 1507: delete from HRI_TIME_ENT_PERIOD

1503: END IF;
1504:
1505: -- Bug 5624487
1506: -- delete from HRI_TIME_ENT_PERIOD where start_date <= l_to_date and end_date >= l_from_date;
1507: delete from HRI_TIME_ENT_PERIOD
1508: where start_date <= l_to_date and end_date >= l_from_date
1509: or end_date >= g_unassigned_day;
1510:
1511: -- ----------------------

Line 1514: insert into HRI_time_ent_period

1510:
1511: -- ----------------------
1512: -- Populate Enterprise Period Level
1513: -- ----------------------
1514: insert into HRI_time_ent_period
1515: (ent_period_id,
1516: ent_qtr_id,
1517: ent_year_id,
1518: sequence,

Line 1562: update HRI_time_ent_period

1558: -- update period sequence
1559: l_period_seq := 1;
1560: for j in get_periods (i.ent_year_id)
1561: loop
1562: update HRI_time_ent_period
1563: set sequence = l_period_seq
1564: where ent_period_id = j.ent_period_id;
1565: l_period_seq :=l_period_seq + 1;
1566: end loop;

Line 1572: insert into HRI_time_ent_period

1568:
1569: commit;
1570:
1571: -- Bug 5624487
1572: insert into HRI_time_ent_period
1573: (ent_period_id,
1574: ent_qtr_id,
1575: ent_year_id,
1576: sequence,

Line 1651: from HRI_time_ent_period

1647: l_period_year number;
1648:
1649: cursor get_years is
1650: select distinct ent_year_id
1651: from HRI_time_ent_period
1652: where start_date <= p_to_date
1653: and end_date >= p_from_date;
1654:
1655: cursor get_quarters (p_year number) is

Line 1844: from HRI_time_ent_period

1840:
1841: -- Bug 5624487
1842: select nvl(max(end_date), l_to_date)
1843: into l_end_date
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

Line 2639: -- which is to make the sequence in HRI_time_ent_period and HRI_time_ent_qtr independent of GL

2635: l_start_date := l_from_date;
2636:
2637: -- Bug 4454026
2638: -- We should default the from date to the start of the fiscal year so that fix of bug 3961336 wroks fine
2639: -- which is to make the sequence in HRI_time_ent_period and HRI_time_ent_qtr independent of GL
2640: -- This is done for initial load and in case the last run was not successfull
2641:
2642: g_phase := 'Checking if all the years in the calendar are fully defined';
2643:

Line 2725: truncate_table('HRI_TIME_ENT_PERIOD');

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');
2729: truncate_table('HRI_TIME_CAL_PERIOD');

Line 2751: truncate_table('HRI_TIME_ENT_PERIOD');

2747: HRI_util.put_line('LOAD : '||'l_period_updated='||l_period_updated);
2748: HRI_util.put_line('');
2749: end if;
2750: if l_period_updated = 'Y' then
2751: truncate_table('HRI_TIME_ENT_PERIOD');
2752: end if;
2753: -- both enterprise quarter and enterprise year tables are truncated because function period_updated
2754: -- can only detect if there is any changes of the existing periods populated into time dimension
2755: -- If there is a new period added to a quarter, then requires the end date of that quarter to be updated

Line 3117: truncate_table('HRI_TIME_ENT_PERIOD');

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');
3121: truncate_table('HRI_TIME_CAL_QTR');

Line 3572: from HRI_TIME_ENT_PERIOD

3568: sysdate,
3569: g_user_id,
3570: g_user_id,
3571: g_login_id
3572: from HRI_TIME_ENT_PERIOD
3573: where start_date >= c1_rec.ent_qtr_start_date
3574: and start_date <= c1_rec.ent_period_start_date
3575: and end_date < c1_rec.report_date
3576: union all

Line 3589: from HRI_TIME_ENT_PERIOD

3585: sysdate,
3586: g_user_id,
3587: g_user_id,
3588: g_login_id
3589: from HRI_TIME_ENT_PERIOD
3590: where start_date >= c1_rec.ent_qtr_start_date
3591: and start_date <= c1_rec.ent_period_start_date
3592: and end_date >= c1_rec.report_date;
3593: