DBA Data[Home] [Help]

APPS.GHR_CPDF_DYNRPT dependencies on HR_API

Line 326: l_special_info ghr_api.special_information_type;

322: ,p_rating_of_record_level OUT NOCOPY VARCHAR2
323: ,p_rating_of_record_pattern OUT NOCOPY VARCHAR2
324: ,p_rating_of_record_period OUT NOCOPY DATE) IS
325: --
326: l_special_info ghr_api.special_information_type;
327: l_emp_number per_people_f.employee_number%TYPE;
328: CURSOR c_per IS
329: SELECT per.employee_number
330: FROM per_people_f per

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

331: WHERE per.person_id = p_person_id
332: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
333: AND per.effective_end_date;
334: BEGIN
335: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',
336: p_effective_date, l_special_info);
337:
338: IF l_special_info.object_version_number IS NOT NULL THEN
339: p_rating_of_record_level := l_special_info.segment5;

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

351: AND flx.id_flex_code = 'PEA'
352: AND flx.application_id = 800
353: AND flx.id_flex_structure_code = 'US_FED_PERF_APPRAISAL'
354: AND pan.person_id = p_person_id;
355: ghr_api.return_special_information(p_person_id, 'US Fed Perf Appraisal',
356: l_effective_date, l_special_info);
357: IF l_special_info.object_version_number IS NOT NULL THEN
358: p_rating_of_record_level := l_special_info.segment5;
359: p_rating_of_record_pattern := l_special_info.segment4;

Line 624: GHR_API.sf52_from_data_elements

620: --
621: ELSE -- FUTURE_ACTION's
622: IF p_from_position_id IS NOT NULL THEN
623: l_assignment_id := p_employee_assignment_id;
624: GHR_API.sf52_from_data_elements
625: (p_person_id => p_person_id
626: ,p_assignment_id => l_assignment_id
627: ,p_effective_date => p_effective_date
628: ,p_altered_pa_request_id => null

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

1581: l_ghr_pa_requests_rec.second_noa_code = '818') THEN
1582: -- Bug#2789704 Added Exception Handling
1583:
1584: BEGIN
1585: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'
1586: ,p_input_value_name => 'Amount'
1587: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1588: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1589: ,p_value => l_ghr_cpdf_temp_rec.award_amount

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

1613: -- Bug#2789704 Added Exception Handling
1614: ELSE
1615: -- Bug#2789704 Added Exception Handling
1616: BEGIN
1617: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'
1618: ,p_input_value_name => 'Amount'
1619: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1620: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1621: ,p_value => l_ghr_cpdf_temp_rec.award_amount

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

1647: ELSE
1648: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
1649: -- Bug#2789704 Added Exception Handling
1650: BEGIN
1651: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
1652: ,p_input_value_name => 'Amount'
1653: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1654: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1655: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential

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

1674: END IF;
1675: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
1676: -- Bug#2789704 Added Exception Handling
1677: BEGIN
1678: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1679: ,p_input_value_name => 'Amount'
1680: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1681: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1682: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance

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

1702: END IF;
1703:
1704: -- Changes for education
1705: -- Fix for 3958881 Madhuri
1706: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
1707: p_effective_date => l_ghr_pa_requests_rec.effective_date,
1708: p_education_level => l_ghr_cpdf_temp_rec.education_level,
1709: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
1710: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);

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

2118:
2119: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
2120:
2121: BEGIN
2122: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
2123: ,p_input_value_name => 'Amount'
2124: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2125: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2126: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential

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

2144: END IF;
2145: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
2146:
2147: BEGIN
2148: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2149: ,p_input_value_name => 'Amount'
2150: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2151: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2152: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance