APPS.OKL_UTIL dependencies on OKC_API

Line 164: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

160:
161:
162: ---------------------------------------------------------
163: FUNCTION check_from_to_number_range(p_from_number IN NUMBER ,p_to_number IN NUMBER ) RETURN VARCHAR2 IS
164: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
165: BEGIN
166: IF (p_from_number IS NULL) OR (p_to_number IS NULL) THEN
167: x_return_status := Okc_Api.G_RET_STS_ERROR;
168: ELSE

Line 167: x_return_status := Okc_Api.G_RET_STS_ERROR;

163: FUNCTION check_from_to_number_range(p_from_number IN NUMBER ,p_to_number IN NUMBER ) RETURN VARCHAR2 IS
164: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
165: BEGIN
166: IF (p_from_number IS NULL) OR (p_to_number IS NULL) THEN
167: x_return_status := Okc_Api.G_RET_STS_ERROR;
168: ELSE
169: IF (p_to_number < p_from_number) THEN
170: x_return_status := Okc_Api.G_RET_STS_ERROR;
171: END IF;

Line 170: x_return_status := Okc_Api.G_RET_STS_ERROR;

166: IF (p_from_number IS NULL) OR (p_to_number IS NULL) THEN
167: x_return_status := Okc_Api.G_RET_STS_ERROR;
168: ELSE
169: IF (p_to_number < p_from_number) THEN
170: x_return_status := Okc_Api.G_RET_STS_ERROR;
171: END IF;
172: END IF;
173: RETURN (x_return_status);
174: EXCEPTION

Line 220: IF (p_col_value IS NULL)OR (p_col_value = OKC_API.G_MISS_CHAR) THEN

216: ----------------------------------------------------------------------------
217: FUNCTION check_domain_yn(p_col_value IN VARCHAR2)RETURN VARCHAR2 IS
218: x_return_status VARCHAR2(1):= Okl_Api.G_RET_STS_SUCCESS;
219: BEGIN
220: IF (p_col_value IS NULL)OR (p_col_value = OKC_API.G_MISS_CHAR) THEN
221: x_return_status:=Okl_Api.G_RET_STS_ERROR;
222: ELSE
223: IF UPPER(p_col_value) NOT IN('Y','N') THEN
224: x_return_status:=Okl_Api.G_RET_STS_ERROR;