DBA Data[Home] [Help]

APPS.OKL_CURE_REPORTS_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cure_reports_pub.crtv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_2000
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE

Line 32: , a10 JTF_VARCHAR2_TABLE_100

28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_2000
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE

Line 117: , a2 out nocopy JTF_VARCHAR2_TABLE_100

113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_cure_reports_pub.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_200
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE

Line 122: , a7 out nocopy JTF_VARCHAR2_TABLE_100

118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
124: , a9 out nocopy JTF_DATE_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE

Line 125: , a10 out nocopy JTF_VARCHAR2_TABLE_100

121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
124: , a9 out nocopy JTF_DATE_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE

Line 159: a2 := JTF_VARCHAR2_TABLE_100();

155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_VARCHAR2_TABLE_200();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_DATE_TABLE();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();
163: a6 := JTF_NUMBER_TABLE();

Line 164: a7 := JTF_VARCHAR2_TABLE_100();

160: a3 := JTF_DATE_TABLE();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();
163: a6 := JTF_NUMBER_TABLE();
164: a7 := JTF_VARCHAR2_TABLE_100();
165: a8 := JTF_VARCHAR2_TABLE_2000();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_NUMBER_TABLE();

Line 167: a10 := JTF_VARCHAR2_TABLE_100();

163: a6 := JTF_NUMBER_TABLE();
164: a7 := JTF_VARCHAR2_TABLE_100();
165: a8 := JTF_VARCHAR2_TABLE_2000();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();
170: a13 := JTF_NUMBER_TABLE();
171: a14 := JTF_NUMBER_TABLE();

Line 198: a2 := JTF_VARCHAR2_TABLE_100();

194: a37 := JTF_NUMBER_TABLE();
195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_VARCHAR2_TABLE_200();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_DATE_TABLE();
200: a4 := JTF_NUMBER_TABLE();
201: a5 := JTF_NUMBER_TABLE();
202: a6 := JTF_NUMBER_TABLE();

Line 203: a7 := JTF_VARCHAR2_TABLE_100();

199: a3 := JTF_DATE_TABLE();
200: a4 := JTF_NUMBER_TABLE();
201: a5 := JTF_NUMBER_TABLE();
202: a6 := JTF_NUMBER_TABLE();
203: a7 := JTF_VARCHAR2_TABLE_100();
204: a8 := JTF_VARCHAR2_TABLE_2000();
205: a9 := JTF_DATE_TABLE();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_NUMBER_TABLE();

Line 206: a10 := JTF_VARCHAR2_TABLE_100();

202: a6 := JTF_NUMBER_TABLE();
203: a7 := JTF_VARCHAR2_TABLE_100();
204: a8 := JTF_VARCHAR2_TABLE_2000();
205: a9 := JTF_DATE_TABLE();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_NUMBER_TABLE();
208: a12 := JTF_NUMBER_TABLE();
209: a13 := JTF_NUMBER_TABLE();
210: a14 := JTF_NUMBER_TABLE();

Line 331: , p5_a2 JTF_VARCHAR2_TABLE_100

327: , x_msg_count out nocopy NUMBER
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_VARCHAR2_TABLE_200
331: , p5_a2 JTF_VARCHAR2_TABLE_100
332: , p5_a3 JTF_DATE_TABLE
333: , p5_a4 JTF_NUMBER_TABLE
334: , p5_a5 JTF_NUMBER_TABLE
335: , p5_a6 JTF_NUMBER_TABLE

Line 336: , p5_a7 JTF_VARCHAR2_TABLE_100

332: , p5_a3 JTF_DATE_TABLE
333: , p5_a4 JTF_NUMBER_TABLE
334: , p5_a5 JTF_NUMBER_TABLE
335: , p5_a6 JTF_NUMBER_TABLE
336: , p5_a7 JTF_VARCHAR2_TABLE_100
337: , p5_a8 JTF_VARCHAR2_TABLE_2000
338: , p5_a9 JTF_DATE_TABLE
339: , p5_a10 JTF_VARCHAR2_TABLE_100
340: , p5_a11 JTF_NUMBER_TABLE

Line 339: , p5_a10 JTF_VARCHAR2_TABLE_100

335: , p5_a6 JTF_NUMBER_TABLE
336: , p5_a7 JTF_VARCHAR2_TABLE_100
337: , p5_a8 JTF_VARCHAR2_TABLE_2000
338: , p5_a9 JTF_DATE_TABLE
339: , p5_a10 JTF_VARCHAR2_TABLE_100
340: , p5_a11 JTF_NUMBER_TABLE
341: , p5_a12 JTF_NUMBER_TABLE
342: , p5_a13 JTF_NUMBER_TABLE
343: , p5_a14 JTF_NUMBER_TABLE

Line 369: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

365: , p5_a36 JTF_DATE_TABLE
366: , p5_a37 JTF_NUMBER_TABLE
367: , p6_a0 out nocopy JTF_NUMBER_TABLE
368: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
369: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a3 out nocopy JTF_DATE_TABLE
371: , p6_a4 out nocopy JTF_NUMBER_TABLE
372: , p6_a5 out nocopy JTF_NUMBER_TABLE
373: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 374: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

