APPS.HXC_TK_GROUP_QUERY_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 256

procedure update_tk_group_query
  (p_validate                       in  boolean   default false
  ,p_tk_group_id                    in  number
  ,p_tk_group_query_id              in  number
  ,p_object_version_number          in  out nocopy number
  ,p_group_query_name                  in     varchar2
  ,p_include_exclude                in  varchar2
  ,p_system_user                    in  varchar2)
IS
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72) ;

Line: 275

  	  l_proc := g_package||' update_tk_group_query';

Line: 281

  savepoint update_tk_group_query;

Line: 297

    hxc_tk_group_query_BK_2.update_tk_group_query_b
	  (p_tk_group_query_id      => p_tk_group_query_id
	  ,p_tk_group_id            => p_tk_group_id
	  ,p_object_version_number  => p_object_version_number
	  ,p_group_query_name          => p_group_query_name
          ,p_include_exclude    => p_include_exclude
          ,p_system_user        => p_system_user
  );

Line: 308

        (p_module_name => 'update_tk_group_query'
        ,p_hook_type   => 'BP'
        );

Line: 337

    hxc_tk_group_query_BK_2.update_tk_group_query_a
	  (p_tk_group_query_id      => p_tk_group_query_id
	  ,p_tk_group_id            => p_tk_group_id
	  ,p_object_version_number  => l_object_version_number
	  ,p_group_query_name          => p_group_query_name
          ,p_include_exclude    => p_include_exclude
          ,p_system_user        => p_system_user
  );

Line: 348

        (p_module_name => 'update_tk_group_query'
        ,p_hook_type   => 'AP'
        );

Line: 378

    ROLLBACK TO update_tk_group_query;

Line: 397

    ROLLBACK TO update_tk_group_query;

Line: 400

end update_tk_group_query;

Line: 438

procedure delete_tk_group_query
  (p_validate                       in  boolean  default false
  ,p_tk_group_query_id              in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) ;

Line: 453

  	  l_proc := g_package||'delete_tk_group_query';

Line: 459

  savepoint delete_tk_group_query;

Line: 461

	hxc_tk_group_query_api.chk_delete (
				 p_tk_group_query_id => p_tk_group_query_id );

Line: 472

    hxc_tk_group_query_BK_3.delete_tk_group_query_b
	  (p_tk_group_query_id     => p_tk_group_query_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 479

        (p_module_name => 'delete_tk_group_query'
        ,p_hook_type   => 'BP'
        );

Line: 504

  hxc_tk_group_query_BK_3.delete_tk_group_query_a
	  (p_tk_group_query_id     => p_tk_group_query_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 511

        (p_module_name => 'delete_tk_group_query'
        ,p_hook_type   => 'AP'
        );

Line: 533

    ROLLBACK TO delete_tk_group_query;

Line: 539

    ROLLBACK TO delete_tk_group_query;

Line: 542

end delete_tk_group_query;

Line: 568

SELECT 'error'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_tk_group_queries tegq
	WHERE	tegq.group_query_name	= p_group_query_name
        AND     tegq.tk_group_id        = p_tk_group_id
        AND
	( tegq.tk_group_query_id <> p_tk_group_query_id OR
	  p_tk_group_query_id IS NULL ) );

Line: 642

SELECT	'x'
FROM 	dual
WHERE EXISTS ( SELECT 'x'
               FROM   hxc_tk_groups tkg
               WHERE  tkg.tk_group_id = p_tk_group_id );

Line: 685

Procedure chk_delete
  (
   p_tk_group_query_id in number
  ) IS
BEGIN
null;

Line: 691

END chk_delete;

Line: 718

SELECT tkgq.tk_group_query_id
FROM   hxc_tk_group_queries tkgq
WHERE  tkgq.tk_group_id = p_tk_group_id;