2: /* $Header: OKLSCLDS.pls 120.6 2006/07/11 10:15:07 dkagrawa noship $ */
3: ---------------------------------------------------------------------------
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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;
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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;