DBA Data[Home] [Help]

APPS.OKL_OPT_RUL_TMP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 316: , p6_a1 JTF_NUMBER_TABLE

312: , x_msg_count out nocopy NUMBER
313: , x_msg_data out nocopy VARCHAR2
314: , p_ovd_id NUMBER
315: , p6_a0 JTF_VARCHAR2_TABLE_100
316: , p6_a1 JTF_NUMBER_TABLE
317: , p6_a2 JTF_NUMBER_TABLE
318: , p6_a3 JTF_VARCHAR2_TABLE_100
319: , p6_a4 JTF_VARCHAR2_TABLE_100
320: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 317: , p6_a2 JTF_NUMBER_TABLE

313: , x_msg_data out nocopy VARCHAR2
314: , p_ovd_id NUMBER
315: , p6_a0 JTF_VARCHAR2_TABLE_100
316: , p6_a1 JTF_NUMBER_TABLE
317: , p6_a2 JTF_NUMBER_TABLE
318: , p6_a3 JTF_VARCHAR2_TABLE_100
319: , p6_a4 JTF_VARCHAR2_TABLE_100
320: , p6_a5 JTF_VARCHAR2_TABLE_100
321: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 328: , p6_a13 JTF_NUMBER_TABLE

324: , p6_a9 JTF_VARCHAR2_TABLE_200
325: , p6_a10 JTF_VARCHAR2_TABLE_100
326: , p6_a11 JTF_VARCHAR2_TABLE_100
327: , p6_a12 JTF_VARCHAR2_TABLE_100
328: , p6_a13 JTF_NUMBER_TABLE
329: , p6_a14 JTF_NUMBER_TABLE
330: , p6_a15 JTF_NUMBER_TABLE
331: , p6_a16 JTF_VARCHAR2_TABLE_100
332: , p6_a17 JTF_VARCHAR2_TABLE_2000

Line 329: , p6_a14 JTF_NUMBER_TABLE

325: , p6_a10 JTF_VARCHAR2_TABLE_100
326: , p6_a11 JTF_VARCHAR2_TABLE_100
327: , p6_a12 JTF_VARCHAR2_TABLE_100
328: , p6_a13 JTF_NUMBER_TABLE
329: , p6_a14 JTF_NUMBER_TABLE
330: , p6_a15 JTF_NUMBER_TABLE
331: , p6_a16 JTF_VARCHAR2_TABLE_100
332: , p6_a17 JTF_VARCHAR2_TABLE_2000
333: , p6_a18 JTF_VARCHAR2_TABLE_100

Line 330: , p6_a15 JTF_NUMBER_TABLE

326: , p6_a11 JTF_VARCHAR2_TABLE_100
327: , p6_a12 JTF_VARCHAR2_TABLE_100
328: , p6_a13 JTF_NUMBER_TABLE
329: , p6_a14 JTF_NUMBER_TABLE
330: , p6_a15 JTF_NUMBER_TABLE
331: , p6_a16 JTF_VARCHAR2_TABLE_100
332: , p6_a17 JTF_VARCHAR2_TABLE_2000
333: , p6_a18 JTF_VARCHAR2_TABLE_100
334: , p6_a19 JTF_VARCHAR2_TABLE_100

Line 350: , p6_a35 JTF_NUMBER_TABLE

346: , p6_a31 JTF_VARCHAR2_TABLE_500
347: , p6_a32 JTF_VARCHAR2_TABLE_500
348: , p6_a33 JTF_VARCHAR2_TABLE_500
349: , p6_a34 JTF_VARCHAR2_TABLE_500
350: , p6_a35 JTF_NUMBER_TABLE
351: , p6_a36 JTF_DATE_TABLE
352: , p6_a37 JTF_NUMBER_TABLE
353: , p6_a38 JTF_DATE_TABLE
354: , p6_a39 JTF_NUMBER_TABLE

Line 352: , p6_a37 JTF_NUMBER_TABLE

