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_RESULT_PUB dependencies on OKC_API

Line 46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

42: ---------------------------------------------------------------------------
43: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V
44: ---------------------------------------------------------------------------
45: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_id OUT NOCOPY NUMBER,
49: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

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

45: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_id OUT NOCOPY NUMBER,
49: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

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

46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_id OUT NOCOPY NUMBER,
49: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

47: x_return_status OUT NOCOPY VARCHAR2,
48: x_id OUT NOCOPY NUMBER,
49: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
55: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

48: x_id OUT NOCOPY NUMBER,
49: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
55: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
56: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

49: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
55: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
56: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
57: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,

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

50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
55: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
56: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
57: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
58: p_date_processed IN DATE

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

51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
55: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
56: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
57: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
58: p_date_processed IN DATE
59:

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

52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
55: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
56: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
57: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
58: p_date_processed IN DATE
59:
60: ) IS

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

53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
55: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
56: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
57: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
58: p_date_processed IN DATE
59:
60: ) IS
61: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';

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

178: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V
179: ---------------------------------------------------------------------------
180: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
181: x_id OUT NOCOPY NUMBER,
182: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
183: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

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

179: ---------------------------------------------------------------------------
180: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
181: x_id OUT NOCOPY NUMBER,
182: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
183: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

180: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
181: x_id OUT NOCOPY NUMBER,
182: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
183: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
188: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

181: x_id OUT NOCOPY NUMBER,
182: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
183: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
188: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
189: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

182: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
183: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
188: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
189: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
190: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,

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

183: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
188: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
189: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
190: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
191: p_date_processed IN DATE

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

184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
188: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
189: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
190: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
191: p_date_processed IN DATE
192:

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

185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
188: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
189: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
190: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
191: p_date_processed IN DATE
192:
193: ) IS

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

186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
188: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
189: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
190: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM,
191: p_date_processed IN DATE
192:
193: ) IS
194: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';

Line 317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

313: -- PROCEUDRE populate_sif_rets
314: ----------------------------------------------------------------------------------------
315:
316: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_id OUT NOCOPY NUMBER,
320: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

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

316: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_id OUT NOCOPY NUMBER,
320: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

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

317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_id OUT NOCOPY NUMBER,
320: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

318: x_return_status OUT NOCOPY VARCHAR2,
319: x_id OUT NOCOPY NUMBER,
320: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
326: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

319: x_id OUT NOCOPY NUMBER,
320: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
326: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
327: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

320: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
326: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
327: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
328: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

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

321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
326: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
327: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
328: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
329: ) IS

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

322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
326: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
327: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
328: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
329: ) IS
330: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';

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

323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
326: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
327: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
328: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
329: ) IS
330: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
331: l_api_version CONSTANT NUMBER := 1;

Line 328: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
326: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
327: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
328: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
329: ) IS
330: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
331: l_api_version CONSTANT NUMBER := 1;
332: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

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

452: ----------------------------------------------------------------------------------------
453:
454: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
455: x_id OUT NOCOPY NUMBER,
456: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
457: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

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

453:
454: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
455: x_id OUT NOCOPY NUMBER,
456: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
457: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

454: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
455: x_id OUT NOCOPY NUMBER,
456: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
457: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
462: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

455: x_id OUT NOCOPY NUMBER,
456: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
457: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
462: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
463: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

456: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
457: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
462: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
463: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
464: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

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

457: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
462: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
463: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
464: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
465: ) IS

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

458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
462: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
463: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
464: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
465: ) IS
466: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';

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

459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
462: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
463: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
464: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
465: ) IS
466: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
467: l_api_version CONSTANT NUMBER := 1;

Line 464: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
462: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
463: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
464: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
465: ) IS
466: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
467: l_api_version CONSTANT NUMBER := 1;
468: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 594: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

590:
591: -- Added by saran
592:
593: PROCEDURE update_sif_rets (p_api_version IN NUMBER := 1.0,
594: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
595: x_return_status OUT NOCOPY VARCHAR2,
596: p_id IN NUMBER,
597: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)
598: IS

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

593: PROCEDURE update_sif_rets (p_api_version IN NUMBER := 1.0,
594: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
595: x_return_status OUT NOCOPY VARCHAR2,
596: p_id IN NUMBER,
597: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)
598: IS
599: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
600: l_api_version CONSTANT NUMBER := 1;
601: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

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

673:
674: -- mvasudev, 04/24/2002
675: PROCEDURE update_sif_rets (x_return_status OUT NOCOPY VARCHAR2,
676: p_id IN NUMBER,
677: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM)
678: IS
679: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
680:
681: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 761: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

757: ----------------------------------------------------------------------------------
758: -- PROCEDURE update_sif_rets
759: ----------------------------------------------------------------------------------
760: PROCEDURE update_sif_rets (p_api_version IN NUMBER := 1.0,
761: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
762: p_id IN NUMBER,
763: p_yield_name IN VARCHAR2,
764: p_amount IN NUMBER,
765: x_return_status OUT NOCOPY VARCHAR2)

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

