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