eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_POPULATE_PRCENG_RST_PUB dependencies on OKC_API

Line 55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

51: ---------------------------------------------------------------------------
52: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V
53: ---------------------------------------------------------------------------
54: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_id OUT NOCOPY NUMBER,
58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,

54: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_id OUT NOCOPY NUMBER,
58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_id OUT NOCOPY NUMBER,
58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

56: x_return_status OUT NOCOPY VARCHAR2,
57: x_id OUT NOCOPY NUMBER,
58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

57: x_id OUT NOCOPY NUMBER,
58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
65: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
65: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
66: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,

Line 63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
65: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
66: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
67: p_date_processed IN DATE

Line 64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
65: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
66: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
67: p_date_processed IN DATE
68:

Line 65: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
65: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
66: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
67: p_date_processed IN DATE
68:
69: ) IS

Line 66: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,

62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
65: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
66: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
67: p_date_processed IN DATE
68:
69: ) IS
70: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';

Line 219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,

215: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V
216: ---------------------------------------------------------------------------
217: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY NUMBER,
219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

216: ---------------------------------------------------------------------------
217: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY NUMBER,
219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

217: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY NUMBER,
219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

218: x_id OUT NOCOPY NUMBER,
219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
226: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
226: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
227: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,

Line 224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
226: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
227: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
228: p_date_processed IN DATE

Line 225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
226: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
227: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
228: p_date_processed IN DATE
229:

Line 226: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
226: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
227: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
228: p_date_processed IN DATE
229:
230: ) IS

Line 227: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,

223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
226: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
227: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
228: p_date_processed IN DATE
229:
230: ) IS
231: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';

Line 383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

379: -- PROCEUDRE populate_sif_rets
380: ----------------------------------------------------------------------------------------
381:
382: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
384: x_return_status OUT NOCOPY VARCHAR2,
385: x_id OUT NOCOPY NUMBER,
386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,

382: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
384: x_return_status OUT NOCOPY VARCHAR2,
385: x_id OUT NOCOPY NUMBER,
386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
384: x_return_status OUT NOCOPY VARCHAR2,
385: x_id OUT NOCOPY NUMBER,
386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

384: x_return_status OUT NOCOPY VARCHAR2,
385: x_id OUT NOCOPY NUMBER,
386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

385: x_id OUT NOCOPY NUMBER,
386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
393: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
393: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
394: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

Line 391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
393: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
394: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
395: ) IS

Line 392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
393: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
394: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
395: ) IS
396: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';

Line 393: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
393: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
394: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
395: ) IS
396: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
397: l_api_version CONSTANT NUMBER := 1;

Line 394: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
393: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
394: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
395: ) IS
396: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
397: l_api_version CONSTANT NUMBER := 1;
398: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 550: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,

546: ----------------------------------------------------------------------------------------
547:
548: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
549: x_id OUT NOCOPY NUMBER,
550: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

547:
548: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
549: x_id OUT NOCOPY NUMBER,
550: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

548: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
549: x_id OUT NOCOPY NUMBER,
550: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

549: x_id OUT NOCOPY NUMBER,
550: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
557: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

550: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
557: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
558: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

Line 555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
557: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
558: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
559: ) IS

Line 556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
557: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
558: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
559: ) IS
560: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';

Line 557: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
557: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
558: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
559: ) IS
560: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
561: l_api_version CONSTANT NUMBER := 1;

Line 558: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
557: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
558: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
559: ) IS
560: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
561: l_api_version CONSTANT NUMBER := 1;
562: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 715: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

711:
712: -- Added by saran
713:
714: PROCEDURE update_sif_rets (p_api_version IN NUMBER := 1.0,
715: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
716: x_return_status OUT NOCOPY VARCHAR2,
717: p_id IN NUMBER,
718: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)
719: IS

Line 718: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)

714: PROCEDURE update_sif_rets (p_api_version IN NUMBER := 1.0,
715: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
716: x_return_status OUT NOCOPY VARCHAR2,
717: p_id IN NUMBER,
718: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)
719: IS
720: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
721: l_api_version CONSTANT NUMBER := 1;
722: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 813: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)

