4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sre_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: rle_code OKC_SUBCLASS_ROLES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_SUBCLASS_ROLES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE sre_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: rle_code OKC_SUBCLASS_ROLES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_SUBCLASS_ROLES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
8: scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: rle_code OKC_SUBCLASS_ROLES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_SUBCLASS_ROLES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_SUBCLASS_ROLES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: start_date OKC_SUBCLASS_ROLES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_SUBCLASS_ROLES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_SUBCLASS_ROLES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: start_date OKC_SUBCLASS_ROLES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
17: end_date OKC_SUBCLASS_ROLES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
18: access_level OKC_SUBCLASS_ROLES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
12: creation_date OKC_SUBCLASS_ROLES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_SUBCLASS_ROLES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: start_date OKC_SUBCLASS_ROLES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
17: end_date OKC_SUBCLASS_ROLES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
18: access_level OKC_SUBCLASS_ROLES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_sre_rec sre_rec_type;
20: TYPE sre_tbl_type IS TABLE OF sre_rec_type
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_SUBCLASS_ROLES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: start_date OKC_SUBCLASS_ROLES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
17: end_date OKC_SUBCLASS_ROLES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
18: access_level OKC_SUBCLASS_ROLES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_sre_rec sre_rec_type;
20: TYPE sre_tbl_type IS TABLE OF sre_rec_type
21: INDEX BY BINARY_INTEGER;
14: last_update_date OKC_SUBCLASS_ROLES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: start_date OKC_SUBCLASS_ROLES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
17: end_date OKC_SUBCLASS_ROLES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
18: access_level OKC_SUBCLASS_ROLES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_sre_rec sre_rec_type;
20: TYPE sre_tbl_type IS TABLE OF sre_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE srev_rec_type IS RECORD (
21: INDEX BY BINARY_INTEGER;
22: TYPE srev_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: rle_code OKC_SUBCLASS_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: scs_code OKC_SUBCLASS_ROLES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_SUBCLASS_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: TYPE srev_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: rle_code OKC_SUBCLASS_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: scs_code OKC_SUBCLASS_ROLES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_SUBCLASS_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_SUBCLASS_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: rle_code OKC_SUBCLASS_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: scs_code OKC_SUBCLASS_ROLES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_SUBCLASS_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_SUBCLASS_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM,
32: start_date OKC_SUBCLASS_ROLES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: scs_code OKC_SUBCLASS_ROLES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_SUBCLASS_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_SUBCLASS_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM,
32: start_date OKC_SUBCLASS_ROLES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
33: end_date OKC_SUBCLASS_ROLES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
34: access_level OKC_SUBCLASS_ROLES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
28: creation_date OKC_SUBCLASS_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_SUBCLASS_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM,
32: start_date OKC_SUBCLASS_ROLES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
33: end_date OKC_SUBCLASS_ROLES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
34: access_level OKC_SUBCLASS_ROLES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_srev_rec srev_rec_type;
36: TYPE srev_tbl_type IS TABLE OF srev_rec_type
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_SUBCLASS_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM,
32: start_date OKC_SUBCLASS_ROLES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
33: end_date OKC_SUBCLASS_ROLES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
34: access_level OKC_SUBCLASS_ROLES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_srev_rec srev_rec_type;
36: TYPE srev_tbl_type IS TABLE OF srev_rec_type
37: INDEX BY BINARY_INTEGER;
30: last_update_date OKC_SUBCLASS_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM,
32: start_date OKC_SUBCLASS_ROLES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
33: end_date OKC_SUBCLASS_ROLES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
34: access_level OKC_SUBCLASS_ROLES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_srev_rec srev_rec_type;
36: TYPE srev_tbl_type IS TABLE OF srev_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------