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

Line 297: ghr_history_fetch.fetch_positionei(

293: l_pos_psi_data per_position_extra_info%rowtype;
294: l_personnel_system_indicator VARCHAR2(30);
295: BEGIN
296: hr_utility.set_location('Entering get_psi',0);
297: ghr_history_fetch.fetch_positionei(
298: p_position_id => p_position_id,
299: p_information_type => 'GHR_US_POS_AFHR_DATA',
300: p_date_effective => p_effective_date,
301: p_pos_ei_data => l_pos_psi_data);

Line 720: -- call to ghr_history_fetch.fetch_peopleei

716: ,p_scd_leave OUT NOCOPY varchar2) IS
717:
718:
719: -- Bug No 550117 Need seperate variable to store what is returned by the second
720: -- call to ghr_history_fetch.fetch_peopleei
721:
722: l_per_ei_data per_people_extra_info%rowtype;
723: l_per_ei_scd_data per_people_extra_info%rowtype;
724:

Line 727: ghr_history_fetch.fetch_peopleei(

723: l_per_ei_scd_data per_people_extra_info%rowtype;
724:
725: BEGIN
726:
727: ghr_history_fetch.fetch_peopleei(
728: p_person_id => p_person_id,
729: p_information_type => 'GHR_US_PER_SF52',
730: p_date_effective => p_date_effective,
731: p_per_ei_data => l_per_ei_data);

Line 740: ghr_history_fetch.fetch_peopleei(

736: p_veterans_pref_for_rif := l_per_ei_data.pei_information5;
737: p_veterans_status := l_per_ei_data.pei_information6;
738: end if;
739:
740: ghr_history_fetch.fetch_peopleei(
741: p_person_id => p_person_id,
742: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
743: p_date_effective => p_date_effective,
744: p_per_ei_data => l_per_ei_scd_data);

Line 775: ghr_history_fetch.fetch_asgei (

771:
772: l_asgei_data per_assignment_extra_info%rowtype;
773:
774: BEGIN
775: ghr_history_fetch.fetch_asgei (
776: p_assignment_id => p_assignment_id,
777: p_information_type => 'GHR_US_ASG_SF52',
778: p_date_effective => p_date_effective,
779: p_asg_ei_data => l_asgei_data) ;

Line 833: ghr_history_fetch.fetch_positionei(

829: --l_dummy_posei per_position_extra_info%rowtype;
830:
831: BEGIN
832:
833: ghr_history_fetch.fetch_positionei(
834: p_position_id => p_position_id,
835: p_information_type => 'GHR_US_POS_GRP1',
836: p_date_effective => p_date_effective,
837: p_pos_ei_data => l_pos_ei_grp1_data);

Line 850: ghr_history_fetch.fetch_positionei(

846: p_supervisory_status := l_pos_ei_grp1_data.poei_information16;
847: p_part_time_hours := l_pos_ei_grp1_data.poei_information23;
848: end if;
849:
850: ghr_history_fetch.fetch_positionei(
851: p_position_id => p_position_id,
852: p_information_type => 'GHR_US_POS_GRP2',
853: p_date_effective => p_date_effective,
854: p_pos_ei_data => l_pos_ei_grp2_data);

Line 1077: ghr_history_fetch.fetch_positionei(

1073: p_location_id := cur_pos_ids_rec.location_id;
1074: END LOOP;
1075: --
1076: -- Retive the Grade info and pay basis from the POI history table
1077: ghr_history_fetch.fetch_positionei(
1078: p_position_id => p_position_id,
1079: p_information_type => 'GHR_US_POS_VALID_GRADE',
1080: p_date_effective => p_effective_date,
1081: p_pos_ei_data => l_pos_ei_grade_data);

Line 1126: ghr_history_fetch.fetch_positionei(

1122: -- Retrieve the location details
1123: --
1124: --
1125: -- Retive the Grade info and pay basis from the POI history table
1126: ghr_history_fetch.fetch_positionei(
1127: p_position_id => p_position_id,
1128: p_information_type => 'GHR_US_POS_GRP1',
1129: p_date_effective => p_effective_date,
1130: p_pos_ei_data => l_pos_ei_grp1_data);

Line 1936: ghr_history_fetch.fetch_positionei

1932: BEGIN
1933:
1934: hr_utility.set_location('Entering ' || l_proc,5);
1935:
1936: ghr_history_fetch.fetch_positionei
1937: (p_position_id => p_position_id ,
1938: p_information_type => 'GHR_US_POS_GRP1' ,
1939: p_date_effective => p_effective_date ,
1940: p_pos_ei_data => l_pos_ei_data

Line 1983: ghr_history_fetch.fetch_positionei

1979:
1980:
1981: If l_position_id is not null then
1982: hr_utility.set_location(l_proc,15);
1983: ghr_history_fetch.fetch_positionei
1984: (p_position_id => l_position_id ,
1985: p_information_type => 'GHR_US_POS_GRP1' ,
1986: p_date_effective => p_effective_date ,
1987: p_pos_ei_data => l_pos_ei_data

Line 2049: ghr_history_fetch.fetch_positionei(

2045: IF p_prd IN ('A','B','E','F')
2046: AND nvl(p_noa_code,'XXX') <> '740'
2047: AND l_retained_grade.temp_step IS NOT NULL THEN
2048: hr_utility.set_location('get from positionei ',1);
2049: ghr_history_fetch.fetch_positionei(
2050: p_position_id => p_position_id,
2051: p_information_type => 'GHR_US_POS_VALID_GRADE',
2052: p_date_effective => p_effective_date,
2053: p_pos_ei_data => l_pos_ei_grade_data);

Line 2070: ghr_history_fetch.fetch_positionei(

2066: hr_utility.set_location('update 34 isnot null and effective_date is ',1);
2067: RETURN(l_retained_grade.pay_basis);
2068: else
2069: hr_utility.set_location('get from positionei ',1);
2070: ghr_history_fetch.fetch_positionei(
2071: p_position_id => p_position_id,
2072: p_information_type => 'GHR_US_POS_VALID_GRADE',
2073: p_date_effective => p_effective_date,
2074: p_pos_ei_data => l_pos_ei_grade_data);

Line 2177: ghr_history_fetch.fetch_peopleei

2173: l_upd_flag := 'Y';
2174: end if;
2175: End if;
2176:
2177: ghr_history_fetch.fetch_peopleei
2178: (p_person_id => p_person_id
2179: ,p_information_type => 'GHR_US_PER_UPDATE34'
2180: ,p_date_effective => p_date
2181: ,p_per_ei_data => l_per_ei_data);

Line 2277: ghr_history_fetch.fetch_positionei

2273: BEGIN
2274:
2275: hr_utility.set_location('Entering ' || l_proc,5);
2276:
2277: ghr_history_fetch.fetch_positionei
2278: (p_position_id => p_position_id ,
2279: p_information_type => 'GHR_US_POS_GRP1' ,
2280: p_date_effective => p_effective_date ,
2281: p_pos_ei_data => l_pos_ei_data

Line 2303: ghr_history_fetch.fetch_positionei

2299: BEGIN
2300:
2301: hr_utility.set_location('Entering ' || l_proc,5);
2302:
2303: ghr_history_fetch.fetch_positionei
2304: (p_position_id => p_position_id ,
2305: p_information_type => 'GHR_US_POS_GRP1' ,
2306: p_date_effective => p_effective_date ,
2307: p_pos_ei_data => l_pos_ei_data

Line 2329: ghr_history_fetch.fetch_positionei

2325: BEGIN
2326:
2327: hr_utility.set_location('Entering ' || l_proc,5);
2328:
2329: ghr_history_fetch.fetch_positionei
2330: (p_position_id => p_position_id ,
2331: p_information_type => 'GHR_US_POS_GRP1' ,
2332: p_date_effective => p_effective_date ,
2333: p_pos_ei_data => l_pos_ei_data

Line 2361: ghr_history_fetch.fetch_positionei

2357: BEGIN
2358:
2359: hr_utility.set_location('Entering ' || l_proc,5);
2360:
2361: ghr_history_fetch.fetch_positionei
2362: (p_position_id => p_position_id ,
2363: p_information_type => 'GHR_US_POS_VALID_GRADE' ,
2364: p_date_effective => p_effective_date ,
2365: p_pos_ei_data => l_pos_ei_data

Line 2463: ghr_history_fetch.fetch_positionei(

2459: BEGIN
2460:
2461: hr_utility.set_location('Entering ' || l_proc,35);
2462:
2463: ghr_history_fetch.fetch_positionei(
2464: p_position_id => p_position_id,
2465: p_information_type => 'GHR_US_POS_GRP2',
2466: p_date_effective => p_effective_date,
2467: p_pos_ei_data => l_pos_ei_grp2_data);