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_RIF_PKG dependencies on HR_API

Line 8: ,p_special_info1 out nocopy ghr_api.special_information_type

4: Procedure return_ratings
5: (p_person_id in number
6: ,p_structure_name in varchar2
7: ,p_effective_date in date
8: ,p_special_info1 out nocopy ghr_api.special_information_type
9: ,p_special_info2 out nocopy ghr_api.special_information_type
10: ,p_special_info3 out nocopy ghr_api.special_information_type
11: )
12: is

Line 9: ,p_special_info2 out nocopy ghr_api.special_information_type

5: (p_person_id in number
6: ,p_structure_name in varchar2
7: ,p_effective_date in date
8: ,p_special_info1 out nocopy ghr_api.special_information_type
9: ,p_special_info2 out nocopy ghr_api.special_information_type
10: ,p_special_info3 out nocopy ghr_api.special_information_type
11: )
12: is
13: l_proc varchar2(72) := 'return_special_information ';

Line 10: ,p_special_info3 out nocopy ghr_api.special_information_type

6: ,p_structure_name in varchar2
7: ,p_effective_date in date
8: ,p_special_info1 out nocopy ghr_api.special_information_type
9: ,p_special_info2 out nocopy ghr_api.special_information_type
10: ,p_special_info3 out nocopy ghr_api.special_information_type
11: )
12: is
13: l_proc varchar2(72) := 'return_special_information ';
14: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

Line 304: l_perf_appraisal1 ghr_api.special_information_type;

300:
301: l_people_ei_data1 per_people_extra_info%rowtype;
302: l_people_ei_data2 per_people_extra_info%rowtype;
303:
304: l_perf_appraisal1 ghr_api.special_information_type;
305: l_perf_appraisal2 ghr_api.special_information_type;
306: l_perf_appraisal3 ghr_api.special_information_type;
307:
308: BEGIN

Line 305: l_perf_appraisal2 ghr_api.special_information_type;

301: l_people_ei_data1 per_people_extra_info%rowtype;
302: l_people_ei_data2 per_people_extra_info%rowtype;
303:
304: l_perf_appraisal1 ghr_api.special_information_type;
305: l_perf_appraisal2 ghr_api.special_information_type;
306: l_perf_appraisal3 ghr_api.special_information_type;
307:
308: BEGIN
309: hr_utility.set_location('Enter Rif' ,1);

Line 306: l_perf_appraisal3 ghr_api.special_information_type;

302: l_people_ei_data2 per_people_extra_info%rowtype;
303:
304: l_perf_appraisal1 ghr_api.special_information_type;
305: l_perf_appraisal2 ghr_api.special_information_type;
306: l_perf_appraisal3 ghr_api.special_information_type;
307:
308: BEGIN
309: hr_utility.set_location('Enter Rif' ,1);
310:

Line 381: l_rif_reg.agency_code_subelement := ghr_api.get_position_agency_code_pos

377:
378: -- Agency Code
379: hr_utility.set_location('Getting Agency Code',4);
380:
381: l_rif_reg.agency_code_subelement := ghr_api.get_position_agency_code_pos
382: (p_position_id => per_rec.position_id
383: ,p_business_group_id => per_rec.business_group_id
384: ,p_effective_date => l_effective_date);
385:

Line 389: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(l_c_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and

385:
386: --Check the Criteria
387:
388: hr_utility.set_location('Checking the Criteria',5);
389: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(l_c_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
390: nvl(l_comp_level,hr_api.g_varchar2) = l_c_comp_level and
391: nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 ) = nvl(l_c_org_structure_id,nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 )) and
392: nvl(l_rif_reg.office_symbol,hr_api.g_varchar2) = nvl(l_c_office_symbol,nvl(l_rif_reg.office_symbol,hr_api.g_varchar2)) and
393: nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2 ) = nvl(l_c_agency_code_se,nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2)) and

Line 390: nvl(l_comp_level,hr_api.g_varchar2) = l_c_comp_level and

386: --Check the Criteria
387:
388: hr_utility.set_location('Checking the Criteria',5);
389: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(l_c_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
390: nvl(l_comp_level,hr_api.g_varchar2) = l_c_comp_level and
391: nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 ) = nvl(l_c_org_structure_id,nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 )) and
392: nvl(l_rif_reg.office_symbol,hr_api.g_varchar2) = nvl(l_c_office_symbol,nvl(l_rif_reg.office_symbol,hr_api.g_varchar2)) and
393: nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2 ) = nvl(l_c_agency_code_se,nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2)) and
394: nvl(per_rec.organization_id,hr_api.g_number ) = nvl(l_c_organization_id,nvl(per_rec.organization_id,hr_api.g_number))

Line 391: nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 ) = nvl(l_c_org_structure_id,nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 )) and

387:
388: hr_utility.set_location('Checking the Criteria',5);
389: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(l_c_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
390: nvl(l_comp_level,hr_api.g_varchar2) = l_c_comp_level and
391: nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 ) = nvl(l_c_org_structure_id,nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 )) and
392: nvl(l_rif_reg.office_symbol,hr_api.g_varchar2) = nvl(l_c_office_symbol,nvl(l_rif_reg.office_symbol,hr_api.g_varchar2)) and
393: nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2 ) = nvl(l_c_agency_code_se,nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2)) and
394: nvl(per_rec.organization_id,hr_api.g_number ) = nvl(l_c_organization_id,nvl(per_rec.organization_id,hr_api.g_number))
395: then

Line 392: nvl(l_rif_reg.office_symbol,hr_api.g_varchar2) = nvl(l_c_office_symbol,nvl(l_rif_reg.office_symbol,hr_api.g_varchar2)) and

388: hr_utility.set_location('Checking the Criteria',5);
389: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(l_c_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
390: nvl(l_comp_level,hr_api.g_varchar2) = l_c_comp_level and
391: nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 ) = nvl(l_c_org_structure_id,nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 )) and
392: nvl(l_rif_reg.office_symbol,hr_api.g_varchar2) = nvl(l_c_office_symbol,nvl(l_rif_reg.office_symbol,hr_api.g_varchar2)) and
393: nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2 ) = nvl(l_c_agency_code_se,nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2)) and
394: nvl(per_rec.organization_id,hr_api.g_number ) = nvl(l_c_organization_id,nvl(per_rec.organization_id,hr_api.g_number))
395: then
396:

Line 393: nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2 ) = nvl(l_c_agency_code_se,nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2)) and

389: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(l_c_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
390: nvl(l_comp_level,hr_api.g_varchar2) = l_c_comp_level and
391: nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 ) = nvl(l_c_org_structure_id,nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 )) and
392: nvl(l_rif_reg.office_symbol,hr_api.g_varchar2) = nvl(l_c_office_symbol,nvl(l_rif_reg.office_symbol,hr_api.g_varchar2)) and
393: nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2 ) = nvl(l_c_agency_code_se,nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2)) and
394: nvl(per_rec.organization_id,hr_api.g_number ) = nvl(l_c_organization_id,nvl(per_rec.organization_id,hr_api.g_number))
395: then
396:
397: -- Populate the details into ghr_rif_registers

Line 394: nvl(per_rec.organization_id,hr_api.g_number ) = nvl(l_c_organization_id,nvl(per_rec.organization_id,hr_api.g_number))

390: nvl(l_comp_level,hr_api.g_varchar2) = l_c_comp_level and
391: nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 ) = nvl(l_c_org_structure_id,nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 )) and
392: nvl(l_rif_reg.office_symbol,hr_api.g_varchar2) = nvl(l_c_office_symbol,nvl(l_rif_reg.office_symbol,hr_api.g_varchar2)) and
393: nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2 ) = nvl(l_c_agency_code_se,nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2)) and
394: nvl(per_rec.organization_id,hr_api.g_number ) = nvl(l_c_organization_id,nvl(per_rec.organization_id,hr_api.g_number))
395: then
396:
397: -- Populate the details into ghr_rif_registers
398:

Line 489: l_rif_reg.occ_code := ghr_api.get_job_occ_series_job

485:
486: -- Series (Occ_code)
487: hr_utility.set_location('Getting OCC Code' ,8);
488:
489: l_rif_reg.occ_code := ghr_api.get_job_occ_series_job
490: (p_job_id => per_rec.job_id,
491: p_business_group_id => per_rec.business_group_id
492: );
493:

Line 529: ghr_api.retrieve_element_entry_value

