APPS.PER_BPD_INS SQL Statements

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

Line: 53

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

Line: 64

  insert into per_bf_payment_details
  (      payment_detail_id,
      processed_assignment_id,
      personal_payment_method_id,
      business_group_id,
      check_number,
      payment_date,
      amount,
      check_type,
      object_version_number,
      bpd_attribute_category,
      bpd_attribute1,
      bpd_attribute2,
      bpd_attribute3,
      bpd_attribute4,
      bpd_attribute5,
      bpd_attribute6,
      bpd_attribute7,
      bpd_attribute8,
      bpd_attribute9,
      bpd_attribute10,
      bpd_attribute11,
      bpd_attribute12,
      bpd_attribute13,
      bpd_attribute14,
      bpd_attribute15,
      bpd_attribute16,
      bpd_attribute17,
      bpd_attribute18,
      bpd_attribute19,
      bpd_attribute20,
      bpd_attribute21,
      bpd_attribute22,
      bpd_attribute23,
      bpd_attribute24,
      bpd_attribute25,
      bpd_attribute26,
      bpd_attribute27,
      bpd_attribute28,
      bpd_attribute29,
      bpd_attribute30
  )
  Values
  (   p_rec.payment_detail_id,
      p_rec.processed_assignment_id,
      p_rec.personal_payment_method_id,
      p_rec.business_group_id,
      p_rec.check_number,
      p_rec.payment_date,
      p_rec.amount,
      p_rec.check_type,
      p_rec.object_version_number,
      p_rec.bpd_attribute_category,
      p_rec.bpd_attribute1,
      p_rec.bpd_attribute2,
      p_rec.bpd_attribute3,
      p_rec.bpd_attribute4,
      p_rec.bpd_attribute5,
      p_rec.bpd_attribute6,
      p_rec.bpd_attribute7,
      p_rec.bpd_attribute8,
      p_rec.bpd_attribute9,
      p_rec.bpd_attribute10,
      p_rec.bpd_attribute11,
      p_rec.bpd_attribute12,
      p_rec.bpd_attribute13,
      p_rec.bpd_attribute14,
      p_rec.bpd_attribute15,
      p_rec.bpd_attribute16,
      p_rec.bpd_attribute17,
      p_rec.bpd_attribute18,
      p_rec.bpd_attribute19,
      p_rec.bpd_attribute20,
      p_rec.bpd_attribute21,
      p_rec.bpd_attribute22,
      p_rec.bpd_attribute23,
      p_rec.bpd_attribute24,
      p_rec.bpd_attribute25,
      p_rec.bpd_attribute26,
      p_rec.bpd_attribute27,
      p_rec.bpd_attribute28,
      p_rec.bpd_attribute29,
      p_rec.bpd_attribute30
  );

Line: 166

End insert_dml;

Line: 205

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

Line: 209

Cursor C_Sel1 is select per_bf_payment_details_s.nextval from sys.dual;

Line: 219

End pre_insert;

Line: 253

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

Line: 262

    per_bpd_rki.after_insert
      (p_effective_date              => p_effective_date,
      p_payment_detail_id          => p_rec.payment_detail_id,
      p_processed_assignment_id    => p_rec.processed_assignment_id,
      p_personal_payment_method_id => p_rec.personal_payment_method_id,
      p_business_group_id          => p_rec.business_group_id,
      p_check_number               => p_rec.check_number,
      p_payment_date                 => p_rec.payment_date,
      p_amount                     => p_rec.amount,
      p_check_type                 => p_rec.check_type,
      p_object_version_number      => p_rec.object_version_number,
      p_bpd_attribute_category     => p_rec.bpd_attribute_category,
      p_bpd_attribute1             => p_rec.bpd_attribute1,
      p_bpd_attribute2             => p_rec.bpd_attribute2,
      p_bpd_attribute3             => p_rec.bpd_attribute3,
      p_bpd_attribute4             => p_rec.bpd_attribute4,
      p_bpd_attribute5             => p_rec.bpd_attribute5,
      p_bpd_attribute6             => p_rec.bpd_attribute6,
      p_bpd_attribute7             => p_rec.bpd_attribute7,
      p_bpd_attribute8             => p_rec.bpd_attribute8,
      p_bpd_attribute9             => p_rec.bpd_attribute9,
      p_bpd_attribute10            => p_rec.bpd_attribute10,
      p_bpd_attribute11            => p_rec.bpd_attribute11,
      p_bpd_attribute12            => p_rec.bpd_attribute12,
      p_bpd_attribute13            => p_rec.bpd_attribute13,
      p_bpd_attribute14            => p_rec.bpd_attribute14,
      p_bpd_attribute15            => p_rec.bpd_attribute15,
      p_bpd_attribute16            => p_rec.bpd_attribute16,
      p_bpd_attribute17            => p_rec.bpd_attribute17,
      p_bpd_attribute18            => p_rec.bpd_attribute18,
      p_bpd_attribute19            => p_rec.bpd_attribute19,
      p_bpd_attribute20            => p_rec.bpd_attribute20,
      p_bpd_attribute21            => p_rec.bpd_attribute21,
      p_bpd_attribute22            => p_rec.bpd_attribute22,
      p_bpd_attribute23            => p_rec.bpd_attribute23,
      p_bpd_attribute24            => p_rec.bpd_attribute24,
      p_bpd_attribute25            => p_rec.bpd_attribute25,
      p_bpd_attribute26            => p_rec.bpd_attribute26,
      p_bpd_attribute27            => p_rec.bpd_attribute27,
      p_bpd_attribute28            => p_rec.bpd_attribute28,
      p_bpd_attribute29            => p_rec.bpd_attribute29,
      p_bpd_attribute30            => p_rec.bpd_attribute30
      );

Line: 317

End post_insert;

Line: 335

  per_bpd_bus.insert_validate(p_effective_date,
                             p_rec
                             );

Line: 341

  pre_insert(p_rec);

Line: 345

  insert_dml(p_rec);

Line: 349

  post_insert(p_effective_date,
                             p_rec);