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_IDH_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_INVESTOR_PAYOUT_SUMMARY_V Record Spec
7: TYPE idhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
10: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,lsm_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKL_INVESTOR_PAYOUT_SUMMARY_V Record Spec
7: TYPE idhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
10: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKL_INVESTOR_PAYOUT_SUMMARY_V Record Spec
7: TYPE idhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
10: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM

7: TYPE idhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
10: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
10: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,request_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR

9: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
10: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,request_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

10: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,request_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_id NUMBER := OKC_API.G_MISS_NUM
18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 15: ,request_id NUMBER := OKC_API.G_MISS_NUM

11: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,request_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_id NUMBER := OKC_API.G_MISS_NUM
18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,org_id NUMBER := OKC_API.G_MISS_NUM

Line 16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

12: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,request_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_id NUMBER := OKC_API.G_MISS_NUM
18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,org_id NUMBER := OKC_API.G_MISS_NUM
20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 17: ,program_id NUMBER := OKC_API.G_MISS_NUM

13: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,request_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_id NUMBER := OKC_API.G_MISS_NUM
18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,org_id NUMBER := OKC_API.G_MISS_NUM
20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

14: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,request_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_id NUMBER := OKC_API.G_MISS_NUM
18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,org_id NUMBER := OKC_API.G_MISS_NUM
20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,org_id NUMBER := OKC_API.G_MISS_NUM

15: ,request_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_id NUMBER := OKC_API.G_MISS_NUM
18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,org_id NUMBER := OKC_API.G_MISS_NUM
20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

16: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_id NUMBER := OKC_API.G_MISS_NUM
18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,org_id NUMBER := OKC_API.G_MISS_NUM
20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

17: ,program_id NUMBER := OKC_API.G_MISS_NUM
18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,org_id NUMBER := OKC_API.G_MISS_NUM
20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

18: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,org_id NUMBER := OKC_API.G_MISS_NUM
20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

19: ,org_id NUMBER := OKC_API.G_MISS_NUM
20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

20: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

Line 25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

21: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

Line 26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

22: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

Line 27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

23: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

Line 28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

24: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

Line 29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

25: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

Line 30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

26: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

Line 31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

27: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

Line 32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

28: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

29: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

30: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

31: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 36: ,created_by NUMBER := OKC_API.G_MISS_NUM

32: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

33: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM

Line 38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

34: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
42: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM

Line 39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

35: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
36: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
42: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
43: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM

Line 40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

36: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
42: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
43: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM
44: );

Line 41: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM

37: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
42: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
43: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM
44: );
45: G_MISS_idhv_rec idhv_rec_type;

Line 42: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM

38: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
42: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
43: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM
44: );
45: G_MISS_idhv_rec idhv_rec_type;
46: TYPE idhv_tbl_type IS TABLE OF idhv_rec_type

Line 43: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM

39: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
42: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
43: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM
44: );
45: G_MISS_idhv_rec idhv_rec_type;
46: TYPE idhv_tbl_type IS TABLE OF idhv_rec_type
47: INDEX BY BINARY_INTEGER;

Line 50: id NUMBER := OKC_API.G_MISS_NUM

