[Home] [Help]
PACKAGE: APPS.OKL_ECC_PVT_W
Source
1 package okl_ecc_pvt_w as
2 /* $Header: OKLIECCS.pls 120.1 2005/10/30 04:58:35 appldev noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy okl_ecc_pvt.okl_eccv_tbl, 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_300
8 , a5 JTF_VARCHAR2_TABLE_2000
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_2000
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_DATE_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_DATE_TABLE
21 , a18 JTF_NUMBER_TABLE
22 );
23 procedure rosetta_table_copy_out_p1(t okl_ecc_pvt.okl_eccv_tbl, a0 out nocopy JTF_NUMBER_TABLE
24 , a1 out nocopy JTF_NUMBER_TABLE
25 , a2 out nocopy JTF_VARCHAR2_TABLE_100
26 , a3 out nocopy JTF_NUMBER_TABLE
27 , a4 out nocopy JTF_VARCHAR2_TABLE_300
28 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
29 , a6 out nocopy JTF_VARCHAR2_TABLE_100
30 , a7 out nocopy JTF_VARCHAR2_TABLE_100
31 , a8 out nocopy JTF_VARCHAR2_TABLE_100
32 , a9 out nocopy JTF_VARCHAR2_TABLE_100
33 , a10 out nocopy JTF_VARCHAR2_TABLE_100
34 , a11 out nocopy JTF_NUMBER_TABLE
35 , a12 out nocopy JTF_VARCHAR2_TABLE_100
36 , a13 out nocopy JTF_VARCHAR2_TABLE_2000
37 , a14 out nocopy JTF_NUMBER_TABLE
38 , a15 out nocopy JTF_DATE_TABLE
39 , a16 out nocopy JTF_NUMBER_TABLE
40 , a17 out nocopy JTF_DATE_TABLE
41 , a18 out nocopy JTF_NUMBER_TABLE
42 );
43
44 procedure rosetta_table_copy_in_p3(t out nocopy okl_ecc_pvt.okl_eccb_tbl, a0 JTF_NUMBER_TABLE
45 , a1 JTF_NUMBER_TABLE
46 , a2 JTF_VARCHAR2_TABLE_300
47 , a3 JTF_VARCHAR2_TABLE_100
48 , a4 JTF_NUMBER_TABLE
49 , a5 JTF_VARCHAR2_TABLE_100
50 , a6 JTF_VARCHAR2_TABLE_100
51 , a7 JTF_VARCHAR2_TABLE_100
52 , a8 JTF_VARCHAR2_TABLE_100
53 , a9 JTF_NUMBER_TABLE
54 , a10 JTF_VARCHAR2_TABLE_100
55 , a11 JTF_VARCHAR2_TABLE_2000
56 , a12 JTF_NUMBER_TABLE
57 , a13 JTF_DATE_TABLE
58 , a14 JTF_NUMBER_TABLE
59 , a15 JTF_DATE_TABLE
60 , a16 JTF_NUMBER_TABLE
61 );
62 procedure rosetta_table_copy_out_p3(t okl_ecc_pvt.okl_eccb_tbl, a0 out nocopy JTF_NUMBER_TABLE
63 , a1 out nocopy JTF_NUMBER_TABLE
64 , a2 out nocopy JTF_VARCHAR2_TABLE_300
65 , a3 out nocopy JTF_VARCHAR2_TABLE_100
66 , a4 out nocopy JTF_NUMBER_TABLE
67 , a5 out nocopy JTF_VARCHAR2_TABLE_100
68 , a6 out nocopy JTF_VARCHAR2_TABLE_100
69 , a7 out nocopy JTF_VARCHAR2_TABLE_100
70 , a8 out nocopy JTF_VARCHAR2_TABLE_100
71 , a9 out nocopy JTF_NUMBER_TABLE
72 , a10 out nocopy JTF_VARCHAR2_TABLE_100
73 , a11 out nocopy JTF_VARCHAR2_TABLE_2000
74 , a12 out nocopy JTF_NUMBER_TABLE
75 , a13 out nocopy JTF_DATE_TABLE
76 , a14 out nocopy JTF_NUMBER_TABLE
77 , a15 out nocopy JTF_DATE_TABLE
78 , a16 out nocopy JTF_NUMBER_TABLE
79 );
80
81 procedure rosetta_table_copy_in_p5(t out nocopy okl_ecc_pvt.okl_ecctl_tbl, a0 JTF_NUMBER_TABLE
82 , a1 JTF_VARCHAR2_TABLE_100
83 , a2 JTF_VARCHAR2_TABLE_100
84 , a3 JTF_VARCHAR2_TABLE_100
85 , a4 JTF_VARCHAR2_TABLE_2000
86 , a5 JTF_NUMBER_TABLE
87 , a6 JTF_DATE_TABLE
88 , a7 JTF_NUMBER_TABLE
89 , a8 JTF_DATE_TABLE
90 , a9 JTF_NUMBER_TABLE
91 );
92 procedure rosetta_table_copy_out_p5(t okl_ecc_pvt.okl_ecctl_tbl, a0 out nocopy JTF_NUMBER_TABLE
93 , a1 out nocopy JTF_VARCHAR2_TABLE_100
94 , a2 out nocopy JTF_VARCHAR2_TABLE_100
95 , a3 out nocopy JTF_VARCHAR2_TABLE_100
96 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
97 , a5 out nocopy JTF_NUMBER_TABLE
98 , a6 out nocopy JTF_DATE_TABLE
99 , a7 out nocopy JTF_NUMBER_TABLE
100 , a8 out nocopy JTF_DATE_TABLE
101 , a9 out nocopy JTF_NUMBER_TABLE
102 );
103
104 procedure insert_row(p_api_version NUMBER
105 , p_init_msg_list VARCHAR2
106 , x_return_status out nocopy VARCHAR2
107 , x_msg_count out nocopy NUMBER
108 , x_msg_data out nocopy VARCHAR2
109 , p5_a0 NUMBER
110 , p5_a1 NUMBER
111 , p5_a2 VARCHAR2
112 , p5_a3 NUMBER
113 , p5_a4 VARCHAR2
114 , p5_a5 VARCHAR2
115 , p5_a6 VARCHAR2
116 , p5_a7 VARCHAR2
117 , p5_a8 VARCHAR2
118 , p5_a9 VARCHAR2
119 , p5_a10 VARCHAR2
120 , p5_a11 NUMBER
121 , p5_a12 VARCHAR2
122 , p5_a13 VARCHAR2
123 , p5_a14 NUMBER
124 , p5_a15 DATE
125 , p5_a16 NUMBER
126 , p5_a17 DATE
127 , p5_a18 NUMBER
128 , p6_a0 out nocopy NUMBER
129 , p6_a1 out nocopy NUMBER
130 , p6_a2 out nocopy VARCHAR2
131 , p6_a3 out nocopy NUMBER
132 , p6_a4 out nocopy VARCHAR2
133 , p6_a5 out nocopy VARCHAR2
134 , p6_a6 out nocopy VARCHAR2
135 , p6_a7 out nocopy VARCHAR2
136 , p6_a8 out nocopy VARCHAR2
137 , p6_a9 out nocopy VARCHAR2
138 , p6_a10 out nocopy VARCHAR2
139 , p6_a11 out nocopy NUMBER
140 , p6_a12 out nocopy VARCHAR2
141 , p6_a13 out nocopy VARCHAR2
142 , p6_a14 out nocopy NUMBER
143 , p6_a15 out nocopy DATE
144 , p6_a16 out nocopy NUMBER
145 , p6_a17 out nocopy DATE
146 , p6_a18 out nocopy NUMBER
147 );
148 procedure insert_row(p_api_version NUMBER
149 , p_init_msg_list VARCHAR2
150 , x_return_status out nocopy VARCHAR2
151 , x_msg_count out nocopy NUMBER
152 , x_msg_data out nocopy VARCHAR2
153 , p5_a0 JTF_NUMBER_TABLE
154 , p5_a1 JTF_NUMBER_TABLE
155 , p5_a2 JTF_VARCHAR2_TABLE_100
156 , p5_a3 JTF_NUMBER_TABLE
157 , p5_a4 JTF_VARCHAR2_TABLE_300
158 , p5_a5 JTF_VARCHAR2_TABLE_2000
159 , p5_a6 JTF_VARCHAR2_TABLE_100
160 , p5_a7 JTF_VARCHAR2_TABLE_100
161 , p5_a8 JTF_VARCHAR2_TABLE_100
162 , p5_a9 JTF_VARCHAR2_TABLE_100
163 , p5_a10 JTF_VARCHAR2_TABLE_100
164 , p5_a11 JTF_NUMBER_TABLE
165 , p5_a12 JTF_VARCHAR2_TABLE_100
166 , p5_a13 JTF_VARCHAR2_TABLE_2000
167 , p5_a14 JTF_NUMBER_TABLE
168 , p5_a15 JTF_DATE_TABLE
169 , p5_a16 JTF_NUMBER_TABLE
170 , p5_a17 JTF_DATE_TABLE
171 , p5_a18 JTF_NUMBER_TABLE
172 , p6_a0 out nocopy JTF_NUMBER_TABLE
173 , p6_a1 out nocopy JTF_NUMBER_TABLE
174 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
175 , p6_a3 out nocopy JTF_NUMBER_TABLE
176 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
177 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
178 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
179 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
180 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
181 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
182 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
183 , p6_a11 out nocopy JTF_NUMBER_TABLE
184 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
185 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
186 , p6_a14 out nocopy JTF_NUMBER_TABLE
187 , p6_a15 out nocopy JTF_DATE_TABLE
188 , p6_a16 out nocopy JTF_NUMBER_TABLE
189 , p6_a17 out nocopy JTF_DATE_TABLE
190 , p6_a18 out nocopy JTF_NUMBER_TABLE
191 );
192 procedure update_row(p_api_version NUMBER
193 , p_init_msg_list VARCHAR2
194 , x_return_status out nocopy VARCHAR2
195 , x_msg_count out nocopy NUMBER
196 , x_msg_data out nocopy VARCHAR2
197 , p5_a0 NUMBER
198 , p5_a1 NUMBER
199 , p5_a2 VARCHAR2
200 , p5_a3 NUMBER
201 , p5_a4 VARCHAR2
202 , p5_a5 VARCHAR2
203 , p5_a6 VARCHAR2
204 , p5_a7 VARCHAR2
205 , p5_a8 VARCHAR2
206 , p5_a9 VARCHAR2
207 , p5_a10 VARCHAR2
208 , p5_a11 NUMBER
209 , p5_a12 VARCHAR2
210 , p5_a13 VARCHAR2
211 , p5_a14 NUMBER
212 , p5_a15 DATE
213 , p5_a16 NUMBER
214 , p5_a17 DATE
215 , p5_a18 NUMBER
216 , p6_a0 out nocopy NUMBER
217 , p6_a1 out nocopy NUMBER
218 , p6_a2 out nocopy VARCHAR2
219 , p6_a3 out nocopy NUMBER
220 , p6_a4 out nocopy VARCHAR2
221 , p6_a5 out nocopy VARCHAR2
222 , p6_a6 out nocopy VARCHAR2
223 , p6_a7 out nocopy VARCHAR2
224 , p6_a8 out nocopy VARCHAR2
225 , p6_a9 out nocopy VARCHAR2
226 , p6_a10 out nocopy VARCHAR2
227 , p6_a11 out nocopy NUMBER
228 , p6_a12 out nocopy VARCHAR2
229 , p6_a13 out nocopy VARCHAR2
230 , p6_a14 out nocopy NUMBER
231 , p6_a15 out nocopy DATE
232 , p6_a16 out nocopy NUMBER
233 , p6_a17 out nocopy DATE
234 , p6_a18 out nocopy NUMBER
235 );
236 procedure update_row(p_api_version NUMBER
237 , p_init_msg_list VARCHAR2
238 , x_return_status out nocopy VARCHAR2
239 , x_msg_count out nocopy NUMBER
240 , x_msg_data out nocopy VARCHAR2
241 , p5_a0 JTF_NUMBER_TABLE
242 , p5_a1 JTF_NUMBER_TABLE
243 , p5_a2 JTF_VARCHAR2_TABLE_100
244 , p5_a3 JTF_NUMBER_TABLE
245 , p5_a4 JTF_VARCHAR2_TABLE_300
246 , p5_a5 JTF_VARCHAR2_TABLE_2000
247 , p5_a6 JTF_VARCHAR2_TABLE_100
248 , p5_a7 JTF_VARCHAR2_TABLE_100
249 , p5_a8 JTF_VARCHAR2_TABLE_100
250 , p5_a9 JTF_VARCHAR2_TABLE_100
251 , p5_a10 JTF_VARCHAR2_TABLE_100
252 , p5_a11 JTF_NUMBER_TABLE
253 , p5_a12 JTF_VARCHAR2_TABLE_100
254 , p5_a13 JTF_VARCHAR2_TABLE_2000
255 , p5_a14 JTF_NUMBER_TABLE
256 , p5_a15 JTF_DATE_TABLE
257 , p5_a16 JTF_NUMBER_TABLE
258 , p5_a17 JTF_DATE_TABLE
259 , p5_a18 JTF_NUMBER_TABLE
260 , p6_a0 out nocopy JTF_NUMBER_TABLE
261 , p6_a1 out nocopy JTF_NUMBER_TABLE
262 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
263 , p6_a3 out nocopy JTF_NUMBER_TABLE
264 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
265 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
266 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
267 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
268 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
269 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
270 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
271 , p6_a11 out nocopy JTF_NUMBER_TABLE
272 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
273 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
274 , p6_a14 out nocopy JTF_NUMBER_TABLE
275 , p6_a15 out nocopy JTF_DATE_TABLE
276 , p6_a16 out nocopy JTF_NUMBER_TABLE
277 , p6_a17 out nocopy JTF_DATE_TABLE
278 , p6_a18 out nocopy JTF_NUMBER_TABLE
279 );
280 procedure delete_row(p_api_version NUMBER
281 , p_init_msg_list VARCHAR2
282 , x_return_status out nocopy VARCHAR2
283 , x_msg_count out nocopy NUMBER
284 , x_msg_data out nocopy VARCHAR2
285 , p5_a0 NUMBER
286 , p5_a1 NUMBER
287 , p5_a2 VARCHAR2
288 , p5_a3 NUMBER
289 , p5_a4 VARCHAR2
290 , p5_a5 VARCHAR2
291 , p5_a6 VARCHAR2
292 , p5_a7 VARCHAR2
293 , p5_a8 VARCHAR2
294 , p5_a9 VARCHAR2
295 , p5_a10 VARCHAR2
296 , p5_a11 NUMBER
297 , p5_a12 VARCHAR2
298 , p5_a13 VARCHAR2
299 , p5_a14 NUMBER
300 , p5_a15 DATE
301 , p5_a16 NUMBER
302 , p5_a17 DATE
303 , p5_a18 NUMBER
304 );
305 procedure delete_row(p_api_version NUMBER
306 , p_init_msg_list VARCHAR2
307 , x_return_status out nocopy VARCHAR2
308 , x_msg_count out nocopy NUMBER
309 , x_msg_data out nocopy VARCHAR2
310 , p5_a0 JTF_NUMBER_TABLE
311 , p5_a1 JTF_NUMBER_TABLE
312 , p5_a2 JTF_VARCHAR2_TABLE_100
313 , p5_a3 JTF_NUMBER_TABLE
314 , p5_a4 JTF_VARCHAR2_TABLE_300
315 , p5_a5 JTF_VARCHAR2_TABLE_2000
316 , p5_a6 JTF_VARCHAR2_TABLE_100
317 , p5_a7 JTF_VARCHAR2_TABLE_100
318 , p5_a8 JTF_VARCHAR2_TABLE_100
319 , p5_a9 JTF_VARCHAR2_TABLE_100
320 , p5_a10 JTF_VARCHAR2_TABLE_100
321 , p5_a11 JTF_NUMBER_TABLE
322 , p5_a12 JTF_VARCHAR2_TABLE_100
323 , p5_a13 JTF_VARCHAR2_TABLE_2000
324 , p5_a14 JTF_NUMBER_TABLE
325 , p5_a15 JTF_DATE_TABLE
326 , p5_a16 JTF_NUMBER_TABLE
327 , p5_a17 JTF_DATE_TABLE
328 , p5_a18 JTF_NUMBER_TABLE
329 );
330 end okl_ecc_pvt_w;