5: -- GLOBAL VARIABLES
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_POPULATE_PR_ENG_RESULT_PUB';
8:
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
11: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
12: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
13: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_POPULATE_PR_ENG_RESULT_PUB';
8:
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
11: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
12: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
13: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_POPULATE_PR_ENG_RESULT_PUB';
8:
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
11: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
12: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
13: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15:
8:
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
11: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
12: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
13: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15:
16: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
11: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
12: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
13: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15:
16: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
17: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
10: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
11: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
12: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
13: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15:
16: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
17: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
12: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
13: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15:
16: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
17: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19: G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
13: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15:
16: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
17: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19: G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
16: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
17: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19: G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
23:
24:
17: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19: G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
23:
24:
25: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19: G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
23:
24:
25: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
26: G_EXCEPTION_ERROR EXCEPTION;