eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CPDF_EHRIS dependencies on GHR_API

Line 480: l_ANCRIT_REC ghr_api.special_information_type;

476: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
477: )
478: IS
479: l_proc varchar2(30) := 'get_from_history_ancrit';
480: l_ANCRIT_REC ghr_api.special_information_type;
481: l_emp_number per_all_people.employee_number%TYPE;
482:
483: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
484: l_max_segment per_analysis_criteria.segment1%type;

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

553: order by pan.date_from desc, pan.analysis_criteria_id desc; -- Latest From Date, Most Recent Record.
554:
555: BEGIN
556:
557: -- bug 749386 use ghr_api.return_education_details and ghr_api.return_special_information
558: hr_utility.set_location('Entering:'||l_proc,5);
559: --Begin Bug# 4753092
560: g_message_name := 'Special Info: Education Dtls';
561: --End Bug# 4753092

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

558: hr_utility.set_location('Entering:'||l_proc,5);
559: --Begin Bug# 4753092
560: g_message_name := 'Special Info: Education Dtls';
561: --End Bug# 4753092
562: ghr_api.return_education_details(p_person_id => p_sr_person_id,
563: p_effective_date => p_sr_report_date,
564: p_education_level => p_sr_ghr_cpdf_temp.education_level,
565: p_academic_discipline => p_sr_ghr_cpdf_temp.academic_discipline,
566: p_year_degree_attained => p_sr_ghr_cpdf_temp.year_degree_attained);

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

3372: asg.location_id,
3373: asg.effective_start_date,
3374: asg.business_group_id,
3375: ast.per_system_status assignment_status_type,
3376: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
3377: FROM PER_ALL_ASSIGNMENTS asg, per_assignment_status_types ast -- Changing from per_assignments_f
3378: WHERE ast.assignment_status_type_id = asg.assignment_status_type_id
3379: -- only consider "Active" assignments as defined by below, also only look at
3380: -- assignments that are assigned to a valid person as of the report date.

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

3383: AND asg.assignment_type <> 'B'
3384: AND asg.position_id IS NOT NULL
3385: --Bug 8486208 modified for new dynamic parameter
3386: AND ((p_agency is not null and
3387: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency)
3388: OR
3389: (p_agencies_with_se is not null and INSTR(p_agencies_with_se,ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1) > 0)
3390: OR
3391: (p_agencies_without_se is not null and INSTR(p_agencies_without_se,substr(ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1,2),1) > 0)

Line 3389: (p_agencies_with_se is not null and INSTR(p_agencies_with_se,ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1) > 0)

3385: --Bug 8486208 modified for new dynamic parameter
3386: AND ((p_agency is not null and
3387: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency)
3388: OR
3389: (p_agencies_with_se is not null and INSTR(p_agencies_with_se,ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1) > 0)
3390: OR
3391: (p_agencies_without_se is not null and INSTR(p_agencies_without_se,substr(ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1,2),1) > 0)
3392: )
3393: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , hr_general.get_business_group_id) = asg.business_group_id

Line 3391: (p_agencies_without_se is not null and INSTR(p_agencies_without_se,substr(ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1,2),1) > 0)

3387: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency)
3388: OR
3389: (p_agencies_with_se is not null and INSTR(p_agencies_with_se,ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1) > 0)
3390: OR
3391: (p_agencies_without_se is not null and INSTR(p_agencies_without_se,substr(ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1,2),1) > 0)
3392: )
3393: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , hr_general.get_business_group_id) = asg.business_group_id
3394: ORDER BY assignment_id;
3395: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment

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

3555:
3556: -- Begin Bug# 4753092
3557: g_message_name := 'Fetch Position title';
3558: -- End Bug# 4753092
3559: g_ghr_cpdf_temp.position_title := ghr_api.get_position_title_pos(
3560: p_position_id => g_position_id,
3561: p_business_group_id => g_business_group_id,
3562: p_effective_date => g_report_date);
3563: