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

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

Line: 22


      select bgp.legislation_code
      from per_people_f per,
           per_business_groups bgp
      where per.business_group_id = bgp.business_group_id
      and    per.person_id       = c_person_id
      and    c_effective_date  between per.effective_start_date and per.effective_END_date;

Line: 180


 PROCEDURE update_in_person_address
   (p_validate                      IN     BOOLEAN  DEFAULT FALSE
   ,p_effective_date                IN     DATE
   ,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_flat_door_block               IN     VARCHAR2 DEFAULT hr_api.g_varchar2
   ,p_building_village              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
   ,p_road_street                   IN     VARCHAR2 DEFAULT hr_api.g_varchar2
   ,p_area_locality                 IN     VARCHAR2 DEFAULT hr_api.g_varchar2
   ,p_town_or_city                  IN     VARCHAR2 DEFAULT hr_api.g_varchar2
   ,p_state_ut                      IN     VARCHAR2 DEFAULT hr_api.g_varchar2
   ,p_pin_code                      IN     VARCHAR2 DEFAULT hr_api.g_varchar2
   ,p_country                       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
   ) AS
   --
   -- Declare cursors and local variables
   --
  g_package VARCHAR2(10);

Line: 227


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

Line: 232


  l_proc := g_package||'update_IN_person_address';

Line: 272


   hr_person_address_api.update_person_address
     (p_validate                     => p_validate
     ,p_effective_date               => p_effective_date
     ,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_flat_door_block
     ,p_address_line2                => p_building_village
     ,p_address_line3                => p_road_street
     ,p_postal_code                  => p_pin_code
     ,p_country                      => 'IN'
     ,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_area_locality
     ,p_add_information14            => p_town_or_city
     ,p_add_information15            => p_state_ut
     );

Line: 316


 END update_IN_person_address;