APPS.IRC_ILP_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_ilp_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 89

  insert into irc_location_preferences
      (location_pref_id
      ,object_id
      ,object_type
      ,rec_area_id
      ,business_group_id
      ,country_code
      ,location_id
      ,attribute_category
      ,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
      )
  Values
    (p_rec.location_pref_id
    ,p_rec.object_id
    ,p_rec.object_type
    ,p_rec.rec_area_id
    ,p_rec.business_group_id
    ,p_rec.country_code
    ,p_rec.location_id
    ,p_rec.attribute_category
    ,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
    );

Line: 194

End insert_dml;

Line: 233

Procedure pre_insert
  (p_rec  in out nocopy irc_ilp_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select irc_location_preferences_s.nextval from sys.dual;

Line: 240

    Select null
      from irc_location_preferences
     where location_pref_id =
             irc_ilp_ins.g_location_pref_id_i;

Line: 245

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

Line: 286

End pre_insert;

Line: 320

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

Line: 331

    irc_ilp_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_location_pref_id
      => p_rec.location_pref_id
      ,p_object_id
      => p_rec.object_id
      ,p_object_type
      => p_rec.object_type
      ,p_rec_area_id
      => p_rec.rec_area_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_country_code
      => p_rec.country_code
      ,p_location_id
      => p_rec.location_id
      ,p_attribute_category
      => p_rec.attribute_category
      ,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
      );

Line: 424

End post_insert;

Line: 441

  irc_ilp_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 451

  irc_ilp_ins.pre_insert(p_rec);

Line: 455

  irc_ilp_ins.insert_dml(p_rec);

Line: 459

  irc_ilp_ins.post_insert
     (p_effective_date
     ,p_rec
     );