APPS.OTA_LME_INS SQL Statements

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

Line: 75

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

Line: 89

  insert into ota_lp_member_enrollments
      (lp_member_enrollment_id
      ,lp_enrollment_id
      ,learning_path_section_id
      ,learning_path_member_id
      ,member_status_code
      ,completion_target_date
      ,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
      ,creator_person_id
      ,event_id
      )
  Values
    (p_rec.lp_member_enrollment_id
    ,p_rec.lp_enrollment_id
    ,p_rec.learning_path_section_id
    ,p_rec.learning_path_member_id
    ,p_rec.member_status_code
    ,p_rec.completion_target_date
    ,p_rec.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.creator_person_id
    ,p_rec.event_id
    );

Line: 200

End insert_dml;

Line: 239

Procedure pre_insert
  (p_rec  in out nocopy ota_lme_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select ota_lp_member_enrollments_s.nextval from sys.dual;

Line: 246

    Select null
      from ota_lp_member_enrollments
     where lp_member_enrollment_id =
             ota_lme_ins.g_lp_member_enrollment_id_i;

Line: 251

  l_proc   varchar2(72) := g_package||'pre_insert';

Line: 292

End pre_insert;

Line: 326

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

Line: 337

    ota_lme_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_lp_member_enrollment_id
      => p_rec.lp_member_enrollment_id
      ,p_lp_enrollment_id
      => p_rec.lp_enrollment_id
      ,p_learning_path_section_id
      => p_rec.learning_path_section_id
      ,p_learning_path_member_id
      => p_rec.learning_path_member_id
      ,p_member_status_code
      => p_rec.member_status_code
      ,p_completion_target_date
      => p_rec.completion_target_date
      ,p_completion_date
      => p_rec.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_creator_person_id
      => p_rec.creator_person_id
      ,p_event_id
      => p_rec.event_id
      );

Line: 436

End post_insert;

Line: 453

  ota_lme_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 463

  ota_lme_ins.pre_insert(p_rec);

Line: 467

  ota_lme_ins.insert_dml(p_rec);

Line: 471

  ota_lme_ins.post_insert
     (p_effective_date
     ,p_rec
     );