1: package okl_cure_reports_pub_w AUTHID CURRENT_USER as
2: /* $Header: OKLUCRTS.pls 115.2 2003/10/07 18:00:15 pdevaraj noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cure_reports_pub.crtv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cure_reports_pub.crtv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_2000
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
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_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
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_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_VARCHAR2_TABLE_100
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_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_300
21: , a18 JTF_VARCHAR2_TABLE_300
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_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_300
21: , a18 JTF_VARCHAR2_TABLE_300
22: , a19 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_300
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_300
35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_300
35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_cure_reports_pub.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_cure_reports_pub.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_cure_reports_pub.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
42: procedure rosetta_table_copy_out_p2(t okl_cure_reports_pub.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_300
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_300
60: , a18 out nocopy JTF_VARCHAR2_TABLE_300
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_300
60: , a18 out nocopy JTF_VARCHAR2_TABLE_300
61: , a19 out nocopy JTF_VARCHAR2_TABLE_300
71: , a29 out nocopy JTF_VARCHAR2_TABLE_300
72: , a30 out nocopy JTF_VARCHAR2_TABLE_300
73: , a31 out nocopy JTF_VARCHAR2_TABLE_300
74: , a32 out nocopy JTF_VARCHAR2_TABLE_300
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
73: , a31 out nocopy JTF_VARCHAR2_TABLE_300
74: , a32 out nocopy JTF_VARCHAR2_TABLE_300
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure insert_cure_reports(p_api_version NUMBER
83: , p_init_msg_list VARCHAR2
83: , p_init_msg_list VARCHAR2
84: , x_return_status out nocopy VARCHAR2
85: , x_msg_count out nocopy NUMBER
86: , x_msg_data out nocopy VARCHAR2
87: , p5_a0 JTF_NUMBER_TABLE
88: , p5_a1 JTF_VARCHAR2_TABLE_200
89: , p5_a2 JTF_VARCHAR2_TABLE_100
90: , p5_a3 JTF_DATE_TABLE
91: , p5_a4 JTF_NUMBER_TABLE
87: , p5_a0 JTF_NUMBER_TABLE
88: , p5_a1 JTF_VARCHAR2_TABLE_200
89: , p5_a2 JTF_VARCHAR2_TABLE_100
90: , p5_a3 JTF_DATE_TABLE
91: , p5_a4 JTF_NUMBER_TABLE
92: , p5_a5 JTF_NUMBER_TABLE
93: , p5_a6 JTF_NUMBER_TABLE
94: , p5_a7 JTF_VARCHAR2_TABLE_100
95: , p5_a8 JTF_VARCHAR2_TABLE_2000
88: , p5_a1 JTF_VARCHAR2_TABLE_200
89: , p5_a2 JTF_VARCHAR2_TABLE_100
90: , p5_a3 JTF_DATE_TABLE
91: , p5_a4 JTF_NUMBER_TABLE
92: , p5_a5 JTF_NUMBER_TABLE
93: , p5_a6 JTF_NUMBER_TABLE
94: , p5_a7 JTF_VARCHAR2_TABLE_100
95: , p5_a8 JTF_VARCHAR2_TABLE_2000
96: , p5_a9 JTF_DATE_TABLE
89: , p5_a2 JTF_VARCHAR2_TABLE_100
90: , p5_a3 JTF_DATE_TABLE
91: , p5_a4 JTF_NUMBER_TABLE
92: , p5_a5 JTF_NUMBER_TABLE
93: , p5_a6 JTF_NUMBER_TABLE
94: , p5_a7 JTF_VARCHAR2_TABLE_100
95: , p5_a8 JTF_VARCHAR2_TABLE_2000
96: , p5_a9 JTF_DATE_TABLE
97: , p5_a10 JTF_VARCHAR2_TABLE_100
94: , p5_a7 JTF_VARCHAR2_TABLE_100
95: , p5_a8 JTF_VARCHAR2_TABLE_2000
96: , p5_a9 JTF_DATE_TABLE
97: , p5_a10 JTF_VARCHAR2_TABLE_100
98: , p5_a11 JTF_NUMBER_TABLE
99: , p5_a12 JTF_NUMBER_TABLE
100: , p5_a13 JTF_NUMBER_TABLE
101: , p5_a14 JTF_NUMBER_TABLE
102: , p5_a15 JTF_NUMBER_TABLE
95: , p5_a8 JTF_VARCHAR2_TABLE_2000
96: , p5_a9 JTF_DATE_TABLE
97: , p5_a10 JTF_VARCHAR2_TABLE_100
98: , p5_a11 JTF_NUMBER_TABLE
99: , p5_a12 JTF_NUMBER_TABLE
100: , p5_a13 JTF_NUMBER_TABLE
101: , p5_a14 JTF_NUMBER_TABLE
102: , p5_a15 JTF_NUMBER_TABLE
103: , p5_a16 JTF_DATE_TABLE
96: , p5_a9 JTF_DATE_TABLE
97: , p5_a10 JTF_VARCHAR2_TABLE_100
98: , p5_a11 JTF_NUMBER_TABLE
99: , p5_a12 JTF_NUMBER_TABLE
100: , p5_a13 JTF_NUMBER_TABLE
101: , p5_a14 JTF_NUMBER_TABLE
102: , p5_a15 JTF_NUMBER_TABLE
103: , p5_a16 JTF_DATE_TABLE
104: , p5_a17 JTF_VARCHAR2_TABLE_300
97: , p5_a10 JTF_VARCHAR2_TABLE_100
98: , p5_a11 JTF_NUMBER_TABLE
99: , p5_a12 JTF_NUMBER_TABLE
100: , p5_a13 JTF_NUMBER_TABLE
101: , p5_a14 JTF_NUMBER_TABLE
102: , p5_a15 JTF_NUMBER_TABLE
103: , p5_a16 JTF_DATE_TABLE
104: , p5_a17 JTF_VARCHAR2_TABLE_300
105: , p5_a18 JTF_VARCHAR2_TABLE_300
98: , p5_a11 JTF_NUMBER_TABLE
99: , p5_a12 JTF_NUMBER_TABLE
100: , p5_a13 JTF_NUMBER_TABLE
101: , p5_a14 JTF_NUMBER_TABLE
102: , p5_a15 JTF_NUMBER_TABLE
103: , p5_a16 JTF_DATE_TABLE
104: , p5_a17 JTF_VARCHAR2_TABLE_300
105: , p5_a18 JTF_VARCHAR2_TABLE_300
106: , p5_a19 JTF_VARCHAR2_TABLE_300
116: , p5_a29 JTF_VARCHAR2_TABLE_300
117: , p5_a30 JTF_VARCHAR2_TABLE_300
118: , p5_a31 JTF_VARCHAR2_TABLE_300
119: , p5_a32 JTF_VARCHAR2_TABLE_300
120: , p5_a33 JTF_NUMBER_TABLE
121: , p5_a34 JTF_DATE_TABLE
122: , p5_a35 JTF_NUMBER_TABLE
123: , p5_a36 JTF_DATE_TABLE
124: , p5_a37 JTF_NUMBER_TABLE
118: , p5_a31 JTF_VARCHAR2_TABLE_300
119: , p5_a32 JTF_VARCHAR2_TABLE_300
120: , p5_a33 JTF_NUMBER_TABLE
121: , p5_a34 JTF_DATE_TABLE
122: , p5_a35 JTF_NUMBER_TABLE
123: , p5_a36 JTF_DATE_TABLE
124: , p5_a37 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
120: , p5_a33 JTF_NUMBER_TABLE
121: , p5_a34 JTF_DATE_TABLE
122: , p5_a35 JTF_NUMBER_TABLE
123: , p5_a36 JTF_DATE_TABLE
124: , p5_a37 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_DATE_TABLE
121: , p5_a34 JTF_DATE_TABLE
122: , p5_a35 JTF_NUMBER_TABLE
123: , p5_a36 JTF_DATE_TABLE
124: , p5_a37 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_DATE_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_DATE_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_DATE_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
134: , p6_a9 out nocopy JTF_DATE_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_DATE_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: , p6_a15 out nocopy JTF_NUMBER_TABLE
133: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: , p6_a15 out nocopy JTF_NUMBER_TABLE
141: , p6_a16 out nocopy JTF_DATE_TABLE
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: , p6_a15 out nocopy JTF_NUMBER_TABLE
141: , p6_a16 out nocopy JTF_DATE_TABLE
142: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: , p6_a15 out nocopy JTF_NUMBER_TABLE
141: , p6_a16 out nocopy JTF_DATE_TABLE
142: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
143: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: , p6_a15 out nocopy JTF_NUMBER_TABLE
141: , p6_a16 out nocopy JTF_DATE_TABLE
142: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
143: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
144: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
154: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
155: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
156: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
157: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
158: , p6_a33 out nocopy JTF_NUMBER_TABLE
159: , p6_a34 out nocopy JTF_DATE_TABLE
160: , p6_a35 out nocopy JTF_NUMBER_TABLE
161: , p6_a36 out nocopy JTF_DATE_TABLE
162: , p6_a37 out nocopy JTF_NUMBER_TABLE
156: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
157: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
158: , p6_a33 out nocopy JTF_NUMBER_TABLE
159: , p6_a34 out nocopy JTF_DATE_TABLE
160: , p6_a35 out nocopy JTF_NUMBER_TABLE
161: , p6_a36 out nocopy JTF_DATE_TABLE
162: , p6_a37 out nocopy JTF_NUMBER_TABLE
163: );
164: procedure insert_cure_reports(p_api_version NUMBER
158: , p6_a33 out nocopy JTF_NUMBER_TABLE
159: , p6_a34 out nocopy JTF_DATE_TABLE
160: , p6_a35 out nocopy JTF_NUMBER_TABLE
161: , p6_a36 out nocopy JTF_DATE_TABLE
162: , p6_a37 out nocopy JTF_NUMBER_TABLE
163: );
164: procedure insert_cure_reports(p_api_version NUMBER
165: , p_init_msg_list VARCHAR2
166: , x_return_status out nocopy VARCHAR2
247: , p_init_msg_list VARCHAR2
248: , x_return_status out nocopy VARCHAR2
249: , x_msg_count out nocopy NUMBER
250: , x_msg_data out nocopy VARCHAR2
251: , p5_a0 JTF_NUMBER_TABLE
252: , p5_a1 JTF_VARCHAR2_TABLE_200
253: , p5_a2 JTF_VARCHAR2_TABLE_100
254: , p5_a3 JTF_DATE_TABLE
255: , p5_a4 JTF_NUMBER_TABLE
251: , p5_a0 JTF_NUMBER_TABLE
252: , p5_a1 JTF_VARCHAR2_TABLE_200
253: , p5_a2 JTF_VARCHAR2_TABLE_100
254: , p5_a3 JTF_DATE_TABLE
255: , p5_a4 JTF_NUMBER_TABLE
256: , p5_a5 JTF_NUMBER_TABLE
257: , p5_a6 JTF_NUMBER_TABLE
258: , p5_a7 JTF_VARCHAR2_TABLE_100
259: , p5_a8 JTF_VARCHAR2_TABLE_2000
252: , p5_a1 JTF_VARCHAR2_TABLE_200
253: , p5_a2 JTF_VARCHAR2_TABLE_100
254: , p5_a3 JTF_DATE_TABLE
255: , p5_a4 JTF_NUMBER_TABLE
256: , p5_a5 JTF_NUMBER_TABLE
257: , p5_a6 JTF_NUMBER_TABLE
258: , p5_a7 JTF_VARCHAR2_TABLE_100
259: , p5_a8 JTF_VARCHAR2_TABLE_2000
260: , p5_a9 JTF_DATE_TABLE
253: , p5_a2 JTF_VARCHAR2_TABLE_100
254: , p5_a3 JTF_DATE_TABLE
255: , p5_a4 JTF_NUMBER_TABLE
256: , p5_a5 JTF_NUMBER_TABLE
257: , p5_a6 JTF_NUMBER_TABLE
258: , p5_a7 JTF_VARCHAR2_TABLE_100
259: , p5_a8 JTF_VARCHAR2_TABLE_2000
260: , p5_a9 JTF_DATE_TABLE
261: , p5_a10 JTF_VARCHAR2_TABLE_100
258: , p5_a7 JTF_VARCHAR2_TABLE_100
259: , p5_a8 JTF_VARCHAR2_TABLE_2000
260: , p5_a9 JTF_DATE_TABLE
261: , p5_a10 JTF_VARCHAR2_TABLE_100
262: , p5_a11 JTF_NUMBER_TABLE
263: , p5_a12 JTF_NUMBER_TABLE
264: , p5_a13 JTF_NUMBER_TABLE
265: , p5_a14 JTF_NUMBER_TABLE
266: , p5_a15 JTF_NUMBER_TABLE
259: , p5_a8 JTF_VARCHAR2_TABLE_2000
260: , p5_a9 JTF_DATE_TABLE
261: , p5_a10 JTF_VARCHAR2_TABLE_100
262: , p5_a11 JTF_NUMBER_TABLE
263: , p5_a12 JTF_NUMBER_TABLE
264: , p5_a13 JTF_NUMBER_TABLE
265: , p5_a14 JTF_NUMBER_TABLE
266: , p5_a15 JTF_NUMBER_TABLE
267: , p5_a16 JTF_DATE_TABLE
260: , p5_a9 JTF_DATE_TABLE
261: , p5_a10 JTF_VARCHAR2_TABLE_100
262: , p5_a11 JTF_NUMBER_TABLE
263: , p5_a12 JTF_NUMBER_TABLE
264: , p5_a13 JTF_NUMBER_TABLE
265: , p5_a14 JTF_NUMBER_TABLE
266: , p5_a15 JTF_NUMBER_TABLE
267: , p5_a16 JTF_DATE_TABLE
268: , p5_a17 JTF_VARCHAR2_TABLE_300
261: , p5_a10 JTF_VARCHAR2_TABLE_100
262: , p5_a11 JTF_NUMBER_TABLE
263: , p5_a12 JTF_NUMBER_TABLE
264: , p5_a13 JTF_NUMBER_TABLE
265: , p5_a14 JTF_NUMBER_TABLE
266: , p5_a15 JTF_NUMBER_TABLE
267: , p5_a16 JTF_DATE_TABLE
268: , p5_a17 JTF_VARCHAR2_TABLE_300
269: , p5_a18 JTF_VARCHAR2_TABLE_300
262: , p5_a11 JTF_NUMBER_TABLE
263: , p5_a12 JTF_NUMBER_TABLE
264: , p5_a13 JTF_NUMBER_TABLE
265: , p5_a14 JTF_NUMBER_TABLE
266: , p5_a15 JTF_NUMBER_TABLE
267: , p5_a16 JTF_DATE_TABLE
268: , p5_a17 JTF_VARCHAR2_TABLE_300
269: , p5_a18 JTF_VARCHAR2_TABLE_300
270: , p5_a19 JTF_VARCHAR2_TABLE_300
280: , p5_a29 JTF_VARCHAR2_TABLE_300
281: , p5_a30 JTF_VARCHAR2_TABLE_300
282: , p5_a31 JTF_VARCHAR2_TABLE_300
283: , p5_a32 JTF_VARCHAR2_TABLE_300
284: , p5_a33 JTF_NUMBER_TABLE
285: , p5_a34 JTF_DATE_TABLE
286: , p5_a35 JTF_NUMBER_TABLE
287: , p5_a36 JTF_DATE_TABLE
288: , p5_a37 JTF_NUMBER_TABLE
282: , p5_a31 JTF_VARCHAR2_TABLE_300
283: , p5_a32 JTF_VARCHAR2_TABLE_300
284: , p5_a33 JTF_NUMBER_TABLE
285: , p5_a34 JTF_DATE_TABLE
286: , p5_a35 JTF_NUMBER_TABLE
287: , p5_a36 JTF_DATE_TABLE
288: , p5_a37 JTF_NUMBER_TABLE
289: );
290: procedure lock_cure_reports(p_api_version NUMBER
284: , p5_a33 JTF_NUMBER_TABLE
285: , p5_a34 JTF_DATE_TABLE
286: , p5_a35 JTF_NUMBER_TABLE
287: , p5_a36 JTF_DATE_TABLE
288: , p5_a37 JTF_NUMBER_TABLE
289: );
290: procedure lock_cure_reports(p_api_version NUMBER
291: , p_init_msg_list VARCHAR2
292: , x_return_status out nocopy VARCHAR2
335: , p_init_msg_list VARCHAR2
336: , x_return_status out nocopy VARCHAR2
337: , x_msg_count out nocopy NUMBER
338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_VARCHAR2_TABLE_200
341: , p5_a2 JTF_VARCHAR2_TABLE_100
342: , p5_a3 JTF_DATE_TABLE
343: , p5_a4 JTF_NUMBER_TABLE
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_VARCHAR2_TABLE_200
341: , p5_a2 JTF_VARCHAR2_TABLE_100
342: , p5_a3 JTF_DATE_TABLE
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_VARCHAR2_TABLE_100
347: , p5_a8 JTF_VARCHAR2_TABLE_2000
340: , p5_a1 JTF_VARCHAR2_TABLE_200
341: , p5_a2 JTF_VARCHAR2_TABLE_100
342: , p5_a3 JTF_DATE_TABLE
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_VARCHAR2_TABLE_100
347: , p5_a8 JTF_VARCHAR2_TABLE_2000
348: , p5_a9 JTF_DATE_TABLE
341: , p5_a2 JTF_VARCHAR2_TABLE_100
342: , p5_a3 JTF_DATE_TABLE
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_VARCHAR2_TABLE_100
347: , p5_a8 JTF_VARCHAR2_TABLE_2000
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_VARCHAR2_TABLE_100
346: , p5_a7 JTF_VARCHAR2_TABLE_100
347: , p5_a8 JTF_VARCHAR2_TABLE_2000
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_VARCHAR2_TABLE_100
350: , p5_a11 JTF_NUMBER_TABLE
351: , p5_a12 JTF_NUMBER_TABLE
352: , p5_a13 JTF_NUMBER_TABLE
353: , p5_a14 JTF_NUMBER_TABLE
354: , p5_a15 JTF_NUMBER_TABLE
347: , p5_a8 JTF_VARCHAR2_TABLE_2000
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_VARCHAR2_TABLE_100
350: , p5_a11 JTF_NUMBER_TABLE
351: , p5_a12 JTF_NUMBER_TABLE
352: , p5_a13 JTF_NUMBER_TABLE
353: , p5_a14 JTF_NUMBER_TABLE
354: , p5_a15 JTF_NUMBER_TABLE
355: , p5_a16 JTF_DATE_TABLE
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_VARCHAR2_TABLE_100
350: , p5_a11 JTF_NUMBER_TABLE
351: , p5_a12 JTF_NUMBER_TABLE
352: , p5_a13 JTF_NUMBER_TABLE
353: , p5_a14 JTF_NUMBER_TABLE
354: , p5_a15 JTF_NUMBER_TABLE
355: , p5_a16 JTF_DATE_TABLE
356: , p5_a17 JTF_VARCHAR2_TABLE_300
349: , p5_a10 JTF_VARCHAR2_TABLE_100
350: , p5_a11 JTF_NUMBER_TABLE
351: , p5_a12 JTF_NUMBER_TABLE
352: , p5_a13 JTF_NUMBER_TABLE
353: , p5_a14 JTF_NUMBER_TABLE
354: , p5_a15 JTF_NUMBER_TABLE
355: , p5_a16 JTF_DATE_TABLE
356: , p5_a17 JTF_VARCHAR2_TABLE_300
357: , p5_a18 JTF_VARCHAR2_TABLE_300
350: , p5_a11 JTF_NUMBER_TABLE
351: , p5_a12 JTF_NUMBER_TABLE
352: , p5_a13 JTF_NUMBER_TABLE
353: , p5_a14 JTF_NUMBER_TABLE
354: , p5_a15 JTF_NUMBER_TABLE
355: , p5_a16 JTF_DATE_TABLE
356: , p5_a17 JTF_VARCHAR2_TABLE_300
357: , p5_a18 JTF_VARCHAR2_TABLE_300
358: , p5_a19 JTF_VARCHAR2_TABLE_300
368: , p5_a29 JTF_VARCHAR2_TABLE_300
369: , p5_a30 JTF_VARCHAR2_TABLE_300
370: , p5_a31 JTF_VARCHAR2_TABLE_300
371: , p5_a32 JTF_VARCHAR2_TABLE_300
372: , p5_a33 JTF_NUMBER_TABLE
373: , p5_a34 JTF_DATE_TABLE
374: , p5_a35 JTF_NUMBER_TABLE
375: , p5_a36 JTF_DATE_TABLE
376: , p5_a37 JTF_NUMBER_TABLE
370: , p5_a31 JTF_VARCHAR2_TABLE_300
371: , p5_a32 JTF_VARCHAR2_TABLE_300
372: , p5_a33 JTF_NUMBER_TABLE
373: , p5_a34 JTF_DATE_TABLE
374: , p5_a35 JTF_NUMBER_TABLE
375: , p5_a36 JTF_DATE_TABLE
376: , p5_a37 JTF_NUMBER_TABLE
377: , p6_a0 out nocopy JTF_NUMBER_TABLE
378: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
372: , p5_a33 JTF_NUMBER_TABLE
373: , p5_a34 JTF_DATE_TABLE
374: , p5_a35 JTF_NUMBER_TABLE
375: , p5_a36 JTF_DATE_TABLE
376: , p5_a37 JTF_NUMBER_TABLE
377: , p6_a0 out nocopy JTF_NUMBER_TABLE
378: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
379: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a3 out nocopy JTF_DATE_TABLE
373: , p5_a34 JTF_DATE_TABLE
374: , p5_a35 JTF_NUMBER_TABLE
375: , p5_a36 JTF_DATE_TABLE
376: , p5_a37 JTF_NUMBER_TABLE
377: , p6_a0 out nocopy JTF_NUMBER_TABLE
378: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
379: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a3 out nocopy JTF_DATE_TABLE
381: , p6_a4 out nocopy JTF_NUMBER_TABLE
377: , p6_a0 out nocopy JTF_NUMBER_TABLE
378: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
379: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a3 out nocopy JTF_DATE_TABLE
381: , p6_a4 out nocopy JTF_NUMBER_TABLE
382: , p6_a5 out nocopy JTF_NUMBER_TABLE
383: , p6_a6 out nocopy JTF_NUMBER_TABLE
384: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
385: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
378: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
379: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a3 out nocopy JTF_DATE_TABLE
381: , p6_a4 out nocopy JTF_NUMBER_TABLE
382: , p6_a5 out nocopy JTF_NUMBER_TABLE
383: , p6_a6 out nocopy JTF_NUMBER_TABLE
384: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
385: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
386: , p6_a9 out nocopy JTF_DATE_TABLE
379: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a3 out nocopy JTF_DATE_TABLE
381: , p6_a4 out nocopy JTF_NUMBER_TABLE
382: , p6_a5 out nocopy JTF_NUMBER_TABLE
383: , p6_a6 out nocopy JTF_NUMBER_TABLE
384: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
385: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
386: , p6_a9 out nocopy JTF_DATE_TABLE
387: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
384: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
385: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
386: , p6_a9 out nocopy JTF_DATE_TABLE
387: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a11 out nocopy JTF_NUMBER_TABLE
389: , p6_a12 out nocopy JTF_NUMBER_TABLE
390: , p6_a13 out nocopy JTF_NUMBER_TABLE
391: , p6_a14 out nocopy JTF_NUMBER_TABLE
392: , p6_a15 out nocopy JTF_NUMBER_TABLE
385: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
386: , p6_a9 out nocopy JTF_DATE_TABLE
387: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a11 out nocopy JTF_NUMBER_TABLE
389: , p6_a12 out nocopy JTF_NUMBER_TABLE
390: , p6_a13 out nocopy JTF_NUMBER_TABLE
391: , p6_a14 out nocopy JTF_NUMBER_TABLE
392: , p6_a15 out nocopy JTF_NUMBER_TABLE
393: , p6_a16 out nocopy JTF_DATE_TABLE
386: , p6_a9 out nocopy JTF_DATE_TABLE
387: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a11 out nocopy JTF_NUMBER_TABLE
389: , p6_a12 out nocopy JTF_NUMBER_TABLE
390: , p6_a13 out nocopy JTF_NUMBER_TABLE
391: , p6_a14 out nocopy JTF_NUMBER_TABLE
392: , p6_a15 out nocopy JTF_NUMBER_TABLE
393: , p6_a16 out nocopy JTF_DATE_TABLE
394: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
387: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a11 out nocopy JTF_NUMBER_TABLE
389: , p6_a12 out nocopy JTF_NUMBER_TABLE
390: , p6_a13 out nocopy JTF_NUMBER_TABLE
391: , p6_a14 out nocopy JTF_NUMBER_TABLE
392: , p6_a15 out nocopy JTF_NUMBER_TABLE
393: , p6_a16 out nocopy JTF_DATE_TABLE
394: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
395: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
388: , p6_a11 out nocopy JTF_NUMBER_TABLE
389: , p6_a12 out nocopy JTF_NUMBER_TABLE
390: , p6_a13 out nocopy JTF_NUMBER_TABLE
391: , p6_a14 out nocopy JTF_NUMBER_TABLE
392: , p6_a15 out nocopy JTF_NUMBER_TABLE
393: , p6_a16 out nocopy JTF_DATE_TABLE
394: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
395: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
396: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
406: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
407: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
410: , p6_a33 out nocopy JTF_NUMBER_TABLE
411: , p6_a34 out nocopy JTF_DATE_TABLE
412: , p6_a35 out nocopy JTF_NUMBER_TABLE
413: , p6_a36 out nocopy JTF_DATE_TABLE
414: , p6_a37 out nocopy JTF_NUMBER_TABLE
408: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
410: , p6_a33 out nocopy JTF_NUMBER_TABLE
411: , p6_a34 out nocopy JTF_DATE_TABLE
412: , p6_a35 out nocopy JTF_NUMBER_TABLE
413: , p6_a36 out nocopy JTF_DATE_TABLE
414: , p6_a37 out nocopy JTF_NUMBER_TABLE
415: );
416: procedure update_cure_reports(p_api_version NUMBER
410: , p6_a33 out nocopy JTF_NUMBER_TABLE
411: , p6_a34 out nocopy JTF_DATE_TABLE
412: , p6_a35 out nocopy JTF_NUMBER_TABLE
413: , p6_a36 out nocopy JTF_DATE_TABLE
414: , p6_a37 out nocopy JTF_NUMBER_TABLE
415: );
416: procedure update_cure_reports(p_api_version NUMBER
417: , p_init_msg_list VARCHAR2
418: , x_return_status out nocopy VARCHAR2
499: , p_init_msg_list VARCHAR2
500: , x_return_status out nocopy VARCHAR2
501: , x_msg_count out nocopy NUMBER
502: , x_msg_data out nocopy VARCHAR2
503: , p5_a0 JTF_NUMBER_TABLE
504: , p5_a1 JTF_VARCHAR2_TABLE_200
505: , p5_a2 JTF_VARCHAR2_TABLE_100
506: , p5_a3 JTF_DATE_TABLE
507: , p5_a4 JTF_NUMBER_TABLE
503: , p5_a0 JTF_NUMBER_TABLE
504: , p5_a1 JTF_VARCHAR2_TABLE_200
505: , p5_a2 JTF_VARCHAR2_TABLE_100
506: , p5_a3 JTF_DATE_TABLE
507: , p5_a4 JTF_NUMBER_TABLE
508: , p5_a5 JTF_NUMBER_TABLE
509: , p5_a6 JTF_NUMBER_TABLE
510: , p5_a7 JTF_VARCHAR2_TABLE_100
511: , p5_a8 JTF_VARCHAR2_TABLE_2000
504: , p5_a1 JTF_VARCHAR2_TABLE_200
505: , p5_a2 JTF_VARCHAR2_TABLE_100
506: , p5_a3 JTF_DATE_TABLE
507: , p5_a4 JTF_NUMBER_TABLE
508: , p5_a5 JTF_NUMBER_TABLE
509: , p5_a6 JTF_NUMBER_TABLE
510: , p5_a7 JTF_VARCHAR2_TABLE_100
511: , p5_a8 JTF_VARCHAR2_TABLE_2000
512: , p5_a9 JTF_DATE_TABLE
505: , p5_a2 JTF_VARCHAR2_TABLE_100
506: , p5_a3 JTF_DATE_TABLE
507: , p5_a4 JTF_NUMBER_TABLE
508: , p5_a5 JTF_NUMBER_TABLE
509: , p5_a6 JTF_NUMBER_TABLE
510: , p5_a7 JTF_VARCHAR2_TABLE_100
511: , p5_a8 JTF_VARCHAR2_TABLE_2000
512: , p5_a9 JTF_DATE_TABLE
513: , p5_a10 JTF_VARCHAR2_TABLE_100
510: , p5_a7 JTF_VARCHAR2_TABLE_100
511: , p5_a8 JTF_VARCHAR2_TABLE_2000
512: , p5_a9 JTF_DATE_TABLE
513: , p5_a10 JTF_VARCHAR2_TABLE_100
514: , p5_a11 JTF_NUMBER_TABLE
515: , p5_a12 JTF_NUMBER_TABLE
516: , p5_a13 JTF_NUMBER_TABLE
517: , p5_a14 JTF_NUMBER_TABLE
518: , p5_a15 JTF_NUMBER_TABLE
511: , p5_a8 JTF_VARCHAR2_TABLE_2000
512: , p5_a9 JTF_DATE_TABLE
513: , p5_a10 JTF_VARCHAR2_TABLE_100
514: , p5_a11 JTF_NUMBER_TABLE
515: , p5_a12 JTF_NUMBER_TABLE
516: , p5_a13 JTF_NUMBER_TABLE
517: , p5_a14 JTF_NUMBER_TABLE
518: , p5_a15 JTF_NUMBER_TABLE
519: , p5_a16 JTF_DATE_TABLE
512: , p5_a9 JTF_DATE_TABLE
513: , p5_a10 JTF_VARCHAR2_TABLE_100
514: , p5_a11 JTF_NUMBER_TABLE
515: , p5_a12 JTF_NUMBER_TABLE
516: , p5_a13 JTF_NUMBER_TABLE
517: , p5_a14 JTF_NUMBER_TABLE
518: , p5_a15 JTF_NUMBER_TABLE
519: , p5_a16 JTF_DATE_TABLE
520: , p5_a17 JTF_VARCHAR2_TABLE_300
513: , p5_a10 JTF_VARCHAR2_TABLE_100
514: , p5_a11 JTF_NUMBER_TABLE
515: , p5_a12 JTF_NUMBER_TABLE
516: , p5_a13 JTF_NUMBER_TABLE
517: , p5_a14 JTF_NUMBER_TABLE
518: , p5_a15 JTF_NUMBER_TABLE
519: , p5_a16 JTF_DATE_TABLE
520: , p5_a17 JTF_VARCHAR2_TABLE_300
521: , p5_a18 JTF_VARCHAR2_TABLE_300
514: , p5_a11 JTF_NUMBER_TABLE
515: , p5_a12 JTF_NUMBER_TABLE
516: , p5_a13 JTF_NUMBER_TABLE
517: , p5_a14 JTF_NUMBER_TABLE
518: , p5_a15 JTF_NUMBER_TABLE
519: , p5_a16 JTF_DATE_TABLE
520: , p5_a17 JTF_VARCHAR2_TABLE_300
521: , p5_a18 JTF_VARCHAR2_TABLE_300
522: , p5_a19 JTF_VARCHAR2_TABLE_300
532: , p5_a29 JTF_VARCHAR2_TABLE_300
533: , p5_a30 JTF_VARCHAR2_TABLE_300
534: , p5_a31 JTF_VARCHAR2_TABLE_300
535: , p5_a32 JTF_VARCHAR2_TABLE_300
536: , p5_a33 JTF_NUMBER_TABLE
537: , p5_a34 JTF_DATE_TABLE
538: , p5_a35 JTF_NUMBER_TABLE
539: , p5_a36 JTF_DATE_TABLE
540: , p5_a37 JTF_NUMBER_TABLE
534: , p5_a31 JTF_VARCHAR2_TABLE_300
535: , p5_a32 JTF_VARCHAR2_TABLE_300
536: , p5_a33 JTF_NUMBER_TABLE
537: , p5_a34 JTF_DATE_TABLE
538: , p5_a35 JTF_NUMBER_TABLE
539: , p5_a36 JTF_DATE_TABLE
540: , p5_a37 JTF_NUMBER_TABLE
541: );
542: procedure delete_cure_reports(p_api_version NUMBER
536: , p5_a33 JTF_NUMBER_TABLE
537: , p5_a34 JTF_DATE_TABLE
538: , p5_a35 JTF_NUMBER_TABLE
539: , p5_a36 JTF_DATE_TABLE
540: , p5_a37 JTF_NUMBER_TABLE
541: );
542: procedure delete_cure_reports(p_api_version NUMBER
543: , p_init_msg_list VARCHAR2
544: , x_return_status out nocopy VARCHAR2
587: , p_init_msg_list VARCHAR2
588: , x_return_status out nocopy VARCHAR2
589: , x_msg_count out nocopy NUMBER
590: , x_msg_data out nocopy VARCHAR2
591: , p5_a0 JTF_NUMBER_TABLE
592: , p5_a1 JTF_VARCHAR2_TABLE_200
593: , p5_a2 JTF_VARCHAR2_TABLE_100
594: , p5_a3 JTF_DATE_TABLE
595: , p5_a4 JTF_NUMBER_TABLE
591: , p5_a0 JTF_NUMBER_TABLE
592: , p5_a1 JTF_VARCHAR2_TABLE_200
593: , p5_a2 JTF_VARCHAR2_TABLE_100
594: , p5_a3 JTF_DATE_TABLE
595: , p5_a4 JTF_NUMBER_TABLE
596: , p5_a5 JTF_NUMBER_TABLE
597: , p5_a6 JTF_NUMBER_TABLE
598: , p5_a7 JTF_VARCHAR2_TABLE_100
599: , p5_a8 JTF_VARCHAR2_TABLE_2000
592: , p5_a1 JTF_VARCHAR2_TABLE_200
593: , p5_a2 JTF_VARCHAR2_TABLE_100
594: , p5_a3 JTF_DATE_TABLE
595: , p5_a4 JTF_NUMBER_TABLE
596: , p5_a5 JTF_NUMBER_TABLE
597: , p5_a6 JTF_NUMBER_TABLE
598: , p5_a7 JTF_VARCHAR2_TABLE_100
599: , p5_a8 JTF_VARCHAR2_TABLE_2000
600: , p5_a9 JTF_DATE_TABLE
593: , p5_a2 JTF_VARCHAR2_TABLE_100
594: , p5_a3 JTF_DATE_TABLE
595: , p5_a4 JTF_NUMBER_TABLE
596: , p5_a5 JTF_NUMBER_TABLE
597: , p5_a6 JTF_NUMBER_TABLE
598: , p5_a7 JTF_VARCHAR2_TABLE_100
599: , p5_a8 JTF_VARCHAR2_TABLE_2000
600: , p5_a9 JTF_DATE_TABLE
601: , p5_a10 JTF_VARCHAR2_TABLE_100
598: , p5_a7 JTF_VARCHAR2_TABLE_100
599: , p5_a8 JTF_VARCHAR2_TABLE_2000
600: , p5_a9 JTF_DATE_TABLE
601: , p5_a10 JTF_VARCHAR2_TABLE_100
602: , p5_a11 JTF_NUMBER_TABLE
603: , p5_a12 JTF_NUMBER_TABLE
604: , p5_a13 JTF_NUMBER_TABLE
605: , p5_a14 JTF_NUMBER_TABLE
606: , p5_a15 JTF_NUMBER_TABLE
599: , p5_a8 JTF_VARCHAR2_TABLE_2000
600: , p5_a9 JTF_DATE_TABLE
601: , p5_a10 JTF_VARCHAR2_TABLE_100
602: , p5_a11 JTF_NUMBER_TABLE
603: , p5_a12 JTF_NUMBER_TABLE
604: , p5_a13 JTF_NUMBER_TABLE
605: , p5_a14 JTF_NUMBER_TABLE
606: , p5_a15 JTF_NUMBER_TABLE
607: , p5_a16 JTF_DATE_TABLE
600: , p5_a9 JTF_DATE_TABLE
601: , p5_a10 JTF_VARCHAR2_TABLE_100
602: , p5_a11 JTF_NUMBER_TABLE
603: , p5_a12 JTF_NUMBER_TABLE
604: , p5_a13 JTF_NUMBER_TABLE
605: , p5_a14 JTF_NUMBER_TABLE
606: , p5_a15 JTF_NUMBER_TABLE
607: , p5_a16 JTF_DATE_TABLE
608: , p5_a17 JTF_VARCHAR2_TABLE_300
601: , p5_a10 JTF_VARCHAR2_TABLE_100
602: , p5_a11 JTF_NUMBER_TABLE
603: , p5_a12 JTF_NUMBER_TABLE
604: , p5_a13 JTF_NUMBER_TABLE
605: , p5_a14 JTF_NUMBER_TABLE
606: , p5_a15 JTF_NUMBER_TABLE
607: , p5_a16 JTF_DATE_TABLE
608: , p5_a17 JTF_VARCHAR2_TABLE_300
609: , p5_a18 JTF_VARCHAR2_TABLE_300
602: , p5_a11 JTF_NUMBER_TABLE
603: , p5_a12 JTF_NUMBER_TABLE
604: , p5_a13 JTF_NUMBER_TABLE
605: , p5_a14 JTF_NUMBER_TABLE
606: , p5_a15 JTF_NUMBER_TABLE
607: , p5_a16 JTF_DATE_TABLE
608: , p5_a17 JTF_VARCHAR2_TABLE_300
609: , p5_a18 JTF_VARCHAR2_TABLE_300
610: , p5_a19 JTF_VARCHAR2_TABLE_300
620: , p5_a29 JTF_VARCHAR2_TABLE_300
621: , p5_a30 JTF_VARCHAR2_TABLE_300
622: , p5_a31 JTF_VARCHAR2_TABLE_300
623: , p5_a32 JTF_VARCHAR2_TABLE_300
624: , p5_a33 JTF_NUMBER_TABLE
625: , p5_a34 JTF_DATE_TABLE
626: , p5_a35 JTF_NUMBER_TABLE
627: , p5_a36 JTF_DATE_TABLE
628: , p5_a37 JTF_NUMBER_TABLE
622: , p5_a31 JTF_VARCHAR2_TABLE_300
623: , p5_a32 JTF_VARCHAR2_TABLE_300
624: , p5_a33 JTF_NUMBER_TABLE
625: , p5_a34 JTF_DATE_TABLE
626: , p5_a35 JTF_NUMBER_TABLE
627: , p5_a36 JTF_DATE_TABLE
628: , p5_a37 JTF_NUMBER_TABLE
629: );
630: procedure validate_cure_reports(p_api_version NUMBER
624: , p5_a33 JTF_NUMBER_TABLE
625: , p5_a34 JTF_DATE_TABLE
626: , p5_a35 JTF_NUMBER_TABLE
627: , p5_a36 JTF_DATE_TABLE
628: , p5_a37 JTF_NUMBER_TABLE
629: );
630: procedure validate_cure_reports(p_api_version NUMBER
631: , p_init_msg_list VARCHAR2
632: , x_return_status out nocopy VARCHAR2