1: package okl_sir_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLISIRS.pls 120.1 2005/07/14 12:00:17 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sir_pvt.sir_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
1: package okl_sir_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLISIRS.pls 120.1 2005/07/14 12:00:17 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sir_pvt.sir_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: OKLISIRS.pls 120.1 2005/07/14 12:00:17 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sir_pvt.sir_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_500
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500
15: , a12 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_sir_pvt.sir_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_sir_pvt.sir_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_sir_pvt.sir_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_200
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_sir_pvt.sir_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_200
45: , a5 out nocopy JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_sir_pvt.sir_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_200
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_200
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_VARCHAR2_TABLE_500
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_200
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_VARCHAR2_TABLE_500
50: , a10 out nocopy JTF_VARCHAR2_TABLE_500
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_200
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_VARCHAR2_TABLE_500
50: , a10 out nocopy JTF_VARCHAR2_TABLE_500
51: , a11 out nocopy JTF_VARCHAR2_TABLE_500
44: , a4 out nocopy JTF_VARCHAR2_TABLE_200
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_VARCHAR2_TABLE_500
50: , a10 out nocopy JTF_VARCHAR2_TABLE_500
51: , a11 out nocopy JTF_VARCHAR2_TABLE_500
52: , a12 out nocopy JTF_VARCHAR2_TABLE_500
60: , a20 out nocopy JTF_VARCHAR2_TABLE_500
61: , a21 out nocopy JTF_VARCHAR2_TABLE_500
62: , a22 out nocopy JTF_VARCHAR2_TABLE_500
63: , a23 out nocopy JTF_VARCHAR2_TABLE_500
64: , a24 out nocopy JTF_NUMBER_TABLE
65: , a25 out nocopy JTF_NUMBER_TABLE
66: , a26 out nocopy JTF_NUMBER_TABLE
67: , a27 out nocopy JTF_DATE_TABLE
68: , a28 out nocopy JTF_DATE_TABLE
61: , a21 out nocopy JTF_VARCHAR2_TABLE_500
62: , a22 out nocopy JTF_VARCHAR2_TABLE_500
63: , a23 out nocopy JTF_VARCHAR2_TABLE_500
64: , a24 out nocopy JTF_NUMBER_TABLE
65: , a25 out nocopy JTF_NUMBER_TABLE
66: , a26 out nocopy JTF_NUMBER_TABLE
67: , a27 out nocopy JTF_DATE_TABLE
68: , a28 out nocopy JTF_DATE_TABLE
69: , a29 out nocopy JTF_NUMBER_TABLE
62: , a22 out nocopy JTF_VARCHAR2_TABLE_500
63: , a23 out nocopy JTF_VARCHAR2_TABLE_500
64: , a24 out nocopy JTF_NUMBER_TABLE
65: , a25 out nocopy JTF_NUMBER_TABLE
66: , a26 out nocopy JTF_NUMBER_TABLE
67: , a27 out nocopy JTF_DATE_TABLE
68: , a28 out nocopy JTF_DATE_TABLE
69: , a29 out nocopy JTF_NUMBER_TABLE
70: , a30 out nocopy JTF_NUMBER_TABLE
65: , a25 out nocopy JTF_NUMBER_TABLE
66: , a26 out nocopy JTF_NUMBER_TABLE
67: , a27 out nocopy JTF_DATE_TABLE
68: , a28 out nocopy JTF_DATE_TABLE
69: , a29 out nocopy JTF_NUMBER_TABLE
70: , a30 out nocopy JTF_NUMBER_TABLE
71: , a31 out nocopy JTF_DATE_TABLE
72: , a32 out nocopy JTF_NUMBER_TABLE
73: , a33 out nocopy JTF_NUMBER_TABLE
66: , a26 out nocopy JTF_NUMBER_TABLE
67: , a27 out nocopy JTF_DATE_TABLE
68: , a28 out nocopy JTF_DATE_TABLE
69: , a29 out nocopy JTF_NUMBER_TABLE
70: , a30 out nocopy JTF_NUMBER_TABLE
71: , a31 out nocopy JTF_DATE_TABLE
72: , a32 out nocopy JTF_NUMBER_TABLE
73: , a33 out nocopy JTF_NUMBER_TABLE
74: , a34 out nocopy JTF_NUMBER_TABLE
68: , a28 out nocopy JTF_DATE_TABLE
69: , a29 out nocopy JTF_NUMBER_TABLE
70: , a30 out nocopy JTF_NUMBER_TABLE
71: , a31 out nocopy JTF_DATE_TABLE
72: , a32 out nocopy JTF_NUMBER_TABLE
73: , a33 out nocopy JTF_NUMBER_TABLE
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
76: );
69: , a29 out nocopy JTF_NUMBER_TABLE
70: , a30 out nocopy JTF_NUMBER_TABLE
71: , a31 out nocopy JTF_DATE_TABLE
72: , a32 out nocopy JTF_NUMBER_TABLE
73: , a33 out nocopy JTF_NUMBER_TABLE
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
76: );
77:
70: , a30 out nocopy JTF_NUMBER_TABLE
71: , a31 out nocopy JTF_DATE_TABLE
72: , a32 out nocopy JTF_NUMBER_TABLE
73: , a33 out nocopy JTF_NUMBER_TABLE
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
76: );
77:
78: procedure rosetta_table_copy_in_p5(t out nocopy okl_sir_pvt.sirv_tbl_type, a0 JTF_NUMBER_TABLE
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
76: );
77:
78: procedure rosetta_table_copy_in_p5(t out nocopy okl_sir_pvt.sirv_tbl_type, a0 JTF_NUMBER_TABLE
79: , a1 JTF_NUMBER_TABLE
80: , a2 JTF_VARCHAR2_TABLE_100
81: , a3 JTF_NUMBER_TABLE
82: , a4 JTF_VARCHAR2_TABLE_200
75: , a35 out nocopy JTF_DATE_TABLE
76: );
77:
78: procedure rosetta_table_copy_in_p5(t out nocopy okl_sir_pvt.sirv_tbl_type, a0 JTF_NUMBER_TABLE
79: , a1 JTF_NUMBER_TABLE
80: , a2 JTF_VARCHAR2_TABLE_100
81: , a3 JTF_NUMBER_TABLE
82: , a4 JTF_VARCHAR2_TABLE_200
83: , a5 JTF_NUMBER_TABLE
77:
78: procedure rosetta_table_copy_in_p5(t out nocopy okl_sir_pvt.sirv_tbl_type, a0 JTF_NUMBER_TABLE
79: , a1 JTF_NUMBER_TABLE
80: , a2 JTF_VARCHAR2_TABLE_100
81: , a3 JTF_NUMBER_TABLE
82: , a4 JTF_VARCHAR2_TABLE_200
83: , a5 JTF_NUMBER_TABLE
84: , a6 JTF_NUMBER_TABLE
85: , a7 JTF_NUMBER_TABLE
79: , a1 JTF_NUMBER_TABLE
80: , a2 JTF_VARCHAR2_TABLE_100
81: , a3 JTF_NUMBER_TABLE
82: , a4 JTF_VARCHAR2_TABLE_200
83: , a5 JTF_NUMBER_TABLE
84: , a6 JTF_NUMBER_TABLE
85: , a7 JTF_NUMBER_TABLE
86: , a8 JTF_NUMBER_TABLE
87: , a9 JTF_VARCHAR2_TABLE_500
80: , a2 JTF_VARCHAR2_TABLE_100
81: , a3 JTF_NUMBER_TABLE
82: , a4 JTF_VARCHAR2_TABLE_200
83: , a5 JTF_NUMBER_TABLE
84: , a6 JTF_NUMBER_TABLE
85: , a7 JTF_NUMBER_TABLE
86: , a8 JTF_NUMBER_TABLE
87: , a9 JTF_VARCHAR2_TABLE_500
88: , a10 JTF_VARCHAR2_TABLE_500
81: , a3 JTF_NUMBER_TABLE
82: , a4 JTF_VARCHAR2_TABLE_200
83: , a5 JTF_NUMBER_TABLE
84: , a6 JTF_NUMBER_TABLE
85: , a7 JTF_NUMBER_TABLE
86: , a8 JTF_NUMBER_TABLE
87: , a9 JTF_VARCHAR2_TABLE_500
88: , a10 JTF_VARCHAR2_TABLE_500
89: , a11 JTF_VARCHAR2_TABLE_500
82: , a4 JTF_VARCHAR2_TABLE_200
83: , a5 JTF_NUMBER_TABLE
84: , a6 JTF_NUMBER_TABLE
85: , a7 JTF_NUMBER_TABLE
86: , a8 JTF_NUMBER_TABLE
87: , a9 JTF_VARCHAR2_TABLE_500
88: , a10 JTF_VARCHAR2_TABLE_500
89: , a11 JTF_VARCHAR2_TABLE_500
90: , a12 JTF_VARCHAR2_TABLE_500
98: , a20 JTF_VARCHAR2_TABLE_500
99: , a21 JTF_VARCHAR2_TABLE_500
100: , a22 JTF_VARCHAR2_TABLE_500
101: , a23 JTF_VARCHAR2_TABLE_500
102: , a24 JTF_NUMBER_TABLE
103: , a25 JTF_NUMBER_TABLE
104: , a26 JTF_NUMBER_TABLE
105: , a27 JTF_DATE_TABLE
106: , a28 JTF_DATE_TABLE
99: , a21 JTF_VARCHAR2_TABLE_500
100: , a22 JTF_VARCHAR2_TABLE_500
101: , a23 JTF_VARCHAR2_TABLE_500
102: , a24 JTF_NUMBER_TABLE
103: , a25 JTF_NUMBER_TABLE
104: , a26 JTF_NUMBER_TABLE
105: , a27 JTF_DATE_TABLE
106: , a28 JTF_DATE_TABLE
107: , a29 JTF_NUMBER_TABLE
100: , a22 JTF_VARCHAR2_TABLE_500
101: , a23 JTF_VARCHAR2_TABLE_500
102: , a24 JTF_NUMBER_TABLE
103: , a25 JTF_NUMBER_TABLE
104: , a26 JTF_NUMBER_TABLE
105: , a27 JTF_DATE_TABLE
106: , a28 JTF_DATE_TABLE
107: , a29 JTF_NUMBER_TABLE
108: , a30 JTF_NUMBER_TABLE
103: , a25 JTF_NUMBER_TABLE
104: , a26 JTF_NUMBER_TABLE
105: , a27 JTF_DATE_TABLE
106: , a28 JTF_DATE_TABLE
107: , a29 JTF_NUMBER_TABLE
108: , a30 JTF_NUMBER_TABLE
109: , a31 JTF_DATE_TABLE
110: , a32 JTF_NUMBER_TABLE
111: , a33 JTF_NUMBER_TABLE
104: , a26 JTF_NUMBER_TABLE
105: , a27 JTF_DATE_TABLE
106: , a28 JTF_DATE_TABLE
107: , a29 JTF_NUMBER_TABLE
108: , a30 JTF_NUMBER_TABLE
109: , a31 JTF_DATE_TABLE
110: , a32 JTF_NUMBER_TABLE
111: , a33 JTF_NUMBER_TABLE
112: , a34 JTF_NUMBER_TABLE
106: , a28 JTF_DATE_TABLE
107: , a29 JTF_NUMBER_TABLE
108: , a30 JTF_NUMBER_TABLE
109: , a31 JTF_DATE_TABLE
110: , a32 JTF_NUMBER_TABLE
111: , a33 JTF_NUMBER_TABLE
112: , a34 JTF_NUMBER_TABLE
113: , a35 JTF_DATE_TABLE
114: );
107: , a29 JTF_NUMBER_TABLE
108: , a30 JTF_NUMBER_TABLE
109: , a31 JTF_DATE_TABLE
110: , a32 JTF_NUMBER_TABLE
111: , a33 JTF_NUMBER_TABLE
112: , a34 JTF_NUMBER_TABLE
113: , a35 JTF_DATE_TABLE
114: );
115: procedure rosetta_table_copy_out_p5(t okl_sir_pvt.sirv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a30 JTF_NUMBER_TABLE
109: , a31 JTF_DATE_TABLE
110: , a32 JTF_NUMBER_TABLE
111: , a33 JTF_NUMBER_TABLE
112: , a34 JTF_NUMBER_TABLE
113: , a35 JTF_DATE_TABLE
114: );
115: procedure rosetta_table_copy_out_p5(t okl_sir_pvt.sirv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
111: , a33 JTF_NUMBER_TABLE
112: , a34 JTF_NUMBER_TABLE
113: , a35 JTF_DATE_TABLE
114: );
115: procedure rosetta_table_copy_out_p5(t okl_sir_pvt.sirv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_200
112: , a34 JTF_NUMBER_TABLE
113: , a35 JTF_DATE_TABLE
114: );
115: procedure rosetta_table_copy_out_p5(t okl_sir_pvt.sirv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_200
120: , a5 out nocopy JTF_NUMBER_TABLE
114: );
115: procedure rosetta_table_copy_out_p5(t okl_sir_pvt.sirv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_200
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_200
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_NUMBER_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_500
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_200
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_NUMBER_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_500
125: , a10 out nocopy JTF_VARCHAR2_TABLE_500
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_200
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_NUMBER_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_500
125: , a10 out nocopy JTF_VARCHAR2_TABLE_500
126: , a11 out nocopy JTF_VARCHAR2_TABLE_500
119: , a4 out nocopy JTF_VARCHAR2_TABLE_200
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_NUMBER_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_500
125: , a10 out nocopy JTF_VARCHAR2_TABLE_500
126: , a11 out nocopy JTF_VARCHAR2_TABLE_500
127: , a12 out nocopy JTF_VARCHAR2_TABLE_500
135: , a20 out nocopy JTF_VARCHAR2_TABLE_500
136: , a21 out nocopy JTF_VARCHAR2_TABLE_500
137: , a22 out nocopy JTF_VARCHAR2_TABLE_500
138: , a23 out nocopy JTF_VARCHAR2_TABLE_500
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_NUMBER_TABLE
142: , a27 out nocopy JTF_DATE_TABLE
143: , a28 out nocopy JTF_DATE_TABLE
136: , a21 out nocopy JTF_VARCHAR2_TABLE_500
137: , a22 out nocopy JTF_VARCHAR2_TABLE_500
138: , a23 out nocopy JTF_VARCHAR2_TABLE_500
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_NUMBER_TABLE
142: , a27 out nocopy JTF_DATE_TABLE
143: , a28 out nocopy JTF_DATE_TABLE
144: , a29 out nocopy JTF_NUMBER_TABLE
137: , a22 out nocopy JTF_VARCHAR2_TABLE_500
138: , a23 out nocopy JTF_VARCHAR2_TABLE_500
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_NUMBER_TABLE
142: , a27 out nocopy JTF_DATE_TABLE
143: , a28 out nocopy JTF_DATE_TABLE
144: , a29 out nocopy JTF_NUMBER_TABLE
145: , a30 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_NUMBER_TABLE
142: , a27 out nocopy JTF_DATE_TABLE
143: , a28 out nocopy JTF_DATE_TABLE
144: , a29 out nocopy JTF_NUMBER_TABLE
145: , a30 out nocopy JTF_NUMBER_TABLE
146: , a31 out nocopy JTF_DATE_TABLE
147: , a32 out nocopy JTF_NUMBER_TABLE
148: , a33 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_NUMBER_TABLE
142: , a27 out nocopy JTF_DATE_TABLE
143: , a28 out nocopy JTF_DATE_TABLE
144: , a29 out nocopy JTF_NUMBER_TABLE
145: , a30 out nocopy JTF_NUMBER_TABLE
146: , a31 out nocopy JTF_DATE_TABLE
147: , a32 out nocopy JTF_NUMBER_TABLE
148: , a33 out nocopy JTF_NUMBER_TABLE
149: , a34 out nocopy JTF_NUMBER_TABLE
143: , a28 out nocopy JTF_DATE_TABLE
144: , a29 out nocopy JTF_NUMBER_TABLE
145: , a30 out nocopy JTF_NUMBER_TABLE
146: , a31 out nocopy JTF_DATE_TABLE
147: , a32 out nocopy JTF_NUMBER_TABLE
148: , a33 out nocopy JTF_NUMBER_TABLE
149: , a34 out nocopy JTF_NUMBER_TABLE
150: , a35 out nocopy JTF_DATE_TABLE
151: );
144: , a29 out nocopy JTF_NUMBER_TABLE
145: , a30 out nocopy JTF_NUMBER_TABLE
146: , a31 out nocopy JTF_DATE_TABLE
147: , a32 out nocopy JTF_NUMBER_TABLE
148: , a33 out nocopy JTF_NUMBER_TABLE
149: , a34 out nocopy JTF_NUMBER_TABLE
150: , a35 out nocopy JTF_DATE_TABLE
151: );
152:
145: , a30 out nocopy JTF_NUMBER_TABLE
146: , a31 out nocopy JTF_DATE_TABLE
147: , a32 out nocopy JTF_NUMBER_TABLE
148: , a33 out nocopy JTF_NUMBER_TABLE
149: , a34 out nocopy JTF_NUMBER_TABLE
150: , a35 out nocopy JTF_DATE_TABLE
151: );
152:
153: procedure insert_row(p_api_version NUMBER
232: , p_init_msg_list VARCHAR2
233: , x_return_status out nocopy VARCHAR2
234: , x_msg_count out nocopy NUMBER
235: , x_msg_data out nocopy VARCHAR2
236: , p5_a0 JTF_NUMBER_TABLE
237: , p5_a1 JTF_NUMBER_TABLE
238: , p5_a2 JTF_VARCHAR2_TABLE_100
239: , p5_a3 JTF_NUMBER_TABLE
240: , p5_a4 JTF_VARCHAR2_TABLE_200
233: , x_return_status out nocopy VARCHAR2
234: , x_msg_count out nocopy NUMBER
235: , x_msg_data out nocopy VARCHAR2
236: , p5_a0 JTF_NUMBER_TABLE
237: , p5_a1 JTF_NUMBER_TABLE
238: , p5_a2 JTF_VARCHAR2_TABLE_100
239: , p5_a3 JTF_NUMBER_TABLE
240: , p5_a4 JTF_VARCHAR2_TABLE_200
241: , p5_a5 JTF_NUMBER_TABLE
235: , x_msg_data out nocopy VARCHAR2
236: , p5_a0 JTF_NUMBER_TABLE
237: , p5_a1 JTF_NUMBER_TABLE
238: , p5_a2 JTF_VARCHAR2_TABLE_100
239: , p5_a3 JTF_NUMBER_TABLE
240: , p5_a4 JTF_VARCHAR2_TABLE_200
241: , p5_a5 JTF_NUMBER_TABLE
242: , p5_a6 JTF_NUMBER_TABLE
243: , p5_a7 JTF_NUMBER_TABLE
237: , p5_a1 JTF_NUMBER_TABLE
238: , p5_a2 JTF_VARCHAR2_TABLE_100
239: , p5_a3 JTF_NUMBER_TABLE
240: , p5_a4 JTF_VARCHAR2_TABLE_200
241: , p5_a5 JTF_NUMBER_TABLE
242: , p5_a6 JTF_NUMBER_TABLE
243: , p5_a7 JTF_NUMBER_TABLE
244: , p5_a8 JTF_NUMBER_TABLE
245: , p5_a9 JTF_VARCHAR2_TABLE_500
238: , p5_a2 JTF_VARCHAR2_TABLE_100
239: , p5_a3 JTF_NUMBER_TABLE
240: , p5_a4 JTF_VARCHAR2_TABLE_200
241: , p5_a5 JTF_NUMBER_TABLE
242: , p5_a6 JTF_NUMBER_TABLE
243: , p5_a7 JTF_NUMBER_TABLE
244: , p5_a8 JTF_NUMBER_TABLE
245: , p5_a9 JTF_VARCHAR2_TABLE_500
246: , p5_a10 JTF_VARCHAR2_TABLE_500
239: , p5_a3 JTF_NUMBER_TABLE
240: , p5_a4 JTF_VARCHAR2_TABLE_200
241: , p5_a5 JTF_NUMBER_TABLE
242: , p5_a6 JTF_NUMBER_TABLE
243: , p5_a7 JTF_NUMBER_TABLE
244: , p5_a8 JTF_NUMBER_TABLE
245: , p5_a9 JTF_VARCHAR2_TABLE_500
246: , p5_a10 JTF_VARCHAR2_TABLE_500
247: , p5_a11 JTF_VARCHAR2_TABLE_500
240: , p5_a4 JTF_VARCHAR2_TABLE_200
241: , p5_a5 JTF_NUMBER_TABLE
242: , p5_a6 JTF_NUMBER_TABLE
243: , p5_a7 JTF_NUMBER_TABLE
244: , p5_a8 JTF_NUMBER_TABLE
245: , p5_a9 JTF_VARCHAR2_TABLE_500
246: , p5_a10 JTF_VARCHAR2_TABLE_500
247: , p5_a11 JTF_VARCHAR2_TABLE_500
248: , p5_a12 JTF_VARCHAR2_TABLE_500
256: , p5_a20 JTF_VARCHAR2_TABLE_500
257: , p5_a21 JTF_VARCHAR2_TABLE_500
258: , p5_a22 JTF_VARCHAR2_TABLE_500
259: , p5_a23 JTF_VARCHAR2_TABLE_500
260: , p5_a24 JTF_NUMBER_TABLE
261: , p5_a25 JTF_NUMBER_TABLE
262: , p5_a26 JTF_NUMBER_TABLE
263: , p5_a27 JTF_DATE_TABLE
264: , p5_a28 JTF_DATE_TABLE
257: , p5_a21 JTF_VARCHAR2_TABLE_500
258: , p5_a22 JTF_VARCHAR2_TABLE_500
259: , p5_a23 JTF_VARCHAR2_TABLE_500
260: , p5_a24 JTF_NUMBER_TABLE
261: , p5_a25 JTF_NUMBER_TABLE
262: , p5_a26 JTF_NUMBER_TABLE
263: , p5_a27 JTF_DATE_TABLE
264: , p5_a28 JTF_DATE_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
258: , p5_a22 JTF_VARCHAR2_TABLE_500
259: , p5_a23 JTF_VARCHAR2_TABLE_500
260: , p5_a24 JTF_NUMBER_TABLE
261: , p5_a25 JTF_NUMBER_TABLE
262: , p5_a26 JTF_NUMBER_TABLE
263: , p5_a27 JTF_DATE_TABLE
264: , p5_a28 JTF_DATE_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a25 JTF_NUMBER_TABLE
262: , p5_a26 JTF_NUMBER_TABLE
263: , p5_a27 JTF_DATE_TABLE
264: , p5_a28 JTF_DATE_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_NUMBER_TABLE
267: , p5_a31 JTF_DATE_TABLE
268: , p5_a32 JTF_NUMBER_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
262: , p5_a26 JTF_NUMBER_TABLE
263: , p5_a27 JTF_DATE_TABLE
264: , p5_a28 JTF_DATE_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_NUMBER_TABLE
267: , p5_a31 JTF_DATE_TABLE
268: , p5_a32 JTF_NUMBER_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p5_a34 JTF_NUMBER_TABLE
264: , p5_a28 JTF_DATE_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_NUMBER_TABLE
267: , p5_a31 JTF_DATE_TABLE
268: , p5_a32 JTF_NUMBER_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p5_a34 JTF_NUMBER_TABLE
271: , p5_a35 JTF_DATE_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_NUMBER_TABLE
267: , p5_a31 JTF_DATE_TABLE
268: , p5_a32 JTF_NUMBER_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p5_a34 JTF_NUMBER_TABLE
271: , p5_a35 JTF_DATE_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
266: , p5_a30 JTF_NUMBER_TABLE
267: , p5_a31 JTF_DATE_TABLE
268: , p5_a32 JTF_NUMBER_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p5_a34 JTF_NUMBER_TABLE
271: , p5_a35 JTF_DATE_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
268: , p5_a32 JTF_NUMBER_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p5_a34 JTF_NUMBER_TABLE
271: , p5_a35 JTF_DATE_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
269: , p5_a33 JTF_NUMBER_TABLE
270: , p5_a34 JTF_NUMBER_TABLE
271: , p5_a35 JTF_DATE_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , p6_a5 out nocopy JTF_NUMBER_TABLE
271: , p5_a35 JTF_DATE_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , p6_a5 out nocopy JTF_NUMBER_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , p6_a5 out nocopy JTF_NUMBER_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_NUMBER_TABLE
280: , p6_a8 out nocopy JTF_NUMBER_TABLE
281: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , p6_a5 out nocopy JTF_NUMBER_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_NUMBER_TABLE
280: , p6_a8 out nocopy JTF_NUMBER_TABLE
281: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , p6_a5 out nocopy JTF_NUMBER_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_NUMBER_TABLE
280: , p6_a8 out nocopy JTF_NUMBER_TABLE
281: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , p6_a5 out nocopy JTF_NUMBER_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_NUMBER_TABLE
280: , p6_a8 out nocopy JTF_NUMBER_TABLE
281: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
292: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
293: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
294: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
295: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
296: , p6_a24 out nocopy JTF_NUMBER_TABLE
297: , p6_a25 out nocopy JTF_NUMBER_TABLE
298: , p6_a26 out nocopy JTF_NUMBER_TABLE
299: , p6_a27 out nocopy JTF_DATE_TABLE
300: , p6_a28 out nocopy JTF_DATE_TABLE
293: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
294: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
295: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
296: , p6_a24 out nocopy JTF_NUMBER_TABLE
297: , p6_a25 out nocopy JTF_NUMBER_TABLE
298: , p6_a26 out nocopy JTF_NUMBER_TABLE
299: , p6_a27 out nocopy JTF_DATE_TABLE
300: , p6_a28 out nocopy JTF_DATE_TABLE
301: , p6_a29 out nocopy JTF_NUMBER_TABLE
294: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
295: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
296: , p6_a24 out nocopy JTF_NUMBER_TABLE
297: , p6_a25 out nocopy JTF_NUMBER_TABLE
298: , p6_a26 out nocopy JTF_NUMBER_TABLE
299: , p6_a27 out nocopy JTF_DATE_TABLE
300: , p6_a28 out nocopy JTF_DATE_TABLE
301: , p6_a29 out nocopy JTF_NUMBER_TABLE
302: , p6_a30 out nocopy JTF_NUMBER_TABLE
297: , p6_a25 out nocopy JTF_NUMBER_TABLE
298: , p6_a26 out nocopy JTF_NUMBER_TABLE
299: , p6_a27 out nocopy JTF_DATE_TABLE
300: , p6_a28 out nocopy JTF_DATE_TABLE
301: , p6_a29 out nocopy JTF_NUMBER_TABLE
302: , p6_a30 out nocopy JTF_NUMBER_TABLE
303: , p6_a31 out nocopy JTF_DATE_TABLE
304: , p6_a32 out nocopy JTF_NUMBER_TABLE
305: , p6_a33 out nocopy JTF_NUMBER_TABLE
298: , p6_a26 out nocopy JTF_NUMBER_TABLE
299: , p6_a27 out nocopy JTF_DATE_TABLE
300: , p6_a28 out nocopy JTF_DATE_TABLE
301: , p6_a29 out nocopy JTF_NUMBER_TABLE
302: , p6_a30 out nocopy JTF_NUMBER_TABLE
303: , p6_a31 out nocopy JTF_DATE_TABLE
304: , p6_a32 out nocopy JTF_NUMBER_TABLE
305: , p6_a33 out nocopy JTF_NUMBER_TABLE
306: , p6_a34 out nocopy JTF_NUMBER_TABLE
300: , p6_a28 out nocopy JTF_DATE_TABLE
301: , p6_a29 out nocopy JTF_NUMBER_TABLE
302: , p6_a30 out nocopy JTF_NUMBER_TABLE
303: , p6_a31 out nocopy JTF_DATE_TABLE
304: , p6_a32 out nocopy JTF_NUMBER_TABLE
305: , p6_a33 out nocopy JTF_NUMBER_TABLE
306: , p6_a34 out nocopy JTF_NUMBER_TABLE
307: , p6_a35 out nocopy JTF_DATE_TABLE
308: );
301: , p6_a29 out nocopy JTF_NUMBER_TABLE
302: , p6_a30 out nocopy JTF_NUMBER_TABLE
303: , p6_a31 out nocopy JTF_DATE_TABLE
304: , p6_a32 out nocopy JTF_NUMBER_TABLE
305: , p6_a33 out nocopy JTF_NUMBER_TABLE
306: , p6_a34 out nocopy JTF_NUMBER_TABLE
307: , p6_a35 out nocopy JTF_DATE_TABLE
308: );
309: procedure lock_row(p_api_version NUMBER
302: , p6_a30 out nocopy JTF_NUMBER_TABLE
303: , p6_a31 out nocopy JTF_DATE_TABLE
304: , p6_a32 out nocopy JTF_NUMBER_TABLE
305: , p6_a33 out nocopy JTF_NUMBER_TABLE
306: , p6_a34 out nocopy JTF_NUMBER_TABLE
307: , p6_a35 out nocopy JTF_DATE_TABLE
308: );
309: procedure lock_row(p_api_version NUMBER
310: , p_init_msg_list VARCHAR2
352: , p_init_msg_list VARCHAR2
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_VARCHAR2_TABLE_100
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_200
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_VARCHAR2_TABLE_100
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_200
361: , p5_a5 JTF_NUMBER_TABLE
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_VARCHAR2_TABLE_100
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_200
361: , p5_a5 JTF_NUMBER_TABLE
362: , p5_a6 JTF_NUMBER_TABLE
363: , p5_a7 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_VARCHAR2_TABLE_100
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_200
361: , p5_a5 JTF_NUMBER_TABLE
362: , p5_a6 JTF_NUMBER_TABLE
363: , p5_a7 JTF_NUMBER_TABLE
364: , p5_a8 JTF_NUMBER_TABLE
365: , p5_a9 JTF_VARCHAR2_TABLE_500
358: , p5_a2 JTF_VARCHAR2_TABLE_100
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_200
361: , p5_a5 JTF_NUMBER_TABLE
362: , p5_a6 JTF_NUMBER_TABLE
363: , p5_a7 JTF_NUMBER_TABLE
364: , p5_a8 JTF_NUMBER_TABLE
365: , p5_a9 JTF_VARCHAR2_TABLE_500
366: , p5_a10 JTF_VARCHAR2_TABLE_500
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_200
361: , p5_a5 JTF_NUMBER_TABLE
362: , p5_a6 JTF_NUMBER_TABLE
363: , p5_a7 JTF_NUMBER_TABLE
364: , p5_a8 JTF_NUMBER_TABLE
365: , p5_a9 JTF_VARCHAR2_TABLE_500
366: , p5_a10 JTF_VARCHAR2_TABLE_500
367: , p5_a11 JTF_VARCHAR2_TABLE_500
360: , p5_a4 JTF_VARCHAR2_TABLE_200
361: , p5_a5 JTF_NUMBER_TABLE
362: , p5_a6 JTF_NUMBER_TABLE
363: , p5_a7 JTF_NUMBER_TABLE
364: , p5_a8 JTF_NUMBER_TABLE
365: , p5_a9 JTF_VARCHAR2_TABLE_500
366: , p5_a10 JTF_VARCHAR2_TABLE_500
367: , p5_a11 JTF_VARCHAR2_TABLE_500
368: , p5_a12 JTF_VARCHAR2_TABLE_500
376: , p5_a20 JTF_VARCHAR2_TABLE_500
377: , p5_a21 JTF_VARCHAR2_TABLE_500
378: , p5_a22 JTF_VARCHAR2_TABLE_500
379: , p5_a23 JTF_VARCHAR2_TABLE_500
380: , p5_a24 JTF_NUMBER_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p5_a26 JTF_NUMBER_TABLE
383: , p5_a27 JTF_DATE_TABLE
384: , p5_a28 JTF_DATE_TABLE
377: , p5_a21 JTF_VARCHAR2_TABLE_500
378: , p5_a22 JTF_VARCHAR2_TABLE_500
379: , p5_a23 JTF_VARCHAR2_TABLE_500
380: , p5_a24 JTF_NUMBER_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p5_a26 JTF_NUMBER_TABLE
383: , p5_a27 JTF_DATE_TABLE
384: , p5_a28 JTF_DATE_TABLE
385: , p5_a29 JTF_NUMBER_TABLE
378: , p5_a22 JTF_VARCHAR2_TABLE_500
379: , p5_a23 JTF_VARCHAR2_TABLE_500
380: , p5_a24 JTF_NUMBER_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p5_a26 JTF_NUMBER_TABLE
383: , p5_a27 JTF_DATE_TABLE
384: , p5_a28 JTF_DATE_TABLE
385: , p5_a29 JTF_NUMBER_TABLE
386: , p5_a30 JTF_NUMBER_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p5_a26 JTF_NUMBER_TABLE
383: , p5_a27 JTF_DATE_TABLE
384: , p5_a28 JTF_DATE_TABLE
385: , p5_a29 JTF_NUMBER_TABLE
386: , p5_a30 JTF_NUMBER_TABLE
387: , p5_a31 JTF_DATE_TABLE
388: , p5_a32 JTF_NUMBER_TABLE
389: , p5_a33 JTF_NUMBER_TABLE
382: , p5_a26 JTF_NUMBER_TABLE
383: , p5_a27 JTF_DATE_TABLE
384: , p5_a28 JTF_DATE_TABLE
385: , p5_a29 JTF_NUMBER_TABLE
386: , p5_a30 JTF_NUMBER_TABLE
387: , p5_a31 JTF_DATE_TABLE
388: , p5_a32 JTF_NUMBER_TABLE
389: , p5_a33 JTF_NUMBER_TABLE
390: , p5_a34 JTF_NUMBER_TABLE
384: , p5_a28 JTF_DATE_TABLE
385: , p5_a29 JTF_NUMBER_TABLE
386: , p5_a30 JTF_NUMBER_TABLE
387: , p5_a31 JTF_DATE_TABLE
388: , p5_a32 JTF_NUMBER_TABLE
389: , p5_a33 JTF_NUMBER_TABLE
390: , p5_a34 JTF_NUMBER_TABLE
391: , p5_a35 JTF_DATE_TABLE
392: );
385: , p5_a29 JTF_NUMBER_TABLE
386: , p5_a30 JTF_NUMBER_TABLE
387: , p5_a31 JTF_DATE_TABLE
388: , p5_a32 JTF_NUMBER_TABLE
389: , p5_a33 JTF_NUMBER_TABLE
390: , p5_a34 JTF_NUMBER_TABLE
391: , p5_a35 JTF_DATE_TABLE
392: );
393: procedure update_row(p_api_version NUMBER
386: , p5_a30 JTF_NUMBER_TABLE
387: , p5_a31 JTF_DATE_TABLE
388: , p5_a32 JTF_NUMBER_TABLE
389: , p5_a33 JTF_NUMBER_TABLE
390: , p5_a34 JTF_NUMBER_TABLE
391: , p5_a35 JTF_DATE_TABLE
392: );
393: procedure update_row(p_api_version NUMBER
394: , p_init_msg_list VARCHAR2
472: , p_init_msg_list VARCHAR2
473: , x_return_status out nocopy VARCHAR2
474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_100
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_200
473: , x_return_status out nocopy VARCHAR2
474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_100
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_200
481: , p5_a5 JTF_NUMBER_TABLE
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_100
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_200
481: , p5_a5 JTF_NUMBER_TABLE
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_100
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_200
481: , p5_a5 JTF_NUMBER_TABLE
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_NUMBER_TABLE
484: , p5_a8 JTF_NUMBER_TABLE
485: , p5_a9 JTF_VARCHAR2_TABLE_500
478: , p5_a2 JTF_VARCHAR2_TABLE_100
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_200
481: , p5_a5 JTF_NUMBER_TABLE
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_NUMBER_TABLE
484: , p5_a8 JTF_NUMBER_TABLE
485: , p5_a9 JTF_VARCHAR2_TABLE_500
486: , p5_a10 JTF_VARCHAR2_TABLE_500
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_200
481: , p5_a5 JTF_NUMBER_TABLE
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_NUMBER_TABLE
484: , p5_a8 JTF_NUMBER_TABLE
485: , p5_a9 JTF_VARCHAR2_TABLE_500
486: , p5_a10 JTF_VARCHAR2_TABLE_500
487: , p5_a11 JTF_VARCHAR2_TABLE_500
480: , p5_a4 JTF_VARCHAR2_TABLE_200
481: , p5_a5 JTF_NUMBER_TABLE
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_NUMBER_TABLE
484: , p5_a8 JTF_NUMBER_TABLE
485: , p5_a9 JTF_VARCHAR2_TABLE_500
486: , p5_a10 JTF_VARCHAR2_TABLE_500
487: , p5_a11 JTF_VARCHAR2_TABLE_500
488: , p5_a12 JTF_VARCHAR2_TABLE_500
496: , p5_a20 JTF_VARCHAR2_TABLE_500
497: , p5_a21 JTF_VARCHAR2_TABLE_500
498: , p5_a22 JTF_VARCHAR2_TABLE_500
499: , p5_a23 JTF_VARCHAR2_TABLE_500
500: , p5_a24 JTF_NUMBER_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_DATE_TABLE
504: , p5_a28 JTF_DATE_TABLE
497: , p5_a21 JTF_VARCHAR2_TABLE_500
498: , p5_a22 JTF_VARCHAR2_TABLE_500
499: , p5_a23 JTF_VARCHAR2_TABLE_500
500: , p5_a24 JTF_NUMBER_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_DATE_TABLE
504: , p5_a28 JTF_DATE_TABLE
505: , p5_a29 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_500
499: , p5_a23 JTF_VARCHAR2_TABLE_500
500: , p5_a24 JTF_NUMBER_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_DATE_TABLE
504: , p5_a28 JTF_DATE_TABLE
505: , p5_a29 JTF_NUMBER_TABLE
506: , p5_a30 JTF_NUMBER_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_DATE_TABLE
504: , p5_a28 JTF_DATE_TABLE
505: , p5_a29 JTF_NUMBER_TABLE
506: , p5_a30 JTF_NUMBER_TABLE
507: , p5_a31 JTF_DATE_TABLE
508: , p5_a32 JTF_NUMBER_TABLE
509: , p5_a33 JTF_NUMBER_TABLE
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_DATE_TABLE
504: , p5_a28 JTF_DATE_TABLE
505: , p5_a29 JTF_NUMBER_TABLE
506: , p5_a30 JTF_NUMBER_TABLE
507: , p5_a31 JTF_DATE_TABLE
508: , p5_a32 JTF_NUMBER_TABLE
509: , p5_a33 JTF_NUMBER_TABLE
510: , p5_a34 JTF_NUMBER_TABLE
504: , p5_a28 JTF_DATE_TABLE
505: , p5_a29 JTF_NUMBER_TABLE
506: , p5_a30 JTF_NUMBER_TABLE
507: , p5_a31 JTF_DATE_TABLE
508: , p5_a32 JTF_NUMBER_TABLE
509: , p5_a33 JTF_NUMBER_TABLE
510: , p5_a34 JTF_NUMBER_TABLE
511: , p5_a35 JTF_DATE_TABLE
512: , p6_a0 out nocopy JTF_NUMBER_TABLE
505: , p5_a29 JTF_NUMBER_TABLE
506: , p5_a30 JTF_NUMBER_TABLE
507: , p5_a31 JTF_DATE_TABLE
508: , p5_a32 JTF_NUMBER_TABLE
509: , p5_a33 JTF_NUMBER_TABLE
510: , p5_a34 JTF_NUMBER_TABLE
511: , p5_a35 JTF_DATE_TABLE
512: , p6_a0 out nocopy JTF_NUMBER_TABLE
513: , p6_a1 out nocopy JTF_NUMBER_TABLE
506: , p5_a30 JTF_NUMBER_TABLE
507: , p5_a31 JTF_DATE_TABLE
508: , p5_a32 JTF_NUMBER_TABLE
509: , p5_a33 JTF_NUMBER_TABLE
510: , p5_a34 JTF_NUMBER_TABLE
511: , p5_a35 JTF_DATE_TABLE
512: , p6_a0 out nocopy JTF_NUMBER_TABLE
513: , p6_a1 out nocopy JTF_NUMBER_TABLE
514: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
508: , p5_a32 JTF_NUMBER_TABLE
509: , p5_a33 JTF_NUMBER_TABLE
510: , p5_a34 JTF_NUMBER_TABLE
511: , p5_a35 JTF_DATE_TABLE
512: , p6_a0 out nocopy JTF_NUMBER_TABLE
513: , p6_a1 out nocopy JTF_NUMBER_TABLE
514: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
515: , p6_a3 out nocopy JTF_NUMBER_TABLE
516: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
509: , p5_a33 JTF_NUMBER_TABLE
510: , p5_a34 JTF_NUMBER_TABLE
511: , p5_a35 JTF_DATE_TABLE
512: , p6_a0 out nocopy JTF_NUMBER_TABLE
513: , p6_a1 out nocopy JTF_NUMBER_TABLE
514: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
515: , p6_a3 out nocopy JTF_NUMBER_TABLE
516: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
517: , p6_a5 out nocopy JTF_NUMBER_TABLE
511: , p5_a35 JTF_DATE_TABLE
512: , p6_a0 out nocopy JTF_NUMBER_TABLE
513: , p6_a1 out nocopy JTF_NUMBER_TABLE
514: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
515: , p6_a3 out nocopy JTF_NUMBER_TABLE
516: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
517: , p6_a5 out nocopy JTF_NUMBER_TABLE
518: , p6_a6 out nocopy JTF_NUMBER_TABLE
519: , p6_a7 out nocopy JTF_NUMBER_TABLE
513: , p6_a1 out nocopy JTF_NUMBER_TABLE
514: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
515: , p6_a3 out nocopy JTF_NUMBER_TABLE
516: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
517: , p6_a5 out nocopy JTF_NUMBER_TABLE
518: , p6_a6 out nocopy JTF_NUMBER_TABLE
519: , p6_a7 out nocopy JTF_NUMBER_TABLE
520: , p6_a8 out nocopy JTF_NUMBER_TABLE
521: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
514: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
515: , p6_a3 out nocopy JTF_NUMBER_TABLE
516: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
517: , p6_a5 out nocopy JTF_NUMBER_TABLE
518: , p6_a6 out nocopy JTF_NUMBER_TABLE
519: , p6_a7 out nocopy JTF_NUMBER_TABLE
520: , p6_a8 out nocopy JTF_NUMBER_TABLE
521: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
522: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a3 out nocopy JTF_NUMBER_TABLE
516: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
517: , p6_a5 out nocopy JTF_NUMBER_TABLE
518: , p6_a6 out nocopy JTF_NUMBER_TABLE
519: , p6_a7 out nocopy JTF_NUMBER_TABLE
520: , p6_a8 out nocopy JTF_NUMBER_TABLE
521: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
522: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
523: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
516: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
517: , p6_a5 out nocopy JTF_NUMBER_TABLE
518: , p6_a6 out nocopy JTF_NUMBER_TABLE
519: , p6_a7 out nocopy JTF_NUMBER_TABLE
520: , p6_a8 out nocopy JTF_NUMBER_TABLE
521: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
522: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
523: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
524: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
532: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
533: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
534: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
535: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
536: , p6_a24 out nocopy JTF_NUMBER_TABLE
537: , p6_a25 out nocopy JTF_NUMBER_TABLE
538: , p6_a26 out nocopy JTF_NUMBER_TABLE
539: , p6_a27 out nocopy JTF_DATE_TABLE
540: , p6_a28 out nocopy JTF_DATE_TABLE
533: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
534: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
535: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
536: , p6_a24 out nocopy JTF_NUMBER_TABLE
537: , p6_a25 out nocopy JTF_NUMBER_TABLE
538: , p6_a26 out nocopy JTF_NUMBER_TABLE
539: , p6_a27 out nocopy JTF_DATE_TABLE
540: , p6_a28 out nocopy JTF_DATE_TABLE
541: , p6_a29 out nocopy JTF_NUMBER_TABLE
534: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
535: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
536: , p6_a24 out nocopy JTF_NUMBER_TABLE
537: , p6_a25 out nocopy JTF_NUMBER_TABLE
538: , p6_a26 out nocopy JTF_NUMBER_TABLE
539: , p6_a27 out nocopy JTF_DATE_TABLE
540: , p6_a28 out nocopy JTF_DATE_TABLE
541: , p6_a29 out nocopy JTF_NUMBER_TABLE
542: , p6_a30 out nocopy JTF_NUMBER_TABLE
537: , p6_a25 out nocopy JTF_NUMBER_TABLE
538: , p6_a26 out nocopy JTF_NUMBER_TABLE
539: , p6_a27 out nocopy JTF_DATE_TABLE
540: , p6_a28 out nocopy JTF_DATE_TABLE
541: , p6_a29 out nocopy JTF_NUMBER_TABLE
542: , p6_a30 out nocopy JTF_NUMBER_TABLE
543: , p6_a31 out nocopy JTF_DATE_TABLE
544: , p6_a32 out nocopy JTF_NUMBER_TABLE
545: , p6_a33 out nocopy JTF_NUMBER_TABLE
538: , p6_a26 out nocopy JTF_NUMBER_TABLE
539: , p6_a27 out nocopy JTF_DATE_TABLE
540: , p6_a28 out nocopy JTF_DATE_TABLE
541: , p6_a29 out nocopy JTF_NUMBER_TABLE
542: , p6_a30 out nocopy JTF_NUMBER_TABLE
543: , p6_a31 out nocopy JTF_DATE_TABLE
544: , p6_a32 out nocopy JTF_NUMBER_TABLE
545: , p6_a33 out nocopy JTF_NUMBER_TABLE
546: , p6_a34 out nocopy JTF_NUMBER_TABLE
540: , p6_a28 out nocopy JTF_DATE_TABLE
541: , p6_a29 out nocopy JTF_NUMBER_TABLE
542: , p6_a30 out nocopy JTF_NUMBER_TABLE
543: , p6_a31 out nocopy JTF_DATE_TABLE
544: , p6_a32 out nocopy JTF_NUMBER_TABLE
545: , p6_a33 out nocopy JTF_NUMBER_TABLE
546: , p6_a34 out nocopy JTF_NUMBER_TABLE
547: , p6_a35 out nocopy JTF_DATE_TABLE
548: );
541: , p6_a29 out nocopy JTF_NUMBER_TABLE
542: , p6_a30 out nocopy JTF_NUMBER_TABLE
543: , p6_a31 out nocopy JTF_DATE_TABLE
544: , p6_a32 out nocopy JTF_NUMBER_TABLE
545: , p6_a33 out nocopy JTF_NUMBER_TABLE
546: , p6_a34 out nocopy JTF_NUMBER_TABLE
547: , p6_a35 out nocopy JTF_DATE_TABLE
548: );
549: procedure delete_row(p_api_version NUMBER
542: , p6_a30 out nocopy JTF_NUMBER_TABLE
543: , p6_a31 out nocopy JTF_DATE_TABLE
544: , p6_a32 out nocopy JTF_NUMBER_TABLE
545: , p6_a33 out nocopy JTF_NUMBER_TABLE
546: , p6_a34 out nocopy JTF_NUMBER_TABLE
547: , p6_a35 out nocopy JTF_DATE_TABLE
548: );
549: procedure delete_row(p_api_version NUMBER
550: , p_init_msg_list VARCHAR2
592: , p_init_msg_list VARCHAR2
593: , x_return_status out nocopy VARCHAR2
594: , x_msg_count out nocopy NUMBER
595: , x_msg_data out nocopy VARCHAR2
596: , p5_a0 JTF_NUMBER_TABLE
597: , p5_a1 JTF_NUMBER_TABLE
598: , p5_a2 JTF_VARCHAR2_TABLE_100
599: , p5_a3 JTF_NUMBER_TABLE
600: , p5_a4 JTF_VARCHAR2_TABLE_200
593: , x_return_status out nocopy VARCHAR2
594: , x_msg_count out nocopy NUMBER
595: , x_msg_data out nocopy VARCHAR2
596: , p5_a0 JTF_NUMBER_TABLE
597: , p5_a1 JTF_NUMBER_TABLE
598: , p5_a2 JTF_VARCHAR2_TABLE_100
599: , p5_a3 JTF_NUMBER_TABLE
600: , p5_a4 JTF_VARCHAR2_TABLE_200
601: , p5_a5 JTF_NUMBER_TABLE
595: , x_msg_data out nocopy VARCHAR2
596: , p5_a0 JTF_NUMBER_TABLE
597: , p5_a1 JTF_NUMBER_TABLE
598: , p5_a2 JTF_VARCHAR2_TABLE_100
599: , p5_a3 JTF_NUMBER_TABLE
600: , p5_a4 JTF_VARCHAR2_TABLE_200
601: , p5_a5 JTF_NUMBER_TABLE
602: , p5_a6 JTF_NUMBER_TABLE
603: , p5_a7 JTF_NUMBER_TABLE
597: , p5_a1 JTF_NUMBER_TABLE
598: , p5_a2 JTF_VARCHAR2_TABLE_100
599: , p5_a3 JTF_NUMBER_TABLE
600: , p5_a4 JTF_VARCHAR2_TABLE_200
601: , p5_a5 JTF_NUMBER_TABLE
602: , p5_a6 JTF_NUMBER_TABLE
603: , p5_a7 JTF_NUMBER_TABLE
604: , p5_a8 JTF_NUMBER_TABLE
605: , p5_a9 JTF_VARCHAR2_TABLE_500
598: , p5_a2 JTF_VARCHAR2_TABLE_100
599: , p5_a3 JTF_NUMBER_TABLE
600: , p5_a4 JTF_VARCHAR2_TABLE_200
601: , p5_a5 JTF_NUMBER_TABLE
602: , p5_a6 JTF_NUMBER_TABLE
603: , p5_a7 JTF_NUMBER_TABLE
604: , p5_a8 JTF_NUMBER_TABLE
605: , p5_a9 JTF_VARCHAR2_TABLE_500
606: , p5_a10 JTF_VARCHAR2_TABLE_500
599: , p5_a3 JTF_NUMBER_TABLE
600: , p5_a4 JTF_VARCHAR2_TABLE_200
601: , p5_a5 JTF_NUMBER_TABLE
602: , p5_a6 JTF_NUMBER_TABLE
603: , p5_a7 JTF_NUMBER_TABLE
604: , p5_a8 JTF_NUMBER_TABLE
605: , p5_a9 JTF_VARCHAR2_TABLE_500
606: , p5_a10 JTF_VARCHAR2_TABLE_500
607: , p5_a11 JTF_VARCHAR2_TABLE_500
600: , p5_a4 JTF_VARCHAR2_TABLE_200
601: , p5_a5 JTF_NUMBER_TABLE
602: , p5_a6 JTF_NUMBER_TABLE
603: , p5_a7 JTF_NUMBER_TABLE
604: , p5_a8 JTF_NUMBER_TABLE
605: , p5_a9 JTF_VARCHAR2_TABLE_500
606: , p5_a10 JTF_VARCHAR2_TABLE_500
607: , p5_a11 JTF_VARCHAR2_TABLE_500
608: , p5_a12 JTF_VARCHAR2_TABLE_500
616: , p5_a20 JTF_VARCHAR2_TABLE_500
617: , p5_a21 JTF_VARCHAR2_TABLE_500
618: , p5_a22 JTF_VARCHAR2_TABLE_500
619: , p5_a23 JTF_VARCHAR2_TABLE_500
620: , p5_a24 JTF_NUMBER_TABLE
621: , p5_a25 JTF_NUMBER_TABLE
622: , p5_a26 JTF_NUMBER_TABLE
623: , p5_a27 JTF_DATE_TABLE
624: , p5_a28 JTF_DATE_TABLE
617: , p5_a21 JTF_VARCHAR2_TABLE_500
618: , p5_a22 JTF_VARCHAR2_TABLE_500
619: , p5_a23 JTF_VARCHAR2_TABLE_500
620: , p5_a24 JTF_NUMBER_TABLE
621: , p5_a25 JTF_NUMBER_TABLE
622: , p5_a26 JTF_NUMBER_TABLE
623: , p5_a27 JTF_DATE_TABLE
624: , p5_a28 JTF_DATE_TABLE
625: , p5_a29 JTF_NUMBER_TABLE
618: , p5_a22 JTF_VARCHAR2_TABLE_500
619: , p5_a23 JTF_VARCHAR2_TABLE_500
620: , p5_a24 JTF_NUMBER_TABLE
621: , p5_a25 JTF_NUMBER_TABLE
622: , p5_a26 JTF_NUMBER_TABLE
623: , p5_a27 JTF_DATE_TABLE
624: , p5_a28 JTF_DATE_TABLE
625: , p5_a29 JTF_NUMBER_TABLE
626: , p5_a30 JTF_NUMBER_TABLE
621: , p5_a25 JTF_NUMBER_TABLE
622: , p5_a26 JTF_NUMBER_TABLE
623: , p5_a27 JTF_DATE_TABLE
624: , p5_a28 JTF_DATE_TABLE
625: , p5_a29 JTF_NUMBER_TABLE
626: , p5_a30 JTF_NUMBER_TABLE
627: , p5_a31 JTF_DATE_TABLE
628: , p5_a32 JTF_NUMBER_TABLE
629: , p5_a33 JTF_NUMBER_TABLE
622: , p5_a26 JTF_NUMBER_TABLE
623: , p5_a27 JTF_DATE_TABLE
624: , p5_a28 JTF_DATE_TABLE
625: , p5_a29 JTF_NUMBER_TABLE
626: , p5_a30 JTF_NUMBER_TABLE
627: , p5_a31 JTF_DATE_TABLE
628: , p5_a32 JTF_NUMBER_TABLE
629: , p5_a33 JTF_NUMBER_TABLE
630: , p5_a34 JTF_NUMBER_TABLE
624: , p5_a28 JTF_DATE_TABLE
625: , p5_a29 JTF_NUMBER_TABLE
626: , p5_a30 JTF_NUMBER_TABLE
627: , p5_a31 JTF_DATE_TABLE
628: , p5_a32 JTF_NUMBER_TABLE
629: , p5_a33 JTF_NUMBER_TABLE
630: , p5_a34 JTF_NUMBER_TABLE
631: , p5_a35 JTF_DATE_TABLE
632: );
625: , p5_a29 JTF_NUMBER_TABLE
626: , p5_a30 JTF_NUMBER_TABLE
627: , p5_a31 JTF_DATE_TABLE
628: , p5_a32 JTF_NUMBER_TABLE
629: , p5_a33 JTF_NUMBER_TABLE
630: , p5_a34 JTF_NUMBER_TABLE
631: , p5_a35 JTF_DATE_TABLE
632: );
633: procedure validate_row(p_api_version NUMBER
626: , p5_a30 JTF_NUMBER_TABLE
627: , p5_a31 JTF_DATE_TABLE
628: , p5_a32 JTF_NUMBER_TABLE
629: , p5_a33 JTF_NUMBER_TABLE
630: , p5_a34 JTF_NUMBER_TABLE
631: , p5_a35 JTF_DATE_TABLE
632: );
633: procedure validate_row(p_api_version NUMBER
634: , p_init_msg_list VARCHAR2
676: , p_init_msg_list VARCHAR2
677: , x_return_status out nocopy VARCHAR2
678: , x_msg_count out nocopy NUMBER
679: , x_msg_data out nocopy VARCHAR2
680: , p5_a0 JTF_NUMBER_TABLE
681: , p5_a1 JTF_NUMBER_TABLE
682: , p5_a2 JTF_VARCHAR2_TABLE_100
683: , p5_a3 JTF_NUMBER_TABLE
684: , p5_a4 JTF_VARCHAR2_TABLE_200
677: , x_return_status out nocopy VARCHAR2
678: , x_msg_count out nocopy NUMBER
679: , x_msg_data out nocopy VARCHAR2
680: , p5_a0 JTF_NUMBER_TABLE
681: , p5_a1 JTF_NUMBER_TABLE
682: , p5_a2 JTF_VARCHAR2_TABLE_100
683: , p5_a3 JTF_NUMBER_TABLE
684: , p5_a4 JTF_VARCHAR2_TABLE_200
685: , p5_a5 JTF_NUMBER_TABLE
679: , x_msg_data out nocopy VARCHAR2
680: , p5_a0 JTF_NUMBER_TABLE
681: , p5_a1 JTF_NUMBER_TABLE
682: , p5_a2 JTF_VARCHAR2_TABLE_100
683: , p5_a3 JTF_NUMBER_TABLE
684: , p5_a4 JTF_VARCHAR2_TABLE_200
685: , p5_a5 JTF_NUMBER_TABLE
686: , p5_a6 JTF_NUMBER_TABLE
687: , p5_a7 JTF_NUMBER_TABLE
681: , p5_a1 JTF_NUMBER_TABLE
682: , p5_a2 JTF_VARCHAR2_TABLE_100
683: , p5_a3 JTF_NUMBER_TABLE
684: , p5_a4 JTF_VARCHAR2_TABLE_200
685: , p5_a5 JTF_NUMBER_TABLE
686: , p5_a6 JTF_NUMBER_TABLE
687: , p5_a7 JTF_NUMBER_TABLE
688: , p5_a8 JTF_NUMBER_TABLE
689: , p5_a9 JTF_VARCHAR2_TABLE_500
682: , p5_a2 JTF_VARCHAR2_TABLE_100
683: , p5_a3 JTF_NUMBER_TABLE
684: , p5_a4 JTF_VARCHAR2_TABLE_200
685: , p5_a5 JTF_NUMBER_TABLE
686: , p5_a6 JTF_NUMBER_TABLE
687: , p5_a7 JTF_NUMBER_TABLE
688: , p5_a8 JTF_NUMBER_TABLE
689: , p5_a9 JTF_VARCHAR2_TABLE_500
690: , p5_a10 JTF_VARCHAR2_TABLE_500
683: , p5_a3 JTF_NUMBER_TABLE
684: , p5_a4 JTF_VARCHAR2_TABLE_200
685: , p5_a5 JTF_NUMBER_TABLE
686: , p5_a6 JTF_NUMBER_TABLE
687: , p5_a7 JTF_NUMBER_TABLE
688: , p5_a8 JTF_NUMBER_TABLE
689: , p5_a9 JTF_VARCHAR2_TABLE_500
690: , p5_a10 JTF_VARCHAR2_TABLE_500
691: , p5_a11 JTF_VARCHAR2_TABLE_500
684: , p5_a4 JTF_VARCHAR2_TABLE_200
685: , p5_a5 JTF_NUMBER_TABLE
686: , p5_a6 JTF_NUMBER_TABLE
687: , p5_a7 JTF_NUMBER_TABLE
688: , p5_a8 JTF_NUMBER_TABLE
689: , p5_a9 JTF_VARCHAR2_TABLE_500
690: , p5_a10 JTF_VARCHAR2_TABLE_500
691: , p5_a11 JTF_VARCHAR2_TABLE_500
692: , p5_a12 JTF_VARCHAR2_TABLE_500
700: , p5_a20 JTF_VARCHAR2_TABLE_500
701: , p5_a21 JTF_VARCHAR2_TABLE_500
702: , p5_a22 JTF_VARCHAR2_TABLE_500
703: , p5_a23 JTF_VARCHAR2_TABLE_500
704: , p5_a24 JTF_NUMBER_TABLE
705: , p5_a25 JTF_NUMBER_TABLE
706: , p5_a26 JTF_NUMBER_TABLE
707: , p5_a27 JTF_DATE_TABLE
708: , p5_a28 JTF_DATE_TABLE
701: , p5_a21 JTF_VARCHAR2_TABLE_500
702: , p5_a22 JTF_VARCHAR2_TABLE_500
703: , p5_a23 JTF_VARCHAR2_TABLE_500
704: , p5_a24 JTF_NUMBER_TABLE
705: , p5_a25 JTF_NUMBER_TABLE
706: , p5_a26 JTF_NUMBER_TABLE
707: , p5_a27 JTF_DATE_TABLE
708: , p5_a28 JTF_DATE_TABLE
709: , p5_a29 JTF_NUMBER_TABLE
702: , p5_a22 JTF_VARCHAR2_TABLE_500
703: , p5_a23 JTF_VARCHAR2_TABLE_500
704: , p5_a24 JTF_NUMBER_TABLE
705: , p5_a25 JTF_NUMBER_TABLE
706: , p5_a26 JTF_NUMBER_TABLE
707: , p5_a27 JTF_DATE_TABLE
708: , p5_a28 JTF_DATE_TABLE
709: , p5_a29 JTF_NUMBER_TABLE
710: , p5_a30 JTF_NUMBER_TABLE
705: , p5_a25 JTF_NUMBER_TABLE
706: , p5_a26 JTF_NUMBER_TABLE
707: , p5_a27 JTF_DATE_TABLE
708: , p5_a28 JTF_DATE_TABLE
709: , p5_a29 JTF_NUMBER_TABLE
710: , p5_a30 JTF_NUMBER_TABLE
711: , p5_a31 JTF_DATE_TABLE
712: , p5_a32 JTF_NUMBER_TABLE
713: , p5_a33 JTF_NUMBER_TABLE
706: , p5_a26 JTF_NUMBER_TABLE
707: , p5_a27 JTF_DATE_TABLE
708: , p5_a28 JTF_DATE_TABLE
709: , p5_a29 JTF_NUMBER_TABLE
710: , p5_a30 JTF_NUMBER_TABLE
711: , p5_a31 JTF_DATE_TABLE
712: , p5_a32 JTF_NUMBER_TABLE
713: , p5_a33 JTF_NUMBER_TABLE
714: , p5_a34 JTF_NUMBER_TABLE
708: , p5_a28 JTF_DATE_TABLE
709: , p5_a29 JTF_NUMBER_TABLE
710: , p5_a30 JTF_NUMBER_TABLE
711: , p5_a31 JTF_DATE_TABLE
712: , p5_a32 JTF_NUMBER_TABLE
713: , p5_a33 JTF_NUMBER_TABLE
714: , p5_a34 JTF_NUMBER_TABLE
715: , p5_a35 JTF_DATE_TABLE
716: );
709: , p5_a29 JTF_NUMBER_TABLE
710: , p5_a30 JTF_NUMBER_TABLE
711: , p5_a31 JTF_DATE_TABLE
712: , p5_a32 JTF_NUMBER_TABLE
713: , p5_a33 JTF_NUMBER_TABLE
714: , p5_a34 JTF_NUMBER_TABLE
715: , p5_a35 JTF_DATE_TABLE
716: );
717: end okl_sir_pvt_w;
710: , p5_a30 JTF_NUMBER_TABLE
711: , p5_a31 JTF_DATE_TABLE
712: , p5_a32 JTF_NUMBER_TABLE
713: , p5_a33 JTF_NUMBER_TABLE
714: , p5_a34 JTF_NUMBER_TABLE
715: , p5_a35 JTF_DATE_TABLE
716: );
717: end okl_sir_pvt_w;