[Home] [Help]
PACKAGE: APPS.OKL_QLS_PVT_W
Source
1 package okl_qls_pvt_w as
2 /* $Header: OKLIQLSS.pls 120.2 2005/07/18 15:55:09 viselvar noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_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_DATE_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_VARCHAR2_TABLE_100
17 , a2 out nocopy JTF_NUMBER_TABLE
18 , a3 out nocopy JTF_VARCHAR2_TABLE_100
19 , a4 out nocopy JTF_NUMBER_TABLE
20 , a5 out nocopy JTF_NUMBER_TABLE
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 rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
29 , a1 JTF_VARCHAR2_TABLE_100
30 , a2 JTF_NUMBER_TABLE
31 , a3 JTF_VARCHAR2_TABLE_100
32 , a4 JTF_NUMBER_TABLE
33 , a5 JTF_NUMBER_TABLE
34 , a6 JTF_NUMBER_TABLE
35 , a7 JTF_DATE_TABLE
36 , a8 JTF_NUMBER_TABLE
37 , a9 JTF_DATE_TABLE
38 , a10 JTF_NUMBER_TABLE
39 );
40 procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41 , a1 out nocopy JTF_VARCHAR2_TABLE_100
42 , a2 out nocopy JTF_NUMBER_TABLE
43 , a3 out nocopy JTF_VARCHAR2_TABLE_100
44 , a4 out nocopy JTF_NUMBER_TABLE
45 , a5 out nocopy JTF_NUMBER_TABLE
46 , a6 out nocopy JTF_NUMBER_TABLE
47 , a7 out nocopy JTF_DATE_TABLE
48 , a8 out nocopy JTF_NUMBER_TABLE
49 , a9 out nocopy JTF_DATE_TABLE
50 , a10 out nocopy JTF_NUMBER_TABLE
51 );
52
53 procedure insert_row(p_api_version NUMBER
54 , p_init_msg_list VARCHAR2
55 , x_return_status out nocopy VARCHAR2
56 , x_msg_count out nocopy NUMBER
57 , x_msg_data out nocopy VARCHAR2
58 , p6_a0 out nocopy NUMBER
59 , p6_a1 out nocopy VARCHAR2
60 , p6_a2 out nocopy NUMBER
61 , p6_a3 out nocopy VARCHAR2
62 , p6_a4 out nocopy NUMBER
63 , p6_a5 out nocopy NUMBER
64 , p6_a6 out nocopy NUMBER
65 , p6_a7 out nocopy DATE
66 , p6_a8 out nocopy NUMBER
67 , p6_a9 out nocopy DATE
68 , p6_a10 out nocopy NUMBER
69 , p5_a0 NUMBER := 0-1962.0724
70 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
71 , p5_a2 NUMBER := 0-1962.0724
72 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73 , p5_a4 NUMBER := 0-1962.0724
74 , p5_a5 NUMBER := 0-1962.0724
75 , p5_a6 NUMBER := 0-1962.0724
76 , p5_a7 DATE := fnd_api.g_miss_date
77 , p5_a8 NUMBER := 0-1962.0724
78 , p5_a9 DATE := fnd_api.g_miss_date
79 , p5_a10 NUMBER := 0-1962.0724
80 );
81 procedure insert_row(p_api_version NUMBER
82 , p_init_msg_list VARCHAR2
83 , x_return_status out nocopy VARCHAR2
84 , x_msg_count out nocopy NUMBER
85 , x_msg_data out nocopy VARCHAR2
86 , p5_a0 JTF_NUMBER_TABLE
87 , p5_a1 JTF_VARCHAR2_TABLE_100
88 , p5_a2 JTF_NUMBER_TABLE
89 , p5_a3 JTF_VARCHAR2_TABLE_100
90 , p5_a4 JTF_NUMBER_TABLE
91 , p5_a5 JTF_NUMBER_TABLE
92 , p5_a6 JTF_NUMBER_TABLE
93 , p5_a7 JTF_DATE_TABLE
94 , p5_a8 JTF_NUMBER_TABLE
95 , p5_a9 JTF_DATE_TABLE
96 , p5_a10 JTF_NUMBER_TABLE
97 , p6_a0 out nocopy JTF_NUMBER_TABLE
98 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99 , p6_a2 out nocopy JTF_NUMBER_TABLE
100 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101 , p6_a4 out nocopy JTF_NUMBER_TABLE
102 , p6_a5 out nocopy JTF_NUMBER_TABLE
103 , p6_a6 out nocopy JTF_NUMBER_TABLE
104 , p6_a7 out nocopy JTF_DATE_TABLE
105 , p6_a8 out nocopy JTF_NUMBER_TABLE
106 , p6_a9 out nocopy JTF_DATE_TABLE
107 , p6_a10 out nocopy JTF_NUMBER_TABLE
108 , p7_a0 in out nocopy JTF_NUMBER_TABLE
109 , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
110 , p7_a2 in out nocopy JTF_NUMBER_TABLE
111 , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
112 , p7_a4 in out nocopy JTF_NUMBER_TABLE
113 , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
114 , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
115 );
116 procedure insert_row(p_api_version NUMBER
117 , p_init_msg_list VARCHAR2
118 , x_return_status out nocopy VARCHAR2
119 , x_msg_count out nocopy NUMBER
120 , x_msg_data out nocopy VARCHAR2
121 , p5_a0 JTF_NUMBER_TABLE
122 , p5_a1 JTF_VARCHAR2_TABLE_100
123 , p5_a2 JTF_NUMBER_TABLE
124 , p5_a3 JTF_VARCHAR2_TABLE_100
125 , p5_a4 JTF_NUMBER_TABLE
126 , p5_a5 JTF_NUMBER_TABLE
127 , p5_a6 JTF_NUMBER_TABLE
128 , p5_a7 JTF_DATE_TABLE
129 , p5_a8 JTF_NUMBER_TABLE
130 , p5_a9 JTF_DATE_TABLE
131 , p5_a10 JTF_NUMBER_TABLE
132 , p6_a0 out nocopy JTF_NUMBER_TABLE
133 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134 , p6_a2 out nocopy JTF_NUMBER_TABLE
135 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136 , p6_a4 out nocopy JTF_NUMBER_TABLE
137 , p6_a5 out nocopy JTF_NUMBER_TABLE
138 , p6_a6 out nocopy JTF_NUMBER_TABLE
139 , p6_a7 out nocopy JTF_DATE_TABLE
140 , p6_a8 out nocopy JTF_NUMBER_TABLE
141 , p6_a9 out nocopy JTF_DATE_TABLE
142 , p6_a10 out nocopy JTF_NUMBER_TABLE
143 );
144 procedure lock_row(p_api_version NUMBER
145 , p_init_msg_list VARCHAR2
146 , x_return_status out nocopy VARCHAR2
147 , x_msg_count out nocopy NUMBER
148 , x_msg_data out nocopy VARCHAR2
149 , p5_a0 NUMBER := 0-1962.0724
150 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
151 , p5_a2 NUMBER := 0-1962.0724
152 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
153 , p5_a4 NUMBER := 0-1962.0724
154 , p5_a5 NUMBER := 0-1962.0724
155 , p5_a6 NUMBER := 0-1962.0724
156 , p5_a7 DATE := fnd_api.g_miss_date
157 , p5_a8 NUMBER := 0-1962.0724
158 , p5_a9 DATE := fnd_api.g_miss_date
159 , p5_a10 NUMBER := 0-1962.0724
160 );
161 procedure lock_row(p_api_version NUMBER
162 , p_init_msg_list VARCHAR2
163 , x_return_status out nocopy VARCHAR2
164 , x_msg_count out nocopy NUMBER
165 , x_msg_data out nocopy VARCHAR2
166 , p5_a0 JTF_NUMBER_TABLE
167 , p5_a1 JTF_VARCHAR2_TABLE_100
168 , p5_a2 JTF_NUMBER_TABLE
169 , p5_a3 JTF_VARCHAR2_TABLE_100
170 , p5_a4 JTF_NUMBER_TABLE
171 , p5_a5 JTF_NUMBER_TABLE
172 , p5_a6 JTF_NUMBER_TABLE
173 , p5_a7 JTF_DATE_TABLE
174 , p5_a8 JTF_NUMBER_TABLE
175 , p5_a9 JTF_DATE_TABLE
176 , p5_a10 JTF_NUMBER_TABLE
177 , p6_a0 in out nocopy JTF_NUMBER_TABLE
178 , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
179 , p6_a2 in out nocopy JTF_NUMBER_TABLE
180 , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
181 , p6_a4 in out nocopy JTF_NUMBER_TABLE
182 , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
183 , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
184 );
185 procedure lock_row(p_api_version NUMBER
186 , p_init_msg_list VARCHAR2
187 , x_return_status out nocopy VARCHAR2
188 , x_msg_count out nocopy NUMBER
189 , x_msg_data out nocopy VARCHAR2
190 , p5_a0 JTF_NUMBER_TABLE
191 , p5_a1 JTF_VARCHAR2_TABLE_100
192 , p5_a2 JTF_NUMBER_TABLE
193 , p5_a3 JTF_VARCHAR2_TABLE_100
194 , p5_a4 JTF_NUMBER_TABLE
195 , p5_a5 JTF_NUMBER_TABLE
196 , p5_a6 JTF_NUMBER_TABLE
197 , p5_a7 JTF_DATE_TABLE
198 , p5_a8 JTF_NUMBER_TABLE
199 , p5_a9 JTF_DATE_TABLE
200 , p5_a10 JTF_NUMBER_TABLE
201 );
202 procedure update_row(p_api_version NUMBER
203 , p_init_msg_list VARCHAR2
204 , x_return_status out nocopy VARCHAR2
205 , x_msg_count out nocopy NUMBER
206 , x_msg_data out nocopy VARCHAR2
207 , p6_a0 out nocopy NUMBER
208 , p6_a1 out nocopy VARCHAR2
209 , p6_a2 out nocopy NUMBER
210 , p6_a3 out nocopy VARCHAR2
211 , p6_a4 out nocopy NUMBER
212 , p6_a5 out nocopy NUMBER
213 , p6_a6 out nocopy NUMBER
214 , p6_a7 out nocopy DATE
215 , p6_a8 out nocopy NUMBER
216 , p6_a9 out nocopy DATE
217 , p6_a10 out nocopy NUMBER
218 , p5_a0 NUMBER := 0-1962.0724
219 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
220 , p5_a2 NUMBER := 0-1962.0724
221 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
222 , p5_a4 NUMBER := 0-1962.0724
223 , p5_a5 NUMBER := 0-1962.0724
224 , p5_a6 NUMBER := 0-1962.0724
225 , p5_a7 DATE := fnd_api.g_miss_date
226 , p5_a8 NUMBER := 0-1962.0724
227 , p5_a9 DATE := fnd_api.g_miss_date
228 , p5_a10 NUMBER := 0-1962.0724
229 );
230 procedure update_row(p_api_version NUMBER
231 , p_init_msg_list VARCHAR2
232 , x_return_status out nocopy VARCHAR2
233 , x_msg_count out nocopy NUMBER
234 , x_msg_data out nocopy VARCHAR2
235 , p5_a0 JTF_NUMBER_TABLE
236 , p5_a1 JTF_VARCHAR2_TABLE_100
237 , p5_a2 JTF_NUMBER_TABLE
238 , p5_a3 JTF_VARCHAR2_TABLE_100
239 , p5_a4 JTF_NUMBER_TABLE
240 , p5_a5 JTF_NUMBER_TABLE
241 , p5_a6 JTF_NUMBER_TABLE
242 , p5_a7 JTF_DATE_TABLE
243 , p5_a8 JTF_NUMBER_TABLE
244 , p5_a9 JTF_DATE_TABLE
245 , p5_a10 JTF_NUMBER_TABLE
246 , p6_a0 out nocopy JTF_NUMBER_TABLE
247 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248 , p6_a2 out nocopy JTF_NUMBER_TABLE
249 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250 , p6_a4 out nocopy JTF_NUMBER_TABLE
251 , p6_a5 out nocopy JTF_NUMBER_TABLE
252 , p6_a6 out nocopy JTF_NUMBER_TABLE
253 , p6_a7 out nocopy JTF_DATE_TABLE
254 , p6_a8 out nocopy JTF_NUMBER_TABLE
255 , p6_a9 out nocopy JTF_DATE_TABLE
256 , p6_a10 out nocopy JTF_NUMBER_TABLE
257 , p7_a0 in out nocopy JTF_NUMBER_TABLE
258 , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
259 , p7_a2 in out nocopy JTF_NUMBER_TABLE
260 , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
261 , p7_a4 in out nocopy JTF_NUMBER_TABLE
262 , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
263 , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
264 );
265 procedure update_row(p_api_version NUMBER
266 , p_init_msg_list VARCHAR2
267 , x_return_status out nocopy VARCHAR2
268 , x_msg_count out nocopy NUMBER
269 , x_msg_data out nocopy VARCHAR2
270 , p5_a0 JTF_NUMBER_TABLE
271 , p5_a1 JTF_VARCHAR2_TABLE_100
272 , p5_a2 JTF_NUMBER_TABLE
273 , p5_a3 JTF_VARCHAR2_TABLE_100
274 , p5_a4 JTF_NUMBER_TABLE
275 , p5_a5 JTF_NUMBER_TABLE
276 , p5_a6 JTF_NUMBER_TABLE
277 , p5_a7 JTF_DATE_TABLE
278 , p5_a8 JTF_NUMBER_TABLE
279 , p5_a9 JTF_DATE_TABLE
280 , p5_a10 JTF_NUMBER_TABLE
281 , p6_a0 out nocopy JTF_NUMBER_TABLE
282 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283 , p6_a2 out nocopy JTF_NUMBER_TABLE
284 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285 , p6_a4 out nocopy JTF_NUMBER_TABLE
286 , p6_a5 out nocopy JTF_NUMBER_TABLE
287 , p6_a6 out nocopy JTF_NUMBER_TABLE
288 , p6_a7 out nocopy JTF_DATE_TABLE
289 , p6_a8 out nocopy JTF_NUMBER_TABLE
290 , p6_a9 out nocopy JTF_DATE_TABLE
291 , p6_a10 out nocopy JTF_NUMBER_TABLE
292 );
293 procedure delete_row(p_api_version NUMBER
294 , p_init_msg_list VARCHAR2
295 , x_return_status out nocopy VARCHAR2
296 , x_msg_count out nocopy NUMBER
297 , x_msg_data out nocopy VARCHAR2
298 , p5_a0 NUMBER := 0-1962.0724
299 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
300 , p5_a2 NUMBER := 0-1962.0724
301 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
302 , p5_a4 NUMBER := 0-1962.0724
303 , p5_a5 NUMBER := 0-1962.0724
304 , p5_a6 NUMBER := 0-1962.0724
305 , p5_a7 DATE := fnd_api.g_miss_date
306 , p5_a8 NUMBER := 0-1962.0724
307 , p5_a9 DATE := fnd_api.g_miss_date
308 , p5_a10 NUMBER := 0-1962.0724
309 );
310 procedure delete_row(p_api_version NUMBER
311 , p_init_msg_list VARCHAR2
312 , x_return_status out nocopy VARCHAR2
313 , x_msg_count out nocopy NUMBER
314 , x_msg_data out nocopy VARCHAR2
315 , p5_a0 JTF_NUMBER_TABLE
316 , p5_a1 JTF_VARCHAR2_TABLE_100
317 , p5_a2 JTF_NUMBER_TABLE
318 , p5_a3 JTF_VARCHAR2_TABLE_100
319 , p5_a4 JTF_NUMBER_TABLE
320 , p5_a5 JTF_NUMBER_TABLE
321 , p5_a6 JTF_NUMBER_TABLE
322 , p5_a7 JTF_DATE_TABLE
323 , p5_a8 JTF_NUMBER_TABLE
324 , p5_a9 JTF_DATE_TABLE
325 , p5_a10 JTF_NUMBER_TABLE
326 , p6_a0 in out nocopy JTF_NUMBER_TABLE
327 , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
328 , p6_a2 in out nocopy JTF_NUMBER_TABLE
329 , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
330 , p6_a4 in out nocopy JTF_NUMBER_TABLE
331 , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
332 , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
333 );
334 procedure delete_row(p_api_version NUMBER
335 , p_init_msg_list VARCHAR2
336 , x_return_status out nocopy VARCHAR2
337 , x_msg_count out nocopy NUMBER
338 , x_msg_data out nocopy VARCHAR2
339 , p5_a0 JTF_NUMBER_TABLE
340 , p5_a1 JTF_VARCHAR2_TABLE_100
341 , p5_a2 JTF_NUMBER_TABLE
342 , p5_a3 JTF_VARCHAR2_TABLE_100
343 , p5_a4 JTF_NUMBER_TABLE
344 , p5_a5 JTF_NUMBER_TABLE
345 , p5_a6 JTF_NUMBER_TABLE
346 , p5_a7 JTF_DATE_TABLE
347 , p5_a8 JTF_NUMBER_TABLE
348 , p5_a9 JTF_DATE_TABLE
349 , p5_a10 JTF_NUMBER_TABLE
350 );
351 procedure validate_row(p_api_version NUMBER
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 NUMBER := 0-1962.0724
357 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
358 , p5_a2 NUMBER := 0-1962.0724
359 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
360 , p5_a4 NUMBER := 0-1962.0724
361 , p5_a5 NUMBER := 0-1962.0724
362 , p5_a6 NUMBER := 0-1962.0724
363 , p5_a7 DATE := fnd_api.g_miss_date
364 , p5_a8 NUMBER := 0-1962.0724
365 , p5_a9 DATE := fnd_api.g_miss_date
366 , p5_a10 NUMBER := 0-1962.0724
367 );
368 procedure validate_row(p_api_version NUMBER
369 , p_init_msg_list VARCHAR2
370 , x_return_status out nocopy VARCHAR2
371 , x_msg_count out nocopy NUMBER
372 , x_msg_data out nocopy VARCHAR2
373 , p5_a0 JTF_NUMBER_TABLE
374 , p5_a1 JTF_VARCHAR2_TABLE_100
375 , p5_a2 JTF_NUMBER_TABLE
376 , p5_a3 JTF_VARCHAR2_TABLE_100
377 , p5_a4 JTF_NUMBER_TABLE
378 , p5_a5 JTF_NUMBER_TABLE
379 , p5_a6 JTF_NUMBER_TABLE
380 , p5_a7 JTF_DATE_TABLE
381 , p5_a8 JTF_NUMBER_TABLE
382 , p5_a9 JTF_DATE_TABLE
383 , p5_a10 JTF_NUMBER_TABLE
384 , p6_a0 in out nocopy JTF_NUMBER_TABLE
385 , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
386 , p6_a2 in out nocopy JTF_NUMBER_TABLE
387 , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
388 , p6_a4 in out nocopy JTF_NUMBER_TABLE
389 , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
390 , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
391 );
392 procedure validate_row(p_api_version NUMBER
393 , p_init_msg_list VARCHAR2
394 , x_return_status out nocopy VARCHAR2
395 , x_msg_count out nocopy NUMBER
396 , x_msg_data out nocopy VARCHAR2
397 , p5_a0 JTF_NUMBER_TABLE
398 , p5_a1 JTF_VARCHAR2_TABLE_100
399 , p5_a2 JTF_NUMBER_TABLE
400 , p5_a3 JTF_VARCHAR2_TABLE_100
401 , p5_a4 JTF_NUMBER_TABLE
402 , p5_a5 JTF_NUMBER_TABLE
403 , p5_a6 JTF_NUMBER_TABLE
404 , p5_a7 JTF_DATE_TABLE
405 , p5_a8 JTF_NUMBER_TABLE
406 , p5_a9 JTF_DATE_TABLE
407 , p5_a10 JTF_NUMBER_TABLE
408 );
409 end okl_qls_pvt_w;