DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PA_REQUESTS_PKG

Line 1788: ghr_pa_requests_pkg.get_noa_pm_family

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

Line 1799: ghr_pa_requests_pkg.get_person_details

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

Line 1812: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

1808:
1809: --Bug # 9329643
1810:
1811: If p_person_id is not null then
1812: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1813: (p_person_id => p_person_id,
1814: p_effective_date => p_effective_date);
1815: End if;
1816:

Line 1902: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1898: --End Bug# 4748927
1899: hr_utility.set_location(l_proc,35);
1900: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
1901:
1902: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1903: (p_location_id => l_duty_station_location_id
1904: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1905:
1906: ghr_pa_requests_pkg.get_duty_station_details

Line 1906: ghr_pa_requests_pkg.get_duty_station_details

1902: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1903: (p_location_id => l_duty_station_location_id
1904: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1905:
1906: ghr_pa_requests_pkg.get_duty_station_details
1907: (p_duty_station_id => l_pa_request_rec.duty_station_id
1908: ,p_effective_date => l_pa_request_rec.effective_date
1909: ,p_duty_station_code => l_pa_request_rec.duty_station_code
1910: ,p_duty_station_desc => l_pa_request_rec.duty_station_desc);

Line 1932: ghr_pa_requests_pkg.get_sf52_pos_ddf_details

1928: l_pa_request_rec.to_position_org_line5 := l_pa_request_rec.from_position_org_line5;
1929: l_pa_request_rec.to_position_org_line6 := l_pa_request_rec.from_position_org_line6;
1930:
1931: hr_utility.set_location(l_proc,40);
1932: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
1933: (p_position_id => p_position_id
1934: ,p_date_Effective => l_pa_request_rec.effective_date
1935: ,p_flsa_category => l_pa_request_rec.flsa_category
1936: ,p_bargaining_unit_status => l_pa_request_rec.bargaining_unit_status

Line 1968: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning

1964: ,p_effective_date => p_effective_date
1965: );
1966: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);
1967:
1968: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning
1969: (800
1970: ,'GHR_US_AGENCY_CODE'
1971: ,l_pa_request_rec.agency_code
1972: );

Line 2218: ghr_pa_requests_pkg.get_SF52_person_ddf_details

2214:
2215: l_pa_request_rec.first_noa_desc := l_first_noa_desc;
2216: -- Bug#3648118 Changes completed.
2217: hr_utility.set_location(l_proc,55);
2218: ghr_pa_requests_pkg.get_SF52_person_ddf_details
2219: (p_person_id => l_pa_request_rec.person_id,
2220: p_date_effective => l_pa_request_rec.effective_date,
2221: p_citizenship => l_pa_request_rec.citizenship,
2222: p_veterans_preference => l_pa_request_rec.veterans_preference,

Line 2243: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

2239: p_year_degree_attained => l_pa_request_rec.year_degree_attained
2240: );
2241:
2242: hr_utility.set_location(l_proc,80);
2243: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
2244: (p_assignment_id => l_pa_request_rec.employee_assignment_id
2245: ,p_date_effective => l_pa_request_rec.effective_date
2246: ,p_tenure => l_pa_request_rec.tenure
2247: ,p_annuitant_indicator => l_pa_request_rec.annuitant_indicator

Line 2254: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning

2250: ,p_part_time_hours => l_pa_request_rec.part_time_hours
2251: );
2252:
2253: -- Annuitant_indicator
2254: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
2255: (800
2256: ,'GHR_US_ANNUITANT_INDICATOR'
2257: ,l_pa_request_rec.annuitant_indicator
2258: );

Line 2261: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning

2257: ,l_pa_request_rec.annuitant_indicator
2258: );
2259:
2260: --WORK_SCHEDULE
2261: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
2262: (800
2263: ,'GHR_US_WORK_SCHEDULE'
2264: ,l_pa_request_rec.work_schedule
2265: );

Line 2279: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

2275: ,p_value => l_pa_request_rec.fegli
2276: ,p_multiple_error_flag => l_multiple_error_flag
2277: );
2278:
2279: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
2280: (800
2281: ,'GHR_US_FEGLI'
2282: ,l_pa_request_rec.fegli
2283: );

Line 2297: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning

2293: ,p_value => l_pa_request_rec.retirement_plan
2294: ,p_multiple_error_flag => l_multiple_error_flag
2295: );
2296:
2297: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
2298: (800
2299: ,'GHR_US_RETIREMENT_PLAN'
2300: ,l_pa_request_rec.retirement_plan
2301: );

Line 3345: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

3341:
3342:
3343: --Bug # 9329643
3344: If l_person_id is not null then
3345: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3346: (p_person_id => l_person_id,
3347: p_effective_date => l_effective_date);
3348: End if;
3349:

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

3405: l_psi VARCHAR2(10);
3406: BEGIN
3407: --bug 5482191
3408:
3409: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_to_position_id,p_effective_date);
3410:
3411:
3412: p_error_flg := FALSE;
3413: --Check for Maximum Amount.