APPS.HXC_TK_GROUP_QUERY_API dependencies on HXC_TK_GROUP_QUERIES

Line 68: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE;

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

Line 69: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;

65: -- Declare cursors and local variables
66: --
67: l_proc varchar2(72) ;
68: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE;
69: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;
70: --
71: begin
72: g_debug :=hr_utility.debug_enabled;
73: --

Line 269: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE := p_object_version_number;

265: --
266: -- Declare cursors and local variables
267: --
268: l_proc varchar2(72) ;
269: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE := p_object_version_number;
270: --
271: begin
272: --
273: g_debug :=hr_utility.debug_enabled;

Line 572: FROM hxc_tk_group_queries tegq

568: SELECT 'error'
569: FROM sys.dual
570: WHERE EXISTS (
571: SELECT 'x'
572: FROM hxc_tk_group_queries tegq
573: WHERE tegq.group_query_name = p_group_query_name
574: AND tegq.tk_group_id = p_tk_group_id
575: AND
576: ( tegq.tk_group_query_id <> p_tk_group_query_id OR

Line 714: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;

710:
711:
712: l_proc varchar2(72) ;
713:
714: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;
715: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE;
716:
717: CURSOR csr_chk_group_query IS
718: SELECT tkgq.tk_group_query_id

Line 715: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE;

711:
712: l_proc varchar2(72) ;
713:
714: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;
715: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE;
716:
717: CURSOR csr_chk_group_query IS
718: SELECT tkgq.tk_group_query_id
719: FROM hxc_tk_group_queries tkgq

Line 719: FROM hxc_tk_group_queries tkgq

715: l_object_version_number hxc_tk_group_queries.object_version_number%TYPE;
716:
717: CURSOR csr_chk_group_query IS
718: SELECT tkgq.tk_group_query_id
719: FROM hxc_tk_group_queries tkgq
720: WHERE tkgq.tk_group_id = p_tk_group_id;
721:
722: BEGIN
723: g_debug :=hr_utility.debug_enabled;