3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qty_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: srd_id NUMBER := okl_api.G_MISS_NUM,
9: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
10: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qty_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: srd_id NUMBER := okl_api.G_MISS_NUM,
9: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
10: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE qty_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: srd_id NUMBER := okl_api.G_MISS_NUM,
9: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
10: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
6: TYPE qty_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: srd_id NUMBER := okl_api.G_MISS_NUM,
9: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
10: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
7: id NUMBER := okl_api.G_MISS_NUM,
8: srd_id NUMBER := okl_api.G_MISS_NUM,
9: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
10: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
8: srd_id NUMBER := okl_api.G_MISS_NUM,
9: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
10: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
9: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
10: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
10: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
11: rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
12: rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
13: object_version_number NUMBER := okl_api.G_MISS_NUM,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
14: attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
15: attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
16: attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
17: attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
18: attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
19: attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
20: attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
21: attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
22: attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30: created_by NUMBER := okl_api.G_MISS_NUM,
23: attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
24: attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
25: attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_QUESTION_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
26: attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_QUESTION_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
27: attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_QUESTION_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
35: g_miss_qty_rec qty_rec_type;
28: attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_QUESTION_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
35: g_miss_qty_rec qty_rec_type;
36: TYPE qty_tbl_type IS TABLE OF qty_rec_type
29: attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_QUESTION_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
35: g_miss_qty_rec qty_rec_type;
36: TYPE qty_tbl_type IS TABLE OF qty_rec_type
37: INDEX BY BINARY_INTEGER;
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_QUESTION_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
35: g_miss_qty_rec qty_rec_type;
36: TYPE qty_tbl_type IS TABLE OF qty_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE okl_question_types_tl_rec_type IS RECORD (
35: g_miss_qty_rec qty_rec_type;
36: TYPE qty_tbl_type IS TABLE OF qty_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE okl_question_types_tl_rec_type IS RECORD (
39: id NUMBER := okl_api.G_MISS_NUM,
40: LANGUAGE OKL_QUESTION_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
41: source_lang OKL_QUESTION_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
42: sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
36: TYPE qty_tbl_type IS TABLE OF qty_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE okl_question_types_tl_rec_type IS RECORD (
39: id NUMBER := okl_api.G_MISS_NUM,
40: LANGUAGE OKL_QUESTION_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
41: source_lang OKL_QUESTION_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
42: sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
37: INDEX BY BINARY_INTEGER;
38: TYPE okl_question_types_tl_rec_type IS RECORD (
39: id NUMBER := okl_api.G_MISS_NUM,
40: LANGUAGE OKL_QUESTION_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
41: source_lang OKL_QUESTION_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
42: sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45: created_by NUMBER := okl_api.G_MISS_NUM,
38: TYPE okl_question_types_tl_rec_type IS RECORD (
39: id NUMBER := okl_api.G_MISS_NUM,
40: LANGUAGE OKL_QUESTION_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
41: source_lang OKL_QUESTION_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
42: sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45: created_by NUMBER := okl_api.G_MISS_NUM,
46: creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
39: id NUMBER := okl_api.G_MISS_NUM,
40: LANGUAGE OKL_QUESTION_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
41: source_lang OKL_QUESTION_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
42: sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45: created_by NUMBER := okl_api.G_MISS_NUM,
46: creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_updated_by NUMBER := okl_api.G_MISS_NUM,
40: LANGUAGE OKL_QUESTION_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
41: source_lang OKL_QUESTION_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
42: sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45: created_by NUMBER := okl_api.G_MISS_NUM,
46: creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_updated_by NUMBER := okl_api.G_MISS_NUM,
48: last_update_date OKL_QUESTION_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
41: source_lang OKL_QUESTION_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
42: sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45: created_by NUMBER := okl_api.G_MISS_NUM,
46: creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_updated_by NUMBER := okl_api.G_MISS_NUM,
48: last_update_date OKL_QUESTION_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
49: last_update_login NUMBER := okl_api.G_MISS_NUM);
42: sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45: created_by NUMBER := okl_api.G_MISS_NUM,
46: creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_updated_by NUMBER := okl_api.G_MISS_NUM,
48: last_update_date OKL_QUESTION_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
49: last_update_login NUMBER := okl_api.G_MISS_NUM);
50: GMissOklQuestionTypesTlRec okl_question_types_tl_rec_type;
43: name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45: created_by NUMBER := okl_api.G_MISS_NUM,
46: creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_updated_by NUMBER := okl_api.G_MISS_NUM,
48: last_update_date OKL_QUESTION_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
49: last_update_login NUMBER := okl_api.G_MISS_NUM);
50: GMissOklQuestionTypesTlRec okl_question_types_tl_rec_type;
51: TYPE okl_question_types_tl_tbl_type IS TABLE OF okl_question_types_tl_rec_type
44: description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45: created_by NUMBER := okl_api.G_MISS_NUM,
46: creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_updated_by NUMBER := okl_api.G_MISS_NUM,
48: last_update_date OKL_QUESTION_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
49: last_update_login NUMBER := okl_api.G_MISS_NUM);
50: GMissOklQuestionTypesTlRec okl_question_types_tl_rec_type;
51: TYPE okl_question_types_tl_tbl_type IS TABLE OF okl_question_types_tl_rec_type
52: INDEX BY BINARY_INTEGER;
45: created_by NUMBER := okl_api.G_MISS_NUM,
46: creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_updated_by NUMBER := okl_api.G_MISS_NUM,
48: last_update_date OKL_QUESTION_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
49: last_update_login NUMBER := okl_api.G_MISS_NUM);
50: GMissOklQuestionTypesTlRec okl_question_types_tl_rec_type;
51: TYPE okl_question_types_tl_tbl_type IS TABLE OF okl_question_types_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE qtyv_rec_type IS RECORD (
50: GMissOklQuestionTypesTlRec okl_question_types_tl_rec_type;
51: TYPE okl_question_types_tl_tbl_type IS TABLE OF okl_question_types_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE qtyv_rec_type IS RECORD (
54: id NUMBER := okl_api.G_MISS_NUM,
55: object_version_number NUMBER := okl_api.G_MISS_NUM,
56: sfwt_flag OKL_QUESTION_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
57: rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
51: TYPE okl_question_types_tl_tbl_type IS TABLE OF okl_question_types_tl_rec_type
52: INDEX BY BINARY_INTEGER;
53: TYPE qtyv_rec_type IS RECORD (
54: id NUMBER := okl_api.G_MISS_NUM,
55: object_version_number NUMBER := okl_api.G_MISS_NUM,
56: sfwt_flag OKL_QUESTION_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
57: rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
52: INDEX BY BINARY_INTEGER;
53: TYPE qtyv_rec_type IS RECORD (
54: id NUMBER := okl_api.G_MISS_NUM,
55: object_version_number NUMBER := okl_api.G_MISS_NUM,
56: sfwt_flag OKL_QUESTION_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
57: rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
53: TYPE qtyv_rec_type IS RECORD (
54: id NUMBER := okl_api.G_MISS_NUM,
55: object_version_number NUMBER := okl_api.G_MISS_NUM,
56: sfwt_flag OKL_QUESTION_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
57: rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
54: id NUMBER := okl_api.G_MISS_NUM,
55: object_version_number NUMBER := okl_api.G_MISS_NUM,
56: sfwt_flag OKL_QUESTION_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
57: rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
55: object_version_number NUMBER := okl_api.G_MISS_NUM,
56: sfwt_flag OKL_QUESTION_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
57: rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
56: sfwt_flag OKL_QUESTION_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
57: rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
57: rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
58: srd_id NUMBER := okl_api.G_MISS_NUM,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
59: lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
60: rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
61: lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
62: name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
63: description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
64: attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
65: attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
73: attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
74: attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
75: attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_QUESTION_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
76: attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_QUESTION_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
77: attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_QUESTION_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
85: g_miss_qtyv_rec qtyv_rec_type;
78: attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_QUESTION_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
85: g_miss_qtyv_rec qtyv_rec_type;
86: TYPE qtyv_tbl_type IS TABLE OF qtyv_rec_type
79: attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_QUESTION_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
85: g_miss_qtyv_rec qtyv_rec_type;
86: TYPE qtyv_tbl_type IS TABLE OF qtyv_rec_type
87: INDEX BY BINARY_INTEGER;
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_QUESTION_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
85: g_miss_qtyv_rec qtyv_rec_type;
86: TYPE qtyv_tbl_type IS TABLE OF qtyv_rec_type
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
101: ---------------------------------------------------------------------------
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES
103: ---------------------------------------------------------------------------
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES
103: ---------------------------------------------------------------------------
104: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QTY_PVT';
101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES
103: ---------------------------------------------------------------------------
104: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QTY_PVT';
105: G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
106:
107: /******************ADDED AFTER TAPI, (05/23/2001) ****************/
108: --GLOBAL MESSAGES
109: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
129: PROCEDURE api_copy;
130: PROCEDURE add_language;
131: PROCEDURE insert_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT okl_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_qtyv_rec IN qtyv_rec_type,
138: x_qtyv_rec OUT NOCOPY qtyv_rec_type);
139:
140: PROCEDURE insert_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_qtyv_tbl IN qtyv_tbl_type,
147: x_qtyv_tbl OUT NOCOPY qtyv_tbl_type);
148:
149: PROCEDURE lock_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_qtyv_rec IN qtyv_rec_type);
155: p_qtyv_rec IN qtyv_rec_type);
156:
157: PROCEDURE lock_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_qtyv_tbl IN qtyv_tbl_type);
163: p_qtyv_tbl IN qtyv_tbl_type);
164:
165: PROCEDURE update_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT okl_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_qtyv_rec IN qtyv_rec_type,
172: x_qtyv_rec OUT NOCOPY qtyv_rec_type);
173:
174: PROCEDURE update_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_qtyv_tbl IN qtyv_tbl_type,
181: x_qtyv_tbl OUT NOCOPY qtyv_tbl_type);
182:
183: PROCEDURE delete_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_qtyv_rec IN qtyv_rec_type);
189: p_qtyv_rec IN qtyv_rec_type);
190:
191: PROCEDURE delete_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_qtyv_tbl IN qtyv_tbl_type);
197: p_qtyv_tbl IN qtyv_tbl_type);
198:
199: PROCEDURE validate_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_qtyv_rec IN qtyv_rec_type);
205: p_qtyv_rec IN qtyv_rec_type);
206:
207: PROCEDURE validate_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_qtyv_tbl IN qtyv_tbl_type);