DBA Data[Home] [Help]

APPS.OKL_SRCH_STRM_TYPS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p5_a0 JTF_NUMBER_TABLE

4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 9: , p5_a1 JTF_NUMBER_TABLE

5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 10: , p5_a2 JTF_NUMBER_TABLE

6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 11: , p5_a3 JTF_NUMBER_TABLE

7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_VARCHAR2_TABLE_500
15: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 29: , p5_a21 JTF_NUMBER_TABLE

25: , p5_a17 JTF_VARCHAR2_TABLE_500
26: , p5_a18 JTF_VARCHAR2_TABLE_500
27: , p5_a19 JTF_VARCHAR2_TABLE_500
28: , p5_a20 JTF_VARCHAR2_TABLE_500
29: , p5_a21 JTF_NUMBER_TABLE
30: , p5_a22 JTF_DATE_TABLE
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_DATE_TABLE
33: , p5_a25 JTF_NUMBER_TABLE

Line 31: , p5_a23 JTF_NUMBER_TABLE

27: , p5_a19 JTF_VARCHAR2_TABLE_500
28: , p5_a20 JTF_VARCHAR2_TABLE_500
29: , p5_a21 JTF_NUMBER_TABLE
30: , p5_a22 JTF_DATE_TABLE
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_DATE_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p6_a0 out nocopy JTF_NUMBER_TABLE
35: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 33: , p5_a25 JTF_NUMBER_TABLE

29: , p5_a21 JTF_NUMBER_TABLE
30: , p5_a22 JTF_DATE_TABLE
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_DATE_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p6_a0 out nocopy JTF_NUMBER_TABLE
35: , p6_a1 out nocopy JTF_NUMBER_TABLE
36: , p6_a2 out nocopy JTF_NUMBER_TABLE
37: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 34: , p6_a0 out nocopy JTF_NUMBER_TABLE

30: , p5_a22 JTF_DATE_TABLE
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_DATE_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p6_a0 out nocopy JTF_NUMBER_TABLE
35: , p6_a1 out nocopy JTF_NUMBER_TABLE
36: , p6_a2 out nocopy JTF_NUMBER_TABLE
37: , p6_a3 out nocopy JTF_NUMBER_TABLE
38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: , p6_a1 out nocopy JTF_NUMBER_TABLE

31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_DATE_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p6_a0 out nocopy JTF_NUMBER_TABLE
35: , p6_a1 out nocopy JTF_NUMBER_TABLE
36: , p6_a2 out nocopy JTF_NUMBER_TABLE
37: , p6_a3 out nocopy JTF_NUMBER_TABLE
38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , p6_a2 out nocopy JTF_NUMBER_TABLE

32: , p5_a24 JTF_DATE_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p6_a0 out nocopy JTF_NUMBER_TABLE
35: , p6_a1 out nocopy JTF_NUMBER_TABLE
36: , p6_a2 out nocopy JTF_NUMBER_TABLE
37: , p6_a3 out nocopy JTF_NUMBER_TABLE
38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 37: , p6_a3 out nocopy JTF_NUMBER_TABLE

33: , p5_a25 JTF_NUMBER_TABLE
34: , p6_a0 out nocopy JTF_NUMBER_TABLE
35: , p6_a1 out nocopy JTF_NUMBER_TABLE
36: , p6_a2 out nocopy JTF_NUMBER_TABLE
37: , p6_a3 out nocopy JTF_NUMBER_TABLE
38: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
41: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 55: , p6_a21 out nocopy JTF_NUMBER_TABLE

51: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
52: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
53: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
54: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
55: , p6_a21 out nocopy JTF_NUMBER_TABLE
56: , p6_a22 out nocopy JTF_DATE_TABLE
57: , p6_a23 out nocopy JTF_NUMBER_TABLE
58: , p6_a24 out nocopy JTF_DATE_TABLE
59: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 57: , p6_a23 out nocopy JTF_NUMBER_TABLE

