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,
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,
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,
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,
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,
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,
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
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:
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
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';
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,
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,
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,
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,
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,
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
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:
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
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';
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,
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,
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,
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,
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,
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
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
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';
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;
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;
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,
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,
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,
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,
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
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
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';
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;
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;
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
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;
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;
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)
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:
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);
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;
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
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:
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,
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
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
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:
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;
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;
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';
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,
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,
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,
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,
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
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
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';
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;
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;
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,
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,
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,
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
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
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';
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;
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;
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
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:
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';
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;
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:
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;
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:
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
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,
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,
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,
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
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
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';
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;
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;
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,
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,
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
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
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';
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;
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;
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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: p_reamort_balance 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: p_reamort_balance IN NUMBER := OKC_API.G_MISS_NUM,
2720: p_reamort_date IN VARCHAR2,
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: p_reamort_balance IN NUMBER := OKC_API.G_MISS_NUM,
2720: p_reamort_date IN VARCHAR2,
2721: x_return_status OUT NOCOPY VARCHAR2
2722: ) IS
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: p_reamort_balance IN NUMBER := OKC_API.G_MISS_NUM,
2720: p_reamort_date IN VARCHAR2,
2721: x_return_status OUT NOCOPY VARCHAR2
2722: ) IS
2723: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_levels';
2853: l_orp_code VARCHAR2(10);
2854:
2855: l_api_version NUMBER := 1;
2856: l_api_name CONSTANT VARCHAR2(30) := 'process';
2857: l_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;
2858: l_return_status VARCHAR2(1);
2859: l_msg_count NUMBER;
2860: --srsreeni Bug 5599821 start
2861: l_msg_index_out NUMBER;