809:
810: -- mvasudev, 04/24/2002
811: PROCEDURE update_sif_rets (x_return_status OUT NOCOPY VARCHAR2,
812: p_id IN NUMBER,
813: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)
814: IS
815: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
816:
817: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 913: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

909: ----------------------------------------------------------------------------------
910: -- PROCEDURE update_sif_rets
911: ----------------------------------------------------------------------------------
912: PROCEDURE update_sif_rets (p_api_version IN NUMBER := 1.0,
913: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
914: p_id IN NUMBER,
915: p_yield_name IN VARCHAR2,
916: p_amount IN NUMBER,
917: x_return_status OUT NOCOPY VARCHAR2)

Line 1120: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

1116: -- This procedure has been modified to accept a table of records in place of
1117: -- a single record.
1118: -- Bug - Start of Changes
1119: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
1120: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1121: p_strm_tbl IN strm_tbl_type,
1122: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1123: ) IS
1124:

Line 1122: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

1118: -- Bug - Start of Changes
1119: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
1120: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1121: p_strm_tbl IN strm_tbl_type,
1122: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1123: ) IS
1124:
1125: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1126: l_sre_date VARCHAR2(30);

Line 1139: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;

1135: l_strm_rec strm_rec_type;
1136:
1137: l_srsv_rec srsv_rec_type;
1138: l_srsv_tbl srsv_tbl_type;
1139: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;
1140: p_se_line_number NUMBER := 1;
1141: l_counter NUMBER := 0;
1142: l_stream_type_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR;
1143: l_description VARCHAR2(150) := OKC_API.G_MISS_CHAR;

Line 1142: l_stream_type_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR;

1138: l_srsv_tbl srsv_tbl_type;
1139: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;
1140: p_se_line_number NUMBER := 1;
1141: l_counter NUMBER := 0;
1142: l_stream_type_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR;
1143: l_description VARCHAR2(150) := OKC_API.G_MISS_CHAR;
1144:
1145: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1146: BEGIN

Line 1143: l_description VARCHAR2(150) := OKC_API.G_MISS_CHAR;

1139: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;
1140: p_se_line_number NUMBER := 1;
1141: l_counter NUMBER := 0;
1142: l_stream_type_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR;
1143: l_description VARCHAR2(150) := OKC_API.G_MISS_CHAR;
1144:
1145: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1146: BEGIN
1147:

Line 1263: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1259: -- PROCEDURE populate_sif_ret_strms for: OKL_SIF_RET_STREAMS_V
1260: ---------------------------------------------------------------------------
1261:
1262: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
1263: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1265: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1266: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1267: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

Line 1264: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,

1260: ---------------------------------------------------------------------------
1261:
1262: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
1263: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1265: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1266: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1267: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1268: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

Line 1265: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

1261:
1262: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
1263: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1265: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1266: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1267: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1268: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1269: ) IS

Line 1266: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,

1262: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
1263: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1265: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1266: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1267: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1268: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1269: ) IS
1270:

Line 1267: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

1263: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1264: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1265: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1266: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1267: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1268: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1269: ) IS
1270:
1271: p_api_version NUMBER := 1.0;

Line 1268: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

1264: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1265: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1266: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1267: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1268: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1269: ) IS
1270:
1271: p_api_version NUMBER := 1.0;
1272: x_id NUMBER;

Line 1273: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;

1269: ) IS
1270:
1271: p_api_version NUMBER := 1.0;
1272: x_id NUMBER;
1273: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;
1274: p_se_line_number NUMBER := 1;
1275: p_init_msg_list VARCHAR2(1) := 'F';
1276:
1277: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';

Line 1422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1418: -- PROCEDURE populate_sif_ret_strms for: OKL_SIF_RET_STREAMS_V
1419: ---------------------------------------------------------------------------
1420:
1421: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_id OUT NOCOPY NUMBER,
1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,

Line 1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1421: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_id OUT NOCOPY NUMBER,
1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,

1422: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_id OUT NOCOPY NUMBER,
1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,

Line 1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_id OUT NOCOPY NUMBER,
1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1431: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

Line 1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,

1424: x_id OUT NOCOPY NUMBER,
1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1431: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1432: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

Line 1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,

1425: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1431: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1432: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1433: ) IS

Line 1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,

1426: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1431: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1432: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1433: ) IS
1434: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';

Line 1431: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

1427: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1431: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1432: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1433: ) IS
1434: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
1435: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1432: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

1428: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1429: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1430: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1431: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1432: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1433: ) IS
1434: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
1435: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1436: l_srsv_rec srsv_rec_type;

Line 1579: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1575: -- PROCEDURE populate_sif_ret_strms for: OKL_SIF_RET_STREAMS_V
1576: ---------------------------------------------------------------------------
1577:
1578: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1579: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1580: x_return_status OUT NOCOPY VARCHAR2,
1581: x_id OUT NOCOPY NUMBER,
1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1578: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1579: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1580: x_return_status OUT NOCOPY VARCHAR2,
1581: x_id OUT NOCOPY NUMBER,
1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

1579: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1580: x_return_status OUT NOCOPY VARCHAR2,
1581: x_id OUT NOCOPY NUMBER,
1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

Line 1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,

1580: x_return_status OUT NOCOPY VARCHAR2,
1581: x_id OUT NOCOPY NUMBER,
1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1588: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

Line 1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,

1581: x_id OUT NOCOPY NUMBER,
1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1588: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1589: ) IS

Line 1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,

1582: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1588: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1589: ) IS
1590: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';

Line 1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

1583: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1588: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1589: ) IS
1590: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
1591: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1588: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

1584: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1585: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1586: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1587: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1588: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1589: ) IS
1590: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
1591: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1592: l_srsv_rec srsv_rec_type;

Line 1710: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,

1706: --Bug - Start of Changes
1707: PROCEDURE populate_sif_ret_errors (
1708: x_return_status OUT NOCOPY VARCHAR2,
1709: x_id OUT NOCOPY NUMBER,
1710: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1711: p_strm_excp_tbl IN strm_excp_tbl_type,
1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1708: x_return_status OUT NOCOPY VARCHAR2,
1709: x_id OUT NOCOPY NUMBER,
1710: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1711: p_strm_excp_tbl IN strm_excp_tbl_type,
1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1715: ) IS
1716:

Line 1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

1709: x_id OUT NOCOPY NUMBER,
1710: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1711: p_strm_excp_tbl IN strm_excp_tbl_type,
1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1715: ) IS
1716:
1717: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';

Line 1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

1710: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1711: p_strm_excp_tbl IN strm_excp_tbl_type,
1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1715: ) IS
1716:
1717: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1718: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;

1721: x_msg_data VARCHAR2(400);
1722: x_msg_count NUMBER ;
1723: l_strm_excp_rec strm_excp_rec_type;
1724: i NUMBER := 0;
1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;
1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;
1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;
1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;
1729:

Line 1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;

1722: x_msg_count NUMBER ;
1723: l_strm_excp_rec strm_excp_rec_type;
1724: i NUMBER := 0;
1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;
1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;
1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;
1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;
1729:
1730: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;

Line 1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;

1723: l_strm_excp_rec strm_excp_rec_type;
1724: i NUMBER := 0;
1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;
1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;
1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;
1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;
1729:
1730: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1731:

Line 1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;

1724: i NUMBER := 0;
1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;
1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;
1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;
1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;
1729:
1730: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1731:
1732: BEGIN

Line 1829: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1825: -- PROCEDURE populate_sif_ret_errors for: OKL_SIF_RET_ERRORS_V
1826: ---------------------------------------------------------------------------
1827:
1828: PROCEDURE populate_sif_ret_errors (p_api_version IN NUMBER := 1.0,
1829: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_id OUT NOCOPY NUMBER,
1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,

1828: PROCEDURE populate_sif_ret_errors (p_api_version IN NUMBER := 1.0,
1829: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_id OUT NOCOPY NUMBER,
1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,

1829: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_id OUT NOCOPY NUMBER,
1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

Line 1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,

1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_id OUT NOCOPY NUMBER,
1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,

1831: x_id OUT NOCOPY NUMBER,
1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1839: ) IS

Line 1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1839: ) IS
1840: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';

