[Home] [Help]
37: p_attribute17 varchar2,
38: p_attribute18 varchar2,
39: p_attribute19 varchar2,
40: p_attribute20 varchar2,
41: p_language_code varchar2 default hr_api.userenv_lang) IS
42: cursor c1 is
43: select per_grades_s.nextval
44: from sys.dual;
45: cursor c2 is
196: p_attribute17 varchar2,
197: p_attribute18 varchar2,
198: p_attribute19 varchar2,
199: p_attribute20 varchar2,
200: p_language_code varchar2 default hr_api.userenv_lang) IS
201:
202: cursor OPM_CUR is
203: select *
204: from per_grades_vl g
387: p_attribute17 varchar2,
388: p_attribute18 varchar2,
389: p_attribute19 varchar2,
390: p_attribute20 varchar2,
391: p_language_code varchar2 default hr_api.userenv_lang) is
392:
393: begin
394: update per_grades g
395: set
860: cursor chk_grd_dt_from is
861: select 'x' from pay_grade_rules_f p
862: where p.grade_or_spinal_point_id = p_grade_id
863: and p.rate_type='G' -- Bug fix 4024588
864: and p.effective_start_date < nvl(p_date_from, hr_api.g_sot);
865: --
866: begin
867: --
868: hr_utility.set_location('per_grades_pkg.chk_date_from', 1);
887: cursor chk_grd_dt_to is
888: select 'x' from pay_grade_rules_f p
889: where p.grade_or_spinal_point_id = p_grade_id
890: and p.rate_type='G' -- Bug fix 3360504. Type check added.
891: and p.effective_end_date > nvl(p_date_to, hr_api.g_eot);
892:
893: -- Bug fix 3360504 starts here
894: -- cursor to check whether any grade steps exist after the
895: -- end date.
895: -- end date.
896: cursor chk_grade_scale is
897: select 'x' from per_grade_spines_f pgs
898: where pgs.grade_id = p_grade_id
899: and pgs.effective_end_date > nvl(p_date_to, hr_api.g_eot);
900:
901:
902: --
903: begin