[Home] [Help]
104: /* check if safetyinfo already exists for the instance, else mark it as create */
105: BEGIN
106: SELECT 'U'
107: INTO l_create_update
108: FROM EAM_ASSET_SAFETY_TYPES
109: WHERE INSTANCE_ID = p_instance_id;
110:
111: EXCEPTION WHEN NO_DATA_FOUND THEN
112: l_create_update := 'C';