DBA Data[Home] [Help]

APPS.OKL_ASO_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_aso_pvt_w as
2: /* $Header: OKLIASOB.pls 120.2 2010/10/28 22:49:02 sechawla noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_aso_pvt.asov_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_400
28: , a25 JTF_NUMBER_TABLE

Line 29: , a26 JTF_VARCHAR2_TABLE_100

25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_400
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_2000
32: , a29 JTF_VARCHAR2_TABLE_2000
33: ) as

Line 82: , a2 out nocopy JTF_VARCHAR2_TABLE_100

78: end if;
79: end rosetta_table_copy_in_p23;
80: procedure rosetta_table_copy_out_p23(t okl_aso_pvt.asov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_VARCHAR2_TABLE_500
84: , a4 out nocopy JTF_VARCHAR2_TABLE_500
85: , a5 out nocopy JTF_VARCHAR2_TABLE_500
86: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 101: , a21 out nocopy JTF_VARCHAR2_TABLE_100

97: , a17 out nocopy JTF_VARCHAR2_TABLE_500
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
101: , a21 out nocopy JTF_VARCHAR2_TABLE_100
102: , a22 out nocopy JTF_NUMBER_TABLE
103: , a23 out nocopy JTF_NUMBER_TABLE
104: , a24 out nocopy JTF_VARCHAR2_TABLE_400
105: , a25 out nocopy JTF_NUMBER_TABLE

Line 106: , a26 out nocopy JTF_VARCHAR2_TABLE_100

102: , a22 out nocopy JTF_NUMBER_TABLE
103: , a23 out nocopy JTF_NUMBER_TABLE
104: , a24 out nocopy JTF_VARCHAR2_TABLE_400
105: , a25 out nocopy JTF_NUMBER_TABLE
106: , a26 out nocopy JTF_VARCHAR2_TABLE_100
107: , a27 out nocopy JTF_VARCHAR2_TABLE_300
108: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
109: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
110: ) as

Line 116: a2 := JTF_VARCHAR2_TABLE_100();

112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_VARCHAR2_TABLE_100();
117: a3 := JTF_VARCHAR2_TABLE_500();
118: a4 := JTF_VARCHAR2_TABLE_500();
119: a5 := JTF_VARCHAR2_TABLE_500();
120: a6 := JTF_VARCHAR2_TABLE_500();

Line 135: a21 := JTF_VARCHAR2_TABLE_100();

131: a17 := JTF_VARCHAR2_TABLE_500();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
135: a21 := JTF_VARCHAR2_TABLE_100();
136: a22 := JTF_NUMBER_TABLE();
137: a23 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_400();
139: a25 := JTF_NUMBER_TABLE();

Line 140: a26 := JTF_VARCHAR2_TABLE_100();

136: a22 := JTF_NUMBER_TABLE();
137: a23 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_400();
139: a25 := JTF_NUMBER_TABLE();
140: a26 := JTF_VARCHAR2_TABLE_100();
141: a27 := JTF_VARCHAR2_TABLE_300();
142: a28 := JTF_VARCHAR2_TABLE_2000();
143: a29 := JTF_VARCHAR2_TABLE_2000();
144: else

Line 147: a2 := JTF_VARCHAR2_TABLE_100();

143: a29 := JTF_VARCHAR2_TABLE_2000();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_VARCHAR2_TABLE_500();
149: a4 := JTF_VARCHAR2_TABLE_500();
150: a5 := JTF_VARCHAR2_TABLE_500();
151: a6 := JTF_VARCHAR2_TABLE_500();

Line 166: a21 := JTF_VARCHAR2_TABLE_100();

162: a17 := JTF_VARCHAR2_TABLE_500();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
166: a21 := JTF_VARCHAR2_TABLE_100();
167: a22 := JTF_NUMBER_TABLE();
168: a23 := JTF_NUMBER_TABLE();
169: a24 := JTF_VARCHAR2_TABLE_400();
170: a25 := JTF_NUMBER_TABLE();

Line 171: a26 := JTF_VARCHAR2_TABLE_100();

167: a22 := JTF_NUMBER_TABLE();
168: a23 := JTF_NUMBER_TABLE();
169: a24 := JTF_VARCHAR2_TABLE_400();
170: a25 := JTF_NUMBER_TABLE();
171: a26 := JTF_VARCHAR2_TABLE_100();
172: a27 := JTF_VARCHAR2_TABLE_300();
173: a28 := JTF_VARCHAR2_TABLE_2000();
174: a29 := JTF_VARCHAR2_TABLE_2000();
175: if t.count > 0 then

Line 256: , p5_a2 JTF_VARCHAR2_TABLE_100

252: , x_msg_count out nocopy NUMBER
253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 JTF_NUMBER_TABLE
255: , p5_a1 JTF_NUMBER_TABLE
256: , p5_a2 JTF_VARCHAR2_TABLE_100
257: , p5_a3 JTF_VARCHAR2_TABLE_500
258: , p5_a4 JTF_VARCHAR2_TABLE_500
259: , p5_a5 JTF_VARCHAR2_TABLE_500
260: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 275: , p5_a21 JTF_VARCHAR2_TABLE_100

271: , p5_a17 JTF_VARCHAR2_TABLE_500
272: , p5_a18 JTF_NUMBER_TABLE
273: , p5_a19 JTF_NUMBER_TABLE
274: , p5_a20 JTF_NUMBER_TABLE
275: , p5_a21 JTF_VARCHAR2_TABLE_100
276: , p5_a22 JTF_NUMBER_TABLE
277: , p5_a23 JTF_NUMBER_TABLE
278: , p5_a24 JTF_VARCHAR2_TABLE_400
279: , p5_a25 JTF_NUMBER_TABLE

Line 280: , p5_a26 JTF_VARCHAR2_TABLE_100

276: , p5_a22 JTF_NUMBER_TABLE
277: , p5_a23 JTF_NUMBER_TABLE
278: , p5_a24 JTF_VARCHAR2_TABLE_400
279: , p5_a25 JTF_NUMBER_TABLE
280: , p5_a26 JTF_VARCHAR2_TABLE_100
281: , p5_a27 JTF_VARCHAR2_TABLE_300
282: , p5_a28 JTF_VARCHAR2_TABLE_2000
283: , p5_a29 JTF_VARCHAR2_TABLE_2000
284: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 286: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

282: , p5_a28 JTF_VARCHAR2_TABLE_2000
283: , p5_a29 JTF_VARCHAR2_TABLE_2000
284: , p6_a0 out nocopy JTF_NUMBER_TABLE
285: , p6_a1 out nocopy JTF_NUMBER_TABLE
286: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
288: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
289: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
290: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 305: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

301: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
302: , p6_a18 out nocopy JTF_NUMBER_TABLE
303: , p6_a19 out nocopy JTF_NUMBER_TABLE
304: , p6_a20 out nocopy JTF_NUMBER_TABLE
305: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
306: , p6_a22 out nocopy JTF_NUMBER_TABLE
307: , p6_a23 out nocopy JTF_NUMBER_TABLE
308: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
309: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 310: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100

306: , p6_a22 out nocopy JTF_NUMBER_TABLE
307: , p6_a23 out nocopy JTF_NUMBER_TABLE
308: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
309: , p6_a25 out nocopy JTF_NUMBER_TABLE
310: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
311: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_300
312: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_2000
313: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_2000
314: )

Line 417: , p5_a2 JTF_VARCHAR2_TABLE_100

413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
415: , p5_a0 JTF_NUMBER_TABLE
416: , p5_a1 JTF_NUMBER_TABLE
417: , p5_a2 JTF_VARCHAR2_TABLE_100
418: , p5_a3 JTF_VARCHAR2_TABLE_500
419: , p5_a4 JTF_VARCHAR2_TABLE_500
420: , p5_a5 JTF_VARCHAR2_TABLE_500
421: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 436: , p5_a21 JTF_VARCHAR2_TABLE_100

432: , p5_a17 JTF_VARCHAR2_TABLE_500
433: , p5_a18 JTF_NUMBER_TABLE
434: , p5_a19 JTF_NUMBER_TABLE
435: , p5_a20 JTF_NUMBER_TABLE
436: , p5_a21 JTF_VARCHAR2_TABLE_100
437: , p5_a22 JTF_NUMBER_TABLE
438: , p5_a23 JTF_NUMBER_TABLE
439: , p5_a24 JTF_VARCHAR2_TABLE_400
440: , p5_a25 JTF_NUMBER_TABLE

Line 441: , p5_a26 JTF_VARCHAR2_TABLE_100

437: , p5_a22 JTF_NUMBER_TABLE
438: , p5_a23 JTF_NUMBER_TABLE
439: , p5_a24 JTF_VARCHAR2_TABLE_400
440: , p5_a25 JTF_NUMBER_TABLE
441: , p5_a26 JTF_VARCHAR2_TABLE_100
442: , p5_a27 JTF_VARCHAR2_TABLE_300
443: , p5_a28 JTF_VARCHAR2_TABLE_2000
444: , p5_a29 JTF_VARCHAR2_TABLE_2000
445: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 447: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

443: , p5_a28 JTF_VARCHAR2_TABLE_2000
444: , p5_a29 JTF_VARCHAR2_TABLE_2000
445: , p6_a0 out nocopy JTF_NUMBER_TABLE
446: , p6_a1 out nocopy JTF_NUMBER_TABLE
447: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
449: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
450: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
451: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 466: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

462: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a18 out nocopy JTF_NUMBER_TABLE
464: , p6_a19 out nocopy JTF_NUMBER_TABLE
465: , p6_a20 out nocopy JTF_NUMBER_TABLE
466: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a22 out nocopy JTF_NUMBER_TABLE
468: , p6_a23 out nocopy JTF_NUMBER_TABLE
469: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
470: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 471: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100

467: , p6_a22 out nocopy JTF_NUMBER_TABLE
468: , p6_a23 out nocopy JTF_NUMBER_TABLE
469: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
470: , p6_a25 out nocopy JTF_NUMBER_TABLE
471: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_300
473: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_2000
474: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_2000
475: )

Line 578: , p5_a2 JTF_VARCHAR2_TABLE_100

574: , x_msg_count out nocopy NUMBER
575: , x_msg_data out nocopy VARCHAR2
576: , p5_a0 JTF_NUMBER_TABLE
577: , p5_a1 JTF_NUMBER_TABLE
578: , p5_a2 JTF_VARCHAR2_TABLE_100
579: , p5_a3 JTF_VARCHAR2_TABLE_500
580: , p5_a4 JTF_VARCHAR2_TABLE_500
581: , p5_a5 JTF_VARCHAR2_TABLE_500
582: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 597: , p5_a21 JTF_VARCHAR2_TABLE_100

593: , p5_a17 JTF_VARCHAR2_TABLE_500
594: , p5_a18 JTF_NUMBER_TABLE
595: , p5_a19 JTF_NUMBER_TABLE
596: , p5_a20 JTF_NUMBER_TABLE
597: , p5_a21 JTF_VARCHAR2_TABLE_100
598: , p5_a22 JTF_NUMBER_TABLE
599: , p5_a23 JTF_NUMBER_TABLE
600: , p5_a24 JTF_VARCHAR2_TABLE_400
601: , p5_a25 JTF_NUMBER_TABLE

Line 602: , p5_a26 JTF_VARCHAR2_TABLE_100

598: , p5_a22 JTF_NUMBER_TABLE
599: , p5_a23 JTF_NUMBER_TABLE
600: , p5_a24 JTF_VARCHAR2_TABLE_400
601: , p5_a25 JTF_NUMBER_TABLE
602: , p5_a26 JTF_VARCHAR2_TABLE_100
603: , p5_a27 JTF_VARCHAR2_TABLE_300
604: , p5_a28 JTF_VARCHAR2_TABLE_2000
605: , p5_a29 JTF_VARCHAR2_TABLE_2000
606: )