eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CRA_PVT dependencies on OKL_API

Line 8: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CURE_REPORT_AMOUNTS Record Spec
7: TYPE crav_rec_type IS RECORD (
8: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
9: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
10: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM

Line 9: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKL_CURE_REPORT_AMOUNTS Record Spec
7: TYPE crav_rec_type IS RECORD (
8: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
9: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
10: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM

Line 10: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM

6: -- OKL_CURE_REPORT_AMOUNTS Record Spec
7: TYPE crav_rec_type IS RECORD (
8: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
9: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
10: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM

Line 11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR

7: TYPE crav_rec_type IS RECORD (
8: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
9: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
10: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM

Line 12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM

8: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
9: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
10: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM

Line 13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM

9: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
10: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM

Line 14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM

10: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18: ,times_cured NUMBER := OKL_API.G_MISS_NUM

Line 15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM

11: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18: ,times_cured NUMBER := OKL_API.G_MISS_NUM
19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM

Line 16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM

12: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18: ,times_cured NUMBER := OKL_API.G_MISS_NUM
19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR

Line 17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM

13: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18: ,times_cured NUMBER := OKL_API.G_MISS_NUM
19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 18: ,times_cured NUMBER := OKL_API.G_MISS_NUM

14: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18: ,times_cured NUMBER := OKL_API.G_MISS_NUM
19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM

15: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18: ,times_cured NUMBER := OKL_API.G_MISS_NUM
19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22: ,org_id NUMBER := OKL_API.G_MISS_NUM
23: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR

16: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18: ,times_cured NUMBER := OKL_API.G_MISS_NUM
19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22: ,org_id NUMBER := OKL_API.G_MISS_NUM
23: ,request_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

17: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18: ,times_cured NUMBER := OKL_API.G_MISS_NUM
19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22: ,org_id NUMBER := OKL_API.G_MISS_NUM
23: ,request_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 22: ,org_id NUMBER := OKL_API.G_MISS_NUM

18: ,times_cured NUMBER := OKL_API.G_MISS_NUM
19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22: ,org_id NUMBER := OKL_API.G_MISS_NUM
23: ,request_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25: ,program_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 23: ,request_id NUMBER := OKL_API.G_MISS_NUM

19: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22: ,org_id NUMBER := OKL_API.G_MISS_NUM
23: ,request_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25: ,program_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

20: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22: ,org_id NUMBER := OKL_API.G_MISS_NUM
23: ,request_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25: ,program_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 25: ,program_id NUMBER := OKL_API.G_MISS_NUM

21: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22: ,org_id NUMBER := OKL_API.G_MISS_NUM
23: ,request_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25: ,program_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

22: ,org_id NUMBER := OKL_API.G_MISS_NUM
23: ,request_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25: ,program_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

23: ,request_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25: ,program_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

24: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25: ,program_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

25: ,program_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

26: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

27: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

28: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

29: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

30: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

31: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

32: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

33: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

34: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

35: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

36: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43: ,created_by NUMBER := OKL_API.G_MISS_NUM
44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

37: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43: ,created_by NUMBER := OKL_API.G_MISS_NUM
44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

38: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43: ,created_by NUMBER := OKL_API.G_MISS_NUM
44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
46: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 43: ,created_by NUMBER := OKL_API.G_MISS_NUM

39: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43: ,created_by NUMBER := OKL_API.G_MISS_NUM
44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
46: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

Line 44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

40: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43: ,created_by NUMBER := OKL_API.G_MISS_NUM
44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
46: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
48: G_MISS_crav_rec crav_rec_type;

Line 45: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

41: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43: ,created_by NUMBER := OKL_API.G_MISS_NUM
44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
46: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
48: G_MISS_crav_rec crav_rec_type;
49: TYPE crav_tbl_type IS TABLE OF crav_rec_type

Line 46: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

42: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43: ,created_by NUMBER := OKL_API.G_MISS_NUM
44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
46: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
48: G_MISS_crav_rec crav_rec_type;
49: TYPE crav_tbl_type IS TABLE OF crav_rec_type
50: INDEX BY BINARY_INTEGER;

Line 47: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

43: ,created_by NUMBER := OKL_API.G_MISS_NUM
44: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
46: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
48: G_MISS_crav_rec crav_rec_type;
49: TYPE crav_tbl_type IS TABLE OF crav_rec_type
50: INDEX BY BINARY_INTEGER;
51: -- OKL_CURE_REPORT_AMOUNTS Record Spec

Line 53: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM

49: TYPE crav_tbl_type IS TABLE OF crav_rec_type
50: INDEX BY BINARY_INTEGER;
51: -- OKL_CURE_REPORT_AMOUNTS Record Spec
52: TYPE cra_rec_type IS RECORD (
53: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
54: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
55: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM

Line 54: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM

50: INDEX BY BINARY_INTEGER;
51: -- OKL_CURE_REPORT_AMOUNTS Record Spec
52: TYPE cra_rec_type IS RECORD (
53: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
54: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
55: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM

Line 55: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM

51: -- OKL_CURE_REPORT_AMOUNTS Record Spec
52: TYPE cra_rec_type IS RECORD (
53: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
54: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
55: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM

Line 56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR

52: TYPE cra_rec_type IS RECORD (
53: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
54: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
55: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM

Line 57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM

53: cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
54: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
55: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM

Line 58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM

54: ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
55: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM

Line 59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM

55: ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63: ,times_cured NUMBER := OKL_API.G_MISS_NUM

Line 60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM

56: ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63: ,times_cured NUMBER := OKL_API.G_MISS_NUM
64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM

Line 61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM

57: ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63: ,times_cured NUMBER := OKL_API.G_MISS_NUM
64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR

Line 62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM

58: ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63: ,times_cured NUMBER := OKL_API.G_MISS_NUM
64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 63: ,times_cured NUMBER := OKL_API.G_MISS_NUM

59: ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63: ,times_cured NUMBER := OKL_API.G_MISS_NUM
64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM

60: ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63: ,times_cured NUMBER := OKL_API.G_MISS_NUM
64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67: ,org_id NUMBER := OKL_API.G_MISS_NUM
68: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR

61: ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63: ,times_cured NUMBER := OKL_API.G_MISS_NUM
64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67: ,org_id NUMBER := OKL_API.G_MISS_NUM
68: ,request_id NUMBER := OKL_API.G_MISS_NUM
69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

62: ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63: ,times_cured NUMBER := OKL_API.G_MISS_NUM
64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67: ,org_id NUMBER := OKL_API.G_MISS_NUM
68: ,request_id NUMBER := OKL_API.G_MISS_NUM
69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 67: ,org_id NUMBER := OKL_API.G_MISS_NUM

63: ,times_cured NUMBER := OKL_API.G_MISS_NUM
64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67: ,org_id NUMBER := OKL_API.G_MISS_NUM
68: ,request_id NUMBER := OKL_API.G_MISS_NUM
69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70: ,program_id NUMBER := OKL_API.G_MISS_NUM
71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 68: ,request_id NUMBER := OKL_API.G_MISS_NUM

64: ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67: ,org_id NUMBER := OKL_API.G_MISS_NUM
68: ,request_id NUMBER := OKL_API.G_MISS_NUM
69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70: ,program_id NUMBER := OKL_API.G_MISS_NUM
71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

65: ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67: ,org_id NUMBER := OKL_API.G_MISS_NUM
68: ,request_id NUMBER := OKL_API.G_MISS_NUM
69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70: ,program_id NUMBER := OKL_API.G_MISS_NUM
71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 70: ,program_id NUMBER := OKL_API.G_MISS_NUM

66: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67: ,org_id NUMBER := OKL_API.G_MISS_NUM
68: ,request_id NUMBER := OKL_API.G_MISS_NUM
69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70: ,program_id NUMBER := OKL_API.G_MISS_NUM
71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

67: ,org_id NUMBER := OKL_API.G_MISS_NUM
68: ,request_id NUMBER := OKL_API.G_MISS_NUM
69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70: ,program_id NUMBER := OKL_API.G_MISS_NUM
71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

68: ,request_id NUMBER := OKL_API.G_MISS_NUM
69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70: ,program_id NUMBER := OKL_API.G_MISS_NUM
71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

69: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70: ,program_id NUMBER := OKL_API.G_MISS_NUM
71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

70: ,program_id NUMBER := OKL_API.G_MISS_NUM
71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

71: ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

72: ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

73: ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

74: ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

75: ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

76: ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

77: ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

78: ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

79: ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

80: ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

81: ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

82: ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

83: ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 88: ,created_by NUMBER := OKL_API.G_MISS_NUM

84: ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

Line 89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

85: ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
93: G_MISS_cra_rec cra_rec_type;

Line 90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

86: ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
93: G_MISS_cra_rec cra_rec_type;
94: TYPE cra_tbl_type IS TABLE OF cra_rec_type

Line 91: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

87: ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
93: G_MISS_cra_rec cra_rec_type;
94: TYPE cra_tbl_type IS TABLE OF cra_rec_type
95: INDEX BY BINARY_INTEGER;

Line 92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

88: ,created_by NUMBER := OKL_API.G_MISS_NUM
89: ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91: ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
93: G_MISS_cra_rec cra_rec_type;
94: TYPE cra_tbl_type IS TABLE OF cra_rec_type
95: INDEX BY BINARY_INTEGER;
96: ---------------------------------------------------------------------------

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

95: INDEX BY BINARY_INTEGER;
96: ---------------------------------------------------------------------------
97: -- GLOBAL MESSAGE CONSTANTS
98: ---------------------------------------------------------------------------
99: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
100: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
101: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
102: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

96: ---------------------------------------------------------------------------
97: -- GLOBAL MESSAGE CONSTANTS
98: ---------------------------------------------------------------------------
99: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
100: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
101: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
102: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

97: -- GLOBAL MESSAGE CONSTANTS
98: ---------------------------------------------------------------------------
99: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
100: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
101: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
102: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

98: ---------------------------------------------------------------------------
99: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
100: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
101: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
102: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
106: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

99: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
100: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
101: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
102: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
106: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
107: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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

100: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
101: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
102: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
106: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
107: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
108: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

101: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
102: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
106: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
107: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
108: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
109: ---------------------------------------------------------------------------

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

102: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
106: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
107: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
108: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
109: ---------------------------------------------------------------------------
110: -- GLOBAL EXCEPTIONS

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

103: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
106: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
107: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
108: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
109: ---------------------------------------------------------------------------
110: -- GLOBAL EXCEPTIONS
111: ---------------------------------------------------------------------------

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

104: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
106: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
107: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
108: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
109: ---------------------------------------------------------------------------
110: -- GLOBAL EXCEPTIONS
111: ---------------------------------------------------------------------------
112: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

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

114: ---------------------------------------------------------------------------
115: -- GLOBAL VARIABLES
116: ---------------------------------------------------------------------------
117: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CRA_PVT';
118: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
119: -------------------------------------------------------------------------------
120: --Post change to TAPI code
121: -------------------------------------------------------------------------------
122: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';

Line 139: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

143: p_crav_rec IN crav_rec_type,
144: x_crav_rec OUT NOCOPY crav_rec_type);
145: PROCEDURE insert_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_crav_tbl IN crav_tbl_type,

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

149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_crav_tbl IN crav_tbl_type,
152: x_crav_tbl OUT NOCOPY crav_tbl_type,
153: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
154: PROCEDURE insert_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,

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

152: x_crav_tbl OUT NOCOPY crav_tbl_type,
153: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
154: PROCEDURE insert_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_crav_tbl IN crav_tbl_type,

Line 164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

160: p_crav_tbl IN crav_tbl_type,
161: x_crav_tbl OUT NOCOPY crav_tbl_type);
162: PROCEDURE lock_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_crav_rec IN crav_rec_type);

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_crav_rec IN crav_rec_type);
169: PROCEDURE lock_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_crav_tbl IN crav_tbl_type,

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

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

Line 179: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_crav_tbl IN crav_tbl_type);
184: PROCEDURE update_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_crav_rec IN crav_rec_type,

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

190: p_crav_rec IN crav_rec_type,
191: x_crav_rec OUT NOCOPY crav_rec_type);
192: PROCEDURE update_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_crav_tbl IN crav_tbl_type,

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

196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_crav_tbl IN crav_tbl_type,
199: x_crav_tbl OUT NOCOPY crav_tbl_type,
200: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
201: PROCEDURE update_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,

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

199: x_crav_tbl OUT NOCOPY crav_tbl_type,
200: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
201: PROCEDURE update_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_crav_tbl IN crav_tbl_type,

Line 211: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

207: p_crav_tbl IN crav_tbl_type,
208: x_crav_tbl OUT NOCOPY crav_tbl_type);
209: PROCEDURE delete_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_crav_rec IN crav_rec_type);

Line 218: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_crav_rec IN crav_rec_type);
216: PROCEDURE delete_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_crav_tbl IN crav_tbl_type,

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

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

Line 226: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

Line 233: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_crav_tbl IN crav_tbl_type);
231: PROCEDURE validate_row(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_crav_rec IN crav_rec_type);

Line 240: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_crav_rec IN crav_rec_type);
238: PROCEDURE validate_row(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_crav_tbl IN crav_tbl_type,

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

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

Line 248: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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