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: ---------------------------------------------------------------------------