1: package okl_inr_pvt_w as
2: /* $Header: OKLIINRS.pls 120.1 2005/07/13 09:28:18 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_inr_pvt.inr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package okl_inr_pvt_w as
2: /* $Header: OKLIINRS.pls 120.1 2005/07/13 09:28:18 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_inr_pvt.inr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_inr_pvt.inr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p2(t okl_inr_pvt.inr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p2(t okl_inr_pvt.inr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p2(t okl_inr_pvt.inr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p2(t okl_inr_pvt.inr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
38: procedure rosetta_table_copy_out_p2(t okl_inr_pvt.inr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_DATE_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_DATE_TABLE
49: , a11 out nocopy JTF_DATE_TABLE
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_DATE_TABLE
49: , a11 out nocopy JTF_DATE_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_DATE_TABLE
49: , a11 out nocopy JTF_DATE_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_DATE_TABLE
49: , a11 out nocopy JTF_DATE_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
53: , a15 out nocopy JTF_VARCHAR2_TABLE_500
54: , a16 out nocopy JTF_VARCHAR2_TABLE_500
63: , a25 out nocopy JTF_VARCHAR2_TABLE_500
64: , a26 out nocopy JTF_VARCHAR2_TABLE_500
65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_inr_pvt.inrv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_inr_pvt.inrv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_inr_pvt.inrv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_inr_pvt.inrv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_NUMBER_TABLE
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_NUMBER_TABLE
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_NUMBER_TABLE
84: , a10 JTF_DATE_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_NUMBER_TABLE
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_NUMBER_TABLE
84: , a10 JTF_DATE_TABLE
85: , a11 JTF_DATE_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_NUMBER_TABLE
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_NUMBER_TABLE
84: , a10 JTF_DATE_TABLE
85: , a11 JTF_DATE_TABLE
86: , a12 JTF_NUMBER_TABLE
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_NUMBER_TABLE
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_NUMBER_TABLE
84: , a10 JTF_DATE_TABLE
85: , a11 JTF_DATE_TABLE
86: , a12 JTF_NUMBER_TABLE
87: , a13 JTF_VARCHAR2_TABLE_100
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_NUMBER_TABLE
84: , a10 JTF_DATE_TABLE
85: , a11 JTF_DATE_TABLE
86: , a12 JTF_NUMBER_TABLE
87: , a13 JTF_VARCHAR2_TABLE_100
88: , a14 JTF_VARCHAR2_TABLE_500
89: , a15 JTF_VARCHAR2_TABLE_500
90: , a16 JTF_VARCHAR2_TABLE_500
99: , a25 JTF_VARCHAR2_TABLE_500
100: , a26 JTF_VARCHAR2_TABLE_500
101: , a27 JTF_VARCHAR2_TABLE_500
102: , a28 JTF_VARCHAR2_TABLE_500
103: , a29 JTF_NUMBER_TABLE
104: , a30 JTF_DATE_TABLE
105: , a31 JTF_NUMBER_TABLE
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
101: , a27 JTF_VARCHAR2_TABLE_500
102: , a28 JTF_VARCHAR2_TABLE_500
103: , a29 JTF_NUMBER_TABLE
104: , a30 JTF_DATE_TABLE
105: , a31 JTF_NUMBER_TABLE
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_inr_pvt.inrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a29 JTF_NUMBER_TABLE
104: , a30 JTF_DATE_TABLE
105: , a31 JTF_NUMBER_TABLE
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_inr_pvt.inrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a31 JTF_NUMBER_TABLE
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_inr_pvt.inrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a32 JTF_DATE_TABLE
107: , a33 JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_inr_pvt.inrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_inr_pvt.inrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_NUMBER_TABLE
117: , a8 out nocopy JTF_NUMBER_TABLE
118: , a9 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_NUMBER_TABLE
117: , a8 out nocopy JTF_NUMBER_TABLE
118: , a9 out nocopy JTF_NUMBER_TABLE
119: , a10 out nocopy JTF_DATE_TABLE
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_NUMBER_TABLE
117: , a8 out nocopy JTF_NUMBER_TABLE
118: , a9 out nocopy JTF_NUMBER_TABLE
119: , a10 out nocopy JTF_DATE_TABLE
120: , a11 out nocopy JTF_DATE_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_NUMBER_TABLE
117: , a8 out nocopy JTF_NUMBER_TABLE
118: , a9 out nocopy JTF_NUMBER_TABLE
119: , a10 out nocopy JTF_DATE_TABLE
120: , a11 out nocopy JTF_DATE_TABLE
121: , a12 out nocopy JTF_NUMBER_TABLE
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_NUMBER_TABLE
117: , a8 out nocopy JTF_NUMBER_TABLE
118: , a9 out nocopy JTF_NUMBER_TABLE
119: , a10 out nocopy JTF_DATE_TABLE
120: , a11 out nocopy JTF_DATE_TABLE
121: , a12 out nocopy JTF_NUMBER_TABLE
122: , a13 out nocopy JTF_VARCHAR2_TABLE_100
117: , a8 out nocopy JTF_NUMBER_TABLE
118: , a9 out nocopy JTF_NUMBER_TABLE
119: , a10 out nocopy JTF_DATE_TABLE
120: , a11 out nocopy JTF_DATE_TABLE
121: , a12 out nocopy JTF_NUMBER_TABLE
122: , a13 out nocopy JTF_VARCHAR2_TABLE_100
123: , a14 out nocopy JTF_VARCHAR2_TABLE_500
124: , a15 out nocopy JTF_VARCHAR2_TABLE_500
125: , a16 out nocopy JTF_VARCHAR2_TABLE_500
134: , a25 out nocopy JTF_VARCHAR2_TABLE_500
135: , a26 out nocopy JTF_VARCHAR2_TABLE_500
136: , a27 out nocopy JTF_VARCHAR2_TABLE_500
137: , a28 out nocopy JTF_VARCHAR2_TABLE_500
138: , a29 out nocopy JTF_NUMBER_TABLE
139: , a30 out nocopy JTF_DATE_TABLE
140: , a31 out nocopy JTF_NUMBER_TABLE
141: , a32 out nocopy JTF_DATE_TABLE
142: , a33 out nocopy JTF_NUMBER_TABLE
136: , a27 out nocopy JTF_VARCHAR2_TABLE_500
137: , a28 out nocopy JTF_VARCHAR2_TABLE_500
138: , a29 out nocopy JTF_NUMBER_TABLE
139: , a30 out nocopy JTF_DATE_TABLE
140: , a31 out nocopy JTF_NUMBER_TABLE
141: , a32 out nocopy JTF_DATE_TABLE
142: , a33 out nocopy JTF_NUMBER_TABLE
143: );
144:
138: , a29 out nocopy JTF_NUMBER_TABLE
139: , a30 out nocopy JTF_DATE_TABLE
140: , a31 out nocopy JTF_NUMBER_TABLE
141: , a32 out nocopy JTF_DATE_TABLE
142: , a33 out nocopy JTF_NUMBER_TABLE
143: );
144:
145: procedure insert_row(p_api_version NUMBER
146: , p_init_msg_list VARCHAR2
220: , p_init_msg_list VARCHAR2
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_NUMBER_TABLE
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_NUMBER_TABLE
230: , p5_a6 JTF_NUMBER_TABLE
231: , p5_a7 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_NUMBER_TABLE
230: , p5_a6 JTF_NUMBER_TABLE
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_NUMBER_TABLE
230: , p5_a6 JTF_NUMBER_TABLE
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_NUMBER_TABLE
230: , p5_a6 JTF_NUMBER_TABLE
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_DATE_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_NUMBER_TABLE
230: , p5_a6 JTF_NUMBER_TABLE
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
229: , p5_a5 JTF_NUMBER_TABLE
230: , p5_a6 JTF_NUMBER_TABLE
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_VARCHAR2_TABLE_100
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_VARCHAR2_TABLE_100
238: , p5_a14 JTF_VARCHAR2_TABLE_500
239: , p5_a15 JTF_VARCHAR2_TABLE_500
240: , p5_a16 JTF_VARCHAR2_TABLE_500
249: , p5_a25 JTF_VARCHAR2_TABLE_500
250: , p5_a26 JTF_VARCHAR2_TABLE_500
251: , p5_a27 JTF_VARCHAR2_TABLE_500
252: , p5_a28 JTF_VARCHAR2_TABLE_500
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
251: , p5_a27 JTF_VARCHAR2_TABLE_500
252: , p5_a28 JTF_VARCHAR2_TABLE_500
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
255: , p5_a31 JTF_NUMBER_TABLE
256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
264: , p6_a6 out nocopy JTF_NUMBER_TABLE
265: , p6_a7 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
264: , p6_a6 out nocopy JTF_NUMBER_TABLE
265: , p6_a7 out nocopy JTF_NUMBER_TABLE
266: , p6_a8 out nocopy JTF_NUMBER_TABLE
267: , p6_a9 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
264: , p6_a6 out nocopy JTF_NUMBER_TABLE
265: , p6_a7 out nocopy JTF_NUMBER_TABLE
266: , p6_a8 out nocopy JTF_NUMBER_TABLE
267: , p6_a9 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 out nocopy JTF_DATE_TABLE
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
264: , p6_a6 out nocopy JTF_NUMBER_TABLE
265: , p6_a7 out nocopy JTF_NUMBER_TABLE
266: , p6_a8 out nocopy JTF_NUMBER_TABLE
267: , p6_a9 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 out nocopy JTF_DATE_TABLE
269: , p6_a11 out nocopy JTF_DATE_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
264: , p6_a6 out nocopy JTF_NUMBER_TABLE
265: , p6_a7 out nocopy JTF_NUMBER_TABLE
266: , p6_a8 out nocopy JTF_NUMBER_TABLE
267: , p6_a9 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 out nocopy JTF_DATE_TABLE
269: , p6_a11 out nocopy JTF_DATE_TABLE
270: , p6_a12 out nocopy JTF_NUMBER_TABLE
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
264: , p6_a6 out nocopy JTF_NUMBER_TABLE
265: , p6_a7 out nocopy JTF_NUMBER_TABLE
266: , p6_a8 out nocopy JTF_NUMBER_TABLE
267: , p6_a9 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 out nocopy JTF_DATE_TABLE
269: , p6_a11 out nocopy JTF_DATE_TABLE
270: , p6_a12 out nocopy JTF_NUMBER_TABLE
271: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a8 out nocopy JTF_NUMBER_TABLE
267: , p6_a9 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 out nocopy JTF_DATE_TABLE
269: , p6_a11 out nocopy JTF_DATE_TABLE
270: , p6_a12 out nocopy JTF_NUMBER_TABLE
271: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
272: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
273: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
285: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
286: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
287: , p6_a29 out nocopy JTF_NUMBER_TABLE
288: , p6_a30 out nocopy JTF_DATE_TABLE
289: , p6_a31 out nocopy JTF_NUMBER_TABLE
290: , p6_a32 out nocopy JTF_DATE_TABLE
291: , p6_a33 out nocopy JTF_NUMBER_TABLE
285: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
286: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
287: , p6_a29 out nocopy JTF_NUMBER_TABLE
288: , p6_a30 out nocopy JTF_DATE_TABLE
289: , p6_a31 out nocopy JTF_NUMBER_TABLE
290: , p6_a32 out nocopy JTF_DATE_TABLE
291: , p6_a33 out nocopy JTF_NUMBER_TABLE
292: );
293: procedure lock_row(p_api_version NUMBER
287: , p6_a29 out nocopy JTF_NUMBER_TABLE
288: , p6_a30 out nocopy JTF_DATE_TABLE
289: , p6_a31 out nocopy JTF_NUMBER_TABLE
290: , p6_a32 out nocopy JTF_DATE_TABLE
291: , p6_a33 out nocopy JTF_NUMBER_TABLE
292: );
293: procedure lock_row(p_api_version NUMBER
294: , p_init_msg_list VARCHAR2
295: , x_return_status out nocopy VARCHAR2
334: , p_init_msg_list VARCHAR2
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_NUMBER_TABLE
337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_NUMBER_TABLE
344: , p5_a6 JTF_NUMBER_TABLE
345: , p5_a7 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_NUMBER_TABLE
344: , p5_a6 JTF_NUMBER_TABLE
345: , p5_a7 JTF_NUMBER_TABLE
346: , p5_a8 JTF_NUMBER_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_NUMBER_TABLE
344: , p5_a6 JTF_NUMBER_TABLE
345: , p5_a7 JTF_NUMBER_TABLE
346: , p5_a8 JTF_NUMBER_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_DATE_TABLE
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_NUMBER_TABLE
344: , p5_a6 JTF_NUMBER_TABLE
345: , p5_a7 JTF_NUMBER_TABLE
346: , p5_a8 JTF_NUMBER_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_DATE_TABLE
349: , p5_a11 JTF_DATE_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_NUMBER_TABLE
344: , p5_a6 JTF_NUMBER_TABLE
345: , p5_a7 JTF_NUMBER_TABLE
346: , p5_a8 JTF_NUMBER_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_DATE_TABLE
349: , p5_a11 JTF_DATE_TABLE
350: , p5_a12 JTF_NUMBER_TABLE
343: , p5_a5 JTF_NUMBER_TABLE
344: , p5_a6 JTF_NUMBER_TABLE
345: , p5_a7 JTF_NUMBER_TABLE
346: , p5_a8 JTF_NUMBER_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_DATE_TABLE
349: , p5_a11 JTF_DATE_TABLE
350: , p5_a12 JTF_NUMBER_TABLE
351: , p5_a13 JTF_VARCHAR2_TABLE_100
346: , p5_a8 JTF_NUMBER_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_DATE_TABLE
349: , p5_a11 JTF_DATE_TABLE
350: , p5_a12 JTF_NUMBER_TABLE
351: , p5_a13 JTF_VARCHAR2_TABLE_100
352: , p5_a14 JTF_VARCHAR2_TABLE_500
353: , p5_a15 JTF_VARCHAR2_TABLE_500
354: , p5_a16 JTF_VARCHAR2_TABLE_500
363: , p5_a25 JTF_VARCHAR2_TABLE_500
364: , p5_a26 JTF_VARCHAR2_TABLE_500
365: , p5_a27 JTF_VARCHAR2_TABLE_500
366: , p5_a28 JTF_VARCHAR2_TABLE_500
367: , p5_a29 JTF_NUMBER_TABLE
368: , p5_a30 JTF_DATE_TABLE
369: , p5_a31 JTF_NUMBER_TABLE
370: , p5_a32 JTF_DATE_TABLE
371: , p5_a33 JTF_NUMBER_TABLE
365: , p5_a27 JTF_VARCHAR2_TABLE_500
366: , p5_a28 JTF_VARCHAR2_TABLE_500
367: , p5_a29 JTF_NUMBER_TABLE
368: , p5_a30 JTF_DATE_TABLE
369: , p5_a31 JTF_NUMBER_TABLE
370: , p5_a32 JTF_DATE_TABLE
371: , p5_a33 JTF_NUMBER_TABLE
372: );
373: procedure update_row(p_api_version NUMBER
367: , p5_a29 JTF_NUMBER_TABLE
368: , p5_a30 JTF_DATE_TABLE
369: , p5_a31 JTF_NUMBER_TABLE
370: , p5_a32 JTF_DATE_TABLE
371: , p5_a33 JTF_NUMBER_TABLE
372: );
373: procedure update_row(p_api_version NUMBER
374: , p_init_msg_list VARCHAR2
375: , x_return_status out nocopy VARCHAR2
448: , p_init_msg_list VARCHAR2
449: , x_return_status out nocopy VARCHAR2
450: , x_msg_count out nocopy NUMBER
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
449: , x_return_status out nocopy VARCHAR2
450: , x_msg_count out nocopy NUMBER
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_NUMBER_TABLE
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_NUMBER_TABLE
458: , p5_a6 JTF_NUMBER_TABLE
459: , p5_a7 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_NUMBER_TABLE
458: , p5_a6 JTF_NUMBER_TABLE
459: , p5_a7 JTF_NUMBER_TABLE
460: , p5_a8 JTF_NUMBER_TABLE
461: , p5_a9 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_NUMBER_TABLE
458: , p5_a6 JTF_NUMBER_TABLE
459: , p5_a7 JTF_NUMBER_TABLE
460: , p5_a8 JTF_NUMBER_TABLE
461: , p5_a9 JTF_NUMBER_TABLE
462: , p5_a10 JTF_DATE_TABLE
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_NUMBER_TABLE
458: , p5_a6 JTF_NUMBER_TABLE
459: , p5_a7 JTF_NUMBER_TABLE
460: , p5_a8 JTF_NUMBER_TABLE
461: , p5_a9 JTF_NUMBER_TABLE
462: , p5_a10 JTF_DATE_TABLE
463: , p5_a11 JTF_DATE_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_NUMBER_TABLE
458: , p5_a6 JTF_NUMBER_TABLE
459: , p5_a7 JTF_NUMBER_TABLE
460: , p5_a8 JTF_NUMBER_TABLE
461: , p5_a9 JTF_NUMBER_TABLE
462: , p5_a10 JTF_DATE_TABLE
463: , p5_a11 JTF_DATE_TABLE
464: , p5_a12 JTF_NUMBER_TABLE
457: , p5_a5 JTF_NUMBER_TABLE
458: , p5_a6 JTF_NUMBER_TABLE
459: , p5_a7 JTF_NUMBER_TABLE
460: , p5_a8 JTF_NUMBER_TABLE
461: , p5_a9 JTF_NUMBER_TABLE
462: , p5_a10 JTF_DATE_TABLE
463: , p5_a11 JTF_DATE_TABLE
464: , p5_a12 JTF_NUMBER_TABLE
465: , p5_a13 JTF_VARCHAR2_TABLE_100
460: , p5_a8 JTF_NUMBER_TABLE
461: , p5_a9 JTF_NUMBER_TABLE
462: , p5_a10 JTF_DATE_TABLE
463: , p5_a11 JTF_DATE_TABLE
464: , p5_a12 JTF_NUMBER_TABLE
465: , p5_a13 JTF_VARCHAR2_TABLE_100
466: , p5_a14 JTF_VARCHAR2_TABLE_500
467: , p5_a15 JTF_VARCHAR2_TABLE_500
468: , p5_a16 JTF_VARCHAR2_TABLE_500
477: , p5_a25 JTF_VARCHAR2_TABLE_500
478: , p5_a26 JTF_VARCHAR2_TABLE_500
479: , p5_a27 JTF_VARCHAR2_TABLE_500
480: , p5_a28 JTF_VARCHAR2_TABLE_500
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_DATE_TABLE
483: , p5_a31 JTF_NUMBER_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
479: , p5_a27 JTF_VARCHAR2_TABLE_500
480: , p5_a28 JTF_VARCHAR2_TABLE_500
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_DATE_TABLE
483: , p5_a31 JTF_NUMBER_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_DATE_TABLE
483: , p5_a31 JTF_NUMBER_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
482: , p5_a30 JTF_DATE_TABLE
483: , p5_a31 JTF_NUMBER_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
483: , p5_a31 JTF_NUMBER_TABLE
484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
492: , p6_a6 out nocopy JTF_NUMBER_TABLE
493: , p6_a7 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
492: , p6_a6 out nocopy JTF_NUMBER_TABLE
493: , p6_a7 out nocopy JTF_NUMBER_TABLE
494: , p6_a8 out nocopy JTF_NUMBER_TABLE
495: , p6_a9 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
492: , p6_a6 out nocopy JTF_NUMBER_TABLE
493: , p6_a7 out nocopy JTF_NUMBER_TABLE
494: , p6_a8 out nocopy JTF_NUMBER_TABLE
495: , p6_a9 out nocopy JTF_NUMBER_TABLE
496: , p6_a10 out nocopy JTF_DATE_TABLE
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
492: , p6_a6 out nocopy JTF_NUMBER_TABLE
493: , p6_a7 out nocopy JTF_NUMBER_TABLE
494: , p6_a8 out nocopy JTF_NUMBER_TABLE
495: , p6_a9 out nocopy JTF_NUMBER_TABLE
496: , p6_a10 out nocopy JTF_DATE_TABLE
497: , p6_a11 out nocopy JTF_DATE_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
492: , p6_a6 out nocopy JTF_NUMBER_TABLE
493: , p6_a7 out nocopy JTF_NUMBER_TABLE
494: , p6_a8 out nocopy JTF_NUMBER_TABLE
495: , p6_a9 out nocopy JTF_NUMBER_TABLE
496: , p6_a10 out nocopy JTF_DATE_TABLE
497: , p6_a11 out nocopy JTF_DATE_TABLE
498: , p6_a12 out nocopy JTF_NUMBER_TABLE
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
492: , p6_a6 out nocopy JTF_NUMBER_TABLE
493: , p6_a7 out nocopy JTF_NUMBER_TABLE
494: , p6_a8 out nocopy JTF_NUMBER_TABLE
495: , p6_a9 out nocopy JTF_NUMBER_TABLE
496: , p6_a10 out nocopy JTF_DATE_TABLE
497: , p6_a11 out nocopy JTF_DATE_TABLE
498: , p6_a12 out nocopy JTF_NUMBER_TABLE
499: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a8 out nocopy JTF_NUMBER_TABLE
495: , p6_a9 out nocopy JTF_NUMBER_TABLE
496: , p6_a10 out nocopy JTF_DATE_TABLE
497: , p6_a11 out nocopy JTF_DATE_TABLE
498: , p6_a12 out nocopy JTF_NUMBER_TABLE
499: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
500: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
501: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
502: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
511: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
512: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
513: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
514: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a29 out nocopy JTF_NUMBER_TABLE
516: , p6_a30 out nocopy JTF_DATE_TABLE
517: , p6_a31 out nocopy JTF_NUMBER_TABLE
518: , p6_a32 out nocopy JTF_DATE_TABLE
519: , p6_a33 out nocopy JTF_NUMBER_TABLE
513: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
514: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a29 out nocopy JTF_NUMBER_TABLE
516: , p6_a30 out nocopy JTF_DATE_TABLE
517: , p6_a31 out nocopy JTF_NUMBER_TABLE
518: , p6_a32 out nocopy JTF_DATE_TABLE
519: , p6_a33 out nocopy JTF_NUMBER_TABLE
520: );
521: procedure delete_row(p_api_version NUMBER
515: , p6_a29 out nocopy JTF_NUMBER_TABLE
516: , p6_a30 out nocopy JTF_DATE_TABLE
517: , p6_a31 out nocopy JTF_NUMBER_TABLE
518: , p6_a32 out nocopy JTF_DATE_TABLE
519: , p6_a33 out nocopy JTF_NUMBER_TABLE
520: );
521: procedure delete_row(p_api_version NUMBER
522: , p_init_msg_list VARCHAR2
523: , x_return_status out nocopy VARCHAR2
562: , p_init_msg_list VARCHAR2
563: , x_return_status out nocopy VARCHAR2
564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
563: , x_return_status out nocopy VARCHAR2
564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_NUMBER_TABLE
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_NUMBER_TABLE
572: , p5_a6 JTF_NUMBER_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_NUMBER_TABLE
572: , p5_a6 JTF_NUMBER_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_NUMBER_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_NUMBER_TABLE
572: , p5_a6 JTF_NUMBER_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_NUMBER_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_NUMBER_TABLE
572: , p5_a6 JTF_NUMBER_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_NUMBER_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_DATE_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_NUMBER_TABLE
572: , p5_a6 JTF_NUMBER_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_NUMBER_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_DATE_TABLE
578: , p5_a12 JTF_NUMBER_TABLE
571: , p5_a5 JTF_NUMBER_TABLE
572: , p5_a6 JTF_NUMBER_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_NUMBER_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_DATE_TABLE
578: , p5_a12 JTF_NUMBER_TABLE
579: , p5_a13 JTF_VARCHAR2_TABLE_100
574: , p5_a8 JTF_NUMBER_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_DATE_TABLE
578: , p5_a12 JTF_NUMBER_TABLE
579: , p5_a13 JTF_VARCHAR2_TABLE_100
580: , p5_a14 JTF_VARCHAR2_TABLE_500
581: , p5_a15 JTF_VARCHAR2_TABLE_500
582: , p5_a16 JTF_VARCHAR2_TABLE_500
591: , p5_a25 JTF_VARCHAR2_TABLE_500
592: , p5_a26 JTF_VARCHAR2_TABLE_500
593: , p5_a27 JTF_VARCHAR2_TABLE_500
594: , p5_a28 JTF_VARCHAR2_TABLE_500
595: , p5_a29 JTF_NUMBER_TABLE
596: , p5_a30 JTF_DATE_TABLE
597: , p5_a31 JTF_NUMBER_TABLE
598: , p5_a32 JTF_DATE_TABLE
599: , p5_a33 JTF_NUMBER_TABLE
593: , p5_a27 JTF_VARCHAR2_TABLE_500
594: , p5_a28 JTF_VARCHAR2_TABLE_500
595: , p5_a29 JTF_NUMBER_TABLE
596: , p5_a30 JTF_DATE_TABLE
597: , p5_a31 JTF_NUMBER_TABLE
598: , p5_a32 JTF_DATE_TABLE
599: , p5_a33 JTF_NUMBER_TABLE
600: );
601: procedure validate_row(p_api_version NUMBER
595: , p5_a29 JTF_NUMBER_TABLE
596: , p5_a30 JTF_DATE_TABLE
597: , p5_a31 JTF_NUMBER_TABLE
598: , p5_a32 JTF_DATE_TABLE
599: , p5_a33 JTF_NUMBER_TABLE
600: );
601: procedure validate_row(p_api_version NUMBER
602: , p_init_msg_list VARCHAR2
603: , x_return_status out nocopy VARCHAR2
642: , p_init_msg_list VARCHAR2
643: , x_return_status out nocopy VARCHAR2
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
643: , x_return_status out nocopy VARCHAR2
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_NUMBER_TABLE
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_NUMBER_TABLE
653: , p5_a7 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_NUMBER_TABLE
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_NUMBER_TABLE
655: , p5_a9 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_NUMBER_TABLE
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_NUMBER_TABLE
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_DATE_TABLE
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_NUMBER_TABLE
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_NUMBER_TABLE
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_DATE_TABLE
657: , p5_a11 JTF_DATE_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_NUMBER_TABLE
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_NUMBER_TABLE
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_DATE_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_NUMBER_TABLE
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_NUMBER_TABLE
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_DATE_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_VARCHAR2_TABLE_100
654: , p5_a8 JTF_NUMBER_TABLE
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_DATE_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_VARCHAR2_TABLE_100
660: , p5_a14 JTF_VARCHAR2_TABLE_500
661: , p5_a15 JTF_VARCHAR2_TABLE_500
662: , p5_a16 JTF_VARCHAR2_TABLE_500
671: , p5_a25 JTF_VARCHAR2_TABLE_500
672: , p5_a26 JTF_VARCHAR2_TABLE_500
673: , p5_a27 JTF_VARCHAR2_TABLE_500
674: , p5_a28 JTF_VARCHAR2_TABLE_500
675: , p5_a29 JTF_NUMBER_TABLE
676: , p5_a30 JTF_DATE_TABLE
677: , p5_a31 JTF_NUMBER_TABLE
678: , p5_a32 JTF_DATE_TABLE
679: , p5_a33 JTF_NUMBER_TABLE
673: , p5_a27 JTF_VARCHAR2_TABLE_500
674: , p5_a28 JTF_VARCHAR2_TABLE_500
675: , p5_a29 JTF_NUMBER_TABLE
676: , p5_a30 JTF_DATE_TABLE
677: , p5_a31 JTF_NUMBER_TABLE
678: , p5_a32 JTF_DATE_TABLE
679: , p5_a33 JTF_NUMBER_TABLE
680: );
681: end okl_inr_pvt_w;
675: , p5_a29 JTF_NUMBER_TABLE
676: , p5_a30 JTF_DATE_TABLE
677: , p5_a31 JTF_NUMBER_TABLE
678: , p5_a32 JTF_DATE_TABLE
679: , p5_a33 JTF_NUMBER_TABLE
680: );
681: end okl_inr_pvt_w;