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_RETRIEVE_ABSENCES

Line 1: PACKAGE BODY HXC_RETRIEVE_ABSENCES AS

1: PACKAGE BODY HXC_RETRIEVE_ABSENCES AS
2: /* $Header: hxcretabs.pkb 120.43.12020000.2 2012/10/09 14:59:12 asrajago ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5:

Line 27: p_abs_tab IN OUT NOCOPY hxc_retrieve_absences.abs_tab)

23:
24: PROCEDURE retrieve_absences( p_person_id IN NUMBER,
25: p_start_date IN DATE,
26: p_end_date IN DATE,
27: p_abs_tab IN OUT NOCOPY hxc_retrieve_absences.abs_tab)
28: AS
29:
30:
31: l_abs_org_tab hr_person_absence_api.abs_data;

Line 4016: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');

4012: l_rounding_rule := 'ROUND_TO_NEAREST';
4013: END IF;
4014:
4015: IF g_debug THEN
4016: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4017: hr_utility.trace('ABS> invoke logic to calculate absence hours and absence days');
4018: hr_utility.trace('ABS> l_precision ::'||l_precision);
4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);

Line 4084: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');

4080: END LOOP;
4081: END IF;
4082:
4083: IF g_debug THEN
4084: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4085: hr_utility.trace('ABS> final values of absence hours and absence days');
4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);
4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);

Line 4142: WHERE resource_id = hxc_retrieve_absences.g_person_id

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:
4146: IF l_abs_record_exist = 'Y' THEN

Line 4143: AND start_time = hxc_retrieve_absences.g_start_time

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:
4146: IF l_abs_record_exist = 'Y' THEN
4147: -- DO NOTHING

Line 4144: AND stop_time = hxc_retrieve_absences.g_stop_time;

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:
4146: IF l_abs_record_exist = 'Y' THEN
4147: -- DO NOTHING
4148: return;

Line 4161: (hxc_retrieve_absences.g_person_id

4157: ,start_time
4158: ,stop_time
4159: )
4160: VALUES
4161: (hxc_retrieve_absences.g_person_id
4162: ,hxc_retrieve_absences.g_start_time
4163: ,hxc_retrieve_absences.g_stop_time
4164: );
4165:

Line 4162: ,hxc_retrieve_absences.g_start_time

4158: ,stop_time
4159: )
4160: VALUES
4161: (hxc_retrieve_absences.g_person_id
4162: ,hxc_retrieve_absences.g_start_time
4163: ,hxc_retrieve_absences.g_stop_time
4164: );
4165:
4166: COMMIT;

Line 4163: ,hxc_retrieve_absences.g_stop_time

4159: )
4160: VALUES
4161: (hxc_retrieve_absences.g_person_id
4162: ,hxc_retrieve_absences.g_start_time
4163: ,hxc_retrieve_absences.g_stop_time
4164: );
4165:
4166: COMMIT;
4167: END insert_absence_summary_row;

Line 4474: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element');

4470: IS
4471:
4472: BEGIN
4473: IF g_debug THEN
4474: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element');
4475: hr_utility.trace('ABS> p_alias_value_id ::'||p_alias_value_id);
4476: END IF;
4477:
4478: SELECT 'Y'

Line 4492: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception NO_DATA_FOUND');

4488: EXCEPTION
4489: WHEN NO_DATA_FOUND THEN
4490: p_absence_element_flag := 'N';
4491: IF g_debug THEN
4492: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception NO_DATA_FOUND');
4493: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);
4494: END IF;
4495: WHEN TOO_MANY_ROWS THEN
4496: p_absence_element_flag := 'Y';

Line 4498: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception TOO_MANY_ROWS');

4494: END IF;
4495: WHEN TOO_MANY_ROWS THEN
4496: p_absence_element_flag := 'Y';
4497: IF g_debug THEN
4498: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception TOO_MANY_ROWS');
4499: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);
4500: END IF;
4501:
4502: END is_absence_element;

Line 4505: END HXC_RETRIEVE_ABSENCES;

4501:
4502: END is_absence_element;
4503:
4504:
4505: END HXC_RETRIEVE_ABSENCES;
4506:
4507: