APPS.GHR_CPDF_EHRIS dependencies on GHR_API

Line 467: l_ANCRIT_REC ghr_api.special_information_type;

463: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
464: )
465: IS
466: l_proc varchar2(30) := 'get_from_history_ancrit';
467: l_ANCRIT_REC ghr_api.special_information_type;
468: l_emp_number per_all_people.employee_number%TYPE;
469:
470: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
471: l_max_segment per_analysis_criteria.segment1%type;

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

540: order by pan.date_from desc, pan.analysis_criteria_id desc; -- Latest From Date, Most Recent Record.
541:
542: BEGIN
543:
544: -- bug 749386 use ghr_api.return_education_details and ghr_api.return_special_information
545: hr_utility.set_location('Entering:'||l_proc,5);
546: --Begin Bug# 4753092
547: g_message_name := 'Special Info: Education Dtls';
548: --End Bug# 4753092

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

545: hr_utility.set_location('Entering:'||l_proc,5);
546: --Begin Bug# 4753092
547: g_message_name := 'Special Info: Education Dtls';
548: --End Bug# 4753092
549: ghr_api.return_education_details(p_person_id => p_sr_person_id,
550: p_effective_date => p_sr_report_date,
551: p_education_level => p_sr_ghr_cpdf_temp.education_level,
552: p_academic_discipline => p_sr_ghr_cpdf_temp.academic_discipline,
553: p_year_degree_attained => p_sr_ghr_cpdf_temp.year_degree_attained);

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

3239: asg.location_id,
3240: asg.effective_start_date,
3241: asg.business_group_id,
3242: ast.per_system_status assignment_status_type,
3243: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
3244: FROM PER_ALL_ASSIGNMENTS asg, per_assignment_status_types ast -- Changing from per_assignments_f
3245: WHERE ast.assignment_status_type_id = asg.assignment_status_type_id
3246: -- only consider "Active" assignments as defined by below, also only look at
3247: -- assignments that are assigned to a valid person as of the report date.

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

3248: AND g_report_date between asg.effective_start_date and asg.effective_end_date
3249: AND ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
3250: AND asg.assignment_type <> 'B'
3251: AND asg.position_id IS NOT NULL
3252: AND ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency
3253: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , hr_general.get_business_group_id) = asg.business_group_id
3254: ORDER BY assignment_id;
3255: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
3256:

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

3402:
3403: -- Begin Bug# 4753092
3404: g_message_name := 'Fetch Position title';
3405: -- End Bug# 4753092
3406: g_ghr_cpdf_temp.position_title := ghr_api.get_position_title_pos(
3407: p_position_id => g_position_id,
3408: p_business_group_id => g_business_group_id,
3409: p_effective_date => g_report_date);
3410: