[Home] [Help]
356: ,p_rating_of_record_period OUT NOCOPY DATE
357: ,p_rating_of_rec_period_starts OUT NOCOPY DATE)
358: IS
359: --
360: l_special_info ghr_api.special_information_type;
361: l_emp_number per_people_f.employee_number%TYPE;
362: CURSOR c_per IS
363: SELECT per.employee_number
364: FROM per_all_people_f per -- Bug 4349372
365: WHERE per.person_id = p_person_id
366: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
367: AND per.effective_end_date;
368: BEGIN
369: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',
370: p_effective_date, l_special_info);
371:
372: IF l_special_info.object_version_number IS NOT NULL THEN
373: p_rating_of_record_level := l_special_info.segment5;
390: AND flx.id_flex_code = 'PEA'
391: AND flx.application_id = 800
392: AND flx.id_flex_structure_code = 'US_FED_PERF_APPRAISAL'
393: AND pan.person_id = p_person_id;
394: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',
395: l_effective_date, l_special_info);
396: IF l_special_info.object_version_number IS NOT NULL THEN
397: p_rating_of_record_level := l_special_info.segment5;
398: p_rating_of_record_pattern := l_special_info.segment4;
957: --
958: ELSE -- FUTURE_ACTION's
959: IF p_from_position_id IS NOT NULL THEN
960: l_assignment_id := p_employee_assignment_id;
961: GHR_API.sf52_from_data_elements
962: (p_person_id => p_person_id
963: ,p_assignment_id => l_assignment_id
964: ,p_effective_date => p_effective_date
965: ,p_altered_pa_request_id => null
2643: from ghr_noa_families nof,
2644: ghr_families fam
2645: where nof.nature_of_action_id = p_noa_id
2646: and fam.noa_family_code = nof.noa_family_code
2647: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
2648: and p_effective_date
2649: between nvl(fam.start_date_active,p_effective_date)
2650: and nvl(fam.end_date_active,p_effective_date);
2651:
3303: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3304: l_ghr_pa_requests_rec.second_noa_code = '818') THEN
3305: -- Bug#2789704 Added Exception Handling
3306: BEGIN
3307: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'
3308: ,p_input_value_name => 'Amount'
3309: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3310: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3311: ,p_value => l_ghr_cpdf_temp_rec.award_amount
3332: -- Bug#2789704 Added Exception Handling
3333: ELSE
3334: -- Bug#2789704 Added Exception Handling
3335: BEGIN
3336: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'
3337: ,p_input_value_name => 'Amount'
3338: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3339: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3340: ,p_value => l_ghr_cpdf_temp_rec.award_amount
3366: ELSE
3367: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
3368: -- Bug#2789704 Added Exception Handling
3369: BEGIN
3370: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
3371: ,p_input_value_name => 'Amount'
3372: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3373: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3374: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
3394: END IF;
3395: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
3396: -- Bug#2789704 Added Exception Handling
3397: BEGIN
3398: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
3399: ,p_input_value_name => 'Amount'
3400: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3401: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3402: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
3423: END IF;
3424:
3425:
3426: -- Sundar Changes for education
3427: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
3428: p_effective_date => l_ghr_pa_requests_rec.effective_date,
3429: p_education_level => l_ghr_cpdf_temp_rec.education_level,
3430: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
3431: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);
4071: THEN
4072: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
4073:
4074: BEGIN
4075: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
4076: ,p_input_value_name => 'Amount'
4077: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
4078: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
4079: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
4097: END IF;
4098: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
4099:
4100: BEGIN
4101: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
4102: ,p_input_value_name => 'Amount'
4103: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
4104: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
4105: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance