APPS.HXC_APPLICATION_SET_COMP_API dependencies on HXC_ENTITY_GROUP_COMPS

Line 59: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE;

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

Line 60: l_application_set_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;

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;

Line 334: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE := p_object_version_number;

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;

Line 685: p_application_set_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE

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

Line 686: , p_application_set_id in hxc_entity_group_comps.entity_group_id%TYPE

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

Line 687: , p_time_recipient_id in hxc_entity_group_comps.entity_id%TYPE

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

Line 699: FROM hxc_entity_group_comps egc

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

Line 763: p_application_set_id in hxc_entity_group_comps.entity_group_id%TYPE

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