APPS.HXC_RETRIEVAL_RULE_GRP_API SQL Statements

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

Line: 161

procedure update_retrieval_rule_grp
  (p_validate                       in  boolean   default false
  ,p_retrieval_rule_grp_id       in  number
  ,p_object_version_number          in  out nocopy number
  ,p_name                           in     varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 177

  	l_proc := g_package||' update_retrieval_rule_grp';

Line: 183

  savepoint update_retrieval_rule_grp;

Line: 196

    hxc_retrieval_rule_grp_BK_2.update_retrieval_rule_grp_b
	  (p_retrieval_rule_grp_id             => p_retrieval_rule_grp_id
	  ,p_object_version_number  => p_object_version_number
	  ,p_name                   => p_name
  );

Line: 204

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

Line: 231

    hxc_retrieval_rule_grp_BK_2.update_retrieval_rule_grp_a
	  (p_retrieval_rule_grp_id => p_retrieval_rule_grp_id
	  ,p_object_version_number  => l_object_version_number
	  ,p_name                   => p_name
  );

Line: 239

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

Line: 269

    ROLLBACK TO update_retrieval_rule_grp;

Line: 288

    ROLLBACK TO update_retrieval_rule_grp;

Line: 291

END update_retrieval_rule_grp;

Line: 297

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

Line: 312

  	l_proc := g_package||'delete_retrieval_rule_grp';

Line: 318

  savepoint delete_retrieval_rule_grp;

Line: 320

	chk_delete ( p_entity_group_id => p_retrieval_rule_grp_id );

Line: 330

    hxc_retrieval_rule_grp_BK_3.delete_retrieval_rule_grp_b
	  (p_retrieval_rule_grp_id => p_retrieval_rule_grp_id
	  ,p_object_version_number    => p_object_version_number
	  );

Line: 337

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

Line: 362

  hxc_retrieval_rule_grp_BK_3.delete_retrieval_rule_grp_a
	  (p_retrieval_rule_grp_id            => p_retrieval_rule_grp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 369

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

Line: 391

    ROLLBACK TO delete_retrieval_rule_grp;

Line: 397

    ROLLBACK TO delete_retrieval_rule_grp;

Line: 400

end delete_retrieval_rule_grp;

Line: 426

SELECT 'error'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_entity_groups heg
	WHERE	heg.name	= p_name
	AND	heg.entity_type = g_entity_type AND
	( heg.entity_group_id <> p_entity_group_id OR
	  p_entity_group_id IS NULL ) );

Line: 488

Procedure chk_delete
  (
   p_entity_group_id in hxc_entity_groups.entity_group_id%TYPE
  ) IS
--
  l_proc  varchar2(72);

Line: 498

 SELECT 'exists'
 FROM	sys.dual
 WHERE	EXISTS (
	SELECT	'x'
	FROM    hxc_resource_all_elig_pref_v
	WHERE	preference_code = 'TS_PER_RETRIEVAL_RULES'
	AND	attribute1	= TO_CHAR(p_entity_group_id) );

Line: 513

  	l_proc := g_package||'chk_delete';

Line: 545

 END chk_delete;