APPS.HXC_APPLICATION_SET_API dependencies on HXC_ENTITY_GROUPS

Line 25: l_object_version_number hxc_entity_groups.object_version_number%TYPE;

21: --
22: -- Declare cursors and local variables
23: --
24: l_proc varchar2(72);
25: l_object_version_number hxc_entity_groups.object_version_number%TYPE;
26: l_application_set_id hxc_entity_groups.entity_group_id%TYPE;
27: --
28: begin
29: --

Line 26: l_application_set_id hxc_entity_groups.entity_group_id%TYPE;

22: -- Declare cursors and local variables
23: --
24: l_proc varchar2(72);
25: l_object_version_number hxc_entity_groups.object_version_number%TYPE;
26: l_application_set_id hxc_entity_groups.entity_group_id%TYPE;
27: --
28: begin
29: --
30: g_debug:=hr_utility.debug_enabled;

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

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

Line 415: p_name in hxc_entity_groups.name%TYPE

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

Line 416: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE

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

Line 428: FROM hxc_entity_groups heg

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

Line 487: p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE

483: --
484: -- ----------------------------------------------------------------------------
485: Procedure chk_delete
486: (
487: p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
488: , p_entity_type in hxc_entity_group_comps.entity_type%TYPE
489: ) IS
490: --
491: l_proc varchar2(72);