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 GHR_RIF_CRITERIA

Line 199: p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE

195: raise;
196: END get_lookup_meaning_desc;
197:
198: procedure run_register (
199: p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
200: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
201: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
202: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
203: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE

Line 200: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE

196: END get_lookup_meaning_desc;
197:
198: procedure run_register (
199: p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
200: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
201: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
202: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
203: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
204: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE

Line 201: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE

197:
198: procedure run_register (
199: p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
200: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
201: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
202: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
203: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
204: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
205: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE

Line 202: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE

198: procedure run_register (
199: p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
200: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
201: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
202: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
203: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
204: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
205: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
206: ,p_effective_date in date

Line 203: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE

199: p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
200: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
201: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
202: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
203: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
204: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
205: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
206: ,p_effective_date in date
207: ) IS

Line 204: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE

200: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
201: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
202: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
203: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
204: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
205: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
206: ,p_effective_date in date
207: ) IS
208:

Line 205: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE

201: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
202: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
203: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
204: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
205: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
206: ,p_effective_date in date
207: ) IS
208:
209: -- Bug 4377361 included EMP_APL for person type condition

Line 239: cursor cur_criteria(p_rif_criteria_id ghr_rif_criteria.rif_criteria_id%TYPE)

235: and p_effective_date between per.effective_start_date
236: and per.effective_end_date
237: and asg.position_id is not null;
238:
239: cursor cur_criteria(p_rif_criteria_id ghr_rif_criteria.rif_criteria_id%TYPE)
240: is
241: select rif.comp_area comp_area,
242: rif.comp_level comp_level,
243: rif.effective_date,

Line 248: from ghr_rif_criteria rif

244: rif.organization_id,
245: rif.org_structure_id,
246: rif.office_symbol,
247: rif.agency_code_subelement
248: from ghr_rif_criteria rif
249: where rif.rif_criteria_id = p_rif_criteria_id;
250:
251: cursor job_name(p_job_id per_jobs.job_id%TYPE)
252: is

Line 826: PROCEDURE check_unique_name (p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE

822: COMMIT;
823: --
824: END purge_register;
825: --
826: PROCEDURE check_unique_name (p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
827: ,p_name IN ghr_rif_criteria.name%TYPE) IS
828: --
829: CURSOR cur_rif IS
830: SELECT 1

Line 827: ,p_name IN ghr_rif_criteria.name%TYPE) IS

823: --
824: END purge_register;
825: --
826: PROCEDURE check_unique_name (p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
827: ,p_name IN ghr_rif_criteria.name%TYPE) IS
828: --
829: CURSOR cur_rif IS
830: SELECT 1
831: FROM ghr_rif_criteria rif

Line 831: FROM ghr_rif_criteria rif

827: ,p_name IN ghr_rif_criteria.name%TYPE) IS
828: --
829: CURSOR cur_rif IS
830: SELECT 1
831: FROM ghr_rif_criteria rif
832: WHERE rif.name = p_name
833: AND rif.rif_criteria_id <> NVL(p_rif_criteria_id,-1);
834: --
835: BEGIN

Line 863: p_organization_id in ghr_rif_criteria.organization_id%TYPE

859: return l_name;
860: end;
861:
862: FUNCTION num_of_vacancies(
863: p_organization_id in ghr_rif_criteria.organization_id%TYPE
864: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
865: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
866: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
867: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE

Line 864: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE

860: end;
861:
862: FUNCTION num_of_vacancies(
863: p_organization_id in ghr_rif_criteria.organization_id%TYPE
864: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
865: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
866: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
867: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
868: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE

Line 865: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE

861:
862: FUNCTION num_of_vacancies(
863: p_organization_id in ghr_rif_criteria.organization_id%TYPE
864: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
865: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
866: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
867: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
868: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
869: ,p_effective_date in date

Line 866: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE

862: FUNCTION num_of_vacancies(
863: p_organization_id in ghr_rif_criteria.organization_id%TYPE
864: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
865: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
866: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
867: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
868: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
869: ,p_effective_date in date
870: )

Line 867: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE

863: p_organization_id in ghr_rif_criteria.organization_id%TYPE
864: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
865: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
866: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
867: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
868: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
869: ,p_effective_date in date
870: )
871: return number is

Line 868: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE

864: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
865: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
866: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
867: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
868: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
869: ,p_effective_date in date
870: )
871: return number is
872: