eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CAGR_GRADES_API dependencies on PER_CAGR_GRADES

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 134: l_cagr_grade_id per_cagr_grades.cagr_grade_id%TYPE;

130: ,p_effective_date in date) is
131: --
132: -- Declare cursors and local variables
133: --
134: l_cagr_grade_id per_cagr_grades.cagr_grade_id%TYPE;
135: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
136: l_proc varchar2(72) := g_package||'create_cagr_grades';
137: l_object_version_number per_cagr_grades.object_version_number%TYPE;
138: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;

Line 135: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;

131: --
132: -- Declare cursors and local variables
133: --
134: l_cagr_grade_id per_cagr_grades.cagr_grade_id%TYPE;
135: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
136: l_proc varchar2(72) := g_package||'create_cagr_grades';
137: l_object_version_number per_cagr_grades.object_version_number%TYPE;
138: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
139: l_cagr_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE

Line 137: l_object_version_number per_cagr_grades.object_version_number%TYPE;

133: --
134: l_cagr_grade_id per_cagr_grades.cagr_grade_id%TYPE;
135: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
136: l_proc varchar2(72) := g_package||'create_cagr_grades';
137: l_object_version_number per_cagr_grades.object_version_number%TYPE;
138: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
139: l_cagr_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE
140: := p_cagr_grade_def_id;
141: l_name varchar2(240) := p_concat_segments;

Line 139: l_cagr_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE

135: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
136: l_proc varchar2(72) := g_package||'create_cagr_grades';
137: l_object_version_number per_cagr_grades.object_version_number%TYPE;
138: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
139: l_cagr_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE
140: := p_cagr_grade_def_id;
141: l_name varchar2(240) := p_concat_segments;
142: --
143: -- bug 2284889 set up and initialize local segment values for use when

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 510: l_object_version_number per_cagr_grades.object_version_number%TYPE;

506: -- Declare cursors and local variables
507: --
508: l_proc varchar2(72) := g_package||'update_cagr_grades';
509: l_segments_changed BOOLEAN;
510: l_object_version_number per_cagr_grades.object_version_number%TYPE;
511: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;
512: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
513: l_name varchar2(240);
514: l_cagr_grade_def_id

Line 511: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;

507: --
508: l_proc varchar2(72) := g_package||'update_cagr_grades';
509: l_segments_changed BOOLEAN;
510: l_object_version_number per_cagr_grades.object_version_number%TYPE;
511: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;
512: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
513: l_name varchar2(240);
514: l_cagr_grade_def_id
515: per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;

Line 515: per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;

511: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;
512: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
513: l_name varchar2(240);
514: l_cagr_grade_def_id
515: per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
516: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
517: --
518: -- bug 2284889 initialize l_cagr_grade_def_id and segment variables with
519: -- values where these are passed into program.

Line 516: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;

512: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
513: l_name varchar2(240);
514: l_cagr_grade_def_id
515: per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
516: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
517: --
518: -- bug 2284889 initialize l_cagr_grade_def_id and segment variables with
519: -- values where these are passed into program.
520: --

Line 548: from per_cagr_grades pcg

544: select pcs.id_flex_num
545: from per_cagr_grade_structures pcs
546: where pcs.cagr_grade_structure_id in
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

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);

Line 877: l_object_version_number per_cagr_grades.object_version_number%TYPE;

873: --
874: -- Declare cursors and local variables
875: --
876: l_proc varchar2(72) := g_package||'update_cagr_grades';
877: l_object_version_number per_cagr_grades.object_version_number%TYPE;
878: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;
879: --
880: begin
881: --

Line 878: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;

874: -- Declare cursors and local variables
875: --
876: l_proc varchar2(72) := g_package||'update_cagr_grades';
877: l_object_version_number per_cagr_grades.object_version_number%TYPE;
878: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;
879: --
880: begin
881: --
882: hr_utility.set_location('Entering:'|| l_proc, 10);