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

Line: 210

End insert_dml;

Line: 249

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: 256

    Select null
      from irc_all_recruiting_sites
     where recruiting_site_id =
             irc_rse_ins.g_recruiting_site_id_i;

Line: 261

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

Line: 302

End pre_insert;

Line: 336

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: 347

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

Line: 452

End post_insert;

Line: 469

  irc_rse_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 479

  irc_rse_ins.pre_insert(p_rec);

Line: 483

  irc_rse_ins.insert_dml(p_rec);

Line: 487

  irc_rse_ins.post_insert
     (p_effective_date
     ,p_rec
     );