1: package okl_ipt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIIPTS.pls 115.6 2003/01/28 01:49:45 smoduga noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package okl_ipt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIIPTS.pls 115.6 2003/01/28 01:49:45 smoduga noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package okl_ipt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIIPTS.pls 115.6 2003/01/28 01:49:45 smoduga noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
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
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
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_NUMBER_TABLE
11: , a8 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_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_DATE_TABLE
47: , a6 out nocopy JTF_VARCHAR2_TABLE_100
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_DATE_TABLE
55: , a14 out nocopy JTF_DATE_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_DATE_TABLE
55: , a14 out nocopy JTF_DATE_TABLE
56: , a15 out nocopy JTF_VARCHAR2_TABLE_100
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_NUMBER_TABLE
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE
53: , a12 out nocopy JTF_NUMBER_TABLE
54: , a13 out nocopy JTF_DATE_TABLE
55: , a14 out nocopy JTF_DATE_TABLE
56: , a15 out nocopy JTF_VARCHAR2_TABLE_100
57: , a16 out nocopy JTF_VARCHAR2_TABLE_100
69: , a28 out nocopy JTF_VARCHAR2_TABLE_500
70: , a29 out nocopy JTF_VARCHAR2_TABLE_500
71: , a30 out nocopy JTF_VARCHAR2_TABLE_500
72: , a31 out nocopy JTF_VARCHAR2_TABLE_500
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
71: , a30 out nocopy JTF_VARCHAR2_TABLE_500
72: , a31 out nocopy JTF_VARCHAR2_TABLE_500
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_VARCHAR2_TABLE_100
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_VARCHAR2_TABLE_100
82: , a2 JTF_VARCHAR2_TABLE_100
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_VARCHAR2_TABLE_300
82: , a2 JTF_VARCHAR2_TABLE_100
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_VARCHAR2_TABLE_300
85: , a5 JTF_VARCHAR2_TABLE_100
86: , a6 JTF_NUMBER_TABLE
87: , a7 JTF_DATE_TABLE
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_DATE_TABLE
90: , a10 JTF_NUMBER_TABLE
84: , a4 JTF_VARCHAR2_TABLE_300
85: , a5 JTF_VARCHAR2_TABLE_100
86: , a6 JTF_NUMBER_TABLE
87: , a7 JTF_DATE_TABLE
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_DATE_TABLE
90: , a10 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a6 JTF_NUMBER_TABLE
87: , a7 JTF_DATE_TABLE
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_DATE_TABLE
90: , a10 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_VARCHAR2_TABLE_100
94: , a2 out nocopy JTF_VARCHAR2_TABLE_100
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_DATE_TABLE
90: , a10 JTF_NUMBER_TABLE
91: );
92: procedure rosetta_table_copy_out_p5(t okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_VARCHAR2_TABLE_100
94: , a2 out nocopy JTF_VARCHAR2_TABLE_100
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_300
94: , a2 out nocopy JTF_VARCHAR2_TABLE_100
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_300
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_DATE_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE
96: , a4 out nocopy JTF_VARCHAR2_TABLE_300
97: , a5 out nocopy JTF_VARCHAR2_TABLE_100
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_DATE_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE
103: );
104:
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_DATE_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_DATE_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_DATE_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_100
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_100
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE
110: , a5 JTF_VARCHAR2_TABLE_100
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_100
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE
110: , a5 JTF_VARCHAR2_TABLE_100
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_300
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_100
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE
110: , a5 JTF_VARCHAR2_TABLE_100
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_300
113: , a8 JTF_NUMBER_TABLE
109: , a4 JTF_NUMBER_TABLE
110: , a5 JTF_VARCHAR2_TABLE_100
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_300
113: , a8 JTF_NUMBER_TABLE
114: , a9 JTF_DATE_TABLE
115: , a10 JTF_NUMBER_TABLE
116: , a11 JTF_DATE_TABLE
117: , a12 JTF_VARCHAR2_TABLE_100
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_300
113: , a8 JTF_NUMBER_TABLE
114: , a9 JTF_DATE_TABLE
115: , a10 JTF_NUMBER_TABLE
116: , a11 JTF_DATE_TABLE
117: , a12 JTF_VARCHAR2_TABLE_100
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
115: , a10 JTF_NUMBER_TABLE
116: , a11 JTF_DATE_TABLE
117: , a12 JTF_VARCHAR2_TABLE_100
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
120: , a15 JTF_NUMBER_TABLE
121: , a16 JTF_NUMBER_TABLE
122: , a17 JTF_NUMBER_TABLE
123: , a18 JTF_VARCHAR2_TABLE_100
116: , a11 JTF_DATE_TABLE
117: , a12 JTF_VARCHAR2_TABLE_100
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
120: , a15 JTF_NUMBER_TABLE
121: , a16 JTF_NUMBER_TABLE
122: , a17 JTF_NUMBER_TABLE
123: , a18 JTF_VARCHAR2_TABLE_100
124: , a19 JTF_VARCHAR2_TABLE_100
117: , a12 JTF_VARCHAR2_TABLE_100
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
120: , a15 JTF_NUMBER_TABLE
121: , a16 JTF_NUMBER_TABLE
122: , a17 JTF_NUMBER_TABLE
123: , a18 JTF_VARCHAR2_TABLE_100
124: , a19 JTF_VARCHAR2_TABLE_100
125: , a20 JTF_VARCHAR2_TABLE_500
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_NUMBER_TABLE
120: , a15 JTF_NUMBER_TABLE
121: , a16 JTF_NUMBER_TABLE
122: , a17 JTF_NUMBER_TABLE
123: , a18 JTF_VARCHAR2_TABLE_100
124: , a19 JTF_VARCHAR2_TABLE_100
125: , a20 JTF_VARCHAR2_TABLE_500
126: , a21 JTF_VARCHAR2_TABLE_500
136: , a31 JTF_VARCHAR2_TABLE_500
137: , a32 JTF_VARCHAR2_TABLE_500
138: , a33 JTF_VARCHAR2_TABLE_500
139: , a34 JTF_VARCHAR2_TABLE_500
140: , a35 JTF_NUMBER_TABLE
141: , a36 JTF_DATE_TABLE
142: , a37 JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
138: , a33 JTF_VARCHAR2_TABLE_500
139: , a34 JTF_VARCHAR2_TABLE_500
140: , a35 JTF_NUMBER_TABLE
141: , a36 JTF_DATE_TABLE
142: , a37 JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
140: , a35 JTF_NUMBER_TABLE
141: , a36 JTF_DATE_TABLE
142: , a37 JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
142: , a37 JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE
143: , a38 JTF_DATE_TABLE
144: , a39 JTF_NUMBER_TABLE
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE
151: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: );
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE
151: , a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , a7 out nocopy JTF_VARCHAR2_TABLE_300
146: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE
151: , a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , a7 out nocopy JTF_VARCHAR2_TABLE_300
154: , a8 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_NUMBER_TABLE
151: , a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , a7 out nocopy JTF_VARCHAR2_TABLE_300
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_DATE_TABLE
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
152: , a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , a7 out nocopy JTF_VARCHAR2_TABLE_300
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_DATE_TABLE
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_DATE_TABLE
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_NUMBER_TABLE
163: , a17 out nocopy JTF_NUMBER_TABLE
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
157: , a11 out nocopy JTF_DATE_TABLE
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_NUMBER_TABLE
163: , a17 out nocopy JTF_NUMBER_TABLE
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , a19 out nocopy JTF_VARCHAR2_TABLE_100
158: , a12 out nocopy JTF_VARCHAR2_TABLE_100
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_NUMBER_TABLE
163: , a17 out nocopy JTF_NUMBER_TABLE
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , a19 out nocopy JTF_VARCHAR2_TABLE_100
166: , a20 out nocopy JTF_VARCHAR2_TABLE_500
159: , a13 out nocopy JTF_VARCHAR2_TABLE_100
160: , a14 out nocopy JTF_NUMBER_TABLE
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_NUMBER_TABLE
163: , a17 out nocopy JTF_NUMBER_TABLE
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , a19 out nocopy JTF_VARCHAR2_TABLE_100
166: , a20 out nocopy JTF_VARCHAR2_TABLE_500
167: , a21 out nocopy JTF_VARCHAR2_TABLE_500
177: , a31 out nocopy JTF_VARCHAR2_TABLE_500
178: , a32 out nocopy JTF_VARCHAR2_TABLE_500
179: , a33 out nocopy JTF_VARCHAR2_TABLE_500
180: , a34 out nocopy JTF_VARCHAR2_TABLE_500
181: , a35 out nocopy JTF_NUMBER_TABLE
182: , a36 out nocopy JTF_DATE_TABLE
183: , a37 out nocopy JTF_NUMBER_TABLE
184: , a38 out nocopy JTF_DATE_TABLE
185: , a39 out nocopy JTF_NUMBER_TABLE
179: , a33 out nocopy JTF_VARCHAR2_TABLE_500
180: , a34 out nocopy JTF_VARCHAR2_TABLE_500
181: , a35 out nocopy JTF_NUMBER_TABLE
182: , a36 out nocopy JTF_DATE_TABLE
183: , a37 out nocopy JTF_NUMBER_TABLE
184: , a38 out nocopy JTF_DATE_TABLE
185: , a39 out nocopy JTF_NUMBER_TABLE
186: );
187:
181: , a35 out nocopy JTF_NUMBER_TABLE
182: , a36 out nocopy JTF_DATE_TABLE
183: , a37 out nocopy JTF_NUMBER_TABLE
184: , a38 out nocopy JTF_DATE_TABLE
185: , a39 out nocopy JTF_NUMBER_TABLE
186: );
187:
188: procedure insert_row(p_api_version NUMBER
189: , p_init_msg_list VARCHAR2
275: , p_init_msg_list VARCHAR2
276: , x_return_status out nocopy VARCHAR2
277: , x_msg_count out nocopy NUMBER
278: , x_msg_data out nocopy VARCHAR2
279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
276: , x_return_status out nocopy VARCHAR2
277: , x_msg_count out nocopy NUMBER
278: , x_msg_data out nocopy VARCHAR2
279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_100
278: , x_msg_data out nocopy VARCHAR2
279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_100
285: , p5_a6 JTF_VARCHAR2_TABLE_100
286: , p5_a7 JTF_VARCHAR2_TABLE_300
279: , p5_a0 JTF_NUMBER_TABLE
280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_100
285: , p5_a6 JTF_VARCHAR2_TABLE_100
286: , p5_a7 JTF_VARCHAR2_TABLE_300
287: , p5_a8 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_100
285: , p5_a6 JTF_VARCHAR2_TABLE_100
286: , p5_a7 JTF_VARCHAR2_TABLE_300
287: , p5_a8 JTF_NUMBER_TABLE
288: , p5_a9 JTF_DATE_TABLE
289: , p5_a10 JTF_NUMBER_TABLE
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_VARCHAR2_TABLE_100
285: , p5_a6 JTF_VARCHAR2_TABLE_100
286: , p5_a7 JTF_VARCHAR2_TABLE_300
287: , p5_a8 JTF_NUMBER_TABLE
288: , p5_a9 JTF_DATE_TABLE
289: , p5_a10 JTF_NUMBER_TABLE
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_VARCHAR2_TABLE_100
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
289: , p5_a10 JTF_NUMBER_TABLE
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_VARCHAR2_TABLE_100
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
294: , p5_a15 JTF_NUMBER_TABLE
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_NUMBER_TABLE
297: , p5_a18 JTF_VARCHAR2_TABLE_100
290: , p5_a11 JTF_DATE_TABLE
291: , p5_a12 JTF_VARCHAR2_TABLE_100
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
294: , p5_a15 JTF_NUMBER_TABLE
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_NUMBER_TABLE
297: , p5_a18 JTF_VARCHAR2_TABLE_100
298: , p5_a19 JTF_VARCHAR2_TABLE_100
291: , p5_a12 JTF_VARCHAR2_TABLE_100
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
294: , p5_a15 JTF_NUMBER_TABLE
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_NUMBER_TABLE
297: , p5_a18 JTF_VARCHAR2_TABLE_100
298: , p5_a19 JTF_VARCHAR2_TABLE_100
299: , p5_a20 JTF_VARCHAR2_TABLE_500
292: , p5_a13 JTF_VARCHAR2_TABLE_100
293: , p5_a14 JTF_NUMBER_TABLE
294: , p5_a15 JTF_NUMBER_TABLE
295: , p5_a16 JTF_NUMBER_TABLE
296: , p5_a17 JTF_NUMBER_TABLE
297: , p5_a18 JTF_VARCHAR2_TABLE_100
298: , p5_a19 JTF_VARCHAR2_TABLE_100
299: , p5_a20 JTF_VARCHAR2_TABLE_500
300: , p5_a21 JTF_VARCHAR2_TABLE_500
310: , p5_a31 JTF_VARCHAR2_TABLE_500
311: , p5_a32 JTF_VARCHAR2_TABLE_500
312: , p5_a33 JTF_VARCHAR2_TABLE_500
313: , p5_a34 JTF_VARCHAR2_TABLE_500
314: , p5_a35 JTF_NUMBER_TABLE
315: , p5_a36 JTF_DATE_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
312: , p5_a33 JTF_VARCHAR2_TABLE_500
313: , p5_a34 JTF_VARCHAR2_TABLE_500
314: , p5_a35 JTF_NUMBER_TABLE
315: , p5_a36 JTF_DATE_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p5_a35 JTF_NUMBER_TABLE
315: , p5_a36 JTF_DATE_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
315: , p5_a36 JTF_DATE_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
316: , p5_a37 JTF_NUMBER_TABLE
317: , p5_a38 JTF_DATE_TABLE
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a39 JTF_NUMBER_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
327: , p6_a8 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
327: , p6_a8 out nocopy JTF_NUMBER_TABLE
328: , p6_a9 out nocopy JTF_DATE_TABLE
329: , p6_a10 out nocopy JTF_NUMBER_TABLE
330: , p6_a11 out nocopy JTF_DATE_TABLE
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
327: , p6_a8 out nocopy JTF_NUMBER_TABLE
328: , p6_a9 out nocopy JTF_DATE_TABLE
329: , p6_a10 out nocopy JTF_NUMBER_TABLE
330: , p6_a11 out nocopy JTF_DATE_TABLE
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
329: , p6_a10 out nocopy JTF_NUMBER_TABLE
330: , p6_a11 out nocopy JTF_DATE_TABLE
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
334: , p6_a15 out nocopy JTF_NUMBER_TABLE
335: , p6_a16 out nocopy JTF_NUMBER_TABLE
336: , p6_a17 out nocopy JTF_NUMBER_TABLE
337: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a11 out nocopy JTF_DATE_TABLE
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
334: , p6_a15 out nocopy JTF_NUMBER_TABLE
335: , p6_a16 out nocopy JTF_NUMBER_TABLE
336: , p6_a17 out nocopy JTF_NUMBER_TABLE
337: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
334: , p6_a15 out nocopy JTF_NUMBER_TABLE
335: , p6_a16 out nocopy JTF_NUMBER_TABLE
336: , p6_a17 out nocopy JTF_NUMBER_TABLE
337: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a14 out nocopy JTF_NUMBER_TABLE
334: , p6_a15 out nocopy JTF_NUMBER_TABLE
335: , p6_a16 out nocopy JTF_NUMBER_TABLE
336: , p6_a17 out nocopy JTF_NUMBER_TABLE
337: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
340: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
351: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
352: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
353: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
354: , p6_a35 out nocopy JTF_NUMBER_TABLE
355: , p6_a36 out nocopy JTF_DATE_TABLE
356: , p6_a37 out nocopy JTF_NUMBER_TABLE
357: , p6_a38 out nocopy JTF_DATE_TABLE
358: , p6_a39 out nocopy JTF_NUMBER_TABLE
352: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
353: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
354: , p6_a35 out nocopy JTF_NUMBER_TABLE
355: , p6_a36 out nocopy JTF_DATE_TABLE
356: , p6_a37 out nocopy JTF_NUMBER_TABLE
357: , p6_a38 out nocopy JTF_DATE_TABLE
358: , p6_a39 out nocopy JTF_NUMBER_TABLE
359: );
360: procedure lock_row(p_api_version NUMBER
354: , p6_a35 out nocopy JTF_NUMBER_TABLE
355: , p6_a36 out nocopy JTF_DATE_TABLE
356: , p6_a37 out nocopy JTF_NUMBER_TABLE
357: , p6_a38 out nocopy JTF_DATE_TABLE
358: , p6_a39 out nocopy JTF_NUMBER_TABLE
359: );
360: procedure lock_row(p_api_version NUMBER
361: , p_init_msg_list VARCHAR2
362: , x_return_status out nocopy VARCHAR2
407: , p_init_msg_list VARCHAR2
408: , x_return_status out nocopy VARCHAR2
409: , x_msg_count out nocopy NUMBER
410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_NUMBER_TABLE
408: , x_return_status out nocopy VARCHAR2
409: , x_msg_count out nocopy NUMBER
410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_NUMBER_TABLE
416: , p5_a5 JTF_VARCHAR2_TABLE_100
410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_NUMBER_TABLE
416: , p5_a5 JTF_VARCHAR2_TABLE_100
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_300
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_NUMBER_TABLE
416: , p5_a5 JTF_VARCHAR2_TABLE_100
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_300
419: , p5_a8 JTF_NUMBER_TABLE
415: , p5_a4 JTF_NUMBER_TABLE
416: , p5_a5 JTF_VARCHAR2_TABLE_100
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_300
419: , p5_a8 JTF_NUMBER_TABLE
420: , p5_a9 JTF_DATE_TABLE
421: , p5_a10 JTF_NUMBER_TABLE
422: , p5_a11 JTF_DATE_TABLE
423: , p5_a12 JTF_VARCHAR2_TABLE_100
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_300
419: , p5_a8 JTF_NUMBER_TABLE
420: , p5_a9 JTF_DATE_TABLE
421: , p5_a10 JTF_NUMBER_TABLE
422: , p5_a11 JTF_DATE_TABLE
423: , p5_a12 JTF_VARCHAR2_TABLE_100
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
421: , p5_a10 JTF_NUMBER_TABLE
422: , p5_a11 JTF_DATE_TABLE
423: , p5_a12 JTF_VARCHAR2_TABLE_100
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
426: , p5_a15 JTF_NUMBER_TABLE
427: , p5_a16 JTF_NUMBER_TABLE
428: , p5_a17 JTF_NUMBER_TABLE
429: , p5_a18 JTF_VARCHAR2_TABLE_100
422: , p5_a11 JTF_DATE_TABLE
423: , p5_a12 JTF_VARCHAR2_TABLE_100
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
426: , p5_a15 JTF_NUMBER_TABLE
427: , p5_a16 JTF_NUMBER_TABLE
428: , p5_a17 JTF_NUMBER_TABLE
429: , p5_a18 JTF_VARCHAR2_TABLE_100
430: , p5_a19 JTF_VARCHAR2_TABLE_100
423: , p5_a12 JTF_VARCHAR2_TABLE_100
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
426: , p5_a15 JTF_NUMBER_TABLE
427: , p5_a16 JTF_NUMBER_TABLE
428: , p5_a17 JTF_NUMBER_TABLE
429: , p5_a18 JTF_VARCHAR2_TABLE_100
430: , p5_a19 JTF_VARCHAR2_TABLE_100
431: , p5_a20 JTF_VARCHAR2_TABLE_500
424: , p5_a13 JTF_VARCHAR2_TABLE_100
425: , p5_a14 JTF_NUMBER_TABLE
426: , p5_a15 JTF_NUMBER_TABLE
427: , p5_a16 JTF_NUMBER_TABLE
428: , p5_a17 JTF_NUMBER_TABLE
429: , p5_a18 JTF_VARCHAR2_TABLE_100
430: , p5_a19 JTF_VARCHAR2_TABLE_100
431: , p5_a20 JTF_VARCHAR2_TABLE_500
432: , p5_a21 JTF_VARCHAR2_TABLE_500
442: , p5_a31 JTF_VARCHAR2_TABLE_500
443: , p5_a32 JTF_VARCHAR2_TABLE_500
444: , p5_a33 JTF_VARCHAR2_TABLE_500
445: , p5_a34 JTF_VARCHAR2_TABLE_500
446: , p5_a35 JTF_NUMBER_TABLE
447: , p5_a36 JTF_DATE_TABLE
448: , p5_a37 JTF_NUMBER_TABLE
449: , p5_a38 JTF_DATE_TABLE
450: , p5_a39 JTF_NUMBER_TABLE
444: , p5_a33 JTF_VARCHAR2_TABLE_500
445: , p5_a34 JTF_VARCHAR2_TABLE_500
446: , p5_a35 JTF_NUMBER_TABLE
447: , p5_a36 JTF_DATE_TABLE
448: , p5_a37 JTF_NUMBER_TABLE
449: , p5_a38 JTF_DATE_TABLE
450: , p5_a39 JTF_NUMBER_TABLE
451: );
452: procedure update_row(p_api_version NUMBER
446: , p5_a35 JTF_NUMBER_TABLE
447: , p5_a36 JTF_DATE_TABLE
448: , p5_a37 JTF_NUMBER_TABLE
449: , p5_a38 JTF_DATE_TABLE
450: , p5_a39 JTF_NUMBER_TABLE
451: );
452: procedure update_row(p_api_version NUMBER
453: , p_init_msg_list VARCHAR2
454: , x_return_status out nocopy VARCHAR2
539: , p_init_msg_list VARCHAR2
540: , x_return_status out nocopy VARCHAR2
541: , x_msg_count out nocopy NUMBER
542: , x_msg_data out nocopy VARCHAR2
543: , p5_a0 JTF_NUMBER_TABLE
544: , p5_a1 JTF_NUMBER_TABLE
545: , p5_a2 JTF_VARCHAR2_TABLE_100
546: , p5_a3 JTF_NUMBER_TABLE
547: , p5_a4 JTF_NUMBER_TABLE
540: , x_return_status out nocopy VARCHAR2
541: , x_msg_count out nocopy NUMBER
542: , x_msg_data out nocopy VARCHAR2
543: , p5_a0 JTF_NUMBER_TABLE
544: , p5_a1 JTF_NUMBER_TABLE
545: , p5_a2 JTF_VARCHAR2_TABLE_100
546: , p5_a3 JTF_NUMBER_TABLE
547: , p5_a4 JTF_NUMBER_TABLE
548: , p5_a5 JTF_VARCHAR2_TABLE_100
542: , x_msg_data out nocopy VARCHAR2
543: , p5_a0 JTF_NUMBER_TABLE
544: , p5_a1 JTF_NUMBER_TABLE
545: , p5_a2 JTF_VARCHAR2_TABLE_100
546: , p5_a3 JTF_NUMBER_TABLE
547: , p5_a4 JTF_NUMBER_TABLE
548: , p5_a5 JTF_VARCHAR2_TABLE_100
549: , p5_a6 JTF_VARCHAR2_TABLE_100
550: , p5_a7 JTF_VARCHAR2_TABLE_300
543: , p5_a0 JTF_NUMBER_TABLE
544: , p5_a1 JTF_NUMBER_TABLE
545: , p5_a2 JTF_VARCHAR2_TABLE_100
546: , p5_a3 JTF_NUMBER_TABLE
547: , p5_a4 JTF_NUMBER_TABLE
548: , p5_a5 JTF_VARCHAR2_TABLE_100
549: , p5_a6 JTF_VARCHAR2_TABLE_100
550: , p5_a7 JTF_VARCHAR2_TABLE_300
551: , p5_a8 JTF_NUMBER_TABLE
547: , p5_a4 JTF_NUMBER_TABLE
548: , p5_a5 JTF_VARCHAR2_TABLE_100
549: , p5_a6 JTF_VARCHAR2_TABLE_100
550: , p5_a7 JTF_VARCHAR2_TABLE_300
551: , p5_a8 JTF_NUMBER_TABLE
552: , p5_a9 JTF_DATE_TABLE
553: , p5_a10 JTF_NUMBER_TABLE
554: , p5_a11 JTF_DATE_TABLE
555: , p5_a12 JTF_VARCHAR2_TABLE_100
549: , p5_a6 JTF_VARCHAR2_TABLE_100
550: , p5_a7 JTF_VARCHAR2_TABLE_300
551: , p5_a8 JTF_NUMBER_TABLE
552: , p5_a9 JTF_DATE_TABLE
553: , p5_a10 JTF_NUMBER_TABLE
554: , p5_a11 JTF_DATE_TABLE
555: , p5_a12 JTF_VARCHAR2_TABLE_100
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
553: , p5_a10 JTF_NUMBER_TABLE
554: , p5_a11 JTF_DATE_TABLE
555: , p5_a12 JTF_VARCHAR2_TABLE_100
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
558: , p5_a15 JTF_NUMBER_TABLE
559: , p5_a16 JTF_NUMBER_TABLE
560: , p5_a17 JTF_NUMBER_TABLE
561: , p5_a18 JTF_VARCHAR2_TABLE_100
554: , p5_a11 JTF_DATE_TABLE
555: , p5_a12 JTF_VARCHAR2_TABLE_100
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
558: , p5_a15 JTF_NUMBER_TABLE
559: , p5_a16 JTF_NUMBER_TABLE
560: , p5_a17 JTF_NUMBER_TABLE
561: , p5_a18 JTF_VARCHAR2_TABLE_100
562: , p5_a19 JTF_VARCHAR2_TABLE_100
555: , p5_a12 JTF_VARCHAR2_TABLE_100
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
558: , p5_a15 JTF_NUMBER_TABLE
559: , p5_a16 JTF_NUMBER_TABLE
560: , p5_a17 JTF_NUMBER_TABLE
561: , p5_a18 JTF_VARCHAR2_TABLE_100
562: , p5_a19 JTF_VARCHAR2_TABLE_100
563: , p5_a20 JTF_VARCHAR2_TABLE_500
556: , p5_a13 JTF_VARCHAR2_TABLE_100
557: , p5_a14 JTF_NUMBER_TABLE
558: , p5_a15 JTF_NUMBER_TABLE
559: , p5_a16 JTF_NUMBER_TABLE
560: , p5_a17 JTF_NUMBER_TABLE
561: , p5_a18 JTF_VARCHAR2_TABLE_100
562: , p5_a19 JTF_VARCHAR2_TABLE_100
563: , p5_a20 JTF_VARCHAR2_TABLE_500
564: , p5_a21 JTF_VARCHAR2_TABLE_500
574: , p5_a31 JTF_VARCHAR2_TABLE_500
575: , p5_a32 JTF_VARCHAR2_TABLE_500
576: , p5_a33 JTF_VARCHAR2_TABLE_500
577: , p5_a34 JTF_VARCHAR2_TABLE_500
578: , p5_a35 JTF_NUMBER_TABLE
579: , p5_a36 JTF_DATE_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
576: , p5_a33 JTF_VARCHAR2_TABLE_500
577: , p5_a34 JTF_VARCHAR2_TABLE_500
578: , p5_a35 JTF_NUMBER_TABLE
579: , p5_a36 JTF_DATE_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
578: , p5_a35 JTF_NUMBER_TABLE
579: , p5_a36 JTF_DATE_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
579: , p5_a36 JTF_DATE_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE
580: , p5_a37 JTF_NUMBER_TABLE
581: , p5_a38 JTF_DATE_TABLE
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE
588: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
582: , p5_a39 JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE
588: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
589: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE
588: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
589: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
591: , p6_a8 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_NUMBER_TABLE
588: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
589: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
591: , p6_a8 out nocopy JTF_NUMBER_TABLE
592: , p6_a9 out nocopy JTF_DATE_TABLE
593: , p6_a10 out nocopy JTF_NUMBER_TABLE
594: , p6_a11 out nocopy JTF_DATE_TABLE
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
589: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
591: , p6_a8 out nocopy JTF_NUMBER_TABLE
592: , p6_a9 out nocopy JTF_DATE_TABLE
593: , p6_a10 out nocopy JTF_NUMBER_TABLE
594: , p6_a11 out nocopy JTF_DATE_TABLE
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
593: , p6_a10 out nocopy JTF_NUMBER_TABLE
594: , p6_a11 out nocopy JTF_DATE_TABLE
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
598: , p6_a15 out nocopy JTF_NUMBER_TABLE
599: , p6_a16 out nocopy JTF_NUMBER_TABLE
600: , p6_a17 out nocopy JTF_NUMBER_TABLE
601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
594: , p6_a11 out nocopy JTF_DATE_TABLE
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
598: , p6_a15 out nocopy JTF_NUMBER_TABLE
599: , p6_a16 out nocopy JTF_NUMBER_TABLE
600: , p6_a17 out nocopy JTF_NUMBER_TABLE
601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
595: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
598: , p6_a15 out nocopy JTF_NUMBER_TABLE
599: , p6_a16 out nocopy JTF_NUMBER_TABLE
600: , p6_a17 out nocopy JTF_NUMBER_TABLE
601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
596: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a14 out nocopy JTF_NUMBER_TABLE
598: , p6_a15 out nocopy JTF_NUMBER_TABLE
599: , p6_a16 out nocopy JTF_NUMBER_TABLE
600: , p6_a17 out nocopy JTF_NUMBER_TABLE
601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
604: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
614: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
615: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
616: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
617: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
618: , p6_a35 out nocopy JTF_NUMBER_TABLE
619: , p6_a36 out nocopy JTF_DATE_TABLE
620: , p6_a37 out nocopy JTF_NUMBER_TABLE
621: , p6_a38 out nocopy JTF_DATE_TABLE
622: , p6_a39 out nocopy JTF_NUMBER_TABLE
616: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
617: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
618: , p6_a35 out nocopy JTF_NUMBER_TABLE
619: , p6_a36 out nocopy JTF_DATE_TABLE
620: , p6_a37 out nocopy JTF_NUMBER_TABLE
621: , p6_a38 out nocopy JTF_DATE_TABLE
622: , p6_a39 out nocopy JTF_NUMBER_TABLE
623: );
624: procedure delete_row(p_api_version NUMBER
618: , p6_a35 out nocopy JTF_NUMBER_TABLE
619: , p6_a36 out nocopy JTF_DATE_TABLE
620: , p6_a37 out nocopy JTF_NUMBER_TABLE
621: , p6_a38 out nocopy JTF_DATE_TABLE
622: , p6_a39 out nocopy JTF_NUMBER_TABLE
623: );
624: procedure delete_row(p_api_version NUMBER
625: , p_init_msg_list VARCHAR2
626: , x_return_status out nocopy VARCHAR2
671: , p_init_msg_list VARCHAR2
672: , x_return_status out nocopy VARCHAR2
673: , x_msg_count out nocopy NUMBER
674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_NUMBER_TABLE
677: , p5_a2 JTF_VARCHAR2_TABLE_100
678: , p5_a3 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
672: , x_return_status out nocopy VARCHAR2
673: , x_msg_count out nocopy NUMBER
674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_NUMBER_TABLE
677: , p5_a2 JTF_VARCHAR2_TABLE_100
678: , p5_a3 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_VARCHAR2_TABLE_100
674: , x_msg_data out nocopy VARCHAR2
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_NUMBER_TABLE
677: , p5_a2 JTF_VARCHAR2_TABLE_100
678: , p5_a3 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_VARCHAR2_TABLE_100
681: , p5_a6 JTF_VARCHAR2_TABLE_100
682: , p5_a7 JTF_VARCHAR2_TABLE_300
675: , p5_a0 JTF_NUMBER_TABLE
676: , p5_a1 JTF_NUMBER_TABLE
677: , p5_a2 JTF_VARCHAR2_TABLE_100
678: , p5_a3 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_VARCHAR2_TABLE_100
681: , p5_a6 JTF_VARCHAR2_TABLE_100
682: , p5_a7 JTF_VARCHAR2_TABLE_300
683: , p5_a8 JTF_NUMBER_TABLE
679: , p5_a4 JTF_NUMBER_TABLE
680: , p5_a5 JTF_VARCHAR2_TABLE_100
681: , p5_a6 JTF_VARCHAR2_TABLE_100
682: , p5_a7 JTF_VARCHAR2_TABLE_300
683: , p5_a8 JTF_NUMBER_TABLE
684: , p5_a9 JTF_DATE_TABLE
685: , p5_a10 JTF_NUMBER_TABLE
686: , p5_a11 JTF_DATE_TABLE
687: , p5_a12 JTF_VARCHAR2_TABLE_100
681: , p5_a6 JTF_VARCHAR2_TABLE_100
682: , p5_a7 JTF_VARCHAR2_TABLE_300
683: , p5_a8 JTF_NUMBER_TABLE
684: , p5_a9 JTF_DATE_TABLE
685: , p5_a10 JTF_NUMBER_TABLE
686: , p5_a11 JTF_DATE_TABLE
687: , p5_a12 JTF_VARCHAR2_TABLE_100
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
685: , p5_a10 JTF_NUMBER_TABLE
686: , p5_a11 JTF_DATE_TABLE
687: , p5_a12 JTF_VARCHAR2_TABLE_100
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
690: , p5_a15 JTF_NUMBER_TABLE
691: , p5_a16 JTF_NUMBER_TABLE
692: , p5_a17 JTF_NUMBER_TABLE
693: , p5_a18 JTF_VARCHAR2_TABLE_100
686: , p5_a11 JTF_DATE_TABLE
687: , p5_a12 JTF_VARCHAR2_TABLE_100
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
690: , p5_a15 JTF_NUMBER_TABLE
691: , p5_a16 JTF_NUMBER_TABLE
692: , p5_a17 JTF_NUMBER_TABLE
693: , p5_a18 JTF_VARCHAR2_TABLE_100
694: , p5_a19 JTF_VARCHAR2_TABLE_100
687: , p5_a12 JTF_VARCHAR2_TABLE_100
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
690: , p5_a15 JTF_NUMBER_TABLE
691: , p5_a16 JTF_NUMBER_TABLE
692: , p5_a17 JTF_NUMBER_TABLE
693: , p5_a18 JTF_VARCHAR2_TABLE_100
694: , p5_a19 JTF_VARCHAR2_TABLE_100
695: , p5_a20 JTF_VARCHAR2_TABLE_500
688: , p5_a13 JTF_VARCHAR2_TABLE_100
689: , p5_a14 JTF_NUMBER_TABLE
690: , p5_a15 JTF_NUMBER_TABLE
691: , p5_a16 JTF_NUMBER_TABLE
692: , p5_a17 JTF_NUMBER_TABLE
693: , p5_a18 JTF_VARCHAR2_TABLE_100
694: , p5_a19 JTF_VARCHAR2_TABLE_100
695: , p5_a20 JTF_VARCHAR2_TABLE_500
696: , p5_a21 JTF_VARCHAR2_TABLE_500
706: , p5_a31 JTF_VARCHAR2_TABLE_500
707: , p5_a32 JTF_VARCHAR2_TABLE_500
708: , p5_a33 JTF_VARCHAR2_TABLE_500
709: , p5_a34 JTF_VARCHAR2_TABLE_500
710: , p5_a35 JTF_NUMBER_TABLE
711: , p5_a36 JTF_DATE_TABLE
712: , p5_a37 JTF_NUMBER_TABLE
713: , p5_a38 JTF_DATE_TABLE
714: , p5_a39 JTF_NUMBER_TABLE
708: , p5_a33 JTF_VARCHAR2_TABLE_500
709: , p5_a34 JTF_VARCHAR2_TABLE_500
710: , p5_a35 JTF_NUMBER_TABLE
711: , p5_a36 JTF_DATE_TABLE
712: , p5_a37 JTF_NUMBER_TABLE
713: , p5_a38 JTF_DATE_TABLE
714: , p5_a39 JTF_NUMBER_TABLE
715: );
716: procedure validate_row(p_api_version NUMBER
710: , p5_a35 JTF_NUMBER_TABLE
711: , p5_a36 JTF_DATE_TABLE
712: , p5_a37 JTF_NUMBER_TABLE
713: , p5_a38 JTF_DATE_TABLE
714: , p5_a39 JTF_NUMBER_TABLE
715: );
716: procedure validate_row(p_api_version NUMBER
717: , p_init_msg_list VARCHAR2
718: , x_return_status out nocopy VARCHAR2
763: , p_init_msg_list VARCHAR2
764: , x_return_status out nocopy VARCHAR2
765: , x_msg_count out nocopy NUMBER
766: , x_msg_data out nocopy VARCHAR2
767: , p5_a0 JTF_NUMBER_TABLE
768: , p5_a1 JTF_NUMBER_TABLE
769: , p5_a2 JTF_VARCHAR2_TABLE_100
770: , p5_a3 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE
764: , x_return_status out nocopy VARCHAR2
765: , x_msg_count out nocopy NUMBER
766: , x_msg_data out nocopy VARCHAR2
767: , p5_a0 JTF_NUMBER_TABLE
768: , p5_a1 JTF_NUMBER_TABLE
769: , p5_a2 JTF_VARCHAR2_TABLE_100
770: , p5_a3 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE
772: , p5_a5 JTF_VARCHAR2_TABLE_100
766: , x_msg_data out nocopy VARCHAR2
767: , p5_a0 JTF_NUMBER_TABLE
768: , p5_a1 JTF_NUMBER_TABLE
769: , p5_a2 JTF_VARCHAR2_TABLE_100
770: , p5_a3 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE
772: , p5_a5 JTF_VARCHAR2_TABLE_100
773: , p5_a6 JTF_VARCHAR2_TABLE_100
774: , p5_a7 JTF_VARCHAR2_TABLE_300
767: , p5_a0 JTF_NUMBER_TABLE
768: , p5_a1 JTF_NUMBER_TABLE
769: , p5_a2 JTF_VARCHAR2_TABLE_100
770: , p5_a3 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE
772: , p5_a5 JTF_VARCHAR2_TABLE_100
773: , p5_a6 JTF_VARCHAR2_TABLE_100
774: , p5_a7 JTF_VARCHAR2_TABLE_300
775: , p5_a8 JTF_NUMBER_TABLE
771: , p5_a4 JTF_NUMBER_TABLE
772: , p5_a5 JTF_VARCHAR2_TABLE_100
773: , p5_a6 JTF_VARCHAR2_TABLE_100
774: , p5_a7 JTF_VARCHAR2_TABLE_300
775: , p5_a8 JTF_NUMBER_TABLE
776: , p5_a9 JTF_DATE_TABLE
777: , p5_a10 JTF_NUMBER_TABLE
778: , p5_a11 JTF_DATE_TABLE
779: , p5_a12 JTF_VARCHAR2_TABLE_100
773: , p5_a6 JTF_VARCHAR2_TABLE_100
774: , p5_a7 JTF_VARCHAR2_TABLE_300
775: , p5_a8 JTF_NUMBER_TABLE
776: , p5_a9 JTF_DATE_TABLE
777: , p5_a10 JTF_NUMBER_TABLE
778: , p5_a11 JTF_DATE_TABLE
779: , p5_a12 JTF_VARCHAR2_TABLE_100
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
777: , p5_a10 JTF_NUMBER_TABLE
778: , p5_a11 JTF_DATE_TABLE
779: , p5_a12 JTF_VARCHAR2_TABLE_100
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
782: , p5_a15 JTF_NUMBER_TABLE
783: , p5_a16 JTF_NUMBER_TABLE
784: , p5_a17 JTF_NUMBER_TABLE
785: , p5_a18 JTF_VARCHAR2_TABLE_100
778: , p5_a11 JTF_DATE_TABLE
779: , p5_a12 JTF_VARCHAR2_TABLE_100
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
782: , p5_a15 JTF_NUMBER_TABLE
783: , p5_a16 JTF_NUMBER_TABLE
784: , p5_a17 JTF_NUMBER_TABLE
785: , p5_a18 JTF_VARCHAR2_TABLE_100
786: , p5_a19 JTF_VARCHAR2_TABLE_100
779: , p5_a12 JTF_VARCHAR2_TABLE_100
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
782: , p5_a15 JTF_NUMBER_TABLE
783: , p5_a16 JTF_NUMBER_TABLE
784: , p5_a17 JTF_NUMBER_TABLE
785: , p5_a18 JTF_VARCHAR2_TABLE_100
786: , p5_a19 JTF_VARCHAR2_TABLE_100
787: , p5_a20 JTF_VARCHAR2_TABLE_500
780: , p5_a13 JTF_VARCHAR2_TABLE_100
781: , p5_a14 JTF_NUMBER_TABLE
782: , p5_a15 JTF_NUMBER_TABLE
783: , p5_a16 JTF_NUMBER_TABLE
784: , p5_a17 JTF_NUMBER_TABLE
785: , p5_a18 JTF_VARCHAR2_TABLE_100
786: , p5_a19 JTF_VARCHAR2_TABLE_100
787: , p5_a20 JTF_VARCHAR2_TABLE_500
788: , p5_a21 JTF_VARCHAR2_TABLE_500
798: , p5_a31 JTF_VARCHAR2_TABLE_500
799: , p5_a32 JTF_VARCHAR2_TABLE_500
800: , p5_a33 JTF_VARCHAR2_TABLE_500
801: , p5_a34 JTF_VARCHAR2_TABLE_500
802: , p5_a35 JTF_NUMBER_TABLE
803: , p5_a36 JTF_DATE_TABLE
804: , p5_a37 JTF_NUMBER_TABLE
805: , p5_a38 JTF_DATE_TABLE
806: , p5_a39 JTF_NUMBER_TABLE
800: , p5_a33 JTF_VARCHAR2_TABLE_500
801: , p5_a34 JTF_VARCHAR2_TABLE_500
802: , p5_a35 JTF_NUMBER_TABLE
803: , p5_a36 JTF_DATE_TABLE
804: , p5_a37 JTF_NUMBER_TABLE
805: , p5_a38 JTF_DATE_TABLE
806: , p5_a39 JTF_NUMBER_TABLE
807: );
808: end okl_ipt_pvt_w;
802: , p5_a35 JTF_NUMBER_TABLE
803: , p5_a36 JTF_DATE_TABLE
804: , p5_a37 JTF_NUMBER_TABLE
805: , p5_a38 JTF_DATE_TABLE
806: , p5_a39 JTF_NUMBER_TABLE
807: );
808: end okl_ipt_pvt_w;