DBA Data[Home] [Help]

APPS.EAM_SAFETY_UTILITY_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 14: , x_safety_association_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type

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: )IS
17:
18: l_safety_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type ;

Line 18: l_safety_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type ;

14: , x_safety_association_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
15: , x_return_status OUT NOCOPY VARCHAR2
16: )IS
17:
18: l_safety_association_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type ;
19: BEGIN
20: SELECT
21: SAFETY_ASSOCIATION_ID
22: ,SOURCE_ID

Line 138: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type

134: * Purpose : Procedure will perfrom an insert into the table
135: *********************************************************************/
136:
137: PROCEDURE INSERT_SAFFETY_ASSOCIATION_ROW
138: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
139: , p_association_type IN NUMBER
140: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
141: , x_return_Status OUT NOCOPY VARCHAR2
142: )IS

Line 259: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type

255: *********************************************************************/
256:
257:
258: PROCEDURE UPDATE_SAFFETY_ASSOCIATION_ROW
259: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
260: , p_association_type IN NUMBER
261: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
262: , x_return_Status OUT NOCOPY VARCHAR2
263: )IS

Line 331: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type

327: * Purpose : This will perform delete on the table
328: *********************************************************************/
329:
330: PROCEDURE DELETE_SAFFETY_ASSOCIATION_ROW
331: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
332: , p_association_type IN NUMBER
333: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
334: , x_return_Status OUT NOCOPY VARCHAR2
335: )IS

Line 372: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type

368: access to when he/she needs to perform any kind of writes to the table.
369: *********************************************************************/
370:
371: PROCEDURE WRITE_SAFFETY_ASSOCIATION_ROW
372: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
373: , p_association_type IN NUMBER
374: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
375: , x_return_Status OUT NOCOPY VARCHAR2
376: ) IS