DBA Data[Home] [Help]

APPS.AHL_CMP_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 10: , a7 JTF_VARCHAR2_TABLE_300

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300

Line 14: , a11 JTF_VARCHAR2_TABLE_300

10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: ) as
18: ddindx binary_integer; indx binary_integer;

Line 55: , a7 out nocopy JTF_VARCHAR2_TABLE_300

51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 59: , a11 out nocopy JTF_VARCHAR2_TABLE_300

55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_VARCHAR2_TABLE_300
60: , a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , a13 out nocopy JTF_VARCHAR2_TABLE_100
62: ) as
63: ddindx binary_integer; indx binary_integer;

Line 73: a7 := JTF_VARCHAR2_TABLE_300();

69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
75: a9 := JTF_VARCHAR2_TABLE_100();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := JTF_VARCHAR2_TABLE_300();

Line 77: a11 := JTF_VARCHAR2_TABLE_300();

73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
75: a9 := JTF_VARCHAR2_TABLE_100();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := JTF_VARCHAR2_TABLE_300();
78: a12 := JTF_VARCHAR2_TABLE_100();
79: a13 := JTF_VARCHAR2_TABLE_100();
80: else
81: a0 := JTF_NUMBER_TABLE();

Line 88: a7 := JTF_VARCHAR2_TABLE_300();

84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_VARCHAR2_TABLE_300();

Line 92: a11 := JTF_VARCHAR2_TABLE_300();

88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_VARCHAR2_TABLE_300();
93: a12 := JTF_VARCHAR2_TABLE_100();
94: a13 := JTF_VARCHAR2_TABLE_100();
95: if t.count > 0 then
96: a0.extend(t.count);

Line 138: , a1 JTF_VARCHAR2_TABLE_300

134: end if;
135: end rosetta_table_copy_out_p4;
136:
137: procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100

Line 146: , a9 JTF_VARCHAR2_TABLE_300

142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE
148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100

Line 189: , a1 out nocopy JTF_VARCHAR2_TABLE_300

185: end if;
186: end if;
187: end rosetta_table_copy_in_p6;
188: procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_VARCHAR2_TABLE_300
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 197: , a9 out nocopy JTF_VARCHAR2_TABLE_300

193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 210: a1 := JTF_VARCHAR2_TABLE_300();

206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_300();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();

Line 218: a9 := JTF_VARCHAR2_TABLE_300();

214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();

Line 228: a1 := JTF_VARCHAR2_TABLE_300();

224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();

Line 236: a9 := JTF_VARCHAR2_TABLE_300();

232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();

Line 303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300

299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
305: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p4_a10 in out nocopy JTF_NUMBER_TABLE
307: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_300

Line 307: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_300

303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
305: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p4_a10 in out nocopy JTF_NUMBER_TABLE
307: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_300
308: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
310: , x_return_status out nocopy VARCHAR2
311: , x_msg_count out nocopy NUMBER

Line 384: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300

380: , p_init_msg_list VARCHAR2
381: , p_commit VARCHAR2
382: , p_validation_level NUMBER
383: , p4_a0 in out nocopy JTF_NUMBER_TABLE
384: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300
385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300

388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE
394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100