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 630: ghr_mass_changes.create_sf52_for_mass_changes

626: --
627: l_sf52_rec.rpa_type := 'MTI';
628: l_sf52_rec.mass_action_id := p_mtin_id;
629: --
630: ghr_mass_changes.create_sf52_for_mass_changes
631: (p_mass_action_type => 'MASS_TRANSFER_IN',
632: p_pa_request_rec => l_sf52_rec,
633: p_errbuf => l_errbuf,
634: p_retcode => l_retcode);

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

633: p_errbuf => l_errbuf,
634: p_retcode => l_retcode);
635: exception
636: when others then
637: hr_utility.set_location('Others error in ghr_mass_changes.create_sf52' ||
638: ' Sql Err is '|| sqlerrm(sqlcode) , 205);
639: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
640: --Bug # 9329643 Modified SSN to Emp No
641: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' Emp No: '||l_employee_number||

Line 641: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' Emp No: '||l_employee_number||

637: hr_utility.set_location('Others error in ghr_mass_changes.create_sf52' ||
638: ' Sql Err is '|| sqlerrm(sqlcode) , 205);
639: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
640: --Bug # 9329643 Modified SSN to Emp No
641: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' Emp No: '||l_employee_number||
642: ' PA Request ID ' || to_char(l_sf52_rec.pa_request_id) ||
643: ' Sql Err is '|| sqlerrm(sqlcode);
644: raise mass_error;
645: end;

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

644: raise mass_error;
645: end;
646:
647: if l_errbuf is not null then
648: hr_utility.set_location('Error in ghr_mass_changes.create_sf52 ' ||
649: l_errbuf , 215);
650: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
651: --Bug # 9329643 Modified SSN to Emp No
652: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' Emp No: '||l_employee_number||

Line 652: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' Emp No: '||l_employee_number||

648: hr_utility.set_location('Error in ghr_mass_changes.create_sf52 ' ||
649: l_errbuf , 215);
650: -- Bug#3718167 Added full Name, SSN in l_mass_errbuf
651: --Bug # 9329643 Modified SSN to Emp No
652: l_mass_errbuf := 'Error in ghr_mass_changes.create_sf52 for '||l_full_name||' Emp No: '||l_employee_number||
653: ' PA Request ID ' || to_char(l_sf52_rec.pa_request_id) ||
654: l_errbuf;
655:
656: raise mass_error;

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

1065: p_sf52_rec.pa_request_id := null;
1066: p_sf52_rec.pa_notification_id := null;
1067: p_sf52_rec.noa_family_code := 'APP';
1068: p_sf52_rec.routing_group_id := null;
1069: p_sf52_rec.academic_discipline := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1070: p_sf52_rec.additional_info_person_id := null;
1071: p_sf52_rec.additional_info_tel_number := null;
1072: p_sf52_rec.agency_code := null;
1073: p_sf52_rec.altered_pa_request_id := null;

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

1071: p_sf52_rec.additional_info_tel_number := null;
1072: p_sf52_rec.agency_code := null;
1073: p_sf52_rec.altered_pa_request_id := null;
1074: p_sf52_rec.annuitant_indicator := p_annuitant_indicator;
1075: p_sf52_rec.annuitant_indicator_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1076: p_sf52_rec.appropriation_code1 := p_appropriation_code1;
1077: p_sf52_rec.appropriation_code2 := p_appropriation_code2;
1078: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1079: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

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

1074: p_sf52_rec.annuitant_indicator := p_annuitant_indicator;
1075: p_sf52_rec.annuitant_indicator_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1076: p_sf52_rec.appropriation_code1 := p_appropriation_code1;
1077: p_sf52_rec.appropriation_code2 := p_appropriation_code2;
1078: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1079: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1080: p_sf52_rec.approving_official_work_title := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1081: p_sf52_rec.authorized_by_person_id := null;
1082: p_sf52_rec.authorized_by_title := null;

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

1075: p_sf52_rec.annuitant_indicator_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1076: p_sf52_rec.appropriation_code1 := p_appropriation_code1;
1077: p_sf52_rec.appropriation_code2 := p_appropriation_code2;
1078: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1079: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1080: p_sf52_rec.approving_official_work_title := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1081: p_sf52_rec.authorized_by_person_id := null;
1082: p_sf52_rec.authorized_by_title := null;
1083: p_sf52_rec.award_amount := null;

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

1076: p_sf52_rec.appropriation_code1 := p_appropriation_code1;
1077: p_sf52_rec.appropriation_code2 := p_appropriation_code2;
1078: p_sf52_rec.approval_date := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1079: p_sf52_rec.approving_official_full_name := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1080: p_sf52_rec.approving_official_work_title := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1081: p_sf52_rec.authorized_by_person_id := null;
1082: p_sf52_rec.authorized_by_title := null;
1083: p_sf52_rec.award_amount := null;
1084: p_sf52_rec.award_uom := null;

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

