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,
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,
15: accrual_yn OKL_STRM_TYPE_B.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
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,
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,
17: -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%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
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,
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,
22: billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
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
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
29: -- allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
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
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
31: --
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,
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,
34: attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%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,
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
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,
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;