10:
11:
12: -- GLOBAL_MESSAGE_CONSTANTS
13: ---------------------------------------------------------------------------------------------
14: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
15: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
11:
12: -- GLOBAL_MESSAGE_CONSTANTS
13: ---------------------------------------------------------------------------------------------
14: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
15: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_UNEXPECTED_ERROR';
12: -- GLOBAL_MESSAGE_CONSTANTS
13: ---------------------------------------------------------------------------------------------
14: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
15: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_MESSAGE';
13: ---------------------------------------------------------------------------------------------
14: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
15: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_MESSAGE';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_CODE';
14: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
15: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_MESSAGE';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_CODE';
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := OKC_API.G_REQUIRED_VALUE;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_MESSAGE';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_CODE';
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := OKC_API.G_REQUIRED_VALUE;
23: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
24: ---------------------------------------------------------------------------------------------
25:
26: -- GLOBAL EXCEPTION
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_MESSAGE';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_CODE';
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := OKC_API.G_REQUIRED_VALUE;
23: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
24: ---------------------------------------------------------------------------------------------
25:
26: -- GLOBAL EXCEPTION
27: ---------------------------------------