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.OKL_CLH_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CHECKLISTS_V Record Spec
7: TYPE clhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKL_CHECKLISTS_V Record Spec
7: TYPE clhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR

6: -- OKL_CHECKLISTS_V Record Spec
7: TYPE clhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

7: TYPE clhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR

9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE

10: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE

11: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR

12: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

13: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 18: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

14: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

15: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 20: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

16: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 21: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

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

Line 22: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

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

Line 23: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

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

Line 24: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

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

Line 25: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

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

Line 26: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

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

Line 27: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

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

Line 28: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

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

Line 29: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

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

Line 30: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

26: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,org_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 31: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

27: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,org_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 32: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

28: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,org_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 33: ,org_id NUMBER := OKC_API.G_MISS_NUM

29: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,org_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_id NUMBER := OKC_API.G_MISS_NUM
37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 34: ,request_id NUMBER := OKC_API.G_MISS_NUM

30: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,org_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_id NUMBER := OKC_API.G_MISS_NUM
37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

31: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,org_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_id NUMBER := OKC_API.G_MISS_NUM
37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 36: ,program_id NUMBER := OKC_API.G_MISS_NUM

32: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,org_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_id NUMBER := OKC_API.G_MISS_NUM
37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

33: ,org_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_id NUMBER := OKC_API.G_MISS_NUM
37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 38: ,created_by NUMBER := OKC_API.G_MISS_NUM

34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_id NUMBER := OKC_API.G_MISS_NUM
37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_id NUMBER := OKC_API.G_MISS_NUM
37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
43: -- start: Apr 25, 2005 cklee: Modification for okl.h

Line 40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

36: ,program_id NUMBER := OKC_API.G_MISS_NUM
37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
43: -- start: Apr 25, 2005 cklee: Modification for okl.h
44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

37: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
43: -- start: Apr 25, 2005 cklee: Modification for okl.h
44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

38: ,created_by NUMBER := OKC_API.G_MISS_NUM
39: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
43: -- start: Apr 25, 2005 cklee: Modification for okl.h
44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM

Line 44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR

40: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
43: -- start: Apr 25, 2005 cklee: Modification for okl.h
44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
47: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM

Line 45: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE

41: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
43: -- start: Apr 25, 2005 cklee: Modification for okl.h
44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
47: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM
49: -- end: Apr 25, 2005 cklee: Modification for okl.h

Line 46: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM

42: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
43: -- start: Apr 25, 2005 cklee: Modification for okl.h
44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
47: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM
49: -- end: Apr 25, 2005 cklee: Modification for okl.h
50: );

Line 47: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR

43: -- start: Apr 25, 2005 cklee: Modification for okl.h
44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
47: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM
49: -- end: Apr 25, 2005 cklee: Modification for okl.h
50: );
51: G_MISS_clhv_rec clhv_rec_type;

Line 48: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM

44: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
47: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM
49: -- end: Apr 25, 2005 cklee: Modification for okl.h
50: );
51: G_MISS_clhv_rec clhv_rec_type;
52: TYPE clhv_tbl_type IS TABLE OF clhv_rec_type

Line 56: id NUMBER := OKC_API.G_MISS_NUM

52: TYPE clhv_tbl_type IS TABLE OF clhv_rec_type
53: INDEX BY BINARY_INTEGER;
54: -- OKL_CHECKLISTS Record Spec
55: TYPE clh_rec_type IS RECORD (
56: id NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

53: INDEX BY BINARY_INTEGER;
54: -- OKL_CHECKLISTS Record Spec
55: TYPE clh_rec_type IS RECORD (
56: id NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 58: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR

54: -- OKL_CHECKLISTS Record Spec
55: TYPE clh_rec_type IS RECORD (
56: id NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

55: TYPE clh_rec_type IS RECORD (
56: id NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

56: id NUMBER := OKC_API.G_MISS_NUM
57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR

57: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE

58: ,checklist_number OKL_CHECKLISTS.CHECKLIST_NUMBER%TYPE := OKC_API.G_MISS_CHAR
59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE

59: ,description OKL_CHECKLISTS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR

60: ,short_description OKL_CHECKLISTS.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

61: ,checklist_type OKL_CHECKLISTS.CHECKLIST_TYPE%TYPE := OKC_API.G_MISS_CHAR
62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

62: ,start_date OKL_CHECKLISTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

63: ,end_date OKL_CHECKLISTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

64: ,status_code OKL_CHECKLISTS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

65: ,attribute_category OKL_CHECKLISTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

Line 70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

66: ,attribute1 OKL_CHECKLISTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

Line 71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

67: ,attribute2 OKL_CHECKLISTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

Line 72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

68: ,attribute3 OKL_CHECKLISTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

Line 73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

69: ,attribute4 OKL_CHECKLISTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

Line 74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

70: ,attribute5 OKL_CHECKLISTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

Line 75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

71: ,attribute6 OKL_CHECKLISTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

Line 76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

72: ,attribute7 OKL_CHECKLISTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

Line 77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

73: ,attribute8 OKL_CHECKLISTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
81: ,org_id NUMBER := OKC_API.G_MISS_NUM

Line 78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

74: ,attribute9 OKL_CHECKLISTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
81: ,org_id NUMBER := OKC_API.G_MISS_NUM
82: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

75: ,attribute10 OKL_CHECKLISTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
81: ,org_id NUMBER := OKC_API.G_MISS_NUM
82: ,request_id NUMBER := OKC_API.G_MISS_NUM
83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

76: ,attribute11 OKL_CHECKLISTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
81: ,org_id NUMBER := OKC_API.G_MISS_NUM
82: ,request_id NUMBER := OKC_API.G_MISS_NUM
83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
84: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 81: ,org_id NUMBER := OKC_API.G_MISS_NUM

77: ,attribute12 OKL_CHECKLISTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
81: ,org_id NUMBER := OKC_API.G_MISS_NUM
82: ,request_id NUMBER := OKC_API.G_MISS_NUM
83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
84: ,program_id NUMBER := OKC_API.G_MISS_NUM
85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 82: ,request_id NUMBER := OKC_API.G_MISS_NUM

78: ,attribute13 OKL_CHECKLISTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
81: ,org_id NUMBER := OKC_API.G_MISS_NUM
82: ,request_id NUMBER := OKC_API.G_MISS_NUM
83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
84: ,program_id NUMBER := OKC_API.G_MISS_NUM
85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

79: ,attribute14 OKL_CHECKLISTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
81: ,org_id NUMBER := OKC_API.G_MISS_NUM
82: ,request_id NUMBER := OKC_API.G_MISS_NUM
83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
84: ,program_id NUMBER := OKC_API.G_MISS_NUM
85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,created_by NUMBER := OKC_API.G_MISS_NUM
87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 84: ,program_id NUMBER := OKC_API.G_MISS_NUM

80: ,attribute15 OKL_CHECKLISTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
81: ,org_id NUMBER := OKC_API.G_MISS_NUM
82: ,request_id NUMBER := OKC_API.G_MISS_NUM
83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
84: ,program_id NUMBER := OKC_API.G_MISS_NUM
85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,created_by NUMBER := OKC_API.G_MISS_NUM
87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

81: ,org_id NUMBER := OKC_API.G_MISS_NUM
82: ,request_id NUMBER := OKC_API.G_MISS_NUM
83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
84: ,program_id NUMBER := OKC_API.G_MISS_NUM
85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,created_by NUMBER := OKC_API.G_MISS_NUM
87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 86: ,created_by NUMBER := OKC_API.G_MISS_NUM

82: ,request_id NUMBER := OKC_API.G_MISS_NUM
83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
84: ,program_id NUMBER := OKC_API.G_MISS_NUM
85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,created_by NUMBER := OKC_API.G_MISS_NUM
87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

83: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
84: ,program_id NUMBER := OKC_API.G_MISS_NUM
85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,created_by NUMBER := OKC_API.G_MISS_NUM
87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
91: -- start: Apr 25, 2005 cklee: Modification for okl.h

Line 88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

84: ,program_id NUMBER := OKC_API.G_MISS_NUM
85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,created_by NUMBER := OKC_API.G_MISS_NUM
87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
91: -- start: Apr 25, 2005 cklee: Modification for okl.h
92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

85: ,program_update_date OKL_CHECKLISTS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,created_by NUMBER := OKC_API.G_MISS_NUM
87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
91: -- start: Apr 25, 2005 cklee: Modification for okl.h
92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

86: ,created_by NUMBER := OKC_API.G_MISS_NUM
87: ,creation_date OKL_CHECKLISTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
91: -- start: Apr 25, 2005 cklee: Modification for okl.h
92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM

Line 92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR

88: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
91: -- start: Apr 25, 2005 cklee: Modification for okl.h
92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
95: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
96: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM

Line 93: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE

89: ,last_update_date OKL_CHECKLISTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
91: -- start: Apr 25, 2005 cklee: Modification for okl.h
92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
95: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
96: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM
97: -- end: Apr 25, 2005 cklee: Modification for okl.h

Line 94: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM

90: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
91: -- start: Apr 25, 2005 cklee: Modification for okl.h
92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
95: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
96: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM
97: -- end: Apr 25, 2005 cklee: Modification for okl.h
98: );

Line 95: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR

91: -- start: Apr 25, 2005 cklee: Modification for okl.h
92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
95: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
96: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM
97: -- end: Apr 25, 2005 cklee: Modification for okl.h
98: );
99: G_MISS_clh_rec clh_rec_type;

Line 96: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM

92: ,CHECKLIST_PURPOSE_CODE OKL_CHECKLISTS.CHECKLIST_PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,DECISION_DATE OKL_CHECKLISTS.DECISION_DATE%TYPE := OKC_API.G_MISS_DATE
94: ,CHECKLIST_OBJ_ID NUMBER := OKC_API.G_MISS_NUM
95: ,CHECKLIST_OBJ_TYPE_CODE OKL_CHECKLISTS.CHECKLIST_OBJ_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
96: ,CKL_ID NUMBER := OKC_API.G_MISS_NUM
97: -- end: Apr 25, 2005 cklee: Modification for okl.h
98: );
99: G_MISS_clh_rec clh_rec_type;
100: TYPE clh_tbl_type IS TABLE OF clh_rec_type

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

101: INDEX BY BINARY_INTEGER;
102: ---------------------------------------------------------------------------
103: -- GLOBAL MESSAGE CONSTANTS
104: ---------------------------------------------------------------------------
105: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

102: ---------------------------------------------------------------------------
103: -- GLOBAL MESSAGE CONSTANTS
104: ---------------------------------------------------------------------------
105: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

103: -- GLOBAL MESSAGE CONSTANTS
104: ---------------------------------------------------------------------------
105: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

104: ---------------------------------------------------------------------------
105: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

105: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

106: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

107: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
115: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

108: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
115: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
116: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

109: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
115: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
116: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
117: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

110: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
111: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
112: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
113: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
114: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
115: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
116: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
117: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
118:

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

124: ---------------------------------------------------------------------------
125: -- GLOBAL VARIABLES
126: ---------------------------------------------------------------------------
127: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CLH_PVT';
128: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
129: ---------------------------------------------------------------------------
130: -- Procedures and Functions
131: ---------------------------------------------------------------------------
132:

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

134: PROCEDURE change_version;
135: PROCEDURE api_copy;
136: PROCEDURE insert_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_clhv_rec IN clhv_rec_type,

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

142: p_clhv_rec IN clhv_rec_type,
143: x_clhv_rec OUT NOCOPY clhv_rec_type);
144: PROCEDURE insert_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_clhv_tbl IN clhv_tbl_type,

