APPS.EAM_CLEARANCE_UTILITY_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 32: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

28: ***********************************************************************/
29: PROCEDURE QUERY_ROW
30: ( p_work_clearance_id IN NUMBER
31: , p_organization_id IN NUMBER
32: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
33: , x_return_status OUT NOCOPY VARCHAR2
34: ) IS
35:
36: l_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

Line 36: l_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;

32: , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
33: , x_return_status OUT NOCOPY VARCHAR2
34: ) IS
35:
36: l_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
37:
38: BEGIN
39:
40: SELECT

Line 162: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

158: * Procedure : INSERT_ROW
159: * Purpose : Procedure will perfrom an insert into the table
160: *********************************************************************/
161: PROCEDURE INSERT_ROW
162: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
163: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
164: , x_return_Status OUT NOCOPY VARCHAR2
165: )IS
166:

Line 291: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB. eam_clearance_header_rec_type

287: * Procedure : UPDATE_ROW
288: * Purpose : Procedure will perform an update on the table
289: *********************************************************************/
290: PROCEDURE UPDATE_ROW
291: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB. eam_clearance_header_rec_type
292: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
293: , x_return_Status OUT NOCOPY VARCHAR2
294: )IS
295:

Line 368: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type

364: access to when he/she needs to perform any kind of
365: writes to the table.
366: *********************************************************************/
367: PROCEDURE PERFORM_WRITES
368: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
369: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
370: , x_return_Status OUT NOCOPY VARCHAR2
371: )IS
372: l_msg_data VARCHAR2(240);