3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE dsf_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_DATA_SRC_FNCTNS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_DATA_SRC_FNCTNS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE dsf_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_DATA_SRC_FNCTNS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_DATA_SRC_FNCTNS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE dsf_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_DATA_SRC_FNCTNS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_DATA_SRC_FNCTNS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE dsf_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_DATA_SRC_FNCTNS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_DATA_SRC_FNCTNS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_DATA_SRC_FNCTNS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_DATA_SRC_FNCTNS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: name OKL_DATA_SRC_FNCTNS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_DATA_SRC_FNCTNS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
9: name OKL_DATA_SRC_FNCTNS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_DATA_SRC_FNCTNS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
10: version OKL_DATA_SRC_FNCTNS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
11: source OKL_DATA_SRC_FNCTNS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
12: org_id NUMBER := OKC_API.G_MISS_NUM,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
13: start_date OKL_DATA_SRC_FNCTNS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
14: end_date OKL_DATA_SRC_FNCTNS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
15: fnctn_code OKL_DATA_SRC_FNCTNS_B.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
25: attribute9 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_DATA_SRC_FNCTNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
26: attribute10 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_DATA_SRC_FNCTNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
27: attribute11 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_DATA_SRC_FNCTNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_DATA_SRC_FNCTNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
28: attribute12 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_DATA_SRC_FNCTNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_DATA_SRC_FNCTNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
29: attribute13 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_DATA_SRC_FNCTNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_DATA_SRC_FNCTNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: g_miss_dsf_rec dsf_rec_type;
30: attribute14 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_DATA_SRC_FNCTNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_DATA_SRC_FNCTNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: g_miss_dsf_rec dsf_rec_type;
38: TYPE dsf_tbl_type IS TABLE OF dsf_rec_type
31: attribute15 OKL_DATA_SRC_FNCTNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_DATA_SRC_FNCTNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_DATA_SRC_FNCTNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: g_miss_dsf_rec dsf_rec_type;
38: TYPE dsf_tbl_type IS TABLE OF dsf_rec_type
39: INDEX BY BINARY_INTEGER;
32: created_by NUMBER := OKC_API.G_MISS_NUM,
33: creation_date OKL_DATA_SRC_FNCTNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35: last_update_date OKL_DATA_SRC_FNCTNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36: last_update_login NUMBER := OKC_API.G_MISS_NUM);
37: g_miss_dsf_rec dsf_rec_type;
38: TYPE dsf_tbl_type IS TABLE OF dsf_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE OklDataSrcFnctnsTlRecType IS RECORD (
37: g_miss_dsf_rec dsf_rec_type;
38: TYPE dsf_tbl_type IS TABLE OF dsf_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE OklDataSrcFnctnsTlRecType IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKL_DATA_SRC_FNCTNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKL_DATA_SRC_FNCTNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKL_DATA_SRC_FNCTNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
38: TYPE dsf_tbl_type IS TABLE OF dsf_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE OklDataSrcFnctnsTlRecType IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKL_DATA_SRC_FNCTNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKL_DATA_SRC_FNCTNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKL_DATA_SRC_FNCTNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
39: INDEX BY BINARY_INTEGER;
40: TYPE OklDataSrcFnctnsTlRecType IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKL_DATA_SRC_FNCTNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKL_DATA_SRC_FNCTNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKL_DATA_SRC_FNCTNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_DATA_SRC_FNCTNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
40: TYPE OklDataSrcFnctnsTlRecType IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKL_DATA_SRC_FNCTNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKL_DATA_SRC_FNCTNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKL_DATA_SRC_FNCTNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_DATA_SRC_FNCTNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKL_DATA_SRC_FNCTNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKL_DATA_SRC_FNCTNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKL_DATA_SRC_FNCTNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_DATA_SRC_FNCTNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_DATA_SRC_FNCTNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
42: language OKL_DATA_SRC_FNCTNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKL_DATA_SRC_FNCTNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKL_DATA_SRC_FNCTNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_DATA_SRC_FNCTNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_DATA_SRC_FNCTNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
43: source_lang OKL_DATA_SRC_FNCTNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKL_DATA_SRC_FNCTNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_DATA_SRC_FNCTNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_DATA_SRC_FNCTNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: GMissOklDataSrcFnctnsTlRec OklDataSrcFnctnsTlRecType;
44: sfwt_flag OKL_DATA_SRC_FNCTNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_DATA_SRC_FNCTNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_DATA_SRC_FNCTNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: GMissOklDataSrcFnctnsTlRec OklDataSrcFnctnsTlRecType;
52: TYPE OklDataSrcFnctnsTlTblType IS TABLE OF OklDataSrcFnctnsTlRecType
45: description OKL_DATA_SRC_FNCTNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_DATA_SRC_FNCTNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_DATA_SRC_FNCTNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: GMissOklDataSrcFnctnsTlRec OklDataSrcFnctnsTlRecType;
52: TYPE OklDataSrcFnctnsTlTblType IS TABLE OF OklDataSrcFnctnsTlRecType
53: INDEX BY BINARY_INTEGER;
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_DATA_SRC_FNCTNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_DATA_SRC_FNCTNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: GMissOklDataSrcFnctnsTlRec OklDataSrcFnctnsTlRecType;
52: TYPE OklDataSrcFnctnsTlTblType IS TABLE OF OklDataSrcFnctnsTlRecType
53: INDEX BY BINARY_INTEGER;
54: TYPE dsfv_rec_type IS RECORD (
51: GMissOklDataSrcFnctnsTlRec OklDataSrcFnctnsTlRecType;
52: TYPE OklDataSrcFnctnsTlTblType IS TABLE OF OklDataSrcFnctnsTlRecType
53: INDEX BY BINARY_INTEGER;
54: TYPE dsfv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKL_DATA_SRC_FNCTNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: fnctn_code OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52: TYPE OklDataSrcFnctnsTlTblType IS TABLE OF OklDataSrcFnctnsTlRecType
53: INDEX BY BINARY_INTEGER;
54: TYPE dsfv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKL_DATA_SRC_FNCTNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: fnctn_code OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: INDEX BY BINARY_INTEGER;
54: TYPE dsfv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKL_DATA_SRC_FNCTNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: fnctn_code OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
54: TYPE dsfv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKL_DATA_SRC_FNCTNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: fnctn_code OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKL_DATA_SRC_FNCTNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: fnctn_code OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKL_DATA_SRC_FNCTNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: fnctn_code OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
57: sfwt_flag OKL_DATA_SRC_FNCTNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: fnctn_code OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: fnctn_code OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: name OKL_DATA_SRC_FNCTNS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: description OKL_DATA_SRC_FNCTNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: version OKL_DATA_SRC_FNCTNS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: start_date OKL_DATA_SRC_FNCTNS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: end_date OKL_DATA_SRC_FNCTNS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: source OKL_DATA_SRC_FNCTNS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute_category OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute1 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute2 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute3 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute4 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute5 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute6 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute7 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: attribute8 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81: org_id NUMBER := OKC_API.G_MISS_NUM,
74: attribute9 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81: org_id NUMBER := OKC_API.G_MISS_NUM,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
75: attribute10 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81: org_id NUMBER := OKC_API.G_MISS_NUM,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKL_DATA_SRC_FNCTNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
76: attribute11 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81: org_id NUMBER := OKC_API.G_MISS_NUM,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKL_DATA_SRC_FNCTNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
77: attribute12 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81: org_id NUMBER := OKC_API.G_MISS_NUM,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKL_DATA_SRC_FNCTNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKL_DATA_SRC_FNCTNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
78: attribute13 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81: org_id NUMBER := OKC_API.G_MISS_NUM,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKL_DATA_SRC_FNCTNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKL_DATA_SRC_FNCTNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
79: attribute14 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81: org_id NUMBER := OKC_API.G_MISS_NUM,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKL_DATA_SRC_FNCTNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKL_DATA_SRC_FNCTNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: g_miss_dsfv_rec dsfv_rec_type;
80: attribute15 OKL_DATA_SRC_FNCTNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81: org_id NUMBER := OKC_API.G_MISS_NUM,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKL_DATA_SRC_FNCTNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKL_DATA_SRC_FNCTNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: g_miss_dsfv_rec dsfv_rec_type;
88: TYPE dsfv_tbl_type IS TABLE OF dsfv_rec_type
81: org_id NUMBER := OKC_API.G_MISS_NUM,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKL_DATA_SRC_FNCTNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKL_DATA_SRC_FNCTNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: g_miss_dsfv_rec dsfv_rec_type;
88: TYPE dsfv_tbl_type IS TABLE OF dsfv_rec_type
89: INDEX BY BINARY_INTEGER;
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKL_DATA_SRC_FNCTNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKL_DATA_SRC_FNCTNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: g_miss_dsfv_rec dsfv_rec_type;
88: TYPE dsfv_tbl_type IS TABLE OF dsfv_rec_type
89: INDEX BY BINARY_INTEGER;
90: ---------------------------------------------------------------------------
89: INDEX BY BINARY_INTEGER;
90: ---------------------------------------------------------------------------
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
90: ---------------------------------------------------------------------------
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: --RPOONUGA001: Add message constant
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: --RPOONUGA001: Add message constant
104: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: --RPOONUGA001: Add message constant
104: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
105: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLERRM';
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: --RPOONUGA001: Add message constant
104: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
105: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLERRM';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLCODE';
114: ---------------------------------------------------------------------------
115: -- GLOBAL VARIABLES
116: ---------------------------------------------------------------------------
117: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_DSF_PVT';
118: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
119: --RPOONUGA001: Add global variables
120: G_PLSQL_TYPE CONSTANT VARCHAR2(200) := 'PLSQL';
121: ---------------------------------------------------------------------------
122: -- GLOBAL EXCEPTION
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 OKC_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_dsfv_rec IN dsfv_rec_type,
141: x_dsfv_rec OUT NOCOPY dsfv_rec_type);
142:
143: PROCEDURE insert_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_tbl IN dsfv_tbl_type,
150: x_dsfv_tbl OUT NOCOPY dsfv_tbl_type);
151:
152: PROCEDURE lock_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_rec IN dsfv_rec_type);
158: p_dsfv_rec IN dsfv_rec_type);
159:
160: PROCEDURE lock_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_tbl IN dsfv_tbl_type);
166: p_dsfv_tbl IN dsfv_tbl_type);
167:
168: PROCEDURE update_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_rec IN dsfv_rec_type,
175: x_dsfv_rec OUT NOCOPY dsfv_rec_type);
176:
177: PROCEDURE update_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_tbl IN dsfv_tbl_type,
184: x_dsfv_tbl OUT NOCOPY dsfv_tbl_type);
185:
186: PROCEDURE delete_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_rec IN dsfv_rec_type);
192: p_dsfv_rec IN dsfv_rec_type);
193:
194: PROCEDURE delete_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_tbl IN dsfv_tbl_type);
200: p_dsfv_tbl IN dsfv_tbl_type);
201:
202: PROCEDURE validate_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_rec IN dsfv_rec_type);
208: p_dsfv_rec IN dsfv_rec_type);
209:
210: PROCEDURE validate_row(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_dsfv_tbl IN dsfv_tbl_type);