DBA Data[Home] [Help]

APPS.GHR_MTI_APP dependencies on FND_DATE

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

305:
306: FOR per IN cur_people (p_effective_date,l_person_id) LOOP
307: l_last_name := per.last_name;
308: ---- l_date_of_birth := to_char(per.DATE_OF_BIRTH, 'DD-MON-YYYY');
309: l_date_of_birth := fnd_date.date_to_canonical(per.DATE_OF_BIRTH);
310: l_national_identifier := per.NATIONAL_IDENTIFIER;
311: l_first_name := per.first_name;
312: l_middle_names := per.middle_names;
313: l_full_name := per.full_name;

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

334: l_step_or_rate := per_mt_int.from_step_or_rate;
335: -- l_date_arr_pers_office :=
336: -- to_char(per_mt_int.date_arrived_personnel_office, 'DD-MON-YYYY');
337: l_date_arr_pers_office :=
338: fnd_date.date_to_canonical(per_mt_int.date_arrived_personnel_office);
339: -- # Bug 711536
340: -- l_date_wgi_due := to_char( per_mt_int.wgi_date_due, 'DD-MON-YYYY');
341: l_date_wgi_due := fnd_date.date_to_canonical( per_mt_int.wgi_date_due);
342: l_non_disc_agmt_status := per_mt_int.non_disclosure_agmt_status;

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

337: l_date_arr_pers_office :=
338: fnd_date.date_to_canonical(per_mt_int.date_arrived_personnel_office);
339: -- # Bug 711536
340: -- l_date_wgi_due := to_char( per_mt_int.wgi_date_due, 'DD-MON-YYYY');
341: l_date_wgi_due := fnd_date.date_to_canonical( per_mt_int.wgi_date_due);
342: l_non_disc_agmt_status := per_mt_int.non_disclosure_agmt_status;
343: l_previous_retirement_coverage := per_mt_int.previous_retirement_coverage;
344: l_position_working_title := per_mt_int.position_working_title;
345: l_part_time_indicator := per_mt_int.part_time_indicator;

Line 390: l_assignment_nte_start_date := fnd_date.date_to_canonical(per_mt_int.assignment_nte_start_date);

386: -- End Changes 4093771
387: --Begin Bug# 8724192
388: l_orig_appt_auth_code_1_desc := per_mt_int.orig_appt_auth_code_1_desc;
389: l_orig_appt_auth_code_2_desc := per_mt_int.orig_appt_auth_code_2_desc;
390: l_assignment_nte_start_date := fnd_date.date_to_canonical(per_mt_int.assignment_nte_start_date);
391: l_assignment_nte := fnd_date.date_to_canonical(per_mt_int.assignment_nte);
392: --End Bug# 8724192
393: exit;
394: end loop;

Line 391: l_assignment_nte := fnd_date.date_to_canonical(per_mt_int.assignment_nte);

387: --Begin Bug# 8724192
388: l_orig_appt_auth_code_1_desc := per_mt_int.orig_appt_auth_code_1_desc;
389: l_orig_appt_auth_code_2_desc := per_mt_int.orig_appt_auth_code_2_desc;
390: l_assignment_nte_start_date := fnd_date.date_to_canonical(per_mt_int.assignment_nte_start_date);
391: l_assignment_nte := fnd_date.date_to_canonical(per_mt_int.assignment_nte);
392: --End Bug# 8724192
393: exit;
394: end loop;
395:

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

1093: p_sf52_rec.education_level := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1094: p_sf52_rec.effective_date := p_effective_date;
1095: p_sf52_rec.employee_assignment_id := p_employee_assignment_id;
1096: ---p_sf52_rec.employee_date_of_birth := to_date(p_date_of_birth, 'DD-MON-YYYY');
1097: p_sf52_rec.employee_date_of_birth := fnd_date.canonical_to_date(p_date_of_birth);
1098: p_sf52_rec.employee_dept_or_agency := null;
1099: p_sf52_rec.employee_first_name := p_first_name;
1100: p_sf52_rec.employee_last_name := p_last_name;
1101: p_sf52_rec.employee_middle_names := p_middle_names;