348: , p6_a33 JTF_VARCHAR2_TABLE_500
349: , p6_a34 JTF_VARCHAR2_TABLE_500
350: , p6_a35 JTF_NUMBER_TABLE
351: , p6_a36 JTF_DATE_TABLE
352: , p6_a37 JTF_NUMBER_TABLE
353: , p6_a38 JTF_DATE_TABLE
354: , p6_a39 JTF_NUMBER_TABLE
355: , p6_a40 JTF_VARCHAR2_TABLE_100
356: , p6_a41 JTF_VARCHAR2_TABLE_500

Line 354: , p6_a39 JTF_NUMBER_TABLE

350: , p6_a35 JTF_NUMBER_TABLE
351: , p6_a36 JTF_DATE_TABLE
352: , p6_a37 JTF_NUMBER_TABLE
353: , p6_a38 JTF_DATE_TABLE
354: , p6_a39 JTF_NUMBER_TABLE
355: , p6_a40 JTF_VARCHAR2_TABLE_100
356: , p6_a41 JTF_VARCHAR2_TABLE_500
357: , p6_a42 JTF_VARCHAR2_TABLE_500
358: , p6_a43 JTF_VARCHAR2_TABLE_500

Line 375: , p6_a60 JTF_NUMBER_TABLE

371: , p6_a56 JTF_VARCHAR2_TABLE_100
372: , p6_a57 JTF_VARCHAR2_TABLE_100
373: , p6_a58 JTF_VARCHAR2_TABLE_100
374: , p6_a59 JTF_VARCHAR2_TABLE_100
375: , p6_a60 JTF_NUMBER_TABLE
376: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
377: , p7_a1 out nocopy JTF_NUMBER_TABLE
378: , p7_a2 out nocopy JTF_NUMBER_TABLE
379: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 377: , p7_a1 out nocopy JTF_NUMBER_TABLE

373: , p6_a58 JTF_VARCHAR2_TABLE_100
374: , p6_a59 JTF_VARCHAR2_TABLE_100
375: , p6_a60 JTF_NUMBER_TABLE
376: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
377: , p7_a1 out nocopy JTF_NUMBER_TABLE
378: , p7_a2 out nocopy JTF_NUMBER_TABLE
379: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
380: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
381: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 378: , p7_a2 out nocopy JTF_NUMBER_TABLE

374: , p6_a59 JTF_VARCHAR2_TABLE_100
375: , p6_a60 JTF_NUMBER_TABLE
376: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
377: , p7_a1 out nocopy JTF_NUMBER_TABLE
378: , p7_a2 out nocopy JTF_NUMBER_TABLE
379: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
380: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
381: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
382: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 389: , p7_a13 out nocopy JTF_NUMBER_TABLE

385: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_200
386: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
387: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
388: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
389: , p7_a13 out nocopy JTF_NUMBER_TABLE
390: , p7_a14 out nocopy JTF_NUMBER_TABLE
391: , p7_a15 out nocopy JTF_NUMBER_TABLE
392: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
393: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 390: , p7_a14 out nocopy JTF_NUMBER_TABLE

386: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
387: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
388: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
389: , p7_a13 out nocopy JTF_NUMBER_TABLE
390: , p7_a14 out nocopy JTF_NUMBER_TABLE
391: , p7_a15 out nocopy JTF_NUMBER_TABLE
392: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
393: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
394: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 391: , p7_a15 out nocopy JTF_NUMBER_TABLE

387: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
388: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
389: , p7_a13 out nocopy JTF_NUMBER_TABLE
390: , p7_a14 out nocopy JTF_NUMBER_TABLE
391: , p7_a15 out nocopy JTF_NUMBER_TABLE
392: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
393: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
394: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
395: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 411: , p7_a35 out nocopy JTF_NUMBER_TABLE

407: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_500
408: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_500
409: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
410: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
411: , p7_a35 out nocopy JTF_NUMBER_TABLE
412: , p7_a36 out nocopy JTF_DATE_TABLE
413: , p7_a37 out nocopy JTF_NUMBER_TABLE
414: , p7_a38 out nocopy JTF_DATE_TABLE
415: , p7_a39 out nocopy JTF_NUMBER_TABLE

Line 413: , p7_a37 out nocopy JTF_NUMBER_TABLE

409: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
410: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
411: , p7_a35 out nocopy JTF_NUMBER_TABLE
412: , p7_a36 out nocopy JTF_DATE_TABLE
413: , p7_a37 out nocopy JTF_NUMBER_TABLE
414: , p7_a38 out nocopy JTF_DATE_TABLE
415: , p7_a39 out nocopy JTF_NUMBER_TABLE
416: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 415: , p7_a39 out nocopy JTF_NUMBER_TABLE

411: , p7_a35 out nocopy JTF_NUMBER_TABLE
412: , p7_a36 out nocopy JTF_DATE_TABLE
413: , p7_a37 out nocopy JTF_NUMBER_TABLE
414: , p7_a38 out nocopy JTF_DATE_TABLE
415: , p7_a39 out nocopy JTF_NUMBER_TABLE
416: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500
418: , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
419: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 436: , p7_a60 out nocopy JTF_NUMBER_TABLE

432: , p7_a56 out nocopy JTF_VARCHAR2_TABLE_100
433: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
434: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
435: , p7_a59 out nocopy JTF_VARCHAR2_TABLE_100
436: , p7_a60 out nocopy JTF_NUMBER_TABLE
437: )
438:
439: as
440: ddp_rgrv_tbl okl_opt_rul_tmp_pvt.rgrv_tbl_type;

Line 887: , p5_a1 JTF_NUMBER_TABLE

883: , x_return_status out nocopy VARCHAR2
884: , x_msg_count out nocopy NUMBER
885: , x_msg_data out nocopy VARCHAR2
886: , p5_a0 JTF_VARCHAR2_TABLE_100
887: , p5_a1 JTF_NUMBER_TABLE
888: , p5_a2 JTF_NUMBER_TABLE
889: , p5_a3 JTF_VARCHAR2_TABLE_100
890: , p5_a4 JTF_VARCHAR2_TABLE_100
891: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 888: , p5_a2 JTF_NUMBER_TABLE

884: , x_msg_count out nocopy NUMBER
885: , x_msg_data out nocopy VARCHAR2
886: , p5_a0 JTF_VARCHAR2_TABLE_100
887: , p5_a1 JTF_NUMBER_TABLE
888: , p5_a2 JTF_NUMBER_TABLE
889: , p5_a3 JTF_VARCHAR2_TABLE_100
890: , p5_a4 JTF_VARCHAR2_TABLE_100
891: , p5_a5 JTF_VARCHAR2_TABLE_100
892: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 899: , p5_a13 JTF_NUMBER_TABLE

895: , p5_a9 JTF_VARCHAR2_TABLE_200
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_VARCHAR2_TABLE_100
898: , p5_a12 JTF_VARCHAR2_TABLE_100
899: , p5_a13 JTF_NUMBER_TABLE
900: , p5_a14 JTF_NUMBER_TABLE
901: , p5_a15 JTF_NUMBER_TABLE
902: , p5_a16 JTF_VARCHAR2_TABLE_100
903: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 900: , p5_a14 JTF_NUMBER_TABLE

896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_VARCHAR2_TABLE_100
898: , p5_a12 JTF_VARCHAR2_TABLE_100
899: , p5_a13 JTF_NUMBER_TABLE
900: , p5_a14 JTF_NUMBER_TABLE
901: , p5_a15 JTF_NUMBER_TABLE
902: , p5_a16 JTF_VARCHAR2_TABLE_100
903: , p5_a17 JTF_VARCHAR2_TABLE_2000
904: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 901: , p5_a15 JTF_NUMBER_TABLE

