APPS.HXC_TIME_SOURCE_API SQL Statements

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

Line: 153

procedure update_time_source
  (p_validate                       in  boolean   default false
  ,p_time_source_id                 in  hxc_time_sources.time_source_id%TYPE
  ,p_object_version_number          in  out nocopy hxc_time_sources.object_version_number%TYPE
  ,p_name                           in     hxc_time_sources.name%TYPE
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 169

  	l_proc := g_package||' update_time_source';

Line: 175

  savepoint update_time_source;

Line: 184

    hxc_time_source_BK_2.update_time_source_b
	  (p_time_source_id         => p_time_source_id
	  ,p_object_version_number  => p_object_version_number
	  ,p_name                   => p_name
  );

Line: 192

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

Line: 219

    hxc_time_source_BK_2.update_time_source_a
	  (p_time_source_id         => p_time_source_id
	  ,p_object_version_number  => l_object_version_number
	  ,p_name                   => p_name
  );

Line: 227

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

Line: 257

    ROLLBACK TO update_time_source;

Line: 276

    ROLLBACK TO update_time_source;

Line: 279

END update_time_source;

Line: 285

procedure delete_time_source
  (p_validate                       in  boolean  default false
  ,p_time_source_id                 in  hxc_time_sources.time_source_id%TYPE
  ,p_object_version_number          in  hxc_time_sources.object_version_number%TYPE
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 299

  	l_proc := g_package||'delete_time_source';

Line: 305

  savepoint delete_time_source;

Line: 315

    hxc_time_source_BK_3.delete_time_source_b
	  (p_time_source_id        => p_time_source_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 322

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

Line: 347

  hxc_time_source_BK_3.delete_time_source_a
	  (p_time_source_id        => p_time_source_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 354

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

Line: 376

    ROLLBACK TO delete_time_source;

Line: 382

    ROLLBACK TO delete_time_source;

Line: 385

end delete_time_source;