eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_ADDRESS_SWI SQL Statements

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

Line: 223


PROCEDURE update_person_address
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_validate_county              in     number    default hr_api.g_true_num
  ,p_address_id                   in     number
  ,p_object_version_number        in out nocopy number
  ,p_date_from                    in     date      default hr_api.g_date
  ,p_date_to                      in     date      default hr_api.g_date
  ,p_address_type                 in     varchar2  default hr_api.g_varchar2
  ,p_comments                     in     long      default hr_api.g_varchar2
  ,p_address_line1                in     varchar2  default hr_api.g_varchar2
  ,p_address_line2                in     varchar2  default hr_api.g_varchar2
  ,p_address_line3                in     varchar2  default hr_api.g_varchar2
  ,p_town_or_city                 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_postal_code                  in     varchar2  default hr_api.g_varchar2
  ,p_country                      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_addr_attribute_category      in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute1              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute2              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute3              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute4              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute5              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute6              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute7              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute8              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute9              in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute10             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute11             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute12             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute13             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute14             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute15             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute16             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute17             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute18             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute19             in     varchar2  default hr_api.g_varchar2
  ,p_addr_attribute20             in     varchar2  default hr_api.g_varchar2
  ,p_add_information13            in     varchar2  default hr_api.g_varchar2
  ,p_add_information14            in     varchar2  default hr_api.g_varchar2
  ,p_add_information15            in     varchar2  default hr_api.g_varchar2
  ,p_add_information16            in     varchar2  default hr_api.g_varchar2
  ,p_add_information17            in     varchar2  default hr_api.g_varchar2
  ,p_add_information18            in     varchar2  default hr_api.g_varchar2
  ,p_add_information19            in     varchar2  default hr_api.g_varchar2
  ,p_add_information20            in     varchar2  default hr_api.g_varchar2
  ,p_party_id                     in     number    default hr_api.g_number
  ,p_style                        in     varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 287


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

Line: 293


  savepoint update_person_address_swi;

Line: 317


    hr_person_address_api.update_pers_addr_with_style
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_validate_county              => l_validate_county
    ,p_address_id                   => p_address_id
    ,p_object_version_number        => p_object_version_number
    ,p_date_from                    => p_date_from
    ,p_date_to                      => p_date_to
    ,p_address_type                 => p_address_type
    ,p_comments                     => p_comments
    ,p_address_line1                => p_address_line1
    ,p_address_line2                => p_address_line2
    ,p_address_line3                => p_address_line3
    ,p_town_or_city                 => p_town_or_city
    ,p_region_1                     => p_region_1
    ,p_region_2                     => p_region_2
    ,p_region_3                     => p_region_3
    ,p_postal_code                  => p_postal_code
    ,p_country                      => p_country
    ,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_addr_attribute_category      => p_addr_attribute_category
    ,p_addr_attribute1              => p_addr_attribute1
    ,p_addr_attribute2              => p_addr_attribute2
    ,p_addr_attribute3              => p_addr_attribute3
    ,p_addr_attribute4              => p_addr_attribute4
    ,p_addr_attribute5              => p_addr_attribute5
    ,p_addr_attribute6              => p_addr_attribute6
    ,p_addr_attribute7              => p_addr_attribute7
    ,p_addr_attribute8              => p_addr_attribute8
    ,p_addr_attribute9              => p_addr_attribute9
    ,p_addr_attribute10             => p_addr_attribute10
    ,p_addr_attribute11             => p_addr_attribute11
    ,p_addr_attribute12             => p_addr_attribute12
    ,p_addr_attribute13             => p_addr_attribute13
    ,p_addr_attribute14             => p_addr_attribute14
    ,p_addr_attribute15             => p_addr_attribute15
    ,p_addr_attribute16             => p_addr_attribute16
    ,p_addr_attribute17             => p_addr_attribute17
    ,p_addr_attribute18             => p_addr_attribute18
    ,p_addr_attribute19             => p_addr_attribute19
    ,p_addr_attribute20             => p_addr_attribute20
    ,p_add_information13            => p_add_information13
    ,p_add_information14            => p_add_information14
    ,p_add_information15            => p_add_information15
    ,p_add_information16            => p_add_information16
    ,p_add_information17            => p_add_information17
    ,p_add_information18            => p_add_information18
    ,p_add_information19            => p_add_information19
    ,p_add_information20            => p_add_information20
    ,p_party_id                     => p_party_id
    ,p_style                        => p_style
    );

Line: 393


    rollback to update_person_address_swi;

Line: 408


    rollback to update_person_address_swi;

Line: 419


end update_person_address;