3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sav_rec_type IS RECORD (
7: sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
8: sae_id NUMBER := OKC_API.G_MISS_NUM,
9: date_active OKC_STD_ART_VERSIONS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE sav_rec_type IS RECORD (
7: sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
8: sae_id NUMBER := OKC_API.G_MISS_NUM,
9: date_active OKC_STD_ART_VERSIONS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE sav_rec_type IS RECORD (
7: sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
8: sae_id NUMBER := OKC_API.G_MISS_NUM,
9: date_active OKC_STD_ART_VERSIONS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE sav_rec_type IS RECORD (
7: sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
8: sae_id NUMBER := OKC_API.G_MISS_NUM,
9: date_active OKC_STD_ART_VERSIONS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
7: sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
8: sae_id NUMBER := OKC_API.G_MISS_NUM,
9: date_active OKC_STD_ART_VERSIONS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
8: sae_id NUMBER := OKC_API.G_MISS_NUM,
9: date_active OKC_STD_ART_VERSIONS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
9: date_active OKC_STD_ART_VERSIONS_B.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
12: creation_date OKC_STD_ART_VERSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
14: last_update_date OKC_STD_ART_VERSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKC_STD_ART_VERSIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_STD_ART_VERSIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_STD_ART_VERSIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_STD_ART_VERSIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_STD_ART_VERSIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_STD_ART_VERSIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_STD_ART_VERSIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_STD_ART_VERSIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_STD_ART_VERSIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_STD_ART_VERSIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_STD_ART_VERSIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_STD_ART_VERSIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_STD_ART_VERSIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_STD_ART_VERSIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
24: attribute8 OKC_STD_ART_VERSIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_STD_ART_VERSIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_STD_ART_VERSIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_STD_ART_VERSIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32: g_miss_sav_rec sav_rec_type;
25: attribute9 OKC_STD_ART_VERSIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_STD_ART_VERSIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_STD_ART_VERSIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_STD_ART_VERSIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32: g_miss_sav_rec sav_rec_type;
33: TYPE sav_tbl_type IS TABLE OF sav_rec_type
26: attribute10 OKC_STD_ART_VERSIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_STD_ART_VERSIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_STD_ART_VERSIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_STD_ART_VERSIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32: g_miss_sav_rec sav_rec_type;
33: TYPE sav_tbl_type IS TABLE OF sav_rec_type
34: INDEX BY BINARY_INTEGER;
27: attribute11 OKC_STD_ART_VERSIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_STD_ART_VERSIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_STD_ART_VERSIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_STD_ART_VERSIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_STD_ART_VERSIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32: g_miss_sav_rec sav_rec_type;
33: TYPE sav_tbl_type IS TABLE OF sav_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE OkcStdArtVersionsTlRecType IS RECORD (
32: g_miss_sav_rec sav_rec_type;
33: TYPE sav_tbl_type IS TABLE OF sav_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE OkcStdArtVersionsTlRecType IS RECORD (
36: sae_id NUMBER := OKC_API.G_MISS_NUM,
37: sav_release OKC_STD_ART_VERSIONS_TL.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
38: language OKC_STD_ART_VERSIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: TYPE sav_tbl_type IS TABLE OF sav_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE OkcStdArtVersionsTlRecType IS RECORD (
36: sae_id NUMBER := OKC_API.G_MISS_NUM,
37: sav_release OKC_STD_ART_VERSIONS_TL.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
38: language OKC_STD_ART_VERSIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
34: INDEX BY BINARY_INTEGER;
35: TYPE OkcStdArtVersionsTlRecType IS RECORD (
36: sae_id NUMBER := OKC_API.G_MISS_NUM,
37: sav_release OKC_STD_ART_VERSIONS_TL.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
38: language OKC_STD_ART_VERSIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
35: TYPE OkcStdArtVersionsTlRecType IS RECORD (
36: sae_id NUMBER := OKC_API.G_MISS_NUM,
37: sav_release OKC_STD_ART_VERSIONS_TL.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
38: language OKC_STD_ART_VERSIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
36: sae_id NUMBER := OKC_API.G_MISS_NUM,
37: sav_release OKC_STD_ART_VERSIONS_TL.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
38: language OKC_STD_ART_VERSIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
37: sav_release OKC_STD_ART_VERSIONS_TL.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
38: language OKC_STD_ART_VERSIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_STD_ART_VERSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: language OKC_STD_ART_VERSIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_STD_ART_VERSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: text OKC_STD_ART_VERSIONS_TL.TEXT%TYPE ,
39: source_lang OKC_STD_ART_VERSIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_STD_ART_VERSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: text OKC_STD_ART_VERSIONS_TL.TEXT%TYPE ,
47: short_description OKC_STD_ART_VERSIONS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_STD_ART_VERSIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_STD_ART_VERSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: text OKC_STD_ART_VERSIONS_TL.TEXT%TYPE ,
47: short_description OKC_STD_ART_VERSIONS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
41: object_version_number NUMBER := OKC_API.G_MISS_NUM,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_STD_ART_VERSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: text OKC_STD_ART_VERSIONS_TL.TEXT%TYPE ,
47: short_description OKC_STD_ART_VERSIONS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: GMissOkcStdArtVersionsTlRec OkcStdArtVersionsTlRecType;
43: creation_date OKC_STD_ART_VERSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_STD_ART_VERSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: text OKC_STD_ART_VERSIONS_TL.TEXT%TYPE ,
47: short_description OKC_STD_ART_VERSIONS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: GMissOkcStdArtVersionsTlRec OkcStdArtVersionsTlRecType;
50: TYPE OkcStdArtVersionsTlTblType IS TABLE OF OkcStdArtVersionsTlRecType
51: INDEX BY BINARY_INTEGER;
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_STD_ART_VERSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: text OKC_STD_ART_VERSIONS_TL.TEXT%TYPE ,
47: short_description OKC_STD_ART_VERSIONS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: GMissOkcStdArtVersionsTlRec OkcStdArtVersionsTlRecType;
50: TYPE OkcStdArtVersionsTlTblType IS TABLE OF OkcStdArtVersionsTlRecType
51: INDEX BY BINARY_INTEGER;
52: TYPE savv_rec_type IS RECORD (
49: GMissOkcStdArtVersionsTlRec OkcStdArtVersionsTlRecType;
50: TYPE OkcStdArtVersionsTlTblType IS TABLE OF OkcStdArtVersionsTlRecType
51: INDEX BY BINARY_INTEGER;
52: TYPE savv_rec_type IS RECORD (
53: sae_id NUMBER := OKC_API.G_MISS_NUM,
54: sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_STD_ART_VERSIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
50: TYPE OkcStdArtVersionsTlTblType IS TABLE OF OkcStdArtVersionsTlRecType
51: INDEX BY BINARY_INTEGER;
52: TYPE savv_rec_type IS RECORD (
53: sae_id NUMBER := OKC_API.G_MISS_NUM,
54: sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_STD_ART_VERSIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
58: text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
51: INDEX BY BINARY_INTEGER;
52: TYPE savv_rec_type IS RECORD (
53: sae_id NUMBER := OKC_API.G_MISS_NUM,
54: sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_STD_ART_VERSIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
58: text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
59: short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
52: TYPE savv_rec_type IS RECORD (
53: sae_id NUMBER := OKC_API.G_MISS_NUM,
54: sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_STD_ART_VERSIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
58: text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
59: short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
60: attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: sae_id NUMBER := OKC_API.G_MISS_NUM,
54: sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_STD_ART_VERSIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
58: text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
59: short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
60: attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55: object_version_number NUMBER := OKC_API.G_MISS_NUM,
56: sfwt_flag OKC_STD_ART_VERSIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
58: text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
59: short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
60: attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: sfwt_flag OKC_STD_ART_VERSIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57: date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
58: text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
59: short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
60: attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: date_active OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
58: text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
59: short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
60: attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: text OKC_STD_ART_VERSIONS_V.TEXT%TYPE ,
59: short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
60: attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: short_description OKC_STD_ART_VERSIONS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
60: attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute_category OKC_STD_ART_VERSIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_STD_ART_VERSIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_STD_ART_VERSIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_STD_ART_VERSIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_STD_ART_VERSIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_STD_ART_VERSIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_STD_ART_VERSIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_STD_ART_VERSIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_STD_ART_VERSIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
69: attribute9 OKC_STD_ART_VERSIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: attribute10 OKC_STD_ART_VERSIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: attribute11 OKC_STD_ART_VERSIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_STD_ART_VERSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: attribute12 OKC_STD_ART_VERSIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_STD_ART_VERSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: attribute13 OKC_STD_ART_VERSIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_STD_ART_VERSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: g_miss_savv_rec savv_rec_type;
74: attribute14 OKC_STD_ART_VERSIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_STD_ART_VERSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: g_miss_savv_rec savv_rec_type;
82: TYPE savv_tbl_type IS TABLE OF savv_rec_type
75: attribute15 OKC_STD_ART_VERSIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_STD_ART_VERSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: g_miss_savv_rec savv_rec_type;
82: TYPE savv_tbl_type IS TABLE OF savv_rec_type
83: INDEX BY BINARY_INTEGER;
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_STD_ART_VERSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_STD_ART_VERSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: g_miss_savv_rec savv_rec_type;
82: TYPE savv_tbl_type IS TABLE OF savv_rec_type
83: INDEX BY BINARY_INTEGER;
84: ---------------------------------------------------------------------------
83: INDEX BY BINARY_INTEGER;
84: ---------------------------------------------------------------------------
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: ---------------------------------------------------------------------------
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: ---------------------------------------------------------------------------
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: ---------------------------------------------------------------------------
98: -- GLOBAL VARIABLES
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: ---------------------------------------------------------------------------
98: -- GLOBAL VARIABLES
99: ---------------------------------------------------------------------------
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: ---------------------------------------------------------------------------
98: -- GLOBAL VARIABLES
99: ---------------------------------------------------------------------------
100: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SAV_PVT';
97: ---------------------------------------------------------------------------
98: -- GLOBAL VARIABLES
99: ---------------------------------------------------------------------------
100: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SAV_PVT';
101: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
102:
103: /******************ADDED AFTER TAPI****************/
104: --GLOBAL MESSAGES
105:
147: PROCEDURE api_copy;
148: PROCEDURE add_language;
149: PROCEDURE insert_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_savv_rec IN savv_rec_type,
156: x_savv_rec OUT NOCOPY savv_rec_type);
157:
158: PROCEDURE insert_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_savv_tbl IN savv_tbl_type,
165: x_savv_tbl OUT NOCOPY savv_tbl_type);
166:
167: PROCEDURE lock_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_savv_rec IN savv_rec_type);
173: p_savv_rec IN savv_rec_type);
174:
175: PROCEDURE lock_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_savv_tbl IN savv_tbl_type);
181: p_savv_tbl IN savv_tbl_type);
182:
183: PROCEDURE update_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_savv_rec IN savv_rec_type,
190: x_savv_rec OUT NOCOPY savv_rec_type);
191:
192: PROCEDURE update_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_savv_tbl IN savv_tbl_type,
199: x_savv_tbl OUT NOCOPY savv_tbl_type);
200:
201: PROCEDURE delete_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_savv_rec IN savv_rec_type);
207: p_savv_rec IN savv_rec_type);
208:
209: PROCEDURE delete_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_savv_tbl IN savv_tbl_type);
215: p_savv_tbl IN savv_tbl_type);
216:
217: PROCEDURE validate_row(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_savv_rec IN savv_rec_type);
223: p_savv_rec IN savv_rec_type);
224:
225: PROCEDURE validate_row(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_savv_tbl IN savv_tbl_type);