DBA Data[Home] [Help]

APPS.OKL_SERVICE_FEES_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_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_VARCHAR2_TABLE_200

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_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_VARCHAR2_TABLE_200
13: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 14: , p5_a6 JTF_NUMBER_TABLE

10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_VARCHAR2_TABLE_200
13: , p5_a5 JTF_VARCHAR2_TABLE_2000
14: , p5_a6 JTF_NUMBER_TABLE
15: , p5_a7 JTF_DATE_TABLE
16: , p5_a8 JTF_DATE_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 17: , p5_a9 JTF_NUMBER_TABLE

13: , p5_a5 JTF_VARCHAR2_TABLE_2000
14: , p5_a6 JTF_NUMBER_TABLE
15: , p5_a7 JTF_DATE_TABLE
16: , p5_a8 JTF_DATE_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100
19: , p5_a11 JTF_VARCHAR2_TABLE_500
20: , p5_a12 JTF_VARCHAR2_TABLE_500
21: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 34: , p5_a26 JTF_NUMBER_TABLE

30: , p5_a22 JTF_VARCHAR2_TABLE_500
31: , p5_a23 JTF_VARCHAR2_TABLE_500
32: , p5_a24 JTF_VARCHAR2_TABLE_500
33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE

Line 36: , p5_a28 JTF_NUMBER_TABLE

32: , p5_a24 JTF_VARCHAR2_TABLE_500
33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p6_a0 out nocopy JTF_NUMBER_TABLE
40: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 38: , p5_a30 JTF_NUMBER_TABLE

34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p6_a0 out nocopy JTF_NUMBER_TABLE
40: , p6_a1 out nocopy JTF_NUMBER_TABLE
41: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , p6_a0 out nocopy JTF_NUMBER_TABLE

35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p6_a0 out nocopy JTF_NUMBER_TABLE
40: , p6_a1 out nocopy JTF_NUMBER_TABLE
41: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 40: , p6_a1 out nocopy JTF_NUMBER_TABLE

36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p6_a0 out nocopy JTF_NUMBER_TABLE
40: , p6_a1 out nocopy JTF_NUMBER_TABLE
41: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
44: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 45: , p6_a6 out nocopy JTF_NUMBER_TABLE

41: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
44: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
45: , p6_a6 out nocopy JTF_NUMBER_TABLE
46: , p6_a7 out nocopy JTF_DATE_TABLE
47: , p6_a8 out nocopy JTF_DATE_TABLE
48: , p6_a9 out nocopy JTF_NUMBER_TABLE
49: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: , p6_a9 out nocopy JTF_NUMBER_TABLE

44: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
45: , p6_a6 out nocopy JTF_NUMBER_TABLE
46: , p6_a7 out nocopy JTF_DATE_TABLE
47: , p6_a8 out nocopy JTF_DATE_TABLE
48: , p6_a9 out nocopy JTF_NUMBER_TABLE
49: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
50: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
51: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
52: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 65: , p6_a26 out nocopy JTF_NUMBER_TABLE

61: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
62: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
63: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
64: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
65: , p6_a26 out nocopy JTF_NUMBER_TABLE
66: , p6_a27 out nocopy JTF_DATE_TABLE
67: , p6_a28 out nocopy JTF_NUMBER_TABLE
68: , p6_a29 out nocopy JTF_DATE_TABLE
69: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 67: , p6_a28 out nocopy JTF_NUMBER_TABLE

