DBA Data[Home] [Help]

APPS.GHR_MTI_INT_INSERT dependencies on FND_DATE

Line 476: l_people_ei3_rec.PEI_INFORMATION3 := fnd_date.date_to_canonical(p_service_comp_date);

472: l_people_ei3_rec.person_id := p_person_id;
473: l_people_ei3_rec.INFORMATION_TYPE := 'GHR_US_PER_SCD_INFORMATION';
474: l_people_ei3_rec.PEI_INFORMATION_CATEGORY := 'GHR_US_PER_SCD_INFORMATION';
475: ----l_people_ei3_rec.PEI_INFORMATION3 := to_char(p_service_comp_date, 'DD-MON-YYYY');
476: l_people_ei3_rec.PEI_INFORMATION3 := fnd_date.date_to_canonical(p_service_comp_date);
477:
478: if p_action = 'INSERT' then
479: ghr_mto_int.insert_people_ei
480: ( p_transfer_name => p_transfer_name,

Line 664: l_ghr_mt_ele_rec.wgi_date_due := fnd_date.date_to_canonical(p_wgi_date_due);

660: l_ghr_mt_ele_rec.retention_allowance := p_retention_allowance;
661: l_ghr_mt_ele_rec.staffing_differential := p_staffing_differential;
662: l_ghr_mt_ele_rec.supervisory_differential := p_supervisory_differential;
663: -- l_ghr_mt_ele_rec.wgi_date_due := to_char(p_wgi_date_due, 'DD-MON-YYYY');
664: l_ghr_mt_ele_rec.wgi_date_due := fnd_date.date_to_canonical(p_wgi_date_due);
665: l_ghr_mt_ele_rec.fegli_meaning := p_fegli_desc;
666: l_ghr_mt_ele_rec.retirement_plan_meaning := p_retirement_plan_desc;
667: l_ghr_mt_ele_rec.auo_amount := p_au_overtime;
668: -- Bug#4151183 Assigned wrong values to AUO Prem. Pay Ind and AP Amount. Assigned Correct values now.

Line 794: l_assign_ei2_rec.AEI_INFORMATION3 := fnd_date.date_to_canonical(p_date_arrivd_personnel_office);

790: begin
791: l_assign_ei2_rec.INFORMATION_TYPE := 'GHR_US_ASG_NON_SF52';
792: l_assign_ei2_rec.AEI_INFORMATION_CATEGORY := 'GHR_US_ASG_NON_SF52';
793: -- l_assign_ei2_rec.AEI_INFORMATION3 := to_char(p_date_arrivd_personnel_office, 'DD-MON-YYYY');
794: l_assign_ei2_rec.AEI_INFORMATION3 := fnd_date.date_to_canonical(p_date_arrivd_personnel_office);
795: l_assign_ei2_rec.AEI_INFORMATION6 := p_non_disclosure_agmt_status;
796: l_assign_ei2_rec.AEI_INFORMATION8 := p_part_time_indicator;
797: l_assign_ei2_rec.AEI_INFORMATION9 := p_qualif_standards_waiver;
798:

Line 829: l_assign_ei3_rec.AEI_INFORMATION3 := fnd_date.date_to_canonical(p_assignment_nte_start_date);

825:
826: begin
827: l_assign_ei3_rec.INFORMATION_TYPE := 'GHR_US_ASG_NTE_DATES';
828: l_assign_ei3_rec.AEI_INFORMATION_CATEGORY := 'GHR_US_ASG_NTE_DATES';
829: l_assign_ei3_rec.AEI_INFORMATION3 := fnd_date.date_to_canonical(p_assignment_nte_start_date);
830: l_assign_ei3_rec.AEI_INFORMATION4 := fnd_date.date_to_canonical(p_assignment_nte);
831:
832: if p_action = 'INSERT' then
833: l_assign_ei3_rec.ASSIGNMENT_ID := p_person_id;

Line 830: l_assign_ei3_rec.AEI_INFORMATION4 := fnd_date.date_to_canonical(p_assignment_nte);

826: begin
827: l_assign_ei3_rec.INFORMATION_TYPE := 'GHR_US_ASG_NTE_DATES';
828: l_assign_ei3_rec.AEI_INFORMATION_CATEGORY := 'GHR_US_ASG_NTE_DATES';
829: l_assign_ei3_rec.AEI_INFORMATION3 := fnd_date.date_to_canonical(p_assignment_nte_start_date);
830: l_assign_ei3_rec.AEI_INFORMATION4 := fnd_date.date_to_canonical(p_assignment_nte);
831:
832: if p_action = 'INSERT' then
833: l_assign_ei3_rec.ASSIGNMENT_ID := p_person_id;
834: ghr_mto_int.insert_assignment_ei