APPS.IRC_ASSIGNMENT_DETAILS_SWI SQL Statements

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

Line: 133

PROCEDURE update_assignment_details
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_update_mode        in     varchar2
  ,p_assignment_id                in     number    default hr_api.g_number
  ,p_attempt_id                   in     number    default hr_api.g_number
  ,p_qualified                    in     varchar2  default null
  ,p_considered                   in     varchar2  default null
  ,p_assignment_details_id        in out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_details_version                 out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 157

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

Line: 163

  savepoint update_assignment_details_swi;

Line: 185

  irc_assignment_details_api.update_assignment_details
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_update_mode        => p_datetrack_update_mode
    ,p_assignment_id                => p_assignment_id
    ,p_attempt_id                   => p_attempt_id
    ,p_qualified                    => p_qualified
    ,p_considered                   => p_considered
    ,p_assignment_details_id        => p_assignment_details_id
    ,p_object_version_number        => p_object_version_number
    ,p_details_version              => p_details_version
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 221

    rollback to update_assignment_details_swi;

Line: 240

    rollback to update_assignment_details_swi;

Line: 255

end update_assignment_details;