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

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

Line: 116


PROCEDURE update_hk_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_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_district                      IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_area                          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
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                VARCHAR2(72) := g_package||'update_hk_person_address';

Line: 164


    SELECT  style
    FROM    per_addresses
    WHERE   address_id = p_address_id;

Line: 196


  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_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_district
    ,p_region_1                     => p_area
    ,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
    );

Line: 239


END update_hk_person_address;