63: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
64: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
65: , p6_a26 out nocopy JTF_NUMBER_TABLE
66: , p6_a27 out nocopy JTF_DATE_TABLE
67: , p6_a28 out nocopy JTF_NUMBER_TABLE
68: , p6_a29 out nocopy JTF_DATE_TABLE
69: , p6_a30 out nocopy JTF_NUMBER_TABLE
70: );
71: procedure insert_service_fees(p_api_version NUMBER

Line 69: , p6_a30 out nocopy JTF_NUMBER_TABLE

65: , p6_a26 out nocopy JTF_NUMBER_TABLE
66: , p6_a27 out nocopy JTF_DATE_TABLE
67: , p6_a28 out nocopy JTF_NUMBER_TABLE
68: , p6_a29 out nocopy JTF_DATE_TABLE
69: , p6_a30 out nocopy JTF_NUMBER_TABLE
70: );
71: procedure insert_service_fees(p_api_version NUMBER
72: , p_init_msg_list VARCHAR2
73: , x_return_status out nocopy VARCHAR2

Line 144: , p5_a0 JTF_NUMBER_TABLE

140: , p_init_msg_list VARCHAR2
141: , x_return_status out nocopy VARCHAR2
142: , x_msg_count out nocopy NUMBER
143: , x_msg_data out nocopy VARCHAR2
144: , p5_a0 JTF_NUMBER_TABLE
145: , p5_a1 JTF_NUMBER_TABLE
146: , p5_a2 JTF_VARCHAR2_TABLE_100
147: , p5_a3 JTF_VARCHAR2_TABLE_100
148: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 145: , p5_a1 JTF_NUMBER_TABLE

141: , x_return_status out nocopy VARCHAR2
142: , x_msg_count out nocopy NUMBER
143: , x_msg_data out nocopy VARCHAR2
144: , p5_a0 JTF_NUMBER_TABLE
145: , p5_a1 JTF_NUMBER_TABLE
146: , p5_a2 JTF_VARCHAR2_TABLE_100
147: , p5_a3 JTF_VARCHAR2_TABLE_100
148: , p5_a4 JTF_VARCHAR2_TABLE_200
149: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 150: , p5_a6 JTF_NUMBER_TABLE

146: , p5_a2 JTF_VARCHAR2_TABLE_100
147: , p5_a3 JTF_VARCHAR2_TABLE_100
148: , p5_a4 JTF_VARCHAR2_TABLE_200
149: , p5_a5 JTF_VARCHAR2_TABLE_2000
150: , p5_a6 JTF_NUMBER_TABLE
151: , p5_a7 JTF_DATE_TABLE
152: , p5_a8 JTF_DATE_TABLE
153: , p5_a9 JTF_NUMBER_TABLE
154: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 153: , p5_a9 JTF_NUMBER_TABLE

149: , p5_a5 JTF_VARCHAR2_TABLE_2000
150: , p5_a6 JTF_NUMBER_TABLE
151: , p5_a7 JTF_DATE_TABLE
152: , p5_a8 JTF_DATE_TABLE
153: , p5_a9 JTF_NUMBER_TABLE
154: , p5_a10 JTF_VARCHAR2_TABLE_100
155: , p5_a11 JTF_VARCHAR2_TABLE_500
156: , p5_a12 JTF_VARCHAR2_TABLE_500
157: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 170: , p5_a26 JTF_NUMBER_TABLE

166: , p5_a22 JTF_VARCHAR2_TABLE_500
167: , p5_a23 JTF_VARCHAR2_TABLE_500
168: , p5_a24 JTF_VARCHAR2_TABLE_500
169: , p5_a25 JTF_VARCHAR2_TABLE_500
170: , p5_a26 JTF_NUMBER_TABLE
171: , p5_a27 JTF_DATE_TABLE
172: , p5_a28 JTF_NUMBER_TABLE
173: , p5_a29 JTF_DATE_TABLE
174: , p5_a30 JTF_NUMBER_TABLE

Line 172: , p5_a28 JTF_NUMBER_TABLE

168: , p5_a24 JTF_VARCHAR2_TABLE_500
169: , p5_a25 JTF_VARCHAR2_TABLE_500
170: , p5_a26 JTF_NUMBER_TABLE
171: , p5_a27 JTF_DATE_TABLE
172: , p5_a28 JTF_NUMBER_TABLE
173: , p5_a29 JTF_DATE_TABLE
174: , p5_a30 JTF_NUMBER_TABLE
175: );
176: procedure lock_service_fees(p_api_version NUMBER

Line 174: , p5_a30 JTF_NUMBER_TABLE

170: , p5_a26 JTF_NUMBER_TABLE
171: , p5_a27 JTF_DATE_TABLE
172: , p5_a28 JTF_NUMBER_TABLE
173: , p5_a29 JTF_DATE_TABLE
174: , p5_a30 JTF_NUMBER_TABLE
175: );
176: procedure lock_service_fees(p_api_version NUMBER
177: , p_init_msg_list VARCHAR2
178: , x_return_status out nocopy VARCHAR2

Line 218: , p5_a0 JTF_NUMBER_TABLE

214: , p_init_msg_list VARCHAR2
215: , x_return_status out nocopy VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_VARCHAR2_TABLE_100
221: , p5_a3 JTF_VARCHAR2_TABLE_100
222: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 219: , p5_a1 JTF_NUMBER_TABLE

215: , x_return_status out nocopy VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_VARCHAR2_TABLE_100
221: , p5_a3 JTF_VARCHAR2_TABLE_100
222: , p5_a4 JTF_VARCHAR2_TABLE_200
223: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 224: , p5_a6 JTF_NUMBER_TABLE

220: , p5_a2 JTF_VARCHAR2_TABLE_100
221: , p5_a3 JTF_VARCHAR2_TABLE_100
222: , p5_a4 JTF_VARCHAR2_TABLE_200
223: , p5_a5 JTF_VARCHAR2_TABLE_2000
224: , p5_a6 JTF_NUMBER_TABLE
225: , p5_a7 JTF_DATE_TABLE
226: , p5_a8 JTF_DATE_TABLE
227: , p5_a9 JTF_NUMBER_TABLE
228: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 227: , p5_a9 JTF_NUMBER_TABLE

223: , p5_a5 JTF_VARCHAR2_TABLE_2000
224: , p5_a6 JTF_NUMBER_TABLE
225: , p5_a7 JTF_DATE_TABLE
226: , p5_a8 JTF_DATE_TABLE
227: , p5_a9 JTF_NUMBER_TABLE
228: , p5_a10 JTF_VARCHAR2_TABLE_100
229: , p5_a11 JTF_VARCHAR2_TABLE_500
230: , p5_a12 JTF_VARCHAR2_TABLE_500
231: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 244: , p5_a26 JTF_NUMBER_TABLE

240: , p5_a22 JTF_VARCHAR2_TABLE_500
241: , p5_a23 JTF_VARCHAR2_TABLE_500
242: , p5_a24 JTF_VARCHAR2_TABLE_500
243: , p5_a25 JTF_VARCHAR2_TABLE_500
244: , p5_a26 JTF_NUMBER_TABLE
245: , p5_a27 JTF_DATE_TABLE
246: , p5_a28 JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE

Line 246: , p5_a28 JTF_NUMBER_TABLE

242: , p5_a24 JTF_VARCHAR2_TABLE_500
243: , p5_a25 JTF_VARCHAR2_TABLE_500
244: , p5_a26 JTF_NUMBER_TABLE
245: , p5_a27 JTF_DATE_TABLE
246: , p5_a28 JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 248: , p5_a30 JTF_NUMBER_TABLE

244: , p5_a26 JTF_NUMBER_TABLE
245: , p5_a27 JTF_DATE_TABLE
246: , p5_a28 JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 249: , p6_a0 out nocopy JTF_NUMBER_TABLE

245: , p5_a27 JTF_DATE_TABLE
246: , p5_a28 JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 250: , p6_a1 out nocopy JTF_NUMBER_TABLE

246: , p5_a28 JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 255: , p6_a6 out nocopy JTF_NUMBER_TABLE

251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
255: , p6_a6 out nocopy JTF_NUMBER_TABLE
256: , p6_a7 out nocopy JTF_DATE_TABLE
257: , p6_a8 out nocopy JTF_DATE_TABLE
258: , p6_a9 out nocopy JTF_NUMBER_TABLE
259: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 258: , p6_a9 out nocopy JTF_NUMBER_TABLE

254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
255: , p6_a6 out nocopy JTF_NUMBER_TABLE
256: , p6_a7 out nocopy JTF_DATE_TABLE
257: , p6_a8 out nocopy JTF_DATE_TABLE
258: , p6_a9 out nocopy JTF_NUMBER_TABLE
259: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
261: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
262: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 275: , p6_a26 out nocopy JTF_NUMBER_TABLE

271: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
272: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
273: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
275: , p6_a26 out nocopy JTF_NUMBER_TABLE
276: , p6_a27 out nocopy JTF_DATE_TABLE
277: , p6_a28 out nocopy JTF_NUMBER_TABLE
278: , p6_a29 out nocopy JTF_DATE_TABLE
279: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 277: , p6_a28 out nocopy JTF_NUMBER_TABLE

273: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
275: , p6_a26 out nocopy JTF_NUMBER_TABLE
276: , p6_a27 out nocopy JTF_DATE_TABLE
277: , p6_a28 out nocopy JTF_NUMBER_TABLE
278: , p6_a29 out nocopy JTF_DATE_TABLE
279: , p6_a30 out nocopy JTF_NUMBER_TABLE
280: );
281: procedure update_service_fees(p_api_version NUMBER

Line 279: , p6_a30 out nocopy JTF_NUMBER_TABLE

275: , p6_a26 out nocopy JTF_NUMBER_TABLE
276: , p6_a27 out nocopy JTF_DATE_TABLE
277: , p6_a28 out nocopy JTF_NUMBER_TABLE
278: , p6_a29 out nocopy JTF_DATE_TABLE
279: , p6_a30 out nocopy JTF_NUMBER_TABLE
280: );
281: procedure update_service_fees(p_api_version NUMBER
282: , p_init_msg_list VARCHAR2
283: , x_return_status out nocopy VARCHAR2

Line 354: , p5_a0 JTF_NUMBER_TABLE

350: , p_init_msg_list VARCHAR2
351: , x_return_status out nocopy VARCHAR2
352: , x_msg_count out nocopy NUMBER
353: , x_msg_data out nocopy VARCHAR2
354: , p5_a0 JTF_NUMBER_TABLE
355: , p5_a1 JTF_NUMBER_TABLE
356: , p5_a2 JTF_VARCHAR2_TABLE_100
357: , p5_a3 JTF_VARCHAR2_TABLE_100
358: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 355: , p5_a1 JTF_NUMBER_TABLE

351: , x_return_status out nocopy VARCHAR2
352: , x_msg_count out nocopy NUMBER
353: , x_msg_data out nocopy VARCHAR2
354: , p5_a0 JTF_NUMBER_TABLE
355: , p5_a1 JTF_NUMBER_TABLE
356: , p5_a2 JTF_VARCHAR2_TABLE_100
357: , p5_a3 JTF_VARCHAR2_TABLE_100
358: , p5_a4 JTF_VARCHAR2_TABLE_200
359: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 360: , p5_a6 JTF_NUMBER_TABLE

356: , p5_a2 JTF_VARCHAR2_TABLE_100
357: , p5_a3 JTF_VARCHAR2_TABLE_100
358: , p5_a4 JTF_VARCHAR2_TABLE_200
359: , p5_a5 JTF_VARCHAR2_TABLE_2000
360: , p5_a6 JTF_NUMBER_TABLE
361: , p5_a7 JTF_DATE_TABLE
362: , p5_a8 JTF_DATE_TABLE
363: , p5_a9 JTF_NUMBER_TABLE
364: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 363: , p5_a9 JTF_NUMBER_TABLE

359: , p5_a5 JTF_VARCHAR2_TABLE_2000
360: , p5_a6 JTF_NUMBER_TABLE
361: , p5_a7 JTF_DATE_TABLE
362: , p5_a8 JTF_DATE_TABLE
363: , p5_a9 JTF_NUMBER_TABLE
364: , p5_a10 JTF_VARCHAR2_TABLE_100
365: , p5_a11 JTF_VARCHAR2_TABLE_500
366: , p5_a12 JTF_VARCHAR2_TABLE_500
367: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 380: , p5_a26 JTF_NUMBER_TABLE

376: , p5_a22 JTF_VARCHAR2_TABLE_500
377: , p5_a23 JTF_VARCHAR2_TABLE_500
378: , p5_a24 JTF_VARCHAR2_TABLE_500
379: , p5_a25 JTF_VARCHAR2_TABLE_500
380: , p5_a26 JTF_NUMBER_TABLE
381: , p5_a27 JTF_DATE_TABLE
382: , p5_a28 JTF_NUMBER_TABLE
383: , p5_a29 JTF_DATE_TABLE
384: , p5_a30 JTF_NUMBER_TABLE

Line 382: , p5_a28 JTF_NUMBER_TABLE

378: , p5_a24 JTF_VARCHAR2_TABLE_500
379: , p5_a25 JTF_VARCHAR2_TABLE_500
380: , p5_a26 JTF_NUMBER_TABLE
381: , p5_a27 JTF_DATE_TABLE
382: , p5_a28 JTF_NUMBER_TABLE
383: , p5_a29 JTF_DATE_TABLE
384: , p5_a30 JTF_NUMBER_TABLE
385: );
386: procedure delete_service_fees(p_api_version NUMBER

Line 384: , p5_a30 JTF_NUMBER_TABLE

380: , p5_a26 JTF_NUMBER_TABLE
381: , p5_a27 JTF_DATE_TABLE
382: , p5_a28 JTF_NUMBER_TABLE
383: , p5_a29 JTF_DATE_TABLE
384: , p5_a30 JTF_NUMBER_TABLE
385: );
386: procedure delete_service_fees(p_api_version NUMBER
387: , p_init_msg_list VARCHAR2
388: , x_return_status out nocopy VARCHAR2

Line 428: , p5_a0 JTF_NUMBER_TABLE

424: , p_init_msg_list VARCHAR2
425: , x_return_status out nocopy VARCHAR2
426: , x_msg_count out nocopy NUMBER
427: , x_msg_data out nocopy VARCHAR2
428: , p5_a0 JTF_NUMBER_TABLE
429: , p5_a1 JTF_NUMBER_TABLE
430: , p5_a2 JTF_VARCHAR2_TABLE_100
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 429: , p5_a1 JTF_NUMBER_TABLE

425: , x_return_status out nocopy VARCHAR2
426: , x_msg_count out nocopy NUMBER
427: , x_msg_data out nocopy VARCHAR2
428: , p5_a0 JTF_NUMBER_TABLE
429: , p5_a1 JTF_NUMBER_TABLE
430: , p5_a2 JTF_VARCHAR2_TABLE_100
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_VARCHAR2_TABLE_200
433: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 434: , p5_a6 JTF_NUMBER_TABLE

430: , p5_a2 JTF_VARCHAR2_TABLE_100
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_VARCHAR2_TABLE_200
433: , p5_a5 JTF_VARCHAR2_TABLE_2000
434: , p5_a6 JTF_NUMBER_TABLE
435: , p5_a7 JTF_DATE_TABLE
436: , p5_a8 JTF_DATE_TABLE
437: , p5_a9 JTF_NUMBER_TABLE
438: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 437: , p5_a9 JTF_NUMBER_TABLE

433: , p5_a5 JTF_VARCHAR2_TABLE_2000
434: , p5_a6 JTF_NUMBER_TABLE
435: , p5_a7 JTF_DATE_TABLE
436: , p5_a8 JTF_DATE_TABLE
437: , p5_a9 JTF_NUMBER_TABLE
438: , p5_a10 JTF_VARCHAR2_TABLE_100
439: , p5_a11 JTF_VARCHAR2_TABLE_500
440: , p5_a12 JTF_VARCHAR2_TABLE_500
441: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 454: , p5_a26 JTF_NUMBER_TABLE

450: , p5_a22 JTF_VARCHAR2_TABLE_500
451: , p5_a23 JTF_VARCHAR2_TABLE_500
452: , p5_a24 JTF_VARCHAR2_TABLE_500
453: , p5_a25 JTF_VARCHAR2_TABLE_500
454: , p5_a26 JTF_NUMBER_TABLE
455: , p5_a27 JTF_DATE_TABLE
456: , p5_a28 JTF_NUMBER_TABLE
457: , p5_a29 JTF_DATE_TABLE
458: , p5_a30 JTF_NUMBER_TABLE

Line 456: , p5_a28 JTF_NUMBER_TABLE

452: , p5_a24 JTF_VARCHAR2_TABLE_500
453: , p5_a25 JTF_VARCHAR2_TABLE_500
454: , p5_a26 JTF_NUMBER_TABLE
455: , p5_a27 JTF_DATE_TABLE
456: , p5_a28 JTF_NUMBER_TABLE
457: , p5_a29 JTF_DATE_TABLE
458: , p5_a30 JTF_NUMBER_TABLE
459: );
460: procedure validate_service_fees(p_api_version NUMBER

Line 458: , p5_a30 JTF_NUMBER_TABLE

454: , p5_a26 JTF_NUMBER_TABLE
455: , p5_a27 JTF_DATE_TABLE
456: , p5_a28 JTF_NUMBER_TABLE
457: , p5_a29 JTF_DATE_TABLE
458: , p5_a30 JTF_NUMBER_TABLE
459: );
460: procedure validate_service_fees(p_api_version NUMBER
461: , p_init_msg_list VARCHAR2
462: , x_return_status out nocopy VARCHAR2