DBA Data[Home] [Help]

APPS.OKL_VLD_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_vld_pvt_w as
2: /* $Header: OKLIVLDB.pls 120.0 2005/09/20 12:39:04 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vld_pvt.vldv_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 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_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_VARCHAR2_TABLE_2000
26: , a23 JTF_VARCHAR2_TABLE_2000
27: ) as

Line 70: , a2 out nocopy JTF_VARCHAR2_TABLE_100

66: end if;
67: end rosetta_table_copy_in_p23;
68: procedure rosetta_table_copy_out_p23(t okl_vld_pvt.vldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_500
72: , a4 out nocopy JTF_VARCHAR2_TABLE_500
73: , a5 out nocopy JTF_VARCHAR2_TABLE_500
74: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 88: , a20 out nocopy JTF_VARCHAR2_TABLE_100

84: , a16 out nocopy JTF_VARCHAR2_TABLE_500
85: , a17 out nocopy JTF_VARCHAR2_TABLE_500
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_NUMBER_TABLE
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_300
90: , a22 out nocopy JTF_VARCHAR2_TABLE_2000
91: , a23 out nocopy JTF_VARCHAR2_TABLE_2000
92: ) as

Line 98: a2 := JTF_VARCHAR2_TABLE_100();

94: begin
95: if t is null or t.count = 0 then
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_VARCHAR2_TABLE_500();
100: a4 := JTF_VARCHAR2_TABLE_500();
101: a5 := JTF_VARCHAR2_TABLE_500();
102: a6 := JTF_VARCHAR2_TABLE_500();

Line 116: a20 := JTF_VARCHAR2_TABLE_100();

112: a16 := JTF_VARCHAR2_TABLE_500();
113: a17 := JTF_VARCHAR2_TABLE_500();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_NUMBER_TABLE();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_300();
118: a22 := JTF_VARCHAR2_TABLE_2000();
119: a23 := JTF_VARCHAR2_TABLE_2000();
120: else

Line 123: a2 := JTF_VARCHAR2_TABLE_100();

119: a23 := JTF_VARCHAR2_TABLE_2000();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_500();
125: a4 := JTF_VARCHAR2_TABLE_500();
126: a5 := JTF_VARCHAR2_TABLE_500();
127: a6 := JTF_VARCHAR2_TABLE_500();

Line 141: a20 := JTF_VARCHAR2_TABLE_100();

137: a16 := JTF_VARCHAR2_TABLE_500();
138: a17 := JTF_VARCHAR2_TABLE_500();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_NUMBER_TABLE();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_300();
143: a22 := JTF_VARCHAR2_TABLE_2000();
144: a23 := JTF_VARCHAR2_TABLE_2000();
145: if t.count > 0 then

Line 214: , p5_a2 JTF_VARCHAR2_TABLE_100

210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_VARCHAR2_TABLE_100
215: , p5_a3 JTF_VARCHAR2_TABLE_500
216: , p5_a4 JTF_VARCHAR2_TABLE_500
217: , p5_a5 JTF_VARCHAR2_TABLE_500
218: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 232: , p5_a20 JTF_VARCHAR2_TABLE_100

228: , p5_a16 JTF_VARCHAR2_TABLE_500
229: , p5_a17 JTF_VARCHAR2_TABLE_500
230: , p5_a18 JTF_NUMBER_TABLE
231: , p5_a19 JTF_NUMBER_TABLE
232: , p5_a20 JTF_VARCHAR2_TABLE_100
233: , p5_a21 JTF_VARCHAR2_TABLE_300
234: , p5_a22 JTF_VARCHAR2_TABLE_2000
235: , p5_a23 JTF_VARCHAR2_TABLE_2000
236: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 238: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

234: , p5_a22 JTF_VARCHAR2_TABLE_2000
235: , p5_a23 JTF_VARCHAR2_TABLE_2000
236: , p6_a0 out nocopy JTF_NUMBER_TABLE
237: , p6_a1 out nocopy JTF_NUMBER_TABLE
238: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
240: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
241: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
242: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 256: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

252: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
253: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
254: , p6_a18 out nocopy JTF_NUMBER_TABLE
255: , p6_a19 out nocopy JTF_NUMBER_TABLE
256: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
257: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
258: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000
259: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000
260: )

Line 351: , p5_a2 JTF_VARCHAR2_TABLE_100

347: , x_msg_count out nocopy NUMBER
348: , x_msg_data out nocopy VARCHAR2
349: , p5_a0 JTF_NUMBER_TABLE
350: , p5_a1 JTF_NUMBER_TABLE
351: , p5_a2 JTF_VARCHAR2_TABLE_100
352: , p5_a3 JTF_VARCHAR2_TABLE_500
353: , p5_a4 JTF_VARCHAR2_TABLE_500
354: , p5_a5 JTF_VARCHAR2_TABLE_500
355: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 369: , p5_a20 JTF_VARCHAR2_TABLE_100

365: , p5_a16 JTF_VARCHAR2_TABLE_500
366: , p5_a17 JTF_VARCHAR2_TABLE_500
367: , p5_a18 JTF_NUMBER_TABLE
368: , p5_a19 JTF_NUMBER_TABLE
369: , p5_a20 JTF_VARCHAR2_TABLE_100
370: , p5_a21 JTF_VARCHAR2_TABLE_300
371: , p5_a22 JTF_VARCHAR2_TABLE_2000
372: , p5_a23 JTF_VARCHAR2_TABLE_2000
373: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

371: , p5_a22 JTF_VARCHAR2_TABLE_2000
372: , p5_a23 JTF_VARCHAR2_TABLE_2000
373: , p6_a0 out nocopy JTF_NUMBER_TABLE
374: , p6_a1 out nocopy JTF_NUMBER_TABLE
375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
377: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
378: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
379: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 393: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

389: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
390: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
391: , p6_a18 out nocopy JTF_NUMBER_TABLE
392: , p6_a19 out nocopy JTF_NUMBER_TABLE
393: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
395: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000
396: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000
397: )

Line 488: , p5_a2 JTF_VARCHAR2_TABLE_100

484: , x_msg_count out nocopy NUMBER
485: , x_msg_data out nocopy VARCHAR2
486: , p5_a0 JTF_NUMBER_TABLE
487: , p5_a1 JTF_NUMBER_TABLE
488: , p5_a2 JTF_VARCHAR2_TABLE_100
489: , p5_a3 JTF_VARCHAR2_TABLE_500
490: , p5_a4 JTF_VARCHAR2_TABLE_500
491: , p5_a5 JTF_VARCHAR2_TABLE_500
492: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 506: , p5_a20 JTF_VARCHAR2_TABLE_100

502: , p5_a16 JTF_VARCHAR2_TABLE_500
503: , p5_a17 JTF_VARCHAR2_TABLE_500
504: , p5_a18 JTF_NUMBER_TABLE
505: , p5_a19 JTF_NUMBER_TABLE
506: , p5_a20 JTF_VARCHAR2_TABLE_100
507: , p5_a21 JTF_VARCHAR2_TABLE_300
508: , p5_a22 JTF_VARCHAR2_TABLE_2000
509: , p5_a23 JTF_VARCHAR2_TABLE_2000
510: )