APPS.PER_SUPPLEMENTARY_ROLE_API SQL Statements

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

Line: 337

procedure update_supplementary_role
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_role_id                       in     number
  ,p_object_version_number         in out nocopy number
  ,p_start_date                    in     date     default hr_api.g_date
  ,p_end_date                      in     date     default hr_api.g_date
  ,p_confidential_date             in     date     default hr_api.g_date
  ,p_emp_rights_flag               in     varchar2 default hr_api.g_varchar2
  ,p_end_of_rights_date            in     date     default hr_api.g_date
  ,p_primary_contact_flag          in     varchar2 default hr_api.g_varchar2
  ,p_attribute_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_role_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_role_information1              in     varchar2 default hr_api.g_varchar2
  ,p_role_information2              in     varchar2 default hr_api.g_varchar2
  ,p_role_information3              in     varchar2 default hr_api.g_varchar2
  ,p_role_information4              in     varchar2 default hr_api.g_varchar2
  ,p_role_information5              in     varchar2 default hr_api.g_varchar2
  ,p_role_information6              in     varchar2 default hr_api.g_varchar2
  ,p_role_information7              in     varchar2 default hr_api.g_varchar2
  ,p_role_information8              in     varchar2 default hr_api.g_varchar2
  ,p_role_information9              in     varchar2 default hr_api.g_varchar2
  ,p_role_information10             in     varchar2 default hr_api.g_varchar2
  ,p_role_information11             in     varchar2 default hr_api.g_varchar2
  ,p_role_information12             in     varchar2 default hr_api.g_varchar2
  ,p_role_information13             in     varchar2 default hr_api.g_varchar2
  ,p_role_information14             in     varchar2 default hr_api.g_varchar2
  ,p_role_information15             in     varchar2 default hr_api.g_varchar2
  ,p_role_information16             in     varchar2 default hr_api.g_varchar2
  ,p_role_information17             in     varchar2 default hr_api.g_varchar2
  ,p_role_information18             in     varchar2 default hr_api.g_varchar2
  ,p_role_information19             in     varchar2 default hr_api.g_varchar2
  ,p_role_information20             in     varchar2 default hr_api.g_varchar2
  ,p_old_end_date                   in     date     default hr_api.g_date     -- fix 1370960
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                   varchar2(72) := g_package||'update_role';

Line: 411

  savepoint update_role;

Line: 430

 per_supplementary_role_bk2.update_supplementary_role_b
  (p_effective_date              => l_effective_date
  ,p_role_id                     => p_role_id
  ,p_object_version_number       => p_object_version_number
  ,p_start_date                  => l_start_date
  ,p_end_date                    => l_end_date
  ,p_confidential_date           => l_confidential_date
  ,p_emp_rights_flag             => p_emp_rights_flag
  ,p_end_of_rights_date          => l_end_of_rights_date
  ,p_primary_contact_flag        => p_primary_contact_flag
  ,p_attribute_category          => p_attribute_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_role_information_category   => p_role_information_category
  ,p_role_information1           => p_role_information1
  ,p_role_information2           => p_role_information2
  ,p_role_information3           => p_role_information3
  ,p_role_information4           => p_role_information4
  ,p_role_information5           => p_role_information5
  ,p_role_information6           => p_role_information6
  ,p_role_information7           => p_role_information7
  ,p_role_information8           => p_role_information8
  ,p_role_information9           => p_role_information9
  ,p_role_information10          => p_role_information10
  ,p_role_information11          => p_role_information11
  ,p_role_information12          => p_role_information12
  ,p_role_information13          => p_role_information13
  ,p_role_information14          => p_role_information14
  ,p_role_information15          => p_role_information15
  ,p_role_information16          => p_role_information16
  ,p_role_information17          => p_role_information17
  ,p_role_information18          => p_role_information18
  ,p_role_information19          => p_role_information19
  ,p_role_information20          => p_role_information20
      );

Line: 486

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

Line: 554

 per_supplementary_role_bk2.update_supplementary_role_a
  (p_effective_date              => l_effective_date
  ,p_role_id                     => p_role_id
  ,p_object_version_number       => l_object_version_number
  ,p_start_date                  => l_start_date
  ,p_end_date                    => l_end_date
  ,p_confidential_date           => l_confidential_date
  ,p_emp_rights_flag             => p_emp_rights_flag
  ,p_end_of_rights_date          => l_end_of_rights_date
  ,p_primary_contact_flag        => p_primary_contact_flag
  ,p_attribute_category          => p_attribute_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_role_information_category   => p_role_information_category
  ,p_role_information1           => p_role_information1
  ,p_role_information2           => p_role_information2
  ,p_role_information3           => p_role_information3
  ,p_role_information4           => p_role_information4
  ,p_role_information5           => p_role_information5
  ,p_role_information6           => p_role_information6
  ,p_role_information7           => p_role_information7
  ,p_role_information8           => p_role_information8
  ,p_role_information9           => p_role_information9
  ,p_role_information10          => p_role_information10
  ,p_role_information11          => p_role_information11
  ,p_role_information12          => p_role_information12
  ,p_role_information13          => p_role_information13
  ,p_role_information14          => p_role_information14
  ,p_role_information15          => p_role_information15
  ,p_role_information16          => p_role_information16
  ,p_role_information17          => p_role_information17
  ,p_role_information18          => p_role_information18
  ,p_role_information19          => p_role_information19
  ,p_role_information20          => p_role_information20
       );

Line: 610

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

Line: 632

    rollback to update_role;

Line: 644

    rollback to update_role;

Line: 647

end update_supplementary_role;

Line: 654

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

Line: 669

  cursor csr_candidate_update (p_role_id number) is
  select election_candidate_id, object_version_number
  from per_election_candidates
  where role_id = p_role_id;

Line: 679

  savepoint delete_role;

Line: 684

    per_supplementary_role_bk3.delete_supplementary_role_b
     (p_role_id                 => p_role_id,
      p_object_version_number   => p_object_version_number
     );

Line: 691

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

Line: 702

  open csr_candidate_update(p_role_id);

Line: 705

   fetch csr_candidate_update into l_election_candidate_id, l_election_ovn;

Line: 706

   exit when csr_candidate_update%notfound;

Line: 707

    hr_elc_candidate_api.update_election_candidate
    (p_election_candidate_id      => l_election_candidate_id
    ,p_object_version_number      => l_election_ovn
    ,p_role_id                    => l_election_role_id);

Line: 712

  close csr_candidate_update;

Line: 727

    per_supplementary_role_bk3.delete_supplementary_role_a
     (p_role_id                 => p_role_id,
      p_object_version_number   => p_object_version_number
     );

Line: 734

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

Line: 752

    ROLLBACK TO delete_role;

Line: 759

  ROLLBACK TO delete_role;

Line: 763

end delete_supplementary_role;