5: ---------------------------------------------------------------------------
6: TYPE sir_rec_type IS RECORD (
7: id NUMBER:= OKC_API.G_MISS_NUM,
8: transaction_number NUMBER := OKC_API.G_MISS_NUM,
9: srt_code OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: effective_pre_tax_yield NUMBER:= OKC_API.G_MISS_NUM,
11: yield_name OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
12: index_number NUMBER := OKC_API.G_MISS_NUM,
13: effective_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER:= OKC_API.G_MISS_NUM,
8: transaction_number NUMBER := OKC_API.G_MISS_NUM,
9: srt_code OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: effective_pre_tax_yield NUMBER:= OKC_API.G_MISS_NUM,
11: yield_name OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
12: index_number NUMBER := OKC_API.G_MISS_NUM,
13: effective_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
14: nominal_pre_tax_yield NUMBER := OKC_API.G_MISS_NUM,
15: nominal_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
13: effective_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
14: nominal_pre_tax_yield NUMBER := OKC_API.G_MISS_NUM,
15: nominal_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
16: stream_interface_attribute01 OKL_STREAM_INTERFACES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
17: stream_interface_attribute02 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
18: stream_interface_attribute03 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
19: stream_interface_attribute04 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
20: stream_interface_attribute05 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
14: nominal_pre_tax_yield NUMBER := OKC_API.G_MISS_NUM,
15: nominal_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
16: stream_interface_attribute01 OKL_STREAM_INTERFACES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
17: stream_interface_attribute02 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
18: stream_interface_attribute03 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
19: stream_interface_attribute04 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
20: stream_interface_attribute05 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
15: nominal_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
16: stream_interface_attribute01 OKL_STREAM_INTERFACES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
17: stream_interface_attribute02 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
18: stream_interface_attribute03 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
19: stream_interface_attribute04 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
20: stream_interface_attribute05 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
16: stream_interface_attribute01 OKL_STREAM_INTERFACES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
17: stream_interface_attribute02 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
18: stream_interface_attribute03 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
19: stream_interface_attribute04 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
20: stream_interface_attribute05 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
17: stream_interface_attribute02 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
18: stream_interface_attribute03 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
19: stream_interface_attribute04 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
20: stream_interface_attribute05 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
18: stream_interface_attribute03 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
19: stream_interface_attribute04 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
20: stream_interface_attribute05 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
19: stream_interface_attribute04 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
20: stream_interface_attribute05 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
20: stream_interface_attribute05 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute13 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
21: stream_interface_attribute06 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute13 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute14 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
22: stream_interface_attribute07 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute13 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute14 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute15 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
23: stream_interface_attribute08 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute13 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute14 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute15 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number OKL_SIF_RETS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
24: stream_interface_attribute09 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute13 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute14 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute15 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number OKL_SIF_RETS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
25: stream_interface_attribute10 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute13 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute14 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute15 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number OKL_SIF_RETS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: stream_interface_attribute11 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute13 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute14 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute15 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number OKL_SIF_RETS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_SIF_RETS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
27: stream_interface_attribute12 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute13 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute14 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute15 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number OKL_SIF_RETS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_SIF_RETS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_date OKL_SIF_RETS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: stream_interface_attribute15 OKL_SIF_RETS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number OKL_SIF_RETS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_SIF_RETS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_date OKL_SIF_RETS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM,
37: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
38: date_processed OKL_SIF_RETS.DATE_PROCESSED%TYPE := OKC_API.G_MISS_DATE,
31: object_version_number OKL_SIF_RETS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKL_SIF_RETS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_date OKL_SIF_RETS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM,
37: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
38: date_processed OKL_SIF_RETS.DATE_PROCESSED%TYPE := OKC_API.G_MISS_DATE,
39: -- mvasudev -- 02/21/2002
34: creation_date OKL_SIF_RETS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_date OKL_SIF_RETS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM,
37: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
38: date_processed OKL_SIF_RETS.DATE_PROCESSED%TYPE := OKC_API.G_MISS_DATE,
39: -- mvasudev -- 02/21/2002
40: -- new columns added for concurrent program manager
41: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
42: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
40: -- new columns added for concurrent program manager
41: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
42: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
43: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
44: PROGRAM_UPDATE_DATE OKL_SIF_RETS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
45: -- mvasudev -- 02/21/2002
46: );
47: g_miss_sir_rec sir_rec_type;
48:
50: INDEX BY BINARY_INTEGER;
51: TYPE sirv_rec_type IS RECORD (
52: id NUMBER:= OKC_API.G_MISS_NUM,
53: transaction_number NUMBER := OKC_API.G_MISS_NUM,
54: srt_code OKL_SIF_RETS_V.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
55: effective_pre_tax_yield NUMBER:= OKC_API.G_MISS_NUM,
56: yield_name OKL_SIF_RETS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
57: index_number NUMBER := OKC_API.G_MISS_NUM,
58: effective_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
52: id NUMBER:= OKC_API.G_MISS_NUM,
53: transaction_number NUMBER := OKC_API.G_MISS_NUM,
54: srt_code OKL_SIF_RETS_V.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
55: effective_pre_tax_yield NUMBER:= OKC_API.G_MISS_NUM,
56: yield_name OKL_SIF_RETS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
57: index_number NUMBER := OKC_API.G_MISS_NUM,
58: effective_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
59: nominal_pre_tax_yield NUMBER := OKC_API.G_MISS_NUM,
60: nominal_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
58: effective_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
59: nominal_pre_tax_yield NUMBER := OKC_API.G_MISS_NUM,
60: nominal_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
61: stream_interface_attribute01 OKL_STREAM_INTERFACES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
62: stream_interface_attribute02 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
63: stream_interface_attribute03 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
64: stream_interface_attribute04 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute05 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
59: nominal_pre_tax_yield NUMBER := OKC_API.G_MISS_NUM,
60: nominal_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
61: stream_interface_attribute01 OKL_STREAM_INTERFACES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
62: stream_interface_attribute02 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
63: stream_interface_attribute03 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
64: stream_interface_attribute04 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute05 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
60: nominal_after_tax_yield NUMBER := OKC_API.G_MISS_NUM,
61: stream_interface_attribute01 OKL_STREAM_INTERFACES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
62: stream_interface_attribute02 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
63: stream_interface_attribute03 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
64: stream_interface_attribute04 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute05 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
61: stream_interface_attribute01 OKL_STREAM_INTERFACES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
62: stream_interface_attribute02 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
63: stream_interface_attribute03 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
64: stream_interface_attribute04 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute05 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
62: stream_interface_attribute02 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
63: stream_interface_attribute03 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
64: stream_interface_attribute04 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute05 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: stream_interface_attribute03 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
64: stream_interface_attribute04 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute05 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: stream_interface_attribute04 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute05 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute05 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute13 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute06 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute13 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute14 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute07 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute13 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute14 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute15 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute08 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute13 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute14 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute15 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: object_version_number OKL_SIF_RETS_V.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
69: stream_interface_attribute09 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute13 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute14 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute15 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: object_version_number OKL_SIF_RETS_V.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
70: stream_interface_attribute10 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute13 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute14 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute15 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: object_version_number OKL_SIF_RETS_V.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: stream_interface_attribute11 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute13 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute14 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute15 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: object_version_number OKL_SIF_RETS_V.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKL_SIF_RETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: stream_interface_attribute12 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute13 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute14 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute15 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: object_version_number OKL_SIF_RETS_V.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKL_SIF_RETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_date OKL_SIF_RETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
75: stream_interface_attribute15 OKL_SIF_RETS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: object_version_number OKL_SIF_RETS_V.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKL_SIF_RETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_date OKL_SIF_RETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
83: date_processed OKL_SIF_RETS_V.DATE_PROCESSED%TYPE := OKC_API.G_MISS_DATE,
76: object_version_number OKL_SIF_RETS_V.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKL_SIF_RETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_date OKL_SIF_RETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
83: date_processed OKL_SIF_RETS_V.DATE_PROCESSED%TYPE := OKC_API.G_MISS_DATE,
84: -- mvasudev -- 02/21/2002
79: creation_date OKL_SIF_RETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_date OKL_SIF_RETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
83: date_processed OKL_SIF_RETS_V.DATE_PROCESSED%TYPE := OKC_API.G_MISS_DATE,
84: -- mvasudev -- 02/21/2002
85: -- new columns added for concurrent program manager
86: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
87: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
85: -- new columns added for concurrent program manager
86: REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
87: PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
88: PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
89: PROGRAM_UPDATE_DATE OKL_SIF_RETS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
90: -- mvasudev -- 02/21/2002
91: );
92: g_miss_sirv_rec sirv_rec_type;
93: TYPE sirv_tbl_type IS TABLE OF sirv_rec_type