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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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;
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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;
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
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;
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;
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;
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;
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;
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;
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;
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';
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';
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';
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';
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:
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,
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,
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,
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,
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);
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,
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,
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);
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,
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,
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,
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,
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);
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,
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,
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);
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);
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,
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,
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);