Line 1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1839: ) IS
1840: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1841: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1839: ) IS
1840: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1841: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1842: l_srmv_rec srmv_rec_type;

Line 1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,

1955: ---------------------------------------------------------------------------
1956:
1957: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1958: x_id OUT NOCOPY NUMBER,
1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,

1956:
1957: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1958: x_id OUT NOCOPY NUMBER,
1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

Line 1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,

1957: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1958: x_id OUT NOCOPY NUMBER,
1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,

1958: x_id OUT NOCOPY NUMBER,
1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1966: ) IS

Line 1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1966: ) IS
1967: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';

Line 1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1966: ) IS
1967: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1968: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1966: ) IS
1967: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1968: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1969: l_srmv_rec srmv_rec_type;

Line 2086: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2082: -- PROCEDURE populate_insured_residual
2083: ----------------------------------------------------------------------------------------
2084: PROCEDURE populate_insured_residual (
2085: p_api_version IN NUMBER,
2086: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2087: p_transaction_number IN NUMBER,
2088: p_amount IN NUMBER,
2089: p_sir_id IN NUMBER,
2090: x_return_status OUT NOCOPY VARCHAR2

Line 2375: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2371:
2372: /*
2373: PROCEDURE update_status (
2374: p_api_version IN NUMBER,
2375: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2376: p_transaction_number IN NUMBER,
2377: p_sis_code IN VARCHAR2,
2378: x_return_status OUT NOCOPY VARCHAR2
2379: ) IS

Line 2431: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2427: END update_status;
2428: */
2429: PROCEDURE update_status (
2430: p_api_version IN NUMBER,
2431: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2432: p_transaction_number IN NUMBER,
2433: p_sis_code IN VARCHAR2, -- outbound status
2434: p_srt_code IN VARCHAR2, -- inbound status
2435: p_log_file_name IN VARCHAR2,

Line 2707: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,

2703: END log_error_messages;
2704:
2705:
2706: PROCEDURE populate_sif_ret_levels (
2707: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2708: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2709: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 2708: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

2704:
2705:
2706: PROCEDURE populate_sif_ret_levels (
2707: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2708: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2709: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

Line 2709: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,

2705:
2706: PROCEDURE populate_sif_ret_levels (
2707: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2708: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2709: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

Line 2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,

2706: PROCEDURE populate_sif_ret_levels (
2707: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2708: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2709: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,

Line 2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,

2707: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2708: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2709: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2715: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,

Line 2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

2708: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2709: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2715: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2716: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,

Line 2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

2709: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2715: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2716: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2717: p_first_payment_date IN VARCHAR2,

Line 2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,

2710: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2715: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2716: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2717: p_first_payment_date IN VARCHAR2,
2718: p_rate IN NUMBER := OKC_API.G_MISS_NUM,

Line 2715: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,

2711: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2715: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2716: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2717: p_first_payment_date IN VARCHAR2,
2718: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
2719: x_return_status OUT NOCOPY VARCHAR2

Line 2716: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,

2712: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2713: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2715: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2716: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2717: p_first_payment_date IN VARCHAR2,
2718: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
2719: x_return_status OUT NOCOPY VARCHAR2
2720: ) IS

Line 2718: p_rate IN NUMBER := OKC_API.G_MISS_NUM,

2714: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2715: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2716: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2717: p_first_payment_date IN VARCHAR2,
2718: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
2719: x_return_status OUT NOCOPY VARCHAR2
2720: ) IS
2721: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_levels';
2722: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 2853: l_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;

2849: l_orp_code VARCHAR2(10);
2850:
2851: l_api_version NUMBER := 1;
2852: l_api_name CONSTANT VARCHAR2(30) := 'process';
2853: l_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;
2854: l_return_status VARCHAR2(1);
2855: l_msg_count NUMBER;
2856: --srsreeni Bug 5599821 start
2857: l_msg_index_out NUMBER;