1 PACKAGE EAM_ISOLATION_UTILITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVISUS.pls 120.0 2011/03/04 01:49:00 mashah noship $ */
3
4 /***************************************************************************
5 --
6 -- Copyright (c) 2011 Oracle Corporation, Redwood Shores, CA, USA
7 -- All rights reserved.
8 --
9 -- FILENAME: EAMVISUS.pls
10 --
11 -- DESCRIPTION: Spec of package EAM_ISOLATION_UTILITY_PVT
12 --
13 -- NOTES
14 --
15 -- HISTORY
16 --
17
18 ***************************************************************************/
19
20
21 /*********************************************************************
22 * Procedure : QUERY_ROW
23 * Purpose : Procedure will query the database record
24 and return with those records.
25 ***********************************************************************/
26 PROCEDURE QUERY_ROW
27 ( p_isolation_id IN NUMBER
28 , p_organization_id IN NUMBER
29 , x_isolation_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
30 , x_Return_status OUT NOCOPY VARCHAR2
31 );
32
33 /********************************************************************
34 * Procedure : INSERT_ROW
35 * Purpose : Procedure will perfrom an insert into the table
36 *********************************************************************/
37 PROCEDURE INSERT_ROW
38 ( p_isolation_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
39 , x_return_Status OUT NOCOPY VARCHAR2
40 );
41
42 /********************************************************************
43 * Procedure : UPDATE_ROW
44 * Purpose : Procedure will perform an update on the table
45 *********************************************************************/
46
47 PROCEDURE UPDATE_ROW
48 ( p_isolation_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
49 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
50 , x_return_Status OUT NOCOPY VARCHAR2
51 );
52
53 /********************************************************************
54 * Procedure : PERFORM_WRITES
55 * Purpose : This is the only procedure that the user will have
56 access to when he/she needs to perform any kind of writes to the table.
57 *********************************************************************/
58
59 PROCEDURE PERFORM_WRITES
60 ( p_isolation_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
61 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
62 , x_return_Status OUT NOCOPY VARCHAR2
63 );
64
65 /********************************************************************
66 * Procedure : CHANGE_ISOLATION_STATUS
67 * Purpose : This procedure will be used to change status of a isolation.
68 *********************************************************************/
69
70 PROCEDURE CHANGE_ISOLATION_STATUS
71 ( p_isolation_id IN NUMBER
72 , p_organization_id IN NUMBER
73 , p_to_status_type IN NUMBER
74 , p_user_id IN NUMBER
75 , p_responsibility_id IN NUMBER
76 , p_transaction_type IN NUMBER
77 , x_return_status OUT NOCOPY VARCHAR2
78 , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
79 );
80
81
82 /********************************************************************
83 * Procedure : INSERT_ISOLATION_HISTORY_ROW
84 * Purpose : This procedure will be used to write isolation history to EAM_SAFETY_HISTORY table
85 *********************************************************************
86
87 PROCEDURE INSERT_ISOLATION_HISTORY_ROW
88 ( p_object_id IN NUMBER
89 , p_object_name IN VARCHAR2
90 , p_object_type IN NUMBER :=3
91 , p_event IN VARCHAR2
92 , p_status IN VARCHAR2
93 , p_details IN VARCHAR2
94 , p_user_id IN NUMBER
95 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
96 , x_return_Status OUT NOCOPY VARCHAR2
97 );*/
98
99
100 END EAM_ISOLATION_UTILITY_PVT;
101