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

Line: 89

  insert into ota_lp_enrollments
      (lp_enrollment_id
      ,learning_path_id
      ,person_id
      ,contact_id
      ,path_status_code
      ,enrollment_source_code
      ,no_of_mandatory_courses
      ,no_of_completed_courses
      ,completion_target_date
      ,completion_date
      ,creator_person_id
      ,object_version_number
      ,business_group_id
      ,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
      ,is_history_flag
      )
  Values
    (p_rec.lp_enrollment_id
    ,p_rec.learning_path_id
    ,p_rec.person_id
    ,p_rec.contact_id
    ,p_rec.path_status_code
    ,p_rec.enrollment_source_code
    ,p_rec.no_of_mandatory_courses
    ,p_rec.no_of_completed_courses
    ,p_rec.completion_target_date
    ,p_rec.completion_date
    ,p_rec.creator_person_id
    ,p_rec.object_version_number
    ,p_rec.business_group_id
    ,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.is_history_flag
    );

Line: 206

End insert_dml;

Line: 245

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

Line: 252

    Select null
      from ota_lp_enrollments
     where lp_enrollment_id =
             ota_lpe_ins.g_lp_enrollment_id_i;

Line: 257

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

Line: 298

End pre_insert;

Line: 332

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

Line: 343

    ota_lpe_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_lp_enrollment_id
      => p_rec.lp_enrollment_id
      ,p_learning_path_id
      => p_rec.learning_path_id
      ,p_person_id
      => p_rec.person_id
      ,p_contact_id
      => p_rec.contact_id
      ,p_path_status_code
      => p_rec.path_status_code
      ,p_enrollment_source_code
      => p_rec.enrollment_source_code
      ,p_no_of_mandatory_courses
      => p_rec.no_of_mandatory_courses
      ,p_no_of_completed_courses
      => p_rec.no_of_completed_courses
      ,p_completion_target_date
      => p_rec.completion_target_date
      ,p_completion_date
      => p_rec.completion_date
      ,p_creator_person_id
      => p_rec.creator_person_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_business_group_id
      => p_rec.business_group_id
      ,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_is_history_flag
      => p_rec.is_history_flag
      );

Line: 448

End post_insert;

Line: 465

  ota_lpe_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 475

  ota_lpe_ins.pre_insert(p_rec);

Line: 479

  ota_lpe_ins.insert_dml(p_rec);

Line: 483

  ota_lpe_ins.post_insert
     (p_effective_date
     ,p_rec
     );