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_GRADE_SCALE_API dependencies on PER_GRADE_SPINES_F

Line 20: FROM per_grade_spines_f pgs

16: RETURN NUMBER
17: IS
18: CURSOR csr_starting_step IS
19: SELECT nvl(pgs.starting_step,1)
20: FROM per_grade_spines_f pgs
21: WHERE pgs.grade_spine_id = p_grade_spine_id
22: AND p_effective_date between pgs.effective_start_date
23: and pgs.effective_end_date;
24:

Line 25: l_starting_step per_grade_spines_f.starting_step%TYPE;

21: WHERE pgs.grade_spine_id = p_grade_spine_id
22: AND p_effective_date between pgs.effective_start_date
23: and pgs.effective_end_date;
24:
25: l_starting_step per_grade_spines_f.starting_step%TYPE;
26:
27: BEGIN
28:
29: OPEN csr_starting_step;

Line 69: l_grade_spine_id per_grade_spines_f.grade_spine_id%TYPE;

65:
66: --
67: -- Declare out parameters
68: --
69: l_grade_spine_id per_grade_spines_f.grade_spine_id%TYPE;
70: l_ceiling_step_id per_grade_spines_f.ceiling_step_id%TYPE;
71: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
72: l_effective_start_date date;
73: l_effective_end_date date;

Line 70: l_ceiling_step_id per_grade_spines_f.ceiling_step_id%TYPE;

66: --
67: -- Declare out parameters
68: --
69: l_grade_spine_id per_grade_spines_f.grade_spine_id%TYPE;
70: l_ceiling_step_id per_grade_spines_f.ceiling_step_id%TYPE;
71: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
72: l_effective_start_date date;
73: l_effective_end_date date;
74:

Line 71: l_object_version_number per_grade_spines_f.object_version_number%TYPE;

67: -- Declare out parameters
68: --
69: l_grade_spine_id per_grade_spines_f.grade_spine_id%TYPE;
70: l_ceiling_step_id per_grade_spines_f.ceiling_step_id%TYPE;
71: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
72: l_effective_start_date date;
73: l_effective_end_date date;
74:
75: --

Line 179: -- Update ceiling_step_id in per_grade_spines_f

175: );
176: --
177: hr_utility.set_location(l_proc, 60);
178: --
179: -- Update ceiling_step_id in per_grade_spines_f
180: --
181: per_pgs_upd.upd
182: (p_effective_date => l_effective_date
183: ,p_datetrack_mode => 'CORRECTION'

Line 312: lv_object_version_number per_grade_spines_f.object_version_number%TYPE;

308: -- Declare cursors and local variables
309: --
310: l_proc varchar2(72) := g_package||'update_grade_scale';
311: l_effective_date date;
312: lv_object_version_number per_grade_spines_f.object_version_number%TYPE;
313:
314: --
315: -- Declare out parameters
316: --

Line 317: l_object_version_number per_grade_spines_f.object_version_number%TYPE;

313:
314: --
315: -- Declare out parameters
316: --
317: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
318: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;
319: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;
320:
321: --

Line 318: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;

314: --
315: -- Declare out parameters
316: --
317: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
318: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;
319: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;
320:
321: --
322: begin

Line 319: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;

315: -- Declare out parameters
316: --
317: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
318: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;
319: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;
320:
321: --
322: begin
323: --

Line 551: from per_grade_spines_f

547: and p_eff_date between effective_start_date and effective_end_date;
548: --
549: Cursor csr_grade_spine_esd IS
550: select min(effective_start_date)
551: from per_grade_spines_f
552: where grade_spine_id = p_grade_spine_id;
553: --
554: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
555: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;

Line 723: lv_object_version_number per_grade_spines_f.object_version_number%TYPE;

719: -- Declare cursors and local variables
720: --
721: l_proc varchar2(72) := g_package||'delete_grade_scale';
722: l_effective_date date;
723: lv_object_version_number per_grade_spines_f.object_version_number%TYPE;
724:
725:
726: --
727: -- Declare out variables

Line 729: l_object_version_number per_grade_spines_f.object_version_number%TYPE;

725:
726: --
727: -- Declare out variables
728: --
729: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
730: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;
731: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;
732: --
733: begin

Line 730: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;

726: --
727: -- Declare out variables
728: --
729: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
730: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;
731: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;
732: --
733: begin
734: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 731: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;

727: -- Declare out variables
728: --
729: l_object_version_number per_grade_spines_f.object_version_number%TYPE;
730: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;
731: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;
732: --
733: begin
734: hr_utility.set_location('Entering:'|| l_proc, 10);
735: