4: ---------------------------------------------------------------------------
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,
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,
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,
14: organization_id NUMBER := Okl_Api.G_MISS_NUM,
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,
14: organization_id NUMBER := Okl_Api.G_MISS_NUM,
15: attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
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,
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,
18: attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%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,
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,
35: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
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);
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);
37: g_miss_svf_rec svf_rec_type;
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
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
39: INDEX BY BINARY_INTEGER;
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
39: INDEX BY BINARY_INTEGER;
40: TYPE okl_service_fees_tl_rec_type IS RECORD (
37: g_miss_svf_rec svf_rec_type;
38: TYPE svf_tbl_type IS TABLE OF svf_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE okl_service_fees_tl_rec_type IS RECORD (
41: id NUMBER := Okl_Api.G_MISS_NUM,
42: LANGUAGE OKL_SERVICE_FEES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
43: source_lang OKL_SERVICE_FEES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
44: sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
38: TYPE svf_tbl_type IS TABLE OF svf_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE okl_service_fees_tl_rec_type IS RECORD (
41: id NUMBER := Okl_Api.G_MISS_NUM,
42: LANGUAGE OKL_SERVICE_FEES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
43: source_lang OKL_SERVICE_FEES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
44: sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
39: INDEX BY BINARY_INTEGER;
40: TYPE okl_service_fees_tl_rec_type IS RECORD (
41: id NUMBER := Okl_Api.G_MISS_NUM,
42: LANGUAGE OKL_SERVICE_FEES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
43: source_lang OKL_SERVICE_FEES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
44: sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
40: TYPE okl_service_fees_tl_rec_type IS RECORD (
41: id NUMBER := Okl_Api.G_MISS_NUM,
42: LANGUAGE OKL_SERVICE_FEES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
43: source_lang OKL_SERVICE_FEES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
44: sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
48: creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
41: id NUMBER := Okl_Api.G_MISS_NUM,
42: LANGUAGE OKL_SERVICE_FEES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
43: source_lang OKL_SERVICE_FEES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
44: sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
48: creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
42: LANGUAGE OKL_SERVICE_FEES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
43: source_lang OKL_SERVICE_FEES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
44: sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
48: creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
50: last_update_date OKL_SERVICE_FEES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
43: source_lang OKL_SERVICE_FEES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
44: sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
48: creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
50: last_update_date OKL_SERVICE_FEES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
44: sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
48: creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
50: last_update_date OKL_SERVICE_FEES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
52: g_miss_okl_service_fees_tl_rec okl_service_fees_tl_rec_type;
45: name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
48: creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
50: last_update_date OKL_SERVICE_FEES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
52: g_miss_okl_service_fees_tl_rec okl_service_fees_tl_rec_type;
53: TYPE okl_service_fees_tl_tbl_type IS TABLE OF okl_service_fees_tl_rec_type
46: description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
48: creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
50: last_update_date OKL_SERVICE_FEES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
52: g_miss_okl_service_fees_tl_rec okl_service_fees_tl_rec_type;
53: TYPE okl_service_fees_tl_tbl_type IS TABLE OF okl_service_fees_tl_rec_type
54: INDEX BY BINARY_INTEGER;
47: created_by NUMBER := Okl_Api.G_MISS_NUM,
48: creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
50: last_update_date OKL_SERVICE_FEES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
52: g_miss_okl_service_fees_tl_rec okl_service_fees_tl_rec_type;
53: TYPE okl_service_fees_tl_tbl_type IS TABLE OF okl_service_fees_tl_rec_type
54: INDEX BY BINARY_INTEGER;
55: TYPE svfv_rec_type IS RECORD (
52: g_miss_okl_service_fees_tl_rec okl_service_fees_tl_rec_type;
53: TYPE okl_service_fees_tl_tbl_type IS TABLE OF okl_service_fees_tl_rec_type
54: INDEX BY BINARY_INTEGER;
55: TYPE svfv_rec_type IS RECORD (
56: id NUMBER := Okl_Api.G_MISS_NUM,
57: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_SERVICE_FEES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
53: TYPE okl_service_fees_tl_tbl_type IS TABLE OF okl_service_fees_tl_rec_type
54: INDEX BY BINARY_INTEGER;
55: TYPE svfv_rec_type IS RECORD (
56: id NUMBER := Okl_Api.G_MISS_NUM,
57: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_SERVICE_FEES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
54: INDEX BY BINARY_INTEGER;
55: TYPE svfv_rec_type IS RECORD (
56: id NUMBER := Okl_Api.G_MISS_NUM,
57: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_SERVICE_FEES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
55: TYPE svfv_rec_type IS RECORD (
56: id NUMBER := Okl_Api.G_MISS_NUM,
57: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_SERVICE_FEES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
56: id NUMBER := Okl_Api.G_MISS_NUM,
57: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_SERVICE_FEES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
57: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_SERVICE_FEES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_SERVICE_FEES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
59: srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
60: name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
61: description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
62: amount NUMBER := Okl_Api.G_MISS_NUM,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
63: start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
64: end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
65: organization_id NUMBER := Okl_Api.G_MISS_NUM,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
75: attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
83: creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
76: attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
83: creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
77: attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
83: creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
85: last_update_date OKL_SERVICE_FEES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
78: attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
83: creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
85: last_update_date OKL_SERVICE_FEES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
86: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
79: attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
83: creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
85: last_update_date OKL_SERVICE_FEES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
86: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
87: g_miss_svfv_rec svfv_rec_type;
80: attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
83: creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
85: last_update_date OKL_SERVICE_FEES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
86: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
87: g_miss_svfv_rec svfv_rec_type;
88: TYPE svfv_tbl_type IS TABLE OF svfv_rec_type
81: attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
83: creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
85: last_update_date OKL_SERVICE_FEES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
86: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
87: g_miss_svfv_rec svfv_rec_type;
88: TYPE svfv_tbl_type IS TABLE OF svfv_rec_type
89: INDEX BY BINARY_INTEGER;
82: created_by NUMBER := Okl_Api.G_MISS_NUM,
83: creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
85: last_update_date OKL_SERVICE_FEES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
86: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
87: g_miss_svfv_rec svfv_rec_type;
88: TYPE svfv_tbl_type IS TABLE OF svfv_rec_type
89: INDEX BY BINARY_INTEGER;
90: ---------------------------------------------------------------------------
90: ---------------------------------------------------------------------------
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93:
94: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93:
94: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
92: ---------------------------------------------------------------------------
93:
94: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
93:
94: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
94: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
115: ---------------------------------------------------------------------------
116: -- GLOBAL VARIABLES
117: ---------------------------------------------------------------------------
118: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SVF_PVT';
119: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
120:
121: --------------------------------------------------------------------------
122: -- GLOBAL EXCEPTION
123: ---------------------------------------------------------------------------
132: PROCEDURE api_copy;
133: PROCEDURE add_language;
134: PROCEDURE insert_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_svfv_rec IN svfv_rec_type,
141: x_svfv_rec OUT NOCOPY svfv_rec_type);
142:
143: PROCEDURE insert_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_svfv_tbl IN svfv_tbl_type,
150: x_svfv_tbl OUT NOCOPY svfv_tbl_type);
151:
152: PROCEDURE lock_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_svfv_rec IN svfv_rec_type);
158: p_svfv_rec IN svfv_rec_type);
159:
160: PROCEDURE lock_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_svfv_tbl IN svfv_tbl_type);
166: p_svfv_tbl IN svfv_tbl_type);
167:
168: PROCEDURE update_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_svfv_rec IN svfv_rec_type,
175: x_svfv_rec OUT NOCOPY svfv_rec_type);
176:
177: PROCEDURE update_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_svfv_tbl IN svfv_tbl_type,
184: x_svfv_tbl OUT NOCOPY svfv_tbl_type);
185:
186: PROCEDURE delete_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_svfv_rec IN svfv_rec_type);
192: p_svfv_rec IN svfv_rec_type);
193:
194: PROCEDURE delete_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_svfv_tbl IN svfv_tbl_type);
200: p_svfv_tbl IN svfv_tbl_type);
201:
202: PROCEDURE validate_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_svfv_rec IN svfv_rec_type);
208: p_svfv_rec IN svfv_rec_type);
209:
210: PROCEDURE validate_row(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_svfv_tbl IN svfv_tbl_type);