APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on OKC_SECTIONS_B

Line 172: ID okc_sections_b.ID%TYPE

168: TYPE tmpl_usage_tbl_type IS TABLE OF tmpl_usage_rec_type
169: INDEX BY PLS_INTEGER;
170:
171: TYPE section_rec_type IS RECORD (
172: ID okc_sections_b.ID%TYPE
173: := okc_api.g_miss_num,
174: scn_type okc_sections_b.scn_type%TYPE
175: := okc_api.g_miss_char,
176: chr_id okc_sections_b.chr_id%TYPE

Line 174: scn_type okc_sections_b.scn_type%TYPE

170:
171: TYPE section_rec_type IS RECORD (
172: ID okc_sections_b.ID%TYPE
173: := okc_api.g_miss_num,
174: scn_type okc_sections_b.scn_type%TYPE
175: := okc_api.g_miss_char,
176: chr_id okc_sections_b.chr_id%TYPE
177: := okc_api.g_miss_num,
178: sat_code okc_sections_b.sat_code%TYPE

Line 176: chr_id okc_sections_b.chr_id%TYPE

172: ID okc_sections_b.ID%TYPE
173: := okc_api.g_miss_num,
174: scn_type okc_sections_b.scn_type%TYPE
175: := okc_api.g_miss_char,
176: chr_id okc_sections_b.chr_id%TYPE
177: := okc_api.g_miss_num,
178: sat_code okc_sections_b.sat_code%TYPE
179: := okc_api.g_miss_char,
180: section_sequence okc_sections_b.section_sequence%TYPE

Line 178: sat_code okc_sections_b.sat_code%TYPE

174: scn_type okc_sections_b.scn_type%TYPE
175: := okc_api.g_miss_char,
176: chr_id okc_sections_b.chr_id%TYPE
177: := okc_api.g_miss_num,
178: sat_code okc_sections_b.sat_code%TYPE
179: := okc_api.g_miss_char,
180: section_sequence okc_sections_b.section_sequence%TYPE
181: := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,

Line 180: section_sequence okc_sections_b.section_sequence%TYPE

176: chr_id okc_sections_b.chr_id%TYPE
177: := okc_api.g_miss_num,
178: sat_code okc_sections_b.sat_code%TYPE
179: := okc_api.g_miss_char,
180: section_sequence okc_sections_b.section_sequence%TYPE
181: := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,
183: created_by NUMBER := okc_api.g_miss_num,
184: creation_date okc_sections_b.creation_date%TYPE

Line 184: creation_date okc_sections_b.creation_date%TYPE

180: section_sequence okc_sections_b.section_sequence%TYPE
181: := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,
183: created_by NUMBER := okc_api.g_miss_num,
184: creation_date okc_sections_b.creation_date%TYPE
185: := okc_api.g_miss_date,
186: last_updated_by NUMBER := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
188: := okc_api.g_miss_date,

Line 187: last_update_date okc_sections_b.last_update_date%TYPE

183: created_by NUMBER := okc_api.g_miss_num,
184: creation_date okc_sections_b.creation_date%TYPE
185: := okc_api.g_miss_date,
186: last_updated_by NUMBER := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
188: := okc_api.g_miss_date,
189: last_update_login NUMBER := okc_api.g_miss_num,
190: label okc_sections_b.label%TYPE
191: := okc_api.g_miss_char,

Line 190: label okc_sections_b.label%TYPE

186: last_updated_by NUMBER := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
188: := okc_api.g_miss_date,
189: last_update_login NUMBER := okc_api.g_miss_num,
190: label okc_sections_b.label%TYPE
191: := okc_api.g_miss_char,
192: scn_id okc_sections_b.scn_id%TYPE
193: := okc_api.g_miss_num,
194: attribute_category okc_sections_b.attribute_category%TYPE

Line 192: scn_id okc_sections_b.scn_id%TYPE

188: := okc_api.g_miss_date,
189: last_update_login NUMBER := okc_api.g_miss_num,
190: label okc_sections_b.label%TYPE
191: := okc_api.g_miss_char,
192: scn_id okc_sections_b.scn_id%TYPE
193: := okc_api.g_miss_num,
194: attribute_category okc_sections_b.attribute_category%TYPE
195: := okc_api.g_miss_char,
196: attribute1 okc_sections_b.attribute1%TYPE

Line 194: attribute_category okc_sections_b.attribute_category%TYPE

190: label okc_sections_b.label%TYPE
191: := okc_api.g_miss_char,
192: scn_id okc_sections_b.scn_id%TYPE
193: := okc_api.g_miss_num,
194: attribute_category okc_sections_b.attribute_category%TYPE
195: := okc_api.g_miss_char,
196: attribute1 okc_sections_b.attribute1%TYPE
197: := okc_api.g_miss_char,
198: attribute2 okc_sections_b.attribute2%TYPE

Line 196: attribute1 okc_sections_b.attribute1%TYPE

192: scn_id okc_sections_b.scn_id%TYPE
193: := okc_api.g_miss_num,
194: attribute_category okc_sections_b.attribute_category%TYPE
195: := okc_api.g_miss_char,
196: attribute1 okc_sections_b.attribute1%TYPE
197: := okc_api.g_miss_char,
198: attribute2 okc_sections_b.attribute2%TYPE
199: := okc_api.g_miss_char,
200: attribute3 okc_sections_b.attribute3%TYPE

Line 198: attribute2 okc_sections_b.attribute2%TYPE

194: attribute_category okc_sections_b.attribute_category%TYPE
195: := okc_api.g_miss_char,
196: attribute1 okc_sections_b.attribute1%TYPE
197: := okc_api.g_miss_char,
198: attribute2 okc_sections_b.attribute2%TYPE
199: := okc_api.g_miss_char,
200: attribute3 okc_sections_b.attribute3%TYPE
201: := okc_api.g_miss_char,
202: attribute4 okc_sections_b.attribute4%TYPE

Line 200: attribute3 okc_sections_b.attribute3%TYPE

196: attribute1 okc_sections_b.attribute1%TYPE
197: := okc_api.g_miss_char,
198: attribute2 okc_sections_b.attribute2%TYPE
199: := okc_api.g_miss_char,
200: attribute3 okc_sections_b.attribute3%TYPE
201: := okc_api.g_miss_char,
202: attribute4 okc_sections_b.attribute4%TYPE
203: := okc_api.g_miss_char,
204: attribute5 okc_sections_b.attribute5%TYPE

Line 202: attribute4 okc_sections_b.attribute4%TYPE

198: attribute2 okc_sections_b.attribute2%TYPE
199: := okc_api.g_miss_char,
200: attribute3 okc_sections_b.attribute3%TYPE
201: := okc_api.g_miss_char,
202: attribute4 okc_sections_b.attribute4%TYPE
203: := okc_api.g_miss_char,
204: attribute5 okc_sections_b.attribute5%TYPE
205: := okc_api.g_miss_char,
206: attribute6 okc_sections_b.attribute6%TYPE

Line 204: attribute5 okc_sections_b.attribute5%TYPE

200: attribute3 okc_sections_b.attribute3%TYPE
201: := okc_api.g_miss_char,
202: attribute4 okc_sections_b.attribute4%TYPE
203: := okc_api.g_miss_char,
204: attribute5 okc_sections_b.attribute5%TYPE
205: := okc_api.g_miss_char,
206: attribute6 okc_sections_b.attribute6%TYPE
207: := okc_api.g_miss_char,
208: attribute7 okc_sections_b.attribute7%TYPE

Line 206: attribute6 okc_sections_b.attribute6%TYPE

202: attribute4 okc_sections_b.attribute4%TYPE
203: := okc_api.g_miss_char,
204: attribute5 okc_sections_b.attribute5%TYPE
205: := okc_api.g_miss_char,
206: attribute6 okc_sections_b.attribute6%TYPE
207: := okc_api.g_miss_char,
208: attribute7 okc_sections_b.attribute7%TYPE
209: := okc_api.g_miss_char,
210: attribute8 okc_sections_b.attribute8%TYPE

Line 208: attribute7 okc_sections_b.attribute7%TYPE

204: attribute5 okc_sections_b.attribute5%TYPE
205: := okc_api.g_miss_char,
206: attribute6 okc_sections_b.attribute6%TYPE
207: := okc_api.g_miss_char,
208: attribute7 okc_sections_b.attribute7%TYPE
209: := okc_api.g_miss_char,
210: attribute8 okc_sections_b.attribute8%TYPE
211: := okc_api.g_miss_char,
212: attribute9 okc_sections_b.attribute9%TYPE

Line 210: attribute8 okc_sections_b.attribute8%TYPE

206: attribute6 okc_sections_b.attribute6%TYPE
207: := okc_api.g_miss_char,
208: attribute7 okc_sections_b.attribute7%TYPE
209: := okc_api.g_miss_char,
210: attribute8 okc_sections_b.attribute8%TYPE
211: := okc_api.g_miss_char,
212: attribute9 okc_sections_b.attribute9%TYPE
213: := okc_api.g_miss_char,
214: attribute10 okc_sections_b.attribute10%TYPE

Line 212: attribute9 okc_sections_b.attribute9%TYPE

208: attribute7 okc_sections_b.attribute7%TYPE
209: := okc_api.g_miss_char,
210: attribute8 okc_sections_b.attribute8%TYPE
211: := okc_api.g_miss_char,
212: attribute9 okc_sections_b.attribute9%TYPE
213: := okc_api.g_miss_char,
214: attribute10 okc_sections_b.attribute10%TYPE
215: := okc_api.g_miss_char,
216: attribute11 okc_sections_b.attribute11%TYPE

Line 214: attribute10 okc_sections_b.attribute10%TYPE

210: attribute8 okc_sections_b.attribute8%TYPE
211: := okc_api.g_miss_char,
212: attribute9 okc_sections_b.attribute9%TYPE
213: := okc_api.g_miss_char,
214: attribute10 okc_sections_b.attribute10%TYPE
215: := okc_api.g_miss_char,
216: attribute11 okc_sections_b.attribute11%TYPE
217: := okc_api.g_miss_char,
218: attribute12 okc_sections_b.attribute12%TYPE

Line 216: attribute11 okc_sections_b.attribute11%TYPE

212: attribute9 okc_sections_b.attribute9%TYPE
213: := okc_api.g_miss_char,
214: attribute10 okc_sections_b.attribute10%TYPE
215: := okc_api.g_miss_char,
216: attribute11 okc_sections_b.attribute11%TYPE
217: := okc_api.g_miss_char,
218: attribute12 okc_sections_b.attribute12%TYPE
219: := okc_api.g_miss_char,
220: attribute13 okc_sections_b.attribute13%TYPE

Line 218: attribute12 okc_sections_b.attribute12%TYPE

214: attribute10 okc_sections_b.attribute10%TYPE
215: := okc_api.g_miss_char,
216: attribute11 okc_sections_b.attribute11%TYPE
217: := okc_api.g_miss_char,
218: attribute12 okc_sections_b.attribute12%TYPE
219: := okc_api.g_miss_char,
220: attribute13 okc_sections_b.attribute13%TYPE
221: := okc_api.g_miss_char,
222: attribute14 okc_sections_b.attribute14%TYPE

Line 220: attribute13 okc_sections_b.attribute13%TYPE

216: attribute11 okc_sections_b.attribute11%TYPE
217: := okc_api.g_miss_char,
218: attribute12 okc_sections_b.attribute12%TYPE
219: := okc_api.g_miss_char,
220: attribute13 okc_sections_b.attribute13%TYPE
221: := okc_api.g_miss_char,
222: attribute14 okc_sections_b.attribute14%TYPE
223: := okc_api.g_miss_char,
224: attribute15 okc_sections_b.attribute15%TYPE

Line 222: attribute14 okc_sections_b.attribute14%TYPE

218: attribute12 okc_sections_b.attribute12%TYPE
219: := okc_api.g_miss_char,
220: attribute13 okc_sections_b.attribute13%TYPE
221: := okc_api.g_miss_char,
222: attribute14 okc_sections_b.attribute14%TYPE
223: := okc_api.g_miss_char,
224: attribute15 okc_sections_b.attribute15%TYPE
225: := okc_api.g_miss_char,
226: security_group_id okc_sections_b.security_group_id%TYPE

Line 224: attribute15 okc_sections_b.attribute15%TYPE

220: attribute13 okc_sections_b.attribute13%TYPE
221: := okc_api.g_miss_char,
222: attribute14 okc_sections_b.attribute14%TYPE
223: := okc_api.g_miss_char,
224: attribute15 okc_sections_b.attribute15%TYPE
225: := okc_api.g_miss_char,
226: security_group_id okc_sections_b.security_group_id%TYPE
227: := okc_api.g_miss_num,
228: old_id okc_sections_b.old_id%TYPE

Line 226: security_group_id okc_sections_b.security_group_id%TYPE

222: attribute14 okc_sections_b.attribute14%TYPE
223: := okc_api.g_miss_char,
224: attribute15 okc_sections_b.attribute15%TYPE
225: := okc_api.g_miss_char,
226: security_group_id okc_sections_b.security_group_id%TYPE
227: := okc_api.g_miss_num,
228: old_id okc_sections_b.old_id%TYPE
229: := okc_api.g_miss_num,
230: document_type okc_sections_b.document_type%TYPE

Line 228: old_id okc_sections_b.old_id%TYPE

224: attribute15 okc_sections_b.attribute15%TYPE
225: := okc_api.g_miss_char,
226: security_group_id okc_sections_b.security_group_id%TYPE
227: := okc_api.g_miss_num,
228: old_id okc_sections_b.old_id%TYPE
229: := okc_api.g_miss_num,
230: document_type okc_sections_b.document_type%TYPE
231: := okc_api.g_miss_char,
232: document_id okc_sections_b.document_id%TYPE

Line 230: document_type okc_sections_b.document_type%TYPE

226: security_group_id okc_sections_b.security_group_id%TYPE
227: := okc_api.g_miss_num,
228: old_id okc_sections_b.old_id%TYPE
229: := okc_api.g_miss_num,
230: document_type okc_sections_b.document_type%TYPE
231: := okc_api.g_miss_char,
232: document_id okc_sections_b.document_id%TYPE
233: := okc_api.g_miss_num,
234: scn_code okc_sections_b.scn_code%TYPE

Line 232: document_id okc_sections_b.document_id%TYPE

228: old_id okc_sections_b.old_id%TYPE
229: := okc_api.g_miss_num,
230: document_type okc_sections_b.document_type%TYPE
231: := okc_api.g_miss_char,
232: document_id okc_sections_b.document_id%TYPE
233: := okc_api.g_miss_num,
234: scn_code okc_sections_b.scn_code%TYPE
235: := okc_api.g_miss_char,
236: description okc_sections_b.description%TYPE

Line 234: scn_code okc_sections_b.scn_code%TYPE

230: document_type okc_sections_b.document_type%TYPE
231: := okc_api.g_miss_char,
232: document_id okc_sections_b.document_id%TYPE
233: := okc_api.g_miss_num,
234: scn_code okc_sections_b.scn_code%TYPE
235: := okc_api.g_miss_char,
236: description okc_sections_b.description%TYPE
237: := okc_api.g_miss_char,
238: amendment_description okc_sections_b.amendment_description%TYPE

Line 236: description okc_sections_b.description%TYPE

232: document_id okc_sections_b.document_id%TYPE
233: := okc_api.g_miss_num,
234: scn_code okc_sections_b.scn_code%TYPE
235: := okc_api.g_miss_char,
236: description okc_sections_b.description%TYPE
237: := okc_api.g_miss_char,
238: amendment_description okc_sections_b.amendment_description%TYPE
239: := okc_api.g_miss_char,
240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE

Line 238: amendment_description okc_sections_b.amendment_description%TYPE

234: scn_code okc_sections_b.scn_code%TYPE
235: := okc_api.g_miss_char,
236: description okc_sections_b.description%TYPE
237: := okc_api.g_miss_char,
238: amendment_description okc_sections_b.amendment_description%TYPE
239: := okc_api.g_miss_char,
240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241: := okc_api.g_miss_char,
242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE

Line 240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE

236: description okc_sections_b.description%TYPE
237: := okc_api.g_miss_char,
238: amendment_description okc_sections_b.amendment_description%TYPE
239: := okc_api.g_miss_char,
240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241: := okc_api.g_miss_char,
242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243: := okc_api.g_miss_char,
244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE

Line 242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE

238: amendment_description okc_sections_b.amendment_description%TYPE
239: := okc_api.g_miss_char,
240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241: := okc_api.g_miss_char,
242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243: := okc_api.g_miss_char,
244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245: := okc_api.g_miss_num,
246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE

Line 244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE

240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241: := okc_api.g_miss_char,
242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243: := okc_api.g_miss_char,
244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245: := okc_api.g_miss_num,
246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
247: := okc_api.g_miss_num,
248: print_yn okc_sections_b.print_yn%TYPE

Line 246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE

242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243: := okc_api.g_miss_char,
244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245: := okc_api.g_miss_num,
246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
247: := okc_api.g_miss_num,
248: print_yn okc_sections_b.print_yn%TYPE
249: := okc_api.g_miss_char,
250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE

Line 248: print_yn okc_sections_b.print_yn%TYPE

244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245: := okc_api.g_miss_num,
246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
247: := okc_api.g_miss_num,
248: print_yn okc_sections_b.print_yn%TYPE
249: := okc_api.g_miss_char,
250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
251: := okc_api.g_miss_char,
252: heading okc_sections_b.heading%TYPE

Line 250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE

246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
247: := okc_api.g_miss_num,
248: print_yn okc_sections_b.print_yn%TYPE
249: := okc_api.g_miss_char,
250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
251: := okc_api.g_miss_char,
252: heading okc_sections_b.heading%TYPE
253: := okc_api.g_miss_char,
254: last_amended_by okc_sections_b.last_amended_by%TYPE

Line 252: heading okc_sections_b.heading%TYPE

248: print_yn okc_sections_b.print_yn%TYPE
249: := okc_api.g_miss_char,
250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
251: := okc_api.g_miss_char,
252: heading okc_sections_b.heading%TYPE
253: := okc_api.g_miss_char,
254: last_amended_by okc_sections_b.last_amended_by%TYPE
255: := okc_api.g_miss_num,
256: last_amendment_date okc_sections_b.last_amendment_date%TYPE

Line 254: last_amended_by okc_sections_b.last_amended_by%TYPE

250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
251: := okc_api.g_miss_char,
252: heading okc_sections_b.heading%TYPE
253: := okc_api.g_miss_char,
254: last_amended_by okc_sections_b.last_amended_by%TYPE
255: := okc_api.g_miss_num,
256: last_amendment_date okc_sections_b.last_amendment_date%TYPE
257: := okc_api.g_miss_date,
258: status VARCHAR2 (1),

Line 256: last_amendment_date okc_sections_b.last_amendment_date%TYPE

252: heading okc_sections_b.heading%TYPE
253: := okc_api.g_miss_char,
254: last_amended_by okc_sections_b.last_amended_by%TYPE
255: := okc_api.g_miss_num,
256: last_amendment_date okc_sections_b.last_amendment_date%TYPE
257: := okc_api.g_miss_date,
258: status VARCHAR2 (1),
259: errmsg VARCHAR2 (2500)
260: );