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

Line: 89

  insert into irc_all_recruiting_sites
      (recruiting_site_id
      ,date_from
      ,date_to
      ,posting_username
      ,posting_password
      ,internal
      ,external
      ,third_party
      ,posting_cost
      ,posting_cost_period
      ,posting_cost_currency
      ,stylesheet
      ,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
      ,internal_name
      ,posting_impl_class
      )
  Values
    (p_rec.recruiting_site_id
    ,p_rec.date_from
    ,p_rec.date_to
    ,p_rec.posting_username
    ,p_rec.posting_password
    ,p_rec.internal
    ,p_rec.external
    ,p_rec.third_party
    ,p_rec.posting_cost
    ,p_rec.posting_cost_period
    ,p_rec.posting_cost_currency
    ,p_rec.stylesheet
    ,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
    ,p_rec.internal_name
    ,p_rec.posting_impl_class
    );

Line: 212

End insert_dml;

Line: 251

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

Line: 258

    Select null
      from irc_all_recruiting_sites
     where recruiting_site_id =
             irc_rse_ins.g_recruiting_site_id_i;

Line: 263

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

Line: 304

End pre_insert;

Line: 338

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

Line: 349

    irc_rse_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_recruiting_site_id
      => p_rec.recruiting_site_id
      ,p_date_from
      => p_rec.date_from
      ,p_date_to
      => p_rec.date_to
      ,p_posting_username
      => p_rec.posting_username
      ,p_posting_password
      => p_rec.posting_password
      ,p_internal
      => p_rec.internal
      ,p_external
      => p_rec.external
      ,p_third_party
      => p_rec.third_party
      ,p_posting_cost
      => p_rec.posting_cost
      ,p_posting_cost_period
      => p_rec.posting_cost_period
      ,p_posting_cost_currency
      => p_rec.posting_cost_currency
      ,p_stylesheet
      => p_rec.stylesheet
      ,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
      ,p_internal_name
      => p_rec.internal_name
      ,p_posting_impl_class
      => p_rec.posting_impl_class
      );

Line: 456

End post_insert;

Line: 473

  irc_rse_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 483

  irc_rse_ins.pre_insert(p_rec);

Line: 487

  irc_rse_ins.insert_dml(p_rec);

Line: 491

  irc_rse_ins.post_insert
     (p_effective_date
     ,p_rec
     );