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_ABSENCE_TYPE_ALIAS dependencies on HXC_ALIAS_DEFINITIONS

Line 7: PROCEDURE ins_otl_abs_type_elements_temp(p_tc_abs_type_alias_def_id IN hxc_alias_definitions_tl.alias_definition_id%TYPE,

3:
4: g_package varchar2(30) := 'hxc_absence_type_alias.';
5: g_debug BOOLEAN := hr_utility.debug_enabled;
6:
7: PROCEDURE ins_otl_abs_type_elements_temp(p_tc_abs_type_alias_def_id IN hxc_alias_definitions_tl.alias_definition_id%TYPE,
8: p_tc_abs_payroll_id IN pay_payrolls_f.payroll_id%TYPE,
9: p_tc_abs_element_set_id IN pay_element_sets_tl.element_set_id%TYPE,
10: p_tc_abs_absence_type_id IN per_abs_attendance_types_tl.absence_attendance_type_id%TYPE) IS
11: PRAGMA AUTONOMOUS_TRANSACTION;

Line 13: l_tc_abs_type_alias_def_id hxc_alias_definitions_tl.alias_definition_id%TYPE;

9: p_tc_abs_element_set_id IN pay_element_sets_tl.element_set_id%TYPE,
10: p_tc_abs_absence_type_id IN per_abs_attendance_types_tl.absence_attendance_type_id%TYPE) IS
11: PRAGMA AUTONOMOUS_TRANSACTION;
12:
13: l_tc_abs_type_alias_def_id hxc_alias_definitions_tl.alias_definition_id%TYPE;
14: l_tc_abs_payroll_id pay_payrolls_f.payroll_id%TYPE;
15: l_tc_abs_element_set_id pay_element_sets_tl.element_set_id%TYPE;
16: l_tc_abs_absence_type_id per_abs_attendance_types_tl.absence_attendance_type_id%TYPE;
17:

Line 94: FROM hxc_alias_definitions_tl hadt,

90:
91: DELETE hxc_absence_type_elements_temp haet
92: WHERE to_char(haet.element_type_id) NOT IN
93: (SELECT hav.attribute1
94: FROM hxc_alias_definitions_tl hadt,
95: hxc_alias_definitions had,
96: hxc_alias_values hav
97: WHERE had.alias_context_code = 'PAYROLL_ELEMENTS'
98: AND hadt.alias_definition_id = had.alias_definition_id

Line 95: hxc_alias_definitions had,

91: DELETE hxc_absence_type_elements_temp haet
92: WHERE to_char(haet.element_type_id) NOT IN
93: (SELECT hav.attribute1
94: FROM hxc_alias_definitions_tl hadt,
95: hxc_alias_definitions had,
96: hxc_alias_values hav
97: WHERE had.alias_context_code = 'PAYROLL_ELEMENTS'
98: AND hadt.alias_definition_id = had.alias_definition_id
99: AND hadt.alias_definition_id = hav.alias_definition_id

Line 170: l_alias_definition_id hxc_alias_definitions.ALIAS_DEFINITION_ID%type;

166: p_alias_definition_name IN VARCHAR2,
167: p_object_version_number OUT nocopy NUMBER,
168: p_alias_definition_name_exists OUT nocopy VARCHAR2) IS
169:
170: l_alias_definition_id hxc_alias_definitions.ALIAS_DEFINITION_ID%type;
171: l_alias_definition_id_ovn hxc_alias_definitions.OBJECT_VERSION_NUMBER%type;
172: l_alias_type_id hxc_alias_definitions.ALIAS_TYPE_ID%type;
173: l_alias_definition_name hxc_alias_definitions.ALIAS_DEFINITION_NAME%type;
174:

Line 171: l_alias_definition_id_ovn hxc_alias_definitions.OBJECT_VERSION_NUMBER%type;

167: p_object_version_number OUT nocopy NUMBER,
168: p_alias_definition_name_exists OUT nocopy VARCHAR2) IS
169:
170: l_alias_definition_id hxc_alias_definitions.ALIAS_DEFINITION_ID%type;
171: l_alias_definition_id_ovn hxc_alias_definitions.OBJECT_VERSION_NUMBER%type;
172: l_alias_type_id hxc_alias_definitions.ALIAS_TYPE_ID%type;
173: l_alias_definition_name hxc_alias_definitions.ALIAS_DEFINITION_NAME%type;
174:
175: l_exists VARCHAR2(1) := 'N';

