DBA Data[Home] [Help]

APPS.OKL_QQL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_qql_pvt_w as
2: /* $Header: OKLIQQLS.pls 120.0 2005/09/27 05:28:16 schodava noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_qql_pvt.qqlv_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_NUMBER_TABLE
25: , a22 JTF_NUMBER_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_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE

Line 37: , a2 out nocopy JTF_VARCHAR2_TABLE_100

33: , a30 JTF_VARCHAR2_TABLE_2000
34: );
35: procedure rosetta_table_copy_out_p23(t okl_qql_pvt.qqlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_VARCHAR2_TABLE_500
39: , a4 out nocopy JTF_VARCHAR2_TABLE_500
40: , a5 out nocopy JTF_VARCHAR2_TABLE_500
41: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 54: , a19 out nocopy JTF_VARCHAR2_TABLE_100

50: , a15 out nocopy JTF_VARCHAR2_TABLE_500
51: , a16 out nocopy JTF_VARCHAR2_TABLE_500
52: , a17 out nocopy JTF_VARCHAR2_TABLE_500
53: , a18 out nocopy JTF_NUMBER_TABLE
54: , a19 out nocopy JTF_VARCHAR2_TABLE_100
55: , a20 out nocopy JTF_VARCHAR2_TABLE_100
56: , a21 out nocopy JTF_NUMBER_TABLE
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE

Line 55: , a20 out nocopy JTF_VARCHAR2_TABLE_100

51: , a16 out nocopy JTF_VARCHAR2_TABLE_500
52: , a17 out nocopy JTF_VARCHAR2_TABLE_500
53: , a18 out nocopy JTF_NUMBER_TABLE
54: , a19 out nocopy JTF_VARCHAR2_TABLE_100
55: , a20 out nocopy JTF_VARCHAR2_TABLE_100
56: , a21 out nocopy JTF_NUMBER_TABLE
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE

Line 75: , p5_a2 JTF_VARCHAR2_TABLE_100

71: , x_msg_count out nocopy NUMBER
72: , x_msg_data out nocopy VARCHAR2
73: , p5_a0 JTF_NUMBER_TABLE
74: , p5_a1 JTF_NUMBER_TABLE
75: , p5_a2 JTF_VARCHAR2_TABLE_100
76: , p5_a3 JTF_VARCHAR2_TABLE_500
77: , p5_a4 JTF_VARCHAR2_TABLE_500
78: , p5_a5 JTF_VARCHAR2_TABLE_500
79: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 92: , p5_a19 JTF_VARCHAR2_TABLE_100

88: , p5_a15 JTF_VARCHAR2_TABLE_500
89: , p5_a16 JTF_VARCHAR2_TABLE_500
90: , p5_a17 JTF_VARCHAR2_TABLE_500
91: , p5_a18 JTF_NUMBER_TABLE
92: , p5_a19 JTF_VARCHAR2_TABLE_100
93: , p5_a20 JTF_VARCHAR2_TABLE_100
94: , p5_a21 JTF_NUMBER_TABLE
95: , p5_a22 JTF_NUMBER_TABLE
96: , p5_a23 JTF_NUMBER_TABLE

Line 93: , p5_a20 JTF_VARCHAR2_TABLE_100

89: , p5_a16 JTF_VARCHAR2_TABLE_500
90: , p5_a17 JTF_VARCHAR2_TABLE_500
91: , p5_a18 JTF_NUMBER_TABLE
92: , p5_a19 JTF_VARCHAR2_TABLE_100
93: , p5_a20 JTF_VARCHAR2_TABLE_100
94: , p5_a21 JTF_NUMBER_TABLE
95: , p5_a22 JTF_NUMBER_TABLE
96: , p5_a23 JTF_NUMBER_TABLE
97: , p5_a24 JTF_NUMBER_TABLE

Line 106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

102: , p5_a29 JTF_VARCHAR2_TABLE_2000
103: , p5_a30 JTF_VARCHAR2_TABLE_2000
104: , p6_a0 out nocopy JTF_NUMBER_TABLE
105: , p6_a1 out nocopy JTF_NUMBER_TABLE
106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
107: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
108: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
109: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
110: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 123: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

119: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
120: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
121: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
122: , p6_a18 out nocopy JTF_NUMBER_TABLE
123: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
124: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
125: , p6_a21 out nocopy JTF_NUMBER_TABLE
126: , p6_a22 out nocopy JTF_NUMBER_TABLE
127: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 124: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

120: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
121: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
122: , p6_a18 out nocopy JTF_NUMBER_TABLE
123: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
124: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
125: , p6_a21 out nocopy JTF_NUMBER_TABLE
126: , p6_a22 out nocopy JTF_NUMBER_TABLE
127: , p6_a23 out nocopy JTF_NUMBER_TABLE
128: , p6_a24 out nocopy JTF_NUMBER_TABLE

Line 143: , p5_a2 JTF_VARCHAR2_TABLE_100

139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_NUMBER_TABLE
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_VARCHAR2_TABLE_500
145: , p5_a4 JTF_VARCHAR2_TABLE_500
146: , p5_a5 JTF_VARCHAR2_TABLE_500
147: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 160: , p5_a19 JTF_VARCHAR2_TABLE_100

156: , p5_a15 JTF_VARCHAR2_TABLE_500
157: , p5_a16 JTF_VARCHAR2_TABLE_500
158: , p5_a17 JTF_VARCHAR2_TABLE_500
159: , p5_a18 JTF_NUMBER_TABLE
160: , p5_a19 JTF_VARCHAR2_TABLE_100
161: , p5_a20 JTF_VARCHAR2_TABLE_100
162: , p5_a21 JTF_NUMBER_TABLE
163: , p5_a22 JTF_NUMBER_TABLE
164: , p5_a23 JTF_NUMBER_TABLE

Line 161: , p5_a20 JTF_VARCHAR2_TABLE_100

157: , p5_a16 JTF_VARCHAR2_TABLE_500
158: , p5_a17 JTF_VARCHAR2_TABLE_500
159: , p5_a18 JTF_NUMBER_TABLE
160: , p5_a19 JTF_VARCHAR2_TABLE_100
161: , p5_a20 JTF_VARCHAR2_TABLE_100
162: , p5_a21 JTF_NUMBER_TABLE
163: , p5_a22 JTF_NUMBER_TABLE
164: , p5_a23 JTF_NUMBER_TABLE
165: , p5_a24 JTF_NUMBER_TABLE

Line 174: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

170: , p5_a29 JTF_VARCHAR2_TABLE_2000
171: , p5_a30 JTF_VARCHAR2_TABLE_2000
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
176: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
177: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
178: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 191: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

187: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
188: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
189: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
190: , p6_a18 out nocopy JTF_NUMBER_TABLE
191: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
192: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
193: , p6_a21 out nocopy JTF_NUMBER_TABLE
194: , p6_a22 out nocopy JTF_NUMBER_TABLE
195: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 192: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

188: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
189: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
190: , p6_a18 out nocopy JTF_NUMBER_TABLE
191: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
192: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
193: , p6_a21 out nocopy JTF_NUMBER_TABLE
194: , p6_a22 out nocopy JTF_NUMBER_TABLE
195: , p6_a23 out nocopy JTF_NUMBER_TABLE
196: , p6_a24 out nocopy JTF_NUMBER_TABLE

Line 211: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 228: , p5_a19 JTF_VARCHAR2_TABLE_100

224: , p5_a15 JTF_VARCHAR2_TABLE_500
225: , p5_a16 JTF_VARCHAR2_TABLE_500
226: , p5_a17 JTF_VARCHAR2_TABLE_500
227: , p5_a18 JTF_NUMBER_TABLE
228: , p5_a19 JTF_VARCHAR2_TABLE_100
229: , p5_a20 JTF_VARCHAR2_TABLE_100
230: , p5_a21 JTF_NUMBER_TABLE
231: , p5_a22 JTF_NUMBER_TABLE
232: , p5_a23 JTF_NUMBER_TABLE

Line 229: , p5_a20 JTF_VARCHAR2_TABLE_100

225: , p5_a16 JTF_VARCHAR2_TABLE_500
226: , p5_a17 JTF_VARCHAR2_TABLE_500
227: , p5_a18 JTF_NUMBER_TABLE
228: , p5_a19 JTF_VARCHAR2_TABLE_100
229: , p5_a20 JTF_VARCHAR2_TABLE_100
230: , p5_a21 JTF_NUMBER_TABLE
231: , p5_a22 JTF_NUMBER_TABLE
232: , p5_a23 JTF_NUMBER_TABLE
233: , p5_a24 JTF_NUMBER_TABLE