55: --
56: -- Declare cursors and local variables
57: --
58: l_proc varchar2(72);
59: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE;
60: l_application_set_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
61: --
62: begin
63: --
56: -- Declare cursors and local variables
57: --
58: l_proc varchar2(72);
59: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE;
60: l_application_set_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
61: --
62: begin
63: --
64: g_debug:=hr_utility.debug_enabled;
330: --
331: -- Declare cursors and local variables
332: --
333: l_proc varchar2(72);
334: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE := p_object_version_number;
335: --
336: begin
337: --
338: g_debug:=hr_utility.debug_enabled;
681: --
682: -- ----------------------------------------------------------------------------
683: Procedure chk_as_unique
684: (
685: p_application_set_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE
686: , p_application_set_id in hxc_entity_group_comps.entity_group_id%TYPE
687: , p_time_recipient_id in hxc_entity_group_comps.entity_id%TYPE
688: ) IS
689: --
682: -- ----------------------------------------------------------------------------
683: Procedure chk_as_unique
684: (
685: p_application_set_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE
686: , p_application_set_id in hxc_entity_group_comps.entity_group_id%TYPE
687: , p_time_recipient_id in hxc_entity_group_comps.entity_id%TYPE
688: ) IS
689: --
690: l_proc varchar2(72);
683: Procedure chk_as_unique
684: (
685: p_application_set_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE
686: , p_application_set_id in hxc_entity_group_comps.entity_group_id%TYPE
687: , p_time_recipient_id in hxc_entity_group_comps.entity_id%TYPE
688: ) IS
689: --
690: l_proc varchar2(72);
691: --
695: SELECT 'error'
696: FROM sys.dual
697: WHERE EXISTS (
698: SELECT 'x'
699: FROM hxc_entity_group_comps egc
700: WHERE egc.entity_group_id = p_application_set_id
701: AND egc.entity_id = p_time_recipient_id
702: AND ( egc.entity_group_comp_id <> p_application_set_comp_id
703: OR p_application_set_comp_id IS NULL ));
759: --
760: -- ----------------------------------------------------------------------------
761: Procedure chk_appl_as_unique
762: (
763: p_application_set_id in hxc_entity_group_comps.entity_group_id%TYPE
764: ) IS
765: --
766: l_proc varchar2(72);
767: --