APPS.IRC_IID_INS SQL Statements

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

Line: 79

Procedure dt_insert_dml
  (p_rec                     in out nocopy irc_iid_shd.g_rec_type
  ,p_effective_date          in date
  ,p_datetrack_mode          in varchar2
  ,p_validation_start_date   in date
  ,p_validation_end_date     in date
  ) is
-- Cursor to select 'old' created AOL who column values
--
  Cursor C_Sel1 Is
    select t.creation_date
    from   irc_interview_details t
    where t.interview_details_id = p_rec.interview_details_id
    and    t.start_date =
             irc_iid_shd.g_old_rec.start_date
    and    t.end_date   = p_validation_start_date;

Line: 97

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

Line: 115

  If (p_datetrack_mode <> hr_api.g_insert) then
    hr_utility.set_location(l_proc, 10);

Line: 153

  insert into irc_interview_details
      (interview_details_id
      ,status
      ,feedback
      ,notes
      ,notes_to_candidate
      ,category
      ,result
      ,iid_information_category
      ,iid_information1
      ,iid_information2
      ,iid_information3
      ,iid_information4
      ,iid_information5
      ,iid_information6
      ,iid_information7
      ,iid_information8
      ,iid_information9
      ,iid_information10
      ,iid_information11
      ,iid_information12
      ,iid_information13
      ,iid_information14
      ,iid_information15
      ,iid_information16
      ,iid_information17
      ,iid_information18
      ,iid_information19
      ,iid_information20
      ,start_date
      ,end_date
      ,event_id
      ,object_version_number
      )
  Values
    (p_rec.interview_details_id
    ,p_rec.status
    ,p_rec.feedback
    ,p_rec.notes
    ,p_rec.notes_to_candidate
    ,p_rec.category
    ,p_rec.result
    ,p_rec.iid_information_category
    ,p_rec.iid_information1
    ,p_rec.iid_information2
    ,p_rec.iid_information3
    ,p_rec.iid_information4
    ,p_rec.iid_information5
    ,p_rec.iid_information6
    ,p_rec.iid_information7
    ,p_rec.iid_information8
    ,p_rec.iid_information9
    ,p_rec.iid_information10
    ,p_rec.iid_information11
    ,p_rec.iid_information12
    ,p_rec.iid_information13
    ,p_rec.iid_information14
    ,p_rec.iid_information15
    ,p_rec.iid_information16
    ,p_rec.iid_information17
    ,p_rec.iid_information18
    ,p_rec.iid_information19
    ,p_rec.iid_information20
    ,p_rec.start_date
    ,p_rec.end_date
    ,p_rec.event_id
    ,p_rec.object_version_number
    );

Line: 239

End dt_insert_dml;

Line: 244

Procedure insert_dml
  (p_rec                   in out nocopy irc_iid_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ) is
--
  l_proc        varchar2(72) := g_package||'insert_dml';

Line: 257

  irc_iid_ins.dt_insert_dml
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => p_datetrack_mode
    ,p_validation_start_date => p_validation_start_date
    ,p_validation_end_date   => p_validation_end_date
    );

Line: 266

End insert_dml;

Line: 307

Procedure pre_insert
  (p_rec                   in out nocopy irc_iid_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ) is
--
  Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;

Line: 318

    Select null
      from irc_interview_details
     where interview_details_id =
             irc_iid_ins.g_interview_details_id_i
       and p_effective_date between start_date
             and end_date;

Line: 325

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

Line: 367

End pre_insert;

Line: 401

Procedure post_insert
  (p_rec                   in irc_iid_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ) is
--
  l_proc        varchar2(72) := g_package||'post_insert';

Line: 415

    irc_iid_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_validation_start_date       => p_validation_start_date
      ,p_validation_end_date         => p_validation_end_date
      ,p_interview_details_id        => p_rec.interview_details_id
      ,p_status                      => p_rec.status
      ,p_feedback                    => p_rec.feedback
      ,p_notes                       => p_rec.notes
      ,p_notes_to_candidate          => p_rec.notes_to_candidate
      ,p_category                    => p_rec.category
      ,p_result                      => p_rec.result
      ,p_iid_information_category    => p_rec.iid_information_category
      ,p_iid_information1            => p_rec.iid_information1
      ,p_iid_information2            => p_rec.iid_information2
      ,p_iid_information3            => p_rec.iid_information3
      ,p_iid_information4            => p_rec.iid_information4
      ,p_iid_information5            => p_rec.iid_information5
      ,p_iid_information6            => p_rec.iid_information6
      ,p_iid_information7            => p_rec.iid_information7
      ,p_iid_information8            => p_rec.iid_information8
      ,p_iid_information9            => p_rec.iid_information9
      ,p_iid_information10           => p_rec.iid_information10
      ,p_iid_information11           => p_rec.iid_information11
      ,p_iid_information12           => p_rec.iid_information12
      ,p_iid_information13           => p_rec.iid_information13
      ,p_iid_information14           => p_rec.iid_information14
      ,p_iid_information15           => p_rec.iid_information15
      ,p_iid_information16           => p_rec.iid_information16
      ,p_iid_information17           => p_rec.iid_information17
      ,p_iid_information18           => p_rec.iid_information18
      ,p_iid_information19           => p_rec.iid_information19
      ,p_iid_information20           => p_rec.iid_information20
      ,p_start_date                  => p_rec.start_date
      ,p_end_date                    => p_rec.end_date
      ,p_event_id                    => p_rec.event_id
      ,p_object_version_number       => p_rec.object_version_number
      );

Line: 464

End post_insert;

Line: 542

  l_datetrack_mode              varchar2(30) := hr_api.g_insert;

Line: 561

    irc_iid_bus.insert_validate
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => l_datetrack_mode
    ,p_validation_start_date => l_validation_start_date
    ,p_validation_end_date   => l_validation_end_date
    );

Line: 574

  irc_iid_ins.pre_insert
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => l_datetrack_mode
    ,p_validation_start_date => l_validation_start_date
    ,p_validation_end_date   => l_validation_end_date
    );

Line: 584

  irc_iid_ins.insert_dml
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => l_datetrack_mode
    ,p_validation_start_date => l_validation_start_date
    ,p_validation_end_date   => l_validation_end_date
    );

Line: 594

  irc_iid_ins.post_insert
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => l_datetrack_mode
    ,p_validation_start_date => l_validation_start_date
    ,p_validation_end_date   => l_validation_end_date
    );