7:
8: TYPE okl_lrvv_rec IS RECORD (
9: rate_set_version_id number,
10: object_version_number number,
11: arrears_yn okl_fe_rate_set_versions_v.arrears_yn%TYPE,
12: effective_from_date okl_fe_rate_set_versions_v.effective_from_date%TYPE,
13: effective_to_date okl_fe_rate_set_versions_v.effective_to_date%TYPE,
14: rate_set_id number,
15: end_of_term_ver_id number,
8: TYPE okl_lrvv_rec IS RECORD (
9: rate_set_version_id number,
10: object_version_number number,
11: arrears_yn okl_fe_rate_set_versions_v.arrears_yn%TYPE,
12: effective_from_date okl_fe_rate_set_versions_v.effective_from_date%TYPE,
13: effective_to_date okl_fe_rate_set_versions_v.effective_to_date%TYPE,
14: rate_set_id number,
15: end_of_term_ver_id number,
16: std_rate_tmpl_ver_id number,
9: rate_set_version_id number,
10: object_version_number number,
11: arrears_yn okl_fe_rate_set_versions_v.arrears_yn%TYPE,
12: effective_from_date okl_fe_rate_set_versions_v.effective_from_date%TYPE,
13: effective_to_date okl_fe_rate_set_versions_v.effective_to_date%TYPE,
14: rate_set_id number,
15: end_of_term_ver_id number,
16: std_rate_tmpl_ver_id number,
17: adj_mat_version_id number,
14: rate_set_id number,
15: end_of_term_ver_id number,
16: std_rate_tmpl_ver_id number,
17: adj_mat_version_id number,
18: version_number okl_fe_rate_set_versions_v.version_number%TYPE,
19: lrs_rate number,
20: rate_tolerance number,
21: residual_tolerance number,
22: deferred_pmts number,
20: rate_tolerance number,
21: residual_tolerance number,
22: deferred_pmts number,
23: advance_pmts number,
24: sts_code okl_fe_rate_set_versions_v.sts_code%TYPE,
25: created_by number,
26: creation_date okl_fe_rate_set_versions_v.creation_date%TYPE,
27: last_updated_by number,
28: last_update_date okl_fe_rate_set_versions_v.last_update_date%TYPE,
22: deferred_pmts number,
23: advance_pmts number,
24: sts_code okl_fe_rate_set_versions_v.sts_code%TYPE,
25: created_by number,
26: creation_date okl_fe_rate_set_versions_v.creation_date%TYPE,
27: last_updated_by number,
28: last_update_date okl_fe_rate_set_versions_v.last_update_date%TYPE,
29: last_update_login number,
30: attribute_category okl_fe_rate_set_versions_v.attribute_category%TYPE,
24: sts_code okl_fe_rate_set_versions_v.sts_code%TYPE,
25: created_by number,
26: creation_date okl_fe_rate_set_versions_v.creation_date%TYPE,
27: last_updated_by number,
28: last_update_date okl_fe_rate_set_versions_v.last_update_date%TYPE,
29: last_update_login number,
30: attribute_category okl_fe_rate_set_versions_v.attribute_category%TYPE,
31: attribute1 okl_fe_rate_set_versions_v.attribute1%TYPE,
32: attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
26: creation_date okl_fe_rate_set_versions_v.creation_date%TYPE,
27: last_updated_by number,
28: last_update_date okl_fe_rate_set_versions_v.last_update_date%TYPE,
29: last_update_login number,
30: attribute_category okl_fe_rate_set_versions_v.attribute_category%TYPE,
31: attribute1 okl_fe_rate_set_versions_v.attribute1%TYPE,
32: attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
33: attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
27: last_updated_by number,
28: last_update_date okl_fe_rate_set_versions_v.last_update_date%TYPE,
29: last_update_login number,
30: attribute_category okl_fe_rate_set_versions_v.attribute_category%TYPE,
31: attribute1 okl_fe_rate_set_versions_v.attribute1%TYPE,
32: attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
33: attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
28: last_update_date okl_fe_rate_set_versions_v.last_update_date%TYPE,
29: last_update_login number,
30: attribute_category okl_fe_rate_set_versions_v.attribute_category%TYPE,
31: attribute1 okl_fe_rate_set_versions_v.attribute1%TYPE,
32: attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
33: attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
29: last_update_login number,
30: attribute_category okl_fe_rate_set_versions_v.attribute_category%TYPE,
31: attribute1 okl_fe_rate_set_versions_v.attribute1%TYPE,
32: attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
33: attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
30: attribute_category okl_fe_rate_set_versions_v.attribute_category%TYPE,
31: attribute1 okl_fe_rate_set_versions_v.attribute1%TYPE,
32: attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
33: attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
31: attribute1 okl_fe_rate_set_versions_v.attribute1%TYPE,
32: attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
33: attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
32: attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
33: attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
33: attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
34: attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
35: attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43: attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
36: attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43: attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
44: attribute14 okl_fe_rate_set_versions_v.attribute14%TYPE,
37: attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43: attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
44: attribute14 okl_fe_rate_set_versions_v.attribute14%TYPE,
45: attribute15 okl_fe_rate_set_versions_v.attribute15%TYPE,
38: attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43: attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
44: attribute14 okl_fe_rate_set_versions_v.attribute14%TYPE,
45: attribute15 okl_fe_rate_set_versions_v.attribute15%TYPE,
46: standard_rate okl_fe_rate_set_versions_v.standard_rate%TYPE
39: attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43: attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
44: attribute14 okl_fe_rate_set_versions_v.attribute14%TYPE,
45: attribute15 okl_fe_rate_set_versions_v.attribute15%TYPE,
46: standard_rate okl_fe_rate_set_versions_v.standard_rate%TYPE
47: );
40: attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43: attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
44: attribute14 okl_fe_rate_set_versions_v.attribute14%TYPE,
45: attribute15 okl_fe_rate_set_versions_v.attribute15%TYPE,
46: standard_rate okl_fe_rate_set_versions_v.standard_rate%TYPE
47: );
48:
41: attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43: attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
44: attribute14 okl_fe_rate_set_versions_v.attribute14%TYPE,
45: attribute15 okl_fe_rate_set_versions_v.attribute15%TYPE,
46: standard_rate okl_fe_rate_set_versions_v.standard_rate%TYPE
47: );
48:
49: TYPE okl_lrvv_tbl IS TABLE OF okl_lrvv_rec INDEX BY BINARY_INTEGER;
42: attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43: attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
44: attribute14 okl_fe_rate_set_versions_v.attribute14%TYPE,
45: attribute15 okl_fe_rate_set_versions_v.attribute15%TYPE,
46: standard_rate okl_fe_rate_set_versions_v.standard_rate%TYPE
47: );
48:
49: TYPE okl_lrvv_tbl IS TABLE OF okl_lrvv_rec INDEX BY BINARY_INTEGER;
50:
57: rate_set_id number,
58: end_of_term_ver_id number,
59: std_rate_tmpl_ver_id number,
60: adj_mat_version_id number,
61: version_number okl_fe_rate_set_versions.version_number%TYPE,
62: lrs_rate number,
63: rate_tolerance number,
64: residual_tolerance number,
65: deferred_pmts number,