eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LPS_UPD SQL Statements

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

Line: 54


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

Line: 70


  update ota_learning_paths
    set
     learning_path_id                = p_rec.learning_path_id
    ,business_group_id               = p_rec.business_group_id
    ,duration                        = p_rec.duration
    ,duration_units                  = p_rec.duration_units
    ,object_version_number           = p_rec.object_version_number
    ,attribute_category              = p_rec.attribute_category
    ,attribute1                      = p_rec.attribute1
    ,attribute2                      = p_rec.attribute2
    ,attribute3                      = p_rec.attribute3
    ,attribute4                      = p_rec.attribute4
    ,attribute5                      = p_rec.attribute5
    ,attribute6                      = p_rec.attribute6
    ,attribute7                      = p_rec.attribute7
    ,attribute8                      = p_rec.attribute8
    ,attribute9                      = p_rec.attribute9
    ,attribute10                     = p_rec.attribute10
    ,attribute11                     = p_rec.attribute11
    ,attribute12                     = p_rec.attribute12
    ,attribute13                     = p_rec.attribute13
    ,attribute14                     = p_rec.attribute14
    ,attribute15                     = p_rec.attribute15
    ,attribute16                     = p_rec.attribute16
    ,attribute17                     = p_rec.attribute17
    ,attribute18                     = p_rec.attribute18
    ,attribute19                     = p_rec.attribute19
    ,attribute20                     = p_rec.attribute20
    ,start_date_active               = p_rec.start_date_active
    ,end_date_active                 = p_rec.end_date_active
    ,path_source_code                = p_rec.path_source_code
    ,source_function_code            = p_rec.source_function_code
    ,assignment_id                   = p_rec.assignment_id
    ,source_id                       = p_rec.source_id
    ,notify_days_before_target       = p_rec.notify_days_before_target
    ,person_id                       = p_rec.person_id
    ,contact_id                      = p_rec.contact_id
    ,display_to_learner_flag         = p_rec.display_to_learner_flag
    ,public_flag                     = p_rec.public_flag
    ,competency_update_level        = p_rec.competency_update_level
    where learning_path_id = p_rec.learning_path_id;

Line: 135


End update_dml;

Line: 169


Procedure pre_update
  (p_rec in ota_lps_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 179


End pre_update;

Line: 213


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

Line: 225


    ota_lps_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_learning_path_id
      => p_rec.learning_path_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_duration
      => p_rec.duration
      ,p_duration_units
      => p_rec.duration_units
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_start_date_active
      => p_rec.start_date_active
      ,p_end_date_active
      => p_rec.end_date_active
      ,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_path_source_code
      => p_rec.path_source_code
      ,p_source_function_code
      => p_rec.source_function_code
      ,p_assignment_id
      => p_rec.assignment_id
      ,p_source_id
      => p_rec.source_id
      ,p_notify_days_before_target
      => p_rec.notify_days_before_target
      ,p_person_id
      => p_rec.person_id
      ,p_contact_id
      => p_rec.contact_id
      ,p_display_to_learner_flag
      => p_rec.display_to_learner_flag
      ,p_public_flag
      => p_rec.public_flag
      ,p_competency_update_level      => p_rec.competency_update_level
      ,p_business_group_id_o
      => ota_lps_shd.g_old_rec.business_group_id
      ,p_duration_o
      => ota_lps_shd.g_old_rec.duration
      ,p_duration_units_o
      => ota_lps_shd.g_old_rec.duration_units
      ,p_start_date_active_o
      => ota_lps_shd.g_old_rec.start_date_active
      ,p_end_date_active_o
      => ota_lps_shd.g_old_rec.end_date_active
      ,p_object_version_number_o
      => ota_lps_shd.g_old_rec.object_version_number
      ,p_attribute_category_o
      => ota_lps_shd.g_old_rec.attribute_category
      ,p_attribute1_o
      => ota_lps_shd.g_old_rec.attribute1
      ,p_attribute2_o
      => ota_lps_shd.g_old_rec.attribute2
      ,p_attribute3_o
      => ota_lps_shd.g_old_rec.attribute3
      ,p_attribute4_o
      => ota_lps_shd.g_old_rec.attribute4
      ,p_attribute5_o
      => ota_lps_shd.g_old_rec.attribute5
      ,p_attribute6_o
      => ota_lps_shd.g_old_rec.attribute6
      ,p_attribute7_o
      => ota_lps_shd.g_old_rec.attribute7
      ,p_attribute8_o
      => ota_lps_shd.g_old_rec.attribute8
      ,p_attribute9_o
      => ota_lps_shd.g_old_rec.attribute9
      ,p_attribute10_o
      => ota_lps_shd.g_old_rec.attribute10
      ,p_attribute11_o
      => ota_lps_shd.g_old_rec.attribute11
      ,p_attribute12_o
      => ota_lps_shd.g_old_rec.attribute12
      ,p_attribute13_o
      => ota_lps_shd.g_old_rec.attribute13
      ,p_attribute14_o
      => ota_lps_shd.g_old_rec.attribute14
      ,p_attribute15_o
      => ota_lps_shd.g_old_rec.attribute15
      ,p_attribute16_o
      => ota_lps_shd.g_old_rec.attribute16
      ,p_attribute17_o
      => ota_lps_shd.g_old_rec.attribute17
      ,p_attribute18_o
      => ota_lps_shd.g_old_rec.attribute18
      ,p_attribute19_o
      => ota_lps_shd.g_old_rec.attribute19
      ,p_attribute20_o
      => ota_lps_shd.g_old_rec.attribute20
      ,p_path_source_code_o
      => ota_lps_shd.g_old_rec.path_source_code
      ,p_source_function_code_o
      => ota_lps_shd.g_old_rec.source_function_code
      ,p_assignment_id_o
      => ota_lps_shd.g_old_rec.assignment_id
      ,p_source_id_o
      => ota_lps_shd.g_old_rec.source_id
      ,p_notify_days_before_target_o
      => ota_lps_shd.g_old_rec.notify_days_before_target
      ,p_person_id_o
      => ota_lps_shd.g_old_rec.person_id
      ,p_contact_id_o
      => ota_lps_shd.g_old_rec.contact_id
      ,p_display_to_learner_flag_o
      => ota_lps_shd.g_old_rec.display_to_learner_flag
      ,p_public_flag_o
      => ota_lps_shd.g_old_rec.public_flag
      ,p_competency_update_level_o      => ota_lps_shd.g_old_rec.competency_update_level
      );

Line: 391


End post_update;

Line: 587


  If (p_rec.competency_update_level = hr_api.g_varchar2) then
    p_rec.competency_update_level :=
    ota_lps_shd.g_old_rec.competency_update_level;

Line: 621


  ota_lps_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 631


  ota_lps_upd.pre_update(p_rec);

Line: 635


  ota_lps_upd.update_dml(p_rec);

Line: 639


  ota_lps_upd.post_update
     (p_effective_date
     ,p_rec
     );

Line: 690


  ,p_competency_update_level        in     varchar2  default hr_api.g_varchar2
  ) is
--
  l_rec   ota_lps_shd.g_rec_type;

Line: 741


  ,p_competency_update_level
  );