1 PACKAGE EAM_SAFETY_UTILITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVSAUS.pls 120.1 2011/03/04 00:16:30 mashah noship $ */
3
4 /*********************************************************************
5 * Procedure : QUERY_SAFFETY_ASSOCIATION_ROWS
6 * Purpose : Procedure will query the database record
7 and return with those records.
8 ***********************************************************************/
9
10 PROCEDURE QUERY_SAFFETY_ASSOCIATION_ROWS
11 ( p_source_id IN NUMBER
12 , p_organization_id IN NUMBER
13 , p_association_type IN NUMBER
14 , x_safety_association_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
15 , x_return_status OUT NOCOPY VARCHAR2
16 );
17
18
19
20 /********************************************************************
21 * Procedure : INSERT_SAFFETY_ASSOCIATION _ROW
22 * Purpose : Procedure will perfrom an insert into the table
23 *********************************************************************/
24
25 PROCEDURE INSERT_SAFFETY_ASSOCIATION_ROW
26 ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
27 , p_association_type IN NUMBER
28 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29 , x_return_Status OUT NOCOPY VARCHAR2
30 );
31
32
33
34
35 /********************************************************************
36 * Procedure : UPDATE_ SAFFETY_ASSOCIATION _ROW
37 * Purpose : Procedure will perform an update on the table
38 *********************************************************************/
39
40 PROCEDURE UPDATE_SAFFETY_ASSOCIATION_ROW
41 ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
42 , p_association_type IN NUMBER
43 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
44 , x_return_Status OUT NOCOPY VARCHAR2
45 );
46
47
48
49
50 /********************************************************************
51 * Procedure : DELETE SAFFETY_ASSOCIATION _ROW
52 * Purpose : This will perform delete on the table
53 *********************************************************************/
54
55 PROCEDURE DELETE_SAFFETY_ASSOCIATION_ROW
56 ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
57 , p_association_type IN NUMBER
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
64
65 /********************************************************************
66 * Procedure : WRITE SAFFETY_ASSOCIATION _ROW
67 * Purpose : This is the only procedure that the user will have
68 access to when he/she needs to perform any kind of writes to the table.
69 *********************************************************************/
70
71 PROCEDURE WRITE_SAFFETY_ASSOCIATION_ROW
72 ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
73 , p_association_type IN NUMBER
74 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
75 , x_return_Status OUT NOCOPY VARCHAR2
76 );
77
78 END EAM_SAFETY_UTILITY_PVT;
79