[Home] [Help]
PACKAGE: APPS.EAM_PROCESS_SAFETY_PUB
Source
1 PACKAGE EAM_PROCESS_SAFETY_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPSAPS.pls 120.1 2011/07/28 15:07:58 vboddapa noship $ */
3
4 /***************************************************************************
5 --
6 -- Copyright (c) 2011 Oracle Corporation, Redwood Shores, CA, USA
7 -- All rights reserved.
8 --
9 -- FILENAME: EAMPSAPS.pls
10 --
11 -- DESCRIPTION: Spec of package EAM_PROCESS_SAFETY_PUB
12 --
13 -- NOTES
14 --
15 -- HISTORY
16 --
17 --
18 ***************************************************************************/
19
20 Type eam_iso_header_rec_type is record
21 ( HEADER_ID NUMBER :=NULL,
22 BATCH_ID NUMBER := NULL,
23 ROW_ID NUMBER := NULL,
24 TRANSACTION_TYPE NUMBER := NULL,
25 ISOLATION_ID NUMBER := NULL,
26 ISOLATION_NAME VARCHAR2(240) := NULL,
27 DESCRIPTION VARCHAR2(240) := NULL,
28 ORGANIZATION_ID NUMBER := NULL,
29 ISOLATION_TYPE NUMBER := NULL,
30 SYSTEM_STATUS NUMBER := NULL,
31 USER_DEFINED_STATUS NUMBER := NULL,
32 PENDING_FLAG VARCHAR2(1) :=NULL,
33 EFFECTIVE_START_DATE DATE :=NULL,
34 EFFECTIVE_END_DATE DATE :=NULL,
35 COPY_FROM_ISOLATION NUMBER :=NULL,
36 COPY_FROM_WORK_CLEARANCE NUMBER :=NULL,
37 ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL,
38 ATTRIBUTE1 VARCHAR2(240) :=NULL,
39 ATTRIBUTE2 VARCHAR2(240) :=NULL,
40 ATTRIBUTE3 VARCHAR2(240) :=NULL,
41 ATTRIBUTE4 VARCHAR2(240) :=NULL,
42 ATTRIBUTE5 VARCHAR2(240) :=NULL,
43 ATTRIBUTE6 VARCHAR2(240) :=NULL,
44 ATTRIBUTE7 VARCHAR2(240) :=NULL,
45 ATTRIBUTE8 VARCHAR2(240) :=NULL,
46 ATTRIBUTE9 VARCHAR2(240) :=NULL,
47 ATTRIBUTE10 VARCHAR2(240) :=NULL,
48 ATTRIBUTE11 VARCHAR2(240) :=NULL,
49 ATTRIBUTE12 VARCHAR2(240) :=NULL,
50 ATTRIBUTE13 VARCHAR2(240) :=NULL,
51 ATTRIBUTE14 VARCHAR2(240) :=NULL,
52 ATTRIBUTE15 VARCHAR2(240) :=NULL,
53 ATTRIBUTE16 VARCHAR2(240) :=NULL,
54 ATTRIBUTE17 VARCHAR2(240) :=NULL,
55 ATTRIBUTE18 VARCHAR2(240) :=NULL,
56 ATTRIBUTE19 VARCHAR2(240) :=NULL,
57 ATTRIBUTE20 VARCHAR2(240) :=NULL,
58 ATTRIBUTE21 VARCHAR2(240) :=NULL,
59 ATTRIBUTE22 VARCHAR2(240) :=NULL,
60 ATTRIBUTE23 VARCHAR2(240) :=NULL,
61 ATTRIBUTE24 VARCHAR2(240) :=NULL,
62 ATTRIBUTE25 VARCHAR2(240) :=NULL,
63 ATTRIBUTE26 VARCHAR2(240) :=NULL,
64 ATTRIBUTE27 VARCHAR2(240) :=NULL,
65 ATTRIBUTE28 VARCHAR2(240) :=NULL,
66 ATTRIBUTE29 VARCHAR2(240) :=NULL,
67 ATTRIBUTE30 VARCHAR2(240) :=NULL,
68 APPROVED_BY NUMBER :=NULL,
69 PERMIT_REQUIRED VARCHAR2(1) :=NULL,
70 CREATED_BY NUMBER :=NULL,
71 CREATION_DATE DATE :=NULL,
72 USER_ID NUMBER :=NULL,
73 RESPONSIBILITY_ID NUMBER :=NULL
74 );
75
76
77 Type eam_clearance_header_rec_type IS record
78 (
79 HEADER_ID NUMBER :=NULL,
80 BATCH_ID NUMBER :=NULL,
81 ROW_ID NUMBER :=NULL,
82 WORK_CLEARANCE_ID NUMBER :=NULL,
83 WORK_CLEARANCE_NAME VARCHAR2(240) :=NULL,
84 DESCRIPTION VARCHAR2(240) :=NULL,
85 ORGANIZATION_ID NUMBER :=NULL,
86 ISOLATION_ID NUMBER :=NULL,
87 SYSTEM_STATUS NUMBER :=NULL,
88 USER_DEFINED_STATUS NUMBER :=NULL,
89 PENDING_FLAG VARCHAR2(1) :=NULL,
90 SCHEDULED_ESTAB_START_DATE DATE :=NULL,
91 SCHEDULED_ESTAB_END_DATE DATE :=NULL,
92 SCHEDULED_REESTAB_START_DATE DATE :=NULL,
93 SCHEDULED_REESTAB_END_DATE DATE :=NULL,
94 COMPLETION_DATE DATE :=NULL,
95 TRANSACTION_TYPE NUMBER :=NULL,
96 PERMIT_REQUIRED VARCHAR2(1) :=NULL,
97 ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL,
98 ATTRIBUTE1 VARCHAR2(240) :=NULL,
99 ATTRIBUTE2 VARCHAR2(240) :=NULL,
100 ATTRIBUTE3 VARCHAR2(240) :=NULL,
101 ATTRIBUTE4 VARCHAR2(240) :=NULL,
102 ATTRIBUTE5 VARCHAR2(240) :=NULL,
103 ATTRIBUTE6 VARCHAR2(240) :=NULL,
104 ATTRIBUTE7 VARCHAR2(240) :=NULL,
105 ATTRIBUTE8 VARCHAR2(240) :=NULL,
106 ATTRIBUTE9 VARCHAR2(240) :=NULL,
107 ATTRIBUTE10 VARCHAR2(240) :=NULL,
108 ATTRIBUTE11 VARCHAR2(240) :=NULL,
109 ATTRIBUTE12 VARCHAR2(240) :=NULL,
110 ATTRIBUTE13 VARCHAR2(240) :=NULL,
111 ATTRIBUTE14 VARCHAR2(240) :=NULL,
112 ATTRIBUTE15 VARCHAR2(240) :=NULL,
113 ATTRIBUTE16 VARCHAR2(240) :=NULL,
114 ATTRIBUTE17 VARCHAR2(240) :=NULL,
115 ATTRIBUTE18 VARCHAR2(240) :=NULL,
116 ATTRIBUTE19 VARCHAR2(240) :=NULL,
117 ATTRIBUTE20 VARCHAR2(240) :=NULL,
118 ATTRIBUTE21 VARCHAR2(240) :=NULL,
119 ATTRIBUTE22 VARCHAR2(240) :=NULL,
120 ATTRIBUTE23 VARCHAR2(240) :=NULL,
121 ATTRIBUTE24 VARCHAR2(240) :=NULL,
122 ATTRIBUTE25 VARCHAR2(240) :=NULL,
123 ATTRIBUTE26 VARCHAR2(240) :=NULL,
124 ATTRIBUTE27 VARCHAR2(240) :=NULL,
125 ATTRIBUTE28 VARCHAR2(240) :=NULL,
126 ATTRIBUTE29 VARCHAR2(240) :=NULL,
127 ATTRIBUTE30 VARCHAR2(240) :=NULL,
128 APPROVED_BY NUMBER :=NULL,
129 CREATED_BY NUMBER :=NULL,
130 CREATION_DATE DATE :=NULL,
131 USER_ID NUMBER :=NULL,
132 RESPONSIBILITY_ID NUMBER :=NULL
133 );
134
135 Type eam_wp_header_rec_type is record
136 (
137 HEADER_ID NUMBER :=NULL,
138 BATCH_ID NUMBER :=NULL,
139 ROW_ID NUMBER :=NULL,
140 TRANSACTION_TYPE NUMBER :=NULL,
141 PERMIT_ID NUMBER :=NULL,
142 PERMIT_NAME VARCHAR2(240) :=NULL,
143 PERMIT_TYPE NUMBER :=NULL,
144 DESCRIPTION VARCHAR2(240) :=NULL,
145 ORGANIZATION_ID NUMBER :=NULL,
146 STATUS_TYPE NUMBER :=NULL, --lookup
147 VALID_FROM DATE :=NULL,
148 VALID_TO DATE :=NULL,
149 PENDING_FLAG VARCHAR2(1) :=NULL,
150 COMPLETION_DATE DATE :=NULL,
151 USER_DEFINED_STATUS_ID NUMBER :=NULL,
152 ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL,
153 ATTRIBUTE1 VARCHAR2(240) :=NULL,
154 ATTRIBUTE2 VARCHAR2(240) :=NULL,
155 ATTRIBUTE3 VARCHAR2(240) :=NULL,
156 ATTRIBUTE4 VARCHAR2(240) :=NULL,
157 ATTRIBUTE5 VARCHAR2(240) :=NULL,
158 ATTRIBUTE6 VARCHAR2(240) :=NULL,
159 ATTRIBUTE7 VARCHAR2(240) :=NULL,
160 ATTRIBUTE8 VARCHAR2(240) :=NULL,
161 ATTRIBUTE9 VARCHAR2(240) :=NULL,
162 ATTRIBUTE10 VARCHAR2(240) :=NULL,
163 ATTRIBUTE11 VARCHAR2(240) :=NULL,
164 ATTRIBUTE12 VARCHAR2(240) :=NULL,
165 ATTRIBUTE13 VARCHAR2(240) :=NULL,
166 ATTRIBUTE14 VARCHAR2(240) :=NULL,
167 ATTRIBUTE15 VARCHAR2(240) :=NULL,
168 ATTRIBUTE16 VARCHAR2(240) :=NULL,
169 ATTRIBUTE17 VARCHAR2(240) :=NULL,
170 ATTRIBUTE18 VARCHAR2(240) :=NULL,
171 ATTRIBUTE19 VARCHAR2(240) :=NULL,
172 ATTRIBUTE20 VARCHAR2(240) :=NULL,
173 ATTRIBUTE21 VARCHAR2(240) :=NULL,
174 ATTRIBUTE22 VARCHAR2(240) :=NULL,
175 ATTRIBUTE23 VARCHAR2(240) :=NULL,
176 ATTRIBUTE24 VARCHAR2(240) :=NULL,
177 ATTRIBUTE25 VARCHAR2(240) :=NULL,
178 ATTRIBUTE26 VARCHAR2(240) :=NULL,
179 ATTRIBUTE27 VARCHAR2(240) :=NULL,
180 ATTRIBUTE28 VARCHAR2(240) :=NULL,
181 ATTRIBUTE29 VARCHAR2(240) :=NULL,
182 ATTRIBUTE30 VARCHAR2(240) :=NULL,
183 APPROVED_BY NUMBER :=NULL,
184 CREATED_BY NUMBER :=NULL,
185 CREATION_DATE DATE :=NULL,
186 USER_ID NUMBER :=NULL,
187 RESPONSIBILITY_ID NUMBER :=NULL
188 );
189
190
191 Type eam_establishment_rec_type IS record
192 (
193 HEADER_ID NUMBER :=NULL,
194 BATCH_ID NUMBER :=NULL,
195 ROW_ID NUMBER :=NULL,
196 ESTABLISHMENT_ID NUMBER :=NULL,
197 ESTABLISHMENT_SOURCE NUMBER :=NULL,
198 ESTABLISHMENT_SOURCE_ID NUMBER :=NULL,
199 SEQUENCE_TYPE NUMBER :=NULL,
200 SEQUENCE_NUMBER NUMBER :=NULL,
201 ORGANIZATION_ID NUMBER :=NULL,
202 DESCRIPTION VARCHAR2(240) :=NULL,
203 MAINTENANCE_OBJECT_ID NUMBER :=NULL,
204 TAG_POSITION NUMBER :=NULL,
205 SAFETY_TAG NUMBER :=NULL,
206 LOCKOUT_DEVICE NUMBER :=NULL,
207 TRANSACTION_TYPE NUMBER :=NULL,
208 DEPT_ID NUMBER :=NULL,
209 RESOURCE_ID NUMBER :=NULL,
210 RES_INSTANCE_ID NUMBER :=NULL,
211 LOCK_NUMBER NUMBER :=NULL,
212 COMPLETION_DATE DATE :=NULL,
213 ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL,
214 ATTRIBUTE1 VARCHAR2(240) :=NULL,
215 ATTRIBUTE2 VARCHAR2(240) :=NULL,
216 ATTRIBUTE3 VARCHAR2(240) :=NULL,
217 ATTRIBUTE4 VARCHAR2(240) :=NULL,
218 ATTRIBUTE5 VARCHAR2(240) :=NULL,
219 ATTRIBUTE6 VARCHAR2(240) :=NULL,
220 ATTRIBUTE7 VARCHAR2(240) :=NULL,
221 ATTRIBUTE8 VARCHAR2(240) :=NULL,
222 ATTRIBUTE9 VARCHAR2(240) :=NULL,
223 ATTRIBUTE10 VARCHAR2(240) :=NULL,
224 ATTRIBUTE11 VARCHAR2(240) :=NULL,
225 ATTRIBUTE12 VARCHAR2(240) :=NULL,
226 ATTRIBUTE13 VARCHAR2(240) :=NULL,
227 ATTRIBUTE14 VARCHAR2(240) :=NULL,
228 ATTRIBUTE15 VARCHAR2(240) :=NULL,
229 ATTRIBUTE16 VARCHAR2(240) :=NULL,
230 ATTRIBUTE17 VARCHAR2(240) :=NULL,
231 ATTRIBUTE18 VARCHAR2(240) :=NULL,
232 ATTRIBUTE19 VARCHAR2(240) :=NULL,
233 ATTRIBUTE20 VARCHAR2(240) :=NULL,
234 ATTRIBUTE21 VARCHAR2(240) :=NULL,
235 ATTRIBUTE22 VARCHAR2(240) :=NULL,
236 ATTRIBUTE23 VARCHAR2(240) :=NULL,
237 ATTRIBUTE24 VARCHAR2(240) :=NULL,
238 ATTRIBUTE25 VARCHAR2(240) :=NULL,
239 ATTRIBUTE26 VARCHAR2(240) :=NULL,
240 ATTRIBUTE27 VARCHAR2(240) :=NULL,
241 ATTRIBUTE28 VARCHAR2(240) :=NULL,
242 ATTRIBUTE29 VARCHAR2(240) :=NULL,
243 ATTRIBUTE30 VARCHAR2(240) :=NULL,
244 CREATED_BY NUMBER :=NULL,
245 CREATION_DATE DATE :=NULL
246 );
247
248 Type eam_safety_assoc_rec_type is record
249 (
250 HEADER_ID NUMBER :=NULL,
254 SAFETY_ASSOCIATION_ID NUMBER :=NULL,
251 BATCH_ID NUMBER :=NULL,
252 ROW_ID NUMBER :=NULL,
253 TRANSACTION_TYPE NUMBER :=NULL,
255 SOURCE_ID NUMBER :=NULL,
256 TARGET_REF_ID NUMBER :=NULL,
257 ASSOCIATION_TYPE NUMBER :=NULL,
258 EFFECTIVE_FROM DATE :=NULL,
259 EFFECTIVE_TO DATE :=NULL,
260 ORGANIZATION_ID NUMBER :=NULL,
261 ENABLED VARCHAR2(3) :=NULL,
262 COMMENTS VARCHAR2(240) :=NULL,
263 ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL,
264 ATTRIBUTE1 VARCHAR2(240) :=NULL,
265 ATTRIBUTE2 VARCHAR2(240) :=NULL,
266 ATTRIBUTE3 VARCHAR2(240) :=NULL,
267 ATTRIBUTE4 VARCHAR2(240) :=NULL,
268 ATTRIBUTE5 VARCHAR2(240) :=NULL,
269 ATTRIBUTE6 VARCHAR2(240) :=NULL,
270 ATTRIBUTE7 VARCHAR2(240) :=NULL,
271 ATTRIBUTE8 VARCHAR2(240) :=NULL,
272 ATTRIBUTE9 VARCHAR2(240) :=NULL,
273 ATTRIBUTE10 VARCHAR2(240) :=NULL,
274 ATTRIBUTE11 VARCHAR2(240) :=NULL,
275 ATTRIBUTE12 VARCHAR2(240) :=NULL,
276 ATTRIBUTE13 VARCHAR2(240) :=NULL,
277 ATTRIBUTE14 VARCHAR2(240) :=NULL,
278 ATTRIBUTE15 VARCHAR2(240) :=NULL,
279 ATTRIBUTE16 VARCHAR2(240) :=NULL,
280 ATTRIBUTE17 VARCHAR2(240) :=NULL,
281 ATTRIBUTE18 VARCHAR2(240) :=NULL,
282 ATTRIBUTE19 VARCHAR2(240) :=NULL,
283 ATTRIBUTE20 VARCHAR2(240) :=NULL,
284 ATTRIBUTE21 VARCHAR2(240) :=NULL,
285 ATTRIBUTE22 VARCHAR2(240) :=NULL,
286 ATTRIBUTE23 VARCHAR2(240) :=NULL,
287 ATTRIBUTE24 VARCHAR2(240) :=NULL,
288 ATTRIBUTE25 VARCHAR2(240) :=NULL,
289 ATTRIBUTE26 VARCHAR2(240) :=NULL,
290 ATTRIBUTE27 VARCHAR2(240) :=NULL,
291 ATTRIBUTE28 VARCHAR2(240) :=NULL,
292 ATTRIBUTE29 VARCHAR2(240) :=NULL,
293 ATTRIBUTE30 VARCHAR2(240) :=NULL,
294 CREATED_BY NUMBER :=NULL,
295 CREATION_DATE DATE :=NULL
296 );
297
298 Type eam_iso_header_tbl_type is table of eam_iso_header_rec_type
299 INDEX BY BINARY_INTEGER;
300
301 Type eam_clearance_header_tbl_type is table of eam_clearance_header_rec_type
302 INDEX BY BINARY_INTEGER;
303
304 Type eam_wp_tbl_type is table of eam_wp_header_rec_type
305 INDEX BY BINARY_INTEGER;
306
307 Type eam_safety_assoc_tbl_type is table of eam_safety_assoc_rec_type
308 INDEX BY BINARY_INTEGER;
309
310 Type eam_establishment_tbl_type IS TABLE OF eam_establishment_rec_type
311 INDEX BY BINARY_INTEGER;
312
313
314 /**************************************************************************
315 * Procedure : PROCESS_ISOLATION
316 * Purpose : This will call the private API for processing isolation
317 ***************************************************************************/
318 PROCEDURE PROCESS_ISOLATION
319 ( p_bo_identifier IN VARCHAR2 := 'EAM'
320 , p_api_version_number IN NUMBER := 1.0
321 , p_init_msg_list IN BOOLEAN := FALSE
322 , p_commit IN VARCHAR2 := 'N'
323 , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
324 , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
325 , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
326 , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
327 , p_debug IN VARCHAR2 := 'N'
328 , p_output_dir IN VARCHAR2 := NULL
329 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
330 , p_debug_file_mode IN VARCHAR2 := 'w'
331 , x_isolation_id OUT NOCOPY NUMBER
332 , x_return_status OUT NOCOPY VARCHAR2
333 , x_msg_count OUT NOCOPY NUMBER
334 );
335
336 /**************************************************************************
337 * Procedure: PROCESS_WORK_CLEARANCE
338 * Purpose: This will call the private API for processing of Work Clearance
339 ***************************************************************************/
340 PROCEDURE PROCESS_WORK_CLEARANCE
341 ( p_bo_identifier IN VARCHAR2 := 'EAM'
342 , p_api_version_number IN NUMBER := 1.0
343 , p_init_msg_list IN BOOLEAN := FALSE
344 , p_commit IN VARCHAR2 := 'N'
345 , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
346 , p_clearance_establish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
347 , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
348 , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
349 , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
350 , p_debug IN VARCHAR2 := 'N'
351 , p_output_dir IN VARCHAR2 := NULL
352 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
353 , p_debug_file_mode IN VARCHAR2 := 'w'
354 , x_clearance_id OUT NOCOPY NUMBER
355 , x_return_status OUT NOCOPY VARCHAR2
356 , x_msg_count OUT NOCOPY NUMBER
357 );
358
359 /**************************************************************************
360 * Procedure: COPY_WORK_CLEARANCE
361 * Purpose: Procedure to copy work Clearance record.
362 * This procedure will call private for copying clearance API.
363 ***************************************************************************/
364 PROCEDURE COPY_WORK_CLEARANCE(
365 p_bo_identifier IN VARCHAR2 := 'EAM'
366 , p_api_version_number IN NUMBER := 1.0
367 , p_init_msg_list IN BOOLEAN := FALSE
368 , p_commit IN VARCHAR2 := 'N'
369 , p_debug IN VARCHAR2 := 'N'
370 , p_output_dir IN VARCHAR2 := NULL
371 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
372 , p_debug_file_mode IN VARCHAR2 := 'w'
373 , p_org_id IN NUMBER
374 , px_clearance_id IN OUT NOCOPY NUMBER
375 , x_return_status OUT NOCOPY VARCHAR2
376 , x_msg_count OUT NOCOPY NUMBER
377 );
378
379
380 /**************************************************************************
381 * Procedure: PROCESS_WORK_PERMIT
382 * Purpose: Procedure to process work permit record.
383 * This procedure will call private the procedure PROCESS_WORK_PERMIT
384 * in the EAM_PROCES_PERMIT_PVT API.
385 ***************************************************************************/
386 PROCEDURE PROCESS_WORK_PERMIT
387 ( p_bo_identifier IN VARCHAR2 := 'EAM'
388 , p_api_version_number IN NUMBER := 1.0
389 , p_init_msg_list IN BOOLEAN := FALSE
390 , p_commit IN VARCHAR2 := 'N'
391 , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
392 , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
393 , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
394 , p_debug IN VARCHAR2 := 'N'
395 , p_output_dir IN VARCHAR2 := NULL
396 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
397 , p_debug_file_mode IN VARCHAR2 := 'w'
398 , x_permit_id OUT NOCOPY NUMBER
399 , x_return_status OUT NOCOPY VARCHAR2
400 , x_msg_count OUT NOCOPY NUMBER
401 );
402
403
404 /**************************************************************************
405 * Procedure: COPY_WORK_PERMIT
406 * Purpose: Procedure to copy work permit record.
407 * This procedure will call the private API to copy work permit
408 * in EAM_PROCES_PERMIT_PVT.
409 ***************************************************************************/
410 PROCEDURE COPY_WORK_PERMIT(
411 p_bo_identifier IN VARCHAR2 := 'EAM'
412 , p_api_version_number IN NUMBER := 1.0
413 , p_init_msg_list IN BOOLEAN := FALSE
414 , p_commit IN VARCHAR2 := 'N'
415 , p_debug IN VARCHAR2 := 'N'
416 , p_output_dir IN VARCHAR2 := NULL
417 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
418 , p_debug_file_mode IN VARCHAR2 := 'w'
419 , p_org_id IN NUMBER
420 , px_permit_id IN OUT NOCOPY NUMBER
421 , x_return_status OUT NOCOPY VARCHAR2
422 , x_msg_count OUT NOCOPY NUMBER
423 );
424 /**************************************************************************
425 * Procedure: CLEARANCE_PERMIT_ASSOCIATION
426 * Purpose : This will process permit clearance association
427 ***************************************************************************/
428 PROCEDURE PERMIT_CLEARANCE_ASSOCIATION
429 (
430 p_bo_identifier IN VARCHAR2 := 'EAM'
431 , p_api_version_number IN NUMBER := 1.0
432 , p_init_msg_list IN BOOLEAN := FALSE
433 , p_commit IN VARCHAR2 := 'N'
434 , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
435 , p_debug IN VARCHAR2 := 'N'
436 , p_output_dir IN VARCHAR2 := NULL
437 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
438 , p_debug_file_mode IN VARCHAR2 := 'w'
439 , x_return_status OUT NOCOPY VARCHAR2
440 , x_msg_count OUT NOCOPY NUMBER
441 );
442
443 /**************************************************************************
444 * Procedure: CLEARANCE_WO_ASSOCIATION
445 * Purpose : This will process clearance work order association
446 ***************************************************************************/
447 PROCEDURE CLEARANCE_WO_ASSOCIATION
448 ( p_bo_identifier IN VARCHAR2 := 'EAM'
449 , p_api_version_number IN NUMBER := 1.0
450 , p_init_msg_list IN BOOLEAN := FALSE
451 , p_commit IN VARCHAR2 := 'N'
452 , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
453 , p_debug IN VARCHAR2 := 'N'
454 , p_output_dir IN VARCHAR2 := NULL
455 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
456 , p_debug_file_mode IN VARCHAR2 := 'w'
457 , x_return_status OUT NOCOPY VARCHAR2
458 , x_msg_count OUT NOCOPY NUMBER
459 );
460
461 /************************************************************
462 * Procedure: PERMIT_WORK_ORDER_ASSOCIATION
463 * Purpose : This will process permit work order association
464 ************************************************************/
465 PROCEDURE PERMIT_WORK_ORDER_ASSOCIATION
466 (
467 p_bo_identifier IN VARCHAR2 := 'EAM'
468 , p_api_version_number IN NUMBER := 1.0
469 , p_init_msg_list IN BOOLEAN := FALSE
470 , p_commit IN VARCHAR2 := 'N'
471 , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
472 , p_debug IN VARCHAR2 := 'N'
473 , p_output_dir IN VARCHAR2 := NULL
474 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
475 , p_debug_file_mode IN VARCHAR2 := 'w'
476 , x_return_status OUT NOCOPY VARCHAR2
477 , x_msg_count OUT NOCOPY NUMBER
478 );
479
480 /************************************************************
481 * Procedure: ASSET_ISOLATION_ASSOCIATION
482 * Purpose : This will process asset isolation association
483 ************************************************************/
484 PROCEDURE ASSET_ISOLATION_ASSOCIATION
485 (
486 p_bo_identifier IN VARCHAR2 := 'EAM'
487 , p_api_version_number IN NUMBER := 1.0
488 , p_init_msg_list IN BOOLEAN := FALSE
489 , p_commit IN VARCHAR2 := 'N'
490 , p_isolated_assets_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
491 , p_debug IN VARCHAR2 := 'N'
492 , p_output_dir IN VARCHAR2 := NULL
493 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
494 , p_debug_file_mode IN VARCHAR2 := 'w'
495 , x_return_status OUT NOCOPY VARCHAR2
496 , x_msg_count OUT NOCOPY NUMBER
497 );
498
499 END EAM_PROCESS_SAFETY_PUB;