2: /* $Header: OKLSVCRS.pls 120.0 2005/07/28 11:30:08 sjalasut noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_VP_CHANGE_REQUESTS_V Record Spec
7: TYPE vcrv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,change_request_number NUMBER := OKL_API.G_MISS_NUM
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,change_request_number NUMBER := OKL_API.G_MISS_NUM
11: ,chr_id NUMBER := OKL_API.G_MISS_NUM
12: ,change_type_code OKL_VP_CHANGE_REQUESTS_V.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,status_code OKL_VP_CHANGE_REQUESTS_V.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
14: ,request_date OKL_VP_CHANGE_REQUESTS_V.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,effective_date OKL_VP_CHANGE_REQUESTS_V.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,change_request_number NUMBER := OKL_API.G_MISS_NUM
11: ,chr_id NUMBER := OKL_API.G_MISS_NUM
12: ,change_type_code OKL_VP_CHANGE_REQUESTS_V.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,status_code OKL_VP_CHANGE_REQUESTS_V.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
14: ,request_date OKL_VP_CHANGE_REQUESTS_V.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,effective_date OKL_VP_CHANGE_REQUESTS_V.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
10: ,change_request_number NUMBER := OKL_API.G_MISS_NUM
11: ,chr_id NUMBER := OKL_API.G_MISS_NUM
12: ,change_type_code OKL_VP_CHANGE_REQUESTS_V.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,status_code OKL_VP_CHANGE_REQUESTS_V.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
14: ,request_date OKL_VP_CHANGE_REQUESTS_V.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,effective_date OKL_VP_CHANGE_REQUESTS_V.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,chr_id NUMBER := OKL_API.G_MISS_NUM
12: ,change_type_code OKL_VP_CHANGE_REQUESTS_V.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,status_code OKL_VP_CHANGE_REQUESTS_V.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
14: ,request_date OKL_VP_CHANGE_REQUESTS_V.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,effective_date OKL_VP_CHANGE_REQUESTS_V.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,change_type_code OKL_VP_CHANGE_REQUESTS_V.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,status_code OKL_VP_CHANGE_REQUESTS_V.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
14: ,request_date OKL_VP_CHANGE_REQUESTS_V.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,effective_date OKL_VP_CHANGE_REQUESTS_V.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13: ,status_code OKL_VP_CHANGE_REQUESTS_V.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
14: ,request_date OKL_VP_CHANGE_REQUESTS_V.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,effective_date OKL_VP_CHANGE_REQUESTS_V.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14: ,request_date OKL_VP_CHANGE_REQUESTS_V.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,effective_date OKL_VP_CHANGE_REQUESTS_V.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_date OKL_VP_CHANGE_REQUESTS_V.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16: ,approved_date OKL_VP_CHANGE_REQUESTS_V.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17: ,rejected_date OKL_VP_CHANGE_REQUESTS_V.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18: ,ineffective_date OKL_VP_CHANGE_REQUESTS_V.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19: ,applied_date OKL_VP_CHANGE_REQUESTS_V.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute_category OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute1 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute2 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute3 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute4 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute12 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute5 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute12 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute13 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute6 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute12 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute13 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute14 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute7 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute12 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute13 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute14 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute15 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute8 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute12 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute13 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute14 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute15 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
36: ,request_id NUMBER := OKL_API.G_MISS_NUM
29: ,attribute9 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute12 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute13 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute14 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute15 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
36: ,request_id NUMBER := OKL_API.G_MISS_NUM
37: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
30: ,attribute10 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute12 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute13 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute14 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute15 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
36: ,request_id NUMBER := OKL_API.G_MISS_NUM
37: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_id NUMBER := OKL_API.G_MISS_NUM
31: ,attribute11 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute12 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute13 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute14 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute15 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
36: ,request_id NUMBER := OKL_API.G_MISS_NUM
37: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_update_date OKL_VP_CHANGE_REQUESTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,attribute15 OKL_VP_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
36: ,request_id NUMBER := OKL_API.G_MISS_NUM
37: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_update_date OKL_VP_CHANGE_REQUESTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
40: ,created_by NUMBER := OKL_API.G_MISS_NUM
41: ,creation_date OKL_VP_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
43: ,last_update_date OKL_VP_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
38: ,program_id NUMBER := OKL_API.G_MISS_NUM
39: ,program_update_date OKL_VP_CHANGE_REQUESTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
40: ,created_by NUMBER := OKL_API.G_MISS_NUM
41: ,creation_date OKL_VP_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
43: ,last_update_date OKL_VP_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
45: G_MISS_vcrv_rec vcrv_rec_type;
39: ,program_update_date OKL_VP_CHANGE_REQUESTS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
40: ,created_by NUMBER := OKL_API.G_MISS_NUM
41: ,creation_date OKL_VP_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
43: ,last_update_date OKL_VP_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
45: G_MISS_vcrv_rec vcrv_rec_type;
46: TYPE vcrv_tbl_type IS TABLE OF vcrv_rec_type
47: INDEX BY BINARY_INTEGER;
44: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
45: G_MISS_vcrv_rec vcrv_rec_type;
46: TYPE vcrv_tbl_type IS TABLE OF vcrv_rec_type
47: INDEX BY BINARY_INTEGER;
48: -- OKL_VP_CHANGE_REQUESTS Record Spec
49: TYPE vcr_rec_type IS RECORD (
50: id NUMBER := OKL_API.G_MISS_NUM
51: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
52: ,change_request_number NUMBER := OKL_API.G_MISS_NUM
50: id NUMBER := OKL_API.G_MISS_NUM
51: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
52: ,change_request_number NUMBER := OKL_API.G_MISS_NUM
53: ,chr_id NUMBER := OKL_API.G_MISS_NUM
54: ,change_type_code OKL_VP_CHANGE_REQUESTS.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
55: ,status_code OKL_VP_CHANGE_REQUESTS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
56: ,request_date OKL_VP_CHANGE_REQUESTS.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,effective_date OKL_VP_CHANGE_REQUESTS.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
51: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
52: ,change_request_number NUMBER := OKL_API.G_MISS_NUM
53: ,chr_id NUMBER := OKL_API.G_MISS_NUM
54: ,change_type_code OKL_VP_CHANGE_REQUESTS.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
55: ,status_code OKL_VP_CHANGE_REQUESTS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
56: ,request_date OKL_VP_CHANGE_REQUESTS.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,effective_date OKL_VP_CHANGE_REQUESTS.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
52: ,change_request_number NUMBER := OKL_API.G_MISS_NUM
53: ,chr_id NUMBER := OKL_API.G_MISS_NUM
54: ,change_type_code OKL_VP_CHANGE_REQUESTS.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
55: ,status_code OKL_VP_CHANGE_REQUESTS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
56: ,request_date OKL_VP_CHANGE_REQUESTS.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,effective_date OKL_VP_CHANGE_REQUESTS.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
53: ,chr_id NUMBER := OKL_API.G_MISS_NUM
54: ,change_type_code OKL_VP_CHANGE_REQUESTS.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
55: ,status_code OKL_VP_CHANGE_REQUESTS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
56: ,request_date OKL_VP_CHANGE_REQUESTS.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,effective_date OKL_VP_CHANGE_REQUESTS.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
54: ,change_type_code OKL_VP_CHANGE_REQUESTS.CHANGE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
55: ,status_code OKL_VP_CHANGE_REQUESTS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
56: ,request_date OKL_VP_CHANGE_REQUESTS.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,effective_date OKL_VP_CHANGE_REQUESTS.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
55: ,status_code OKL_VP_CHANGE_REQUESTS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
56: ,request_date OKL_VP_CHANGE_REQUESTS.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,effective_date OKL_VP_CHANGE_REQUESTS.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
56: ,request_date OKL_VP_CHANGE_REQUESTS.REQUEST_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,effective_date OKL_VP_CHANGE_REQUESTS.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
57: ,effective_date OKL_VP_CHANGE_REQUESTS.EFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
58: ,approved_date OKL_VP_CHANGE_REQUESTS.APPROVED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
59: ,rejected_date OKL_VP_CHANGE_REQUESTS.REJECTED_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
60: ,ineffective_date OKL_VP_CHANGE_REQUESTS.INEFFECTIVE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
61: ,applied_date OKL_VP_CHANGE_REQUESTS.APPLIED_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute_category OKL_VP_CHANGE_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute1 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute2 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute3 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute4 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute12 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute5 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute12 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute13 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute6 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute12 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute13 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute14 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute7 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute12 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute13 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute14 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute15 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute8 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute12 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute13 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute14 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute15 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
71: ,attribute9 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute12 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute13 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute14 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute15 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
78: ,request_id NUMBER := OKL_API.G_MISS_NUM
79: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
72: ,attribute10 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute12 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute13 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute14 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute15 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
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
73: ,attribute11 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute12 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute13 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute14 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute15 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
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_VP_CHANGE_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
77: ,attribute15 OKL_VP_CHANGE_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
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_VP_CHANGE_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_VP_CHANGE_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_VP_CHANGE_REQUESTS.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_VP_CHANGE_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_VP_CHANGE_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_VP_CHANGE_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
87: G_MISS_vcr_rec vcr_rec_type;
81: ,program_update_date OKL_VP_CHANGE_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
82: ,created_by NUMBER := OKL_API.G_MISS_NUM
83: ,creation_date OKL_VP_CHANGE_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
85: ,last_update_date OKL_VP_CHANGE_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
87: G_MISS_vcr_rec vcr_rec_type;
88: TYPE vcr_tbl_type IS TABLE OF vcr_rec_type
89: INDEX BY BINARY_INTEGER;