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

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

Line: 81


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

Line: 236


procedure update_contact_extra_info(
    p_validate                    IN      NUMBER,
    p_effective_date              IN      DATE,
    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_effective_start_date        OUT     NOCOPY DATE,
    p_effective_end_date          OUT     NOCOPY DATE,
    p_return_status               OUT     NOCOPY VARCHAR2)
is
    --
    -- Variables for API Boolean parameters
    l_validate                      boolean;

Line: 307


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

Line: 314


    savepoint update_contact_extra_info_swi;

Line: 330


    hr_contact_extra_info_api.update_contact_extra_info(
        p_validate                    => l_validate,
        p_effective_date              => p_effective_date,
        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_object_version_number       => p_object_version_number,
        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        => p_effective_start_date,
        p_effective_end_date          => p_effective_end_date
    );

Line: 395


        rollback to update_contact_extra_info_swi;

Line: 404


        rollback to update_contact_extra_info_swi;

Line: 416


        rollback to update_contact_extra_info_swi;

Line: 430


end update_contact_extra_info;

Line: 434


procedure delete_contact_extra_info(
    p_validate                    in      number,
    p_effective_date              in      date,
    p_datetrack_delete_mode       in      varchar2,
    p_contact_extra_info_id       in      number,
    p_object_version_number       in      out nocopy number,
    p_effective_start_date        out     nocopy date,
    p_effective_end_date          out     nocopy date,
    p_return_status               out     nocopy varchar2)
is

    --
    -- Variables for API Boolean parameters
    l_validate                      boolean;

Line: 452


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

Line: 458


    savepoint delete_contact_extra_info_swi;

Line: 465


    hr_contact_extra_info_api.delete_contact_extra_info(
        p_validate                    => l_validate,
        p_effective_date              => p_effective_date,
        p_datetrack_delete_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        => p_effective_start_date,
        p_effective_end_date          => p_effective_end_date);

Line: 475


        rollback to delete_contact_extra_info_swi;

Line: 488


        rollback to delete_contact_extra_info_swi;

Line: 505


        rollback to delete_contact_extra_info_swi;

Line: 518


end delete_contact_extra_info;