APPS.IRC_REC_TEAM_MEMBERS_API SQL Statements

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

Line: 19

  ,p_update_allowed                in     varchar2 default 'Y'
  ,p_delete_allowed                in     varchar2 default 'Y'
  ,p_rec_team_member_id            out nocopy    number
  ,p_object_version_number         out nocopy    number
  ,p_interview_security             in      varchar2 default 'SELF'
  ) is
  --
  -- Declare cursors and local variables
  --
  --
  l_proc                    varchar2(72) := g_package||'create_rec_team_member';

Line: 57

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

Line: 73

  ,p_update_allowed                 => p_update_allowed
  ,p_delete_allowed                 => p_delete_allowed
  ,p_start_date                     => l_start_date
  ,p_end_date                       => l_end_date
  ,p_person_id                      => p_person_id
  ,p_vacancy_id                     => p_vacancy_id
  ,p_rec_team_member_id             => l_rec_team_member_id
  ,p_object_version_number          => l_object_version_number
  ,p_interview_security              => p_interview_security
  );

Line: 94

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

Line: 152

procedure update_rec_team_member
  (p_validate                      in     boolean  default false
  ,p_rec_team_member_id            in     number
  ,p_person_id                     in     number   default hr_api.g_number
  ,p_vacancy_id                    in     number   default hr_api.g_number
  ,p_party_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'
  ) is
--
  --
  -- Declare cursors and local variables
  --
  l_proc                   varchar2(72) := g_package||'update_rec_team_member';

Line: 179

  savepoint update_rec_team_member;

Line: 189

    IRC_REC_TEAM_MEMBERS_BK2.UPDATE_REC_TEAM_MEMBER_B
    (p_rec_team_member_id    =>   p_rec_team_member_id
    ,p_person_id             =>   p_person_id
    ,p_object_version_number =>   l_object_version_number
    ,p_job_id                =>   p_job_id
    ,p_start_date            =>   l_start_date
    ,p_end_date              =>   l_end_date
    ,p_update_allowed        =>   p_update_allowed
    ,p_delete_allowed        =>   p_delete_allowed
    ,p_interview_security     =>   p_interview_security
    );

Line: 203

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

Line: 217

  ,p_update_allowed          => p_update_allowed
  ,p_delete_allowed          => p_delete_allowed
  ,p_start_date              => l_start_date
  ,p_end_date                => l_end_date
  ,p_interview_security       => p_interview_security
  );

Line: 227

    IRC_REC_TEAM_MEMBERS_BK2.UPDATE_REC_TEAM_MEMBER_A
    (p_rec_team_member_id     => p_rec_team_member_id
    ,p_person_id              => p_person_id
    ,p_object_version_number  => l_object_version_number
    ,p_job_id                 => p_job_id
    ,p_start_date             => l_start_date
    ,p_end_date               => l_end_date
    ,p_update_allowed         => p_update_allowed
    ,p_delete_allowed         => p_delete_allowed
    ,p_interview_security      => p_interview_security
    );

Line: 241

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

Line: 263

    rollback to UPDATE_REC_TEAM_MEMBER;

Line: 278

    rollback to UPDATE_REC_TEAM_MEMBER;

Line: 285

end UPDATE_REC_TEAM_MEMBER;

Line: 291

procedure delete_rec_team_member
  (p_validate                      in     boolean  default false
  ,p_rec_team_member_id             in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_rec_team_member';

Line: 305

  savepoint delete_rec_team_member;

Line: 310

    IRC_REC_TEAM_MEMBERS_BK3.DELETE_REC_TEAM_MEMBER_B
    (p_rec_team_member_id    => p_rec_team_member_id
    ,p_object_version_number => p_object_version_number
    );

Line: 317

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

Line: 332

     IRC_REC_TEAM_MEMBERS_BK3.DELETE_REC_TEAM_MEMBER_A
    (p_rec_team_member_id      => p_rec_team_member_id
    ,p_object_version_number   => p_object_version_number
    );

Line: 339

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

Line: 360

    rollback to DELETE_REC_TEAM_MEMBER;

Line: 371

    rollback to DELETE_REC_TEAM_MEMBER;

Line: 374

end DELETE_REC_TEAM_MEMBER;