APPS.OKL_QQH_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_qqh_pvt_w as
2: /* $Header: OKLIQQHS.pls 120.1 2005/12/28 13:40:12 abhsaxen noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_qqh_pvt.qqhv_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 25: , a22 JTF_VARCHAR2_TABLE_100

21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE

Line 28: , a25 JTF_VARCHAR2_TABLE_100

24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE

Line 34: , a31 JTF_VARCHAR2_TABLE_100

30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE

Line 35: , a32 JTF_VARCHAR2_TABLE_100

31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100

Line 42: , a39 JTF_VARCHAR2_TABLE_100

38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_NUMBER_TABLE

Line 43: , a40 JTF_VARCHAR2_TABLE_100

39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE

Line 56: , a53 JTF_VARCHAR2_TABLE_100

52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_VARCHAR2_TABLE_300
54: , a51 JTF_VARCHAR2_TABLE_2000
55: , a52 JTF_VARCHAR2_TABLE_2000
56: , a53 JTF_VARCHAR2_TABLE_100
57: );
58: procedure rosetta_table_copy_out_p23(t okl_qqh_pvt.qqhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a2 out nocopy JTF_VARCHAR2_TABLE_100

56: , a53 JTF_VARCHAR2_TABLE_100
57: );
58: procedure rosetta_table_copy_out_p23(t okl_qqh_pvt.qqhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_VARCHAR2_TABLE_500
62: , a4 out nocopy JTF_VARCHAR2_TABLE_500
63: , a5 out nocopy JTF_VARCHAR2_TABLE_500
64: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 80: , a22 out nocopy JTF_VARCHAR2_TABLE_100

76: , a18 out nocopy JTF_VARCHAR2_TABLE_200
77: , a19 out nocopy JTF_DATE_TABLE
78: , a20 out nocopy JTF_NUMBER_TABLE
79: , a21 out nocopy JTF_NUMBER_TABLE
80: , a22 out nocopy JTF_VARCHAR2_TABLE_100
81: , a23 out nocopy JTF_NUMBER_TABLE
82: , a24 out nocopy JTF_NUMBER_TABLE
83: , a25 out nocopy JTF_VARCHAR2_TABLE_100
84: , a26 out nocopy JTF_NUMBER_TABLE

Line 83: , a25 out nocopy JTF_VARCHAR2_TABLE_100

79: , a21 out nocopy JTF_NUMBER_TABLE
80: , a22 out nocopy JTF_VARCHAR2_TABLE_100
81: , a23 out nocopy JTF_NUMBER_TABLE
82: , a24 out nocopy JTF_NUMBER_TABLE
83: , a25 out nocopy JTF_VARCHAR2_TABLE_100
84: , a26 out nocopy JTF_NUMBER_TABLE
85: , a27 out nocopy JTF_NUMBER_TABLE
86: , a28 out nocopy JTF_NUMBER_TABLE
87: , a29 out nocopy JTF_NUMBER_TABLE

Line 89: , a31 out nocopy JTF_VARCHAR2_TABLE_100

85: , a27 out nocopy JTF_NUMBER_TABLE
86: , a28 out nocopy JTF_NUMBER_TABLE
87: , a29 out nocopy JTF_NUMBER_TABLE
88: , a30 out nocopy JTF_NUMBER_TABLE
89: , a31 out nocopy JTF_VARCHAR2_TABLE_100
90: , a32 out nocopy JTF_VARCHAR2_TABLE_100
91: , a33 out nocopy JTF_NUMBER_TABLE
92: , a34 out nocopy JTF_NUMBER_TABLE
93: , a35 out nocopy JTF_NUMBER_TABLE

Line 90: , a32 out nocopy JTF_VARCHAR2_TABLE_100

86: , a28 out nocopy JTF_NUMBER_TABLE
87: , a29 out nocopy JTF_NUMBER_TABLE
88: , a30 out nocopy JTF_NUMBER_TABLE
89: , a31 out nocopy JTF_VARCHAR2_TABLE_100
90: , a32 out nocopy JTF_VARCHAR2_TABLE_100
91: , a33 out nocopy JTF_NUMBER_TABLE
92: , a34 out nocopy JTF_NUMBER_TABLE
93: , a35 out nocopy JTF_NUMBER_TABLE
94: , a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 94: , a36 out nocopy JTF_VARCHAR2_TABLE_100

90: , a32 out nocopy JTF_VARCHAR2_TABLE_100
91: , a33 out nocopy JTF_NUMBER_TABLE
92: , a34 out nocopy JTF_NUMBER_TABLE
93: , a35 out nocopy JTF_NUMBER_TABLE
94: , a36 out nocopy JTF_VARCHAR2_TABLE_100
95: , a37 out nocopy JTF_NUMBER_TABLE
96: , a38 out nocopy JTF_NUMBER_TABLE
97: , a39 out nocopy JTF_VARCHAR2_TABLE_100
98: , a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 97: , a39 out nocopy JTF_VARCHAR2_TABLE_100

93: , a35 out nocopy JTF_NUMBER_TABLE
94: , a36 out nocopy JTF_VARCHAR2_TABLE_100
95: , a37 out nocopy JTF_NUMBER_TABLE
96: , a38 out nocopy JTF_NUMBER_TABLE
97: , a39 out nocopy JTF_VARCHAR2_TABLE_100
98: , a40 out nocopy JTF_VARCHAR2_TABLE_100
99: , a41 out nocopy JTF_NUMBER_TABLE
100: , a42 out nocopy JTF_NUMBER_TABLE
101: , a43 out nocopy JTF_NUMBER_TABLE

Line 98: , a40 out nocopy JTF_VARCHAR2_TABLE_100

94: , a36 out nocopy JTF_VARCHAR2_TABLE_100
95: , a37 out nocopy JTF_NUMBER_TABLE
96: , a38 out nocopy JTF_NUMBER_TABLE
97: , a39 out nocopy JTF_VARCHAR2_TABLE_100
98: , a40 out nocopy JTF_VARCHAR2_TABLE_100
99: , a41 out nocopy JTF_NUMBER_TABLE
100: , a42 out nocopy JTF_NUMBER_TABLE
101: , a43 out nocopy JTF_NUMBER_TABLE
102: , a44 out nocopy JTF_NUMBER_TABLE

Line 111: , a53 out nocopy JTF_VARCHAR2_TABLE_100

107: , a49 out nocopy JTF_NUMBER_TABLE
108: , a50 out nocopy JTF_VARCHAR2_TABLE_300
109: , a51 out nocopy JTF_VARCHAR2_TABLE_2000
110: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a53 out nocopy JTF_VARCHAR2_TABLE_100
112: );
113:
114: procedure insert_row(p_api_version NUMBER
115: , p_init_msg_list VARCHAR2

Line 121: , p5_a2 JTF_VARCHAR2_TABLE_100

117: , x_msg_count out nocopy NUMBER
118: , x_msg_data out nocopy VARCHAR2
119: , p5_a0 JTF_NUMBER_TABLE
120: , p5_a1 JTF_NUMBER_TABLE
121: , p5_a2 JTF_VARCHAR2_TABLE_100
122: , p5_a3 JTF_VARCHAR2_TABLE_500
123: , p5_a4 JTF_VARCHAR2_TABLE_500
124: , p5_a5 JTF_VARCHAR2_TABLE_500
125: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 141: , p5_a22 JTF_VARCHAR2_TABLE_100

137: , p5_a18 JTF_VARCHAR2_TABLE_200
138: , p5_a19 JTF_DATE_TABLE
139: , p5_a20 JTF_NUMBER_TABLE
140: , p5_a21 JTF_NUMBER_TABLE
141: , p5_a22 JTF_VARCHAR2_TABLE_100
142: , p5_a23 JTF_NUMBER_TABLE
143: , p5_a24 JTF_NUMBER_TABLE
144: , p5_a25 JTF_VARCHAR2_TABLE_100
145: , p5_a26 JTF_NUMBER_TABLE

Line 144: , p5_a25 JTF_VARCHAR2_TABLE_100

140: , p5_a21 JTF_NUMBER_TABLE
141: , p5_a22 JTF_VARCHAR2_TABLE_100
142: , p5_a23 JTF_NUMBER_TABLE
143: , p5_a24 JTF_NUMBER_TABLE
144: , p5_a25 JTF_VARCHAR2_TABLE_100
145: , p5_a26 JTF_NUMBER_TABLE
146: , p5_a27 JTF_NUMBER_TABLE
147: , p5_a28 JTF_NUMBER_TABLE
148: , p5_a29 JTF_NUMBER_TABLE

Line 150: , p5_a31 JTF_VARCHAR2_TABLE_100

146: , p5_a27 JTF_NUMBER_TABLE
147: , p5_a28 JTF_NUMBER_TABLE
148: , p5_a29 JTF_NUMBER_TABLE
149: , p5_a30 JTF_NUMBER_TABLE
150: , p5_a31 JTF_VARCHAR2_TABLE_100
151: , p5_a32 JTF_VARCHAR2_TABLE_100
152: , p5_a33 JTF_NUMBER_TABLE
153: , p5_a34 JTF_NUMBER_TABLE
154: , p5_a35 JTF_NUMBER_TABLE

Line 151: , p5_a32 JTF_VARCHAR2_TABLE_100

147: , p5_a28 JTF_NUMBER_TABLE
148: , p5_a29 JTF_NUMBER_TABLE
149: , p5_a30 JTF_NUMBER_TABLE
150: , p5_a31 JTF_VARCHAR2_TABLE_100
151: , p5_a32 JTF_VARCHAR2_TABLE_100
152: , p5_a33 JTF_NUMBER_TABLE
153: , p5_a34 JTF_NUMBER_TABLE
154: , p5_a35 JTF_NUMBER_TABLE
155: , p5_a36 JTF_VARCHAR2_TABLE_100

Line 155: , p5_a36 JTF_VARCHAR2_TABLE_100

151: , p5_a32 JTF_VARCHAR2_TABLE_100
152: , p5_a33 JTF_NUMBER_TABLE
153: , p5_a34 JTF_NUMBER_TABLE
154: , p5_a35 JTF_NUMBER_TABLE
155: , p5_a36 JTF_VARCHAR2_TABLE_100
156: , p5_a37 JTF_NUMBER_TABLE
157: , p5_a38 JTF_NUMBER_TABLE
158: , p5_a39 JTF_VARCHAR2_TABLE_100
159: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 158: , p5_a39 JTF_VARCHAR2_TABLE_100

154: , p5_a35 JTF_NUMBER_TABLE
155: , p5_a36 JTF_VARCHAR2_TABLE_100
156: , p5_a37 JTF_NUMBER_TABLE
157: , p5_a38 JTF_NUMBER_TABLE
158: , p5_a39 JTF_VARCHAR2_TABLE_100
159: , p5_a40 JTF_VARCHAR2_TABLE_100
160: , p5_a41 JTF_NUMBER_TABLE
161: , p5_a42 JTF_NUMBER_TABLE
162: , p5_a43 JTF_NUMBER_TABLE

Line 159: , p5_a40 JTF_VARCHAR2_TABLE_100

155: , p5_a36 JTF_VARCHAR2_TABLE_100
156: , p5_a37 JTF_NUMBER_TABLE
157: , p5_a38 JTF_NUMBER_TABLE
158: , p5_a39 JTF_VARCHAR2_TABLE_100
159: , p5_a40 JTF_VARCHAR2_TABLE_100
160: , p5_a41 JTF_NUMBER_TABLE
161: , p5_a42 JTF_NUMBER_TABLE
162: , p5_a43 JTF_NUMBER_TABLE
163: , p5_a44 JTF_NUMBER_TABLE

Line 172: , p5_a53 JTF_VARCHAR2_TABLE_100

168: , p5_a49 JTF_NUMBER_TABLE
169: , p5_a50 JTF_VARCHAR2_TABLE_300
170: , p5_a51 JTF_VARCHAR2_TABLE_2000
171: , p5_a52 JTF_VARCHAR2_TABLE_2000
172: , p5_a53 JTF_VARCHAR2_TABLE_100
173: , p6_a0 out nocopy JTF_NUMBER_TABLE
174: , p6_a1 out nocopy JTF_NUMBER_TABLE
175: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
176: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 175: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

171: , p5_a52 JTF_VARCHAR2_TABLE_2000
172: , p5_a53 JTF_VARCHAR2_TABLE_100
173: , p6_a0 out nocopy JTF_NUMBER_TABLE
174: , p6_a1 out nocopy JTF_NUMBER_TABLE
175: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
176: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
177: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
178: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
179: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 195: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

191: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
192: , p6_a19 out nocopy JTF_DATE_TABLE
193: , p6_a20 out nocopy JTF_NUMBER_TABLE
194: , p6_a21 out nocopy JTF_NUMBER_TABLE
195: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a23 out nocopy JTF_NUMBER_TABLE
197: , p6_a24 out nocopy JTF_NUMBER_TABLE
198: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
199: , p6_a26 out nocopy JTF_NUMBER_TABLE

Line 198: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

194: , p6_a21 out nocopy JTF_NUMBER_TABLE
195: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a23 out nocopy JTF_NUMBER_TABLE
197: , p6_a24 out nocopy JTF_NUMBER_TABLE
198: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
199: , p6_a26 out nocopy JTF_NUMBER_TABLE
200: , p6_a27 out nocopy JTF_NUMBER_TABLE
201: , p6_a28 out nocopy JTF_NUMBER_TABLE
202: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 204: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

200: , p6_a27 out nocopy JTF_NUMBER_TABLE
201: , p6_a28 out nocopy JTF_NUMBER_TABLE
202: , p6_a29 out nocopy JTF_NUMBER_TABLE
203: , p6_a30 out nocopy JTF_NUMBER_TABLE
204: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
205: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
206: , p6_a33 out nocopy JTF_NUMBER_TABLE
207: , p6_a34 out nocopy JTF_NUMBER_TABLE
208: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 205: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100

201: , p6_a28 out nocopy JTF_NUMBER_TABLE
202: , p6_a29 out nocopy JTF_NUMBER_TABLE
203: , p6_a30 out nocopy JTF_NUMBER_TABLE
204: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
205: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
206: , p6_a33 out nocopy JTF_NUMBER_TABLE
207: , p6_a34 out nocopy JTF_NUMBER_TABLE
208: , p6_a35 out nocopy JTF_NUMBER_TABLE
209: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 209: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

205: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
206: , p6_a33 out nocopy JTF_NUMBER_TABLE
207: , p6_a34 out nocopy JTF_NUMBER_TABLE
208: , p6_a35 out nocopy JTF_NUMBER_TABLE
209: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a37 out nocopy JTF_NUMBER_TABLE
211: , p6_a38 out nocopy JTF_NUMBER_TABLE
212: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
213: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 212: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

208: , p6_a35 out nocopy JTF_NUMBER_TABLE
209: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a37 out nocopy JTF_NUMBER_TABLE
211: , p6_a38 out nocopy JTF_NUMBER_TABLE
212: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
213: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
214: , p6_a41 out nocopy JTF_NUMBER_TABLE
215: , p6_a42 out nocopy JTF_NUMBER_TABLE
216: , p6_a43 out nocopy JTF_NUMBER_TABLE

Line 213: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

209: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a37 out nocopy JTF_NUMBER_TABLE
211: , p6_a38 out nocopy JTF_NUMBER_TABLE
212: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
213: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
214: , p6_a41 out nocopy JTF_NUMBER_TABLE
215: , p6_a42 out nocopy JTF_NUMBER_TABLE
216: , p6_a43 out nocopy JTF_NUMBER_TABLE
217: , p6_a44 out nocopy JTF_NUMBER_TABLE

Line 226: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100

222: , p6_a49 out nocopy JTF_NUMBER_TABLE
223: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
224: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
225: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
227: );
228: procedure update_row(p_api_version NUMBER
229: , p_init_msg_list VARCHAR2
230: , x_return_status out nocopy VARCHAR2

Line 235: , p5_a2 JTF_VARCHAR2_TABLE_100

231: , x_msg_count out nocopy NUMBER
232: , x_msg_data out nocopy VARCHAR2
233: , p5_a0 JTF_NUMBER_TABLE
234: , p5_a1 JTF_NUMBER_TABLE
235: , p5_a2 JTF_VARCHAR2_TABLE_100
236: , p5_a3 JTF_VARCHAR2_TABLE_500
237: , p5_a4 JTF_VARCHAR2_TABLE_500
238: , p5_a5 JTF_VARCHAR2_TABLE_500
239: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 255: , p5_a22 JTF_VARCHAR2_TABLE_100

251: , p5_a18 JTF_VARCHAR2_TABLE_200
252: , p5_a19 JTF_DATE_TABLE
253: , p5_a20 JTF_NUMBER_TABLE
254: , p5_a21 JTF_NUMBER_TABLE
255: , p5_a22 JTF_VARCHAR2_TABLE_100
256: , p5_a23 JTF_NUMBER_TABLE
257: , p5_a24 JTF_NUMBER_TABLE
258: , p5_a25 JTF_VARCHAR2_TABLE_100
259: , p5_a26 JTF_NUMBER_TABLE

Line 258: , p5_a25 JTF_VARCHAR2_TABLE_100

254: , p5_a21 JTF_NUMBER_TABLE
255: , p5_a22 JTF_VARCHAR2_TABLE_100
256: , p5_a23 JTF_NUMBER_TABLE
257: , p5_a24 JTF_NUMBER_TABLE
258: , p5_a25 JTF_VARCHAR2_TABLE_100
259: , p5_a26 JTF_NUMBER_TABLE
260: , p5_a27 JTF_NUMBER_TABLE
261: , p5_a28 JTF_NUMBER_TABLE
262: , p5_a29 JTF_NUMBER_TABLE

Line 264: , p5_a31 JTF_VARCHAR2_TABLE_100

260: , p5_a27 JTF_NUMBER_TABLE
261: , p5_a28 JTF_NUMBER_TABLE
262: , p5_a29 JTF_NUMBER_TABLE
263: , p5_a30 JTF_NUMBER_TABLE
264: , p5_a31 JTF_VARCHAR2_TABLE_100
265: , p5_a32 JTF_VARCHAR2_TABLE_100
266: , p5_a33 JTF_NUMBER_TABLE
267: , p5_a34 JTF_NUMBER_TABLE
268: , p5_a35 JTF_NUMBER_TABLE

Line 265: , p5_a32 JTF_VARCHAR2_TABLE_100

261: , p5_a28 JTF_NUMBER_TABLE
262: , p5_a29 JTF_NUMBER_TABLE
263: , p5_a30 JTF_NUMBER_TABLE
264: , p5_a31 JTF_VARCHAR2_TABLE_100
265: , p5_a32 JTF_VARCHAR2_TABLE_100
266: , p5_a33 JTF_NUMBER_TABLE
267: , p5_a34 JTF_NUMBER_TABLE
268: , p5_a35 JTF_NUMBER_TABLE
269: , p5_a36 JTF_VARCHAR2_TABLE_100

Line 269: , p5_a36 JTF_VARCHAR2_TABLE_100

265: , p5_a32 JTF_VARCHAR2_TABLE_100
266: , p5_a33 JTF_NUMBER_TABLE
267: , p5_a34 JTF_NUMBER_TABLE
268: , p5_a35 JTF_NUMBER_TABLE
269: , p5_a36 JTF_VARCHAR2_TABLE_100
270: , p5_a37 JTF_NUMBER_TABLE
271: , p5_a38 JTF_NUMBER_TABLE
272: , p5_a39 JTF_VARCHAR2_TABLE_100
273: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 272: , p5_a39 JTF_VARCHAR2_TABLE_100

268: , p5_a35 JTF_NUMBER_TABLE
269: , p5_a36 JTF_VARCHAR2_TABLE_100
270: , p5_a37 JTF_NUMBER_TABLE
271: , p5_a38 JTF_NUMBER_TABLE
272: , p5_a39 JTF_VARCHAR2_TABLE_100
273: , p5_a40 JTF_VARCHAR2_TABLE_100
274: , p5_a41 JTF_NUMBER_TABLE
275: , p5_a42 JTF_NUMBER_TABLE
276: , p5_a43 JTF_NUMBER_TABLE

Line 273: , p5_a40 JTF_VARCHAR2_TABLE_100

269: , p5_a36 JTF_VARCHAR2_TABLE_100
270: , p5_a37 JTF_NUMBER_TABLE
271: , p5_a38 JTF_NUMBER_TABLE
272: , p5_a39 JTF_VARCHAR2_TABLE_100
273: , p5_a40 JTF_VARCHAR2_TABLE_100
274: , p5_a41 JTF_NUMBER_TABLE
275: , p5_a42 JTF_NUMBER_TABLE
276: , p5_a43 JTF_NUMBER_TABLE
277: , p5_a44 JTF_NUMBER_TABLE

Line 286: , p5_a53 JTF_VARCHAR2_TABLE_100

282: , p5_a49 JTF_NUMBER_TABLE
283: , p5_a50 JTF_VARCHAR2_TABLE_300
284: , p5_a51 JTF_VARCHAR2_TABLE_2000
285: , p5_a52 JTF_VARCHAR2_TABLE_2000
286: , p5_a53 JTF_VARCHAR2_TABLE_100
287: , p6_a0 out nocopy JTF_NUMBER_TABLE
288: , p6_a1 out nocopy JTF_NUMBER_TABLE
289: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 289: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

285: , p5_a52 JTF_VARCHAR2_TABLE_2000
286: , p5_a53 JTF_VARCHAR2_TABLE_100
287: , p6_a0 out nocopy JTF_NUMBER_TABLE
288: , p6_a1 out nocopy JTF_NUMBER_TABLE
289: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
291: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
292: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
293: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 309: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

305: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
306: , p6_a19 out nocopy JTF_DATE_TABLE
307: , p6_a20 out nocopy JTF_NUMBER_TABLE
308: , p6_a21 out nocopy JTF_NUMBER_TABLE
309: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a23 out nocopy JTF_NUMBER_TABLE
311: , p6_a24 out nocopy JTF_NUMBER_TABLE
312: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a26 out nocopy JTF_NUMBER_TABLE

Line 312: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

308: , p6_a21 out nocopy JTF_NUMBER_TABLE
309: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a23 out nocopy JTF_NUMBER_TABLE
311: , p6_a24 out nocopy JTF_NUMBER_TABLE
312: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a26 out nocopy JTF_NUMBER_TABLE
314: , p6_a27 out nocopy JTF_NUMBER_TABLE
315: , p6_a28 out nocopy JTF_NUMBER_TABLE
316: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 318: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

314: , p6_a27 out nocopy JTF_NUMBER_TABLE
315: , p6_a28 out nocopy JTF_NUMBER_TABLE
316: , p6_a29 out nocopy JTF_NUMBER_TABLE
317: , p6_a30 out nocopy JTF_NUMBER_TABLE
318: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a33 out nocopy JTF_NUMBER_TABLE
321: , p6_a34 out nocopy JTF_NUMBER_TABLE
322: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 319: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100

315: , p6_a28 out nocopy JTF_NUMBER_TABLE
316: , p6_a29 out nocopy JTF_NUMBER_TABLE
317: , p6_a30 out nocopy JTF_NUMBER_TABLE
318: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a33 out nocopy JTF_NUMBER_TABLE
321: , p6_a34 out nocopy JTF_NUMBER_TABLE
322: , p6_a35 out nocopy JTF_NUMBER_TABLE
323: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 323: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

319: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a33 out nocopy JTF_NUMBER_TABLE
321: , p6_a34 out nocopy JTF_NUMBER_TABLE
322: , p6_a35 out nocopy JTF_NUMBER_TABLE
323: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
324: , p6_a37 out nocopy JTF_NUMBER_TABLE
325: , p6_a38 out nocopy JTF_NUMBER_TABLE
326: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
327: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 326: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

322: , p6_a35 out nocopy JTF_NUMBER_TABLE
323: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
324: , p6_a37 out nocopy JTF_NUMBER_TABLE
325: , p6_a38 out nocopy JTF_NUMBER_TABLE
326: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
327: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a41 out nocopy JTF_NUMBER_TABLE
329: , p6_a42 out nocopy JTF_NUMBER_TABLE
330: , p6_a43 out nocopy JTF_NUMBER_TABLE

Line 327: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

323: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
324: , p6_a37 out nocopy JTF_NUMBER_TABLE
325: , p6_a38 out nocopy JTF_NUMBER_TABLE
326: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
327: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a41 out nocopy JTF_NUMBER_TABLE
329: , p6_a42 out nocopy JTF_NUMBER_TABLE
330: , p6_a43 out nocopy JTF_NUMBER_TABLE
331: , p6_a44 out nocopy JTF_NUMBER_TABLE

Line 340: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100

336: , p6_a49 out nocopy JTF_NUMBER_TABLE
337: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
338: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
340: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
341: );
342: procedure delete_row(p_api_version NUMBER
343: , p_init_msg_list VARCHAR2
344: , x_return_status out nocopy VARCHAR2

Line 349: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 369: , p5_a22 JTF_VARCHAR2_TABLE_100

365: , p5_a18 JTF_VARCHAR2_TABLE_200
366: , p5_a19 JTF_DATE_TABLE
367: , p5_a20 JTF_NUMBER_TABLE
368: , p5_a21 JTF_NUMBER_TABLE
369: , p5_a22 JTF_VARCHAR2_TABLE_100
370: , p5_a23 JTF_NUMBER_TABLE
371: , p5_a24 JTF_NUMBER_TABLE
372: , p5_a25 JTF_VARCHAR2_TABLE_100
373: , p5_a26 JTF_NUMBER_TABLE

Line 372: , p5_a25 JTF_VARCHAR2_TABLE_100

368: , p5_a21 JTF_NUMBER_TABLE
369: , p5_a22 JTF_VARCHAR2_TABLE_100
370: , p5_a23 JTF_NUMBER_TABLE
371: , p5_a24 JTF_NUMBER_TABLE
372: , p5_a25 JTF_VARCHAR2_TABLE_100
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_NUMBER_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_NUMBER_TABLE

Line 378: , p5_a31 JTF_VARCHAR2_TABLE_100

374: , p5_a27 JTF_NUMBER_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_NUMBER_TABLE
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_VARCHAR2_TABLE_100
379: , p5_a32 JTF_VARCHAR2_TABLE_100
380: , p5_a33 JTF_NUMBER_TABLE
381: , p5_a34 JTF_NUMBER_TABLE
382: , p5_a35 JTF_NUMBER_TABLE

Line 379: , p5_a32 JTF_VARCHAR2_TABLE_100

375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_NUMBER_TABLE
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_VARCHAR2_TABLE_100
379: , p5_a32 JTF_VARCHAR2_TABLE_100
380: , p5_a33 JTF_NUMBER_TABLE
381: , p5_a34 JTF_NUMBER_TABLE
382: , p5_a35 JTF_NUMBER_TABLE
383: , p5_a36 JTF_VARCHAR2_TABLE_100

Line 383: , p5_a36 JTF_VARCHAR2_TABLE_100

379: , p5_a32 JTF_VARCHAR2_TABLE_100
380: , p5_a33 JTF_NUMBER_TABLE
381: , p5_a34 JTF_NUMBER_TABLE
382: , p5_a35 JTF_NUMBER_TABLE
383: , p5_a36 JTF_VARCHAR2_TABLE_100
384: , p5_a37 JTF_NUMBER_TABLE
385: , p5_a38 JTF_NUMBER_TABLE
386: , p5_a39 JTF_VARCHAR2_TABLE_100
387: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 386: , p5_a39 JTF_VARCHAR2_TABLE_100

382: , p5_a35 JTF_NUMBER_TABLE
383: , p5_a36 JTF_VARCHAR2_TABLE_100
384: , p5_a37 JTF_NUMBER_TABLE
385: , p5_a38 JTF_NUMBER_TABLE
386: , p5_a39 JTF_VARCHAR2_TABLE_100
387: , p5_a40 JTF_VARCHAR2_TABLE_100
388: , p5_a41 JTF_NUMBER_TABLE
389: , p5_a42 JTF_NUMBER_TABLE
390: , p5_a43 JTF_NUMBER_TABLE

Line 387: , p5_a40 JTF_VARCHAR2_TABLE_100

383: , p5_a36 JTF_VARCHAR2_TABLE_100
384: , p5_a37 JTF_NUMBER_TABLE
385: , p5_a38 JTF_NUMBER_TABLE
386: , p5_a39 JTF_VARCHAR2_TABLE_100
387: , p5_a40 JTF_VARCHAR2_TABLE_100
388: , p5_a41 JTF_NUMBER_TABLE
389: , p5_a42 JTF_NUMBER_TABLE
390: , p5_a43 JTF_NUMBER_TABLE
391: , p5_a44 JTF_NUMBER_TABLE

Line 400: , p5_a53 JTF_VARCHAR2_TABLE_100

396: , p5_a49 JTF_NUMBER_TABLE
397: , p5_a50 JTF_VARCHAR2_TABLE_300
398: , p5_a51 JTF_VARCHAR2_TABLE_2000
399: , p5_a52 JTF_VARCHAR2_TABLE_2000
400: , p5_a53 JTF_VARCHAR2_TABLE_100
401: );
402: procedure insert_row(p_api_version NUMBER
403: , p_init_msg_list VARCHAR2
404: , x_return_status out nocopy VARCHAR2