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

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

Line: 358


procedure update_contact_extra_info
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date,
--  ,p_business_group_id             in     number
--  ,p_non_mandatory_arg             in     number   default null
  p_datetrack_update_mode	IN	VARCHAR2,
  p_contact_extra_info_id       IN      NUMBER,
  p_contact_relationship_id	IN	NUMBER		DEFAULT hr_api.g_number,
  p_information_type		IN	VARCHAR2	DEFAULT hr_api.g_varchar2,
  p_object_version_number       IN OUT NOCOPY  NUMBER,
  p_cei_information_category    IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information1            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information2            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information3            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information4            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information5            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information6            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information7            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information8            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information9            IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information10           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information11           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information12           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information13           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information14           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information15           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information16           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information17           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information18           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information19           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information20           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information21           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information22           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information23           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information24           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information25           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information26           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information27           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information28           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information29           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_information30           IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute_category      IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute1              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute2              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute3              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute4              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute5              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute6              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute7              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute8              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute9              IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute10             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute11             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute12             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute13             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute14             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute15             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute16             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute17             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute18             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute19             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
  p_cei_attribute20             IN      VARCHAR2        DEFAULT hr_api.g_varchar2,
--  ,p_id                               out number
--  ,p_object_version_number            out number
--  ,p_some_warning                     out boolean
  p_effective_start_date OUT NOCOPY DATE,
  p_effective_end_date	 OUT NOCOPY DATE
  ) is
  --
  --
  -- Declare cursors and local variables
  --
  l_effective_start_date	per_contact_extra_info_f.effective_start_date%TYPE;

Line: 432


  l_proc                varchar2(72) := g_package||'update_contact_extra_info';

Line: 439


  savepoint update_contact_extra_info;

Line: 448


    hr_contact_extra_info_bk2.update_contact_extra_info_b
      (p_effective_date                => p_effective_date,
--      ,p_business_group_id             => p_business_group_id
--      ,p_non_mandatory_arg             => p_non_mandatory_arg
      p_datetrack_update_mode	 => p_datetrack_update_mode,
      p_contact_extra_info_id    => p_contact_extra_info_id,
      p_contact_relationship_id	 => p_contact_relationship_id,
      p_information_type	 => p_information_type,
      p_cei_information_category => p_cei_information_category,
      p_cei_information1         => p_cei_information1,
      p_cei_information2         => p_cei_information2,
      p_cei_information3         => p_cei_information3,
      p_cei_information4         => p_cei_information4,
      p_cei_information5         => p_cei_information5,
      p_cei_information6         => p_cei_information6,
      p_cei_information7         => p_cei_information7,
      p_cei_information8         => p_cei_information8,
      p_cei_information9         => p_cei_information9,
      p_cei_information10        => p_cei_information10,
      p_cei_information11        => p_cei_information11,
      p_cei_information12        => p_cei_information12,
      p_cei_information13        => p_cei_information13,
      p_cei_information14        => p_cei_information14,
      p_cei_information15        => p_cei_information15,
      p_cei_information16        => p_cei_information16,
      p_cei_information17        => p_cei_information17,
      p_cei_information18        => p_cei_information18,
      p_cei_information19        => p_cei_information19,
      p_cei_information20        => p_cei_information20,
      p_cei_information21        => p_cei_information21,
      p_cei_information22        => p_cei_information22,
      p_cei_information23        => p_cei_information23,
      p_cei_information24        => p_cei_information24,
      p_cei_information25        => p_cei_information25,
      p_cei_information26        => p_cei_information26,
      p_cei_information27        => p_cei_information27,
      p_cei_information28        => p_cei_information28,
      p_cei_information29        => p_cei_information29,
      p_cei_information30        => p_cei_information30,
      p_cei_attribute_category   => p_cei_attribute_category,
      p_cei_attribute1           => p_cei_attribute1,
      p_cei_attribute2           => p_cei_attribute2,
      p_cei_attribute3           => p_cei_attribute3,
      p_cei_attribute4           => p_cei_attribute4,
      p_cei_attribute5           => p_cei_attribute5,
      p_cei_attribute6           => p_cei_attribute6,
      p_cei_attribute7           => p_cei_attribute7,
      p_cei_attribute8           => p_cei_attribute8,
      p_cei_attribute9           => p_cei_attribute9,
      p_cei_attribute10          => p_cei_attribute10,
      p_cei_attribute11          => p_cei_attribute11,
      p_cei_attribute12          => p_cei_attribute12,
      p_cei_attribute13          => p_cei_attribute13,
      p_cei_attribute14          => p_cei_attribute14,
      p_cei_attribute15          => p_cei_attribute15,
      p_cei_attribute16          => p_cei_attribute16,
      p_cei_attribute17          => p_cei_attribute17,
      p_cei_attribute18          => p_cei_attribute18,
      p_cei_attribute19          => p_cei_attribute19,
      p_cei_attribute20          => p_cei_attribute20,
      p_object_version_number    => p_object_version_number
      );

