1993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1994: END IF;
1995: SELECT model_usage_id
1996: INTO v_usage_id
1997: FROM CZ_MODEL_USAGES
1998: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
1999: AND cz_model_usages.in_use = '1';
2000:
2001: x_return_status := FND_API.G_RET_STS_SUCCESS;
1994: END IF;
1995: SELECT model_usage_id
1996: INTO v_usage_id
1997: FROM CZ_MODEL_USAGES
1998: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
1999: AND cz_model_usages.in_use = '1';
2000:
2001: x_return_status := FND_API.G_RET_STS_SUCCESS;
2002: RETURN v_usage_id;
1995: SELECT model_usage_id
1996: INTO v_usage_id
1997: FROM CZ_MODEL_USAGES
1998: WHERE LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
1999: AND cz_model_usages.in_use = '1';
2000:
2001: x_return_status := FND_API.G_RET_STS_SUCCESS;
2002: RETURN v_usage_id;
2003: EXCEPTION