APPS.OTA_TPM_INS SQL Statements

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

Line: 71

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

Line: 88

  insert into ota_training_plan_members
      (training_plan_member_id
      ,training_plan_id
      ,activity_version_id
      ,activity_definition_id
      ,member_status_type_id
      ,target_completion_date
      ,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
      ,assignment_id
      ,source_id
      ,source_function
      ,cancellation_reason
      ,earliest_start_date
      ,creator_person_id
      )
  Values
    (p_rec.training_plan_member_id
    ,p_rec.training_plan_id
    ,p_rec.activity_version_id
    ,p_rec.activity_definition_id
    ,p_rec.member_status_type_id
    ,p_rec.target_completion_date
    ,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.assignment_id
    ,p_rec.source_id
    ,p_rec.source_function
    ,p_rec.cancellation_reason
    ,p_rec.earliest_start_date
    ,p_rec.creator_person_id
    );

Line: 205

End insert_dml;

Line: 244

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

Line: 250

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

Line: 253

    Select null
      from ota_training_plan_members
     where training_plan_member_id =
             ota_tpm_ins.g_training_plan_member_id_i;

Line: 296

End pre_insert;

Line: 330

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

Line: 341

    ota_tpm_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_training_plan_member_id
      => p_rec.training_plan_member_id
      ,p_training_plan_id
      => p_rec.training_plan_id
      ,p_activity_version_id
      => p_rec.activity_version_id
      ,p_activity_definition_id
      => p_rec.activity_definition_id
      ,p_member_status_type_id
      => p_rec.member_status_type_id
      ,p_target_completion_date
      => p_rec.target_completion_date
      ,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_assignment_id => p_rec.assignment_id
      ,p_source_id => p_rec.source_id
      ,p_source_function => p_rec.source_function
      ,p_cancellation_reason => p_rec.cancellation_reason
      ,p_earliest_start_date => p_rec.earliest_start_date
      ,p_creator_person_id  =>p_rec.creator_person_id
      );

Line: 440

End post_insert;

Line: 457

  ota_tpm_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 465

  ota_tpm_ins.pre_insert(p_rec);

Line: 469

  ota_tpm_ins.insert_dml(p_rec);

Line: 473

  ota_tpm_ins.post_insert
     (p_effective_date
     ,p_rec
     );