[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_work_incident
(p_validate in boolean default false
,p_effective_date in date
,p_incident_id in number
,p_object_version_number in out nocopy number
,p_incident_reference in varchar2 default hr_api.g_varchar2
,p_incident_type in varchar2 default hr_api.g_varchar2
,p_at_work_flag in varchar2 default hr_api.g_varchar2
,p_incident_date in date default hr_api.g_date
,p_incident_time in varchar2 default hr_api.g_varchar2
,p_org_notified_date in date default hr_api.g_date
,p_assignment_id in number default hr_api.g_number
,p_location in varchar2 default hr_api.g_varchar2
,p_report_date in date default hr_api.g_date
,p_report_time in varchar2 default hr_api.g_varchar2
,p_report_method in varchar2 default hr_api.g_varchar2
,p_person_reported_by in number default hr_api.g_number
,p_person_reported_to in varchar2 default hr_api.g_varchar2
,p_witness_details in varchar2 default hr_api.g_varchar2
,p_description in varchar2 default hr_api.g_varchar2
,p_injury_type in varchar2 default hr_api.g_varchar2
,p_disease_type in varchar2 default hr_api.g_varchar2
,p_hazard_type in varchar2 default hr_api.g_varchar2
,p_body_part in varchar2 default hr_api.g_varchar2
,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
,p_hospital_details in varchar2 default hr_api.g_varchar2
,p_emergency_code in varchar2 default hr_api.g_varchar2
,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
,p_hospital_address in varchar2 default hr_api.g_varchar2
,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
,p_objects_involved in varchar2 default hr_api.g_varchar2
,p_privacy_issue in varchar2 default hr_api.g_varchar2
,p_work_start_time in varchar2 default hr_api.g_varchar2
,p_date_of_death in date default hr_api.g_date
,p_report_completed_by in varchar2 default hr_api.g_varchar2
,p_reporting_person_title in varchar2 default hr_api.g_varchar2
,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
,p_days_restricted_work in number default hr_api.g_number
,p_days_away_from_work in number default hr_api.g_number
,p_doctor_name in varchar2 default hr_api.g_varchar2
,p_compensation_date in date default hr_api.g_date
,p_compensation_currency in varchar2 default hr_api.g_varchar2
,p_compensation_amount in number default hr_api.g_number
,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
,p_notified_hsrep_id in number default hr_api.g_number
,p_notified_hsrep_date in date default hr_api.g_date
,p_notified_rep_id in number default hr_api.g_number
,p_notified_rep_date in date default hr_api.g_date
,p_notified_rep_org_id in number default hr_api.g_number
,p_related_incident_id in number default hr_api.g_number
,p_over_time_flag in varchar2 default hr_api.g_varchar2
,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
,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_attribute21 in varchar2 default hr_api.g_varchar2
,p_attribute22 in varchar2 default hr_api.g_varchar2
,p_attribute23 in varchar2 default hr_api.g_varchar2
,p_attribute24 in varchar2 default hr_api.g_varchar2
,p_attribute25 in varchar2 default hr_api.g_varchar2
,p_attribute26 in varchar2 default hr_api.g_varchar2
,p_attribute27 in varchar2 default hr_api.g_varchar2
,p_attribute28 in varchar2 default hr_api.g_varchar2
,p_attribute29 in varchar2 default hr_api.g_varchar2
,p_attribute30 in varchar2 default hr_api.g_varchar2
,p_inc_information_category in varchar2 default hr_api.g_varchar2
,p_inc_information1 in varchar2 default hr_api.g_varchar2
,p_inc_information2 in varchar2 default hr_api.g_varchar2
,p_inc_information3 in varchar2 default hr_api.g_varchar2
,p_inc_information4 in varchar2 default hr_api.g_varchar2
,p_inc_information5 in varchar2 default hr_api.g_varchar2
,p_inc_information6 in varchar2 default hr_api.g_varchar2
,p_inc_information7 in varchar2 default hr_api.g_varchar2
,p_inc_information8 in varchar2 default hr_api.g_varchar2
,p_inc_information9 in varchar2 default hr_api.g_varchar2
,p_inc_information10 in varchar2 default hr_api.g_varchar2
,p_inc_information11 in varchar2 default hr_api.g_varchar2
,p_inc_information12 in varchar2 default hr_api.g_varchar2
,p_inc_information13 in varchar2 default hr_api.g_varchar2
,p_inc_information14 in varchar2 default hr_api.g_varchar2
,p_inc_information15 in varchar2 default hr_api.g_varchar2
,p_inc_information16 in varchar2 default hr_api.g_varchar2
,p_inc_information17 in varchar2 default hr_api.g_varchar2
,p_inc_information18 in varchar2 default hr_api.g_varchar2
,p_inc_information19 in varchar2 default hr_api.g_varchar2
,p_inc_information20 in varchar2 default hr_api.g_varchar2
,p_inc_information21 in varchar2 default hr_api.g_varchar2
,p_inc_information22 in varchar2 default hr_api.g_varchar2
,p_inc_information23 in varchar2 default hr_api.g_varchar2
,p_inc_information24 in varchar2 default hr_api.g_varchar2
,p_inc_information25 in varchar2 default hr_api.g_varchar2
,p_inc_information26 in varchar2 default hr_api.g_varchar2
,p_inc_information27 in varchar2 default hr_api.g_varchar2
,p_inc_information28 in varchar2 default hr_api.g_varchar2
,p_inc_information29 in varchar2 default hr_api.g_varchar2
,p_inc_information30 in varchar2 default hr_api.g_varchar2
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_work_incident';
savepoint update_work_incident;
per_work_incident_bk2.update_work_incident_b
(p_effective_date => l_effective_date
,p_incident_id => p_incident_id
,p_object_version_number => p_object_version_number
,p_incident_reference => p_incident_reference
,p_incident_type => p_incident_type
,p_at_work_flag => p_at_work_flag
,p_incident_date => l_incident_date
,p_incident_time => p_incident_time
,p_org_notified_date => l_org_notified_date
,p_assignment_id => p_assignment_id
,p_location => p_location
,p_report_date => p_report_date
,p_report_time => p_report_time
,p_report_method => p_report_method
,p_person_reported_by => p_person_reported_by
,p_person_reported_to => p_person_reported_to
,p_witness_details => p_witness_details
,p_description => p_description
,p_injury_type => p_injury_type
,p_disease_type => p_disease_type
,p_hazard_type => p_hazard_type
,p_body_part => p_body_part
,p_treatment_received_flag => p_treatment_received_flag
,p_hospital_details => p_hospital_details
,p_emergency_code => p_emergency_code
,p_hospitalized_flag => p_hospitalized_flag
,p_hospital_address => p_hospital_address
,p_activity_at_time_of_work => p_activity_at_time_of_work
,p_objects_involved => p_objects_involved
,p_privacy_issue => p_privacy_issue
,p_work_start_time => p_work_start_time
,p_date_of_death => p_date_of_death
,p_report_completed_by => p_report_completed_by
,p_reporting_person_title => p_reporting_person_title
,p_reporting_person_phone => p_reporting_person_phone
,p_days_restricted_work => p_days_restricted_work
,p_days_away_from_work => p_days_away_from_work
,p_doctor_name => p_doctor_name
,p_compensation_date => p_compensation_date
,p_compensation_currency => p_compensation_currency
,p_compensation_amount => p_compensation_amount
,p_remedial_hs_action => p_remedial_hs_action
,p_notified_hsrep_id => p_notified_hsrep_id
,p_notified_hsrep_date => p_notified_hsrep_date
,p_notified_rep_id => p_notified_rep_id
,p_notified_rep_date => p_notified_rep_date
,p_notified_rep_org_id => p_notified_rep_org_id
,p_related_incident_id => p_related_incident_id
,p_over_time_flag => p_over_time_flag
,p_absence_exists_flag => p_absence_exists_flag
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_inc_information_category => p_inc_information_category
,p_inc_information1 => p_inc_information1
,p_inc_information2 => p_inc_information2
,p_inc_information3 => p_inc_information3
,p_inc_information4 => p_inc_information4
,p_inc_information5 => p_inc_information5
,p_inc_information6 => p_inc_information6
,p_inc_information7 => p_inc_information7
,p_inc_information8 => p_inc_information8
,p_inc_information9 => p_inc_information9
,p_inc_information10 => p_inc_information10
,p_inc_information11 => p_inc_information11
,p_inc_information12 => p_inc_information12
,p_inc_information13 => p_inc_information13
,p_inc_information14 => p_inc_information14
,p_inc_information15 => p_inc_information15
,p_inc_information16 => p_inc_information16
,p_inc_information17 => p_inc_information17
,p_inc_information18 => p_inc_information18
,p_inc_information19 => p_inc_information19
,p_inc_information20 => p_inc_information20
,p_inc_information21 => p_inc_information21
,p_inc_information22 => p_inc_information22
,p_inc_information23 => p_inc_information23
,p_inc_information24 => p_inc_information24
,p_inc_information25 => p_inc_information25
,p_inc_information26 => p_inc_information26
,p_inc_information27 => p_inc_information27
,p_inc_information28 => p_inc_information28
,p_inc_information29 => p_inc_information29
,p_inc_information30 => p_inc_information30
);
(p_module_name => 'update_work_incident_b'
,p_hook_type => 'BP'
);
per_work_incident_bk2.update_work_incident_a
(p_effective_date => l_effective_date
,p_incident_id => p_incident_id
,p_object_version_number => l_object_version_number
,p_incident_reference => p_incident_reference
,p_incident_type => p_incident_type
,p_at_work_flag => p_at_work_flag
,p_incident_date => l_incident_date
,p_incident_time => p_incident_time
,p_org_notified_date => l_org_notified_date
,p_assignment_id => p_assignment_id
,p_location => p_location
,p_report_date => p_report_date
,p_report_time => p_report_time
,p_report_method => p_report_method
,p_person_reported_by => p_person_reported_by
,p_person_reported_to => p_person_reported_to
,p_witness_details => p_witness_details
,p_description => p_description
,p_injury_type => p_injury_type
,p_disease_type => p_disease_type
,p_hazard_type => p_hazard_type
,p_body_part => p_body_part
,p_treatment_received_flag => p_treatment_received_flag
,p_hospital_details => p_hospital_details
,p_emergency_code => p_emergency_code
,p_hospitalized_flag => p_hospitalized_flag
,p_hospital_address => p_hospital_address
,p_activity_at_time_of_work => p_activity_at_time_of_work
,p_objects_involved => p_objects_involved
,p_privacy_issue => p_privacy_issue
,p_work_start_time => p_work_start_time
,p_date_of_death => p_date_of_death
,p_report_completed_by => p_report_completed_by
,p_reporting_person_title => p_reporting_person_title
,p_reporting_person_phone => p_reporting_person_phone
,p_days_restricted_work => p_days_restricted_work
,p_days_away_from_work => p_days_away_from_work
,p_doctor_name => p_doctor_name
,p_compensation_date => p_compensation_date
,p_compensation_currency => p_compensation_currency
,p_compensation_amount => p_compensation_amount
,p_remedial_hs_action => p_remedial_hs_action
,p_notified_hsrep_id => p_notified_hsrep_id
,p_notified_hsrep_date => p_notified_hsrep_date
,p_notified_rep_id => p_notified_rep_id
,p_notified_rep_date => p_notified_rep_date
,p_notified_rep_org_id => p_notified_rep_org_id
,p_related_incident_id => p_related_incident_id
,p_over_time_flag => p_over_time_flag
,p_absence_exists_flag => p_absence_exists_flag
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_inc_information_category => p_inc_information_category
,p_inc_information1 => p_inc_information1
,p_inc_information2 => p_inc_information2
,p_inc_information3 => p_inc_information3
,p_inc_information4 => p_inc_information4
,p_inc_information5 => p_inc_information5
,p_inc_information6 => p_inc_information6
,p_inc_information7 => p_inc_information7
,p_inc_information8 => p_inc_information8
,p_inc_information9 => p_inc_information9
,p_inc_information10 => p_inc_information10
,p_inc_information11 => p_inc_information11
,p_inc_information12 => p_inc_information12
,p_inc_information13 => p_inc_information13
,p_inc_information14 => p_inc_information14
,p_inc_information15 => p_inc_information15
,p_inc_information16 => p_inc_information16
,p_inc_information17 => p_inc_information17
,p_inc_information18 => p_inc_information18
,p_inc_information19 => p_inc_information19
,p_inc_information20 => p_inc_information20
,p_inc_information21 => p_inc_information21
,p_inc_information22 => p_inc_information22
,p_inc_information23 => p_inc_information23
,p_inc_information24 => p_inc_information24
,p_inc_information25 => p_inc_information25
,p_inc_information26 => p_inc_information26
,p_inc_information27 => p_inc_information27
,p_inc_information28 => p_inc_information28
,p_inc_information29 => p_inc_information29
,p_inc_information30 => p_inc_information30
);
(p_module_name => 'update_work_incident_a'
,p_hook_type => 'AP'
);
rollback to update_work_incident;
rollback to update_work_incident;
end update_work_incident;
procedure delete_work_incident
(p_validate in boolean default false
,p_incident_id in number
,p_object_version_number in number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_work_incident';
savepoint delete_work_incident;
per_work_incident_bk3.delete_work_incident_b
(p_incident_id => p_incident_id,
p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_work_incident_b',
p_hook_type => 'BP'
);
per_work_incident_bk3.delete_work_incident_a
(p_incident_id => p_incident_id,
p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_work_incident_a',
p_hook_type => 'AP'
);
ROLLBACK TO delete_work_incident;
ROLLBACK TO delete_work_incident;
end delete_work_incident;