DBA Data[Home] [Help]

APPS.GHR_MTI_APP dependencies on FND_DATE

Line 277: l_date_of_birth := fnd_date.date_to_canonical(per.DATE_OF_BIRTH);

273:
274: FOR per IN cur_people (p_effective_date,l_person_id) LOOP
275: l_last_name := per.last_name;
276: ---- l_date_of_birth := to_char(per.DATE_OF_BIRTH, 'DD-MON-YYYY');
277: l_date_of_birth := fnd_date.date_to_canonical(per.DATE_OF_BIRTH);
278: l_national_identifier := per.NATIONAL_IDENTIFIER;
279: l_first_name := per.first_name;
280: l_middle_names := per.middle_names;
281: l_full_name := per.full_name;

Line 304: fnd_date.date_to_canonical(per_mt_int.date_arrived_personnel_office);

300: l_step_or_rate := per_mt_int.from_step_or_rate;
301: -- l_date_arr_pers_office :=
302: -- to_char(per_mt_int.date_arrived_personnel_office, 'DD-MON-YYYY');
303: l_date_arr_pers_office :=
304: fnd_date.date_to_canonical(per_mt_int.date_arrived_personnel_office);
305: -- # Bug 711536
306: -- l_date_wgi_due := to_char( per_mt_int.wgi_date_due, 'DD-MON-YYYY');
307: l_date_wgi_due := fnd_date.date_to_canonical( per_mt_int.wgi_date_due);
308: l_non_disc_agmt_status := per_mt_int.non_disclosure_agmt_status;

Line 307: l_date_wgi_due := fnd_date.date_to_canonical( per_mt_int.wgi_date_due);

303: l_date_arr_pers_office :=
304: fnd_date.date_to_canonical(per_mt_int.date_arrived_personnel_office);
305: -- # Bug 711536
306: -- l_date_wgi_due := to_char( per_mt_int.wgi_date_due, 'DD-MON-YYYY');
307: l_date_wgi_due := fnd_date.date_to_canonical( per_mt_int.wgi_date_due);
308: l_non_disc_agmt_status := per_mt_int.non_disclosure_agmt_status;
309: l_previous_retirement_coverage := per_mt_int.previous_retirement_coverage;
310: l_position_working_title := per_mt_int.position_working_title;
311: l_part_time_indicator := per_mt_int.part_time_indicator;

Line 984: p_sf52_rec.employee_date_of_birth := fnd_date.canonical_to_date(p_date_of_birth);

980: p_sf52_rec.education_level := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
981: p_sf52_rec.effective_date := p_effective_date;
982: p_sf52_rec.employee_assignment_id := p_employee_assignment_id;
983: ---p_sf52_rec.employee_date_of_birth := to_date(p_date_of_birth, 'DD-MON-YYYY');
984: p_sf52_rec.employee_date_of_birth := fnd_date.canonical_to_date(p_date_of_birth);
985: p_sf52_rec.employee_dept_or_agency := null;
986: p_sf52_rec.employee_first_name := p_first_name;
987: p_sf52_rec.employee_last_name := p_last_name;
988: p_sf52_rec.employee_middle_names := p_middle_names;