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

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

Line: 478


PROCEDURE update_location
  (   p_validate                       IN  BOOLEAN   DEFAULT false
     ,p_effective_date                 IN  DATE
     ,p_language_code                  IN  VARCHAR2  DEFAULT hr_api.userenv_lang
     ,p_location_id                    IN  NUMBER
     ,p_location_code                  IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_description                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_timezone_code                  IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_tp_header_id                   IN  NUMBER    DEFAULT hr_api.g_number
     ,p_ece_tp_location_code           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_bill_to_site_flag              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_country                        IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_designated_receiver_id         IN  NUMBER    DEFAULT hr_api.g_number
     ,p_in_organization_flag           IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_inactive_date                  IN  DATE      DEFAULT hr_api.g_date
     ,p_operating_unit_id              IN  NUMBER    DEFAULT NULL
     ,p_inventory_organization_id      IN  NUMBER    DEFAULT hr_api.g_number
     ,p_office_site_flag               IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_postal_code                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_receiving_site_flag            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_ship_to_location_id            IN  NUMBER    DEFAULT hr_api.g_number
     ,p_ship_to_site_flag              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_style                          IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_tax_name                       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_town_or_city                   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_attribute_category             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute1                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute2                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute3                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute4                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute5                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute6                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute7                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute8                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute9                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute10                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute11                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute12                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute13                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute14                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute15                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute16                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute17                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute18                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute19                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute20                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute_category      IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute1              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute2              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute3              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute4              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute5              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute6              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute7              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute8              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute9              IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute10             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute11             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute12             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute13             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute14             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute15             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute16             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute17             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute18             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute19             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_global_attribute20             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_object_version_number          IN OUT NOCOPY NUMBER
  ) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'update_location';

Line: 591


  savepoint update_location;

Line: 627


       select address_line_1
             ,address_line_2
             ,address_line_3
             ,country
             ,inactive_date
             ,postal_code
             ,region_1
             ,region_2
             ,region_3
             ,style
             ,town_or_city
       into   l_address_line_1
             ,l_address_line_2
             ,l_address_line_3
             ,l_country
             ,l_inactive_date
             ,l_postal_code
             ,l_region_1
             ,l_region_2
             ,l_region_3
             ,l_style
             ,l_town_or_city
       from   hr_locations_all loc
     where  loc.location_id = p_location_id;

Line: 684


       hr_utility.set_message(800, 'HR_50049_NON_UPDATEABLE_VALUES');

