2: /* $Header: OKLPTSGS.pls 120.4 2005/11/15 11:52:47 rgooty noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ---------------------------------------------------------------------------
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PUB';
8:
9: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
5: ---------------------------------------------------------------------------
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PUB';
8:
9: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PUB';
8:
9: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
14:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PUB';
8:
9: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
14:
15: G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
8:
9: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
14:
15: G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
16:
9: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
14:
15: G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
16:
17: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
13: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
14:
15: G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
16:
17: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
18: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
16:
17: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
18: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
15: G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
16:
17: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
18: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
23:
16:
17: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
18: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
23:
24: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
17: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
18: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
23:
24: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
25: G_EXCEPTION_ERROR EXCEPTION;