APPS.PER_ES_ABSENCE dependencies on FND_DATE

Line 129: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date

125: ,p_business_group_id => p_business_group_id
126: ,p_element_entry_id => l_element_entry_id
127: ,p_object_version_number => l_ovn
128: ,p_input_value_id1 => l_start_date_iv_id
129: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
130: ,p_input_value_id2 => l_end_date_iv_id
131: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
132: ,p_input_value_id3 => l_absence_id
133: ,p_entry_value3 => p_absence_attendance_id

Line 131: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date

127: ,p_object_version_number => l_ovn
128: ,p_input_value_id1 => l_start_date_iv_id
129: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
130: ,p_input_value_id2 => l_end_date_iv_id
131: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
132: ,p_input_value_id3 => l_absence_id
133: ,p_entry_value3 => p_absence_attendance_id
134: ,p_input_value_id4 => l_ptm_percentage_iv_id
135: ,p_entry_value4 => p_abs_information3

Line 149: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date

145: ,p_business_group_id => p_business_group_id
146: ,p_element_entry_id => l_element_entry_id
147: ,p_object_version_number => l_ovn
148: ,p_input_value_id1 => l_start_date_iv_id
149: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
150: ,p_input_value_id2 => l_end_date_iv_id
151: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
152: ,p_input_value_id3 => l_absence_id
153: ,p_entry_value3 => p_absence_attendance_id

Line 151: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date

147: ,p_object_version_number => l_ovn
148: ,p_input_value_id1 => l_start_date_iv_id
149: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
150: ,p_input_value_id2 => l_end_date_iv_id
151: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
152: ,p_input_value_id3 => l_absence_id
153: ,p_entry_value3 => p_absence_attendance_id
154: ,p_effective_start_date => l_o_start_dt
155: ,p_effective_end_date => l_o_end_dt

Line 298: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date

294: ,p_business_group_id => l_bus_grp_id
295: ,p_element_entry_id => l_element_entry_id
296: ,p_object_version_number => l_ovn
297: ,p_input_value_id1 => l_start_date_iv_id
298: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
299: ,p_input_value_id2 => l_end_date_iv_id
300: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
301: ,p_input_value_id3 => l_absence_type_iv_id
302: ,p_entry_value3 => p_absence_attendance_id

Line 300: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date

296: ,p_object_version_number => l_ovn
297: ,p_input_value_id1 => l_start_date_iv_id
298: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
299: ,p_input_value_id2 => l_end_date_iv_id
300: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
301: ,p_input_value_id3 => l_absence_type_iv_id
302: ,p_entry_value3 => p_absence_attendance_id
303: ,p_input_value_id4 => l_ptm_percentage_iv_id
304: ,p_entry_value4 => p_abs_information3

Line 317: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date

313: ,p_business_group_id => l_bus_grp_id
314: ,p_element_entry_id => l_element_entry_id
315: ,p_object_version_number => l_ovn
316: ,p_input_value_id1 => l_start_date_iv_id
317: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
318: ,p_input_value_id2 => l_end_date_iv_id
319: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
320: ,p_input_value_id3 => l_absence_type_iv_id
321: ,p_entry_value3 => p_absence_attendance_id

Line 319: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date

315: ,p_object_version_number => l_ovn
316: ,p_input_value_id1 => l_start_date_iv_id
317: ,p_entry_value1 => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
318: ,p_input_value_id2 => l_end_date_iv_id
319: ,p_entry_value2 => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
320: ,p_input_value_id3 => l_absence_type_iv_id
321: ,p_entry_value3 => p_absence_attendance_id
322: ,p_effective_start_date => l_o_start_dt
323: ,p_effective_end_date => l_o_end_dt

Line 409: fnd_profile.put('HR_FR_ABSENCE_START_DATE',fnd_date.date_to_canonical(p_date_start));

405: --
406: -- get the values of the person_id profile
407: fnd_profile.put('HR_FR_PERSON_ID',p_person_id);
408: -- get the value of the absence_start_date
409: fnd_profile.put('HR_FR_ABSENCE_START_DATE',fnd_date.date_to_canonical(p_date_start));
410: --
411: --IF p_date_start IS NOT NULL THEN
412: --
413: OPEN csr_get_absence_category(p_absence_attendance_type_id);

Line 665: fnd_profile.put('HR_FR_ABSENCE_START_DATE',fnd_date.date_to_canonical(p_date_start));

661:
662: -- get the values of the person_id profile
663: fnd_profile.put('HR_FR_PERSON_ID',l_person_id);
664: -- get the value of the absence_start_date
665: fnd_profile.put('HR_FR_ABSENCE_START_DATE',fnd_date.date_to_canonical(p_date_start));
666: --
667: --IF p_date_start IS NOT NULL THEN
668: --
669: OPEN csr_get_absence_category(p_absence_attendance_id);