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_CLD_PVT dependencies on OKL_API

Line 8: id NUMBER := OKL_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CHECKLIST_DETAILS_V Record Spec
7: TYPE cldv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKL_CHECKLIST_DETAILS_V Record Spec
7: TYPE cldv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 10: ,ckl_id NUMBER := OKL_API.G_MISS_NUM

6: -- OKL_CHECKLIST_DETAILS_V Record Spec
7: TYPE cldv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR

7: TYPE cldv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

10: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

11: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

12: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

13: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

14: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

15: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

16: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

17: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

18: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

19: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

20: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

21: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,org_id NUMBER := OKL_API.G_MISS_NUM
29: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

22: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,org_id NUMBER := OKL_API.G_MISS_NUM
29: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

23: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,org_id NUMBER := OKL_API.G_MISS_NUM
29: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 28: ,org_id NUMBER := OKL_API.G_MISS_NUM

24: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,org_id NUMBER := OKL_API.G_MISS_NUM
29: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 29: ,request_id NUMBER := OKL_API.G_MISS_NUM

25: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,org_id NUMBER := OKL_API.G_MISS_NUM
29: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

26: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,org_id NUMBER := OKL_API.G_MISS_NUM
29: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 31: ,program_id NUMBER := OKL_API.G_MISS_NUM

27: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,org_id NUMBER := OKL_API.G_MISS_NUM
29: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

28: ,org_id NUMBER := OKL_API.G_MISS_NUM
29: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 33: ,created_by NUMBER := OKL_API.G_MISS_NUM

29: ,request_id NUMBER := OKL_API.G_MISS_NUM
30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

Line 34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

30: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
38: -- start: Apr 25, 2005 cklee: Modification for okl.h

Line 35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

31: ,program_id NUMBER := OKL_API.G_MISS_NUM
32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
38: -- start: Apr 25, 2005 cklee: Modification for okl.h
39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR

Line 36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

32: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
38: -- start: Apr 25, 2005 cklee: Modification for okl.h
39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR

Line 37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

33: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
38: -- start: Apr 25, 2005 cklee: Modification for okl.h
39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR

Line 39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR

35: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
38: -- start: Apr 25, 2005 cklee: Modification for okl.h
39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM

Line 40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR

36: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
38: -- start: Apr 25, 2005 cklee: Modification for okl.h
39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM

Line 41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR

37: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
38: -- start: Apr 25, 2005 cklee: Modification for okl.h
39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
45: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR

Line 42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR

38: -- start: Apr 25, 2005 cklee: Modification for okl.h
39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
45: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
46: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR

Line 43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM

39: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
45: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
46: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
47: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR

Line 44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM

40: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
45: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
46: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
47: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
48: -- end: Apr 25, 2005 cklee: Modification for okl.h

Line 45: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR

41: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
45: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
46: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
47: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
48: -- end: Apr 25, 2005 cklee: Modification for okl.h
49: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal

Line 46: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR

42: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
45: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
46: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
47: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
48: -- end: Apr 25, 2005 cklee: Modification for okl.h
49: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
50: ,APPEAL_FLAG OKL_CHECKLIST_DETAILS.APPEAL_FLAG%TYPE := OKL_API.G_MISS_CHAR

Line 47: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR

43: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
44: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
45: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
46: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
47: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
48: -- end: Apr 25, 2005 cklee: Modification for okl.h
49: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
50: ,APPEAL_FLAG OKL_CHECKLIST_DETAILS.APPEAL_FLAG%TYPE := OKL_API.G_MISS_CHAR
51: );

Line 50: ,APPEAL_FLAG OKL_CHECKLIST_DETAILS.APPEAL_FLAG%TYPE := OKL_API.G_MISS_CHAR

46: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
47: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
48: -- end: Apr 25, 2005 cklee: Modification for okl.h
49: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
50: ,APPEAL_FLAG OKL_CHECKLIST_DETAILS.APPEAL_FLAG%TYPE := OKL_API.G_MISS_CHAR
51: );
52: G_MISS_cldv_rec cldv_rec_type;
53: TYPE cldv_tbl_type IS TABLE OF cldv_rec_type
54: INDEX BY BINARY_INTEGER;

