[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select per.business_group_id
from per_all_people_f per
where per.person_id = p_person_id
and p_effective_date between per.effective_start_date
and per.effective_end_date;
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = l_business_group_id;
procedure update_sa_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_date_wage_stop in varchar2 default hr_api.g_varchar2
,p_patient_number in varchar2 default hr_api.g_varchar2
,p_admission_date in varchar2 default hr_api.g_varchar2
,p_hospitalised_from in varchar2 default hr_api.g_varchar2
,p_hospitalised_to in varchar2 default hr_api.g_varchar2
,p_rest_home_from in varchar2 default hr_api.g_varchar2
,p_rest_home_to in varchar2 default hr_api.g_varchar2
,p_number_external_visits in varchar2 default hr_api.g_varchar2
,p_days_violated_med in varchar2 default hr_api.g_varchar2
,p_violation_type in varchar2 default hr_api.g_varchar2
,p_days_escorted in varchar2 default hr_api.g_varchar2
,p_date_commenced in varchar2 default hr_api.g_varchar2
) is
--
-- Declare cursors and local variables
--
l_business_group_id per_contracts_f.business_group_id%TYPE;
l_proc varchar2(72) := g_package||'update_sa_work_incident';
select per.business_group_id
from per_all_people_f per
where per.person_id = (select person_id
from per_work_incidents
where incident_id = p_incident_id)
and p_effective_date between per.effective_start_date
and per.effective_end_date;
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = l_business_group_id;
savepoint update_sa_work_incident;
per_work_incident_api.update_work_incident
(p_validate => p_validate
,p_effective_date => p_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 => p_incident_date
,p_incident_time => p_incident_time
,p_org_notified_date => p_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 => 'SA'
,p_inc_information1 => p_date_wage_stop
,p_inc_information2 => p_patient_number
,p_inc_information3 => p_admission_date
,p_inc_information4 => p_hospitalised_from
,p_inc_information5 => p_hospitalised_to
,p_inc_information6 => p_rest_home_from
,p_inc_information7 => p_rest_home_to
,p_inc_information8 => p_number_external_visits
,p_inc_information9 => p_days_violated_med
,p_inc_information10 => p_violation_type
,p_inc_information11 => p_days_escorted
,p_inc_information12 => p_date_commenced
);
end update_sa_work_incident;