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.PAY_PMA_UPD SQL Statements

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

Line: 54


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

Line: 69


  update pay_ca_pmed_accounts
  set
  organization_id                   = p_rec.organization_id,
  source_id                         = p_rec.source_id,
  account_number                    = p_rec.account_number,
  enabled                           = p_rec.enabled,
  description                       = p_rec.description,
  business_group_id                 = p_rec.business_group_id,
  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
  where source_id = p_rec.source_id;

Line: 134


End update_dml;

Line: 168


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

Line: 176


End pre_update;

Line: 210


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

Line: 222


    pay_pma_rku.after_update
      (
  p_organization_id               =>p_rec.organization_id
 ,p_source_id                     =>p_rec.source_id
 ,p_account_number                =>p_rec.account_number
 ,p_enabled                       =>p_rec.enabled
 ,p_description                   =>p_rec.description
 ,p_business_group_id             =>p_rec.business_group_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
 ,p_organization_id_o             =>pay_pma_shd.g_old_rec.organization_id
 ,p_account_number_o              =>pay_pma_shd.g_old_rec.account_number
 ,p_enabled_o                     =>pay_pma_shd.g_old_rec.enabled
 ,p_description_o                 =>pay_pma_shd.g_old_rec.description
 ,p_business_group_id_o           =>pay_pma_shd.g_old_rec.business_group_id
 ,p_attribute_category_o          =>pay_pma_shd.g_old_rec.attribute_category
 ,p_attribute1_o                  =>pay_pma_shd.g_old_rec.attribute1
 ,p_attribute2_o                  =>pay_pma_shd.g_old_rec.attribute2
 ,p_attribute3_o                  =>pay_pma_shd.g_old_rec.attribute3
 ,p_attribute4_o                  =>pay_pma_shd.g_old_rec.attribute4
 ,p_attribute5_o                  =>pay_pma_shd.g_old_rec.attribute5
 ,p_attribute6_o                  =>pay_pma_shd.g_old_rec.attribute6
 ,p_attribute7_o                  =>pay_pma_shd.g_old_rec.attribute7
 ,p_attribute8_o                  =>pay_pma_shd.g_old_rec.attribute8
 ,p_attribute9_o                  =>pay_pma_shd.g_old_rec.attribute9
 ,p_attribute10_o                 =>pay_pma_shd.g_old_rec.attribute10
 ,p_attribute11_o                 =>pay_pma_shd.g_old_rec.attribute11
 ,p_attribute12_o                 =>pay_pma_shd.g_old_rec.attribute12
 ,p_attribute13_o                 =>pay_pma_shd.g_old_rec.attribute13
 ,p_attribute14_o                 =>pay_pma_shd.g_old_rec.attribute14
 ,p_attribute15_o                 =>pay_pma_shd.g_old_rec.attribute15
 ,p_attribute16_o                 =>pay_pma_shd.g_old_rec.attribute16
 ,p_attribute17_o                 =>pay_pma_shd.g_old_rec.attribute17
 ,p_attribute18_o                 =>pay_pma_shd.g_old_rec.attribute18
 ,p_attribute19_o                 =>pay_pma_shd.g_old_rec.attribute19
 ,p_attribute20_o                 =>pay_pma_shd.g_old_rec.attribute20
 ,p_attribute21_o                 =>pay_pma_shd.g_old_rec.attribute21
 ,p_attribute22_o                 =>pay_pma_shd.g_old_rec.attribute22
 ,p_attribute23_o                 =>pay_pma_shd.g_old_rec.attribute23
 ,p_attribute24_o                 =>pay_pma_shd.g_old_rec.attribute24
 ,p_attribute25_o                 =>pay_pma_shd.g_old_rec.attribute25
 ,p_attribute26_o                 =>pay_pma_shd.g_old_rec.attribute26
 ,p_attribute27_o                 =>pay_pma_shd.g_old_rec.attribute27
 ,p_attribute28_o                 =>pay_pma_shd.g_old_rec.attribute28
 ,p_attribute29_o                 =>pay_pma_shd.g_old_rec.attribute29
 ,p_attribute30_o                 =>pay_pma_shd.g_old_rec.attribute30
 ,p_object_version_number_o       =>pay_pma_shd.g_old_rec.object_version_number
      );

Line: 315


End post_update;

Line: 551


  pay_pma_bus.update_validate(p_rec);

Line: 555


  pre_update(p_rec);

Line: 559


  update_dml(p_rec);

Line: 563


  post_update(p_rec);