APPS.HXC_TIME_CATEGORY_COMP_API SQL Statements

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

Line: 181

procedure update_time_category_comp
  (p_validate                       in  boolean   default false
  ,p_time_category_comp_id           in  number
  ,p_object_version_number          in  out nocopy number
  ,p_time_category_id             number
  ,p_ref_time_category_id         number
  ,p_component_type_id            number
  ,p_flex_value_set_id            number
  ,p_value_id                     Varchar2
  ,p_is_null                        in varchar2
  ,p_equal_to                       in varchar2
  ,p_type                           in varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 204

  	l_proc := g_package||' update_time_category_comp';

Line: 210

  savepoint update_time_category_comp;

Line: 219

    hxc_time_category_comp_BK_2.update_time_category_comp_b
  (p_time_category_comp_id    => p_time_category_comp_id
  ,p_object_version_number    => p_object_version_number
  ,p_time_category_id         => p_time_category_id
  ,p_ref_time_category_id     => p_ref_time_category_id
  ,p_component_type_id        => p_component_type_id
  ,p_flex_value_set_id        => p_flex_value_set_id
  ,p_value_id                 => p_value_id
  ,p_is_null                  => p_is_null
  ,p_equal_to                 => p_equal_to
  ,p_type                     => p_type
  );

Line: 234

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

Line: 268

    hxc_time_category_comp_BK_2.update_time_category_comp_a
	  (p_time_category_comp_id   => p_time_category_comp_id
	 ,p_object_version_number    => l_object_version_number
         ,p_time_category_id         => p_time_category_id
         ,p_ref_time_category_id     => p_ref_time_category_id
         ,p_component_type_id        => p_component_type_id
         ,p_flex_value_set_id        => p_flex_value_set_id
         ,p_value_id                 => p_value_id
         ,p_is_null                  => p_is_null
         ,p_equal_to                 => p_equal_to
         ,p_type                     => p_type
        );

Line: 283

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

Line: 313

    ROLLBACK TO update_time_category_comp;

Line: 332

    ROLLBACK TO update_time_category_comp;

Line: 335

END update_time_category_comp;

Line: 341

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

Line: 355

  	l_proc := g_package||'delete_time_category_comp';

Line: 361

  savepoint delete_time_category_comp;

Line: 371

	    hxc_time_category_comp_BK_3.delete_time_category_comp_b
	  (p_time_category_comp_id => p_time_category_comp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 378

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

Line: 403

	hxc_time_category_comp_BK_3.delete_time_category_comp_a
	  (p_time_category_comp_id => p_time_category_comp_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 410

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

Line: 432

    ROLLBACK TO delete_time_category_comp;

Line: 438

    ROLLBACK TO delete_time_category_comp;

Line: 441

end delete_time_category_comp;