APPS.PER_BPA_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_bpa_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 67

  insert into per_bf_processed_assignments
      (processed_assignment_id,
      payroll_run_id,
      assignment_id,
      object_version_number,
      bpa_attribute_category,
      bpa_attribute1,
      bpa_attribute2,
      bpa_attribute3,
      bpa_attribute4,
      bpa_attribute5,
      bpa_attribute6,
      bpa_attribute7,
      bpa_attribute8,
      bpa_attribute9,
      bpa_attribute10,
      bpa_attribute11,
      bpa_attribute12,
      bpa_attribute13,
      bpa_attribute14,
      bpa_attribute15,
      bpa_attribute16,
      bpa_attribute17,
      bpa_attribute18,
      bpa_attribute19,
      bpa_attribute20,
      bpa_attribute21,
      bpa_attribute22,
      bpa_attribute23,
      bpa_attribute24,
      bpa_attribute25,
      bpa_attribute26,
      bpa_attribute27,
      bpa_attribute28,
      bpa_attribute29,
      bpa_attribute30
      )
  Values
    (p_rec.processed_assignment_id,
    p_rec.payroll_run_id,
    p_rec.assignment_id,
    p_rec.object_version_number,
    p_rec.bpa_attribute_category,
    p_rec.bpa_attribute1,
    p_rec.bpa_attribute2,
    p_rec.bpa_attribute3,
    p_rec.bpa_attribute4,
    p_rec.bpa_attribute5,
    p_rec.bpa_attribute6,
    p_rec.bpa_attribute7,
    p_rec.bpa_attribute8,
    p_rec.bpa_attribute9,
    p_rec.bpa_attribute10,
    p_rec.bpa_attribute11,
    p_rec.bpa_attribute12,
    p_rec.bpa_attribute13,
    p_rec.bpa_attribute14,
    p_rec.bpa_attribute15,
    p_rec.bpa_attribute16,
    p_rec.bpa_attribute17,
    p_rec.bpa_attribute18,
    p_rec.bpa_attribute19,
    p_rec.bpa_attribute20,
    p_rec.bpa_attribute21,
    p_rec.bpa_attribute22,
    p_rec.bpa_attribute23,
    p_rec.bpa_attribute24,
    p_rec.bpa_attribute25,
    p_rec.bpa_attribute26,
    p_rec.bpa_attribute27,
    p_rec.bpa_attribute28,
    p_rec.bpa_attribute29,
    p_rec.bpa_attribute30
    );

Line: 164

End insert_dml;

Line: 203

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

Line: 209

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

Line: 222

End pre_insert;

Line: 256

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

Line: 267

    per_bpa_rki.after_insert
      (p_effective_date              => p_effective_date,
      p_processed_assignment_id       => p_rec.processed_assignment_id,
      p_payroll_run_id               => p_rec.payroll_run_id,
      p_assignment_id                => p_rec.assignment_id,
      p_object_version_number        => p_rec.object_version_number,
      p_bpa_attribute_category         => p_rec.bpa_attribute_category,
      p_bpa_attribute1                 => p_rec.bpa_attribute1,
      p_bpa_attribute2                 => p_rec.bpa_attribute2,
      p_bpa_attribute3                 => p_rec.bpa_attribute3,
      p_bpa_attribute4                 => p_rec.bpa_attribute4,
      p_bpa_attribute5                 => p_rec.bpa_attribute5,
      p_bpa_attribute6                 => p_rec.bpa_attribute6,
      p_bpa_attribute7                 => p_rec.bpa_attribute7,
      p_bpa_attribute8                 => p_rec.bpa_attribute8,
      p_bpa_attribute9                 => p_rec.bpa_attribute9,
      p_bpa_attribute10                => p_rec.bpa_attribute10,
      p_bpa_attribute11                => p_rec.bpa_attribute11,
      p_bpa_attribute12                => p_rec.bpa_attribute12,
      p_bpa_attribute13                => p_rec.bpa_attribute13,
      p_bpa_attribute14                => p_rec.bpa_attribute14,
      p_bpa_attribute15                => p_rec.bpa_attribute15,
      p_bpa_attribute16                => p_rec.bpa_attribute16,
      p_bpa_attribute17                => p_rec.bpa_attribute17,
      p_bpa_attribute18                => p_rec.bpa_attribute18,
      p_bpa_attribute19                => p_rec.bpa_attribute19,
      p_bpa_attribute20                => p_rec.bpa_attribute20,
      p_bpa_attribute21                => p_rec.bpa_attribute21,
      p_bpa_attribute22                => p_rec.bpa_attribute22,
      p_bpa_attribute23                => p_rec.bpa_attribute23,
      p_bpa_attribute24                => p_rec.bpa_attribute24,
      p_bpa_attribute25                => p_rec.bpa_attribute25,
      p_bpa_attribute26                => p_rec.bpa_attribute26,
      p_bpa_attribute27                => p_rec.bpa_attribute27,
      p_bpa_attribute28                => p_rec.bpa_attribute28,
      p_bpa_attribute29                => p_rec.bpa_attribute29,
      p_bpa_attribute30                => p_rec.bpa_attribute30
      );

Line: 317

End post_insert;

Line: 334

  per_bpa_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
     );