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_RATING_LEVELS_API dependencies on PER_COMPETENCES

Line 62: from per_competences

58: Cursor get_cpn_levels is
59: select min_level,
60: max_level,
61: object_version_number
62: from per_competences
63: where competence_id = p_competence_id;
64: --
65: -- Cursor to get min amd max levels from the
66: -- rating scale entity

Line 80: l_min_level per_competences.min_level%TYPE;

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

Line 81: l_max_level per_competences.max_level%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;
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: --

Line 694: l_competence_id per_competences.competence_id%TYPE;

690: p_object_version_number in number,
691: p_obj_ver_number_cpn_or_rsc out nocopy number
692: ) is
693: --
694: l_competence_id per_competences.competence_id%TYPE;
695: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
696: --
697: -- Declare cursors and local variables
698: --

Line 705: from per_competences cpn

701: --
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: --

Line 743: l_min_level per_competences.min_level%TYPE;

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;
747: l_effective_date date := to_date('01/01/1900','DD/MM/YYYY');

Line 744: l_max_level per_competences.max_level%TYPE;

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;
747: l_effective_date date := to_date('01/01/1900','DD/MM/YYYY');
748: -- the l_effective_date parameter is set as it is a mandatory parameter on the

Line 786: -- of competence from per_competences

782: -- Process Logic
783: -- 1) Get min and max step value from rating levels.
784: -- if inserting a rating level of competence then:
785: -- - get min_level, max_level,competence id and object version number
786: -- of competence from per_competences
787: -- if inserting a rating level of rating scale
788: -- - get min_level, max_level,rating scale id and object version number
789: -- of rating scale from per_rating_scales
790: -- 2) place lock on competence or rating scale

Line 871: -- whatever the value in the min_level column in per_competences

867: );
868: --
869: --
870: -- if there is only one step left then we want to make sure that
871: -- whatever the value in the min_level column in per_competences
872: -- table as long as the last value is not greater than 0, we need to
873: -- update the table with the new min value.
874: -- ** As a general rule the min_level column in per_competences
875: -- should not be greater than 0.

Line 874: -- ** As a general rule the min_level column in per_competences

870: -- if there is only one step left then we want to make sure that
871: -- whatever the value in the min_level column in per_competences
872: -- table as long as the last value is not greater than 0, we need to
873: -- update the table with the new min value.
874: -- ** As a general rule the min_level column in per_competences
875: -- should not be greater than 0.
876: --
877: elsif ( (l_min_step = l_max_step)
878: and (l_min_step > l_min_level)

Line 892: -- ** As a general rule, the max_level column in per_competences

888: );
889: --
890: -- Same as above but, this time for max_level column.
891: -- We want to make sure that the last value is not less than 0.
892: -- ** As a general rule, the max_level column in per_competences
893: -- should not be less than 0.
894: --
895: elsif ( (l_min_step = l_max_step)
896: and (l_max_step < l_max_level)

Line 1136: from per_competences

1132: and name = p_rating_scale_name;
1133:
1134: cursor csr_comp is
1135: select competence_id
1136: from per_competences
1137: where business_group_id is null
1138: and name = p_competence_name;
1139:
1140: begin