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.

[Home] [Help]

APPS.HXC_ULQ_UPD SQL Statements

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

Line: 55


Procedure update_dml
  (p_rec in out nocopy hxc_ulq_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) ;

Line: 64


  	l_proc := g_package||'update_dml';

Line: 75


  update hxc_layout_comp_qualifiers
    set
     layout_comp_qualifier_id        = p_rec.layout_comp_qualifier_id
    ,qualifier_name                  = p_rec.qualifier_name
    ,qualifier_attribute_category    = p_rec.qualifier_attribute_category
    ,qualifier_attribute1            = p_rec.qualifier_attribute1
    ,qualifier_attribute2            = p_rec.qualifier_attribute2
    ,qualifier_attribute3            = p_rec.qualifier_attribute3
    ,qualifier_attribute4            = p_rec.qualifier_attribute4
    ,qualifier_attribute5            = p_rec.qualifier_attribute5
    ,qualifier_attribute6            = p_rec.qualifier_attribute6
    ,qualifier_attribute7            = p_rec.qualifier_attribute7
    ,qualifier_attribute8            = p_rec.qualifier_attribute8
    ,qualifier_attribute9            = p_rec.qualifier_attribute9
    ,qualifier_attribute10           = p_rec.qualifier_attribute10
    ,qualifier_attribute11           = p_rec.qualifier_attribute11
    ,qualifier_attribute12           = p_rec.qualifier_attribute12
    ,qualifier_attribute13           = p_rec.qualifier_attribute13
    ,qualifier_attribute14           = p_rec.qualifier_attribute14
    ,qualifier_attribute15           = p_rec.qualifier_attribute15
    ,qualifier_attribute16           = p_rec.qualifier_attribute16
    ,qualifier_attribute17           = p_rec.qualifier_attribute17
    ,qualifier_attribute18           = p_rec.qualifier_attribute18
    ,qualifier_attribute19           = p_rec.qualifier_attribute19
    ,qualifier_attribute20           = p_rec.qualifier_attribute20
    ,qualifier_attribute21           = p_rec.qualifier_attribute21
    ,qualifier_attribute22           = p_rec.qualifier_attribute22
    ,qualifier_attribute23           = p_rec.qualifier_attribute23
    ,qualifier_attribute24           = p_rec.qualifier_attribute24
    ,qualifier_attribute25           = p_rec.qualifier_attribute25
    ,qualifier_attribute26           = p_rec.qualifier_attribute26
    ,qualifier_attribute27           = p_rec.qualifier_attribute27
    ,qualifier_attribute28           = p_rec.qualifier_attribute28
    ,qualifier_attribute29           = p_rec.qualifier_attribute29
    ,qualifier_attribute30           = p_rec.qualifier_attribute30
    ,object_version_number           = p_rec.object_version_number
        ,last_updated_by		     = fnd_global.user_id
    ,last_update_date		     = sysdate
    ,last_update_login	             = fnd_global.login_id

    where layout_comp_qualifier_id = p_rec.layout_comp_qualifier_id;

Line: 142


End update_dml;

Line: 176


Procedure pre_update
  (p_rec in hxc_ulq_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) ;

Line: 185


  	l_proc := g_package||'pre_update';

Line: 189


End pre_update;

Line: 223


Procedure post_update
  (p_rec                          in hxc_ulq_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) ;

Line: 232


  	l_proc := g_package||'post_update';

Line: 237


    hxc_ulq_rku.after_update
      (p_layout_comp_qualifier_id
      => p_rec.layout_comp_qualifier_id
      ,p_qualifier_name
      => p_rec.qualifier_name
      ,p_qualifier_attribute_category
      => p_rec.qualifier_attribute_category
      ,p_qualifier_attribute1
      => p_rec.qualifier_attribute1
      ,p_qualifier_attribute2
      => p_rec.qualifier_attribute2
      ,p_qualifier_attribute3
      => p_rec.qualifier_attribute3
      ,p_qualifier_attribute4
      => p_rec.qualifier_attribute4
      ,p_qualifier_attribute5
      => p_rec.qualifier_attribute5
      ,p_qualifier_attribute6
      => p_rec.qualifier_attribute6
      ,p_qualifier_attribute7
      => p_rec.qualifier_attribute7
      ,p_qualifier_attribute8
      => p_rec.qualifier_attribute8
      ,p_qualifier_attribute9
      => p_rec.qualifier_attribute9
      ,p_qualifier_attribute10
      => p_rec.qualifier_attribute10
      ,p_qualifier_attribute11
      => p_rec.qualifier_attribute11
      ,p_qualifier_attribute12
      => p_rec.qualifier_attribute12
      ,p_qualifier_attribute13
      => p_rec.qualifier_attribute13
      ,p_qualifier_attribute14
      => p_rec.qualifier_attribute14
      ,p_qualifier_attribute15
      => p_rec.qualifier_attribute15
      ,p_qualifier_attribute16
      => p_rec.qualifier_attribute16
      ,p_qualifier_attribute17
      => p_rec.qualifier_attribute17
      ,p_qualifier_attribute18
      => p_rec.qualifier_attribute18
      ,p_qualifier_attribute19
      => p_rec.qualifier_attribute19
      ,p_qualifier_attribute20
      => p_rec.qualifier_attribute20
      ,p_qualifier_attribute21
      => p_rec.qualifier_attribute21
      ,p_qualifier_attribute22
      => p_rec.qualifier_attribute22
      ,p_qualifier_attribute23
      => p_rec.qualifier_attribute23
      ,p_qualifier_attribute24
      => p_rec.qualifier_attribute24
      ,p_qualifier_attribute25
      => p_rec.qualifier_attribute25
      ,p_qualifier_attribute26
      => p_rec.qualifier_attribute26
      ,p_qualifier_attribute27
      => p_rec.qualifier_attribute27
      ,p_qualifier_attribute28
      => p_rec.qualifier_attribute28
      ,p_qualifier_attribute29
      => p_rec.qualifier_attribute29
      ,p_qualifier_attribute30
      => p_rec.qualifier_attribute30
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_qualifier_name_o
      => hxc_ulq_shd.g_old_rec.qualifier_name
      ,p_qualifier_attribute_catego_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute_category
      ,p_qualifier_attribute1_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute1
      ,p_qualifier_attribute2_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute2
      ,p_qualifier_attribute3_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute3
      ,p_qualifier_attribute4_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute4
      ,p_qualifier_attribute5_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute5
      ,p_qualifier_attribute6_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute6
      ,p_qualifier_attribute7_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute7
      ,p_qualifier_attribute8_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute8
      ,p_qualifier_attribute9_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute9
      ,p_qualifier_attribute10_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute10
      ,p_qualifier_attribute11_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute11
      ,p_qualifier_attribute12_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute12
      ,p_qualifier_attribute13_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute13
      ,p_qualifier_attribute14_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute14
      ,p_qualifier_attribute15_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute15
      ,p_qualifier_attribute16_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute16
      ,p_qualifier_attribute17_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute17
      ,p_qualifier_attribute18_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute18
      ,p_qualifier_attribute19_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute19
      ,p_qualifier_attribute20_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute20
      ,p_qualifier_attribute21_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute21
      ,p_qualifier_attribute22_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute22
      ,p_qualifier_attribute23_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute23
      ,p_qualifier_attribute24_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute24
      ,p_qualifier_attribute25_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute25
      ,p_qualifier_attribute26_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute26
      ,p_qualifier_attribute27_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute27
      ,p_qualifier_attribute28_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute28
      ,p_qualifier_attribute29_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute29
      ,p_qualifier_attribute30_o
      => hxc_ulq_shd.g_old_rec.qualifier_attribute30
      ,p_object_version_number_o
      => hxc_ulq_shd.g_old_rec.object_version_number
      );

Line: 387


End post_update;

Line: 604


  hxc_ulq_bus.update_validate
     (p_rec
     );

Line: 610


  hxc_ulq_upd.pre_update(p_rec);

Line: 614


  hxc_ulq_upd.update_dml(p_rec);

Line: 618


  hxc_ulq_upd.post_update
     (p_rec
     );