DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on HR_API

Line 358: l_special_info ghr_api.special_information_type;

354: ,p_rating_of_record_period OUT NOCOPY DATE
355: ,p_rating_of_rec_period_starts OUT NOCOPY DATE)
356: IS
357: --
358: l_special_info ghr_api.special_information_type;
359: l_emp_number per_people_f.employee_number%TYPE;
360: CURSOR c_per IS
361: SELECT per.employee_number
362: FROM per_all_people_f per -- Bug 4349372

Line 367: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',

363: WHERE per.person_id = p_person_id
364: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
365: AND per.effective_end_date;
366: BEGIN
367: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',
368: p_effective_date, l_special_info);
369:
370: IF l_special_info.object_version_number IS NOT NULL THEN
371: p_rating_of_record_level := l_special_info.segment5;

Line 392: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',

388: AND flx.id_flex_code = 'PEA'
389: AND flx.application_id = 800
390: AND flx.id_flex_structure_code = 'US_FED_PERF_APPRAISAL'
391: AND pan.person_id = p_person_id;
392: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',
393: l_effective_date, l_special_info);
394: IF l_special_info.object_version_number IS NOT NULL THEN
395: p_rating_of_record_level := l_special_info.segment5;
396: p_rating_of_record_pattern := l_special_info.segment4;

Line 916: GHR_API.sf52_from_data_elements

912: --
913: ELSE -- FUTURE_ACTION's
914: IF p_from_position_id IS NOT NULL THEN
915: l_assignment_id := p_employee_assignment_id;
916: GHR_API.sf52_from_data_elements
917: (p_person_id => p_person_id
918: ,p_assignment_id => l_assignment_id
919: ,p_effective_date => p_effective_date
920: ,p_altered_pa_request_id => null

Line 3069: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'

3065: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3066: l_ghr_pa_requests_rec.second_noa_code = '818') THEN
3067: -- Bug#2789704 Added Exception Handling
3068: BEGIN
3069: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'
3070: ,p_input_value_name => 'Amount'
3071: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3072: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3073: ,p_value => l_ghr_cpdf_temp_rec.award_amount

Line 3094: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'

3090: -- Bug#2789704 Added Exception Handling
3091: ELSE
3092: -- Bug#2789704 Added Exception Handling
3093: BEGIN
3094: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'
3095: ,p_input_value_name => 'Amount'
3096: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3097: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3098: ,p_value => l_ghr_cpdf_temp_rec.award_amount

Line 3122: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'

3118: ELSE
3119: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
3120: -- Bug#2789704 Added Exception Handling
3121: BEGIN
3122: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
3123: ,p_input_value_name => 'Amount'
3124: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3125: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3126: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential

Line 3149: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'

3145: END IF;
3146: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
3147: -- Bug#2789704 Added Exception Handling
3148: BEGIN
3149: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
3150: ,p_input_value_name => 'Amount'
3151: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3152: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3153: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance

Line 3176: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,

3172: END IF;
3173: END IF;
3174:
3175: -- Sundar Changes for education
3176: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
3177: p_effective_date => l_ghr_pa_requests_rec.effective_date,
3178: p_education_level => l_ghr_cpdf_temp_rec.education_level,
3179: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
3180: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);

Line 3801: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'

3797: THEN
3798: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
3799:
3800: BEGIN
3801: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
3802: ,p_input_value_name => 'Amount'
3803: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3804: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3805: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential

Line 3826: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'

3822: END IF;
3823: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
3824:
3825: BEGIN
3826: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
3827: ,p_input_value_name => 'Amount'
3828: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3829: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3830: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance