3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE xhr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: irq_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE xhr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: irq_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE xhr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: irq_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE xhr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: irq_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: irq_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
8: irq_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
11: creation_date OKL_EXT_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
13: last_update_date OKL_EXT_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
15: request_id NUMBER := OKC_API.G_MISS_NUM,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
16: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
17: program_id NUMBER := OKC_API.G_MISS_NUM,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
18: program_update_date OKL_EXT_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
19: attribute_category OKL_EXT_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
20: attribute1 OKL_EXT_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
21: attribute2 OKL_EXT_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
22: attribute3 OKL_EXT_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
23: attribute4 OKL_EXT_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
24: attribute5 OKL_EXT_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_EXT_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
25: attribute6 OKL_EXT_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_EXT_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_EXT_FUND_RQNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
26: attribute7 OKL_EXT_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_EXT_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_EXT_FUND_RQNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_EXT_FUND_RQNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
27: attribute8 OKL_EXT_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_EXT_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_EXT_FUND_RQNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_EXT_FUND_RQNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
28: attribute9 OKL_EXT_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_EXT_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_EXT_FUND_RQNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_EXT_FUND_RQNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: g_miss_xhr_rec xhr_rec_type;
29: attribute10 OKL_EXT_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_EXT_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_EXT_FUND_RQNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_EXT_FUND_RQNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: g_miss_xhr_rec xhr_rec_type;
37: TYPE xhr_tbl_type IS TABLE OF xhr_rec_type
30: attribute11 OKL_EXT_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_EXT_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_EXT_FUND_RQNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_EXT_FUND_RQNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: g_miss_xhr_rec xhr_rec_type;
37: TYPE xhr_tbl_type IS TABLE OF xhr_rec_type
38: INDEX BY BINARY_INTEGER;
31: attribute12 OKL_EXT_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32: attribute13 OKL_EXT_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33: attribute14 OKL_EXT_FUND_RQNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_EXT_FUND_RQNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: g_miss_xhr_rec xhr_rec_type;
37: TYPE xhr_tbl_type IS TABLE OF xhr_rec_type
38: INDEX BY BINARY_INTEGER;
39: TYPE okl_ext_fund_rqns_tl_rec_type IS RECORD (
36: g_miss_xhr_rec xhr_rec_type;
37: TYPE xhr_tbl_type IS TABLE OF xhr_rec_type
38: INDEX BY BINARY_INTEGER;
39: TYPE okl_ext_fund_rqns_tl_rec_type IS RECORD (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKL_EXT_FUND_RQNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKL_EXT_FUND_RQNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKL_EXT_FUND_RQNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
37: TYPE xhr_tbl_type IS TABLE OF xhr_rec_type
38: INDEX BY BINARY_INTEGER;
39: TYPE okl_ext_fund_rqns_tl_rec_type IS RECORD (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKL_EXT_FUND_RQNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKL_EXT_FUND_RQNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKL_EXT_FUND_RQNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_EXT_FUND_RQNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38: INDEX BY BINARY_INTEGER;
39: TYPE okl_ext_fund_rqns_tl_rec_type IS RECORD (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKL_EXT_FUND_RQNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKL_EXT_FUND_RQNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKL_EXT_FUND_RQNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_EXT_FUND_RQNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39: TYPE okl_ext_fund_rqns_tl_rec_type IS RECORD (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKL_EXT_FUND_RQNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKL_EXT_FUND_RQNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKL_EXT_FUND_RQNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_EXT_FUND_RQNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_EXT_FUND_RQNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40: id NUMBER := OKC_API.G_MISS_NUM,
41: language OKL_EXT_FUND_RQNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKL_EXT_FUND_RQNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKL_EXT_FUND_RQNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_EXT_FUND_RQNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_EXT_FUND_RQNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
41: language OKL_EXT_FUND_RQNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42: source_lang OKL_EXT_FUND_RQNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKL_EXT_FUND_RQNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_EXT_FUND_RQNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_EXT_FUND_RQNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: GMissOklExtFundRqnsTlRec okl_ext_fund_rqns_tl_rec_type;
42: source_lang OKL_EXT_FUND_RQNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43: sfwt_flag OKL_EXT_FUND_RQNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_EXT_FUND_RQNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_EXT_FUND_RQNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: GMissOklExtFundRqnsTlRec okl_ext_fund_rqns_tl_rec_type;
50: TYPE okl_ext_fund_rqns_tl_tbl_type IS TABLE OF okl_ext_fund_rqns_tl_rec_type
43: sfwt_flag OKL_EXT_FUND_RQNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_EXT_FUND_RQNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_EXT_FUND_RQNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: GMissOklExtFundRqnsTlRec okl_ext_fund_rqns_tl_rec_type;
50: TYPE okl_ext_fund_rqns_tl_tbl_type IS TABLE OF okl_ext_fund_rqns_tl_rec_type
51: INDEX BY BINARY_INTEGER;
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKL_EXT_FUND_RQNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKL_EXT_FUND_RQNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: GMissOklExtFundRqnsTlRec okl_ext_fund_rqns_tl_rec_type;
50: TYPE okl_ext_fund_rqns_tl_tbl_type IS TABLE OF okl_ext_fund_rqns_tl_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE xhrv_rec_type IS RECORD (
49: GMissOklExtFundRqnsTlRec okl_ext_fund_rqns_tl_rec_type;
50: TYPE okl_ext_fund_rqns_tl_tbl_type IS TABLE OF okl_ext_fund_rqns_tl_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE xhrv_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: sfwt_flag OKL_EXT_FUND_RQNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: irq_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: TYPE okl_ext_fund_rqns_tl_tbl_type IS TABLE OF okl_ext_fund_rqns_tl_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE xhrv_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: sfwt_flag OKL_EXT_FUND_RQNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: irq_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: INDEX BY BINARY_INTEGER;
52: TYPE xhrv_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: sfwt_flag OKL_EXT_FUND_RQNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: irq_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: TYPE xhrv_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: sfwt_flag OKL_EXT_FUND_RQNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: irq_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: sfwt_flag OKL_EXT_FUND_RQNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: irq_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: sfwt_flag OKL_EXT_FUND_RQNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: irq_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKL_EXT_FUND_RQNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: irq_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: irq_id NUMBER := OKC_API.G_MISS_NUM,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKL_EXT_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKL_EXT_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKL_EXT_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKL_EXT_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKL_EXT_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKL_EXT_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKL_EXT_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKL_EXT_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKL_EXT_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
66: attribute9 OKL_EXT_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: attribute10 OKL_EXT_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: attribute11 OKL_EXT_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: attribute12 OKL_EXT_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: org_id NUMBER := OKC_API.G_MISS_NUM,
70: attribute13 OKL_EXT_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: org_id NUMBER := OKC_API.G_MISS_NUM,
78: request_id NUMBER := OKC_API.G_MISS_NUM,
71: attribute14 OKL_EXT_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: org_id NUMBER := OKC_API.G_MISS_NUM,
78: request_id NUMBER := OKC_API.G_MISS_NUM,
79: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: attribute15 OKL_EXT_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: org_id NUMBER := OKC_API.G_MISS_NUM,
78: request_id NUMBER := OKC_API.G_MISS_NUM,
79: program_application_id NUMBER := OKC_API.G_MISS_NUM,
80: program_id NUMBER := OKC_API.G_MISS_NUM,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: org_id NUMBER := OKC_API.G_MISS_NUM,
78: request_id NUMBER := OKC_API.G_MISS_NUM,
79: program_application_id NUMBER := OKC_API.G_MISS_NUM,
80: program_id NUMBER := OKC_API.G_MISS_NUM,
81: program_update_date OKL_EXT_FUND_RQNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: creation_date OKL_EXT_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: org_id NUMBER := OKC_API.G_MISS_NUM,
78: request_id NUMBER := OKC_API.G_MISS_NUM,
79: program_application_id NUMBER := OKC_API.G_MISS_NUM,
80: program_id NUMBER := OKC_API.G_MISS_NUM,
81: program_update_date OKL_EXT_FUND_RQNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: org_id NUMBER := OKC_API.G_MISS_NUM,
78: request_id NUMBER := OKC_API.G_MISS_NUM,
79: program_application_id NUMBER := OKC_API.G_MISS_NUM,
80: program_id NUMBER := OKC_API.G_MISS_NUM,
81: program_update_date OKL_EXT_FUND_RQNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: g_miss_xhrv_rec xhrv_rec_type;
76: last_update_date OKL_EXT_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: org_id NUMBER := OKC_API.G_MISS_NUM,
78: request_id NUMBER := OKC_API.G_MISS_NUM,
79: program_application_id NUMBER := OKC_API.G_MISS_NUM,
80: program_id NUMBER := OKC_API.G_MISS_NUM,
81: program_update_date OKL_EXT_FUND_RQNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: g_miss_xhrv_rec xhrv_rec_type;
84: TYPE xhrv_tbl_type IS TABLE OF xhrv_rec_type
77: org_id NUMBER := OKC_API.G_MISS_NUM,
78: request_id NUMBER := OKC_API.G_MISS_NUM,
79: program_application_id NUMBER := OKC_API.G_MISS_NUM,
80: program_id NUMBER := OKC_API.G_MISS_NUM,
81: program_update_date OKL_EXT_FUND_RQNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: g_miss_xhrv_rec xhrv_rec_type;
84: TYPE xhrv_tbl_type IS TABLE OF xhrv_rec_type
85: INDEX BY BINARY_INTEGER;
78: request_id NUMBER := OKC_API.G_MISS_NUM,
79: program_application_id NUMBER := OKC_API.G_MISS_NUM,
80: program_id NUMBER := OKC_API.G_MISS_NUM,
81: program_update_date OKL_EXT_FUND_RQNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: g_miss_xhrv_rec xhrv_rec_type;
84: TYPE xhrv_tbl_type IS TABLE OF xhrv_rec_type
85: INDEX BY BINARY_INTEGER;
86: ---------------------------------------------------------------------------
85: INDEX BY BINARY_INTEGER;
86: ---------------------------------------------------------------------------
87: -- GLOBAL MESSAGE CONSTANTS
88: ---------------------------------------------------------------------------
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: ---------------------------------------------------------------------------
87: -- GLOBAL MESSAGE CONSTANTS
88: ---------------------------------------------------------------------------
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: -- GLOBAL MESSAGE CONSTANTS
88: ---------------------------------------------------------------------------
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: ---------------------------------------------------------------------------
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
99: ---------------------------------------------------------------------------
92: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
99: ---------------------------------------------------------------------------
100: -- GLOBAL VARIABLES
93: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
99: ---------------------------------------------------------------------------
100: -- GLOBAL VARIABLES
101: ---------------------------------------------------------------------------
94: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
95: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
96: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
97: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
98: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
99: ---------------------------------------------------------------------------
100: -- GLOBAL VARIABLES
101: ---------------------------------------------------------------------------
102: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XHR_PVT';
99: ---------------------------------------------------------------------------
100: -- GLOBAL VARIABLES
101: ---------------------------------------------------------------------------
102: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XHR_PVT';
103: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
104: ---------------------------------------------------------------------------
105: -- Procedures and Functions
106: ---------------------------------------------------------------------------
107:
110: PROCEDURE api_copy;
111: PROCEDURE add_language;
112: PROCEDURE insert_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_xhrv_rec IN xhrv_rec_type,
119: x_xhrv_rec OUT NOCOPY xhrv_rec_type);
120:
121: PROCEDURE insert_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_xhrv_tbl IN xhrv_tbl_type,
128: x_xhrv_tbl OUT NOCOPY xhrv_tbl_type);
129:
130: PROCEDURE lock_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_xhrv_rec IN xhrv_rec_type);
136: p_xhrv_rec IN xhrv_rec_type);
137:
138: PROCEDURE lock_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_xhrv_tbl IN xhrv_tbl_type);
144: p_xhrv_tbl IN xhrv_tbl_type);
145:
146: PROCEDURE update_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_xhrv_rec IN xhrv_rec_type,
153: x_xhrv_rec OUT NOCOPY xhrv_rec_type);
154:
155: PROCEDURE update_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_xhrv_tbl IN xhrv_tbl_type,
162: x_xhrv_tbl OUT NOCOPY xhrv_tbl_type);
163:
164: PROCEDURE delete_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_xhrv_rec IN xhrv_rec_type);
170: p_xhrv_rec IN xhrv_rec_type);
171:
172: PROCEDURE delete_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_xhrv_tbl IN xhrv_tbl_type);
178: p_xhrv_tbl IN xhrv_tbl_type);
179:
180: PROCEDURE validate_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_xhrv_rec IN xhrv_rec_type);
186: p_xhrv_rec IN xhrv_rec_type);
187:
188: PROCEDURE validate_row(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_xhrv_tbl IN xhrv_tbl_type);