Line: 699


    hr_location_bk2.update_location_b
      (
     p_effective_date                => p_effective_date
    ,p_language_code                 => l_language_code
    ,p_location_id                   => p_location_id
    ,p_location_code                 => p_location_code
    ,p_description                   => p_description
    ,p_timezone_code                 => p_timezone_code
    ,p_tp_header_id                  => p_tp_header_id
    ,p_ece_tp_location_code          => p_ece_tp_location_code
    ,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_bill_to_site_flag             => p_bill_to_site_flag
    ,p_country                       => p_country
    ,p_designated_receiver_id        => p_designated_receiver_id
    ,p_in_organization_flag          => p_in_organization_flag
    ,p_inactive_date                 => l_inactive_date
    ,p_operating_unit_id             => p_operating_unit_id
    ,p_inventory_organization_id     => p_inventory_organization_id
    ,p_office_site_flag              => p_office_site_flag
    ,p_postal_code                   => p_postal_code
    ,p_receiving_site_flag           => p_receiving_site_flag
    ,p_region_1                      => p_region_1
    ,p_region_2                      => p_region_2
    ,p_region_3                      => p_region_3
    ,p_ship_to_location_id           => p_ship_to_location_id
    ,p_ship_to_site_flag             => p_ship_to_site_flag
    ,p_style                         => p_style
    ,p_tax_name                      => p_tax_name
    ,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_town_or_city                  => p_town_or_city
    ,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_attribute_category            => p_attribute_category
    ,p_attribute1                    => p_attribute1
    ,p_attribute2                    => p_attribute2
    ,p_attribute3                    => p_attribute3
    ,p_attribute4                    => p_attribute4
    ,p_attribute5                    => p_attribute5
    ,p_attribute6                    => p_attribute6
    ,p_attribute7                    => p_attribute7
    ,p_attribute8                    => p_attribute8
    ,p_attribute9                    => p_attribute9
    ,p_attribute10                   => p_attribute10
    ,p_attribute11                   => p_attribute11
    ,p_attribute12                   => p_attribute12
    ,p_attribute13                   => p_attribute13
    ,p_attribute14                   => p_attribute14
    ,p_attribute15                   => p_attribute15
    ,p_attribute16                   => p_attribute16
    ,p_attribute17                   => p_attribute17
    ,p_attribute18                   => p_attribute18
    ,p_attribute19                   => p_attribute19
    ,p_attribute20                   => p_attribute20
    ,p_global_attribute_category     => p_global_attribute_category
    ,p_global_attribute1             => p_global_attribute1
    ,p_global_attribute2             => p_global_attribute2
    ,p_global_attribute3             => p_global_attribute3
    ,p_global_attribute4             => p_global_attribute4
    ,p_global_attribute5             => p_global_attribute5
    ,p_global_attribute6             => p_global_attribute6
    ,p_global_attribute7             => p_global_attribute7
    ,p_global_attribute8             => p_global_attribute8
    ,p_global_attribute9             => p_global_attribute9
    ,p_global_attribute10            => p_global_attribute10
    ,p_global_attribute11            => p_global_attribute11
    ,p_global_attribute12            => p_global_attribute12
    ,p_global_attribute13            => p_global_attribute13
    ,p_global_attribute14            => p_global_attribute14
    ,p_global_attribute15            => p_global_attribute15
    ,p_global_attribute16            => p_global_attribute16
    ,p_global_attribute17            => p_global_attribute17
    ,p_global_attribute18            => p_global_attribute18
    ,p_global_attribute19            => p_global_attribute19
    ,p_global_attribute20            => p_global_attribute20
    ,p_object_version_number         => l_object_version_number
     );

Line: 788


        (p_module_name => 'UPDATE_LOCATION'
        ,p_hook_type   => 'BP'
        );

Line: 798


  hr_location_internal.update_generic_location
    ( p_effective_date                => p_effective_date
     ,p_language_code                 => l_language_code  -- Added for bug 3368450.
     ,p_location_id                   => p_location_id
     ,p_timezone_code                 => p_timezone_code
     ,p_object_version_number         => l_object_version_number
     ,p_tp_header_id                  => p_tp_header_id
     ,p_ece_tp_location_code          => p_ece_tp_location_code
     ,p_location_code                 => p_location_code
     ,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_bill_to_site_flag             => p_bill_to_site_flag
     ,p_country                       => p_country
     ,p_description                   => p_description
     ,p_designated_receiver_id        => p_designated_receiver_id
     ,p_in_organization_flag          => p_in_organization_flag
     ,p_inactive_date                 => l_inactive_date
     ,p_operating_unit_id             => p_operating_unit_id
     ,p_inventory_organization_id     => p_inventory_organization_id
     ,p_office_site_flag              => p_office_site_flag
     ,p_postal_code                   => p_postal_code
     ,p_receiving_site_flag           => p_receiving_site_flag
     ,p_region_1                      => p_region_1
     ,p_region_2                      => p_region_2
     ,p_region_3                      => p_region_3
     ,p_ship_to_location_id           => p_ship_to_location_id
     ,p_ship_to_site_flag             => p_ship_to_site_flag
     ,p_style                         => p_style
     -- Bug 4195237 : 'p_tax_name' parameter is disabled.
     -- Passing 'null' to hr_location_internal
    -- ,p_tax_name                      => null -- reverted the fix 10106543
     ,p_tax_name                      => p_tax_name
     ,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_town_or_city                  => p_town_or_city
     ,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_attribute_category            => p_attribute_category
     ,p_attribute1                    => p_attribute1
     ,p_attribute2                    => p_attribute2
     ,p_attribute3                    => p_attribute3
     ,p_attribute4                    => p_attribute4
     ,p_attribute5                    => p_attribute5
     ,p_attribute6                    => p_attribute6
     ,p_attribute7                    => p_attribute7
     ,p_attribute8                    => p_attribute8
     ,p_attribute9                    => p_attribute9
     ,p_attribute10                   => p_attribute10
     ,p_attribute11                   => p_attribute11
     ,p_attribute12                   => p_attribute12
     ,p_attribute13                   => p_attribute13
     ,p_attribute14                   => p_attribute14
     ,p_attribute15                   => p_attribute15
     ,p_attribute16                   => p_attribute16
     ,p_attribute17                   => p_attribute17
     ,p_attribute18                   => p_attribute18
     ,p_attribute19                   => p_attribute19
     ,p_attribute20                   => p_attribute20
     ,p_global_attribute_category     => p_global_attribute_category
     ,p_global_attribute1             => p_global_attribute1
     ,p_global_attribute2             => p_global_attribute2
     ,p_global_attribute3             => p_global_attribute3
     ,p_global_attribute4             => p_global_attribute4
     ,p_global_attribute5             => p_global_attribute5
     ,p_global_attribute6             => p_global_attribute6
     ,p_global_attribute7             => p_global_attribute7
     ,p_global_attribute8             => p_global_attribute8
     ,p_global_attribute9             => p_global_attribute9
     ,p_global_attribute10            => p_global_attribute10
     ,p_global_attribute11            => p_global_attribute11
     ,p_global_attribute12            => p_global_attribute12
     ,p_global_attribute13            => p_global_attribute13
     ,p_global_attribute14            => p_global_attribute14
     ,p_global_attribute15            => p_global_attribute15
     ,p_global_attribute16            => p_global_attribute16
     ,p_global_attribute17            => p_global_attribute17
     ,p_global_attribute18            => p_global_attribute18
     ,p_global_attribute19            => p_global_attribute19
     ,p_global_attribute20            => p_global_attribute20
    );

