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.HR_ORU_UPD SQL Statements

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

Line: 54


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

Line: 70


  update hr_all_organization_units
    set
     organization_id                 = p_rec.organization_id
    ,business_group_id               = p_rec.business_group_id
    ,cost_allocation_keyflex_id      = p_rec.cost_allocation_keyflex_id
    ,location_id                     = p_rec.location_id
    -- Bug 3040119
    --,soft_coding_keyflex_id          = p_rec.soft_coding_keyflex_id
    ,date_from                       = p_rec.date_from
    ,name                            = p_rec.name
    ,comments                        = p_rec.comments
    ,date_to                         = p_rec.date_to
    ,internal_external_flag          = p_rec.internal_external_flag
    ,internal_address_line           = p_rec.internal_address_line
    ,type                            = p_rec.type
    ,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
    --Enhancement 4040086
    ,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
    --End Enhancement 4040086
    ,object_version_number           = p_rec.object_version_number
    where organization_id = p_rec.organization_id;

Line: 144


End update_dml;

Line: 178


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

Line: 188


End pre_update;

Line: 222


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

Line: 233


    hr_oru_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_organization_id
      => p_rec.organization_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_cost_allocation_keyflex_id
      => p_rec.cost_allocation_keyflex_id
      ,p_location_id
      => p_rec.location_id
      ,p_soft_coding_keyflex_id
      => p_rec.soft_coding_keyflex_id
      ,p_date_from
      => p_rec.date_from
      ,p_name
      => p_rec.name
      ,p_comments
      => p_rec.comments
      ,p_date_to
      => p_rec.date_to
      ,p_internal_external_flag
      => p_rec.internal_external_flag
      ,p_internal_address_line
      => p_rec.internal_address_line
      ,p_type
      => p_rec.type
      ,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
      --Enhancement 4040086
      ,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
      --End Enhacement 4040086
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_business_group_id_o
      => hr_oru_shd.g_old_rec.business_group_id
      ,p_cost_allocation_keyflex_id_o
      => hr_oru_shd.g_old_rec.cost_allocation_keyflex_id
      ,p_location_id_o
      => hr_oru_shd.g_old_rec.location_id
      ,p_soft_coding_keyflex_id_o
      => hr_oru_shd.g_old_rec.soft_coding_keyflex_id
      ,p_date_from_o
      => hr_oru_shd.g_old_rec.date_from
      ,p_name_o
      => hr_oru_shd.g_old_rec.name
      ,p_comments_o
      => hr_oru_shd.g_old_rec.comments
      ,p_date_to_o
      => hr_oru_shd.g_old_rec.date_to
      ,p_internal_external_flag_o
      => hr_oru_shd.g_old_rec.internal_external_flag
      ,p_internal_address_line_o
      => hr_oru_shd.g_old_rec.internal_address_line
      ,p_type_o
      => hr_oru_shd.g_old_rec.type
      ,p_request_id_o
      => hr_oru_shd.g_old_rec.request_id
      ,p_program_application_id_o
      => hr_oru_shd.g_old_rec.program_application_id
      ,p_program_id_o
      => hr_oru_shd.g_old_rec.program_id
      ,p_program_update_date_o
      => hr_oru_shd.g_old_rec.program_update_date
      ,p_attribute_category_o
      => hr_oru_shd.g_old_rec.attribute_category
      ,p_attribute1_o
      => hr_oru_shd.g_old_rec.attribute1
      ,p_attribute2_o
      => hr_oru_shd.g_old_rec.attribute2
      ,p_attribute3_o
      => hr_oru_shd.g_old_rec.attribute3
      ,p_attribute4_o
      => hr_oru_shd.g_old_rec.attribute4
      ,p_attribute5_o
      => hr_oru_shd.g_old_rec.attribute5
      ,p_attribute6_o
      => hr_oru_shd.g_old_rec.attribute6
      ,p_attribute7_o
      => hr_oru_shd.g_old_rec.attribute7
      ,p_attribute8_o
      => hr_oru_shd.g_old_rec.attribute8
      ,p_attribute9_o
      => hr_oru_shd.g_old_rec.attribute9
      ,p_attribute10_o
      => hr_oru_shd.g_old_rec.attribute10
      ,p_attribute11_o
      => hr_oru_shd.g_old_rec.attribute11
      ,p_attribute12_o
      => hr_oru_shd.g_old_rec.attribute12
      ,p_attribute13_o
      => hr_oru_shd.g_old_rec.attribute13
      ,p_attribute14_o
      => hr_oru_shd.g_old_rec.attribute14
      ,p_attribute15_o
      => hr_oru_shd.g_old_rec.attribute15
      ,p_attribute16_o
      => hr_oru_shd.g_old_rec.attribute16
      ,p_attribute17_o
      => hr_oru_shd.g_old_rec.attribute17
      ,p_attribute18_o
      => hr_oru_shd.g_old_rec.attribute18
      ,p_attribute19_o
      => hr_oru_shd.g_old_rec.attribute19
      ,p_attribute20_o
      => hr_oru_shd.g_old_rec.attribute20
      --Enhancement 4040086
      ,p_attribute21_o
      => hr_oru_shd.g_old_rec.attribute21
      ,p_attribute22_o
      => hr_oru_shd.g_old_rec.attribute22
      ,p_attribute23_o
      => hr_oru_shd.g_old_rec.attribute23
      ,p_attribute24_o
      => hr_oru_shd.g_old_rec.attribute24
      ,p_attribute25_o
      => hr_oru_shd.g_old_rec.attribute25
      ,p_attribute26_o
      => hr_oru_shd.g_old_rec.attribute26
      ,p_attribute27_o
      => hr_oru_shd.g_old_rec.attribute27
      ,p_attribute28_o
      => hr_oru_shd.g_old_rec.attribute28
      ,p_attribute29_o
      => hr_oru_shd.g_old_rec.attribute29
      ,p_attribute30_o
      => hr_oru_shd.g_old_rec.attribute30
      --End  Enhancement 4040086
      ,p_object_version_number_o
      => hr_oru_shd.g_old_rec.object_version_number
      );

Line: 434


End post_update;

Line: 546


  If (p_rec.program_update_date = hr_api.g_date) then
    p_rec.program_update_date :=
    hr_oru_shd.g_old_rec.program_update_date;

Line: 707


  hr_oru_bus.update_validate
     (p_effective_date
     ,p_rec
     ,p_duplicate_org_warning
     );

Line: 715


  hr_oru_upd.pre_update(p_rec);

Line: 719


  hr_oru_upd.update_dml(p_rec);

Line: 723


  hr_oru_upd.post_update
     (p_effective_date
     ,p_rec
     );