APPS.GHR_CPDF_STATRPT dependencies on GHR_API

Line 244: l_ANCRIT_REC ghr_api.special_information_type;

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

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

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

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

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

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

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

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

1257: asg.job_id,
1258: asg.location_id,
1259: asg.effective_start_date,
1260: asg.business_group_id,
1261: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
1262: FROM PER_ALL_ASSIGNMENTS asg -- Bug # 10632194 changed from PER_ASSIGNMENTS_F to match EHRI
1263: WHERE
1264: -- only consider "Active" assignments as defined by below, also only look at
1265: -- assignments that are assigned to a valid person as of the report date.

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

1269: from PER_ASSIGNMENT_STATUS_TYPES ast
1270: where ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN'))
1271: AND asg.assignment_type <> 'B'
1272: AND asg.position_id IS NOT NULL
1273: AND ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency
1274: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , hr_general.get_business_group_id) = asg.business_group_id
1275: ORDER BY assignment_id;
1276: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
1277:

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

1389: g_message_name := 'Fetch Position title';
1390: --l_message_name :='get_position_title_pos';
1391: -- End Bug# 4168162
1392:
1393: g_ghr_cpdf_temp.position_title := ghr_api.get_position_title_pos(
1394: p_position_id => g_position_id,
1395: p_business_group_id => l_business_group_id,
1396: p_effective_date => g_report_date);
1397: