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_VALUES

Line 96: hxc_alias_values hav

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
100: AND hadt.alias_definition_id = l_tc_abs_type_alias_def_id

Line 262: l_alias_value_id hxc_alias_values.alias_value_id%type;

258: p_date_from IN VARCHAR2,
259: p_date_to IN VARCHAR2,
260: p_alias_value_name_exists OUT nocopy VARCHAR2) IS
261:
262: l_alias_value_id hxc_alias_values.alias_value_id%type;
263: l_alias_value_id_ovn hxc_alias_values.object_version_number%type;
264: l_alias_value_name hxc_alias_values.alias_value_name%type;
265:
266: l_proc VARCHAR2(100);

Line 263: l_alias_value_id_ovn hxc_alias_values.object_version_number%type;

259: p_date_to IN VARCHAR2,
260: p_alias_value_name_exists OUT nocopy VARCHAR2) IS
261:
262: l_alias_value_id hxc_alias_values.alias_value_id%type;
263: l_alias_value_id_ovn hxc_alias_values.object_version_number%type;
264: l_alias_value_name hxc_alias_values.alias_value_name%type;
265:
266: l_proc VARCHAR2(100);
267:

Line 264: l_alias_value_name hxc_alias_values.alias_value_name%type;

260: p_alias_value_name_exists OUT nocopy VARCHAR2) IS
261:
262: l_alias_value_id hxc_alias_values.alias_value_id%type;
263: l_alias_value_id_ovn hxc_alias_values.object_version_number%type;
264: l_alias_value_name hxc_alias_values.alias_value_name%type;
265:
266: l_proc VARCHAR2(100);
267:
268: BEGIN

Line 292: FROM hxc_alias_values_tl havt,

288: BEGIN
289:
290: SELECT 'Y'
291: INTO p_alias_value_name_exists
292: FROM hxc_alias_values_tl havt,
293: hxc_alias_values hav
294: WHERE substr(havt.alias_value_name,1,instr(havt.alias_value_name,'(')-2)
295: = substr(l_alias_value_name,1,instr(havt.alias_value_name,'(')-2)
296: AND havt.alias_value_id = hav.alias_value_id

Line 293: hxc_alias_values hav

289:
290: SELECT 'Y'
291: INTO p_alias_value_name_exists
292: FROM hxc_alias_values_tl havt,
293: hxc_alias_values hav
294: WHERE substr(havt.alias_value_name,1,instr(havt.alias_value_name,'(')-2)
295: = substr(l_alias_value_name,1,instr(havt.alias_value_name,'(')-2)
296: AND havt.alias_value_id = hav.alias_value_id
297: AND hav.alias_definition_id = p_alias_definition_id

Line 311: FROM hxc_alias_values_tl havt,

307: SELECT hav.alias_value_id,
308: hav.object_version_number
309: INTO l_alias_value_id,
310: l_alias_value_id_ovn
311: FROM hxc_alias_values_tl havt,
312: hxc_alias_values hav
313: WHERE substr(havt.alias_value_name,1,instr(havt.alias_value_name,'(')-2)
314: = substr(l_alias_value_name,1,instr(havt.alias_value_name,'(')-2)
315: AND havt.alias_value_id = hav.alias_value_id

Line 312: hxc_alias_values hav

308: hav.object_version_number
309: INTO l_alias_value_id,
310: l_alias_value_id_ovn
311: FROM hxc_alias_values_tl havt,
312: hxc_alias_values hav
313: WHERE substr(havt.alias_value_name,1,instr(havt.alias_value_name,'(')-2)
314: = substr(l_alias_value_name,1,instr(havt.alias_value_name,'(')-2)
315: AND havt.alias_value_id = hav.alias_value_id
316: AND hav.alias_definition_id = p_alias_definition_id

Line 323: hr_utility.trace('ABS:Calling hxc_alias_values_api.update_alias_value procedure.');

319: IF g_debug THEN
320: hr_utility.set_location('ABS:Processing '||l_proc, 30);
321: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
322: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
323: hr_utility.trace('ABS:Calling hxc_alias_values_api.update_alias_value procedure.');
324: END IF;
325:
326: hxc_alias_values_api.update_alias_value(p_alias_value_id => l_alias_value_id,
327: p_alias_value_name => l_alias_value_name,

Line 326: hxc_alias_values_api.update_alias_value(p_alias_value_id => l_alias_value_id,

322: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
323: hr_utility.trace('ABS:Calling hxc_alias_values_api.update_alias_value procedure.');
324: END IF;
325:
326: hxc_alias_values_api.update_alias_value(p_alias_value_id => l_alias_value_id,
327: p_alias_value_name => l_alias_value_name,
328: p_alias_definition_id => p_alias_definition_id,
329: p_enabled_flag => 'Y',
330: p_attribute_category => 'PAYROLL_ELEMENTS',

Line 337: hr_utility.trace('ABS:End of hxc_alias_values_api.update_alias_value procedure.');

333: p_date_to => to_date(p_date_to,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
334: p_object_version_number => l_alias_value_id_ovn);
335:
336: IF g_debug THEN
337: hr_utility.trace('ABS:End of hxc_alias_values_api.update_alias_value procedure.');
338: hr_utility.set_location('ABS:Processing '||l_proc, 40);
339: END IF;
340:
341:

Line 352: hr_utility.trace('ABS:Calling hxc_alias_values_api.create_alias_value procedure.');

348: IF g_debug THEN
349: hr_utility.set_location('ABS:Processing '||l_proc, 50);
350: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
351: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
352: hr_utility.trace('ABS:Calling hxc_alias_values_api.create_alias_value procedure.');
353: END IF;
354:
355: hxc_alias_values_api.create_alias_value(p_alias_value_id => l_alias_value_id,
356: p_alias_value_name => l_alias_value_name,

Line 355: hxc_alias_values_api.create_alias_value(p_alias_value_id => l_alias_value_id,

351: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
352: hr_utility.trace('ABS:Calling hxc_alias_values_api.create_alias_value procedure.');
353: END IF;
354:
355: hxc_alias_values_api.create_alias_value(p_alias_value_id => l_alias_value_id,
356: p_alias_value_name => l_alias_value_name,
357: p_alias_definition_id => p_alias_definition_id,
358: p_enabled_flag => 'Y',
359: p_attribute_category => 'PAYROLL_ELEMENTS',

Line 366: hr_utility.trace('ABS:End of hxc_alias_values_api.create_alias_value procedure.');

362: p_date_to => to_date(p_date_to,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
363: p_object_version_number => l_alias_value_id_ovn);
364:
365: IF g_debug THEN
366: hr_utility.trace('ABS:End of hxc_alias_values_api.create_alias_value procedure.');
367: hr_utility.set_location('ABS:Processing '||l_proc, 60);
368: END IF;
369:
370: END;