APPS.HXC_RET_RULE_GRP_COMP_API dependencies on HXC_ENTITY_GROUP_COMPS

Line 60: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE;

56: --
57: -- Declare cursors and local variables
58: --
59: l_proc varchar2(72);
60: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE;
61: l_ret_rule_grp_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
62: --
63: begin
64: g_debug := hr_utility.debug_enabled;

Line 61: l_ret_rule_grp_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;

57: -- Declare cursors and local variables
58: --
59: l_proc varchar2(72);
60: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE;
61: l_ret_rule_grp_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
62: --
63: begin
64: g_debug := hr_utility.debug_enabled;
65: --

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

333: --
334: -- Declare cursors and local variables
335: --
336: l_proc varchar2(72);
337: l_object_version_number hxc_entity_group_comps.object_version_number%TYPE := p_object_version_number;
338: --
339: begin
340: g_debug := hr_utility.debug_enabled;
341: --

Line 692: p_ret_rule_grp_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE

688: --
689: -- ----------------------------------------------------------------------------
690: Procedure chk_rr_unique
691: (
692: p_ret_rule_grp_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE
693: , p_retrieval_rule_grp_id in hxc_entity_group_comps.entity_group_id%TYPE
694: , p_retrieval_rule_id in hxc_entity_group_comps.entity_id%TYPE
695: ) IS
696: --

Line 693: , p_retrieval_rule_grp_id in hxc_entity_group_comps.entity_group_id%TYPE

689: -- ----------------------------------------------------------------------------
690: Procedure chk_rr_unique
691: (
692: p_ret_rule_grp_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE
693: , p_retrieval_rule_grp_id in hxc_entity_group_comps.entity_group_id%TYPE
694: , p_retrieval_rule_id in hxc_entity_group_comps.entity_id%TYPE
695: ) IS
696: --
697: l_proc varchar2(72);

Line 694: , p_retrieval_rule_id in hxc_entity_group_comps.entity_id%TYPE

690: Procedure chk_rr_unique
691: (
692: p_ret_rule_grp_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE
693: , p_retrieval_rule_grp_id in hxc_entity_group_comps.entity_group_id%TYPE
694: , p_retrieval_rule_id in hxc_entity_group_comps.entity_id%TYPE
695: ) IS
696: --
697: l_proc varchar2(72);
698: --

Line 706: FROM hxc_entity_group_comps egc

702: SELECT 'error'
703: FROM sys.dual
704: WHERE EXISTS (
705: SELECT 'x'
706: FROM hxc_entity_group_comps egc
707: WHERE egc.entity_group_id = p_retrieval_rule_grp_id
708: AND egc.entity_id = p_retrieval_rule_id
709: AND ( egc.entity_group_comp_id <> p_ret_rule_grp_comp_id
710: OR p_ret_rule_grp_comp_id IS NULL ));