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 128: ghr_history_fetch.fetch_positionei(

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

Line 156: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id

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

Line 179: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id

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

Line 591: ghr_history_fetch.fetch_peopleei

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

Line 612: ghr_history_fetch.fetch_peopleei

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

Line 646: ghr_history_fetch.fetch_peopleei(

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

Line 656: ghr_history_fetch.fetch_peopleei(

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

Line 673: ghr_history_fetch.fetch_peopleei(

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

Line 821: ghr_history_fetch.fetch_asgei

817: LOOP
818: l_asg_id := get_asg_rec.employee_assignment_id;
819: END LOOP;
820:
821: ghr_history_fetch.fetch_asgei
822: ( p_assignment_id => l_asg_id,
823: p_information_type => 'GHR_US_ASG_NTE_DATES',
824: p_date_effective => p_effective_date,
825: p_asg_ei_data => l_asg_ei_data

Line 886: GHR_HISTORY_FETCH.fetch_asgei_prior_root_sf50(p_assignment_id => p_employee_assignment_id

882: -- This means we wills tive give values for 5__ NOAC's even though the guide says
883: -- they are not needed?
884: --
885: IF p_from_position_id IS NOT NULL THEN
886: GHR_HISTORY_FETCH.fetch_asgei_prior_root_sf50(p_assignment_id => p_employee_assignment_id
887: ,p_information_type => 'GHR_US_ASG_SF52'
888: ,p_altered_pa_request_id => l_pa_request_id
889: ,p_noa_id_corrected => l_noa_id
890: ,p_date_effective => p_effective_date

Line 897: GHR_HISTORY_FETCH.fetch_asgn_prior_root_sf50(p_assignment_id => p_employee_assignment_id

893: p_from_work_schedule := l_asgei_data.aei_information7;
894: p_from_pay_rate_determinant := l_asgei_data.aei_information6;
895: --
896: -- Now lets go get the location id which gives us the duty station
897: GHR_HISTORY_FETCH.fetch_asgn_prior_root_sf50(p_assignment_id => p_employee_assignment_id
898: ,p_altered_pa_request_id => l_pa_request_id
899: ,p_noa_id_corrected => l_noa_id
900: ,p_date_effective => p_effective_date
901: ,p_assignment_data => l_asgn_data);

Line 3724: ghr_history_fetch.fetch_peopleei

3720: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
3721: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
3722:
3723: BEGIN
3724: ghr_history_fetch.fetch_peopleei
3725: (p_person_id => l_ghr_pa_requests_rec.person_id,
3726: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
3727: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
3728: p_per_ei_data => ll_per_ei_data

Line 3864: ghr_history_fetch.fetch_peopleei

3860: OR l_ghr_pa_requests_rec.first_noa_code in ('702','703','713','721','781','782','790','800',
3861: '850','855','867','868','891','892','893','895','899')
3862: ) THEN
3863:
3864: ghr_history_fetch.fetch_peopleei
3865: (p_person_id => l_ghr_pa_requests_rec.person_id,
3866: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
3867: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
3868: p_per_ei_data => ll_per_ei_data

Line 3874: ghr_history_fetch.fetch_peopleei

3870:
3871: l_ghr_cpdf_temp_rec.creditable_military_service:= ll_per_ei_data.pei_information5;
3872: ll_per_ei_data :=NULL;
3873:
3874: ghr_history_fetch.fetch_peopleei
3875: (p_person_id => l_ghr_pa_requests_rec.person_id,
3876: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
3877: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
3878: p_per_ei_data => ll_per_ei_data

Line 4061: ghr_history_fetch.fetch_peopleei

4057:
4058: /*BEGIN
4059: ll_per_ei_data:=NULL;
4060: l_message_name := 'Fetch Retirement System Info';
4061: ghr_history_fetch.fetch_peopleei
4062: (p_person_id => l_ghr_pa_requests_rec.person_id,
4063: p_information_type => 'GHR_US_PER_RETIRMENT_SYS_INFO',
4064: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4065: p_per_ei_data => ll_per_ei_data

Line 4092: ghr_history_fetch.fetch_peopleei

4088: END;
4089:
4090: BEGIN
4091: ll_per_ei_data:=NULL;
4092: ghr_history_fetch.fetch_peopleei
4093: (p_person_id => l_ghr_pa_requests_rec.person_id,
4094: p_information_type => 'GHR_US_PER_BENEFIT_INFO',
4095: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4096: p_per_ei_data => ll_per_ei_data