APPS.PER_RI_CONFIG_LOCATION_API SQL Statements

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

Line: 162

Procedure update_location
  (   p_validate                       In  Boolean   Default False
     ,p_location_id                    In  Number
     ,p_configuration_code             In  Varchar2
     ,p_configuration_context          In  Varchar2
     ,p_location_code                  In  Varchar2
     ,p_description                    In  Varchar2  Default hr_api.g_varchar2
     ,p_style                          In  Varchar2  Default hr_api.g_varchar2
     ,p_address_line_1                 In  Varchar2  Default hr_api.g_varchar2
     ,p_address_line_2                 In  Varchar2  Default hr_api.g_varchar2
     ,p_address_line_3                 In  Varchar2  Default hr_api.g_varchar2
     ,p_town_or_city                   In  Varchar2  Default hr_api.g_varchar2
     ,p_country                        In  Varchar2  Default hr_api.g_varchar2
     ,p_postal_code                    In  Varchar2  Default hr_api.g_varchar2
     ,p_region_1                       In  Varchar2  Default hr_api.g_varchar2
     ,p_region_2                       In  Varchar2  Default hr_api.g_varchar2
     ,p_region_3                       In  Varchar2  Default hr_api.g_varchar2
     ,p_telephone_number_1             In  Varchar2  Default hr_api.g_varchar2
     ,p_telephone_number_2             In  Varchar2  Default hr_api.g_varchar2
     ,p_telephone_number_3             In  Varchar2  Default hr_api.g_varchar2
     ,p_loc_information13              In  Varchar2  Default hr_api.g_varchar2
     ,p_loc_information14              In  Varchar2  Default hr_api.g_varchar2
     ,p_loc_information15              In  Varchar2  Default hr_api.g_varchar2
     ,p_loc_information16              In  Varchar2  Default hr_api.g_varchar2
     ,p_loc_information17              In  Varchar2  Default hr_api.g_varchar2
     ,p_loc_information18              In  Varchar2  Default hr_api.g_varchar2
     ,p_loc_information19              In  Varchar2  Default hr_api.g_varchar2
     ,p_loc_information20              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_location';

Line: 211

  savepoint update_location;

Line: 289

    Rollback To update_location;

Line: 300

    Rollback To update_location;

Line: 307

End update_location;

Line: 312

Procedure delete_location
   (  p_validate                     In Boolean Default False
     ,p_location_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: 330

  Savepoint delete_workbench_item;

Line: 358

    Rollback To delete_location;

Line: 368

    Rollback To delete_location;

Line: 372

End delete_location;