2: /* $Header: OKLIREPS.pls 120.0 2007/12/10 18:28:01 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_2000
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: );
24: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: );
24: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_VARCHAR2_TABLE_300
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: );
24: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_VARCHAR2_TABLE_300
26: , a2 out nocopy JTF_NUMBER_TABLE
23: );
24: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_VARCHAR2_TABLE_300
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_VARCHAR2_TABLE_300
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
32: , a8 out nocopy JTF_VARCHAR2_TABLE_100
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
32: , a8 out nocopy JTF_VARCHAR2_TABLE_100
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_DATE_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
32: , a8 out nocopy JTF_VARCHAR2_TABLE_100
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_DATE_TABLE
35: , a11 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_VARCHAR2_TABLE_100
32: , a8 out nocopy JTF_VARCHAR2_TABLE_100
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_DATE_TABLE
35: , a11 out nocopy JTF_DATE_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_DATE_TABLE
40: , a16 out nocopy JTF_NUMBER_TABLE
41: , a17 out nocopy JTF_VARCHAR2_TABLE_100
42: , a18 out nocopy JTF_VARCHAR2_TABLE_100
43: , a19 out nocopy JTF_VARCHAR2_TABLE_100
44: );
45:
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_DATE_TABLE
40: , a16 out nocopy JTF_NUMBER_TABLE
41: , a17 out nocopy JTF_VARCHAR2_TABLE_100
42: , a18 out nocopy JTF_VARCHAR2_TABLE_100
43: , a19 out nocopy JTF_VARCHAR2_TABLE_100
44: );
45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_DATE_TABLE
40: , a16 out nocopy JTF_NUMBER_TABLE
41: , a17 out nocopy JTF_VARCHAR2_TABLE_100
42: , a18 out nocopy JTF_VARCHAR2_TABLE_100
43: , a19 out nocopy JTF_VARCHAR2_TABLE_100
44: );
45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_VARCHAR2_TABLE_300
45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_VARCHAR2_TABLE_300
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_NUMBER_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_DATE_TABLE
47: , a1 JTF_VARCHAR2_TABLE_300
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_NUMBER_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_DATE_TABLE
54: , a8 JTF_VARCHAR2_TABLE_100
55: , a9 JTF_VARCHAR2_TABLE_100
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_NUMBER_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_DATE_TABLE
54: , a8 JTF_VARCHAR2_TABLE_100
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_DATE_TABLE
50: , a4 JTF_NUMBER_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_DATE_TABLE
54: , a8 JTF_VARCHAR2_TABLE_100
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_DATE_TABLE
57: , a11 JTF_NUMBER_TABLE
58: , a12 JTF_DATE_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_DATE_TABLE
54: , a8 JTF_VARCHAR2_TABLE_100
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_DATE_TABLE
57: , a11 JTF_NUMBER_TABLE
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_NUMBER_TABLE
62: );
63: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_300
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_DATE_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_300
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_DATE_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_DATE_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_DATE_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_DATE_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: , a12 out nocopy JTF_DATE_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_DATE_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: , a12 out nocopy JTF_DATE_TABLE
76: , a13 out nocopy JTF_NUMBER_TABLE
78: , a15 out nocopy JTF_NUMBER_TABLE
79: );
80:
81: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_VARCHAR2_TABLE_100
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_300
86: , a5 JTF_VARCHAR2_TABLE_2000
79: );
80:
81: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_VARCHAR2_TABLE_100
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_300
86: , a5 JTF_VARCHAR2_TABLE_2000
87: , a6 JTF_NUMBER_TABLE
80:
81: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_VARCHAR2_TABLE_100
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_300
86: , a5 JTF_VARCHAR2_TABLE_2000
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_DATE_TABLE
90: , a9 JTF_DATE_TABLE
91: , a10 JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_300
98: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
91: , a10 JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_300
98: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a6 out nocopy JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_300
98: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a6 out nocopy JTF_NUMBER_TABLE
100: , a7 out nocopy JTF_DATE_TABLE
156: , x_msg_data out nocopy VARCHAR2
157: , p5_a0 JTF_NUMBER_TABLE
158: , p5_a1 JTF_VARCHAR2_TABLE_300
159: , p5_a2 JTF_NUMBER_TABLE
160: , p5_a3 JTF_VARCHAR2_TABLE_100
161: , p5_a4 JTF_NUMBER_TABLE
162: , p5_a5 JTF_VARCHAR2_TABLE_100
163: , p5_a6 JTF_VARCHAR2_TABLE_100
164: , p5_a7 JTF_VARCHAR2_TABLE_100
158: , p5_a1 JTF_VARCHAR2_TABLE_300
159: , p5_a2 JTF_NUMBER_TABLE
160: , p5_a3 JTF_VARCHAR2_TABLE_100
161: , p5_a4 JTF_NUMBER_TABLE
162: , p5_a5 JTF_VARCHAR2_TABLE_100
163: , p5_a6 JTF_VARCHAR2_TABLE_100
164: , p5_a7 JTF_VARCHAR2_TABLE_100
165: , p5_a8 JTF_VARCHAR2_TABLE_100
166: , p5_a9 JTF_VARCHAR2_TABLE_2000
159: , p5_a2 JTF_NUMBER_TABLE
160: , p5_a3 JTF_VARCHAR2_TABLE_100
161: , p5_a4 JTF_NUMBER_TABLE
162: , p5_a5 JTF_VARCHAR2_TABLE_100
163: , p5_a6 JTF_VARCHAR2_TABLE_100
164: , p5_a7 JTF_VARCHAR2_TABLE_100
165: , p5_a8 JTF_VARCHAR2_TABLE_100
166: , p5_a9 JTF_VARCHAR2_TABLE_2000
167: , p5_a10 JTF_DATE_TABLE
160: , p5_a3 JTF_VARCHAR2_TABLE_100
161: , p5_a4 JTF_NUMBER_TABLE
162: , p5_a5 JTF_VARCHAR2_TABLE_100
163: , p5_a6 JTF_VARCHAR2_TABLE_100
164: , p5_a7 JTF_VARCHAR2_TABLE_100
165: , p5_a8 JTF_VARCHAR2_TABLE_100
166: , p5_a9 JTF_VARCHAR2_TABLE_2000
167: , p5_a10 JTF_DATE_TABLE
168: , p5_a11 JTF_DATE_TABLE
161: , p5_a4 JTF_NUMBER_TABLE
162: , p5_a5 JTF_VARCHAR2_TABLE_100
163: , p5_a6 JTF_VARCHAR2_TABLE_100
164: , p5_a7 JTF_VARCHAR2_TABLE_100
165: , p5_a8 JTF_VARCHAR2_TABLE_100
166: , p5_a9 JTF_VARCHAR2_TABLE_2000
167: , p5_a10 JTF_DATE_TABLE
168: , p5_a11 JTF_DATE_TABLE
169: , p5_a12 JTF_NUMBER_TABLE
170: , p5_a13 JTF_DATE_TABLE
171: , p5_a14 JTF_NUMBER_TABLE
172: , p5_a15 JTF_DATE_TABLE
173: , p5_a16 JTF_NUMBER_TABLE
174: , p5_a17 JTF_VARCHAR2_TABLE_100
175: , p5_a18 JTF_VARCHAR2_TABLE_100
176: , p5_a19 JTF_VARCHAR2_TABLE_100
177: , p6_a0 out nocopy JTF_NUMBER_TABLE
178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
171: , p5_a14 JTF_NUMBER_TABLE
172: , p5_a15 JTF_DATE_TABLE
173: , p5_a16 JTF_NUMBER_TABLE
174: , p5_a17 JTF_VARCHAR2_TABLE_100
175: , p5_a18 JTF_VARCHAR2_TABLE_100
176: , p5_a19 JTF_VARCHAR2_TABLE_100
177: , p6_a0 out nocopy JTF_NUMBER_TABLE
178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
179: , p6_a2 out nocopy JTF_NUMBER_TABLE
172: , p5_a15 JTF_DATE_TABLE
173: , p5_a16 JTF_NUMBER_TABLE
174: , p5_a17 JTF_VARCHAR2_TABLE_100
175: , p5_a18 JTF_VARCHAR2_TABLE_100
176: , p5_a19 JTF_VARCHAR2_TABLE_100
177: , p6_a0 out nocopy JTF_NUMBER_TABLE
178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
179: , p6_a2 out nocopy JTF_NUMBER_TABLE
180: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
176: , p5_a19 JTF_VARCHAR2_TABLE_100
177: , p6_a0 out nocopy JTF_NUMBER_TABLE
178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
179: , p6_a2 out nocopy JTF_NUMBER_TABLE
180: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a4 out nocopy JTF_NUMBER_TABLE
182: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
179: , p6_a2 out nocopy JTF_NUMBER_TABLE
180: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a4 out nocopy JTF_NUMBER_TABLE
182: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
179: , p6_a2 out nocopy JTF_NUMBER_TABLE
180: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a4 out nocopy JTF_NUMBER_TABLE
182: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
187: , p6_a10 out nocopy JTF_DATE_TABLE
180: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a4 out nocopy JTF_NUMBER_TABLE
182: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
187: , p6_a10 out nocopy JTF_DATE_TABLE
188: , p6_a11 out nocopy JTF_DATE_TABLE
181: , p6_a4 out nocopy JTF_NUMBER_TABLE
182: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
187: , p6_a10 out nocopy JTF_DATE_TABLE
188: , p6_a11 out nocopy JTF_DATE_TABLE
189: , p6_a12 out nocopy JTF_NUMBER_TABLE
190: , p6_a13 out nocopy JTF_DATE_TABLE
191: , p6_a14 out nocopy JTF_NUMBER_TABLE
192: , p6_a15 out nocopy JTF_DATE_TABLE
193: , p6_a16 out nocopy JTF_NUMBER_TABLE
194: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a0 in out nocopy JTF_NUMBER_TABLE
198: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p6_a14 out nocopy JTF_NUMBER_TABLE
192: , p6_a15 out nocopy JTF_DATE_TABLE
193: , p6_a16 out nocopy JTF_NUMBER_TABLE
194: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a0 in out nocopy JTF_NUMBER_TABLE
198: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a2 in out nocopy JTF_NUMBER_TABLE
192: , p6_a15 out nocopy JTF_DATE_TABLE
193: , p6_a16 out nocopy JTF_NUMBER_TABLE
194: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a0 in out nocopy JTF_NUMBER_TABLE
198: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a2 in out nocopy JTF_NUMBER_TABLE
200: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
194: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a0 in out nocopy JTF_NUMBER_TABLE
198: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a2 in out nocopy JTF_NUMBER_TABLE
200: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
201: , p7_a4 in out nocopy JTF_NUMBER_TABLE
202: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
198: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a2 in out nocopy JTF_NUMBER_TABLE
200: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
201: , p7_a4 in out nocopy JTF_NUMBER_TABLE
202: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
204: );
205: procedure insert_row(p_api_version NUMBER
206: , p_init_msg_list VARCHAR2
199: , p7_a2 in out nocopy JTF_NUMBER_TABLE
200: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
201: , p7_a4 in out nocopy JTF_NUMBER_TABLE
202: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
204: );
205: procedure insert_row(p_api_version NUMBER
206: , p_init_msg_list VARCHAR2
207: , x_return_status out nocopy VARCHAR2
209: , x_msg_data out nocopy VARCHAR2
210: , p5_a0 JTF_NUMBER_TABLE
211: , p5_a1 JTF_VARCHAR2_TABLE_300
212: , p5_a2 JTF_NUMBER_TABLE
213: , p5_a3 JTF_VARCHAR2_TABLE_100
214: , p5_a4 JTF_NUMBER_TABLE
215: , p5_a5 JTF_VARCHAR2_TABLE_100
216: , p5_a6 JTF_VARCHAR2_TABLE_100
217: , p5_a7 JTF_VARCHAR2_TABLE_100
211: , p5_a1 JTF_VARCHAR2_TABLE_300
212: , p5_a2 JTF_NUMBER_TABLE
213: , p5_a3 JTF_VARCHAR2_TABLE_100
214: , p5_a4 JTF_NUMBER_TABLE
215: , p5_a5 JTF_VARCHAR2_TABLE_100
216: , p5_a6 JTF_VARCHAR2_TABLE_100
217: , p5_a7 JTF_VARCHAR2_TABLE_100
218: , p5_a8 JTF_VARCHAR2_TABLE_100
219: , p5_a9 JTF_VARCHAR2_TABLE_2000
212: , p5_a2 JTF_NUMBER_TABLE
213: , p5_a3 JTF_VARCHAR2_TABLE_100
214: , p5_a4 JTF_NUMBER_TABLE
215: , p5_a5 JTF_VARCHAR2_TABLE_100
216: , p5_a6 JTF_VARCHAR2_TABLE_100
217: , p5_a7 JTF_VARCHAR2_TABLE_100
218: , p5_a8 JTF_VARCHAR2_TABLE_100
219: , p5_a9 JTF_VARCHAR2_TABLE_2000
220: , p5_a10 JTF_DATE_TABLE
213: , p5_a3 JTF_VARCHAR2_TABLE_100
214: , p5_a4 JTF_NUMBER_TABLE
215: , p5_a5 JTF_VARCHAR2_TABLE_100
216: , p5_a6 JTF_VARCHAR2_TABLE_100
217: , p5_a7 JTF_VARCHAR2_TABLE_100
218: , p5_a8 JTF_VARCHAR2_TABLE_100
219: , p5_a9 JTF_VARCHAR2_TABLE_2000
220: , p5_a10 JTF_DATE_TABLE
221: , p5_a11 JTF_DATE_TABLE
214: , p5_a4 JTF_NUMBER_TABLE
215: , p5_a5 JTF_VARCHAR2_TABLE_100
216: , p5_a6 JTF_VARCHAR2_TABLE_100
217: , p5_a7 JTF_VARCHAR2_TABLE_100
218: , p5_a8 JTF_VARCHAR2_TABLE_100
219: , p5_a9 JTF_VARCHAR2_TABLE_2000
220: , p5_a10 JTF_DATE_TABLE
221: , p5_a11 JTF_DATE_TABLE
222: , p5_a12 JTF_NUMBER_TABLE
223: , p5_a13 JTF_DATE_TABLE
224: , p5_a14 JTF_NUMBER_TABLE
225: , p5_a15 JTF_DATE_TABLE
226: , p5_a16 JTF_NUMBER_TABLE
227: , p5_a17 JTF_VARCHAR2_TABLE_100
228: , p5_a18 JTF_VARCHAR2_TABLE_100
229: , p5_a19 JTF_VARCHAR2_TABLE_100
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
224: , p5_a14 JTF_NUMBER_TABLE
225: , p5_a15 JTF_DATE_TABLE
226: , p5_a16 JTF_NUMBER_TABLE
227: , p5_a17 JTF_VARCHAR2_TABLE_100
228: , p5_a18 JTF_VARCHAR2_TABLE_100
229: , p5_a19 JTF_VARCHAR2_TABLE_100
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
225: , p5_a15 JTF_DATE_TABLE
226: , p5_a16 JTF_NUMBER_TABLE
227: , p5_a17 JTF_VARCHAR2_TABLE_100
228: , p5_a18 JTF_VARCHAR2_TABLE_100
229: , p5_a19 JTF_VARCHAR2_TABLE_100
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
229: , p5_a19 JTF_VARCHAR2_TABLE_100
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
236: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
236: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
236: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p6_a10 out nocopy JTF_DATE_TABLE
233: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
236: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p6_a10 out nocopy JTF_DATE_TABLE
241: , p6_a11 out nocopy JTF_DATE_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
236: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
237: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p6_a10 out nocopy JTF_DATE_TABLE
241: , p6_a11 out nocopy JTF_DATE_TABLE
242: , p6_a12 out nocopy JTF_NUMBER_TABLE
243: , p6_a13 out nocopy JTF_DATE_TABLE
244: , p6_a14 out nocopy JTF_NUMBER_TABLE
245: , p6_a15 out nocopy JTF_DATE_TABLE
246: , p6_a16 out nocopy JTF_NUMBER_TABLE
247: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
250: );
251: procedure lock_row(p_api_version NUMBER
244: , p6_a14 out nocopy JTF_NUMBER_TABLE
245: , p6_a15 out nocopy JTF_DATE_TABLE
246: , p6_a16 out nocopy JTF_NUMBER_TABLE
247: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
250: );
251: procedure lock_row(p_api_version NUMBER
252: , p_init_msg_list VARCHAR2
245: , p6_a15 out nocopy JTF_DATE_TABLE
246: , p6_a16 out nocopy JTF_NUMBER_TABLE
247: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
250: );
251: procedure lock_row(p_api_version NUMBER
252: , p_init_msg_list VARCHAR2
253: , x_return_status out nocopy VARCHAR2
281: , x_msg_data out nocopy VARCHAR2
282: , p5_a0 JTF_NUMBER_TABLE
283: , p5_a1 JTF_VARCHAR2_TABLE_300
284: , p5_a2 JTF_NUMBER_TABLE
285: , p5_a3 JTF_VARCHAR2_TABLE_100
286: , p5_a4 JTF_NUMBER_TABLE
287: , p5_a5 JTF_VARCHAR2_TABLE_100
288: , p5_a6 JTF_VARCHAR2_TABLE_100
289: , p5_a7 JTF_VARCHAR2_TABLE_100
283: , p5_a1 JTF_VARCHAR2_TABLE_300
284: , p5_a2 JTF_NUMBER_TABLE
285: , p5_a3 JTF_VARCHAR2_TABLE_100
286: , p5_a4 JTF_NUMBER_TABLE
287: , p5_a5 JTF_VARCHAR2_TABLE_100
288: , p5_a6 JTF_VARCHAR2_TABLE_100
289: , p5_a7 JTF_VARCHAR2_TABLE_100
290: , p5_a8 JTF_VARCHAR2_TABLE_100
291: , p5_a9 JTF_VARCHAR2_TABLE_2000
284: , p5_a2 JTF_NUMBER_TABLE
285: , p5_a3 JTF_VARCHAR2_TABLE_100
286: , p5_a4 JTF_NUMBER_TABLE
287: , p5_a5 JTF_VARCHAR2_TABLE_100
288: , p5_a6 JTF_VARCHAR2_TABLE_100
289: , p5_a7 JTF_VARCHAR2_TABLE_100
290: , p5_a8 JTF_VARCHAR2_TABLE_100
291: , p5_a9 JTF_VARCHAR2_TABLE_2000
292: , p5_a10 JTF_DATE_TABLE
285: , p5_a3 JTF_VARCHAR2_TABLE_100
286: , p5_a4 JTF_NUMBER_TABLE
287: , p5_a5 JTF_VARCHAR2_TABLE_100
288: , p5_a6 JTF_VARCHAR2_TABLE_100
289: , p5_a7 JTF_VARCHAR2_TABLE_100
290: , p5_a8 JTF_VARCHAR2_TABLE_100
291: , p5_a9 JTF_VARCHAR2_TABLE_2000
292: , p5_a10 JTF_DATE_TABLE
293: , p5_a11 JTF_DATE_TABLE
286: , p5_a4 JTF_NUMBER_TABLE
287: , p5_a5 JTF_VARCHAR2_TABLE_100
288: , p5_a6 JTF_VARCHAR2_TABLE_100
289: , p5_a7 JTF_VARCHAR2_TABLE_100
290: , p5_a8 JTF_VARCHAR2_TABLE_100
291: , p5_a9 JTF_VARCHAR2_TABLE_2000
292: , p5_a10 JTF_DATE_TABLE
293: , p5_a11 JTF_DATE_TABLE
294: , p5_a12 JTF_NUMBER_TABLE
295: , p5_a13 JTF_DATE_TABLE
296: , p5_a14 JTF_NUMBER_TABLE
297: , p5_a15 JTF_DATE_TABLE
298: , p5_a16 JTF_NUMBER_TABLE
299: , p5_a17 JTF_VARCHAR2_TABLE_100
300: , p5_a18 JTF_VARCHAR2_TABLE_100
301: , p5_a19 JTF_VARCHAR2_TABLE_100
302: , p6_a0 in out nocopy JTF_NUMBER_TABLE
303: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p5_a14 JTF_NUMBER_TABLE
297: , p5_a15 JTF_DATE_TABLE
298: , p5_a16 JTF_NUMBER_TABLE
299: , p5_a17 JTF_VARCHAR2_TABLE_100
300: , p5_a18 JTF_VARCHAR2_TABLE_100
301: , p5_a19 JTF_VARCHAR2_TABLE_100
302: , p6_a0 in out nocopy JTF_NUMBER_TABLE
303: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a2 in out nocopy JTF_NUMBER_TABLE
297: , p5_a15 JTF_DATE_TABLE
298: , p5_a16 JTF_NUMBER_TABLE
299: , p5_a17 JTF_VARCHAR2_TABLE_100
300: , p5_a18 JTF_VARCHAR2_TABLE_100
301: , p5_a19 JTF_VARCHAR2_TABLE_100
302: , p6_a0 in out nocopy JTF_NUMBER_TABLE
303: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a2 in out nocopy JTF_NUMBER_TABLE
305: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
299: , p5_a17 JTF_VARCHAR2_TABLE_100
300: , p5_a18 JTF_VARCHAR2_TABLE_100
301: , p5_a19 JTF_VARCHAR2_TABLE_100
302: , p6_a0 in out nocopy JTF_NUMBER_TABLE
303: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a2 in out nocopy JTF_NUMBER_TABLE
305: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
306: , p6_a4 in out nocopy JTF_NUMBER_TABLE
307: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a2 in out nocopy JTF_NUMBER_TABLE
305: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
306: , p6_a4 in out nocopy JTF_NUMBER_TABLE
307: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
309: );
310: procedure lock_row(p_api_version NUMBER
311: , p_init_msg_list VARCHAR2
304: , p6_a2 in out nocopy JTF_NUMBER_TABLE
305: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
306: , p6_a4 in out nocopy JTF_NUMBER_TABLE
307: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
309: );
310: procedure lock_row(p_api_version NUMBER
311: , p_init_msg_list VARCHAR2
312: , x_return_status out nocopy VARCHAR2
314: , x_msg_data out nocopy VARCHAR2
315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_300
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_VARCHAR2_TABLE_100
321: , p5_a6 JTF_VARCHAR2_TABLE_100
322: , p5_a7 JTF_VARCHAR2_TABLE_100
316: , p5_a1 JTF_VARCHAR2_TABLE_300
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_VARCHAR2_TABLE_100
321: , p5_a6 JTF_VARCHAR2_TABLE_100
322: , p5_a7 JTF_VARCHAR2_TABLE_100
323: , p5_a8 JTF_VARCHAR2_TABLE_100
324: , p5_a9 JTF_VARCHAR2_TABLE_2000
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_VARCHAR2_TABLE_100
321: , p5_a6 JTF_VARCHAR2_TABLE_100
322: , p5_a7 JTF_VARCHAR2_TABLE_100
323: , p5_a8 JTF_VARCHAR2_TABLE_100
324: , p5_a9 JTF_VARCHAR2_TABLE_2000
325: , p5_a10 JTF_DATE_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_VARCHAR2_TABLE_100
321: , p5_a6 JTF_VARCHAR2_TABLE_100
322: , p5_a7 JTF_VARCHAR2_TABLE_100
323: , p5_a8 JTF_VARCHAR2_TABLE_100
324: , p5_a9 JTF_VARCHAR2_TABLE_2000
325: , p5_a10 JTF_DATE_TABLE
326: , p5_a11 JTF_DATE_TABLE
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_VARCHAR2_TABLE_100
321: , p5_a6 JTF_VARCHAR2_TABLE_100
322: , p5_a7 JTF_VARCHAR2_TABLE_100
323: , p5_a8 JTF_VARCHAR2_TABLE_100
324: , p5_a9 JTF_VARCHAR2_TABLE_2000
325: , p5_a10 JTF_DATE_TABLE
326: , p5_a11 JTF_DATE_TABLE
327: , p5_a12 JTF_NUMBER_TABLE
328: , p5_a13 JTF_DATE_TABLE
329: , p5_a14 JTF_NUMBER_TABLE
330: , p5_a15 JTF_DATE_TABLE
331: , p5_a16 JTF_NUMBER_TABLE
332: , p5_a17 JTF_VARCHAR2_TABLE_100
333: , p5_a18 JTF_VARCHAR2_TABLE_100
334: , p5_a19 JTF_VARCHAR2_TABLE_100
335: );
336: procedure update_row(p_api_version NUMBER
329: , p5_a14 JTF_NUMBER_TABLE
330: , p5_a15 JTF_DATE_TABLE
331: , p5_a16 JTF_NUMBER_TABLE
332: , p5_a17 JTF_VARCHAR2_TABLE_100
333: , p5_a18 JTF_VARCHAR2_TABLE_100
334: , p5_a19 JTF_VARCHAR2_TABLE_100
335: );
336: procedure update_row(p_api_version NUMBER
337: , p_init_msg_list VARCHAR2
330: , p5_a15 JTF_DATE_TABLE
331: , p5_a16 JTF_NUMBER_TABLE
332: , p5_a17 JTF_VARCHAR2_TABLE_100
333: , p5_a18 JTF_VARCHAR2_TABLE_100
334: , p5_a19 JTF_VARCHAR2_TABLE_100
335: );
336: procedure update_row(p_api_version NUMBER
337: , p_init_msg_list VARCHAR2
338: , x_return_status out nocopy VARCHAR2
386: , x_msg_data out nocopy VARCHAR2
387: , p5_a0 JTF_NUMBER_TABLE
388: , p5_a1 JTF_VARCHAR2_TABLE_300
389: , p5_a2 JTF_NUMBER_TABLE
390: , p5_a3 JTF_VARCHAR2_TABLE_100
391: , p5_a4 JTF_NUMBER_TABLE
392: , p5_a5 JTF_VARCHAR2_TABLE_100
393: , p5_a6 JTF_VARCHAR2_TABLE_100
394: , p5_a7 JTF_VARCHAR2_TABLE_100
388: , p5_a1 JTF_VARCHAR2_TABLE_300
389: , p5_a2 JTF_NUMBER_TABLE
390: , p5_a3 JTF_VARCHAR2_TABLE_100
391: , p5_a4 JTF_NUMBER_TABLE
392: , p5_a5 JTF_VARCHAR2_TABLE_100
393: , p5_a6 JTF_VARCHAR2_TABLE_100
394: , p5_a7 JTF_VARCHAR2_TABLE_100
395: , p5_a8 JTF_VARCHAR2_TABLE_100
396: , p5_a9 JTF_VARCHAR2_TABLE_2000
389: , p5_a2 JTF_NUMBER_TABLE
390: , p5_a3 JTF_VARCHAR2_TABLE_100
391: , p5_a4 JTF_NUMBER_TABLE
392: , p5_a5 JTF_VARCHAR2_TABLE_100
393: , p5_a6 JTF_VARCHAR2_TABLE_100
394: , p5_a7 JTF_VARCHAR2_TABLE_100
395: , p5_a8 JTF_VARCHAR2_TABLE_100
396: , p5_a9 JTF_VARCHAR2_TABLE_2000
397: , p5_a10 JTF_DATE_TABLE
390: , p5_a3 JTF_VARCHAR2_TABLE_100
391: , p5_a4 JTF_NUMBER_TABLE
392: , p5_a5 JTF_VARCHAR2_TABLE_100
393: , p5_a6 JTF_VARCHAR2_TABLE_100
394: , p5_a7 JTF_VARCHAR2_TABLE_100
395: , p5_a8 JTF_VARCHAR2_TABLE_100
396: , p5_a9 JTF_VARCHAR2_TABLE_2000
397: , p5_a10 JTF_DATE_TABLE
398: , p5_a11 JTF_DATE_TABLE
391: , p5_a4 JTF_NUMBER_TABLE
392: , p5_a5 JTF_VARCHAR2_TABLE_100
393: , p5_a6 JTF_VARCHAR2_TABLE_100
394: , p5_a7 JTF_VARCHAR2_TABLE_100
395: , p5_a8 JTF_VARCHAR2_TABLE_100
396: , p5_a9 JTF_VARCHAR2_TABLE_2000
397: , p5_a10 JTF_DATE_TABLE
398: , p5_a11 JTF_DATE_TABLE
399: , p5_a12 JTF_NUMBER_TABLE
400: , p5_a13 JTF_DATE_TABLE
401: , p5_a14 JTF_NUMBER_TABLE
402: , p5_a15 JTF_DATE_TABLE
403: , p5_a16 JTF_NUMBER_TABLE
404: , p5_a17 JTF_VARCHAR2_TABLE_100
405: , p5_a18 JTF_VARCHAR2_TABLE_100
406: , p5_a19 JTF_VARCHAR2_TABLE_100
407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
401: , p5_a14 JTF_NUMBER_TABLE
402: , p5_a15 JTF_DATE_TABLE
403: , p5_a16 JTF_NUMBER_TABLE
404: , p5_a17 JTF_VARCHAR2_TABLE_100
405: , p5_a18 JTF_VARCHAR2_TABLE_100
406: , p5_a19 JTF_VARCHAR2_TABLE_100
407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a2 out nocopy JTF_NUMBER_TABLE
402: , p5_a15 JTF_DATE_TABLE
403: , p5_a16 JTF_NUMBER_TABLE
404: , p5_a17 JTF_VARCHAR2_TABLE_100
405: , p5_a18 JTF_VARCHAR2_TABLE_100
406: , p5_a19 JTF_VARCHAR2_TABLE_100
407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a2 out nocopy JTF_NUMBER_TABLE
410: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
406: , p5_a19 JTF_VARCHAR2_TABLE_100
407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a2 out nocopy JTF_NUMBER_TABLE
410: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a4 out nocopy JTF_NUMBER_TABLE
412: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
408: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a2 out nocopy JTF_NUMBER_TABLE
410: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a4 out nocopy JTF_NUMBER_TABLE
412: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
415: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
409: , p6_a2 out nocopy JTF_NUMBER_TABLE
410: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a4 out nocopy JTF_NUMBER_TABLE
412: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
415: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
417: , p6_a10 out nocopy JTF_DATE_TABLE
410: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a4 out nocopy JTF_NUMBER_TABLE
412: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
415: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
417: , p6_a10 out nocopy JTF_DATE_TABLE
418: , p6_a11 out nocopy JTF_DATE_TABLE
411: , p6_a4 out nocopy JTF_NUMBER_TABLE
412: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
415: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
417: , p6_a10 out nocopy JTF_DATE_TABLE
418: , p6_a11 out nocopy JTF_DATE_TABLE
419: , p6_a12 out nocopy JTF_NUMBER_TABLE
420: , p6_a13 out nocopy JTF_DATE_TABLE
421: , p6_a14 out nocopy JTF_NUMBER_TABLE
422: , p6_a15 out nocopy JTF_DATE_TABLE
423: , p6_a16 out nocopy JTF_NUMBER_TABLE
424: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
427: , p7_a0 in out nocopy JTF_NUMBER_TABLE
428: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p6_a14 out nocopy JTF_NUMBER_TABLE
422: , p6_a15 out nocopy JTF_DATE_TABLE
423: , p6_a16 out nocopy JTF_NUMBER_TABLE
424: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
427: , p7_a0 in out nocopy JTF_NUMBER_TABLE
428: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p7_a2 in out nocopy JTF_NUMBER_TABLE
422: , p6_a15 out nocopy JTF_DATE_TABLE
423: , p6_a16 out nocopy JTF_NUMBER_TABLE
424: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
427: , p7_a0 in out nocopy JTF_NUMBER_TABLE
428: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p7_a2 in out nocopy JTF_NUMBER_TABLE
430: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
424: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
427: , p7_a0 in out nocopy JTF_NUMBER_TABLE
428: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p7_a2 in out nocopy JTF_NUMBER_TABLE
430: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
431: , p7_a4 in out nocopy JTF_NUMBER_TABLE
432: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
428: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p7_a2 in out nocopy JTF_NUMBER_TABLE
430: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
431: , p7_a4 in out nocopy JTF_NUMBER_TABLE
432: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
433: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
434: );
435: procedure update_row(p_api_version NUMBER
436: , p_init_msg_list VARCHAR2
429: , p7_a2 in out nocopy JTF_NUMBER_TABLE
430: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
431: , p7_a4 in out nocopy JTF_NUMBER_TABLE
432: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
433: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
434: );
435: procedure update_row(p_api_version NUMBER
436: , p_init_msg_list VARCHAR2
437: , x_return_status out nocopy VARCHAR2
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_VARCHAR2_TABLE_300
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_VARCHAR2_TABLE_100
447: , p5_a7 JTF_VARCHAR2_TABLE_100
441: , p5_a1 JTF_VARCHAR2_TABLE_300
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_VARCHAR2_TABLE_100
447: , p5_a7 JTF_VARCHAR2_TABLE_100
448: , p5_a8 JTF_VARCHAR2_TABLE_100
449: , p5_a9 JTF_VARCHAR2_TABLE_2000
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_VARCHAR2_TABLE_100
447: , p5_a7 JTF_VARCHAR2_TABLE_100
448: , p5_a8 JTF_VARCHAR2_TABLE_100
449: , p5_a9 JTF_VARCHAR2_TABLE_2000
450: , p5_a10 JTF_DATE_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_VARCHAR2_TABLE_100
447: , p5_a7 JTF_VARCHAR2_TABLE_100
448: , p5_a8 JTF_VARCHAR2_TABLE_100
449: , p5_a9 JTF_VARCHAR2_TABLE_2000
450: , p5_a10 JTF_DATE_TABLE
451: , p5_a11 JTF_DATE_TABLE
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_VARCHAR2_TABLE_100
447: , p5_a7 JTF_VARCHAR2_TABLE_100
448: , p5_a8 JTF_VARCHAR2_TABLE_100
449: , p5_a9 JTF_VARCHAR2_TABLE_2000
450: , p5_a10 JTF_DATE_TABLE
451: , p5_a11 JTF_DATE_TABLE
452: , p5_a12 JTF_NUMBER_TABLE
453: , p5_a13 JTF_DATE_TABLE
454: , p5_a14 JTF_NUMBER_TABLE
455: , p5_a15 JTF_DATE_TABLE
456: , p5_a16 JTF_NUMBER_TABLE
457: , p5_a17 JTF_VARCHAR2_TABLE_100
458: , p5_a18 JTF_VARCHAR2_TABLE_100
459: , p5_a19 JTF_VARCHAR2_TABLE_100
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
454: , p5_a14 JTF_NUMBER_TABLE
455: , p5_a15 JTF_DATE_TABLE
456: , p5_a16 JTF_NUMBER_TABLE
457: , p5_a17 JTF_VARCHAR2_TABLE_100
458: , p5_a18 JTF_VARCHAR2_TABLE_100
459: , p5_a19 JTF_VARCHAR2_TABLE_100
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
455: , p5_a15 JTF_DATE_TABLE
456: , p5_a16 JTF_NUMBER_TABLE
457: , p5_a17 JTF_VARCHAR2_TABLE_100
458: , p5_a18 JTF_VARCHAR2_TABLE_100
459: , p5_a19 JTF_VARCHAR2_TABLE_100
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
459: , p5_a19 JTF_VARCHAR2_TABLE_100
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_NUMBER_TABLE
465: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_NUMBER_TABLE
465: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_NUMBER_TABLE
465: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
470: , p6_a10 out nocopy JTF_DATE_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_NUMBER_TABLE
465: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
470: , p6_a10 out nocopy JTF_DATE_TABLE
471: , p6_a11 out nocopy JTF_DATE_TABLE
464: , p6_a4 out nocopy JTF_NUMBER_TABLE
465: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
470: , p6_a10 out nocopy JTF_DATE_TABLE
471: , p6_a11 out nocopy JTF_DATE_TABLE
472: , p6_a12 out nocopy JTF_NUMBER_TABLE
473: , p6_a13 out nocopy JTF_DATE_TABLE
474: , p6_a14 out nocopy JTF_NUMBER_TABLE
475: , p6_a15 out nocopy JTF_DATE_TABLE
476: , p6_a16 out nocopy JTF_NUMBER_TABLE
477: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
479: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
480: );
481: procedure delete_row(p_api_version NUMBER
474: , p6_a14 out nocopy JTF_NUMBER_TABLE
475: , p6_a15 out nocopy JTF_DATE_TABLE
476: , p6_a16 out nocopy JTF_NUMBER_TABLE
477: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
479: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
480: );
481: procedure delete_row(p_api_version NUMBER
482: , p_init_msg_list VARCHAR2
475: , p6_a15 out nocopy JTF_DATE_TABLE
476: , p6_a16 out nocopy JTF_NUMBER_TABLE
477: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
479: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
480: );
481: procedure delete_row(p_api_version NUMBER
482: , p_init_msg_list VARCHAR2
483: , x_return_status out nocopy VARCHAR2
511: , x_msg_data out nocopy VARCHAR2
512: , p5_a0 JTF_NUMBER_TABLE
513: , p5_a1 JTF_VARCHAR2_TABLE_300
514: , p5_a2 JTF_NUMBER_TABLE
515: , p5_a3 JTF_VARCHAR2_TABLE_100
516: , p5_a4 JTF_NUMBER_TABLE
517: , p5_a5 JTF_VARCHAR2_TABLE_100
518: , p5_a6 JTF_VARCHAR2_TABLE_100
519: , p5_a7 JTF_VARCHAR2_TABLE_100
513: , p5_a1 JTF_VARCHAR2_TABLE_300
514: , p5_a2 JTF_NUMBER_TABLE
515: , p5_a3 JTF_VARCHAR2_TABLE_100
516: , p5_a4 JTF_NUMBER_TABLE
517: , p5_a5 JTF_VARCHAR2_TABLE_100
518: , p5_a6 JTF_VARCHAR2_TABLE_100
519: , p5_a7 JTF_VARCHAR2_TABLE_100
520: , p5_a8 JTF_VARCHAR2_TABLE_100
521: , p5_a9 JTF_VARCHAR2_TABLE_2000
514: , p5_a2 JTF_NUMBER_TABLE
515: , p5_a3 JTF_VARCHAR2_TABLE_100
516: , p5_a4 JTF_NUMBER_TABLE
517: , p5_a5 JTF_VARCHAR2_TABLE_100
518: , p5_a6 JTF_VARCHAR2_TABLE_100
519: , p5_a7 JTF_VARCHAR2_TABLE_100
520: , p5_a8 JTF_VARCHAR2_TABLE_100
521: , p5_a9 JTF_VARCHAR2_TABLE_2000
522: , p5_a10 JTF_DATE_TABLE
515: , p5_a3 JTF_VARCHAR2_TABLE_100
516: , p5_a4 JTF_NUMBER_TABLE
517: , p5_a5 JTF_VARCHAR2_TABLE_100
518: , p5_a6 JTF_VARCHAR2_TABLE_100
519: , p5_a7 JTF_VARCHAR2_TABLE_100
520: , p5_a8 JTF_VARCHAR2_TABLE_100
521: , p5_a9 JTF_VARCHAR2_TABLE_2000
522: , p5_a10 JTF_DATE_TABLE
523: , p5_a11 JTF_DATE_TABLE
516: , p5_a4 JTF_NUMBER_TABLE
517: , p5_a5 JTF_VARCHAR2_TABLE_100
518: , p5_a6 JTF_VARCHAR2_TABLE_100
519: , p5_a7 JTF_VARCHAR2_TABLE_100
520: , p5_a8 JTF_VARCHAR2_TABLE_100
521: , p5_a9 JTF_VARCHAR2_TABLE_2000
522: , p5_a10 JTF_DATE_TABLE
523: , p5_a11 JTF_DATE_TABLE
524: , p5_a12 JTF_NUMBER_TABLE
525: , p5_a13 JTF_DATE_TABLE
526: , p5_a14 JTF_NUMBER_TABLE
527: , p5_a15 JTF_DATE_TABLE
528: , p5_a16 JTF_NUMBER_TABLE
529: , p5_a17 JTF_VARCHAR2_TABLE_100
530: , p5_a18 JTF_VARCHAR2_TABLE_100
531: , p5_a19 JTF_VARCHAR2_TABLE_100
532: , p6_a0 in out nocopy JTF_NUMBER_TABLE
533: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
526: , p5_a14 JTF_NUMBER_TABLE
527: , p5_a15 JTF_DATE_TABLE
528: , p5_a16 JTF_NUMBER_TABLE
529: , p5_a17 JTF_VARCHAR2_TABLE_100
530: , p5_a18 JTF_VARCHAR2_TABLE_100
531: , p5_a19 JTF_VARCHAR2_TABLE_100
532: , p6_a0 in out nocopy JTF_NUMBER_TABLE
533: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a2 in out nocopy JTF_NUMBER_TABLE
527: , p5_a15 JTF_DATE_TABLE
528: , p5_a16 JTF_NUMBER_TABLE
529: , p5_a17 JTF_VARCHAR2_TABLE_100
530: , p5_a18 JTF_VARCHAR2_TABLE_100
531: , p5_a19 JTF_VARCHAR2_TABLE_100
532: , p6_a0 in out nocopy JTF_NUMBER_TABLE
533: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a2 in out nocopy JTF_NUMBER_TABLE
535: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
529: , p5_a17 JTF_VARCHAR2_TABLE_100
530: , p5_a18 JTF_VARCHAR2_TABLE_100
531: , p5_a19 JTF_VARCHAR2_TABLE_100
532: , p6_a0 in out nocopy JTF_NUMBER_TABLE
533: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a2 in out nocopy JTF_NUMBER_TABLE
535: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
536: , p6_a4 in out nocopy JTF_NUMBER_TABLE
537: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a2 in out nocopy JTF_NUMBER_TABLE
535: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
536: , p6_a4 in out nocopy JTF_NUMBER_TABLE
537: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
539: );
540: procedure delete_row(p_api_version NUMBER
541: , p_init_msg_list VARCHAR2
534: , p6_a2 in out nocopy JTF_NUMBER_TABLE
535: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
536: , p6_a4 in out nocopy JTF_NUMBER_TABLE
537: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
539: );
540: procedure delete_row(p_api_version NUMBER
541: , p_init_msg_list VARCHAR2
542: , x_return_status out nocopy VARCHAR2
544: , x_msg_data out nocopy VARCHAR2
545: , p5_a0 JTF_NUMBER_TABLE
546: , p5_a1 JTF_VARCHAR2_TABLE_300
547: , p5_a2 JTF_NUMBER_TABLE
548: , p5_a3 JTF_VARCHAR2_TABLE_100
549: , p5_a4 JTF_NUMBER_TABLE
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
552: , p5_a7 JTF_VARCHAR2_TABLE_100
546: , p5_a1 JTF_VARCHAR2_TABLE_300
547: , p5_a2 JTF_NUMBER_TABLE
548: , p5_a3 JTF_VARCHAR2_TABLE_100
549: , p5_a4 JTF_NUMBER_TABLE
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
552: , p5_a7 JTF_VARCHAR2_TABLE_100
553: , p5_a8 JTF_VARCHAR2_TABLE_100
554: , p5_a9 JTF_VARCHAR2_TABLE_2000
547: , p5_a2 JTF_NUMBER_TABLE
548: , p5_a3 JTF_VARCHAR2_TABLE_100
549: , p5_a4 JTF_NUMBER_TABLE
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
552: , p5_a7 JTF_VARCHAR2_TABLE_100
553: , p5_a8 JTF_VARCHAR2_TABLE_100
554: , p5_a9 JTF_VARCHAR2_TABLE_2000
555: , p5_a10 JTF_DATE_TABLE
548: , p5_a3 JTF_VARCHAR2_TABLE_100
549: , p5_a4 JTF_NUMBER_TABLE
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
552: , p5_a7 JTF_VARCHAR2_TABLE_100
553: , p5_a8 JTF_VARCHAR2_TABLE_100
554: , p5_a9 JTF_VARCHAR2_TABLE_2000
555: , p5_a10 JTF_DATE_TABLE
556: , p5_a11 JTF_DATE_TABLE
549: , p5_a4 JTF_NUMBER_TABLE
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
552: , p5_a7 JTF_VARCHAR2_TABLE_100
553: , p5_a8 JTF_VARCHAR2_TABLE_100
554: , p5_a9 JTF_VARCHAR2_TABLE_2000
555: , p5_a10 JTF_DATE_TABLE
556: , p5_a11 JTF_DATE_TABLE
557: , p5_a12 JTF_NUMBER_TABLE
558: , p5_a13 JTF_DATE_TABLE
559: , p5_a14 JTF_NUMBER_TABLE
560: , p5_a15 JTF_DATE_TABLE
561: , p5_a16 JTF_NUMBER_TABLE
562: , p5_a17 JTF_VARCHAR2_TABLE_100
563: , p5_a18 JTF_VARCHAR2_TABLE_100
564: , p5_a19 JTF_VARCHAR2_TABLE_100
565: );
566: procedure validate_row(p_api_version NUMBER
559: , p5_a14 JTF_NUMBER_TABLE
560: , p5_a15 JTF_DATE_TABLE
561: , p5_a16 JTF_NUMBER_TABLE
562: , p5_a17 JTF_VARCHAR2_TABLE_100
563: , p5_a18 JTF_VARCHAR2_TABLE_100
564: , p5_a19 JTF_VARCHAR2_TABLE_100
565: );
566: procedure validate_row(p_api_version NUMBER
567: , p_init_msg_list VARCHAR2
560: , p5_a15 JTF_DATE_TABLE
561: , p5_a16 JTF_NUMBER_TABLE
562: , p5_a17 JTF_VARCHAR2_TABLE_100
563: , p5_a18 JTF_VARCHAR2_TABLE_100
564: , p5_a19 JTF_VARCHAR2_TABLE_100
565: );
566: procedure validate_row(p_api_version NUMBER
567: , p_init_msg_list VARCHAR2
568: , x_return_status out nocopy VARCHAR2
596: , x_msg_data out nocopy VARCHAR2
597: , p5_a0 JTF_NUMBER_TABLE
598: , p5_a1 JTF_VARCHAR2_TABLE_300
599: , p5_a2 JTF_NUMBER_TABLE
600: , p5_a3 JTF_VARCHAR2_TABLE_100
601: , p5_a4 JTF_NUMBER_TABLE
602: , p5_a5 JTF_VARCHAR2_TABLE_100
603: , p5_a6 JTF_VARCHAR2_TABLE_100
604: , p5_a7 JTF_VARCHAR2_TABLE_100
598: , p5_a1 JTF_VARCHAR2_TABLE_300
599: , p5_a2 JTF_NUMBER_TABLE
600: , p5_a3 JTF_VARCHAR2_TABLE_100
601: , p5_a4 JTF_NUMBER_TABLE
602: , p5_a5 JTF_VARCHAR2_TABLE_100
603: , p5_a6 JTF_VARCHAR2_TABLE_100
604: , p5_a7 JTF_VARCHAR2_TABLE_100
605: , p5_a8 JTF_VARCHAR2_TABLE_100
606: , p5_a9 JTF_VARCHAR2_TABLE_2000
599: , p5_a2 JTF_NUMBER_TABLE
600: , p5_a3 JTF_VARCHAR2_TABLE_100
601: , p5_a4 JTF_NUMBER_TABLE
602: , p5_a5 JTF_VARCHAR2_TABLE_100
603: , p5_a6 JTF_VARCHAR2_TABLE_100
604: , p5_a7 JTF_VARCHAR2_TABLE_100
605: , p5_a8 JTF_VARCHAR2_TABLE_100
606: , p5_a9 JTF_VARCHAR2_TABLE_2000
607: , p5_a10 JTF_DATE_TABLE
600: , p5_a3 JTF_VARCHAR2_TABLE_100
601: , p5_a4 JTF_NUMBER_TABLE
602: , p5_a5 JTF_VARCHAR2_TABLE_100
603: , p5_a6 JTF_VARCHAR2_TABLE_100
604: , p5_a7 JTF_VARCHAR2_TABLE_100
605: , p5_a8 JTF_VARCHAR2_TABLE_100
606: , p5_a9 JTF_VARCHAR2_TABLE_2000
607: , p5_a10 JTF_DATE_TABLE
608: , p5_a11 JTF_DATE_TABLE
601: , p5_a4 JTF_NUMBER_TABLE
602: , p5_a5 JTF_VARCHAR2_TABLE_100
603: , p5_a6 JTF_VARCHAR2_TABLE_100
604: , p5_a7 JTF_VARCHAR2_TABLE_100
605: , p5_a8 JTF_VARCHAR2_TABLE_100
606: , p5_a9 JTF_VARCHAR2_TABLE_2000
607: , p5_a10 JTF_DATE_TABLE
608: , p5_a11 JTF_DATE_TABLE
609: , p5_a12 JTF_NUMBER_TABLE
610: , p5_a13 JTF_DATE_TABLE
611: , p5_a14 JTF_NUMBER_TABLE
612: , p5_a15 JTF_DATE_TABLE
613: , p5_a16 JTF_NUMBER_TABLE
614: , p5_a17 JTF_VARCHAR2_TABLE_100
615: , p5_a18 JTF_VARCHAR2_TABLE_100
616: , p5_a19 JTF_VARCHAR2_TABLE_100
617: , p6_a0 in out nocopy JTF_NUMBER_TABLE
618: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
611: , p5_a14 JTF_NUMBER_TABLE
612: , p5_a15 JTF_DATE_TABLE
613: , p5_a16 JTF_NUMBER_TABLE
614: , p5_a17 JTF_VARCHAR2_TABLE_100
615: , p5_a18 JTF_VARCHAR2_TABLE_100
616: , p5_a19 JTF_VARCHAR2_TABLE_100
617: , p6_a0 in out nocopy JTF_NUMBER_TABLE
618: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p6_a2 in out nocopy JTF_NUMBER_TABLE
612: , p5_a15 JTF_DATE_TABLE
613: , p5_a16 JTF_NUMBER_TABLE
614: , p5_a17 JTF_VARCHAR2_TABLE_100
615: , p5_a18 JTF_VARCHAR2_TABLE_100
616: , p5_a19 JTF_VARCHAR2_TABLE_100
617: , p6_a0 in out nocopy JTF_NUMBER_TABLE
618: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p6_a2 in out nocopy JTF_NUMBER_TABLE
620: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
614: , p5_a17 JTF_VARCHAR2_TABLE_100
615: , p5_a18 JTF_VARCHAR2_TABLE_100
616: , p5_a19 JTF_VARCHAR2_TABLE_100
617: , p6_a0 in out nocopy JTF_NUMBER_TABLE
618: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p6_a2 in out nocopy JTF_NUMBER_TABLE
620: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
621: , p6_a4 in out nocopy JTF_NUMBER_TABLE
622: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
618: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p6_a2 in out nocopy JTF_NUMBER_TABLE
620: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
621: , p6_a4 in out nocopy JTF_NUMBER_TABLE
622: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
624: );
625: procedure validate_row(p_api_version NUMBER
626: , p_init_msg_list VARCHAR2
619: , p6_a2 in out nocopy JTF_NUMBER_TABLE
620: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
621: , p6_a4 in out nocopy JTF_NUMBER_TABLE
622: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
624: );
625: procedure validate_row(p_api_version NUMBER
626: , p_init_msg_list VARCHAR2
627: , x_return_status out nocopy VARCHAR2
629: , x_msg_data out nocopy VARCHAR2
630: , p5_a0 JTF_NUMBER_TABLE
631: , p5_a1 JTF_VARCHAR2_TABLE_300
632: , p5_a2 JTF_NUMBER_TABLE
633: , p5_a3 JTF_VARCHAR2_TABLE_100
634: , p5_a4 JTF_NUMBER_TABLE
635: , p5_a5 JTF_VARCHAR2_TABLE_100
636: , p5_a6 JTF_VARCHAR2_TABLE_100
637: , p5_a7 JTF_VARCHAR2_TABLE_100
631: , p5_a1 JTF_VARCHAR2_TABLE_300
632: , p5_a2 JTF_NUMBER_TABLE
633: , p5_a3 JTF_VARCHAR2_TABLE_100
634: , p5_a4 JTF_NUMBER_TABLE
635: , p5_a5 JTF_VARCHAR2_TABLE_100
636: , p5_a6 JTF_VARCHAR2_TABLE_100
637: , p5_a7 JTF_VARCHAR2_TABLE_100
638: , p5_a8 JTF_VARCHAR2_TABLE_100
639: , p5_a9 JTF_VARCHAR2_TABLE_2000
632: , p5_a2 JTF_NUMBER_TABLE
633: , p5_a3 JTF_VARCHAR2_TABLE_100
634: , p5_a4 JTF_NUMBER_TABLE
635: , p5_a5 JTF_VARCHAR2_TABLE_100
636: , p5_a6 JTF_VARCHAR2_TABLE_100
637: , p5_a7 JTF_VARCHAR2_TABLE_100
638: , p5_a8 JTF_VARCHAR2_TABLE_100
639: , p5_a9 JTF_VARCHAR2_TABLE_2000
640: , p5_a10 JTF_DATE_TABLE
633: , p5_a3 JTF_VARCHAR2_TABLE_100
634: , p5_a4 JTF_NUMBER_TABLE
635: , p5_a5 JTF_VARCHAR2_TABLE_100
636: , p5_a6 JTF_VARCHAR2_TABLE_100
637: , p5_a7 JTF_VARCHAR2_TABLE_100
638: , p5_a8 JTF_VARCHAR2_TABLE_100
639: , p5_a9 JTF_VARCHAR2_TABLE_2000
640: , p5_a10 JTF_DATE_TABLE
641: , p5_a11 JTF_DATE_TABLE
634: , p5_a4 JTF_NUMBER_TABLE
635: , p5_a5 JTF_VARCHAR2_TABLE_100
636: , p5_a6 JTF_VARCHAR2_TABLE_100
637: , p5_a7 JTF_VARCHAR2_TABLE_100
638: , p5_a8 JTF_VARCHAR2_TABLE_100
639: , p5_a9 JTF_VARCHAR2_TABLE_2000
640: , p5_a10 JTF_DATE_TABLE
641: , p5_a11 JTF_DATE_TABLE
642: , p5_a12 JTF_NUMBER_TABLE
643: , p5_a13 JTF_DATE_TABLE
644: , p5_a14 JTF_NUMBER_TABLE
645: , p5_a15 JTF_DATE_TABLE
646: , p5_a16 JTF_NUMBER_TABLE
647: , p5_a17 JTF_VARCHAR2_TABLE_100
648: , p5_a18 JTF_VARCHAR2_TABLE_100
649: , p5_a19 JTF_VARCHAR2_TABLE_100
650: );
651: end okl_rep_pvt_w;
644: , p5_a14 JTF_NUMBER_TABLE
645: , p5_a15 JTF_DATE_TABLE
646: , p5_a16 JTF_NUMBER_TABLE
647: , p5_a17 JTF_VARCHAR2_TABLE_100
648: , p5_a18 JTF_VARCHAR2_TABLE_100
649: , p5_a19 JTF_VARCHAR2_TABLE_100
650: );
651: end okl_rep_pvt_w;
645: , p5_a15 JTF_DATE_TABLE
646: , p5_a16 JTF_NUMBER_TABLE
647: , p5_a17 JTF_VARCHAR2_TABLE_100
648: , p5_a18 JTF_VARCHAR2_TABLE_100
649: , p5_a19 JTF_VARCHAR2_TABLE_100
650: );
651: end okl_rep_pvt_w;