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:
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: );
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: );
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: );
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: );