[Home] [Help]
115: TYPE terms_template_tbl_type IS TABLE OF terms_template_rec_type
116: INDEX BY PLS_INTEGER;
117:
118: TYPE tmpl_usage_rec_type IS RECORD (
119: allowed_tmpl_usages_id okc_allowed_tmpl_usages.allowed_tmpl_usages_id%TYPE
120: := okc_api.g_miss_num,
121:
122: document_type okc_allowed_tmpl_usages.document_type%TYPE
123: := okc_api.g_miss_char,
118: TYPE tmpl_usage_rec_type IS RECORD (
119: allowed_tmpl_usages_id okc_allowed_tmpl_usages.allowed_tmpl_usages_id%TYPE
120: := okc_api.g_miss_num,
121:
122: document_type okc_allowed_tmpl_usages.document_type%TYPE
123: := okc_api.g_miss_char,
124: default_yn okc_allowed_tmpl_usages.default_yn%TYPE
125: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
120: := okc_api.g_miss_num,
121:
122: document_type okc_allowed_tmpl_usages.document_type%TYPE
123: := okc_api.g_miss_char,
124: default_yn okc_allowed_tmpl_usages.default_yn%TYPE
125: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
127: creation_date DATE := okc_api.g_miss_date,
128: created_by NUMBER := okc_api.g_miss_num,
128: created_by NUMBER := okc_api.g_miss_num,
129: last_updated_by NUMBER := okc_api.g_miss_num,
130: last_update_date DATE := okc_api.g_miss_date,
131: object_version_number NUMBER := okc_api.g_miss_num,
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133: := okc_api.g_miss_char,
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135: := okc_api.g_miss_char,
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
130: last_update_date DATE := okc_api.g_miss_date,
131: object_version_number NUMBER := okc_api.g_miss_num,
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133: := okc_api.g_miss_char,
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135: := okc_api.g_miss_char,
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137: := okc_api.g_miss_char,
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133: := okc_api.g_miss_char,
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135: := okc_api.g_miss_char,
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137: := okc_api.g_miss_char,
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139: := okc_api.g_miss_char,
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135: := okc_api.g_miss_char,
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137: := okc_api.g_miss_char,
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139: := okc_api.g_miss_char,
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141: := okc_api.g_miss_char,
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137: := okc_api.g_miss_char,
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139: := okc_api.g_miss_char,
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141: := okc_api.g_miss_char,
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143: := okc_api.g_miss_char,
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139: := okc_api.g_miss_char,
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141: := okc_api.g_miss_char,
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143: := okc_api.g_miss_char,
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145: := okc_api.g_miss_char,
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141: := okc_api.g_miss_char,
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143: := okc_api.g_miss_char,
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145: := okc_api.g_miss_char,
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147: := okc_api.g_miss_char,
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143: := okc_api.g_miss_char,
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145: := okc_api.g_miss_char,
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147: := okc_api.g_miss_char,
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149: := okc_api.g_miss_char,
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145: := okc_api.g_miss_char,
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147: := okc_api.g_miss_char,
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149: := okc_api.g_miss_char,
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151: := okc_api.g_miss_char,
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147: := okc_api.g_miss_char,
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149: := okc_api.g_miss_char,
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151: := okc_api.g_miss_char,
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153: := okc_api.g_miss_char,
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149: := okc_api.g_miss_char,
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151: := okc_api.g_miss_char,
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153: := okc_api.g_miss_char,
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155: := okc_api.g_miss_char,
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151: := okc_api.g_miss_char,
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153: := okc_api.g_miss_char,
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155: := okc_api.g_miss_char,
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157: := okc_api.g_miss_char,
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153: := okc_api.g_miss_char,
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155: := okc_api.g_miss_char,
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157: := okc_api.g_miss_char,
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159: := okc_api.g_miss_char,
160: attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155: := okc_api.g_miss_char,
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157: := okc_api.g_miss_char,
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159: := okc_api.g_miss_char,
160: attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
161: := okc_api.g_miss_char,
162: attribute15 okc_allowed_tmpl_usages.attribute15%TYPE
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157: := okc_api.g_miss_char,
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159: := okc_api.g_miss_char,
160: attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
161: := okc_api.g_miss_char,
162: attribute15 okc_allowed_tmpl_usages.attribute15%TYPE
163: := okc_api.g_miss_char,
164: status VARCHAR2 (1),
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159: := okc_api.g_miss_char,
160: attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
161: := okc_api.g_miss_char,
162: attribute15 okc_allowed_tmpl_usages.attribute15%TYPE
163: := okc_api.g_miss_char,
164: status VARCHAR2 (1),
165: errmsg VARCHAR2 (2500)
166: );