DBA Data[Home] [Help]

APPS.CS_CTR_CAPTURE_READING_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p4(t out nocopy cs_ctr_capture_reading_pub.ctr_rdg_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100

Line 30: , a8 JTF_VARCHAR2_TABLE_100

26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_200
34: , a12 JTF_VARCHAR2_TABLE_200

Line 48: , a26 JTF_VARCHAR2_TABLE_100

44: , a22 JTF_VARCHAR2_TABLE_200
45: , a23 JTF_VARCHAR2_TABLE_200
46: , a24 JTF_VARCHAR2_TABLE_200
47: , a25 JTF_VARCHAR2_TABLE_200
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_2000
52: , a30 JTF_NUMBER_TABLE

Line 49: , a27 JTF_VARCHAR2_TABLE_100

45: , a23 JTF_VARCHAR2_TABLE_200
46: , a24 JTF_VARCHAR2_TABLE_200
47: , a25 JTF_VARCHAR2_TABLE_200
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_2000
52: , a30 JTF_NUMBER_TABLE
53: ) as

Line 50: , a28 JTF_VARCHAR2_TABLE_100

46: , a24 JTF_VARCHAR2_TABLE_200
47: , a25 JTF_VARCHAR2_TABLE_200
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_2000
52: , a30 JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;

Line 105: , a4 out nocopy JTF_VARCHAR2_TABLE_100

101: procedure rosetta_table_copy_out_p4(t cs_ctr_capture_reading_pub.ctr_rdg_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_DATE_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_VARCHAR2_TABLE_300
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_NUMBER_TABLE
109: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , a8 out nocopy JTF_VARCHAR2_TABLE_100

105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_VARCHAR2_TABLE_300
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_NUMBER_TABLE
109: , a8 out nocopy JTF_VARCHAR2_TABLE_100
110: , a9 out nocopy JTF_NUMBER_TABLE
111: , a10 out nocopy JTF_NUMBER_TABLE
112: , a11 out nocopy JTF_VARCHAR2_TABLE_200
113: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 127: , a26 out nocopy JTF_VARCHAR2_TABLE_100

123: , a22 out nocopy JTF_VARCHAR2_TABLE_200
124: , a23 out nocopy JTF_VARCHAR2_TABLE_200
125: , a24 out nocopy JTF_VARCHAR2_TABLE_200
126: , a25 out nocopy JTF_VARCHAR2_TABLE_200
127: , a26 out nocopy JTF_VARCHAR2_TABLE_100
128: , a27 out nocopy JTF_VARCHAR2_TABLE_100
129: , a28 out nocopy JTF_VARCHAR2_TABLE_100
130: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a30 out nocopy JTF_NUMBER_TABLE

Line 128: , a27 out nocopy JTF_VARCHAR2_TABLE_100

124: , a23 out nocopy JTF_VARCHAR2_TABLE_200
125: , a24 out nocopy JTF_VARCHAR2_TABLE_200
126: , a25 out nocopy JTF_VARCHAR2_TABLE_200
127: , a26 out nocopy JTF_VARCHAR2_TABLE_100
128: , a27 out nocopy JTF_VARCHAR2_TABLE_100
129: , a28 out nocopy JTF_VARCHAR2_TABLE_100
130: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a30 out nocopy JTF_NUMBER_TABLE
132: ) as

Line 129: , a28 out nocopy JTF_VARCHAR2_TABLE_100

125: , a24 out nocopy JTF_VARCHAR2_TABLE_200
126: , a25 out nocopy JTF_VARCHAR2_TABLE_200
127: , a26 out nocopy JTF_VARCHAR2_TABLE_100
128: , a27 out nocopy JTF_VARCHAR2_TABLE_100
129: , a28 out nocopy JTF_VARCHAR2_TABLE_100
130: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a30 out nocopy JTF_NUMBER_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;

Line 140: a4 := JTF_VARCHAR2_TABLE_100();

136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_DATE_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_300();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_VARCHAR2_TABLE_100();

Line 144: a8 := JTF_VARCHAR2_TABLE_100();

140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_300();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_NUMBER_TABLE();
147: a11 := JTF_VARCHAR2_TABLE_200();
148: a12 := JTF_VARCHAR2_TABLE_200();

Line 162: a26 := JTF_VARCHAR2_TABLE_100();