Line: 513


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

Line: 527


    p_datetrack_mode           => p_datetrack_update_mode,
    p_contact_extra_info_id    => p_contact_extra_info_id,
    p_object_version_number    => p_object_version_number,
    p_contact_relationship_id  => p_contact_relationship_id,
    p_information_type         => p_information_type,
    p_cei_information_category => p_cei_information_category,
    p_cei_information1         => p_cei_information1,
    p_cei_information2         => p_cei_information2,
    p_cei_information3         => p_cei_information3,
    p_cei_information4         => p_cei_information4,
    p_cei_information5         => p_cei_information5,
    p_cei_information6         => p_cei_information6,
    p_cei_information7         => p_cei_information7,
    p_cei_information8         => p_cei_information8,
    p_cei_information9         => p_cei_information9,
    p_cei_information10        => p_cei_information10,
    p_cei_information11        => p_cei_information11,
    p_cei_information12        => p_cei_information12,
    p_cei_information13        => p_cei_information13,
    p_cei_information14        => p_cei_information14,
    p_cei_information15        => p_cei_information15,
    p_cei_information16        => p_cei_information16,
    p_cei_information17        => p_cei_information17,
    p_cei_information18        => p_cei_information18,
    p_cei_information19        => p_cei_information19,
    p_cei_information20        => p_cei_information20,
    p_cei_information21        => p_cei_information21,
    p_cei_information22        => p_cei_information22,
    p_cei_information23        => p_cei_information23,
    p_cei_information24        => p_cei_information24,
    p_cei_information25        => p_cei_information25,
    p_cei_information26        => p_cei_information26,
    p_cei_information27        => p_cei_information27,
    p_cei_information28        => p_cei_information28,
    p_cei_information29        => p_cei_information29,
    p_cei_information30        => p_cei_information30,
    p_cei_attribute_category   => p_cei_attribute_category,
    p_cei_attribute1           => p_cei_attribute1,
    p_cei_attribute2           => p_cei_attribute2,
    p_cei_attribute3           => p_cei_attribute3,
    p_cei_attribute4           => p_cei_attribute4,
    p_cei_attribute5           => p_cei_attribute5,
    p_cei_attribute6           => p_cei_attribute6,
    p_cei_attribute7           => p_cei_attribute7,
    p_cei_attribute8           => p_cei_attribute8,
    p_cei_attribute9           => p_cei_attribute9,
    p_cei_attribute10          => p_cei_attribute10,
    p_cei_attribute11          => p_cei_attribute11,
    p_cei_attribute12          => p_cei_attribute12,
    p_cei_attribute13          => p_cei_attribute13,
    p_cei_attribute14          => p_cei_attribute14,
    p_cei_attribute15          => p_cei_attribute15,
    p_cei_attribute16          => p_cei_attribute16,
    p_cei_attribute17          => p_cei_attribute17,
    p_cei_attribute18          => p_cei_attribute18,
    p_cei_attribute19          => p_cei_attribute19,
    p_cei_attribute20          => p_cei_attribute20,
    p_effective_start_date     => l_effective_start_date,
    p_effective_end_date       => l_effective_end_date);

