APPS.IRC_REC_TEAM_MEMBERS_SWI SQL Statements

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

Line: 19

  ,p_update_allowed               in     varchar2  default null
  ,p_delete_allowed               in     varchar2  default null
  ,p_interview_security            in     varchar2  default 'SELF'
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 70

    ,p_update_allowed               => p_update_allowed
    ,p_delete_allowed               => p_delete_allowed
    ,p_interview_security            => p_interview_security
    ,p_object_version_number        => p_object_version_number
    );

Line: 127

PROCEDURE delete_rec_team_member
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_rec_team_member_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: 140

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

Line: 144

  select object_version_number
    from irc_rec_team_members
   where rec_team_member_id = p_rec_team_member_id;

Line: 153

  savepoint delete_rec_team_member_swi;

Line: 180

  irc_rec_team_members_api.delete_rec_team_member
    (p_validate                     => l_validate
    ,p_rec_team_member_id           => p_rec_team_member_id
    ,p_object_version_number        => l_object_version_number
    );

Line: 207

    rollback to delete_rec_team_member_swi;

Line: 221

    rollback to delete_rec_team_member_swi;

Line: 231

end delete_rec_team_member;

Line: 235

PROCEDURE update_rec_team_member
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_rec_team_member_id           in     number
  ,p_person_id                    in     number    default hr_api.g_number
  ,p_party_id                     in     number    default hr_api.g_number
  ,p_vacancy_id                   in     number    default hr_api.g_number
  ,p_object_version_number        in out nocopy number
  ,p_job_id                       in     number    default hr_api.g_number
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_update_allowed               in     varchar2  default hr_api.g_varchar2
  ,p_delete_allowed               in     varchar2  default hr_api.g_varchar2
  ,p_interview_security            in     varchar2  default 'SELF'
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 258

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

Line: 264

  savepoint update_rec_team_member_swi;

Line: 285

  irc_rec_team_members_api.update_rec_team_member
    (p_validate                     => l_validate
    ,p_rec_team_member_id           => p_rec_team_member_id
    ,p_person_id                    => p_person_id
    ,p_object_version_number        => p_object_version_number
    ,p_job_id                       => p_job_id
    ,p_party_id                     => p_party_id
    ,p_vacancy_id                   => p_vacancy_id
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_update_allowed               => p_update_allowed
    ,p_delete_allowed               => p_delete_allowed
    ,p_interview_security            => p_interview_security
    );

Line: 321

    rollback to update_rec_team_member_swi;

Line: 336

    rollback to update_rec_team_member_swi;

Line: 347

end update_rec_team_member;

Line: 409

    ,p_update_allowed         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
    ,p_delete_allowed         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
    ,p_interview_security      => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
    ,p_object_version_number  => l_object_version_number
    ,p_return_status          => l_return_status
    );

Line: 420

    update_rec_team_member
    (p_validate               => p_validate
    ,p_rec_team_member_id     => l_rec_team_member_id
    ,p_person_id              => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',NULL)
    ,p_party_id               => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',NULL)
    ,p_vacancy_id             => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
    ,p_job_id                 => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',NULL)
    ,p_start_date             => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',NULL)
    ,p_end_date               => hr_transaction_swi.getDateValue(l_CommitNode,'EndDate',NULL)
    ,p_update_allowed         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAllowed',NULL)
    ,p_delete_allowed         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeleteAllowed',NULL)
    ,p_interview_security      => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InterviewSecurity',NULL)
    ,p_object_version_number  => l_object_version_number
    ,p_return_status          => l_return_status
    );

Line: 440

    delete_rec_team_member
    (p_validate               => p_validate
    ,p_object_version_number  => l_object_version_number
    ,p_rec_team_member_id     => l_rec_team_member_id
    ,p_return_status          => l_return_status
    );