DBA Data[Home] [Help]

APPS.OKS_RDS_PVT dependencies on OKC_UTIL

Line 399: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view

395: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
396: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
397:
398: Begin
399: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
400:
401: OKC_UTIL.ADD_VIEW('OKS_REV_DISTRIBUTIONS_v',x_return_status);
402:
403: --dbms_output.put_line('After calling okc_util_.add_view ');

Line 401: OKC_UTIL.ADD_VIEW('OKS_REV_DISTRIBUTIONS_v',x_return_status);

397:
398: Begin
399: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
400:
401: OKC_UTIL.ADD_VIEW('OKS_REV_DISTRIBUTIONS_v',x_return_status);
402:
403: --dbms_output.put_line('After calling okc_util_.add_view ');
404: --dbms_output.put_line('Value of x_return_status after calling OKC ='||x_return_status);
405: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 403: --dbms_output.put_line('After calling okc_util_.add_view ');

399: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
400:
401: OKC_UTIL.ADD_VIEW('OKS_REV_DISTRIBUTIONS_v',x_return_status);
402:
403: --dbms_output.put_line('After calling okc_util_.add_view ');
404: --dbms_output.put_line('Value of x_return_status after calling OKC ='||x_return_status);
405: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
406: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
407: -- need to leave