APPS.PER_RI_CONFIGURATION_API SQL Statements

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

Line: 126

Procedure update_configuration
  (   p_validate                       In  Boolean   Default False
     ,p_configuration_code             In  Varchar2
     ,p_configuration_type             In  Varchar2  Default hr_api.g_varchar2
     ,p_configuration_status           In  Varchar2  Default hr_api.g_varchar2
     ,p_configuration_name             In  Varchar2  Default hr_api.g_varchar2
     ,p_configuration_description      In  Varchar2  Default hr_api.g_varchar2
     ,p_language_code                  In  Varchar2  Default hr_api.userenv_lang
     ,p_effective_date                 In  Date
     ,p_object_version_number          In Out Nocopy Number
  ) Is
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'update_configuration';

Line: 154

  savepoint update_configuration;

Line: 218

    Rollback To update_configuration;

Line: 229

    Rollback To update_configuration;

Line: 236

End update_configuration;

Line: 241

Procedure delete_configuration
   (  p_validate                     In Boolean Default False
     ,p_configuration_code          In Varchar2
     ,p_object_version_number        IN Number )

Is
  --
  --
  -- Declare cursors and local variables
  --
  l_proc Varchar2(72) := g_package||'delete_configuration';

Line: 259

  Savepoint delete_configuration;

Line: 301

    Rollback To delete_configuration;

Line: 311

    Rollback To delete_configuration;

Line: 315

End delete_configuration;