[Home] [Help]
10735: -- Update or select the cagr_grade_def_id
10736: --
10737: -- need to call the lck procedure early, to fetch the
10738: -- old value of cagr_id_flex_num
10739: -- before passing it into the hr_cgd_upd.upd_or_sel function.
10740: -- This is because the user may be updating a grade definition,
10741: -- but not changing
10742: -- or specifying the cagr_id_flex_num (ie the grade structure).
10743: -- Also, need to fetch the old cagr_grade_def_id, as
10742: -- or specifying the cagr_id_flex_num (ie the grade structure).
10743: -- Also, need to fetch the old cagr_grade_def_id, as
10744: -- the user may be updating some
10745: -- segments, and not changing others.
10746: -- Passing cagr_grade_id into the hr_cgd_upd.upd_or_sel
10747: -- function allows that function to derive the old values.
10748: --
10749: l_cagr_id_flex_num := p_cagr_id_flex_num;
10750: --
10769: if l_cag_null_ind = 0 and l_cagr_id_flex_num is not null -- bug 2359997
10770: then
10771: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
10772: --
10773: hr_cgd_upd.upd_or_sel
10774: (p_segment1 => l_cag_segment1
10775: ,p_segment2 => l_cag_segment2
10776: ,p_segment3 => l_cag_segment3
10777: ,p_segment4 => l_cag_segment4
11799: --
11800: -- Update or select the cagr_grade_def_id
11801: --
11802: -- need to call the lck procedure early, to fetch the old value of cagr_id_flex_num
11803: -- before passing it into the hr_cgd_upd.upd_or_sel function.
11804: -- This is because the user may be updating a grade definition, but not changing
11805: -- or specifying the cagr_id_flex_num (ie the grade structure).
11806: -- Also, need to fetch the old cagr_grade_def_id, as the user may be updating some
11807: -- segments, and not changing others. Passing cagr_grade_id into the hr_cgd_upd.upd_or_sel
11803: -- before passing it into the hr_cgd_upd.upd_or_sel function.
11804: -- This is because the user may be updating a grade definition, but not changing
11805: -- or specifying the cagr_id_flex_num (ie the grade structure).
11806: -- Also, need to fetch the old cagr_grade_def_id, as the user may be updating some
11807: -- segments, and not changing others. Passing cagr_grade_id into the hr_cgd_upd.upd_or_sel
11808: -- function allows that function to derive the old values.
11809: --
11810: l_cagr_id_flex_num := p_cagr_id_flex_num;
11811: --
11825: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
11826: --
11827: End if;
11828: --
11829: hr_cgd_upd.upd_or_sel
11830: (p_segment1 => p_cag_segment1
11831: ,p_segment2 => p_cag_segment2
11832: ,p_segment3 => p_cag_segment3
11833: ,p_segment4 => p_cag_segment4
17673: end if; -- l_soft_coding_key_flex_id is null
17674: --
17675: -- need to call the lck procedure early, to fetch the old value of
17676: -- cagr_id_flex_num
17677: -- before passing it into the hr_cgd_upd.upd_or_sel function.
17678: -- This is because the user may be updating a grade definition,
17679: -- but not changing
17680: -- or specifying the cagr_id_flex_num (ie the grade structure).
17681: -- Also, need to fetch the old cagr_grade_def_id, as the
17680: -- or specifying the cagr_id_flex_num (ie the grade structure).
17681: -- Also, need to fetch the old cagr_grade_def_id, as the
17682: -- user may be updating some
17683: -- segments, and not changing others. Passing cagr_grade_id
17684: -- into the hr_cgd_upd.upd_or_sel
17685: -- function allows that function to derive the old values.
17686: --
17687: l_cagr_id_flex_num := p_cagr_id_flex_num;
17688: --
17703: if l_cag_null_ind = 0
17704: then
17705: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
17706: --
17707: hr_cgd_upd.upd_or_sel
17708: (p_segment1 => l_cag_segment1
17709: ,p_segment2 => l_cag_segment2
17710: ,p_segment3 => l_cag_segment3
17711: ,p_segment4 => l_cag_segment4