DBA Data[Home] [Help]

APPS.IRC_APPLICANT_TRACKING_SWI SQL Statements

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

Line: 116

PROCEDURE update_applicant_snapshot
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_person_id                    in     number
  ,p_profile_snapshot_id          in out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;
Line: 133

  l_proc    varchar2(72) := g_package ||'update_applicant_snapshot';
Line: 139

  savepoint update_applicant_snapshot_swi;
Line: 161

  irc_apl_prfl_snapshots_api.update_applicant_snapshot
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_person_id                    => p_person_id
    ,p_profile_snapshot_id          => p_profile_snapshot_id
    ,p_object_version_number        => p_object_version_number
    );
Line: 190

    rollback to update_applicant_snapshot_swi;
Line: 206

    rollback to update_applicant_snapshot_swi;
Line: 218

end update_applicant_snapshot;
Line: 223

PROCEDURE delete_applicant_snapshot
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_person_id                    in     number
  ,p_profile_snapshot_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_applicant_snapshot';
Line: 244

  savepoint delete_applicant_snapshot_swi;
Line: 264

  irc_apl_prfl_snapshots_api.delete_applicant_snapshot
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_person_id                    => p_person_id
    ,p_profile_snapshot_id          => p_profile_snapshot_id
    ,p_object_version_number        => p_object_version_number
    );
Line: 293

    rollback to delete_applicant_snapshot_swi;
Line: 307

    rollback to delete_applicant_snapshot_swi;
Line: 317

end delete_applicant_snapshot;
Line: 427

PROCEDURE update_search_criteria
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_vacancy_id                   in     number
  ,p_saved_search_criteria_id     in out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;
Line: 443

  l_proc    varchar2(72) := g_package ||'update_search_criteria';
Line: 449

  savepoint update_search_criteria_swi;
Line: 471

  irc_saved_search_criteria_api.update_search_criteria
    (p_validate                     => l_validate
    ,p_vacancy_id                   => p_vacancy_id
    ,p_saved_search_criteria_id     => p_saved_search_criteria_id
    ,p_object_version_number        => p_object_version_number
    );
Line: 499

    rollback to update_search_criteria_swi;
Line: 515

    rollback to update_search_criteria_swi;
Line: 527

end update_search_criteria;
Line: 532

PROCEDURE delete_search_criteria
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_vacancy_id                   in     number
  ,p_saved_search_criteria_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: 546

  l_proc    varchar2(72) := g_package ||'delete_search_criteria';
Line: 552

  savepoint delete_search_criteria_swi;
Line: 572

  irc_saved_search_criteria_api.delete_search_criteria
    (p_validate                     => l_validate
    ,p_vacancy_id                   => p_vacancy_id
    ,p_saved_search_criteria_id     => p_saved_search_criteria_id
    ,p_object_version_number        => p_object_version_number
    );
Line: 600

    rollback to delete_search_criteria_swi;
Line: 614

    rollback to delete_search_criteria_swi;
Line: 624

end delete_search_criteria;
Line: 729

PROCEDURE update_apl_profile_access
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_person_id                    in     number
  ,p_apl_profile_access_id        in out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;
Line: 745

  l_proc    varchar2(72) := g_package ||'update_apl_profile_access';
Line: 751

  savepoint update_apl_profile_access_swi;
Line: 773

  irc_apl_profile_access_api.update_apl_profile_access
    (p_validate                     => l_validate
    ,p_person_id                    => p_person_id
    ,p_apl_profile_access_id        => p_apl_profile_access_id
    ,p_object_version_number        => p_object_version_number
    );
Line: 801

    rollback to update_apl_profile_access_swi;
Line: 817

    rollback to update_apl_profile_access_swi;
Line: 829

end update_apl_profile_access;
Line: 834

PROCEDURE delete_apl_profile_access
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_person_id                   in     number
  ,p_apl_profile_access_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: 848

  l_proc    varchar2(72) := g_package ||'delete_apl_profile_access';
Line: 854

  savepoint delete_apl_profile_access_swi;
Line: 874

  irc_apl_profile_access_api.delete_apl_profile_access
    (p_validate                     => l_validate
    ,p_person_id                   => p_person_id
    ,p_apl_profile_access_id     => p_apl_profile_access_id
    ,p_object_version_number        => p_object_version_number
    );
Line: 902

    rollback to delete_apl_profile_access_swi;
Line: 916

    rollback to delete_apl_profile_access_swi;
Line: 926

end delete_apl_profile_access;