4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_TRX_QTE_CF_OBJECTS_V Record Spec
7: TYPE qcov_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,qte_id NUMBER := OKL_API.G_MISS_NUM
10: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
11: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKL_TRX_QTE_CF_OBJECTS_V Record Spec
7: TYPE qcov_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,qte_id NUMBER := OKL_API.G_MISS_NUM
10: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
11: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
6: -- OKL_TRX_QTE_CF_OBJECTS_V Record Spec
7: TYPE qcov_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,qte_id NUMBER := OKL_API.G_MISS_NUM
10: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
11: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
7: TYPE qcov_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,qte_id NUMBER := OKL_API.G_MISS_NUM
10: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
11: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,qte_id NUMBER := OKL_API.G_MISS_NUM
10: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
11: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
9: ,qte_id NUMBER := OKL_API.G_MISS_NUM
10: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
11: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
10: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
11: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
11: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
14: ,creation_date OKL_TRX_QTE_CF_OBJECTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
16: ,last_update_date OKL_TRX_QTE_CF_OBJECTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute_category OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute1 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute2 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute3 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute4 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute5 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute6 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute7 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
26: ,attribute8 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
34: G_MISS_qcov_rec qcov_rec_type;
27: ,attribute9 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
34: G_MISS_qcov_rec qcov_rec_type;
35: TYPE qcov_tbl_type IS TABLE OF qcov_rec_type
28: ,attribute10 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
34: G_MISS_qcov_rec qcov_rec_type;
35: TYPE qcov_tbl_type IS TABLE OF qcov_rec_type
36: INDEX BY BINARY_INTEGER;
29: ,attribute11 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute12 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute13 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute14 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute15 OKL_TRX_QTE_CF_OBJECTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
34: G_MISS_qcov_rec qcov_rec_type;
35: TYPE qcov_tbl_type IS TABLE OF qcov_rec_type
36: INDEX BY BINARY_INTEGER;
37: -- OKL_TRX_QTE_CF_OBJECTS Record Spec
35: TYPE qcov_tbl_type IS TABLE OF qcov_rec_type
36: INDEX BY BINARY_INTEGER;
37: -- OKL_TRX_QTE_CF_OBJECTS Record Spec
38: TYPE qco_rec_type IS RECORD (
39: id NUMBER := OKL_API.G_MISS_NUM
40: ,qte_id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
36: INDEX BY BINARY_INTEGER;
37: -- OKL_TRX_QTE_CF_OBJECTS Record Spec
38: TYPE qco_rec_type IS RECORD (
39: id NUMBER := OKL_API.G_MISS_NUM
40: ,qte_id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
37: -- OKL_TRX_QTE_CF_OBJECTS Record Spec
38: TYPE qco_rec_type IS RECORD (
39: id NUMBER := OKL_API.G_MISS_NUM
40: ,qte_id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
38: TYPE qco_rec_type IS RECORD (
39: id NUMBER := OKL_API.G_MISS_NUM
40: ,qte_id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
39: id NUMBER := OKL_API.G_MISS_NUM
40: ,qte_id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
40: ,qte_id NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
41: ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
42: ,base_source_id NUMBER := OKL_API.G_MISS_NUM
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
43: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
44: ,created_by NUMBER := OKL_API.G_MISS_NUM
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
45: ,creation_date OKL_TRX_QTE_CF_OBJECTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
46: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
47: ,last_update_date OKL_TRX_QTE_CF_OBJECTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
48: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
49: ,attribute_category OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
50: ,attribute1 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
51: ,attribute2 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
52: ,attribute3 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
53: ,attribute4 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute12 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
54: ,attribute5 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute12 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute13 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
55: ,attribute6 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute12 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute13 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute14 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute7 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute12 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute13 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute14 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute15 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
57: ,attribute8 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute12 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute13 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute14 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute15 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
65: G_MISS_qco_rec qco_rec_type;
58: ,attribute9 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute12 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute13 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute14 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute15 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
65: G_MISS_qco_rec qco_rec_type;
66: TYPE qco_tbl_type IS TABLE OF qco_rec_type
59: ,attribute10 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute12 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute13 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute14 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute15 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
65: G_MISS_qco_rec qco_rec_type;
66: TYPE qco_tbl_type IS TABLE OF qco_rec_type
67: INDEX BY BINARY_INTEGER;
60: ,attribute11 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute12 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute13 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute14 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute15 OKL_TRX_QTE_CF_OBJECTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR);
65: G_MISS_qco_rec qco_rec_type;
66: TYPE qco_tbl_type IS TABLE OF qco_rec_type
67: INDEX BY BINARY_INTEGER;
68: ---------------------------------------------------------------------------
67: INDEX BY BINARY_INTEGER;
68: ---------------------------------------------------------------------------
69: -- GLOBAL MESSAGE CONSTANTS
70: ---------------------------------------------------------------------------
71: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
72: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
73: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
68: ---------------------------------------------------------------------------
69: -- GLOBAL MESSAGE CONSTANTS
70: ---------------------------------------------------------------------------
71: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
72: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
73: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
69: -- GLOBAL MESSAGE CONSTANTS
70: ---------------------------------------------------------------------------
71: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
72: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
73: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
70: ---------------------------------------------------------------------------
71: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
72: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
73: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
71: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
72: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
73: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
79: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
72: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
73: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
79: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
80: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
73: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
79: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
80: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
81: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
74: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
79: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
80: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
81: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
82: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
75: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
79: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
80: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
81: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
82: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
83: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
76: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
79: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
80: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
81: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
82: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
83: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
84:
94: ---------------------------------------------------------------------------
95: -- GLOBAL VARIABLES
96: ---------------------------------------------------------------------------
97: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QCO_PVT';
98: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
99:
100: --Bug 4299668 PAGARG Included these types, to be used for bulk insert
101: --**START**--
102: TYPE NumberTabTyp IS TABLE OF NUMBER
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_qcov_tbl IN qcov_tbl_type,
139: x_qcov_tbl OUT NOCOPY qcov_tbl_type,
140: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
141: PROCEDURE insert_row(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2,
144: x_return_status OUT NOCOPY VARCHAR2,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_qcov_tbl IN qcov_tbl_type,
174: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
175: PROCEDURE lock_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2,
178: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_qcov_tbl IN qcov_tbl_type,
197: x_qcov_tbl OUT NOCOPY qcov_tbl_type,
198: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
199: PROCEDURE update_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2,
202: x_return_status OUT NOCOPY VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_qcov_tbl IN qcov_tbl_type,
221: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
222: PROCEDURE delete_row(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2,
225: x_return_status OUT NOCOPY VARCHAR2,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_qcov_tbl IN qcov_tbl_type,
243: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
244: PROCEDURE validate_row(
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2,
247: x_return_status OUT NOCOPY VARCHAR2,