DBA Data[Home] [Help]

APPS.HR_DE_ORGANIZATION_LINKS_API SQL Statements

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

Line: 87

    select org.business_group_id
    from   hr_organization_units org
    where  org.organization_id = p_parent_organization_id;
Line: 394

procedure update_link
  (p_validate                       in     boolean  default false
  ,p_effective_date                 in     date
  ,p_organization_link_id           in     number
  ,p_org_link_information_categor   in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information1          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information2          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information3          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information4          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information5          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information6          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information7          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information8          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information9          in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information10         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information11         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information12         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information13         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information14         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information15         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information16         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information17         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information18         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information19         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information20         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information21         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information22         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information23         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information24         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information25         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information26         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information27         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information28         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information29         in     varchar2 default hr_api.g_varchar2
  ,p_org_link_information30         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_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_object_version_number          in out nocopy number
  ) is
  --
  -- Declare local variables
  --
  l_proc                  varchar2(72) := g_package||'update_link';
Line: 473

  savepoint update_link;
Line: 478

    hr_de_organization_links_bk2.update_link_b
      (p_effective_date               => trunc(p_effective_date)
      ,p_organization_link_id         => p_organization_link_id
      ,p_org_link_information_categor => p_org_link_information_categor
      ,p_org_link_information1        => p_org_link_information1
      ,p_org_link_information2        => p_org_link_information2
      ,p_org_link_information3        => p_org_link_information3
      ,p_org_link_information4        => p_org_link_information4
      ,p_org_link_information5        => p_org_link_information5
      ,p_org_link_information6        => p_org_link_information6
      ,p_org_link_information7        => p_org_link_information7
      ,p_org_link_information8        => p_org_link_information8
      ,p_org_link_information9        => p_org_link_information9
      ,p_org_link_information10       => p_org_link_information10
      ,p_org_link_information11       => p_org_link_information11
      ,p_org_link_information12       => p_org_link_information12
      ,p_org_link_information13       => p_org_link_information13
      ,p_org_link_information14       => p_org_link_information14
      ,p_org_link_information15       => p_org_link_information15
      ,p_org_link_information16       => p_org_link_information16
      ,p_org_link_information17       => p_org_link_information17
      ,p_org_link_information18       => p_org_link_information18
      ,p_org_link_information19       => p_org_link_information19
      ,p_org_link_information20       => p_org_link_information20
      ,p_org_link_information21       => p_org_link_information21
      ,p_org_link_information22       => p_org_link_information22
      ,p_org_link_information23       => p_org_link_information23
      ,p_org_link_information24       => p_org_link_information24
      ,p_org_link_information25       => p_org_link_information25
      ,p_org_link_information26       => p_org_link_information26
      ,p_org_link_information27       => p_org_link_information27
      ,p_org_link_information28       => p_org_link_information28
      ,p_org_link_information29       => p_org_link_information29
      ,p_org_link_information30       => p_org_link_information30
      ,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_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_object_version_number        => l_object_version_number);
Line: 547

        (p_module_name => 'update_link'
        ,p_hook_type   => 'BP'
        );
Line: 624

    hr_de_organization_links_bk2.update_link_a
      (p_effective_date               => trunc(p_effective_date)
      ,p_organization_link_id         => p_organization_link_id
      ,p_org_link_information_categor => p_org_link_information_categor
      ,p_org_link_information1        => p_org_link_information1
      ,p_org_link_information2        => p_org_link_information2
      ,p_org_link_information3        => p_org_link_information3
      ,p_org_link_information4        => p_org_link_information4
      ,p_org_link_information5        => p_org_link_information5
      ,p_org_link_information6        => p_org_link_information6
      ,p_org_link_information7        => p_org_link_information7
      ,p_org_link_information8        => p_org_link_information8
      ,p_org_link_information9        => p_org_link_information9
      ,p_org_link_information10       => p_org_link_information10
      ,p_org_link_information11       => p_org_link_information11
      ,p_org_link_information12       => p_org_link_information12
      ,p_org_link_information13       => p_org_link_information13
      ,p_org_link_information14       => p_org_link_information14
      ,p_org_link_information15       => p_org_link_information15
      ,p_org_link_information16       => p_org_link_information16
      ,p_org_link_information17       => p_org_link_information17
      ,p_org_link_information18       => p_org_link_information18
      ,p_org_link_information19       => p_org_link_information19
      ,p_org_link_information20       => p_org_link_information20
      ,p_org_link_information21       => p_org_link_information21
      ,p_org_link_information22       => p_org_link_information22
      ,p_org_link_information23       => p_org_link_information23
      ,p_org_link_information24       => p_org_link_information24
      ,p_org_link_information25       => p_org_link_information25
      ,p_org_link_information26       => p_org_link_information26
      ,p_org_link_information27       => p_org_link_information27
      ,p_org_link_information28       => p_org_link_information28
      ,p_org_link_information29       => p_org_link_information29
      ,p_org_link_information30       => p_org_link_information30
      ,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_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_object_version_number        => l_object_version_number);
Line: 693

        (p_module_name => 'update_link'
        ,p_hook_type   => 'AP'
        );
Line: 715

    rollback to update_link;
Line: 727

    rollback to update_link;
Line: 732

end update_link;
Line: 738

procedure delete_link
  (p_validate                       in     boolean  default false
  ,p_organization_link_id           in     number
  ,p_object_version_number          in     number
  ) is
  --
  -- Declare local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_link';
Line: 752

  savepoint delete_link;
Line: 757

    hr_de_organization_links_bk3.delete_link_b
      (p_organization_link_id  => p_organization_link_id
      ,p_object_version_number => p_object_version_number);
Line: 763

        (p_module_name => 'delete_link'
        ,p_hook_type   => 'BP'
        );
Line: 775

    hr_de_organization_links_bk3.delete_link_a
      (p_organization_link_id  => p_organization_link_id
      ,p_object_version_number => p_object_version_number);
Line: 781

        (p_module_name => 'delete_link'
        ,p_hook_type   => 'AP'
        );
Line: 799

    rollback to delete_link;
Line: 810

    rollback to delete_link;
Line: 813

end delete_link;