DBA Data[Home] [Help]

APPS.OKL_PROCESS_TMPT_SET_PUB_W dependencies on JTF_DATE_TABLE

Line 25: , p6_a17 JTF_DATE_TABLE

21: , p6_a13 JTF_VARCHAR2_TABLE_200
22: , p6_a14 JTF_VARCHAR2_TABLE_2000
23: , p6_a15 JTF_VARCHAR2_TABLE_100
24: , p6_a16 JTF_VARCHAR2_TABLE_100
25: , p6_a17 JTF_DATE_TABLE
26: , p6_a18 JTF_DATE_TABLE
27: , p6_a19 JTF_VARCHAR2_TABLE_100
28: , p6_a20 JTF_VARCHAR2_TABLE_100
29: , p6_a21 JTF_VARCHAR2_TABLE_500

Line 26: , p6_a18 JTF_DATE_TABLE

22: , p6_a14 JTF_VARCHAR2_TABLE_2000
23: , p6_a15 JTF_VARCHAR2_TABLE_100
24: , p6_a16 JTF_VARCHAR2_TABLE_100
25: , p6_a17 JTF_DATE_TABLE
26: , p6_a18 JTF_DATE_TABLE
27: , p6_a19 JTF_VARCHAR2_TABLE_100
28: , p6_a20 JTF_VARCHAR2_TABLE_100
29: , p6_a21 JTF_VARCHAR2_TABLE_500
30: , p6_a22 JTF_VARCHAR2_TABLE_500

Line 46: , p6_a38 JTF_DATE_TABLE

42: , p6_a34 JTF_VARCHAR2_TABLE_500
43: , p6_a35 JTF_VARCHAR2_TABLE_500
44: , p6_a36 JTF_NUMBER_TABLE
45: , p6_a37 JTF_NUMBER_TABLE
46: , p6_a38 JTF_DATE_TABLE
47: , p6_a39 JTF_NUMBER_TABLE
48: , p6_a40 JTF_DATE_TABLE
49: , p6_a41 JTF_NUMBER_TABLE
50: , p6_a42 JTF_VARCHAR2_TABLE_100

Line 48: , p6_a40 JTF_DATE_TABLE

44: , p6_a36 JTF_NUMBER_TABLE
45: , p6_a37 JTF_NUMBER_TABLE
46: , p6_a38 JTF_DATE_TABLE
47: , p6_a39 JTF_NUMBER_TABLE
48: , p6_a40 JTF_DATE_TABLE
49: , p6_a41 JTF_NUMBER_TABLE
50: , p6_a42 JTF_VARCHAR2_TABLE_100
51: , p7_a0 JTF_NUMBER_TABLE
52: , p7_a1 JTF_NUMBER_TABLE

Line 80: , p7_a29 JTF_DATE_TABLE

76: , p7_a25 JTF_VARCHAR2_TABLE_500
77: , p7_a26 JTF_NUMBER_TABLE
78: , p7_a27 JTF_NUMBER_TABLE
79: , p7_a28 JTF_NUMBER_TABLE
80: , p7_a29 JTF_DATE_TABLE
81: , p7_a30 JTF_NUMBER_TABLE
82: , p7_a31 JTF_DATE_TABLE
83: , p7_a32 JTF_NUMBER_TABLE
84: , p8_a0 out nocopy NUMBER

Line 82: , p7_a31 JTF_DATE_TABLE

78: , p7_a27 JTF_NUMBER_TABLE
79: , p7_a28 JTF_NUMBER_TABLE
80: , p7_a29 JTF_DATE_TABLE
81: , p7_a30 JTF_NUMBER_TABLE
82: , p7_a31 JTF_DATE_TABLE
83: , p7_a32 JTF_NUMBER_TABLE
84: , p8_a0 out nocopy NUMBER
85: , p8_a1 out nocopy NUMBER
86: , p8_a2 out nocopy VARCHAR2

Line 115: , p9_a17 out nocopy JTF_DATE_TABLE

111: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
112: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
113: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
115: , p9_a17 out nocopy JTF_DATE_TABLE
116: , p9_a18 out nocopy JTF_DATE_TABLE
117: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
119: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 116: , p9_a18 out nocopy JTF_DATE_TABLE

112: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
113: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
115: , p9_a17 out nocopy JTF_DATE_TABLE
116: , p9_a18 out nocopy JTF_DATE_TABLE
117: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
119: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
120: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 136: , p9_a38 out nocopy JTF_DATE_TABLE

132: , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
133: , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
134: , p9_a36 out nocopy JTF_NUMBER_TABLE
135: , p9_a37 out nocopy JTF_NUMBER_TABLE
136: , p9_a38 out nocopy JTF_DATE_TABLE
137: , p9_a39 out nocopy JTF_NUMBER_TABLE
138: , p9_a40 out nocopy JTF_DATE_TABLE
139: , p9_a41 out nocopy JTF_NUMBER_TABLE
140: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 138: , p9_a40 out nocopy JTF_DATE_TABLE

134: , p9_a36 out nocopy JTF_NUMBER_TABLE
135: , p9_a37 out nocopy JTF_NUMBER_TABLE
136: , p9_a38 out nocopy JTF_DATE_TABLE
137: , p9_a39 out nocopy JTF_NUMBER_TABLE
138: , p9_a40 out nocopy JTF_DATE_TABLE
139: , p9_a41 out nocopy JTF_NUMBER_TABLE
140: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
141: , p10_a0 out nocopy JTF_NUMBER_TABLE
142: , p10_a1 out nocopy JTF_NUMBER_TABLE

Line 170: , p10_a29 out nocopy JTF_DATE_TABLE

166: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
167: , p10_a26 out nocopy JTF_NUMBER_TABLE
168: , p10_a27 out nocopy JTF_NUMBER_TABLE
169: , p10_a28 out nocopy JTF_NUMBER_TABLE
170: , p10_a29 out nocopy JTF_DATE_TABLE
171: , p10_a30 out nocopy JTF_NUMBER_TABLE
172: , p10_a31 out nocopy JTF_DATE_TABLE
173: , p10_a32 out nocopy JTF_NUMBER_TABLE
174: , p5_a0 NUMBER := 0-1962.0724

Line 172: , p10_a31 out nocopy JTF_DATE_TABLE

168: , p10_a27 out nocopy JTF_NUMBER_TABLE
169: , p10_a28 out nocopy JTF_NUMBER_TABLE
170: , p10_a29 out nocopy JTF_DATE_TABLE
171: , p10_a30 out nocopy JTF_NUMBER_TABLE
172: , p10_a31 out nocopy JTF_DATE_TABLE
173: , p10_a32 out nocopy JTF_NUMBER_TABLE
174: , p5_a0 NUMBER := 0-1962.0724
175: , p5_a1 NUMBER := 0-1962.0724
176: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

Line 211: , p6_a17 JTF_DATE_TABLE

207: , p6_a13 JTF_VARCHAR2_TABLE_200
208: , p6_a14 JTF_VARCHAR2_TABLE_2000
209: , p6_a15 JTF_VARCHAR2_TABLE_100
210: , p6_a16 JTF_VARCHAR2_TABLE_100
211: , p6_a17 JTF_DATE_TABLE
212: , p6_a18 JTF_DATE_TABLE
213: , p6_a19 JTF_VARCHAR2_TABLE_100
214: , p6_a20 JTF_VARCHAR2_TABLE_100
215: , p6_a21 JTF_VARCHAR2_TABLE_500

Line 212: , p6_a18 JTF_DATE_TABLE

208: , p6_a14 JTF_VARCHAR2_TABLE_2000
209: , p6_a15 JTF_VARCHAR2_TABLE_100
210: , p6_a16 JTF_VARCHAR2_TABLE_100
211: , p6_a17 JTF_DATE_TABLE
212: , p6_a18 JTF_DATE_TABLE
213: , p6_a19 JTF_VARCHAR2_TABLE_100
214: , p6_a20 JTF_VARCHAR2_TABLE_100
215: , p6_a21 JTF_VARCHAR2_TABLE_500
216: , p6_a22 JTF_VARCHAR2_TABLE_500

Line 232: , p6_a38 JTF_DATE_TABLE

228: , p6_a34 JTF_VARCHAR2_TABLE_500
229: , p6_a35 JTF_VARCHAR2_TABLE_500
230: , p6_a36 JTF_NUMBER_TABLE
231: , p6_a37 JTF_NUMBER_TABLE
232: , p6_a38 JTF_DATE_TABLE
233: , p6_a39 JTF_NUMBER_TABLE
234: , p6_a40 JTF_DATE_TABLE
235: , p6_a41 JTF_NUMBER_TABLE
236: , p6_a42 JTF_VARCHAR2_TABLE_100

Line 234: , p6_a40 JTF_DATE_TABLE

230: , p6_a36 JTF_NUMBER_TABLE
231: , p6_a37 JTF_NUMBER_TABLE
232: , p6_a38 JTF_DATE_TABLE
233: , p6_a39 JTF_NUMBER_TABLE
234: , p6_a40 JTF_DATE_TABLE
235: , p6_a41 JTF_NUMBER_TABLE
236: , p6_a42 JTF_VARCHAR2_TABLE_100
237: , p7_a0 JTF_NUMBER_TABLE
238: , p7_a1 JTF_NUMBER_TABLE

Line 266: , p7_a29 JTF_DATE_TABLE

262: , p7_a25 JTF_VARCHAR2_TABLE_500
263: , p7_a26 JTF_NUMBER_TABLE
264: , p7_a27 JTF_NUMBER_TABLE
265: , p7_a28 JTF_NUMBER_TABLE
266: , p7_a29 JTF_DATE_TABLE
267: , p7_a30 JTF_NUMBER_TABLE
268: , p7_a31 JTF_DATE_TABLE
269: , p7_a32 JTF_NUMBER_TABLE
270: , p8_a0 out nocopy NUMBER

Line 268: , p7_a31 JTF_DATE_TABLE