158: a22 := JTF_VARCHAR2_TABLE_200();
159: a23 := JTF_VARCHAR2_TABLE_200();
160: a24 := JTF_VARCHAR2_TABLE_200();
161: a25 := JTF_VARCHAR2_TABLE_200();
162: a26 := JTF_VARCHAR2_TABLE_100();
163: a27 := JTF_VARCHAR2_TABLE_100();
164: a28 := JTF_VARCHAR2_TABLE_100();
165: a29 := JTF_VARCHAR2_TABLE_2000();
166: a30 := JTF_NUMBER_TABLE();

Line 163: a27 := JTF_VARCHAR2_TABLE_100();

159: a23 := JTF_VARCHAR2_TABLE_200();
160: a24 := JTF_VARCHAR2_TABLE_200();
161: a25 := JTF_VARCHAR2_TABLE_200();
162: a26 := JTF_VARCHAR2_TABLE_100();
163: a27 := JTF_VARCHAR2_TABLE_100();
164: a28 := JTF_VARCHAR2_TABLE_100();
165: a29 := JTF_VARCHAR2_TABLE_2000();
166: a30 := JTF_NUMBER_TABLE();
167: else

Line 164: a28 := JTF_VARCHAR2_TABLE_100();

160: a24 := JTF_VARCHAR2_TABLE_200();
161: a25 := JTF_VARCHAR2_TABLE_200();
162: a26 := JTF_VARCHAR2_TABLE_100();
163: a27 := JTF_VARCHAR2_TABLE_100();
164: a28 := JTF_VARCHAR2_TABLE_100();
165: a29 := JTF_VARCHAR2_TABLE_2000();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();

Line 172: a4 := JTF_VARCHAR2_TABLE_100();

168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_DATE_TABLE();
171: a3 := JTF_NUMBER_TABLE();
172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_VARCHAR2_TABLE_300();
174: a6 := JTF_NUMBER_TABLE();
175: a7 := JTF_NUMBER_TABLE();
176: a8 := JTF_VARCHAR2_TABLE_100();

Line 176: a8 := JTF_VARCHAR2_TABLE_100();

172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_VARCHAR2_TABLE_300();
174: a6 := JTF_NUMBER_TABLE();
175: a7 := JTF_NUMBER_TABLE();
176: a8 := JTF_VARCHAR2_TABLE_100();
177: a9 := JTF_NUMBER_TABLE();
178: a10 := JTF_NUMBER_TABLE();
179: a11 := JTF_VARCHAR2_TABLE_200();
180: a12 := JTF_VARCHAR2_TABLE_200();

Line 194: a26 := JTF_VARCHAR2_TABLE_100();

190: a22 := JTF_VARCHAR2_TABLE_200();
191: a23 := JTF_VARCHAR2_TABLE_200();
192: a24 := JTF_VARCHAR2_TABLE_200();
193: a25 := JTF_VARCHAR2_TABLE_200();
194: a26 := JTF_VARCHAR2_TABLE_100();
195: a27 := JTF_VARCHAR2_TABLE_100();
196: a28 := JTF_VARCHAR2_TABLE_100();
197: a29 := JTF_VARCHAR2_TABLE_2000();
198: a30 := JTF_NUMBER_TABLE();

Line 195: a27 := JTF_VARCHAR2_TABLE_100();

191: a23 := JTF_VARCHAR2_TABLE_200();
192: a24 := JTF_VARCHAR2_TABLE_200();
193: a25 := JTF_VARCHAR2_TABLE_200();
194: a26 := JTF_VARCHAR2_TABLE_100();
195: a27 := JTF_VARCHAR2_TABLE_100();
196: a28 := JTF_VARCHAR2_TABLE_100();
197: a29 := JTF_VARCHAR2_TABLE_2000();
198: a30 := JTF_NUMBER_TABLE();
199: if t.count > 0 then

Line 196: a28 := JTF_VARCHAR2_TABLE_100();

192: a24 := JTF_VARCHAR2_TABLE_200();
193: a25 := JTF_VARCHAR2_TABLE_200();
194: a26 := JTF_VARCHAR2_TABLE_100();
195: a27 := JTF_VARCHAR2_TABLE_100();
196: a28 := JTF_VARCHAR2_TABLE_100();
197: a29 := JTF_VARCHAR2_TABLE_2000();
198: a30 := JTF_NUMBER_TABLE();
199: if t.count > 0 then
200: a0.extend(t.count);

Line 295: , a20 JTF_VARCHAR2_TABLE_100

291: , a16 JTF_VARCHAR2_TABLE_200
292: , a17 JTF_VARCHAR2_TABLE_200
293: , a18 JTF_VARCHAR2_TABLE_200
294: , a19 JTF_VARCHAR2_TABLE_200
295: , a20 JTF_VARCHAR2_TABLE_100
296: ) as
297: ddindx binary_integer; indx binary_integer;
298: begin
299: if a0 is not null and a0.count > 0 then

Line 354: , a20 out nocopy JTF_VARCHAR2_TABLE_100

350: , a16 out nocopy JTF_VARCHAR2_TABLE_200
351: , a17 out nocopy JTF_VARCHAR2_TABLE_200
352: , a18 out nocopy JTF_VARCHAR2_TABLE_200
353: , a19 out nocopy JTF_VARCHAR2_TABLE_200
354: , a20 out nocopy JTF_VARCHAR2_TABLE_100
355: ) as
356: ddindx binary_integer; indx binary_integer;
357: begin
358: if t is null or t.count = 0 then

Line 379: a20 := JTF_VARCHAR2_TABLE_100();

375: a16 := JTF_VARCHAR2_TABLE_200();
376: a17 := JTF_VARCHAR2_TABLE_200();
377: a18 := JTF_VARCHAR2_TABLE_200();
378: a19 := JTF_VARCHAR2_TABLE_200();
379: a20 := JTF_VARCHAR2_TABLE_100();
380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_DATE_TABLE();

Line 401: a20 := JTF_VARCHAR2_TABLE_100();

397: a16 := JTF_VARCHAR2_TABLE_200();
398: a17 := JTF_VARCHAR2_TABLE_200();
399: a18 := JTF_VARCHAR2_TABLE_200();
400: a19 := JTF_VARCHAR2_TABLE_200();
401: a20 := JTF_VARCHAR2_TABLE_100();
402: if t.count > 0 then
403: a0.extend(t.count);
404: a1.extend(t.count);
405: a2.extend(t.count);

Line 466: , p5_a4 JTF_VARCHAR2_TABLE_100

462: , p5_a0 JTF_NUMBER_TABLE
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_DATE_TABLE
465: , p5_a3 JTF_NUMBER_TABLE
466: , p5_a4 JTF_VARCHAR2_TABLE_100
467: , p5_a5 JTF_VARCHAR2_TABLE_300
468: , p5_a6 JTF_NUMBER_TABLE
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 470: , p5_a8 JTF_VARCHAR2_TABLE_100

466: , p5_a4 JTF_VARCHAR2_TABLE_100
467: , p5_a5 JTF_VARCHAR2_TABLE_300
468: , p5_a6 JTF_NUMBER_TABLE
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_VARCHAR2_TABLE_200
474: , p5_a12 JTF_VARCHAR2_TABLE_200

Line 488: , p5_a26 JTF_VARCHAR2_TABLE_100

484: , p5_a22 JTF_VARCHAR2_TABLE_200
485: , p5_a23 JTF_VARCHAR2_TABLE_200
486: , p5_a24 JTF_VARCHAR2_TABLE_200
487: , p5_a25 JTF_VARCHAR2_TABLE_200
488: , p5_a26 JTF_VARCHAR2_TABLE_100
489: , p5_a27 JTF_VARCHAR2_TABLE_100
490: , p5_a28 JTF_VARCHAR2_TABLE_100
491: , p5_a29 JTF_VARCHAR2_TABLE_2000
492: , p5_a30 JTF_NUMBER_TABLE

Line 489: , p5_a27 JTF_VARCHAR2_TABLE_100

485: , p5_a23 JTF_VARCHAR2_TABLE_200
486: , p5_a24 JTF_VARCHAR2_TABLE_200
487: , p5_a25 JTF_VARCHAR2_TABLE_200
488: , p5_a26 JTF_VARCHAR2_TABLE_100
489: , p5_a27 JTF_VARCHAR2_TABLE_100
490: , p5_a28 JTF_VARCHAR2_TABLE_100
491: , p5_a29 JTF_VARCHAR2_TABLE_2000
492: , p5_a30 JTF_NUMBER_TABLE
493: , p6_a0 JTF_NUMBER_TABLE

Line 490: , p5_a28 JTF_VARCHAR2_TABLE_100

486: , p5_a24 JTF_VARCHAR2_TABLE_200
487: , p5_a25 JTF_VARCHAR2_TABLE_200
488: , p5_a26 JTF_VARCHAR2_TABLE_100
489: , p5_a27 JTF_VARCHAR2_TABLE_100
490: , p5_a28 JTF_VARCHAR2_TABLE_100
491: , p5_a29 JTF_VARCHAR2_TABLE_2000
492: , p5_a30 JTF_NUMBER_TABLE
493: , p6_a0 JTF_NUMBER_TABLE
494: , p6_a1 JTF_NUMBER_TABLE

