3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sts_rec_type IS RECORD (
7: code OKC_STATUSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: ste_code OKC_STATUSES_B.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: default_yn OKC_STATUSES_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
10: start_date OKC_STATUSES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
11: end_date OKC_STATUSES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sts_rec_type IS RECORD (
7: code OKC_STATUSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: ste_code OKC_STATUSES_B.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: default_yn OKC_STATUSES_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
10: start_date OKC_STATUSES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
11: end_date OKC_STATUSES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE sts_rec_type IS RECORD (
7: code OKC_STATUSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: ste_code OKC_STATUSES_B.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: default_yn OKC_STATUSES_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
10: start_date OKC_STATUSES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
11: end_date OKC_STATUSES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE sts_rec_type IS RECORD (
7: code OKC_STATUSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: ste_code OKC_STATUSES_B.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: default_yn OKC_STATUSES_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
10: start_date OKC_STATUSES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
11: end_date OKC_STATUSES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_STATUSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: code OKC_STATUSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: ste_code OKC_STATUSES_B.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: default_yn OKC_STATUSES_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
10: start_date OKC_STATUSES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
11: end_date OKC_STATUSES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_STATUSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
10: start_date OKC_STATUSES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
11: end_date OKC_STATUSES_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_STATUSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_STATUSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: g_miss_sts_rec sts_rec_type;
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_STATUSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_STATUSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: g_miss_sts_rec sts_rec_type;
19: TYPE sts_tbl_type IS TABLE OF sts_rec_type
20: INDEX BY BINARY_INTEGER;