46: TYPE idhv_tbl_type IS TABLE OF idhv_rec_type
47: INDEX BY BINARY_INTEGER;
48: -- OKL_INVESTOR_PAYOUT_SUMMARY_B Record Spec
49: TYPE idh_rec_type IS RECORD (
50: id NUMBER := OKC_API.G_MISS_NUM
51: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
52: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 51: ,lsm_id NUMBER := OKC_API.G_MISS_NUM

47: INDEX BY BINARY_INTEGER;
48: -- OKL_INVESTOR_PAYOUT_SUMMARY_B Record Spec
49: TYPE idh_rec_type IS RECORD (
50: id NUMBER := OKC_API.G_MISS_NUM
51: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
52: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR

Line 52: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM

48: -- OKL_INVESTOR_PAYOUT_SUMMARY_B Record Spec
49: TYPE idh_rec_type IS RECORD (
50: id NUMBER := OKC_API.G_MISS_NUM
51: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
52: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM

49: TYPE idh_rec_type IS RECORD (
50: id NUMBER := OKC_API.G_MISS_NUM
51: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
52: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
57: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR

50: id NUMBER := OKC_API.G_MISS_NUM
51: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
52: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
57: ,request_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR

51: ,lsm_id NUMBER := OKC_API.G_MISS_NUM
52: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
57: ,request_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
59: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

52: ,cash_receipt_id NUMBER := OKC_API.G_MISS_NUM
53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
57: ,request_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
59: ,program_id NUMBER := OKC_API.G_MISS_NUM
60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 57: ,request_id NUMBER := OKC_API.G_MISS_NUM

53: ,ap_invoice_number NUMBER := OKC_API.G_MISS_NUM
54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
57: ,request_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
59: ,program_id NUMBER := OKC_API.G_MISS_NUM
60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,org_id NUMBER := OKC_API.G_MISS_NUM

Line 58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

54: ,status OKL_INVESTOR_PAYOUT_SUMMARY_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
57: ,request_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
59: ,program_id NUMBER := OKC_API.G_MISS_NUM
60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,org_id NUMBER := OKC_API.G_MISS_NUM
62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

Line 59: ,program_id NUMBER := OKC_API.G_MISS_NUM

55: ,error_message OKL_INVESTOR_PAYOUT_SUMMARY_B.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR
56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
57: ,request_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
59: ,program_id NUMBER := OKC_API.G_MISS_NUM
60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,org_id NUMBER := OKC_API.G_MISS_NUM
62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

Line 60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

56: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
57: ,request_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
59: ,program_id NUMBER := OKC_API.G_MISS_NUM
60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,org_id NUMBER := OKC_API.G_MISS_NUM
62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

Line 61: ,org_id NUMBER := OKC_API.G_MISS_NUM

57: ,request_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
59: ,program_id NUMBER := OKC_API.G_MISS_NUM
60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,org_id NUMBER := OKC_API.G_MISS_NUM
62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

Line 62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR

58: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
59: ,program_id NUMBER := OKC_API.G_MISS_NUM
60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,org_id NUMBER := OKC_API.G_MISS_NUM
62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

Line 63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR

59: ,program_id NUMBER := OKC_API.G_MISS_NUM
60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,org_id NUMBER := OKC_API.G_MISS_NUM
62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

Line 64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR

60: ,program_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,org_id NUMBER := OKC_API.G_MISS_NUM
62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

Line 65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR

61: ,org_id NUMBER := OKC_API.G_MISS_NUM
62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

Line 66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR

62: ,attribute_category OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

Line 67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR

63: ,attribute1 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

Line 68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR

64: ,attribute2 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

Line 69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR

65: ,attribute3 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

Line 70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR

66: ,attribute4 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

Line 71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR

67: ,attribute5 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

Line 72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR

68: ,attribute6 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

Line 73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR

69: ,attribute7 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

Line 74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR

70: ,attribute8 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
78: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR

71: ,attribute9 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR

72: ,attribute10 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR

73: ,attribute11 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 78: ,created_by NUMBER := OKC_API.G_MISS_NUM

74: ,attribute12 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

75: ,attribute13 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
83: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM

Line 80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

76: ,attribute14 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
83: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
84: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM

Line 81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

77: ,attribute15 OKL_INVESTOR_PAYOUT_SUMMARY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
83: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
84: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
85: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM

Line 82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

78: ,created_by NUMBER := OKC_API.G_MISS_NUM
79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
83: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
84: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
85: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM
86: );

Line 83: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM

79: ,creation_date OKL_INVESTOR_PAYOUT_SUMMARY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
83: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
84: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
85: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM
86: );
87: G_MISS_idh_rec idh_rec_type;

Line 84: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM

80: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
83: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
84: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
85: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM
86: );
87: G_MISS_idh_rec idh_rec_type;
88: TYPE idh_tbl_type IS TABLE OF idh_rec_type

Line 85: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM

81: ,last_update_date OKL_INVESTOR_PAYOUT_SUMMARY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
83: ,investor_agreement_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_AGREEMENT_ID%TYPE := OKC_API.G_MISS_NUM
84: ,investor_line_id OKL_INVESTOR_PAYOUT_SUMMARY_B.INVESTOR_LINE_ID%TYPE := OKC_API.G_MISS_NUM
85: ,receivable_application_id OKL_INVESTOR_PAYOUT_SUMMARY_B.RECEIVABLE_APPLICATION_ID%TYPE := OKC_API.G_MISS_NUM
86: );
87: G_MISS_idh_rec idh_rec_type;
88: TYPE idh_tbl_type IS TABLE OF idh_rec_type
89: INDEX BY BINARY_INTEGER;