53: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
54: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
55: , p6_a21 out nocopy JTF_NUMBER_TABLE
56: , p6_a22 out nocopy JTF_DATE_TABLE
57: , p6_a23 out nocopy JTF_NUMBER_TABLE
58: , p6_a24 out nocopy JTF_DATE_TABLE
59: , p6_a25 out nocopy JTF_NUMBER_TABLE
60: );
61: procedure insert_srch_strm_typs(p_api_version NUMBER

Line 59: , p6_a25 out nocopy JTF_NUMBER_TABLE

55: , p6_a21 out nocopy JTF_NUMBER_TABLE
56: , p6_a22 out nocopy JTF_DATE_TABLE
57: , p6_a23 out nocopy JTF_NUMBER_TABLE
58: , p6_a24 out nocopy JTF_DATE_TABLE
59: , p6_a25 out nocopy JTF_NUMBER_TABLE
60: );
61: procedure insert_srch_strm_typs(p_api_version NUMBER
62: , p_init_msg_list VARCHAR2
63: , x_return_status out nocopy VARCHAR2

Line 124: , p5_a0 JTF_NUMBER_TABLE

120: , p_init_msg_list VARCHAR2
121: , x_return_status out nocopy VARCHAR2
122: , x_msg_count out nocopy NUMBER
123: , x_msg_data out nocopy VARCHAR2
124: , p5_a0 JTF_NUMBER_TABLE
125: , p5_a1 JTF_NUMBER_TABLE
126: , p5_a2 JTF_NUMBER_TABLE
127: , p5_a3 JTF_NUMBER_TABLE
128: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 125: , p5_a1 JTF_NUMBER_TABLE

121: , x_return_status out nocopy VARCHAR2
122: , x_msg_count out nocopy NUMBER
123: , x_msg_data out nocopy VARCHAR2
124: , p5_a0 JTF_NUMBER_TABLE
125: , p5_a1 JTF_NUMBER_TABLE
126: , p5_a2 JTF_NUMBER_TABLE
127: , p5_a3 JTF_NUMBER_TABLE
128: , p5_a4 JTF_VARCHAR2_TABLE_100
129: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 126: , p5_a2 JTF_NUMBER_TABLE

122: , x_msg_count out nocopy NUMBER
123: , x_msg_data out nocopy VARCHAR2
124: , p5_a0 JTF_NUMBER_TABLE
125: , p5_a1 JTF_NUMBER_TABLE
126: , p5_a2 JTF_NUMBER_TABLE
127: , p5_a3 JTF_NUMBER_TABLE
128: , p5_a4 JTF_VARCHAR2_TABLE_100
129: , p5_a5 JTF_VARCHAR2_TABLE_100
130: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 127: , p5_a3 JTF_NUMBER_TABLE

123: , x_msg_data out nocopy VARCHAR2
124: , p5_a0 JTF_NUMBER_TABLE
125: , p5_a1 JTF_NUMBER_TABLE
126: , p5_a2 JTF_NUMBER_TABLE
127: , p5_a3 JTF_NUMBER_TABLE
128: , p5_a4 JTF_VARCHAR2_TABLE_100
129: , p5_a5 JTF_VARCHAR2_TABLE_100
130: , p5_a6 JTF_VARCHAR2_TABLE_500
131: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 145: , p5_a21 JTF_NUMBER_TABLE

141: , p5_a17 JTF_VARCHAR2_TABLE_500
142: , p5_a18 JTF_VARCHAR2_TABLE_500
143: , p5_a19 JTF_VARCHAR2_TABLE_500
144: , p5_a20 JTF_VARCHAR2_TABLE_500
145: , p5_a21 JTF_NUMBER_TABLE
146: , p5_a22 JTF_DATE_TABLE
147: , p5_a23 JTF_NUMBER_TABLE
148: , p5_a24 JTF_DATE_TABLE
149: , p5_a25 JTF_NUMBER_TABLE

Line 147: , p5_a23 JTF_NUMBER_TABLE

143: , p5_a19 JTF_VARCHAR2_TABLE_500
144: , p5_a20 JTF_VARCHAR2_TABLE_500
145: , p5_a21 JTF_NUMBER_TABLE
146: , p5_a22 JTF_DATE_TABLE
147: , p5_a23 JTF_NUMBER_TABLE
148: , p5_a24 JTF_DATE_TABLE
149: , p5_a25 JTF_NUMBER_TABLE
150: );
151: procedure lock_srch_strm_typs(p_api_version NUMBER

Line 149: , p5_a25 JTF_NUMBER_TABLE

145: , p5_a21 JTF_NUMBER_TABLE
146: , p5_a22 JTF_DATE_TABLE
147: , p5_a23 JTF_NUMBER_TABLE
148: , p5_a24 JTF_DATE_TABLE
149: , p5_a25 JTF_NUMBER_TABLE
150: );
151: procedure lock_srch_strm_typs(p_api_version NUMBER
152: , p_init_msg_list VARCHAR2
153: , x_return_status out nocopy VARCHAR2

Line 188: , p5_a0 JTF_NUMBER_TABLE

184: , p_init_msg_list VARCHAR2
185: , x_return_status out nocopy VARCHAR2
186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 189: , p5_a1 JTF_NUMBER_TABLE

185: , x_return_status out nocopy VARCHAR2
186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 190: , p5_a2 JTF_NUMBER_TABLE

186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 191: , p5_a3 JTF_NUMBER_TABLE

187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_VARCHAR2_TABLE_500
195: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 209: , p5_a21 JTF_NUMBER_TABLE

205: , p5_a17 JTF_VARCHAR2_TABLE_500
206: , p5_a18 JTF_VARCHAR2_TABLE_500
207: , p5_a19 JTF_VARCHAR2_TABLE_500
208: , p5_a20 JTF_VARCHAR2_TABLE_500
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_DATE_TABLE
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE

Line 211: , p5_a23 JTF_NUMBER_TABLE

207: , p5_a19 JTF_VARCHAR2_TABLE_500
208: , p5_a20 JTF_VARCHAR2_TABLE_500
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_DATE_TABLE
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p6_a0 out nocopy JTF_NUMBER_TABLE
215: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 213: , p5_a25 JTF_NUMBER_TABLE

209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_DATE_TABLE
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p6_a0 out nocopy JTF_NUMBER_TABLE
215: , p6_a1 out nocopy JTF_NUMBER_TABLE
216: , p6_a2 out nocopy JTF_NUMBER_TABLE
217: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 214: , p6_a0 out nocopy JTF_NUMBER_TABLE

210: , p5_a22 JTF_DATE_TABLE
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p6_a0 out nocopy JTF_NUMBER_TABLE
215: , p6_a1 out nocopy JTF_NUMBER_TABLE
216: , p6_a2 out nocopy JTF_NUMBER_TABLE
217: , p6_a3 out nocopy JTF_NUMBER_TABLE
218: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 215: , p6_a1 out nocopy JTF_NUMBER_TABLE

211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p6_a0 out nocopy JTF_NUMBER_TABLE
215: , p6_a1 out nocopy JTF_NUMBER_TABLE
216: , p6_a2 out nocopy JTF_NUMBER_TABLE
217: , p6_a3 out nocopy JTF_NUMBER_TABLE
218: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
219: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 216: , p6_a2 out nocopy JTF_NUMBER_TABLE

212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p6_a0 out nocopy JTF_NUMBER_TABLE
215: , p6_a1 out nocopy JTF_NUMBER_TABLE
216: , p6_a2 out nocopy JTF_NUMBER_TABLE
217: , p6_a3 out nocopy JTF_NUMBER_TABLE
218: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
219: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
220: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 217: , p6_a3 out nocopy JTF_NUMBER_TABLE

213: , p5_a25 JTF_NUMBER_TABLE
214: , p6_a0 out nocopy JTF_NUMBER_TABLE
215: , p6_a1 out nocopy JTF_NUMBER_TABLE
216: , p6_a2 out nocopy JTF_NUMBER_TABLE
217: , p6_a3 out nocopy JTF_NUMBER_TABLE
218: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
219: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
220: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
221: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 235: , p6_a21 out nocopy JTF_NUMBER_TABLE

231: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
232: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
233: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
234: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
235: , p6_a21 out nocopy JTF_NUMBER_TABLE
236: , p6_a22 out nocopy JTF_DATE_TABLE
237: , p6_a23 out nocopy JTF_NUMBER_TABLE
238: , p6_a24 out nocopy JTF_DATE_TABLE
239: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 237: , p6_a23 out nocopy JTF_NUMBER_TABLE

233: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
234: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
235: , p6_a21 out nocopy JTF_NUMBER_TABLE
236: , p6_a22 out nocopy JTF_DATE_TABLE
237: , p6_a23 out nocopy JTF_NUMBER_TABLE
238: , p6_a24 out nocopy JTF_DATE_TABLE
239: , p6_a25 out nocopy JTF_NUMBER_TABLE
240: );
241: procedure update_srch_strm_typs(p_api_version NUMBER

Line 239: , p6_a25 out nocopy JTF_NUMBER_TABLE

235: , p6_a21 out nocopy JTF_NUMBER_TABLE
236: , p6_a22 out nocopy JTF_DATE_TABLE
237: , p6_a23 out nocopy JTF_NUMBER_TABLE
238: , p6_a24 out nocopy JTF_DATE_TABLE
239: , p6_a25 out nocopy JTF_NUMBER_TABLE
240: );
241: procedure update_srch_strm_typs(p_api_version NUMBER
242: , p_init_msg_list VARCHAR2
243: , x_return_status out nocopy VARCHAR2

Line 304: , p5_a0 JTF_NUMBER_TABLE

300: , p_init_msg_list VARCHAR2
301: , x_return_status out nocopy VARCHAR2
302: , x_msg_count out nocopy NUMBER
303: , x_msg_data out nocopy VARCHAR2
304: , p5_a0 JTF_NUMBER_TABLE
305: , p5_a1 JTF_NUMBER_TABLE
306: , p5_a2 JTF_NUMBER_TABLE
307: , p5_a3 JTF_NUMBER_TABLE
308: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 305: , p5_a1 JTF_NUMBER_TABLE

301: , x_return_status out nocopy VARCHAR2
302: , x_msg_count out nocopy NUMBER
303: , x_msg_data out nocopy VARCHAR2
304: , p5_a0 JTF_NUMBER_TABLE
305: , p5_a1 JTF_NUMBER_TABLE
306: , p5_a2 JTF_NUMBER_TABLE
307: , p5_a3 JTF_NUMBER_TABLE
308: , p5_a4 JTF_VARCHAR2_TABLE_100
309: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 306: , p5_a2 JTF_NUMBER_TABLE

302: , x_msg_count out nocopy NUMBER
303: , x_msg_data out nocopy VARCHAR2
304: , p5_a0 JTF_NUMBER_TABLE
305: , p5_a1 JTF_NUMBER_TABLE
306: , p5_a2 JTF_NUMBER_TABLE
307: , p5_a3 JTF_NUMBER_TABLE
308: , p5_a4 JTF_VARCHAR2_TABLE_100
309: , p5_a5 JTF_VARCHAR2_TABLE_100
310: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 307: , p5_a3 JTF_NUMBER_TABLE

303: , x_msg_data out nocopy VARCHAR2
304: , p5_a0 JTF_NUMBER_TABLE
305: , p5_a1 JTF_NUMBER_TABLE
306: , p5_a2 JTF_NUMBER_TABLE
307: , p5_a3 JTF_NUMBER_TABLE
308: , p5_a4 JTF_VARCHAR2_TABLE_100
309: , p5_a5 JTF_VARCHAR2_TABLE_100
310: , p5_a6 JTF_VARCHAR2_TABLE_500
311: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 325: , p5_a21 JTF_NUMBER_TABLE

321: , p5_a17 JTF_VARCHAR2_TABLE_500
322: , p5_a18 JTF_VARCHAR2_TABLE_500
323: , p5_a19 JTF_VARCHAR2_TABLE_500
324: , p5_a20 JTF_VARCHAR2_TABLE_500
325: , p5_a21 JTF_NUMBER_TABLE
326: , p5_a22 JTF_DATE_TABLE
327: , p5_a23 JTF_NUMBER_TABLE
328: , p5_a24 JTF_DATE_TABLE
329: , p5_a25 JTF_NUMBER_TABLE

Line 327: , p5_a23 JTF_NUMBER_TABLE

323: , p5_a19 JTF_VARCHAR2_TABLE_500
324: , p5_a20 JTF_VARCHAR2_TABLE_500
325: , p5_a21 JTF_NUMBER_TABLE
326: , p5_a22 JTF_DATE_TABLE
327: , p5_a23 JTF_NUMBER_TABLE
328: , p5_a24 JTF_DATE_TABLE
329: , p5_a25 JTF_NUMBER_TABLE
330: );
331: procedure delete_srch_strm_typs(p_api_version NUMBER

Line 329: , p5_a25 JTF_NUMBER_TABLE

325: , p5_a21 JTF_NUMBER_TABLE
326: , p5_a22 JTF_DATE_TABLE
327: , p5_a23 JTF_NUMBER_TABLE
328: , p5_a24 JTF_DATE_TABLE
329: , p5_a25 JTF_NUMBER_TABLE
330: );
331: procedure delete_srch_strm_typs(p_api_version NUMBER
332: , p_init_msg_list VARCHAR2
333: , x_return_status out nocopy VARCHAR2

Line 368: , p5_a0 JTF_NUMBER_TABLE

364: , p_init_msg_list VARCHAR2
365: , x_return_status out nocopy VARCHAR2
366: , x_msg_count out nocopy NUMBER
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_NUMBER_TABLE
371: , p5_a3 JTF_NUMBER_TABLE
372: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 369: , p5_a1 JTF_NUMBER_TABLE

365: , x_return_status out nocopy VARCHAR2
366: , x_msg_count out nocopy NUMBER
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_NUMBER_TABLE
371: , p5_a3 JTF_NUMBER_TABLE
372: , p5_a4 JTF_VARCHAR2_TABLE_100
373: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 370: , p5_a2 JTF_NUMBER_TABLE

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

Line 371: , p5_a3 JTF_NUMBER_TABLE

367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_NUMBER_TABLE
371: , p5_a3 JTF_NUMBER_TABLE
372: , p5_a4 JTF_VARCHAR2_TABLE_100
373: , p5_a5 JTF_VARCHAR2_TABLE_100
374: , p5_a6 JTF_VARCHAR2_TABLE_500
375: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 389: , p5_a21 JTF_NUMBER_TABLE

385: , p5_a17 JTF_VARCHAR2_TABLE_500
386: , p5_a18 JTF_VARCHAR2_TABLE_500
387: , p5_a19 JTF_VARCHAR2_TABLE_500
388: , p5_a20 JTF_VARCHAR2_TABLE_500
389: , p5_a21 JTF_NUMBER_TABLE
390: , p5_a22 JTF_DATE_TABLE
391: , p5_a23 JTF_NUMBER_TABLE
392: , p5_a24 JTF_DATE_TABLE
393: , p5_a25 JTF_NUMBER_TABLE

Line 391: , p5_a23 JTF_NUMBER_TABLE

387: , p5_a19 JTF_VARCHAR2_TABLE_500
388: , p5_a20 JTF_VARCHAR2_TABLE_500
389: , p5_a21 JTF_NUMBER_TABLE
390: , p5_a22 JTF_DATE_TABLE
391: , p5_a23 JTF_NUMBER_TABLE
392: , p5_a24 JTF_DATE_TABLE
393: , p5_a25 JTF_NUMBER_TABLE
394: );
395: procedure validate_srch_strm_typs(p_api_version NUMBER

Line 393: , p5_a25 JTF_NUMBER_TABLE

389: , p5_a21 JTF_NUMBER_TABLE
390: , p5_a22 JTF_DATE_TABLE
391: , p5_a23 JTF_NUMBER_TABLE
392: , p5_a24 JTF_DATE_TABLE
393: , p5_a25 JTF_NUMBER_TABLE
394: );
395: procedure validate_srch_strm_typs(p_api_version NUMBER
396: , p_init_msg_list VARCHAR2
397: , x_return_status out nocopy VARCHAR2