APPS.HR_KI_TOPIC_INTEGRATIONS_API SQL Statements

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

Line: 250

  select topic_id
   from  hr_ki_topics
   where topic_key = p_topic_key;

Line: 255

  select integration_id
    from hr_ki_integrations
   where integration_key = p_integration_key;

Line: 342

procedure update_topic_integration
  (
   p_validate                      in     boolean  default false
  ,p_topic_integrations_id         in     number
  ,p_topic_id                      in     number   default hr_api.g_number
  ,p_integration_id                in     number   default hr_api.g_number
  ,p_param_name1                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value1                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name2                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value2                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name3                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value3                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name4                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value4                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name5                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value5                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name6                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value6                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name7                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value7                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name8                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value8                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name9                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value9                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name10                  in     varchar2 default hr_api.g_varchar2
  ,p_param_value10                 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_topic_integration';

Line: 381

  savepoint update_topic_integration;

Line: 391

    hr_ki_topic_integrations_bk2.update_topic_integration_b
      (
       p_topic_id                   => p_topic_id
      ,p_integration_id             => p_integration_id
      ,p_param_name1                => p_param_name1
      ,p_param_value1               => p_param_value1
      ,p_param_name2                => p_param_name2
      ,p_param_value2               => p_param_value2
      ,p_param_name3                => p_param_name3
      ,p_param_value3               => p_param_value3
      ,p_param_name4                => p_param_name4
      ,p_param_value4               => p_param_value4
      ,p_param_name5                => p_param_name5
      ,p_param_value5               => p_param_value5
      ,p_param_name6                => p_param_name6
      ,p_param_value6               => p_param_value6
      ,p_param_name7                => p_param_name7
      ,p_param_value7               => p_param_value7
      ,p_param_name8                => p_param_name8
      ,p_param_value8               => p_param_value8
      ,p_param_name9                => p_param_name9
      ,p_param_value9               => p_param_value9
      ,p_param_name10               => p_param_name10
      ,p_param_value10              => p_param_value10
      ,p_topic_integrations_id      => p_topic_integrations_id
      ,p_object_version_number      => p_object_version_number
      );

Line: 421

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

Line: 461

    hr_ki_topic_integrations_bk2.update_topic_integration_a
      (
       p_topic_id                   => p_topic_id
      ,p_integration_id             => p_integration_id
      ,p_param_name1                => p_param_name1
      ,p_param_value1               => p_param_value1
      ,p_param_name2                => p_param_name2
      ,p_param_value2               => p_param_value2
      ,p_param_name3                => p_param_name3
      ,p_param_value3               => p_param_value3
      ,p_param_name4                => p_param_name4
      ,p_param_value4               => p_param_value4
      ,p_param_name5                => p_param_name5
      ,p_param_value5               => p_param_value5
      ,p_param_name6                => p_param_name6
      ,p_param_value6               => p_param_value6
      ,p_param_name7                => p_param_name7
      ,p_param_value7               => p_param_value7
      ,p_param_name8                => p_param_name8
      ,p_param_value8               => p_param_value8
      ,p_param_name9                => p_param_name9
      ,p_param_value9               => p_param_value9
      ,p_param_name10               => p_param_name10
      ,p_param_value10              => p_param_value10
      ,p_topic_integrations_id      => p_topic_integrations_id
      ,p_object_version_number      => p_object_version_number
      );

Line: 491

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

Line: 515

    rollback to update_topic_integration;

Line: 529

    rollback to update_topic_integration;

Line: 539

end update_topic_integration;

Line: 545

procedure update_topic_integration_key
  (
   p_validate                      in     boolean  default false
  ,p_topic_integrations_id         in     number
  ,p_topic_key                     in     varchar2 default hr_api.g_varchar2
  ,p_integration_key               in     varchar2 default hr_api.g_varchar2
  ,p_param_name1                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value1                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name2                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value2                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name3                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value3                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name4                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value4                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name5                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value5                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name6                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value6                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name7                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value7                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name8                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value8                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name9                   in     varchar2 default hr_api.g_varchar2
  ,p_param_value9                  in     varchar2 default hr_api.g_varchar2
  ,p_param_name10                  in     varchar2 default hr_api.g_varchar2
  ,p_param_value10                 in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy   number
  ) is
    --
  -- Declare cursors and local variables
  --
  CURSOR csr_topic_key is
  select
   topic_id
  from
   hr_ki_topics
  where topic_key = p_topic_key;

Line: 584

  select
   integration_id
  from
   hr_ki_integrations
  where integration_key = p_integration_key;

Line: 590

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

Line: 601

  savepoint update_topic_integration_key;

Line: 611

  update_topic_integration
  (
   p_validate              => p_validate
  ,p_topic_integrations_id => p_topic_integrations_id
  ,p_topic_id              => l_topic_id
  ,p_integration_id        => l_integration_id
  ,p_param_name1           => p_param_name1
  ,p_param_value1          => p_param_value1
  ,p_param_name2           => p_param_name2
  ,p_param_value2          => p_param_value2
  ,p_param_name3           => p_param_name3
  ,p_param_value3          => p_param_value3
  ,p_param_name4           => p_param_name4
  ,p_param_value4          => p_param_value4
  ,p_param_name5           => p_param_name5
  ,p_param_value5          => p_param_value5
  ,p_param_name6           => p_param_name6
  ,p_param_value6          => p_param_value6
  ,p_param_name7           => p_param_name7
  ,p_param_value7          => p_param_value7
  ,p_param_name8           => p_param_name8
  ,p_param_value8          => p_param_value8
  ,p_param_name9           => p_param_name9
  ,p_param_value9          => p_param_value9
  ,p_param_name10          => p_param_name10
  ,p_param_value10         => p_param_value10
  ,p_object_version_number => p_object_version_number
  );

Line: 663

end update_topic_integration_key;

Line: 670

procedure delete_topic_integration
  (
   P_VALIDATE                 in boolean         default false
  ,P_TOPIC_INTEGRATIONS_ID    in number
  ,P_OBJECT_VERSION_NUMBER    in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_topic_integration';

Line: 686

  savepoint delete_topic_integration;

Line: 694

    hr_ki_topic_integrations_bk3.delete_topic_integration_b
      (
       p_topic_integrations_id   => p_topic_integrations_id
       ,p_object_version_number  => p_object_version_number

      );

Line: 703

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

Line: 723

    hr_ki_topic_integrations_bk3.delete_topic_integration_a
      (
       p_topic_integrations_id   =>    p_topic_integrations_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 731

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

Line: 753

    rollback to delete_topic_integration;

Line: 765

    rollback to delete_topic_integration;

Line: 772

end delete_topic_integration;