eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_PROCESS_SAFETY_PUB dependencies on EAM_PROCESS_SAFETY_PUB

Line 1: PACKAGE BODY EAM_PROCESS_SAFETY_PUB AS

1: PACKAGE BODY EAM_PROCESS_SAFETY_PUB AS
2: /* $Header: EAMPSAPB.pls 120.2 2011/07/20 13:01:37 somitra noship $ */
3: /***************************************************************************
4: --
5: -- Copyright (c) 2011 Oracle Corporation, Redwood Shores, CA, USA

Line 10: -- DESCRIPTION: Body of package EAM_PROCESS_SAFETY_PUB

6: -- All rights reserved.
7: --
8: -- FILENAME: EAMPSAPB.pls
9: --
10: -- DESCRIPTION: Body of package EAM_PROCESS_SAFETY_PUB
11: --
12: -- NOTES
13: --
14: -- HISTORY

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_PROCESS_SAFETY_PUB';

16: --
17: ***************************************************************************/
18: -- g_debug_flag VARCHAR2(1) := 'N';
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_PROCESS_SAFETY_PUB';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EAMPSAPB.pls';
22:
23: /**************************************************************************
24: * Procedure : PROCESS_ISOLATION

Line 33: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type

29: ( p_bo_identifier IN VARCHAR2 := 'EAM'
30: , p_api_version_number IN NUMBER := 1.0
31: , p_init_msg_list IN BOOLEAN := FALSE
32: , p_commit IN VARCHAR2
33: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
34: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
35: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
36: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
37: , p_debug IN VARCHAR2

Line 34: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type

30: , p_api_version_number IN NUMBER := 1.0
31: , p_init_msg_list IN BOOLEAN := FALSE
32: , p_commit IN VARCHAR2
33: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
34: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
35: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
36: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
37: , p_debug IN VARCHAR2
38: , p_output_dir IN VARCHAR2

Line 35: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type

31: , p_init_msg_list IN BOOLEAN := FALSE
32: , p_commit IN VARCHAR2
33: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
34: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
35: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
36: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
37: , p_debug IN VARCHAR2
38: , p_output_dir IN VARCHAR2
39: , p_debug_filename IN VARCHAR2

Line 36: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

32: , p_commit IN VARCHAR2
33: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
34: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
35: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
36: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
37: , p_debug IN VARCHAR2
38: , p_output_dir IN VARCHAR2
39: , p_debug_filename IN VARCHAR2
40: , p_debug_file_mode IN VARCHAR2

Line 47: -- lx_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;

43: , x_msg_count OUT NOCOPY NUMBER
44: ) IS
45:
46: l_api_version CONSTANT NUMBER := 1.0;
47: -- lx_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
48: l_isolation_id NUMBER;
49:
50: l_debug VARCHAR2(1) := p_debug;
51: l_output_dir VARCHAR2(512) := p_output_dir;

Line 97: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling EAM_PROCESS_SAFETY_PUB.PROCESS_ISOLATION'); end if;

93: EAM_PROCESS_WO_PVT.Set_Debug('N');
94: END IF;
95: END IF;
96:
97: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling EAM_PROCESS_SAFETY_PUB.PROCESS_ISOLATION'); end if;
98:
99: EAM_PROCESS_ISOLATION_PVT.PROCESS_ISOLATION(
100: p_bo_identifier => p_bo_identifier
101: , p_api_version_number => l_api_version

Line 148: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

144: ( p_bo_identifier IN VARCHAR2 := 'EAM'
145: , p_api_version_number IN NUMBER := 1.0
146: , p_init_msg_list IN BOOLEAN := FALSE
147: , p_commit IN VARCHAR2
148: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
149: , p_clearance_establish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
150: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
151: , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
152: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

Line 149: , p_clearance_establish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type

145: , p_api_version_number IN NUMBER := 1.0
146: , p_init_msg_list IN BOOLEAN := FALSE
147: , p_commit IN VARCHAR2
148: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
149: , p_clearance_establish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
150: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
151: , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
152: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
153: , p_debug IN VARCHAR2

Line 150: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type

146: , p_init_msg_list IN BOOLEAN := FALSE
147: , p_commit IN VARCHAR2
148: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
149: , p_clearance_establish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
150: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
151: , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
152: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
153: , p_debug IN VARCHAR2
154: , p_output_dir IN VARCHAR2

Line 151: , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

147: , p_commit IN VARCHAR2
148: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
149: , p_clearance_establish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
150: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
151: , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
152: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
153: , p_debug IN VARCHAR2
154: , p_output_dir IN VARCHAR2
155: , p_debug_filename IN VARCHAR2

Line 152: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

148: , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
149: , p_clearance_establish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
150: , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
151: , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
152: , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
153: , p_debug IN VARCHAR2
154: , p_output_dir IN VARCHAR2
155: , p_debug_filename IN VARCHAR2
156: , p_debug_file_mode IN VARCHAR2

Line 163: l_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

159: , x_msg_count OUT NOCOPY NUMBER
160: ) IS
161:
162: l_api_version CONSTANT NUMBER := 1.0;
163: l_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
164:
165: l_debug VARCHAR2(1) := p_debug;
166: l_output_dir VARCHAR2(512) := p_output_dir;
167: l_debug_filename VARCHAR2(512) := p_debug_filename;

Line 211: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE'); end if;

207: EAM_PROCESS_WO_PVT.Set_Debug('N');
208: END IF;
209: END IF;
210:
211: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE'); end if;
212:
213: EAM_PROCESS_CLEARANCE_PVT.PROCESS_WORK_CLEARANCE(
214: p_bo_identifier => p_bo_identifier
215: , p_api_version_number => l_api_version

Line 319: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling EAM_PROCESS_PERMIT_PVT.COPY_WORK_PERMIT from EAM_PROCESS_SAFETY_PUB'); end if;

315: EAM_PROCESS_WO_PVT.Set_Debug('N');
316: END IF;
317: END IF;
318:
319: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling EAM_PROCESS_PERMIT_PVT.COPY_WORK_PERMIT from EAM_PROCESS_SAFETY_PUB'); end if;
320:
321: EAM_PROCESS_CLEARANCE_PVT.COPY_WORK_CLEARANCE(
322: p_bo_identifier => p_bo_identifier
323: , p_api_version_number => l_api_version

Line 371: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type

367: ( p_bo_identifier IN VARCHAR2 := 'EAM'
368: , p_api_version_number IN NUMBER := 1.0
369: , p_init_msg_list IN BOOLEAN := FALSE
370: , p_commit IN VARCHAR2
371: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
372: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
373: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
374: , p_debug IN VARCHAR2
375: , p_output_dir IN VARCHAR2

Line 372: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

368: , p_api_version_number IN NUMBER := 1.0
369: , p_init_msg_list IN BOOLEAN := FALSE
370: , p_commit IN VARCHAR2
371: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
372: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
373: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
374: , p_debug IN VARCHAR2
375: , p_output_dir IN VARCHAR2
376: , p_debug_filename IN VARCHAR2

Line 373: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

369: , p_init_msg_list IN BOOLEAN := FALSE
370: , p_commit IN VARCHAR2
371: , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
372: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
373: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
374: , p_debug IN VARCHAR2
375: , p_output_dir IN VARCHAR2
376: , p_debug_filename IN VARCHAR2
377: , p_debug_file_mode IN VARCHAR2

Line 384: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

380: , x_msg_count OUT NOCOPY NUMBER
381: ) IS
382:
383: l_api_version CONSTANT NUMBER := 1.0;
384: lx_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
385:
386: l_debug VARCHAR2(1) := p_debug;
387: l_output_dir VARCHAR2(512) := p_output_dir;
388: l_debug_filename VARCHAR2(512) := p_debug_filename;

Line 432: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT from EAM_PROCESS_SAFETY_PUB'); end if;

428: EAM_PROCESS_WO_PVT.Set_Debug('N');
429: END IF;
430: END IF;
431:
432: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT from EAM_PROCESS_SAFETY_PUB'); end if;
433:
434: EAM_PROCESS_PERMIT_PVT.PROCESS_WORK_PERMIT(
435: p_bo_identifier => p_bo_identifier
436: , p_api_version_number => l_api_version

Line 540: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling EAM_PROCESS_SAFETY_PUB.COPY_WORK_PERMIT from EAM_PROCESS_SAFETY_PUB'); end if;

536: EAM_PROCESS_WO_PVT.Set_Debug('N');
537: END IF;
538: END IF;
539:
540: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling EAM_PROCESS_SAFETY_PUB.COPY_WORK_PERMIT from EAM_PROCESS_SAFETY_PUB'); end if;
541:
542: EAM_PROCESS_PERMIT_PVT.COPY_WORK_PERMIT(
543: p_bo_identifier => p_bo_identifier
544: , p_api_version_number => l_api_version

Line 590: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

586: p_bo_identifier IN VARCHAR2 := 'EAM'
587: , p_api_version_number IN NUMBER := 1.0
588: , p_init_msg_list IN BOOLEAN := FALSE
589: , p_commit IN VARCHAR2
590: , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
591: , p_debug IN VARCHAR2
592: , p_output_dir IN VARCHAR2
593: , p_debug_filename IN VARCHAR2
594: , p_debug_file_mode IN VARCHAR2

Line 685: , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

681: ( p_bo_identifier IN VARCHAR2 := 'EAM'
682: , p_api_version_number IN NUMBER := 1.0
683: , p_init_msg_list IN BOOLEAN := FALSE
684: , p_commit IN VARCHAR2
685: , p_clearance_wo_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
686: , p_debug IN VARCHAR2
687: , p_output_dir IN VARCHAR2
688: , p_debug_filename IN VARCHAR2
689: , p_debug_file_mode IN VARCHAR2

Line 791: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

787: p_bo_identifier IN VARCHAR2 := 'EAM'
788: , p_api_version_number IN NUMBER := 1.0
789: , p_init_msg_list IN BOOLEAN := FALSE
790: , p_commit IN VARCHAR2
791: , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
792: , p_debug IN VARCHAR2
793: , p_output_dir IN VARCHAR2
794: , p_debug_filename IN VARCHAR2
795: , p_debug_file_mode IN VARCHAR2

Line 889: , p_isolated_assets_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

885: p_bo_identifier IN VARCHAR2 := 'EAM'
886: , p_api_version_number IN NUMBER := 1.0
887: , p_init_msg_list IN BOOLEAN := FALSE
888: , p_commit IN VARCHAR2 := 'N'
889: , p_isolated_assets_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
890: , p_debug IN VARCHAR2 := 'N'
891: , p_output_dir IN VARCHAR2 := NULL
892: , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
893: , p_debug_file_mode IN VARCHAR2 := 'w'

Line 975: END EAM_PROCESS_SAFETY_PUB;

971: END IF;
972:
973: END ASSET_ISOLATION_ASSOCIATION;
974:
975: END EAM_PROCESS_SAFETY_PUB;