3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cgp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cgp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE cgp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE cgp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
8: public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
11: creation_date OKC_K_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
13: last_update_date OKC_K_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
14: user_id NUMBER := OKC_API.G_MISS_NUM,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
16: attribute_category OKC_K_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
17: attribute1 OKC_K_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
18: attribute2 OKC_K_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
19: attribute3 OKC_K_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
20: attribute4 OKC_K_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
21: attribute5 OKC_K_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_K_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
22: attribute6 OKC_K_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_K_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_K_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
23: attribute7 OKC_K_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_K_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_K_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_K_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
24: attribute8 OKC_K_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_K_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_K_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_K_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32: g_miss_cgp_rec cgp_rec_type;
25: attribute9 OKC_K_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_K_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_K_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_K_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32: g_miss_cgp_rec cgp_rec_type;
33: TYPE cgp_tbl_type IS TABLE OF cgp_rec_type
26: attribute10 OKC_K_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_K_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_K_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_K_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32: g_miss_cgp_rec cgp_rec_type;
33: TYPE cgp_tbl_type IS TABLE OF cgp_rec_type
34: INDEX BY BINARY_INTEGER;
27: attribute11 OKC_K_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
28: attribute12 OKC_K_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
29: attribute13 OKC_K_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
30: attribute14 OKC_K_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
31: attribute15 OKC_K_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
32: g_miss_cgp_rec cgp_rec_type;
33: TYPE cgp_tbl_type IS TABLE OF cgp_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE OkcContractGroupsTlRecType IS RECORD (
32: g_miss_cgp_rec cgp_rec_type;
33: TYPE cgp_tbl_type IS TABLE OF cgp_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE OkcContractGroupsTlRecType IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM,
37: language OKC_K_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
38: source_lang OKC_K_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
39: sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
33: TYPE cgp_tbl_type IS TABLE OF cgp_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE OkcContractGroupsTlRecType IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM,
37: language OKC_K_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
38: source_lang OKC_K_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
39: sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
34: INDEX BY BINARY_INTEGER;
35: TYPE OkcContractGroupsTlRecType IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM,
37: language OKC_K_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
38: source_lang OKC_K_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
39: sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
35: TYPE OkcContractGroupsTlRecType IS RECORD (
36: id NUMBER := OKC_API.G_MISS_NUM,
37: language OKC_K_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
38: source_lang OKC_K_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
39: sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
36: id NUMBER := OKC_API.G_MISS_NUM,
37: language OKC_K_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
38: source_lang OKC_K_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
39: sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
37: language OKC_K_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
38: source_lang OKC_K_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
39: sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: source_lang OKC_K_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
39: sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
39: sfwt_flag OKC_K_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: GMissOkcContractGroupsTlRec OkcContractGroupsTlRecType;
40: name OKC_K_GROUPS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: GMissOkcContractGroupsTlRec OkcContractGroupsTlRecType;
48: TYPE OkcContractGroupsTlTblType IS TABLE OF OkcContractGroupsTlRecType
41: short_description OKC_K_GROUPS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: GMissOkcContractGroupsTlRec OkcContractGroupsTlRecType;
48: TYPE OkcContractGroupsTlTblType IS TABLE OF OkcContractGroupsTlRecType
49: INDEX BY BINARY_INTEGER;
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_K_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_K_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM);
47: GMissOkcContractGroupsTlRec OkcContractGroupsTlRecType;
48: TYPE OkcContractGroupsTlTblType IS TABLE OF OkcContractGroupsTlRecType
49: INDEX BY BINARY_INTEGER;
50: TYPE cgpv_rec_type IS RECORD (
47: GMissOkcContractGroupsTlRec OkcContractGroupsTlRecType;
48: TYPE OkcContractGroupsTlTblType IS TABLE OF OkcContractGroupsTlRecType
49: INDEX BY BINARY_INTEGER;
50: TYPE cgpv_rec_type IS RECORD (
51: id NUMBER := OKC_API.G_MISS_NUM,
52: object_version_number NUMBER := OKC_API.G_MISS_NUM,
53: sfwt_flag OKC_K_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54: name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
48: TYPE OkcContractGroupsTlTblType IS TABLE OF OkcContractGroupsTlRecType
49: INDEX BY BINARY_INTEGER;
50: TYPE cgpv_rec_type IS RECORD (
51: id NUMBER := OKC_API.G_MISS_NUM,
52: object_version_number NUMBER := OKC_API.G_MISS_NUM,
53: sfwt_flag OKC_K_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54: name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: INDEX BY BINARY_INTEGER;
50: TYPE cgpv_rec_type IS RECORD (
51: id NUMBER := OKC_API.G_MISS_NUM,
52: object_version_number NUMBER := OKC_API.G_MISS_NUM,
53: sfwt_flag OKC_K_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54: name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: TYPE cgpv_rec_type IS RECORD (
51: id NUMBER := OKC_API.G_MISS_NUM,
52: object_version_number NUMBER := OKC_API.G_MISS_NUM,
53: sfwt_flag OKC_K_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54: name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: id NUMBER := OKC_API.G_MISS_NUM,
52: object_version_number NUMBER := OKC_API.G_MISS_NUM,
53: sfwt_flag OKC_K_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54: name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: object_version_number NUMBER := OKC_API.G_MISS_NUM,
53: sfwt_flag OKC_K_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54: name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: sfwt_flag OKC_K_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54: name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: name OKC_K_GROUPS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: public_yn OKC_K_GROUPS_V.PUBLIC_YN%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_K_GROUPS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute_category OKC_K_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute1 OKC_K_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute2 OKC_K_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute3 OKC_K_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute4 OKC_K_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute5 OKC_K_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63: attribute6 OKC_K_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
64: attribute7 OKC_K_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
65: attribute8 OKC_K_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
66: attribute9 OKC_K_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: attribute10 OKC_K_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: attribute11 OKC_K_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKC_K_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: attribute12 OKC_K_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKC_K_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: user_id NUMBER := OKC_API.G_MISS_NUM,
70: attribute13 OKC_K_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKC_K_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: user_id NUMBER := OKC_API.G_MISS_NUM,
78: last_update_login NUMBER := OKC_API.G_MISS_NUM);
71: attribute14 OKC_K_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKC_K_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: user_id NUMBER := OKC_API.G_MISS_NUM,
78: last_update_login NUMBER := OKC_API.G_MISS_NUM);
79: g_miss_cgpv_rec cgpv_rec_type;
72: attribute15 OKC_K_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKC_K_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: user_id NUMBER := OKC_API.G_MISS_NUM,
78: last_update_login NUMBER := OKC_API.G_MISS_NUM);
79: g_miss_cgpv_rec cgpv_rec_type;
80: TYPE cgpv_tbl_type IS TABLE OF cgpv_rec_type
73: created_by NUMBER := OKC_API.G_MISS_NUM,
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKC_K_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: user_id NUMBER := OKC_API.G_MISS_NUM,
78: last_update_login NUMBER := OKC_API.G_MISS_NUM);
79: g_miss_cgpv_rec cgpv_rec_type;
80: TYPE cgpv_tbl_type IS TABLE OF cgpv_rec_type
81: INDEX BY BINARY_INTEGER;
74: creation_date OKC_K_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
75: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
76: last_update_date OKC_K_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
77: user_id NUMBER := OKC_API.G_MISS_NUM,
78: last_update_login NUMBER := OKC_API.G_MISS_NUM);
79: g_miss_cgpv_rec cgpv_rec_type;
80: TYPE cgpv_tbl_type IS TABLE OF cgpv_rec_type
81: INDEX BY BINARY_INTEGER;
82: --
90:
91: ---------------------------------------------------------------------------
92: -- GLOBAL MESSAGE CONSTANTS
93: ---------------------------------------------------------------------------
94: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: ---------------------------------------------------------------------------
92: -- GLOBAL MESSAGE CONSTANTS
93: ---------------------------------------------------------------------------
94: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: -- GLOBAL MESSAGE CONSTANTS
93: ---------------------------------------------------------------------------
94: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: ---------------------------------------------------------------------------
94: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
104: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
97: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
104: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
105: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
98: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
104: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
105: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
99: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
104: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
105: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
113: -- GLOBAL VARIABLES
114: ---------------------------------------------------------------------------
115: G_VIEW_NAME CONSTANT VARCHAR2(200) := 'OKC_K_GROUPS_V';
116: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CGP_PVT';
117: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
118: ---------------------------------------------------------------------------
119: -- Procedures and Functions
120: ---------------------------------------------------------------------------
121:
124: PROCEDURE api_copy;
125: PROCEDURE add_language;
126: PROCEDURE insert_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_cgpv_rec IN cgpv_rec_type,
133: x_cgpv_rec OUT NOCOPY cgpv_rec_type);
134:
135: PROCEDURE insert_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_cgpv_tbl IN cgpv_tbl_type,
142: x_cgpv_tbl OUT NOCOPY cgpv_tbl_type);
143:
144: PROCEDURE lock_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_cgpv_rec IN cgpv_rec_type);
150: p_cgpv_rec IN cgpv_rec_type);
151:
152: PROCEDURE lock_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_cgpv_tbl IN cgpv_tbl_type);
158: p_cgpv_tbl IN cgpv_tbl_type);
159:
160: PROCEDURE update_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_cgpv_rec IN cgpv_rec_type,
167: x_cgpv_rec OUT NOCOPY cgpv_rec_type);
168:
169: PROCEDURE update_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_cgpv_tbl IN cgpv_tbl_type,
176: x_cgpv_tbl OUT NOCOPY cgpv_tbl_type);
177:
178: PROCEDURE delete_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_cgpv_rec IN cgpv_rec_type);
184: p_cgpv_rec IN cgpv_rec_type);
185:
186: PROCEDURE delete_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_cgpv_tbl IN cgpv_tbl_type);
192: p_cgpv_tbl IN cgpv_tbl_type);
193:
194: PROCEDURE validate_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_cgpv_rec IN cgpv_rec_type);
200: p_cgpv_rec IN cgpv_rec_type);
201:
202: PROCEDURE validate_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_cgpv_tbl IN cgpv_tbl_type);