APPS.EAM_SAFETY_ASSOCIATION_PVT dependencies on EAM_WORK_CLEARANCES

Line 64: FROM EAM_WORK_CLEARANCES

60: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking clearance existence'); end if;
61:
62: SELECT COUNT(*)
63: INTO l_count
64: FROM EAM_WORK_CLEARANCES
65: WHERE WORK_CLEARANCE_ID = l_safety_assoc_rec.TARGET_REF_ID
66: AND organization_id = l_safety_assoc_rec.organization_id;
67:
68: IF (l_count < 1)

Line 193: FROM EAM_WORK_CLEARANCES EWC

189: AND WP.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
190:
191: l_token_tbl(2).token_name := 'TARGET';
192: SELECT EWC.WORK_CLEARANCE_NAME into l_token_tbl(2).token_value
193: FROM EAM_WORK_CLEARANCES EWC
194: WHERE EWC.WORK_CLEARANCE_ID = l_safety_assoc_rec.TARGET_REF_ID
195: AND EWC.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
196:
197: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 255: FROM EAM_WORK_CLEARANCES

251: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking clearance existence'); end if;
252:
253: SELECT COUNT(*)
254: INTO l_count
255: FROM EAM_WORK_CLEARANCES
256: WHERE WORK_CLEARANCE_ID = l_safety_assoc_rec.source_id
257: AND organization_id = l_safety_assoc_rec.organization_id;
258:
259: IF (l_count < 1)

Line 399: FROM EAM_WORK_CLEARANCES EWC

395: WHEN G_SAFETY_DUPLICATE_ASSO_ERROR THEN
396:
397: l_token_tbl(1).token_name := 'SOURCE';
398: SELECT EWC.WORK_CLEARANCE_NAME into l_token_tbl(1).token_value
399: FROM EAM_WORK_CLEARANCES EWC
400: WHERE EWC.WORK_CLEARANCE_ID = l_safety_assoc_rec.SOURCE_ID
401: AND EWC.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
402:
403: l_token_tbl(2).token_name := 'TARGET';