Line 57: id NUMBER := OKL_API.G_MISS_NUM

53: TYPE cldv_tbl_type IS TABLE OF cldv_rec_type
54: INDEX BY BINARY_INTEGER;
55: -- OKL_CHECKLIST_DETAILS Record Spec
56: TYPE cld_rec_type IS RECORD (
57: id NUMBER := OKL_API.G_MISS_NUM
58: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
59: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 58: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

54: INDEX BY BINARY_INTEGER;
55: -- OKL_CHECKLIST_DETAILS Record Spec
56: TYPE cld_rec_type IS RECORD (
57: id NUMBER := OKL_API.G_MISS_NUM
58: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
59: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 59: ,ckl_id NUMBER := OKL_API.G_MISS_NUM

55: -- OKL_CHECKLIST_DETAILS Record Spec
56: TYPE cld_rec_type IS RECORD (
57: id NUMBER := OKL_API.G_MISS_NUM
58: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
59: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR

56: TYPE cld_rec_type IS RECORD (
57: id NUMBER := OKL_API.G_MISS_NUM
58: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
59: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

57: id NUMBER := OKL_API.G_MISS_NUM
58: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
59: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

58: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
59: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

59: ,ckl_id NUMBER := OKL_API.G_MISS_NUM
60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

60: ,todo_item_code OKL_CHECKLIST_DETAILS.TODO_ITEM_CODE%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

61: ,attribute_category OKL_CHECKLIST_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

62: ,attribute1 OKL_CHECKLIST_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

63: ,attribute2 OKL_CHECKLIST_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

64: ,attribute3 OKL_CHECKLIST_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

65: ,attribute4 OKL_CHECKLIST_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

66: ,attribute5 OKL_CHECKLIST_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

67: ,attribute6 OKL_CHECKLIST_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

68: ,attribute7 OKL_CHECKLIST_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

69: ,attribute8 OKL_CHECKLIST_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
77: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

70: ,attribute9 OKL_CHECKLIST_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
77: ,org_id NUMBER := OKL_API.G_MISS_NUM
78: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

71: ,attribute10 OKL_CHECKLIST_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
77: ,org_id NUMBER := OKL_API.G_MISS_NUM
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

72: ,attribute11 OKL_CHECKLIST_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
77: ,org_id NUMBER := OKL_API.G_MISS_NUM
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
80: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 77: ,org_id NUMBER := OKL_API.G_MISS_NUM

73: ,attribute12 OKL_CHECKLIST_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
77: ,org_id NUMBER := OKL_API.G_MISS_NUM
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
80: ,program_id NUMBER := OKL_API.G_MISS_NUM
81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 78: ,request_id NUMBER := OKL_API.G_MISS_NUM

74: ,attribute13 OKL_CHECKLIST_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
77: ,org_id NUMBER := OKL_API.G_MISS_NUM
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
80: ,program_id NUMBER := OKL_API.G_MISS_NUM
81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

75: ,attribute14 OKL_CHECKLIST_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
77: ,org_id NUMBER := OKL_API.G_MISS_NUM
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
80: ,program_id NUMBER := OKL_API.G_MISS_NUM
81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 80: ,program_id NUMBER := OKL_API.G_MISS_NUM

76: ,attribute15 OKL_CHECKLIST_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
77: ,org_id NUMBER := OKL_API.G_MISS_NUM
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
80: ,program_id NUMBER := OKL_API.G_MISS_NUM
81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

77: ,org_id NUMBER := OKL_API.G_MISS_NUM
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
80: ,program_id NUMBER := OKL_API.G_MISS_NUM
81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 82: ,created_by NUMBER := OKL_API.G_MISS_NUM

78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
80: ,program_id NUMBER := OKL_API.G_MISS_NUM
81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

Line 83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
80: ,program_id NUMBER := OKL_API.G_MISS_NUM
81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
87: -- start: Apr 25, 2005 cklee: Modification for okl.h

Line 84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

80: ,program_id NUMBER := OKL_API.G_MISS_NUM
81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
87: -- start: Apr 25, 2005 cklee: Modification for okl.h
88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR

Line 85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

81: ,program_update_date OKL_CHECKLIST_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
87: -- start: Apr 25, 2005 cklee: Modification for okl.h
88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR

Line 86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM

82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_CHECKLIST_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
87: -- start: Apr 25, 2005 cklee: Modification for okl.h
88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR

Line 88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR

84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
87: -- start: Apr 25, 2005 cklee: Modification for okl.h
88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM

Line 89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR

85: ,last_update_date OKL_CHECKLIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
87: -- start: Apr 25, 2005 cklee: Modification for okl.h
88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM

Line 90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR

86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
87: -- start: Apr 25, 2005 cklee: Modification for okl.h
88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
94: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR

Line 91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR

87: -- start: Apr 25, 2005 cklee: Modification for okl.h
88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
94: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
95: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR

Line 92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM

88: ,MANDATORY_FLAG OKL_CHECKLIST_DETAILS.MANDATORY_FLAG%TYPE := OKL_API.G_MISS_CHAR
89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
94: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
95: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
96: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR

Line 93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM

89: ,USER_COMPLETE_FLAG OKL_CHECKLIST_DETAILS.USER_COMPLETE_FLAG%TYPE := OKL_API.G_MISS_CHAR
90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
94: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
95: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
96: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
97: -- end: Apr 25, 2005 cklee: Modification for okl.h

Line 94: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR

90: ,ADMIN_NOTE OKL_CHECKLIST_DETAILS.ADMIN_NOTE%TYPE := OKL_API.G_MISS_CHAR
91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
94: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
95: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
96: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
97: -- end: Apr 25, 2005 cklee: Modification for okl.h
98: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal

Line 95: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR

91: ,USER_NOTE OKL_CHECKLIST_DETAILS.USER_NOTE%TYPE := OKL_API.G_MISS_CHAR
92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
94: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
95: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
96: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
97: -- end: Apr 25, 2005 cklee: Modification for okl.h
98: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
99: ,APPEAL_FLAG OKL_CHECKLIST_DETAILS.APPEAL_FLAG%TYPE := OKL_API.G_MISS_CHAR

Line 96: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR

92: ,DNZ_CHECKLIST_OBJ_ID NUMBER := OKL_API.G_MISS_NUM
93: ,FUNCTION_ID NUMBER := OKL_API.G_MISS_NUM
94: ,FUNCTION_VALIDATE_RSTS OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_RSTS%TYPE := OKL_API.G_MISS_CHAR
95: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
96: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
97: -- end: Apr 25, 2005 cklee: Modification for okl.h
98: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
99: ,APPEAL_FLAG OKL_CHECKLIST_DETAILS.APPEAL_FLAG%TYPE := OKL_API.G_MISS_CHAR
100: );

Line 99: ,APPEAL_FLAG OKL_CHECKLIST_DETAILS.APPEAL_FLAG%TYPE := OKL_API.G_MISS_CHAR

95: ,FUNCTION_VALIDATE_MSG OKL_CHECKLIST_DETAILS.FUNCTION_VALIDATE_MSG%TYPE := OKL_API.G_MISS_CHAR
96: ,INST_CHECKLIST_TYPE OKL_CHECKLIST_DETAILS.INST_CHECKLIST_TYPE%TYPE := OKL_API.G_MISS_CHAR
97: -- end: Apr 25, 2005 cklee: Modification for okl.h
98: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
99: ,APPEAL_FLAG OKL_CHECKLIST_DETAILS.APPEAL_FLAG%TYPE := OKL_API.G_MISS_CHAR
100: );
101: G_MISS_cld_rec cld_rec_type;
102: TYPE cld_tbl_type IS TABLE OF cld_rec_type
103: INDEX BY BINARY_INTEGER;

Line 107: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

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

Line 108: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

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

Line 109: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

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

Line 110: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

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

Line 111: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

Line 112: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

Line 113: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

Line 114: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

Line 115: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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

Line 116: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

Line 130: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

126: ---------------------------------------------------------------------------
127: -- GLOBAL VARIABLES
128: ---------------------------------------------------------------------------
129: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CLD_PVT';
130: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
131: ---------------------------------------------------------------------------
132: -- Procedures and Functions
133: ---------------------------------------------------------------------------
134:

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

136: PROCEDURE change_version;
137: PROCEDURE api_copy;
138: PROCEDURE insert_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_cldv_rec IN cldv_rec_type,

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

144: p_cldv_rec IN cldv_rec_type,
145: x_cldv_rec OUT NOCOPY cldv_rec_type);
146: PROCEDURE insert_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_cldv_tbl IN cldv_tbl_type,

Line 154: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_cldv_tbl IN cldv_tbl_type,
153: x_cldv_tbl OUT NOCOPY cldv_tbl_type,
154: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
155: PROCEDURE insert_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

153: x_cldv_tbl OUT NOCOPY cldv_tbl_type,
154: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
155: PROCEDURE insert_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_cldv_tbl IN cldv_tbl_type,

Line 165: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

161: p_cldv_tbl IN cldv_tbl_type,
162: x_cldv_tbl OUT NOCOPY cldv_tbl_type);
163: PROCEDURE lock_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_cldv_rec IN cldv_rec_type);

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_cldv_rec IN cldv_rec_type);
170: PROCEDURE lock_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_cldv_tbl IN cldv_tbl_type,

