DBA Data[Home] [Help]

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

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

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

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

Line 421: p_name in hxc_entity_groups.name%TYPE

417: --
418: -- ----------------------------------------------------------------------------
419: Procedure chk_name
420: (
421: p_name in hxc_entity_groups.name%TYPE
422: ,p_entity_type in hxc_entity_group_Comps.entity_type%TYPE
423: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
424: ) IS
425:

Line 423: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE

419: Procedure chk_name
420: (
421: p_name in hxc_entity_groups.name%TYPE
422: ,p_entity_type in hxc_entity_group_Comps.entity_type%TYPE
423: ,p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
424: ) IS
425:
426: l_proc varchar2(72);
427: --

Line 435: FROM hxc_entity_groups heg

431: SELECT 'error'
432: FROM sys.dual
433: WHERE EXISTS (
434: SELECT 'x'
435: FROM hxc_entity_groups heg
436: WHERE heg.name = p_name
437: AND heg.entity_type = p_entity_type AND
438: ( heg.entity_group_id <> p_entity_group_id OR
439: p_entity_group_id IS NULL ) );

Line 493: p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE

489: --
490: -- ----------------------------------------------------------------------------
491: Procedure chk_delete
492: (
493: p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
494: ,p_entity_type in hxc_entity_group_comps.entity_type%TYPE
495: ) IS
496: --
497: l_proc varchar2(72);