APPS.EAM_SAFETY_ASSOCIATION_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 33: ( p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

29: * Procedure: CLEARANCE_PERMIT_ASSOCIATION
30: * Purpose : This will process clearance permit association
31: ***************************************************************************/
32: PROCEDURE PERMIT_CLEARANCE_ASSOCIATION
33: ( p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
34: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
35: , x_return_status OUT NOCOPY VARCHAR2
36: )IS
37:

Line 46: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

42: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
43: l_return_status VARCHAR2(1);
44: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
45:
46: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
47: l_safety_assoc_id NUMBER;
48: l_count NUMBER;
49:
50: BEGIN

Line 221: ( p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

217: * Procedure: CLEARANCE_WORK_ORDER_ASSOCIATION
218: * Purpose : This will process clearance work order association
219: ***************************************************************************/
220: PROCEDURE CLEARANCE_WO_ASSOCIATION
221: ( p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
222: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
223: , x_return_status OUT NOCOPY VARCHAR2
224: )IS
225:

Line 234: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

230: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
231: l_return_status VARCHAR2(1);
232: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
233:
234: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
235: l_safety_assoc_id NUMBER;
236: l_count NUMBER;
237: l_error_level NUMBER :=EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL;
238: l_entity_index NUMBER :=1;

Line 440: ( p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

436: * Procedure: PERMIT_WORK_ORDER_ASSOCIATION
437: * Purpose : This will process permit work order association
438: ************************************************************/
439: PROCEDURE PERMIT_WORK_ORDER_ASSOCIATION
440: ( p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
441: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
442: , x_return_status OUT NOCOPY VARCHAR2
443: )IS
444: CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

Line 452: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

448: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
449: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
450: l_return_status VARCHAR2(1);
451:
452: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
453: l_safety_assoc_id NUMBER;
454: l_count NUMBER;
455:
456: BEGIN

Line 628: p_isolated_assets_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

624: * Purpose : This will process asset isolation association
625: ************************************************************/
626: PROCEDURE ASSET_ISOLATION_ASSOCIATION
627: (
628: p_isolated_assets_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
629: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
630: , x_return_status OUT NOCOPY VARCHAR2
631: ) IS
632: CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

Line 640: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

636: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
637: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
638: l_return_status VARCHAR2(1);
639:
640: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
641: l_safety_assoc_id NUMBER;
642: l_iso_association_error EXCEPTION;
643: l_count NUMBER;
644: BEGIN