2: /* $Header: OKLSCBLS.pls 120.3 2006/07/14 05:06:38 pagarg noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CONTRACT_BALANCES_V Record Spec
7: TYPE cblv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,khr_id NUMBER := OKL_API.G_MISS_NUM
10: ,kle_id NUMBER := OKL_API.G_MISS_NUM
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,khr_id NUMBER := OKL_API.G_MISS_NUM
10: ,kle_id NUMBER := OKL_API.G_MISS_NUM
11: ,actual_principal_balance_amt NUMBER := OKL_API.G_MISS_NUM
12: ,actual_principal_balance_date OKL_CONTRACT_BALANCES.ACTUAL_PRINCIPAL_BALANCE_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,interest_amt NUMBER := OKL_API.G_MISS_NUM
14: ,interest_calc_date OKL_CONTRACT_BALANCES.INTEREST_CALC_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,interest_accrued_amt NUMBER := OKL_API.G_MISS_NUM
16: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
10: ,kle_id NUMBER := OKL_API.G_MISS_NUM
11: ,actual_principal_balance_amt NUMBER := OKL_API.G_MISS_NUM
12: ,actual_principal_balance_date OKL_CONTRACT_BALANCES.ACTUAL_PRINCIPAL_BALANCE_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,interest_amt NUMBER := OKL_API.G_MISS_NUM
14: ,interest_calc_date OKL_CONTRACT_BALANCES.INTEREST_CALC_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,interest_accrued_amt NUMBER := OKL_API.G_MISS_NUM
16: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,interest_billed_amt NUMBER := OKL_API.G_MISS_NUM
18: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
12: ,actual_principal_balance_date OKL_CONTRACT_BALANCES.ACTUAL_PRINCIPAL_BALANCE_DATE%TYPE := OKL_API.G_MISS_DATE
13: ,interest_amt NUMBER := OKL_API.G_MISS_NUM
14: ,interest_calc_date OKL_CONTRACT_BALANCES.INTEREST_CALC_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,interest_accrued_amt NUMBER := OKL_API.G_MISS_NUM
16: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,interest_billed_amt NUMBER := OKL_API.G_MISS_NUM
18: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,interest_received_amt NUMBER := OKL_API.G_MISS_NUM
20: ,interest_received_date OKL_CONTRACT_BALANCES.INTEREST_RECEIVED_DATE%TYPE := OKL_API.G_MISS_DATE
14: ,interest_calc_date OKL_CONTRACT_BALANCES.INTEREST_CALC_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,interest_accrued_amt NUMBER := OKL_API.G_MISS_NUM
16: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,interest_billed_amt NUMBER := OKL_API.G_MISS_NUM
18: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,interest_received_amt NUMBER := OKL_API.G_MISS_NUM
20: ,interest_received_date OKL_CONTRACT_BALANCES.INTEREST_RECEIVED_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,termination_value_amt NUMBER := OKL_API.G_MISS_NUM
22: ,termination_date OKL_CONTRACT_BALANCES.TERMINATION_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,interest_billed_amt NUMBER := OKL_API.G_MISS_NUM
18: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,interest_received_amt NUMBER := OKL_API.G_MISS_NUM
20: ,interest_received_date OKL_CONTRACT_BALANCES.INTEREST_RECEIVED_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,termination_value_amt NUMBER := OKL_API.G_MISS_NUM
22: ,termination_date OKL_CONTRACT_BALANCES.TERMINATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,org_id NUMBER := OKL_API.G_MISS_NUM
18: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
19: ,interest_received_amt NUMBER := OKL_API.G_MISS_NUM
20: ,interest_received_date OKL_CONTRACT_BALANCES.INTEREST_RECEIVED_DATE%TYPE := OKL_API.G_MISS_DATE
21: ,termination_value_amt NUMBER := OKL_API.G_MISS_NUM
22: ,termination_date OKL_CONTRACT_BALANCES.TERMINATION_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24: ,org_id NUMBER := OKL_API.G_MISS_NUM
25: ,request_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
24: ,org_id NUMBER := OKL_API.G_MISS_NUM
25: ,request_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
27: ,program_id NUMBER := OKL_API.G_MISS_NUM
28: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
29: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
25: ,request_id NUMBER := OKL_API.G_MISS_NUM
26: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
27: ,program_id NUMBER := OKL_API.G_MISS_NUM
28: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
29: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
26: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
27: ,program_id NUMBER := OKL_API.G_MISS_NUM
28: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
29: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
27: ,program_id NUMBER := OKL_API.G_MISS_NUM
28: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
29: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
28: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
29: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
43: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
43: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
44: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
43: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
44: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
38: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
43: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
44: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
43: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
44: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
40: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
41: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
42: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
43: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
44: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_CONTRACT_BALANCES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
42: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
43: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
44: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_CONTRACT_BALANCES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
50: G_MISS_cblv_rec cblv_rec_type;
44: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
45: ,created_by NUMBER := OKL_API.G_MISS_NUM
46: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48: ,last_update_date OKL_CONTRACT_BALANCES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
50: G_MISS_cblv_rec cblv_rec_type;
51: TYPE cblv_tbl_type IS TABLE OF cblv_rec_type
52: INDEX BY BINARY_INTEGER;
49: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
50: G_MISS_cblv_rec cblv_rec_type;
51: TYPE cblv_tbl_type IS TABLE OF cblv_rec_type
52: INDEX BY BINARY_INTEGER;
53: -- OKL_CONTRACT_BALANCES Record Spec
54: TYPE cbl_rec_type IS RECORD (
55: id NUMBER := OKL_API.G_MISS_NUM
56: ,khr_id NUMBER := OKL_API.G_MISS_NUM
57: ,kle_id NUMBER := OKL_API.G_MISS_NUM
55: id NUMBER := OKL_API.G_MISS_NUM
56: ,khr_id NUMBER := OKL_API.G_MISS_NUM
57: ,kle_id NUMBER := OKL_API.G_MISS_NUM
58: ,actual_principal_balance_amt NUMBER := OKL_API.G_MISS_NUM
59: ,actual_principal_balance_date OKL_CONTRACT_BALANCES.ACTUAL_PRINCIPAL_BALANCE_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,interest_amt NUMBER := OKL_API.G_MISS_NUM
61: ,interest_calc_date OKL_CONTRACT_BALANCES.INTEREST_CALC_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,interest_accrued_amt NUMBER := OKL_API.G_MISS_NUM
63: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
57: ,kle_id NUMBER := OKL_API.G_MISS_NUM
58: ,actual_principal_balance_amt NUMBER := OKL_API.G_MISS_NUM
59: ,actual_principal_balance_date OKL_CONTRACT_BALANCES.ACTUAL_PRINCIPAL_BALANCE_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,interest_amt NUMBER := OKL_API.G_MISS_NUM
61: ,interest_calc_date OKL_CONTRACT_BALANCES.INTEREST_CALC_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,interest_accrued_amt NUMBER := OKL_API.G_MISS_NUM
63: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
64: ,interest_billed_amt NUMBER := OKL_API.G_MISS_NUM
65: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,actual_principal_balance_date OKL_CONTRACT_BALANCES.ACTUAL_PRINCIPAL_BALANCE_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,interest_amt NUMBER := OKL_API.G_MISS_NUM
61: ,interest_calc_date OKL_CONTRACT_BALANCES.INTEREST_CALC_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,interest_accrued_amt NUMBER := OKL_API.G_MISS_NUM
63: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
64: ,interest_billed_amt NUMBER := OKL_API.G_MISS_NUM
65: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
66: ,interest_received_amt NUMBER := OKL_API.G_MISS_NUM
67: ,interest_received_date OKL_CONTRACT_BALANCES.INTEREST_RECEIVED_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,interest_calc_date OKL_CONTRACT_BALANCES.INTEREST_CALC_DATE%TYPE := OKL_API.G_MISS_DATE
62: ,interest_accrued_amt NUMBER := OKL_API.G_MISS_NUM
63: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
64: ,interest_billed_amt NUMBER := OKL_API.G_MISS_NUM
65: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
66: ,interest_received_amt NUMBER := OKL_API.G_MISS_NUM
67: ,interest_received_date OKL_CONTRACT_BALANCES.INTEREST_RECEIVED_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,termination_value_amt NUMBER := OKL_API.G_MISS_NUM
69: ,termination_date OKL_CONTRACT_BALANCES.TERMINATION_DATE%TYPE := OKL_API.G_MISS_DATE
63: ,interest_accrued_date OKL_CONTRACT_BALANCES.INTEREST_ACCRUED_DATE%TYPE := OKL_API.G_MISS_DATE
64: ,interest_billed_amt NUMBER := OKL_API.G_MISS_NUM
65: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
66: ,interest_received_amt NUMBER := OKL_API.G_MISS_NUM
67: ,interest_received_date OKL_CONTRACT_BALANCES.INTEREST_RECEIVED_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,termination_value_amt NUMBER := OKL_API.G_MISS_NUM
69: ,termination_date OKL_CONTRACT_BALANCES.TERMINATION_DATE%TYPE := OKL_API.G_MISS_DATE
70: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
71: ,org_id NUMBER := OKL_API.G_MISS_NUM
65: ,interest_billed_date OKL_CONTRACT_BALANCES.INTEREST_BILLED_DATE%TYPE := OKL_API.G_MISS_DATE
66: ,interest_received_amt NUMBER := OKL_API.G_MISS_NUM
67: ,interest_received_date OKL_CONTRACT_BALANCES.INTEREST_RECEIVED_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,termination_value_amt NUMBER := OKL_API.G_MISS_NUM
69: ,termination_date OKL_CONTRACT_BALANCES.TERMINATION_DATE%TYPE := OKL_API.G_MISS_DATE
70: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
71: ,org_id NUMBER := OKL_API.G_MISS_NUM
72: ,request_id NUMBER := OKL_API.G_MISS_NUM
73: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
71: ,org_id NUMBER := OKL_API.G_MISS_NUM
72: ,request_id NUMBER := OKL_API.G_MISS_NUM
73: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
74: ,program_id NUMBER := OKL_API.G_MISS_NUM
75: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
72: ,request_id NUMBER := OKL_API.G_MISS_NUM
73: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
74: ,program_id NUMBER := OKL_API.G_MISS_NUM
75: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
73: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
74: ,program_id NUMBER := OKL_API.G_MISS_NUM
75: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
74: ,program_id NUMBER := OKL_API.G_MISS_NUM
75: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
75: ,program_update_date OKL_CONTRACT_BALANCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
76: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute_category OKL_CONTRACT_BALANCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute1 OKL_CONTRACT_BALANCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute2 OKL_CONTRACT_BALANCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute3 OKL_CONTRACT_BALANCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute4 OKL_CONTRACT_BALANCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute5 OKL_CONTRACT_BALANCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute6 OKL_CONTRACT_BALANCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute7 OKL_CONTRACT_BALANCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute8 OKL_CONTRACT_BALANCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
92: ,created_by NUMBER := OKL_API.G_MISS_NUM
85: ,attribute9 OKL_CONTRACT_BALANCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
92: ,created_by NUMBER := OKL_API.G_MISS_NUM
93: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
86: ,attribute10 OKL_CONTRACT_BALANCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
92: ,created_by NUMBER := OKL_API.G_MISS_NUM
93: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
94: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
87: ,attribute11 OKL_CONTRACT_BALANCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute12 OKL_CONTRACT_BALANCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
92: ,created_by NUMBER := OKL_API.G_MISS_NUM
93: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
94: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
95: ,last_update_date OKL_CONTRACT_BALANCES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
89: ,attribute13 OKL_CONTRACT_BALANCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute14 OKL_CONTRACT_BALANCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
92: ,created_by NUMBER := OKL_API.G_MISS_NUM
93: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
94: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
95: ,last_update_date OKL_CONTRACT_BALANCES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
96: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
97: G_MISS_cbl_rec cbl_rec_type;
91: ,attribute15 OKL_CONTRACT_BALANCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
92: ,created_by NUMBER := OKL_API.G_MISS_NUM
93: ,creation_date OKL_CONTRACT_BALANCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
94: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
95: ,last_update_date OKL_CONTRACT_BALANCES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
96: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
97: G_MISS_cbl_rec cbl_rec_type;
98: TYPE cbl_tbl_type IS TABLE OF cbl_rec_type
99: INDEX BY BINARY_INTEGER;