4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qcl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: begin_date OKC_QA_CHECK_LISTS_B.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_QA_CHECK_LISTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: begin_date OKC_QA_CHECK_LISTS_B.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_QA_CHECK_LISTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_QA_CHECK_LISTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKC_QA_CHECK_LISTS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_QA_CHECK_LISTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_QA_CHECK_LISTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKC_QA_CHECK_LISTS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_QA_CHECK_LISTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_QA_CHECK_LISTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_QA_CHECK_LISTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_QA_CHECK_LISTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKC_QA_CHECK_LISTS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_QA_CHECK_LISTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_QA_CHECK_LISTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_QA_CHECK_LISTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_QA_CHECK_LISTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKC_QA_CHECK_LISTS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_QA_CHECK_LISTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_QA_CHECK_LISTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_QA_CHECK_LISTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
13: last_update_date OKC_QA_CHECK_LISTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKC_QA_CHECK_LISTS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_QA_CHECK_LISTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_QA_CHECK_LISTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_QA_CHECK_LISTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
14: end_date OKC_QA_CHECK_LISTS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_QA_CHECK_LISTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_QA_CHECK_LISTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_QA_CHECK_LISTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_QA_CHECK_LISTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_QA_CHECK_LISTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_QA_CHECK_LISTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKC_QA_CHECK_LISTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_QA_CHECK_LISTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_QA_CHECK_LISTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_QA_CHECK_LISTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_QA_CHECK_LISTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_QA_CHECK_LISTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_QA_CHECK_LISTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_QA_CHECK_LISTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_QA_CHECK_LISTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_QA_CHECK_LISTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_QA_CHECK_LISTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_QA_CHECK_LISTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_QA_CHECK_LISTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_QA_CHECK_LISTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_QA_CHECK_LISTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_QA_CHECK_LISTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_QA_CHECK_LISTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_QA_CHECK_LISTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_QA_CHECK_LISTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_QA_CHECK_LISTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_QA_CHECK_LISTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_QA_CHECK_LISTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_QA_CHECK_LISTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_QA_CHECK_LISTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_QA_CHECK_LISTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: application_id NUMBER := OKC_API.G_MISS_NUM,
25: attribute9 OKC_QA_CHECK_LISTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_QA_CHECK_LISTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_QA_CHECK_LISTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_QA_CHECK_LISTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_QA_CHECK_LISTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: application_id NUMBER := OKC_API.G_MISS_NUM,
33: default_yn OKC_QA_CHECK_LISTS_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
26: attribute10 OKC_QA_CHECK_LISTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_QA_CHECK_LISTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_QA_CHECK_LISTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_QA_CHECK_LISTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_QA_CHECK_LISTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: application_id NUMBER := OKC_API.G_MISS_NUM,
33: default_yn OKC_QA_CHECK_LISTS_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
34:
27: attribute11 OKC_QA_CHECK_LISTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_QA_CHECK_LISTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_QA_CHECK_LISTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_QA_CHECK_LISTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_QA_CHECK_LISTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: application_id NUMBER := OKC_API.G_MISS_NUM,
33: default_yn OKC_QA_CHECK_LISTS_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
34:
35: g_miss_qcl_rec qcl_rec_type;
29: attribute13 OKC_QA_CHECK_LISTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_QA_CHECK_LISTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_QA_CHECK_LISTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: application_id NUMBER := OKC_API.G_MISS_NUM,
33: default_yn OKC_QA_CHECK_LISTS_B.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
34:
35: g_miss_qcl_rec qcl_rec_type;
36: TYPE qcl_tbl_type IS TABLE OF qcl_rec_type
37: INDEX BY BINARY_INTEGER;