10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SERVICE_K_INT_WF';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
15: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SERVICE_K_INT_WF';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
15: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: G_API_VERSION CONSTANT NUMBER := 1;
20: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SERVICE_K_INT_WF';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
15: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: G_API_VERSION CONSTANT NUMBER := 1;
20: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
21: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
15: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: G_API_VERSION CONSTANT NUMBER := 1;
20: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
21: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
22: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
16: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: G_API_VERSION CONSTANT NUMBER := 1;
20: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
21: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
22: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
23: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
24: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: G_API_VERSION CONSTANT NUMBER := 1;
20: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
21: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
22: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
23: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
24: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
25:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: G_API_VERSION CONSTANT NUMBER := 1;
20: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
21: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
22: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
23: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
24: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
25:
26: -- Rec Type and Tbl Type to store Asset Schedule details
19: G_API_VERSION CONSTANT NUMBER := 1;
20: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
21: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
22: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
23: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
24: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
25:
26: -- Rec Type and Tbl Type to store Asset Schedule details
27: TYPE kle_rec_type IS RECORD (
20: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
21: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
22: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
23: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
24: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
25:
26: -- Rec Type and Tbl Type to store Asset Schedule details
27: TYPE kle_rec_type IS RECORD (
28: asset_number OKC_K_LINES_TL.name%TYPE,