1: package okl_ech_pvt_w as
2: /* $Header: OKLIECHS.pls 120.1 2005/10/30 04:58:38 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ech_pvt.okl_ech_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_ech_pvt_w as
2: /* $Header: OKLIECHS.pls 120.1 2005/10/30 04:58:38 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ech_pvt.okl_ech_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
1: package okl_ech_pvt_w as
2: /* $Header: OKLIECHS.pls 120.1 2005/10/30 04:58:38 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ech_pvt.okl_ech_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_ech_pvt.okl_ech_tbl, a0 out nocopy JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_ech_pvt.okl_ech_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_ech_pvt.okl_ech_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_ech_pvt.okl_ech_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_ech_pvt.okl_ech_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_DATE_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_DATE_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_DATE_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure insert_row(p_api_version NUMBER
29: , p_init_msg_list VARCHAR2
57: , p_init_msg_list VARCHAR2
58: , x_return_status out nocopy VARCHAR2
59: , x_msg_count out nocopy NUMBER
60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_VARCHAR2_TABLE_100
65: , p5_a4 JTF_VARCHAR2_TABLE_100
58: , x_return_status out nocopy VARCHAR2
59: , x_msg_count out nocopy NUMBER
60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_VARCHAR2_TABLE_100
65: , p5_a4 JTF_VARCHAR2_TABLE_100
66: , p5_a5 JTF_VARCHAR2_TABLE_100
59: , x_msg_count out nocopy NUMBER
60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_VARCHAR2_TABLE_100
65: , p5_a4 JTF_VARCHAR2_TABLE_100
66: , p5_a5 JTF_VARCHAR2_TABLE_100
67: , p5_a6 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_VARCHAR2_TABLE_100
65: , p5_a4 JTF_VARCHAR2_TABLE_100
66: , p5_a5 JTF_VARCHAR2_TABLE_100
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
65: , p5_a4 JTF_VARCHAR2_TABLE_100
66: , p5_a5 JTF_VARCHAR2_TABLE_100
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
76: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_DATE_TABLE
82: , p6_a10 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_DATE_TABLE
82: , p6_a10 out nocopy JTF_NUMBER_TABLE
83: );
84: procedure update_row(p_api_version NUMBER
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_DATE_TABLE
82: , p6_a10 out nocopy JTF_NUMBER_TABLE
83: );
84: procedure update_row(p_api_version NUMBER
85: , p_init_msg_list VARCHAR2
86: , x_return_status out nocopy VARCHAR2
113: , p_init_msg_list VARCHAR2
114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_VARCHAR2_TABLE_100
121: , p5_a4 JTF_VARCHAR2_TABLE_100
114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_VARCHAR2_TABLE_100
121: , p5_a4 JTF_VARCHAR2_TABLE_100
122: , p5_a5 JTF_VARCHAR2_TABLE_100
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_VARCHAR2_TABLE_100
121: , p5_a4 JTF_VARCHAR2_TABLE_100
122: , p5_a5 JTF_VARCHAR2_TABLE_100
123: , p5_a6 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_VARCHAR2_TABLE_100
121: , p5_a4 JTF_VARCHAR2_TABLE_100
122: , p5_a5 JTF_VARCHAR2_TABLE_100
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
121: , p5_a4 JTF_VARCHAR2_TABLE_100
122: , p5_a5 JTF_VARCHAR2_TABLE_100
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_DATE_TABLE
138: , p6_a10 out nocopy JTF_NUMBER_TABLE
132: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_DATE_TABLE
138: , p6_a10 out nocopy JTF_NUMBER_TABLE
139: );
140: procedure delete_row(p_api_version NUMBER
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_DATE_TABLE
138: , p6_a10 out nocopy JTF_NUMBER_TABLE
139: );
140: procedure delete_row(p_api_version NUMBER
141: , p_init_msg_list VARCHAR2
142: , x_return_status out nocopy VARCHAR2
158: , p_init_msg_list VARCHAR2
159: , x_return_status out nocopy VARCHAR2
160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_VARCHAR2_TABLE_100
166: , p5_a4 JTF_VARCHAR2_TABLE_100
159: , x_return_status out nocopy VARCHAR2
160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_VARCHAR2_TABLE_100
166: , p5_a4 JTF_VARCHAR2_TABLE_100
167: , p5_a5 JTF_VARCHAR2_TABLE_100
160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_VARCHAR2_TABLE_100
166: , p5_a4 JTF_VARCHAR2_TABLE_100
167: , p5_a5 JTF_VARCHAR2_TABLE_100
168: , p5_a6 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_VARCHAR2_TABLE_100
166: , p5_a4 JTF_VARCHAR2_TABLE_100
167: , p5_a5 JTF_VARCHAR2_TABLE_100
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_DATE_TABLE
172: , p5_a10 JTF_NUMBER_TABLE
166: , p5_a4 JTF_VARCHAR2_TABLE_100
167: , p5_a5 JTF_VARCHAR2_TABLE_100
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_DATE_TABLE
172: , p5_a10 JTF_NUMBER_TABLE
173: );
174: end okl_ech_pvt_w;
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_DATE_TABLE
172: , p5_a10 JTF_NUMBER_TABLE
173: );
174: end okl_ech_pvt_w;