3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sty_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: version OKL_STRM_TYPE_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
9: code OKL_STRM_TYPE_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
10: -- customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sty_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: version OKL_STRM_TYPE_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
9: code OKL_STRM_TYPE_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
10: -- customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
12: -- stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE sty_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: version OKL_STRM_TYPE_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
9: code OKL_STRM_TYPE_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
10: -- customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
12: -- stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
13: stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := 'BOTH',
6: TYPE sty_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: version OKL_STRM_TYPE_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
9: code OKL_STRM_TYPE_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
10: -- customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
12: -- stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
13: stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := 'BOTH',
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
8: version OKL_STRM_TYPE_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
9: code OKL_STRM_TYPE_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
10: -- customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
12: -- stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
13: stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := 'BOTH',
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: accrual_yn OKL_STRM_TYPE_B.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxable_default_yn OKL_STRM_TYPE_B.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
10: -- customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
12: -- stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
13: stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := 'BOTH',
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: accrual_yn OKL_STRM_TYPE_B.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxable_default_yn OKL_STRM_TYPE_B.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
17: -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
18: stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
11: customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
12: -- stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
13: stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := 'BOTH',
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: accrual_yn OKL_STRM_TYPE_B.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxable_default_yn OKL_STRM_TYPE_B.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
17: -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
18: stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
19: stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
12: -- stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
13: stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := 'BOTH',
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: accrual_yn OKL_STRM_TYPE_B.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxable_default_yn OKL_STRM_TYPE_B.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
17: -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
18: stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
19: stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
20: start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
13: stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := 'BOTH',
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: accrual_yn OKL_STRM_TYPE_B.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxable_default_yn OKL_STRM_TYPE_B.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
17: -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
18: stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
19: stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
20: start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
21: end_date OKL_STRM_TYPE_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: accrual_yn OKL_STRM_TYPE_B.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxable_default_yn OKL_STRM_TYPE_B.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
17: -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
18: stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
19: stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
20: start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
21: end_date OKL_STRM_TYPE_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
22: billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
23: capitalize_yn OKL_STRM_TYPE_B.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
16: taxable_default_yn OKL_STRM_TYPE_B.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
17: -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
18: stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
19: stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
20: start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
21: end_date OKL_STRM_TYPE_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
22: billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
23: capitalize_yn OKL_STRM_TYPE_B.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: -- periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
17: -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
18: stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
19: stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
20: start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
21: end_date OKL_STRM_TYPE_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
22: billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
23: capitalize_yn OKL_STRM_TYPE_B.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: -- periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
25: periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
18: stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
19: stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
20: start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
21: end_date OKL_STRM_TYPE_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
22: billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
23: capitalize_yn OKL_STRM_TYPE_B.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: -- periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
25: periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
26: -- fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
20: start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
21: end_date OKL_STRM_TYPE_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
22: billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
23: capitalize_yn OKL_STRM_TYPE_B.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: -- periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
25: periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
26: -- fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
27: fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
20: start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
21: end_date OKL_STRM_TYPE_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
22: billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
23: capitalize_yn OKL_STRM_TYPE_B.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: -- periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
25: periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
26: -- fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
27: fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
28: -- mvasudev , 05/13/2002
22: billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
23: capitalize_yn OKL_STRM_TYPE_B.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: -- periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
25: periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
26: -- fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
27: fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
28: -- mvasudev , 05/13/2002
29: -- allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
30: allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
25: periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
26: -- fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
27: fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
28: -- mvasudev , 05/13/2002
29: -- allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
30: allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
31: --
32: attribute_category OKL_STRM_TYPE_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: -- mvasudev , 05/13/2002
29: -- allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
30: allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
31: --
32: attribute_category OKL_STRM_TYPE_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: -- allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
30: allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
31: --
32: attribute_category OKL_STRM_TYPE_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
31: --
32: attribute_category OKL_STRM_TYPE_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: --
32: attribute_category OKL_STRM_TYPE_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute_category OKL_STRM_TYPE_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute1 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
41: attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
43: attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
44: attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
45: attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: -- Added by RGOOTY for ER 3935682: Start
46: attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: -- Added by RGOOTY for ER 3935682: Start
54: stream_type_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR,
47: attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: -- Added by RGOOTY for ER 3935682: Start
54: stream_type_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR,
55: contingency OKL_STRM_TYPE_B.CONTINGENCY%TYPE := OKC_API.G_MISS_CHAR,
48: created_by NUMBER := OKC_API.G_MISS_NUM,
49: creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: -- Added by RGOOTY for ER 3935682: Start
54: stream_type_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR,
55: contingency OKL_STRM_TYPE_B.CONTINGENCY%TYPE := OKC_API.G_MISS_CHAR,
56: -- Added by RGOOTY for ER 3935682: End
50: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51: last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: -- Added by RGOOTY for ER 3935682: Start
54: stream_type_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR,
55: contingency OKL_STRM_TYPE_B.CONTINGENCY%TYPE := OKC_API.G_MISS_CHAR,
56: -- Added by RGOOTY for ER 3935682: End
57:
58: -- Added by SNANDIKO for Bug 6744584 Start
51: last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: last_update_login NUMBER := OKC_API.G_MISS_NUM,
53: -- Added by RGOOTY for ER 3935682: Start
54: stream_type_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR,
55: contingency OKL_STRM_TYPE_B.CONTINGENCY%TYPE := OKC_API.G_MISS_CHAR,
56: -- Added by RGOOTY for ER 3935682: End
57:
58: -- Added by SNANDIKO for Bug 6744584 Start
59: contingency_id OKL_STRM_TYPE_B.CONTINGENCY_ID%TYPE := OKC_API.G_MISS_NUM );
55: contingency OKL_STRM_TYPE_B.CONTINGENCY%TYPE := OKC_API.G_MISS_CHAR,
56: -- Added by RGOOTY for ER 3935682: End
57:
58: -- Added by SNANDIKO for Bug 6744584 Start
59: contingency_id OKL_STRM_TYPE_B.CONTINGENCY_ID%TYPE := OKC_API.G_MISS_NUM );
60: -- Added by SNANDIKO for Bug 6744584 End
61: g_miss_sty_rec sty_rec_type;
62: TYPE sty_tbl_type IS TABLE OF sty_rec_type
63: INDEX BY BINARY_INTEGER;
62: TYPE sty_tbl_type IS TABLE OF sty_rec_type
63: INDEX BY BINARY_INTEGER;
64: TYPE okl_strm_type_tl_rec_type IS RECORD (
65:
66: id NUMBER := OKC_API.G_MISS_NUM,
67: language OKL_STRM_TYPE_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
68: source_lang OKL_STRM_TYPE_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
69: sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
63: INDEX BY BINARY_INTEGER;
64: TYPE okl_strm_type_tl_rec_type IS RECORD (
65:
66: id NUMBER := OKC_API.G_MISS_NUM,
67: language OKL_STRM_TYPE_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
68: source_lang OKL_STRM_TYPE_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
69: sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
64: TYPE okl_strm_type_tl_rec_type IS RECORD (
65:
66: id NUMBER := OKC_API.G_MISS_NUM,
67: language OKL_STRM_TYPE_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
68: source_lang OKL_STRM_TYPE_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
69: sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
65:
66: id NUMBER := OKC_API.G_MISS_NUM,
67: language OKL_STRM_TYPE_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
68: source_lang OKL_STRM_TYPE_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
69: sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: id NUMBER := OKC_API.G_MISS_NUM,
67: language OKL_STRM_TYPE_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
68: source_lang OKL_STRM_TYPE_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
69: sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: language OKL_STRM_TYPE_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
68: source_lang OKL_STRM_TYPE_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
69: sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_STRM_TYPE_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: source_lang OKL_STRM_TYPE_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
69: sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_STRM_TYPE_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM,
69: sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_STRM_TYPE_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM,
77: -- Added by RGOOTY for ER 3935682: Start
70: name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_STRM_TYPE_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM,
77: -- Added by RGOOTY for ER 3935682: Start
78: short_description OKL_STRM_TYPE_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
71: description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_STRM_TYPE_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM,
77: -- Added by RGOOTY for ER 3935682: Start
78: short_description OKL_STRM_TYPE_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: -- Added by RGOOTY for ER 3935682: End
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_STRM_TYPE_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM,
77: -- Added by RGOOTY for ER 3935682: Start
78: short_description OKL_STRM_TYPE_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: -- Added by RGOOTY for ER 3935682: End
80: );
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_STRM_TYPE_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM,
77: -- Added by RGOOTY for ER 3935682: Start
78: short_description OKL_STRM_TYPE_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: -- Added by RGOOTY for ER 3935682: End
80: );
81: g_miss_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
82: TYPE okl_strm_type_tl_tbl_type IS TABLE OF okl_strm_type_tl_rec_type
81: g_miss_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
82: TYPE okl_strm_type_tl_tbl_type IS TABLE OF okl_strm_type_tl_rec_type
83: INDEX BY BINARY_INTEGER;
84: TYPE styv_rec_type IS RECORD (
85: id NUMBER := OKC_API.G_MISS_NUM,
86: name OKL_STRM_TYPE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
87: version OKL_STRM_TYPE_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
88: object_version_number NUMBER := OKC_API.G_MISS_NUM,
89: code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
82: TYPE okl_strm_type_tl_tbl_type IS TABLE OF okl_strm_type_tl_rec_type
83: INDEX BY BINARY_INTEGER;
84: TYPE styv_rec_type IS RECORD (
85: id NUMBER := OKC_API.G_MISS_NUM,
86: name OKL_STRM_TYPE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
87: version OKL_STRM_TYPE_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
88: object_version_number NUMBER := OKC_API.G_MISS_NUM,
89: code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
90: sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83: INDEX BY BINARY_INTEGER;
84: TYPE styv_rec_type IS RECORD (
85: id NUMBER := OKC_API.G_MISS_NUM,
86: name OKL_STRM_TYPE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
87: version OKL_STRM_TYPE_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
88: object_version_number NUMBER := OKC_API.G_MISS_NUM,
89: code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
90: sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
91: -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
84: TYPE styv_rec_type IS RECORD (
85: id NUMBER := OKC_API.G_MISS_NUM,
86: name OKL_STRM_TYPE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
87: version OKL_STRM_TYPE_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
88: object_version_number NUMBER := OKC_API.G_MISS_NUM,
89: code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
90: sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
91: -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
92: stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
85: id NUMBER := OKC_API.G_MISS_NUM,
86: name OKL_STRM_TYPE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
87: version OKL_STRM_TYPE_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
88: object_version_number NUMBER := OKC_API.G_MISS_NUM,
89: code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
90: sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
91: -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
92: stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
93: description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
86: name OKL_STRM_TYPE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
87: version OKL_STRM_TYPE_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
88: object_version_number NUMBER := OKC_API.G_MISS_NUM,
89: code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
90: sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
91: -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
92: stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
93: description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
87: version OKL_STRM_TYPE_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
88: object_version_number NUMBER := OKC_API.G_MISS_NUM,
89: code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
90: sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
91: -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
92: stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
93: description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKL_STRM_TYPE_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
89: code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
90: sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
91: -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
92: stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
93: description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKL_STRM_TYPE_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: billable_yn OKL_STRM_TYPE_V.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
97: taxable_default_yn OKL_STRM_TYPE_V.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
90: sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
91: -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
92: stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
93: description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKL_STRM_TYPE_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: billable_yn OKL_STRM_TYPE_V.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
97: taxable_default_yn OKL_STRM_TYPE_V.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
98: -- customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
91: -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
92: stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
93: description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKL_STRM_TYPE_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: billable_yn OKL_STRM_TYPE_V.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
97: taxable_default_yn OKL_STRM_TYPE_V.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
98: -- customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
99: customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
92: stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
93: description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKL_STRM_TYPE_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: billable_yn OKL_STRM_TYPE_V.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
97: taxable_default_yn OKL_STRM_TYPE_V.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
98: -- customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
99: customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
100: -- stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
93: description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKL_STRM_TYPE_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: billable_yn OKL_STRM_TYPE_V.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
97: taxable_default_yn OKL_STRM_TYPE_V.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
98: -- customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
99: customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
100: -- stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
101: stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
94: start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKL_STRM_TYPE_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: billable_yn OKL_STRM_TYPE_V.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
97: taxable_default_yn OKL_STRM_TYPE_V.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
98: -- customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
99: customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
100: -- stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
101: stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
102: stream_type_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
96: billable_yn OKL_STRM_TYPE_V.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
97: taxable_default_yn OKL_STRM_TYPE_V.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
98: -- customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
99: customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
100: -- stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
101: stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
102: stream_type_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
103: accrual_yn OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
104: capitalize_yn OKL_STRM_TYPE_V.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
98: -- customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
99: customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
100: -- stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
101: stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
102: stream_type_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
103: accrual_yn OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
104: capitalize_yn OKL_STRM_TYPE_V.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
105: -- periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
106: periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
99: customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
100: -- stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
101: stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
102: stream_type_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
103: accrual_yn OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
104: capitalize_yn OKL_STRM_TYPE_V.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
105: -- periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
106: periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
107: -- fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
100: -- stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
101: stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
102: stream_type_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
103: accrual_yn OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
104: capitalize_yn OKL_STRM_TYPE_V.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
105: -- periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
106: periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
107: -- fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
108: fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
101: stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
102: stream_type_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
103: accrual_yn OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
104: capitalize_yn OKL_STRM_TYPE_V.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
105: -- periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
106: periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
107: -- fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
108: fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
109: -- mvasudev , 05/13/2002
103: accrual_yn OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
104: capitalize_yn OKL_STRM_TYPE_V.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
105: -- periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
106: periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
107: -- fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
108: fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
109: -- mvasudev , 05/13/2002
110: -- allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
111: allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
106: periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
107: -- fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
108: fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
109: -- mvasudev , 05/13/2002
110: -- allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
111: allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
112: --
113: attribute_category OKL_STRM_TYPE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
114: attribute1 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: -- mvasudev , 05/13/2002
110: -- allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
111: allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
112: --
113: attribute_category OKL_STRM_TYPE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
114: attribute1 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
115: attribute2 OKL_STRM_TYPE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
116: attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
110: -- allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
111: allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
112: --
113: attribute_category OKL_STRM_TYPE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
114: attribute1 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
115: attribute2 OKL_STRM_TYPE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
116: attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
111: allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
112: --
113: attribute_category OKL_STRM_TYPE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
114: attribute1 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
115: attribute2 OKL_STRM_TYPE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
116: attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
112: --
113: attribute_category OKL_STRM_TYPE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
114: attribute1 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
115: attribute2 OKL_STRM_TYPE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
116: attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
113: attribute_category OKL_STRM_TYPE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
114: attribute1 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
115: attribute2 OKL_STRM_TYPE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
116: attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
114: attribute1 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
115: attribute2 OKL_STRM_TYPE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
116: attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
115: attribute2 OKL_STRM_TYPE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
116: attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
116: attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
117: attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
118: attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
119: attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
120: attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
121: attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
122: attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
123: attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
124: attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
125: attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM,
126: attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM,
134: -- Added by RGOOTY for ER 3935682: Start
127: attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM,
134: -- Added by RGOOTY for ER 3935682: Start
135: stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
128: attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM,
134: -- Added by RGOOTY for ER 3935682: Start
135: stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
136: contingency OKL_STRM_TYPE_V.contingency%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM,
134: -- Added by RGOOTY for ER 3935682: Start
135: stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
136: contingency OKL_STRM_TYPE_V.contingency%TYPE := OKC_API.G_MISS_CHAR,
137: short_description OKL_STRM_TYPE_V.short_description%TYPE := OKC_API.G_MISS_CHAR,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM,
134: -- Added by RGOOTY for ER 3935682: Start
135: stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
136: contingency OKL_STRM_TYPE_V.contingency%TYPE := OKC_API.G_MISS_CHAR,
137: short_description OKL_STRM_TYPE_V.short_description%TYPE := OKC_API.G_MISS_CHAR,
138: -- Added by RGOOTY for ER 3935682: End
139:
132: last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM,
134: -- Added by RGOOTY for ER 3935682: Start
135: stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
136: contingency OKL_STRM_TYPE_V.contingency%TYPE := OKC_API.G_MISS_CHAR,
137: short_description OKL_STRM_TYPE_V.short_description%TYPE := OKC_API.G_MISS_CHAR,
138: -- Added by RGOOTY for ER 3935682: End
139:
140: -- Added by SNANDIKO for Bug 6744584 Start
133: last_update_login NUMBER := OKC_API.G_MISS_NUM,
134: -- Added by RGOOTY for ER 3935682: Start
135: stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
136: contingency OKL_STRM_TYPE_V.contingency%TYPE := OKC_API.G_MISS_CHAR,
137: short_description OKL_STRM_TYPE_V.short_description%TYPE := OKC_API.G_MISS_CHAR,
138: -- Added by RGOOTY for ER 3935682: End
139:
140: -- Added by SNANDIKO for Bug 6744584 Start
141: contingency_id OKL_STRM_TYPE_V.contingency_id%TYPE := OKC_API.G_MISS_NUM
137: short_description OKL_STRM_TYPE_V.short_description%TYPE := OKC_API.G_MISS_CHAR,
138: -- Added by RGOOTY for ER 3935682: End
139:
140: -- Added by SNANDIKO for Bug 6744584 Start
141: contingency_id OKL_STRM_TYPE_V.contingency_id%TYPE := OKC_API.G_MISS_NUM
142: );
143: -- Added by SNANDIKO for Bug 6744584 End
144: g_miss_styv_rec styv_rec_type;
145: TYPE styv_tbl_type IS TABLE OF styv_rec_type
146: INDEX BY BINARY_INTEGER;
147: ---------------------------------------------------------------------------
148: -- GLOBAL MESSAGE CONSTANTS
149: ---------------------------------------------------------------------------
150: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
151: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
147: ---------------------------------------------------------------------------
148: -- GLOBAL MESSAGE CONSTANTS
149: ---------------------------------------------------------------------------
150: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
151: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
148: -- GLOBAL MESSAGE CONSTANTS
149: ---------------------------------------------------------------------------
150: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
151: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
149: ---------------------------------------------------------------------------
150: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
151: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
150: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
151: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
151: G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
152: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
153: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161: G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
154: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161: G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
162: G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
155: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161: G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
162: G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
163: G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
156: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161: G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
162: G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
163: G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
164: G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_STY_NOT_UNIQUE';
185: PROCEDURE api_copy;
186: PROCEDURE add_language;
187: PROCEDURE insert_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_styv_rec IN styv_rec_type,
194: x_styv_rec OUT NOCOPY styv_rec_type);
195:
196: PROCEDURE insert_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_styv_tbl IN styv_tbl_type,
203: x_styv_tbl OUT NOCOPY styv_tbl_type);
204:
205: PROCEDURE lock_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_styv_rec IN styv_rec_type);
211: p_styv_rec IN styv_rec_type);
212:
213: PROCEDURE lock_row(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_styv_tbl IN styv_tbl_type);
219: p_styv_tbl IN styv_tbl_type);
220:
221: PROCEDURE update_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_styv_rec IN styv_rec_type,
228: x_styv_rec OUT NOCOPY styv_rec_type);
229:
230: PROCEDURE update_row(
231: p_api_version IN NUMBER,
232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_styv_tbl IN styv_tbl_type,
237: x_styv_tbl OUT NOCOPY styv_tbl_type);
238:
239: PROCEDURE delete_row(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_styv_rec IN styv_rec_type);
245: p_styv_rec IN styv_rec_type);
246:
247: PROCEDURE delete_row(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_styv_tbl IN styv_tbl_type);
253: p_styv_tbl IN styv_tbl_type);
254:
255: PROCEDURE validate_row(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_styv_rec IN styv_rec_type);
261: p_styv_rec IN styv_rec_type);
262:
263: PROCEDURE validate_row(
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_styv_tbl IN styv_tbl_type);