[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
473: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
474: --
475: cursor csr_chk_pos_grd_comb is
476: select null
477: from per_valid_grades vgr
478: where vgr.position_id = p_position_id
479: and vgr.grade_id = p_grade_id;
480: --
481: begin
778: -- b) During insert.
779: --
780: hr_dflex_utility.ins_or_upd_descflex_attribs
781: (p_appl_short_name => 'PER'
782: ,p_descflex_name => 'PER_VALID_GRADES'
783: ,p_attribute_category => p_rec.attribute_category
784: ,p_attribute1_name => 'ATTRIBUTE1'
785: ,p_attribute1_value => p_rec.attribute1
786: ,p_attribute2_name => 'ATTRIBUTE2'
994: -- |---------------------< return_legislation_code >-------------------------|
995: -- ---------------------------------------------------------------------------
996: --
997: function return_legislation_code
998: (p_valid_grade_id in per_valid_grades.valid_grade_id%TYPE
999: ) return varchar2 is
1000: --
1001: -- Cursor to find legislation code
1002: --
1002: --
1003: cursor csr_leg_code is
1004: select pbg.legislation_code
1005: from per_business_groups pbg
1006: , per_valid_grades pvg
1007: where pvg.valid_grade_id = p_valid_grade_id
1008: and pbg.business_group_id = pvg.business_group_id;
1009: --
1010: -- Declare local variables