5: ---------------------------------------------------------------------------
6: TYPE bkt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: ibc_id NUMBER := OKC_API.G_MISS_NUM,
9: version OKL_BUCKETS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
10: loss_rate NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number NUMBER := OKC_API.G_MISS_NUM,
12: comments OKL_BUCKETS.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
13: program_id NUMBER := OKC_API.G_MISS_NUM,
27: TYPE bktv_rec_type IS RECORD (
28: id NUMBER := OKC_API.G_MISS_NUM,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: ibc_id NUMBER := OKC_API.G_MISS_NUM,
31: version OKL_BUCKETS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
32: comments OKL_BUCKETS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
33: loss_rate NUMBER := OKC_API.G_MISS_NUM,
34: program_id NUMBER := OKC_API.G_MISS_NUM,
35: request_id NUMBER := OKC_API.G_MISS_NUM,
28: id NUMBER := OKC_API.G_MISS_NUM,
29: object_version_number NUMBER := OKC_API.G_MISS_NUM,
30: ibc_id NUMBER := OKC_API.G_MISS_NUM,
31: version OKL_BUCKETS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
32: comments OKL_BUCKETS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
33: loss_rate NUMBER := OKC_API.G_MISS_NUM,
34: program_id NUMBER := OKC_API.G_MISS_NUM,
35: request_id NUMBER := OKC_API.G_MISS_NUM,
36: program_application_id NUMBER := OKC_API.G_MISS_NUM,
33: loss_rate NUMBER := OKC_API.G_MISS_NUM,
34: program_id NUMBER := OKC_API.G_MISS_NUM,
35: request_id NUMBER := OKC_API.G_MISS_NUM,
36: program_application_id NUMBER := OKC_API.G_MISS_NUM,
37: program_update_date OKL_BUCKETS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: start_date OKL_BUCKETS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
39: end_date OKL_BUCKETS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
40: created_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_BUCKETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: program_id NUMBER := OKC_API.G_MISS_NUM,
35: request_id NUMBER := OKC_API.G_MISS_NUM,
36: program_application_id NUMBER := OKC_API.G_MISS_NUM,
37: program_update_date OKL_BUCKETS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: start_date OKL_BUCKETS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
39: end_date OKL_BUCKETS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
40: created_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_BUCKETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: request_id NUMBER := OKC_API.G_MISS_NUM,
36: program_application_id NUMBER := OKC_API.G_MISS_NUM,
37: program_update_date OKL_BUCKETS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: start_date OKL_BUCKETS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
39: end_date OKL_BUCKETS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
40: created_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_BUCKETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
43: last_update_date OKL_BUCKETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37: program_update_date OKL_BUCKETS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: start_date OKL_BUCKETS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
39: end_date OKL_BUCKETS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
40: created_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_BUCKETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
43: last_update_date OKL_BUCKETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: g_miss_bktv_rec bktv_rec_type;
39: end_date OKL_BUCKETS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
40: created_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKL_BUCKETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
43: last_update_date OKL_BUCKETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: g_miss_bktv_rec bktv_rec_type;
46: TYPE bktv_tbl_type IS TABLE OF bktv_rec_type
47: INDEX BY BINARY_INTEGER;