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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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:
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: );
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:
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
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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:
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';
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;
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';
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:
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,
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,
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,
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,
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,
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,
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);
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);
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);
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);
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);