APPS.EAM_ESTABLISHMENT_UTILITY_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 30: , x_safety_establishment_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type

26: ***********************************************************************/
27: PROCEDURE QUERY_ROW
28: ( p_establishment_id IN NUMBER
29: , p_organization_id IN NUMBER
30: , x_safety_establishment_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
31: , x_Return_status OUT NOCOPY VARCHAR2
32: )IS
33: l_safety_establishment_rec EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type;
34:

Line 33: l_safety_establishment_rec EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type;

29: , p_organization_id IN NUMBER
30: , x_safety_establishment_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
31: , x_Return_status OUT NOCOPY VARCHAR2
32: )IS
33: l_safety_establishment_rec EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type;
34:
35: BEGIN
36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Querying establishment details ' ); END IF;
37:

Line 165: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type

161: * Purpose : Procedure will perfrom an insert into the table
162: *********************************************************************/
163:
164: PROCEDURE INSERT_ROW
165: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
166: , x_return_Status OUT NOCOPY VARCHAR2
167: ) IS
168:
169: BEGIN

Line 297: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type

293: * Procedure : UPDATE_ROW
294: * Purpose : Procedure will perform an update on the table
295: *********************************************************************/
296: PROCEDURE UPDATE_ROW
297: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
298: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
299: , x_return_Status OUT NOCOPY VARCHAR2
300: ) IS
301:

Line 373: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type

369: * Procedure : DELETE_ROW
370: * Purpose : Procedure will perform a delete on the table
371: *********************************************************************/
372: PROCEDURE DELETE_ROW
373: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
374: , p_organization_id IN NUMBER
375: , x_return_Status OUT NOCOPY VARCHAR2
376: ) IS
377: BEGIN

Line 398: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type

394: * Purpose : This is the only procedure that the user will have
395: access to when he/she needs to perform any kind of writes to the table.
396: *********************************************************************/
397: PROCEDURE PERFORM_WRITES
398: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
399: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
400: , x_return_Status OUT NOCOPY VARCHAR2
401: ) IS
402: l_msg_data VARCHAR2(240);

Line 445: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type

441: * Procedure : Check_Required
442: * Purpose : Check_Required procedure will check the existence of mandatory attributes.
443: *********************************************************************/
444: PROCEDURE CHECK_REQUIRED
445: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
446: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
447: , x_return_Status OUT NOCOPY VARCHAR2
448: )IS
449: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;