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

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

Line: 782


      select per.object_version_number into l_per_object_version_number
      from per_all_people_f per
      where per.person_id=l_contact_person_id_save
      and p_start_date between per.effective_start_date and per.effective_end_date;

Line: 1077


procedure update_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_cont_information_category           in        varchar2  default hr_api.g_varchar2
  ,p_cont_information1                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information2                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information3                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information4                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information5                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information6                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information7                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information8                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information9                   in        varchar2  default hr_api.g_varchar2
  ,p_cont_information10                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information11                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information12                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information13                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information14                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information15                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information16                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information17                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information18                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information19                  in        varchar2  default hr_api.g_varchar2
  ,p_cont_information20                  in        varchar2  default hr_api.g_varchar2
  ,p_object_version_number             in out nocopy    number
  )
is
  --
  -- Declare all out local variables and cursors
  --
  l_proc                            varchar2(72) := g_package||'update_contact';

Line: 1159


    select pcr2.contact_relationship_id,
           pcr2.object_version_number
    from   per_contact_relationships pcr1,
           per_contact_relationships pcr2
    where pcr2.contact_person_id = pcr1.person_id
      and pcr2.person_id = pcr1.contact_person_id
      and (pcr2.date_start = pcr1.date_start
       or (pcr2.date_start is null and pcr1.date_start is null))
      and pcr1.contact_relationship_id = p_contact_relationship_id
      and pcr2.contact_type = l_mirror_contact_type;

Line: 1173


     select pcr.contact_type,
            pcr.date_start,
            pcr.start_life_reason_id,
            pcr.date_end,
            pcr.end_life_reason_id,
            pcr.rltd_per_rsds_w_dsgntr_flag,
            pcr.personal_flag,
            pcr.contact_person_id
     from   per_contact_relationships pcr
     where  pcr.contact_relationship_id = p_contact_relationship_id;

Line: 1204


  savepoint update_contact_relationship;

Line: 1212


    hr_contact_rel_bk2.update_contact_relationship_b
      (p_effective_date               =>  l_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      =>  p_cont_information_category
      ,p_cont_information1              =>  p_cont_information1
      ,p_cont_information2              =>  p_cont_information2
      ,p_cont_information3              =>  p_cont_information3
      ,p_cont_information4              =>  p_cont_information4
      ,p_cont_information5              =>  p_cont_information5
      ,p_cont_information6              =>  p_cont_information6
      ,p_cont_information7              =>  p_cont_information7
      ,p_cont_information8              =>  p_cont_information8
      ,p_cont_information9              =>  p_cont_information9
      ,p_cont_information10             =>  p_cont_information10
      ,p_cont_information11             =>  p_cont_information11
      ,p_cont_information12             =>  p_cont_information12
      ,p_cont_information13             =>  p_cont_information13
      ,p_cont_information14             =>  p_cont_information14
      ,p_cont_information15             =>  p_cont_information15
      ,p_cont_information16             =>  p_cont_information16
      ,p_cont_information17             =>  p_cont_information17
      ,p_cont_information18             =>  p_cont_information18
      ,p_cont_information19             =>  p_cont_information19
      ,p_cont_information20             =>  p_cont_information20
      ,p_object_version_number        =>  p_object_version_number
      );

Line: 1276


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

Line: 1438


    hr_contact_rel_bk2.update_contact_relationship_a
      (p_effective_date               =>  l_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      =>  p_cont_information_category
      ,p_cont_information1              =>  p_cont_information1
      ,p_cont_information2              =>  p_cont_information2
      ,p_cont_information3              =>  p_cont_information3
      ,p_cont_information4              =>  p_cont_information4
      ,p_cont_information5              =>  p_cont_information5
      ,p_cont_information6              =>  p_cont_information6
      ,p_cont_information7              =>  p_cont_information7
      ,p_cont_information8              =>  p_cont_information8
      ,p_cont_information9              =>  p_cont_information9
      ,p_cont_information10             =>  p_cont_information10
      ,p_cont_information11             =>  p_cont_information11
      ,p_cont_information12             =>  p_cont_information12
      ,p_cont_information13             =>  p_cont_information13
      ,p_cont_information14             =>  p_cont_information14
      ,p_cont_information15             =>  p_cont_information15
      ,p_cont_information16             =>  p_cont_information16
      ,p_cont_information17             =>  p_cont_information17
      ,p_cont_information18             =>  p_cont_information18
      ,p_cont_information19             =>  p_cont_information19
      ,p_cont_information20             =>  p_cont_information20
      ,p_object_version_number        =>  p_object_version_number
      );

Line: 1502


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

Line: 1523


    ROLLBACK TO update_contact_relationship;

Line: 1537


    ROLLBACK TO update_contact_relationship;

Line: 1548


end update_contact_relationship;

Line: 1555


procedure delete_contact_relationship
  (p_validate                          in        boolean   default false
  ,p_contact_relationship_id           in        number
  ,p_object_version_number             in        number
  )
is
  --
  -- Declare all out local variables and cursors
  --
  l_proc                            varchar2(72) := g_package||'delete_contact';

Line: 1571


    select pcr2.contact_relationship_id,
           pcr2.object_version_number
    from   per_contact_relationships pcr1,
           per_contact_relationships pcr2
    where pcr2.contact_person_id = pcr1.person_id
      and pcr2.person_id = pcr1.contact_person_id
      and pcr1.contact_relationship_id = p_contact_relationship_id
      and pcr2.contact_type = l_mirror_contact_type;   -- bug# 2742210

Line: 1581


	select object_version_number
	      ,effective_start_date
	from  per_all_people_f
	where person_id = p_person_id
	and   effective_end_date = hr_general.end_of_time;

Line: 1588


    select contact_person_id,contact_type
    from per_contact_relationships
    where contact_relationship_id = p_contact_relationship_id;

Line: 1609


    savepoint delete_contact_relationship;

Line: 1617


    hr_contact_rel_bk3.delete_contact_relationship_b
      (p_contact_relationship_id           => p_contact_relationship_id
      ,p_object_version_number             => p_object_version_number
      );

Line: 1624


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

Line: 1678


     per_contact_relationships_pkg.delete_validation
             (l_contact_person_id
             ,p_contact_relationship_id
             );

Line: 1709


    hr_contact_rel_bk3.delete_contact_relationship_a
      (p_contact_relationship_id           => p_contact_relationship_id
      ,p_object_version_number             => p_object_version_number
      );

Line: 1716


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

Line: 1737


    ROLLBACK TO delete_contact_relationship;

Line: 1746


    ROLLBACK TO delete_contact_relationship;

Line: 1752


end delete_contact_relationship;