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_EHRI_DYNRPT dependencies on GHR_HISTORY_FETCH

Line 129: ghr_history_fetch.fetch_positionei(

125: l_position_type VARCHAR2(150);
126: --
127: BEGIN
128: -- first get the Position Type on Position Group 2
129: ghr_history_fetch.fetch_positionei(
130: p_position_id => p_position_id,
131: p_information_type => 'GHR_US_POS_GRP2',
132: p_date_effective => p_effective_date,
133: p_pos_ei_data => l_pos_ei_grp2_data);

Line 158: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id

154: ,p_org_comp OUT NOCOPY VARCHAR2) IS
155: --
156: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
157: BEGIN
158: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
159: ,p_information_type => 'GHR_US_POS_GRP1'
160: ,p_date_effective => p_effective_date
161: ,p_pos_ei_data => l_pos_ei_grp1_data);
162:

Line 181: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id

177: --
178: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
179: l_appr_code per_position_extra_info.POEI_INFORMATION13%TYPE;
180: BEGIN
181: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
182: ,p_information_type => 'GHR_US_POS_GRP2'
183: ,p_date_effective => p_effective_date
184: ,p_pos_ei_data => l_pos_ei_grp1_data);
185:

Line 595: ghr_history_fetch.fetch_peopleei

591: --
592: IF p_race_ethnic_info IS NULL THEN
593: -- Fetching Race and ethnicity category
594: l_per_ei_grp1_data := NULL;
595: ghr_history_fetch.fetch_peopleei
596: (p_person_id => p_person_id,
597: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
598: p_date_effective => p_effective_date,
599: p_per_ei_data => l_per_ei_grp1_data

Line 616: ghr_history_fetch.fetch_peopleei

612: END IF; -- IF p_race_ethnic_info IS NULL THEN
613:
614: --Incase the SCD's above are NULL then pick values from GHR_US_PER_SCD_INFORMATION
615: -- New EHRI changes Madhuri
616: ghr_history_fetch.fetch_peopleei
617: (p_person_id => p_person_id,
618: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
619: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
620: p_per_ei_data => l_per_ei_grp1_data

Line 650: ghr_history_fetch.fetch_peopleei(

646: -- bug 711711
647: -- if RNO or Handicap code was not filled then get them from HR Person EI
648:
649: IF p_from_retirement_coverage IS NULL THEN
650: ghr_history_fetch.fetch_peopleei(
651: p_person_id => p_person_id,
652: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
653: p_date_effective => p_effective_date,
654: p_per_ei_data => l_per_ei_grp1_data);

Line 660: ghr_history_fetch.fetch_peopleei(

656: p_from_retirement_coverage := l_per_ei_grp1_data.PEI_INFORMATION4;
657: END IF;
658: --
659: IF p_ehri_employee_id IS NULL THEN
660: ghr_history_fetch.fetch_peopleei(
661: p_person_id => p_person_id,
662: p_information_type => 'GHR_US_PER_GROUP1',
663: p_date_effective => p_effective_date,
664: p_per_ei_data => l_per_ei_grp1_data);

Line 677: ghr_history_fetch.fetch_peopleei(

673: -- IF l_race_national_origin IS NULL
674: -- OR l_handicap_code IS NULL THEN
675: --Bug#6158983
676:
677: ghr_history_fetch.fetch_peopleei(
678: p_person_id => p_person_id,
679: p_information_type => 'GHR_US_PER_GROUP1',
680: p_date_effective => p_effective_date,
681: p_per_ei_data => l_per_ei_grp1_data);

Line 825: ghr_history_fetch.fetch_asgei

821: LOOP
822: l_asg_id := get_asg_rec.employee_assignment_id;
823: END LOOP;
824:
825: ghr_history_fetch.fetch_asgei
826: ( p_assignment_id => l_asg_id,
827: p_information_type => 'GHR_US_ASG_NTE_DATES',
828: p_date_effective => p_effective_date,
829: p_asg_ei_data => l_asg_ei_data

Line 931: GHR_HISTORY_FETCH.fetch_asgei_prior_root_sf50(p_assignment_id => p_employee_assignment_id

927: -- This means we wills tive give values for 5__ NOAC's even though the guide says
928: -- they are not needed?
929: --
930: IF p_from_position_id IS NOT NULL THEN
931: GHR_HISTORY_FETCH.fetch_asgei_prior_root_sf50(p_assignment_id => p_employee_assignment_id
932: ,p_information_type => 'GHR_US_ASG_SF52'
933: ,p_altered_pa_request_id => l_pa_request_id
934: ,p_noa_id_corrected => l_noa_id
935: ,p_date_effective => p_effective_date

Line 942: GHR_HISTORY_FETCH.fetch_asgn_prior_root_sf50(p_assignment_id => p_employee_assignment_id

938: p_from_work_schedule := l_asgei_data.aei_information7;
939: p_from_pay_rate_determinant := l_asgei_data.aei_information6;
940: --
941: -- Now lets go get the location id which gives us the duty station
942: GHR_HISTORY_FETCH.fetch_asgn_prior_root_sf50(p_assignment_id => p_employee_assignment_id
943: ,p_altered_pa_request_id => l_pa_request_id
944: ,p_noa_id_corrected => l_noa_id
945: ,p_date_effective => p_effective_date
946: ,p_assignment_data => l_asgn_data);

Line 3996: ghr_history_fetch.fetch_peopleei

3992: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
3993: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
3994:
3995: BEGIN
3996: ghr_history_fetch.fetch_peopleei
3997: (p_person_id => l_ghr_pa_requests_rec.person_id,
3998: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
3999: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4000: p_per_ei_data => ll_per_ei_data

Line 4140: ghr_history_fetch.fetch_peopleei

4136: OR l_ghr_pa_requests_rec.first_noa_code in ('702','703','713','721','781','782','790','800',
4137: '850','855','867','868','891','892','893','895','899')
4138: ) THEN
4139:
4140: ghr_history_fetch.fetch_peopleei
4141: (p_person_id => l_ghr_pa_requests_rec.person_id,
4142: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
4143: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4144: p_per_ei_data => ll_per_ei_data

Line 4150: ghr_history_fetch.fetch_peopleei

4146:
4147: l_ghr_cpdf_temp_rec.creditable_military_service:= ll_per_ei_data.pei_information5;
4148: ll_per_ei_data :=NULL;
4149:
4150: ghr_history_fetch.fetch_peopleei
4151: (p_person_id => l_ghr_pa_requests_rec.person_id,
4152: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
4153: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4154: p_per_ei_data => ll_per_ei_data

Line 4350: ghr_history_fetch.fetch_peopleei

4346:
4347: /*BEGIN
4348: ll_per_ei_data:=NULL;
4349: l_message_name := 'Fetch Retirement System Info';
4350: ghr_history_fetch.fetch_peopleei
4351: (p_person_id => l_ghr_pa_requests_rec.person_id,
4352: p_information_type => 'GHR_US_PER_RETIRMENT_SYS_INFO',
4353: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4354: p_per_ei_data => ll_per_ei_data

Line 4381: ghr_history_fetch.fetch_peopleei

4377: END;
4378:
4379: BEGIN
4380: ll_per_ei_data:=NULL;
4381: ghr_history_fetch.fetch_peopleei
4382: (p_person_id => l_ghr_pa_requests_rec.person_id,
4383: p_information_type => 'GHR_US_PER_BENEFIT_INFO',
4384: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4385: p_per_ei_data => ll_per_ei_data