264: , p7_a27 JTF_NUMBER_TABLE
265: , p7_a28 JTF_NUMBER_TABLE
266: , p7_a29 JTF_DATE_TABLE
267: , p7_a30 JTF_NUMBER_TABLE
268: , p7_a31 JTF_DATE_TABLE
269: , p7_a32 JTF_NUMBER_TABLE
270: , p8_a0 out nocopy NUMBER
271: , p8_a1 out nocopy NUMBER
272: , p8_a2 out nocopy VARCHAR2

Line 301: , p9_a17 out nocopy JTF_DATE_TABLE

297: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
298: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
299: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
300: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
301: , p9_a17 out nocopy JTF_DATE_TABLE
302: , p9_a18 out nocopy JTF_DATE_TABLE
303: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
304: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
305: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 302: , p9_a18 out nocopy JTF_DATE_TABLE

298: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
299: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
300: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
301: , p9_a17 out nocopy JTF_DATE_TABLE
302: , p9_a18 out nocopy JTF_DATE_TABLE
303: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
304: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
305: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
306: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 322: , p9_a38 out nocopy JTF_DATE_TABLE

318: , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
319: , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
320: , p9_a36 out nocopy JTF_NUMBER_TABLE
321: , p9_a37 out nocopy JTF_NUMBER_TABLE
322: , p9_a38 out nocopy JTF_DATE_TABLE
323: , p9_a39 out nocopy JTF_NUMBER_TABLE
324: , p9_a40 out nocopy JTF_DATE_TABLE
325: , p9_a41 out nocopy JTF_NUMBER_TABLE
326: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 324: , p9_a40 out nocopy JTF_DATE_TABLE

320: , p9_a36 out nocopy JTF_NUMBER_TABLE
321: , p9_a37 out nocopy JTF_NUMBER_TABLE
322: , p9_a38 out nocopy JTF_DATE_TABLE
323: , p9_a39 out nocopy JTF_NUMBER_TABLE
324: , p9_a40 out nocopy JTF_DATE_TABLE
325: , p9_a41 out nocopy JTF_NUMBER_TABLE
326: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
327: , p10_a0 out nocopy JTF_NUMBER_TABLE
328: , p10_a1 out nocopy JTF_NUMBER_TABLE

Line 356: , p10_a29 out nocopy JTF_DATE_TABLE

352: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
353: , p10_a26 out nocopy JTF_NUMBER_TABLE
354: , p10_a27 out nocopy JTF_NUMBER_TABLE
355: , p10_a28 out nocopy JTF_NUMBER_TABLE
356: , p10_a29 out nocopy JTF_DATE_TABLE
357: , p10_a30 out nocopy JTF_NUMBER_TABLE
358: , p10_a31 out nocopy JTF_DATE_TABLE
359: , p10_a32 out nocopy JTF_NUMBER_TABLE
360: , p5_a0 NUMBER := 0-1962.0724

Line 358: , p10_a31 out nocopy JTF_DATE_TABLE

354: , p10_a27 out nocopy JTF_NUMBER_TABLE
355: , p10_a28 out nocopy JTF_NUMBER_TABLE
356: , p10_a29 out nocopy JTF_DATE_TABLE
357: , p10_a30 out nocopy JTF_NUMBER_TABLE
358: , p10_a31 out nocopy JTF_DATE_TABLE
359: , p10_a32 out nocopy JTF_NUMBER_TABLE
360: , p5_a0 NUMBER := 0-1962.0724
361: , p5_a1 NUMBER := 0-1962.0724
362: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

Line 385: , p5_a5 JTF_DATE_TABLE

381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_200
383: , p5_a3 JTF_VARCHAR2_TABLE_2000
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_DATE_TABLE
386: , p5_a6 JTF_DATE_TABLE
387: , p5_a7 JTF_NUMBER_TABLE
388: , p5_a8 JTF_NUMBER_TABLE
389: , p5_a9 JTF_DATE_TABLE

Line 386: , p5_a6 JTF_DATE_TABLE

382: , p5_a2 JTF_VARCHAR2_TABLE_200
383: , p5_a3 JTF_VARCHAR2_TABLE_2000
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_DATE_TABLE
386: , p5_a6 JTF_DATE_TABLE
387: , p5_a7 JTF_NUMBER_TABLE
388: , p5_a8 JTF_NUMBER_TABLE
389: , p5_a9 JTF_DATE_TABLE
390: , p5_a10 JTF_NUMBER_TABLE

Line 389: , p5_a9 JTF_DATE_TABLE

385: , p5_a5 JTF_DATE_TABLE
386: , p5_a6 JTF_DATE_TABLE
387: , p5_a7 JTF_NUMBER_TABLE
388: , p5_a8 JTF_NUMBER_TABLE
389: , p5_a9 JTF_DATE_TABLE
390: , p5_a10 JTF_NUMBER_TABLE
391: , p5_a11 JTF_DATE_TABLE
392: , p5_a12 JTF_NUMBER_TABLE
393: , p5_a13 JTF_NUMBER_TABLE

Line 391: , p5_a11 JTF_DATE_TABLE

