DBA Data[Home] [Help]

APPS.PER_INC_BUS dependencies on PER_WORK_INCIDENTS

Line 128: (p_incident_id in per_work_incidents.incident_id%TYPE

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: --

Line 129: ,p_incident_reference in per_work_incidents.incident_reference%TYPE

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: -- ----------------------------------------------------------------------------

Line 130: ,p_object_version_number in per_work_incidents.object_version_number%TYPE

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 >----------------------------|

Line 269: (p_incident_id in per_work_incidents.incident_id%TYPE

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

Line 270: ,p_incident_date in per_work_incidents.incident_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

Line 271: ,p_incident_time in per_work_incidents.incident_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

Line 272: ,p_person_reported_by in per_work_incidents.person_reported_by%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);

Line 273: ,p_report_date in per_work_incidents.report_date%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: --

Line 274: ,p_report_time in per_work_incidents.report_time%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: --
278: -- ----------------------------------------------------------------------------

Line 276: ,p_object_version_number in per_work_incidents.object_version_number%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: -- ----------------------------------------------------------------------------
279: -- |----------------------< chk_notified_hsrep_and_date >----------------------|
280: -- ----------------------------------------------------------------------------

Line 290: (p_incident_id in per_work_incidents.incident_id%TYPE

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

Line 291: ,p_incident_date in per_work_incidents.incident_date%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);

Line 292: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%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: --

Line 293: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE

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: --

Line 295: ,p_object_version_number in per_work_incidents.object_version_number%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: --
298: -- ----------------------------------------------------------------------------
299: -- |----------------------< chk_notified_rep_org_date >------------------------|

Line 311: (p_incident_id in per_work_incidents.incident_id%TYPE

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

Line 312: ,p_incident_date in per_work_incidents.incident_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

Line 313: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_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);

Line 314: ,p_notified_rep_id in per_work_incidents.notified_rep_id%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: --

Line 315: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE

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: --

Line 317: ,p_object_version_number in per_work_incidents.object_version_number%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: --
320: -- ----------------------------------------------------------------------------
321: -- |-------------------------< create_osha_numbers >--------------------------|