931: -- PROCEDURE populate_sif_ret_strms for: OKL_SIF_RET_STREAMS_V
932: ---------------------------------------------------------------------------
933:
934: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
935: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
936: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
937: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
938: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
939: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

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

932: ---------------------------------------------------------------------------
933:
934: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
935: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
936: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
937: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
938: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
939: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
940: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

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

933:
934: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
935: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
936: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
937: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
938: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
939: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
940: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
941: ) IS

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

934: PROCEDURE populate_sif_ret_strms (x_return_status OUT NOCOPY VARCHAR2,
935: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
936: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
937: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
938: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
939: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
940: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
941: ) IS
942:

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

935: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
936: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
937: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
938: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
939: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
940: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
941: ) IS
942:
943: p_api_version NUMBER := 1.0;

Line 940: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

936: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
937: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
938: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
939: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
940: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
941: ) IS
942:
943: p_api_version NUMBER := 1.0;
944: x_id NUMBER;

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

941: ) IS
942:
943: p_api_version NUMBER := 1.0;
944: x_id NUMBER;
945: p_activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR;
946: p_se_line_number NUMBER := 1;
947: p_init_msg_list VARCHAR2(1) := 'F';
948:
949: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';

Line 1078: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1074: -- PROCEDURE populate_sif_ret_strms for: OKL_SIF_RET_STREAMS_V
1075: ---------------------------------------------------------------------------
1076:
1077: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1078: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1079: x_return_status OUT NOCOPY VARCHAR2,
1080: x_id OUT NOCOPY NUMBER,
1081: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1082: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,

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

1077: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1078: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1079: x_return_status OUT NOCOPY VARCHAR2,
1080: x_id OUT NOCOPY NUMBER,
1081: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1082: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1083: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1084: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1085: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,

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

1078: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1079: x_return_status OUT NOCOPY VARCHAR2,
1080: x_id OUT NOCOPY NUMBER,
1081: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1082: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1083: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1084: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1085: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1086: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,

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

1079: x_return_status OUT NOCOPY VARCHAR2,
1080: x_id OUT NOCOPY NUMBER,
1081: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1082: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1083: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1084: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1085: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1086: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1087: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

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

1080: x_id OUT NOCOPY NUMBER,
1081: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1082: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1083: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1084: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1085: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1086: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1087: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1088: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

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

1081: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1082: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1083: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1084: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1085: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1086: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1087: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1088: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1089: ) IS

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

1082: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1083: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1084: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1085: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1086: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1087: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1088: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1089: ) IS
1090: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';

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

1083: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1084: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1085: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1086: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1087: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1088: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1089: ) IS
1090: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
1091: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1088: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

1084: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1085: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1086: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
1087: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1088: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1089: ) IS
1090: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
1091: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1092: l_srsv_rec srsv_rec_type;

Line 1219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1215: -- PROCEDURE populate_sif_ret_strms for: OKL_SIF_RET_STREAMS_V
1216: ---------------------------------------------------------------------------
1217:
1218: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1220: x_return_status OUT NOCOPY VARCHAR2,
1221: x_id OUT NOCOPY NUMBER,
1222: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

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

1218: PROCEDURE populate_sif_ret_strms (p_api_version IN NUMBER := 1.0,
1219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1220: x_return_status OUT NOCOPY VARCHAR2,
1221: x_id OUT NOCOPY NUMBER,
1222: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1224: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1225: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1226: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,

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

1219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1220: x_return_status OUT NOCOPY VARCHAR2,
1221: x_id OUT NOCOPY NUMBER,
1222: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1224: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1225: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1226: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1227: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

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

1220: x_return_status OUT NOCOPY VARCHAR2,
1221: x_id OUT NOCOPY NUMBER,
1222: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1224: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1225: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1226: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1227: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1228: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

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

1221: x_id OUT NOCOPY NUMBER,
1222: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1224: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1225: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1226: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1227: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1228: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1229: ) IS

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

1222: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1224: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1225: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1226: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1227: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1228: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1229: ) IS
1230: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';

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

1223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
1224: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1225: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1226: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1227: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1228: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1229: ) IS
1230: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
1231: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1228: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM

1224: p_activity_type IN OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
1225: p_se_line_number IN NUMBER := OKC_API.G_MISS_NUM,
1226: p_sre_date IN OKL_SIF_RET_STRMS.SRE_DATE%TYPE := OKC_API.G_MISS_DATE,
1227: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
1228: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM
1229: ) IS
1230: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
1231: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1232: l_srsv_rec srsv_rec_type;

