3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_rscv_rec rscv_rec_type;
36: TYPE rscv_tbl_type IS TABLE OF rscv_rec_type
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_rscv_rec rscv_rec_type;
36: TYPE rscv_tbl_type IS TABLE OF rscv_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------