154: IF l_eam_failure_entry_record.source_id IS NULL THEN
155: BEGIN
156: SELECT wip_entity_id
157: INTO l_eam_failure_entry_record.source_id
158: FROM wip_entities
159: WHERE wip_entity_name = l_eam_failure_entry_record.source_name
160: AND organization_id = l_eam_failure_entry_record.maint_organization_id
161: AND entity_type in (6,7);
162: EXCEPTION
336: SELECT failure_id
337: INTO l_eam_failure_entry_record.failure_id
338: FROM eam_asset_failures
339: WHERE source_id = ( SELECT wip_entity_id
340: FROM WIP_ENTITIES
341: WHERE WIP_ENTITY_NAME = l_eam_failure_entry_record.source_name
342: AND organization_id = l_eam_failure_entry_record.maint_organization_id
343: )
344: AND source_type = 1;