APPS.IRC_ASSIGNMENT_DETAILS_API SQL Statements

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

Line: 170

procedure update_assignment_details
  (p_validate                      in     boolean  default false
  ,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
  ) is
  --
  -- Declare cursors and local variables
  --
  l_latest_details         irc_assignment_details_f.latest_details%TYPE;

Line: 196

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

Line: 202

  savepoint update_assignment_details;

Line: 216

    irc_assignment_details_bk2.update_assignment_details_b
      (p_effective_date                => l_effective_date
      ,p_datetrack_update_mode         => p_datetrack_update_mode
      ,p_assignment_id                 => p_assignment_id
      ,p_attempt_id                    => p_attempt_id
      ,p_assignment_details_id         => l_assignment_details_id
      ,p_object_version_number         => l_object_version_number
      ,p_qualified                     => p_qualified
      ,p_considered                    => p_considered
      );

Line: 229

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

Line: 243

    ,p_datetrack_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      => l_assignment_details_id
    ,p_details_version            => l_details_version
    ,p_latest_details             => l_latest_details
    ,p_effective_start_date       => l_effective_start_date
    ,p_effective_end_date         => l_effective_end_date
    ,p_object_version_number      => l_object_version_number
    );

Line: 260

    irc_assignment_details_bk2.update_assignment_details_a
      (p_effective_date                => l_effective_date
      ,p_datetrack_update_mode         => p_datetrack_update_mode
      ,p_assignment_details_id         => l_assignment_details_id
      ,p_assignment_id                 => p_assignment_id
      ,p_attempt_id                    => p_attempt_id
      ,p_details_version               => l_details_version
      ,p_latest_details                => l_latest_details
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      ,p_object_version_number         => l_object_version_number
      ,p_qualified                     => p_qualified
      ,p_considered                    => p_considered
      );

Line: 277

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

Line: 303

    rollback to update_assignment_details;

Line: 320

    rollback to update_assignment_details;

Line: 333

end update_assignment_details;