Line 172: l_alias_type_id hxc_alias_definitions.ALIAS_TYPE_ID%type;

168: p_alias_definition_name_exists OUT nocopy VARCHAR2) IS
169:
170: l_alias_definition_id hxc_alias_definitions.ALIAS_DEFINITION_ID%type;
171: l_alias_definition_id_ovn hxc_alias_definitions.OBJECT_VERSION_NUMBER%type;
172: l_alias_type_id hxc_alias_definitions.ALIAS_TYPE_ID%type;
173: l_alias_definition_name hxc_alias_definitions.ALIAS_DEFINITION_NAME%type;
174:
175: l_exists VARCHAR2(1) := 'N';
176: l_messages hxc_message_table_type;

Line 173: l_alias_definition_name hxc_alias_definitions.ALIAS_DEFINITION_NAME%type;

169:
170: l_alias_definition_id hxc_alias_definitions.ALIAS_DEFINITION_ID%type;
171: l_alias_definition_id_ovn hxc_alias_definitions.OBJECT_VERSION_NUMBER%type;
172: l_alias_type_id hxc_alias_definitions.ALIAS_TYPE_ID%type;
173: l_alias_definition_name hxc_alias_definitions.ALIAS_DEFINITION_NAME%type;
174:
175: l_exists VARCHAR2(1) := 'N';
176: l_messages hxc_message_table_type;
177:

Line 210: FROM hxc_alias_definitions_tl

206: BEGIN
207:
208: SELECT 'Y'
209: INTO l_exists
210: FROM hxc_alias_definitions_tl
211: WHERE alias_definition_name = l_alias_definition_name
212: AND LANGUAGE = userenv('LANG');
213:
214: IF g_debug THEN

Line 225: hr_utility.trace('ABS:Calling hxc_alias_definitions_api.create_alias_definition procedure.');

221: WHEN NO_DATA_FOUND THEN
222:
223: IF g_debug THEN
224: hr_utility.set_location('ABS:Processing '||l_proc, 40);
225: hr_utility.trace('ABS:Calling hxc_alias_definitions_api.create_alias_definition procedure.');
226: END IF;
227:
228: l_exists := 'N';
229: hxc_alias_definitions_api.create_alias_definition(p_alias_definition_id => p_alias_definition_id,

Line 229: hxc_alias_definitions_api.create_alias_definition(p_alias_definition_id => p_alias_definition_id,

225: hr_utility.trace('ABS:Calling hxc_alias_definitions_api.create_alias_definition procedure.');
226: END IF;
227:
228: l_exists := 'N';
229: hxc_alias_definitions_api.create_alias_definition(p_alias_definition_id => p_alias_definition_id,
230: p_alias_definition_name => l_alias_definition_name,
231: p_alias_context_code => 'PAYROLL_ELEMENTS',
232: p_timecard_field => NULL,
233: p_object_version_number => p_object_version_number,

Line 240: hr_utility.trace('ABS:End of hxc_alias_definitions_api.create_alias_definition procedure.');

236: p_prompt => 'Hours Type'
237: );
238:
239: IF g_debug THEN
240: hr_utility.trace('ABS:End of hxc_alias_definitions_api.create_alias_definition procedure.');
241: hr_utility.set_location('ABS:Processing '||l_proc, 50);
242: END IF;
243:
244: END;