DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_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_mc_item_comp_pvt.det_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_VARCHAR2_TABLE_2000
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100

Line 23: , a7 JTF_VARCHAR2_TABLE_100

19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_2000
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_DATE_TABLE

Line 25: , a9 JTF_VARCHAR2_TABLE_100

21: , a5 JTF_VARCHAR2_TABLE_2000
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE

Line 30: , a14 JTF_VARCHAR2_TABLE_100

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

Line 46: , a30 JTF_VARCHAR2_TABLE_100

42: , a26 JTF_VARCHAR2_TABLE_200
43: , a27 JTF_VARCHAR2_TABLE_200
44: , a28 JTF_VARCHAR2_TABLE_200
45: , a29 JTF_VARCHAR2_TABLE_200
46: , a30 JTF_VARCHAR2_TABLE_100
47: ) as
48: ddindx binary_integer; indx binary_integer;
49: begin
50: if a0 is not null and a0.count > 0 then

Line 98: , a3 out nocopy JTF_VARCHAR2_TABLE_100

94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t ahl_mc_item_comp_pvt.det_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_NUMBER_TABLE
97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_NUMBER_TABLE
100: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a6 out nocopy JTF_NUMBER_TABLE
102: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 102: , a7 out nocopy JTF_VARCHAR2_TABLE_100

98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_NUMBER_TABLE
100: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a6 out nocopy JTF_NUMBER_TABLE
102: , a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , a8 out nocopy JTF_NUMBER_TABLE
104: , a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , a10 out nocopy JTF_NUMBER_TABLE
106: , a11 out nocopy JTF_DATE_TABLE

Line 104: , a9 out nocopy JTF_VARCHAR2_TABLE_100

100: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a6 out nocopy JTF_NUMBER_TABLE
102: , a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , a8 out nocopy JTF_NUMBER_TABLE
104: , a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , a10 out nocopy JTF_NUMBER_TABLE
106: , a11 out nocopy JTF_DATE_TABLE
107: , a12 out nocopy JTF_NUMBER_TABLE
108: , a13 out nocopy JTF_NUMBER_TABLE

Line 109: , a14 out nocopy JTF_VARCHAR2_TABLE_100

105: , a10 out nocopy JTF_NUMBER_TABLE
106: , a11 out nocopy JTF_DATE_TABLE
107: , a12 out nocopy JTF_NUMBER_TABLE
108: , a13 out nocopy JTF_NUMBER_TABLE
109: , a14 out nocopy JTF_VARCHAR2_TABLE_100
110: , a15 out nocopy JTF_VARCHAR2_TABLE_200
111: , a16 out nocopy JTF_VARCHAR2_TABLE_200
112: , a17 out nocopy JTF_VARCHAR2_TABLE_200
113: , a18 out nocopy JTF_VARCHAR2_TABLE_200

Line 125: , a30 out nocopy JTF_VARCHAR2_TABLE_100

121: , a26 out nocopy JTF_VARCHAR2_TABLE_200
122: , a27 out nocopy JTF_VARCHAR2_TABLE_200
123: , a28 out nocopy JTF_VARCHAR2_TABLE_200
124: , a29 out nocopy JTF_VARCHAR2_TABLE_200
125: , a30 out nocopy JTF_VARCHAR2_TABLE_100
126: ) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then

Line 133: a3 := JTF_VARCHAR2_TABLE_100();

129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();
135: a5 := JTF_VARCHAR2_TABLE_2000();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_VARCHAR2_TABLE_100();

Line 137: a7 := JTF_VARCHAR2_TABLE_100();

133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();
135: a5 := JTF_VARCHAR2_TABLE_2000();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_VARCHAR2_TABLE_100();
138: a8 := JTF_NUMBER_TABLE();
139: a9 := JTF_VARCHAR2_TABLE_100();
140: a10 := JTF_NUMBER_TABLE();
141: a11 := JTF_DATE_TABLE();

Line 139: a9 := JTF_VARCHAR2_TABLE_100();

135: a5 := JTF_VARCHAR2_TABLE_2000();
136: a6 := JTF_NUMBER_TABLE();
137: a7 := JTF_VARCHAR2_TABLE_100();
138: a8 := JTF_NUMBER_TABLE();
139: a9 := JTF_VARCHAR2_TABLE_100();
140: a10 := JTF_NUMBER_TABLE();
141: a11 := JTF_DATE_TABLE();
142: a12 := JTF_NUMBER_TABLE();
143: a13 := JTF_NUMBER_TABLE();

Line 144: a14 := JTF_VARCHAR2_TABLE_100();

140: a10 := JTF_NUMBER_TABLE();
141: a11 := JTF_DATE_TABLE();
142: a12 := JTF_NUMBER_TABLE();
143: a13 := JTF_NUMBER_TABLE();
144: a14 := JTF_VARCHAR2_TABLE_100();
145: a15 := JTF_VARCHAR2_TABLE_200();
146: a16 := JTF_VARCHAR2_TABLE_200();
147: a17 := JTF_VARCHAR2_TABLE_200();
148: a18 := JTF_VARCHAR2_TABLE_200();

Line 160: a30 := JTF_VARCHAR2_TABLE_100();

156: a26 := JTF_VARCHAR2_TABLE_200();
157: a27 := JTF_VARCHAR2_TABLE_200();
158: a28 := JTF_VARCHAR2_TABLE_200();
159: a29 := JTF_VARCHAR2_TABLE_200();
160: a30 := JTF_VARCHAR2_TABLE_100();
161: else
162: a0 := JTF_NUMBER_TABLE();
163: a1 := JTF_NUMBER_TABLE();
164: a2 := JTF_NUMBER_TABLE();

Line 165: a3 := JTF_VARCHAR2_TABLE_100();

161: else
162: a0 := JTF_NUMBER_TABLE();
163: a1 := JTF_NUMBER_TABLE();
164: a2 := JTF_NUMBER_TABLE();
165: a3 := JTF_VARCHAR2_TABLE_100();
166: a4 := JTF_NUMBER_TABLE();
167: a5 := JTF_VARCHAR2_TABLE_2000();
168: a6 := JTF_NUMBER_TABLE();
169: a7 := JTF_VARCHAR2_TABLE_100();

Line 169: a7 := JTF_VARCHAR2_TABLE_100();

165: a3 := JTF_VARCHAR2_TABLE_100();
166: a4 := JTF_NUMBER_TABLE();
167: a5 := JTF_VARCHAR2_TABLE_2000();
168: a6 := JTF_NUMBER_TABLE();
169: a7 := JTF_VARCHAR2_TABLE_100();
170: a8 := JTF_NUMBER_TABLE();
171: a9 := JTF_VARCHAR2_TABLE_100();
172: a10 := JTF_NUMBER_TABLE();
173: a11 := JTF_DATE_TABLE();

Line 171: a9 := JTF_VARCHAR2_TABLE_100();

167: a5 := JTF_VARCHAR2_TABLE_2000();
168: a6 := JTF_NUMBER_TABLE();
169: a7 := JTF_VARCHAR2_TABLE_100();
170: a8 := JTF_NUMBER_TABLE();
171: a9 := JTF_VARCHAR2_TABLE_100();
172: a10 := JTF_NUMBER_TABLE();
173: a11 := JTF_DATE_TABLE();
174: a12 := JTF_NUMBER_TABLE();
175: a13 := JTF_NUMBER_TABLE();

Line 176: a14 := JTF_VARCHAR2_TABLE_100();

172: a10 := JTF_NUMBER_TABLE();
173: a11 := JTF_DATE_TABLE();
174: a12 := JTF_NUMBER_TABLE();
175: a13 := JTF_NUMBER_TABLE();
176: a14 := JTF_VARCHAR2_TABLE_100();
177: a15 := JTF_VARCHAR2_TABLE_200();
178: a16 := JTF_VARCHAR2_TABLE_200();
179: a17 := JTF_VARCHAR2_TABLE_200();
180: a18 := JTF_VARCHAR2_TABLE_200();

Line 192: a30 := JTF_VARCHAR2_TABLE_100();

188: a26 := JTF_VARCHAR2_TABLE_200();
189: a27 := JTF_VARCHAR2_TABLE_200();
190: a28 := JTF_VARCHAR2_TABLE_200();
191: a29 := JTF_VARCHAR2_TABLE_200();
192: a30 := JTF_VARCHAR2_TABLE_100();
193: if t.count > 0 then
194: a0.extend(t.count);
195: a1.extend(t.count);
196: a2.extend(t.count);

Line 306: , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100

302: , p7_a26 in out nocopy VARCHAR2
303: , p8_a0 in out nocopy JTF_NUMBER_TABLE
304: , p8_a1 in out nocopy JTF_NUMBER_TABLE
305: , p8_a2 in out nocopy JTF_NUMBER_TABLE
306: , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
307: , p8_a4 in out nocopy JTF_NUMBER_TABLE
308: , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_2000
309: , p8_a6 in out nocopy JTF_NUMBER_TABLE
310: , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 310: , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100

306: , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
307: , p8_a4 in out nocopy JTF_NUMBER_TABLE
308: , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_2000
309: , p8_a6 in out nocopy JTF_NUMBER_TABLE
310: , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100
311: , p8_a8 in out nocopy JTF_NUMBER_TABLE
312: , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_100
313: , p8_a10 in out nocopy JTF_NUMBER_TABLE
314: , p8_a11 in out nocopy JTF_DATE_TABLE

Line 312: , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_100

308: , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_2000
309: , p8_a6 in out nocopy JTF_NUMBER_TABLE
310: , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100
311: , p8_a8 in out nocopy JTF_NUMBER_TABLE
312: , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_100
313: , p8_a10 in out nocopy JTF_NUMBER_TABLE
314: , p8_a11 in out nocopy JTF_DATE_TABLE
315: , p8_a12 in out nocopy JTF_NUMBER_TABLE
316: , p8_a13 in out nocopy JTF_NUMBER_TABLE

Line 317: , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_100

313: , p8_a10 in out nocopy JTF_NUMBER_TABLE
314: , p8_a11 in out nocopy JTF_DATE_TABLE
315: , p8_a12 in out nocopy JTF_NUMBER_TABLE
316: , p8_a13 in out nocopy JTF_NUMBER_TABLE
317: , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
319: , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
320: , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
321: , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200

Line 333: , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100

329: , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
330: , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
331: , p8_a28 in out nocopy JTF_VARCHAR2_TABLE_200
332: , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_200
333: , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100
334: )
335:
336: as
337: ddp_x_ic_header_rec ahl_mc_item_comp_pvt.header_rec_type;

Line 529: , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100

525: , p7_a26 in out nocopy VARCHAR2
526: , p8_a0 in out nocopy JTF_NUMBER_TABLE
527: , p8_a1 in out nocopy JTF_NUMBER_TABLE
528: , p8_a2 in out nocopy JTF_NUMBER_TABLE
529: , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p8_a4 in out nocopy JTF_NUMBER_TABLE
531: , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_2000
532: , p8_a6 in out nocopy JTF_NUMBER_TABLE
533: , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 533: , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100

529: , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p8_a4 in out nocopy JTF_NUMBER_TABLE
531: , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_2000
532: , p8_a6 in out nocopy JTF_NUMBER_TABLE
533: , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p8_a8 in out nocopy JTF_NUMBER_TABLE
535: , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p8_a10 in out nocopy JTF_NUMBER_TABLE
537: , p8_a11 in out nocopy JTF_DATE_TABLE

Line 535: , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_100

531: , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_2000
532: , p8_a6 in out nocopy JTF_NUMBER_TABLE
533: , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p8_a8 in out nocopy JTF_NUMBER_TABLE
535: , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p8_a10 in out nocopy JTF_NUMBER_TABLE
537: , p8_a11 in out nocopy JTF_DATE_TABLE
538: , p8_a12 in out nocopy JTF_NUMBER_TABLE
539: , p8_a13 in out nocopy JTF_NUMBER_TABLE

Line 540: , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_100

536: , p8_a10 in out nocopy JTF_NUMBER_TABLE
537: , p8_a11 in out nocopy JTF_DATE_TABLE
538: , p8_a12 in out nocopy JTF_NUMBER_TABLE
539: , p8_a13 in out nocopy JTF_NUMBER_TABLE
540: , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_100
541: , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
542: , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
543: , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
544: , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200

Line 556: , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100

552: , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
553: , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
554: , p8_a28 in out nocopy JTF_VARCHAR2_TABLE_200
555: , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_200
556: , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100
557: )
558:
559: as
560: ddp_x_ic_header_rec ahl_mc_item_comp_pvt.header_rec_type;