897: , p5_a11 JTF_VARCHAR2_TABLE_100
898: , p5_a12 JTF_VARCHAR2_TABLE_100
899: , p5_a13 JTF_NUMBER_TABLE
900: , p5_a14 JTF_NUMBER_TABLE
901: , p5_a15 JTF_NUMBER_TABLE
902: , p5_a16 JTF_VARCHAR2_TABLE_100
903: , p5_a17 JTF_VARCHAR2_TABLE_2000
904: , p5_a18 JTF_VARCHAR2_TABLE_100
905: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 921: , p5_a35 JTF_NUMBER_TABLE

917: , p5_a31 JTF_VARCHAR2_TABLE_500
918: , p5_a32 JTF_VARCHAR2_TABLE_500
919: , p5_a33 JTF_VARCHAR2_TABLE_500
920: , p5_a34 JTF_VARCHAR2_TABLE_500
921: , p5_a35 JTF_NUMBER_TABLE
922: , p5_a36 JTF_DATE_TABLE
923: , p5_a37 JTF_NUMBER_TABLE
924: , p5_a38 JTF_DATE_TABLE
925: , p5_a39 JTF_NUMBER_TABLE

Line 923: , p5_a37 JTF_NUMBER_TABLE

919: , p5_a33 JTF_VARCHAR2_TABLE_500
920: , p5_a34 JTF_VARCHAR2_TABLE_500
921: , p5_a35 JTF_NUMBER_TABLE
922: , p5_a36 JTF_DATE_TABLE
923: , p5_a37 JTF_NUMBER_TABLE
924: , p5_a38 JTF_DATE_TABLE
925: , p5_a39 JTF_NUMBER_TABLE
926: , p5_a40 JTF_VARCHAR2_TABLE_100
927: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 925: , p5_a39 JTF_NUMBER_TABLE

921: , p5_a35 JTF_NUMBER_TABLE
922: , p5_a36 JTF_DATE_TABLE
923: , p5_a37 JTF_NUMBER_TABLE
924: , p5_a38 JTF_DATE_TABLE
925: , p5_a39 JTF_NUMBER_TABLE
926: , p5_a40 JTF_VARCHAR2_TABLE_100
927: , p5_a41 JTF_VARCHAR2_TABLE_500
928: , p5_a42 JTF_VARCHAR2_TABLE_500
929: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 946: , p5_a60 JTF_NUMBER_TABLE

942: , p5_a56 JTF_VARCHAR2_TABLE_100
943: , p5_a57 JTF_VARCHAR2_TABLE_100
944: , p5_a58 JTF_VARCHAR2_TABLE_100
945: , p5_a59 JTF_VARCHAR2_TABLE_100
946: , p5_a60 JTF_NUMBER_TABLE
947: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
948: , p6_a1 out nocopy JTF_NUMBER_TABLE
949: , p6_a2 out nocopy JTF_NUMBER_TABLE
950: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 948: , p6_a1 out nocopy JTF_NUMBER_TABLE

944: , p5_a58 JTF_VARCHAR2_TABLE_100
945: , p5_a59 JTF_VARCHAR2_TABLE_100
946: , p5_a60 JTF_NUMBER_TABLE
947: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
948: , p6_a1 out nocopy JTF_NUMBER_TABLE
949: , p6_a2 out nocopy JTF_NUMBER_TABLE
950: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
951: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
952: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 949: , p6_a2 out nocopy JTF_NUMBER_TABLE

945: , p5_a59 JTF_VARCHAR2_TABLE_100
946: , p5_a60 JTF_NUMBER_TABLE
947: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
948: , p6_a1 out nocopy JTF_NUMBER_TABLE
949: , p6_a2 out nocopy JTF_NUMBER_TABLE
950: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
951: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
952: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
953: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 960: , p6_a13 out nocopy JTF_NUMBER_TABLE

956: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
957: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
958: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
959: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a13 out nocopy JTF_NUMBER_TABLE
961: , p6_a14 out nocopy JTF_NUMBER_TABLE
962: , p6_a15 out nocopy JTF_NUMBER_TABLE
963: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 961: , p6_a14 out nocopy JTF_NUMBER_TABLE

