3:
4: -- GLOBAL VARIABLES
5: ---------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LA_TRADEIN_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
9: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
10: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
11: ---------------------------------------------------------------------------
5: ---------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LA_TRADEIN_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
9: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
10: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
11: ---------------------------------------------------------------------------
12: -----------------------------------------------------------------------------
13: -- APPLICATION GLOBAL CONSTANTS
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LA_TRADEIN_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
9: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
10: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
11: ---------------------------------------------------------------------------
12: -----------------------------------------------------------------------------
13: -- APPLICATION GLOBAL CONSTANTS
14: -----------------------------------------------------------------------------
16: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
17: G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
18: G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19: G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
23:
24:
17: G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
18: G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19: G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
23:
24:
25: TYPE tradein_rec_type is record
18: G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19: G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
23:
24:
25: TYPE tradein_rec_type is record
26: (