APPS.HXC_MAPPING_COMP_USAGE_API SQL Statements

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

Line: 158

procedure update_mapping_comp_usage
  (p_validate                       in  boolean   default false
  ,p_mapping_comp_usage_id          in  number
  ,p_object_version_number          in  out nocopy number
  ,p_mapping_id                     in
  ,p_mapping_component_id           in
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 175

  	l_proc := g_package||' update_mapping_comp_usage';

Line: 181

  savepoint update_mapping_comp_usage;

Line: 190

    hxc_mapping_comp_usage_BK_2.update_mapping_comp_usage_b
	  (p_mapping_comp_usage_id  => p_mapping_comp_usage_id
	  ,p_object_version_number  => p_object_version_number
          ,p_mapping_id             => p_mapping_id
          ,p_mapping_component_id   => p_mapping_component_id
  );

Line: 199

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

Line: 225

    hxc_mapping_comp_usage_BK_2.update_mapping_comp_usage_a
	  (p_mapping_comp_usage_id  => p_mapping_comp_usage_id
	  ,p_object_version_number  => l_object_version_number
          ,p_mapping_id             => p_mapping_id
          ,p_mapping_component_id   => p_mapping_component_id
  );

Line: 234

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

Line: 264

    ROLLBACK TO update_mapping_comp_usage;

Line: 283

    ROLLBACK TO update_mapping_comp_usage;

Line: 286

END update_mapping_comp_usage;

Line: 293

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

Line: 307

  	l_proc := g_package||'delete_mapping_comp_usage';

Line: 313

  savepoint delete_mapping_comp_usage;

Line: 323

    hxc_mapping_comp_usage_BK_3.delete_mapping_comp_usage_b
	  (p_mapping_comp_usage_id => p_mapping_comp_usage_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 330

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

Line: 355

  hxc_mapping_comp_usage_BK_3.delete_mapping_comp_usage_a
	  (p_mapping_comp_usage_id => p_mapping_comp_usage_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 362

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

Line: 384

    ROLLBACK TO delete_mapping_comp_usage;

Line: 390

    ROLLBACK TO delete_mapping_comp_usage;

Line: 393

end delete_mapping_comp_usage;