DBA Data[Home] [Help]

APPS.AHL_DI_SUBSCRIPTION_PUB_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_di_subscription_pub.subscription_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_di_subscription_pub.subscription_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_di_subscription_pub.subscription_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100

Line 17: , a4 JTF_NUMBER_TABLE

13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_di_subscription_pub.subscription_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_400
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100

Line 20: , a7 JTF_NUMBER_TABLE

16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_400
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_300

Line 23: , a10 JTF_NUMBER_TABLE

19: , a6 JTF_VARCHAR2_TABLE_400
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_300
25: , a12 JTF_VARCHAR2_TABLE_400
26: , a13 JTF_DATE_TABLE
27: , a14 JTF_DATE_TABLE

Line 52: , a39 JTF_NUMBER_TABLE

48: , a35 JTF_VARCHAR2_TABLE_200
49: , a36 JTF_VARCHAR2_TABLE_100
50: , a37 JTF_VARCHAR2_TABLE_100
51: , a38 JTF_VARCHAR2_TABLE_2000
52: , a39 JTF_NUMBER_TABLE
53: , a40 JTF_VARCHAR2_TABLE_100
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin

Line 112: procedure rosetta_table_copy_out_p1(t ahl_di_subscription_pub.subscription_tbl, a0 out nocopy JTF_NUMBER_TABLE

108: end loop;
109: end if;
110: end if;
111: end rosetta_table_copy_in_p1;
112: procedure rosetta_table_copy_out_p1(t ahl_di_subscription_pub.subscription_tbl, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_NUMBER_TABLE

Line 113: , a1 out nocopy JTF_NUMBER_TABLE

109: end if;
110: end if;
111: end rosetta_table_copy_in_p1;
112: procedure rosetta_table_copy_out_p1(t ahl_di_subscription_pub.subscription_tbl, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 116: , a4 out nocopy JTF_NUMBER_TABLE

112: procedure rosetta_table_copy_out_p1(t ahl_di_subscription_pub.subscription_tbl, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_100
118: , a6 out nocopy JTF_VARCHAR2_TABLE_400
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , a7 out nocopy JTF_NUMBER_TABLE

115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_100
118: , a6 out nocopy JTF_VARCHAR2_TABLE_400
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_VARCHAR2_TABLE_100
121: , a9 out nocopy JTF_VARCHAR2_TABLE_100
122: , a10 out nocopy JTF_NUMBER_TABLE
123: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 122: , a10 out nocopy JTF_NUMBER_TABLE

118: , a6 out nocopy JTF_VARCHAR2_TABLE_400
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_VARCHAR2_TABLE_100
121: , a9 out nocopy JTF_VARCHAR2_TABLE_100
122: , a10 out nocopy JTF_NUMBER_TABLE
123: , a11 out nocopy JTF_VARCHAR2_TABLE_300
124: , a12 out nocopy JTF_VARCHAR2_TABLE_400
125: , a13 out nocopy JTF_DATE_TABLE
126: , a14 out nocopy JTF_DATE_TABLE

Line 151: , a39 out nocopy JTF_NUMBER_TABLE

147: , a35 out nocopy JTF_VARCHAR2_TABLE_200
148: , a36 out nocopy JTF_VARCHAR2_TABLE_100
149: , a37 out nocopy JTF_VARCHAR2_TABLE_100
150: , a38 out nocopy JTF_VARCHAR2_TABLE_2000
151: , a39 out nocopy JTF_NUMBER_TABLE
152: , a40 out nocopy JTF_VARCHAR2_TABLE_100
153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin

Line 157: a0 := JTF_NUMBER_TABLE();

153: ) as
154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_NUMBER_TABLE();

Line 158: a1 := JTF_NUMBER_TABLE();

154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_VARCHAR2_TABLE_100();

Line 161: a4 := JTF_NUMBER_TABLE();

157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_VARCHAR2_TABLE_400();
164: a7 := JTF_NUMBER_TABLE();
165: a8 := JTF_VARCHAR2_TABLE_100();

Line 164: a7 := JTF_NUMBER_TABLE();

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

Line 167: a10 := JTF_NUMBER_TABLE();

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

Line 196: a39 := JTF_NUMBER_TABLE();

192: a35 := JTF_VARCHAR2_TABLE_200();
193: a36 := JTF_VARCHAR2_TABLE_100();
194: a37 := JTF_VARCHAR2_TABLE_100();
195: a38 := JTF_VARCHAR2_TABLE_2000();
196: a39 := JTF_NUMBER_TABLE();
197: a40 := JTF_VARCHAR2_TABLE_100();
198: else
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();

Line 199: a0 := JTF_NUMBER_TABLE();

195: a38 := JTF_VARCHAR2_TABLE_2000();
196: a39 := JTF_NUMBER_TABLE();
197: a40 := JTF_VARCHAR2_TABLE_100();
198: else
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_NUMBER_TABLE();

Line 200: a1 := JTF_NUMBER_TABLE();

196: a39 := JTF_NUMBER_TABLE();
197: a40 := JTF_VARCHAR2_TABLE_100();
198: else
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_NUMBER_TABLE();
204: a5 := JTF_VARCHAR2_TABLE_100();

Line 203: a4 := JTF_NUMBER_TABLE();

199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_NUMBER_TABLE();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_VARCHAR2_TABLE_400();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_VARCHAR2_TABLE_100();

Line 206: a7 := JTF_NUMBER_TABLE();

202: a3 := JTF_VARCHAR2_TABLE_100();
203: a4 := JTF_NUMBER_TABLE();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_VARCHAR2_TABLE_400();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_VARCHAR2_TABLE_100();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: a10 := JTF_NUMBER_TABLE();
210: a11 := JTF_VARCHAR2_TABLE_300();

Line 209: a10 := JTF_NUMBER_TABLE();

205: a6 := JTF_VARCHAR2_TABLE_400();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_VARCHAR2_TABLE_100();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: a10 := JTF_NUMBER_TABLE();
210: a11 := JTF_VARCHAR2_TABLE_300();
211: a12 := JTF_VARCHAR2_TABLE_400();
212: a13 := JTF_DATE_TABLE();
213: a14 := JTF_DATE_TABLE();

Line 238: a39 := JTF_NUMBER_TABLE();

234: a35 := JTF_VARCHAR2_TABLE_200();
235: a36 := JTF_VARCHAR2_TABLE_100();
236: a37 := JTF_VARCHAR2_TABLE_100();
237: a38 := JTF_VARCHAR2_TABLE_2000();
238: a39 := JTF_NUMBER_TABLE();
239: a40 := JTF_VARCHAR2_TABLE_100();
240: if t.count > 0 then
241: a0.extend(t.count);
242: a1.extend(t.count);

Line 341: , p5_a0 in out nocopy JTF_NUMBER_TABLE

337: , p_init_msg_list VARCHAR2
338: , p_commit VARCHAR2
339: , p_validate_only VARCHAR2
340: , p_validation_level NUMBER
341: , p5_a0 in out nocopy JTF_NUMBER_TABLE
342: , p5_a1 in out nocopy JTF_NUMBER_TABLE
343: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
344: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
345: , p5_a4 in out nocopy JTF_NUMBER_TABLE

Line 342: , p5_a1 in out nocopy JTF_NUMBER_TABLE

338: , p_commit VARCHAR2
339: , p_validate_only VARCHAR2
340: , p_validation_level NUMBER
341: , p5_a0 in out nocopy JTF_NUMBER_TABLE
342: , p5_a1 in out nocopy JTF_NUMBER_TABLE
343: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
344: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
345: , p5_a4 in out nocopy JTF_NUMBER_TABLE
346: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 345: , p5_a4 in out nocopy JTF_NUMBER_TABLE

341: , p5_a0 in out nocopy JTF_NUMBER_TABLE
342: , p5_a1 in out nocopy JTF_NUMBER_TABLE
343: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
344: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
345: , p5_a4 in out nocopy JTF_NUMBER_TABLE
346: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
347: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_400
348: , p5_a7 in out nocopy JTF_NUMBER_TABLE
349: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 348: , p5_a7 in out nocopy JTF_NUMBER_TABLE

344: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
345: , p5_a4 in out nocopy JTF_NUMBER_TABLE
346: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
347: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_400
348: , p5_a7 in out nocopy JTF_NUMBER_TABLE
349: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
350: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
351: , p5_a10 in out nocopy JTF_NUMBER_TABLE
352: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_300

Line 351: , p5_a10 in out nocopy JTF_NUMBER_TABLE

347: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_400
348: , p5_a7 in out nocopy JTF_NUMBER_TABLE
349: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
350: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
351: , p5_a10 in out nocopy JTF_NUMBER_TABLE
352: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_300
353: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_400
354: , p5_a13 in out nocopy JTF_DATE_TABLE
355: , p5_a14 in out nocopy JTF_DATE_TABLE

Line 380: , p5_a39 in out nocopy JTF_NUMBER_TABLE

376: , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_200
377: , p5_a36 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_2000
380: , p5_a39 in out nocopy JTF_NUMBER_TABLE
381: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
382: , p_module_type VARCHAR2
383: , x_return_status out nocopy VARCHAR2
384: , x_msg_count out nocopy NUMBER

Line 517: , p5_a0 in out nocopy JTF_NUMBER_TABLE

513: , p_init_msg_list VARCHAR2
514: , p_commit VARCHAR2
515: , p_validate_only VARCHAR2
516: , p_validation_level NUMBER
517: , p5_a0 in out nocopy JTF_NUMBER_TABLE
518: , p5_a1 in out nocopy JTF_NUMBER_TABLE
519: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
521: , p5_a4 in out nocopy JTF_NUMBER_TABLE

Line 518: , p5_a1 in out nocopy JTF_NUMBER_TABLE

514: , p_commit VARCHAR2
515: , p_validate_only VARCHAR2
516: , p_validation_level NUMBER
517: , p5_a0 in out nocopy JTF_NUMBER_TABLE
518: , p5_a1 in out nocopy JTF_NUMBER_TABLE
519: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
521: , p5_a4 in out nocopy JTF_NUMBER_TABLE
522: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 521: , p5_a4 in out nocopy JTF_NUMBER_TABLE

517: , p5_a0 in out nocopy JTF_NUMBER_TABLE
518: , p5_a1 in out nocopy JTF_NUMBER_TABLE
519: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
521: , p5_a4 in out nocopy JTF_NUMBER_TABLE
522: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_400
524: , p5_a7 in out nocopy JTF_NUMBER_TABLE
525: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 524: , p5_a7 in out nocopy JTF_NUMBER_TABLE

520: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
521: , p5_a4 in out nocopy JTF_NUMBER_TABLE
522: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_400
524: , p5_a7 in out nocopy JTF_NUMBER_TABLE
525: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
526: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
527: , p5_a10 in out nocopy JTF_NUMBER_TABLE
528: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_300

Line 527: , p5_a10 in out nocopy JTF_NUMBER_TABLE

523: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_400
524: , p5_a7 in out nocopy JTF_NUMBER_TABLE
525: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
526: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
527: , p5_a10 in out nocopy JTF_NUMBER_TABLE
528: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_300
529: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_400
530: , p5_a13 in out nocopy JTF_DATE_TABLE
531: , p5_a14 in out nocopy JTF_DATE_TABLE

Line 556: , p5_a39 in out nocopy JTF_NUMBER_TABLE

552: , p5_a35 in out nocopy JTF_VARCHAR2_TABLE_200
553: , p5_a36 in out nocopy JTF_VARCHAR2_TABLE_100
554: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
555: , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_2000
556: , p5_a39 in out nocopy JTF_NUMBER_TABLE
557: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
558: , p_module_type VARCHAR2
559: , x_return_status out nocopy VARCHAR2
560: , x_msg_count out nocopy NUMBER