APPS.HXC_TIMEKEEPER_GROUP_API dependencies on HXC_TK_GROUPS

Line 67: l_object_version_number hxc_tk_groups.object_version_number%TYPE;

63: --
64: -- Declare cursors and local variables
65: --
66: l_proc varchar2(72);
67: l_object_version_number hxc_tk_groups.object_version_number%TYPE;
68: l_tk_group_id hxc_tk_groups.tk_group_id%TYPE;
69: --
70: begin
71: g_debug := hr_utility.debug_enabled;

Line 68: l_tk_group_id hxc_tk_groups.tk_group_id%TYPE;

64: -- Declare cursors and local variables
65: --
66: l_proc varchar2(72);
67: l_object_version_number hxc_tk_groups.object_version_number%TYPE;
68: l_tk_group_id hxc_tk_groups.tk_group_id%TYPE;
69: --
70: begin
71: g_debug := hr_utility.debug_enabled;
72: --

Line 265: l_object_version_number hxc_tk_groups.object_version_number%TYPE := p_object_version_number;

261: --
262: -- Declare cursors and local variables
263: --
264: l_proc varchar2(72);
265: l_object_version_number hxc_tk_groups.object_version_number%TYPE := p_object_version_number;
266: --
267: begin
268: g_debug := hr_utility.debug_enabled;
269: --

Line 569: FROM hxc_tk_groups teg

565: SELECT 'error'
566: FROM sys.dual
567: WHERE EXISTS (
568: SELECT 'x'
569: FROM hxc_tk_groups teg
570: WHERE teg.tk_group_name = p_tk_group_name
571: AND teg.tk_resource_id = p_tk_resource_id
572: AND
573: ( teg.tk_group_id <> p_tk_group_id OR