APPS.EAM_PERMIT_VALIDATE_PVT dependencies on EAM_WORK_PERMITS

Line 176: FROM EAM_WORK_PERMITS

172: BEGIN
173: IF (p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
174: SELECT COUNT(*)
175: INTO l_count
176: FROM EAM_WORK_PERMITS
177: WHERE PERMIT_ID = p_work_permit_header_rec.PERMIT_ID
178: AND organization_id = p_work_permit_header_rec.organization_id;
179: IF(l_count > 0) THEN
180: raise fnd_api.g_exc_unexpected_error;

Line 207: FROM EAM_WORK_PERMITS

203: BEGIN
204: IF (p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
205: SELECT COUNT(*)
206: INTO l_count
207: FROM EAM_WORK_PERMITS
208: WHERE PERMIT_ID = p_work_permit_header_rec.PERMIT_ID
209: AND organization_id = p_work_permit_header_rec.organization_id;
210:
211: IF(l_count <> 1) THEN

Line 239: FROM EAM_WORK_PERMITS

235: BEGIN
236: IF (p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
237: SELECT COUNT(*)
238: INTO l_count
239: FROM EAM_WORK_PERMITS
240: WHERE PERMIT_NAME = p_work_permit_header_rec.PERMIT_NAME
241: AND organization_id = p_work_permit_header_rec.organization_id;
242: IF(l_count > 0) THEN
243: raise fnd_api.g_exc_unexpected_error;

Line 253: FROM EAM_WORK_PERMITS

249: IF (p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
250: BEGIN
251: SELECT permit_id
252: INTO l_permit_id
253: FROM EAM_WORK_PERMITS
254: WHERE PERMIT_NAME = p_work_permit_header_rec.PERMIT_NAME
255: AND organization_id = p_work_permit_header_rec.organization_id;
256: EXCEPTION
257: WHEN others THEN