80: IF p_usage_name IS NOT NULL THEN
81: BEGIN
82: SELECT model_usage_id
83: INTO v_usage_id
84: FROM CZ_MODEL_USAGES
85: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
86: AND cz_model_usages.in_use = '1';
87: EXCEPTION
88: WHEN OTHERS THEN
81: BEGIN
82: SELECT model_usage_id
83: INTO v_usage_id
84: FROM CZ_MODEL_USAGES
85: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
86: AND cz_model_usages.in_use = '1';
87: EXCEPTION
88: WHEN OTHERS THEN
89: v_usage_id := ANY_USAGE_ID;
82: SELECT model_usage_id
83: INTO v_usage_id
84: FROM CZ_MODEL_USAGES
85: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
86: AND cz_model_usages.in_use = '1';
87: EXCEPTION
88: WHEN OTHERS THEN
89: v_usage_id := ANY_USAGE_ID;
90: END;