APPS.HR_CN_PERSON_ADDRESS_API SQL Statements

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

Line: 332

 PROCEDURE update_cn_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   null
  ,p_address_line1                 IN     VARCHAR2 DEFAULT   hr_api.g_varchar2
  ,p_address_line2                 IN     VARCHAR2 DEFAULT   hr_api.g_varchar2
  ,p_province_city_sar             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                     IN     VARCHAR2 DEFAULT   hr_api.g_varchar2
  ,p_fax                           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_cn_person_address';

Line: 389

    SELECT  style
    FROM    per_addresses
    WHERE   address_id = p_address_id;

Line: 409

   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_town_or_city			=>	  p_province_city_sar
  ,p_postal_code                  	=>	  p_postal_code
  ,p_country                      	=>	  p_country
  ,p_telephone_number_1			=>	  p_telephone
  ,p_telephone_number_2 		=>	  p_fax
  ,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: 462

End update_cn_person_address;