[Home] [Help]
PACKAGE: APPS.EAM_PROCESS_ISOLATION_PVT
Source
1 PACKAGE EAM_PROCESS_ISOLATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVISOS.pls 120.0 2011/03/04 02:00:44 mashah noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2009 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME: EAMVISOS.pls
9 --
10 -- DESCRIPTION: Spec of package EAM_PROCESS_ISOLATION_PVT
11 --
12 -- NOTES
13 --
14 -- HISTORY
15 --
16
17 ***************************************************************************/
18
19 PROCEDURE VALIDATE_TRANSACTION_TYPE(
20 p_validation_level IN NUMBER
21 , p_entity IN VARCHAR2
22 , x_return_status OUT NOCOPY VARCHAR2
23 , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
24 );
25
26 /************************************************************
27 * Procedure : PROCESS_ISOLATION
28 * Purpose : This will process create/update/delete on Isoalation
29 ************************************************************/
30 PROCEDURE PROCESS_ISOLATION
31 ( p_bo_identifier IN VARCHAR2 := 'EAM'
32 , p_api_version_number IN NUMBER := 1.0
33 , p_init_msg_list IN BOOLEAN := FALSE
34 , p_commit IN VARCHAR2 := 'N'
35 , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
36 , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
37 , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
38 , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
39 , x_isolation_id OUT NOCOPY NUMBER
40 , x_return_status OUT NOCOPY VARCHAR2
41 , x_msg_count OUT NOCOPY NUMBER
42 , p_debug IN VARCHAR2 := 'N'
43 , p_output_dir IN VARCHAR2 := NULL
44 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
45 , p_debug_file_mode IN VARCHAR2 := 'w'
46 );
47 /************************************************************
48 * Procedure : ISOLATION
49 * Purpose : This will process ISOLATION header
50 ************************************************************/
51 PROCEDURE WORK_ISOLATION
52 (
53 p_validation_level IN NUMBER
54 , p_isolation_id IN NUMBER :=NULL
55 , p_organization_id IN NUMBER :=NULL
56 , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
57 , x_iso_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
58 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
59 , x_return_status OUT NOCOPY VARCHAR2
60 );
61
62 /************************************************************
63 * Procedure: ESTABLISHMENT
64 * Purpose : This will process establishment records
65 ************************************************************/
66 PROCEDURE ESTABLISHMENT
67 ( p_organization_id IN NUMBER
68 , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
69 , p_safety_source_id IN NUMBER
70 , x_establish_iso_tbl OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
71 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
72 , x_return_status OUT NOCOPY VARCHAR2
73 );
74
75
76 /********************************************************************
77 * Procedure: Raise_Workflow_Events
78 * Purpose: This procedure raises the workflow events for work ISO release
79 *********************************************************************/
80 PROCEDURE RAISE_WORKFLOW_EVENTS
81 ( p_api_version IN NUMBER
82 , p_validation_level IN NUMBER
83 , p_eam_iso_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
84 , p_old_eam_iso_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
85 , p_approval_required IN BOOLEAN
86 , p_new_system_status IN NUMBER
87 , p_workflow_name IN VARCHAR2
88 , p_workflow_process IN VARCHAR2
89 , x_mesg_token_tbl IN OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
90 , x_return_status IN OUT NOCOPY VARCHAR2
91 );
92
93 END EAM_PROCESS_ISOLATION_PVT;