[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml
(p_rec in per_inc_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from per_work_incidents
where incident_id = p_rec.incident_id;
End delete_dml;
Procedure pre_delete(p_rec in per_inc_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(p_rec in per_inc_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
per_inc_rkd.after_delete
(p_incident_id
=> p_rec.incident_id
,p_person_id_o
=> per_inc_shd.g_old_rec.person_id
,p_incident_reference_o
=> per_inc_shd.g_old_rec.incident_reference
,p_incident_type_o
=> per_inc_shd.g_old_rec.incident_type
,p_incident_date_o
=> per_inc_shd.g_old_rec.incident_date
,p_incident_time_o
=> per_inc_shd.g_old_rec.incident_time
,p_org_notified_date_o
=> per_inc_shd.g_old_rec.org_notified_date
,p_assignment_id_o
=> per_inc_shd.g_old_rec.assignment_id
,p_location_o
=> per_inc_shd.g_old_rec.location
,p_at_work_flag_o
=> per_inc_shd.g_old_rec.at_work_flag
,p_report_date_o
=> per_inc_shd.g_old_rec.report_date
,p_report_time_o
=> per_inc_shd.g_old_rec.report_time
,p_report_method_o
=> per_inc_shd.g_old_rec.report_method
,p_person_reported_by_o
=> per_inc_shd.g_old_rec.person_reported_by
,p_person_reported_to_o
=> per_inc_shd.g_old_rec.person_reported_to
,p_witness_details_o
=> per_inc_shd.g_old_rec.witness_details
,p_description_o
=> per_inc_shd.g_old_rec.description
,p_injury_type_o
=> per_inc_shd.g_old_rec.injury_type
,p_disease_type_o
=> per_inc_shd.g_old_rec.disease_type
,p_hazard_type_o
=> per_inc_shd.g_old_rec.hazard_type
,p_body_part_o
=> per_inc_shd.g_old_rec.body_part
,p_treatment_received_flag_o
=> per_inc_shd.g_old_rec.treatment_received_flag
,p_hospital_details_o
=> per_inc_shd.g_old_rec.hospital_details
,p_emergency_code_o => per_inc_shd.g_old_rec.emergency_code
,p_hospitalized_flag_o => per_inc_shd.g_old_rec.hospitalized_flag
,p_hospital_address_o => per_inc_shd.g_old_rec.hospital_address
,p_activity_at_time_of_work_o => per_inc_shd.g_old_rec.activity_at_time_of_work
,p_objects_involved_o => per_inc_shd.g_old_rec.objects_involved
,p_privacy_issue_o => per_inc_shd.g_old_rec.privacy_issue
,p_work_start_time_o => per_inc_shd.g_old_rec.work_start_time
,p_date_of_death_o => per_inc_shd.g_old_rec.date_of_death
,p_report_completed_by_o => per_inc_shd.g_old_rec.report_completed_by
,p_reporting_person_title_o => per_inc_shd.g_old_rec.reporting_person_title
,p_reporting_person_phone_o => per_inc_shd.g_old_rec.reporting_person_phone
,p_days_restricted_work_o => per_inc_shd.g_old_rec.days_restricted_work
,p_days_away_from_work_o => per_inc_shd.g_old_rec.days_away_from_work
,p_doctor_name_o
=> per_inc_shd.g_old_rec.doctor_name
,p_compensation_date_o
=> per_inc_shd.g_old_rec.compensation_date
,p_compensation_currency_o
=> per_inc_shd.g_old_rec.compensation_currency
,p_compensation_amount_o
=> per_inc_shd.g_old_rec.compensation_amount
,p_remedial_hs_action_o
=> per_inc_shd.g_old_rec.remedial_hs_action
,p_notified_hsrep_id_o
=> per_inc_shd.g_old_rec.notified_hsrep_id
,p_notified_hsrep_date_o
=> per_inc_shd.g_old_rec.notified_hsrep_date
,p_notified_rep_id_o
=> per_inc_shd.g_old_rec.notified_rep_id
,p_notified_rep_date_o
=> per_inc_shd.g_old_rec.notified_rep_date
,p_notified_rep_org_id_o
=> per_inc_shd.g_old_rec.notified_rep_org_id
,p_related_incident_id_o
=> per_inc_shd.g_old_rec.related_incident_id
,p_over_time_flag_o
=> per_inc_shd.g_old_rec.over_time_flag
,p_absence_exists_flag_o
=> per_inc_shd.g_old_rec.absence_exists_flag
,p_attribute_category_o
=> per_inc_shd.g_old_rec.attribute_category
,p_attribute1_o
=> per_inc_shd.g_old_rec.attribute1
,p_attribute2_o
=> per_inc_shd.g_old_rec.attribute2
,p_attribute3_o
=> per_inc_shd.g_old_rec.attribute3
,p_attribute4_o
=> per_inc_shd.g_old_rec.attribute4
,p_attribute5_o
=> per_inc_shd.g_old_rec.attribute5
,p_attribute6_o
=> per_inc_shd.g_old_rec.attribute6
,p_attribute7_o
=> per_inc_shd.g_old_rec.attribute7
,p_attribute8_o
=> per_inc_shd.g_old_rec.attribute8
,p_attribute9_o
=> per_inc_shd.g_old_rec.attribute9
,p_attribute10_o
=> per_inc_shd.g_old_rec.attribute10
,p_attribute11_o
=> per_inc_shd.g_old_rec.attribute11
,p_attribute12_o
=> per_inc_shd.g_old_rec.attribute12
,p_attribute13_o
=> per_inc_shd.g_old_rec.attribute13
,p_attribute14_o
=> per_inc_shd.g_old_rec.attribute14
,p_attribute15_o
=> per_inc_shd.g_old_rec.attribute15
,p_attribute16_o
=> per_inc_shd.g_old_rec.attribute16
,p_attribute17_o
=> per_inc_shd.g_old_rec.attribute17
,p_attribute18_o
=> per_inc_shd.g_old_rec.attribute18
,p_attribute19_o
=> per_inc_shd.g_old_rec.attribute19
,p_attribute20_o
=> per_inc_shd.g_old_rec.attribute20
,p_attribute21_o
=> per_inc_shd.g_old_rec.attribute21
,p_attribute22_o
=> per_inc_shd.g_old_rec.attribute22
,p_attribute23_o
=> per_inc_shd.g_old_rec.attribute23
,p_attribute24_o
=> per_inc_shd.g_old_rec.attribute24
,p_attribute25_o
=> per_inc_shd.g_old_rec.attribute25
,p_attribute26_o
=> per_inc_shd.g_old_rec.attribute26
,p_attribute27_o
=> per_inc_shd.g_old_rec.attribute27
,p_attribute28_o
=> per_inc_shd.g_old_rec.attribute28
,p_attribute29_o
=> per_inc_shd.g_old_rec.attribute29
,p_attribute30_o
=> per_inc_shd.g_old_rec.attribute30
,p_inc_information_category_o
=> per_inc_shd.g_old_rec.inc_information_category
,p_inc_information1_o
=> per_inc_shd.g_old_rec.inc_information1
,p_inc_information2_o
=> per_inc_shd.g_old_rec.inc_information2
,p_inc_information3_o
=> per_inc_shd.g_old_rec.inc_information3
,p_inc_information4_o
=> per_inc_shd.g_old_rec.inc_information4
,p_inc_information5_o
=> per_inc_shd.g_old_rec.inc_information5
,p_inc_information6_o
=> per_inc_shd.g_old_rec.inc_information6
,p_inc_information7_o
=> per_inc_shd.g_old_rec.inc_information7
,p_inc_information8_o
=> per_inc_shd.g_old_rec.inc_information8
,p_inc_information9_o
=> per_inc_shd.g_old_rec.inc_information9
,p_inc_information10_o
=> per_inc_shd.g_old_rec.inc_information10
,p_inc_information11_o
=> per_inc_shd.g_old_rec.inc_information11
,p_inc_information12_o
=> per_inc_shd.g_old_rec.inc_information12
,p_inc_information13_o
=> per_inc_shd.g_old_rec.inc_information13
,p_inc_information14_o
=> per_inc_shd.g_old_rec.inc_information14
,p_inc_information15_o
=> per_inc_shd.g_old_rec.inc_information15
,p_inc_information16_o
=> per_inc_shd.g_old_rec.inc_information16
,p_inc_information17_o
=> per_inc_shd.g_old_rec.inc_information17
,p_inc_information18_o
=> per_inc_shd.g_old_rec.inc_information18
,p_inc_information19_o
=> per_inc_shd.g_old_rec.inc_information19
,p_inc_information20_o
=> per_inc_shd.g_old_rec.inc_information20
,p_inc_information21_o
=> per_inc_shd.g_old_rec.inc_information21
,p_inc_information22_o
=> per_inc_shd.g_old_rec.inc_information22
,p_inc_information23_o
=> per_inc_shd.g_old_rec.inc_information23
,p_inc_information24_o
=> per_inc_shd.g_old_rec.inc_information24
,p_inc_information25_o
=> per_inc_shd.g_old_rec.inc_information25
,p_inc_information26_o
=> per_inc_shd.g_old_rec.inc_information26
,p_inc_information27_o
=> per_inc_shd.g_old_rec.inc_information27
,p_inc_information28_o
=> per_inc_shd.g_old_rec.inc_information28
,p_inc_information29_o
=> per_inc_shd.g_old_rec.inc_information29
,p_inc_information30_o
=> per_inc_shd.g_old_rec.inc_information30
,p_object_version_number_o
=> per_inc_shd.g_old_rec.object_version_number
);
End post_delete;
per_inc_bus.delete_validate(p_rec);
per_inc_del.pre_delete(p_rec);
per_inc_del.delete_dml(p_rec);
per_inc_del.post_delete(p_rec);