APPS.OKE_PARTY_PVT dependencies on OKE_API

Line 6: POOL_PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,

2: /* $Header: OKEVFPPS.pls 115.6 2002/08/14 01:45:05 alaw ship $*/
3: -- GLOBAL DATA STRUCTURES
4:
5: TYPE party_rec_type IS RECORD(
6: POOL_PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,

Line 7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,

3: -- GLOBAL DATA STRUCTURES
4:
5: TYPE party_rec_type IS RECORD(
6: POOL_PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,

Line 8: PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,

4:
5: TYPE party_rec_type IS RECORD(
6: POOL_PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,

Line 9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,

5: TYPE party_rec_type IS RECORD(
6: POOL_PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,

Line 10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,

6: POOL_PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,

Line 11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,

7: FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8: PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,

Line 12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,

8: PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,

Line 13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,

9: CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,

Line 14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,

10: CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
18:

Line 15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,

11: CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
18:
19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,

Line 16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,

12: CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
18:
19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,

Line 17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,

13: INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14: AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
18:
19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,

Line 19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,

15: AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
18:
19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,

Line 20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,

16: START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
18:
19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,

Line 21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,

17: END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
18:
19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,

Line 22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,

18:
19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,

Line 23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,

19: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,

Line 24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,

20: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,

Line 25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,

21: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,

Line 26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,

22: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,

Line 27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,

23: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,

Line 28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,

24: ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,

Line 29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,

25: ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,

Line 30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,

26: ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,

Line 31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,

27: ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,

Line 32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,

28: ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,

Line 33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,

29: ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
37: ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,

Line 34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,

30: ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
37: ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
38: ATTRIBUTE14 OKE_POOL_PARTIES.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,

Line 35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,

31: ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
37: ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
38: ATTRIBUTE14 OKE_POOL_PARTIES.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
39: ATTRIBUTE15 OKE_POOL_PARTIES.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR

Line 36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,

32: ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
37: ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
38: ATTRIBUTE14 OKE_POOL_PARTIES.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
39: ATTRIBUTE15 OKE_POOL_PARTIES.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
40: );

Line 37: ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,

33: ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
37: ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
38: ATTRIBUTE14 OKE_POOL_PARTIES.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
39: ATTRIBUTE15 OKE_POOL_PARTIES.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
40: );
41:

Line 38: ATTRIBUTE14 OKE_POOL_PARTIES.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,

34: ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
37: ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
38: ATTRIBUTE14 OKE_POOL_PARTIES.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
39: ATTRIBUTE15 OKE_POOL_PARTIES.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
40: );
41:
42: TYPE party_tbl_type IS TABLE OF party_rec_type

Line 39: ATTRIBUTE15 OKE_POOL_PARTIES.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR

35: ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36: ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
37: ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
38: ATTRIBUTE14 OKE_POOL_PARTIES.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
39: ATTRIBUTE15 OKE_POOL_PARTIES.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
40: );
41:
42: TYPE party_tbl_type IS TABLE OF party_rec_type
43: INDEX BY BINARY_INTEGER;

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

43: INDEX BY BINARY_INTEGER;
44:
45: -- GLOBAL MESSAGE CONSTANTS
46:
47: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
48:
49: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
50: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
51:

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

45: -- GLOBAL MESSAGE CONSTANTS
46:
47: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
48:
49: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
50: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
51:
52: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
53:

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

46:
47: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
48:
49: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
50: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
51:
52: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
53:
54: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;

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

48:
49: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
50: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
51:
52: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
53:
54: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
55: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
56: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

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

50: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
51:
52: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
53:
54: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
55: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
56: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
57: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
58: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;

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

51:
52: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
53:
54: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
55: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
56: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
57: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
58: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;

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

52: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
53:
54: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
55: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
56: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
57: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
58: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
60:

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

53:
54: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
55: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
56: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
57: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
58: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
60:
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;

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

54: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
55: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
56: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
57: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
58: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
60:
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;

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

55: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
56: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
57: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
58: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
60:
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;

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

57: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
58: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
60:
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;

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

58: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
60:
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
66: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_PARTY_PVT';

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

59: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
60:
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
66: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_PARTY_PVT';
67: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;

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

60:
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
66: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_PARTY_PVT';
67: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
68: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_POOL_PARTIES';

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

61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
66: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_PARTY_PVT';
67: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
68: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_POOL_PARTIES';
69:

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

63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
66: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_PARTY_PVT';
67: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
68: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_POOL_PARTIES';
69:
70: G_EXCEPTION_HALT_VALIDATION exception;
71:

Line 76: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

72: -- Procedures and functions
73:
74: PROCEDURE insert_row(
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,
80: p_party_rec IN party_rec_type,

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

81: x_party_rec OUT NOCOPY party_rec_type);
82:
83: PROCEDURE insert_row(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_party_tbl IN party_tbl_type,

Line 94: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

90: x_party_tbl OUT NOCOPY party_tbl_type);
91:
92: PROCEDURE update_row(
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_party_rec IN party_rec_type,

Line 103: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

99: x_party_rec OUT NOCOPY party_rec_type);
100:
101: PROCEDURE update_row(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_party_tbl IN party_tbl_type,

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

110:
111:
112: PROCEDURE delete_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_party_rec IN party_rec_type);

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

118: p_party_rec IN party_rec_type);
119:
120: PROCEDURE delete_row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_party_tbl IN party_tbl_type);

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

127:
128:
129: PROCEDURE lock_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_party_rec IN party_rec_type);