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

Line: 64

  insert into per_bf_balance_amounts
  (      balance_amount_id,
      balance_type_id,
      processed_assignment_id,
      business_group_id,
      ytd_amount,
      fytd_amount,
      ptd_amount,
      mtd_amount,
      qtd_amount,
      run_amount,
      object_version_number,
      bba_attribute_category,
      bba_attribute1,
      bba_attribute2,
      bba_attribute3,
      bba_attribute4,
      bba_attribute5,
      bba_attribute6,
      bba_attribute7,
      bba_attribute8,
      bba_attribute9,
      bba_attribute10,
      bba_attribute11,
      bba_attribute12,
      bba_attribute13,
      bba_attribute14,
      bba_attribute15,
      bba_attribute16,
      bba_attribute17,
      bba_attribute18,
      bba_attribute19,
      bba_attribute20,
      bba_attribute21,
      bba_attribute22,
      bba_attribute23,
      bba_attribute24,
      bba_attribute25,
      bba_attribute26,
      bba_attribute27,
      bba_attribute28,
      bba_attribute29,
      bba_attribute30
  )
  Values
  (   p_rec.balance_amount_id,
      p_rec.balance_type_id,
      p_rec.processed_assignment_id,
      p_rec.business_group_id,
      p_rec.ytd_amount,
      p_rec.fytd_amount,
      p_rec.ptd_amount,
      p_rec.mtd_amount,
      p_rec.qtd_amount,
      p_rec.run_amount,
      p_rec.object_version_number,
      p_rec.bba_attribute_category,
      p_rec.bba_attribute1,
      p_rec.bba_attribute2,
      p_rec.bba_attribute3,
      p_rec.bba_attribute4,
      p_rec.bba_attribute5,
      p_rec.bba_attribute6,
      p_rec.bba_attribute7,
      p_rec.bba_attribute8,
      p_rec.bba_attribute9,
      p_rec.bba_attribute10,
      p_rec.bba_attribute11,
      p_rec.bba_attribute12,
      p_rec.bba_attribute13,
      p_rec.bba_attribute14,
      p_rec.bba_attribute15,
      p_rec.bba_attribute16,
      p_rec.bba_attribute17,
      p_rec.bba_attribute18,
      p_rec.bba_attribute19,
      p_rec.bba_attribute20,
      p_rec.bba_attribute21,
      p_rec.bba_attribute22,
      p_rec.bba_attribute23,
      p_rec.bba_attribute24,
      p_rec.bba_attribute25,
      p_rec.bba_attribute26,
      p_rec.bba_attribute27,
      p_rec.bba_attribute28,
      p_rec.bba_attribute29,
      p_rec.bba_attribute30
  );

Line: 170

End insert_dml;

Line: 209

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

Line: 213

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

Line: 224

End pre_insert;

Line: 258

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

Line: 267

    per_bba_rki.after_insert
      (p_effective_date            => p_effective_date,
      p_balance_amount_id          => p_rec.balance_amount_id,
      p_balance_type_id            => p_rec.balance_type_id,
      p_processed_assignment_id    => p_rec.processed_assignment_id,
      p_business_group_id          => p_rec.business_group_id,
      p_ytd_amount                 => p_rec.ytd_amount,
      p_fytd_amount                => p_rec.fytd_amount,
      p_ptd_amount                 => p_rec.ptd_amount,
      p_mtd_amount                 => p_rec.mtd_amount,
      p_qtd_amount                 => p_rec.qtd_amount,
      p_run_amount                 => p_rec.run_amount,
      p_object_version_number      => p_rec.object_version_number,
      p_bba_attribute_category         => p_rec.bba_attribute_category,
      p_bba_attribute1                 => p_rec.bba_attribute1,
      p_bba_attribute2                 => p_rec.bba_attribute2,
      p_bba_attribute3                 => p_rec.bba_attribute3,
      p_bba_attribute4                 => p_rec.bba_attribute4,
      p_bba_attribute5                 => p_rec.bba_attribute5,
      p_bba_attribute6                 => p_rec.bba_attribute6,
      p_bba_attribute7                 => p_rec.bba_attribute7,
      p_bba_attribute8                 => p_rec.bba_attribute8,
      p_bba_attribute9                 => p_rec.bba_attribute9,
      p_bba_attribute10                => p_rec.bba_attribute10,
      p_bba_attribute11                => p_rec.bba_attribute11,
      p_bba_attribute12                => p_rec.bba_attribute12,
      p_bba_attribute13                => p_rec.bba_attribute13,
      p_bba_attribute14                => p_rec.bba_attribute14,
      p_bba_attribute15                => p_rec.bba_attribute15,
      p_bba_attribute16                => p_rec.bba_attribute16,
      p_bba_attribute17                => p_rec.bba_attribute17,
      p_bba_attribute18                => p_rec.bba_attribute18,
      p_bba_attribute19                => p_rec.bba_attribute19,
      p_bba_attribute20                => p_rec.bba_attribute20,
      p_bba_attribute21                => p_rec.bba_attribute21,
      p_bba_attribute22                => p_rec.bba_attribute22,
      p_bba_attribute23                => p_rec.bba_attribute23,
      p_bba_attribute24                => p_rec.bba_attribute24,
      p_bba_attribute25                => p_rec.bba_attribute25,
      p_bba_attribute26                => p_rec.bba_attribute26,
      p_bba_attribute27                => p_rec.bba_attribute27,
      p_bba_attribute28                => p_rec.bba_attribute28,
      p_bba_attribute29                => p_rec.bba_attribute29,
      p_bba_attribute30                => p_rec.bba_attribute30
      );

Line: 324

End post_insert;

Line: 343

  per_bba_bus.insert_validate(p_effective_date,
                             p_rec
                             );

Line: 349

  pre_insert(p_rec);

Line: 353

  insert_dml(p_rec);

Line: 357

  post_insert(p_effective_date,
                             p_rec);