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