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_RSE_UPD SQL Statements

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

Line: 54


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

Line: 70


  update irc_all_recruiting_sites
    set
     recruiting_site_id              = p_rec.recruiting_site_id
    ,date_from                       = p_rec.date_from
    ,date_to                         = p_rec.date_to
    ,posting_username                = p_rec.posting_username
    ,posting_password                = p_rec.posting_password
    ,internal                        = p_rec.internal
    ,external                        = p_rec.external
    ,third_party                     = p_rec.third_party
    ,posting_cost                    = p_rec.posting_cost
    ,posting_cost_period             = p_rec.posting_cost_period
    ,posting_cost_currency           = p_rec.posting_cost_currency
    ,stylesheet             = p_rec.stylesheet
    ,attribute_category              = p_rec.attribute_category
    ,attribute1                      = p_rec.attribute1
    ,attribute2                      = p_rec.attribute2
    ,attribute3                      = p_rec.attribute3
    ,attribute4                      = p_rec.attribute4
    ,attribute5                      = p_rec.attribute5
    ,attribute6                      = p_rec.attribute6
    ,attribute7                      = p_rec.attribute7
    ,attribute8                      = p_rec.attribute8
    ,attribute9                      = p_rec.attribute9
    ,attribute10                     = p_rec.attribute10
    ,attribute11                     = p_rec.attribute11
    ,attribute12                     = p_rec.attribute12
    ,attribute13                     = p_rec.attribute13
    ,attribute14                     = p_rec.attribute14
    ,attribute15                     = p_rec.attribute15
    ,attribute16                     = p_rec.attribute16
    ,attribute17                     = p_rec.attribute17
    ,attribute18                     = p_rec.attribute18
    ,attribute19                     = p_rec.attribute19
    ,attribute20                     = p_rec.attribute20
    ,attribute21                     = p_rec.attribute21
    ,attribute22                     = p_rec.attribute22
    ,attribute23                     = p_rec.attribute23
    ,attribute24                     = p_rec.attribute24
    ,attribute25                     = p_rec.attribute25
    ,attribute26                     = p_rec.attribute26
    ,attribute27                     = p_rec.attribute27
    ,attribute28                     = p_rec.attribute28
    ,attribute29                     = p_rec.attribute29
    ,attribute30                     = p_rec.attribute30
    ,object_version_number           = p_rec.object_version_number
    ,internal_name                   = p_rec.internal_name
    where recruiting_site_id = p_rec.recruiting_site_id;

Line: 145


End update_dml;

Line: 179


Procedure pre_update
  (p_rec in irc_rse_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 189


End pre_update;

Line: 223


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

Line: 234


    irc_rse_rku.after_update
      (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_date_from_o
      => irc_rse_shd.g_old_rec.date_from
      ,p_date_to_o
      => irc_rse_shd.g_old_rec.date_to
      ,p_posting_username_o
      => irc_rse_shd.g_old_rec.posting_username
      ,p_posting_password_o
      => irc_rse_shd.g_old_rec.posting_password
      ,p_internal_o
      => irc_rse_shd.g_old_rec.internal
      ,p_external_o
      => irc_rse_shd.g_old_rec.external
      ,p_third_party_o
      => irc_rse_shd.g_old_rec.third_party
      ,p_posting_cost_o
      => irc_rse_shd.g_old_rec.posting_cost
      ,p_posting_cost_period_o
      => irc_rse_shd.g_old_rec.posting_cost_period
      ,p_posting_cost_currency_o
      => irc_rse_shd.g_old_rec.posting_cost_currency
      ,p_stylesheet_o
      => irc_rse_shd.g_old_rec.stylesheet
      ,p_attribute_category_o
      => irc_rse_shd.g_old_rec.attribute_category
      ,p_attribute1_o
      => irc_rse_shd.g_old_rec.attribute1
      ,p_attribute2_o
      => irc_rse_shd.g_old_rec.attribute2
      ,p_attribute3_o
      => irc_rse_shd.g_old_rec.attribute3
      ,p_attribute4_o
      => irc_rse_shd.g_old_rec.attribute4
      ,p_attribute5_o
      => irc_rse_shd.g_old_rec.attribute5
      ,p_attribute6_o
      => irc_rse_shd.g_old_rec.attribute6
      ,p_attribute7_o
      => irc_rse_shd.g_old_rec.attribute7
      ,p_attribute8_o
      => irc_rse_shd.g_old_rec.attribute8
      ,p_attribute9_o
      => irc_rse_shd.g_old_rec.attribute9
      ,p_attribute10_o
      => irc_rse_shd.g_old_rec.attribute10
      ,p_attribute11_o
      => irc_rse_shd.g_old_rec.attribute11
      ,p_attribute12_o
      => irc_rse_shd.g_old_rec.attribute12
      ,p_attribute13_o
      => irc_rse_shd.g_old_rec.attribute13
      ,p_attribute14_o
      => irc_rse_shd.g_old_rec.attribute14
      ,p_attribute15_o
      => irc_rse_shd.g_old_rec.attribute15
      ,p_attribute16_o
      => irc_rse_shd.g_old_rec.attribute16
      ,p_attribute17_o
      => irc_rse_shd.g_old_rec.attribute17
      ,p_attribute18_o
      => irc_rse_shd.g_old_rec.attribute18
      ,p_attribute19_o
      => irc_rse_shd.g_old_rec.attribute19
      ,p_attribute20_o
      => irc_rse_shd.g_old_rec.attribute20
      ,p_attribute21_o
      => irc_rse_shd.g_old_rec.attribute21
      ,p_attribute22_o
      => irc_rse_shd.g_old_rec.attribute22
      ,p_attribute23_o
      => irc_rse_shd.g_old_rec.attribute23
      ,p_attribute24_o
      => irc_rse_shd.g_old_rec.attribute24
      ,p_attribute25_o
      => irc_rse_shd.g_old_rec.attribute25
      ,p_attribute26_o
      => irc_rse_shd.g_old_rec.attribute26
      ,p_attribute27_o
      => irc_rse_shd.g_old_rec.attribute27
      ,p_attribute28_o
      => irc_rse_shd.g_old_rec.attribute28
      ,p_attribute29_o
      => irc_rse_shd.g_old_rec.attribute29
      ,p_attribute30_o
      => irc_rse_shd.g_old_rec.attribute30
      ,p_object_version_number_o
      => irc_rse_shd.g_old_rec.object_version_number
      ,p_internal_name_o
      => irc_rse_shd.g_old_rec.internal_name
      );

Line: 427


End post_update;

Line: 688


  irc_rse_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 698


  irc_rse_upd.pre_update(p_rec);

Line: 702


  irc_rse_upd.update_dml(p_rec);

Line: 706


  irc_rse_upd.post_update
     (p_effective_date
     ,p_rec
     );