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

Line 8: cure_report_id NUMBER := OKL_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CURE_REPORTS_V Record Spec
7: TYPE crtv_rec_type IS RECORD (
8: cure_report_id NUMBER := OKL_API.G_MISS_NUM
9: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM

Line 9: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR

5: ---------------------------------------------------------------------------
6: -- OKL_CURE_REPORTS_V Record Spec
7: TYPE crtv_rec_type IS RECORD (
8: cure_report_id NUMBER := OKL_API.G_MISS_NUM
9: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM

Line 10: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR

6: -- OKL_CURE_REPORTS_V Record Spec
7: TYPE crtv_rec_type IS RECORD (
8: cure_report_id NUMBER := OKL_API.G_MISS_NUM
9: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM

Line 11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE

7: TYPE crtv_rec_type IS RECORD (
8: cure_report_id NUMBER := OKL_API.G_MISS_NUM
9: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR

Line 12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM

8: cure_report_id NUMBER := OKL_API.G_MISS_NUM
9: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR

Line 13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM

9: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM

10: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR

11: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR

12: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
20: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE

13: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
20: ,org_id NUMBER := OKL_API.G_MISS_NUM
21: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

14: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
20: ,org_id NUMBER := OKL_API.G_MISS_NUM
21: ,request_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

15: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
20: ,org_id NUMBER := OKL_API.G_MISS_NUM
21: ,request_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
23: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 20: ,org_id NUMBER := OKL_API.G_MISS_NUM

16: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
20: ,org_id NUMBER := OKL_API.G_MISS_NUM
21: ,request_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
23: ,program_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 21: ,request_id NUMBER := OKL_API.G_MISS_NUM

17: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
20: ,org_id NUMBER := OKL_API.G_MISS_NUM
21: ,request_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
23: ,program_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 22: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

18: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
20: ,org_id NUMBER := OKL_API.G_MISS_NUM
21: ,request_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
23: ,program_id NUMBER := OKL_API.G_MISS_NUM
24: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 23: ,program_id NUMBER := OKL_API.G_MISS_NUM

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

Line 24: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 25: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

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

Line 26: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

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

Line 27: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

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

Line 28: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

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

Line 29: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

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

Line 30: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

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

Line 31: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

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

Line 32: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

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

Line 33: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

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

Line 34: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

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

Line 35: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

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

Line 36: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

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

Line 37: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

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

Line 38: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

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

Line 39: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

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

Line 40: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

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

Line 41: ,created_by NUMBER := OKL_API.G_MISS_NUM

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

Line 42: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

39: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
46: G_MISS_crtv_rec crtv_rec_type;
47: TYPE crtv_tbl_type IS TABLE OF crtv_rec_type

Line 44: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

40: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
46: G_MISS_crtv_rec crtv_rec_type;
47: TYPE crtv_tbl_type IS TABLE OF crtv_rec_type
48: INDEX BY BINARY_INTEGER;

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

41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
46: G_MISS_crtv_rec crtv_rec_type;
47: TYPE crtv_tbl_type IS TABLE OF crtv_rec_type
48: INDEX BY BINARY_INTEGER;
49: -- OKL_CURE_REPORTS Record Spec

Line 51: cure_report_id NUMBER := OKL_API.G_MISS_NUM

47: TYPE crtv_tbl_type IS TABLE OF crtv_rec_type
48: INDEX BY BINARY_INTEGER;
49: -- OKL_CURE_REPORTS Record Spec
50: TYPE crt_rec_type IS RECORD (
51: cure_report_id NUMBER := OKL_API.G_MISS_NUM
52: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
53: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM

Line 52: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR

48: INDEX BY BINARY_INTEGER;
49: -- OKL_CURE_REPORTS Record Spec
50: TYPE crt_rec_type IS RECORD (
51: cure_report_id NUMBER := OKL_API.G_MISS_NUM
52: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
53: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM

Line 53: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR

49: -- OKL_CURE_REPORTS Record Spec
50: TYPE crt_rec_type IS RECORD (
51: cure_report_id NUMBER := OKL_API.G_MISS_NUM
52: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
53: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM

Line 54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE

50: TYPE crt_rec_type IS RECORD (
51: cure_report_id NUMBER := OKL_API.G_MISS_NUM
52: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
53: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR

Line 55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM

51: cure_report_id NUMBER := OKL_API.G_MISS_NUM
52: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
53: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR

Line 56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM

52: ,report_number OKL_CURE_REPORTS.REPORT_NUMBER%TYPE := OKL_API.G_MISS_CHAR
53: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM

53: ,report_type OKL_CURE_REPORTS.REPORT_TYPE%TYPE := OKL_API.G_MISS_CHAR
54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

Line 58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR

54: ,report_date OKL_CURE_REPORTS.REPORT_DATE%TYPE := OKL_API.G_MISS_DATE
55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM

Line 59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR

55: ,vendor_id NUMBER := OKL_API.G_MISS_NUM
56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM

Line 60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE

56: ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

Line 61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

57: ,vendor_contact_id NUMBER := OKL_API.G_MISS_NUM
58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM

Line 62: ,org_id NUMBER := OKL_API.G_MISS_NUM

58: ,approval_status OKL_CURE_REPORTS.APPROVAL_STATUS%TYPE := OKL_API.G_MISS_CHAR
59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 63: ,request_id NUMBER := OKL_API.G_MISS_NUM

59: ,approval_reason OKL_CURE_REPORTS.APPROVAL_REASON%TYPE := OKL_API.G_MISS_CHAR
60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM

60: ,expiration_date OKL_CURE_REPORTS.EXPIRATION_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 65: ,program_id NUMBER := OKL_API.G_MISS_NUM

61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

66: ,currency_code OKL_CURE_REPORTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

67: ,program_update_date OKL_CURE_REPORTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

68: ,attribute_category OKL_CURE_REPORTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

69: ,attribute1 OKL_CURE_REPORTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

70: ,attribute2 OKL_CURE_REPORTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

71: ,attribute3 OKL_CURE_REPORTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

72: ,attribute4 OKL_CURE_REPORTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

73: ,attribute5 OKL_CURE_REPORTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

74: ,attribute6 OKL_CURE_REPORTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

75: ,attribute7 OKL_CURE_REPORTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

76: ,attribute8 OKL_CURE_REPORTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

77: ,attribute9 OKL_CURE_REPORTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

78: ,attribute10 OKL_CURE_REPORTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

79: ,attribute11 OKL_CURE_REPORTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
87: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 84: ,created_by NUMBER := OKL_API.G_MISS_NUM

80: ,attribute12 OKL_CURE_REPORTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
87: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

Line 85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

81: ,attribute13 OKL_CURE_REPORTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
87: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
89: G_MISS_crt_rec crt_rec_type;

Line 86: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

82: ,attribute14 OKL_CURE_REPORTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
87: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
89: G_MISS_crt_rec crt_rec_type;
90: TYPE crt_tbl_type IS TABLE OF crt_rec_type

Line 87: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

83: ,attribute15 OKL_CURE_REPORTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
87: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
89: G_MISS_crt_rec crt_rec_type;
90: TYPE crt_tbl_type IS TABLE OF crt_rec_type
91: INDEX BY BINARY_INTEGER;

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

84: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,creation_date OKL_CURE_REPORTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
87: ,last_update_date OKL_CURE_REPORTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
89: G_MISS_crt_rec crt_rec_type;
90: TYPE crt_tbl_type IS TABLE OF crt_rec_type
91: INDEX BY BINARY_INTEGER;
92: ---------------------------------------------------------------------------

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

91: INDEX BY BINARY_INTEGER;
92: ---------------------------------------------------------------------------
93: -- GLOBAL MESSAGE CONSTANTS
94: ---------------------------------------------------------------------------
95: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

92: ---------------------------------------------------------------------------
93: -- GLOBAL MESSAGE CONSTANTS
94: ---------------------------------------------------------------------------
95: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

93: -- GLOBAL MESSAGE CONSTANTS
94: ---------------------------------------------------------------------------
95: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

94: ---------------------------------------------------------------------------
95: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

95: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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

96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';

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

98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108:

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_CRT_PVT';
118: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
119: ---------------------------------------------------------------------------
120: -- Procedures and Functions
121: ---------------------------------------------------------------------------
122:

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

124: PROCEDURE change_version;
125: PROCEDURE api_copy;
126: PROCEDURE insert_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_crtv_rec IN crtv_rec_type,

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

132: p_crtv_rec IN crtv_rec_type,
133: x_crtv_rec OUT NOCOPY crtv_rec_type);
134: PROCEDURE insert_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_crtv_tbl IN crtv_tbl_type,

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

138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_crtv_tbl IN crtv_tbl_type,
141: x_crtv_tbl OUT NOCOPY crtv_tbl_type,
142: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
143: PROCEDURE insert_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

141: x_crtv_tbl OUT NOCOPY crtv_tbl_type,
142: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
143: PROCEDURE insert_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_crtv_tbl IN crtv_tbl_type,

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

149: p_crtv_tbl IN crtv_tbl_type,
150: x_crtv_tbl OUT NOCOPY crtv_tbl_type);
151: PROCEDURE lock_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_crtv_rec IN crtv_rec_type);

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_crtv_rec IN crtv_rec_type);
158: PROCEDURE lock_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_crtv_tbl IN crtv_tbl_type,

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

161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_crtv_tbl IN crtv_tbl_type,
165: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

164: p_crtv_tbl IN crtv_tbl_type,
165: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_crtv_tbl IN crtv_tbl_type);

Line 175: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_crtv_tbl IN crtv_tbl_type);
173: PROCEDURE update_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_crtv_rec IN crtv_rec_type,

Line 183: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

179: p_crtv_rec IN crtv_rec_type,
180: x_crtv_rec OUT NOCOPY crtv_rec_type);
181: PROCEDURE update_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_crtv_tbl IN crtv_tbl_type,

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

185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_crtv_tbl IN crtv_tbl_type,
188: x_crtv_tbl OUT NOCOPY crtv_tbl_type,
189: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
190: PROCEDURE update_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,

Line 192: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

188: x_crtv_tbl OUT NOCOPY crtv_tbl_type,
189: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
190: PROCEDURE update_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_crtv_tbl IN crtv_tbl_type,

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

196: p_crtv_tbl IN crtv_tbl_type,
197: x_crtv_tbl OUT NOCOPY crtv_tbl_type);
198: PROCEDURE delete_row(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_crtv_rec IN crtv_rec_type);

Line 207: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_crtv_rec IN crtv_rec_type);
205: PROCEDURE delete_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_crtv_tbl IN crtv_tbl_type,

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

208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_crtv_tbl IN crtv_tbl_type,
212: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
213: PROCEDURE delete_row(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

211: p_crtv_tbl IN crtv_tbl_type,
212: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
213: PROCEDURE delete_row(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_crtv_tbl IN crtv_tbl_type);

Line 222: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_crtv_tbl IN crtv_tbl_type);
220: PROCEDURE validate_row(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_crtv_rec IN crtv_rec_type);

Line 229: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_crtv_rec IN crtv_rec_type);
227: PROCEDURE validate_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_crtv_tbl IN crtv_tbl_type,

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

230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_crtv_tbl IN crtv_tbl_type,
234: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
235: PROCEDURE validate_row(
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
238: x_return_status OUT NOCOPY VARCHAR2,

Line 237: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

233: p_crtv_tbl IN crtv_tbl_type,
234: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
235: PROCEDURE validate_row(
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
241: p_crtv_tbl IN crtv_tbl_type);