4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CURE_REFUND_STAGE_V Record Spec
7: TYPE crsv_rec_type IS RECORD (
8: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
9: ,status OKL_CURE_REFUND_STAGE_V.STATUS%TYPE := OKL_API.G_MISS_CHAR
10: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
11: ,received_amount NUMBER := OKL_API.G_MISS_NUM
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKL_CURE_REFUND_STAGE_V Record Spec
7: TYPE crsv_rec_type IS RECORD (
8: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
9: ,status OKL_CURE_REFUND_STAGE_V.STATUS%TYPE := OKL_API.G_MISS_CHAR
10: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
11: ,received_amount NUMBER := OKL_API.G_MISS_NUM
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
6: -- OKL_CURE_REFUND_STAGE_V Record Spec
7: TYPE crsv_rec_type IS RECORD (
8: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
9: ,status OKL_CURE_REFUND_STAGE_V.STATUS%TYPE := OKL_API.G_MISS_CHAR
10: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
11: ,received_amount NUMBER := OKL_API.G_MISS_NUM
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
7: TYPE crsv_rec_type IS RECORD (
8: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
9: ,status OKL_CURE_REFUND_STAGE_V.STATUS%TYPE := OKL_API.G_MISS_CHAR
10: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
11: ,received_amount NUMBER := OKL_API.G_MISS_NUM
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
8: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
9: ,status OKL_CURE_REFUND_STAGE_V.STATUS%TYPE := OKL_API.G_MISS_CHAR
10: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
11: ,received_amount NUMBER := OKL_API.G_MISS_NUM
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
9: ,status OKL_CURE_REFUND_STAGE_V.STATUS%TYPE := OKL_API.G_MISS_CHAR
10: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
11: ,received_amount NUMBER := OKL_API.G_MISS_NUM
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
10: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
11: ,received_amount NUMBER := OKL_API.G_MISS_NUM
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,received_amount NUMBER := OKL_API.G_MISS_NUM
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
12: ,chr_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
13: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
15: ,request_id NUMBER := OKL_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
16: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
17: ,program_id NUMBER := OKL_API.G_MISS_NUM
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
18: ,program_update_date OKL_CURE_REFUND_STAGE_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
19: ,attribute_category OKL_CURE_REFUND_STAGE_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
20: ,attribute1 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
21: ,attribute2 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
22: ,attribute3 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute4 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute5 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute6 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute7 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute8 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
28: ,attribute9 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_CURE_REFUND_STAGE_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
29: ,attribute10 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_CURE_REFUND_STAGE_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
30: ,attribute11 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_CURE_REFUND_STAGE_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_CURE_REFUND_STAGE_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
31: ,attribute12 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_CURE_REFUND_STAGE_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_CURE_REFUND_STAGE_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
32: ,attribute13 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_CURE_REFUND_STAGE_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_CURE_REFUND_STAGE_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
40: G_MISS_crsv_rec crsv_rec_type;
33: ,attribute14 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_CURE_REFUND_STAGE_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_CURE_REFUND_STAGE_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
40: G_MISS_crsv_rec crsv_rec_type;
41: TYPE crsv_tbl_type IS TABLE OF crsv_rec_type
34: ,attribute15 OKL_CURE_REFUND_STAGE_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_CURE_REFUND_STAGE_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_CURE_REFUND_STAGE_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
40: G_MISS_crsv_rec crsv_rec_type;
41: TYPE crsv_tbl_type IS TABLE OF crsv_rec_type
42: INDEX BY BINARY_INTEGER;
35: ,created_by NUMBER := OKL_API.G_MISS_NUM
36: ,creation_date OKL_CURE_REFUND_STAGE_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
38: ,last_update_date OKL_CURE_REFUND_STAGE_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
40: G_MISS_crsv_rec crsv_rec_type;
41: TYPE crsv_tbl_type IS TABLE OF crsv_rec_type
42: INDEX BY BINARY_INTEGER;
43: -- OKL_CURE_REFUND_STAGE Record Spec
41: TYPE crsv_tbl_type IS TABLE OF crsv_rec_type
42: INDEX BY BINARY_INTEGER;
43: -- OKL_CURE_REFUND_STAGE Record Spec
44: TYPE crs_rec_type IS RECORD (
45: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
46: ,status OKL_CURE_REFUND_STAGE.STATUS%TYPE := OKL_API.G_MISS_CHAR
47: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
48: ,received_amount NUMBER := OKL_API.G_MISS_NUM
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
42: INDEX BY BINARY_INTEGER;
43: -- OKL_CURE_REFUND_STAGE Record Spec
44: TYPE crs_rec_type IS RECORD (
45: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
46: ,status OKL_CURE_REFUND_STAGE.STATUS%TYPE := OKL_API.G_MISS_CHAR
47: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
48: ,received_amount NUMBER := OKL_API.G_MISS_NUM
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
43: -- OKL_CURE_REFUND_STAGE Record Spec
44: TYPE crs_rec_type IS RECORD (
45: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
46: ,status OKL_CURE_REFUND_STAGE.STATUS%TYPE := OKL_API.G_MISS_CHAR
47: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
48: ,received_amount NUMBER := OKL_API.G_MISS_NUM
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
44: TYPE crs_rec_type IS RECORD (
45: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
46: ,status OKL_CURE_REFUND_STAGE.STATUS%TYPE := OKL_API.G_MISS_CHAR
47: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
48: ,received_amount NUMBER := OKL_API.G_MISS_NUM
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
45: cure_refund_stage_id NUMBER := OKL_API.G_MISS_NUM
46: ,status OKL_CURE_REFUND_STAGE.STATUS%TYPE := OKL_API.G_MISS_CHAR
47: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
48: ,received_amount NUMBER := OKL_API.G_MISS_NUM
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
46: ,status OKL_CURE_REFUND_STAGE.STATUS%TYPE := OKL_API.G_MISS_CHAR
47: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
48: ,received_amount NUMBER := OKL_API.G_MISS_NUM
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
47: ,negotiated_amount NUMBER := OKL_API.G_MISS_NUM
48: ,received_amount NUMBER := OKL_API.G_MISS_NUM
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48: ,received_amount NUMBER := OKL_API.G_MISS_NUM
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
49: ,chr_id NUMBER := OKL_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
50: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
51: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
52: ,request_id NUMBER := OKL_API.G_MISS_NUM
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
53: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
54: ,program_id NUMBER := OKL_API.G_MISS_NUM
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
55: ,program_update_date OKL_CURE_REFUND_STAGE.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
56: ,attribute_category OKL_CURE_REFUND_STAGE.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
57: ,attribute1 OKL_CURE_REFUND_STAGE.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
58: ,attribute2 OKL_CURE_REFUND_STAGE.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
59: ,attribute3 OKL_CURE_REFUND_STAGE.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
60: ,attribute4 OKL_CURE_REFUND_STAGE.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
61: ,attribute5 OKL_CURE_REFUND_STAGE.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
62: ,attribute6 OKL_CURE_REFUND_STAGE.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
63: ,attribute7 OKL_CURE_REFUND_STAGE.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
64: ,attribute8 OKL_CURE_REFUND_STAGE.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
65: ,attribute9 OKL_CURE_REFUND_STAGE.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CURE_REFUND_STAGE.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
66: ,attribute10 OKL_CURE_REFUND_STAGE.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CURE_REFUND_STAGE.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
67: ,attribute11 OKL_CURE_REFUND_STAGE.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CURE_REFUND_STAGE.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CURE_REFUND_STAGE.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute12 OKL_CURE_REFUND_STAGE.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CURE_REFUND_STAGE.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CURE_REFUND_STAGE.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
69: ,attribute13 OKL_CURE_REFUND_STAGE.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CURE_REFUND_STAGE.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CURE_REFUND_STAGE.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
77: G_MISS_crs_rec crs_rec_type;
70: ,attribute14 OKL_CURE_REFUND_STAGE.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CURE_REFUND_STAGE.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CURE_REFUND_STAGE.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
77: G_MISS_crs_rec crs_rec_type;
78: TYPE crs_tbl_type IS TABLE OF crs_rec_type
71: ,attribute15 OKL_CURE_REFUND_STAGE.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CURE_REFUND_STAGE.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CURE_REFUND_STAGE.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
77: G_MISS_crs_rec crs_rec_type;
78: TYPE crs_tbl_type IS TABLE OF crs_rec_type
79: INDEX BY BINARY_INTEGER;
72: ,created_by NUMBER := OKL_API.G_MISS_NUM
73: ,creation_date OKL_CURE_REFUND_STAGE.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
75: ,last_update_date OKL_CURE_REFUND_STAGE.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
77: G_MISS_crs_rec crs_rec_type;
78: TYPE crs_tbl_type IS TABLE OF crs_rec_type
79: INDEX BY BINARY_INTEGER;
80: ---------------------------------------------------------------------------
79: INDEX BY BINARY_INTEGER;
80: ---------------------------------------------------------------------------
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
80: ---------------------------------------------------------------------------
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
81: -- GLOBAL MESSAGE CONSTANTS
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
82: ---------------------------------------------------------------------------
83: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
83: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
84: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
85: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
93: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
86: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
93: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
94: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
87: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
93: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
94: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
95: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
88: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
90: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
91: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
92: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
93: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
94: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
95: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
96:
102: ---------------------------------------------------------------------------
103: -- GLOBAL VARIABLES
104: ---------------------------------------------------------------------------
105: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CRS_PVT';
106: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
107: ---------------------------------------------------------------------------
108: -- Procedures and Functions
109: ---------------------------------------------------------------------------
110:
112: PROCEDURE change_version;
113: PROCEDURE api_copy;
114: PROCEDURE insert_row(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_crsv_rec IN crsv_rec_type,
120: p_crsv_rec IN crsv_rec_type,
121: x_crsv_rec OUT NOCOPY crsv_rec_type);
122: PROCEDURE insert_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_crsv_tbl IN crsv_tbl_type,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_crsv_tbl IN crsv_tbl_type,
129: x_crsv_tbl OUT NOCOPY crsv_tbl_type,
130: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
131: PROCEDURE insert_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
129: x_crsv_tbl OUT NOCOPY crsv_tbl_type,
130: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
131: PROCEDURE insert_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_crsv_tbl IN crsv_tbl_type,
137: p_crsv_tbl IN crsv_tbl_type,
138: x_crsv_tbl OUT NOCOPY crsv_tbl_type);
139: PROCEDURE lock_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_crsv_rec IN crsv_rec_type);
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_crsv_rec IN crsv_rec_type);
146: PROCEDURE lock_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_crsv_tbl IN crsv_tbl_type,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_crsv_tbl IN crsv_tbl_type,
153: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
154: PROCEDURE lock_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
152: p_crsv_tbl IN crsv_tbl_type,
153: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
154: PROCEDURE lock_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_crsv_tbl IN crsv_tbl_type);
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_crsv_tbl IN crsv_tbl_type);
161: PROCEDURE update_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_crsv_rec IN crsv_rec_type,
167: p_crsv_rec IN crsv_rec_type,
168: x_crsv_rec OUT NOCOPY crsv_rec_type);
169: PROCEDURE update_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_crsv_tbl IN crsv_tbl_type,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_crsv_tbl IN crsv_tbl_type,
176: x_crsv_tbl OUT NOCOPY crsv_tbl_type,
177: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
178: PROCEDURE update_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,
176: x_crsv_tbl OUT NOCOPY crsv_tbl_type,
177: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
178: PROCEDURE update_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_crsv_tbl IN crsv_tbl_type,
184: p_crsv_tbl IN crsv_tbl_type,
185: x_crsv_tbl OUT NOCOPY crsv_tbl_type);
186: PROCEDURE delete_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_crsv_rec IN crsv_rec_type);
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_crsv_rec IN crsv_rec_type);
193: PROCEDURE delete_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_crsv_tbl IN crsv_tbl_type,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_crsv_tbl IN crsv_tbl_type,
200: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
201: PROCEDURE delete_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
199: p_crsv_tbl IN crsv_tbl_type,
200: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
201: PROCEDURE delete_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_crsv_tbl IN crsv_tbl_type);
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_crsv_tbl IN crsv_tbl_type);
208: PROCEDURE validate_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_crsv_rec IN crsv_rec_type);
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_crsv_rec IN crsv_rec_type);
215: PROCEDURE validate_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_crsv_tbl IN crsv_tbl_type,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_crsv_tbl IN crsv_tbl_type,
222: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
223: PROCEDURE validate_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
221: p_crsv_tbl IN crsv_tbl_type,
222: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
223: PROCEDURE validate_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_crsv_tbl IN crsv_tbl_type);