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

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

Line: 54


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

Line: 70


  update per_organization_structures
    set
     organization_structure_id       = p_rec.organization_structure_id
    ,business_group_id               = p_rec.business_group_id
    ,name                            = p_rec.name
    ,comments                        = p_rec.comments
    ,primary_structure_flag          = p_rec.primary_structure_flag
    ,request_id                      = p_rec.request_id
    ,program_application_id          = p_rec.program_application_id
    ,program_id                      = p_rec.program_id
    ,program_update_date             = p_rec.program_update_date
    ,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
    ,position_control_structure_flg  = p_rec.position_control_structure_flg
    ,object_version_number           = p_rec.object_version_number
    where organization_structure_id = p_rec.organization_structure_id;

Line: 129


End update_dml;

Line: 163


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

Line: 173


End pre_update;

Line: 207


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

Line: 218


    per_ors_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_organization_structure_id
      => p_rec.organization_structure_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_name
      => p_rec.name
      ,p_comments
      => p_rec.comments
      ,p_primary_structure_flag
      => p_rec.primary_structure_flag
      ,p_request_id
      => p_rec.request_id
      ,p_program_application_id
      => p_rec.program_application_id
      ,p_program_id
      => p_rec.program_id
      ,p_program_update_date
      => p_rec.program_update_date
      ,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_position_control_structure_f
      => p_rec.position_control_structure_flg
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_business_group_id_o
      => per_ors_shd.g_old_rec.business_group_id
      ,p_name_o
      => per_ors_shd.g_old_rec.name
      ,p_comments_o
      => per_ors_shd.g_old_rec.comments
      ,p_primary_structure_flag_o
      => per_ors_shd.g_old_rec.primary_structure_flag
      ,p_request_id_o
      => per_ors_shd.g_old_rec.request_id
      ,p_program_application_id_o
      => per_ors_shd.g_old_rec.program_application_id
      ,p_program_id_o
      => per_ors_shd.g_old_rec.program_id
      ,p_program_update_date_o
      => per_ors_shd.g_old_rec.program_update_date
      ,p_attribute_category_o
      => per_ors_shd.g_old_rec.attribute_category
      ,p_attribute1_o
      => per_ors_shd.g_old_rec.attribute1
      ,p_attribute2_o
      => per_ors_shd.g_old_rec.attribute2
      ,p_attribute3_o
      => per_ors_shd.g_old_rec.attribute3
      ,p_attribute4_o
      => per_ors_shd.g_old_rec.attribute4
      ,p_attribute5_o
      => per_ors_shd.g_old_rec.attribute5
      ,p_attribute6_o
      => per_ors_shd.g_old_rec.attribute6
      ,p_attribute7_o
      => per_ors_shd.g_old_rec.attribute7
      ,p_attribute8_o
      => per_ors_shd.g_old_rec.attribute8
      ,p_attribute9_o
      => per_ors_shd.g_old_rec.attribute9
      ,p_attribute10_o
      => per_ors_shd.g_old_rec.attribute10
      ,p_attribute11_o
      => per_ors_shd.g_old_rec.attribute11
      ,p_attribute12_o
      => per_ors_shd.g_old_rec.attribute12
      ,p_attribute13_o
      => per_ors_shd.g_old_rec.attribute13
      ,p_attribute14_o
      => per_ors_shd.g_old_rec.attribute14
      ,p_attribute15_o
      => per_ors_shd.g_old_rec.attribute15
      ,p_attribute16_o
      => per_ors_shd.g_old_rec.attribute16
      ,p_attribute17_o
      => per_ors_shd.g_old_rec.attribute17
      ,p_attribute18_o
      => per_ors_shd.g_old_rec.attribute18
      ,p_attribute19_o
      => per_ors_shd.g_old_rec.attribute19
      ,p_attribute20_o
      => per_ors_shd.g_old_rec.attribute20
      ,p_position_control_structure_o
      => per_ors_shd.g_old_rec.position_control_structure_flg
      ,p_object_version_number_o
      => per_ors_shd.g_old_rec.object_version_number
      );

Line: 359


End post_update;

Line: 443


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

Line: 565


  per_ors_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 572


  per_ors_upd.pre_update(p_rec);

Line: 576


  per_ors_upd.update_dml(p_rec);

Line: 580


  per_ors_upd.post_update
     (p_effective_date
     ,p_rec
     );

Line: 600


  ,p_program_update_date          in     date      default hr_api.g_date
  ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
  ,p_position_control_structure_f in     varchar2  default hr_api.g_varchar2
  ) is
--
  l_rec   per_ors_shd.g_rec_type;

Line: 644


  ,p_program_update_date
  ,p_attribute_category
  ,p_attribute1
  ,p_attribute2
  ,p_attribute3
  ,p_attribute4
  ,p_attribute5
  ,p_attribute6
  ,p_attribute7
  ,p_attribute8
  ,p_attribute9
  ,p_attribute10
  ,p_attribute11
  ,p_attribute12
  ,p_attribute13
  ,p_attribute14
  ,p_attribute15
  ,p_attribute16
  ,p_attribute17
  ,p_attribute18
  ,p_attribute19
  ,p_attribute20
  ,p_position_control_structure_f
  ,p_object_version_number
  );