3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qcn_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: qty_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qcn_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: qty_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE qcn_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: qty_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
6: TYPE qcn_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: qty_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
7: id NUMBER := okl_api.G_MISS_NUM,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: qty_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
8: crn_id NUMBER := okl_api.G_MISS_NUM,
9: qty_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
9: qty_id NUMBER := okl_api.G_MISS_NUM,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
10: object_version_number NUMBER := okl_api.G_MISS_NUM,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
11: attribute_category OKL_QUESTION_CRTRNS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
12: attribute1 OKL_QUESTION_CRTRNS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
13: attribute2 OKL_QUESTION_CRTRNS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
14: attribute3 OKL_QUESTION_CRTRNS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
15: attribute4 OKL_QUESTION_CRTRNS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute5 OKL_QUESTION_CRTRNS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute6 OKL_QUESTION_CRTRNS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
18: attribute7 OKL_QUESTION_CRTRNS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
19: attribute8 OKL_QUESTION_CRTRNS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
20: attribute9 OKL_QUESTION_CRTRNS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
28: creation_date OKL_QUESTION_CRTRNS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
21: attribute10 OKL_QUESTION_CRTRNS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
28: creation_date OKL_QUESTION_CRTRNS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
22: attribute11 OKL_QUESTION_CRTRNS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
28: creation_date OKL_QUESTION_CRTRNS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_QUESTION_CRTRNS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
23: attribute12 OKL_QUESTION_CRTRNS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
28: creation_date OKL_QUESTION_CRTRNS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_QUESTION_CRTRNS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
24: attribute13 OKL_QUESTION_CRTRNS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
28: creation_date OKL_QUESTION_CRTRNS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_QUESTION_CRTRNS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
32: g_miss_qcn_rec qcn_rec_type;
25: attribute14 OKL_QUESTION_CRTRNS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
28: creation_date OKL_QUESTION_CRTRNS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_QUESTION_CRTRNS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
32: g_miss_qcn_rec qcn_rec_type;
33: TYPE qcn_tbl_type IS TABLE OF qcn_rec_type
26: attribute15 OKL_QUESTION_CRTRNS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
28: creation_date OKL_QUESTION_CRTRNS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_QUESTION_CRTRNS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
32: g_miss_qcn_rec qcn_rec_type;
33: TYPE qcn_tbl_type IS TABLE OF qcn_rec_type
34: INDEX BY BINARY_INTEGER;
27: created_by NUMBER := Okl_Api.G_MISS_NUM,
28: creation_date OKL_QUESTION_CRTRNS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
29: last_updated_by NUMBER := okl_api.G_MISS_NUM,
30: last_update_date OKL_QUESTION_CRTRNS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31: last_update_login NUMBER := okl_api.G_MISS_NUM);
32: g_miss_qcn_rec qcn_rec_type;
33: TYPE qcn_tbl_type IS TABLE OF qcn_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE qcnv_rec_type IS RECORD (
32: g_miss_qcn_rec qcn_rec_type;
33: TYPE qcn_tbl_type IS TABLE OF qcn_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE qcnv_rec_type IS RECORD (
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: qty_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
33: TYPE qcn_tbl_type IS TABLE OF qcn_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE qcnv_rec_type IS RECORD (
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: qty_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
34: INDEX BY BINARY_INTEGER;
35: TYPE qcnv_rec_type IS RECORD (
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: qty_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
35: TYPE qcnv_rec_type IS RECORD (
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: qty_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
36: id NUMBER := okl_api.G_MISS_NUM,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: qty_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
37: object_version_number NUMBER := okl_api.G_MISS_NUM,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: qty_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
38: crn_id NUMBER := okl_api.G_MISS_NUM,
39: qty_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
39: qty_id NUMBER := okl_api.G_MISS_NUM,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
40: attribute_category OKL_QUESTION_CRTRNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
41: attribute1 OKL_QUESTION_CRTRNS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
42: attribute2 OKL_QUESTION_CRTRNS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
43: attribute3 OKL_QUESTION_CRTRNS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
44: attribute4 OKL_QUESTION_CRTRNS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
45: attribute5 OKL_QUESTION_CRTRNS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
46: attribute6 OKL_QUESTION_CRTRNS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
47: attribute7 OKL_QUESTION_CRTRNS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
48: attribute8 OKL_QUESTION_CRTRNS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
49: attribute9 OKL_QUESTION_CRTRNS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
57: creation_date OKL_QUESTION_CRTRNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
50: attribute10 OKL_QUESTION_CRTRNS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
57: creation_date OKL_QUESTION_CRTRNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
51: attribute11 OKL_QUESTION_CRTRNS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
57: creation_date OKL_QUESTION_CRTRNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_QUESTION_CRTRNS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
52: attribute12 OKL_QUESTION_CRTRNS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
57: creation_date OKL_QUESTION_CRTRNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_QUESTION_CRTRNS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
53: attribute13 OKL_QUESTION_CRTRNS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
57: creation_date OKL_QUESTION_CRTRNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_QUESTION_CRTRNS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
61: g_miss_qcnv_rec qcnv_rec_type;
54: attribute14 OKL_QUESTION_CRTRNS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
57: creation_date OKL_QUESTION_CRTRNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_QUESTION_CRTRNS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
61: g_miss_qcnv_rec qcnv_rec_type;
62: TYPE qcnv_tbl_type IS TABLE OF qcnv_rec_type
55: attribute15 OKL_QUESTION_CRTRNS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
57: creation_date OKL_QUESTION_CRTRNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_QUESTION_CRTRNS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
61: g_miss_qcnv_rec qcnv_rec_type;
62: TYPE qcnv_tbl_type IS TABLE OF qcnv_rec_type
63: INDEX BY BINARY_INTEGER;
56: created_by NUMBER := Okl_Api.G_MISS_NUM,
57: creation_date OKL_QUESTION_CRTRNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
58: last_updated_by NUMBER := okl_api.G_MISS_NUM,
59: last_update_date OKL_QUESTION_CRTRNS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
61: g_miss_qcnv_rec qcnv_rec_type;
62: TYPE qcnv_tbl_type IS TABLE OF qcnv_rec_type
63: INDEX BY BINARY_INTEGER;
64: ---------------------------------------------------------------------------
63: INDEX BY BINARY_INTEGER;
64: ---------------------------------------------------------------------------
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
64: ---------------------------------------------------------------------------
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
67: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77: ---------------------------------------------------------------------------
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77: ---------------------------------------------------------------------------
78: -- GLOBAL VARIABLES
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77: ---------------------------------------------------------------------------
78: -- GLOBAL VARIABLES
79: ---------------------------------------------------------------------------
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77: ---------------------------------------------------------------------------
78: -- GLOBAL VARIABLES
79: ---------------------------------------------------------------------------
80: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QCN_PVT';
77: ---------------------------------------------------------------------------
78: -- GLOBAL VARIABLES
79: ---------------------------------------------------------------------------
80: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QCN_PVT';
81: G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
82:
83: /******************ADDED AFTER TAPI, (05/23/2001) ****************/
84: --GLOBAL MESSAGES
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
104: PROCEDURE change_version;
105: PROCEDURE api_copy;
106: PROCEDURE insert_row(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_qcnv_rec IN qcnv_rec_type,
113: x_qcnv_rec OUT NOCOPY qcnv_rec_type);
114:
115: PROCEDURE insert_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_qcnv_tbl IN qcnv_tbl_type,
122: x_qcnv_tbl OUT NOCOPY qcnv_tbl_type);
123:
124: PROCEDURE lock_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_qcnv_rec IN qcnv_rec_type);
130: p_qcnv_rec IN qcnv_rec_type);
131:
132: PROCEDURE lock_row(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_qcnv_tbl IN qcnv_tbl_type);
138: p_qcnv_tbl IN qcnv_tbl_type);
139:
140: PROCEDURE update_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_qcnv_rec IN qcnv_rec_type,
147: x_qcnv_rec OUT NOCOPY qcnv_rec_type);
148:
149: PROCEDURE update_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_qcnv_tbl IN qcnv_tbl_type,
156: x_qcnv_tbl OUT NOCOPY qcnv_tbl_type);
157:
158: PROCEDURE delete_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_qcnv_rec IN qcnv_rec_type);
164: p_qcnv_rec IN qcnv_rec_type);
165:
166: PROCEDURE delete_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_qcnv_tbl IN qcnv_tbl_type);
172: p_qcnv_tbl IN qcnv_tbl_type);
173:
174: PROCEDURE validate_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_qcnv_rec IN qcnv_rec_type);
180: p_qcnv_rec IN qcnv_rec_type);
181:
182: PROCEDURE validate_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_qcnv_tbl IN qcnv_tbl_type);