3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rgr_rec_type IS RECORD (
7: rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_RG_DEF_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rgr_rec_type IS RECORD (
7: rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_RG_DEF_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
7: rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_RG_DEF_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_RG_DEF_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_RG_DEF_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_RG_DEF_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: min_cardinality NUMBER := OKC_API.G_MISS_NUM,
17: max_cardinality NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_RG_DEF_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_RG_DEF_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: min_cardinality NUMBER := OKC_API.G_MISS_NUM,
17: max_cardinality NUMBER := OKC_API.G_MISS_NUM,
18: pricing_related_yn OKC_RG_DEF_RULES.PRICING_RELATED_YN%TYPE := OKC_API.G_MISS_CHAR,
14: optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: min_cardinality NUMBER := OKC_API.G_MISS_NUM,
17: max_cardinality NUMBER := OKC_API.G_MISS_NUM,
18: pricing_related_yn OKC_RG_DEF_RULES.PRICING_RELATED_YN%TYPE := OKC_API.G_MISS_CHAR,
19: access_level OKC_RG_DEF_RULES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
20: g_miss_rgr_rec rgr_rec_type;
21: TYPE rgr_tbl_type IS TABLE OF rgr_rec_type
22: INDEX BY BINARY_INTEGER;
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: min_cardinality NUMBER := OKC_API.G_MISS_NUM,
17: max_cardinality NUMBER := OKC_API.G_MISS_NUM,
18: pricing_related_yn OKC_RG_DEF_RULES.PRICING_RELATED_YN%TYPE := OKC_API.G_MISS_CHAR,
19: access_level OKC_RG_DEF_RULES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
20: g_miss_rgr_rec rgr_rec_type;
21: TYPE rgr_tbl_type IS TABLE OF rgr_rec_type
22: INDEX BY BINARY_INTEGER;
23: TYPE rgrv_rec_type IS RECORD (
20: g_miss_rgr_rec rgr_rec_type;
21: TYPE rgr_tbl_type IS TABLE OF rgr_rec_type
22: INDEX BY BINARY_INTEGER;
23: TYPE rgrv_rec_type IS RECORD (
24: rgd_code OKC_RG_DEF_RULES_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: rdf_code OKC_RG_DEF_RULES_V.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: object_version_number NUMBER := OKC_API.G_MISS_NUM,
27: optional_yn OKC_RG_DEF_RULES_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
21: TYPE rgr_tbl_type IS TABLE OF rgr_rec_type
22: INDEX BY BINARY_INTEGER;
23: TYPE rgrv_rec_type IS RECORD (
24: rgd_code OKC_RG_DEF_RULES_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: rdf_code OKC_RG_DEF_RULES_V.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: object_version_number NUMBER := OKC_API.G_MISS_NUM,
27: optional_yn OKC_RG_DEF_RULES_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_RG_DEF_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: TYPE rgrv_rec_type IS RECORD (
24: rgd_code OKC_RG_DEF_RULES_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: rdf_code OKC_RG_DEF_RULES_V.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: object_version_number NUMBER := OKC_API.G_MISS_NUM,
27: optional_yn OKC_RG_DEF_RULES_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_RG_DEF_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_RG_DEF_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: rdf_code OKC_RG_DEF_RULES_V.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: object_version_number NUMBER := OKC_API.G_MISS_NUM,
27: optional_yn OKC_RG_DEF_RULES_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_RG_DEF_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_RG_DEF_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: min_cardinality NUMBER := OKC_API.G_MISS_NUM,
27: optional_yn OKC_RG_DEF_RULES_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKC_RG_DEF_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKC_RG_DEF_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: min_cardinality NUMBER := OKC_API.G_MISS_NUM,
34: max_cardinality NUMBER := OKC_API.G_MISS_NUM,
35: pricing_related_yn OKC_RG_DEF_RULES.PRICING_RELATED_YN%TYPE := OKC_API.G_MISS_CHAR,
31: last_update_date OKC_RG_DEF_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: min_cardinality NUMBER := OKC_API.G_MISS_NUM,
34: max_cardinality NUMBER := OKC_API.G_MISS_NUM,
35: pricing_related_yn OKC_RG_DEF_RULES.PRICING_RELATED_YN%TYPE := OKC_API.G_MISS_CHAR,
36: access_level OKC_RG_DEF_RULES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_rgrv_rec rgrv_rec_type;
38: TYPE rgrv_tbl_type IS TABLE OF rgrv_rec_type
39: INDEX BY BINARY_INTEGER;
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: min_cardinality NUMBER := OKC_API.G_MISS_NUM,
34: max_cardinality NUMBER := OKC_API.G_MISS_NUM,
35: pricing_related_yn OKC_RG_DEF_RULES.PRICING_RELATED_YN%TYPE := OKC_API.G_MISS_CHAR,
36: access_level OKC_RG_DEF_RULES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_rgrv_rec rgrv_rec_type;
38: TYPE rgrv_tbl_type IS TABLE OF rgrv_rec_type
39: INDEX BY BINARY_INTEGER;
40: ---------------------------------------------------------------------------