[Home] [Help]
PACKAGE: APPS.EAM_ESTABLISHMENT_UTILITY_PVT
Source
1 PACKAGE EAM_ESTABLISHMENT_UTILITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVETUS.pls 120.0 2011/03/04 02:06:48 mashah noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2011 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME: EAMVETUS.pls
9 --
10 -- DESCRIPTION: Spec of package EAM_ESTABLISHMENT_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_establishment_id IN NUMBER
27 , p_organization_id IN NUMBER
28 , x_safety_establishment_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_establishment_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_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_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
48 PROCEDURE UPDATE_ROW
49 ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
50 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
51 , x_return_Status OUT NOCOPY VARCHAR2
52 );
53
54
55
56 /********************************************************************
57 * Procedure : DELETE_ROW
58 * Purpose : Procedure will perform a delete on the table
59 *********************************************************************/
60 PROCEDURE DELETE_ROW
61 ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
62 , p_organization_id IN NUMBER
63 , x_return_Status OUT NOCOPY VARCHAR2
64 );
65
66
67
68 /********************************************************************
69 * Procedure : PERFORM_WRITES
70 * Purpose : This is the only procedure that the user will have
71 access to when he/she needs to perform any kind of writes to the table.
72 *********************************************************************/
73 PROCEDURE PERFORM_WRITES
74 ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
75 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
76 , x_return_Status OUT NOCOPY VARCHAR2
77 );
78
79
80 /********************************************************************
81 * Procedure : Check_Required
82 * Purpose : Check_Required procedure will check the existence of mandatory attributes.
83 *********************************************************************/
84 PROCEDURE CHECK_REQUIRED
85 ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
86 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
87 , x_return_Status OUT NOCOPY VARCHAR2
88 );
89
90 END EAM_ESTABLISHMENT_UTILITY_PVT ;
91