124: --
125: -- {End Of Comments}
126: -- ---------------------------------------------------------------------------
127: PROCEDURE chk_incident_reference
128: (p_incident_id in per_work_incidents.incident_id%TYPE
129: ,p_incident_reference in per_work_incidents.incident_reference%TYPE
130: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
131: );
132: --
125: -- {End Of Comments}
126: -- ---------------------------------------------------------------------------
127: PROCEDURE chk_incident_reference
128: (p_incident_id in per_work_incidents.incident_id%TYPE
129: ,p_incident_reference in per_work_incidents.incident_reference%TYPE
130: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
131: );
132: --
133: -- ----------------------------------------------------------------------------
126: -- ---------------------------------------------------------------------------
127: PROCEDURE chk_incident_reference
128: (p_incident_id in per_work_incidents.incident_id%TYPE
129: ,p_incident_reference in per_work_incidents.incident_reference%TYPE
130: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
131: );
132: --
133: -- ----------------------------------------------------------------------------
134: -- |---------------------------< insert_validate >----------------------------|
265: -- {End Of Comments}
266: --
267: --
268: procedure chk_person_reported_date_time
269: (p_incident_id in per_work_incidents.incident_id%TYPE
270: ,p_incident_date in per_work_incidents.incident_date%TYPE
271: ,p_incident_time in per_work_incidents.incident_time%TYPE
272: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
273: ,p_report_date in per_work_incidents.report_date%TYPE
266: --
267: --
268: procedure chk_person_reported_date_time
269: (p_incident_id in per_work_incidents.incident_id%TYPE
270: ,p_incident_date in per_work_incidents.incident_date%TYPE
271: ,p_incident_time in per_work_incidents.incident_time%TYPE
272: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
273: ,p_report_date in per_work_incidents.report_date%TYPE
274: ,p_report_time in per_work_incidents.report_time%TYPE
267: --
268: procedure chk_person_reported_date_time
269: (p_incident_id in per_work_incidents.incident_id%TYPE
270: ,p_incident_date in per_work_incidents.incident_date%TYPE
271: ,p_incident_time in per_work_incidents.incident_time%TYPE
272: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
273: ,p_report_date in per_work_incidents.report_date%TYPE
274: ,p_report_time in per_work_incidents.report_time%TYPE
275: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
268: procedure chk_person_reported_date_time
269: (p_incident_id in per_work_incidents.incident_id%TYPE
270: ,p_incident_date in per_work_incidents.incident_date%TYPE
271: ,p_incident_time in per_work_incidents.incident_time%TYPE
272: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
273: ,p_report_date in per_work_incidents.report_date%TYPE
274: ,p_report_time in per_work_incidents.report_time%TYPE
275: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
276: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
269: (p_incident_id in per_work_incidents.incident_id%TYPE
270: ,p_incident_date in per_work_incidents.incident_date%TYPE
271: ,p_incident_time in per_work_incidents.incident_time%TYPE
272: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
273: ,p_report_date in per_work_incidents.report_date%TYPE
274: ,p_report_time in per_work_incidents.report_time%TYPE
275: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
276: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
277: --
270: ,p_incident_date in per_work_incidents.incident_date%TYPE
271: ,p_incident_time in per_work_incidents.incident_time%TYPE
272: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
273: ,p_report_date in per_work_incidents.report_date%TYPE
274: ,p_report_time in per_work_incidents.report_time%TYPE
275: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
276: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
277: --
278: -- ----------------------------------------------------------------------------
272: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
273: ,p_report_date in per_work_incidents.report_date%TYPE
274: ,p_report_time in per_work_incidents.report_time%TYPE
275: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
276: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
277: --
278: -- ----------------------------------------------------------------------------
279: -- |----------------------< chk_notified_hsrep_and_date >----------------------|
280: -- ----------------------------------------------------------------------------
286: -- {End Of Comments}
287: --
288: --
289: procedure chk_notified_hsrep_and_date
290: (p_incident_id in per_work_incidents.incident_id%TYPE
291: ,p_incident_date in per_work_incidents.incident_date%TYPE
292: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
293: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
294: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
287: --
288: --
289: procedure chk_notified_hsrep_and_date
290: (p_incident_id in per_work_incidents.incident_id%TYPE
291: ,p_incident_date in per_work_incidents.incident_date%TYPE
292: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
293: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
294: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
295: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
288: --
289: procedure chk_notified_hsrep_and_date
290: (p_incident_id in per_work_incidents.incident_id%TYPE
291: ,p_incident_date in per_work_incidents.incident_date%TYPE
292: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
293: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
294: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
295: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
296: --
289: procedure chk_notified_hsrep_and_date
290: (p_incident_id in per_work_incidents.incident_id%TYPE
291: ,p_incident_date in per_work_incidents.incident_date%TYPE
292: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
293: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
294: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
295: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
296: --
297: --
291: ,p_incident_date in per_work_incidents.incident_date%TYPE
292: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
293: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
294: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
295: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
296: --
297: --
298: -- ----------------------------------------------------------------------------
299: -- |----------------------< chk_notified_rep_org_date >------------------------|
307: -- {End Of Comments}
308: --
309: --
310: procedure chk_notified_rep_org_date
311: (p_incident_id in per_work_incidents.incident_id%TYPE
312: ,p_incident_date in per_work_incidents.incident_date%TYPE
313: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
314: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
315: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
308: --
309: --
310: procedure chk_notified_rep_org_date
311: (p_incident_id in per_work_incidents.incident_id%TYPE
312: ,p_incident_date in per_work_incidents.incident_date%TYPE
313: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
314: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
315: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
316: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
309: --
310: procedure chk_notified_rep_org_date
311: (p_incident_id in per_work_incidents.incident_id%TYPE
312: ,p_incident_date in per_work_incidents.incident_date%TYPE
313: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
314: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
315: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
316: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
317: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
310: procedure chk_notified_rep_org_date
311: (p_incident_id in per_work_incidents.incident_id%TYPE
312: ,p_incident_date in per_work_incidents.incident_date%TYPE
313: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
314: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
315: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
316: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
317: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
318: --
311: (p_incident_id in per_work_incidents.incident_id%TYPE
312: ,p_incident_date in per_work_incidents.incident_date%TYPE
313: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
314: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
315: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
316: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
317: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
318: --
319: --
313: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
314: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
315: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
316: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
317: ,p_object_version_number in per_work_incidents.object_version_number%TYPE);
318: --
319: --
320: -- ----------------------------------------------------------------------------
321: -- |-------------------------< create_osha_numbers >--------------------------|