387: , p5_a7 JTF_NUMBER_TABLE
388: , p5_a8 JTF_NUMBER_TABLE
389: , p5_a9 JTF_DATE_TABLE
390: , p5_a10 JTF_NUMBER_TABLE
391: , p5_a11 JTF_DATE_TABLE
392: , p5_a12 JTF_NUMBER_TABLE
393: , p5_a13 JTF_NUMBER_TABLE
394: , p6_a0 out nocopy JTF_NUMBER_TABLE
395: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 399: , p6_a5 out nocopy JTF_DATE_TABLE

395: , p6_a1 out nocopy JTF_NUMBER_TABLE
396: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
397: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
398: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
399: , p6_a5 out nocopy JTF_DATE_TABLE
400: , p6_a6 out nocopy JTF_DATE_TABLE
401: , p6_a7 out nocopy JTF_NUMBER_TABLE
402: , p6_a8 out nocopy JTF_NUMBER_TABLE
403: , p6_a9 out nocopy JTF_DATE_TABLE

Line 400: , p6_a6 out nocopy JTF_DATE_TABLE

396: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
397: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
398: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
399: , p6_a5 out nocopy JTF_DATE_TABLE
400: , p6_a6 out nocopy JTF_DATE_TABLE
401: , p6_a7 out nocopy JTF_NUMBER_TABLE
402: , p6_a8 out nocopy JTF_NUMBER_TABLE
403: , p6_a9 out nocopy JTF_DATE_TABLE
404: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 403: , p6_a9 out nocopy JTF_DATE_TABLE

399: , p6_a5 out nocopy JTF_DATE_TABLE
400: , p6_a6 out nocopy JTF_DATE_TABLE
401: , p6_a7 out nocopy JTF_NUMBER_TABLE
402: , p6_a8 out nocopy JTF_NUMBER_TABLE
403: , p6_a9 out nocopy JTF_DATE_TABLE
404: , p6_a10 out nocopy JTF_NUMBER_TABLE
405: , p6_a11 out nocopy JTF_DATE_TABLE
406: , p6_a12 out nocopy JTF_NUMBER_TABLE
407: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 405: , p6_a11 out nocopy JTF_DATE_TABLE

