APPS.HR_CAGR_GRADES_API dependencies on PER_CAGR_GRADES_DEF

Line 13: (p_cagr_grade_def_id IN per_cagr_grades_def.cagr_grade_def_id%TYPE

9: -- |--------------------------< update_concat_segs >---------------------------|
10: -- ----------------------------------------------------------------------------
11: --
12: PROCEDURE update_concat_segs
13: (p_cagr_grade_def_id IN per_cagr_grades_def.cagr_grade_def_id%TYPE
14: ,p_concatenated_segments IN per_cagr_grades_def.concatenated_segments%TYPE) is
15: --
16: l_proc VARCHAR2(72) := g_package||'update_concat_segs';
17: l_concat_segments per_cagr_grades_def.concatenated_segments%TYPE;

Line 14: ,p_concatenated_segments IN per_cagr_grades_def.concatenated_segments%TYPE) is

10: -- ----------------------------------------------------------------------------
11: --
12: PROCEDURE update_concat_segs
13: (p_cagr_grade_def_id IN per_cagr_grades_def.cagr_grade_def_id%TYPE
14: ,p_concatenated_segments IN per_cagr_grades_def.concatenated_segments%TYPE) is
15: --
16: l_proc VARCHAR2(72) := g_package||'update_concat_segs';
17: l_concat_segments per_cagr_grades_def.concatenated_segments%TYPE;
18: l_cagr_found varchar2(1) := 'N';

Line 17: l_concat_segments per_cagr_grades_def.concatenated_segments%TYPE;

13: (p_cagr_grade_def_id IN per_cagr_grades_def.cagr_grade_def_id%TYPE
14: ,p_concatenated_segments IN per_cagr_grades_def.concatenated_segments%TYPE) is
15: --
16: l_proc VARCHAR2(72) := g_package||'update_concat_segs';
17: l_concat_segments per_cagr_grades_def.concatenated_segments%TYPE;
18: l_cagr_found varchar2(1) := 'N';
19: --
20: CURSOR get_concat_segs IS
21: SELECT concatenated_segments

Line 22: FROM per_cagr_grades_def

18: l_cagr_found varchar2(1) := 'N';
19: --
20: CURSOR get_concat_segs IS
21: SELECT concatenated_segments
22: FROM per_cagr_grades_def
23: WHERE cagr_grade_def_id = p_cagr_grade_def_id;
24: --
25: procedure update_concat_segs_auto
26: (p_cagr_grade_def_id in number) is

Line 31: FROM per_cagr_grades_def

27: PRAGMA AUTONOMOUS_TRANSACTION;
28: --
29: CURSOR csr_cagr_lock is
30: SELECT null
31: FROM per_cagr_grades_def
32: where cagr_grade_def_id = p_cagr_grade_def_id
33: for update nowait;
34: --
35: l_exists varchar2(30);

Line 49: UPDATE per_cagr_grades_def

45: close csr_cagr_lock;
46: --
47: hr_utility.set_location(l_proc, 20);
48: --
49: UPDATE per_cagr_grades_def
50: SET concatenated_segments = p_concatenated_segments
51: WHERE cagr_grade_def_id = p_cagr_grade_def_id;
52: --
53: commit;

Line 198: from per_cagr_grades_def

194: segment17,
195: segment18,
196: segment19,
197: segment20
198: from per_cagr_grades_def
199: where cagr_grade_def_id = l_cagr_grade_def_id;
200: --
201: begin
202: --

Line 353: -- record on the per_cagr_grades_def table.

349: --
350: -- Added as part of fix for bug 2126247
351: --
352: -- Updates the concatenated segments for the new
353: -- record on the per_cagr_grades_def table.
354: --
355: update_concat_segs
356: (p_cagr_grade_def_id => l_cagr_grade_def_id
357: ,p_concatenated_segments => l_name);

Line 551: -- bug 2284889 get per_cagr_grades_def segment values where

547: (select pcg.cagr_grade_structure_id
548: from per_cagr_grades pcg
549: where pcg.cagr_grade_id = p_cagr_grade_id);
550: --
551: -- bug 2284889 get per_cagr_grades_def segment values where
552: -- cagr_grade_def_id is known
553: --
554: cursor c_segments is
555: select segment1,

Line 575: from per_cagr_grades_def

571: segment17,
572: segment18,
573: segment19,
574: segment20
575: from per_cagr_grades_def
576: where cagr_grade_def_id = l_cagr_grade_def_id;
577: --
578: BEGIN
579: --

Line 705: -- update cagr grades definitions in per_cagr_grades_def if

701: --
702: hr_utility.set_location(l_proc, 60);
703: --
704: -- 2284889
705: -- update cagr grades definitions in per_cagr_grades_def if
706: -- p_cagr_grade_def_id had no value when passed into program
707: --
708: if l_null_ind = 0 OR l_segments_changed = TRUE then
709: --

Line 749: -- on the per_cagr_grades_def table.

745: --
746: -- Added as part of fix for bug 2126247
747: --
748: -- Updates the concatenated segments for the record
749: -- on the per_cagr_grades_def table.
750: --
751: update_concat_segs
752: (p_cagr_grade_def_id => l_cagr_grade_def_id
753: ,p_concatenated_segments => l_name);