[Home] [Help]
11315: -- Update or select the cagr_grade_def_id
11316: --
11317: -- need to call the lck procedure early, to fetch the
11318: -- old value of cagr_id_flex_num
11319: -- before passing it into the hr_cgd_upd.upd_or_sel function.
11320: -- This is because the user may be updating a grade definition,
11321: -- but not changing
11322: -- or specifying the cagr_id_flex_num (ie the grade structure).
11323: -- Also, need to fetch the old cagr_grade_def_id, as
11322: -- or specifying the cagr_id_flex_num (ie the grade structure).
11323: -- Also, need to fetch the old cagr_grade_def_id, as
11324: -- the user may be updating some
11325: -- segments, and not changing others.
11326: -- Passing cagr_grade_id into the hr_cgd_upd.upd_or_sel
11327: -- function allows that function to derive the old values.
11328: --
11329: l_cagr_id_flex_num := p_cagr_id_flex_num;
11330: --
11349: if l_cag_null_ind = 0 and l_cagr_id_flex_num is not null -- bug 2359997
11350: then
11351: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
11352: --
11353: hr_cgd_upd.upd_or_sel
11354: (p_segment1 => l_cag_segment1
11355: ,p_segment2 => l_cag_segment2
11356: ,p_segment3 => l_cag_segment3
11357: ,p_segment4 => l_cag_segment4
12400: --
12401: -- Update or select the cagr_grade_def_id
12402: --
12403: -- need to call the lck procedure early, to fetch the old value of cagr_id_flex_num
12404: -- before passing it into the hr_cgd_upd.upd_or_sel function.
12405: -- This is because the user may be updating a grade definition, but not changing
12406: -- or specifying the cagr_id_flex_num (ie the grade structure).
12407: -- Also, need to fetch the old cagr_grade_def_id, as the user may be updating some
12408: -- segments, and not changing others. Passing cagr_grade_id into the hr_cgd_upd.upd_or_sel
12404: -- before passing it into the hr_cgd_upd.upd_or_sel function.
12405: -- This is because the user may be updating a grade definition, but not changing
12406: -- or specifying the cagr_id_flex_num (ie the grade structure).
12407: -- Also, need to fetch the old cagr_grade_def_id, as the user may be updating some
12408: -- segments, and not changing others. Passing cagr_grade_id into the hr_cgd_upd.upd_or_sel
12409: -- function allows that function to derive the old values.
12410: --
12411: l_cagr_id_flex_num := p_cagr_id_flex_num;
12412: --
12426: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
12427: --
12428: End if;
12429: --
12430: hr_cgd_upd.upd_or_sel
12431: (p_segment1 => p_cag_segment1
12432: ,p_segment2 => p_cag_segment2
12433: ,p_segment3 => p_cag_segment3
12434: ,p_segment4 => p_cag_segment4
18520: end if; -- l_soft_coding_key_flex_id is null
18521: --
18522: -- need to call the lck procedure early, to fetch the old value of
18523: -- cagr_id_flex_num
18524: -- before passing it into the hr_cgd_upd.upd_or_sel function.
18525: -- This is because the user may be updating a grade definition,
18526: -- but not changing
18527: -- or specifying the cagr_id_flex_num (ie the grade structure).
18528: -- Also, need to fetch the old cagr_grade_def_id, as the
18527: -- or specifying the cagr_id_flex_num (ie the grade structure).
18528: -- Also, need to fetch the old cagr_grade_def_id, as the
18529: -- user may be updating some
18530: -- segments, and not changing others. Passing cagr_grade_id
18531: -- into the hr_cgd_upd.upd_or_sel
18532: -- function allows that function to derive the old values.
18533: --
18534: l_cagr_id_flex_num := p_cagr_id_flex_num;
18535: --
18550: if l_cag_null_ind = 0
18551: then
18552: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
18553: --
18554: hr_cgd_upd.upd_or_sel
18555: (p_segment1 => l_cag_segment1
18556: ,p_segment2 => l_cag_segment2
18557: ,p_segment3 => l_cag_segment3
18558: ,p_segment4 => l_cag_segment4