8:
9: -----------------------------------------------------------------------------
10: -- APPLICATION GLOBAL CONSTANTS
11: -----------------------------------------------------------------------------
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13: G_API_VERSION CONSTANT NUMBER := 1;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
16: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
10: -- APPLICATION GLOBAL CONSTANTS
11: -----------------------------------------------------------------------------
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13: G_API_VERSION CONSTANT NUMBER := 1;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
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';
11: -----------------------------------------------------------------------------
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13: G_API_VERSION CONSTANT NUMBER := 1;
14: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
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';
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: -- PROGRAM UNITS
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: -- PROGRAM UNITS
26: ---------------------------------------------------------------------------
197:
198:
199: PROCEDURE get_payment_after_ppd(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_khr_id IN NUMBER,