DBA Data[Home] [Help]

APPS.OKL_LAV_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_lav_pvt_w as
2: /* $Header: OKLILAVB.pls 120.0 2005/09/16 11:40:08 pagarg noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_lav_pvt.lavv_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 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE

Line 74: , a2 out nocopy JTF_VARCHAR2_TABLE_100

70: end if;
71: end rosetta_table_copy_in_p23;
72: procedure rosetta_table_copy_out_p23(t okl_lav_pvt.lavv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , a3 out nocopy JTF_VARCHAR2_TABLE_500
76: , a4 out nocopy JTF_VARCHAR2_TABLE_500
77: , a5 out nocopy JTF_VARCHAR2_TABLE_500
78: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 91: , a19 out nocopy JTF_VARCHAR2_TABLE_100

87: , a15 out nocopy JTF_VARCHAR2_TABLE_500
88: , a16 out nocopy JTF_VARCHAR2_TABLE_500
89: , a17 out nocopy JTF_VARCHAR2_TABLE_500
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_VARCHAR2_TABLE_100
92: , a20 out nocopy JTF_VARCHAR2_TABLE_100
93: , a21 out nocopy JTF_DATE_TABLE
94: , a22 out nocopy JTF_DATE_TABLE
95: , a23 out nocopy JTF_NUMBER_TABLE

Line 92: , a20 out nocopy JTF_VARCHAR2_TABLE_100

88: , a16 out nocopy JTF_VARCHAR2_TABLE_500
89: , a17 out nocopy JTF_VARCHAR2_TABLE_500
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_VARCHAR2_TABLE_100
92: , a20 out nocopy JTF_VARCHAR2_TABLE_100
93: , a21 out nocopy JTF_DATE_TABLE
94: , a22 out nocopy JTF_DATE_TABLE
95: , a23 out nocopy JTF_NUMBER_TABLE
96: , a24 out nocopy JTF_NUMBER_TABLE

Line 104: a2 := JTF_VARCHAR2_TABLE_100();

100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_VARCHAR2_TABLE_100();
105: a3 := JTF_VARCHAR2_TABLE_500();
106: a4 := JTF_VARCHAR2_TABLE_500();
107: a5 := JTF_VARCHAR2_TABLE_500();
108: a6 := JTF_VARCHAR2_TABLE_500();

Line 121: a19 := JTF_VARCHAR2_TABLE_100();

117: a15 := JTF_VARCHAR2_TABLE_500();
118: a16 := JTF_VARCHAR2_TABLE_500();
119: a17 := JTF_VARCHAR2_TABLE_500();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_VARCHAR2_TABLE_100();
122: a20 := JTF_VARCHAR2_TABLE_100();
123: a21 := JTF_DATE_TABLE();
124: a22 := JTF_DATE_TABLE();
125: a23 := JTF_NUMBER_TABLE();

Line 122: a20 := JTF_VARCHAR2_TABLE_100();

118: a16 := JTF_VARCHAR2_TABLE_500();
119: a17 := JTF_VARCHAR2_TABLE_500();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_VARCHAR2_TABLE_100();
122: a20 := JTF_VARCHAR2_TABLE_100();
123: a21 := JTF_DATE_TABLE();
124: a22 := JTF_DATE_TABLE();
125: a23 := JTF_NUMBER_TABLE();
126: a24 := JTF_NUMBER_TABLE();

Line 131: a2 := JTF_VARCHAR2_TABLE_100();

127: a25 := JTF_VARCHAR2_TABLE_300();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_VARCHAR2_TABLE_100();
132: a3 := JTF_VARCHAR2_TABLE_500();
133: a4 := JTF_VARCHAR2_TABLE_500();
134: a5 := JTF_VARCHAR2_TABLE_500();
135: a6 := JTF_VARCHAR2_TABLE_500();

Line 148: a19 := JTF_VARCHAR2_TABLE_100();

144: a15 := JTF_VARCHAR2_TABLE_500();
145: a16 := JTF_VARCHAR2_TABLE_500();
146: a17 := JTF_VARCHAR2_TABLE_500();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_VARCHAR2_TABLE_100();
149: a20 := JTF_VARCHAR2_TABLE_100();
150: a21 := JTF_DATE_TABLE();
151: a22 := JTF_DATE_TABLE();
152: a23 := JTF_NUMBER_TABLE();

Line 149: a20 := JTF_VARCHAR2_TABLE_100();

145: a16 := JTF_VARCHAR2_TABLE_500();
146: a17 := JTF_VARCHAR2_TABLE_500();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_VARCHAR2_TABLE_100();
149: a20 := JTF_VARCHAR2_TABLE_100();
150: a21 := JTF_DATE_TABLE();
151: a22 := JTF_DATE_TABLE();
152: a23 := JTF_NUMBER_TABLE();
153: a24 := JTF_NUMBER_TABLE();

Line 228: , p5_a2 JTF_VARCHAR2_TABLE_100

224: , x_msg_count out nocopy NUMBER
225: , x_msg_data out nocopy VARCHAR2
226: , p5_a0 JTF_NUMBER_TABLE
227: , p5_a1 JTF_NUMBER_TABLE
228: , p5_a2 JTF_VARCHAR2_TABLE_100
229: , p5_a3 JTF_VARCHAR2_TABLE_500
230: , p5_a4 JTF_VARCHAR2_TABLE_500
231: , p5_a5 JTF_VARCHAR2_TABLE_500
232: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 245: , p5_a19 JTF_VARCHAR2_TABLE_100

241: , p5_a15 JTF_VARCHAR2_TABLE_500
242: , p5_a16 JTF_VARCHAR2_TABLE_500
243: , p5_a17 JTF_VARCHAR2_TABLE_500
244: , p5_a18 JTF_NUMBER_TABLE
245: , p5_a19 JTF_VARCHAR2_TABLE_100
246: , p5_a20 JTF_VARCHAR2_TABLE_100
247: , p5_a21 JTF_DATE_TABLE
248: , p5_a22 JTF_DATE_TABLE
249: , p5_a23 JTF_NUMBER_TABLE

Line 246: , p5_a20 JTF_VARCHAR2_TABLE_100

242: , p5_a16 JTF_VARCHAR2_TABLE_500
243: , p5_a17 JTF_VARCHAR2_TABLE_500
244: , p5_a18 JTF_NUMBER_TABLE
245: , p5_a19 JTF_VARCHAR2_TABLE_100
246: , p5_a20 JTF_VARCHAR2_TABLE_100
247: , p5_a21 JTF_DATE_TABLE
248: , p5_a22 JTF_DATE_TABLE
249: , p5_a23 JTF_NUMBER_TABLE
250: , p5_a24 JTF_NUMBER_TABLE

Line 254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

250: , p5_a24 JTF_NUMBER_TABLE
251: , p5_a25 JTF_VARCHAR2_TABLE_300
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
256: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 271: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

267: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
268: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
269: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a18 out nocopy JTF_NUMBER_TABLE
271: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
272: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a21 out nocopy JTF_DATE_TABLE
274: , p6_a22 out nocopy JTF_DATE_TABLE
275: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 272: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

268: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
269: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a18 out nocopy JTF_NUMBER_TABLE
271: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
272: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a21 out nocopy JTF_DATE_TABLE
274: , p6_a22 out nocopy JTF_DATE_TABLE
275: , p6_a23 out nocopy JTF_NUMBER_TABLE
276: , p6_a24 out nocopy JTF_NUMBER_TABLE

Line 373: , p5_a2 JTF_VARCHAR2_TABLE_100

369: , x_msg_count out nocopy NUMBER
370: , x_msg_data out nocopy VARCHAR2
371: , p5_a0 JTF_NUMBER_TABLE
372: , p5_a1 JTF_NUMBER_TABLE
373: , p5_a2 JTF_VARCHAR2_TABLE_100
374: , p5_a3 JTF_VARCHAR2_TABLE_500
375: , p5_a4 JTF_VARCHAR2_TABLE_500
376: , p5_a5 JTF_VARCHAR2_TABLE_500
377: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 390: , p5_a19 JTF_VARCHAR2_TABLE_100

386: , p5_a15 JTF_VARCHAR2_TABLE_500
387: , p5_a16 JTF_VARCHAR2_TABLE_500
388: , p5_a17 JTF_VARCHAR2_TABLE_500
389: , p5_a18 JTF_NUMBER_TABLE
390: , p5_a19 JTF_VARCHAR2_TABLE_100
391: , p5_a20 JTF_VARCHAR2_TABLE_100
392: , p5_a21 JTF_DATE_TABLE
393: , p5_a22 JTF_DATE_TABLE
394: , p5_a23 JTF_NUMBER_TABLE

Line 391: , p5_a20 JTF_VARCHAR2_TABLE_100

387: , p5_a16 JTF_VARCHAR2_TABLE_500
388: , p5_a17 JTF_VARCHAR2_TABLE_500
389: , p5_a18 JTF_NUMBER_TABLE
390: , p5_a19 JTF_VARCHAR2_TABLE_100
391: , p5_a20 JTF_VARCHAR2_TABLE_100
392: , p5_a21 JTF_DATE_TABLE
393: , p5_a22 JTF_DATE_TABLE
394: , p5_a23 JTF_NUMBER_TABLE
395: , p5_a24 JTF_NUMBER_TABLE

Line 399: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

395: , p5_a24 JTF_NUMBER_TABLE
396: , p5_a25 JTF_VARCHAR2_TABLE_300
397: , p6_a0 out nocopy JTF_NUMBER_TABLE
398: , p6_a1 out nocopy JTF_NUMBER_TABLE
399: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
400: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
401: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
403: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 416: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

412: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
413: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
414: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
415: , p6_a18 out nocopy JTF_NUMBER_TABLE
416: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
418: , p6_a21 out nocopy JTF_DATE_TABLE
419: , p6_a22 out nocopy JTF_DATE_TABLE
420: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 417: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

413: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
414: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
415: , p6_a18 out nocopy JTF_NUMBER_TABLE
416: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
418: , p6_a21 out nocopy JTF_DATE_TABLE
419: , p6_a22 out nocopy JTF_DATE_TABLE
420: , p6_a23 out nocopy JTF_NUMBER_TABLE
421: , p6_a24 out nocopy JTF_NUMBER_TABLE

Line 518: , p5_a2 JTF_VARCHAR2_TABLE_100

514: , x_msg_count out nocopy NUMBER
515: , x_msg_data out nocopy VARCHAR2
516: , p5_a0 JTF_NUMBER_TABLE
517: , p5_a1 JTF_NUMBER_TABLE
518: , p5_a2 JTF_VARCHAR2_TABLE_100
519: , p5_a3 JTF_VARCHAR2_TABLE_500
520: , p5_a4 JTF_VARCHAR2_TABLE_500
521: , p5_a5 JTF_VARCHAR2_TABLE_500
522: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 535: , p5_a19 JTF_VARCHAR2_TABLE_100

531: , p5_a15 JTF_VARCHAR2_TABLE_500
532: , p5_a16 JTF_VARCHAR2_TABLE_500
533: , p5_a17 JTF_VARCHAR2_TABLE_500
534: , p5_a18 JTF_NUMBER_TABLE
535: , p5_a19 JTF_VARCHAR2_TABLE_100
536: , p5_a20 JTF_VARCHAR2_TABLE_100
537: , p5_a21 JTF_DATE_TABLE
538: , p5_a22 JTF_DATE_TABLE
539: , p5_a23 JTF_NUMBER_TABLE

Line 536: , p5_a20 JTF_VARCHAR2_TABLE_100

532: , p5_a16 JTF_VARCHAR2_TABLE_500
533: , p5_a17 JTF_VARCHAR2_TABLE_500
534: , p5_a18 JTF_NUMBER_TABLE
535: , p5_a19 JTF_VARCHAR2_TABLE_100
536: , p5_a20 JTF_VARCHAR2_TABLE_100
537: , p5_a21 JTF_DATE_TABLE
538: , p5_a22 JTF_DATE_TABLE
539: , p5_a23 JTF_NUMBER_TABLE
540: , p5_a24 JTF_NUMBER_TABLE