Line: 590


    hr_contact_extra_info_bk2.update_contact_extra_info_a
      (p_effective_date                => p_effective_date
--      ,p_business_group_id             => p_business_group_id
--      ,p_non_mandatory_arg             => p_non_mandatory_arg
      ,p_contact_extra_info_id         => p_contact_extra_info_id,
    p_contact_relationship_id	=> p_contact_relationship_id,
    p_information_type		=> p_information_type
      ,p_object_version_number         => p_object_version_number,
--      ,p_some_warning                  => 
    p_datetrack_update_mode     => p_datetrack_update_mode,
    p_cei_information_category  => p_cei_information_category,
    p_cei_information1          => p_cei_information1,
    p_cei_information2          => p_cei_information2,
    p_cei_information3          => p_cei_information3,
    p_cei_information4          => p_cei_information4,
    p_cei_information5          => p_cei_information5,
    p_cei_information6          => p_cei_information6,
    p_cei_information7          => p_cei_information7,
    p_cei_information8          => p_cei_information8,
    p_cei_information9          => p_cei_information9,
    p_cei_information10         => p_cei_information10,
    p_cei_information11         => p_cei_information11,
    p_cei_information12         => p_cei_information12,
    p_cei_information13         => p_cei_information13,
    p_cei_information14         => p_cei_information14,
    p_cei_information15         => p_cei_information15,
    p_cei_information16         => p_cei_information16,
    p_cei_information17         => p_cei_information17,
    p_cei_information18         => p_cei_information18,
    p_cei_information19         => p_cei_information19,
    p_cei_information20         => p_cei_information20,
    p_cei_information21         => p_cei_information21,
    p_cei_information22         => p_cei_information22,
    p_cei_information23         => p_cei_information23,
    p_cei_information24         => p_cei_information24,
    p_cei_information25         => p_cei_information25,
    p_cei_information26         => p_cei_information26,
    p_cei_information27         => p_cei_information27,
    p_cei_information28         => p_cei_information28,
    p_cei_information29         => p_cei_information29,
    p_cei_information30         => p_cei_information30,
    p_cei_attribute_category    => p_cei_attribute_category,
    p_cei_attribute1            => p_cei_attribute1,
    p_cei_attribute2            => p_cei_attribute2,
    p_cei_attribute3            => p_cei_attribute3,
    p_cei_attribute4            => p_cei_attribute4,
    p_cei_attribute5            => p_cei_attribute5,
    p_cei_attribute6            => p_cei_attribute6,
    p_cei_attribute7            => p_cei_attribute7,
    p_cei_attribute8            => p_cei_attribute8,
    p_cei_attribute9            => p_cei_attribute9,
    p_cei_attribute10           => p_cei_attribute10,
    p_cei_attribute11           => p_cei_attribute11,
    p_cei_attribute12           => p_cei_attribute12,
    p_cei_attribute13           => p_cei_attribute13,
    p_cei_attribute14           => p_cei_attribute14,
    p_cei_attribute15           => p_cei_attribute15,
    p_cei_attribute16           => p_cei_attribute16,
    p_cei_attribute17           => p_cei_attribute17,
    p_cei_attribute18           => p_cei_attribute18,
    p_cei_attribute19           => p_cei_attribute19,
    p_cei_attribute20           => p_cei_attribute20
      );

Line: 656


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

Line: 682


    rollback to update_contact_extra_info;

Line: 701


    rollback to update_contact_extra_info;

Line: 704


end update_contact_extra_info;

Line: 710


procedure delete_contact_extra_info
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date,
--  ,p_business_group_id             in     number
--  ,p_non_mandatory_arg             in     number   default null
  p_datetrack_delete_mode       IN      VARCHAR2,
  p_contact_extra_info_id       IN      NUMBER,
  p_object_version_number       IN OUT NOCOPY  NUMBER,
--  ,p_id                               out number
--  ,p_object_version_number            out number
--  ,p_some_warning                     out boolean
  p_effective_start_date        OUT NOCOPY     DATE,
  p_effective_end_date          OUT NOCOPY     DATE
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_start_date	per_contact_extra_info_f.effective_start_date%TYPE;

Line: 729


  l_proc                varchar2(72) := g_package||'delete_contact_extra_info';

Line: 736


  savepoint delete_contact_extra_info;

Line: 745


    hr_contact_extra_info_bk3.delete_contact_extra_info_b
      (p_effective_date                => p_effective_date,
--      ,p_business_group_id             => p_business_group_id
--      ,p_non_mandatory_arg             => p_non_mandatory_arg
    p_contact_extra_info_id	=> p_contact_extra_info_id,
    p_object_version_number	=> p_object_version_number,
    p_datetrack_delete_mode	=> p_datetrack_delete_mode
      );

Line: 756


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

Line: 771


     p_datetrack_mode		=> p_datetrack_delete_mode,
     p_contact_extra_info_id	=> p_contact_extra_info_id,
     p_object_version_number	=> p_object_version_number,
     p_effective_start_date	=> l_effective_start_date,
     p_effective_end_date	=> l_effective_end_date);

Line: 780


    hr_contact_extra_info_bk3.delete_contact_extra_info_a
      (p_effective_date                => p_effective_date
--      ,p_business_group_id             => p_business_group_id
--      ,p_non_mandatory_arg             => p_non_mandatory_arg
      ,p_contact_extra_info_id         => p_contact_extra_info_id
      ,p_object_version_number         => p_object_version_number,
--      ,p_some_warning                  => 
     p_datetrack_delete_mode	=> p_datetrack_delete_mode
      );

Line: 792


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

Line: 818


    rollback to delete_contact_extra_info;

Line: 837


    rollback to delete_contact_extra_info;

Line: 840


end delete_contact_extra_info;