APPS.IRC_INP_INS SQL Statements

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

Line: 75

Procedure insert_dml
  (p_rec in out nocopy irc_inp_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 89

  insert into irc_notification_preferences
      (party_id
      ,person_id
      ,notification_preference_id
      ,matching_jobs
      ,matching_job_freq
      ,attribute_category
      ,receive_info_mail
      ,allow_access
      ,address_id
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,attribute21
      ,attribute22
      ,attribute23
      ,attribute24
      ,attribute25
      ,attribute26
      ,attribute27
      ,attribute28
      ,attribute29
      ,attribute30
      ,object_version_number
      ,agency_id
      ,attempt_id
      )
  Values
    (p_rec.party_id
    ,p_rec.person_id
    ,p_rec.notification_preference_id
    ,p_rec.matching_jobs
    ,p_rec.matching_job_freq
    ,p_rec.attribute_category
    ,p_rec.receive_info_mail
    ,p_rec.allow_access
    ,p_rec.address_id
    ,p_rec.attribute1
    ,p_rec.attribute2
    ,p_rec.attribute3
    ,p_rec.attribute4
    ,p_rec.attribute5
    ,p_rec.attribute6
    ,p_rec.attribute7
    ,p_rec.attribute8
    ,p_rec.attribute9
    ,p_rec.attribute10
    ,p_rec.attribute11
    ,p_rec.attribute12
    ,p_rec.attribute13
    ,p_rec.attribute14
    ,p_rec.attribute15
    ,p_rec.attribute16
    ,p_rec.attribute17
    ,p_rec.attribute18
    ,p_rec.attribute19
    ,p_rec.attribute20
    ,p_rec.attribute21
    ,p_rec.attribute22
    ,p_rec.attribute23
    ,p_rec.attribute24
    ,p_rec.attribute25
    ,p_rec.attribute26
    ,p_rec.attribute27
    ,p_rec.attribute28
    ,p_rec.attribute29
    ,p_rec.attribute30
    ,p_rec.object_version_number
    ,p_rec.agency_id
    ,p_rec.attempt_id
    );

Line: 204

End insert_dml;

Line: 243

Procedure pre_insert
  (p_rec  in out nocopy irc_inp_shd.g_rec_type
  ) is
--
cursor c1 is select irc_notification_prefs_s.nextval from sys.dual;

Line: 250

select null from irc_notification_preferences
where notification_preference_id = irc_inp_ins.g_notification_preference_id_i;

Line: 253

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

Line: 284

End pre_insert;

Line: 318

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

Line: 329

    irc_inp_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_party_id
      => p_rec.party_id
      ,p_person_id => p_rec.person_id
      ,p_notification_preference_id => p_rec.notification_preference_id
      ,p_matching_jobs
      => p_rec.matching_jobs
      ,p_matching_job_freq
      => p_rec.matching_job_freq
      ,p_attribute_category
      => p_rec.attribute_category
      ,p_receive_info_mail
      => p_rec.receive_info_mail
      ,p_allow_access
      => p_rec.allow_access
      ,p_address_id
      => p_rec.address_id
      ,p_attribute1
      => p_rec.attribute1
      ,p_attribute2
      => p_rec.attribute2
      ,p_attribute3
      => p_rec.attribute3
      ,p_attribute4
      => p_rec.attribute4
      ,p_attribute5
      => p_rec.attribute5
      ,p_attribute6
      => p_rec.attribute6
      ,p_attribute7
      => p_rec.attribute7
      ,p_attribute8
      => p_rec.attribute8
      ,p_attribute9
      => p_rec.attribute9
      ,p_attribute10
      => p_rec.attribute10
      ,p_attribute11
      => p_rec.attribute11
      ,p_attribute12
      => p_rec.attribute12
      ,p_attribute13
      => p_rec.attribute13
      ,p_attribute14
      => p_rec.attribute14
      ,p_attribute15
      => p_rec.attribute15
      ,p_attribute16
      => p_rec.attribute16
      ,p_attribute17
      => p_rec.attribute17
      ,p_attribute18
      => p_rec.attribute18
      ,p_attribute19
      => p_rec.attribute19
      ,p_attribute20
      => p_rec.attribute20
      ,p_attribute21
      => p_rec.attribute21
      ,p_attribute22
      => p_rec.attribute22
      ,p_attribute23
      => p_rec.attribute23
      ,p_attribute24
      => p_rec.attribute24
      ,p_attribute25
      => p_rec.attribute25
      ,p_attribute26
      => p_rec.attribute26
      ,p_attribute27
      => p_rec.attribute27
      ,p_attribute28
      => p_rec.attribute28
      ,p_attribute29
      => p_rec.attribute29
      ,p_attribute30
      => p_rec.attribute30
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_agency_id
      => p_rec.agency_id
      ,p_attempt_id
      => p_rec.attempt_id
      );

Line: 426

End post_insert;

Line: 443

  irc_inp_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 455

  irc_inp_ins.pre_insert(p_rec);

Line: 459

  irc_inp_ins.insert_dml(p_rec);

Line: 463

  irc_inp_ins.post_insert
     (p_effective_date
     ,p_rec
     );