401: , p6_a7 out nocopy JTF_NUMBER_TABLE
402: , p6_a8 out nocopy JTF_NUMBER_TABLE
403: , p6_a9 out nocopy JTF_DATE_TABLE
404: , p6_a10 out nocopy JTF_NUMBER_TABLE
405: , p6_a11 out nocopy JTF_DATE_TABLE
406: , p6_a12 out nocopy JTF_NUMBER_TABLE
407: , p6_a13 out nocopy JTF_NUMBER_TABLE
408: );
409: procedure create_tmpt_set(p_api_version NUMBER

Line 454: , p5_a5 JTF_DATE_TABLE

450: , p5_a1 JTF_NUMBER_TABLE
451: , p5_a2 JTF_VARCHAR2_TABLE_200
452: , p5_a3 JTF_VARCHAR2_TABLE_2000
453: , p5_a4 JTF_VARCHAR2_TABLE_100
454: , p5_a5 JTF_DATE_TABLE
455: , p5_a6 JTF_DATE_TABLE
456: , p5_a7 JTF_NUMBER_TABLE
457: , p5_a8 JTF_NUMBER_TABLE
458: , p5_a9 JTF_DATE_TABLE

Line 455: , p5_a6 JTF_DATE_TABLE

451: , p5_a2 JTF_VARCHAR2_TABLE_200
452: , p5_a3 JTF_VARCHAR2_TABLE_2000
453: , p5_a4 JTF_VARCHAR2_TABLE_100
454: , p5_a5 JTF_DATE_TABLE
455: , p5_a6 JTF_DATE_TABLE
456: , p5_a7 JTF_NUMBER_TABLE
457: , p5_a8 JTF_NUMBER_TABLE
458: , p5_a9 JTF_DATE_TABLE
459: , p5_a10 JTF_NUMBER_TABLE

Line 458: , p5_a9 JTF_DATE_TABLE

454: , p5_a5 JTF_DATE_TABLE
455: , p5_a6 JTF_DATE_TABLE
456: , p5_a7 JTF_NUMBER_TABLE
457: , p5_a8 JTF_NUMBER_TABLE
458: , p5_a9 JTF_DATE_TABLE
459: , p5_a10 JTF_NUMBER_TABLE
460: , p5_a11 JTF_DATE_TABLE
461: , p5_a12 JTF_NUMBER_TABLE
462: , p5_a13 JTF_NUMBER_TABLE

Line 460: , p5_a11 JTF_DATE_TABLE

456: , p5_a7 JTF_NUMBER_TABLE
457: , p5_a8 JTF_NUMBER_TABLE
458: , p5_a9 JTF_DATE_TABLE
459: , p5_a10 JTF_NUMBER_TABLE
460: , p5_a11 JTF_DATE_TABLE
461: , p5_a12 JTF_NUMBER_TABLE
462: , p5_a13 JTF_NUMBER_TABLE
463: , p6_a0 out nocopy JTF_NUMBER_TABLE
464: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 468: , p6_a5 out nocopy JTF_DATE_TABLE

464: , p6_a1 out nocopy JTF_NUMBER_TABLE
465: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
466: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
467: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a5 out nocopy JTF_DATE_TABLE
469: , p6_a6 out nocopy JTF_DATE_TABLE
470: , p6_a7 out nocopy JTF_NUMBER_TABLE
471: , p6_a8 out nocopy JTF_NUMBER_TABLE
472: , p6_a9 out nocopy JTF_DATE_TABLE

Line 469: , p6_a6 out nocopy JTF_DATE_TABLE

465: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
466: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
467: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a5 out nocopy JTF_DATE_TABLE
469: , p6_a6 out nocopy JTF_DATE_TABLE
470: , p6_a7 out nocopy JTF_NUMBER_TABLE
471: , p6_a8 out nocopy JTF_NUMBER_TABLE
472: , p6_a9 out nocopy JTF_DATE_TABLE
473: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 472: , p6_a9 out nocopy JTF_DATE_TABLE

468: , p6_a5 out nocopy JTF_DATE_TABLE
469: , p6_a6 out nocopy JTF_DATE_TABLE
470: , p6_a7 out nocopy JTF_NUMBER_TABLE
471: , p6_a8 out nocopy JTF_NUMBER_TABLE
472: , p6_a9 out nocopy JTF_DATE_TABLE
473: , p6_a10 out nocopy JTF_NUMBER_TABLE
474: , p6_a11 out nocopy JTF_DATE_TABLE
475: , p6_a12 out nocopy JTF_NUMBER_TABLE
476: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 474: , p6_a11 out nocopy JTF_DATE_TABLE

470: , p6_a7 out nocopy JTF_NUMBER_TABLE
471: , p6_a8 out nocopy JTF_NUMBER_TABLE
472: , p6_a9 out nocopy JTF_DATE_TABLE
473: , p6_a10 out nocopy JTF_NUMBER_TABLE
474: , p6_a11 out nocopy JTF_DATE_TABLE
475: , p6_a12 out nocopy JTF_NUMBER_TABLE
476: , p6_a13 out nocopy JTF_NUMBER_TABLE
477: );
478: procedure update_tmpt_set(p_api_version NUMBER

Line 522: , p5_a5 JTF_DATE_TABLE

518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_VARCHAR2_TABLE_200
520: , p5_a3 JTF_VARCHAR2_TABLE_2000
521: , p5_a4 JTF_VARCHAR2_TABLE_100
522: , p5_a5 JTF_DATE_TABLE
523: , p5_a6 JTF_DATE_TABLE
524: , p5_a7 JTF_NUMBER_TABLE
525: , p5_a8 JTF_NUMBER_TABLE
526: , p5_a9 JTF_DATE_TABLE

Line 523: , p5_a6 JTF_DATE_TABLE

519: , p5_a2 JTF_VARCHAR2_TABLE_200
520: , p5_a3 JTF_VARCHAR2_TABLE_2000
521: , p5_a4 JTF_VARCHAR2_TABLE_100
522: , p5_a5 JTF_DATE_TABLE
523: , p5_a6 JTF_DATE_TABLE
524: , p5_a7 JTF_NUMBER_TABLE
525: , p5_a8 JTF_NUMBER_TABLE
526: , p5_a9 JTF_DATE_TABLE
527: , p5_a10 JTF_NUMBER_TABLE

Line 526: , p5_a9 JTF_DATE_TABLE

522: , p5_a5 JTF_DATE_TABLE
523: , p5_a6 JTF_DATE_TABLE
524: , p5_a7 JTF_NUMBER_TABLE
525: , p5_a8 JTF_NUMBER_TABLE
526: , p5_a9 JTF_DATE_TABLE
527: , p5_a10 JTF_NUMBER_TABLE
528: , p5_a11 JTF_DATE_TABLE
529: , p5_a12 JTF_NUMBER_TABLE
530: , p5_a13 JTF_NUMBER_TABLE

Line 528: , p5_a11 JTF_DATE_TABLE

524: , p5_a7 JTF_NUMBER_TABLE
525: , p5_a8 JTF_NUMBER_TABLE
526: , p5_a9 JTF_DATE_TABLE
527: , p5_a10 JTF_NUMBER_TABLE
528: , p5_a11 JTF_DATE_TABLE
529: , p5_a12 JTF_NUMBER_TABLE
530: , p5_a13 JTF_NUMBER_TABLE
531: );
532: procedure delete_tmpt_set(p_api_version NUMBER

Line 574: , p5_a17 JTF_DATE_TABLE

570: , p5_a13 JTF_VARCHAR2_TABLE_200
571: , p5_a14 JTF_VARCHAR2_TABLE_2000
572: , p5_a15 JTF_VARCHAR2_TABLE_100
573: , p5_a16 JTF_VARCHAR2_TABLE_100
574: , p5_a17 JTF_DATE_TABLE
575: , p5_a18 JTF_DATE_TABLE
576: , p5_a19 JTF_VARCHAR2_TABLE_100
577: , p5_a20 JTF_VARCHAR2_TABLE_100
578: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 575: , p5_a18 JTF_DATE_TABLE

571: , p5_a14 JTF_VARCHAR2_TABLE_2000
572: , p5_a15 JTF_VARCHAR2_TABLE_100
573: , p5_a16 JTF_VARCHAR2_TABLE_100
574: , p5_a17 JTF_DATE_TABLE
575: , p5_a18 JTF_DATE_TABLE
576: , p5_a19 JTF_VARCHAR2_TABLE_100
577: , p5_a20 JTF_VARCHAR2_TABLE_100
578: , p5_a21 JTF_VARCHAR2_TABLE_500
579: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 595: , p5_a38 JTF_DATE_TABLE

591: , p5_a34 JTF_VARCHAR2_TABLE_500
592: , p5_a35 JTF_VARCHAR2_TABLE_500
593: , p5_a36 JTF_NUMBER_TABLE
594: , p5_a37 JTF_NUMBER_TABLE
595: , p5_a38 JTF_DATE_TABLE
596: , p5_a39 JTF_NUMBER_TABLE
597: , p5_a40 JTF_DATE_TABLE
598: , p5_a41 JTF_NUMBER_TABLE
599: , p5_a42 JTF_VARCHAR2_TABLE_100

Line 597: , p5_a40 JTF_DATE_TABLE

593: , p5_a36 JTF_NUMBER_TABLE
594: , p5_a37 JTF_NUMBER_TABLE
595: , p5_a38 JTF_DATE_TABLE
596: , p5_a39 JTF_NUMBER_TABLE
597: , p5_a40 JTF_DATE_TABLE
598: , p5_a41 JTF_NUMBER_TABLE
599: , p5_a42 JTF_VARCHAR2_TABLE_100
600: , p6_a0 out nocopy JTF_NUMBER_TABLE
601: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 617: , p6_a17 out nocopy JTF_DATE_TABLE

613: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
614: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
615: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
616: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
617: , p6_a17 out nocopy JTF_DATE_TABLE
618: , p6_a18 out nocopy JTF_DATE_TABLE
619: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
620: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
621: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 618: , p6_a18 out nocopy JTF_DATE_TABLE

614: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
615: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
616: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
617: , p6_a17 out nocopy JTF_DATE_TABLE
618: , p6_a18 out nocopy JTF_DATE_TABLE
619: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
620: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
621: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
622: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 638: , p6_a38 out nocopy JTF_DATE_TABLE

634: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
635: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
636: , p6_a36 out nocopy JTF_NUMBER_TABLE
637: , p6_a37 out nocopy JTF_NUMBER_TABLE
638: , p6_a38 out nocopy JTF_DATE_TABLE
639: , p6_a39 out nocopy JTF_NUMBER_TABLE
640: , p6_a40 out nocopy JTF_DATE_TABLE
641: , p6_a41 out nocopy JTF_NUMBER_TABLE
642: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 640: , p6_a40 out nocopy JTF_DATE_TABLE

636: , p6_a36 out nocopy JTF_NUMBER_TABLE
637: , p6_a37 out nocopy JTF_NUMBER_TABLE
638: , p6_a38 out nocopy JTF_DATE_TABLE
639: , p6_a39 out nocopy JTF_NUMBER_TABLE
640: , p6_a40 out nocopy JTF_DATE_TABLE
641: , p6_a41 out nocopy JTF_NUMBER_TABLE
642: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
643: );
644: procedure create_template(p_api_version NUMBER

Line 758: , p5_a17 JTF_DATE_TABLE

754: , p5_a13 JTF_VARCHAR2_TABLE_200
755: , p5_a14 JTF_VARCHAR2_TABLE_2000
756: , p5_a15 JTF_VARCHAR2_TABLE_100
757: , p5_a16 JTF_VARCHAR2_TABLE_100
758: , p5_a17 JTF_DATE_TABLE
759: , p5_a18 JTF_DATE_TABLE
760: , p5_a19 JTF_VARCHAR2_TABLE_100
761: , p5_a20 JTF_VARCHAR2_TABLE_100
762: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 759: , p5_a18 JTF_DATE_TABLE

755: , p5_a14 JTF_VARCHAR2_TABLE_2000
756: , p5_a15 JTF_VARCHAR2_TABLE_100
757: , p5_a16 JTF_VARCHAR2_TABLE_100
758: , p5_a17 JTF_DATE_TABLE
759: , p5_a18 JTF_DATE_TABLE
760: , p5_a19 JTF_VARCHAR2_TABLE_100
761: , p5_a20 JTF_VARCHAR2_TABLE_100
762: , p5_a21 JTF_VARCHAR2_TABLE_500
763: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 779: , p5_a38 JTF_DATE_TABLE

775: , p5_a34 JTF_VARCHAR2_TABLE_500
776: , p5_a35 JTF_VARCHAR2_TABLE_500
777: , p5_a36 JTF_NUMBER_TABLE
778: , p5_a37 JTF_NUMBER_TABLE
779: , p5_a38 JTF_DATE_TABLE
780: , p5_a39 JTF_NUMBER_TABLE
781: , p5_a40 JTF_DATE_TABLE
782: , p5_a41 JTF_NUMBER_TABLE
783: , p5_a42 JTF_VARCHAR2_TABLE_100

Line 781: , p5_a40 JTF_DATE_TABLE

777: , p5_a36 JTF_NUMBER_TABLE
778: , p5_a37 JTF_NUMBER_TABLE
779: , p5_a38 JTF_DATE_TABLE
780: , p5_a39 JTF_NUMBER_TABLE
781: , p5_a40 JTF_DATE_TABLE
782: , p5_a41 JTF_NUMBER_TABLE
783: , p5_a42 JTF_VARCHAR2_TABLE_100
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 801: , p6_a17 out nocopy JTF_DATE_TABLE

797: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
798: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
799: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
800: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a17 out nocopy JTF_DATE_TABLE
802: , p6_a18 out nocopy JTF_DATE_TABLE
803: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
805: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 802: , p6_a18 out nocopy JTF_DATE_TABLE

798: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
799: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
800: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a17 out nocopy JTF_DATE_TABLE
802: , p6_a18 out nocopy JTF_DATE_TABLE
803: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
805: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
806: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 822: , p6_a38 out nocopy JTF_DATE_TABLE

818: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
819: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
820: , p6_a36 out nocopy JTF_NUMBER_TABLE
821: , p6_a37 out nocopy JTF_NUMBER_TABLE
822: , p6_a38 out nocopy JTF_DATE_TABLE
823: , p6_a39 out nocopy JTF_NUMBER_TABLE
824: , p6_a40 out nocopy JTF_DATE_TABLE
825: , p6_a41 out nocopy JTF_NUMBER_TABLE
826: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 824: , p6_a40 out nocopy JTF_DATE_TABLE

820: , p6_a36 out nocopy JTF_NUMBER_TABLE
821: , p6_a37 out nocopy JTF_NUMBER_TABLE
822: , p6_a38 out nocopy JTF_DATE_TABLE
823: , p6_a39 out nocopy JTF_NUMBER_TABLE
824: , p6_a40 out nocopy JTF_DATE_TABLE
825: , p6_a41 out nocopy JTF_NUMBER_TABLE
826: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
827: );
828: procedure update_template(p_api_version NUMBER

Line 942: , p5_a17 JTF_DATE_TABLE

938: , p5_a13 JTF_VARCHAR2_TABLE_200
939: , p5_a14 JTF_VARCHAR2_TABLE_2000
940: , p5_a15 JTF_VARCHAR2_TABLE_100
941: , p5_a16 JTF_VARCHAR2_TABLE_100
942: , p5_a17 JTF_DATE_TABLE
943: , p5_a18 JTF_DATE_TABLE
944: , p5_a19 JTF_VARCHAR2_TABLE_100
945: , p5_a20 JTF_VARCHAR2_TABLE_100
946: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 943: , p5_a18 JTF_DATE_TABLE

939: , p5_a14 JTF_VARCHAR2_TABLE_2000
940: , p5_a15 JTF_VARCHAR2_TABLE_100
941: , p5_a16 JTF_VARCHAR2_TABLE_100
942: , p5_a17 JTF_DATE_TABLE
943: , p5_a18 JTF_DATE_TABLE
944: , p5_a19 JTF_VARCHAR2_TABLE_100
945: , p5_a20 JTF_VARCHAR2_TABLE_100
946: , p5_a21 JTF_VARCHAR2_TABLE_500
947: , p5_a22 JTF_VARCHAR2_TABLE_500

Line 963: , p5_a38 JTF_DATE_TABLE

959: , p5_a34 JTF_VARCHAR2_TABLE_500
960: , p5_a35 JTF_VARCHAR2_TABLE_500
961: , p5_a36 JTF_NUMBER_TABLE
962: , p5_a37 JTF_NUMBER_TABLE
963: , p5_a38 JTF_DATE_TABLE
964: , p5_a39 JTF_NUMBER_TABLE
965: , p5_a40 JTF_DATE_TABLE
966: , p5_a41 JTF_NUMBER_TABLE
967: , p5_a42 JTF_VARCHAR2_TABLE_100

Line 965: , p5_a40 JTF_DATE_TABLE

961: , p5_a36 JTF_NUMBER_TABLE
962: , p5_a37 JTF_NUMBER_TABLE
963: , p5_a38 JTF_DATE_TABLE
964: , p5_a39 JTF_NUMBER_TABLE
965: , p5_a40 JTF_DATE_TABLE
966: , p5_a41 JTF_NUMBER_TABLE
967: , p5_a42 JTF_VARCHAR2_TABLE_100
968: );
969: procedure delete_template(p_api_version NUMBER

Line 1052: , p5_a29 JTF_DATE_TABLE

1048: , p5_a25 JTF_VARCHAR2_TABLE_500
1049: , p5_a26 JTF_NUMBER_TABLE
1050: , p5_a27 JTF_NUMBER_TABLE
1051: , p5_a28 JTF_NUMBER_TABLE
1052: , p5_a29 JTF_DATE_TABLE
1053: , p5_a30 JTF_NUMBER_TABLE
1054: , p5_a31 JTF_DATE_TABLE
1055: , p5_a32 JTF_NUMBER_TABLE
1056: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1054: , p5_a31 JTF_DATE_TABLE

1050: , p5_a27 JTF_NUMBER_TABLE
1051: , p5_a28 JTF_NUMBER_TABLE
1052: , p5_a29 JTF_DATE_TABLE
1053: , p5_a30 JTF_NUMBER_TABLE
1054: , p5_a31 JTF_DATE_TABLE
1055: , p5_a32 JTF_NUMBER_TABLE
1056: , p6_a0 out nocopy JTF_NUMBER_TABLE
1057: , p6_a1 out nocopy JTF_NUMBER_TABLE
1058: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 1085: , p6_a29 out nocopy JTF_DATE_TABLE

1081: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1082: , p6_a26 out nocopy JTF_NUMBER_TABLE
1083: , p6_a27 out nocopy JTF_NUMBER_TABLE
1084: , p6_a28 out nocopy JTF_NUMBER_TABLE
1085: , p6_a29 out nocopy JTF_DATE_TABLE
1086: , p6_a30 out nocopy JTF_NUMBER_TABLE
1087: , p6_a31 out nocopy JTF_DATE_TABLE
1088: , p6_a32 out nocopy JTF_NUMBER_TABLE
1089: );

Line 1087: , p6_a31 out nocopy JTF_DATE_TABLE

1083: , p6_a27 out nocopy JTF_NUMBER_TABLE
1084: , p6_a28 out nocopy JTF_NUMBER_TABLE
1085: , p6_a29 out nocopy JTF_DATE_TABLE
1086: , p6_a30 out nocopy JTF_NUMBER_TABLE
1087: , p6_a31 out nocopy JTF_DATE_TABLE
1088: , p6_a32 out nocopy JTF_NUMBER_TABLE
1089: );
1090: procedure create_tmpt_lines(p_api_version NUMBER
1091: , p_init_msg_list VARCHAR2

Line 1196: , p5_a29 JTF_DATE_TABLE

1192: , p5_a25 JTF_VARCHAR2_TABLE_500
1193: , p5_a26 JTF_NUMBER_TABLE
1194: , p5_a27 JTF_NUMBER_TABLE
1195: , p5_a28 JTF_NUMBER_TABLE
1196: , p5_a29 JTF_DATE_TABLE
1197: , p5_a30 JTF_NUMBER_TABLE
1198: , p5_a31 JTF_DATE_TABLE
1199: , p5_a32 JTF_NUMBER_TABLE
1200: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1198: , p5_a31 JTF_DATE_TABLE

1194: , p5_a27 JTF_NUMBER_TABLE
1195: , p5_a28 JTF_NUMBER_TABLE
1196: , p5_a29 JTF_DATE_TABLE
1197: , p5_a30 JTF_NUMBER_TABLE
1198: , p5_a31 JTF_DATE_TABLE
1199: , p5_a32 JTF_NUMBER_TABLE
1200: , p6_a0 out nocopy JTF_NUMBER_TABLE
1201: , p6_a1 out nocopy JTF_NUMBER_TABLE
1202: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 1229: , p6_a29 out nocopy JTF_DATE_TABLE

1225: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1226: , p6_a26 out nocopy JTF_NUMBER_TABLE
1227: , p6_a27 out nocopy JTF_NUMBER_TABLE
1228: , p6_a28 out nocopy JTF_NUMBER_TABLE
1229: , p6_a29 out nocopy JTF_DATE_TABLE
1230: , p6_a30 out nocopy JTF_NUMBER_TABLE
1231: , p6_a31 out nocopy JTF_DATE_TABLE
1232: , p6_a32 out nocopy JTF_NUMBER_TABLE
1233: );