1089: p_sf52_rec.duty_station_code := p_duty_station_code;
1090: p_sf52_rec.duty_station_desc := p_duty_station_desc;
1091: p_sf52_rec.duty_station_id := p_duty_station_id;
1092: p_sf52_rec.duty_station_location_id := p_duty_station_location_id;
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);

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

1107: p_sf52_rec.first_action_la_desc1 := p_lac_sf52_rec.first_action_la_desc1;
1108: p_sf52_rec.first_action_la_desc2 := p_lac_sf52_rec.first_action_la_desc2;
1109: p_sf52_rec.first_noa_cancel_or_correct := null;
1110: p_sf52_rec.first_noa_code := '132';
1111: p_sf52_rec.first_noa_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1112: p_sf52_rec.first_noa_id := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1113: p_sf52_rec.first_noa_pa_request_id := null;
1114: p_sf52_rec.flsa_category := p_flsa_category;
1115: p_sf52_rec.forwarding_address_line1 := null;

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

1108: p_sf52_rec.first_action_la_desc2 := p_lac_sf52_rec.first_action_la_desc2;
1109: p_sf52_rec.first_noa_cancel_or_correct := null;
1110: p_sf52_rec.first_noa_code := '132';
1111: p_sf52_rec.first_noa_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1112: p_sf52_rec.first_noa_id := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1113: p_sf52_rec.first_noa_pa_request_id := null;
1114: p_sf52_rec.flsa_category := p_flsa_category;
1115: p_sf52_rec.forwarding_address_line1 := null;
1116: p_sf52_rec.forwarding_address_line2 := null;

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

1148: p_sf52_rec.notepad := null;
1149: p_sf52_rec.notification_printed_by := null;
1150: p_sf52_rec.part_time_hours := null;
1151: p_sf52_rec.pay_rate_determinant := p_pay_rate_determinant;
1152: p_sf52_rec.personnel_office_id := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1153: p_sf52_rec.person_id := p_person_id;
1154: p_sf52_rec.position_occupied := p_position_occupied;
1155: p_sf52_rec.proposed_effective_asap_flag := null;
1156: p_sf52_rec.proposed_effective_date := null;

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

1158: p_sf52_rec.requested_by_title := null;
1159: p_sf52_rec.requested_date := null;
1160: p_sf52_rec.requesting_office_remarks_desc := null;
1161: p_sf52_rec.requesting_office_remarks_flag := null;
1162: p_sf52_rec.request_number := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1163: p_sf52_rec.resign_and_retire_reason_desc := null;
1164: p_sf52_rec.retirement_plan := p_retirement_plan;
1165: p_sf52_rec.retirement_plan_desc := null;
1166: p_sf52_rec.second_action_la_code1 := null;

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

1209: p_sf52_rec.to_staffing_differential := null;
1210: p_sf52_rec.to_step_or_rate := p_step_or_rate;
1211: p_sf52_rec.to_supervisory_differential := null;
1212: p_sf52_rec.to_total_salary := null;
1213: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1214: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1215: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1216: p_sf52_rec.work_schedule := p_work_schedule;
1217: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

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

1210: p_sf52_rec.to_step_or_rate := p_step_or_rate;
1211: p_sf52_rec.to_supervisory_differential := null;
1212: p_sf52_rec.to_total_salary := null;
1213: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1214: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1215: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1216: p_sf52_rec.work_schedule := p_work_schedule;
1217: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1218: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES

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

1211: p_sf52_rec.to_supervisory_differential := null;
1212: p_sf52_rec.to_total_salary := null;
1213: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1214: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1215: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1216: p_sf52_rec.work_schedule := p_work_schedule;
1217: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1218: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1219: p_sf52_rec.first_noa_information1 := null;

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

1213: p_sf52_rec.veterans_preference := p_veterans_preference; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1214: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1215: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1216: p_sf52_rec.work_schedule := p_work_schedule;
1217: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1218: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1219: p_sf52_rec.first_noa_information1 := null;
1220: p_sf52_rec.first_noa_information2 := null;
1221: p_sf52_rec.first_noa_information3 := null;

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

1214: p_sf52_rec.veterans_pref_for_rif := p_vet_preference_for_rif; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1215: p_sf52_rec.veterans_status := p_veterans_status; -- Re-populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES?
1216: p_sf52_rec.work_schedule := p_work_schedule;
1217: p_sf52_rec.work_schedule_desc := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1218: p_sf52_rec.year_degree_attained := null; -- Populated in GHR_MASS_CHANGES.CREATE_SF52_FOR_MASS_CHANGES
1219: p_sf52_rec.first_noa_information1 := null;
1220: p_sf52_rec.first_noa_information2 := null;
1221: p_sf52_rec.first_noa_information3 := null;
1222: p_sf52_rec.first_noa_information4 := null;