9: ---------------------------------------------------------------------------
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STREAMS_RECON_PVT';
15:
16:
17: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STREAMS_RECON_PVT';
15:
16:
17: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STREAMS_RECON_PVT';
15:
16:
17: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
22:
15:
16:
17: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
16:
17: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
17: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
20: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
28:
21: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
30: G_EXCEPTION_ERROR EXCEPTION;
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
30: G_EXCEPTION_ERROR EXCEPTION;
31: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;