APPS.OTA_TMT_INS SQL Statements

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

Line: 53

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

Line: 67

  insert into ota_tp_measurement_types
      (tp_measurement_type_id
      ,tp_measurement_code
      ,unit
      ,reporting_sequence
      ,budget_level
      ,cost_level
      ,many_budget_values_flag
      ,item_type_usage_id
      ,business_group_id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,attribute21
      ,attribute22
      ,attribute23
      ,attribute24
      ,attribute25
      ,attribute26
      ,attribute27
      ,attribute28
      ,attribute29
      ,attribute30
      )
  Values
    (p_rec.tp_measurement_type_id
    ,p_rec.tp_measurement_code
    ,p_rec.unit
    ,p_rec.reporting_sequence
    ,p_rec.budget_level
    ,p_rec.cost_level
    ,p_rec.many_budget_values_flag
    ,p_rec.item_type_usage_id
    ,p_rec.business_group_id
    ,p_rec.object_version_number
    ,p_rec.attribute_category
    ,p_rec.attribute1
    ,p_rec.attribute2
    ,p_rec.attribute3
    ,p_rec.attribute4
    ,p_rec.attribute5
    ,p_rec.attribute6
    ,p_rec.attribute7
    ,p_rec.attribute8
    ,p_rec.attribute9
    ,p_rec.attribute10
    ,p_rec.attribute11
    ,p_rec.attribute12
    ,p_rec.attribute13
    ,p_rec.attribute14
    ,p_rec.attribute15
    ,p_rec.attribute16
    ,p_rec.attribute17
    ,p_rec.attribute18
    ,p_rec.attribute19
    ,p_rec.attribute20
    ,p_rec.attribute21
    ,p_rec.attribute22
    ,p_rec.attribute23
    ,p_rec.attribute24
    ,p_rec.attribute25
    ,p_rec.attribute26
    ,p_rec.attribute27
    ,p_rec.attribute28
    ,p_rec.attribute29
    ,p_rec.attribute30
    );

Line: 176

End insert_dml;

Line: 215

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

Line: 221

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

Line: 234

End pre_insert;

Line: 268

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

Line: 279

    ota_tmt_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_tp_measurement_type_id
      => p_rec.tp_measurement_type_id
      ,p_tp_measurement_code
      => p_rec.tp_measurement_code
      ,p_unit
      => p_rec.unit
      ,p_reporting_sequence
      => p_rec.reporting_sequence
      ,p_budget_level
      => p_rec.budget_level
      ,p_cost_level
      => p_rec.cost_level
      ,p_many_budget_values_flag
      => p_rec.many_budget_values_flag
      ,p_item_type_usage_id
      => p_rec.item_type_usage_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_attribute_category
      => p_rec.attribute_category
      ,p_attribute1
      => p_rec.attribute1
      ,p_attribute2
      => p_rec.attribute2
      ,p_attribute3
      => p_rec.attribute3
      ,p_attribute4
      => p_rec.attribute4
      ,p_attribute5
      => p_rec.attribute5
      ,p_attribute6
      => p_rec.attribute6
      ,p_attribute7
      => p_rec.attribute7
      ,p_attribute8
      => p_rec.attribute8
      ,p_attribute9
      => p_rec.attribute9
      ,p_attribute10
      => p_rec.attribute10
      ,p_attribute11
      => p_rec.attribute11
      ,p_attribute12
      => p_rec.attribute12
      ,p_attribute13
      => p_rec.attribute13
      ,p_attribute14
      => p_rec.attribute14
      ,p_attribute15
      => p_rec.attribute15
      ,p_attribute16
      => p_rec.attribute16
      ,p_attribute17
      => p_rec.attribute17
      ,p_attribute18
      => p_rec.attribute18
      ,p_attribute19
      => p_rec.attribute19
      ,p_attribute20
      => p_rec.attribute20
      ,p_attribute21
      => p_rec.attribute21
      ,p_attribute22
      => p_rec.attribute22
      ,p_attribute23
      => p_rec.attribute23
      ,p_attribute24
      => p_rec.attribute24
      ,p_attribute25
      => p_rec.attribute25
      ,p_attribute26
      => p_rec.attribute26
      ,p_attribute27
      => p_rec.attribute27
      ,p_attribute28
      => p_rec.attribute28
      ,p_attribute29
      => p_rec.attribute29
      ,p_attribute30
      => p_rec.attribute30
      );

Line: 376

End post_insert;

Line: 393

  ota_tmt_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 400

  ota_tmt_ins.pre_insert(p_rec);

Line: 404

  ota_tmt_ins.insert_dml(p_rec);

Line: 408

  ota_tmt_ins.post_insert
     (p_effective_date
     ,p_rec
     );