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.HXC_RETRIEVE_ABSENCES dependencies on HXC_ABSENCE_SUMMARY_TEMP

Line 4141: FROM hxc_absence_summary_temp

4137: BEGIN
4138:
4139: SELECT 'Y'
4140: INTO l_abs_record_exist
4141: FROM hxc_absence_summary_temp
4142: WHERE resource_id = hxc_retrieve_absences.g_person_id
4143: AND start_time = hxc_retrieve_absences.g_start_time
4144: AND stop_time = hxc_retrieve_absences.g_stop_time;
4145:

Line 4155: INSERT INTO hxc_absence_summary_temp

4151:
4152: EXCEPTION
4153: WHEN NO_DATA_FOUND THEN
4154:
4155: INSERT INTO hxc_absence_summary_temp
4156: (resource_id
4157: ,start_time
4158: ,stop_time
4159: )

Line 4182: UPDATE hxc_absence_summary_temp

4178: PRAGMA AUTONOMOUS_TRANSACTION;
4179:
4180: BEGIN
4181:
4182: UPDATE hxc_absence_summary_temp
4183: SET absence_days = p_abs_days,
4184: absence_hours = p_abs_hours
4185: WHERE resource_id = p_resource_id
4186: AND start_time = p_tc_start

Line 4200: DELETE FROM hxc_absence_summary_temp;

4196: PRAGMA AUTONOMOUS_TRANSACTION;
4197:
4198: BEGIN
4199:
4200: DELETE FROM hxc_absence_summary_temp;
4201: COMMIT;
4202:
4203: END clear_absence_summary_rows;
4204: