22: --
23: -- Declare cursors and local variables
24: --
25: l_proc varchar2(72);
26: l_object_version_number hxc_entity_groups.object_version_number%TYPE;
27: l_time_entry_rule_group_id hxc_entity_groups.entity_group_id%TYPE;
28: --
29: begin
30: g_debug := hr_utility.debug_enabled;
23: -- Declare cursors and local variables
24: --
25: l_proc varchar2(72);
26: l_object_version_number hxc_entity_groups.object_version_number%TYPE;
27: l_time_entry_rule_group_id hxc_entity_groups.entity_group_id%TYPE;
28: --
29: begin
30: g_debug := hr_utility.debug_enabled;
31: --
168: --
169: -- Declare cursors and local variables
170: --
171: l_proc varchar2(72);
172: l_object_version_number hxc_entity_groups.object_version_number%TYPE := p_object_version_number;
173: --
174: begin
175: g_debug := hr_utility.debug_enabled;
176: --
417: --
418: -- ----------------------------------------------------------------------------
419: Procedure chk_name
420: (
421: p_name in hxc_entity_groups.name%TYPE
422: ,p_entity_type in hxc_entity_group_Comps.entity_type%TYPE
423: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
424: ) IS
425:
419: Procedure chk_name
420: (
421: p_name in hxc_entity_groups.name%TYPE
422: ,p_entity_type in hxc_entity_group_Comps.entity_type%TYPE
423: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
424: ) IS
425:
426: l_proc varchar2(72);
427: --
431: SELECT 'error'
432: FROM sys.dual
433: WHERE EXISTS (
434: SELECT 'x'
435: FROM hxc_entity_groups heg
436: WHERE heg.name = p_name
437: AND heg.entity_type = p_entity_type AND
438: ( heg.entity_group_id <> p_entity_group_id OR
439: p_entity_group_id IS NULL ) );
489: --
490: -- ----------------------------------------------------------------------------
491: Procedure chk_delete
492: (
493: p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
494: ,p_entity_type in hxc_entity_group_comps.entity_type%TYPE
495: ) IS
496: --
497: l_proc varchar2(72);