Line: 892


    hr_location_bk2.update_location_a
      (
     p_effective_date                => p_effective_date
    ,p_language_code                 => l_language_code
    ,p_location_id                   => p_location_id
    ,p_location_code                 => p_location_code
    ,p_description                   => p_description
    ,p_timezone_code                 => p_timezone_code
    ,p_tp_header_id                  => p_tp_header_id
    ,p_ece_tp_location_code          => p_ece_tp_location_code
    ,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_bill_to_site_flag             => p_bill_to_site_flag
    ,p_country                       => p_country
    ,p_designated_receiver_id        => p_designated_receiver_id
    ,p_in_organization_flag          => p_in_organization_flag
    ,p_inactive_date                 => l_inactive_date
    ,p_operating_unit_id             => p_operating_unit_id
    ,p_inventory_organization_id     => p_inventory_organization_id
    ,p_office_site_flag              => p_office_site_flag
    ,p_postal_code                   => p_postal_code
    ,p_receiving_site_flag           => p_receiving_site_flag
    ,p_region_1                      => p_region_1
    ,p_region_2                      => p_region_2
    ,p_region_3                      => p_region_3
    ,p_ship_to_location_id           => p_ship_to_location_id
    ,p_ship_to_site_flag             => p_ship_to_site_flag
    ,p_style                         => p_style
    ,p_tax_name                      => p_tax_name
    ,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_town_or_city                  => p_town_or_city
    ,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_attribute_category            => p_attribute_category
    ,p_attribute1                    => p_attribute1
    ,p_attribute2                    => p_attribute2
    ,p_attribute3                    => p_attribute3
    ,p_attribute4                    => p_attribute4
    ,p_attribute5                    => p_attribute5
    ,p_attribute6                    => p_attribute6
    ,p_attribute7                    => p_attribute7
    ,p_attribute8                    => p_attribute8
    ,p_attribute9                    => p_attribute9
    ,p_attribute10                   => p_attribute10
    ,p_attribute11                   => p_attribute11
    ,p_attribute12                   => p_attribute12
    ,p_attribute13                   => p_attribute13
    ,p_attribute14                   => p_attribute14
    ,p_attribute15                   => p_attribute15
    ,p_attribute16                   => p_attribute16
    ,p_attribute17                   => p_attribute17
    ,p_attribute18                   => p_attribute18
    ,p_attribute19                   => p_attribute19
    ,p_attribute20                   => p_attribute20
    ,p_global_attribute_category     => p_global_attribute_category
    ,p_global_attribute1             => p_global_attribute1
    ,p_global_attribute2             => p_global_attribute2
    ,p_global_attribute3             => p_global_attribute3
    ,p_global_attribute4             => p_global_attribute4
    ,p_global_attribute5             => p_global_attribute5
    ,p_global_attribute6             => p_global_attribute6
    ,p_global_attribute7             => p_global_attribute7
    ,p_global_attribute8             => p_global_attribute8
    ,p_global_attribute9             => p_global_attribute9
    ,p_global_attribute10            => p_global_attribute10
    ,p_global_attribute11            => p_global_attribute11
    ,p_global_attribute12            => p_global_attribute12
    ,p_global_attribute13            => p_global_attribute13
    ,p_global_attribute14            => p_global_attribute14
    ,p_global_attribute15            => p_global_attribute15
    ,p_global_attribute16            => p_global_attribute16
    ,p_global_attribute17            => p_global_attribute17
    ,p_global_attribute18            => p_global_attribute18
    ,p_global_attribute19            => p_global_attribute19
    ,p_global_attribute20            => p_global_attribute20
    ,p_object_version_number         => l_object_version_number
     );

