78: AND paatt.LANGUAGE = userenv('LANG')
79: AND paatt.absence_attendance_type_id = paat.absence_attendance_type_id
80: AND petft.element_type_id = petf.element_type_id
81: AND paat.business_group_id = petf.business_group_id
82: AND paat.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'));
83:
84: IF g_debug THEN
85: hr_utility.set_location('ABS:Processing '||l_proc, 20);
86: END IF;
231: p_alias_context_code => 'PAYROLL_ELEMENTS',
232: p_timecard_field => NULL,
233: p_object_version_number => p_object_version_number,
234: p_alias_type_id => l_alias_type_id,
235: p_business_group_id => fnd_profile.VALUE('PER_BUSINESS_GROUP_ID'),
236: p_prompt => 'Hours Type'
237: );
238:
239: IF g_debug THEN
328: p_alias_definition_id => p_alias_definition_id,
329: p_enabled_flag => 'Y',
330: p_attribute_category => 'PAYROLL_ELEMENTS',
331: p_attribute1 => p_attribute1,
332: p_date_from => to_date(p_date_from,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
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
329: p_enabled_flag => 'Y',
330: p_attribute_category => 'PAYROLL_ELEMENTS',
331: p_attribute1 => p_attribute1,
332: p_date_from => to_date(p_date_from,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
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.');
357: p_alias_definition_id => p_alias_definition_id,
358: p_enabled_flag => 'Y',
359: p_attribute_category => 'PAYROLL_ELEMENTS',
360: p_attribute1 => p_attribute1,
361: p_date_from => to_date(p_date_from,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
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
358: p_enabled_flag => 'Y',
359: p_attribute_category => 'PAYROLL_ELEMENTS',
360: p_attribute1 => p_attribute1,
361: p_date_from => to_date(p_date_from,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
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.');