eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MTI_APP dependencies on GHR_MASS_CHANGES

Line 587: ghr_mass_changes.create_sf52_for_mass_changes

583: --
584: l_sf52_rec.rpa_type := 'MTI';
585: l_sf52_rec.mass_action_id := p_mtin_id;
586: --
587: ghr_mass_changes.create_sf52_for_mass_changes
588: (p_mass_action_type => 'MASS_TRANSFER_IN',
589: p_pa_request_rec => l_sf52_rec,
590: p_errbuf => l_errbuf,
591: p_retcode => l_retcode);

Line 594: hr_utility.set_location('Others error in ghr_mass_changes.create_sf52' ||

590: p_errbuf => l_errbuf,
591: p_retcode => l_retcode);
592: exception
593: when others then
594: hr_utility.set_location('Others error in ghr_mass_changes.create_sf52' ||
595: ' Sql Err is '|| sqlerrm(sqlcode) , 205);
596: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
597: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' SSN: '||l_national_identifier||
598: ' PA Request ID ' || to_char(l_sf52_rec.pa_request_id) ||

Line 597: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' SSN: '||l_national_identifier||

593: when others then
594: hr_utility.set_location('Others error in ghr_mass_changes.create_sf52' ||
595: ' Sql Err is '|| sqlerrm(sqlcode) , 205);
596: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
597: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' SSN: '||l_national_identifier||
598: ' PA Request ID ' || to_char(l_sf52_rec.pa_request_id) ||
599: ' Sql Err is '|| sqlerrm(sqlcode);
600: raise mass_error;
601: end;

Line 604: hr_utility.set_location('Error in ghr_mass_changes.create_sf52 ' ||

600: raise mass_error;
601: end;
602:
603: if l_errbuf is not null then
604: hr_utility.set_location('Error in ghr_mass_changes.create_sf52 ' ||
605: l_errbuf , 215);
606: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
607: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' SSN: '||l_national_identifier||
608: ' PA Request ID ' || to_char(l_sf52_rec.pa_request_id) ||

Line 607: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' SSN: '||l_national_identifier||

603: if l_errbuf is not null then
604: hr_utility.set_location('Error in ghr_mass_changes.create_sf52 ' ||
605: l_errbuf , 215);
606: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
607: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' SSN: '||l_national_identifier||
608: ' PA Request ID ' || to_char(l_sf52_rec.pa_request_id) ||
609: l_errbuf;
610:
611: raise mass_error;

Line 956: p_sf52_rec.academic_discipline := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

952: p_sf52_rec.pa_request_id := null;
953: p_sf52_rec.pa_notification_id := null;
954: p_sf52_rec.noa_family_code := 'APP';
955: p_sf52_rec.routing_group_id := null;
956: p_sf52_rec.academic_discipline := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
957: p_sf52_rec.additional_info_person_id := null;
958: p_sf52_rec.additional_info_tel_number := null;
959: p_sf52_rec.agency_code := null;
960: p_sf52_rec.altered_pa_request_id := null;

Line 962: p_sf52_rec.annuitant_indicator_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

958: p_sf52_rec.additional_info_tel_number := null;
959: p_sf52_rec.agency_code := null;
960: p_sf52_rec.altered_pa_request_id := null;
961: p_sf52_rec.annuitant_indicator := p_annuitant_indicator;
962: p_sf52_rec.annuitant_indicator_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
963: p_sf52_rec.appropriation_code1 := p_appropriation_code1;
964: p_sf52_rec.appropriation_code2 := p_appropriation_code2;
965: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
966: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

Line 965: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

961: p_sf52_rec.annuitant_indicator := p_annuitant_indicator;
962: p_sf52_rec.annuitant_indicator_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
963: p_sf52_rec.appropriation_code1 := p_appropriation_code1;
964: p_sf52_rec.appropriation_code2 := p_appropriation_code2;
965: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
966: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
967: p_sf52_rec.approving_official_work_title := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
968: p_sf52_rec.authorized_by_person_id := null;
969: p_sf52_rec.authorized_by_title := null;

Line 966: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

962: p_sf52_rec.annuitant_indicator_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
963: p_sf52_rec.appropriation_code1 := p_appropriation_code1;
964: p_sf52_rec.appropriation_code2 := p_appropriation_code2;
965: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
966: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
967: p_sf52_rec.approving_official_work_title := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
968: p_sf52_rec.authorized_by_person_id := null;
969: p_sf52_rec.authorized_by_title := null;
970: p_sf52_rec.award_amount := null;

Line 967: p_sf52_rec.approving_official_work_title := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

963: p_sf52_rec.appropriation_code1 := p_appropriation_code1;
964: p_sf52_rec.appropriation_code2 := p_appropriation_code2;
965: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
966: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
967: p_sf52_rec.approving_official_work_title := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
968: p_sf52_rec.authorized_by_person_id := null;
969: p_sf52_rec.authorized_by_title := null;
970: p_sf52_rec.award_amount := null;
971: p_sf52_rec.award_uom := null;

Line 980: p_sf52_rec.education_level := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

976: p_sf52_rec.duty_station_code := p_duty_station_code;
977: p_sf52_rec.duty_station_desc := p_duty_station_desc;
978: p_sf52_rec.duty_station_id := p_duty_station_id;
979: p_sf52_rec.duty_station_location_id := p_duty_station_location_id;
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);

