[Home] [Help]
317: -- Validates that the business group id for the job is the same as that
318: -- for the valid grade.
319: --
320: -- Validates that the combination of grade_id and job_id does not already
321: -- exist on per_valid_grades.
322: --
323: -- Pre-conditions:
324: -- None
325: --
356: where job.job_id = p_job_id;
357: --
358: cursor csr_chk_job_grd_comb is
359: select null
360: from per_valid_grades vgr
361: where vgr.job_id = p_job_id
362: and vgr.grade_id = p_grade_id
363: -- Fix For Bug # 6983587 Starts
364: and
476: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
477: --
478: cursor csr_chk_pos_grd_comb is
479: select null
480: from per_valid_grades vgr
481: where vgr.position_id = p_position_id
482: and vgr.grade_id = p_grade_id
483: -- Fix For Bug # 7516458 Starts
484: and
792: -- b) During insert.
793: --
794: hr_dflex_utility.ins_or_upd_descflex_attribs
795: (p_appl_short_name => 'PER'
796: ,p_descflex_name => 'PER_VALID_GRADES'
797: ,p_attribute_category => p_rec.attribute_category
798: ,p_attribute1_name => 'ATTRIBUTE1'
799: ,p_attribute1_value => p_rec.attribute1
800: ,p_attribute2_name => 'ATTRIBUTE2'
1011: -- |---------------------< return_legislation_code >-------------------------|
1012: -- ---------------------------------------------------------------------------
1013: --
1014: function return_legislation_code
1015: (p_valid_grade_id in per_valid_grades.valid_grade_id%TYPE
1016: ) return varchar2 is
1017: --
1018: -- Cursor to find legislation code
1019: --
1019: --
1020: cursor csr_leg_code is
1021: select pbg.legislation_code
1022: from per_business_groups pbg
1023: , per_valid_grades pvg
1024: where pvg.valid_grade_id = p_valid_grade_id
1025: and pbg.business_group_id = pvg.business_group_id;
1026: --
1027: -- Declare local variables