APPS.PER_RI_CONFIG_LOCATION_SWI SQL Statements

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

Line: 163

PROCEDURE update_location
  (p_validate                     in     number    default hr_api.g_false_num
  ,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.g_varchar2
  ,p_effective_date               in     date
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 204

  l_proc    varchar2(72) := g_package ||'update_location';

Line: 210

  savepoint update_location_swi;

Line: 231

  per_ri_config_location_api.update_location
    (p_validate                     => l_validate
    ,p_location_id                  => p_location_id
    ,p_configuration_code           => p_configuration_code
    ,p_configuration_context        => p_configuration_context
    ,p_location_code                => p_location_code
    ,p_description                  => p_description
    ,p_style                        => p_style
    ,p_address_line_1               => p_address_line_1
    ,p_address_line_2               => p_address_line_2
    ,p_address_line_3               => p_address_line_3
    ,p_town_or_city                 => p_town_or_city
    ,p_country                      => p_country
    ,p_postal_code                  => p_postal_code
    ,p_region_1                     => p_region_1
    ,p_region_2                     => p_region_2
    ,p_region_3                     => p_region_3
    ,p_telephone_number_1           => p_telephone_number_1
    ,p_telephone_number_2           => p_telephone_number_2
    ,p_telephone_number_3           => p_telephone_number_3
    ,p_loc_information13            => p_loc_information13
    ,p_loc_information14            => p_loc_information14
    ,p_loc_information15            => p_loc_information15
    ,p_loc_information16            => p_loc_information16
    ,p_loc_information17            => p_loc_information17
    ,p_loc_information18            => p_loc_information18
    ,p_loc_information19            => p_loc_information19
    ,p_loc_information20            => p_loc_information20
    ,p_language_code                => p_language_code
    ,p_effective_date               => p_effective_date
    ,p_object_version_number        => p_object_version_number
    );

Line: 285

    rollback to update_location_swi;

Line: 300

    rollback to update_location_swi;

Line: 311

end update_location;

Line: 315

PROCEDURE delete_location
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_location_id                  in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 328

  l_proc    varchar2(72) := g_package ||'delete_location';

Line: 334

  savepoint delete_location_swi;

Line: 354

  per_ri_config_location_api.delete_location
    (p_validate                     => l_validate
    ,p_location_id                  => p_location_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 381

    rollback to delete_location_swi;

Line: 395

    rollback to delete_location_swi;

Line: 405

end delete_location;