APPS.EAM_ISOLATION_VALIDATE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 62

  ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND p_iso_header_rec.transaction_type IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE) THEN
        l_token_tbl(1).token_name  := 'SAFETY_NAME';

Line: 115

    SELECT 1
    INTO g_dummy
    FROM wip_eam_parameters wep,
      mtl_parameters mp
    WHERE wep.organization_id = mp.organization_id
    AND mp.eam_enabled_flag   = 'Y'
    AND wep.organization_id   = p_iso_header_rec.organization_id;

Line: 142

      SELECT COUNT(*)
      INTO l_count
      FROM EAM_ISOLATIONS
      WHERE ISOLATION_ID     = p_iso_header_rec.ISOLATION_ID
      AND organization_id = p_iso_header_rec.organization_id;

Line: 166

  IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Isolation ID exists for update . . . '); END IF;

Line: 170

    IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
      SELECT COUNT(*)
      INTO l_count
      FROM EAM_ISOLATIONS
      WHERE ISOLATION_ID     = p_iso_header_rec.ISOLATION_ID
      AND organization_id = p_iso_header_rec.organization_id;

Line: 201

      SELECT COUNT(*)
      INTO l_count
      FROM EAM_ISOLATIONS
      WHERE ISOLATION_NAME   = p_iso_header_rec.ISOLATION_NAME
      AND organization_id = p_iso_header_rec.organization_id;

Line: 251

    IF (p_iso_header_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
    p_iso_header_rec.SYSTEM_STATUS = wip_constants.cancelled OR
    p_iso_header_rec.ISOLATION_NAME <> p_old_iso_header_rec.ISOLATION_NAME OR
     p_iso_header_rec.DESCRIPTION <> p_old_iso_header_rec.DESCRIPTION OR
     p_iso_header_rec.ORGANIZATION_ID <> p_old_iso_header_rec.ORGANIZATION_ID OR
    p_iso_header_rec.ISOLATION_TYPE <> p_old_iso_header_rec.ISOLATION_TYPE OR
--    p_iso_header_rec.ISOLATION_TYPE_DESCRIPTION <> p_old_iso_header_rec.ISOLATION_TYPE_DESCRIPTION OR
    p_iso_header_rec.EFFECTIVE_START_DATE <> p_old_iso_header_rec.EFFECTIVE_START_DATE OR
    p_iso_header_rec.EFFECTIVE_END_DATE <> p_old_iso_header_rec.EFFECTIVE_END_DATE OR
    p_iso_header_rec.COPY_FROM_ISOLATION <> p_old_iso_header_rec.COPY_FROM_ISOLATION OR
    p_iso_header_rec.COPY_FROM_WORK_CLEARANCE <> p_old_iso_header_rec.COPY_FROM_WORK_CLEARANCE OR
    p_iso_header_rec.PERMIT_REQUIRED <> p_old_iso_header_rec.PERMIT_REQUIRED OR
    p_iso_header_rec.ATTRIBUTE_CATEGORY <> p_old_iso_header_rec.ATTRIBUTE_CATEGORY OR
    p_iso_header_rec.ATTRIBUTE1 <> p_old_iso_header_rec.ATTRIBUTE1 OR
    p_iso_header_rec.ATTRIBUTE2 <> p_old_iso_header_rec.ATTRIBUTE2 OR
    p_iso_header_rec.ATTRIBUTE3 <> p_old_iso_header_rec.ATTRIBUTE3 OR
    p_iso_header_rec.ATTRIBUTE4 <> p_old_iso_header_rec.ATTRIBUTE4 OR
    p_iso_header_rec.ATTRIBUTE5 <> p_old_iso_header_rec.ATTRIBUTE5 OR
    p_iso_header_rec.ATTRIBUTE6 <> p_old_iso_header_rec.ATTRIBUTE6 OR
    p_iso_header_rec.ATTRIBUTE7 <> p_old_iso_header_rec.ATTRIBUTE7 OR
    p_iso_header_rec.ATTRIBUTE8 <> p_old_iso_header_rec.ATTRIBUTE8 OR
    p_iso_header_rec.ATTRIBUTE9 <> p_old_iso_header_rec.ATTRIBUTE9 OR
    p_iso_header_rec.ATTRIBUTE10 <> p_old_iso_header_rec.ATTRIBUTE10 OR
    p_iso_header_rec.ATTRIBUTE11 <> p_old_iso_header_rec.ATTRIBUTE11 OR
    p_iso_header_rec.ATTRIBUTE12 <> p_old_iso_header_rec.ATTRIBUTE12 OR
    p_iso_header_rec.ATTRIBUTE13 <> p_old_iso_header_rec.ATTRIBUTE13 OR
    p_iso_header_rec.ATTRIBUTE14 <> p_old_iso_header_rec.ATTRIBUTE14 OR
    p_iso_header_rec.ATTRIBUTE15 <> p_old_iso_header_rec.ATTRIBUTE15 OR
    p_iso_header_rec.ATTRIBUTE16 <> p_old_iso_header_rec.ATTRIBUTE1 OR
    p_iso_header_rec.ATTRIBUTE17 <> p_old_iso_header_rec.ATTRIBUTE2 OR
    p_iso_header_rec.ATTRIBUTE18 <> p_old_iso_header_rec.ATTRIBUTE3 OR
    p_iso_header_rec.ATTRIBUTE19 <> p_old_iso_header_rec.ATTRIBUTE4 OR
    p_iso_header_rec.ATTRIBUTE20 <> p_old_iso_header_rec.ATTRIBUTE5 OR
    p_iso_header_rec.ATTRIBUTE21 <> p_old_iso_header_rec.ATTRIBUTE6 OR
    p_iso_header_rec.ATTRIBUTE22 <> p_old_iso_header_rec.ATTRIBUTE7 OR
    p_iso_header_rec.ATTRIBUTE23 <> p_old_iso_header_rec.ATTRIBUTE8 OR
    p_iso_header_rec.ATTRIBUTE24 <> p_old_iso_header_rec.ATTRIBUTE9 OR
    p_iso_header_rec.ATTRIBUTE25 <> p_old_iso_header_rec.ATTRIBUTE10 OR
    p_iso_header_rec.ATTRIBUTE26 <> p_old_iso_header_rec.ATTRIBUTE11 OR
    p_iso_header_rec.ATTRIBUTE27 <> p_old_iso_header_rec.ATTRIBUTE12 OR
    p_iso_header_rec.ATTRIBUTE28 <> p_old_iso_header_rec.ATTRIBUTE13 OR
    p_iso_header_rec.ATTRIBUTE29 <> p_old_iso_header_rec.ATTRIBUTE14 OR
    p_iso_header_rec.ATTRIBUTE30 <> p_old_iso_header_rec.ATTRIBUTE15 OR
    p_iso_header_rec.APPROVED_BY <> p_old_iso_header_rec.APPROVED_BY ) THEN
      raise fnd_api.g_exc_unexpected_error;

Line: 318

      SELECT 1
      INTO g_dummy
      FROM fnd_user
      WHERE user_id    = p_iso_header_rec.user_id;

Line: 343

      SELECT 1
      INTO g_dummy
      FROM fnd_responsibility
      WHERE responsibility_id = p_iso_header_rec.responsibility_id;