eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

Line: 89


  insert into irc_offers
      (offer_id
      ,offer_version
      ,latest_offer
      ,offer_status
      ,discretionary_job_title
      ,offer_extended_method
      ,respondent_id
      ,expiry_date
      ,proposed_start_date
      ,offer_letter_tracking_code
      ,offer_postal_service
      ,offer_shipping_date
      ,vacancy_id
      ,applicant_assignment_id
      ,offer_assignment_id
      ,address_id
      ,template_id
      ,offer_letter
      ,offer_letter_file_type
      ,offer_letter_file_name
      ,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.offer_id
    ,p_rec.offer_version
    ,p_rec.latest_offer
    ,p_rec.offer_status
    ,p_rec.discretionary_job_title
    ,p_rec.offer_extended_method
    ,p_rec.respondent_id
    ,p_rec.expiry_date
    ,p_rec.proposed_start_date
    ,p_rec.offer_letter_tracking_code
    ,p_rec.offer_postal_service
    ,p_rec.offer_shipping_date
    ,p_rec.vacancy_id
    ,p_rec.applicant_assignment_id
    ,p_rec.offer_assignment_id
    ,p_rec.address_id
    ,p_rec.template_id
    ,empty_blob()
    ,p_rec.offer_letter_file_type
    ,p_rec.offer_letter_file_name
    ,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: 220


end insert_dml;

Line: 259


procedure pre_insert
  (p_rec  in out nocopy irc_iof_shd.g_rec_type
  ) is
--
  cursor c_sel1 is select irc_offers_s.nextval from sys.dual;

Line: 266


    select null
      from irc_offers
     where offer_id =
             irc_iof_ins.g_offer_id_i;

Line: 271


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

Line: 312


end pre_insert;

Line: 346


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

Line: 357


    irc_iof_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_offer_id
      => p_rec.offer_id
      ,p_offer_version
      => p_rec.offer_version
      ,p_latest_offer
      => p_rec.latest_offer
      ,p_offer_status
      => p_rec.offer_status
      ,p_discretionary_job_title
      => p_rec.discretionary_job_title
      ,p_offer_extended_method
      => p_rec.offer_extended_method
      ,p_respondent_id
      => p_rec.respondent_id
      ,p_expiry_date
      => p_rec.expiry_date
      ,p_proposed_start_date
      => p_rec.proposed_start_date
      ,p_offer_letter_tracking_code
      => p_rec.offer_letter_tracking_code
      ,p_offer_postal_service
      => p_rec.offer_postal_service
      ,p_offer_shipping_date
      => p_rec.offer_shipping_date
      ,p_vacancy_id
      => p_rec.vacancy_id
      ,p_applicant_assignment_id
      => p_rec.applicant_assignment_id
      ,p_offer_assignment_id
      => p_rec.offer_assignment_id
      ,p_address_id
      => p_rec.address_id
      ,p_template_id
      => p_rec.template_id
      ,p_offer_letter_file_type
      => p_rec.offer_letter_file_type
      ,p_offer_letter_file_name
      => p_rec.offer_letter_file_name
      ,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: 474


end post_insert;

Line: 491


  irc_iof_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 501


  irc_iof_ins.pre_insert(p_rec);

Line: 505


  irc_iof_ins.insert_dml(p_rec);

Line: 509


  irc_iof_ins.post_insert
     (p_effective_date
     ,p_rec
     );