370: , p6_a3 out nocopy JTF_DATE_TABLE
371: , p6_a4 out nocopy JTF_NUMBER_TABLE
372: , p6_a5 out nocopy JTF_NUMBER_TABLE
373: , p6_a6 out nocopy JTF_NUMBER_TABLE
374: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
375: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
376: , p6_a9 out nocopy JTF_DATE_TABLE
377: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 377: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

373: , p6_a6 out nocopy JTF_NUMBER_TABLE
374: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
375: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
376: , p6_a9 out nocopy JTF_DATE_TABLE
377: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a11 out nocopy JTF_NUMBER_TABLE
379: , p6_a12 out nocopy JTF_NUMBER_TABLE
380: , p6_a13 out nocopy JTF_NUMBER_TABLE
381: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 715: , p5_a2 JTF_VARCHAR2_TABLE_100

711: , x_msg_count out nocopy NUMBER
712: , x_msg_data out nocopy VARCHAR2
713: , p5_a0 JTF_NUMBER_TABLE
714: , p5_a1 JTF_VARCHAR2_TABLE_200
715: , p5_a2 JTF_VARCHAR2_TABLE_100
716: , p5_a3 JTF_DATE_TABLE
717: , p5_a4 JTF_NUMBER_TABLE
718: , p5_a5 JTF_NUMBER_TABLE
719: , p5_a6 JTF_NUMBER_TABLE

Line 720: , p5_a7 JTF_VARCHAR2_TABLE_100

716: , p5_a3 JTF_DATE_TABLE
717: , p5_a4 JTF_NUMBER_TABLE
718: , p5_a5 JTF_NUMBER_TABLE
719: , p5_a6 JTF_NUMBER_TABLE
720: , p5_a7 JTF_VARCHAR2_TABLE_100
721: , p5_a8 JTF_VARCHAR2_TABLE_2000
722: , p5_a9 JTF_DATE_TABLE
723: , p5_a10 JTF_VARCHAR2_TABLE_100
724: , p5_a11 JTF_NUMBER_TABLE

Line 723: , p5_a10 JTF_VARCHAR2_TABLE_100

719: , p5_a6 JTF_NUMBER_TABLE
720: , p5_a7 JTF_VARCHAR2_TABLE_100
721: , p5_a8 JTF_VARCHAR2_TABLE_2000
722: , p5_a9 JTF_DATE_TABLE
723: , p5_a10 JTF_VARCHAR2_TABLE_100
724: , p5_a11 JTF_NUMBER_TABLE
725: , p5_a12 JTF_NUMBER_TABLE
726: , p5_a13 JTF_NUMBER_TABLE
727: , p5_a14 JTF_NUMBER_TABLE

Line 938: , p5_a2 JTF_VARCHAR2_TABLE_100

934: , x_msg_count out nocopy NUMBER
935: , x_msg_data out nocopy VARCHAR2
936: , p5_a0 JTF_NUMBER_TABLE
937: , p5_a1 JTF_VARCHAR2_TABLE_200
938: , p5_a2 JTF_VARCHAR2_TABLE_100
939: , p5_a3 JTF_DATE_TABLE
940: , p5_a4 JTF_NUMBER_TABLE
941: , p5_a5 JTF_NUMBER_TABLE
942: , p5_a6 JTF_NUMBER_TABLE

Line 943: , p5_a7 JTF_VARCHAR2_TABLE_100

939: , p5_a3 JTF_DATE_TABLE
940: , p5_a4 JTF_NUMBER_TABLE
941: , p5_a5 JTF_NUMBER_TABLE
942: , p5_a6 JTF_NUMBER_TABLE
943: , p5_a7 JTF_VARCHAR2_TABLE_100
944: , p5_a8 JTF_VARCHAR2_TABLE_2000
945: , p5_a9 JTF_DATE_TABLE
946: , p5_a10 JTF_VARCHAR2_TABLE_100
947: , p5_a11 JTF_NUMBER_TABLE

Line 946: , p5_a10 JTF_VARCHAR2_TABLE_100

942: , p5_a6 JTF_NUMBER_TABLE
943: , p5_a7 JTF_VARCHAR2_TABLE_100
944: , p5_a8 JTF_VARCHAR2_TABLE_2000
945: , p5_a9 JTF_DATE_TABLE
946: , p5_a10 JTF_VARCHAR2_TABLE_100
947: , p5_a11 JTF_NUMBER_TABLE
948: , p5_a12 JTF_NUMBER_TABLE
949: , p5_a13 JTF_NUMBER_TABLE
950: , p5_a14 JTF_NUMBER_TABLE

Line 976: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

972: , p5_a36 JTF_DATE_TABLE
973: , p5_a37 JTF_NUMBER_TABLE
974: , p6_a0 out nocopy JTF_NUMBER_TABLE
975: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
976: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
977: , p6_a3 out nocopy JTF_DATE_TABLE
978: , p6_a4 out nocopy JTF_NUMBER_TABLE
979: , p6_a5 out nocopy JTF_NUMBER_TABLE
980: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 981: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

977: , p6_a3 out nocopy JTF_DATE_TABLE
978: , p6_a4 out nocopy JTF_NUMBER_TABLE
979: , p6_a5 out nocopy JTF_NUMBER_TABLE
980: , p6_a6 out nocopy JTF_NUMBER_TABLE
981: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
982: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
983: , p6_a9 out nocopy JTF_DATE_TABLE
984: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 984: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

980: , p6_a6 out nocopy JTF_NUMBER_TABLE
981: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
982: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
983: , p6_a9 out nocopy JTF_DATE_TABLE
984: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a11 out nocopy JTF_NUMBER_TABLE
986: , p6_a12 out nocopy JTF_NUMBER_TABLE
987: , p6_a13 out nocopy JTF_NUMBER_TABLE
988: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 1322: , p5_a2 JTF_VARCHAR2_TABLE_100

1318: , x_msg_count out nocopy NUMBER
1319: , x_msg_data out nocopy VARCHAR2
1320: , p5_a0 JTF_NUMBER_TABLE
1321: , p5_a1 JTF_VARCHAR2_TABLE_200
1322: , p5_a2 JTF_VARCHAR2_TABLE_100
1323: , p5_a3 JTF_DATE_TABLE
1324: , p5_a4 JTF_NUMBER_TABLE
1325: , p5_a5 JTF_NUMBER_TABLE
1326: , p5_a6 JTF_NUMBER_TABLE

Line 1327: , p5_a7 JTF_VARCHAR2_TABLE_100

1323: , p5_a3 JTF_DATE_TABLE
1324: , p5_a4 JTF_NUMBER_TABLE
1325: , p5_a5 JTF_NUMBER_TABLE
1326: , p5_a6 JTF_NUMBER_TABLE
1327: , p5_a7 JTF_VARCHAR2_TABLE_100
1328: , p5_a8 JTF_VARCHAR2_TABLE_2000
1329: , p5_a9 JTF_DATE_TABLE
1330: , p5_a10 JTF_VARCHAR2_TABLE_100
1331: , p5_a11 JTF_NUMBER_TABLE

Line 1330: , p5_a10 JTF_VARCHAR2_TABLE_100

1326: , p5_a6 JTF_NUMBER_TABLE
1327: , p5_a7 JTF_VARCHAR2_TABLE_100
1328: , p5_a8 JTF_VARCHAR2_TABLE_2000
1329: , p5_a9 JTF_DATE_TABLE
1330: , p5_a10 JTF_VARCHAR2_TABLE_100
1331: , p5_a11 JTF_NUMBER_TABLE
1332: , p5_a12 JTF_NUMBER_TABLE
1333: , p5_a13 JTF_NUMBER_TABLE
1334: , p5_a14 JTF_NUMBER_TABLE

Line 1545: , p5_a2 JTF_VARCHAR2_TABLE_100

1541: , x_msg_count out nocopy NUMBER
1542: , x_msg_data out nocopy VARCHAR2
1543: , p5_a0 JTF_NUMBER_TABLE
1544: , p5_a1 JTF_VARCHAR2_TABLE_200
1545: , p5_a2 JTF_VARCHAR2_TABLE_100
1546: , p5_a3 JTF_DATE_TABLE
1547: , p5_a4 JTF_NUMBER_TABLE
1548: , p5_a5 JTF_NUMBER_TABLE
1549: , p5_a6 JTF_NUMBER_TABLE

Line 1550: , p5_a7 JTF_VARCHAR2_TABLE_100

1546: , p5_a3 JTF_DATE_TABLE
1547: , p5_a4 JTF_NUMBER_TABLE
1548: , p5_a5 JTF_NUMBER_TABLE
1549: , p5_a6 JTF_NUMBER_TABLE
1550: , p5_a7 JTF_VARCHAR2_TABLE_100
1551: , p5_a8 JTF_VARCHAR2_TABLE_2000
1552: , p5_a9 JTF_DATE_TABLE
1553: , p5_a10 JTF_VARCHAR2_TABLE_100
1554: , p5_a11 JTF_NUMBER_TABLE

Line 1553: , p5_a10 JTF_VARCHAR2_TABLE_100

1549: , p5_a6 JTF_NUMBER_TABLE
1550: , p5_a7 JTF_VARCHAR2_TABLE_100
1551: , p5_a8 JTF_VARCHAR2_TABLE_2000
1552: , p5_a9 JTF_DATE_TABLE
1553: , p5_a10 JTF_VARCHAR2_TABLE_100
1554: , p5_a11 JTF_NUMBER_TABLE
1555: , p5_a12 JTF_NUMBER_TABLE
1556: , p5_a13 JTF_NUMBER_TABLE
1557: , p5_a14 JTF_NUMBER_TABLE