525:
526: --WGI Due Date
527: hr_utility.set_location('Getting WGI Due Date',9);
528:
529: ghr_api.retrieve_element_entry_value
530: (p_element_name => 'Within Grade Increase',
531: p_input_value_name => 'Date Due',
532: p_assignment_id => per_rec.assignment_id, p_effective_date => l_effective_date,
533: p_value => l_value,

Line 627: l_rif_reg.position_title := ghr_api.get_position_title_pos

623:
624: -- Position Title
625: hr_utility.set_location('Getting Position Title',12);
626:
627: l_rif_reg.position_title := ghr_api.get_position_title_pos
628: (p_position_id => per_rec.position_id,
629: p_business_group_id => per_rec.business_group_id,
630: p_effective_date => l_effective_date
631: );

Line 919: l_agency_code_se := ghr_api.get_position_agency_code_pos

915: l_org_structure_id := l_pos_ei_data.poei_information5;
916: l_office_symbol := l_pos_ei_data.poei_information4;
917:
918:
919: l_agency_code_se := ghr_api.get_position_agency_code_pos
920: (p_position_id => vac_rec.position_id
921: ,p_business_group_id => vac_rec.business_group_id
922: ,p_effective_date => l_effective_date);
923:

Line 926: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(p_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and

922: ,p_effective_date => l_effective_date);
923:
924: --Check the Criteria
925:
926: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(p_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
927: nvl(l_comp_level,hr_api.g_varchar2) = nvl(p_comp_level,nvl(l_comp_level,hr_api.g_varchar2)) and
928: nvl(l_org_structure_id,hr_api.g_varchar2) = nvl(p_org_structure_id,nvl(l_org_structure_id,hr_api.g_varchar2) ) and
929: nvl(l_office_symbol,hr_api.g_varchar2) = nvl(p_office_symbol,nvl(l_office_symbol,hr_api.g_varchar2) ) and
930: nvl(l_agency_code_se,hr_api.g_varchar2 ) = nvl(p_agency_code_subelement,nvl(l_agency_code_se,hr_api.g_varchar2 ) )

Line 927: nvl(l_comp_level,hr_api.g_varchar2) = nvl(p_comp_level,nvl(l_comp_level,hr_api.g_varchar2)) and

923:
924: --Check the Criteria
925:
926: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(p_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
927: nvl(l_comp_level,hr_api.g_varchar2) = nvl(p_comp_level,nvl(l_comp_level,hr_api.g_varchar2)) and
928: nvl(l_org_structure_id,hr_api.g_varchar2) = nvl(p_org_structure_id,nvl(l_org_structure_id,hr_api.g_varchar2) ) and
929: nvl(l_office_symbol,hr_api.g_varchar2) = nvl(p_office_symbol,nvl(l_office_symbol,hr_api.g_varchar2) ) and
930: nvl(l_agency_code_se,hr_api.g_varchar2 ) = nvl(p_agency_code_subelement,nvl(l_agency_code_se,hr_api.g_varchar2 ) )
931: then

Line 928: nvl(l_org_structure_id,hr_api.g_varchar2) = nvl(p_org_structure_id,nvl(l_org_structure_id,hr_api.g_varchar2) ) and

924: --Check the Criteria
925:
926: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(p_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
927: nvl(l_comp_level,hr_api.g_varchar2) = nvl(p_comp_level,nvl(l_comp_level,hr_api.g_varchar2)) and
928: nvl(l_org_structure_id,hr_api.g_varchar2) = nvl(p_org_structure_id,nvl(l_org_structure_id,hr_api.g_varchar2) ) and
929: nvl(l_office_symbol,hr_api.g_varchar2) = nvl(p_office_symbol,nvl(l_office_symbol,hr_api.g_varchar2) ) and
930: nvl(l_agency_code_se,hr_api.g_varchar2 ) = nvl(p_agency_code_subelement,nvl(l_agency_code_se,hr_api.g_varchar2 ) )
931: then
932: l_num_of_vac := l_num_of_vac + 1;

Line 929: nvl(l_office_symbol,hr_api.g_varchar2) = nvl(p_office_symbol,nvl(l_office_symbol,hr_api.g_varchar2) ) and

925:
926: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(p_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
927: nvl(l_comp_level,hr_api.g_varchar2) = nvl(p_comp_level,nvl(l_comp_level,hr_api.g_varchar2)) and
928: nvl(l_org_structure_id,hr_api.g_varchar2) = nvl(p_org_structure_id,nvl(l_org_structure_id,hr_api.g_varchar2) ) and
929: nvl(l_office_symbol,hr_api.g_varchar2) = nvl(p_office_symbol,nvl(l_office_symbol,hr_api.g_varchar2) ) and
930: nvl(l_agency_code_se,hr_api.g_varchar2 ) = nvl(p_agency_code_subelement,nvl(l_agency_code_se,hr_api.g_varchar2 ) )
931: then
932: l_num_of_vac := l_num_of_vac + 1;
933: end if;

Line 930: nvl(l_agency_code_se,hr_api.g_varchar2 ) = nvl(p_agency_code_subelement,nvl(l_agency_code_se,hr_api.g_varchar2 ) )

926: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(p_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
927: nvl(l_comp_level,hr_api.g_varchar2) = nvl(p_comp_level,nvl(l_comp_level,hr_api.g_varchar2)) and
928: nvl(l_org_structure_id,hr_api.g_varchar2) = nvl(p_org_structure_id,nvl(l_org_structure_id,hr_api.g_varchar2) ) and
929: nvl(l_office_symbol,hr_api.g_varchar2) = nvl(p_office_symbol,nvl(l_office_symbol,hr_api.g_varchar2) ) and
930: nvl(l_agency_code_se,hr_api.g_varchar2 ) = nvl(p_agency_code_subelement,nvl(l_agency_code_se,hr_api.g_varchar2 ) )
931: then
932: l_num_of_vac := l_num_of_vac + 1;
933: end if;
934: