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.PQH_CORPS_EXTRA_INFO_API SQL Statements

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

Line: 12


     SELECT 'Y'
     FROM   DUAL
     WHERE  EXISTS (SELECT 1
                    FROM   hr_all_organization_units
                    WHERE  organization_id = fnd_number.canonical_to_number(p_organization_id)
                    AND    p_effective_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time));

Line: 20


     SELECT 'Y'
     FROM   DUAL
     WHERE EXISTS (SELECT 1
                   FROM   pqh_corps_extra_info
                   WHERE  corps_definition_id = p_corps_definition_id
                   AND    information_type = 'ORGANIZATION'
                   AND    information3 = p_organization_id
                   AND   (p_corps_extra_info_id IS NULL OR
                          corps_extra_info_id <> p_corps_extra_info_id) );

Line: 59


    SELECT 'Y'
    FROM    dual
    WHERE EXISTS (SELECT 1
                  FROM   per_shared_types
                  WHERE  shared_type_id = fnd_number.canonical_to_number(p_field_of_prof_activity_id));

Line: 67


    SELECT 'Y'
    FROM   dual
    WHERE  EXISTS (SELECT 1
                   FROM   pqh_corps_extra_info
                   WHERE  corps_definition_id = p_corps_definition_id
                   AND    information_type    = 'FILERE'
                   AND    information3        = p_field_of_prof_activity_id
                   AND    (p_corps_extra_info_id IS NULL OR corps_extra_info_id <> p_corps_extra_info_id));

Line: 108


    SELECT 'Y'
    FROM   dual
    WHERE  EXISTS (SELECT 1
                   FROM   hr_all_organization_units
                   WHERE  organization_id = fnd_number.canonical_to_number(p_institution_id)
                   AND    p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));

Line: 116


    SELECT 'Y'
    FROM   dual
    WHERE  EXISTS (SELECT 1
                   FROM   pqh_corps_extra_info
                   WHERE  information_type = 'EXAM'
                   AND    corps_definition_id = p_corps_definition_id
                   AND    nvl(information3,'#@') = nvl(p_examination_type_cd,'#@')
                   AND    nvl(information4,'#@') = nvl(p_institution_id,'#@')
                   AND    nvl(information5,'#@') = nvl(p_joining_way_cd,'#@')
                   AND    nvl(information7,'#@')  = nvl(p_exam_name,'#@')
                   AND    (p_corps_extra_info_id IS NULL OR corps_extra_info_id <> p_corps_extra_info_id));

Line: 176


     SELECT 'Y'
     FROM   dual
     WHERE EXISTS (SELECT 1
                   FROM   per_qualification_types
                   WHERE  qualification_type_id = fnd_number.canonical_to_number(p_qualification_id) );

Line: 183


    SELECT 'Y'
    FROM   dual
    WHERE  EXISTS (SELECT 1
                   FROM   hr_all_organization_units
                   WHERE  organization_id = fnd_number.canonical_to_number(p_institution_id)
                   AND    p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));

Line: 191


    SELECT 'Y'
    FROM   dual
    WHERE  EXISTS (SELECT 1
                   FROM   pqh_corps_extra_info
                   WHERE  corps_definition_id = p_corps_definition_id
                   AND    information_type = 'TRAINING'
                   AND    nvl(information3,'#@') = nvl(p_qualification_id,'#@')
                   AND    nvl(information4,'#@') = nvl(p_institution_id,'#@')
                   AND    nvl(information5,'#@') = nvl(p_training_duration,'#@')
                   AND    nvl(information6,'#@') = nvl(p_training_duration_uom,'#@')
                   AND    nvl(information7,'#@') = nvl(p_joining_way_cd,'#@')
                   AND    (p_corps_extra_info_id IS NULL OR
                           corps_extra_info_id <> p_corps_extra_info_id) );

Line: 267


     SELECT 'Y'
     FROM   dual
     WHERE  EXISTS (SELECT 1
                    FROM   pqh_corps_definitions cpd,
                           pqh_corps_extra_info cei
                    WHERE  cei.information_type = 'FILERE'
                    AND    cei.corps_definition_id = cpd.corps_definition_id
                    AND    fnd_number.canonical_to_number(nvl(cei.information4,'-1')) = nvl(primary_prof_field_id,-1)
                    AND    corps_extra_info_id  = p_corps_extra_info_id);

Line: 879


procedure update_corps_extra_info
  (
  p_validate                      in    boolean    default false
  ,p_effective_date               in    date
  ,p_corps_extra_info_id          in    number
  ,p_corps_definition_id          in    number     default hr_api.g_number
  ,p_information_type             in    varchar2   default hr_api.g_varchar2
  ,p_information1                 in    varchar2   default hr_api.g_varchar2
  ,p_information2                 in    varchar2   default hr_api.g_varchar2
  ,p_information3                 in    varchar2   default hr_api.g_varchar2
  ,p_information4                 in    varchar2   default hr_api.g_varchar2
  ,p_information5                 in    varchar2   default hr_api.g_varchar2
  ,p_information6                 in    varchar2   default hr_api.g_varchar2
  ,p_information7                 in    varchar2   default hr_api.g_varchar2
  ,p_information8                 in    varchar2   default hr_api.g_varchar2
  ,p_information9                 in    varchar2   default hr_api.g_varchar2
  ,p_information10                in    varchar2   default hr_api.g_varchar2
  ,p_information11                in    varchar2   default hr_api.g_varchar2
  ,p_information12                in    varchar2   default hr_api.g_varchar2
  ,p_information13                in    varchar2   default hr_api.g_varchar2
  ,p_information14                in    varchar2   default hr_api.g_varchar2
  ,p_information15                in    varchar2   default hr_api.g_varchar2
  ,p_information16                in    varchar2   default hr_api.g_varchar2
  ,p_information17                in    varchar2   default hr_api.g_varchar2
  ,p_information18                in    varchar2   default hr_api.g_varchar2
  ,p_information19                in    varchar2   default hr_api.g_varchar2
  ,p_information20                in    varchar2   default hr_api.g_varchar2
  ,p_information21                in    varchar2   default hr_api.g_varchar2
  ,p_information22                in    varchar2   default hr_api.g_varchar2
  ,p_information23                in    varchar2   default hr_api.g_varchar2
  ,p_information24                in    varchar2   default hr_api.g_varchar2
  ,p_information25                in    varchar2   default hr_api.g_varchar2
  ,p_information26                in    varchar2   default hr_api.g_varchar2
  ,p_information27                in    varchar2   default hr_api.g_varchar2
  ,p_information28                in    varchar2   default hr_api.g_varchar2
  ,p_information29                in    varchar2   default hr_api.g_varchar2
  ,p_information30                in    varchar2   default hr_api.g_varchar2
  ,p_information_category         in    varchar2   default hr_api.g_varchar2
  ,p_attribute1                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute2                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute3                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute4                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute5                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute6                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute7                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute8                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute9                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute10                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute11                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute12                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute13                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute14                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute15                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute16                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute17                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute18                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute19                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute20                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute21                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute22                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute23                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute24                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute25                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute26                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute27                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute28                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute29                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute30                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute_category           in    varchar2   default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy   number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_corps_extra_info';

Line: 962


  savepoint update_corps_extra_info;

Line: 972


  pqh_corps_extra_info_bk2.update_corps_extra_info_b
 (
  p_effective_date                =>    trunc(p_effective_date)
  ,p_corps_extra_info_id          =>    p_corps_extra_info_id
  ,p_corps_definition_id          =>    p_corps_definition_id
  ,p_object_version_number        =>    p_object_version_number
  ,p_information_type             =>    p_information_type
  ,p_information1                 =>    p_information1
  ,p_information2                 =>    p_information2
  ,p_information3                 =>    p_information3
  ,p_information4                 =>    p_information4
  ,p_information5                 =>    p_information5
  ,p_information6                 =>    p_information6
  ,p_information7                 =>    p_information7
  ,p_information8                 =>    p_information8
  ,p_information9                 =>    p_information9
  ,p_information10                =>    p_information10
  ,p_information11                =>    p_information11
  ,p_information12                =>    p_information12
  ,p_information13                =>    p_information13
  ,p_information14                =>    p_information14
  ,p_information15                =>    p_information15
  ,p_information16                =>    p_information16
  ,p_information17                =>    p_information17
  ,p_information18                =>    p_information18
  ,p_information19                =>    p_information19
  ,p_information20                =>    p_information20
  ,p_information21                =>    p_information21
  ,p_information22                =>    p_information22
  ,p_information23                =>    p_information23
  ,p_information24                =>    p_information24
  ,p_information25                =>    p_information25
  ,p_information26                =>    p_information26
  ,p_information27                =>    p_information27
  ,p_information28                =>    p_information28
  ,p_information29                =>    p_information29
  ,p_information30                =>    p_information30
  ,p_information_category         =>    p_information_category
  ,p_attribute1                   =>    p_attribute1
  ,p_attribute2                   =>    p_attribute2
  ,p_attribute3                   =>    p_attribute3
  ,p_attribute4                   =>    p_attribute4
  ,p_attribute5                   =>    p_attribute5
  ,p_attribute6                   =>    p_attribute6
  ,p_attribute7                   =>    p_attribute7
  ,p_attribute8                   =>    p_attribute8
  ,p_attribute9                   =>    p_attribute9
  ,p_attribute10                  =>    p_attribute10
  ,p_attribute11                  =>    p_attribute11
  ,p_attribute12                  =>    p_attribute12
  ,p_attribute13                  =>    p_attribute13
  ,p_attribute14                  =>    p_attribute14
  ,p_attribute15                  =>    p_attribute15
  ,p_attribute16                  =>    p_attribute16
  ,p_attribute17                  =>    p_attribute17
  ,p_attribute18                  =>    p_attribute18
  ,p_attribute19                  =>    p_attribute19
  ,p_attribute20                  =>    p_attribute20
  ,p_attribute21                  =>    p_attribute21
  ,p_attribute22                  =>    p_attribute22
  ,p_attribute23                  =>    p_attribute23
  ,p_attribute24                  =>    p_attribute24
  ,p_attribute25                  =>    p_attribute25
  ,p_attribute26                  =>    p_attribute26
  ,p_attribute27                  =>    p_attribute27
  ,p_attribute28                  =>    p_attribute28
  ,p_attribute29                  =>    p_attribute29
  ,p_attribute30                  =>    p_attribute30
  ,p_attribute_category           =>    p_attribute_category
);

Line: 1046


         p_module_name => 'update_corps_extra_info'
        ,p_hook_type   => 'BP'
        );

