DBA Data[Home] [Help]

APPS.OKE_TERM_PVT dependencies on OKE_API

Line 7: K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,

3: -- GLOBAL DATA STRUCTURES
4:
5: TYPE term_rec_type IS RECORD(
6:
7: K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
8: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
9: TERM_CODE OKE_K_TERMS.TERM_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,
11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,

Line 8: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,

4:
5: TYPE term_rec_type IS RECORD(
6:
7: K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
8: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
9: TERM_CODE OKE_K_TERMS.TERM_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,
11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,
12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,

Line 9: TERM_CODE OKE_K_TERMS.TERM_CODE%TYPE:=OKE_API.G_MISS_CHAR,

5: TYPE term_rec_type IS RECORD(
6:
7: K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
8: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
9: TERM_CODE OKE_K_TERMS.TERM_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,
11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,
12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,

Line 10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,

6:
7: K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
8: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
9: TERM_CODE OKE_K_TERMS.TERM_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,
11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,
12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,

Line 11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,

7: K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
8: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
9: TERM_CODE OKE_K_TERMS.TERM_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,
11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,
12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,

Line 12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,

8: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
9: TERM_CODE OKE_K_TERMS.TERM_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,
11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,
12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,

Line 13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,

9: TERM_CODE OKE_K_TERMS.TERM_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,
11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,
12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,

Line 14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,

10: TERM_VALUE_PK1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE:=OKE_API.G_MISS_CHAR,
11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,
12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,

Line 15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,

11: TERM_VALUE_PK2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE:=OKE_API.G_MISS_CHAR,
12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,

Line 16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,

12: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,

Line 17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,

13: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,

Line 18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,

14: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,

Line 19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,

15: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,

Line 20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,

16: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,

Line 21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,

17: ATTRIBUTE_CATEGORY OKE_K_TERMS.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,

Line 22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,

18: ATTRIBUTE1 OKE_K_TERMS.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,

Line 23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,

19: ATTRIBUTE2 OKE_K_TERMS.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,

Line 24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,

20: ATTRIBUTE3 OKE_K_TERMS.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,

Line 25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,

21: ATTRIBUTE4 OKE_K_TERMS.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,

Line 26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,

22: ATTRIBUTE5 OKE_K_TERMS.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_TERMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,

Line 27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,

23: ATTRIBUTE6 OKE_K_TERMS.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_TERMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_TERMS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,

Line 28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,

24: ATTRIBUTE7 OKE_K_TERMS.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_TERMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_TERMS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_TERMS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR

Line 29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,

25: ATTRIBUTE8 OKE_K_TERMS.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_TERMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_TERMS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_TERMS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
33:

Line 30: ATTRIBUTE13 OKE_K_TERMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,

26: ATTRIBUTE9 OKE_K_TERMS.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_TERMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_TERMS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_TERMS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
33:
34: );

Line 31: ATTRIBUTE14 OKE_K_TERMS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,

27: ATTRIBUTE10 OKE_K_TERMS.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_TERMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_TERMS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_TERMS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
33:
34: );
35:

Line 32: ATTRIBUTE15 OKE_K_TERMS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR

28: ATTRIBUTE11 OKE_K_TERMS.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_TERMS.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_TERMS.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_TERMS.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_TERMS.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
33:
34: );
35:
36: TYPE term_tbl_type IS TABLE OF term_rec_type

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

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: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
46:
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;

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: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
46:
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;

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

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: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
46:
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

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

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: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
46:
47: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
48: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
49: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
50: G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
51: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

52: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
53:
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
57: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
58: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
59:
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_TERM_PVT';

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

53:
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
57: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
58: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
59:
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_TERM_PVT';
61: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;

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

54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
57: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
58: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
59:
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_TERM_PVT';
61: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
62: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_TERMS_V';

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

57: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
58: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
59:
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_TERM_PVT';
61: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
62: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_TERMS_V';
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_term_rec IN term_rec_type,

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

75: x_term_rec OUT NOCOPY term_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_term_tbl IN term_tbl_type,

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

84: x_term_tbl OUT NOCOPY term_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_term_rec IN term_rec_type,

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

93: x_term_rec OUT NOCOPY term_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_term_tbl IN term_tbl_type,

Line 107: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

103:
104:
105: PROCEDURE delete_row(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_cle_id IN NUMBER,

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

119: /* note: does not cascade into lines */
120:
121: PROCEDURE delete_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_chr_id IN NUMBER,

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

132:
133:
134: PROCEDURE delete_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_term_rec IN term_rec_type);

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

140: p_term_rec IN term_rec_type);
141:
142: PROCEDURE delete_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_term_tbl IN term_tbl_type);

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

149:
150:
151: PROCEDURE validate_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_term_rec IN term_rec_type);

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

157: p_term_rec IN term_rec_type);
158:
159: PROCEDURE validate_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_term_tbl IN term_tbl_type);

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

165: p_term_tbl IN term_tbl_type);
166:
167: PROCEDURE lock_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_term_rec IN term_rec_type);