DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PA_REQUESTS_PKG

Line 1786: ghr_pa_requests_pkg.get_noa_pm_family

1782: l_pa_request_rec.to_job_id := p_job_id;
1783:
1784: l_pa_request_rec.first_noa_id := get_noa_id(p_mass_award_id);
1785: l_pa_request_rec.noa_family_code :=
1786: ghr_pa_requests_pkg.get_noa_pm_family
1787: (p_nature_of_action_id => l_pa_request_rec.first_noa_id);
1788:
1789: hr_utility.set_location(l_proc,15);
1790: get_noa_code_desc

Line 1797: ghr_pa_requests_pkg.get_person_details

1793: p_noa_code => l_pa_request_rec.first_noa_code,
1794: p_noa_desc => l_pa_request_rec.first_noa_desc );
1795:
1796: hr_utility.set_location(l_proc,20);
1797: ghr_pa_requests_pkg.get_person_details
1798: (p_person_id => p_person_id
1799: ,p_effective_date => p_effective_date
1800: ,p_national_identifier => l_pa_request_rec.employee_national_identifier
1801: ,p_date_of_birth => l_pa_request_rec.employee_date_of_birth

Line 1892: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1888: --End Bug# 4748927
1889: hr_utility.set_location(l_proc,35);
1890: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
1891:
1892: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1893: (p_location_id => l_duty_station_location_id
1894: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1895:
1896: ghr_pa_requests_pkg.get_duty_station_details

Line 1896: ghr_pa_requests_pkg.get_duty_station_details

1892: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1893: (p_location_id => l_duty_station_location_id
1894: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1895:
1896: ghr_pa_requests_pkg.get_duty_station_details
1897: (p_duty_station_id => l_pa_request_rec.duty_station_id
1898: ,p_effective_date => l_pa_request_rec.effective_date
1899: ,p_duty_station_code => l_pa_request_rec.duty_station_code
1900: ,p_duty_station_desc => l_pa_request_rec.duty_station_desc);

Line 1922: ghr_pa_requests_pkg.get_sf52_pos_ddf_details

1918: l_pa_request_rec.to_position_org_line5 := l_pa_request_rec.from_position_org_line5;
1919: l_pa_request_rec.to_position_org_line6 := l_pa_request_rec.from_position_org_line6;
1920:
1921: hr_utility.set_location(l_proc,40);
1922: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
1923: (p_position_id => p_position_id
1924: ,p_date_Effective => l_pa_request_rec.effective_date
1925: ,p_flsa_category => l_pa_request_rec.flsa_category
1926: ,p_bargaining_unit_status => l_pa_request_rec.bargaining_unit_status

Line 1958: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning

1954: ,p_effective_date => p_effective_date
1955: );
1956: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);
1957:
1958: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning
1959: (800
1960: ,'GHR_US_AGENCY_CODE'
1961: ,l_pa_request_rec.agency_code
1962: );

Line 2208: ghr_pa_requests_pkg.get_SF52_person_ddf_details

2204:
2205: l_pa_request_rec.first_noa_desc := l_first_noa_desc;
2206: -- Bug#3648118 Changes completed.
2207: hr_utility.set_location(l_proc,55);
2208: ghr_pa_requests_pkg.get_SF52_person_ddf_details
2209: (p_person_id => l_pa_request_rec.person_id,
2210: p_date_effective => l_pa_request_rec.effective_date,
2211: p_citizenship => l_pa_request_rec.citizenship,
2212: p_veterans_preference => l_pa_request_rec.veterans_preference,

Line 2233: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

2229: p_year_degree_attained => l_pa_request_rec.year_degree_attained
2230: );
2231:
2232: hr_utility.set_location(l_proc,80);
2233: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
2234: (p_assignment_id => l_pa_request_rec.employee_assignment_id
2235: ,p_date_effective => l_pa_request_rec.effective_date
2236: ,p_tenure => l_pa_request_rec.tenure
2237: ,p_annuitant_indicator => l_pa_request_rec.annuitant_indicator

Line 2244: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning

2240: ,p_part_time_hours => l_pa_request_rec.part_time_hours
2241: );
2242:
2243: -- Annuitant_indicator
2244: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
2245: (800
2246: ,'GHR_US_ANNUITANT_INDICATOR'
2247: ,l_pa_request_rec.annuitant_indicator
2248: );

Line 2251: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning

2247: ,l_pa_request_rec.annuitant_indicator
2248: );
2249:
2250: --WORK_SCHEDULE
2251: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
2252: (800
2253: ,'GHR_US_WORK_SCHEDULE'
2254: ,l_pa_request_rec.work_schedule
2255: );

Line 2269: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

2265: ,p_value => l_pa_request_rec.fegli
2266: ,p_multiple_error_flag => l_multiple_error_flag
2267: );
2268:
2269: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
2270: (800
2271: ,'GHR_US_FEGLI'
2272: ,l_pa_request_rec.fegli
2273: );

Line 2287: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning

2283: ,p_value => l_pa_request_rec.retirement_plan
2284: ,p_multiple_error_flag => l_multiple_error_flag
2285: );
2286:
2287: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
2288: (800
2289: ,'GHR_US_RETIREMENT_PLAN'
2290: ,l_pa_request_rec.retirement_plan
2291: );

Line 3377: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_to_position_id,p_effective_date);

3373: l_psi VARCHAR2(10);
3374: BEGIN
3375: --bug 5482191
3376:
3377: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_to_position_id,p_effective_date);
3378:
3379:
3380: p_error_flg := FALSE;
3381: --Check for Maximum Amount.