DBA Data[Home] [Help]

APPS.HXC_ALIAS_TYPES_API SQL Statements

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

Line: 140

procedure update_alias_types
  (p_validate                      in     boolean  default false,
   p_alias_type                    in     varchar2,
   p_reference_object              in     varchar2,
   p_alias_type_id                 in     number,
   p_object_version_number         in out nocopy    number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number  hxc_alias_types.object_version_number%TYPE := p_object_version_number;
Line: 155

	l_proc := g_package||'update_alias_types';
Line: 161

  savepoint update_alias_types;
Line: 169

    hxc_alias_types_bk1.update_alias_types_b
      (p_alias_type            => p_alias_type,
       p_reference_object      => p_reference_object,
       p_alias_type_id         => p_alias_type_id,
       p_object_version_number => p_object_version_number
      );
Line: 199

     hxc_alias_types_bk1.update_alias_types_a
      (p_alias_type            => p_alias_type,
       p_reference_object      => p_reference_object,
       p_alias_type_id         => p_alias_type_id,
       p_object_version_number => p_object_version_number
      );
Line: 208

        (p_module_name => 'update_alias_types'
        ,p_hook_type   => 'AP'
        );
Line: 233

    rollback to update_alias_types;
Line: 246

    rollback to update_alias_types;
Line: 251

end update_alias_types;
Line: 258

procedure delete_alias_types
  (p_validate                      in     boolean default FALSE,
   p_alias_type_id                 in     number,
   p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72);
Line: 271

	l_proc := g_package||'delete_alias_types';
Line: 277

  savepoint delete_alias_types;
Line: 288

    hxc_alias_types_bk1.delete_alias_types_b
      (p_alias_type_id                 => p_alias_type_id,
       p_object_version_number         => p_object_version_number
      );
Line: 295

        (p_module_name => 'delete_alias_types'
        ,p_hook_type   => 'BP'
        );
Line: 321

     hxc_alias_types_bk1.delete_alias_types_a
      (p_alias_type_id         => p_alias_type_id,
       p_object_version_number => p_object_version_number
      );
Line: 328

        (p_module_name => 'delete_alias_types'
        ,p_hook_type   => 'AP'
        );
Line: 355

    rollback to delete_alias_types;
Line: 368

    rollback to delete_alias_types;
Line: 373

end delete_alias_types;