3: -- GLOBAL DATA STRUCTURES
4:
5: TYPE note_rec_type IS RECORD(
6:
7: STANDARD_NOTES_ID NUMBER:= OKE_API.G_MISS_NUM,
8: CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
9: CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
10: LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
11: LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
12: LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
13: K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
14: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
15: DELIVERABLE_ID NUMBER:= OKE_API.G_MISS_NUM,
16: TYPE_CODE OKE_K_STANDARD_NOTES_B.TYPE_CODE%TYPE:=OKE_API.G_MISS_CHAR,
17: ATTRIBUTE_CATEGORY OKE_K_STANDARD_NOTES_B.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_STANDARD_NOTES_B.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
13: K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
14: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
15: DELIVERABLE_ID NUMBER:= OKE_API.G_MISS_NUM,
16: TYPE_CODE OKE_K_STANDARD_NOTES_B.TYPE_CODE%TYPE:=OKE_API.G_MISS_CHAR,
17: ATTRIBUTE_CATEGORY OKE_K_STANDARD_NOTES_B.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_STANDARD_NOTES_B.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
14: K_LINE_ID NUMBER:= OKE_API.G_MISS_NUM,
15: DELIVERABLE_ID NUMBER:= OKE_API.G_MISS_NUM,
16: TYPE_CODE OKE_K_STANDARD_NOTES_B.TYPE_CODE%TYPE:=OKE_API.G_MISS_CHAR,
17: ATTRIBUTE_CATEGORY OKE_K_STANDARD_NOTES_B.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_STANDARD_NOTES_B.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
15: DELIVERABLE_ID NUMBER:= OKE_API.G_MISS_NUM,
16: TYPE_CODE OKE_K_STANDARD_NOTES_B.TYPE_CODE%TYPE:=OKE_API.G_MISS_CHAR,
17: ATTRIBUTE_CATEGORY OKE_K_STANDARD_NOTES_B.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_STANDARD_NOTES_B.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
16: TYPE_CODE OKE_K_STANDARD_NOTES_B.TYPE_CODE%TYPE:=OKE_API.G_MISS_CHAR,
17: ATTRIBUTE_CATEGORY OKE_K_STANDARD_NOTES_B.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_STANDARD_NOTES_B.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
17: ATTRIBUTE_CATEGORY OKE_K_STANDARD_NOTES_B.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_STANDARD_NOTES_B.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
18: ATTRIBUTE1 OKE_K_STANDARD_NOTES_B.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
19: ATTRIBUTE2 OKE_K_STANDARD_NOTES_B.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
20: ATTRIBUTE3 OKE_K_STANDARD_NOTES_B.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
21: ATTRIBUTE4 OKE_K_STANDARD_NOTES_B.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
22: ATTRIBUTE5 OKE_K_STANDARD_NOTES_B.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
23: ATTRIBUTE6 OKE_K_STANDARD_NOTES_B.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
24: ATTRIBUTE7 OKE_K_STANDARD_NOTES_B.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
25: ATTRIBUTE8 OKE_K_STANDARD_NOTES_B.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
33:
26: ATTRIBUTE9 OKE_K_STANDARD_NOTES_B.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
33:
34: SFWT_FLAG OKE_K_STANDARD_NOTES_TL.SFWT_FLAG%TYPE := 'N',
27: ATTRIBUTE10 OKE_K_STANDARD_NOTES_B.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
33:
34: SFWT_FLAG OKE_K_STANDARD_NOTES_TL.SFWT_FLAG%TYPE := 'N',
35: DESCRIPTION OKE_K_STANDARD_NOTES_TL.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
28: ATTRIBUTE11 OKE_K_STANDARD_NOTES_B.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
29: ATTRIBUTE12 OKE_K_STANDARD_NOTES_B.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
33:
34: SFWT_FLAG OKE_K_STANDARD_NOTES_TL.SFWT_FLAG%TYPE := 'N',
35: DESCRIPTION OKE_K_STANDARD_NOTES_TL.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
36: NAME OKE_K_STANDARD_NOTES_TL.NAME%TYPE:=OKE_API.G_MISS_CHAR,
30: ATTRIBUTE13 OKE_K_STANDARD_NOTES_B.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
31: ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
33:
34: SFWT_FLAG OKE_K_STANDARD_NOTES_TL.SFWT_FLAG%TYPE := 'N',
35: DESCRIPTION OKE_K_STANDARD_NOTES_TL.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
36: NAME OKE_K_STANDARD_NOTES_TL.NAME%TYPE:=OKE_API.G_MISS_CHAR,
37: TEXT OKE_K_STANDARD_NOTES_TL.TEXT%TYPE:=OKE_API.G_MISS_CHAR,
38:
31: ATTRIBUTE14 OKE_K_STANDARD_NOTES_B.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
32: ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
33:
34: SFWT_FLAG OKE_K_STANDARD_NOTES_TL.SFWT_FLAG%TYPE := 'N',
35: DESCRIPTION OKE_K_STANDARD_NOTES_TL.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
36: NAME OKE_K_STANDARD_NOTES_TL.NAME%TYPE:=OKE_API.G_MISS_CHAR,
37: TEXT OKE_K_STANDARD_NOTES_TL.TEXT%TYPE:=OKE_API.G_MISS_CHAR,
38:
39: default_flag OKE_K_STANDARD_NOTES_B.default_flag%TYPE:=OKE_API.G_MISS_CHAR
32: ATTRIBUTE15 OKE_K_STANDARD_NOTES_B.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR,
33:
34: SFWT_FLAG OKE_K_STANDARD_NOTES_TL.SFWT_FLAG%TYPE := 'N',
35: DESCRIPTION OKE_K_STANDARD_NOTES_TL.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
36: NAME OKE_K_STANDARD_NOTES_TL.NAME%TYPE:=OKE_API.G_MISS_CHAR,
37: TEXT OKE_K_STANDARD_NOTES_TL.TEXT%TYPE:=OKE_API.G_MISS_CHAR,
38:
39: default_flag OKE_K_STANDARD_NOTES_B.default_flag%TYPE:=OKE_API.G_MISS_CHAR
40:
33:
34: SFWT_FLAG OKE_K_STANDARD_NOTES_TL.SFWT_FLAG%TYPE := 'N',
35: DESCRIPTION OKE_K_STANDARD_NOTES_TL.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
36: NAME OKE_K_STANDARD_NOTES_TL.NAME%TYPE:=OKE_API.G_MISS_CHAR,
37: TEXT OKE_K_STANDARD_NOTES_TL.TEXT%TYPE:=OKE_API.G_MISS_CHAR,
38:
39: default_flag OKE_K_STANDARD_NOTES_B.default_flag%TYPE:=OKE_API.G_MISS_CHAR
40:
41: );
35: DESCRIPTION OKE_K_STANDARD_NOTES_TL.DESCRIPTION%TYPE:=OKE_API.G_MISS_CHAR,
36: NAME OKE_K_STANDARD_NOTES_TL.NAME%TYPE:=OKE_API.G_MISS_CHAR,
37: TEXT OKE_K_STANDARD_NOTES_TL.TEXT%TYPE:=OKE_API.G_MISS_CHAR,
38:
39: default_flag OKE_K_STANDARD_NOTES_B.default_flag%TYPE:=OKE_API.G_MISS_CHAR
40:
41: );
42:
43: TYPE note_tbl_type IS TABLE OF note_rec_type
65: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
66: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
67: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_NOTE_PVT';
68: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
69: G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_STANDARD_NOTES_VL';
70:
71: G_EXCEPTION_HALT_VALIDATION exception;
72:
73: -- Procedures and functions