3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE siy_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: yield_name OKL_SIF_YIELDS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
10: sif_id NUMBER := OKC_API.G_MISS_NUM,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE siy_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: yield_name OKL_SIF_YIELDS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
10: sif_id NUMBER := OKC_API.G_MISS_NUM,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE siy_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: yield_name OKL_SIF_YIELDS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
10: sif_id NUMBER := OKC_API.G_MISS_NUM,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
6: TYPE siy_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: yield_name OKL_SIF_YIELDS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
10: sif_id NUMBER := OKC_API.G_MISS_NUM,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: yield_name OKL_SIF_YIELDS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
10: sif_id NUMBER := OKC_API.G_MISS_NUM,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15: compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: yield_name OKL_SIF_YIELDS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
10: sif_id NUMBER := OKC_API.G_MISS_NUM,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15: compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
16: target_value NUMBER := OKC_API.G_MISS_NUM,
9: yield_name OKL_SIF_YIELDS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
10: sif_id NUMBER := OKC_API.G_MISS_NUM,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15: compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
16: target_value NUMBER := OKC_API.G_MISS_NUM,
17: index_number NUMBER := OKC_API.G_MISS_NUM,
10: sif_id NUMBER := OKC_API.G_MISS_NUM,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15: compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
16: target_value NUMBER := OKC_API.G_MISS_NUM,
17: index_number NUMBER := OKC_API.G_MISS_NUM,
18: nominal_yn OKL_SIF_YIELDS.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
11: method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15: compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
16: target_value NUMBER := OKC_API.G_MISS_NUM,
17: index_number NUMBER := OKC_API.G_MISS_NUM,
18: nominal_yn OKL_SIF_YIELDS.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
19: -- 04/29/2002, mvasudev
12: array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15: compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
16: target_value NUMBER := OKC_API.G_MISS_NUM,
17: index_number NUMBER := OKC_API.G_MISS_NUM,
18: nominal_yn OKL_SIF_YIELDS.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
19: -- 04/29/2002, mvasudev
20: -- added for "Restructure" requirements
13: roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15: compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
16: target_value NUMBER := OKC_API.G_MISS_NUM,
17: index_number NUMBER := OKC_API.G_MISS_NUM,
18: nominal_yn OKL_SIF_YIELDS.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
19: -- 04/29/2002, mvasudev
20: -- added for "Restructure" requirements
21: pre_tax_yn OKL_SIF_YIELDS.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
14: roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15: compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
16: target_value NUMBER := OKC_API.G_MISS_NUM,
17: index_number NUMBER := OKC_API.G_MISS_NUM,
18: nominal_yn OKL_SIF_YIELDS.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
19: -- 04/29/2002, mvasudev
20: -- added for "Restructure" requirements
21: pre_tax_yn OKL_SIF_YIELDS.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
22: -- mvasudev, 06/26/2002
17: index_number NUMBER := OKC_API.G_MISS_NUM,
18: nominal_yn OKL_SIF_YIELDS.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
19: -- 04/29/2002, mvasudev
20: -- added for "Restructure" requirements
21: pre_tax_yn OKL_SIF_YIELDS.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
22: -- mvasudev, 06/26/2002
23: siy_type OKL_SIF_YIELDS.siy_type%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute01 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
19: -- 04/29/2002, mvasudev
20: -- added for "Restructure" requirements
21: pre_tax_yn OKL_SIF_YIELDS.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
22: -- mvasudev, 06/26/2002
23: siy_type OKL_SIF_YIELDS.siy_type%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute01 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
20: -- added for "Restructure" requirements
21: pre_tax_yn OKL_SIF_YIELDS.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
22: -- mvasudev, 06/26/2002
23: siy_type OKL_SIF_YIELDS.siy_type%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute01 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
21: pre_tax_yn OKL_SIF_YIELDS.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
22: -- mvasudev, 06/26/2002
23: siy_type OKL_SIF_YIELDS.siy_type%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute01 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
22: -- mvasudev, 06/26/2002
23: siy_type OKL_SIF_YIELDS.siy_type%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute01 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
23: siy_type OKL_SIF_YIELDS.siy_type%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute01 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
24: stream_interface_attribute01 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
25: stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
26: stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
27: stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
28: stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
29: stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
30: stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
31: stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
32: stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_SIF_YIELDS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_SIF_YIELDS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_update_date OKL_SIF_YIELDS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
35: stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_SIF_YIELDS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_update_date OKL_SIF_YIELDS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_SIF_YIELDS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_update_date OKL_SIF_YIELDS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
44: g_miss_siy_rec siy_rec_type;
37: stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_SIF_YIELDS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_update_date OKL_SIF_YIELDS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
44: g_miss_siy_rec siy_rec_type;
45: TYPE siy_tbl_type IS TABLE OF siy_rec_type
38: stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_SIF_YIELDS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_update_date OKL_SIF_YIELDS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
44: g_miss_siy_rec siy_rec_type;
45: TYPE siy_tbl_type IS TABLE OF siy_rec_type
46: INDEX BY BINARY_INTEGER;
39: created_by NUMBER := OKC_API.G_MISS_NUM,
40: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_SIF_YIELDS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_update_date OKL_SIF_YIELDS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_update_login NUMBER := OKC_API.G_MISS_NUM);
44: g_miss_siy_rec siy_rec_type;
45: TYPE siy_tbl_type IS TABLE OF siy_rec_type
46: INDEX BY BINARY_INTEGER;
47: TYPE siyv_rec_type IS RECORD (
44: g_miss_siy_rec siy_rec_type;
45: TYPE siy_tbl_type IS TABLE OF siy_rec_type
46: INDEX BY BINARY_INTEGER;
47: TYPE siyv_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
51: sif_id NUMBER := OKC_API.G_MISS_NUM,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
45: TYPE siy_tbl_type IS TABLE OF siy_rec_type
46: INDEX BY BINARY_INTEGER;
47: TYPE siyv_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
51: sif_id NUMBER := OKC_API.G_MISS_NUM,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
46: INDEX BY BINARY_INTEGER;
47: TYPE siyv_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
51: sif_id NUMBER := OKC_API.G_MISS_NUM,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
47: TYPE siyv_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
51: sif_id NUMBER := OKC_API.G_MISS_NUM,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
51: sif_id NUMBER := OKC_API.G_MISS_NUM,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
51: sif_id NUMBER := OKC_API.G_MISS_NUM,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
57: target_value NUMBER := OKC_API.G_MISS_NUM,
50: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
51: sif_id NUMBER := OKC_API.G_MISS_NUM,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
57: target_value NUMBER := OKC_API.G_MISS_NUM,
58: index_number NUMBER := OKC_API.G_MISS_NUM,
51: sif_id NUMBER := OKC_API.G_MISS_NUM,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
57: target_value NUMBER := OKC_API.G_MISS_NUM,
58: index_number NUMBER := OKC_API.G_MISS_NUM,
59: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
52: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
57: target_value NUMBER := OKC_API.G_MISS_NUM,
58: index_number NUMBER := OKC_API.G_MISS_NUM,
59: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
60: -- 04/29/2002, mvasudev
53: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
57: target_value NUMBER := OKC_API.G_MISS_NUM,
58: index_number NUMBER := OKC_API.G_MISS_NUM,
59: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
60: -- 04/29/2002, mvasudev
61: -- added for "Restructure" requirements
54: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
57: target_value NUMBER := OKC_API.G_MISS_NUM,
58: index_number NUMBER := OKC_API.G_MISS_NUM,
59: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
60: -- 04/29/2002, mvasudev
61: -- added for "Restructure" requirements
62: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
55: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
57: target_value NUMBER := OKC_API.G_MISS_NUM,
58: index_number NUMBER := OKC_API.G_MISS_NUM,
59: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
60: -- 04/29/2002, mvasudev
61: -- added for "Restructure" requirements
62: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- mvasudev, 06/26/2002
58: index_number NUMBER := OKC_API.G_MISS_NUM,
59: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
60: -- 04/29/2002, mvasudev
61: -- added for "Restructure" requirements
62: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- mvasudev, 06/26/2002
64: siy_type OKL_SIF_YIELDS_V.siy_type%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute01 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
60: -- 04/29/2002, mvasudev
61: -- added for "Restructure" requirements
62: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- mvasudev, 06/26/2002
64: siy_type OKL_SIF_YIELDS_V.siy_type%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute01 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
61: -- added for "Restructure" requirements
62: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- mvasudev, 06/26/2002
64: siy_type OKL_SIF_YIELDS_V.siy_type%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute01 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
62: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
63: -- mvasudev, 06/26/2002
64: siy_type OKL_SIF_YIELDS_V.siy_type%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute01 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
63: -- mvasudev, 06/26/2002
64: siy_type OKL_SIF_YIELDS_V.siy_type%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute01 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
64: siy_type OKL_SIF_YIELDS_V.siy_type%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute01 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
65: stream_interface_attribute01 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
66: stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
67: stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
68: stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
69: stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
70: stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
71: stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
72: stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
73: stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
74: stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: creation_date OKL_SIF_YIELDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: creation_date OKL_SIF_YIELDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_date OKL_SIF_YIELDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: creation_date OKL_SIF_YIELDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_date OKL_SIF_YIELDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: creation_date OKL_SIF_YIELDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_date OKL_SIF_YIELDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM);
85: g_miss_siyv_rec siyv_rec_type;
78: stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: creation_date OKL_SIF_YIELDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_date OKL_SIF_YIELDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM);
85: g_miss_siyv_rec siyv_rec_type;
86: TYPE siyv_tbl_type IS TABLE OF siyv_rec_type
79: stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: creation_date OKL_SIF_YIELDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_date OKL_SIF_YIELDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM);
85: g_miss_siyv_rec siyv_rec_type;
86: TYPE siyv_tbl_type IS TABLE OF siyv_rec_type
87: INDEX BY BINARY_INTEGER;
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: creation_date OKL_SIF_YIELDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_date OKL_SIF_YIELDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM);
85: g_miss_siyv_rec siyv_rec_type;
86: TYPE siyv_tbl_type IS TABLE OF siyv_rec_type
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
92: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102: ---------------------------------------------------------------------------
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102: ---------------------------------------------------------------------------
103: -- GLOBAL VARIABLES
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102: ---------------------------------------------------------------------------
103: -- GLOBAL VARIABLES
104: ---------------------------------------------------------------------------
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102: ---------------------------------------------------------------------------
103: -- GLOBAL VARIABLES
104: ---------------------------------------------------------------------------
105: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SIY_PVT';
131: PROCEDURE change_version;
132: PROCEDURE api_copy;
133: PROCEDURE insert_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_siyv_rec IN siyv_rec_type,
140: x_siyv_rec OUT NOCOPY siyv_rec_type);
141:
142: PROCEDURE insert_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_siyv_tbl IN siyv_tbl_type,
149: x_siyv_tbl OUT NOCOPY siyv_tbl_type);
150:
151: PROCEDURE lock_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_siyv_rec IN siyv_rec_type);
157: p_siyv_rec IN siyv_rec_type);
158:
159: PROCEDURE lock_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_siyv_tbl IN siyv_tbl_type);
165: p_siyv_tbl IN siyv_tbl_type);
166:
167: PROCEDURE update_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_siyv_rec IN siyv_rec_type,
174: x_siyv_rec OUT NOCOPY siyv_rec_type);
175:
176: PROCEDURE update_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_siyv_tbl IN siyv_tbl_type,
183: x_siyv_tbl OUT NOCOPY siyv_tbl_type);
184:
185: PROCEDURE delete_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_siyv_rec IN siyv_rec_type);
191: p_siyv_rec IN siyv_rec_type);
192:
193: PROCEDURE delete_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_siyv_tbl IN siyv_tbl_type);
199: p_siyv_tbl IN siyv_tbl_type);
200:
201: PROCEDURE validate_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_siyv_rec IN siyv_rec_type);
207: p_siyv_rec IN siyv_rec_type);
208:
209: PROCEDURE validate_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_siyv_tbl IN siyv_tbl_type);