[Home] [Help]
323: ,p_rating_of_record_level OUT NOCOPY VARCHAR2
324: ,p_rating_of_record_pattern OUT NOCOPY VARCHAR2
325: ,p_rating_of_record_period OUT NOCOPY DATE) IS
326: --
327: l_special_info ghr_api.special_information_type;
328: l_emp_number per_people_f.employee_number%TYPE;
329: CURSOR c_per IS
330: SELECT per.employee_number
331: FROM per_people_f per
332: WHERE per.person_id = p_person_id
333: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
334: AND per.effective_end_date;
335: BEGIN
336: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',
337: p_effective_date, l_special_info);
338:
339: IF l_special_info.object_version_number IS NOT NULL THEN
340: p_rating_of_record_level := l_special_info.segment5;
352: AND flx.id_flex_code = 'PEA'
353: AND flx.application_id = 800
354: AND flx.id_flex_structure_code = 'US_FED_PERF_APPRAISAL'
355: AND pan.person_id = p_person_id;
356: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',
357: l_effective_date, l_special_info);
358: IF l_special_info.object_version_number IS NOT NULL THEN
359: p_rating_of_record_level := l_special_info.segment5;
360: p_rating_of_record_pattern := l_special_info.segment4;
666: --
667: ELSE -- FUTURE_ACTION's
668: IF p_from_position_id IS NOT NULL THEN
669: l_assignment_id := p_employee_assignment_id;
670: GHR_API.sf52_from_data_elements
671: (p_person_id => p_person_id
672: ,p_assignment_id => l_assignment_id
673: ,p_effective_date => p_effective_date
674: ,p_altered_pa_request_id => null
1283: from ghr_noa_families nof,
1284: ghr_families fam
1285: where nof.nature_of_action_id = p_noa_id
1286: and fam.noa_family_code = nof.noa_family_code
1287: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
1288: and p_effective_date
1289: between nvl(fam.start_date_active,p_effective_date)
1290: and nvl(fam.end_date_active,p_effective_date);
1291:
1709: l_ghr_pa_requests_rec.second_noa_code = '818') THEN
1710: -- Bug#2789704 Added Exception Handling
1711:
1712: BEGIN
1713: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'
1714: ,p_input_value_name => 'Amount'
1715: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1716: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1717: ,p_value => l_ghr_cpdf_temp_rec.award_amount
1742: -- Bug#2789704 Added Exception Handling
1743: ELSE
1744: -- Bug#2789704 Added Exception Handling
1745: BEGIN
1746: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'
1747: ,p_input_value_name => 'Amount'
1748: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1749: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1750: ,p_value => l_ghr_cpdf_temp_rec.award_amount
1777: ELSE
1778: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
1779: -- Bug#2789704 Added Exception Handling
1780: BEGIN
1781: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
1782: ,p_input_value_name => 'Amount'
1783: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1784: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1785: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
1805: END IF;
1806: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
1807: -- Bug#2789704 Added Exception Handling
1808: BEGIN
1809: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1810: ,p_input_value_name => 'Amount'
1811: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1812: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1813: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
1834: END IF;
1835:
1836: -- Changes for education
1837: -- Fix for 3958881 Madhuri
1838: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
1839: p_effective_date => l_ghr_pa_requests_rec.effective_date,
1840: p_education_level => l_ghr_cpdf_temp_rec.education_level,
1841: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
1842: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);
2259:
2260: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
2261:
2262: BEGIN
2263: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
2264: ,p_input_value_name => 'Amount'
2265: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2266: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2267: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
2286: END IF;
2287: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
2288:
2289: BEGIN
2290: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2291: ,p_input_value_name => 'Amount'
2292: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2293: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2294: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance