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,
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);
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
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: --
83: -- TYPE id_tbl IS TABLE OF okc_k_groups_v.id%TYPE INDEX BY BINARY_INTEGER;
84: -- TYPE public_yn_tbl IS TABLE OF okc_k_groups_v.public_yn%TYPE INDEX BY BINARY_INTEGER;
85: -- TYPE name_tbl IS TABLE OF okc_k_groups_v.name%TYPE INDEX BY BINARY_INTEGER;
86:
87: TYPE id_tbl IS TABLE OF number INDEX BY BINARY_INTEGER;
80: TYPE cgpv_tbl_type IS TABLE OF cgpv_rec_type
81: INDEX BY BINARY_INTEGER;
82: --
83: -- TYPE id_tbl IS TABLE OF okc_k_groups_v.id%TYPE INDEX BY BINARY_INTEGER;
84: -- TYPE public_yn_tbl IS TABLE OF okc_k_groups_v.public_yn%TYPE INDEX BY BINARY_INTEGER;
85: -- TYPE name_tbl IS TABLE OF okc_k_groups_v.name%TYPE INDEX BY BINARY_INTEGER;
86:
87: TYPE id_tbl IS TABLE OF number INDEX BY BINARY_INTEGER;
88: TYPE public_yn_tbl IS TABLE OF varchar2(3) INDEX BY BINARY_INTEGER;
81: INDEX BY BINARY_INTEGER;
82: --
83: -- TYPE id_tbl IS TABLE OF okc_k_groups_v.id%TYPE INDEX BY BINARY_INTEGER;
84: -- TYPE public_yn_tbl IS TABLE OF okc_k_groups_v.public_yn%TYPE INDEX BY BINARY_INTEGER;
85: -- TYPE name_tbl IS TABLE OF okc_k_groups_v.name%TYPE INDEX BY BINARY_INTEGER;
86:
87: TYPE id_tbl IS TABLE OF number INDEX BY BINARY_INTEGER;
88: TYPE public_yn_tbl IS TABLE OF varchar2(3) INDEX BY BINARY_INTEGER;
89: TYPE name_tbl IS TABLE OF varchar2(150) INDEX BY BINARY_INTEGER;
111: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
112: ---------------------------------------------------------------------------
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