APPS.OTA_TPS_INS SQL Statements

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

Line: 70

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

Line: 84

  insert into ota_training_plans
      (training_plan_id
      ,time_period_id
      ,plan_status_type_id
      ,organization_id
      ,person_id
      ,budget_currency
      ,name
      ,description
      ,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
      ,plan_source
      ,start_date
      ,end_date
      ,creator_person_id
      ,additional_member_flag
      ,learning_path_id
      ,contact_id
      )
  Values
    (p_rec.training_plan_id
    ,p_rec.time_period_id
    ,p_rec.plan_status_type_id
    ,p_rec.organization_id
    ,p_rec.person_id
    ,p_rec.budget_currency
    ,p_rec.name
    ,p_rec.description
    ,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
    ,p_rec.plan_source
    ,p_rec.start_date
    ,p_rec.end_date
    ,p_rec.creator_person_id
    ,p_rec.additional_member_flag
    ,p_rec.learning_path_id
    ,p_rec.contact_id
    );

Line: 207

End insert_dml;

Line: 246

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

Line: 252

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

Line: 255

    Select null
      from ota_training_plans
     where training_plan_id =
             ota_tps_ins.g_training_plan_id_i;

Line: 299

End pre_insert;

Line: 333

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

Line: 344

    ota_tps_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_training_plan_id
      => p_rec.training_plan_id
      ,p_time_period_id
      => p_rec.time_period_id
      ,p_plan_status_type_id
      => p_rec.plan_status_type_id
      ,p_organization_id
      => p_rec.organization_id
      ,p_person_id
      => p_rec.person_id
      ,p_budget_currency
      => p_rec.budget_currency
      ,p_name
      => p_rec.name
      ,p_description
      => p_rec.description
      ,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
      ,p_plan_source => p_rec.plan_source  --changed
      ,p_start_date => p_rec.start_date
      ,p_end_date => p_rec.end_date
      ,p_creator_person_id => p_rec.creator_person_id
      ,p_additional_member_flag  => p_rec.additional_member_flag
      ,p_learning_path_id  => p_rec.learning_path_id
      ,p_contact_id => p_rec.contact_id
      );

Line: 448

End post_insert;

Line: 465

  ota_tps_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 475

  ota_tps_ins.pre_insert(p_rec);

Line: 479

  ota_tps_ins.insert_dml(p_rec);

Line: 483

  ota_tps_ins.post_insert
     (p_effective_date
     ,p_rec
     );