535: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
536:
537: Begin
538:
539: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
540:
541: OKC_UTIL.ADD_VIEW('OKC_K_SALES_CREDITS_V',x_return_status);
542:
543: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
537: Begin
538:
539: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
540:
541: OKC_UTIL.ADD_VIEW('OKC_K_SALES_CREDITS_V',x_return_status);
542:
543: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
544: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: -- need to leave