213: , p_init_msg_list VARCHAR2
214: , x_return_status out nocopy VARCHAR2
215: , x_msg_count out nocopy NUMBER
216: , x_msg_data out nocopy VARCHAR2
217: , p5_a0 JTF_NUMBER_TABLE
218: , p5_a1 JTF_NUMBER_TABLE
219: , p5_a2 JTF_NUMBER_TABLE
220: , p5_a3 JTF_VARCHAR2_TABLE_200
221: , p5_a4 JTF_VARCHAR2_TABLE_400
214: , x_return_status out nocopy VARCHAR2
215: , x_msg_count out nocopy NUMBER
216: , x_msg_data out nocopy VARCHAR2
217: , p5_a0 JTF_NUMBER_TABLE
218: , p5_a1 JTF_NUMBER_TABLE
219: , p5_a2 JTF_NUMBER_TABLE
220: , p5_a3 JTF_VARCHAR2_TABLE_200
221: , p5_a4 JTF_VARCHAR2_TABLE_400
222: , p5_a5 JTF_VARCHAR2_TABLE_100
215: , x_msg_count out nocopy NUMBER
216: , x_msg_data out nocopy VARCHAR2
217: , p5_a0 JTF_NUMBER_TABLE
218: , p5_a1 JTF_NUMBER_TABLE
219: , p5_a2 JTF_NUMBER_TABLE
220: , p5_a3 JTF_VARCHAR2_TABLE_200
221: , p5_a4 JTF_VARCHAR2_TABLE_400
222: , p5_a5 JTF_VARCHAR2_TABLE_100
223: , p5_a6 JTF_DATE_TABLE
222: , p5_a5 JTF_VARCHAR2_TABLE_100
223: , p5_a6 JTF_DATE_TABLE
224: , p5_a7 JTF_DATE_TABLE
225: , p5_a8 JTF_VARCHAR2_TABLE_2000
226: , p5_a9 JTF_NUMBER_TABLE
227: , p5_a10 JTF_DATE_TABLE
228: , p5_a11 JTF_NUMBER_TABLE
229: , p5_a12 JTF_DATE_TABLE
230: , p5_a13 JTF_NUMBER_TABLE
224: , p5_a7 JTF_DATE_TABLE
225: , p5_a8 JTF_VARCHAR2_TABLE_2000
226: , p5_a9 JTF_NUMBER_TABLE
227: , p5_a10 JTF_DATE_TABLE
228: , p5_a11 JTF_NUMBER_TABLE
229: , p5_a12 JTF_DATE_TABLE
230: , p5_a13 JTF_NUMBER_TABLE
231: , p6_a0 out nocopy JTF_NUMBER_TABLE
232: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p5_a9 JTF_NUMBER_TABLE
227: , p5_a10 JTF_DATE_TABLE
228: , p5_a11 JTF_NUMBER_TABLE
229: , p5_a12 JTF_DATE_TABLE
230: , p5_a13 JTF_NUMBER_TABLE
231: , p6_a0 out nocopy JTF_NUMBER_TABLE
232: , p6_a1 out nocopy JTF_NUMBER_TABLE
233: , p6_a2 out nocopy JTF_NUMBER_TABLE
234: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p5_a10 JTF_DATE_TABLE
228: , p5_a11 JTF_NUMBER_TABLE
229: , p5_a12 JTF_DATE_TABLE
230: , p5_a13 JTF_NUMBER_TABLE
231: , p6_a0 out nocopy JTF_NUMBER_TABLE
232: , p6_a1 out nocopy JTF_NUMBER_TABLE
233: , p6_a2 out nocopy JTF_NUMBER_TABLE
234: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
235: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
228: , p5_a11 JTF_NUMBER_TABLE
229: , p5_a12 JTF_DATE_TABLE
230: , p5_a13 JTF_NUMBER_TABLE
231: , p6_a0 out nocopy JTF_NUMBER_TABLE
232: , p6_a1 out nocopy JTF_NUMBER_TABLE
233: , p6_a2 out nocopy JTF_NUMBER_TABLE
234: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
235: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
236: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
229: , p5_a12 JTF_DATE_TABLE
230: , p5_a13 JTF_NUMBER_TABLE
231: , p6_a0 out nocopy JTF_NUMBER_TABLE
232: , p6_a1 out nocopy JTF_NUMBER_TABLE
233: , p6_a2 out nocopy JTF_NUMBER_TABLE
234: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
235: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
236: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a6 out nocopy JTF_DATE_TABLE
236: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a6 out nocopy JTF_DATE_TABLE
238: , p6_a7 out nocopy JTF_DATE_TABLE
239: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p6_a9 out nocopy JTF_NUMBER_TABLE
241: , p6_a10 out nocopy JTF_DATE_TABLE
242: , p6_a11 out nocopy JTF_NUMBER_TABLE
243: , p6_a12 out nocopy JTF_DATE_TABLE
244: , p6_a13 out nocopy JTF_NUMBER_TABLE
238: , p6_a7 out nocopy JTF_DATE_TABLE
239: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p6_a9 out nocopy JTF_NUMBER_TABLE
241: , p6_a10 out nocopy JTF_DATE_TABLE
242: , p6_a11 out nocopy JTF_NUMBER_TABLE
243: , p6_a12 out nocopy JTF_DATE_TABLE
244: , p6_a13 out nocopy JTF_NUMBER_TABLE
245: )
246:
240: , p6_a9 out nocopy JTF_NUMBER_TABLE
241: , p6_a10 out nocopy JTF_DATE_TABLE
242: , p6_a11 out nocopy JTF_NUMBER_TABLE
243: , p6_a12 out nocopy JTF_DATE_TABLE
244: , p6_a13 out nocopy JTF_NUMBER_TABLE
245: )
246:
247: as
248: ddp_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
310: , p_init_msg_list VARCHAR2
311: , x_return_status out nocopy VARCHAR2
312: , x_msg_count out nocopy NUMBER
313: , x_msg_data out nocopy VARCHAR2
314: , p5_a0 JTF_NUMBER_TABLE
315: , p5_a1 JTF_NUMBER_TABLE
316: , p5_a2 JTF_NUMBER_TABLE
317: , p5_a3 JTF_VARCHAR2_TABLE_200
318: , p5_a4 JTF_VARCHAR2_TABLE_400
311: , x_return_status out nocopy VARCHAR2
312: , x_msg_count out nocopy NUMBER
313: , x_msg_data out nocopy VARCHAR2
314: , p5_a0 JTF_NUMBER_TABLE
315: , p5_a1 JTF_NUMBER_TABLE
316: , p5_a2 JTF_NUMBER_TABLE
317: , p5_a3 JTF_VARCHAR2_TABLE_200
318: , p5_a4 JTF_VARCHAR2_TABLE_400
319: , p5_a5 JTF_VARCHAR2_TABLE_100
312: , x_msg_count out nocopy NUMBER
313: , x_msg_data out nocopy VARCHAR2
314: , p5_a0 JTF_NUMBER_TABLE
315: , p5_a1 JTF_NUMBER_TABLE
316: , p5_a2 JTF_NUMBER_TABLE
317: , p5_a3 JTF_VARCHAR2_TABLE_200
318: , p5_a4 JTF_VARCHAR2_TABLE_400
319: , p5_a5 JTF_VARCHAR2_TABLE_100
320: , p5_a6 JTF_DATE_TABLE
319: , p5_a5 JTF_VARCHAR2_TABLE_100
320: , p5_a6 JTF_DATE_TABLE
321: , p5_a7 JTF_DATE_TABLE
322: , p5_a8 JTF_VARCHAR2_TABLE_2000
323: , p5_a9 JTF_NUMBER_TABLE
324: , p5_a10 JTF_DATE_TABLE
325: , p5_a11 JTF_NUMBER_TABLE
326: , p5_a12 JTF_DATE_TABLE
327: , p5_a13 JTF_NUMBER_TABLE
321: , p5_a7 JTF_DATE_TABLE
322: , p5_a8 JTF_VARCHAR2_TABLE_2000
323: , p5_a9 JTF_NUMBER_TABLE
324: , p5_a10 JTF_DATE_TABLE
325: , p5_a11 JTF_NUMBER_TABLE
326: , p5_a12 JTF_DATE_TABLE
327: , p5_a13 JTF_NUMBER_TABLE
328: , p6_a0 out nocopy JTF_NUMBER_TABLE
329: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p5_a9 JTF_NUMBER_TABLE
324: , p5_a10 JTF_DATE_TABLE
325: , p5_a11 JTF_NUMBER_TABLE
326: , p5_a12 JTF_DATE_TABLE
327: , p5_a13 JTF_NUMBER_TABLE
328: , p6_a0 out nocopy JTF_NUMBER_TABLE
329: , p6_a1 out nocopy JTF_NUMBER_TABLE
330: , p6_a2 out nocopy JTF_NUMBER_TABLE
331: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
324: , p5_a10 JTF_DATE_TABLE
325: , p5_a11 JTF_NUMBER_TABLE
326: , p5_a12 JTF_DATE_TABLE
327: , p5_a13 JTF_NUMBER_TABLE
328: , p6_a0 out nocopy JTF_NUMBER_TABLE
329: , p6_a1 out nocopy JTF_NUMBER_TABLE
330: , p6_a2 out nocopy JTF_NUMBER_TABLE
331: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
332: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
325: , p5_a11 JTF_NUMBER_TABLE
326: , p5_a12 JTF_DATE_TABLE
327: , p5_a13 JTF_NUMBER_TABLE
328: , p6_a0 out nocopy JTF_NUMBER_TABLE
329: , p6_a1 out nocopy JTF_NUMBER_TABLE
330: , p6_a2 out nocopy JTF_NUMBER_TABLE
331: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
332: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
326: , p5_a12 JTF_DATE_TABLE
327: , p5_a13 JTF_NUMBER_TABLE
328: , p6_a0 out nocopy JTF_NUMBER_TABLE
329: , p6_a1 out nocopy JTF_NUMBER_TABLE
330: , p6_a2 out nocopy JTF_NUMBER_TABLE
331: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
332: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a6 out nocopy JTF_DATE_TABLE
333: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a6 out nocopy JTF_DATE_TABLE
335: , p6_a7 out nocopy JTF_DATE_TABLE
336: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
337: , p6_a9 out nocopy JTF_NUMBER_TABLE
338: , p6_a10 out nocopy JTF_DATE_TABLE
339: , p6_a11 out nocopy JTF_NUMBER_TABLE
340: , p6_a12 out nocopy JTF_DATE_TABLE
341: , p6_a13 out nocopy JTF_NUMBER_TABLE
335: , p6_a7 out nocopy JTF_DATE_TABLE
336: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
337: , p6_a9 out nocopy JTF_NUMBER_TABLE
338: , p6_a10 out nocopy JTF_DATE_TABLE
339: , p6_a11 out nocopy JTF_NUMBER_TABLE
340: , p6_a12 out nocopy JTF_DATE_TABLE
341: , p6_a13 out nocopy JTF_NUMBER_TABLE
342: )
343:
337: , p6_a9 out nocopy JTF_NUMBER_TABLE
338: , p6_a10 out nocopy JTF_DATE_TABLE
339: , p6_a11 out nocopy JTF_NUMBER_TABLE
340: , p6_a12 out nocopy JTF_DATE_TABLE
341: , p6_a13 out nocopy JTF_NUMBER_TABLE
342: )
343:
344: as
345: ddp_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
512: , p_init_msg_list VARCHAR2
513: , x_return_status out nocopy VARCHAR2
514: , x_msg_count out nocopy NUMBER
515: , x_msg_data out nocopy VARCHAR2
516: , p5_a0 JTF_NUMBER_TABLE
517: , p5_a1 JTF_NUMBER_TABLE
518: , p5_a2 JTF_NUMBER_TABLE
519: , p5_a3 JTF_NUMBER_TABLE
520: , p5_a4 JTF_VARCHAR2_TABLE_200
513: , x_return_status out nocopy VARCHAR2
514: , x_msg_count out nocopy NUMBER
515: , x_msg_data out nocopy VARCHAR2
516: , p5_a0 JTF_NUMBER_TABLE
517: , p5_a1 JTF_NUMBER_TABLE
518: , p5_a2 JTF_NUMBER_TABLE
519: , p5_a3 JTF_NUMBER_TABLE
520: , p5_a4 JTF_VARCHAR2_TABLE_200
521: , p5_a5 JTF_VARCHAR2_TABLE_2000
514: , x_msg_count out nocopy NUMBER
515: , x_msg_data out nocopy VARCHAR2
516: , p5_a0 JTF_NUMBER_TABLE
517: , p5_a1 JTF_NUMBER_TABLE
518: , p5_a2 JTF_NUMBER_TABLE
519: , p5_a3 JTF_NUMBER_TABLE
520: , p5_a4 JTF_VARCHAR2_TABLE_200
521: , p5_a5 JTF_VARCHAR2_TABLE_2000
522: , p5_a6 JTF_NUMBER_TABLE
515: , x_msg_data out nocopy VARCHAR2
516: , p5_a0 JTF_NUMBER_TABLE
517: , p5_a1 JTF_NUMBER_TABLE
518: , p5_a2 JTF_NUMBER_TABLE
519: , p5_a3 JTF_NUMBER_TABLE
520: , p5_a4 JTF_VARCHAR2_TABLE_200
521: , p5_a5 JTF_VARCHAR2_TABLE_2000
522: , p5_a6 JTF_NUMBER_TABLE
523: , p5_a7 JTF_VARCHAR2_TABLE_100
518: , p5_a2 JTF_NUMBER_TABLE
519: , p5_a3 JTF_NUMBER_TABLE
520: , p5_a4 JTF_VARCHAR2_TABLE_200
521: , p5_a5 JTF_VARCHAR2_TABLE_2000
522: , p5_a6 JTF_NUMBER_TABLE
523: , p5_a7 JTF_VARCHAR2_TABLE_100
524: , p5_a8 JTF_VARCHAR2_TABLE_100
525: , p5_a9 JTF_DATE_TABLE
526: , p5_a10 JTF_VARCHAR2_TABLE_100
540: , p5_a24 JTF_VARCHAR2_TABLE_500
541: , p5_a25 JTF_VARCHAR2_TABLE_500
542: , p5_a26 JTF_VARCHAR2_TABLE_500
543: , p5_a27 JTF_VARCHAR2_TABLE_500
544: , p5_a28 JTF_NUMBER_TABLE
545: , p5_a29 JTF_DATE_TABLE
546: , p5_a30 JTF_NUMBER_TABLE
547: , p5_a31 JTF_DATE_TABLE
548: , p5_a32 JTF_NUMBER_TABLE
542: , p5_a26 JTF_VARCHAR2_TABLE_500
543: , p5_a27 JTF_VARCHAR2_TABLE_500
544: , p5_a28 JTF_NUMBER_TABLE
545: , p5_a29 JTF_DATE_TABLE
546: , p5_a30 JTF_NUMBER_TABLE
547: , p5_a31 JTF_DATE_TABLE
548: , p5_a32 JTF_NUMBER_TABLE
549: , x_validated out nocopy VARCHAR2
550: )
544: , p5_a28 JTF_NUMBER_TABLE
545: , p5_a29 JTF_DATE_TABLE
546: , p5_a30 JTF_NUMBER_TABLE
547: , p5_a31 JTF_DATE_TABLE
548: , p5_a32 JTF_NUMBER_TABLE
549: , x_validated out nocopy VARCHAR2
550: )
551:
552: as