APPS.IRC_LINKED_CANDIDATES_SWI SQL Statements

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

Line: 120

PROCEDURE update_linked_candidate
  (p_validate                       in            number   default hr_api.g_false_num
  ,p_link_id                        in            number
  ,p_duplicate_set_id               in            number
  ,p_party_id                       in            number
  ,p_status                         in            varchar2
  ,p_target_party_id                in            number   default null
  ,p_object_version_number          in out nocopy number
  ,p_return_status                  out nocopy    varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 138

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

Line: 144

  savepoint update_linked_candidates_swi;

Line: 165

  irc_linked_candidates_api.update_linked_candidate
    (p_validate                  => l_validate
    ,p_link_id                   => p_link_id
    ,p_duplicate_set_id          => p_duplicate_set_id
    ,p_party_id                  => p_party_id
    ,p_status                    => p_status
    ,p_target_party_id           => p_target_party_id
    ,p_object_version_number     => p_object_version_number
    );

Line: 196

    rollback to update_linked_candidates_swi;

Line: 211

    rollback to update_linked_candidates_swi;

Line: 222

end update_linked_candidate;

Line: 226

PROCEDURE delete_linked_candidate
  (p_validate                       in          number   default hr_api.g_false_num
  ,p_link_id                        in          number
  ,p_object_version_number          in          number
  ,p_return_status                  out nocopy  varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 238

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

Line: 244

  savepoint delete_linked_candidates_swi;

Line: 262

  irc_linked_candidates_api.delete_linked_candidate
    (p_validate                  => l_validate
    ,p_link_id                   => p_link_id
    ,p_object_version_number     => p_object_version_number
    );

Line: 289

    rollback to delete_linked_candidates_swi;

Line: 303

    rollback to delete_linked_candidates_swi;

Line: 313

end delete_linked_candidate;