Line 998: p_sf52_rec.first_noa_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

994: p_sf52_rec.first_action_la_desc1 := p_lac_sf52_rec.first_action_la_desc1;
995: p_sf52_rec.first_action_la_desc2 := p_lac_sf52_rec.first_action_la_desc2;
996: p_sf52_rec.first_noa_cancel_or_correct := null;
997: p_sf52_rec.first_noa_code := '132';
998: p_sf52_rec.first_noa_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
999: p_sf52_rec.first_noa_id := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1000: p_sf52_rec.first_noa_pa_request_id := null;
1001: p_sf52_rec.flsa_category := p_flsa_category;
1002: p_sf52_rec.forwarding_address_line1 := null;

Line 999: p_sf52_rec.first_noa_id := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

995: p_sf52_rec.first_action_la_desc2 := p_lac_sf52_rec.first_action_la_desc2;
996: p_sf52_rec.first_noa_cancel_or_correct := null;
997: p_sf52_rec.first_noa_code := '132';
998: p_sf52_rec.first_noa_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
999: p_sf52_rec.first_noa_id := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1000: p_sf52_rec.first_noa_pa_request_id := null;
1001: p_sf52_rec.flsa_category := p_flsa_category;
1002: p_sf52_rec.forwarding_address_line1 := null;
1003: p_sf52_rec.forwarding_address_line2 := null;

Line 1039: p_sf52_rec.personnel_office_id := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

1035: p_sf52_rec.notepad := null;
1036: p_sf52_rec.notification_printed_by := null;
1037: p_sf52_rec.part_time_hours := null;
1038: p_sf52_rec.pay_rate_determinant := p_pay_rate_determinant;
1039: p_sf52_rec.personnel_office_id := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1040: p_sf52_rec.person_id := p_person_id;
1041: p_sf52_rec.position_occupied := p_position_occupied;
1042: p_sf52_rec.proposed_effective_asap_flag := null;
1043: p_sf52_rec.proposed_effective_date := null;

Line 1049: p_sf52_rec.request_number := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

1045: p_sf52_rec.requested_by_title := null;
1046: p_sf52_rec.requested_date := null;
1047: p_sf52_rec.requesting_office_remarks_desc := null;
1048: p_sf52_rec.requesting_office_remarks_flag := null;
1049: p_sf52_rec.request_number := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1050: p_sf52_rec.resign_and_retire_reason_desc := null;
1051: p_sf52_rec.retirement_plan := p_retirement_plan;
1052: p_sf52_rec.retirement_plan_desc := null;
1053: p_sf52_rec.second_action_la_code1 := null;

Line 1100: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?

1096: p_sf52_rec.to_staffing_differential := null;
1097: p_sf52_rec.to_step_or_rate := p_step_or_rate;
1098: p_sf52_rec.to_supervisory_differential := null;
1099: p_sf52_rec.to_total_salary := null;
1100: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1101: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1102: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1103: p_sf52_rec.work_schedule := p_work_schedule;
1104: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

Line 1101: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?

1097: p_sf52_rec.to_step_or_rate := p_step_or_rate;
1098: p_sf52_rec.to_supervisory_differential := null;
1099: p_sf52_rec.to_total_salary := null;
1100: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1101: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1102: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1103: p_sf52_rec.work_schedule := p_work_schedule;
1104: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1105: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

Line 1102: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?

1098: p_sf52_rec.to_supervisory_differential := null;
1099: p_sf52_rec.to_total_salary := null;
1100: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1101: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1102: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1103: p_sf52_rec.work_schedule := p_work_schedule;
1104: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1105: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1106: p_sf52_rec.first_noa_information1 := null;

Line 1104: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

1100: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1101: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1102: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1103: p_sf52_rec.work_schedule := p_work_schedule;
1104: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1105: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1106: p_sf52_rec.first_noa_information1 := null;
1107: p_sf52_rec.first_noa_information2 := null;
1108: p_sf52_rec.first_noa_information3 := null;

Line 1105: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

1101: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1102: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1103: p_sf52_rec.work_schedule := p_work_schedule;
1104: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1105: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1106: p_sf52_rec.first_noa_information1 := null;
1107: p_sf52_rec.first_noa_information2 := null;
1108: p_sf52_rec.first_noa_information3 := null;
1109: p_sf52_rec.first_noa_information4 := null;