DBA Data[Home] [Help]

APPS.AHL_FMP_MR_INTERVAL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_fmp_mr_interval_pvt.interval_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE

Line 29: , a13 JTF_VARCHAR2_TABLE_100

25: , a9 JTF_DATE_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200

Line 50: , a34 JTF_VARCHAR2_TABLE_100

46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_DATE_TABLE
48: , a32 JTF_NUMBER_TABLE
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_VARCHAR2_TABLE_100
51: , a35 JTF_VARCHAR2_TABLE_100
52: , a36 JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;

Line 51: , a35 JTF_VARCHAR2_TABLE_100

47: , a31 JTF_DATE_TABLE
48: , a32 JTF_NUMBER_TABLE
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_VARCHAR2_TABLE_100
51: , a35 JTF_VARCHAR2_TABLE_100
52: , a36 JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin

Line 52: , a36 JTF_VARCHAR2_TABLE_100

48: , a32 JTF_NUMBER_TABLE
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_VARCHAR2_TABLE_100
51: , a35 JTF_VARCHAR2_TABLE_100
52: , a36 JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if a0 is not null and a0.count > 0 then

Line 110: , a3 out nocopy JTF_VARCHAR2_TABLE_100

106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t ahl_fmp_mr_interval_pvt.interval_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_NUMBER_TABLE

Line 120: , a13 out nocopy JTF_VARCHAR2_TABLE_100

116: , a9 out nocopy JTF_DATE_TABLE
117: , a10 out nocopy JTF_NUMBER_TABLE
118: , a11 out nocopy JTF_NUMBER_TABLE
119: , a12 out nocopy JTF_NUMBER_TABLE
120: , a13 out nocopy JTF_VARCHAR2_TABLE_100
121: , a14 out nocopy JTF_VARCHAR2_TABLE_200
122: , a15 out nocopy JTF_VARCHAR2_TABLE_200
123: , a16 out nocopy JTF_VARCHAR2_TABLE_200
124: , a17 out nocopy JTF_VARCHAR2_TABLE_200

Line 141: , a34 out nocopy JTF_VARCHAR2_TABLE_100

137: , a30 out nocopy JTF_NUMBER_TABLE
138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: , a34 out nocopy JTF_VARCHAR2_TABLE_100
142: , a35 out nocopy JTF_VARCHAR2_TABLE_100
143: , a36 out nocopy JTF_VARCHAR2_TABLE_100
144: ) as
145: ddindx binary_integer; indx binary_integer;

Line 142: , a35 out nocopy JTF_VARCHAR2_TABLE_100

138: , a31 out nocopy JTF_DATE_TABLE
139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: , a34 out nocopy JTF_VARCHAR2_TABLE_100
142: , a35 out nocopy JTF_VARCHAR2_TABLE_100
143: , a36 out nocopy JTF_VARCHAR2_TABLE_100
144: ) as
145: ddindx binary_integer; indx binary_integer;
146: begin

Line 143: , a36 out nocopy JTF_VARCHAR2_TABLE_100

139: , a32 out nocopy JTF_NUMBER_TABLE
140: , a33 out nocopy JTF_NUMBER_TABLE
141: , a34 out nocopy JTF_VARCHAR2_TABLE_100
142: , a35 out nocopy JTF_VARCHAR2_TABLE_100
143: , a36 out nocopy JTF_VARCHAR2_TABLE_100
144: ) as
145: ddindx binary_integer; indx binary_integer;
146: begin
147: if t is null or t.count = 0 then

Line 151: a3 := JTF_VARCHAR2_TABLE_100();

147: if t is null or t.count = 0 then
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_NUMBER_TABLE();
151: a3 := JTF_VARCHAR2_TABLE_100();
152: a4 := JTF_NUMBER_TABLE();
153: a5 := JTF_NUMBER_TABLE();
154: a6 := JTF_NUMBER_TABLE();
155: a7 := JTF_NUMBER_TABLE();

Line 161: a13 := JTF_VARCHAR2_TABLE_100();

157: a9 := JTF_DATE_TABLE();
158: a10 := JTF_NUMBER_TABLE();
159: a11 := JTF_NUMBER_TABLE();
160: a12 := JTF_NUMBER_TABLE();
161: a13 := JTF_VARCHAR2_TABLE_100();
162: a14 := JTF_VARCHAR2_TABLE_200();
163: a15 := JTF_VARCHAR2_TABLE_200();
164: a16 := JTF_VARCHAR2_TABLE_200();
165: a17 := JTF_VARCHAR2_TABLE_200();

Line 182: a34 := JTF_VARCHAR2_TABLE_100();

178: a30 := JTF_NUMBER_TABLE();
179: a31 := JTF_DATE_TABLE();
180: a32 := JTF_NUMBER_TABLE();
181: a33 := JTF_NUMBER_TABLE();
182: a34 := JTF_VARCHAR2_TABLE_100();
183: a35 := JTF_VARCHAR2_TABLE_100();
184: a36 := JTF_VARCHAR2_TABLE_100();
185: else
186: a0 := JTF_NUMBER_TABLE();

Line 183: a35 := JTF_VARCHAR2_TABLE_100();

179: a31 := JTF_DATE_TABLE();
180: a32 := JTF_NUMBER_TABLE();
181: a33 := JTF_NUMBER_TABLE();
182: a34 := JTF_VARCHAR2_TABLE_100();
183: a35 := JTF_VARCHAR2_TABLE_100();
184: a36 := JTF_VARCHAR2_TABLE_100();
185: else
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();

Line 184: a36 := JTF_VARCHAR2_TABLE_100();

180: a32 := JTF_NUMBER_TABLE();
181: a33 := JTF_NUMBER_TABLE();
182: a34 := JTF_VARCHAR2_TABLE_100();
183: a35 := JTF_VARCHAR2_TABLE_100();
184: a36 := JTF_VARCHAR2_TABLE_100();
185: else
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_NUMBER_TABLE();

Line 189: a3 := JTF_VARCHAR2_TABLE_100();

185: else
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_NUMBER_TABLE();
189: a3 := JTF_VARCHAR2_TABLE_100();
190: a4 := JTF_NUMBER_TABLE();
191: a5 := JTF_NUMBER_TABLE();
192: a6 := JTF_NUMBER_TABLE();
193: a7 := JTF_NUMBER_TABLE();

Line 199: a13 := JTF_VARCHAR2_TABLE_100();

195: a9 := JTF_DATE_TABLE();
196: a10 := JTF_NUMBER_TABLE();
197: a11 := JTF_NUMBER_TABLE();
198: a12 := JTF_NUMBER_TABLE();
199: a13 := JTF_VARCHAR2_TABLE_100();
200: a14 := JTF_VARCHAR2_TABLE_200();
201: a15 := JTF_VARCHAR2_TABLE_200();
202: a16 := JTF_VARCHAR2_TABLE_200();
203: a17 := JTF_VARCHAR2_TABLE_200();

Line 220: a34 := JTF_VARCHAR2_TABLE_100();

216: a30 := JTF_NUMBER_TABLE();
217: a31 := JTF_DATE_TABLE();
218: a32 := JTF_NUMBER_TABLE();
219: a33 := JTF_NUMBER_TABLE();
220: a34 := JTF_VARCHAR2_TABLE_100();
221: a35 := JTF_VARCHAR2_TABLE_100();
222: a36 := JTF_VARCHAR2_TABLE_100();
223: if t.count > 0 then
224: a0.extend(t.count);

Line 221: a35 := JTF_VARCHAR2_TABLE_100();

217: a31 := JTF_DATE_TABLE();
218: a32 := JTF_NUMBER_TABLE();
219: a33 := JTF_NUMBER_TABLE();
220: a34 := JTF_VARCHAR2_TABLE_100();
221: a35 := JTF_VARCHAR2_TABLE_100();
222: a36 := JTF_VARCHAR2_TABLE_100();
223: if t.count > 0 then
224: a0.extend(t.count);
225: a1.extend(t.count);

Line 222: a36 := JTF_VARCHAR2_TABLE_100();

218: a32 := JTF_NUMBER_TABLE();
219: a33 := JTF_NUMBER_TABLE();
220: a34 := JTF_VARCHAR2_TABLE_100();
221: a35 := JTF_VARCHAR2_TABLE_100();
222: a36 := JTF_VARCHAR2_TABLE_100();
223: if t.count > 0 then
224: a0.extend(t.count);
225: a1.extend(t.count);
226: a2.extend(t.count);

Line 323: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

319: , x_msg_data out nocopy VARCHAR2
320: , p9_a0 in out nocopy JTF_NUMBER_TABLE
321: , p9_a1 in out nocopy JTF_NUMBER_TABLE
322: , p9_a2 in out nocopy JTF_NUMBER_TABLE
323: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
324: , p9_a4 in out nocopy JTF_NUMBER_TABLE
325: , p9_a5 in out nocopy JTF_NUMBER_TABLE
326: , p9_a6 in out nocopy JTF_NUMBER_TABLE
327: , p9_a7 in out nocopy JTF_NUMBER_TABLE

Line 333: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100

329: , p9_a9 in out nocopy JTF_DATE_TABLE
330: , p9_a10 in out nocopy JTF_NUMBER_TABLE
331: , p9_a11 in out nocopy JTF_NUMBER_TABLE
332: , p9_a12 in out nocopy JTF_NUMBER_TABLE
333: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
334: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
335: , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
336: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
337: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200

Line 354: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100

350: , p9_a30 in out nocopy JTF_NUMBER_TABLE
351: , p9_a31 in out nocopy JTF_DATE_TABLE
352: , p9_a32 in out nocopy JTF_NUMBER_TABLE
353: , p9_a33 in out nocopy JTF_NUMBER_TABLE
354: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
355: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
356: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
357: , p10_a0 in out nocopy NUMBER
358: , p10_a1 in out nocopy NUMBER

Line 355: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100

351: , p9_a31 in out nocopy JTF_DATE_TABLE
352: , p9_a32 in out nocopy JTF_NUMBER_TABLE
353: , p9_a33 in out nocopy JTF_NUMBER_TABLE
354: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
355: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
356: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
357: , p10_a0 in out nocopy NUMBER
358: , p10_a1 in out nocopy NUMBER
359: , p10_a2 in out nocopy DATE

Line 356: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100

352: , p9_a32 in out nocopy JTF_NUMBER_TABLE
353: , p9_a33 in out nocopy JTF_NUMBER_TABLE
354: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
355: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
356: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_100
357: , p10_a0 in out nocopy NUMBER
358: , p10_a1 in out nocopy NUMBER
359: , p10_a2 in out nocopy DATE
360: , p10_a3 in out nocopy NUMBER