3: ---------------------------------------------------------------------------
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,
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,
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,
13: last_update_date OKC_QA_CHECK_LISTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
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,
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,
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,
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,
16: attribute_category OKC_QA_CHECK_LISTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
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,
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,
19: attribute3 OKC_QA_CHECK_LISTS_B.ATTRIBUTE3%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;
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;
36: TYPE qcl_tbl_type IS TABLE OF 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;
35: g_miss_qcl_rec qcl_rec_type;
36: TYPE qcl_tbl_type IS TABLE OF qcl_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE okc_qa_check_lists_tl_rec_type IS RECORD (
39: id NUMBER := OKC_API.G_MISS_NUM,
40: language OKC_QA_CHECK_LISTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
41: source_lang OKC_QA_CHECK_LISTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
42: sfwt_flag OKC_QA_CHECK_LISTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
36: TYPE qcl_tbl_type IS TABLE OF qcl_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE okc_qa_check_lists_tl_rec_type IS RECORD (
39: id NUMBER := OKC_API.G_MISS_NUM,
40: language OKC_QA_CHECK_LISTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
41: source_lang OKC_QA_CHECK_LISTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
42: sfwt_flag OKC_QA_CHECK_LISTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
37: INDEX BY BINARY_INTEGER;
38: TYPE okc_qa_check_lists_tl_rec_type IS RECORD (
39: id NUMBER := OKC_API.G_MISS_NUM,
40: language OKC_QA_CHECK_LISTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
41: source_lang OKC_QA_CHECK_LISTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
42: sfwt_flag OKC_QA_CHECK_LISTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
38: TYPE okc_qa_check_lists_tl_rec_type IS RECORD (
39: id NUMBER := OKC_API.G_MISS_NUM,
40: language OKC_QA_CHECK_LISTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
41: source_lang OKC_QA_CHECK_LISTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
42: sfwt_flag OKC_QA_CHECK_LISTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_QA_CHECK_LISTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
39: id NUMBER := OKC_API.G_MISS_NUM,
40: language OKC_QA_CHECK_LISTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
41: source_lang OKC_QA_CHECK_LISTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
42: sfwt_flag OKC_QA_CHECK_LISTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_QA_CHECK_LISTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
40: language OKC_QA_CHECK_LISTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
41: source_lang OKC_QA_CHECK_LISTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
42: sfwt_flag OKC_QA_CHECK_LISTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_QA_CHECK_LISTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_QA_CHECK_LISTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
41: source_lang OKC_QA_CHECK_LISTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
42: sfwt_flag OKC_QA_CHECK_LISTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_QA_CHECK_LISTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_QA_CHECK_LISTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
42: sfwt_flag OKC_QA_CHECK_LISTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_QA_CHECK_LISTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_QA_CHECK_LISTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: GMissOkcQaCheckListsTlRec okc_qa_check_lists_tl_rec_type;
43: name OKC_QA_CHECK_LISTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_QA_CHECK_LISTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_QA_CHECK_LISTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: GMissOkcQaCheckListsTlRec okc_qa_check_lists_tl_rec_type;
51: TYPE okc_qa_check_lists_tl_tbl_type IS TABLE OF okc_qa_check_lists_tl_rec_type
44: short_description OKC_QA_CHECK_LISTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_QA_CHECK_LISTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_QA_CHECK_LISTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: GMissOkcQaCheckListsTlRec okc_qa_check_lists_tl_rec_type;
51: TYPE okc_qa_check_lists_tl_tbl_type IS TABLE OF okc_qa_check_lists_tl_rec_type
52: INDEX BY BINARY_INTEGER;
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKC_QA_CHECK_LISTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKC_QA_CHECK_LISTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: GMissOkcQaCheckListsTlRec okc_qa_check_lists_tl_rec_type;
51: TYPE okc_qa_check_lists_tl_tbl_type IS TABLE OF okc_qa_check_lists_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE qclv_rec_type IS RECORD (
50: GMissOkcQaCheckListsTlRec okc_qa_check_lists_tl_rec_type;
51: TYPE okc_qa_check_lists_tl_tbl_type IS TABLE OF okc_qa_check_lists_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE qclv_rec_type IS RECORD (
54: id NUMBER := OKC_API.G_MISS_NUM,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_QA_CHECK_LISTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: name OKC_QA_CHECK_LISTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: TYPE okc_qa_check_lists_tl_tbl_type IS TABLE OF okc_qa_check_lists_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE qclv_rec_type IS RECORD (
54: id NUMBER := OKC_API.G_MISS_NUM,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_QA_CHECK_LISTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: name OKC_QA_CHECK_LISTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
52: INDEX BY BINARY_INTEGER;
53: TYPE qclv_rec_type IS RECORD (
54: id NUMBER := OKC_API.G_MISS_NUM,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_QA_CHECK_LISTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: name OKC_QA_CHECK_LISTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
53: TYPE qclv_rec_type IS RECORD (
54: id NUMBER := OKC_API.G_MISS_NUM,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_QA_CHECK_LISTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: name OKC_QA_CHECK_LISTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54: id NUMBER := OKC_API.G_MISS_NUM,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_QA_CHECK_LISTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: name OKC_QA_CHECK_LISTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_QA_CHECK_LISTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: name OKC_QA_CHECK_LISTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_QA_CHECK_LISTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: name OKC_QA_CHECK_LISTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57: name OKC_QA_CHECK_LISTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_QA_CHECK_LISTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59: begin_date OKC_QA_CHECK_LISTS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60: end_date OKC_QA_CHECK_LISTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61: attribute_category OKC_QA_CHECK_LISTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62: attribute1 OKC_QA_CHECK_LISTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63: attribute2 OKC_QA_CHECK_LISTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64: attribute3 OKC_QA_CHECK_LISTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65: attribute4 OKC_QA_CHECK_LISTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66: attribute5 OKC_QA_CHECK_LISTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67: attribute6 OKC_QA_CHECK_LISTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68: attribute7 OKC_QA_CHECK_LISTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69: attribute8 OKC_QA_CHECK_LISTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
70: attribute9 OKC_QA_CHECK_LISTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71: attribute10 OKC_QA_CHECK_LISTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72: attribute11 OKC_QA_CHECK_LISTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: last_update_date OKC_QA_CHECK_LISTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73: attribute12 OKC_QA_CHECK_LISTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: last_update_date OKC_QA_CHECK_LISTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
74: attribute13 OKC_QA_CHECK_LISTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: last_update_date OKC_QA_CHECK_LISTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: application_id NUMBER := OKC_API.G_MISS_NUM,
75: attribute14 OKC_QA_CHECK_LISTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: last_update_date OKC_QA_CHECK_LISTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: application_id NUMBER := OKC_API.G_MISS_NUM,
83: default_yn OKC_QA_CHECK_LISTS_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
76: attribute15 OKC_QA_CHECK_LISTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: last_update_date OKC_QA_CHECK_LISTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: application_id NUMBER := OKC_API.G_MISS_NUM,
83: default_yn OKC_QA_CHECK_LISTS_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
84: g_miss_qclv_rec qclv_rec_type;
77: created_by NUMBER := OKC_API.G_MISS_NUM,
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: last_update_date OKC_QA_CHECK_LISTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: application_id NUMBER := OKC_API.G_MISS_NUM,
83: default_yn OKC_QA_CHECK_LISTS_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
84: g_miss_qclv_rec qclv_rec_type;
85: TYPE qclv_tbl_type IS TABLE OF qclv_rec_type
78: creation_date OKC_QA_CHECK_LISTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: last_update_date OKC_QA_CHECK_LISTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: application_id NUMBER := OKC_API.G_MISS_NUM,
83: default_yn OKC_QA_CHECK_LISTS_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
84: g_miss_qclv_rec qclv_rec_type;
85: TYPE qclv_tbl_type IS TABLE OF qclv_rec_type
86: INDEX BY BINARY_INTEGER;
79: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
80: last_update_date OKC_QA_CHECK_LISTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_update_login NUMBER := OKC_API.G_MISS_NUM,
82: application_id NUMBER := OKC_API.G_MISS_NUM,
83: default_yn OKC_QA_CHECK_LISTS_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR);
84: g_miss_qclv_rec qclv_rec_type;
85: TYPE qclv_tbl_type IS TABLE OF qclv_rec_type
86: INDEX BY BINARY_INTEGER;
87: ---------------------------------------------------------------------------
86: INDEX BY BINARY_INTEGER;
87: ---------------------------------------------------------------------------
88: -- GLOBAL MESSAGE CONSTANTS
89: ---------------------------------------------------------------------------
90: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
91: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
92: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
93: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87: ---------------------------------------------------------------------------
88: -- GLOBAL MESSAGE CONSTANTS
89: ---------------------------------------------------------------------------
90: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
91: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
92: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
93: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88: -- GLOBAL MESSAGE CONSTANTS
89: ---------------------------------------------------------------------------
90: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
91: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
92: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
93: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89: ---------------------------------------------------------------------------
90: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
91: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
92: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
93: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
90: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
91: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
92: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
93: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
91: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
92: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
93: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
92: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
93: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
93: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
94: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
95: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
96: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
103: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QCL_PVT';
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
103: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QCL_PVT';
104: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
105: ---------------------------------------------------------------------------
106: -- Procedures and Functions
107: ---------------------------------------------------------------------------
108:
111: PROCEDURE api_copy;
112: PROCEDURE add_language;
113: PROCEDURE insert_row(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_qclv_rec IN qclv_rec_type,
120: x_qclv_rec OUT NOCOPY qclv_rec_type);
121:
122: PROCEDURE insert_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_qclv_tbl IN qclv_tbl_type,
129: x_qclv_tbl OUT NOCOPY qclv_tbl_type);
130:
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_qclv_rec IN qclv_rec_type);
137: p_qclv_rec IN qclv_rec_type);
138:
139: PROCEDURE lock_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_qclv_tbl IN qclv_tbl_type);
145: p_qclv_tbl IN qclv_tbl_type);
146:
147: PROCEDURE update_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_qclv_rec IN qclv_rec_type,
154: x_qclv_rec OUT NOCOPY qclv_rec_type);
155:
156: PROCEDURE update_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_qclv_tbl IN qclv_tbl_type,
163: x_qclv_tbl OUT NOCOPY qclv_tbl_type);
164:
165: PROCEDURE delete_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_qclv_rec IN qclv_rec_type);
171: p_qclv_rec IN qclv_rec_type);
172:
173: PROCEDURE delete_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_qclv_tbl IN qclv_tbl_type);
179: p_qclv_tbl IN qclv_tbl_type);
180:
181: PROCEDURE validate_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_qclv_rec IN qclv_rec_type);
187: p_qclv_rec IN qclv_rec_type);
188:
189: PROCEDURE validate_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_qclv_tbl IN qclv_tbl_type);