4:
5: TYPE pool_rec_type IS RECORD(
6:
7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: NAME OKE_FUNDING_POOLS.NAME%TYPE:=OKE_API.G_MISS_CHAR,
9: DESCRIPTION OKE_FUNDING_POOLS.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
10: CURRENCY_CODE OKE_FUNDING_POOLS.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONTACT_PERSON_ID NUMBER:= OKE_API.G_MISS_NUM,
12: PROGRAM_ID NUMBER:= OKE_API.G_MISS_NUM,
5: TYPE pool_rec_type IS RECORD(
6:
7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: NAME OKE_FUNDING_POOLS.NAME%TYPE:=OKE_API.G_MISS_CHAR,
9: DESCRIPTION OKE_FUNDING_POOLS.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
10: CURRENCY_CODE OKE_FUNDING_POOLS.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONTACT_PERSON_ID NUMBER:= OKE_API.G_MISS_NUM,
12: PROGRAM_ID NUMBER:= OKE_API.G_MISS_NUM,
13: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
6:
7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: NAME OKE_FUNDING_POOLS.NAME%TYPE:=OKE_API.G_MISS_CHAR,
9: DESCRIPTION OKE_FUNDING_POOLS.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
10: CURRENCY_CODE OKE_FUNDING_POOLS.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONTACT_PERSON_ID NUMBER:= OKE_API.G_MISS_NUM,
12: PROGRAM_ID NUMBER:= OKE_API.G_MISS_NUM,
13: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
14: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
15: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
16: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
17: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
18: ATTRIBUTE_CATEGORY OKE_FUNDING_POOLS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE1 OKE_FUNDING_POOLS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE2 OKE_FUNDING_POOLS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
15: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
16: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
17: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
18: ATTRIBUTE_CATEGORY OKE_FUNDING_POOLS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE1 OKE_FUNDING_POOLS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE2 OKE_FUNDING_POOLS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
16: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
17: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
18: ATTRIBUTE_CATEGORY OKE_FUNDING_POOLS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE1 OKE_FUNDING_POOLS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE2 OKE_FUNDING_POOLS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
17: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
18: ATTRIBUTE_CATEGORY OKE_FUNDING_POOLS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE1 OKE_FUNDING_POOLS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE2 OKE_FUNDING_POOLS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE_CATEGORY OKE_FUNDING_POOLS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE1 OKE_FUNDING_POOLS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE2 OKE_FUNDING_POOLS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE1 OKE_FUNDING_POOLS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE2 OKE_FUNDING_POOLS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE2 OKE_FUNDING_POOLS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE13 OKE_FUNDING_POOLS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE13 OKE_FUNDING_POOLS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE14 OKE_FUNDING_POOLS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE13 OKE_FUNDING_POOLS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE14 OKE_FUNDING_POOLS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE15 OKE_FUNDING_POOLS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE13 OKE_FUNDING_POOLS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE14 OKE_FUNDING_POOLS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE15 OKE_FUNDING_POOLS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
34: );
27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE13 OKE_FUNDING_POOLS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE14 OKE_FUNDING_POOLS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE15 OKE_FUNDING_POOLS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
34: );
35:
28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE13 OKE_FUNDING_POOLS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE14 OKE_FUNDING_POOLS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE15 OKE_FUNDING_POOLS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
34: );
35:
36: TYPE pool_tbl_type IS TABLE OF pool_rec_type
29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE13 OKE_FUNDING_POOLS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE14 OKE_FUNDING_POOLS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE15 OKE_FUNDING_POOLS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
34: );
35:
36: TYPE pool_tbl_type IS TABLE OF pool_rec_type
37: INDEX BY BINARY_INTEGER;
58: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
59: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_POOL_PVT';
61: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
62: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_FUNDING_POOLS';
63:
64: G_EXCEPTION_HALT_VALIDATION exception;
65:
66: -- Procedures and functions