Line 1331: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1327: -- PROCEDURE populate_sif_ret_errors for: OKL_SIF_RET_ERRORS_V
1328: ---------------------------------------------------------------------------
1329:
1330: PROCEDURE populate_sif_ret_errors (p_api_version IN NUMBER := 1.0,
1331: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1332: x_return_status OUT NOCOPY VARCHAR2,
1333: x_id OUT NOCOPY NUMBER,
1334: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1335: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,

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

1330: PROCEDURE populate_sif_ret_errors (p_api_version IN NUMBER := 1.0,
1331: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1332: x_return_status OUT NOCOPY VARCHAR2,
1333: x_id OUT NOCOPY NUMBER,
1334: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1335: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1336: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1337: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1338: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

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

1331: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1332: x_return_status OUT NOCOPY VARCHAR2,
1333: x_id OUT NOCOPY NUMBER,
1334: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1335: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1336: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1337: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1338: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1339: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

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

1332: x_return_status OUT NOCOPY VARCHAR2,
1333: x_id OUT NOCOPY NUMBER,
1334: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1335: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1336: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1337: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1338: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1339: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1340: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

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

1333: x_id OUT NOCOPY NUMBER,
1334: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1335: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1336: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1337: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1338: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1339: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1340: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1341: ) IS

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

1334: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1335: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1336: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1337: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1338: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1339: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1340: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1341: ) IS
1342: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';

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

1335: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1336: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1337: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1338: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1339: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1340: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1341: ) IS
1342: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1343: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

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

1336: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1337: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1338: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1339: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1340: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1341: ) IS
1342: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1343: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1344: l_srmv_rec srmv_rec_type;

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

1439: ---------------------------------------------------------------------------
1440:
1441: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1442: x_id OUT NOCOPY NUMBER,
1443: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1444: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1445: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1446: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1447: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

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

1440:
1441: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1442: x_id OUT NOCOPY NUMBER,
1443: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1444: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1445: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1446: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1447: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1448: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

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

1441: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1442: x_id OUT NOCOPY NUMBER,
1443: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1444: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1445: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1446: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1447: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1448: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1449: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

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

1442: x_id OUT NOCOPY NUMBER,
1443: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1444: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1445: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1446: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1447: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1448: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1449: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1450: ) IS

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

1443: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1444: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1445: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1446: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1447: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1448: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1449: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1450: ) IS
1451: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';

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

1444: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1445: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1446: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1447: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1448: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1449: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1450: ) IS
1451: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1452: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

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

1445: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1446: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1447: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1448: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1449: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1450: ) IS
1451: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1452: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1453: l_srmv_rec srmv_rec_type;

Line 1554: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1550: -- PROCEDURE populate_insured_residual
1551: ----------------------------------------------------------------------------------------
1552: PROCEDURE populate_insured_residual (
1553: p_api_version IN NUMBER,
1554: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1555: p_transaction_number IN NUMBER,
1556: p_amount IN NUMBER,
1557: p_sir_id IN NUMBER,
1558: x_return_status OUT NOCOPY VARCHAR2

Line 1809: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1805:
1806: /*
1807: PROCEDURE update_status (
1808: p_api_version IN NUMBER,
1809: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1810: p_transaction_number IN NUMBER,
1811: p_sis_code IN VARCHAR2,
1812: x_return_status OUT NOCOPY VARCHAR2
1813: ) IS

Line 1865: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1861: END update_status;
1862: */
1863: PROCEDURE update_status (
1864: p_api_version IN NUMBER,
1865: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1866: p_transaction_number IN NUMBER,
1867: p_sis_code IN VARCHAR2, -- outbound status
1868: p_srt_code IN VARCHAR2, -- inbound status
1869: p_log_file_name IN VARCHAR2,

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

2137: END log_error_messages;
2138:
2139:
2140: PROCEDURE populate_sif_ret_levels (
2141: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2142: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2143: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2144: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,

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

2138:
2139:
2140: PROCEDURE populate_sif_ret_levels (
2141: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2142: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2143: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2144: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

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

2139:
2140: PROCEDURE populate_sif_ret_levels (
2141: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2142: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2143: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2144: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2147: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

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

2140: PROCEDURE populate_sif_ret_levels (
2141: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2142: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2143: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2144: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2147: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2148: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,

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

2141: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
2142: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2143: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2144: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2147: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2148: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2149: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,

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

2142: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2143: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2144: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2147: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2148: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2149: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2150: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,

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

2143: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
2144: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2147: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2148: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2149: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2150: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2151: p_first_payment_date IN VARCHAR2,

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

2144: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2147: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2148: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2149: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2150: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2151: p_first_payment_date IN VARCHAR2,
2152: p_rate IN NUMBER := OKC_API.G_MISS_NUM,

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

2145: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2147: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2148: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2149: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2150: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2151: p_first_payment_date IN VARCHAR2,
2152: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
2153: x_return_status OUT NOCOPY VARCHAR2

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

2146: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
2147: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
2148: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2149: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2150: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2151: p_first_payment_date IN VARCHAR2,
2152: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
2153: x_return_status OUT NOCOPY VARCHAR2
2154: ) IS

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

2148: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
2149: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
2150: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
2151: p_first_payment_date IN VARCHAR2,
2152: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
2153: x_return_status OUT NOCOPY VARCHAR2
2154: ) IS
2155: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_levels';
2156: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;