APPS.HXC_MAPPING_COMPONENT_API SQL Statements

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

Line: 166

procedure update_mapping_component
  (p_validate                       in  boolean   default false
  ,p_mapping_component_id           in  number
  ,p_object_version_number          in  out nocopy number
  ,p_name                           in     varchar2
  ,p_field_name                     in     varchar2
  ,p_bld_blk_info_type_id           in     number
  ,p_segment                        in     varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 185

  	l_proc := g_package||' update_mapping_component';

Line: 191

  savepoint update_mapping_component;

Line: 200

    hxc_mapping_component_BK_2.update_mapping_component_b
	  (p_mapping_component_id  => p_mapping_component_id
	  ,p_object_version_number  => p_object_version_number
	  ,p_name                   => p_name
	  ,p_field_name             => p_field_name
          ,p_bld_blk_info_type_id   => p_bld_blk_info_type_id
          ,p_segment                 => p_segment
  );

Line: 211

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

Line: 241

    hxc_mapping_component_BK_2.update_mapping_component_a
	  (p_mapping_component_id  => p_mapping_component_id
	  ,p_object_version_number  => l_object_version_number
	  ,p_name                   => p_name
	  ,p_field_name             => p_field_name
          ,p_bld_blk_info_type_id   => p_bld_blk_info_type_id
          ,p_segment                 => p_segment
  );

Line: 252

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

Line: 282

    ROLLBACK TO update_mapping_component;

Line: 301

    ROLLBACK TO update_mapping_component;

Line: 304

END update_mapping_component;

Line: 310

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

Line: 324

  	l_proc := g_package||'delete_mapping_component';

Line: 330

  savepoint delete_mapping_component;

Line: 340

	    hxc_mapping_component_BK_3.delete_mapping_component_b
	  (p_mapping_component_id => p_mapping_component_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 347

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

Line: 372

	hxc_mapping_component_BK_3.delete_mapping_component_a
	  (p_mapping_component_id => p_mapping_component_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 379

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

Line: 401

    ROLLBACK TO delete_mapping_component;

Line: 407

    ROLLBACK TO delete_mapping_component;

Line: 410

end delete_mapping_component;