APPS.HXC_RETRIEVAL_RULE_GRP_API dependencies on HXC_ENTITY_GROUPS

Line 26: l_object_version_number hxc_entity_groups.object_version_number%TYPE;

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_retrieval_rule_grp_id hxc_entity_groups.entity_group_id%TYPE;
28: --
29: begin
30: g_debug := hr_utility.debug_enabled;

Line 27: l_retrieval_rule_grp_id hxc_entity_groups.entity_group_id%TYPE;

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_retrieval_rule_grp_id hxc_entity_groups.entity_group_id%TYPE;
28: --
29: begin
30: g_debug := hr_utility.debug_enabled;
31: --

Line 171: l_object_version_number hxc_entity_groups.object_version_number%TYPE := p_object_version_number;

167: --
168: -- Declare cursors and local variables
169: --
170: l_proc varchar2(72);
171: l_object_version_number hxc_entity_groups.object_version_number%TYPE := p_object_version_number;
172: --
173: begin
174: g_debug := hr_utility.debug_enabled;
175: --

Line 417: p_name in hxc_entity_groups.name%TYPE

413: --
414: -- ----------------------------------------------------------------------------
415: Procedure chk_name
416: (
417: p_name in hxc_entity_groups.name%TYPE
418: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
419: ) IS
420:
421: l_proc varchar2(72);

Line 418: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE

414: -- ----------------------------------------------------------------------------
415: Procedure chk_name
416: (
417: p_name in hxc_entity_groups.name%TYPE
418: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
419: ) IS
420:
421: l_proc varchar2(72);
422: --

Line 430: FROM hxc_entity_groups heg

426: SELECT 'error'
427: FROM sys.dual
428: WHERE EXISTS (
429: SELECT 'x'
430: FROM hxc_entity_groups heg
431: WHERE heg.name = p_name
432: AND heg.entity_type = g_entity_type AND
433: ( heg.entity_group_id <> p_entity_group_id OR
434: p_entity_group_id IS NULL ) );

Line 490: p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE

486: --
487: -- ----------------------------------------------------------------------------
488: Procedure chk_delete
489: (
490: p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
491: ) IS
492: --
493: l_proc varchar2(72);
494: --