Line: 981


        (p_module_name => 'UPDATE_LOCATION'
        ,p_hook_type   => 'AP'
        );

Line: 1011


    ROLLBACK TO update_location;

Line: 1022


    ROLLBACK TO update_location;

Line: 1029


END update_location;

Line: 1034


PROCEDURE delete_location
   (  p_validate                     IN BOOLEAN DEFAULT false
     ,p_location_id                  IN hr_locations.location_id%TYPE
     ,p_object_version_number        IN hr_locations.object_version_number%TYPE )

IS
  --
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'delete_location';

Line: 1052


  savepoint delete_location;

Line: 1056


    hr_location_bk3.delete_location_b (
      p_location_id                 => p_location_id,
      p_object_version_number       => p_object_version_number );

Line: 1063


        (p_module_name => 'DELETE_LOCATION'
        ,p_hook_type   => 'BP'
   );

Line: 1092


    hr_location_bk3.delete_location_a (
      p_location_id                 => p_location_id,
      p_object_version_number       => p_object_version_number );

Line: 1099


        (p_module_name => 'DELETE_LOCATION'
        ,p_hook_type   => 'AP'
   );

Line: 1121


    ROLLBACK TO delete_location;

Line: 1131


    ROLLBACK TO delete_location;

Line: 1135


END delete_location;

Line: 1476


PROCEDURE update_location_legal_adr
  (   p_validate                       IN  BOOLEAN   DEFAULT false
     ,p_effective_date                 IN  DATE
     ,p_location_id                    IN  NUMBER
     ,p_description                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_timezone_code                  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_inactive_date                  IN  DATE      DEFAULT hr_api.g_date
     ,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_style                          IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_town_or_city                   IN  VARCHAR2  DEFAULT hr_api.g_varchar2
    /* Added for bug8703747*/
     ,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
    /*Changes end for bug8703747 */
     ,p_attribute_category             IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute1                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute2                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute3                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute4                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute5                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute6                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute7                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute8                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute9                     IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute10                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute11                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute12                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute13                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute14                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute15                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute16                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute17                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute18                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute19                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_attribute20                    IN  VARCHAR2  DEFAULT hr_api.g_varchar2
     ,p_object_version_number          IN OUT NOCOPY NUMBER
  ) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'update_location_legal_adr';

Line: 1541


  savepoint update_location_legal_adr;

Line: 1551


    hr_location_bk5.update_location_legal_adr_b
      (
     p_effective_date                => p_effective_date
    ,p_location_id                   => p_location_id
    ,p_description                   => p_description
    ,p_timezone_code                 => p_timezone_code
    ,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_inactive_date                 => p_inactive_date
    ,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_style                         => p_style
    ,p_town_or_city                  => p_town_or_city
      /*Added for bug8703747 */
     ,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
 /*Changes end for bug8703747 */
    ,p_attribute_category            => p_attribute_category
    ,p_attribute1                    => p_attribute1
    ,p_attribute2                    => p_attribute2
    ,p_attribute3                    => p_attribute3
    ,p_attribute4                    => p_attribute4
    ,p_attribute5                    => p_attribute5
    ,p_attribute6                    => p_attribute6
    ,p_attribute7                    => p_attribute7
    ,p_attribute8                    => p_attribute8
    ,p_attribute9                    => p_attribute9
    ,p_attribute10                   => p_attribute10
    ,p_attribute11                   => p_attribute11
    ,p_attribute12                   => p_attribute12
    ,p_attribute13                   => p_attribute13
    ,p_attribute14                   => p_attribute14
    ,p_attribute15                   => p_attribute15
    ,p_attribute16                   => p_attribute16
    ,p_attribute17                   => p_attribute17
    ,p_attribute18                   => p_attribute18
    ,p_attribute19                   => p_attribute19
    ,p_attribute20                   => p_attribute20
    ,p_object_version_number         => l_object_version_number
      );

