4: --GLOBAL DATASTRUCTURES
5: --------------------------------------------------------------------------------
6: TYPE okl_srtv_rec IS RECORD (
7: std_rate_tmpl_id NUMBER,
8: template_name okl_fe_std_rt_tmp_v.template_name%TYPE,
9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
5: --------------------------------------------------------------------------------
6: TYPE okl_srtv_rec IS RECORD (
7: std_rate_tmpl_id NUMBER,
8: template_name okl_fe_std_rt_tmp_v.template_name%TYPE,
9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
8: template_name okl_fe_std_rt_tmp_v.template_name%TYPE,
9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
9: template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
10: object_version_number NUMBER,
11: org_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
12: currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
13: rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14: pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
15: orig_std_rate_tmpl_id NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
16: rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
17: frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
18: index_id NUMBER,
19: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
20: sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
21: effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
22: effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
23: srt_rate NUMBER,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
24: attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
25: attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
26: attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
27: attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
28: attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
29: attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
30: attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
31: attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
32: attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
33: attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
34: attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42: last_updated_by NUMBER,
35: attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36: attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42: last_updated_by NUMBER,
43: last_update_date okl_fe_std_rt_tmp_v.last_update_date%TYPE,
37: attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38: attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42: last_updated_by NUMBER,
43: last_update_date okl_fe_std_rt_tmp_v.last_update_date%TYPE,
44: last_update_login NUMBER
45: );
39: attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40: created_by NUMBER,
41: creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42: last_updated_by NUMBER,
43: last_update_date okl_fe_std_rt_tmp_v.last_update_date%TYPE,
44: last_update_login NUMBER
45: );
46:
47: TYPE okl_srtv_tbl IS TABLE OF okl_srtv_rec INDEX BY BINARY_INTEGER;
56: orig_std_rate_tmpl_id NUMBER,
57: rate_type_code okl_fe_std_rt_tmp_all_b.rate_type_code%TYPE,
58: frequency_code okl_fe_std_rt_tmp_all_b.frequency_code%TYPE,
59: index_id NUMBER,
60: default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
61: sts_code okl_fe_std_rt_tmp_all_b.sts_code%TYPE,
62: effective_from_date okl_fe_std_rt_tmp_all_b.effective_from_date%TYPE,
63: effective_to_date okl_fe_std_rt_tmp_all_b.effective_to_date%TYPE,
64: srt_rate NUMBER,