eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_POOL_PVT dependencies on OKE_API

Line 7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,

3: -- GLOBAL DATA STRUCTURES
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,

Line 8: NAME OKE_FUNDING_POOLS.NAME%TYPE:=OKE_API.G_MISS_CHAR,

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,

Line 9: DESCRIPTION OKE_FUNDING_POOLS.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,

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,

Line 10: CURRENCY_CODE OKE_FUNDING_POOLS.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,

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,

Line 11: CONTACT_PERSON_ID NUMBER:= OKE_API.G_MISS_NUM,

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,
15: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,

Line 12: PROGRAM_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,
15: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
16: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,

Line 13: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,

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,
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,

Line 14: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,

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,
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,

Line 15: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,

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,
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,

Line 16: LAST_UPDATED_BY 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,
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,

Line 17: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,

13: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
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,

Line 18: ATTRIBUTE_CATEGORY OKE_FUNDING_POOLS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,

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,

Line 19: ATTRIBUTE1 OKE_FUNDING_POOLS.ATTRIBUTE1%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,

Line 20: ATTRIBUTE2 OKE_FUNDING_POOLS.ATTRIBUTE2%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,

Line 21: ATTRIBUTE3 OKE_FUNDING_POOLS.ATTRIBUTE3%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,

Line 22: ATTRIBUTE4 OKE_FUNDING_POOLS.ATTRIBUTE4%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,

Line 23: ATTRIBUTE5 OKE_FUNDING_POOLS.ATTRIBUTE5%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,

Line 24: ATTRIBUTE6 OKE_FUNDING_POOLS.ATTRIBUTE6%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,

Line 25: ATTRIBUTE7 OKE_FUNDING_POOLS.ATTRIBUTE7%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,

Line 26: ATTRIBUTE8 OKE_FUNDING_POOLS.ATTRIBUTE8%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,

Line 27: ATTRIBUTE9 OKE_FUNDING_POOLS.ATTRIBUTE9%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,

Line 28: ATTRIBUTE10 OKE_FUNDING_POOLS.ATTRIBUTE10%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,

Line 29: ATTRIBUTE11 OKE_FUNDING_POOLS.ATTRIBUTE11%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

Line 30: ATTRIBUTE12 OKE_FUNDING_POOLS.ATTRIBUTE12%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: );

Line 31: ATTRIBUTE13 OKE_FUNDING_POOLS.ATTRIBUTE13%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: );
35:

Line 32: ATTRIBUTE14 OKE_FUNDING_POOLS.ATTRIBUTE14%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:
36: TYPE pool_tbl_type IS TABLE OF pool_rec_type

Line 33: ATTRIBUTE15 OKE_FUNDING_POOLS.ATTRIBUTE15%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
37: INDEX BY BINARY_INTEGER;

Line 41: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;

37: INDEX BY BINARY_INTEGER;
38:
39: -- GLOBAL MESSAGE CONSTANTS
40:
41: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
42:
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
45:

Line 43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;

39: -- GLOBAL MESSAGE CONSTANTS
40:
41: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
42:
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
45:
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
47:

Line 44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;

40:
41: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
42:
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
45:
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
47:
48: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;

Line 46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;

42:
43: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
45:
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
47:
48: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
50: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

Line 48: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;

44: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
45:
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
47:
48: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
50: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
51: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;

Line 49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;

45:
46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
47:
48: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
50: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
51: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;

Line 50: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

46: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
47:
48: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
50: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
51: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
54:

Line 51: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;

47:
48: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
50: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
51: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
54:
55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;

Line 52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;

48: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
50: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
51: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
54:
55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
56: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;

Line 53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;

49: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
50: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
51: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
54:
55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
56: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
57: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;

Line 55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;

51: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
54:
55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
56: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
57: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
58: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
59: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;

Line 56: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;

52: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
54:
55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
56: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
57: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
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';

Line 57: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;

53: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
54:
55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
56: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
57: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
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;

Line 58: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;

54:
55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
56: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
57: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
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';

Line 59: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;

55: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
56: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
57: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
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:

Line 61: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;

57: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
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:

Line 70: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

66: -- Procedures and functions
67:
68: PROCEDURE insert_row(
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_pool_rec IN pool_rec_type,

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

75: x_pool_rec OUT NOCOPY pool_rec_type);
76:
77: PROCEDURE insert_row(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_pool_tbl IN pool_tbl_type,

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

84: x_pool_tbl OUT NOCOPY pool_tbl_type);
85:
86: PROCEDURE update_row(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_pool_rec IN pool_rec_type,

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

93: x_pool_rec OUT NOCOPY pool_rec_type);
94:
95: PROCEDURE update_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_pool_tbl IN pool_tbl_type,

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

105: /* note: does not cascade into lines */
106:
107: PROCEDURE delete_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_pool_rec IN pool_rec_type);

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

113: p_pool_rec IN pool_rec_type);
114:
115: PROCEDURE delete_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_pool_tbl IN pool_tbl_type);

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

122:
123:
124: PROCEDURE lock_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_pool_rec IN pool_rec_type);