Line: 1606


        (p_module_name => 'update_location_legal_adr'
        ,p_hook_type   => 'BP'
        );

Line: 1616


  hr_location_internal.update_generic_location
    ( p_effective_date                => p_effective_date
     ,p_location_id                   => p_location_id
     ,p_object_version_number         => l_object_version_number
     ,p_description                   => p_description
     ,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_inactive_date                 => p_inactive_date
     ,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_style                         => p_style
     ,p_town_or_city                  => p_town_or_city
       /*Added for bug8703747 */
     ,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
 /*Changes end for bug8703747 */
     ,p_attribute_category            => p_attribute_category
     ,p_attribute1                    => p_attribute1
     ,p_attribute2                    => p_attribute2
     ,p_attribute3                    => p_attribute3
     ,p_attribute4                    => p_attribute4
     ,p_attribute5                    => p_attribute5
     ,p_attribute6                    => p_attribute6
     ,p_attribute7                    => p_attribute7
     ,p_attribute8                    => p_attribute8
     ,p_attribute9                    => p_attribute9
     ,p_attribute10                   => p_attribute10
     ,p_attribute11                   => p_attribute11
     ,p_attribute12                   => p_attribute12
     ,p_attribute13                   => p_attribute13
     ,p_attribute14                   => p_attribute14
     ,p_attribute15                   => p_attribute15
     ,p_attribute16                   => p_attribute16
     ,p_attribute17                   => p_attribute17
     ,p_attribute18                   => p_attribute18
     ,p_attribute19                   => p_attribute19
     ,p_attribute20                   => p_attribute20
    );

Line: 1672


    hr_location_bk5.update_location_legal_adr_a
      (
         p_effective_date                => p_effective_date
        ,p_location_id                   => p_location_id
        ,p_description                   => p_description
        ,p_timezone_code                 => p_timezone_code
        ,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_inactive_date                 => p_inactive_date
        ,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_style                         => p_style
        ,p_town_or_city                  => p_town_or_city
          /*Added for bug8703747 */
     ,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
 /*Changes end for bug8703747 */
        ,p_attribute_category            => p_attribute_category
   ,p_attribute1                    => p_attribute1
   ,p_attribute2                    => p_attribute2
   ,p_attribute3                    => p_attribute3
   ,p_attribute4                    => p_attribute4
   ,p_attribute5                    => p_attribute5
   ,p_attribute6                    => p_attribute6
   ,p_attribute7                    => p_attribute7
   ,p_attribute8                    => p_attribute8
   ,p_attribute9                    => p_attribute9
   ,p_attribute10                   => p_attribute10
   ,p_attribute11                   => p_attribute11
   ,p_attribute12                   => p_attribute12
   ,p_attribute13                   => p_attribute13
   ,p_attribute14                   => p_attribute14
   ,p_attribute15                   => p_attribute15
   ,p_attribute16                   => p_attribute16
   ,p_attribute17                   => p_attribute17
   ,p_attribute18                   => p_attribute18
   ,p_attribute19                   => p_attribute19
   ,p_attribute20                   => p_attribute20
        ,p_object_version_number         => l_object_version_number
      );

Line: 1727


        (p_module_name => 'update_location_legal_adr'
        ,p_hook_type   => 'AP'
        );

Line: 1757


    ROLLBACK TO update_location_legal_adr;

Line: 1768


    ROLLBACK TO update_location_legal_adr;

Line: 1775


END update_location_legal_adr;

Line: 1842


    hr_location_internal.update_generic_location
  (   p_effective_date                => p_effective_date
     ,p_location_id                   => p_location_id
     ,p_object_version_number         => l_object_version_number
     ,p_legal_address_flag       => NULL
   );

Line: 1972


    hr_location_internal.update_generic_location
  (   p_effective_date                => p_effective_date
     ,p_location_id                   => p_location_id
     ,p_object_version_number         => l_object_version_number
     ,p_legal_address_flag       => 'Y'
   );