5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE svf_rec_type IS RECORD (
8: id NUMBER := Okl_Api.G_MISS_NUM,
9: srv_code OKL_SERVICE_FEES_B.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
10: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
11: amount NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_SERVICE_FEES_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_SERVICE_FEES_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
8: id NUMBER := Okl_Api.G_MISS_NUM,
9: srv_code OKL_SERVICE_FEES_B.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
10: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
11: amount NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_SERVICE_FEES_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_SERVICE_FEES_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: organization_id NUMBER := Okl_Api.G_MISS_NUM,
15: attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
9: srv_code OKL_SERVICE_FEES_B.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
10: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
11: amount NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_SERVICE_FEES_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_SERVICE_FEES_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: organization_id NUMBER := Okl_Api.G_MISS_NUM,
15: attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
11: amount NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_SERVICE_FEES_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_SERVICE_FEES_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: organization_id NUMBER := Okl_Api.G_MISS_NUM,
15: attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
12: start_date OKL_SERVICE_FEES_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_SERVICE_FEES_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: organization_id NUMBER := Okl_Api.G_MISS_NUM,
15: attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
13: end_date OKL_SERVICE_FEES_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: organization_id NUMBER := Okl_Api.G_MISS_NUM,
15: attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
14: organization_id NUMBER := Okl_Api.G_MISS_NUM,
15: attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute14 OKL_SERVICE_FEES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute14 OKL_SERVICE_FEES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute15 OKL_SERVICE_FEES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute14 OKL_SERVICE_FEES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute15 OKL_SERVICE_FEES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31: created_by NUMBER := Okl_Api.G_MISS_NUM,
24: attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute14 OKL_SERVICE_FEES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute15 OKL_SERVICE_FEES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31: created_by NUMBER := Okl_Api.G_MISS_NUM,
32: creation_date OKL_SERVICE_FEES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
25: attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute14 OKL_SERVICE_FEES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute15 OKL_SERVICE_FEES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31: created_by NUMBER := Okl_Api.G_MISS_NUM,
32: creation_date OKL_SERVICE_FEES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
33: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
26: attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute14 OKL_SERVICE_FEES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute15 OKL_SERVICE_FEES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31: created_by NUMBER := Okl_Api.G_MISS_NUM,
32: creation_date OKL_SERVICE_FEES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
33: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
34: last_update_date OKL_SERVICE_FEES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
28: attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute14 OKL_SERVICE_FEES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute15 OKL_SERVICE_FEES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31: created_by NUMBER := Okl_Api.G_MISS_NUM,
32: creation_date OKL_SERVICE_FEES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
33: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
34: last_update_date OKL_SERVICE_FEES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
35: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
36: org_id NUMBER := Okl_Api.G_MISS_NUM);
30: attribute15 OKL_SERVICE_FEES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31: created_by NUMBER := Okl_Api.G_MISS_NUM,
32: creation_date OKL_SERVICE_FEES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
33: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
34: last_update_date OKL_SERVICE_FEES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
35: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
36: org_id NUMBER := Okl_Api.G_MISS_NUM);
37: g_miss_svf_rec svf_rec_type;
38: TYPE svf_tbl_type IS TABLE OF svf_rec_type