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

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

Line: 305


PROCEDURE update_in_contact_relationship
  (p_validate                          IN        BOOLEAN   default false
  ,p_effective_date                    IN        DATE
  ,p_contact_relationship_id           IN        NUMBER
  ,p_contact_type                      IN        VARCHAR2  default hr_api.g_varchar2
  ,p_comments                          IN        LONG      default hr_api.g_varchar2
  ,p_primary_contact_flag              IN        VARCHAR2  default hr_api.g_varchar2
  ,p_third_party_pay_flag              IN        VARCHAR2  default hr_api.g_varchar2
  ,p_bondholder_flag                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_date_start                        IN        DATE      default hr_api.g_date
  ,p_start_life_reason_id              IN        NUMBER    default hr_api.g_number
  ,p_date_end                          IN        DATE      default hr_api.g_date
  ,p_end_life_reason_id                IN        NUMBER    default hr_api.g_number
  ,p_rltd_per_rsds_w_dsgntr_flag       IN        VARCHAR2  default hr_api.g_varchar2
  ,p_personal_flag                     IN        VARCHAR2  default hr_api.g_varchar2
  ,p_sequence_number                   IN        NUMBER    default hr_api.g_number
  ,p_dependent_flag                    IN        VARCHAR2  default hr_api.g_varchar2
  ,p_beneficiary_flag                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute_category           IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute1                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute2                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute3                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute4                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute5                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute6                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute7                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute8                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute9                   IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute10                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute11                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute12                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute13                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute14                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute15                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute16                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute17                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute18                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute19                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_cont_attribute20                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_guardian_name                     IN        VARCHAR2  default hr_api.g_varchar2
  ,p_guardian_birth_date               IN        VARCHAR2  default hr_api.g_varchar2
  ,p_guardian_address                  IN        VARCHAR2  default hr_api.g_varchar2
  ,p_guardian_telephone                IN        VARCHAR2  default hr_api.g_varchar2
  ,p_object_version_number             IN OUT NOCOPY    number
  )
AS
--
-- Declare cursors and local variables
--
  l_proc  VARCHAR2(72);

Line: 356


   l_proc := g_package||'update_in_contact_relationship';

Line: 364


   hr_contact_rel_api.update_contact_relationship(
       p_effective_date               =>  p_effective_date
      ,p_contact_relationship_id      =>  p_contact_relationship_id
      ,p_contact_type                 =>  p_contact_type
      ,p_comments                     =>  p_comments
      ,p_primary_contact_flag         =>  p_primary_contact_flag
      ,p_third_party_pay_flag         =>  p_third_party_pay_flag
      ,p_bondholder_flag              =>  p_bondholder_flag
      ,p_date_start                   =>  trunc(p_date_start)
      ,p_start_life_reason_id         =>  p_start_life_reason_id
      ,p_date_end                     =>  trunc(p_date_end)
      ,p_end_life_reason_id           =>  p_end_life_reason_id
      ,p_rltd_per_rsds_w_dsgntr_flag  =>  p_rltd_per_rsds_w_dsgntr_flag
      ,p_personal_flag                =>  p_personal_flag
      ,p_sequence_number              =>  p_sequence_number
      ,p_dependent_flag               =>  p_dependent_flag
      ,p_beneficiary_flag             =>  p_beneficiary_flag
      ,p_cont_attribute_category      =>  p_cont_attribute_category
      ,p_cont_attribute1              =>  p_cont_attribute1
      ,p_cont_attribute2              =>  p_cont_attribute2
      ,p_cont_attribute3              =>  p_cont_attribute3
      ,p_cont_attribute4              =>  p_cont_attribute4
      ,p_cont_attribute5              =>  p_cont_attribute5
      ,p_cont_attribute6              =>  p_cont_attribute6
      ,p_cont_attribute7              =>  p_cont_attribute7
      ,p_cont_attribute8              =>  p_cont_attribute8
      ,p_cont_attribute9              =>  p_cont_attribute9
      ,p_cont_attribute10             =>  p_cont_attribute10
      ,p_cont_attribute11             =>  p_cont_attribute11
      ,p_cont_attribute12             =>  p_cont_attribute12
      ,p_cont_attribute13             =>  p_cont_attribute13
      ,p_cont_attribute14             =>  p_cont_attribute14
      ,p_cont_attribute15             =>  p_cont_attribute15
      ,p_cont_attribute16             =>  p_cont_attribute16
      ,p_cont_attribute17             =>  p_cont_attribute17
      ,p_cont_attribute18             =>  p_cont_attribute18
      ,p_cont_attribute19             =>  p_cont_attribute19
      ,p_cont_attribute20             =>  p_cont_attribute20
      ,p_cont_information_category    =>  'IN'
      ,p_cont_information13           =>  p_guardian_name
      ,p_cont_information14           =>  p_guardian_birth_date
      ,p_cont_information15           =>  p_guardian_address
      ,p_cont_information17           =>  p_guardian_telephone
      ,p_object_version_number        =>  p_object_version_number
      );

Line: 412


    END update_in_contact_relationship;