Line 513: , p6_a20 JTF_VARCHAR2_TABLE_100

509: , p6_a16 JTF_VARCHAR2_TABLE_200
510: , p6_a17 JTF_VARCHAR2_TABLE_200
511: , p6_a18 JTF_VARCHAR2_TABLE_200
512: , p6_a19 JTF_VARCHAR2_TABLE_200
513: , p6_a20 JTF_VARCHAR2_TABLE_100
514: , x_return_status out nocopy VARCHAR2
515: , x_msg_count out nocopy NUMBER
516: , x_msg_data out nocopy VARCHAR2
517: , p4_a0 NUMBER := 0-1962.0724

Line 668: , p5_a4 JTF_VARCHAR2_TABLE_100

664: , p5_a0 JTF_NUMBER_TABLE
665: , p5_a1 JTF_NUMBER_TABLE
666: , p5_a2 JTF_DATE_TABLE
667: , p5_a3 JTF_NUMBER_TABLE
668: , p5_a4 JTF_VARCHAR2_TABLE_100
669: , p5_a5 JTF_VARCHAR2_TABLE_300
670: , p5_a6 JTF_NUMBER_TABLE
671: , p5_a7 JTF_NUMBER_TABLE
672: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 672: , p5_a8 JTF_VARCHAR2_TABLE_100

668: , p5_a4 JTF_VARCHAR2_TABLE_100
669: , p5_a5 JTF_VARCHAR2_TABLE_300
670: , p5_a6 JTF_NUMBER_TABLE
671: , p5_a7 JTF_NUMBER_TABLE
672: , p5_a8 JTF_VARCHAR2_TABLE_100
673: , p5_a9 JTF_NUMBER_TABLE
674: , p5_a10 JTF_NUMBER_TABLE
675: , p5_a11 JTF_VARCHAR2_TABLE_200
676: , p5_a12 JTF_VARCHAR2_TABLE_200

Line 690: , p5_a26 JTF_VARCHAR2_TABLE_100

686: , p5_a22 JTF_VARCHAR2_TABLE_200
687: , p5_a23 JTF_VARCHAR2_TABLE_200
688: , p5_a24 JTF_VARCHAR2_TABLE_200
689: , p5_a25 JTF_VARCHAR2_TABLE_200
690: , p5_a26 JTF_VARCHAR2_TABLE_100
691: , p5_a27 JTF_VARCHAR2_TABLE_100
692: , p5_a28 JTF_VARCHAR2_TABLE_100
693: , p5_a29 JTF_VARCHAR2_TABLE_2000
694: , p5_a30 JTF_NUMBER_TABLE

Line 691: , p5_a27 JTF_VARCHAR2_TABLE_100

687: , p5_a23 JTF_VARCHAR2_TABLE_200
688: , p5_a24 JTF_VARCHAR2_TABLE_200
689: , p5_a25 JTF_VARCHAR2_TABLE_200
690: , p5_a26 JTF_VARCHAR2_TABLE_100
691: , p5_a27 JTF_VARCHAR2_TABLE_100
692: , p5_a28 JTF_VARCHAR2_TABLE_100
693: , p5_a29 JTF_VARCHAR2_TABLE_2000
694: , p5_a30 JTF_NUMBER_TABLE
695: , p6_a0 JTF_NUMBER_TABLE

Line 692: , p5_a28 JTF_VARCHAR2_TABLE_100

688: , p5_a24 JTF_VARCHAR2_TABLE_200
689: , p5_a25 JTF_VARCHAR2_TABLE_200
690: , p5_a26 JTF_VARCHAR2_TABLE_100
691: , p5_a27 JTF_VARCHAR2_TABLE_100
692: , p5_a28 JTF_VARCHAR2_TABLE_100
693: , p5_a29 JTF_VARCHAR2_TABLE_2000
694: , p5_a30 JTF_NUMBER_TABLE
695: , p6_a0 JTF_NUMBER_TABLE
696: , p6_a1 JTF_NUMBER_TABLE

Line 715: , p6_a20 JTF_VARCHAR2_TABLE_100

711: , p6_a16 JTF_VARCHAR2_TABLE_200
712: , p6_a17 JTF_VARCHAR2_TABLE_200
713: , p6_a18 JTF_VARCHAR2_TABLE_200
714: , p6_a19 JTF_VARCHAR2_TABLE_200
715: , p6_a20 JTF_VARCHAR2_TABLE_100
716: , x_return_status out nocopy VARCHAR2
717: , x_msg_count out nocopy NUMBER
718: , x_msg_data out nocopy VARCHAR2
719: )