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.

[Home] [Help]

APPS.HR_RATING_LEVELS_API dependencies on PER_RATING_LEVELS

Line 76: l_rating_level_id per_rating_levels.rating_level_id%TYPE;

72: from per_rating_scales
73: where rating_scale_id = p_rating_scale_id;
74: --
75: l_proc varchar2(72) := g_package||'create_rating_level';
76: l_rating_level_id per_rating_levels.rating_level_id%TYPE;
77: l_object_version_number per_rating_levels.object_version_number%TYPE;
78: l_obj_ver_number_cpn_or_rsc number;
79: --
80: l_min_level per_competences.min_level%TYPE;

Line 77: l_object_version_number per_rating_levels.object_version_number%TYPE;

73: where rating_scale_id = p_rating_scale_id;
74: --
75: l_proc varchar2(72) := g_package||'create_rating_level';
76: l_rating_level_id per_rating_levels.rating_level_id%TYPE;
77: l_object_version_number per_rating_levels.object_version_number%TYPE;
78: l_obj_ver_number_cpn_or_rsc number;
79: --
80: l_min_level per_competences.min_level%TYPE;
81: l_max_level per_competences.max_level%TYPE;

Line 84: l_language_code per_rating_levels_tl.language%TYPE;

80: l_min_level per_competences.min_level%TYPE;
81: l_max_level per_competences.max_level%TYPE;
82: l_min_scale_step per_rating_scales.min_scale_step%TYPE;
83: l_max_scale_step per_rating_scales.max_scale_step%TYPE;
84: l_language_code per_rating_levels_tl.language%TYPE;
85: --
86: begin
87: hr_utility.set_location('Entering:'|| l_proc, 5);
88: --

Line 495: l_object_version_number per_rating_levels.object_version_number%TYPE;

491: --
492: -- Declare cursors and local variables
493: --
494: l_proc varchar2(72) := g_package||'update_rating_level';
495: l_object_version_number per_rating_levels.object_version_number%TYPE;
496: l_language_code per_rating_levels_tl.language%TYPE;
497: begin
498: hr_utility.set_location('Entering:'|| l_proc, 5);
499: --

Line 496: l_language_code per_rating_levels_tl.language%TYPE;

492: -- Declare cursors and local variables
493: --
494: l_proc varchar2(72) := g_package||'update_rating_level';
495: l_object_version_number per_rating_levels.object_version_number%TYPE;
496: l_language_code per_rating_levels_tl.language%TYPE;
497: begin
498: hr_utility.set_location('Entering:'|| l_proc, 5);
499: --
500: -- Issue a savepoint.

Line 706: ,per_rating_levels rtl

702: Cursor get_competence_values is
703: select cpn.competence_id,cpn.object_version_number
704: ,cpn.min_level, cpn.max_level
705: from per_competences cpn
706: ,per_rating_levels rtl
707: where rtl.competence_id = cpn.competence_id
708: and rtl.rating_level_id = p_rating_level_id;
709: --
710: -- Get values from rating scale table

Line 716: ,per_rating_levels rtl

712: Cursor get_rating_scale_values is
713: select rsc.rating_scale_id,rsc.object_version_number
714: ,rsc.min_scale_step, rsc.max_scale_step
715: from per_rating_scales rsc
716: ,per_rating_levels rtl
717: where rtl.rating_scale_id = rsc.rating_scale_id
718: and rtl.rating_level_id = p_rating_level_id;
719: --
720: -- Cursor to get min and max rating levels for

Line 725: from per_rating_levels

721: -- competence from the rating level table.
722: --
723: Cursor get_cpn_levels is
724: select min(step_value), max(step_value)
725: from per_rating_levels
726: where competence_id = l_competence_id;
727: --
728: --
729: -- Cursor to get min and max levels for

Line 734: from per_rating_levels

730: -- rating scale from the rating level table.
731: --
732: Cursor get_rsc_levels is
733: select min(step_value), max(step_value)
734: from per_rating_levels
735: where rating_scale_id = l_rating_scale_id;
736: --
737: --
738: l_proc varchar2(72) := g_package||'delete_rating_level';

Line 741: l_min_step per_rating_levels.step_value%TYPE;

737: --
738: l_proc varchar2(72) := g_package||'delete_rating_level';
739: l_obj_ver_number_cpn_or_rsc number;
740: --
741: l_min_step per_rating_levels.step_value%TYPE;
742: l_max_step per_rating_levels.step_value%TYPE;
743: l_min_level per_competences.min_level%TYPE;
744: l_max_level per_competences.max_level%TYPE;
745: l_min_scale_step per_rating_scales.min_scale_step%TYPE;

Line 742: l_max_step per_rating_levels.step_value%TYPE;

738: l_proc varchar2(72) := g_package||'delete_rating_level';
739: l_obj_ver_number_cpn_or_rsc number;
740: --
741: l_min_step per_rating_levels.step_value%TYPE;
742: l_max_step per_rating_levels.step_value%TYPE;
743: l_min_level per_competences.min_level%TYPE;
744: l_max_level per_competences.max_level%TYPE;
745: l_min_scale_step per_rating_scales.min_scale_step%TYPE;
746: l_max_scale_step per_rating_scales.max_scale_step%TYPE;

