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

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

Line: 51


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

Line: 62


  delete from per_periods_of_service
  where  period_of_service_id  = p_rec.period_of_service_id
  and    object_version_number = p_rec.object_version_number;

Line: 79


End delete_dml;

Line: 113


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

Line: 121


End pre_delete;

Line: 155


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

Line: 164


    per_pds_rkd.after_delete
    (
     p_period_of_service_id         =>p_rec.period_of_service_id
    ,p_business_group_id_o          =>per_pds_shd.g_old_rec.business_group_id
    ,p_person_id_o                  =>per_pds_shd.g_old_rec.person_id
    ,p_terminat_accepted_person_o   =>per_pds_shd.g_old_rec.termination_accepted_person_id
    ,p_date_start_o                 =>per_pds_shd.g_old_rec.date_start
    ,p_accepted_termination_date_o  =>per_pds_shd.g_old_rec.accepted_termination_date
    ,p_actual_termination_date_o    =>per_pds_shd.g_old_rec.actual_termination_date
    ,p_comments_o                   =>per_pds_shd.g_old_rec.comments
    ,p_adjusted_svc_date_o          =>per_pds_shd.g_old_rec.adjusted_svc_date
    ,p_final_process_date_o         =>per_pds_shd.g_old_rec.final_process_date
    ,p_last_standard_process_date_o =>per_pds_shd.g_old_rec.last_standard_process_date
    ,p_leaving_reason_o             =>per_pds_shd.g_old_rec.leaving_reason
    ,p_notified_termination_date_o  =>per_pds_shd.g_old_rec.notified_termination_date
    ,p_projected_termination_date_o =>per_pds_shd.g_old_rec.projected_termination_date
    ,p_request_id_o                 =>per_pds_shd.g_old_rec.request_id
    ,p_program_application_id_o     =>per_pds_shd.g_old_rec.program_application_id
    ,p_program_id_o                 =>per_pds_shd.g_old_rec.program_id
    ,p_program_update_date_o        =>per_pds_shd.g_old_rec.program_update_date
    ,p_attribute_category_o         =>per_pds_shd.g_old_rec.attribute_category
    ,p_attribute1_o                 =>per_pds_shd.g_old_rec.attribute1
    ,p_attribute2_o                 =>per_pds_shd.g_old_rec.attribute2
    ,p_attribute3_o                 =>per_pds_shd.g_old_rec.attribute3
    ,p_attribute4_o                 =>per_pds_shd.g_old_rec.attribute4
    ,p_attribute5_o                 =>per_pds_shd.g_old_rec.attribute5
    ,p_attribute6_o                 =>per_pds_shd.g_old_rec.attribute6
    ,p_attribute7_o                 =>per_pds_shd.g_old_rec.attribute7
    ,p_attribute8_o                 =>per_pds_shd.g_old_rec.attribute8
    ,p_attribute9_o                 =>per_pds_shd.g_old_rec.attribute9
    ,p_attribute10_o                =>per_pds_shd.g_old_rec.attribute10
    ,p_attribute11_o                =>per_pds_shd.g_old_rec.attribute11
    ,p_attribute12_o                =>per_pds_shd.g_old_rec.attribute12
    ,p_attribute13_o                =>per_pds_shd.g_old_rec.attribute13
    ,p_attribute14_o                =>per_pds_shd.g_old_rec.attribute14
    ,p_attribute15_o                =>per_pds_shd.g_old_rec.attribute15
    ,p_attribute16_o                =>per_pds_shd.g_old_rec.attribute16
    ,p_attribute17_o                =>per_pds_shd.g_old_rec.attribute17
    ,p_attribute18_o                =>per_pds_shd.g_old_rec.attribute18
    ,p_attribute19_o                =>per_pds_shd.g_old_rec.attribute19
    ,p_attribute20_o                =>per_pds_shd.g_old_rec.attribute20
    ,p_object_version_number_o      =>per_pds_shd.g_old_rec.object_version_number
    ,p_prior_employment_ssp_weeks_o =>per_pds_shd.g_old_rec.prior_employment_ssp_weeks
    ,p_prior_employmt_ssp_paid_to_o =>per_pds_shd.g_old_rec.prior_employment_ssp_paid_to
    ,p_pds_information_category_o    =>per_pds_shd.g_old_rec.pds_information_category
    ,p_pds_information1_o            =>per_pds_shd.g_old_rec.pds_information1
    ,p_pds_information2_o            =>per_pds_shd.g_old_rec.pds_information2
    ,p_pds_information3_o            =>per_pds_shd.g_old_rec.pds_information3
    ,p_pds_information4_o            =>per_pds_shd.g_old_rec.pds_information4
    ,p_pds_information5_o            =>per_pds_shd.g_old_rec.pds_information5
    ,p_pds_information6_o            =>per_pds_shd.g_old_rec.pds_information6
    ,p_pds_information7_o            =>per_pds_shd.g_old_rec.pds_information7
    ,p_pds_information8_o            =>per_pds_shd.g_old_rec.pds_information8
    ,p_pds_information9_o            =>per_pds_shd.g_old_rec.pds_information9
    ,p_pds_information10_o           =>per_pds_shd.g_old_rec.pds_information10
    ,p_pds_information11_o           =>per_pds_shd.g_old_rec.pds_information11
    ,p_pds_information12_o           =>per_pds_shd.g_old_rec.pds_information12
    ,p_pds_information13_o           =>per_pds_shd.g_old_rec.pds_information13
    ,p_pds_information14_o           =>per_pds_shd.g_old_rec.pds_information14
    ,p_pds_information15_o           =>per_pds_shd.g_old_rec.pds_information15
    ,p_pds_information16_o           =>per_pds_shd.g_old_rec.pds_information16
    ,p_pds_information17_o           =>per_pds_shd.g_old_rec.pds_information17
    ,p_pds_information18_o           =>per_pds_shd.g_old_rec.pds_information18
    ,p_pds_information19_o           =>per_pds_shd.g_old_rec.pds_information19
    ,p_pds_information20_o           =>per_pds_shd.g_old_rec.pds_information20
    ,p_pds_information21_o           =>per_pds_shd.g_old_rec.pds_information21
    ,p_pds_information22_o           =>per_pds_shd.g_old_rec.pds_information22
    ,p_pds_information23_o           =>per_pds_shd.g_old_rec.pds_information23
    ,p_pds_information24_o           =>per_pds_shd.g_old_rec.pds_information24
    ,p_pds_information25_o           =>per_pds_shd.g_old_rec.pds_information25
    ,p_pds_information26_o           =>per_pds_shd.g_old_rec.pds_information26
    ,p_pds_information27_o           =>per_pds_shd.g_old_rec.pds_information27
    ,p_pds_information28_o           =>per_pds_shd.g_old_rec.pds_information28
    ,p_pds_information29_o           =>per_pds_shd.g_old_rec.pds_information29
    ,p_pds_information30_o           =>per_pds_shd.g_old_rec.pds_information30
     );

Line: 249


End post_delete;

Line: 284


  per_pds_bus.delete_validate(p_rec);

Line: 288


  pre_delete(p_rec);

Line: 292


  delete_dml(p_rec);

Line: 296


  post_delete(p_rec);