Line: 1163


  pqh_corps_extra_info_bk2.update_corps_extra_info_a
 (
  p_effective_date                =>    trunc(p_effective_date)
  ,p_corps_extra_info_id          =>    p_corps_extra_info_id
  ,p_corps_definition_id          =>    p_corps_definition_id
  ,p_object_version_number        =>    l_object_version_number
  ,p_information_type             =>    p_information_type
  ,p_information1                 =>    p_information1
  ,p_information2                 =>    p_information2
  ,p_information3                 =>    p_information3
  ,p_information4                 =>    p_information4
  ,p_information5                 =>    p_information5
  ,p_information6                 =>    p_information6
  ,p_information7                 =>    p_information7
  ,p_information8                 =>    p_information8
  ,p_information9                 =>    p_information9
  ,p_information10                =>    p_information10
  ,p_information11                =>    p_information11
  ,p_information12                =>    p_information12
  ,p_information13                =>    p_information13
  ,p_information14                =>    p_information14
  ,p_information15                =>    p_information15
  ,p_information16                =>    p_information16
  ,p_information17                =>    p_information17
  ,p_information18                =>    p_information18
  ,p_information19                =>    p_information19
  ,p_information20                =>    p_information20
  ,p_information21                =>    p_information21
  ,p_information22                =>    p_information22
  ,p_information23                =>    p_information23
  ,p_information24                =>    p_information24
  ,p_information25                =>    p_information25
  ,p_information26                =>    p_information26
  ,p_information27                =>    p_information27
  ,p_information28                =>    p_information28
  ,p_information29                =>    p_information29
  ,p_information30                =>    p_information30
  ,p_information_category         =>    p_information_category
  ,p_attribute1                   =>    p_attribute1
  ,p_attribute2                   =>    p_attribute2
  ,p_attribute3                   =>    p_attribute3
  ,p_attribute4                   =>    p_attribute4
  ,p_attribute5                   =>    p_attribute5
  ,p_attribute6                   =>    p_attribute6
  ,p_attribute7                   =>    p_attribute7
  ,p_attribute8                   =>    p_attribute8
  ,p_attribute9                   =>    p_attribute9
  ,p_attribute10                  =>    p_attribute10
  ,p_attribute11                  =>    p_attribute11
  ,p_attribute12                  =>    p_attribute12
  ,p_attribute13                  =>    p_attribute13
  ,p_attribute14                  =>    p_attribute14
  ,p_attribute15                  =>    p_attribute15
  ,p_attribute16                  =>    p_attribute16
  ,p_attribute17                  =>    p_attribute17
  ,p_attribute18                  =>    p_attribute18
  ,p_attribute19                  =>    p_attribute19
  ,p_attribute20                  =>    p_attribute20
  ,p_attribute21                  =>    p_attribute21
  ,p_attribute22                  =>    p_attribute22
  ,p_attribute23                  =>    p_attribute23
  ,p_attribute24                  =>    p_attribute24
  ,p_attribute25                  =>    p_attribute25
  ,p_attribute26                  =>    p_attribute26
  ,p_attribute27                  =>    p_attribute27
  ,p_attribute28                  =>    p_attribute28
  ,p_attribute29                  =>    p_attribute29
  ,p_attribute30                  =>    p_attribute30
  ,p_attribute_category           =>    p_attribute_category
);

Line: 1237


         p_module_name => 'update_corps_extra_info'
        ,p_hook_type   => 'AP'
        );

Line: 1267


    ROLLBACK TO update_corps_extra_info;

Line: 1280


    ROLLBACK TO update_corps_extra_info;

Line: 1314


procedure delete_corps_extra_info
  (
  p_validate                        in boolean        default false
  ,p_corps_extra_info_id            in  number
  ,p_object_version_number          in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_corps_extra_info';

Line: 1332


  savepoint delete_corps_extra_info;

Line: 1345


    pqh_corps_extra_info_bk3.delete_corps_extra_info_b
      (
       p_corps_extra_info_id            =>  p_corps_extra_info_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 1353


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

Line: 1377


    pqh_corps_extra_info_bk3.delete_corps_extra_info_a
      (
       p_corps_extra_info_id            =>  p_corps_extra_info_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 1385


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

Line: 1410


    ROLLBACK TO delete_corps_extra_info;

Line: 1421


    ROLLBACK TO delete_corps_extra_info;

Line: 1424


end delete_corps_extra_info;