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_TPM_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_tpm_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 73


  update ota_training_plan_members
    set
     training_plan_member_id         = p_rec.training_plan_member_id
    ,training_plan_id                = p_rec.training_plan_id
    ,activity_version_id             = p_rec.activity_version_id
    ,activity_definition_id          = p_rec.activity_definition_id
    ,member_status_type_id           = p_rec.member_status_type_id
    ,target_completion_date          = p_rec.target_completion_date
    ,business_group_id               = p_rec.business_group_id
    ,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
    ,attribute21                     = p_rec.attribute21
    ,attribute22                     = p_rec.attribute22
    ,attribute23                     = p_rec.attribute23
    ,attribute24                     = p_rec.attribute24
    ,attribute25                     = p_rec.attribute25
    ,attribute26                     = p_rec.attribute26
    ,attribute27                     = p_rec.attribute27
    ,attribute28                     = p_rec.attribute28
    ,attribute29                     = p_rec.attribute29
    ,attribute30                     = p_rec.attribute30
    ,assignment_id		             = p_rec.assignment_id
    ,source_id                       = p_rec.source_id
    ,source_function                 = p_rec.source_function
    ,cancellation_reason             = p_rec.cancellation_reason
    ,earliest_start_date             = p_rec.earliest_start_date
    ,creator_person_id               = p_rec.creator_person_id
    where training_plan_member_id    = p_rec.training_plan_member_id;

Line: 145


End update_dml;

Line: 179


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

Line: 189


End pre_update;

Line: 223


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

Line: 234


    ota_tpm_rku.after_update
      (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
      ,p_training_plan_id_o
      => ota_tpm_shd.g_old_rec.training_plan_id
      ,p_activity_version_id_o
      => ota_tpm_shd.g_old_rec.activity_version_id
      ,p_activity_definition_id_o
      => ota_tpm_shd.g_old_rec.activity_definition_id
      ,p_member_status_type_id_o
      => ota_tpm_shd.g_old_rec.member_status_type_id
      ,p_target_completion_date_o
      => ota_tpm_shd.g_old_rec.target_completion_date
      ,p_business_group_id_o
      => ota_tpm_shd.g_old_rec.business_group_id
      ,p_object_version_number_o
      => ota_tpm_shd.g_old_rec.object_version_number
      ,p_attribute_category_o
      => ota_tpm_shd.g_old_rec.attribute_category
      ,p_attribute1_o
      => ota_tpm_shd.g_old_rec.attribute1
      ,p_attribute2_o
      => ota_tpm_shd.g_old_rec.attribute2
      ,p_attribute3_o
      => ota_tpm_shd.g_old_rec.attribute3
      ,p_attribute4_o
      => ota_tpm_shd.g_old_rec.attribute4
      ,p_attribute5_o
      => ota_tpm_shd.g_old_rec.attribute5
      ,p_attribute6_o
      => ota_tpm_shd.g_old_rec.attribute6
      ,p_attribute7_o
      => ota_tpm_shd.g_old_rec.attribute7
      ,p_attribute8_o
      => ota_tpm_shd.g_old_rec.attribute8
      ,p_attribute9_o
      => ota_tpm_shd.g_old_rec.attribute9
      ,p_attribute10_o
      => ota_tpm_shd.g_old_rec.attribute10
      ,p_attribute11_o
      => ota_tpm_shd.g_old_rec.attribute11
      ,p_attribute12_o
      => ota_tpm_shd.g_old_rec.attribute12
      ,p_attribute13_o
      => ota_tpm_shd.g_old_rec.attribute13
      ,p_attribute14_o
      => ota_tpm_shd.g_old_rec.attribute14
      ,p_attribute15_o
      => ota_tpm_shd.g_old_rec.attribute15
      ,p_attribute16_o
      => ota_tpm_shd.g_old_rec.attribute16
      ,p_attribute17_o
      => ota_tpm_shd.g_old_rec.attribute17
      ,p_attribute18_o
      => ota_tpm_shd.g_old_rec.attribute18
      ,p_attribute19_o
      => ota_tpm_shd.g_old_rec.attribute19
      ,p_attribute20_o
      => ota_tpm_shd.g_old_rec.attribute20
      ,p_attribute21_o
      => ota_tpm_shd.g_old_rec.attribute21
      ,p_attribute22_o
      => ota_tpm_shd.g_old_rec.attribute22
      ,p_attribute23_o
      => ota_tpm_shd.g_old_rec.attribute23
      ,p_attribute24_o
      => ota_tpm_shd.g_old_rec.attribute24
      ,p_attribute25_o
      => ota_tpm_shd.g_old_rec.attribute25
      ,p_attribute26_o
      => ota_tpm_shd.g_old_rec.attribute26
      ,p_attribute27_o
      => ota_tpm_shd.g_old_rec.attribute27
      ,p_attribute28_o
      => ota_tpm_shd.g_old_rec.attribute28
      ,p_attribute29_o
      => ota_tpm_shd.g_old_rec.attribute29
      ,p_attribute30_o
      => ota_tpm_shd.g_old_rec.attribute30
      ,p_assignment_id_o => ota_tpm_shd.g_old_rec.assignment_id
      ,p_source_id_o => ota_tpm_shd.g_old_rec.source_id
      ,p_source_function_o => ota_tpm_shd.g_old_rec.source_function
      ,p_cancellation_reason_o => ota_tpm_shd.g_old_rec.cancellation_reason
      ,p_earliest_start_date_o => ota_tpm_shd.g_old_rec.earliest_start_date
      ,p_creator_person_id_o => ota_tpm_shd.g_old_rec.creator_person_id
      );

Line: 415


End post_update;

Line: 673


  ota_tpm_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 681


  ota_tpm_upd.pre_update(p_rec);

Line: 685


  ota_tpm_upd.update_dml(p_rec);

Line: 689


  ota_tpm_upd.post_update
     (p_effective_date
     ,p_rec
     );