957: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
958: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
959: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a13 out nocopy JTF_NUMBER_TABLE
961: , p6_a14 out nocopy JTF_NUMBER_TABLE
962: , p6_a15 out nocopy JTF_NUMBER_TABLE
963: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
965: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 962: , p6_a15 out nocopy JTF_NUMBER_TABLE

958: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
959: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
960: , p6_a13 out nocopy JTF_NUMBER_TABLE
961: , p6_a14 out nocopy JTF_NUMBER_TABLE
962: , p6_a15 out nocopy JTF_NUMBER_TABLE
963: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
964: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
965: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
966: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 982: , p6_a35 out nocopy JTF_NUMBER_TABLE

978: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
979: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
980: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
981: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
982: , p6_a35 out nocopy JTF_NUMBER_TABLE
983: , p6_a36 out nocopy JTF_DATE_TABLE
984: , p6_a37 out nocopy JTF_NUMBER_TABLE
985: , p6_a38 out nocopy JTF_DATE_TABLE
986: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 984: , p6_a37 out nocopy JTF_NUMBER_TABLE

980: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
981: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
982: , p6_a35 out nocopy JTF_NUMBER_TABLE
983: , p6_a36 out nocopy JTF_DATE_TABLE
984: , p6_a37 out nocopy JTF_NUMBER_TABLE
985: , p6_a38 out nocopy JTF_DATE_TABLE
986: , p6_a39 out nocopy JTF_NUMBER_TABLE
987: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
988: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 986: , p6_a39 out nocopy JTF_NUMBER_TABLE

982: , p6_a35 out nocopy JTF_NUMBER_TABLE
983: , p6_a36 out nocopy JTF_DATE_TABLE
984: , p6_a37 out nocopy JTF_NUMBER_TABLE
985: , p6_a38 out nocopy JTF_DATE_TABLE
986: , p6_a39 out nocopy JTF_NUMBER_TABLE
987: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
988: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
989: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
990: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 1007: , p6_a60 out nocopy JTF_NUMBER_TABLE

1003: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
1004: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p6_a60 out nocopy JTF_NUMBER_TABLE
1008: )
1009:
1010: as
1011: ddp_rgrv_tbl okl_opt_rul_tmp_pvt.rgrv_tbl_type;

Line 1329: , p5_a1 JTF_NUMBER_TABLE

1325: , x_return_status out nocopy VARCHAR2
1326: , x_msg_count out nocopy NUMBER
1327: , x_msg_data out nocopy VARCHAR2
1328: , p5_a0 JTF_VARCHAR2_TABLE_100
1329: , p5_a1 JTF_NUMBER_TABLE
1330: , p5_a2 JTF_NUMBER_TABLE
1331: , p5_a3 JTF_VARCHAR2_TABLE_100
1332: , p5_a4 JTF_VARCHAR2_TABLE_100
1333: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1330: , p5_a2 JTF_NUMBER_TABLE

1326: , x_msg_count out nocopy NUMBER
1327: , x_msg_data out nocopy VARCHAR2
1328: , p5_a0 JTF_VARCHAR2_TABLE_100
1329: , p5_a1 JTF_NUMBER_TABLE
1330: , p5_a2 JTF_NUMBER_TABLE
1331: , p5_a3 JTF_VARCHAR2_TABLE_100
1332: , p5_a4 JTF_VARCHAR2_TABLE_100
1333: , p5_a5 JTF_VARCHAR2_TABLE_100
1334: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1341: , p5_a13 JTF_NUMBER_TABLE

