3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cor_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: crt_id NUMBER := OKC_API.G_MISS_NUM,
9: change_sequence NUMBER := OKC_API.G_MISS_NUM,
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 cor_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: crt_id NUMBER := OKC_API.G_MISS_NUM,
9: change_sequence NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE cor_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: crt_id NUMBER := OKC_API.G_MISS_NUM,
9: change_sequence NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE cor_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: crt_id NUMBER := OKC_API.G_MISS_NUM,
9: change_sequence NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: crt_id NUMBER := OKC_API.G_MISS_NUM,
9: change_sequence NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
8: crt_id NUMBER := OKC_API.G_MISS_NUM,
9: change_sequence NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
9: change_sequence NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%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_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
12: creation_date OKC_CHANGES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
14: last_update_date OKC_CHANGES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
15: datetime_ineffective OKC_CHANGES_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
17: attribute_category OKC_CHANGES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
18: attribute1 OKC_CHANGES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
19: attribute2 OKC_CHANGES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
20: attribute3 OKC_CHANGES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
21: attribute4 OKC_CHANGES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKC_CHANGES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
22: attribute5 OKC_CHANGES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKC_CHANGES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKC_CHANGES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
23: attribute6 OKC_CHANGES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKC_CHANGES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKC_CHANGES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKC_CHANGES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
24: attribute7 OKC_CHANGES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKC_CHANGES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKC_CHANGES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKC_CHANGES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKC_CHANGES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
25: attribute8 OKC_CHANGES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKC_CHANGES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKC_CHANGES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKC_CHANGES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKC_CHANGES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
33: g_miss_cor_rec cor_rec_type;
26: attribute9 OKC_CHANGES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKC_CHANGES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKC_CHANGES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKC_CHANGES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKC_CHANGES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
33: g_miss_cor_rec cor_rec_type;
34: TYPE cor_tbl_type IS TABLE OF cor_rec_type
27: attribute10 OKC_CHANGES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKC_CHANGES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKC_CHANGES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKC_CHANGES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKC_CHANGES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
33: g_miss_cor_rec cor_rec_type;
34: TYPE cor_tbl_type IS TABLE OF cor_rec_type
35: INDEX BY BINARY_INTEGER;
28: attribute11 OKC_CHANGES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute12 OKC_CHANGES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute13 OKC_CHANGES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute14 OKC_CHANGES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute15 OKC_CHANGES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
33: g_miss_cor_rec cor_rec_type;
34: TYPE cor_tbl_type IS TABLE OF cor_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE okc_changes_tl_rec_type IS RECORD (
33: g_miss_cor_rec cor_rec_type;
34: TYPE cor_tbl_type IS TABLE OF cor_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE okc_changes_tl_rec_type IS RECORD (
37: id NUMBER := OKC_API.G_MISS_NUM,
38: language OKC_CHANGES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_CHANGES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_CHANGES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
34: TYPE cor_tbl_type IS TABLE OF cor_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE okc_changes_tl_rec_type IS RECORD (
37: id NUMBER := OKC_API.G_MISS_NUM,
38: language OKC_CHANGES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_CHANGES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_CHANGES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
35: INDEX BY BINARY_INTEGER;
36: TYPE okc_changes_tl_rec_type IS RECORD (
37: id NUMBER := OKC_API.G_MISS_NUM,
38: language OKC_CHANGES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_CHANGES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_CHANGES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
36: TYPE okc_changes_tl_rec_type IS RECORD (
37: id NUMBER := OKC_API.G_MISS_NUM,
38: language OKC_CHANGES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_CHANGES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_CHANGES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_CHANGES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: id NUMBER := OKC_API.G_MISS_NUM,
38: language OKC_CHANGES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_CHANGES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_CHANGES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_CHANGES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: language OKC_CHANGES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
39: source_lang OKC_CHANGES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_CHANGES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_CHANGES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_CHANGES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: source_lang OKC_CHANGES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
40: sfwt_flag OKC_CHANGES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_CHANGES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_CHANGES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
40: sfwt_flag OKC_CHANGES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_CHANGES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_CHANGES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
48: g_miss_okc_changes_tl_rec okc_changes_tl_rec_type;
41: short_description OKC_CHANGES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_CHANGES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_CHANGES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
48: g_miss_okc_changes_tl_rec okc_changes_tl_rec_type;
49: TYPE okc_changes_tl_tbl_type IS TABLE OF okc_changes_tl_rec_type
42: change_text OKC_CHANGES_TL.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_CHANGES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_CHANGES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
48: g_miss_okc_changes_tl_rec okc_changes_tl_rec_type;
49: TYPE okc_changes_tl_tbl_type IS TABLE OF okc_changes_tl_rec_type
50: INDEX BY BINARY_INTEGER;
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_CHANGES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_CHANGES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
48: g_miss_okc_changes_tl_rec okc_changes_tl_rec_type;
49: TYPE okc_changes_tl_tbl_type IS TABLE OF okc_changes_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE corv_rec_type IS RECORD (
48: g_miss_okc_changes_tl_rec okc_changes_tl_rec_type;
49: TYPE okc_changes_tl_tbl_type IS TABLE OF okc_changes_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE corv_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKC_CHANGES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: crt_id NUMBER := OKC_API.G_MISS_NUM,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
49: TYPE okc_changes_tl_tbl_type IS TABLE OF okc_changes_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE corv_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKC_CHANGES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: crt_id NUMBER := OKC_API.G_MISS_NUM,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
50: INDEX BY BINARY_INTEGER;
51: TYPE corv_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKC_CHANGES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: crt_id NUMBER := OKC_API.G_MISS_NUM,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: TYPE corv_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKC_CHANGES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: crt_id NUMBER := OKC_API.G_MISS_NUM,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKC_CHANGES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: crt_id NUMBER := OKC_API.G_MISS_NUM,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKC_CHANGES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: crt_id NUMBER := OKC_API.G_MISS_NUM,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
54: sfwt_flag OKC_CHANGES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: crt_id NUMBER := OKC_API.G_MISS_NUM,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
55: crt_id NUMBER := OKC_API.G_MISS_NUM,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
56: change_sequence NUMBER := OKC_API.G_MISS_NUM,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
57: change_text OKC_CHANGES_V.CHANGE_TEXT%TYPE,-- := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
58: short_description OKC_CHANGES_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
59: attribute_category OKC_CHANGES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
60: attribute1 OKC_CHANGES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
61: attribute2 OKC_CHANGES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
62: attribute3 OKC_CHANGES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
63: attribute4 OKC_CHANGES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
64: attribute5 OKC_CHANGES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
65: attribute6 OKC_CHANGES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
66: attribute7 OKC_CHANGES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
67: attribute8 OKC_CHANGES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
75: created_by NUMBER := OKC_API.G_MISS_NUM,
68: attribute9 OKC_CHANGES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
75: created_by NUMBER := OKC_API.G_MISS_NUM,
76: creation_date OKC_CHANGES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
69: attribute10 OKC_CHANGES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
75: created_by NUMBER := OKC_API.G_MISS_NUM,
76: creation_date OKC_CHANGES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
77: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
70: attribute11 OKC_CHANGES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
75: created_by NUMBER := OKC_API.G_MISS_NUM,
76: creation_date OKC_CHANGES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
77: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
78: last_update_date OKC_CHANGES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
71: attribute12 OKC_CHANGES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
75: created_by NUMBER := OKC_API.G_MISS_NUM,
76: creation_date OKC_CHANGES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
77: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
78: last_update_date OKC_CHANGES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_update_login NUMBER := OKC_API.G_MISS_NUM);
72: attribute13 OKC_CHANGES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
75: created_by NUMBER := OKC_API.G_MISS_NUM,
76: creation_date OKC_CHANGES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
77: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
78: last_update_date OKC_CHANGES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_update_login NUMBER := OKC_API.G_MISS_NUM);
80: g_miss_corv_rec corv_rec_type;
73: attribute14 OKC_CHANGES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
75: created_by NUMBER := OKC_API.G_MISS_NUM,
76: creation_date OKC_CHANGES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
77: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
78: last_update_date OKC_CHANGES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_update_login NUMBER := OKC_API.G_MISS_NUM);
80: g_miss_corv_rec corv_rec_type;
81: TYPE corv_tbl_type IS TABLE OF corv_rec_type
74: attribute15 OKC_CHANGES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
75: created_by NUMBER := OKC_API.G_MISS_NUM,
76: creation_date OKC_CHANGES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
77: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
78: last_update_date OKC_CHANGES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_update_login NUMBER := OKC_API.G_MISS_NUM);
80: g_miss_corv_rec corv_rec_type;
81: TYPE corv_tbl_type IS TABLE OF corv_rec_type
82: INDEX BY BINARY_INTEGER;
75: created_by NUMBER := OKC_API.G_MISS_NUM,
76: creation_date OKC_CHANGES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
77: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
78: last_update_date OKC_CHANGES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
79: last_update_login NUMBER := OKC_API.G_MISS_NUM);
80: g_miss_corv_rec corv_rec_type;
81: TYPE corv_tbl_type IS TABLE OF corv_rec_type
82: INDEX BY BINARY_INTEGER;
83: ---------------------------------------------------------------------------
82: INDEX BY BINARY_INTEGER;
83: ---------------------------------------------------------------------------
84: -- GLOBAL MESSAGE CONSTANTS
85: ---------------------------------------------------------------------------
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83: ---------------------------------------------------------------------------
84: -- GLOBAL MESSAGE CONSTANTS
85: ---------------------------------------------------------------------------
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84: -- GLOBAL MESSAGE CONSTANTS
85: ---------------------------------------------------------------------------
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85: ---------------------------------------------------------------------------
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: ---------------------------------------------------------------------------
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
98: ---------------------------------------------------------------------------
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
98: ---------------------------------------------------------------------------
99: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COR_PVT';
96: ---------------------------------------------------------------------------
97: -- GLOBAL VARIABLES
98: ---------------------------------------------------------------------------
99: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COR_PVT';
100: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
101: ---------------------------------------------------------------------------
102: -- Procedures and Functions
103: ---------------------------------------------------------------------------
104:
107: PROCEDURE api_copy;
108: PROCEDURE add_language;
109: PROCEDURE insert_row(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_corv_rec IN corv_rec_type,
116: x_corv_rec OUT NOCOPY corv_rec_type);
117:
118: PROCEDURE insert_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_corv_tbl IN corv_tbl_type,
125: x_corv_tbl OUT NOCOPY corv_tbl_type);
126:
127: PROCEDURE lock_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_corv_rec IN corv_rec_type);
133: p_corv_rec IN corv_rec_type);
134:
135: PROCEDURE lock_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_corv_tbl IN corv_tbl_type);
141: p_corv_tbl IN corv_tbl_type);
142:
143: PROCEDURE update_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_corv_rec IN corv_rec_type,
150: x_corv_rec OUT NOCOPY corv_rec_type);
151:
152: PROCEDURE update_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_corv_tbl IN corv_tbl_type,
159: x_corv_tbl OUT NOCOPY corv_tbl_type);
160:
161: PROCEDURE delete_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_corv_rec IN corv_rec_type);
167: p_corv_rec IN corv_rec_type);
168:
169: PROCEDURE delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_corv_tbl IN corv_tbl_type);
175: p_corv_tbl IN corv_tbl_type);
176:
177: PROCEDURE validate_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_corv_rec IN corv_rec_type);
183: p_corv_rec IN corv_rec_type);
184:
185: PROCEDURE validate_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_corv_tbl IN corv_tbl_type);