23: , p_init_msg_list VARCHAR2
24: , x_return_status out nocopy VARCHAR2
25: , x_msg_count out nocopy NUMBER
26: , x_msg_data out nocopy VARCHAR2
27: , p5_a0 JTF_NUMBER_TABLE
28: , p5_a1 JTF_NUMBER_TABLE
29: , p5_a2 JTF_VARCHAR2_TABLE_100
30: , p5_a3 JTF_VARCHAR2_TABLE_200
31: , p5_a4 JTF_VARCHAR2_TABLE_100
24: , x_return_status out nocopy VARCHAR2
25: , x_msg_count out nocopy NUMBER
26: , x_msg_data out nocopy VARCHAR2
27: , p5_a0 JTF_NUMBER_TABLE
28: , p5_a1 JTF_NUMBER_TABLE
29: , p5_a2 JTF_VARCHAR2_TABLE_100
30: , p5_a3 JTF_VARCHAR2_TABLE_200
31: , p5_a4 JTF_VARCHAR2_TABLE_100
32: , p5_a5 JTF_DATE_TABLE
30: , p5_a3 JTF_VARCHAR2_TABLE_200
31: , p5_a4 JTF_VARCHAR2_TABLE_100
32: , p5_a5 JTF_DATE_TABLE
33: , p5_a6 JTF_VARCHAR2_TABLE_100
34: , p5_a7 JTF_NUMBER_TABLE
35: , p5_a8 JTF_NUMBER_TABLE
36: , p5_a9 JTF_DATE_TABLE
37: , p5_a10 JTF_VARCHAR2_TABLE_100
38: , p5_a11 JTF_VARCHAR2_TABLE_500
31: , p5_a4 JTF_VARCHAR2_TABLE_100
32: , p5_a5 JTF_DATE_TABLE
33: , p5_a6 JTF_VARCHAR2_TABLE_100
34: , p5_a7 JTF_NUMBER_TABLE
35: , p5_a8 JTF_NUMBER_TABLE
36: , p5_a9 JTF_DATE_TABLE
37: , p5_a10 JTF_VARCHAR2_TABLE_100
38: , p5_a11 JTF_VARCHAR2_TABLE_500
39: , p5_a12 JTF_VARCHAR2_TABLE_500
49: , p5_a22 JTF_VARCHAR2_TABLE_500
50: , p5_a23 JTF_VARCHAR2_TABLE_500
51: , p5_a24 JTF_VARCHAR2_TABLE_500
52: , p5_a25 JTF_VARCHAR2_TABLE_500
53: , p5_a26 JTF_NUMBER_TABLE
54: , p5_a27 JTF_DATE_TABLE
55: , p5_a28 JTF_NUMBER_TABLE
56: , p5_a29 JTF_DATE_TABLE
57: , p5_a30 JTF_NUMBER_TABLE
51: , p5_a24 JTF_VARCHAR2_TABLE_500
52: , p5_a25 JTF_VARCHAR2_TABLE_500
53: , p5_a26 JTF_NUMBER_TABLE
54: , p5_a27 JTF_DATE_TABLE
55: , p5_a28 JTF_NUMBER_TABLE
56: , p5_a29 JTF_DATE_TABLE
57: , p5_a30 JTF_NUMBER_TABLE
58: , p6_a0 out nocopy JTF_NUMBER_TABLE
59: , p6_a1 out nocopy JTF_NUMBER_TABLE
53: , p5_a26 JTF_NUMBER_TABLE
54: , p5_a27 JTF_DATE_TABLE
55: , p5_a28 JTF_NUMBER_TABLE
56: , p5_a29 JTF_DATE_TABLE
57: , p5_a30 JTF_NUMBER_TABLE
58: , p6_a0 out nocopy JTF_NUMBER_TABLE
59: , p6_a1 out nocopy JTF_NUMBER_TABLE
60: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
54: , p5_a27 JTF_DATE_TABLE
55: , p5_a28 JTF_NUMBER_TABLE
56: , p5_a29 JTF_DATE_TABLE
57: , p5_a30 JTF_NUMBER_TABLE
58: , p6_a0 out nocopy JTF_NUMBER_TABLE
59: , p6_a1 out nocopy JTF_NUMBER_TABLE
60: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
62: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , p5_a28 JTF_NUMBER_TABLE
56: , p5_a29 JTF_DATE_TABLE
57: , p5_a30 JTF_NUMBER_TABLE
58: , p6_a0 out nocopy JTF_NUMBER_TABLE
59: , p6_a1 out nocopy JTF_NUMBER_TABLE
60: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
62: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
63: , p6_a5 out nocopy JTF_DATE_TABLE
61: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
62: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
63: , p6_a5 out nocopy JTF_DATE_TABLE
64: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
65: , p6_a7 out nocopy JTF_NUMBER_TABLE
66: , p6_a8 out nocopy JTF_NUMBER_TABLE
67: , p6_a9 out nocopy JTF_DATE_TABLE
68: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
62: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
63: , p6_a5 out nocopy JTF_DATE_TABLE
64: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
65: , p6_a7 out nocopy JTF_NUMBER_TABLE
66: , p6_a8 out nocopy JTF_NUMBER_TABLE
67: , p6_a9 out nocopy JTF_DATE_TABLE
68: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
70: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
80: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
81: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
82: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
83: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
84: , p6_a26 out nocopy JTF_NUMBER_TABLE
85: , p6_a27 out nocopy JTF_DATE_TABLE
86: , p6_a28 out nocopy JTF_NUMBER_TABLE
87: , p6_a29 out nocopy JTF_DATE_TABLE
88: , p6_a30 out nocopy JTF_NUMBER_TABLE
82: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
83: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
84: , p6_a26 out nocopy JTF_NUMBER_TABLE
85: , p6_a27 out nocopy JTF_DATE_TABLE
86: , p6_a28 out nocopy JTF_NUMBER_TABLE
87: , p6_a29 out nocopy JTF_DATE_TABLE
88: , p6_a30 out nocopy JTF_NUMBER_TABLE
89: )
90:
84: , p6_a26 out nocopy JTF_NUMBER_TABLE
85: , p6_a27 out nocopy JTF_DATE_TABLE
86: , p6_a28 out nocopy JTF_NUMBER_TABLE
87: , p6_a29 out nocopy JTF_DATE_TABLE
88: , p6_a30 out nocopy JTF_NUMBER_TABLE
89: )
90:
91: as
92: ddp_budget_line_tbl okl_subsidy_pool_budget_pvt.budget_line_tbl;
188: , p_init_msg_list VARCHAR2
189: , x_return_status out nocopy VARCHAR2
190: , x_msg_count out nocopy NUMBER
191: , x_msg_data out nocopy VARCHAR2
192: , p5_a0 JTF_NUMBER_TABLE
193: , p5_a1 JTF_NUMBER_TABLE
194: , p5_a2 JTF_VARCHAR2_TABLE_100
195: , p5_a3 JTF_VARCHAR2_TABLE_200
196: , p5_a4 JTF_VARCHAR2_TABLE_100
189: , x_return_status out nocopy VARCHAR2
190: , x_msg_count out nocopy NUMBER
191: , x_msg_data out nocopy VARCHAR2
192: , p5_a0 JTF_NUMBER_TABLE
193: , p5_a1 JTF_NUMBER_TABLE
194: , p5_a2 JTF_VARCHAR2_TABLE_100
195: , p5_a3 JTF_VARCHAR2_TABLE_200
196: , p5_a4 JTF_VARCHAR2_TABLE_100
197: , p5_a5 JTF_DATE_TABLE
195: , p5_a3 JTF_VARCHAR2_TABLE_200
196: , p5_a4 JTF_VARCHAR2_TABLE_100
197: , p5_a5 JTF_DATE_TABLE
198: , p5_a6 JTF_VARCHAR2_TABLE_100
199: , p5_a7 JTF_NUMBER_TABLE
200: , p5_a8 JTF_NUMBER_TABLE
201: , p5_a9 JTF_DATE_TABLE
202: , p5_a10 JTF_VARCHAR2_TABLE_100
203: , p5_a11 JTF_VARCHAR2_TABLE_500
196: , p5_a4 JTF_VARCHAR2_TABLE_100
197: , p5_a5 JTF_DATE_TABLE
198: , p5_a6 JTF_VARCHAR2_TABLE_100
199: , p5_a7 JTF_NUMBER_TABLE
200: , p5_a8 JTF_NUMBER_TABLE
201: , p5_a9 JTF_DATE_TABLE
202: , p5_a10 JTF_VARCHAR2_TABLE_100
203: , p5_a11 JTF_VARCHAR2_TABLE_500
204: , p5_a12 JTF_VARCHAR2_TABLE_500
214: , p5_a22 JTF_VARCHAR2_TABLE_500
215: , p5_a23 JTF_VARCHAR2_TABLE_500
216: , p5_a24 JTF_VARCHAR2_TABLE_500
217: , p5_a25 JTF_VARCHAR2_TABLE_500
218: , p5_a26 JTF_NUMBER_TABLE
219: , p5_a27 JTF_DATE_TABLE
220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_DATE_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
216: , p5_a24 JTF_VARCHAR2_TABLE_500
217: , p5_a25 JTF_VARCHAR2_TABLE_500
218: , p5_a26 JTF_NUMBER_TABLE
219: , p5_a27 JTF_DATE_TABLE
220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_DATE_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p5_a26 JTF_NUMBER_TABLE
219: , p5_a27 JTF_DATE_TABLE
220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_DATE_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
219: , p5_a27 JTF_DATE_TABLE
220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_DATE_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
220: , p5_a28 JTF_NUMBER_TABLE
221: , p5_a29 JTF_DATE_TABLE
222: , p5_a30 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a5 out nocopy JTF_DATE_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , p6_a7 out nocopy JTF_NUMBER_TABLE
231: , p6_a8 out nocopy JTF_NUMBER_TABLE
232: , p6_a9 out nocopy JTF_DATE_TABLE
233: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
234: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , p6_a7 out nocopy JTF_NUMBER_TABLE
231: , p6_a8 out nocopy JTF_NUMBER_TABLE
232: , p6_a9 out nocopy JTF_DATE_TABLE
233: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
234: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
235: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
247: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
248: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: , p6_a29 out nocopy JTF_DATE_TABLE
253: , p6_a30 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
248: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: , p6_a29 out nocopy JTF_DATE_TABLE
253: , p6_a30 out nocopy JTF_NUMBER_TABLE
254: )
255:
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: , p6_a29 out nocopy JTF_DATE_TABLE
253: , p6_a30 out nocopy JTF_NUMBER_TABLE
254: )
255:
256: as
257: ddp_budget_line_tbl okl_subsidy_pool_budget_pvt.budget_line_tbl;
353: , p_init_msg_list VARCHAR2
354: , x_return_status out nocopy VARCHAR2
355: , x_msg_count out nocopy NUMBER
356: , x_msg_data out nocopy VARCHAR2
357: , p5_a0 JTF_NUMBER_TABLE
358: , p5_a1 JTF_NUMBER_TABLE
359: , p5_a2 JTF_VARCHAR2_TABLE_100
360: , p5_a3 JTF_VARCHAR2_TABLE_200
361: , p5_a4 JTF_VARCHAR2_TABLE_100
354: , x_return_status out nocopy VARCHAR2
355: , x_msg_count out nocopy NUMBER
356: , x_msg_data out nocopy VARCHAR2
357: , p5_a0 JTF_NUMBER_TABLE
358: , p5_a1 JTF_NUMBER_TABLE
359: , p5_a2 JTF_VARCHAR2_TABLE_100
360: , p5_a3 JTF_VARCHAR2_TABLE_200
361: , p5_a4 JTF_VARCHAR2_TABLE_100
362: , p5_a5 JTF_DATE_TABLE
360: , p5_a3 JTF_VARCHAR2_TABLE_200
361: , p5_a4 JTF_VARCHAR2_TABLE_100
362: , p5_a5 JTF_DATE_TABLE
363: , p5_a6 JTF_VARCHAR2_TABLE_100
364: , p5_a7 JTF_NUMBER_TABLE
365: , p5_a8 JTF_NUMBER_TABLE
366: , p5_a9 JTF_DATE_TABLE
367: , p5_a10 JTF_VARCHAR2_TABLE_100
368: , p5_a11 JTF_VARCHAR2_TABLE_500
361: , p5_a4 JTF_VARCHAR2_TABLE_100
362: , p5_a5 JTF_DATE_TABLE
363: , p5_a6 JTF_VARCHAR2_TABLE_100
364: , p5_a7 JTF_NUMBER_TABLE
365: , p5_a8 JTF_NUMBER_TABLE
366: , p5_a9 JTF_DATE_TABLE
367: , p5_a10 JTF_VARCHAR2_TABLE_100
368: , p5_a11 JTF_VARCHAR2_TABLE_500
369: , p5_a12 JTF_VARCHAR2_TABLE_500
379: , p5_a22 JTF_VARCHAR2_TABLE_500
380: , p5_a23 JTF_VARCHAR2_TABLE_500
381: , p5_a24 JTF_VARCHAR2_TABLE_500
382: , p5_a25 JTF_VARCHAR2_TABLE_500
383: , p5_a26 JTF_NUMBER_TABLE
384: , p5_a27 JTF_DATE_TABLE
385: , p5_a28 JTF_NUMBER_TABLE
386: , p5_a29 JTF_DATE_TABLE
387: , p5_a30 JTF_NUMBER_TABLE
381: , p5_a24 JTF_VARCHAR2_TABLE_500
382: , p5_a25 JTF_VARCHAR2_TABLE_500
383: , p5_a26 JTF_NUMBER_TABLE
384: , p5_a27 JTF_DATE_TABLE
385: , p5_a28 JTF_NUMBER_TABLE
386: , p5_a29 JTF_DATE_TABLE
387: , p5_a30 JTF_NUMBER_TABLE
388: )
389:
383: , p5_a26 JTF_NUMBER_TABLE
384: , p5_a27 JTF_DATE_TABLE
385: , p5_a28 JTF_NUMBER_TABLE
386: , p5_a29 JTF_DATE_TABLE
387: , p5_a30 JTF_NUMBER_TABLE
388: )
389:
390: as
391: ddp_budget_line_tbl okl_subsidy_pool_budget_pvt.budget_line_tbl;