Line 152: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_clhv_tbl IN clhv_tbl_type,
151: x_clhv_tbl OUT NOCOPY clhv_tbl_type,
152: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
153: PROCEDURE insert_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

151: x_clhv_tbl OUT NOCOPY clhv_tbl_type,
152: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
153: PROCEDURE insert_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_clhv_tbl IN clhv_tbl_type,

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

159: p_clhv_tbl IN clhv_tbl_type,
160: x_clhv_tbl OUT NOCOPY clhv_tbl_type);
161: PROCEDURE lock_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_clhv_rec IN clhv_rec_type);

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_clhv_rec IN clhv_rec_type);
168: PROCEDURE lock_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_clhv_tbl IN clhv_tbl_type,

Line 175: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_clhv_tbl IN clhv_tbl_type,
175: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
176: PROCEDURE lock_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

174: p_clhv_tbl IN clhv_tbl_type,
175: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
176: PROCEDURE lock_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_clhv_tbl IN clhv_tbl_type);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_clhv_tbl IN clhv_tbl_type);
183: PROCEDURE update_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_clhv_rec IN clhv_rec_type,

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

189: p_clhv_rec IN clhv_rec_type,
190: x_clhv_rec OUT NOCOPY clhv_rec_type);
191: PROCEDURE update_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_clhv_tbl IN clhv_tbl_type,

Line 199: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_clhv_tbl IN clhv_tbl_type,
198: x_clhv_tbl OUT NOCOPY clhv_tbl_type,
199: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
200: PROCEDURE update_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

198: x_clhv_tbl OUT NOCOPY clhv_tbl_type,
199: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
200: PROCEDURE update_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_clhv_tbl IN clhv_tbl_type,

Line 210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

206: p_clhv_tbl IN clhv_tbl_type,
207: x_clhv_tbl OUT NOCOPY clhv_tbl_type);
208: PROCEDURE delete_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_clhv_rec IN clhv_rec_type);

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_clhv_rec IN clhv_rec_type);
215: PROCEDURE delete_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_clhv_tbl IN clhv_tbl_type,

Line 222: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_clhv_tbl IN clhv_tbl_type,
222: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
223: PROCEDURE delete_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,

Line 225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

221: p_clhv_tbl IN clhv_tbl_type,
222: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
223: PROCEDURE delete_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_clhv_tbl IN clhv_tbl_type);

Line 232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_clhv_tbl IN clhv_tbl_type);
230: PROCEDURE validate_row(
231: p_api_version IN NUMBER,
232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_clhv_rec IN clhv_rec_type);

Line 239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_clhv_rec IN clhv_rec_type);
237: PROCEDURE validate_row(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_clhv_tbl IN clhv_tbl_type,

Line 244: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_clhv_tbl IN clhv_tbl_type,
244: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
245: PROCEDURE validate_row(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,

Line 247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

243: p_clhv_tbl IN clhv_tbl_type,
244: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
245: PROCEDURE validate_row(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_clhv_tbl IN clhv_tbl_type);