1337: , p5_a9 JTF_VARCHAR2_TABLE_200
1338: , p5_a10 JTF_VARCHAR2_TABLE_100
1339: , p5_a11 JTF_VARCHAR2_TABLE_100
1340: , p5_a12 JTF_VARCHAR2_TABLE_100
1341: , p5_a13 JTF_NUMBER_TABLE
1342: , p5_a14 JTF_NUMBER_TABLE
1343: , p5_a15 JTF_NUMBER_TABLE
1344: , p5_a16 JTF_VARCHAR2_TABLE_100
1345: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 1342: , p5_a14 JTF_NUMBER_TABLE

1338: , p5_a10 JTF_VARCHAR2_TABLE_100
1339: , p5_a11 JTF_VARCHAR2_TABLE_100
1340: , p5_a12 JTF_VARCHAR2_TABLE_100
1341: , p5_a13 JTF_NUMBER_TABLE
1342: , p5_a14 JTF_NUMBER_TABLE
1343: , p5_a15 JTF_NUMBER_TABLE
1344: , p5_a16 JTF_VARCHAR2_TABLE_100
1345: , p5_a17 JTF_VARCHAR2_TABLE_2000
1346: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 1343: , p5_a15 JTF_NUMBER_TABLE

1339: , p5_a11 JTF_VARCHAR2_TABLE_100
1340: , p5_a12 JTF_VARCHAR2_TABLE_100
1341: , p5_a13 JTF_NUMBER_TABLE
1342: , p5_a14 JTF_NUMBER_TABLE
1343: , p5_a15 JTF_NUMBER_TABLE
1344: , p5_a16 JTF_VARCHAR2_TABLE_100
1345: , p5_a17 JTF_VARCHAR2_TABLE_2000
1346: , p5_a18 JTF_VARCHAR2_TABLE_100
1347: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 1363: , p5_a35 JTF_NUMBER_TABLE

1359: , p5_a31 JTF_VARCHAR2_TABLE_500
1360: , p5_a32 JTF_VARCHAR2_TABLE_500
1361: , p5_a33 JTF_VARCHAR2_TABLE_500
1362: , p5_a34 JTF_VARCHAR2_TABLE_500
1363: , p5_a35 JTF_NUMBER_TABLE
1364: , p5_a36 JTF_DATE_TABLE
1365: , p5_a37 JTF_NUMBER_TABLE
1366: , p5_a38 JTF_DATE_TABLE
1367: , p5_a39 JTF_NUMBER_TABLE

Line 1365: , p5_a37 JTF_NUMBER_TABLE

1361: , p5_a33 JTF_VARCHAR2_TABLE_500
1362: , p5_a34 JTF_VARCHAR2_TABLE_500
1363: , p5_a35 JTF_NUMBER_TABLE
1364: , p5_a36 JTF_DATE_TABLE
1365: , p5_a37 JTF_NUMBER_TABLE
1366: , p5_a38 JTF_DATE_TABLE
1367: , p5_a39 JTF_NUMBER_TABLE
1368: , p5_a40 JTF_VARCHAR2_TABLE_100
1369: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 1367: , p5_a39 JTF_NUMBER_TABLE

1363: , p5_a35 JTF_NUMBER_TABLE
1364: , p5_a36 JTF_DATE_TABLE
1365: , p5_a37 JTF_NUMBER_TABLE
1366: , p5_a38 JTF_DATE_TABLE
1367: , p5_a39 JTF_NUMBER_TABLE
1368: , p5_a40 JTF_VARCHAR2_TABLE_100
1369: , p5_a41 JTF_VARCHAR2_TABLE_500
1370: , p5_a42 JTF_VARCHAR2_TABLE_500
1371: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 1388: , p5_a60 JTF_NUMBER_TABLE

1384: , p5_a56 JTF_VARCHAR2_TABLE_100
1385: , p5_a57 JTF_VARCHAR2_TABLE_100
1386: , p5_a58 JTF_VARCHAR2_TABLE_100
1387: , p5_a59 JTF_VARCHAR2_TABLE_100
1388: , p5_a60 JTF_NUMBER_TABLE
1389: )
1390:
1391: as
1392: ddp_rgrv_tbl okl_opt_rul_tmp_pvt.rgrv_tbl_type;