eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_SAFETY_ASSOCIATION_PVT dependencies on EAM_SAFETY_ASSOCIATIONS

Line 38: CURSOR C2 IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

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:
38: CURSOR C2 IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;
39:
40: --Error handling variables
41: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
42: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 102: FROM EAM_SAFETY_ASSOCIATIONS

98: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
99: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
100: SELECT COUNT(*)
101: INTO l_count
102: FROM EAM_SAFETY_ASSOCIATIONS
103: WHERE SOURCE_ID = l_safety_assoc_rec.SOURCE_ID
104: AND TARGET_REF_ID = l_safety_assoc_rec.TARGET_REF_ID
105: AND organization_id = l_safety_assoc_rec.organization_id;
106:

Line 226: CURSOR C1 IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

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:
226: CURSOR C1 IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;
227:
228: --Error handling variables
229: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
230: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 293: FROM EAM_SAFETY_ASSOCIATIONS

289: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
290: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
291: SELECT COUNT(*)
292: INTO l_count
293: FROM EAM_SAFETY_ASSOCIATIONS
294: WHERE SOURCE_ID = l_safety_assoc_rec.SOURCE_ID
295: AND TARGET_REF_ID = l_safety_assoc_rec.TARGET_REF_ID
296: AND organization_id = l_safety_assoc_rec.organization_id;
297:

Line 444: CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

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;
445:
446: --Error handling variables
447: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
448: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 508: FROM EAM_SAFETY_ASSOCIATIONS

504: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
505: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
506: SELECT COUNT(*)
507: INTO l_count
508: FROM EAM_SAFETY_ASSOCIATIONS
509: WHERE SOURCE_ID = l_safety_assoc_rec.SOURCE_ID
510: AND TARGET_REF_ID = l_safety_assoc_rec.TARGET_REF_ID
511: AND organization_id = l_safety_assoc_rec.organization_id;
512:

Line 632: CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

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;
633:
634: --Error handling variables
635: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
636: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 671: FROM EAM_SAFETY_ASSOCIATIONS

667: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
668: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
669: SELECT COUNT(*)
670: INTO l_count
671: FROM EAM_SAFETY_ASSOCIATIONS
672: WHERE SOURCE_ID = l_safety_assoc_rec.SOURCE_ID
673: AND TARGET_REF_ID = l_safety_assoc_rec.TARGET_REF_ID
674: AND organization_id = l_safety_assoc_rec.organization_id;
675: