APPS.OKL_CHECKLIST_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 229: , p5_a3 JTF_VARCHAR2_TABLE_100

225: , x_msg_data out nocopy VARCHAR2
226: , p5_a0 JTF_NUMBER_TABLE
227: , p5_a1 JTF_NUMBER_TABLE
228: , p5_a2 JTF_NUMBER_TABLE
229: , p5_a3 JTF_VARCHAR2_TABLE_100
230: , p5_a4 JTF_VARCHAR2_TABLE_100
231: , p5_a5 JTF_VARCHAR2_TABLE_500
232: , p5_a6 JTF_VARCHAR2_TABLE_500
233: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 230: , p5_a4 JTF_VARCHAR2_TABLE_100

226: , p5_a0 JTF_NUMBER_TABLE
227: , p5_a1 JTF_NUMBER_TABLE
228: , p5_a2 JTF_NUMBER_TABLE
229: , p5_a3 JTF_VARCHAR2_TABLE_100
230: , p5_a4 JTF_VARCHAR2_TABLE_100
231: , p5_a5 JTF_VARCHAR2_TABLE_500
232: , p5_a6 JTF_VARCHAR2_TABLE_500
233: , p5_a7 JTF_VARCHAR2_TABLE_500
234: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 256: , p5_a30 JTF_VARCHAR2_TABLE_100

252: , p5_a26 JTF_DATE_TABLE
253: , p5_a27 JTF_NUMBER_TABLE
254: , p5_a28 JTF_DATE_TABLE
255: , p5_a29 JTF_NUMBER_TABLE
256: , p5_a30 JTF_VARCHAR2_TABLE_100
257: , p5_a31 JTF_VARCHAR2_TABLE_100
258: , p5_a32 JTF_VARCHAR2_TABLE_500
259: , p5_a33 JTF_VARCHAR2_TABLE_500
260: , p5_a34 JTF_NUMBER_TABLE

Line 257: , p5_a31 JTF_VARCHAR2_TABLE_100

253: , p5_a27 JTF_NUMBER_TABLE
254: , p5_a28 JTF_DATE_TABLE
255: , p5_a29 JTF_NUMBER_TABLE
256: , p5_a30 JTF_VARCHAR2_TABLE_100
257: , p5_a31 JTF_VARCHAR2_TABLE_100
258: , p5_a32 JTF_VARCHAR2_TABLE_500
259: , p5_a33 JTF_VARCHAR2_TABLE_500
260: , p5_a34 JTF_NUMBER_TABLE
261: , p5_a35 JTF_NUMBER_TABLE

Line 262: , p5_a36 JTF_VARCHAR2_TABLE_100

258: , p5_a32 JTF_VARCHAR2_TABLE_500
259: , p5_a33 JTF_VARCHAR2_TABLE_500
260: , p5_a34 JTF_NUMBER_TABLE
261: , p5_a35 JTF_NUMBER_TABLE
262: , p5_a36 JTF_VARCHAR2_TABLE_100
263: , p5_a37 JTF_VARCHAR2_TABLE_2000
264: , p5_a38 JTF_VARCHAR2_TABLE_100
265: , p5_a39 JTF_VARCHAR2_TABLE_100
266: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 264: , p5_a38 JTF_VARCHAR2_TABLE_100

260: , p5_a34 JTF_NUMBER_TABLE
261: , p5_a35 JTF_NUMBER_TABLE
262: , p5_a36 JTF_VARCHAR2_TABLE_100
263: , p5_a37 JTF_VARCHAR2_TABLE_2000
264: , p5_a38 JTF_VARCHAR2_TABLE_100
265: , p5_a39 JTF_VARCHAR2_TABLE_100
266: , p6_a0 out nocopy JTF_NUMBER_TABLE
267: , p6_a1 out nocopy JTF_NUMBER_TABLE
268: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 265: , p5_a39 JTF_VARCHAR2_TABLE_100

261: , p5_a35 JTF_NUMBER_TABLE
262: , p5_a36 JTF_VARCHAR2_TABLE_100
263: , p5_a37 JTF_VARCHAR2_TABLE_2000
264: , p5_a38 JTF_VARCHAR2_TABLE_100
265: , p5_a39 JTF_VARCHAR2_TABLE_100
266: , p6_a0 out nocopy JTF_NUMBER_TABLE
267: , p6_a1 out nocopy JTF_NUMBER_TABLE
268: , p6_a2 out nocopy JTF_NUMBER_TABLE
269: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 269: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

265: , p5_a39 JTF_VARCHAR2_TABLE_100
266: , p6_a0 out nocopy JTF_NUMBER_TABLE
267: , p6_a1 out nocopy JTF_NUMBER_TABLE
268: , p6_a2 out nocopy JTF_NUMBER_TABLE
269: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
272: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
273: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 270: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

266: , p6_a0 out nocopy JTF_NUMBER_TABLE
267: , p6_a1 out nocopy JTF_NUMBER_TABLE
268: , p6_a2 out nocopy JTF_NUMBER_TABLE
269: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
270: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
271: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
272: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
273: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 296: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

292: , p6_a26 out nocopy JTF_DATE_TABLE
293: , p6_a27 out nocopy JTF_NUMBER_TABLE
294: , p6_a28 out nocopy JTF_DATE_TABLE
295: , p6_a29 out nocopy JTF_NUMBER_TABLE
296: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
297: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
298: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
299: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
300: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 297: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

293: , p6_a27 out nocopy JTF_NUMBER_TABLE
294: , p6_a28 out nocopy JTF_DATE_TABLE
295: , p6_a29 out nocopy JTF_NUMBER_TABLE
296: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
297: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
298: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
299: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
300: , p6_a34 out nocopy JTF_NUMBER_TABLE
301: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 302: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

298: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
299: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
300: , p6_a34 out nocopy JTF_NUMBER_TABLE
301: , p6_a35 out nocopy JTF_NUMBER_TABLE
302: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
306: );

Line 304: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

300: , p6_a34 out nocopy JTF_NUMBER_TABLE
301: , p6_a35 out nocopy JTF_NUMBER_TABLE
302: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
306: );
307: procedure update_checklist_dtl(p_api_version NUMBER
308: , p_init_msg_list VARCHAR2

Line 305: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

301: , p6_a35 out nocopy JTF_NUMBER_TABLE
302: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
306: );
307: procedure update_checklist_dtl(p_api_version NUMBER
308: , p_init_msg_list VARCHAR2
309: , x_return_status out nocopy VARCHAR2

Line 315: , p5_a3 JTF_VARCHAR2_TABLE_100

311: , x_msg_data out nocopy VARCHAR2
312: , p5_a0 JTF_NUMBER_TABLE
313: , p5_a1 JTF_NUMBER_TABLE
314: , p5_a2 JTF_NUMBER_TABLE
315: , p5_a3 JTF_VARCHAR2_TABLE_100
316: , p5_a4 JTF_VARCHAR2_TABLE_100
317: , p5_a5 JTF_VARCHAR2_TABLE_500
318: , p5_a6 JTF_VARCHAR2_TABLE_500
319: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 316: , p5_a4 JTF_VARCHAR2_TABLE_100

312: , p5_a0 JTF_NUMBER_TABLE
313: , p5_a1 JTF_NUMBER_TABLE
314: , p5_a2 JTF_NUMBER_TABLE
315: , p5_a3 JTF_VARCHAR2_TABLE_100
316: , p5_a4 JTF_VARCHAR2_TABLE_100
317: , p5_a5 JTF_VARCHAR2_TABLE_500
318: , p5_a6 JTF_VARCHAR2_TABLE_500
319: , p5_a7 JTF_VARCHAR2_TABLE_500
320: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 342: , p5_a30 JTF_VARCHAR2_TABLE_100

338: , p5_a26 JTF_DATE_TABLE
339: , p5_a27 JTF_NUMBER_TABLE
340: , p5_a28 JTF_DATE_TABLE
341: , p5_a29 JTF_NUMBER_TABLE
342: , p5_a30 JTF_VARCHAR2_TABLE_100
343: , p5_a31 JTF_VARCHAR2_TABLE_100
344: , p5_a32 JTF_VARCHAR2_TABLE_500
345: , p5_a33 JTF_VARCHAR2_TABLE_500
346: , p5_a34 JTF_NUMBER_TABLE

Line 343: , p5_a31 JTF_VARCHAR2_TABLE_100

339: , p5_a27 JTF_NUMBER_TABLE
340: , p5_a28 JTF_DATE_TABLE
341: , p5_a29 JTF_NUMBER_TABLE
342: , p5_a30 JTF_VARCHAR2_TABLE_100
343: , p5_a31 JTF_VARCHAR2_TABLE_100
344: , p5_a32 JTF_VARCHAR2_TABLE_500
345: , p5_a33 JTF_VARCHAR2_TABLE_500
346: , p5_a34 JTF_NUMBER_TABLE
347: , p5_a35 JTF_NUMBER_TABLE

Line 348: , p5_a36 JTF_VARCHAR2_TABLE_100

344: , p5_a32 JTF_VARCHAR2_TABLE_500
345: , p5_a33 JTF_VARCHAR2_TABLE_500
346: , p5_a34 JTF_NUMBER_TABLE
347: , p5_a35 JTF_NUMBER_TABLE
348: , p5_a36 JTF_VARCHAR2_TABLE_100
349: , p5_a37 JTF_VARCHAR2_TABLE_2000
350: , p5_a38 JTF_VARCHAR2_TABLE_100
351: , p5_a39 JTF_VARCHAR2_TABLE_100
352: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 350: , p5_a38 JTF_VARCHAR2_TABLE_100

346: , p5_a34 JTF_NUMBER_TABLE
347: , p5_a35 JTF_NUMBER_TABLE
348: , p5_a36 JTF_VARCHAR2_TABLE_100
349: , p5_a37 JTF_VARCHAR2_TABLE_2000
350: , p5_a38 JTF_VARCHAR2_TABLE_100
351: , p5_a39 JTF_VARCHAR2_TABLE_100
352: , p6_a0 out nocopy JTF_NUMBER_TABLE
353: , p6_a1 out nocopy JTF_NUMBER_TABLE
354: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 351: , p5_a39 JTF_VARCHAR2_TABLE_100

347: , p5_a35 JTF_NUMBER_TABLE
348: , p5_a36 JTF_VARCHAR2_TABLE_100
349: , p5_a37 JTF_VARCHAR2_TABLE_2000
350: , p5_a38 JTF_VARCHAR2_TABLE_100
351: , p5_a39 JTF_VARCHAR2_TABLE_100
352: , p6_a0 out nocopy JTF_NUMBER_TABLE
353: , p6_a1 out nocopy JTF_NUMBER_TABLE
354: , p6_a2 out nocopy JTF_NUMBER_TABLE
355: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 355: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

351: , p5_a39 JTF_VARCHAR2_TABLE_100
352: , p6_a0 out nocopy JTF_NUMBER_TABLE
353: , p6_a1 out nocopy JTF_NUMBER_TABLE
354: , p6_a2 out nocopy JTF_NUMBER_TABLE
355: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
358: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
359: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 356: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

352: , p6_a0 out nocopy JTF_NUMBER_TABLE
353: , p6_a1 out nocopy JTF_NUMBER_TABLE
354: , p6_a2 out nocopy JTF_NUMBER_TABLE
355: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
358: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
359: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
360: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 382: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

378: , p6_a26 out nocopy JTF_DATE_TABLE
379: , p6_a27 out nocopy JTF_NUMBER_TABLE
380: , p6_a28 out nocopy JTF_DATE_TABLE
381: , p6_a29 out nocopy JTF_NUMBER_TABLE
382: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
384: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
385: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
386: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 383: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

379: , p6_a27 out nocopy JTF_NUMBER_TABLE
380: , p6_a28 out nocopy JTF_DATE_TABLE
381: , p6_a29 out nocopy JTF_NUMBER_TABLE
382: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
384: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
385: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
386: , p6_a34 out nocopy JTF_NUMBER_TABLE
387: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 388: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

384: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
385: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
386: , p6_a34 out nocopy JTF_NUMBER_TABLE
387: , p6_a35 out nocopy JTF_NUMBER_TABLE
388: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
389: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
390: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
392: );

Line 390: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

386: , p6_a34 out nocopy JTF_NUMBER_TABLE
387: , p6_a35 out nocopy JTF_NUMBER_TABLE
388: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
389: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
390: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
392: );
393: procedure delete_checklist_dtl(p_api_version NUMBER
394: , p_init_msg_list VARCHAR2

Line 391: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

387: , p6_a35 out nocopy JTF_NUMBER_TABLE
388: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
389: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
390: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
392: );
393: procedure delete_checklist_dtl(p_api_version NUMBER
394: , p_init_msg_list VARCHAR2
395: , x_return_status out nocopy VARCHAR2

Line 401: , p5_a3 JTF_VARCHAR2_TABLE_100

397: , x_msg_data out nocopy VARCHAR2
398: , p5_a0 JTF_NUMBER_TABLE
399: , p5_a1 JTF_NUMBER_TABLE
400: , p5_a2 JTF_NUMBER_TABLE
401: , p5_a3 JTF_VARCHAR2_TABLE_100
402: , p5_a4 JTF_VARCHAR2_TABLE_100
403: , p5_a5 JTF_VARCHAR2_TABLE_500
404: , p5_a6 JTF_VARCHAR2_TABLE_500
405: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 402: , p5_a4 JTF_VARCHAR2_TABLE_100

398: , p5_a0 JTF_NUMBER_TABLE
399: , p5_a1 JTF_NUMBER_TABLE
400: , p5_a2 JTF_NUMBER_TABLE
401: , p5_a3 JTF_VARCHAR2_TABLE_100
402: , p5_a4 JTF_VARCHAR2_TABLE_100
403: , p5_a5 JTF_VARCHAR2_TABLE_500
404: , p5_a6 JTF_VARCHAR2_TABLE_500
405: , p5_a7 JTF_VARCHAR2_TABLE_500
406: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 428: , p5_a30 JTF_VARCHAR2_TABLE_100

424: , p5_a26 JTF_DATE_TABLE
425: , p5_a27 JTF_NUMBER_TABLE
426: , p5_a28 JTF_DATE_TABLE
427: , p5_a29 JTF_NUMBER_TABLE
428: , p5_a30 JTF_VARCHAR2_TABLE_100
429: , p5_a31 JTF_VARCHAR2_TABLE_100
430: , p5_a32 JTF_VARCHAR2_TABLE_500
431: , p5_a33 JTF_VARCHAR2_TABLE_500
432: , p5_a34 JTF_NUMBER_TABLE

Line 429: , p5_a31 JTF_VARCHAR2_TABLE_100

425: , p5_a27 JTF_NUMBER_TABLE
426: , p5_a28 JTF_DATE_TABLE
427: , p5_a29 JTF_NUMBER_TABLE
428: , p5_a30 JTF_VARCHAR2_TABLE_100
429: , p5_a31 JTF_VARCHAR2_TABLE_100
430: , p5_a32 JTF_VARCHAR2_TABLE_500
431: , p5_a33 JTF_VARCHAR2_TABLE_500
432: , p5_a34 JTF_NUMBER_TABLE
433: , p5_a35 JTF_NUMBER_TABLE

Line 434: , p5_a36 JTF_VARCHAR2_TABLE_100

430: , p5_a32 JTF_VARCHAR2_TABLE_500
431: , p5_a33 JTF_VARCHAR2_TABLE_500
432: , p5_a34 JTF_NUMBER_TABLE
433: , p5_a35 JTF_NUMBER_TABLE
434: , p5_a36 JTF_VARCHAR2_TABLE_100
435: , p5_a37 JTF_VARCHAR2_TABLE_2000
436: , p5_a38 JTF_VARCHAR2_TABLE_100
437: , p5_a39 JTF_VARCHAR2_TABLE_100
438: );

Line 436: , p5_a38 JTF_VARCHAR2_TABLE_100

432: , p5_a34 JTF_NUMBER_TABLE
433: , p5_a35 JTF_NUMBER_TABLE
434: , p5_a36 JTF_VARCHAR2_TABLE_100
435: , p5_a37 JTF_VARCHAR2_TABLE_2000
436: , p5_a38 JTF_VARCHAR2_TABLE_100
437: , p5_a39 JTF_VARCHAR2_TABLE_100
438: );
439: procedure create_checklist_inst_hdr(p_api_version NUMBER
440: , p_init_msg_list VARCHAR2

Line 437: , p5_a39 JTF_VARCHAR2_TABLE_100

433: , p5_a35 JTF_NUMBER_TABLE
434: , p5_a36 JTF_VARCHAR2_TABLE_100
435: , p5_a37 JTF_VARCHAR2_TABLE_2000
436: , p5_a38 JTF_VARCHAR2_TABLE_100
437: , p5_a39 JTF_VARCHAR2_TABLE_100
438: );
439: procedure create_checklist_inst_hdr(p_api_version NUMBER
440: , p_init_msg_list VARCHAR2
441: , x_return_status out nocopy VARCHAR2

Line 665: , p5_a3 JTF_VARCHAR2_TABLE_100

661: , x_msg_data out nocopy VARCHAR2
662: , p5_a0 JTF_NUMBER_TABLE
663: , p5_a1 JTF_NUMBER_TABLE
664: , p5_a2 JTF_NUMBER_TABLE
665: , p5_a3 JTF_VARCHAR2_TABLE_100
666: , p5_a4 JTF_VARCHAR2_TABLE_100
667: , p5_a5 JTF_VARCHAR2_TABLE_500
668: , p5_a6 JTF_VARCHAR2_TABLE_500
669: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 666: , p5_a4 JTF_VARCHAR2_TABLE_100

662: , p5_a0 JTF_NUMBER_TABLE
663: , p5_a1 JTF_NUMBER_TABLE
664: , p5_a2 JTF_NUMBER_TABLE
665: , p5_a3 JTF_VARCHAR2_TABLE_100
666: , p5_a4 JTF_VARCHAR2_TABLE_100
667: , p5_a5 JTF_VARCHAR2_TABLE_500
668: , p5_a6 JTF_VARCHAR2_TABLE_500
669: , p5_a7 JTF_VARCHAR2_TABLE_500
670: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 692: , p5_a30 JTF_VARCHAR2_TABLE_100

688: , p5_a26 JTF_DATE_TABLE
689: , p5_a27 JTF_NUMBER_TABLE
690: , p5_a28 JTF_DATE_TABLE
691: , p5_a29 JTF_NUMBER_TABLE
692: , p5_a30 JTF_VARCHAR2_TABLE_100
693: , p5_a31 JTF_VARCHAR2_TABLE_100
694: , p5_a32 JTF_VARCHAR2_TABLE_500
695: , p5_a33 JTF_VARCHAR2_TABLE_500
696: , p5_a34 JTF_NUMBER_TABLE

Line 693: , p5_a31 JTF_VARCHAR2_TABLE_100

689: , p5_a27 JTF_NUMBER_TABLE
690: , p5_a28 JTF_DATE_TABLE
691: , p5_a29 JTF_NUMBER_TABLE
692: , p5_a30 JTF_VARCHAR2_TABLE_100
693: , p5_a31 JTF_VARCHAR2_TABLE_100
694: , p5_a32 JTF_VARCHAR2_TABLE_500
695: , p5_a33 JTF_VARCHAR2_TABLE_500
696: , p5_a34 JTF_NUMBER_TABLE
697: , p5_a35 JTF_NUMBER_TABLE

Line 698: , p5_a36 JTF_VARCHAR2_TABLE_100

694: , p5_a32 JTF_VARCHAR2_TABLE_500
695: , p5_a33 JTF_VARCHAR2_TABLE_500
696: , p5_a34 JTF_NUMBER_TABLE
697: , p5_a35 JTF_NUMBER_TABLE
698: , p5_a36 JTF_VARCHAR2_TABLE_100
699: , p5_a37 JTF_VARCHAR2_TABLE_2000
700: , p5_a38 JTF_VARCHAR2_TABLE_100
701: , p5_a39 JTF_VARCHAR2_TABLE_100
702: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 700: , p5_a38 JTF_VARCHAR2_TABLE_100

696: , p5_a34 JTF_NUMBER_TABLE
697: , p5_a35 JTF_NUMBER_TABLE
698: , p5_a36 JTF_VARCHAR2_TABLE_100
699: , p5_a37 JTF_VARCHAR2_TABLE_2000
700: , p5_a38 JTF_VARCHAR2_TABLE_100
701: , p5_a39 JTF_VARCHAR2_TABLE_100
702: , p6_a0 out nocopy JTF_NUMBER_TABLE
703: , p6_a1 out nocopy JTF_NUMBER_TABLE
704: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 701: , p5_a39 JTF_VARCHAR2_TABLE_100

697: , p5_a35 JTF_NUMBER_TABLE
698: , p5_a36 JTF_VARCHAR2_TABLE_100
699: , p5_a37 JTF_VARCHAR2_TABLE_2000
700: , p5_a38 JTF_VARCHAR2_TABLE_100
701: , p5_a39 JTF_VARCHAR2_TABLE_100
702: , p6_a0 out nocopy JTF_NUMBER_TABLE
703: , p6_a1 out nocopy JTF_NUMBER_TABLE
704: , p6_a2 out nocopy JTF_NUMBER_TABLE
705: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 705: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

701: , p5_a39 JTF_VARCHAR2_TABLE_100
702: , p6_a0 out nocopy JTF_NUMBER_TABLE
703: , p6_a1 out nocopy JTF_NUMBER_TABLE
704: , p6_a2 out nocopy JTF_NUMBER_TABLE
705: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
706: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
707: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
708: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
709: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 706: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

702: , p6_a0 out nocopy JTF_NUMBER_TABLE
703: , p6_a1 out nocopy JTF_NUMBER_TABLE
704: , p6_a2 out nocopy JTF_NUMBER_TABLE
705: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
706: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
707: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
708: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
709: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
710: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 732: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

728: , p6_a26 out nocopy JTF_DATE_TABLE
729: , p6_a27 out nocopy JTF_NUMBER_TABLE
730: , p6_a28 out nocopy JTF_DATE_TABLE
731: , p6_a29 out nocopy JTF_NUMBER_TABLE
732: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
733: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
734: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
735: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
736: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 733: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

729: , p6_a27 out nocopy JTF_NUMBER_TABLE
730: , p6_a28 out nocopy JTF_DATE_TABLE
731: , p6_a29 out nocopy JTF_NUMBER_TABLE
732: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
733: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
734: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
735: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
736: , p6_a34 out nocopy JTF_NUMBER_TABLE
737: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 738: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

734: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
735: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
736: , p6_a34 out nocopy JTF_NUMBER_TABLE
737: , p6_a35 out nocopy JTF_NUMBER_TABLE
738: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
740: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
742: );

Line 740: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

736: , p6_a34 out nocopy JTF_NUMBER_TABLE
737: , p6_a35 out nocopy JTF_NUMBER_TABLE
738: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
740: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
742: );
743: procedure update_checklist_inst_dtl(p_api_version NUMBER
744: , p_init_msg_list VARCHAR2

Line 741: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

737: , p6_a35 out nocopy JTF_NUMBER_TABLE
738: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
740: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
742: );
743: procedure update_checklist_inst_dtl(p_api_version NUMBER
744: , p_init_msg_list VARCHAR2
745: , x_return_status out nocopy VARCHAR2

Line 751: , p5_a3 JTF_VARCHAR2_TABLE_100

747: , x_msg_data out nocopy VARCHAR2
748: , p5_a0 JTF_NUMBER_TABLE
749: , p5_a1 JTF_NUMBER_TABLE
750: , p5_a2 JTF_NUMBER_TABLE
751: , p5_a3 JTF_VARCHAR2_TABLE_100
752: , p5_a4 JTF_VARCHAR2_TABLE_100
753: , p5_a5 JTF_VARCHAR2_TABLE_500
754: , p5_a6 JTF_VARCHAR2_TABLE_500
755: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 752: , p5_a4 JTF_VARCHAR2_TABLE_100

748: , p5_a0 JTF_NUMBER_TABLE
749: , p5_a1 JTF_NUMBER_TABLE
750: , p5_a2 JTF_NUMBER_TABLE
751: , p5_a3 JTF_VARCHAR2_TABLE_100
752: , p5_a4 JTF_VARCHAR2_TABLE_100
753: , p5_a5 JTF_VARCHAR2_TABLE_500
754: , p5_a6 JTF_VARCHAR2_TABLE_500
755: , p5_a7 JTF_VARCHAR2_TABLE_500
756: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 778: , p5_a30 JTF_VARCHAR2_TABLE_100

774: , p5_a26 JTF_DATE_TABLE
775: , p5_a27 JTF_NUMBER_TABLE
776: , p5_a28 JTF_DATE_TABLE
777: , p5_a29 JTF_NUMBER_TABLE
778: , p5_a30 JTF_VARCHAR2_TABLE_100
779: , p5_a31 JTF_VARCHAR2_TABLE_100
780: , p5_a32 JTF_VARCHAR2_TABLE_500
781: , p5_a33 JTF_VARCHAR2_TABLE_500
782: , p5_a34 JTF_NUMBER_TABLE

Line 779: , p5_a31 JTF_VARCHAR2_TABLE_100

775: , p5_a27 JTF_NUMBER_TABLE
776: , p5_a28 JTF_DATE_TABLE
777: , p5_a29 JTF_NUMBER_TABLE
778: , p5_a30 JTF_VARCHAR2_TABLE_100
779: , p5_a31 JTF_VARCHAR2_TABLE_100
780: , p5_a32 JTF_VARCHAR2_TABLE_500
781: , p5_a33 JTF_VARCHAR2_TABLE_500
782: , p5_a34 JTF_NUMBER_TABLE
783: , p5_a35 JTF_NUMBER_TABLE

Line 784: , p5_a36 JTF_VARCHAR2_TABLE_100

780: , p5_a32 JTF_VARCHAR2_TABLE_500
781: , p5_a33 JTF_VARCHAR2_TABLE_500
782: , p5_a34 JTF_NUMBER_TABLE
783: , p5_a35 JTF_NUMBER_TABLE
784: , p5_a36 JTF_VARCHAR2_TABLE_100
785: , p5_a37 JTF_VARCHAR2_TABLE_2000
786: , p5_a38 JTF_VARCHAR2_TABLE_100
787: , p5_a39 JTF_VARCHAR2_TABLE_100
788: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 786: , p5_a38 JTF_VARCHAR2_TABLE_100

782: , p5_a34 JTF_NUMBER_TABLE
783: , p5_a35 JTF_NUMBER_TABLE
784: , p5_a36 JTF_VARCHAR2_TABLE_100
785: , p5_a37 JTF_VARCHAR2_TABLE_2000
786: , p5_a38 JTF_VARCHAR2_TABLE_100
787: , p5_a39 JTF_VARCHAR2_TABLE_100
788: , p6_a0 out nocopy JTF_NUMBER_TABLE
789: , p6_a1 out nocopy JTF_NUMBER_TABLE
790: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 787: , p5_a39 JTF_VARCHAR2_TABLE_100

783: , p5_a35 JTF_NUMBER_TABLE
784: , p5_a36 JTF_VARCHAR2_TABLE_100
785: , p5_a37 JTF_VARCHAR2_TABLE_2000
786: , p5_a38 JTF_VARCHAR2_TABLE_100
787: , p5_a39 JTF_VARCHAR2_TABLE_100
788: , p6_a0 out nocopy JTF_NUMBER_TABLE
789: , p6_a1 out nocopy JTF_NUMBER_TABLE
790: , p6_a2 out nocopy JTF_NUMBER_TABLE
791: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 791: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

787: , p5_a39 JTF_VARCHAR2_TABLE_100
788: , p6_a0 out nocopy JTF_NUMBER_TABLE
789: , p6_a1 out nocopy JTF_NUMBER_TABLE
790: , p6_a2 out nocopy JTF_NUMBER_TABLE
791: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
792: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
794: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
795: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 792: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

788: , p6_a0 out nocopy JTF_NUMBER_TABLE
789: , p6_a1 out nocopy JTF_NUMBER_TABLE
790: , p6_a2 out nocopy JTF_NUMBER_TABLE
791: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
792: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
794: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
795: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
796: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 818: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

814: , p6_a26 out nocopy JTF_DATE_TABLE
815: , p6_a27 out nocopy JTF_NUMBER_TABLE
816: , p6_a28 out nocopy JTF_DATE_TABLE
817: , p6_a29 out nocopy JTF_NUMBER_TABLE
818: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
819: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
820: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
821: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
822: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 819: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

815: , p6_a27 out nocopy JTF_NUMBER_TABLE
816: , p6_a28 out nocopy JTF_DATE_TABLE
817: , p6_a29 out nocopy JTF_NUMBER_TABLE
818: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
819: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
820: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
821: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
822: , p6_a34 out nocopy JTF_NUMBER_TABLE
823: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 824: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

820: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
821: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
822: , p6_a34 out nocopy JTF_NUMBER_TABLE
823: , p6_a35 out nocopy JTF_NUMBER_TABLE
824: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
825: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
828: );

Line 826: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

822: , p6_a34 out nocopy JTF_NUMBER_TABLE
823: , p6_a35 out nocopy JTF_NUMBER_TABLE
824: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
825: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
828: );
829: procedure delete_checklist_inst_dtl(p_api_version NUMBER
830: , p_init_msg_list VARCHAR2

Line 827: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

823: , p6_a35 out nocopy JTF_NUMBER_TABLE
824: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
825: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
828: );
829: procedure delete_checklist_inst_dtl(p_api_version NUMBER
830: , p_init_msg_list VARCHAR2
831: , x_return_status out nocopy VARCHAR2

Line 837: , p5_a3 JTF_VARCHAR2_TABLE_100

833: , x_msg_data out nocopy VARCHAR2
834: , p5_a0 JTF_NUMBER_TABLE
835: , p5_a1 JTF_NUMBER_TABLE
836: , p5_a2 JTF_NUMBER_TABLE
837: , p5_a3 JTF_VARCHAR2_TABLE_100
838: , p5_a4 JTF_VARCHAR2_TABLE_100
839: , p5_a5 JTF_VARCHAR2_TABLE_500
840: , p5_a6 JTF_VARCHAR2_TABLE_500
841: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 838: , p5_a4 JTF_VARCHAR2_TABLE_100

834: , p5_a0 JTF_NUMBER_TABLE
835: , p5_a1 JTF_NUMBER_TABLE
836: , p5_a2 JTF_NUMBER_TABLE
837: , p5_a3 JTF_VARCHAR2_TABLE_100
838: , p5_a4 JTF_VARCHAR2_TABLE_100
839: , p5_a5 JTF_VARCHAR2_TABLE_500
840: , p5_a6 JTF_VARCHAR2_TABLE_500
841: , p5_a7 JTF_VARCHAR2_TABLE_500
842: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 864: , p5_a30 JTF_VARCHAR2_TABLE_100

860: , p5_a26 JTF_DATE_TABLE
861: , p5_a27 JTF_NUMBER_TABLE
862: , p5_a28 JTF_DATE_TABLE
863: , p5_a29 JTF_NUMBER_TABLE
864: , p5_a30 JTF_VARCHAR2_TABLE_100
865: , p5_a31 JTF_VARCHAR2_TABLE_100
866: , p5_a32 JTF_VARCHAR2_TABLE_500
867: , p5_a33 JTF_VARCHAR2_TABLE_500
868: , p5_a34 JTF_NUMBER_TABLE

Line 865: , p5_a31 JTF_VARCHAR2_TABLE_100

861: , p5_a27 JTF_NUMBER_TABLE
862: , p5_a28 JTF_DATE_TABLE
863: , p5_a29 JTF_NUMBER_TABLE
864: , p5_a30 JTF_VARCHAR2_TABLE_100
865: , p5_a31 JTF_VARCHAR2_TABLE_100
866: , p5_a32 JTF_VARCHAR2_TABLE_500
867: , p5_a33 JTF_VARCHAR2_TABLE_500
868: , p5_a34 JTF_NUMBER_TABLE
869: , p5_a35 JTF_NUMBER_TABLE

Line 870: , p5_a36 JTF_VARCHAR2_TABLE_100

866: , p5_a32 JTF_VARCHAR2_TABLE_500
867: , p5_a33 JTF_VARCHAR2_TABLE_500
868: , p5_a34 JTF_NUMBER_TABLE
869: , p5_a35 JTF_NUMBER_TABLE
870: , p5_a36 JTF_VARCHAR2_TABLE_100
871: , p5_a37 JTF_VARCHAR2_TABLE_2000
872: , p5_a38 JTF_VARCHAR2_TABLE_100
873: , p5_a39 JTF_VARCHAR2_TABLE_100
874: );

Line 872: , p5_a38 JTF_VARCHAR2_TABLE_100

868: , p5_a34 JTF_NUMBER_TABLE
869: , p5_a35 JTF_NUMBER_TABLE
870: , p5_a36 JTF_VARCHAR2_TABLE_100
871: , p5_a37 JTF_VARCHAR2_TABLE_2000
872: , p5_a38 JTF_VARCHAR2_TABLE_100
873: , p5_a39 JTF_VARCHAR2_TABLE_100
874: );
875: end okl_checklist_pvt_w;

Line 873: , p5_a39 JTF_VARCHAR2_TABLE_100

869: , p5_a35 JTF_NUMBER_TABLE
870: , p5_a36 JTF_VARCHAR2_TABLE_100
871: , p5_a37 JTF_VARCHAR2_TABLE_2000
872: , p5_a38 JTF_VARCHAR2_TABLE_100
873: , p5_a39 JTF_VARCHAR2_TABLE_100
874: );
875: end okl_checklist_pvt_w;