Line 1107: l_rating_level_id per_rating_levels.rating_level_id%TYPE;

1103: --
1104: -- Declare cursor and local variables
1105: --
1106: l_proc varchar2(72) := g_package||'create_or_update_rating_level';
1107: l_rating_level_id per_rating_levels.rating_level_id%TYPE;
1108: l_source_rating_level_id per_rating_levels.rating_level_id%TYPE;
1109: l_rating_scale_id per_rating_levels.rating_scale_id%TYPE;
1110: l_step_value per_rating_levels.step_value%TYPE;
1111: l_competence_id per_rating_levels.competence_id%TYPE;

Line 1108: l_source_rating_level_id per_rating_levels.rating_level_id%TYPE;

1104: -- Declare cursor and local variables
1105: --
1106: l_proc varchar2(72) := g_package||'create_or_update_rating_level';
1107: l_rating_level_id per_rating_levels.rating_level_id%TYPE;
1108: l_source_rating_level_id per_rating_levels.rating_level_id%TYPE;
1109: l_rating_scale_id per_rating_levels.rating_scale_id%TYPE;
1110: l_step_value per_rating_levels.step_value%TYPE;
1111: l_competence_id per_rating_levels.competence_id%TYPE;
1112: l_ovn per_rating_levels.object_version_number%TYPE;

Line 1109: l_rating_scale_id per_rating_levels.rating_scale_id%TYPE;

1105: --
1106: l_proc varchar2(72) := g_package||'create_or_update_rating_level';
1107: l_rating_level_id per_rating_levels.rating_level_id%TYPE;
1108: l_source_rating_level_id per_rating_levels.rating_level_id%TYPE;
1109: l_rating_scale_id per_rating_levels.rating_scale_id%TYPE;
1110: l_step_value per_rating_levels.step_value%TYPE;
1111: l_competence_id per_rating_levels.competence_id%TYPE;
1112: l_ovn per_rating_levels.object_version_number%TYPE;
1113: l_source_ovn per_rating_levels.object_version_number%TYPE;

Line 1110: l_step_value per_rating_levels.step_value%TYPE;

1106: l_proc varchar2(72) := g_package||'create_or_update_rating_level';
1107: l_rating_level_id per_rating_levels.rating_level_id%TYPE;
1108: l_source_rating_level_id per_rating_levels.rating_level_id%TYPE;
1109: l_rating_scale_id per_rating_levels.rating_scale_id%TYPE;
1110: l_step_value per_rating_levels.step_value%TYPE;
1111: l_competence_id per_rating_levels.competence_id%TYPE;
1112: l_ovn per_rating_levels.object_version_number%TYPE;
1113: l_source_ovn per_rating_levels.object_version_number%TYPE;
1114: l_obj_ver_number_cpn_or_rsc number;

Line 1111: l_competence_id per_rating_levels.competence_id%TYPE;

1107: l_rating_level_id per_rating_levels.rating_level_id%TYPE;
1108: l_source_rating_level_id per_rating_levels.rating_level_id%TYPE;
1109: l_rating_scale_id per_rating_levels.rating_scale_id%TYPE;
1110: l_step_value per_rating_levels.step_value%TYPE;
1111: l_competence_id per_rating_levels.competence_id%TYPE;
1112: l_ovn per_rating_levels.object_version_number%TYPE;
1113: l_source_ovn per_rating_levels.object_version_number%TYPE;
1114: l_obj_ver_number_cpn_or_rsc number;
1115: l_effective_date date;

Line 1112: l_ovn per_rating_levels.object_version_number%TYPE;

1108: l_source_rating_level_id per_rating_levels.rating_level_id%TYPE;
1109: l_rating_scale_id per_rating_levels.rating_scale_id%TYPE;
1110: l_step_value per_rating_levels.step_value%TYPE;
1111: l_competence_id per_rating_levels.competence_id%TYPE;
1112: l_ovn per_rating_levels.object_version_number%TYPE;
1113: l_source_ovn per_rating_levels.object_version_number%TYPE;
1114: l_obj_ver_number_cpn_or_rsc number;
1115: l_effective_date date;
1116: l_language_code varchar2(10);

Line 1113: l_source_ovn per_rating_levels.object_version_number%TYPE;

1109: l_rating_scale_id per_rating_levels.rating_scale_id%TYPE;
1110: l_step_value per_rating_levels.step_value%TYPE;
1111: l_competence_id per_rating_levels.competence_id%TYPE;
1112: l_ovn per_rating_levels.object_version_number%TYPE;
1113: l_source_ovn per_rating_levels.object_version_number%TYPE;
1114: l_obj_ver_number_cpn_or_rsc number;
1115: l_effective_date date;
1116: l_language_code varchar2(10);
1117: l_translated_language varchar2(20);

Line 1122: from per_rating_levels

1118:
1119: cursor csr_rtl(p_rating_level_name in varchar2
1120: ,p_rating_scale_id in number) is
1121: select rating_level_id , object_version_number , step_value
1122: from per_rating_levels
1123: where business_group_id is null
1124: and name = p_rating_level_name
1125: and step_value = p_step_value
1126: and rating_scale_id = p_rating_scale_id;