[Home] [Help]
326: --
327: -- call the rating scale row handler api to update the min step level
328: -- column in the rating scale table
329: --
330: per_rsc_upd.upd
331: (p_validate => FALSE
332: ,p_effective_date => p_effective_date
333: ,p_rating_scale_id => p_rating_scale_id
334: ,p_object_version_number => l_obj_ver_number_cpn_or_rsc
342: --
343: -- call the rating scale row handler api to update the max step level
344: -- column in the rating scale table
345: --
346: per_rsc_upd.upd
347: (p_validate => FALSE
348: ,p_effective_date => p_effective_date
349: ,p_rating_scale_id => p_rating_scale_id
350: ,p_object_version_number => l_obj_ver_number_cpn_or_rsc
951: --
952: -- call the rating scale row handler api to update the min scale step
953: -- column in the competence table
954: --
955: per_rsc_upd.upd
956: (p_validate => FALSE
957: ,p_effective_date => l_effective_date
958: ,p_rating_scale_id => l_rating_scale_id
959: ,p_object_version_number => l_obj_ver_number_cpn_or_rsc
967: --
968: -- call the rating scale row handler api to update the max scale step
969: -- column in the rating scale table
970: --
971: per_rsc_upd.upd
972: (p_validate => FALSE
973: ,p_effective_date => l_effective_date
974: ,p_rating_scale_id => l_rating_scale_id
975: ,p_object_version_number => l_obj_ver_number_cpn_or_rsc
988: and (l_min_step > l_min_scale_step)
989: and (l_min_step <= 0 )
990: ) then
991: --
992: per_rsc_upd.upd
993: (p_validate => FALSE
994: ,p_effective_date => l_effective_date
995: ,p_rating_scale_id => l_rating_scale_id
996: ,p_object_version_number => l_obj_ver_number_cpn_or_rsc
1006: and (l_max_step < l_max_scale_step)
1007: and (l_max_step >= 0 )
1008: ) then
1009: --
1010: per_rsc_upd.upd
1011: (p_validate => FALSE
1012: ,p_effective_date => l_effective_date
1013: ,p_rating_scale_id => l_rating_scale_id
1014: ,p_object_version_number => l_obj_ver_number_cpn_or_rsc