Line 177: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_cldv_tbl IN cldv_tbl_type,
177: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
178: PROCEDURE lock_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

176: p_cldv_tbl IN cldv_tbl_type,
177: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
178: PROCEDURE lock_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_cldv_tbl IN cldv_tbl_type);

Line 187: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_cldv_tbl IN cldv_tbl_type);
185: PROCEDURE update_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_cldv_rec IN cldv_rec_type,

Line 195: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

191: p_cldv_rec IN cldv_rec_type,
192: x_cldv_rec OUT NOCOPY cldv_rec_type);
193: PROCEDURE update_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_cldv_tbl IN cldv_tbl_type,

Line 201: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_cldv_tbl IN cldv_tbl_type,
200: x_cldv_tbl OUT NOCOPY cldv_tbl_type,
201: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
202: PROCEDURE update_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,

Line 204: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

200: x_cldv_tbl OUT NOCOPY cldv_tbl_type,
201: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
202: PROCEDURE update_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_cldv_tbl IN cldv_tbl_type,

Line 212: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

208: p_cldv_tbl IN cldv_tbl_type,
209: x_cldv_tbl OUT NOCOPY cldv_tbl_type);
210: PROCEDURE delete_row(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cldv_rec IN cldv_rec_type);

Line 219: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cldv_rec IN cldv_rec_type);
217: PROCEDURE delete_row(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_cldv_tbl IN cldv_tbl_type,

Line 224: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_cldv_tbl IN cldv_tbl_type,
224: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
225: PROCEDURE delete_row(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,

Line 227: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

223: p_cldv_tbl IN cldv_tbl_type,
224: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
225: PROCEDURE delete_row(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_cldv_tbl IN cldv_tbl_type);

Line 234: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_cldv_tbl IN cldv_tbl_type);
232: PROCEDURE validate_row(
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2,
238: p_cldv_rec IN cldv_rec_type);

Line 241: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

237: x_msg_data OUT NOCOPY VARCHAR2,
238: p_cldv_rec IN cldv_rec_type);
239: PROCEDURE validate_row(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_cldv_tbl IN cldv_tbl_type,

Line 246: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_cldv_tbl IN cldv_tbl_type,
246: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
247: PROCEDURE validate_row(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,

Line 249: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

245: p_cldv_tbl IN cldv_tbl_type,
246: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
247: PROCEDURE validate_row(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_cldv_tbl IN cldv_tbl_type);