7:
8: TYPE okl_pal_rec IS RECORD (
9: adj_mat_version_id NUMBER,
10: object_version_number NUMBER,
11: version_number okl_fe_adj_mat_versions.version_number%TYPE,
12: adj_mat_id NUMBER,
13: sts_code okl_fe_adj_mat_versions.sts_code%TYPE,
14: effective_from_date okl_fe_adj_mat_versions.effective_from_date%TYPE,
15: effective_to_date okl_fe_adj_mat_versions.effective_to_date%TYPE,
9: adj_mat_version_id NUMBER,
10: object_version_number NUMBER,
11: version_number okl_fe_adj_mat_versions.version_number%TYPE,
12: adj_mat_id NUMBER,
13: sts_code okl_fe_adj_mat_versions.sts_code%TYPE,
14: effective_from_date okl_fe_adj_mat_versions.effective_from_date%TYPE,
15: effective_to_date okl_fe_adj_mat_versions.effective_to_date%TYPE,
16: attribute_category okl_fe_adj_mat_versions.attribute_category%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
10: object_version_number NUMBER,
11: version_number okl_fe_adj_mat_versions.version_number%TYPE,
12: adj_mat_id NUMBER,
13: sts_code okl_fe_adj_mat_versions.sts_code%TYPE,
14: effective_from_date okl_fe_adj_mat_versions.effective_from_date%TYPE,
15: effective_to_date okl_fe_adj_mat_versions.effective_to_date%TYPE,
16: attribute_category okl_fe_adj_mat_versions.attribute_category%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
11: version_number okl_fe_adj_mat_versions.version_number%TYPE,
12: adj_mat_id NUMBER,
13: sts_code okl_fe_adj_mat_versions.sts_code%TYPE,
14: effective_from_date okl_fe_adj_mat_versions.effective_from_date%TYPE,
15: effective_to_date okl_fe_adj_mat_versions.effective_to_date%TYPE,
16: attribute_category okl_fe_adj_mat_versions.attribute_category%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
12: adj_mat_id NUMBER,
13: sts_code okl_fe_adj_mat_versions.sts_code%TYPE,
14: effective_from_date okl_fe_adj_mat_versions.effective_from_date%TYPE,
15: effective_to_date okl_fe_adj_mat_versions.effective_to_date%TYPE,
16: attribute_category okl_fe_adj_mat_versions.attribute_category%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
13: sts_code okl_fe_adj_mat_versions.sts_code%TYPE,
14: effective_from_date okl_fe_adj_mat_versions.effective_from_date%TYPE,
15: effective_to_date okl_fe_adj_mat_versions.effective_to_date%TYPE,
16: attribute_category okl_fe_adj_mat_versions.attribute_category%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
14: effective_from_date okl_fe_adj_mat_versions.effective_from_date%TYPE,
15: effective_to_date okl_fe_adj_mat_versions.effective_to_date%TYPE,
16: attribute_category okl_fe_adj_mat_versions.attribute_category%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
15: effective_to_date okl_fe_adj_mat_versions.effective_to_date%TYPE,
16: attribute_category okl_fe_adj_mat_versions.attribute_category%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
16: attribute_category okl_fe_adj_mat_versions.attribute_category%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
17: attribute1 okl_fe_adj_mat_versions.attribute1%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
18: attribute2 okl_fe_adj_mat_versions.attribute2%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
19: attribute3 okl_fe_adj_mat_versions.attribute3%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
20: attribute4 okl_fe_adj_mat_versions.attribute4%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
28: attribute12 okl_fe_adj_mat_versions.attribute12%TYPE,
21: attribute5 okl_fe_adj_mat_versions.attribute5%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
28: attribute12 okl_fe_adj_mat_versions.attribute12%TYPE,
29: attribute13 okl_fe_adj_mat_versions.attribute13%TYPE,
22: attribute6 okl_fe_adj_mat_versions.attribute6%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
28: attribute12 okl_fe_adj_mat_versions.attribute12%TYPE,
29: attribute13 okl_fe_adj_mat_versions.attribute13%TYPE,
30: attribute14 okl_fe_adj_mat_versions.attribute14%TYPE,
23: attribute7 okl_fe_adj_mat_versions.attribute7%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
28: attribute12 okl_fe_adj_mat_versions.attribute12%TYPE,
29: attribute13 okl_fe_adj_mat_versions.attribute13%TYPE,
30: attribute14 okl_fe_adj_mat_versions.attribute14%TYPE,
31: attribute15 okl_fe_adj_mat_versions.attribute15%TYPE,
24: attribute8 okl_fe_adj_mat_versions.attribute8%TYPE,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
28: attribute12 okl_fe_adj_mat_versions.attribute12%TYPE,
29: attribute13 okl_fe_adj_mat_versions.attribute13%TYPE,
30: attribute14 okl_fe_adj_mat_versions.attribute14%TYPE,
31: attribute15 okl_fe_adj_mat_versions.attribute15%TYPE,
32: created_by NUMBER,
25: attribute9 okl_fe_adj_mat_versions.attribute9%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
28: attribute12 okl_fe_adj_mat_versions.attribute12%TYPE,
29: attribute13 okl_fe_adj_mat_versions.attribute13%TYPE,
30: attribute14 okl_fe_adj_mat_versions.attribute14%TYPE,
31: attribute15 okl_fe_adj_mat_versions.attribute15%TYPE,
32: created_by NUMBER,
33: creation_date okl_fe_adj_mat_versions.creation_date%TYPE,
26: attribute10 okl_fe_adj_mat_versions.attribute10%TYPE,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
28: attribute12 okl_fe_adj_mat_versions.attribute12%TYPE,
29: attribute13 okl_fe_adj_mat_versions.attribute13%TYPE,
30: attribute14 okl_fe_adj_mat_versions.attribute14%TYPE,
31: attribute15 okl_fe_adj_mat_versions.attribute15%TYPE,
32: created_by NUMBER,
33: creation_date okl_fe_adj_mat_versions.creation_date%TYPE,
34: last_updated_by NUMBER,
27: attribute11 okl_fe_adj_mat_versions.attribute11%TYPE,
28: attribute12 okl_fe_adj_mat_versions.attribute12%TYPE,
29: attribute13 okl_fe_adj_mat_versions.attribute13%TYPE,
30: attribute14 okl_fe_adj_mat_versions.attribute14%TYPE,
31: attribute15 okl_fe_adj_mat_versions.attribute15%TYPE,
32: created_by NUMBER,
33: creation_date okl_fe_adj_mat_versions.creation_date%TYPE,
34: last_updated_by NUMBER,
35: last_update_date okl_fe_adj_mat_versions.last_update_date%TYPE,
29: attribute13 okl_fe_adj_mat_versions.attribute13%TYPE,
30: attribute14 okl_fe_adj_mat_versions.attribute14%TYPE,
31: attribute15 okl_fe_adj_mat_versions.attribute15%TYPE,
32: created_by NUMBER,
33: creation_date okl_fe_adj_mat_versions.creation_date%TYPE,
34: last_updated_by NUMBER,
35: last_update_date okl_fe_adj_mat_versions.last_update_date%TYPE,
36: last_update_login NUMBER
37: );
31: attribute15 okl_fe_adj_mat_versions.attribute15%TYPE,
32: created_by NUMBER,
33: creation_date okl_fe_adj_mat_versions.creation_date%TYPE,
34: last_updated_by NUMBER,
35: last_update_date okl_fe_adj_mat_versions.last_update_date%TYPE,
36: last_update_login NUMBER
37: );
38:
39: TYPE okl_pal_tbl IS TABLE OF okl_pal_rec INDEX BY BINARY_INTEGER;