1: package okl_clm_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLICLMS.pls 115.2 2003/05/26 07:45:41 arajagop noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_clm_pvt.clmv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_clm_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLICLMS.pls 115.2 2003/05/26 07:45:41 arajagop noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_clm_pvt.clmv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
2: /* $Header: OKLICLMS.pls 115.2 2003/05/26 07:45:41 arajagop noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_clm_pvt.clmv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 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
34: , a31 JTF_NUMBER_TABLE
35: , a32 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: , a38 JTF_DATE_TABLE
42: , a39 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: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clm_pvt.clmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clm_pvt.clmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_300
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clm_pvt.clmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_300
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clm_pvt.clmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_300
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clm_pvt.clmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_300
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_VARCHAR2_TABLE_100
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_DATE_TABLE
53: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a10 out nocopy JTF_VARCHAR2_TABLE_300
55: , a11 out nocopy JTF_VARCHAR2_TABLE_300
56: , a12 out nocopy JTF_NUMBER_TABLE
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_500
59: , a15 out nocopy JTF_VARCHAR2_TABLE_500
60: , a16 out nocopy JTF_VARCHAR2_TABLE_500
70: , a26 out nocopy JTF_VARCHAR2_TABLE_500
71: , a27 out nocopy JTF_VARCHAR2_TABLE_500
72: , a28 out nocopy JTF_VARCHAR2_TABLE_500
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_NUMBER_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_NUMBER_TABLE
78: , a34 out nocopy JTF_DATE_TABLE
71: , a27 out nocopy JTF_VARCHAR2_TABLE_500
72: , a28 out nocopy JTF_VARCHAR2_TABLE_500
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_NUMBER_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_NUMBER_TABLE
78: , a34 out nocopy JTF_DATE_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_VARCHAR2_TABLE_500
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_NUMBER_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_NUMBER_TABLE
78: , a34 out nocopy JTF_DATE_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_DATE_TABLE
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_NUMBER_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_NUMBER_TABLE
78: , a34 out nocopy JTF_DATE_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_NUMBER_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_NUMBER_TABLE
78: , a34 out nocopy JTF_DATE_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_NUMBER_TABLE
82: , a38 out nocopy JTF_DATE_TABLE
83: , a39 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_NUMBER_TABLE
78: , a34 out nocopy JTF_DATE_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_NUMBER_TABLE
82: , a38 out nocopy JTF_DATE_TABLE
83: , a39 out nocopy JTF_NUMBER_TABLE
84: );
85:
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_NUMBER_TABLE
82: , a38 out nocopy JTF_DATE_TABLE
83: , a39 out nocopy JTF_NUMBER_TABLE
84: );
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_clm_pvt.clm_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_100
82: , a38 out nocopy JTF_DATE_TABLE
83: , a39 out nocopy JTF_NUMBER_TABLE
84: );
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_clm_pvt.clm_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_100
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_NUMBER_TABLE
90: , a4 JTF_VARCHAR2_TABLE_100
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_clm_pvt.clm_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_100
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_NUMBER_TABLE
90: , a4 JTF_VARCHAR2_TABLE_100
91: , a5 JTF_DATE_TABLE
92: , a6 JTF_DATE_TABLE
93: , a7 JTF_NUMBER_TABLE
89: , a3 JTF_NUMBER_TABLE
90: , a4 JTF_VARCHAR2_TABLE_100
91: , a5 JTF_DATE_TABLE
92: , a6 JTF_DATE_TABLE
93: , a7 JTF_NUMBER_TABLE
94: , a8 JTF_DATE_TABLE
95: , a9 JTF_VARCHAR2_TABLE_300
96: , a10 JTF_NUMBER_TABLE
97: , a11 JTF_NUMBER_TABLE
92: , a6 JTF_DATE_TABLE
93: , a7 JTF_NUMBER_TABLE
94: , a8 JTF_DATE_TABLE
95: , a9 JTF_VARCHAR2_TABLE_300
96: , a10 JTF_NUMBER_TABLE
97: , a11 JTF_NUMBER_TABLE
98: , a12 JTF_NUMBER_TABLE
99: , a13 JTF_NUMBER_TABLE
100: , a14 JTF_VARCHAR2_TABLE_100
93: , a7 JTF_NUMBER_TABLE
94: , a8 JTF_DATE_TABLE
95: , a9 JTF_VARCHAR2_TABLE_300
96: , a10 JTF_NUMBER_TABLE
97: , a11 JTF_NUMBER_TABLE
98: , a12 JTF_NUMBER_TABLE
99: , a13 JTF_NUMBER_TABLE
100: , a14 JTF_VARCHAR2_TABLE_100
101: , a15 JTF_VARCHAR2_TABLE_500
94: , a8 JTF_DATE_TABLE
95: , a9 JTF_VARCHAR2_TABLE_300
96: , a10 JTF_NUMBER_TABLE
97: , a11 JTF_NUMBER_TABLE
98: , a12 JTF_NUMBER_TABLE
99: , a13 JTF_NUMBER_TABLE
100: , a14 JTF_VARCHAR2_TABLE_100
101: , a15 JTF_VARCHAR2_TABLE_500
102: , a16 JTF_VARCHAR2_TABLE_500
95: , a9 JTF_VARCHAR2_TABLE_300
96: , a10 JTF_NUMBER_TABLE
97: , a11 JTF_NUMBER_TABLE
98: , a12 JTF_NUMBER_TABLE
99: , a13 JTF_NUMBER_TABLE
100: , a14 JTF_VARCHAR2_TABLE_100
101: , a15 JTF_VARCHAR2_TABLE_500
102: , a16 JTF_VARCHAR2_TABLE_500
103: , a17 JTF_VARCHAR2_TABLE_500
113: , a27 JTF_VARCHAR2_TABLE_500
114: , a28 JTF_VARCHAR2_TABLE_500
115: , a29 JTF_VARCHAR2_TABLE_500
116: , a30 JTF_DATE_TABLE
117: , a31 JTF_NUMBER_TABLE
118: , a32 JTF_NUMBER_TABLE
119: , a33 JTF_DATE_TABLE
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_DATE_TABLE
114: , a28 JTF_VARCHAR2_TABLE_500
115: , a29 JTF_VARCHAR2_TABLE_500
116: , a30 JTF_DATE_TABLE
117: , a31 JTF_NUMBER_TABLE
118: , a32 JTF_NUMBER_TABLE
119: , a33 JTF_DATE_TABLE
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_DATE_TABLE
122: , a36 JTF_NUMBER_TABLE
116: , a30 JTF_DATE_TABLE
117: , a31 JTF_NUMBER_TABLE
118: , a32 JTF_NUMBER_TABLE
119: , a33 JTF_DATE_TABLE
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_DATE_TABLE
122: , a36 JTF_NUMBER_TABLE
123: );
124: procedure rosetta_table_copy_out_p5(t okl_clm_pvt.clm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
118: , a32 JTF_NUMBER_TABLE
119: , a33 JTF_DATE_TABLE
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_DATE_TABLE
122: , a36 JTF_NUMBER_TABLE
123: );
124: procedure rosetta_table_copy_out_p5(t okl_clm_pvt.clm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
125: , a1 out nocopy JTF_VARCHAR2_TABLE_100
126: , a2 out nocopy JTF_VARCHAR2_TABLE_100
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_DATE_TABLE
122: , a36 JTF_NUMBER_TABLE
123: );
124: procedure rosetta_table_copy_out_p5(t okl_clm_pvt.clm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
125: , a1 out nocopy JTF_VARCHAR2_TABLE_100
126: , a2 out nocopy JTF_VARCHAR2_TABLE_100
127: , a3 out nocopy JTF_NUMBER_TABLE
128: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: );
124: procedure rosetta_table_copy_out_p5(t okl_clm_pvt.clm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
125: , a1 out nocopy JTF_VARCHAR2_TABLE_100
126: , a2 out nocopy JTF_VARCHAR2_TABLE_100
127: , a3 out nocopy JTF_NUMBER_TABLE
128: , a4 out nocopy JTF_VARCHAR2_TABLE_100
129: , a5 out nocopy JTF_DATE_TABLE
130: , a6 out nocopy JTF_DATE_TABLE
131: , a7 out nocopy JTF_NUMBER_TABLE
127: , a3 out nocopy JTF_NUMBER_TABLE
128: , a4 out nocopy JTF_VARCHAR2_TABLE_100
129: , a5 out nocopy JTF_DATE_TABLE
130: , a6 out nocopy JTF_DATE_TABLE
131: , a7 out nocopy JTF_NUMBER_TABLE
132: , a8 out nocopy JTF_DATE_TABLE
133: , a9 out nocopy JTF_VARCHAR2_TABLE_300
134: , a10 out nocopy JTF_NUMBER_TABLE
135: , a11 out nocopy JTF_NUMBER_TABLE
130: , a6 out nocopy JTF_DATE_TABLE
131: , a7 out nocopy JTF_NUMBER_TABLE
132: , a8 out nocopy JTF_DATE_TABLE
133: , a9 out nocopy JTF_VARCHAR2_TABLE_300
134: , a10 out nocopy JTF_NUMBER_TABLE
135: , a11 out nocopy JTF_NUMBER_TABLE
136: , a12 out nocopy JTF_NUMBER_TABLE
137: , a13 out nocopy JTF_NUMBER_TABLE
138: , a14 out nocopy JTF_VARCHAR2_TABLE_100
131: , a7 out nocopy JTF_NUMBER_TABLE
132: , a8 out nocopy JTF_DATE_TABLE
133: , a9 out nocopy JTF_VARCHAR2_TABLE_300
134: , a10 out nocopy JTF_NUMBER_TABLE
135: , a11 out nocopy JTF_NUMBER_TABLE
136: , a12 out nocopy JTF_NUMBER_TABLE
137: , a13 out nocopy JTF_NUMBER_TABLE
138: , a14 out nocopy JTF_VARCHAR2_TABLE_100
139: , a15 out nocopy JTF_VARCHAR2_TABLE_500
132: , a8 out nocopy JTF_DATE_TABLE
133: , a9 out nocopy JTF_VARCHAR2_TABLE_300
134: , a10 out nocopy JTF_NUMBER_TABLE
135: , a11 out nocopy JTF_NUMBER_TABLE
136: , a12 out nocopy JTF_NUMBER_TABLE
137: , a13 out nocopy JTF_NUMBER_TABLE
138: , a14 out nocopy JTF_VARCHAR2_TABLE_100
139: , a15 out nocopy JTF_VARCHAR2_TABLE_500
140: , a16 out nocopy JTF_VARCHAR2_TABLE_500
133: , a9 out nocopy JTF_VARCHAR2_TABLE_300
134: , a10 out nocopy JTF_NUMBER_TABLE
135: , a11 out nocopy JTF_NUMBER_TABLE
136: , a12 out nocopy JTF_NUMBER_TABLE
137: , a13 out nocopy JTF_NUMBER_TABLE
138: , a14 out nocopy JTF_VARCHAR2_TABLE_100
139: , a15 out nocopy JTF_VARCHAR2_TABLE_500
140: , a16 out nocopy JTF_VARCHAR2_TABLE_500
141: , a17 out nocopy JTF_VARCHAR2_TABLE_500
151: , a27 out nocopy JTF_VARCHAR2_TABLE_500
152: , a28 out nocopy JTF_VARCHAR2_TABLE_500
153: , a29 out nocopy JTF_VARCHAR2_TABLE_500
154: , a30 out nocopy JTF_DATE_TABLE
155: , a31 out nocopy JTF_NUMBER_TABLE
156: , a32 out nocopy JTF_NUMBER_TABLE
157: , a33 out nocopy JTF_DATE_TABLE
158: , a34 out nocopy JTF_NUMBER_TABLE
159: , a35 out nocopy JTF_DATE_TABLE
152: , a28 out nocopy JTF_VARCHAR2_TABLE_500
153: , a29 out nocopy JTF_VARCHAR2_TABLE_500
154: , a30 out nocopy JTF_DATE_TABLE
155: , a31 out nocopy JTF_NUMBER_TABLE
156: , a32 out nocopy JTF_NUMBER_TABLE
157: , a33 out nocopy JTF_DATE_TABLE
158: , a34 out nocopy JTF_NUMBER_TABLE
159: , a35 out nocopy JTF_DATE_TABLE
160: , a36 out nocopy JTF_NUMBER_TABLE
154: , a30 out nocopy JTF_DATE_TABLE
155: , a31 out nocopy JTF_NUMBER_TABLE
156: , a32 out nocopy JTF_NUMBER_TABLE
157: , a33 out nocopy JTF_DATE_TABLE
158: , a34 out nocopy JTF_NUMBER_TABLE
159: , a35 out nocopy JTF_DATE_TABLE
160: , a36 out nocopy JTF_NUMBER_TABLE
161: );
162:
156: , a32 out nocopy JTF_NUMBER_TABLE
157: , a33 out nocopy JTF_DATE_TABLE
158: , a34 out nocopy JTF_NUMBER_TABLE
159: , a35 out nocopy JTF_DATE_TABLE
160: , a36 out nocopy JTF_NUMBER_TABLE
161: );
162:
163: procedure rosetta_table_copy_in_p8(t out nocopy okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_300
159: , a35 out nocopy JTF_DATE_TABLE
160: , a36 out nocopy JTF_NUMBER_TABLE
161: );
162:
163: procedure rosetta_table_copy_in_p8(t out nocopy okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_300
165: , a2 JTF_VARCHAR2_TABLE_2000
166: , a3 JTF_VARCHAR2_TABLE_300
167: , a4 JTF_VARCHAR2_TABLE_2000
166: , a3 JTF_VARCHAR2_TABLE_300
167: , a4 JTF_VARCHAR2_TABLE_2000
168: , a5 JTF_VARCHAR2_TABLE_300
169: , a6 JTF_VARCHAR2_TABLE_300
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_DATE_TABLE
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
168: , a5 JTF_VARCHAR2_TABLE_300
169: , a6 JTF_VARCHAR2_TABLE_300
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_DATE_TABLE
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: );
176: procedure rosetta_table_copy_out_p8(t okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_DATE_TABLE
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: );
176: procedure rosetta_table_copy_out_p8(t okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
177: , a1 out nocopy JTF_VARCHAR2_TABLE_300
178: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: );
176: procedure rosetta_table_copy_out_p8(t okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
177: , a1 out nocopy JTF_VARCHAR2_TABLE_300
178: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a3 out nocopy JTF_VARCHAR2_TABLE_300
180: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a3 out nocopy JTF_VARCHAR2_TABLE_300
180: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a5 out nocopy JTF_VARCHAR2_TABLE_300
182: , a6 out nocopy JTF_VARCHAR2_TABLE_300
183: , a7 out nocopy JTF_NUMBER_TABLE
184: , a8 out nocopy JTF_DATE_TABLE
185: , a9 out nocopy JTF_NUMBER_TABLE
186: , a10 out nocopy JTF_DATE_TABLE
187: , a11 out nocopy JTF_NUMBER_TABLE
181: , a5 out nocopy JTF_VARCHAR2_TABLE_300
182: , a6 out nocopy JTF_VARCHAR2_TABLE_300
183: , a7 out nocopy JTF_NUMBER_TABLE
184: , a8 out nocopy JTF_DATE_TABLE
185: , a9 out nocopy JTF_NUMBER_TABLE
186: , a10 out nocopy JTF_DATE_TABLE
187: , a11 out nocopy JTF_NUMBER_TABLE
188: );
189:
183: , a7 out nocopy JTF_NUMBER_TABLE
184: , a8 out nocopy JTF_DATE_TABLE
185: , a9 out nocopy JTF_NUMBER_TABLE
186: , a10 out nocopy JTF_DATE_TABLE
187: , a11 out nocopy JTF_NUMBER_TABLE
188: );
189:
190: procedure insert_row(p_api_version NUMBER
191: , p_init_msg_list VARCHAR2
277: , p_init_msg_list VARCHAR2
278: , x_return_status out nocopy VARCHAR2
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_VARCHAR2_TABLE_300
284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_VARCHAR2_TABLE_100
278: , x_return_status out nocopy VARCHAR2
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_VARCHAR2_TABLE_300
284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_VARCHAR2_TABLE_100
286: , p5_a5 JTF_VARCHAR2_TABLE_100
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_VARCHAR2_TABLE_300
284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_VARCHAR2_TABLE_100
286: , p5_a5 JTF_VARCHAR2_TABLE_100
287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_DATE_TABLE
289: , p5_a8 JTF_DATE_TABLE
290: , p5_a9 JTF_VARCHAR2_TABLE_2000
291: , p5_a10 JTF_VARCHAR2_TABLE_300
292: , p5_a11 JTF_VARCHAR2_TABLE_300
293: , p5_a12 JTF_NUMBER_TABLE
294: , p5_a13 JTF_VARCHAR2_TABLE_100
295: , p5_a14 JTF_VARCHAR2_TABLE_500
296: , p5_a15 JTF_VARCHAR2_TABLE_500
297: , p5_a16 JTF_VARCHAR2_TABLE_500
307: , p5_a26 JTF_VARCHAR2_TABLE_500
308: , p5_a27 JTF_VARCHAR2_TABLE_500
309: , p5_a28 JTF_VARCHAR2_TABLE_500
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p5_a31 JTF_NUMBER_TABLE
313: , p5_a32 JTF_NUMBER_TABLE
314: , p5_a33 JTF_NUMBER_TABLE
315: , p5_a34 JTF_DATE_TABLE
308: , p5_a27 JTF_VARCHAR2_TABLE_500
309: , p5_a28 JTF_VARCHAR2_TABLE_500
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p5_a31 JTF_NUMBER_TABLE
313: , p5_a32 JTF_NUMBER_TABLE
314: , p5_a33 JTF_NUMBER_TABLE
315: , p5_a34 JTF_DATE_TABLE
316: , p5_a35 JTF_NUMBER_TABLE
309: , p5_a28 JTF_VARCHAR2_TABLE_500
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p5_a31 JTF_NUMBER_TABLE
313: , p5_a32 JTF_NUMBER_TABLE
314: , p5_a33 JTF_NUMBER_TABLE
315: , p5_a34 JTF_DATE_TABLE
316: , p5_a35 JTF_NUMBER_TABLE
317: , p5_a36 JTF_DATE_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p5_a31 JTF_NUMBER_TABLE
313: , p5_a32 JTF_NUMBER_TABLE
314: , p5_a33 JTF_NUMBER_TABLE
315: , p5_a34 JTF_DATE_TABLE
316: , p5_a35 JTF_NUMBER_TABLE
317: , p5_a36 JTF_DATE_TABLE
318: , p5_a37 JTF_NUMBER_TABLE
312: , p5_a31 JTF_NUMBER_TABLE
313: , p5_a32 JTF_NUMBER_TABLE
314: , p5_a33 JTF_NUMBER_TABLE
315: , p5_a34 JTF_DATE_TABLE
316: , p5_a35 JTF_NUMBER_TABLE
317: , p5_a36 JTF_DATE_TABLE
318: , p5_a37 JTF_NUMBER_TABLE
319: , p5_a38 JTF_DATE_TABLE
320: , p5_a39 JTF_NUMBER_TABLE
314: , p5_a33 JTF_NUMBER_TABLE
315: , p5_a34 JTF_DATE_TABLE
316: , p5_a35 JTF_NUMBER_TABLE
317: , p5_a36 JTF_DATE_TABLE
318: , p5_a37 JTF_NUMBER_TABLE
319: , p5_a38 JTF_DATE_TABLE
320: , p5_a39 JTF_NUMBER_TABLE
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
316: , p5_a35 JTF_NUMBER_TABLE
317: , p5_a36 JTF_DATE_TABLE
318: , p5_a37 JTF_NUMBER_TABLE
319: , p5_a38 JTF_DATE_TABLE
320: , p5_a39 JTF_NUMBER_TABLE
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
317: , p5_a36 JTF_DATE_TABLE
318: , p5_a37 JTF_NUMBER_TABLE
319: , p5_a38 JTF_DATE_TABLE
320: , p5_a39 JTF_NUMBER_TABLE
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a37 JTF_NUMBER_TABLE
319: , p5_a38 JTF_DATE_TABLE
320: , p5_a39 JTF_NUMBER_TABLE
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
320: , p5_a39 JTF_NUMBER_TABLE
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
327: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a7 out nocopy JTF_DATE_TABLE
329: , p6_a8 out nocopy JTF_DATE_TABLE
330: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
331: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
332: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
333: , p6_a12 out nocopy JTF_NUMBER_TABLE
334: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
336: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
337: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
347: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
348: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
349: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a29 out nocopy JTF_DATE_TABLE
351: , p6_a30 out nocopy JTF_NUMBER_TABLE
352: , p6_a31 out nocopy JTF_NUMBER_TABLE
353: , p6_a32 out nocopy JTF_NUMBER_TABLE
354: , p6_a33 out nocopy JTF_NUMBER_TABLE
355: , p6_a34 out nocopy JTF_DATE_TABLE
348: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
349: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a29 out nocopy JTF_DATE_TABLE
351: , p6_a30 out nocopy JTF_NUMBER_TABLE
352: , p6_a31 out nocopy JTF_NUMBER_TABLE
353: , p6_a32 out nocopy JTF_NUMBER_TABLE
354: , p6_a33 out nocopy JTF_NUMBER_TABLE
355: , p6_a34 out nocopy JTF_DATE_TABLE
356: , p6_a35 out nocopy JTF_NUMBER_TABLE
349: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a29 out nocopy JTF_DATE_TABLE
351: , p6_a30 out nocopy JTF_NUMBER_TABLE
352: , p6_a31 out nocopy JTF_NUMBER_TABLE
353: , p6_a32 out nocopy JTF_NUMBER_TABLE
354: , p6_a33 out nocopy JTF_NUMBER_TABLE
355: , p6_a34 out nocopy JTF_DATE_TABLE
356: , p6_a35 out nocopy JTF_NUMBER_TABLE
357: , p6_a36 out nocopy JTF_DATE_TABLE
350: , p6_a29 out nocopy JTF_DATE_TABLE
351: , p6_a30 out nocopy JTF_NUMBER_TABLE
352: , p6_a31 out nocopy JTF_NUMBER_TABLE
353: , p6_a32 out nocopy JTF_NUMBER_TABLE
354: , p6_a33 out nocopy JTF_NUMBER_TABLE
355: , p6_a34 out nocopy JTF_DATE_TABLE
356: , p6_a35 out nocopy JTF_NUMBER_TABLE
357: , p6_a36 out nocopy JTF_DATE_TABLE
358: , p6_a37 out nocopy JTF_NUMBER_TABLE
352: , p6_a31 out nocopy JTF_NUMBER_TABLE
353: , p6_a32 out nocopy JTF_NUMBER_TABLE
354: , p6_a33 out nocopy JTF_NUMBER_TABLE
355: , p6_a34 out nocopy JTF_DATE_TABLE
356: , p6_a35 out nocopy JTF_NUMBER_TABLE
357: , p6_a36 out nocopy JTF_DATE_TABLE
358: , p6_a37 out nocopy JTF_NUMBER_TABLE
359: , p6_a38 out nocopy JTF_DATE_TABLE
360: , p6_a39 out nocopy JTF_NUMBER_TABLE
354: , p6_a33 out nocopy JTF_NUMBER_TABLE
355: , p6_a34 out nocopy JTF_DATE_TABLE
356: , p6_a35 out nocopy JTF_NUMBER_TABLE
357: , p6_a36 out nocopy JTF_DATE_TABLE
358: , p6_a37 out nocopy JTF_NUMBER_TABLE
359: , p6_a38 out nocopy JTF_DATE_TABLE
360: , p6_a39 out nocopy JTF_NUMBER_TABLE
361: );
362: procedure lock_row(p_api_version NUMBER
356: , p6_a35 out nocopy JTF_NUMBER_TABLE
357: , p6_a36 out nocopy JTF_DATE_TABLE
358: , p6_a37 out nocopy JTF_NUMBER_TABLE
359: , p6_a38 out nocopy JTF_DATE_TABLE
360: , p6_a39 out nocopy JTF_NUMBER_TABLE
361: );
362: procedure lock_row(p_api_version NUMBER
363: , p_init_msg_list VARCHAR2
364: , x_return_status out nocopy VARCHAR2
409: , p_init_msg_list VARCHAR2
410: , x_return_status out nocopy VARCHAR2
411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy VARCHAR2
413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_VARCHAR2_TABLE_300
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_VARCHAR2_TABLE_100
410: , x_return_status out nocopy VARCHAR2
411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy VARCHAR2
413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_VARCHAR2_TABLE_300
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_VARCHAR2_TABLE_100
418: , p5_a5 JTF_VARCHAR2_TABLE_100
412: , x_msg_data out nocopy VARCHAR2
413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_VARCHAR2_TABLE_300
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_VARCHAR2_TABLE_100
418: , p5_a5 JTF_VARCHAR2_TABLE_100
419: , p5_a6 JTF_VARCHAR2_TABLE_100
420: , p5_a7 JTF_DATE_TABLE
421: , p5_a8 JTF_DATE_TABLE
422: , p5_a9 JTF_VARCHAR2_TABLE_2000
423: , p5_a10 JTF_VARCHAR2_TABLE_300
424: , p5_a11 JTF_VARCHAR2_TABLE_300
425: , p5_a12 JTF_NUMBER_TABLE
426: , p5_a13 JTF_VARCHAR2_TABLE_100
427: , p5_a14 JTF_VARCHAR2_TABLE_500
428: , p5_a15 JTF_VARCHAR2_TABLE_500
429: , p5_a16 JTF_VARCHAR2_TABLE_500
439: , p5_a26 JTF_VARCHAR2_TABLE_500
440: , p5_a27 JTF_VARCHAR2_TABLE_500
441: , p5_a28 JTF_VARCHAR2_TABLE_500
442: , p5_a29 JTF_DATE_TABLE
443: , p5_a30 JTF_NUMBER_TABLE
444: , p5_a31 JTF_NUMBER_TABLE
445: , p5_a32 JTF_NUMBER_TABLE
446: , p5_a33 JTF_NUMBER_TABLE
447: , p5_a34 JTF_DATE_TABLE
440: , p5_a27 JTF_VARCHAR2_TABLE_500
441: , p5_a28 JTF_VARCHAR2_TABLE_500
442: , p5_a29 JTF_DATE_TABLE
443: , p5_a30 JTF_NUMBER_TABLE
444: , p5_a31 JTF_NUMBER_TABLE
445: , p5_a32 JTF_NUMBER_TABLE
446: , p5_a33 JTF_NUMBER_TABLE
447: , p5_a34 JTF_DATE_TABLE
448: , p5_a35 JTF_NUMBER_TABLE
441: , p5_a28 JTF_VARCHAR2_TABLE_500
442: , p5_a29 JTF_DATE_TABLE
443: , p5_a30 JTF_NUMBER_TABLE
444: , p5_a31 JTF_NUMBER_TABLE
445: , p5_a32 JTF_NUMBER_TABLE
446: , p5_a33 JTF_NUMBER_TABLE
447: , p5_a34 JTF_DATE_TABLE
448: , p5_a35 JTF_NUMBER_TABLE
449: , p5_a36 JTF_DATE_TABLE
442: , p5_a29 JTF_DATE_TABLE
443: , p5_a30 JTF_NUMBER_TABLE
444: , p5_a31 JTF_NUMBER_TABLE
445: , p5_a32 JTF_NUMBER_TABLE
446: , p5_a33 JTF_NUMBER_TABLE
447: , p5_a34 JTF_DATE_TABLE
448: , p5_a35 JTF_NUMBER_TABLE
449: , p5_a36 JTF_DATE_TABLE
450: , p5_a37 JTF_NUMBER_TABLE
444: , p5_a31 JTF_NUMBER_TABLE
445: , p5_a32 JTF_NUMBER_TABLE
446: , p5_a33 JTF_NUMBER_TABLE
447: , p5_a34 JTF_DATE_TABLE
448: , p5_a35 JTF_NUMBER_TABLE
449: , p5_a36 JTF_DATE_TABLE
450: , p5_a37 JTF_NUMBER_TABLE
451: , p5_a38 JTF_DATE_TABLE
452: , p5_a39 JTF_NUMBER_TABLE
446: , p5_a33 JTF_NUMBER_TABLE
447: , p5_a34 JTF_DATE_TABLE
448: , p5_a35 JTF_NUMBER_TABLE
449: , p5_a36 JTF_DATE_TABLE
450: , p5_a37 JTF_NUMBER_TABLE
451: , p5_a38 JTF_DATE_TABLE
452: , p5_a39 JTF_NUMBER_TABLE
453: );
454: procedure update_row(p_api_version NUMBER
448: , p5_a35 JTF_NUMBER_TABLE
449: , p5_a36 JTF_DATE_TABLE
450: , p5_a37 JTF_NUMBER_TABLE
451: , p5_a38 JTF_DATE_TABLE
452: , p5_a39 JTF_NUMBER_TABLE
453: );
454: procedure update_row(p_api_version NUMBER
455: , p_init_msg_list VARCHAR2
456: , x_return_status out nocopy VARCHAR2
541: , p_init_msg_list VARCHAR2
542: , x_return_status out nocopy VARCHAR2
543: , x_msg_count out nocopy NUMBER
544: , x_msg_data out nocopy VARCHAR2
545: , p5_a0 JTF_NUMBER_TABLE
546: , p5_a1 JTF_NUMBER_TABLE
547: , p5_a2 JTF_VARCHAR2_TABLE_300
548: , p5_a3 JTF_NUMBER_TABLE
549: , p5_a4 JTF_VARCHAR2_TABLE_100
542: , x_return_status out nocopy VARCHAR2
543: , x_msg_count out nocopy NUMBER
544: , x_msg_data out nocopy VARCHAR2
545: , p5_a0 JTF_NUMBER_TABLE
546: , p5_a1 JTF_NUMBER_TABLE
547: , p5_a2 JTF_VARCHAR2_TABLE_300
548: , p5_a3 JTF_NUMBER_TABLE
549: , p5_a4 JTF_VARCHAR2_TABLE_100
550: , p5_a5 JTF_VARCHAR2_TABLE_100
544: , x_msg_data out nocopy VARCHAR2
545: , p5_a0 JTF_NUMBER_TABLE
546: , p5_a1 JTF_NUMBER_TABLE
547: , p5_a2 JTF_VARCHAR2_TABLE_300
548: , p5_a3 JTF_NUMBER_TABLE
549: , p5_a4 JTF_VARCHAR2_TABLE_100
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
552: , p5_a7 JTF_DATE_TABLE
553: , p5_a8 JTF_DATE_TABLE
554: , p5_a9 JTF_VARCHAR2_TABLE_2000
555: , p5_a10 JTF_VARCHAR2_TABLE_300
556: , p5_a11 JTF_VARCHAR2_TABLE_300
557: , p5_a12 JTF_NUMBER_TABLE
558: , p5_a13 JTF_VARCHAR2_TABLE_100
559: , p5_a14 JTF_VARCHAR2_TABLE_500
560: , p5_a15 JTF_VARCHAR2_TABLE_500
561: , p5_a16 JTF_VARCHAR2_TABLE_500
571: , p5_a26 JTF_VARCHAR2_TABLE_500
572: , p5_a27 JTF_VARCHAR2_TABLE_500
573: , p5_a28 JTF_VARCHAR2_TABLE_500
574: , p5_a29 JTF_DATE_TABLE
575: , p5_a30 JTF_NUMBER_TABLE
576: , p5_a31 JTF_NUMBER_TABLE
577: , p5_a32 JTF_NUMBER_TABLE
578: , p5_a33 JTF_NUMBER_TABLE
579: , p5_a34 JTF_DATE_TABLE
572: , p5_a27 JTF_VARCHAR2_TABLE_500
573: , p5_a28 JTF_VARCHAR2_TABLE_500
574: , p5_a29 JTF_DATE_TABLE
575: , p5_a30 JTF_NUMBER_TABLE
576: , p5_a31 JTF_NUMBER_TABLE
577: , p5_a32 JTF_NUMBER_TABLE
578: , p5_a33 JTF_NUMBER_TABLE
579: , p5_a34 JTF_DATE_TABLE
580: , p5_a35 JTF_NUMBER_TABLE
573: , p5_a28 JTF_VARCHAR2_TABLE_500
574: , p5_a29 JTF_DATE_TABLE
575: , p5_a30 JTF_NUMBER_TABLE
576: , p5_a31 JTF_NUMBER_TABLE
577: , p5_a32 JTF_NUMBER_TABLE
578: , p5_a33 JTF_NUMBER_TABLE
579: , p5_a34 JTF_DATE_TABLE
580: , p5_a35 JTF_NUMBER_TABLE
581: , p5_a36 JTF_DATE_TABLE
574: , p5_a29 JTF_DATE_TABLE
575: , p5_a30 JTF_NUMBER_TABLE
576: , p5_a31 JTF_NUMBER_TABLE
577: , p5_a32 JTF_NUMBER_TABLE
578: , p5_a33 JTF_NUMBER_TABLE
579: , p5_a34 JTF_DATE_TABLE
580: , p5_a35 JTF_NUMBER_TABLE
581: , p5_a36 JTF_DATE_TABLE
582: , p5_a37 JTF_NUMBER_TABLE
576: , p5_a31 JTF_NUMBER_TABLE
577: , p5_a32 JTF_NUMBER_TABLE
578: , p5_a33 JTF_NUMBER_TABLE
579: , p5_a34 JTF_DATE_TABLE
580: , p5_a35 JTF_NUMBER_TABLE
581: , p5_a36 JTF_DATE_TABLE
582: , p5_a37 JTF_NUMBER_TABLE
583: , p5_a38 JTF_DATE_TABLE
584: , p5_a39 JTF_NUMBER_TABLE
578: , p5_a33 JTF_NUMBER_TABLE
579: , p5_a34 JTF_DATE_TABLE
580: , p5_a35 JTF_NUMBER_TABLE
581: , p5_a36 JTF_DATE_TABLE
582: , p5_a37 JTF_NUMBER_TABLE
583: , p5_a38 JTF_DATE_TABLE
584: , p5_a39 JTF_NUMBER_TABLE
585: , p6_a0 out nocopy JTF_NUMBER_TABLE
586: , p6_a1 out nocopy JTF_NUMBER_TABLE
580: , p5_a35 JTF_NUMBER_TABLE
581: , p5_a36 JTF_DATE_TABLE
582: , p5_a37 JTF_NUMBER_TABLE
583: , p5_a38 JTF_DATE_TABLE
584: , p5_a39 JTF_NUMBER_TABLE
585: , p6_a0 out nocopy JTF_NUMBER_TABLE
586: , p6_a1 out nocopy JTF_NUMBER_TABLE
587: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
588: , p6_a3 out nocopy JTF_NUMBER_TABLE
581: , p5_a36 JTF_DATE_TABLE
582: , p5_a37 JTF_NUMBER_TABLE
583: , p5_a38 JTF_DATE_TABLE
584: , p5_a39 JTF_NUMBER_TABLE
585: , p6_a0 out nocopy JTF_NUMBER_TABLE
586: , p6_a1 out nocopy JTF_NUMBER_TABLE
587: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
588: , p6_a3 out nocopy JTF_NUMBER_TABLE
589: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
582: , p5_a37 JTF_NUMBER_TABLE
583: , p5_a38 JTF_DATE_TABLE
584: , p5_a39 JTF_NUMBER_TABLE
585: , p6_a0 out nocopy JTF_NUMBER_TABLE
586: , p6_a1 out nocopy JTF_NUMBER_TABLE
587: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
588: , p6_a3 out nocopy JTF_NUMBER_TABLE
589: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
584: , p5_a39 JTF_NUMBER_TABLE
585: , p6_a0 out nocopy JTF_NUMBER_TABLE
586: , p6_a1 out nocopy JTF_NUMBER_TABLE
587: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
588: , p6_a3 out nocopy JTF_NUMBER_TABLE
589: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
591: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a7 out nocopy JTF_DATE_TABLE
593: , p6_a8 out nocopy JTF_DATE_TABLE
594: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
595: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
596: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
597: , p6_a12 out nocopy JTF_NUMBER_TABLE
598: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
599: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
600: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
601: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
611: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
612: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
613: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
614: , p6_a29 out nocopy JTF_DATE_TABLE
615: , p6_a30 out nocopy JTF_NUMBER_TABLE
616: , p6_a31 out nocopy JTF_NUMBER_TABLE
617: , p6_a32 out nocopy JTF_NUMBER_TABLE
618: , p6_a33 out nocopy JTF_NUMBER_TABLE
619: , p6_a34 out nocopy JTF_DATE_TABLE
612: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
613: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
614: , p6_a29 out nocopy JTF_DATE_TABLE
615: , p6_a30 out nocopy JTF_NUMBER_TABLE
616: , p6_a31 out nocopy JTF_NUMBER_TABLE
617: , p6_a32 out nocopy JTF_NUMBER_TABLE
618: , p6_a33 out nocopy JTF_NUMBER_TABLE
619: , p6_a34 out nocopy JTF_DATE_TABLE
620: , p6_a35 out nocopy JTF_NUMBER_TABLE
613: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
614: , p6_a29 out nocopy JTF_DATE_TABLE
615: , p6_a30 out nocopy JTF_NUMBER_TABLE
616: , p6_a31 out nocopy JTF_NUMBER_TABLE
617: , p6_a32 out nocopy JTF_NUMBER_TABLE
618: , p6_a33 out nocopy JTF_NUMBER_TABLE
619: , p6_a34 out nocopy JTF_DATE_TABLE
620: , p6_a35 out nocopy JTF_NUMBER_TABLE
621: , p6_a36 out nocopy JTF_DATE_TABLE
614: , p6_a29 out nocopy JTF_DATE_TABLE
615: , p6_a30 out nocopy JTF_NUMBER_TABLE
616: , p6_a31 out nocopy JTF_NUMBER_TABLE
617: , p6_a32 out nocopy JTF_NUMBER_TABLE
618: , p6_a33 out nocopy JTF_NUMBER_TABLE
619: , p6_a34 out nocopy JTF_DATE_TABLE
620: , p6_a35 out nocopy JTF_NUMBER_TABLE
621: , p6_a36 out nocopy JTF_DATE_TABLE
622: , p6_a37 out nocopy JTF_NUMBER_TABLE
616: , p6_a31 out nocopy JTF_NUMBER_TABLE
617: , p6_a32 out nocopy JTF_NUMBER_TABLE
618: , p6_a33 out nocopy JTF_NUMBER_TABLE
619: , p6_a34 out nocopy JTF_DATE_TABLE
620: , p6_a35 out nocopy JTF_NUMBER_TABLE
621: , p6_a36 out nocopy JTF_DATE_TABLE
622: , p6_a37 out nocopy JTF_NUMBER_TABLE
623: , p6_a38 out nocopy JTF_DATE_TABLE
624: , p6_a39 out nocopy JTF_NUMBER_TABLE
618: , p6_a33 out nocopy JTF_NUMBER_TABLE
619: , p6_a34 out nocopy JTF_DATE_TABLE
620: , p6_a35 out nocopy JTF_NUMBER_TABLE
621: , p6_a36 out nocopy JTF_DATE_TABLE
622: , p6_a37 out nocopy JTF_NUMBER_TABLE
623: , p6_a38 out nocopy JTF_DATE_TABLE
624: , p6_a39 out nocopy JTF_NUMBER_TABLE
625: );
626: procedure delete_row(p_api_version NUMBER
620: , p6_a35 out nocopy JTF_NUMBER_TABLE
621: , p6_a36 out nocopy JTF_DATE_TABLE
622: , p6_a37 out nocopy JTF_NUMBER_TABLE
623: , p6_a38 out nocopy JTF_DATE_TABLE
624: , p6_a39 out nocopy JTF_NUMBER_TABLE
625: );
626: procedure delete_row(p_api_version NUMBER
627: , p_init_msg_list VARCHAR2
628: , x_return_status out nocopy VARCHAR2
673: , p_init_msg_list VARCHAR2
674: , x_return_status out nocopy VARCHAR2
675: , x_msg_count out nocopy NUMBER
676: , x_msg_data out nocopy VARCHAR2
677: , p5_a0 JTF_NUMBER_TABLE
678: , p5_a1 JTF_NUMBER_TABLE
679: , p5_a2 JTF_VARCHAR2_TABLE_300
680: , p5_a3 JTF_NUMBER_TABLE
681: , p5_a4 JTF_VARCHAR2_TABLE_100
674: , x_return_status out nocopy VARCHAR2
675: , x_msg_count out nocopy NUMBER
676: , x_msg_data out nocopy VARCHAR2
677: , p5_a0 JTF_NUMBER_TABLE
678: , p5_a1 JTF_NUMBER_TABLE
679: , p5_a2 JTF_VARCHAR2_TABLE_300
680: , p5_a3 JTF_NUMBER_TABLE
681: , p5_a4 JTF_VARCHAR2_TABLE_100
682: , p5_a5 JTF_VARCHAR2_TABLE_100
676: , x_msg_data out nocopy VARCHAR2
677: , p5_a0 JTF_NUMBER_TABLE
678: , p5_a1 JTF_NUMBER_TABLE
679: , p5_a2 JTF_VARCHAR2_TABLE_300
680: , p5_a3 JTF_NUMBER_TABLE
681: , p5_a4 JTF_VARCHAR2_TABLE_100
682: , p5_a5 JTF_VARCHAR2_TABLE_100
683: , p5_a6 JTF_VARCHAR2_TABLE_100
684: , p5_a7 JTF_DATE_TABLE
685: , p5_a8 JTF_DATE_TABLE
686: , p5_a9 JTF_VARCHAR2_TABLE_2000
687: , p5_a10 JTF_VARCHAR2_TABLE_300
688: , p5_a11 JTF_VARCHAR2_TABLE_300
689: , p5_a12 JTF_NUMBER_TABLE
690: , p5_a13 JTF_VARCHAR2_TABLE_100
691: , p5_a14 JTF_VARCHAR2_TABLE_500
692: , p5_a15 JTF_VARCHAR2_TABLE_500
693: , p5_a16 JTF_VARCHAR2_TABLE_500
703: , p5_a26 JTF_VARCHAR2_TABLE_500
704: , p5_a27 JTF_VARCHAR2_TABLE_500
705: , p5_a28 JTF_VARCHAR2_TABLE_500
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p5_a31 JTF_NUMBER_TABLE
709: , p5_a32 JTF_NUMBER_TABLE
710: , p5_a33 JTF_NUMBER_TABLE
711: , p5_a34 JTF_DATE_TABLE
704: , p5_a27 JTF_VARCHAR2_TABLE_500
705: , p5_a28 JTF_VARCHAR2_TABLE_500
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p5_a31 JTF_NUMBER_TABLE
709: , p5_a32 JTF_NUMBER_TABLE
710: , p5_a33 JTF_NUMBER_TABLE
711: , p5_a34 JTF_DATE_TABLE
712: , p5_a35 JTF_NUMBER_TABLE
705: , p5_a28 JTF_VARCHAR2_TABLE_500
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p5_a31 JTF_NUMBER_TABLE
709: , p5_a32 JTF_NUMBER_TABLE
710: , p5_a33 JTF_NUMBER_TABLE
711: , p5_a34 JTF_DATE_TABLE
712: , p5_a35 JTF_NUMBER_TABLE
713: , p5_a36 JTF_DATE_TABLE
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p5_a31 JTF_NUMBER_TABLE
709: , p5_a32 JTF_NUMBER_TABLE
710: , p5_a33 JTF_NUMBER_TABLE
711: , p5_a34 JTF_DATE_TABLE
712: , p5_a35 JTF_NUMBER_TABLE
713: , p5_a36 JTF_DATE_TABLE
714: , p5_a37 JTF_NUMBER_TABLE
708: , p5_a31 JTF_NUMBER_TABLE
709: , p5_a32 JTF_NUMBER_TABLE
710: , p5_a33 JTF_NUMBER_TABLE
711: , p5_a34 JTF_DATE_TABLE
712: , p5_a35 JTF_NUMBER_TABLE
713: , p5_a36 JTF_DATE_TABLE
714: , p5_a37 JTF_NUMBER_TABLE
715: , p5_a38 JTF_DATE_TABLE
716: , p5_a39 JTF_NUMBER_TABLE
710: , p5_a33 JTF_NUMBER_TABLE
711: , p5_a34 JTF_DATE_TABLE
712: , p5_a35 JTF_NUMBER_TABLE
713: , p5_a36 JTF_DATE_TABLE
714: , p5_a37 JTF_NUMBER_TABLE
715: , p5_a38 JTF_DATE_TABLE
716: , p5_a39 JTF_NUMBER_TABLE
717: );
718: procedure validate_row(p_api_version NUMBER
712: , p5_a35 JTF_NUMBER_TABLE
713: , p5_a36 JTF_DATE_TABLE
714: , p5_a37 JTF_NUMBER_TABLE
715: , p5_a38 JTF_DATE_TABLE
716: , p5_a39 JTF_NUMBER_TABLE
717: );
718: procedure validate_row(p_api_version NUMBER
719: , p_init_msg_list VARCHAR2
720: , x_return_status out nocopy VARCHAR2
765: , p_init_msg_list VARCHAR2
766: , x_return_status out nocopy VARCHAR2
767: , x_msg_count out nocopy NUMBER
768: , x_msg_data out nocopy VARCHAR2
769: , p5_a0 JTF_NUMBER_TABLE
770: , p5_a1 JTF_NUMBER_TABLE
771: , p5_a2 JTF_VARCHAR2_TABLE_300
772: , p5_a3 JTF_NUMBER_TABLE
773: , p5_a4 JTF_VARCHAR2_TABLE_100
766: , x_return_status out nocopy VARCHAR2
767: , x_msg_count out nocopy NUMBER
768: , x_msg_data out nocopy VARCHAR2
769: , p5_a0 JTF_NUMBER_TABLE
770: , p5_a1 JTF_NUMBER_TABLE
771: , p5_a2 JTF_VARCHAR2_TABLE_300
772: , p5_a3 JTF_NUMBER_TABLE
773: , p5_a4 JTF_VARCHAR2_TABLE_100
774: , p5_a5 JTF_VARCHAR2_TABLE_100
768: , x_msg_data out nocopy VARCHAR2
769: , p5_a0 JTF_NUMBER_TABLE
770: , p5_a1 JTF_NUMBER_TABLE
771: , p5_a2 JTF_VARCHAR2_TABLE_300
772: , p5_a3 JTF_NUMBER_TABLE
773: , p5_a4 JTF_VARCHAR2_TABLE_100
774: , p5_a5 JTF_VARCHAR2_TABLE_100
775: , p5_a6 JTF_VARCHAR2_TABLE_100
776: , p5_a7 JTF_DATE_TABLE
777: , p5_a8 JTF_DATE_TABLE
778: , p5_a9 JTF_VARCHAR2_TABLE_2000
779: , p5_a10 JTF_VARCHAR2_TABLE_300
780: , p5_a11 JTF_VARCHAR2_TABLE_300
781: , p5_a12 JTF_NUMBER_TABLE
782: , p5_a13 JTF_VARCHAR2_TABLE_100
783: , p5_a14 JTF_VARCHAR2_TABLE_500
784: , p5_a15 JTF_VARCHAR2_TABLE_500
785: , p5_a16 JTF_VARCHAR2_TABLE_500
795: , p5_a26 JTF_VARCHAR2_TABLE_500
796: , p5_a27 JTF_VARCHAR2_TABLE_500
797: , p5_a28 JTF_VARCHAR2_TABLE_500
798: , p5_a29 JTF_DATE_TABLE
799: , p5_a30 JTF_NUMBER_TABLE
800: , p5_a31 JTF_NUMBER_TABLE
801: , p5_a32 JTF_NUMBER_TABLE
802: , p5_a33 JTF_NUMBER_TABLE
803: , p5_a34 JTF_DATE_TABLE
796: , p5_a27 JTF_VARCHAR2_TABLE_500
797: , p5_a28 JTF_VARCHAR2_TABLE_500
798: , p5_a29 JTF_DATE_TABLE
799: , p5_a30 JTF_NUMBER_TABLE
800: , p5_a31 JTF_NUMBER_TABLE
801: , p5_a32 JTF_NUMBER_TABLE
802: , p5_a33 JTF_NUMBER_TABLE
803: , p5_a34 JTF_DATE_TABLE
804: , p5_a35 JTF_NUMBER_TABLE
797: , p5_a28 JTF_VARCHAR2_TABLE_500
798: , p5_a29 JTF_DATE_TABLE
799: , p5_a30 JTF_NUMBER_TABLE
800: , p5_a31 JTF_NUMBER_TABLE
801: , p5_a32 JTF_NUMBER_TABLE
802: , p5_a33 JTF_NUMBER_TABLE
803: , p5_a34 JTF_DATE_TABLE
804: , p5_a35 JTF_NUMBER_TABLE
805: , p5_a36 JTF_DATE_TABLE
798: , p5_a29 JTF_DATE_TABLE
799: , p5_a30 JTF_NUMBER_TABLE
800: , p5_a31 JTF_NUMBER_TABLE
801: , p5_a32 JTF_NUMBER_TABLE
802: , p5_a33 JTF_NUMBER_TABLE
803: , p5_a34 JTF_DATE_TABLE
804: , p5_a35 JTF_NUMBER_TABLE
805: , p5_a36 JTF_DATE_TABLE
806: , p5_a37 JTF_NUMBER_TABLE
800: , p5_a31 JTF_NUMBER_TABLE
801: , p5_a32 JTF_NUMBER_TABLE
802: , p5_a33 JTF_NUMBER_TABLE
803: , p5_a34 JTF_DATE_TABLE
804: , p5_a35 JTF_NUMBER_TABLE
805: , p5_a36 JTF_DATE_TABLE
806: , p5_a37 JTF_NUMBER_TABLE
807: , p5_a38 JTF_DATE_TABLE
808: , p5_a39 JTF_NUMBER_TABLE
802: , p5_a33 JTF_NUMBER_TABLE
803: , p5_a34 JTF_DATE_TABLE
804: , p5_a35 JTF_NUMBER_TABLE
805: , p5_a36 JTF_DATE_TABLE
806: , p5_a37 JTF_NUMBER_TABLE
807: , p5_a38 JTF_DATE_TABLE
808: , p5_a39 JTF_NUMBER_TABLE
809: );
810: end okl_clm_pvt_w;
804: , p5_a35 JTF_NUMBER_TABLE
805: , p5_a36 JTF_DATE_TABLE
806: , p5_a37 JTF_NUMBER_TABLE
807: , p5_a38 JTF_DATE_TABLE
808: , p5_a39 JTF_NUMBER_TABLE
809: );
810: end okl_clm_pvt_w;