1: package okl_pay_cure_refunds_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEPCRS.pls 115.5 2003/04/25 03:50:27 nmakhani noship $ */
3: procedure rosetta_table_copy_in_p8(t out nocopy okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 JTF_VARCHAR2_TABLE_200
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package okl_pay_cure_refunds_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEPCRS.pls 115.5 2003/04/25 03:50:27 nmakhani noship $ */
3: procedure rosetta_table_copy_in_p8(t out nocopy okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 JTF_VARCHAR2_TABLE_200
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p8(t out nocopy okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 JTF_VARCHAR2_TABLE_200
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: );
24: procedure rosetta_table_copy_out_p8(t okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: );
24: procedure rosetta_table_copy_out_p8(t okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
25: , a1 out nocopy JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: );
24: procedure rosetta_table_copy_out_p8(t okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: );
24: procedure rosetta_table_copy_out_p8(t okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_DATE_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: );
24: procedure rosetta_table_copy_out_p8(t okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_DATE_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
24: procedure rosetta_table_copy_out_p8(t okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_DATE_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_DATE_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_NUMBER_TABLE
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_NUMBER_TABLE
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_NUMBER_TABLE
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_NUMBER_TABLE
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_NUMBER_TABLE
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_NUMBER_TABLE
34: , a10 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_NUMBER_TABLE
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_NUMBER_TABLE
43: , a19 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_NUMBER_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_NUMBER_TABLE
43: , a19 out nocopy JTF_NUMBER_TABLE
44: );
45:
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_NUMBER_TABLE
43: , a19 out nocopy JTF_NUMBER_TABLE
44: );
45:
46: procedure create_refund_hdr(p_api_version NUMBER
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_VARCHAR2_TABLE_100
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_NUMBER_TABLE
43: , a19 out nocopy JTF_NUMBER_TABLE
44: );
45:
46: procedure create_refund_hdr(p_api_version NUMBER
47: , p_init_msg_list VARCHAR2
156: procedure create_refund_details(p_api_version NUMBER
157: , p_init_msg_list VARCHAR2
158: , p_commit VARCHAR2
159: , p3_a0 JTF_VARCHAR2_TABLE_200
160: , p3_a1 JTF_NUMBER_TABLE
161: , p3_a2 JTF_NUMBER_TABLE
162: , p3_a3 JTF_DATE_TABLE
163: , p3_a4 JTF_NUMBER_TABLE
164: , p3_a5 JTF_VARCHAR2_TABLE_100
157: , p_init_msg_list VARCHAR2
158: , p_commit VARCHAR2
159: , p3_a0 JTF_VARCHAR2_TABLE_200
160: , p3_a1 JTF_NUMBER_TABLE
161: , p3_a2 JTF_NUMBER_TABLE
162: , p3_a3 JTF_DATE_TABLE
163: , p3_a4 JTF_NUMBER_TABLE
164: , p3_a5 JTF_VARCHAR2_TABLE_100
165: , p3_a6 JTF_VARCHAR2_TABLE_100
159: , p3_a0 JTF_VARCHAR2_TABLE_200
160: , p3_a1 JTF_NUMBER_TABLE
161: , p3_a2 JTF_NUMBER_TABLE
162: , p3_a3 JTF_DATE_TABLE
163: , p3_a4 JTF_NUMBER_TABLE
164: , p3_a5 JTF_VARCHAR2_TABLE_100
165: , p3_a6 JTF_VARCHAR2_TABLE_100
166: , p3_a7 JTF_NUMBER_TABLE
167: , p3_a8 JTF_NUMBER_TABLE
162: , p3_a3 JTF_DATE_TABLE
163: , p3_a4 JTF_NUMBER_TABLE
164: , p3_a5 JTF_VARCHAR2_TABLE_100
165: , p3_a6 JTF_VARCHAR2_TABLE_100
166: , p3_a7 JTF_NUMBER_TABLE
167: , p3_a8 JTF_NUMBER_TABLE
168: , p3_a9 JTF_VARCHAR2_TABLE_2000
169: , p3_a10 JTF_NUMBER_TABLE
170: , p3_a11 JTF_NUMBER_TABLE
163: , p3_a4 JTF_NUMBER_TABLE
164: , p3_a5 JTF_VARCHAR2_TABLE_100
165: , p3_a6 JTF_VARCHAR2_TABLE_100
166: , p3_a7 JTF_NUMBER_TABLE
167: , p3_a8 JTF_NUMBER_TABLE
168: , p3_a9 JTF_VARCHAR2_TABLE_2000
169: , p3_a10 JTF_NUMBER_TABLE
170: , p3_a11 JTF_NUMBER_TABLE
171: , p3_a12 JTF_NUMBER_TABLE
165: , p3_a6 JTF_VARCHAR2_TABLE_100
166: , p3_a7 JTF_NUMBER_TABLE
167: , p3_a8 JTF_NUMBER_TABLE
168: , p3_a9 JTF_VARCHAR2_TABLE_2000
169: , p3_a10 JTF_NUMBER_TABLE
170: , p3_a11 JTF_NUMBER_TABLE
171: , p3_a12 JTF_NUMBER_TABLE
172: , p3_a13 JTF_NUMBER_TABLE
173: , p3_a14 JTF_NUMBER_TABLE
166: , p3_a7 JTF_NUMBER_TABLE
167: , p3_a8 JTF_NUMBER_TABLE
168: , p3_a9 JTF_VARCHAR2_TABLE_2000
169: , p3_a10 JTF_NUMBER_TABLE
170: , p3_a11 JTF_NUMBER_TABLE
171: , p3_a12 JTF_NUMBER_TABLE
172: , p3_a13 JTF_NUMBER_TABLE
173: , p3_a14 JTF_NUMBER_TABLE
174: , p3_a15 JTF_NUMBER_TABLE
167: , p3_a8 JTF_NUMBER_TABLE
168: , p3_a9 JTF_VARCHAR2_TABLE_2000
169: , p3_a10 JTF_NUMBER_TABLE
170: , p3_a11 JTF_NUMBER_TABLE
171: , p3_a12 JTF_NUMBER_TABLE
172: , p3_a13 JTF_NUMBER_TABLE
173: , p3_a14 JTF_NUMBER_TABLE
174: , p3_a15 JTF_NUMBER_TABLE
175: , p3_a16 JTF_VARCHAR2_TABLE_100
168: , p3_a9 JTF_VARCHAR2_TABLE_2000
169: , p3_a10 JTF_NUMBER_TABLE
170: , p3_a11 JTF_NUMBER_TABLE
171: , p3_a12 JTF_NUMBER_TABLE
172: , p3_a13 JTF_NUMBER_TABLE
173: , p3_a14 JTF_NUMBER_TABLE
174: , p3_a15 JTF_NUMBER_TABLE
175: , p3_a16 JTF_VARCHAR2_TABLE_100
176: , p3_a17 JTF_NUMBER_TABLE
169: , p3_a10 JTF_NUMBER_TABLE
170: , p3_a11 JTF_NUMBER_TABLE
171: , p3_a12 JTF_NUMBER_TABLE
172: , p3_a13 JTF_NUMBER_TABLE
173: , p3_a14 JTF_NUMBER_TABLE
174: , p3_a15 JTF_NUMBER_TABLE
175: , p3_a16 JTF_VARCHAR2_TABLE_100
176: , p3_a17 JTF_NUMBER_TABLE
177: , p3_a18 JTF_NUMBER_TABLE
170: , p3_a11 JTF_NUMBER_TABLE
171: , p3_a12 JTF_NUMBER_TABLE
172: , p3_a13 JTF_NUMBER_TABLE
173: , p3_a14 JTF_NUMBER_TABLE
174: , p3_a15 JTF_NUMBER_TABLE
175: , p3_a16 JTF_VARCHAR2_TABLE_100
176: , p3_a17 JTF_NUMBER_TABLE
177: , p3_a18 JTF_NUMBER_TABLE
178: , p3_a19 JTF_NUMBER_TABLE
172: , p3_a13 JTF_NUMBER_TABLE
173: , p3_a14 JTF_NUMBER_TABLE
174: , p3_a15 JTF_NUMBER_TABLE
175: , p3_a16 JTF_VARCHAR2_TABLE_100
176: , p3_a17 JTF_NUMBER_TABLE
177: , p3_a18 JTF_NUMBER_TABLE
178: , p3_a19 JTF_NUMBER_TABLE
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
173: , p3_a14 JTF_NUMBER_TABLE
174: , p3_a15 JTF_NUMBER_TABLE
175: , p3_a16 JTF_VARCHAR2_TABLE_100
176: , p3_a17 JTF_NUMBER_TABLE
177: , p3_a18 JTF_NUMBER_TABLE
178: , p3_a19 JTF_NUMBER_TABLE
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
174: , p3_a15 JTF_NUMBER_TABLE
175: , p3_a16 JTF_VARCHAR2_TABLE_100
176: , p3_a17 JTF_NUMBER_TABLE
177: , p3_a18 JTF_NUMBER_TABLE
178: , p3_a19 JTF_NUMBER_TABLE
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: );
183: procedure update_refund_details(p_api_version NUMBER
184: , p_init_msg_list VARCHAR2
185: , p_commit VARCHAR2
186: , p3_a0 JTF_VARCHAR2_TABLE_200
187: , p3_a1 JTF_NUMBER_TABLE
188: , p3_a2 JTF_NUMBER_TABLE
189: , p3_a3 JTF_DATE_TABLE
190: , p3_a4 JTF_NUMBER_TABLE
191: , p3_a5 JTF_VARCHAR2_TABLE_100
184: , p_init_msg_list VARCHAR2
185: , p_commit VARCHAR2
186: , p3_a0 JTF_VARCHAR2_TABLE_200
187: , p3_a1 JTF_NUMBER_TABLE
188: , p3_a2 JTF_NUMBER_TABLE
189: , p3_a3 JTF_DATE_TABLE
190: , p3_a4 JTF_NUMBER_TABLE
191: , p3_a5 JTF_VARCHAR2_TABLE_100
192: , p3_a6 JTF_VARCHAR2_TABLE_100
186: , p3_a0 JTF_VARCHAR2_TABLE_200
187: , p3_a1 JTF_NUMBER_TABLE
188: , p3_a2 JTF_NUMBER_TABLE
189: , p3_a3 JTF_DATE_TABLE
190: , p3_a4 JTF_NUMBER_TABLE
191: , p3_a5 JTF_VARCHAR2_TABLE_100
192: , p3_a6 JTF_VARCHAR2_TABLE_100
193: , p3_a7 JTF_NUMBER_TABLE
194: , p3_a8 JTF_NUMBER_TABLE
189: , p3_a3 JTF_DATE_TABLE
190: , p3_a4 JTF_NUMBER_TABLE
191: , p3_a5 JTF_VARCHAR2_TABLE_100
192: , p3_a6 JTF_VARCHAR2_TABLE_100
193: , p3_a7 JTF_NUMBER_TABLE
194: , p3_a8 JTF_NUMBER_TABLE
195: , p3_a9 JTF_VARCHAR2_TABLE_2000
196: , p3_a10 JTF_NUMBER_TABLE
197: , p3_a11 JTF_NUMBER_TABLE
190: , p3_a4 JTF_NUMBER_TABLE
191: , p3_a5 JTF_VARCHAR2_TABLE_100
192: , p3_a6 JTF_VARCHAR2_TABLE_100
193: , p3_a7 JTF_NUMBER_TABLE
194: , p3_a8 JTF_NUMBER_TABLE
195: , p3_a9 JTF_VARCHAR2_TABLE_2000
196: , p3_a10 JTF_NUMBER_TABLE
197: , p3_a11 JTF_NUMBER_TABLE
198: , p3_a12 JTF_NUMBER_TABLE
192: , p3_a6 JTF_VARCHAR2_TABLE_100
193: , p3_a7 JTF_NUMBER_TABLE
194: , p3_a8 JTF_NUMBER_TABLE
195: , p3_a9 JTF_VARCHAR2_TABLE_2000
196: , p3_a10 JTF_NUMBER_TABLE
197: , p3_a11 JTF_NUMBER_TABLE
198: , p3_a12 JTF_NUMBER_TABLE
199: , p3_a13 JTF_NUMBER_TABLE
200: , p3_a14 JTF_NUMBER_TABLE
193: , p3_a7 JTF_NUMBER_TABLE
194: , p3_a8 JTF_NUMBER_TABLE
195: , p3_a9 JTF_VARCHAR2_TABLE_2000
196: , p3_a10 JTF_NUMBER_TABLE
197: , p3_a11 JTF_NUMBER_TABLE
198: , p3_a12 JTF_NUMBER_TABLE
199: , p3_a13 JTF_NUMBER_TABLE
200: , p3_a14 JTF_NUMBER_TABLE
201: , p3_a15 JTF_NUMBER_TABLE
194: , p3_a8 JTF_NUMBER_TABLE
195: , p3_a9 JTF_VARCHAR2_TABLE_2000
196: , p3_a10 JTF_NUMBER_TABLE
197: , p3_a11 JTF_NUMBER_TABLE
198: , p3_a12 JTF_NUMBER_TABLE
199: , p3_a13 JTF_NUMBER_TABLE
200: , p3_a14 JTF_NUMBER_TABLE
201: , p3_a15 JTF_NUMBER_TABLE
202: , p3_a16 JTF_VARCHAR2_TABLE_100
195: , p3_a9 JTF_VARCHAR2_TABLE_2000
196: , p3_a10 JTF_NUMBER_TABLE
197: , p3_a11 JTF_NUMBER_TABLE
198: , p3_a12 JTF_NUMBER_TABLE
199: , p3_a13 JTF_NUMBER_TABLE
200: , p3_a14 JTF_NUMBER_TABLE
201: , p3_a15 JTF_NUMBER_TABLE
202: , p3_a16 JTF_VARCHAR2_TABLE_100
203: , p3_a17 JTF_NUMBER_TABLE
196: , p3_a10 JTF_NUMBER_TABLE
197: , p3_a11 JTF_NUMBER_TABLE
198: , p3_a12 JTF_NUMBER_TABLE
199: , p3_a13 JTF_NUMBER_TABLE
200: , p3_a14 JTF_NUMBER_TABLE
201: , p3_a15 JTF_NUMBER_TABLE
202: , p3_a16 JTF_VARCHAR2_TABLE_100
203: , p3_a17 JTF_NUMBER_TABLE
204: , p3_a18 JTF_NUMBER_TABLE
197: , p3_a11 JTF_NUMBER_TABLE
198: , p3_a12 JTF_NUMBER_TABLE
199: , p3_a13 JTF_NUMBER_TABLE
200: , p3_a14 JTF_NUMBER_TABLE
201: , p3_a15 JTF_NUMBER_TABLE
202: , p3_a16 JTF_VARCHAR2_TABLE_100
203: , p3_a17 JTF_NUMBER_TABLE
204: , p3_a18 JTF_NUMBER_TABLE
205: , p3_a19 JTF_NUMBER_TABLE
199: , p3_a13 JTF_NUMBER_TABLE
200: , p3_a14 JTF_NUMBER_TABLE
201: , p3_a15 JTF_NUMBER_TABLE
202: , p3_a16 JTF_VARCHAR2_TABLE_100
203: , p3_a17 JTF_NUMBER_TABLE
204: , p3_a18 JTF_NUMBER_TABLE
205: , p3_a19 JTF_NUMBER_TABLE
206: , x_return_status out nocopy VARCHAR2
207: , x_msg_count out nocopy NUMBER
200: , p3_a14 JTF_NUMBER_TABLE
201: , p3_a15 JTF_NUMBER_TABLE
202: , p3_a16 JTF_VARCHAR2_TABLE_100
203: , p3_a17 JTF_NUMBER_TABLE
204: , p3_a18 JTF_NUMBER_TABLE
205: , p3_a19 JTF_NUMBER_TABLE
206: , x_return_status out nocopy VARCHAR2
207: , x_msg_count out nocopy NUMBER
208: , x_msg_data out nocopy VARCHAR2
201: , p3_a15 JTF_NUMBER_TABLE
202: , p3_a16 JTF_VARCHAR2_TABLE_100
203: , p3_a17 JTF_NUMBER_TABLE
204: , p3_a18 JTF_NUMBER_TABLE
205: , p3_a19 JTF_NUMBER_TABLE
206: , x_return_status out nocopy VARCHAR2
207: , x_msg_count out nocopy NUMBER
208: , x_msg_data out nocopy VARCHAR2
209: );
210: procedure delete_refund_details(p_api_version NUMBER
211: , p_init_msg_list VARCHAR2
212: , p_commit VARCHAR2
213: , p3_a0 JTF_VARCHAR2_TABLE_200
214: , p3_a1 JTF_NUMBER_TABLE
215: , p3_a2 JTF_NUMBER_TABLE
216: , p3_a3 JTF_DATE_TABLE
217: , p3_a4 JTF_NUMBER_TABLE
218: , p3_a5 JTF_VARCHAR2_TABLE_100
211: , p_init_msg_list VARCHAR2
212: , p_commit VARCHAR2
213: , p3_a0 JTF_VARCHAR2_TABLE_200
214: , p3_a1 JTF_NUMBER_TABLE
215: , p3_a2 JTF_NUMBER_TABLE
216: , p3_a3 JTF_DATE_TABLE
217: , p3_a4 JTF_NUMBER_TABLE
218: , p3_a5 JTF_VARCHAR2_TABLE_100
219: , p3_a6 JTF_VARCHAR2_TABLE_100
213: , p3_a0 JTF_VARCHAR2_TABLE_200
214: , p3_a1 JTF_NUMBER_TABLE
215: , p3_a2 JTF_NUMBER_TABLE
216: , p3_a3 JTF_DATE_TABLE
217: , p3_a4 JTF_NUMBER_TABLE
218: , p3_a5 JTF_VARCHAR2_TABLE_100
219: , p3_a6 JTF_VARCHAR2_TABLE_100
220: , p3_a7 JTF_NUMBER_TABLE
221: , p3_a8 JTF_NUMBER_TABLE
216: , p3_a3 JTF_DATE_TABLE
217: , p3_a4 JTF_NUMBER_TABLE
218: , p3_a5 JTF_VARCHAR2_TABLE_100
219: , p3_a6 JTF_VARCHAR2_TABLE_100
220: , p3_a7 JTF_NUMBER_TABLE
221: , p3_a8 JTF_NUMBER_TABLE
222: , p3_a9 JTF_VARCHAR2_TABLE_2000
223: , p3_a10 JTF_NUMBER_TABLE
224: , p3_a11 JTF_NUMBER_TABLE
217: , p3_a4 JTF_NUMBER_TABLE
218: , p3_a5 JTF_VARCHAR2_TABLE_100
219: , p3_a6 JTF_VARCHAR2_TABLE_100
220: , p3_a7 JTF_NUMBER_TABLE
221: , p3_a8 JTF_NUMBER_TABLE
222: , p3_a9 JTF_VARCHAR2_TABLE_2000
223: , p3_a10 JTF_NUMBER_TABLE
224: , p3_a11 JTF_NUMBER_TABLE
225: , p3_a12 JTF_NUMBER_TABLE
219: , p3_a6 JTF_VARCHAR2_TABLE_100
220: , p3_a7 JTF_NUMBER_TABLE
221: , p3_a8 JTF_NUMBER_TABLE
222: , p3_a9 JTF_VARCHAR2_TABLE_2000
223: , p3_a10 JTF_NUMBER_TABLE
224: , p3_a11 JTF_NUMBER_TABLE
225: , p3_a12 JTF_NUMBER_TABLE
226: , p3_a13 JTF_NUMBER_TABLE
227: , p3_a14 JTF_NUMBER_TABLE
220: , p3_a7 JTF_NUMBER_TABLE
221: , p3_a8 JTF_NUMBER_TABLE
222: , p3_a9 JTF_VARCHAR2_TABLE_2000
223: , p3_a10 JTF_NUMBER_TABLE
224: , p3_a11 JTF_NUMBER_TABLE
225: , p3_a12 JTF_NUMBER_TABLE
226: , p3_a13 JTF_NUMBER_TABLE
227: , p3_a14 JTF_NUMBER_TABLE
228: , p3_a15 JTF_NUMBER_TABLE
221: , p3_a8 JTF_NUMBER_TABLE
222: , p3_a9 JTF_VARCHAR2_TABLE_2000
223: , p3_a10 JTF_NUMBER_TABLE
224: , p3_a11 JTF_NUMBER_TABLE
225: , p3_a12 JTF_NUMBER_TABLE
226: , p3_a13 JTF_NUMBER_TABLE
227: , p3_a14 JTF_NUMBER_TABLE
228: , p3_a15 JTF_NUMBER_TABLE
229: , p3_a16 JTF_VARCHAR2_TABLE_100
222: , p3_a9 JTF_VARCHAR2_TABLE_2000
223: , p3_a10 JTF_NUMBER_TABLE
224: , p3_a11 JTF_NUMBER_TABLE
225: , p3_a12 JTF_NUMBER_TABLE
226: , p3_a13 JTF_NUMBER_TABLE
227: , p3_a14 JTF_NUMBER_TABLE
228: , p3_a15 JTF_NUMBER_TABLE
229: , p3_a16 JTF_VARCHAR2_TABLE_100
230: , p3_a17 JTF_NUMBER_TABLE
223: , p3_a10 JTF_NUMBER_TABLE
224: , p3_a11 JTF_NUMBER_TABLE
225: , p3_a12 JTF_NUMBER_TABLE
226: , p3_a13 JTF_NUMBER_TABLE
227: , p3_a14 JTF_NUMBER_TABLE
228: , p3_a15 JTF_NUMBER_TABLE
229: , p3_a16 JTF_VARCHAR2_TABLE_100
230: , p3_a17 JTF_NUMBER_TABLE
231: , p3_a18 JTF_NUMBER_TABLE
224: , p3_a11 JTF_NUMBER_TABLE
225: , p3_a12 JTF_NUMBER_TABLE
226: , p3_a13 JTF_NUMBER_TABLE
227: , p3_a14 JTF_NUMBER_TABLE
228: , p3_a15 JTF_NUMBER_TABLE
229: , p3_a16 JTF_VARCHAR2_TABLE_100
230: , p3_a17 JTF_NUMBER_TABLE
231: , p3_a18 JTF_NUMBER_TABLE
232: , p3_a19 JTF_NUMBER_TABLE
226: , p3_a13 JTF_NUMBER_TABLE
227: , p3_a14 JTF_NUMBER_TABLE
228: , p3_a15 JTF_NUMBER_TABLE
229: , p3_a16 JTF_VARCHAR2_TABLE_100
230: , p3_a17 JTF_NUMBER_TABLE
231: , p3_a18 JTF_NUMBER_TABLE
232: , p3_a19 JTF_NUMBER_TABLE
233: , x_return_status out nocopy VARCHAR2
234: , x_msg_count out nocopy NUMBER
227: , p3_a14 JTF_NUMBER_TABLE
228: , p3_a15 JTF_NUMBER_TABLE
229: , p3_a16 JTF_VARCHAR2_TABLE_100
230: , p3_a17 JTF_NUMBER_TABLE
231: , p3_a18 JTF_NUMBER_TABLE
232: , p3_a19 JTF_NUMBER_TABLE
233: , x_return_status out nocopy VARCHAR2
234: , x_msg_count out nocopy NUMBER
235: , x_msg_data out nocopy VARCHAR2
228: , p3_a15 JTF_NUMBER_TABLE
229: , p3_a16 JTF_VARCHAR2_TABLE_100
230: , p3_a17 JTF_NUMBER_TABLE
231: , p3_a18 JTF_NUMBER_TABLE
232: , p3_a19 JTF_NUMBER_TABLE
233: , x_return_status out nocopy VARCHAR2
234: , x_msg_count out nocopy NUMBER
235: , x_msg_data out nocopy VARCHAR2
236: );