eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_QLP_PVT dependencies on OKC_API

Line 7: pdf_id NUMBER := OKC_API.G_MISS_NUM,

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qlp_rec_type IS RECORD (
7: pdf_id NUMBER := OKC_API.G_MISS_NUM,
8: qcl_id NUMBER := OKC_API.G_MISS_NUM,
9: severity OKC_QA_LIST_PROCESSES.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
11: run_sequence NUMBER := OKC_API.G_MISS_NUM,

Line 8: qcl_id NUMBER := OKC_API.G_MISS_NUM,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qlp_rec_type IS RECORD (
7: pdf_id NUMBER := OKC_API.G_MISS_NUM,
8: qcl_id NUMBER := OKC_API.G_MISS_NUM,
9: severity OKC_QA_LIST_PROCESSES.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
11: run_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 9: severity OKC_QA_LIST_PROCESSES.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,

5: ---------------------------------------------------------------------------
6: TYPE qlp_rec_type IS RECORD (
7: pdf_id NUMBER := OKC_API.G_MISS_NUM,
8: qcl_id NUMBER := OKC_API.G_MISS_NUM,
9: severity OKC_QA_LIST_PROCESSES.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
11: run_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,

6: TYPE qlp_rec_type IS RECORD (
7: pdf_id NUMBER := OKC_API.G_MISS_NUM,
8: qcl_id NUMBER := OKC_API.G_MISS_NUM,
9: severity OKC_QA_LIST_PROCESSES.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
11: run_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 11: run_sequence NUMBER := OKC_API.G_MISS_NUM,

7: pdf_id NUMBER := OKC_API.G_MISS_NUM,
8: qcl_id NUMBER := OKC_API.G_MISS_NUM,
9: severity OKC_QA_LIST_PROCESSES.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
11: run_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 12: object_version_number NUMBER := OKC_API.G_MISS_NUM,

8: qcl_id NUMBER := OKC_API.G_MISS_NUM,
9: severity OKC_QA_LIST_PROCESSES.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
11: run_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 13: created_by NUMBER := OKC_API.G_MISS_NUM,

9: severity OKC_QA_LIST_PROCESSES.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
11: run_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

10: active_yn OKC_QA_LIST_PROCESSES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
11: run_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

11: run_sequence NUMBER := OKC_API.G_MISS_NUM,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 17: last_update_login NUMBER := OKC_API.G_MISS_NUM,

13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

14: creation_date OKC_QA_LIST_PROCESSES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

16: last_update_date OKC_QA_LIST_PROCESSES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

18: attribute_category OKC_QA_LIST_PROCESSES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

19: attribute1 OKC_QA_LIST_PROCESSES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

20: attribute2 OKC_QA_LIST_PROCESSES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

21: attribute3 OKC_QA_LIST_PROCESSES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

22: attribute4 OKC_QA_LIST_PROCESSES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

23: attribute5 OKC_QA_LIST_PROCESSES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

24: attribute6 OKC_QA_LIST_PROCESSES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKC_QA_LIST_PROCESSES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

25: attribute7 OKC_QA_LIST_PROCESSES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKC_QA_LIST_PROCESSES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKC_QA_LIST_PROCESSES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

26: attribute8 OKC_QA_LIST_PROCESSES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKC_QA_LIST_PROCESSES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKC_QA_LIST_PROCESSES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: access_level OKC_QA_LIST_PROCESSES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

Line 31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

27: attribute9 OKC_QA_LIST_PROCESSES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKC_QA_LIST_PROCESSES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKC_QA_LIST_PROCESSES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: access_level OKC_QA_LIST_PROCESSES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_qlp_rec qlp_rec_type;

Line 32: attribute14 OKC_QA_LIST_PROCESSES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

28: attribute10 OKC_QA_LIST_PROCESSES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKC_QA_LIST_PROCESSES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKC_QA_LIST_PROCESSES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: access_level OKC_QA_LIST_PROCESSES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_qlp_rec qlp_rec_type;
36: TYPE qlp_tbl_type IS TABLE OF qlp_rec_type

Line 33: attribute15 OKC_QA_LIST_PROCESSES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

29: attribute11 OKC_QA_LIST_PROCESSES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKC_QA_LIST_PROCESSES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKC_QA_LIST_PROCESSES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: access_level OKC_QA_LIST_PROCESSES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_qlp_rec qlp_rec_type;
36: TYPE qlp_tbl_type IS TABLE OF qlp_rec_type
37: INDEX BY BINARY_INTEGER;

Line 34: access_level OKC_QA_LIST_PROCESSES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

30: attribute12 OKC_QA_LIST_PROCESSES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31: attribute13 OKC_QA_LIST_PROCESSES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32: attribute14 OKC_QA_LIST_PROCESSES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33: attribute15 OKC_QA_LIST_PROCESSES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34: access_level OKC_QA_LIST_PROCESSES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_qlp_rec qlp_rec_type;
36: TYPE qlp_tbl_type IS TABLE OF qlp_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE qlpv_rec_type IS RECORD (

Line 40: qcl_id NUMBER := OKC_API.G_MISS_NUM,

36: TYPE qlp_tbl_type IS TABLE OF qlp_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE qlpv_rec_type IS RECORD (
39: row_id ROWID,
40: qcl_id NUMBER := OKC_API.G_MISS_NUM,
41: pdf_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 41: pdf_id NUMBER := OKC_API.G_MISS_NUM,

37: INDEX BY BINARY_INTEGER;
38: TYPE qlpv_rec_type IS RECORD (
39: row_id ROWID,
40: qcl_id NUMBER := OKC_API.G_MISS_NUM,
41: pdf_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
45: run_sequence NUMBER := OKC_API.G_MISS_NUM,

Line 42: object_version_number NUMBER := OKC_API.G_MISS_NUM,

38: TYPE qlpv_rec_type IS RECORD (
39: row_id ROWID,
40: qcl_id NUMBER := OKC_API.G_MISS_NUM,
41: pdf_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
45: run_sequence NUMBER := OKC_API.G_MISS_NUM,
46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,

39: row_id ROWID,
40: qcl_id NUMBER := OKC_API.G_MISS_NUM,
41: pdf_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
45: run_sequence NUMBER := OKC_API.G_MISS_NUM,
46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,

40: qcl_id NUMBER := OKC_API.G_MISS_NUM,
41: pdf_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
45: run_sequence NUMBER := OKC_API.G_MISS_NUM,
46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 45: run_sequence NUMBER := OKC_API.G_MISS_NUM,

41: pdf_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
45: run_sequence NUMBER := OKC_API.G_MISS_NUM,
46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
45: run_sequence NUMBER := OKC_API.G_MISS_NUM,
46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

43: severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE := OKC_API.G_MISS_CHAR,
44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
45: run_sequence NUMBER := OKC_API.G_MISS_NUM,
46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

44: active_yn OKC_QA_LIST_PROCESSES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
45: run_sequence NUMBER := OKC_API.G_MISS_NUM,
46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

45: run_sequence NUMBER := OKC_API.G_MISS_NUM,
46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

46: attribute_category OKC_QA_LIST_PROCESSES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

47: attribute1 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

48: attribute2 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

49: attribute3 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

50: attribute4 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

51: attribute5 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

52: attribute6 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

53: attribute7 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

54: attribute8 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

55: attribute9 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

56: attribute10 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

57: attribute11 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKC_QA_LIST_PROCESSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 62: created_by NUMBER := OKC_API.G_MISS_NUM,

58: attribute12 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKC_QA_LIST_PROCESSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

59: attribute13 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKC_QA_LIST_PROCESSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM,
67: access_level OKC_QA_LIST_PROCESSES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

Line 64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

60: attribute14 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKC_QA_LIST_PROCESSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM,
67: access_level OKC_QA_LIST_PROCESSES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
68: g_miss_qlpv_rec qlpv_rec_type;

Line 65: last_update_date OKC_QA_LIST_PROCESSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

61: attribute15 OKC_QA_LIST_PROCESSES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKC_QA_LIST_PROCESSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM,
67: access_level OKC_QA_LIST_PROCESSES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
68: g_miss_qlpv_rec qlpv_rec_type;
69: TYPE qlpv_tbl_type IS TABLE OF qlpv_rec_type

Line 66: last_update_login NUMBER := OKC_API.G_MISS_NUM,

62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKC_QA_LIST_PROCESSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM,
67: access_level OKC_QA_LIST_PROCESSES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
68: g_miss_qlpv_rec qlpv_rec_type;
69: TYPE qlpv_tbl_type IS TABLE OF qlpv_rec_type
70: INDEX BY BINARY_INTEGER;

Line 67: access_level OKC_QA_LIST_PROCESSES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

63: creation_date OKC_QA_LIST_PROCESSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKC_QA_LIST_PROCESSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM,
67: access_level OKC_QA_LIST_PROCESSES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
68: g_miss_qlpv_rec qlpv_rec_type;
69: TYPE qlpv_tbl_type IS TABLE OF qlpv_rec_type
70: INDEX BY BINARY_INTEGER;
71: ---------------------------------------------------------------------------

Line 74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

70: INDEX BY BINARY_INTEGER;
71: ---------------------------------------------------------------------------
72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

71: ---------------------------------------------------------------------------
72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: ---------------------------------------------------------------------------

Line 81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: ---------------------------------------------------------------------------
85: -- GLOBAL VARIABLES

Line 82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: ---------------------------------------------------------------------------
85: -- GLOBAL VARIABLES
86: ---------------------------------------------------------------------------

Line 83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: ---------------------------------------------------------------------------
85: -- GLOBAL VARIABLES
86: ---------------------------------------------------------------------------
87: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QLP_PVT';

Line 88: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

84: ---------------------------------------------------------------------------
85: -- GLOBAL VARIABLES
86: ---------------------------------------------------------------------------
87: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QLP_PVT';
88: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
89: ---------------------------------------------------------------------------
90: -- Procedures and Functions
91: ---------------------------------------------------------------------------
92:

Line 98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

94: PROCEDURE change_version;
95: PROCEDURE api_copy;
96: PROCEDURE insert_row(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_qlpv_rec IN qlpv_rec_type,

Line 107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

103: x_qlpv_rec OUT NOCOPY qlpv_rec_type);
104:
105: PROCEDURE insert_row(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_qlpv_tbl IN qlpv_tbl_type,

Line 116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

112: x_qlpv_tbl OUT NOCOPY qlpv_tbl_type);
113:
114: PROCEDURE lock_row(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_qlpv_rec IN qlpv_rec_type);

Line 124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

120: p_qlpv_rec IN qlpv_rec_type);
121:
122: PROCEDURE lock_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_qlpv_tbl IN qlpv_tbl_type);

Line 132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

128: p_qlpv_tbl IN qlpv_tbl_type);
129:
130: PROCEDURE update_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_qlpv_rec IN qlpv_rec_type,

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

137: x_qlpv_rec OUT NOCOPY qlpv_rec_type);
138:
139: PROCEDURE update_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_qlpv_tbl IN qlpv_tbl_type,

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

146: x_qlpv_tbl OUT NOCOPY qlpv_tbl_type);
147:
148: PROCEDURE delete_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_qlpv_rec IN qlpv_rec_type);

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

154: p_qlpv_rec IN qlpv_rec_type);
155:
156: PROCEDURE delete_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_qlpv_tbl IN qlpv_tbl_type);

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

162: p_qlpv_tbl IN qlpv_tbl_type);
163:
164: PROCEDURE validate_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_qlpv_rec IN qlpv_rec_type);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: p_qlpv_rec IN qlpv_rec_type);
171:
172: PROCEDURE validate_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_qlpv_tbl IN qlpv_tbl_type);