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_OPL_SUP_STATUS_HST dependencies on HR_GENERAL

Line 14: g_end_of_time DATE := hr_general.end_of_time;

10: g_current_time DATE;
11: --
12: -- End of time
13: --
14: g_end_of_time DATE := hr_general.end_of_time;
15: --
16: -- Full or incremental refresh
17: --
18: g_run_mode VARCHAR2(30);

Line 166: l_end_of_time := hr_general.end_of_time;

162: dbg('Inside collect_data');
163: --
164: -- Initialize variables
165: --
166: l_end_of_time := hr_general.end_of_time;
167: l_user_id := fnd_global.user_id;
168: l_current_time := SYSDATE;
169: --
170: -- This sql statement creates the supervisor status history records, which tells

Line 349: WHERE (p_collect_from BETWEEN pos.date_start AND NVL(pos.actual_termination_date, hr_general.end_of_time)

345: --
346: SELECT pos.person_id,
347: GREATEST(p_collect_from,pos.date_start)
348: FROM per_periods_of_service pos
349: WHERE (p_collect_from BETWEEN pos.date_start AND NVL(pos.actual_termination_date, hr_general.end_of_time)
350: OR p_collect_from <= pos.date_start)
351: --
352: -- Gets all active contingent workers
353: --

Line 358: WHERE (p_collect_from BETWEEN pop.date_start AND NVL(pop.actual_termination_date, hr_general.end_of_time)

354: UNION
355: SELECT pop.person_id,
356: GREATEST(p_collect_from,pop.date_start)
357: FROM per_periods_of_placement pop
358: WHERE (p_collect_from BETWEEN pop.date_start AND NVL(pop.actual_termination_date, hr_general.end_of_time)
359: OR p_collect_from <= pop.date_start)
360: )leaf_date
361: WHERE leaf_date.event_supervisor_id = asg.supervisor_id (+)
362: AND leaf_date.event_supervisor_id = pos.person_id

Line 404: l_end_of_time := hr_general.end_of_time;

400: dbg('Inside collect_incremental_data');
401: --
402: -- Initialize variables
403: --
404: l_end_of_time := hr_general.end_of_time;
405: l_start_date := hri_bpl_parameter.get_bis_global_start_date;
406: l_user_id := fnd_global.user_id;
407: l_current_time := SYSDATE;
408: --

Line 642: l_end_of_time := hr_general.end_of_time;

638: dbg('Inside collect_asg_data');
639: --
640: -- Initialize variables
641: --
642: l_end_of_time := hr_general.end_of_time;
643: l_user_id := fnd_global.user_id;
644: l_current_time := SYSDATE;
645: --
646: -- This sql statement creates the supervisor status history records, which tells

Line 792: AND NVL(pos.actual_termination_date, hr_general.end_of_time)

788: --
789: SELECT pos.person_id, GREATEST(p_collect_from,pos.date_start)
790: FROM per_periods_of_service pos
791: WHERE (p_collect_from BETWEEN pos.date_start
792: AND NVL(pos.actual_termination_date, hr_general.end_of_time)
793: OR p_collect_from <= pos.date_start)
794: --
795: -- Gets all active contingent workers
796: --

Line 801: AND NVL(pop.actual_termination_date, hr_general.end_of_time)

797: UNION
798: SELECT pop.person_id, GREATEST(p_collect_from,pop.date_start)
799: FROM per_periods_of_placement pop
800: WHERE (p_collect_from BETWEEN pop.date_start
801: AND NVL(pop.actual_termination_date, hr_general.end_of_time)
802: OR p_collect_from <= pop.date_start)
803: )leaf_date
804: WHERE leaf_date.event_supervisor_id = asg.supervisor_id (+)
805: AND leaf_date.event_supervisor_id = pos.person_id

Line 851: l_end_of_time := hr_general.end_of_time;

847: dbg('Inside collect_asg_incremental_data');
848: --
849: -- Initialize variables
850: --
851: l_end_of_time := hr_general.end_of_time;
852: l_start_date := hri_bpl_parameter.get_bis_global_start_date;
853: l_user_id := fnd_global.user_id;
854: l_current_time := SYSDATE;
855: --

Line 1543: l_is_hr_installed := hr_general.chk_product_installed(800);

1539: BEGIN
1540: --
1541: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');
1542: --
1543: l_is_hr_installed := hr_general.chk_product_installed(800);
1544: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
1545: --
1546: IF l_is_hr_installed = 'FALSE'
1547: OR l_frc_shrd_hr_prfl_val = 'Y' THEN

Line 1550: l_end_date := hr_general.end_of_time;

1546: IF l_is_hr_installed = 'FALSE'
1547: OR l_frc_shrd_hr_prfl_val = 'Y' THEN
1548: --
1549: l_start_date := TRUNC(SYSDATE);
1550: l_end_date := hr_general.end_of_time;
1551: --
1552: IF l_is_hr_installed = 'FALSE' THEN
1553: --
1554: dbg('Foundation HR detected. Defaulting '||

Line 1654: l_is_hr_installed := hr_general.chk_product_installed(800);

1650: -- If Full HR has not been installed or if profile HRI:DBI Force Shared HR
1651: -- Processes has been set, then the force the process to run in
1652: -- full refresh mode and from SYSDATE
1653: --
1654: l_is_hr_installed := hr_general.chk_product_installed(800);
1655: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
1656: --
1657: IF l_is_hr_installed = 'FALSE'
1658: OR l_frc_shrd_hr_prfl_val = 'Y'

Line 1677: l_end_date := hr_general.end_of_time;

1673: --
1674: END IF;
1675: --
1676: l_start_date := trunc(SYSDATE);
1677: l_end_date := hr_general.end_of_time;
1678: --
1679: dbg('Collect From Date : '||l_start_date);
1680: dbg('Collect To Date : '||l_end_date);
1681: --

Line 1783: l_is_hr_installed := hr_general.chk_product_installed(800);

1779: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');
1780: --
1781: -- Determine if the process needs to be run in Foundation HR mode
1782: --
1783: l_is_hr_installed := hr_general.chk_product_installed(800);
1784: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
1785: --
1786: l_end_date := fnd_date.canonical_to_date(p_end_date);
1787: --