APPS.HXC_TIME_ENTRY_GROUP_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_time_entry_group_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
62: --
63: begin
64:

Line 61: l_time_entry_group_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_time_entry_group_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE;
62: --
63: begin
64:
65: g_debug := hr_utility.debug_enabled;

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

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

Line 700: p_time_entry_group_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE

696: --
697: -- ----------------------------------------------------------------------------
698: Procedure chk_ter_unique
699: (
700: p_time_entry_group_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE
701: , p_time_entry_rule_group_id in hxc_entity_group_comps.entity_group_id%TYPE
702: , p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE
703: ) IS
704: --

Line 701: , p_time_entry_rule_group_id in hxc_entity_group_comps.entity_group_id%TYPE

697: -- ----------------------------------------------------------------------------
698: Procedure chk_ter_unique
699: (
700: p_time_entry_group_comp_id in hxc_entity_group_comps.entity_group_comp_id%TYPE
701: , p_time_entry_rule_group_id in hxc_entity_group_comps.entity_group_id%TYPE
702: , p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE
703: ) IS
704: --
705: l_proc varchar2(72);

Line 714: FROM hxc_entity_group_comps egc

710: SELECT 'error'
711: FROM sys.dual
712: WHERE EXISTS (
713: SELECT 'x'
714: FROM hxc_entity_group_comps egc
715: WHERE egc.entity_group_id = p_time_entry_rule_group_id
716: AND egc.entity_id = p_time_entry_rule_id
717: AND ( egc.entity_group_comp_id <> p_time_entry_group_comp_id
718: OR p_time_entry_group_comp_id IS NULL ));