Line 1231: , p6_a31 out nocopy JTF_DATE_TABLE

1227: , p6_a27 out nocopy JTF_NUMBER_TABLE
1228: , p6_a28 out nocopy JTF_NUMBER_TABLE
1229: , p6_a29 out nocopy JTF_DATE_TABLE
1230: , p6_a30 out nocopy JTF_NUMBER_TABLE
1231: , p6_a31 out nocopy JTF_DATE_TABLE
1232: , p6_a32 out nocopy JTF_NUMBER_TABLE
1233: );
1234: procedure update_tmpt_lines(p_api_version NUMBER
1235: , p_init_msg_list VARCHAR2

Line 1340: , p5_a29 JTF_DATE_TABLE

1336: , p5_a25 JTF_VARCHAR2_TABLE_500
1337: , p5_a26 JTF_NUMBER_TABLE
1338: , p5_a27 JTF_NUMBER_TABLE
1339: , p5_a28 JTF_NUMBER_TABLE
1340: , p5_a29 JTF_DATE_TABLE
1341: , p5_a30 JTF_NUMBER_TABLE
1342: , p5_a31 JTF_DATE_TABLE
1343: , p5_a32 JTF_NUMBER_TABLE
1344: );

Line 1342: , p5_a31 JTF_DATE_TABLE

1338: , p5_a27 JTF_NUMBER_TABLE
1339: , p5_a28 JTF_NUMBER_TABLE
1340: , p5_a29 JTF_DATE_TABLE
1341: , p5_a30 JTF_NUMBER_TABLE
1342: , p5_a31 JTF_DATE_TABLE
1343: , p5_a32 JTF_NUMBER_TABLE
1344: );
1345: procedure delete_tmpt_lines(p_api_version NUMBER
1346: , p_init_msg_list VARCHAR2