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_PDM_UPD SQL Statements

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

Line: 48


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

Line: 61


  update per_person_dlvry_methods
  set
  delivery_method_id                = p_rec.delivery_method_id,
  date_start                        = p_rec.date_start,
  date_end                          = p_rec.date_end,
  comm_dlvry_method                 = p_rec.comm_dlvry_method,
  preferred_flag                    = p_rec.preferred_flag,
  object_version_number             = p_rec.object_version_number,
  request_id                        = p_rec.request_id,
  program_update_date               = p_rec.program_update_date,
  program_application_id            = p_rec.program_application_id,
  program_id                        = p_rec.program_id,
  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
  where delivery_method_id = p_rec.delivery_method_id;

Line: 113


End update_dml;

Line: 147


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

Line: 155


End pre_update;

Line: 189


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

Line: 202


    per_pdm_rku.after_update
      (
  p_delivery_method_id            =>p_rec.delivery_method_id
 ,p_date_start                    =>p_rec.date_start
 ,p_date_end                      =>p_rec.date_end
 ,p_comm_dlvry_method             =>p_rec.comm_dlvry_method
 ,p_preferred_flag                =>p_rec.preferred_flag
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_request_id                    =>p_rec.request_id
 ,p_program_update_date           =>p_rec.program_update_date
 ,p_program_application_id        =>p_rec.program_application_id
 ,p_program_id                    =>p_rec.program_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_effective_date                =>p_effective_date
 ,p_person_id_o                   =>per_pdm_shd.g_old_rec.person_id
 ,p_date_start_o                  =>per_pdm_shd.g_old_rec.date_start
 ,p_date_end_o                    =>per_pdm_shd.g_old_rec.date_end
 ,p_comm_dlvry_method_o           =>per_pdm_shd.g_old_rec.comm_dlvry_method
 ,p_preferred_flag_o              =>per_pdm_shd.g_old_rec.preferred_flag
 ,p_object_version_number_o       =>per_pdm_shd.g_old_rec.object_version_number
 ,p_request_id_o                  =>per_pdm_shd.g_old_rec.request_id
 ,p_program_update_date_o         =>per_pdm_shd.g_old_rec.program_update_date
 ,p_program_application_id_o      =>per_pdm_shd.g_old_rec.program_application_id
 ,p_program_id_o                  =>per_pdm_shd.g_old_rec.program_id
 ,p_attribute_category_o          =>per_pdm_shd.g_old_rec.attribute_category
 ,p_attribute1_o                  =>per_pdm_shd.g_old_rec.attribute1
 ,p_attribute2_o                  =>per_pdm_shd.g_old_rec.attribute2
 ,p_attribute3_o                  =>per_pdm_shd.g_old_rec.attribute3
 ,p_attribute4_o                  =>per_pdm_shd.g_old_rec.attribute4
 ,p_attribute5_o                  =>per_pdm_shd.g_old_rec.attribute5
 ,p_attribute6_o                  =>per_pdm_shd.g_old_rec.attribute6
 ,p_attribute7_o                  =>per_pdm_shd.g_old_rec.attribute7
 ,p_attribute8_o                  =>per_pdm_shd.g_old_rec.attribute8
 ,p_attribute9_o                  =>per_pdm_shd.g_old_rec.attribute9
 ,p_attribute10_o                 =>per_pdm_shd.g_old_rec.attribute10
 ,p_attribute11_o                 =>per_pdm_shd.g_old_rec.attribute11
 ,p_attribute12_o                 =>per_pdm_shd.g_old_rec.attribute12
 ,p_attribute13_o                 =>per_pdm_shd.g_old_rec.attribute13
 ,p_attribute14_o                 =>per_pdm_shd.g_old_rec.attribute14
 ,p_attribute15_o                 =>per_pdm_shd.g_old_rec.attribute15
 ,p_attribute16_o                 =>per_pdm_shd.g_old_rec.attribute16
 ,p_attribute17_o                 =>per_pdm_shd.g_old_rec.attribute17
 ,p_attribute18_o                 =>per_pdm_shd.g_old_rec.attribute18
 ,p_attribute19_o                 =>per_pdm_shd.g_old_rec.attribute19
 ,p_attribute20_o                 =>per_pdm_shd.g_old_rec.attribute20
      );

Line: 283


End post_update;

Line: 365


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

Line: 495


  per_pdm_bus.update_validate(p_rec, p_effective_date);

Line: 499


  pre_update(p_rec);

Line: 503


  update_dml(p_rec);

Line: 507


  post_update(
p_effective_date,p_rec);

Line: 524


  p_program_update_date          in date             default hr_api.g_date,
  p_program_application_id       in number           default hr_api.g_number,
  p_program_id                   in number           default hr_api.g_number,
  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
  ) is
--
  l_rec	  per_pdm_shd.g_rec_type;

Line: 570


  p_program_update_date,
  p_program_application_id,
  p_program_id,
  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
  );