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,
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
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
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,
112: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
113: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
114: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
115: );
116:
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_cle_id IN NUMBER,
112: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
113: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
114: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
115: );
116:
117:
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_cle_id IN NUMBER,
112: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
113: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
114: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
115: );
116:
117:
118:
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,
128: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
129: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
130: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
131: );
132:
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_chr_id IN NUMBER,
128: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
129: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
130: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
131: );
132:
133:
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_chr_id IN NUMBER,
128: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
129: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
130: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
131: );
132:
133:
134: PROCEDURE delete_row(