Line 93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

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

Line 94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

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

Line 95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

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

Line 96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

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

Line 97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

Line 98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

Line 99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
104: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
104: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
105: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
104: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
105: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
106: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';

Line 117: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

113: ---------------------------------------------------------------------------
114: -- GLOBAL VARIABLES
115: ---------------------------------------------------------------------------
116: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IDH_PVT';
117: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
118: ---------------------------------------------------------------------------
119: -- Procedures and Functions
120: ---------------------------------------------------------------------------
121:

Line 127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

123: PROCEDURE change_version;
124: PROCEDURE api_copy;
125: PROCEDURE insert_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_idhv_rec IN idhv_rec_type,

Line 135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

131: p_idhv_rec IN idhv_rec_type,
132: x_idhv_rec OUT NOCOPY idhv_rec_type);
133: PROCEDURE insert_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_idhv_tbl IN idhv_tbl_type,

Line 141: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_idhv_tbl IN idhv_tbl_type,
140: x_idhv_tbl OUT NOCOPY idhv_tbl_type,
141: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
142: PROCEDURE insert_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

140: x_idhv_tbl OUT NOCOPY idhv_tbl_type,
141: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
142: PROCEDURE insert_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_idhv_tbl IN idhv_tbl_type,

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

148: p_idhv_tbl IN idhv_tbl_type,
149: x_idhv_tbl OUT NOCOPY idhv_tbl_type);
150: PROCEDURE lock_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_idhv_rec IN idhv_rec_type);

Line 159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_idhv_rec IN idhv_rec_type);
157: PROCEDURE lock_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_idhv_tbl IN idhv_tbl_type,

Line 164: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_idhv_tbl IN idhv_tbl_type,
164: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
165: PROCEDURE lock_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

163: p_idhv_tbl IN idhv_tbl_type,
164: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
165: PROCEDURE lock_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_idhv_tbl IN idhv_tbl_type);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_idhv_tbl IN idhv_tbl_type);
172: PROCEDURE update_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_idhv_rec IN idhv_rec_type,

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

178: p_idhv_rec IN idhv_rec_type,
179: x_idhv_rec OUT NOCOPY idhv_rec_type);
180: PROCEDURE update_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_idhv_tbl IN idhv_tbl_type,

Line 188: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_idhv_tbl IN idhv_tbl_type,
187: x_idhv_tbl OUT NOCOPY idhv_tbl_type,
188: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
189: PROCEDURE update_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

187: x_idhv_tbl OUT NOCOPY idhv_tbl_type,
188: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
189: PROCEDURE update_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_idhv_tbl IN idhv_tbl_type,

Line 199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

195: p_idhv_tbl IN idhv_tbl_type,
196: x_idhv_tbl OUT NOCOPY idhv_tbl_type);
197: PROCEDURE delete_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_idhv_rec IN idhv_rec_type);

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_idhv_rec IN idhv_rec_type);
204: PROCEDURE delete_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_idhv_tbl IN idhv_tbl_type,

Line 211: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_idhv_tbl IN idhv_tbl_type,
211: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
212: PROCEDURE delete_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

210: p_idhv_tbl IN idhv_tbl_type,
211: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
212: PROCEDURE delete_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_idhv_tbl IN idhv_tbl_type);

Line 221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_idhv_tbl IN idhv_tbl_type);
219: PROCEDURE validate_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_idhv_rec IN idhv_rec_type);

Line 228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_idhv_rec IN idhv_rec_type);
226: PROCEDURE validate_row(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_idhv_tbl IN idhv_tbl_type,

Line 233: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_idhv_tbl IN idhv_tbl_type,
233: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
234: PROCEDURE validate_row(
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237: x_return_status OUT NOCOPY VARCHAR2,

Line 236: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

232: p_idhv_tbl IN idhv_tbl_type,
233: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
234: PROCEDURE validate_row(
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_idhv_tbl IN idhv_tbl_type);