1: package okl_crt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLICRTS.pls 115.2 2003/10/07 17:58:10 pdevaraj noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_crt_pvt.crtv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_crt_pvt.crtv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_300
21: , a18 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_300
21: , a18 JTF_VARCHAR2_TABLE_300
22: , a19 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_300
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_300
35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_300
35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_crt_pvt.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_crt_pvt.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_crt_pvt.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
42: procedure rosetta_table_copy_out_p2(t okl_crt_pvt.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_300
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_300
60: , a18 out nocopy JTF_VARCHAR2_TABLE_300
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_300
60: , a18 out nocopy JTF_VARCHAR2_TABLE_300
61: , a19 out nocopy JTF_VARCHAR2_TABLE_300
71: , a29 out nocopy JTF_VARCHAR2_TABLE_300
72: , a30 out nocopy JTF_VARCHAR2_TABLE_300
73: , a31 out nocopy JTF_VARCHAR2_TABLE_300
74: , a32 out nocopy JTF_VARCHAR2_TABLE_300
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
73: , a31 out nocopy JTF_VARCHAR2_TABLE_300
74: , a32 out nocopy JTF_VARCHAR2_TABLE_300
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_crt_pvt.crt_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_200
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_crt_pvt.crt_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_200
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_DATE_TABLE
86: , a4 JTF_NUMBER_TABLE
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_crt_pvt.crt_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_200
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_DATE_TABLE
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_VARCHAR2_TABLE_100
90: , a8 JTF_VARCHAR2_TABLE_2000
83: , a1 JTF_VARCHAR2_TABLE_200
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_DATE_TABLE
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_VARCHAR2_TABLE_100
90: , a8 JTF_VARCHAR2_TABLE_2000
91: , a9 JTF_DATE_TABLE
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_DATE_TABLE
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_VARCHAR2_TABLE_100
90: , a8 JTF_VARCHAR2_TABLE_2000
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_VARCHAR2_TABLE_100
90: , a8 JTF_VARCHAR2_TABLE_2000
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_NUMBER_TABLE
89: , a7 JTF_VARCHAR2_TABLE_100
90: , a8 JTF_VARCHAR2_TABLE_2000
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_NUMBER_TABLE
97: , a15 JTF_VARCHAR2_TABLE_100
90: , a8 JTF_VARCHAR2_TABLE_2000
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_NUMBER_TABLE
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE
91: , a9 JTF_DATE_TABLE
92: , a10 JTF_NUMBER_TABLE
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_NUMBER_TABLE
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE
99: , a17 JTF_VARCHAR2_TABLE_300
92: , a10 JTF_NUMBER_TABLE
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_NUMBER_TABLE
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE
99: , a17 JTF_VARCHAR2_TABLE_300
100: , a18 JTF_VARCHAR2_TABLE_300
111: , a29 JTF_VARCHAR2_TABLE_300
112: , a30 JTF_VARCHAR2_TABLE_300
113: , a31 JTF_VARCHAR2_TABLE_300
114: , a32 JTF_VARCHAR2_TABLE_300
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_DATE_TABLE
117: , a35 JTF_NUMBER_TABLE
118: , a36 JTF_DATE_TABLE
119: , a37 JTF_NUMBER_TABLE
113: , a31 JTF_VARCHAR2_TABLE_300
114: , a32 JTF_VARCHAR2_TABLE_300
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_DATE_TABLE
117: , a35 JTF_NUMBER_TABLE
118: , a36 JTF_DATE_TABLE
119: , a37 JTF_NUMBER_TABLE
120: );
121: procedure rosetta_table_copy_out_p5(t okl_crt_pvt.crt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_DATE_TABLE
117: , a35 JTF_NUMBER_TABLE
118: , a36 JTF_DATE_TABLE
119: , a37 JTF_NUMBER_TABLE
120: );
121: procedure rosetta_table_copy_out_p5(t okl_crt_pvt.crt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_200
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a35 JTF_NUMBER_TABLE
118: , a36 JTF_DATE_TABLE
119: , a37 JTF_NUMBER_TABLE
120: );
121: procedure rosetta_table_copy_out_p5(t okl_crt_pvt.crt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_200
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_NUMBER_TABLE
121: procedure rosetta_table_copy_out_p5(t okl_crt_pvt.crt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_200
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_NUMBER_TABLE
126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_NUMBER_TABLE
128: , a7 out nocopy JTF_VARCHAR2_TABLE_100
129: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a1 out nocopy JTF_VARCHAR2_TABLE_200
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_NUMBER_TABLE
126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_NUMBER_TABLE
128: , a7 out nocopy JTF_VARCHAR2_TABLE_100
129: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
130: , a9 out nocopy JTF_DATE_TABLE
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_NUMBER_TABLE
126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_NUMBER_TABLE
128: , a7 out nocopy JTF_VARCHAR2_TABLE_100
129: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
130: , a9 out nocopy JTF_DATE_TABLE
131: , a10 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_NUMBER_TABLE
128: , a7 out nocopy JTF_VARCHAR2_TABLE_100
129: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
130: , a9 out nocopy JTF_DATE_TABLE
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_NUMBER_TABLE
133: , a12 out nocopy JTF_NUMBER_TABLE
134: , a13 out nocopy JTF_NUMBER_TABLE
135: , a14 out nocopy JTF_NUMBER_TABLE
128: , a7 out nocopy JTF_VARCHAR2_TABLE_100
129: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
130: , a9 out nocopy JTF_DATE_TABLE
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_NUMBER_TABLE
133: , a12 out nocopy JTF_NUMBER_TABLE
134: , a13 out nocopy JTF_NUMBER_TABLE
135: , a14 out nocopy JTF_NUMBER_TABLE
136: , a15 out nocopy JTF_VARCHAR2_TABLE_100
129: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
130: , a9 out nocopy JTF_DATE_TABLE
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_NUMBER_TABLE
133: , a12 out nocopy JTF_NUMBER_TABLE
134: , a13 out nocopy JTF_NUMBER_TABLE
135: , a14 out nocopy JTF_NUMBER_TABLE
136: , a15 out nocopy JTF_VARCHAR2_TABLE_100
137: , a16 out nocopy JTF_DATE_TABLE
130: , a9 out nocopy JTF_DATE_TABLE
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_NUMBER_TABLE
133: , a12 out nocopy JTF_NUMBER_TABLE
134: , a13 out nocopy JTF_NUMBER_TABLE
135: , a14 out nocopy JTF_NUMBER_TABLE
136: , a15 out nocopy JTF_VARCHAR2_TABLE_100
137: , a16 out nocopy JTF_DATE_TABLE
138: , a17 out nocopy JTF_VARCHAR2_TABLE_300
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_NUMBER_TABLE
133: , a12 out nocopy JTF_NUMBER_TABLE
134: , a13 out nocopy JTF_NUMBER_TABLE
135: , a14 out nocopy JTF_NUMBER_TABLE
136: , a15 out nocopy JTF_VARCHAR2_TABLE_100
137: , a16 out nocopy JTF_DATE_TABLE
138: , a17 out nocopy JTF_VARCHAR2_TABLE_300
139: , a18 out nocopy JTF_VARCHAR2_TABLE_300
150: , a29 out nocopy JTF_VARCHAR2_TABLE_300
151: , a30 out nocopy JTF_VARCHAR2_TABLE_300
152: , a31 out nocopy JTF_VARCHAR2_TABLE_300
153: , a32 out nocopy JTF_VARCHAR2_TABLE_300
154: , a33 out nocopy JTF_NUMBER_TABLE
155: , a34 out nocopy JTF_DATE_TABLE
156: , a35 out nocopy JTF_NUMBER_TABLE
157: , a36 out nocopy JTF_DATE_TABLE
158: , a37 out nocopy JTF_NUMBER_TABLE
152: , a31 out nocopy JTF_VARCHAR2_TABLE_300
153: , a32 out nocopy JTF_VARCHAR2_TABLE_300
154: , a33 out nocopy JTF_NUMBER_TABLE
155: , a34 out nocopy JTF_DATE_TABLE
156: , a35 out nocopy JTF_NUMBER_TABLE
157: , a36 out nocopy JTF_DATE_TABLE
158: , a37 out nocopy JTF_NUMBER_TABLE
159: );
160:
154: , a33 out nocopy JTF_NUMBER_TABLE
155: , a34 out nocopy JTF_DATE_TABLE
156: , a35 out nocopy JTF_NUMBER_TABLE
157: , a36 out nocopy JTF_DATE_TABLE
158: , a37 out nocopy JTF_NUMBER_TABLE
159: );
160:
161: procedure insert_row(p_api_version NUMBER
162: , p_init_msg_list VARCHAR2
244: , p_init_msg_list VARCHAR2
245: , x_return_status out nocopy VARCHAR2
246: , x_msg_count out nocopy NUMBER
247: , x_msg_data out nocopy VARCHAR2
248: , p5_a0 JTF_NUMBER_TABLE
249: , p5_a1 JTF_VARCHAR2_TABLE_200
250: , p5_a2 JTF_VARCHAR2_TABLE_100
251: , p5_a3 JTF_DATE_TABLE
252: , p5_a4 JTF_NUMBER_TABLE
248: , p5_a0 JTF_NUMBER_TABLE
249: , p5_a1 JTF_VARCHAR2_TABLE_200
250: , p5_a2 JTF_VARCHAR2_TABLE_100
251: , p5_a3 JTF_DATE_TABLE
252: , p5_a4 JTF_NUMBER_TABLE
253: , p5_a5 JTF_NUMBER_TABLE
254: , p5_a6 JTF_NUMBER_TABLE
255: , p5_a7 JTF_VARCHAR2_TABLE_100
256: , p5_a8 JTF_VARCHAR2_TABLE_2000
249: , p5_a1 JTF_VARCHAR2_TABLE_200
250: , p5_a2 JTF_VARCHAR2_TABLE_100
251: , p5_a3 JTF_DATE_TABLE
252: , p5_a4 JTF_NUMBER_TABLE
253: , p5_a5 JTF_NUMBER_TABLE
254: , p5_a6 JTF_NUMBER_TABLE
255: , p5_a7 JTF_VARCHAR2_TABLE_100
256: , p5_a8 JTF_VARCHAR2_TABLE_2000
257: , p5_a9 JTF_DATE_TABLE
250: , p5_a2 JTF_VARCHAR2_TABLE_100
251: , p5_a3 JTF_DATE_TABLE
252: , p5_a4 JTF_NUMBER_TABLE
253: , p5_a5 JTF_NUMBER_TABLE
254: , p5_a6 JTF_NUMBER_TABLE
255: , p5_a7 JTF_VARCHAR2_TABLE_100
256: , p5_a8 JTF_VARCHAR2_TABLE_2000
257: , p5_a9 JTF_DATE_TABLE
258: , p5_a10 JTF_VARCHAR2_TABLE_100
255: , p5_a7 JTF_VARCHAR2_TABLE_100
256: , p5_a8 JTF_VARCHAR2_TABLE_2000
257: , p5_a9 JTF_DATE_TABLE
258: , p5_a10 JTF_VARCHAR2_TABLE_100
259: , p5_a11 JTF_NUMBER_TABLE
260: , p5_a12 JTF_NUMBER_TABLE
261: , p5_a13 JTF_NUMBER_TABLE
262: , p5_a14 JTF_NUMBER_TABLE
263: , p5_a15 JTF_NUMBER_TABLE
256: , p5_a8 JTF_VARCHAR2_TABLE_2000
257: , p5_a9 JTF_DATE_TABLE
258: , p5_a10 JTF_VARCHAR2_TABLE_100
259: , p5_a11 JTF_NUMBER_TABLE
260: , p5_a12 JTF_NUMBER_TABLE
261: , p5_a13 JTF_NUMBER_TABLE
262: , p5_a14 JTF_NUMBER_TABLE
263: , p5_a15 JTF_NUMBER_TABLE
264: , p5_a16 JTF_DATE_TABLE
257: , p5_a9 JTF_DATE_TABLE
258: , p5_a10 JTF_VARCHAR2_TABLE_100
259: , p5_a11 JTF_NUMBER_TABLE
260: , p5_a12 JTF_NUMBER_TABLE
261: , p5_a13 JTF_NUMBER_TABLE
262: , p5_a14 JTF_NUMBER_TABLE
263: , p5_a15 JTF_NUMBER_TABLE
264: , p5_a16 JTF_DATE_TABLE
265: , p5_a17 JTF_VARCHAR2_TABLE_300
258: , p5_a10 JTF_VARCHAR2_TABLE_100
259: , p5_a11 JTF_NUMBER_TABLE
260: , p5_a12 JTF_NUMBER_TABLE
261: , p5_a13 JTF_NUMBER_TABLE
262: , p5_a14 JTF_NUMBER_TABLE
263: , p5_a15 JTF_NUMBER_TABLE
264: , p5_a16 JTF_DATE_TABLE
265: , p5_a17 JTF_VARCHAR2_TABLE_300
266: , p5_a18 JTF_VARCHAR2_TABLE_300
259: , p5_a11 JTF_NUMBER_TABLE
260: , p5_a12 JTF_NUMBER_TABLE
261: , p5_a13 JTF_NUMBER_TABLE
262: , p5_a14 JTF_NUMBER_TABLE
263: , p5_a15 JTF_NUMBER_TABLE
264: , p5_a16 JTF_DATE_TABLE
265: , p5_a17 JTF_VARCHAR2_TABLE_300
266: , p5_a18 JTF_VARCHAR2_TABLE_300
267: , p5_a19 JTF_VARCHAR2_TABLE_300
277: , p5_a29 JTF_VARCHAR2_TABLE_300
278: , p5_a30 JTF_VARCHAR2_TABLE_300
279: , p5_a31 JTF_VARCHAR2_TABLE_300
280: , p5_a32 JTF_VARCHAR2_TABLE_300
281: , p5_a33 JTF_NUMBER_TABLE
282: , p5_a34 JTF_DATE_TABLE
283: , p5_a35 JTF_NUMBER_TABLE
284: , p5_a36 JTF_DATE_TABLE
285: , p5_a37 JTF_NUMBER_TABLE
279: , p5_a31 JTF_VARCHAR2_TABLE_300
280: , p5_a32 JTF_VARCHAR2_TABLE_300
281: , p5_a33 JTF_NUMBER_TABLE
282: , p5_a34 JTF_DATE_TABLE
283: , p5_a35 JTF_NUMBER_TABLE
284: , p5_a36 JTF_DATE_TABLE
285: , p5_a37 JTF_NUMBER_TABLE
286: , p6_a0 out nocopy JTF_NUMBER_TABLE
287: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
281: , p5_a33 JTF_NUMBER_TABLE
282: , p5_a34 JTF_DATE_TABLE
283: , p5_a35 JTF_NUMBER_TABLE
284: , p5_a36 JTF_DATE_TABLE
285: , p5_a37 JTF_NUMBER_TABLE
286: , p6_a0 out nocopy JTF_NUMBER_TABLE
287: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a3 out nocopy JTF_DATE_TABLE
282: , p5_a34 JTF_DATE_TABLE
283: , p5_a35 JTF_NUMBER_TABLE
284: , p5_a36 JTF_DATE_TABLE
285: , p5_a37 JTF_NUMBER_TABLE
286: , p6_a0 out nocopy JTF_NUMBER_TABLE
287: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a3 out nocopy JTF_DATE_TABLE
290: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a0 out nocopy JTF_NUMBER_TABLE
287: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a3 out nocopy JTF_DATE_TABLE
290: , p6_a4 out nocopy JTF_NUMBER_TABLE
291: , p6_a5 out nocopy JTF_NUMBER_TABLE
292: , p6_a6 out nocopy JTF_NUMBER_TABLE
293: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
294: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
287: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a3 out nocopy JTF_DATE_TABLE
290: , p6_a4 out nocopy JTF_NUMBER_TABLE
291: , p6_a5 out nocopy JTF_NUMBER_TABLE
292: , p6_a6 out nocopy JTF_NUMBER_TABLE
293: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
294: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
295: , p6_a9 out nocopy JTF_DATE_TABLE
288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a3 out nocopy JTF_DATE_TABLE
290: , p6_a4 out nocopy JTF_NUMBER_TABLE
291: , p6_a5 out nocopy JTF_NUMBER_TABLE
292: , p6_a6 out nocopy JTF_NUMBER_TABLE
293: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
294: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
295: , p6_a9 out nocopy JTF_DATE_TABLE
296: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
293: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
294: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
295: , p6_a9 out nocopy JTF_DATE_TABLE
296: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
297: , p6_a11 out nocopy JTF_NUMBER_TABLE
298: , p6_a12 out nocopy JTF_NUMBER_TABLE
299: , p6_a13 out nocopy JTF_NUMBER_TABLE
300: , p6_a14 out nocopy JTF_NUMBER_TABLE
301: , p6_a15 out nocopy JTF_NUMBER_TABLE
294: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
295: , p6_a9 out nocopy JTF_DATE_TABLE
296: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
297: , p6_a11 out nocopy JTF_NUMBER_TABLE
298: , p6_a12 out nocopy JTF_NUMBER_TABLE
299: , p6_a13 out nocopy JTF_NUMBER_TABLE
300: , p6_a14 out nocopy JTF_NUMBER_TABLE
301: , p6_a15 out nocopy JTF_NUMBER_TABLE
302: , p6_a16 out nocopy JTF_DATE_TABLE
295: , p6_a9 out nocopy JTF_DATE_TABLE
296: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
297: , p6_a11 out nocopy JTF_NUMBER_TABLE
298: , p6_a12 out nocopy JTF_NUMBER_TABLE
299: , p6_a13 out nocopy JTF_NUMBER_TABLE
300: , p6_a14 out nocopy JTF_NUMBER_TABLE
301: , p6_a15 out nocopy JTF_NUMBER_TABLE
302: , p6_a16 out nocopy JTF_DATE_TABLE
303: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
296: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
297: , p6_a11 out nocopy JTF_NUMBER_TABLE
298: , p6_a12 out nocopy JTF_NUMBER_TABLE
299: , p6_a13 out nocopy JTF_NUMBER_TABLE
300: , p6_a14 out nocopy JTF_NUMBER_TABLE
301: , p6_a15 out nocopy JTF_NUMBER_TABLE
302: , p6_a16 out nocopy JTF_DATE_TABLE
303: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
304: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
297: , p6_a11 out nocopy JTF_NUMBER_TABLE
298: , p6_a12 out nocopy JTF_NUMBER_TABLE
299: , p6_a13 out nocopy JTF_NUMBER_TABLE
300: , p6_a14 out nocopy JTF_NUMBER_TABLE
301: , p6_a15 out nocopy JTF_NUMBER_TABLE
302: , p6_a16 out nocopy JTF_DATE_TABLE
303: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
304: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
305: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
315: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
316: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
317: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
318: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
319: , p6_a33 out nocopy JTF_NUMBER_TABLE
320: , p6_a34 out nocopy JTF_DATE_TABLE
321: , p6_a35 out nocopy JTF_NUMBER_TABLE
322: , p6_a36 out nocopy JTF_DATE_TABLE
323: , p6_a37 out nocopy JTF_NUMBER_TABLE
317: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
318: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
319: , p6_a33 out nocopy JTF_NUMBER_TABLE
320: , p6_a34 out nocopy JTF_DATE_TABLE
321: , p6_a35 out nocopy JTF_NUMBER_TABLE
322: , p6_a36 out nocopy JTF_DATE_TABLE
323: , p6_a37 out nocopy JTF_NUMBER_TABLE
324: );
325: procedure lock_row(p_api_version NUMBER
319: , p6_a33 out nocopy JTF_NUMBER_TABLE
320: , p6_a34 out nocopy JTF_DATE_TABLE
321: , p6_a35 out nocopy JTF_NUMBER_TABLE
322: , p6_a36 out nocopy JTF_DATE_TABLE
323: , p6_a37 out nocopy JTF_NUMBER_TABLE
324: );
325: procedure lock_row(p_api_version NUMBER
326: , p_init_msg_list VARCHAR2
327: , x_return_status out nocopy VARCHAR2
370: , p_init_msg_list VARCHAR2
371: , x_return_status out nocopy VARCHAR2
372: , x_msg_count out nocopy NUMBER
373: , x_msg_data out nocopy VARCHAR2
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_VARCHAR2_TABLE_200
376: , p5_a2 JTF_VARCHAR2_TABLE_100
377: , p5_a3 JTF_DATE_TABLE
378: , p5_a4 JTF_NUMBER_TABLE
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_VARCHAR2_TABLE_200
376: , p5_a2 JTF_VARCHAR2_TABLE_100
377: , p5_a3 JTF_DATE_TABLE
378: , p5_a4 JTF_NUMBER_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_NUMBER_TABLE
381: , p5_a7 JTF_VARCHAR2_TABLE_100
382: , p5_a8 JTF_VARCHAR2_TABLE_2000
375: , p5_a1 JTF_VARCHAR2_TABLE_200
376: , p5_a2 JTF_VARCHAR2_TABLE_100
377: , p5_a3 JTF_DATE_TABLE
378: , p5_a4 JTF_NUMBER_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_NUMBER_TABLE
381: , p5_a7 JTF_VARCHAR2_TABLE_100
382: , p5_a8 JTF_VARCHAR2_TABLE_2000
383: , p5_a9 JTF_DATE_TABLE
376: , p5_a2 JTF_VARCHAR2_TABLE_100
377: , p5_a3 JTF_DATE_TABLE
378: , p5_a4 JTF_NUMBER_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_NUMBER_TABLE
381: , p5_a7 JTF_VARCHAR2_TABLE_100
382: , p5_a8 JTF_VARCHAR2_TABLE_2000
383: , p5_a9 JTF_DATE_TABLE
384: , p5_a10 JTF_VARCHAR2_TABLE_100
381: , p5_a7 JTF_VARCHAR2_TABLE_100
382: , p5_a8 JTF_VARCHAR2_TABLE_2000
383: , p5_a9 JTF_DATE_TABLE
384: , p5_a10 JTF_VARCHAR2_TABLE_100
385: , p5_a11 JTF_NUMBER_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_NUMBER_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
382: , p5_a8 JTF_VARCHAR2_TABLE_2000
383: , p5_a9 JTF_DATE_TABLE
384: , p5_a10 JTF_VARCHAR2_TABLE_100
385: , p5_a11 JTF_NUMBER_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_NUMBER_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
390: , p5_a16 JTF_DATE_TABLE
383: , p5_a9 JTF_DATE_TABLE
384: , p5_a10 JTF_VARCHAR2_TABLE_100
385: , p5_a11 JTF_NUMBER_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_NUMBER_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
390: , p5_a16 JTF_DATE_TABLE
391: , p5_a17 JTF_VARCHAR2_TABLE_300
384: , p5_a10 JTF_VARCHAR2_TABLE_100
385: , p5_a11 JTF_NUMBER_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_NUMBER_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
390: , p5_a16 JTF_DATE_TABLE
391: , p5_a17 JTF_VARCHAR2_TABLE_300
392: , p5_a18 JTF_VARCHAR2_TABLE_300
385: , p5_a11 JTF_NUMBER_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_NUMBER_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
390: , p5_a16 JTF_DATE_TABLE
391: , p5_a17 JTF_VARCHAR2_TABLE_300
392: , p5_a18 JTF_VARCHAR2_TABLE_300
393: , p5_a19 JTF_VARCHAR2_TABLE_300
403: , p5_a29 JTF_VARCHAR2_TABLE_300
404: , p5_a30 JTF_VARCHAR2_TABLE_300
405: , p5_a31 JTF_VARCHAR2_TABLE_300
406: , p5_a32 JTF_VARCHAR2_TABLE_300
407: , p5_a33 JTF_NUMBER_TABLE
408: , p5_a34 JTF_DATE_TABLE
409: , p5_a35 JTF_NUMBER_TABLE
410: , p5_a36 JTF_DATE_TABLE
411: , p5_a37 JTF_NUMBER_TABLE
405: , p5_a31 JTF_VARCHAR2_TABLE_300
406: , p5_a32 JTF_VARCHAR2_TABLE_300
407: , p5_a33 JTF_NUMBER_TABLE
408: , p5_a34 JTF_DATE_TABLE
409: , p5_a35 JTF_NUMBER_TABLE
410: , p5_a36 JTF_DATE_TABLE
411: , p5_a37 JTF_NUMBER_TABLE
412: );
413: procedure update_row(p_api_version NUMBER
407: , p5_a33 JTF_NUMBER_TABLE
408: , p5_a34 JTF_DATE_TABLE
409: , p5_a35 JTF_NUMBER_TABLE
410: , p5_a36 JTF_DATE_TABLE
411: , p5_a37 JTF_NUMBER_TABLE
412: );
413: procedure update_row(p_api_version NUMBER
414: , p_init_msg_list VARCHAR2
415: , x_return_status out nocopy VARCHAR2
496: , p_init_msg_list VARCHAR2
497: , x_return_status out nocopy VARCHAR2
498: , x_msg_count out nocopy NUMBER
499: , x_msg_data out nocopy VARCHAR2
500: , p5_a0 JTF_NUMBER_TABLE
501: , p5_a1 JTF_VARCHAR2_TABLE_200
502: , p5_a2 JTF_VARCHAR2_TABLE_100
503: , p5_a3 JTF_DATE_TABLE
504: , p5_a4 JTF_NUMBER_TABLE
500: , p5_a0 JTF_NUMBER_TABLE
501: , p5_a1 JTF_VARCHAR2_TABLE_200
502: , p5_a2 JTF_VARCHAR2_TABLE_100
503: , p5_a3 JTF_DATE_TABLE
504: , p5_a4 JTF_NUMBER_TABLE
505: , p5_a5 JTF_NUMBER_TABLE
506: , p5_a6 JTF_NUMBER_TABLE
507: , p5_a7 JTF_VARCHAR2_TABLE_100
508: , p5_a8 JTF_VARCHAR2_TABLE_2000
501: , p5_a1 JTF_VARCHAR2_TABLE_200
502: , p5_a2 JTF_VARCHAR2_TABLE_100
503: , p5_a3 JTF_DATE_TABLE
504: , p5_a4 JTF_NUMBER_TABLE
505: , p5_a5 JTF_NUMBER_TABLE
506: , p5_a6 JTF_NUMBER_TABLE
507: , p5_a7 JTF_VARCHAR2_TABLE_100
508: , p5_a8 JTF_VARCHAR2_TABLE_2000
509: , p5_a9 JTF_DATE_TABLE
502: , p5_a2 JTF_VARCHAR2_TABLE_100
503: , p5_a3 JTF_DATE_TABLE
504: , p5_a4 JTF_NUMBER_TABLE
505: , p5_a5 JTF_NUMBER_TABLE
506: , p5_a6 JTF_NUMBER_TABLE
507: , p5_a7 JTF_VARCHAR2_TABLE_100
508: , p5_a8 JTF_VARCHAR2_TABLE_2000
509: , p5_a9 JTF_DATE_TABLE
510: , p5_a10 JTF_VARCHAR2_TABLE_100
507: , p5_a7 JTF_VARCHAR2_TABLE_100
508: , p5_a8 JTF_VARCHAR2_TABLE_2000
509: , p5_a9 JTF_DATE_TABLE
510: , p5_a10 JTF_VARCHAR2_TABLE_100
511: , p5_a11 JTF_NUMBER_TABLE
512: , p5_a12 JTF_NUMBER_TABLE
513: , p5_a13 JTF_NUMBER_TABLE
514: , p5_a14 JTF_NUMBER_TABLE
515: , p5_a15 JTF_NUMBER_TABLE
508: , p5_a8 JTF_VARCHAR2_TABLE_2000
509: , p5_a9 JTF_DATE_TABLE
510: , p5_a10 JTF_VARCHAR2_TABLE_100
511: , p5_a11 JTF_NUMBER_TABLE
512: , p5_a12 JTF_NUMBER_TABLE
513: , p5_a13 JTF_NUMBER_TABLE
514: , p5_a14 JTF_NUMBER_TABLE
515: , p5_a15 JTF_NUMBER_TABLE
516: , p5_a16 JTF_DATE_TABLE
509: , p5_a9 JTF_DATE_TABLE
510: , p5_a10 JTF_VARCHAR2_TABLE_100
511: , p5_a11 JTF_NUMBER_TABLE
512: , p5_a12 JTF_NUMBER_TABLE
513: , p5_a13 JTF_NUMBER_TABLE
514: , p5_a14 JTF_NUMBER_TABLE
515: , p5_a15 JTF_NUMBER_TABLE
516: , p5_a16 JTF_DATE_TABLE
517: , p5_a17 JTF_VARCHAR2_TABLE_300
510: , p5_a10 JTF_VARCHAR2_TABLE_100
511: , p5_a11 JTF_NUMBER_TABLE
512: , p5_a12 JTF_NUMBER_TABLE
513: , p5_a13 JTF_NUMBER_TABLE
514: , p5_a14 JTF_NUMBER_TABLE
515: , p5_a15 JTF_NUMBER_TABLE
516: , p5_a16 JTF_DATE_TABLE
517: , p5_a17 JTF_VARCHAR2_TABLE_300
518: , p5_a18 JTF_VARCHAR2_TABLE_300
511: , p5_a11 JTF_NUMBER_TABLE
512: , p5_a12 JTF_NUMBER_TABLE
513: , p5_a13 JTF_NUMBER_TABLE
514: , p5_a14 JTF_NUMBER_TABLE
515: , p5_a15 JTF_NUMBER_TABLE
516: , p5_a16 JTF_DATE_TABLE
517: , p5_a17 JTF_VARCHAR2_TABLE_300
518: , p5_a18 JTF_VARCHAR2_TABLE_300
519: , p5_a19 JTF_VARCHAR2_TABLE_300
529: , p5_a29 JTF_VARCHAR2_TABLE_300
530: , p5_a30 JTF_VARCHAR2_TABLE_300
531: , p5_a31 JTF_VARCHAR2_TABLE_300
532: , p5_a32 JTF_VARCHAR2_TABLE_300
533: , p5_a33 JTF_NUMBER_TABLE
534: , p5_a34 JTF_DATE_TABLE
535: , p5_a35 JTF_NUMBER_TABLE
536: , p5_a36 JTF_DATE_TABLE
537: , p5_a37 JTF_NUMBER_TABLE
531: , p5_a31 JTF_VARCHAR2_TABLE_300
532: , p5_a32 JTF_VARCHAR2_TABLE_300
533: , p5_a33 JTF_NUMBER_TABLE
534: , p5_a34 JTF_DATE_TABLE
535: , p5_a35 JTF_NUMBER_TABLE
536: , p5_a36 JTF_DATE_TABLE
537: , p5_a37 JTF_NUMBER_TABLE
538: , p6_a0 out nocopy JTF_NUMBER_TABLE
539: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
533: , p5_a33 JTF_NUMBER_TABLE
534: , p5_a34 JTF_DATE_TABLE
535: , p5_a35 JTF_NUMBER_TABLE
536: , p5_a36 JTF_DATE_TABLE
537: , p5_a37 JTF_NUMBER_TABLE
538: , p6_a0 out nocopy JTF_NUMBER_TABLE
539: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
540: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
541: , p6_a3 out nocopy JTF_DATE_TABLE
534: , p5_a34 JTF_DATE_TABLE
535: , p5_a35 JTF_NUMBER_TABLE
536: , p5_a36 JTF_DATE_TABLE
537: , p5_a37 JTF_NUMBER_TABLE
538: , p6_a0 out nocopy JTF_NUMBER_TABLE
539: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
540: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
541: , p6_a3 out nocopy JTF_DATE_TABLE
542: , p6_a4 out nocopy JTF_NUMBER_TABLE
538: , p6_a0 out nocopy JTF_NUMBER_TABLE
539: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
540: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
541: , p6_a3 out nocopy JTF_DATE_TABLE
542: , p6_a4 out nocopy JTF_NUMBER_TABLE
543: , p6_a5 out nocopy JTF_NUMBER_TABLE
544: , p6_a6 out nocopy JTF_NUMBER_TABLE
545: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
539: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
540: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
541: , p6_a3 out nocopy JTF_DATE_TABLE
542: , p6_a4 out nocopy JTF_NUMBER_TABLE
543: , p6_a5 out nocopy JTF_NUMBER_TABLE
544: , p6_a6 out nocopy JTF_NUMBER_TABLE
545: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
547: , p6_a9 out nocopy JTF_DATE_TABLE
540: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
541: , p6_a3 out nocopy JTF_DATE_TABLE
542: , p6_a4 out nocopy JTF_NUMBER_TABLE
543: , p6_a5 out nocopy JTF_NUMBER_TABLE
544: , p6_a6 out nocopy JTF_NUMBER_TABLE
545: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
547: , p6_a9 out nocopy JTF_DATE_TABLE
548: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
545: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
547: , p6_a9 out nocopy JTF_DATE_TABLE
548: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
549: , p6_a11 out nocopy JTF_NUMBER_TABLE
550: , p6_a12 out nocopy JTF_NUMBER_TABLE
551: , p6_a13 out nocopy JTF_NUMBER_TABLE
552: , p6_a14 out nocopy JTF_NUMBER_TABLE
553: , p6_a15 out nocopy JTF_NUMBER_TABLE
546: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
547: , p6_a9 out nocopy JTF_DATE_TABLE
548: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
549: , p6_a11 out nocopy JTF_NUMBER_TABLE
550: , p6_a12 out nocopy JTF_NUMBER_TABLE
551: , p6_a13 out nocopy JTF_NUMBER_TABLE
552: , p6_a14 out nocopy JTF_NUMBER_TABLE
553: , p6_a15 out nocopy JTF_NUMBER_TABLE
554: , p6_a16 out nocopy JTF_DATE_TABLE
547: , p6_a9 out nocopy JTF_DATE_TABLE
548: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
549: , p6_a11 out nocopy JTF_NUMBER_TABLE
550: , p6_a12 out nocopy JTF_NUMBER_TABLE
551: , p6_a13 out nocopy JTF_NUMBER_TABLE
552: , p6_a14 out nocopy JTF_NUMBER_TABLE
553: , p6_a15 out nocopy JTF_NUMBER_TABLE
554: , p6_a16 out nocopy JTF_DATE_TABLE
555: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
548: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
549: , p6_a11 out nocopy JTF_NUMBER_TABLE
550: , p6_a12 out nocopy JTF_NUMBER_TABLE
551: , p6_a13 out nocopy JTF_NUMBER_TABLE
552: , p6_a14 out nocopy JTF_NUMBER_TABLE
553: , p6_a15 out nocopy JTF_NUMBER_TABLE
554: , p6_a16 out nocopy JTF_DATE_TABLE
555: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
556: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
549: , p6_a11 out nocopy JTF_NUMBER_TABLE
550: , p6_a12 out nocopy JTF_NUMBER_TABLE
551: , p6_a13 out nocopy JTF_NUMBER_TABLE
552: , p6_a14 out nocopy JTF_NUMBER_TABLE
553: , p6_a15 out nocopy JTF_NUMBER_TABLE
554: , p6_a16 out nocopy JTF_DATE_TABLE
555: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
556: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
557: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
567: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
568: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
569: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
570: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
571: , p6_a33 out nocopy JTF_NUMBER_TABLE
572: , p6_a34 out nocopy JTF_DATE_TABLE
573: , p6_a35 out nocopy JTF_NUMBER_TABLE
574: , p6_a36 out nocopy JTF_DATE_TABLE
575: , p6_a37 out nocopy JTF_NUMBER_TABLE
569: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
570: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
571: , p6_a33 out nocopy JTF_NUMBER_TABLE
572: , p6_a34 out nocopy JTF_DATE_TABLE
573: , p6_a35 out nocopy JTF_NUMBER_TABLE
574: , p6_a36 out nocopy JTF_DATE_TABLE
575: , p6_a37 out nocopy JTF_NUMBER_TABLE
576: );
577: procedure delete_row(p_api_version NUMBER
571: , p6_a33 out nocopy JTF_NUMBER_TABLE
572: , p6_a34 out nocopy JTF_DATE_TABLE
573: , p6_a35 out nocopy JTF_NUMBER_TABLE
574: , p6_a36 out nocopy JTF_DATE_TABLE
575: , p6_a37 out nocopy JTF_NUMBER_TABLE
576: );
577: procedure delete_row(p_api_version NUMBER
578: , p_init_msg_list VARCHAR2
579: , x_return_status out nocopy VARCHAR2
622: , p_init_msg_list VARCHAR2
623: , x_return_status out nocopy VARCHAR2
624: , x_msg_count out nocopy NUMBER
625: , x_msg_data out nocopy VARCHAR2
626: , p5_a0 JTF_NUMBER_TABLE
627: , p5_a1 JTF_VARCHAR2_TABLE_200
628: , p5_a2 JTF_VARCHAR2_TABLE_100
629: , p5_a3 JTF_DATE_TABLE
630: , p5_a4 JTF_NUMBER_TABLE
626: , p5_a0 JTF_NUMBER_TABLE
627: , p5_a1 JTF_VARCHAR2_TABLE_200
628: , p5_a2 JTF_VARCHAR2_TABLE_100
629: , p5_a3 JTF_DATE_TABLE
630: , p5_a4 JTF_NUMBER_TABLE
631: , p5_a5 JTF_NUMBER_TABLE
632: , p5_a6 JTF_NUMBER_TABLE
633: , p5_a7 JTF_VARCHAR2_TABLE_100
634: , p5_a8 JTF_VARCHAR2_TABLE_2000
627: , p5_a1 JTF_VARCHAR2_TABLE_200
628: , p5_a2 JTF_VARCHAR2_TABLE_100
629: , p5_a3 JTF_DATE_TABLE
630: , p5_a4 JTF_NUMBER_TABLE
631: , p5_a5 JTF_NUMBER_TABLE
632: , p5_a6 JTF_NUMBER_TABLE
633: , p5_a7 JTF_VARCHAR2_TABLE_100
634: , p5_a8 JTF_VARCHAR2_TABLE_2000
635: , p5_a9 JTF_DATE_TABLE
628: , p5_a2 JTF_VARCHAR2_TABLE_100
629: , p5_a3 JTF_DATE_TABLE
630: , p5_a4 JTF_NUMBER_TABLE
631: , p5_a5 JTF_NUMBER_TABLE
632: , p5_a6 JTF_NUMBER_TABLE
633: , p5_a7 JTF_VARCHAR2_TABLE_100
634: , p5_a8 JTF_VARCHAR2_TABLE_2000
635: , p5_a9 JTF_DATE_TABLE
636: , p5_a10 JTF_VARCHAR2_TABLE_100
633: , p5_a7 JTF_VARCHAR2_TABLE_100
634: , p5_a8 JTF_VARCHAR2_TABLE_2000
635: , p5_a9 JTF_DATE_TABLE
636: , p5_a10 JTF_VARCHAR2_TABLE_100
637: , p5_a11 JTF_NUMBER_TABLE
638: , p5_a12 JTF_NUMBER_TABLE
639: , p5_a13 JTF_NUMBER_TABLE
640: , p5_a14 JTF_NUMBER_TABLE
641: , p5_a15 JTF_NUMBER_TABLE
634: , p5_a8 JTF_VARCHAR2_TABLE_2000
635: , p5_a9 JTF_DATE_TABLE
636: , p5_a10 JTF_VARCHAR2_TABLE_100
637: , p5_a11 JTF_NUMBER_TABLE
638: , p5_a12 JTF_NUMBER_TABLE
639: , p5_a13 JTF_NUMBER_TABLE
640: , p5_a14 JTF_NUMBER_TABLE
641: , p5_a15 JTF_NUMBER_TABLE
642: , p5_a16 JTF_DATE_TABLE
635: , p5_a9 JTF_DATE_TABLE
636: , p5_a10 JTF_VARCHAR2_TABLE_100
637: , p5_a11 JTF_NUMBER_TABLE
638: , p5_a12 JTF_NUMBER_TABLE
639: , p5_a13 JTF_NUMBER_TABLE
640: , p5_a14 JTF_NUMBER_TABLE
641: , p5_a15 JTF_NUMBER_TABLE
642: , p5_a16 JTF_DATE_TABLE
643: , p5_a17 JTF_VARCHAR2_TABLE_300
636: , p5_a10 JTF_VARCHAR2_TABLE_100
637: , p5_a11 JTF_NUMBER_TABLE
638: , p5_a12 JTF_NUMBER_TABLE
639: , p5_a13 JTF_NUMBER_TABLE
640: , p5_a14 JTF_NUMBER_TABLE
641: , p5_a15 JTF_NUMBER_TABLE
642: , p5_a16 JTF_DATE_TABLE
643: , p5_a17 JTF_VARCHAR2_TABLE_300
644: , p5_a18 JTF_VARCHAR2_TABLE_300
637: , p5_a11 JTF_NUMBER_TABLE
638: , p5_a12 JTF_NUMBER_TABLE
639: , p5_a13 JTF_NUMBER_TABLE
640: , p5_a14 JTF_NUMBER_TABLE
641: , p5_a15 JTF_NUMBER_TABLE
642: , p5_a16 JTF_DATE_TABLE
643: , p5_a17 JTF_VARCHAR2_TABLE_300
644: , p5_a18 JTF_VARCHAR2_TABLE_300
645: , p5_a19 JTF_VARCHAR2_TABLE_300
655: , p5_a29 JTF_VARCHAR2_TABLE_300
656: , p5_a30 JTF_VARCHAR2_TABLE_300
657: , p5_a31 JTF_VARCHAR2_TABLE_300
658: , p5_a32 JTF_VARCHAR2_TABLE_300
659: , p5_a33 JTF_NUMBER_TABLE
660: , p5_a34 JTF_DATE_TABLE
661: , p5_a35 JTF_NUMBER_TABLE
662: , p5_a36 JTF_DATE_TABLE
663: , p5_a37 JTF_NUMBER_TABLE
657: , p5_a31 JTF_VARCHAR2_TABLE_300
658: , p5_a32 JTF_VARCHAR2_TABLE_300
659: , p5_a33 JTF_NUMBER_TABLE
660: , p5_a34 JTF_DATE_TABLE
661: , p5_a35 JTF_NUMBER_TABLE
662: , p5_a36 JTF_DATE_TABLE
663: , p5_a37 JTF_NUMBER_TABLE
664: );
665: procedure validate_row(p_api_version NUMBER
659: , p5_a33 JTF_NUMBER_TABLE
660: , p5_a34 JTF_DATE_TABLE
661: , p5_a35 JTF_NUMBER_TABLE
662: , p5_a36 JTF_DATE_TABLE
663: , p5_a37 JTF_NUMBER_TABLE
664: );
665: procedure validate_row(p_api_version NUMBER
666: , p_init_msg_list VARCHAR2
667: , x_return_status out nocopy VARCHAR2
710: , p_init_msg_list VARCHAR2
711: , x_return_status out nocopy VARCHAR2
712: , x_msg_count out nocopy NUMBER
713: , x_msg_data out nocopy VARCHAR2
714: , p5_a0 JTF_NUMBER_TABLE
715: , p5_a1 JTF_VARCHAR2_TABLE_200
716: , p5_a2 JTF_VARCHAR2_TABLE_100
717: , p5_a3 JTF_DATE_TABLE
718: , p5_a4 JTF_NUMBER_TABLE
714: , p5_a0 JTF_NUMBER_TABLE
715: , p5_a1 JTF_VARCHAR2_TABLE_200
716: , p5_a2 JTF_VARCHAR2_TABLE_100
717: , p5_a3 JTF_DATE_TABLE
718: , p5_a4 JTF_NUMBER_TABLE
719: , p5_a5 JTF_NUMBER_TABLE
720: , p5_a6 JTF_NUMBER_TABLE
721: , p5_a7 JTF_VARCHAR2_TABLE_100
722: , p5_a8 JTF_VARCHAR2_TABLE_2000
715: , p5_a1 JTF_VARCHAR2_TABLE_200
716: , p5_a2 JTF_VARCHAR2_TABLE_100
717: , p5_a3 JTF_DATE_TABLE
718: , p5_a4 JTF_NUMBER_TABLE
719: , p5_a5 JTF_NUMBER_TABLE
720: , p5_a6 JTF_NUMBER_TABLE
721: , p5_a7 JTF_VARCHAR2_TABLE_100
722: , p5_a8 JTF_VARCHAR2_TABLE_2000
723: , p5_a9 JTF_DATE_TABLE
716: , p5_a2 JTF_VARCHAR2_TABLE_100
717: , p5_a3 JTF_DATE_TABLE
718: , p5_a4 JTF_NUMBER_TABLE
719: , p5_a5 JTF_NUMBER_TABLE
720: , p5_a6 JTF_NUMBER_TABLE
721: , p5_a7 JTF_VARCHAR2_TABLE_100
722: , p5_a8 JTF_VARCHAR2_TABLE_2000
723: , p5_a9 JTF_DATE_TABLE
724: , p5_a10 JTF_VARCHAR2_TABLE_100
721: , p5_a7 JTF_VARCHAR2_TABLE_100
722: , p5_a8 JTF_VARCHAR2_TABLE_2000
723: , p5_a9 JTF_DATE_TABLE
724: , p5_a10 JTF_VARCHAR2_TABLE_100
725: , p5_a11 JTF_NUMBER_TABLE
726: , p5_a12 JTF_NUMBER_TABLE
727: , p5_a13 JTF_NUMBER_TABLE
728: , p5_a14 JTF_NUMBER_TABLE
729: , p5_a15 JTF_NUMBER_TABLE
722: , p5_a8 JTF_VARCHAR2_TABLE_2000
723: , p5_a9 JTF_DATE_TABLE
724: , p5_a10 JTF_VARCHAR2_TABLE_100
725: , p5_a11 JTF_NUMBER_TABLE
726: , p5_a12 JTF_NUMBER_TABLE
727: , p5_a13 JTF_NUMBER_TABLE
728: , p5_a14 JTF_NUMBER_TABLE
729: , p5_a15 JTF_NUMBER_TABLE
730: , p5_a16 JTF_DATE_TABLE
723: , p5_a9 JTF_DATE_TABLE
724: , p5_a10 JTF_VARCHAR2_TABLE_100
725: , p5_a11 JTF_NUMBER_TABLE
726: , p5_a12 JTF_NUMBER_TABLE
727: , p5_a13 JTF_NUMBER_TABLE
728: , p5_a14 JTF_NUMBER_TABLE
729: , p5_a15 JTF_NUMBER_TABLE
730: , p5_a16 JTF_DATE_TABLE
731: , p5_a17 JTF_VARCHAR2_TABLE_300
724: , p5_a10 JTF_VARCHAR2_TABLE_100
725: , p5_a11 JTF_NUMBER_TABLE
726: , p5_a12 JTF_NUMBER_TABLE
727: , p5_a13 JTF_NUMBER_TABLE
728: , p5_a14 JTF_NUMBER_TABLE
729: , p5_a15 JTF_NUMBER_TABLE
730: , p5_a16 JTF_DATE_TABLE
731: , p5_a17 JTF_VARCHAR2_TABLE_300
732: , p5_a18 JTF_VARCHAR2_TABLE_300
725: , p5_a11 JTF_NUMBER_TABLE
726: , p5_a12 JTF_NUMBER_TABLE
727: , p5_a13 JTF_NUMBER_TABLE
728: , p5_a14 JTF_NUMBER_TABLE
729: , p5_a15 JTF_NUMBER_TABLE
730: , p5_a16 JTF_DATE_TABLE
731: , p5_a17 JTF_VARCHAR2_TABLE_300
732: , p5_a18 JTF_VARCHAR2_TABLE_300
733: , p5_a19 JTF_VARCHAR2_TABLE_300
743: , p5_a29 JTF_VARCHAR2_TABLE_300
744: , p5_a30 JTF_VARCHAR2_TABLE_300
745: , p5_a31 JTF_VARCHAR2_TABLE_300
746: , p5_a32 JTF_VARCHAR2_TABLE_300
747: , p5_a33 JTF_NUMBER_TABLE
748: , p5_a34 JTF_DATE_TABLE
749: , p5_a35 JTF_NUMBER_TABLE
750: , p5_a36 JTF_DATE_TABLE
751: , p5_a37 JTF_NUMBER_TABLE
745: , p5_a31 JTF_VARCHAR2_TABLE_300
746: , p5_a32 JTF_VARCHAR2_TABLE_300
747: , p5_a33 JTF_NUMBER_TABLE
748: , p5_a34 JTF_DATE_TABLE
749: , p5_a35 JTF_NUMBER_TABLE
750: , p5_a36 JTF_DATE_TABLE
751: , p5_a37 JTF_NUMBER_TABLE
752: );
753: end okl_crt_pvt_w;
747: , p5_a33 JTF_NUMBER_TABLE
748: , p5_a34 JTF_DATE_TABLE
749: , p5_a35 JTF_NUMBER_TABLE
750: , p5_a36 JTF_DATE_TABLE
751: , p5_a37 JTF_NUMBER_TABLE
752: );
753: end okl_crt_pvt_w;