APPS.GHR_CPDF_STATRPT dependencies on GHR_API

Line 240: l_ANCRIT_REC ghr_api.special_information_type;

236: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
237: )
238: IS
239: l_proc varchar2(30) := 'get_from_history_ancrit';
240: l_ANCRIT_REC ghr_api.special_information_type;
241: l_emp_number per_people_f.employee_number%TYPE;
242: CURSOR c_per IS
243: SELECT per.employee_number
244: FROM per_people_f per

Line 250: -- bug 749386 use ghr_api.return_education_details and ghr_api.return_special_information

246: AND NVL(p_sr_report_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
247: AND per.effective_end_date;
248: BEGIN
249:
250: -- bug 749386 use ghr_api.return_education_details and ghr_api.return_special_information
251: hr_utility.set_location('Entering:'||l_proc,5);
252: -- Begin Bug# 4168162
253: g_message_name := 'Special Info: Education Dtls';
254: -- End Bug# 4168162

Line 255: ghr_api.return_education_details(p_person_id => p_sr_person_id,

251: hr_utility.set_location('Entering:'||l_proc,5);
252: -- Begin Bug# 4168162
253: g_message_name := 'Special Info: Education Dtls';
254: -- End Bug# 4168162
255: ghr_api.return_education_details(p_person_id => p_sr_person_id,
256: p_effective_date => p_sr_report_date,
257: p_education_level => p_sr_ghr_cpdf_temp.education_level,
258: p_academic_discipline => p_sr_ghr_cpdf_temp.academic_discipline,
259: p_year_degree_attained => p_sr_ghr_cpdf_temp.year_degree_attained);

Line 271: ghr_api.return_special_information(p_person_id => p_sr_person_id,

267: ,p_sr_ghr_cpdf_temp.rating_of_record_pattern
268: ,p_sr_ghr_cpdf_temp.rating_of_record_period_ends);
269:
270: /***** Commented 2003405
271: ghr_api.return_special_information(p_person_id => p_sr_person_id,
272: p_structure_name => 'US Fed Perf Appraisal',
273: p_effective_date => p_sr_report_date,
274: p_special_info => l_ancrit_rec);
275:

Line 1231: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code

1227: asg.job_id,
1228: asg.location_id,
1229: asg.effective_start_date,
1230: asg.business_group_id,
1231: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
1232: FROM PER_ASSIGNMENTS_F asg
1233: WHERE
1234: -- only consider "Active" assignments as defined by below, also only look at
1235: -- assignments that are assigned to a valid person as of the report date.

Line 1243: AND ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency

1239: from PER_ASSIGNMENT_STATUS_TYPES ast
1240: where ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN'))
1241: AND asg.assignment_type <> 'B'
1242: AND asg.position_id IS NOT NULL
1243: AND ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency
1244: ORDER BY assignment_id;
1245: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
1246:
1247: l_assignments_f_rec assignments_f_cur%ROWTYPE;

Line 1347: g_ghr_cpdf_temp.position_title := ghr_api.get_position_title_pos(

1343: g_message_name := 'Fetch Position title';
1344: --l_message_name :='get_position_title_pos';
1345: -- End Bug# 4168162
1346:
1347: g_ghr_cpdf_temp.position_title := ghr_api.get_position_title_pos(
1348: p_position_id => g_position_id,
1349: p_business_group_id => l_business_group_id,
1350: p_effective_date => g_report_date);
1351: