APPS.BEN_PDT_UPD SQL Statements

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

Line: 54

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

Line: 70

  update ben_pymt_check_det
    set
     pymt_check_det_id               = p_rec.pymt_check_det_id
    ,person_id                       = p_rec.person_id
    ,business_group_id               = p_rec.business_group_id
    ,check_num                       = p_rec.check_num
    ,pymt_dt                         = p_rec.pymt_dt
    ,pymt_amt                        = p_rec.pymt_amt
    ,pdt_attribute_category          = p_rec.pdt_attribute_category
    ,pdt_attribute1                  = p_rec.pdt_attribute1
    ,pdt_attribute2                  = p_rec.pdt_attribute2
    ,pdt_attribute3                  = p_rec.pdt_attribute3
    ,pdt_attribute4                  = p_rec.pdt_attribute4
    ,pdt_attribute5                  = p_rec.pdt_attribute5
    ,pdt_attribute6                  = p_rec.pdt_attribute6
    ,pdt_attribute7                  = p_rec.pdt_attribute7
    ,pdt_attribute8                  = p_rec.pdt_attribute8
    ,pdt_attribute9                  = p_rec.pdt_attribute9
    ,pdt_attribute10                 = p_rec.pdt_attribute10
    ,pdt_attribute11                 = p_rec.pdt_attribute11
    ,pdt_attribute12                 = p_rec.pdt_attribute12
    ,pdt_attribute13                 = p_rec.pdt_attribute13
    ,pdt_attribute14                 = p_rec.pdt_attribute14
    ,pdt_attribute15                 = p_rec.pdt_attribute15
    ,pdt_attribute16                 = p_rec.pdt_attribute16
    ,pdt_attribute17                 = p_rec.pdt_attribute17
    ,pdt_attribute18                 = p_rec.pdt_attribute18
    ,pdt_attribute19                 = p_rec.pdt_attribute19
    ,pdt_attribute20                 = p_rec.pdt_attribute20
    ,pdt_attribute21                 = p_rec.pdt_attribute21
    ,pdt_attribute22                 = p_rec.pdt_attribute22
    ,pdt_attribute23                 = p_rec.pdt_attribute23
    ,pdt_attribute24                 = p_rec.pdt_attribute24
    ,pdt_attribute25                 = p_rec.pdt_attribute25
    ,pdt_attribute26                 = p_rec.pdt_attribute26
    ,pdt_attribute27                 = p_rec.pdt_attribute27
    ,pdt_attribute28                 = p_rec.pdt_attribute28
    ,pdt_attribute29                 = p_rec.pdt_attribute29
    ,pdt_attribute30                 = p_rec.pdt_attribute30
    ,object_version_number           = p_rec.object_version_number
    where pymt_check_det_id = p_rec.pymt_check_det_id;

Line: 135

End update_dml;

Line: 169

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

Line: 179

End pre_update;

Line: 213

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

Line: 224

    ben_pdt_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_pymt_check_det_id
      => p_rec.pymt_check_det_id
      ,p_person_id
      => p_rec.person_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_check_num
      => p_rec.check_num
      ,p_pymt_dt
      => p_rec.pymt_dt
      ,p_pymt_amt
      => p_rec.pymt_amt
      ,p_pdt_attribute_category
      => p_rec.pdt_attribute_category
      ,p_pdt_attribute1
      => p_rec.pdt_attribute1
      ,p_pdt_attribute2
      => p_rec.pdt_attribute2
      ,p_pdt_attribute3
      => p_rec.pdt_attribute3
      ,p_pdt_attribute4
      => p_rec.pdt_attribute4
      ,p_pdt_attribute5
      => p_rec.pdt_attribute5
      ,p_pdt_attribute6
      => p_rec.pdt_attribute6
      ,p_pdt_attribute7
      => p_rec.pdt_attribute7
      ,p_pdt_attribute8
      => p_rec.pdt_attribute8
      ,p_pdt_attribute9
      => p_rec.pdt_attribute9
      ,p_pdt_attribute10
      => p_rec.pdt_attribute10
      ,p_pdt_attribute11
      => p_rec.pdt_attribute11
      ,p_pdt_attribute12
      => p_rec.pdt_attribute12
      ,p_pdt_attribute13
      => p_rec.pdt_attribute13
      ,p_pdt_attribute14
      => p_rec.pdt_attribute14
      ,p_pdt_attribute15
      => p_rec.pdt_attribute15
      ,p_pdt_attribute16
      => p_rec.pdt_attribute16
      ,p_pdt_attribute17
      => p_rec.pdt_attribute17
      ,p_pdt_attribute18
      => p_rec.pdt_attribute18
      ,p_pdt_attribute19
      => p_rec.pdt_attribute19
      ,p_pdt_attribute20
      => p_rec.pdt_attribute20
      ,p_pdt_attribute21
      => p_rec.pdt_attribute21
      ,p_pdt_attribute22
      => p_rec.pdt_attribute22
      ,p_pdt_attribute23
      => p_rec.pdt_attribute23
      ,p_pdt_attribute24
      => p_rec.pdt_attribute24
      ,p_pdt_attribute25
      => p_rec.pdt_attribute25
      ,p_pdt_attribute26
      => p_rec.pdt_attribute26
      ,p_pdt_attribute27
      => p_rec.pdt_attribute27
      ,p_pdt_attribute28
      => p_rec.pdt_attribute28
      ,p_pdt_attribute29
      => p_rec.pdt_attribute29
      ,p_pdt_attribute30
      => p_rec.pdt_attribute30
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_person_id_o
      => ben_pdt_shd.g_old_rec.person_id
      ,p_business_group_id_o
      => ben_pdt_shd.g_old_rec.business_group_id
      ,p_check_num_o
      => ben_pdt_shd.g_old_rec.check_num
      ,p_pymt_dt_o
      => ben_pdt_shd.g_old_rec.pymt_dt
      ,p_pymt_amt_o
      => ben_pdt_shd.g_old_rec.pymt_amt
      ,p_pdt_attribute_category_o
      => ben_pdt_shd.g_old_rec.pdt_attribute_category
      ,p_pdt_attribute1_o
      => ben_pdt_shd.g_old_rec.pdt_attribute1
      ,p_pdt_attribute2_o
      => ben_pdt_shd.g_old_rec.pdt_attribute2
      ,p_pdt_attribute3_o
      => ben_pdt_shd.g_old_rec.pdt_attribute3
      ,p_pdt_attribute4_o
      => ben_pdt_shd.g_old_rec.pdt_attribute4
      ,p_pdt_attribute5_o
      => ben_pdt_shd.g_old_rec.pdt_attribute5
      ,p_pdt_attribute6_o
      => ben_pdt_shd.g_old_rec.pdt_attribute6
      ,p_pdt_attribute7_o
      => ben_pdt_shd.g_old_rec.pdt_attribute7
      ,p_pdt_attribute8_o
      => ben_pdt_shd.g_old_rec.pdt_attribute8
      ,p_pdt_attribute9_o
      => ben_pdt_shd.g_old_rec.pdt_attribute9
      ,p_pdt_attribute10_o
      => ben_pdt_shd.g_old_rec.pdt_attribute10
      ,p_pdt_attribute11_o
      => ben_pdt_shd.g_old_rec.pdt_attribute11
      ,p_pdt_attribute12_o
      => ben_pdt_shd.g_old_rec.pdt_attribute12
      ,p_pdt_attribute13_o
      => ben_pdt_shd.g_old_rec.pdt_attribute13
      ,p_pdt_attribute14_o
      => ben_pdt_shd.g_old_rec.pdt_attribute14
      ,p_pdt_attribute15_o
      => ben_pdt_shd.g_old_rec.pdt_attribute15
      ,p_pdt_attribute16_o
      => ben_pdt_shd.g_old_rec.pdt_attribute16
      ,p_pdt_attribute17_o
      => ben_pdt_shd.g_old_rec.pdt_attribute17
      ,p_pdt_attribute18_o
      => ben_pdt_shd.g_old_rec.pdt_attribute18
      ,p_pdt_attribute19_o
      => ben_pdt_shd.g_old_rec.pdt_attribute19
      ,p_pdt_attribute20_o
      => ben_pdt_shd.g_old_rec.pdt_attribute20
      ,p_pdt_attribute21_o
      => ben_pdt_shd.g_old_rec.pdt_attribute21
      ,p_pdt_attribute22_o
      => ben_pdt_shd.g_old_rec.pdt_attribute22
      ,p_pdt_attribute23_o
      => ben_pdt_shd.g_old_rec.pdt_attribute23
      ,p_pdt_attribute24_o
      => ben_pdt_shd.g_old_rec.pdt_attribute24
      ,p_pdt_attribute25_o
      => ben_pdt_shd.g_old_rec.pdt_attribute25
      ,p_pdt_attribute26_o
      => ben_pdt_shd.g_old_rec.pdt_attribute26
      ,p_pdt_attribute27_o
      => ben_pdt_shd.g_old_rec.pdt_attribute27
      ,p_pdt_attribute28_o
      => ben_pdt_shd.g_old_rec.pdt_attribute28
      ,p_pdt_attribute29_o
      => ben_pdt_shd.g_old_rec.pdt_attribute29
      ,p_pdt_attribute30_o
      => ben_pdt_shd.g_old_rec.pdt_attribute30
      ,p_object_version_number_o
      => ben_pdt_shd.g_old_rec.object_version_number
      );

Line: 389

End post_update;

Line: 619

  ben_pdt_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 629

  ben_pdt_upd.pre_update(p_rec);

Line: 633

  ben_pdt_upd.update_dml(p_rec);

Line: 637

  ben_pdt_upd.post_update
     (p_effective_date
     ,p_rec
     );