APPS.IRC_ASSIGNMENT_DETAILS_API SQL Statements

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

Line: 179

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 hr_api.g_varchar2
  ,p_considered                    in     varchar2 default hr_api.g_varchar2
  ,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: 205

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

Line: 212

  savepoint update_assignment_details;

Line: 234

    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                    => l_considered
      );

Line: 247

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

Line: 261

    ,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                 => l_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: 278

    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                    => l_considered
      );

Line: 295

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

Line: 321

    rollback to update_assignment_details;

Line: 338

    rollback to update_assignment_details;

Line: 351

end update_assignment_details;

Line: 370

  select *
    from irc_assignment_details_f
   where assignment_id = p_source_assignment_id;

Line: 374

  Cursor C_Sel1 is select irc_assignment_details_s.nextval from sys.dual;

Line: 394

  insert into irc_assignment_details_f
      (assignment_details_id
      ,assignment_id
      ,effective_start_date
      ,effective_end_date
      ,details_version
      ,latest_details
      ,attempt_id
      ,qualified
      ,considered
      ,object_version_number
      )
  Values
    (l_assignment_details_id
    ,p_target_assignment_id
    ,l_asg_det_rec.effective_start_date
    ,l_asg_det_rec.effective_end_date
    ,l_asg_det_rec.details_version
    ,l_asg_det_rec.latest_details
    ,l_asg_det_rec.attempt_id
    ,l_asg_det_rec.qualified
    ,l_asg_det_rec.considered
    ,l_asg_det_rec.object_version_number
    );