1 package hr_se_work_incident_api as
2 /* $Header: peincsei.pkh 120.1 2006/10/11 15:40:14 rravi noship $ */
3 /*#
4 * This package contains work incident APIs for Sweden.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Work Incident for Sweden
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------------< create_se_work_incident >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a work incident record for a person in Sweden.
17 *
18 * The API does an alternative to the API create_work_incident. If p_validate is
19 * set to false, an work incident is created.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * Person must exist.
26 *
27 * <p><b>Post Success</b><br>
28 * The work incident will be successfully inserted into the database.
29 *
30 * <p><b>Post Failure</b><br>
31 * The API does not create the work incident and raises an error.
32 *
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_effective_date Reference date for validating lookup values are
37 * applicable during the start to end active date range. This date does not
38 * determine when the changes take effect.
39 * @param p_person_id Identifies the person for whom you create the work
40 * incident record.
41 * @param p_incident_reference Reference code for the incident record.
42 * @param p_incident_type The type of work incident that is being recorded.
43 * @param p_at_work_flag Indicates whether work incident occurred at work or en
44 * route.
45 * @param p_incident_date The date that the work incident occurred.
46 * @param p_incident_time The time that the incident occurred. (HH24:MI).
47 * @param p_org_notified_date The date that the organization was notified of
48 * the work incident.
49 * @param p_assignment_id Identifies the assignment for which you create the
50 * work incident record.
51 * @param p_location Location of incident.
52 * @param p_report_date The date the incident was reported.
53 * @param p_report_time The time the incident was reported. (HH24:MI).
54 * @param p_report_method The method by which the incident was reported.
55 * @param p_person_reported_by The id of the person who reported the work
56 * incident to the authorities.
57 * @param p_person_reported_to The name and contact details of the person (not
58 * held on HRMS) representing the authority that the incident has been reported
59 * to.
60 * @param p_witness_details The name and contact details of any witnesses to
61 * the work incident.
62 * @param p_description Description of the work incident.
63 * @param p_injury_type Type of injury suffered by the person in the work
64 * incident.
65 * @param p_disease_type Type of disease diagnosed as resulting from the work
66 * incident.
67 * @param p_hazard_type Object or substance involved in the work incident.
68 * @param p_body_part Details of the injured or diseased area of the person's
69 * anatomy.
70 * @param p_treatment_received_flag Indicates if medical treatment has been
71 * administered to the person.
72 * @param p_hospital_details Name and contact details of the hospital where
73 * treatment has been administered.
74 * @param p_emergency_code Indicates whether admitted to an emergency room.
75 * @param p_hospitalized_flag Indicates whether hospitalized.
76 * @param p_hospital_address Address of the hospital.
77 * @param p_activity_at_time_of_work Activity of the person at the time of the
78 * incident.
79 * @param p_objects_involved Objects or substances involved in the incident.
80 * @param p_privacy_issue Indicates whether the incident should be kept
81 * private.
82 * @param p_work_start_time Time the person started work (HH24:MI).
83 * @param p_date_of_death Date of persons death.
84 * @param p_report_completed_by Name of the person completing this incident.
85 * @param p_reporting_person_title Title of the person completing this
86 * incident.
87 * @param p_reporting_person_phone Phone number of the person completing this
88 * incident.
89 * @param p_days_restricted_work Number of days the person is on restricted
90 * work.
91 * @param p_days_away_from_work Number of days the person is away from work or
92 * on transfer.
93 * @param p_doctor_name Name of the medical practitioner coordinating the
94 * treatment of the person.
95 * @param p_compensation_date Date compensation was awarded.
96 * @param p_compensation_currency Currency (code) in which compensation was
97 * awarded.
98 * @param p_compensation_amount Amount of compensation awarded.
99 * @param p_remedial_hs_action Description of any corrective action that has
100 * been recommended by the health and safety representative.
101 * @param p_notified_hsrep_id The person id of the health and safety
102 * representative notified of the work incident.
103 * @param p_notified_hsrep_date The date the health and safety representative
104 * was notified.
105 * @param p_notified_rep_id The id of the person who has been notified of the
106 * work incident and who represents (by role) the representative body.
107 * @param p_notified_rep_date The date the representative body representative
108 * was notified.
109 * @param p_notified_rep_org_id The id (organization) of the notified
110 * representative body.
111 * @param p_related_incident_id The id of the work incident that is related to
112 * the current work incident.
113 * @param p_over_time_flag Indicates if the incident occurred over time.
114 * @param p_absence_exists_flag Indicates if person has been absent (not an
115 * HRMS absence) due to the incident. over time.
116 * @param p_attribute_category This context value determines which flexfield
117 * structure to use with the descriptive flexfield segments.
118 * @param p_attribute1 Descriptive flexfield segment.
119 * @param p_attribute2 Descriptive flexfield segment.
120 * @param p_attribute3 Descriptive flexfield segment.
121 * @param p_attribute4 Descriptive flexfield segment.
122 * @param p_attribute5 Descriptive flexfield segment.
123 * @param p_attribute6 Descriptive flexfield segment.
124 * @param p_attribute7 Descriptive flexfield segment.
125 * @param p_attribute8 Descriptive flexfield segment.
126 * @param p_attribute9 Descriptive flexfield segment.
127 * @param p_attribute10 Descriptive flexfield segment.
128 * @param p_attribute11 Descriptive flexfield segment.
129 * @param p_attribute12 Descriptive flexfield segment.
130 * @param p_attribute13 Descriptive flexfield segment.
131 * @param p_attribute14 Descriptive flexfield segment.
132 * @param p_attribute15 Descriptive flexfield segment.
133 * @param p_attribute16 Descriptive flexfield segment.
134 * @param p_attribute17 Descriptive flexfield segment.
135 * @param p_attribute18 Descriptive flexfield segment.
136 * @param p_attribute19 Descriptive flexfield segment.
137 * @param p_attribute20 Descriptive flexfield segment.
138 * @param p_attribute21 Descriptive flexfield segment.
139 * @param p_attribute22 Descriptive flexfield segment.
140 * @param p_attribute23 Descriptive flexfield segment.
141 * @param p_attribute24 Descriptive flexfield segment.
142 * @param p_attribute25 Descriptive flexfield segment.
143 * @param p_attribute26 Descriptive flexfield segment.
144 * @param p_attribute27 Descriptive flexfield segment.
145 * @param p_attribute28 Descriptive flexfield segment.
146 * @param p_attribute29 Descriptive flexfield segment.
147 * @param p_attribute30 Descriptive flexfield segment.
148 * @param p_employment_category The type of activity in which the company is
149 * involved.
150 * @param p_coverage_comm_date The Coverage Commencement Date for the person.
151 * @param p_coverage_expiry_date The Coverage Expirty Date for the person.
152 * @param p_personnel_category The Personal Category of the person.
153 * @param p_main_duties The Main Duties of the person.
154 * @param p_vessel_reg_number The Vessel Registration Number.
155 * @param p_main_activity The Main Activity of the person.
156 * @param p_accident_site_work The Accident Site, if different from workplace.
157 * @param p_accident_site_emp The Accident Site Employer, if different from
158 * workplace employer.
159 * @param p_equipment_materials The Equipment, Materials or Chemical used when
160 * Accident occurred.
161 * @param p_manufacturing_details The Manufacturing Details of Equipment.
162 * @param p_purpose_chemical The Purpose for using Chemical.
163 * @param p_chemical_equipment The chemical or equipment Name.
164 * @param p_circumstances The circumstances and cause of accident.
165 * @param p_type_of_injury The type of Injury or Illness sustained.
166 * @param p_affected_areas The affected areas of body.
167 * @param p_est_period_absence The estimated period of absence.
168 * @param p_num_sick_pay_days The number of sick pay days.
169 * @param p_safety_delegate The safety delegate notified?.
170 * @param p_reason_not_notify The reason for not notifying safety delegate.
171 * @param p_incident_id If p_validate is false, uniquely identifies the work.
172 * incident created. If p_validate is true, set to null.
173 * @param p_object_version_number If p_validate is false, then set to the
174 * version number of the created work incident. If p_validate is true, then
175 * the value will be null.
176 * @rep:displayname Create Work Incident for Sweden
177 * @rep:category BUSINESS_ENTITY PER_WORK_INCIDENT
178 * @rep:lifecycle active
179 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
180 * @rep:scope public
181 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
182 */
183 --
184 -- {End Of Comments}
185 --
186 --
187 procedure create_se_work_incident
188 (p_validate in boolean default false
189 ,p_effective_date in date
190 ,p_person_id in number
191 ,p_incident_reference in varchar2
192 ,p_incident_type in varchar2
193 ,p_at_work_flag in varchar2
194 ,p_incident_date in date
195 ,p_incident_time in varchar2 default null
196 ,p_org_notified_date in date default null
197 ,p_assignment_id in number default null
198 ,p_location in varchar2 default null
199 ,p_report_date in date default null
200 ,p_report_time in varchar2 default null
201 ,p_report_method in varchar2 default null
202 ,p_person_reported_by in number default null
203 ,p_person_reported_to in varchar2 default null
204 ,p_witness_details in varchar2 default null
205 ,p_description in varchar2 default null
206 ,p_injury_type in varchar2 default null
207 ,p_disease_type in varchar2 default null
208 ,p_hazard_type in varchar2 default null
209 ,p_body_part in varchar2 default null
210 ,p_treatment_received_flag in varchar2 default null
211 ,p_hospital_details in varchar2 default null
212 ,p_emergency_code in varchar2 default null
213 ,p_hospitalized_flag in varchar2 default null
214 ,p_hospital_address in varchar2 default null
215 ,p_activity_at_time_of_work in varchar2 default null
216 ,p_objects_involved in varchar2 default null
217 ,p_privacy_issue in varchar2 default null
218 ,p_work_start_time in varchar2 default null
219 ,p_date_of_death in date default null
220 ,p_report_completed_by in varchar2 default null
221 ,p_reporting_person_title in varchar2 default null
222 ,p_reporting_person_phone in varchar2 default null
223 ,p_days_restricted_work in number default null
224 ,p_days_away_from_work in number default null
225 ,p_doctor_name in varchar2 default null
226 ,p_compensation_date in date default null
227 ,p_compensation_currency in varchar2 default null
228 ,p_compensation_amount in number default null
229 ,p_remedial_hs_action in varchar2 default null
230 ,p_notified_hsrep_id in number default null
231 ,p_notified_hsrep_date in date default null
232 ,p_notified_rep_id in number default null
233 ,p_notified_rep_date in date default null
234 ,p_notified_rep_org_id in number default null
235 ,p_related_incident_id in number default null
236 ,p_over_time_flag in varchar2 default null
237 ,p_absence_exists_flag in varchar2 default null
238 ,p_attribute_category in varchar2 default null
239 ,p_attribute1 in varchar2 default null
240 ,p_attribute2 in varchar2 default null
241 ,p_attribute3 in varchar2 default null
242 ,p_attribute4 in varchar2 default null
243 ,p_attribute5 in varchar2 default null
244 ,p_attribute6 in varchar2 default null
245 ,p_attribute7 in varchar2 default null
246 ,p_attribute8 in varchar2 default null
247 ,p_attribute9 in varchar2 default null
248 ,p_attribute10 in varchar2 default null
249 ,p_attribute11 in varchar2 default null
250 ,p_attribute12 in varchar2 default null
251 ,p_attribute13 in varchar2 default null
252 ,p_attribute14 in varchar2 default null
253 ,p_attribute15 in varchar2 default null
254 ,p_attribute16 in varchar2 default null
255 ,p_attribute17 in varchar2 default null
256 ,p_attribute18 in varchar2 default null
257 ,p_attribute19 in varchar2 default null
258 ,p_attribute20 in varchar2 default null
259 ,p_attribute21 in varchar2 default null
260 ,p_attribute22 in varchar2 default null
261 ,p_attribute23 in varchar2 default null
262 ,p_attribute24 in varchar2 default null
263 ,p_attribute25 in varchar2 default null
264 ,p_attribute26 in varchar2 default null
265 ,p_attribute27 in varchar2 default null
266 ,p_attribute28 in varchar2 default null
267 ,p_attribute29 in varchar2 default null
268 ,p_attribute30 in varchar2 default null
269 ,p_employment_category in varchar2 default null
270 ,p_coverage_comm_date in varchar2 default null
271 ,p_coverage_expiry_date in varchar2 default null
272 ,p_personnel_category in varchar2 default null
273 ,p_main_duties in varchar2 default null
274 ,p_vessel_reg_number in varchar2 default null
275 ,p_main_activity in varchar2 default null
276 ,p_accident_site_work in varchar2 default null
277 ,p_accident_site_emp in varchar2 default null
278 ,p_equipment_materials in varchar2 default null
279 ,p_manufacturing_details in varchar2 default null
280 ,p_purpose_chemical in varchar2 default null
281 ,p_chemical_equipment in varchar2 default null
282 ,p_circumstances in varchar2 default null
283 ,p_type_of_injury in varchar2 default null
284 ,p_affected_areas in varchar2 default null
285 ,p_est_period_Absence in varchar2 default null
286 ,p_num_sick_pay_days in varchar2 default null
287 ,p_safety_delegate in varchar2 default null
288 ,p_reason_not_notify in varchar2 default null
289 ,p_incident_id out nocopy number
290 ,p_object_version_number out nocopy number
291 );
292 -- ----------------------------------------------------------------------------
293 -- |-------------------------< update_se_work_incident >----------------------|
294 -- ----------------------------------------------------------------------------
295 --
296 -- {Start Of Comments}
297 /*#
298 * This API contains work incident APIs
299 *
300 * The API updates a work incident record for a person as identified by
301 * p_incident_id.
302 *
303 * <p><b>Licensing</b><br>
304 * This API is licensed for use with Human Resources.
305 *
306 * <p><b>Prerequisites</b><br>
307 * The work incident record identified by p_incident_id and
308 * object_version_number must exist.
309 *
310 * <p><b>Post Success</b><br>
311 * The work incident record is successfully updated.
312 *
313 * <p><b>Post Failure</b><br>
314 * The API does not update the work incident and raises an error.
315 *
316 * @param p_validate If true, then validation alone will be performed and the
317 * database will remain unchanged. If false and all validation checks pass,
318 * then the database will be modified.
319 * @param p_effective_date Reference date for validating lookup values are
320 * applicable during the start to end active date range. This date does not
321 * determine when the changes take effect.
322 * @param p_incident_id Surrogate id of the incident record.
323 * @param p_object_version_number If p_validate is false, then set to the
324 * version number of the created work incident. If p_validate is true, then the
325 * value will be null.
326 * @param p_incident_reference Reference code for the incident record.
327 * @param p_incident_type The type of work incident that is being recorded.
328 * @param p_at_work_flag Indicates whether work incident occurred at work or en
329 * route.
330 * @param p_incident_date The date that the incident occurred.
331 * @param p_incident_time The time that the incident occurred. (HH24:MI).
332 * @param p_org_notified_date The date that the organization was notified of
333 * the work incident.
334 * @param p_assignment_id Identifies the assignment for which you update the
335 * work incident record.
336 * @param p_location Location of incident (not an HRMS location).
337 * @param p_report_date The date the incident was reported.
338 * @param p_report_time The time the incident was reported. (HH24:MI).
339 * @param p_report_method The method by which the incident was reported.
340 * @param p_person_reported_by The id if the person who reported the work
341 * incident to the authorities.
342 * @param p_person_reported_to The name and contact details of the person (not
343 * held on HRMS) representing the authority that the incident has been reported
344 * to.
345 * @param p_witness_details The name and contact details of any witnesses to
346 * the work incident.
347 * @param p_description Description of the work incident.
348 * @param p_injury_type Type of injury suffered by the person in the work
349 * incident.
350 * @param p_disease_type Type of disease diagnosed as resulting from the work
351 * incident.
352 * @param p_hazard_type Object or substance involved in the work incident.
353 * @param p_body_part Details of the injured or diseased area of the person's
354 * anatomy.
355 * @param p_treatment_received_flag Indicates if medical treatment has been
356 * administered to the person.
357 * @param p_hospital_details Name and contact details of the hospital where
358 * treatment has been administered.
359 * @param p_emergency_code Indicates whether admitted to an emergency room.
360 * @param p_hospitalized_flag Indicates whether hospitalized.
361 * @param p_hospital_address Address of the hospital.
362 * @param p_activity_at_time_of_work Activity of the person at the time of the
363 * incident.
364 * @param p_objects_involved Objects or substances involved in the incident.
365 * @param p_privacy_issue Indicates whether the incident should be kept
366 * private.
367 * @param p_work_start_time Time the person started work (HH24:MI).
368 * @param p_date_of_death Date of persons death.
369 * @param p_report_completed_by Name of the person completing this incident
370 * report.
371 * @param p_reporting_person_title Title of the person completing this incident
372 * report.
373 * @param p_reporting_person_phone Phone number of the person completing this
374 * incident report.
375 * @param p_days_restricted_work Number of days the person is on restricted
376 * work.
377 * @param p_days_away_from_work Number of days the person is away from work or
378 * on transfer.
379 * @param p_doctor_name Name of the medical practitioner coordinating the
380 * treatment of the person.
381 * @param p_compensation_date Date compensation was awarded.
382 * @param p_compensation_currency Currency (code) in which compensation was
383 * awarded.
384 * @param p_compensation_amount Amount of compensation awarded.
385 * @param p_remedial_hs_action Description of any corrective action that has
386 * been recommended by the health and safety representative.
387 * @param p_notified_hsrep_id The person id of the health and safety
388 * representative notified of the work incident.
389 * @param p_notified_hsrep_date The date the health and safety representative
390 * was notified.
391 * @param p_notified_rep_id The id of the person who has been notified of the
392 * work incident and who represents (by role) the representative body.
393 * @param p_notified_rep_date The date the representative body representative
394 * was notified.
395 * @param p_notified_rep_org_id The id (organization) of the notified
396 * representative body.
397 * @param p_related_incident_id The id of the work incident that is related to
398 * the current work incident.
399 * @param p_over_time_flag Indicates if the medical condition (injury or
400 * disease) occurred over time.
401 * @param p_absence_exists_flag Indicates if person has been absent (not an
402 * HRMS absence) due to the incident.
403 * @param p_attribute_category This context value determines which flexfield
404 * structure to use with the descriptive flexfield segments.
405 * @param p_attribute1 Descriptive flexfield segment.
406 * @param p_attribute2 Descriptive flexfield segment.
407 * @param p_attribute3 Descriptive flexfield segment.
408 * @param p_attribute4 Descriptive flexfield segment.
409 * @param p_attribute5 Descriptive flexfield segment.
410 * @param p_attribute6 Descriptive flexfield segment.
411 * @param p_attribute7 Descriptive flexfield segment.
412 * @param p_attribute8 Descriptive flexfield segment.
413 * @param p_attribute9 Descriptive flexfield segment.
414 * @param p_attribute10 Descriptive flexfield segment.
415 * @param p_attribute11 Descriptive flexfield segment.
416 * @param p_attribute12 Descriptive flexfield segment.
417 * @param p_attribute13 Descriptive flexfield segment.
418 * @param p_attribute14 Descriptive flexfield segment.
419 * @param p_attribute15 Descriptive flexfield segment.
420 * @param p_attribute16 Descriptive flexfield segment.
421 * @param p_attribute17 Descriptive flexfield segment.
422 * @param p_attribute18 Descriptive flexfield segment.
423 * @param p_attribute19 Descriptive flexfield segment.
424 * @param p_attribute20 Descriptive flexfield segment.
425 * @param p_attribute21 Descriptive flexfield segment.
426 * @param p_attribute22 Descriptive flexfield segment.
427 * @param p_attribute23 Descriptive flexfield segment.
428 * @param p_attribute24 Descriptive flexfield segment.
429 * @param p_attribute25 Descriptive flexfield segment.
430 * @param p_attribute26 Descriptive flexfield segment.
431 * @param p_attribute27 Descriptive flexfield segment.
432 * @param p_attribute28 Descriptive flexfield segment.
433 * @param p_attribute29 Descriptive flexfield segment.
434 * @param p_attribute30 Descriptive flexfield segment.
435 * @param p_employment_category The type of activity in which the company is
436 * involved.
437 * @param p_coverage_comm_date The Coverage Commencement Date for the person.
438 * @param p_coverage_expiry_date The Coverage Expirty Date for the person.
439 * @param p_personnel_category The Personal Category of the person.
440 * @param p_main_duties The Main Duties of the person.
441 * @param p_vessel_reg_number The Vessel Registration Number.
442 * @param p_main_activity The Main Activity of the person.
443 * @param p_accident_site_work The Accident Site, if different from workplace.
444 * @param p_accident_site_emp The Accident Site Employer, if different from
445 * workplace employer.
446 * @param p_equipment_materials The Equipment, Materials or Chemical used
447 * when Accident occurred.
448 * @param p_manufacturing_details The Manufacturing Details of Equipment.
449 * @param p_purpose_chemical The Purpose for using Chemical.
450 * @param p_chemical_equipment The chemical or equipment Name.
451 * @param p_circumstances The circumstances and cause of accident.
452 * @param p_type_of_injury The type of Injury or Illness sustained.
453 * @param p_affected_areas The affected areas of body.
454 * @param p_est_period_absence The estimated period of absence.
455 * @param p_num_sick_pay_days The number of sick pay days.
456 * @param p_safety_delegate The safety delegate notified?.
457 * @param p_reason_not_notify The reason for not notifying safety delegate.
458 * @rep:displayname Update Work Incident for Sweden
459 * @rep:category BUSINESS_ENTITY PER_WORK_INCIDENT
460 * @rep:lifecycle active
461 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
462 * @rep:scope public
463 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
464 */
465 --
466 -- {End Of Comments}
467 --
468 procedure update_se_work_incident
469 (p_validate in boolean default false
470 ,p_effective_date in date
471 ,p_incident_id in number
472 ,p_object_version_number in out nocopy number
473 ,p_incident_reference in varchar2 default hr_api.g_varchar2
474 ,p_incident_type in varchar2 default hr_api.g_varchar2
475 ,p_at_work_flag in varchar2 default hr_api.g_varchar2
476 ,p_incident_date in date default hr_api.g_date
477 ,p_incident_time in varchar2 default hr_api.g_varchar2
478 ,p_org_notified_date in date default hr_api.g_date
479 ,p_assignment_id in number default hr_api.g_number
480 ,p_location in varchar2 default hr_api.g_varchar2
481 ,p_report_date in date default hr_api.g_date
482 ,p_report_time in varchar2 default hr_api.g_varchar2
483 ,p_report_method in varchar2 default hr_api.g_varchar2
484 ,p_person_reported_by in number default hr_api.g_number
485 ,p_person_reported_to in varchar2 default hr_api.g_varchar2
486 ,p_witness_details in varchar2 default hr_api.g_varchar2
487 ,p_description in varchar2 default hr_api.g_varchar2
488 ,p_injury_type in varchar2 default hr_api.g_varchar2
489 ,p_disease_type in varchar2 default hr_api.g_varchar2
490 ,p_hazard_type in varchar2 default hr_api.g_varchar2
491 ,p_body_part in varchar2 default hr_api.g_varchar2
492 ,p_treatment_received_flag in varchar2 default hr_api.g_varchar2
493 ,p_hospital_details in varchar2 default hr_api.g_varchar2
494 ,p_emergency_code in varchar2 default hr_api.g_varchar2
495 ,p_hospitalized_flag in varchar2 default hr_api.g_varchar2
496 ,p_hospital_address in varchar2 default hr_api.g_varchar2
497 ,p_activity_at_time_of_work in varchar2 default hr_api.g_varchar2
498 ,p_objects_involved in varchar2 default hr_api.g_varchar2
499 ,p_privacy_issue in varchar2 default hr_api.g_varchar2
500 ,p_work_start_time in varchar2 default hr_api.g_varchar2
501 ,p_date_of_death in date default hr_api.g_date
502 ,p_report_completed_by in varchar2 default hr_api.g_varchar2
503 ,p_reporting_person_title in varchar2 default hr_api.g_varchar2
504 ,p_reporting_person_phone in varchar2 default hr_api.g_varchar2
505 ,p_days_restricted_work in number default hr_api.g_number
506 ,p_days_away_from_work in number default hr_api.g_number
507 ,p_doctor_name in varchar2 default hr_api.g_varchar2
508 ,p_compensation_date in date default hr_api.g_date
509 ,p_compensation_currency in varchar2 default hr_api.g_varchar2
510 ,p_compensation_amount in number default hr_api.g_number
511 ,p_remedial_hs_action in varchar2 default hr_api.g_varchar2
512 ,p_notified_hsrep_id in number default hr_api.g_number
513 ,p_notified_hsrep_date in date default hr_api.g_date
514 ,p_notified_rep_id in number default hr_api.g_number
515 ,p_notified_rep_date in date default hr_api.g_date
516 ,p_notified_rep_org_id in number default hr_api.g_number
517 ,p_related_incident_id in number default hr_api.g_number
518 ,p_over_time_flag in varchar2 default hr_api.g_varchar2
519 ,p_absence_exists_flag in varchar2 default hr_api.g_varchar2
520 ,p_attribute_category in varchar2 default hr_api.g_varchar2
521 ,p_attribute1 in varchar2 default hr_api.g_varchar2
522 ,p_attribute2 in varchar2 default hr_api.g_varchar2
523 ,p_attribute3 in varchar2 default hr_api.g_varchar2
524 ,p_attribute4 in varchar2 default hr_api.g_varchar2
525 ,p_attribute5 in varchar2 default hr_api.g_varchar2
526 ,p_attribute6 in varchar2 default hr_api.g_varchar2
527 ,p_attribute7 in varchar2 default hr_api.g_varchar2
528 ,p_attribute8 in varchar2 default hr_api.g_varchar2
529 ,p_attribute9 in varchar2 default hr_api.g_varchar2
530 ,p_attribute10 in varchar2 default hr_api.g_varchar2
531 ,p_attribute11 in varchar2 default hr_api.g_varchar2
532 ,p_attribute12 in varchar2 default hr_api.g_varchar2
533 ,p_attribute13 in varchar2 default hr_api.g_varchar2
534 ,p_attribute14 in varchar2 default hr_api.g_varchar2
535 ,p_attribute15 in varchar2 default hr_api.g_varchar2
536 ,p_attribute16 in varchar2 default hr_api.g_varchar2
537 ,p_attribute17 in varchar2 default hr_api.g_varchar2
538 ,p_attribute18 in varchar2 default hr_api.g_varchar2
539 ,p_attribute19 in varchar2 default hr_api.g_varchar2
540 ,p_attribute20 in varchar2 default hr_api.g_varchar2
541 ,p_attribute21 in varchar2 default hr_api.g_varchar2
542 ,p_attribute22 in varchar2 default hr_api.g_varchar2
543 ,p_attribute23 in varchar2 default hr_api.g_varchar2
544 ,p_attribute24 in varchar2 default hr_api.g_varchar2
545 ,p_attribute25 in varchar2 default hr_api.g_varchar2
546 ,p_attribute26 in varchar2 default hr_api.g_varchar2
547 ,p_attribute27 in varchar2 default hr_api.g_varchar2
548 ,p_attribute28 in varchar2 default hr_api.g_varchar2
549 ,p_attribute29 in varchar2 default hr_api.g_varchar2
550 ,p_attribute30 in varchar2 default hr_api.g_varchar2
551 ,p_employment_category in varchar2 default hr_api.g_varchar2
552 ,p_coverage_comm_date in varchar2 default hr_api.g_varchar2
553 ,p_coverage_expiry_date in varchar2 default hr_api.g_varchar2
554 ,p_personnel_category in varchar2 default hr_api.g_varchar2
555 ,p_main_duties in varchar2 default hr_api.g_varchar2
556 ,p_vessel_reg_number in varchar2 default hr_api.g_varchar2
557 ,p_main_activity in varchar2 default hr_api.g_varchar2
558 ,p_accident_site_work in varchar2 default hr_api.g_varchar2
559 ,p_accident_site_emp in varchar2 default hr_api.g_varchar2
560 ,p_equipment_materials in varchar2 default hr_api.g_varchar2
561 ,p_manufacturing_details in varchar2 default hr_api.g_varchar2
562 ,p_purpose_chemical in varchar2 default hr_api.g_varchar2
563 ,p_chemical_equipment in varchar2 default hr_api.g_varchar2
564 ,p_circumstances in varchar2 default hr_api.g_varchar2
565 ,p_type_of_injury in varchar2 default hr_api.g_varchar2
566 ,p_affected_areas in varchar2 default hr_api.g_varchar2
567 ,p_est_period_Absence in varchar2 default hr_api.g_varchar2
568 ,p_num_sick_pay_days in varchar2 default hr_api.g_varchar2
569 ,p_safety_delegate in varchar2 default hr_api.g_varchar2
570 ,p_reason_not_notify in varchar2 default hr_api.g_varchar2
571 );
572
573 end hr_se_work_incident_api;
574
[Home] [Help]