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_NZ_PERSON_ADDRESS_API SQL Statements

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

Line: 142


PROCEDURE update_nz_person_address
  (p_validate                      IN     BOOLEAN  DEFAULT FALSE
  ,p_effective_date                IN     DATE
  ,p_validate_county               IN     BOOLEAN  DEFAULT TRUE
  ,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_primary_flag                  IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_address_type                  IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_comments                      IN     per_addresses.comments%TYPE   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_postcode                      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
  ) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                VARCHAR2(72) := g_package||'update_nz_person_address';

Line: 203


  SELECT addr.style
  FROM per_addresses addr
  WHERE addr.address_id = p_address_id;

Line: 241


  hr_person_address_api.update_person_address
    (p_validate                     => p_validate
    ,p_effective_date               => p_effective_date
    ,p_validate_county              => p_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_primary_flag                 => p_primary_flag
    ,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_postcode
    ,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
    );

Line: 296


  END update_nz_person_address;