APPS.PER_RI_CONFIG_INFORMATION_API SQL Statements

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

Line: 177

Procedure update_config_information
  (   p_validate                       In  Boolean   Default False
     ,p_config_information_id          In  Number
     ,p_configuration_code             In  Varchar2
     ,p_config_information_category    In  Varchar2
     ,p_config_sequence                In  Number    Default hr_api.g_number
     ,p_config_information1            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information2            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information3            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information4            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information5            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information6            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information7            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information8            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information9            In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information10           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information11           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information12           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information13           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information14           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information15           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information16           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information17           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information18           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information19           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information20           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information21           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information22           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information23           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information24           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information25           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information26           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information27           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information28           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information29           In  Varchar2  Default hr_api.g_varchar2
     ,p_config_information30           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_workbench_item';

Line: 234

  savepoint update_config_information;

Line: 320

    Rollback To update_config_information;

Line: 331

    Rollback To update_config_information;

Line: 338

End update_config_information;

Line: 343

Procedure delete_config_information
   (  p_validate                     In Boolean Default False
     ,p_config_information_id        In Number
     ,p_object_version_number        IN Number )

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

Line: 361

  Savepoint delete_workbench_item;

Line: 388

    Rollback To delete_config_information;

Line: 398

    Rollback To delete_config_information;

Line: 402

End delete_config_information;