[Home] [Help]
68: Cursor get_rsc_levels is
69: select min_scale_step,
70: max_scale_step,
71: object_version_number
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;
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: --
86: begin
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: --
86: begin
87: hr_utility.set_location('Entering:'|| l_proc, 5);
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: --
699: --
711: --
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: --
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
749: -- competence and the rating scale api's. The actual date value itself has no
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
749: -- competence and the rating scale api's. The actual date value itself has no
750: -- particular use at all and is not used for any sort of validation in the
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
791: -- 3) delete row in rating levels
792: -- 4) update competence or rating scale
793: --
976: ,p_max_scale_step => l_max_scale_step
977: );
978: --
979: -- if there is only one step left then we want to make sure that
980: -- whatever the value in the min_scale_step column in per_rating_scales
981: -- table as long as the last value is not greater than 0, we need to
982: -- update the table with the new min value.
983: -- ** As a general rule the min_scale_step column in per_rating_scales
984: -- should not be greater than 0.
979: -- if there is only one step left then we want to make sure that
980: -- whatever the value in the min_scale_step column in per_rating_scales
981: -- table as long as the last value is not greater than 0, we need to
982: -- update the table with the new min value.
983: -- ** As a general rule the min_scale_step column in per_rating_scales
984: -- should not be greater than 0.
985: --
986: --
987: elsif ( (l_min_step = l_max_step)
998: );
999: --
1000: -- Same as above but, this time for max_scale_step column.
1001: -- We want to make sure that the last value is not less than 0.
1002: -- ** As a general rule, the max_scale_step column in per_rating_scales
1003: -- should not be less than 0.
1004: --
1005: elsif ( (l_min_step = l_max_step)
1006: and (l_max_step < l_max_scale_step)
1126: and rating_scale_id = p_rating_scale_id;
1127:
1128: cursor csr_rsc is
1129: select rating_scale_id
1130: from per_rating_scales
1131: where business_group_id is null
1132: and name = p_rating_scale_name;
1133:
1134: cursor csr_comp is