1 package csi_asset_pvt_w AUTHID CURRENT_USER as
2 /* $Header: csivasws.pls 120.10 2008/01/15 03:33:11 devijay ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_VARCHAR2_TABLE_100
5 );
6 procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
7 , a1 out nocopy JTF_VARCHAR2_TABLE_100
8 );
9
10 procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE
11 , a1 JTF_VARCHAR2_TABLE_100
12 , a2 JTF_VARCHAR2_TABLE_100
13 );
14 procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
15 , a1 out nocopy JTF_VARCHAR2_TABLE_100
16 , a2 out nocopy JTF_VARCHAR2_TABLE_100
17 );
18
19 procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE
20 , a1 JTF_VARCHAR2_TABLE_100
21 );
22 procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE
23 , a1 out nocopy JTF_VARCHAR2_TABLE_100
24 );
25
26 procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
27 , a1 JTF_NUMBER_TABLE
28 , a2 JTF_NUMBER_TABLE
29 , a3 JTF_NUMBER_TABLE
30 , a4 JTF_NUMBER_TABLE
31 );
32 procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
33 , a1 out nocopy JTF_NUMBER_TABLE
34 , a2 out nocopy JTF_NUMBER_TABLE
35 , a3 out nocopy JTF_NUMBER_TABLE
36 , a4 out nocopy JTF_NUMBER_TABLE
37 );
38
39 procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
40 , a1 JTF_NUMBER_TABLE
41 , a2 JTF_NUMBER_TABLE
42 , a3 JTF_NUMBER_TABLE
43 );
44 procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
45 , a1 out nocopy JTF_NUMBER_TABLE
46 , a2 out nocopy JTF_NUMBER_TABLE
47 , a3 out nocopy JTF_NUMBER_TABLE
48 );
49
50 procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
51 , a1 JTF_NUMBER_TABLE
52 , a2 JTF_NUMBER_TABLE
53 , a3 JTF_NUMBER_TABLE
54 , a4 JTF_VARCHAR2_TABLE_100
55 , a5 JTF_NUMBER_TABLE
56 , a6 JTF_NUMBER_TABLE
57 , a7 JTF_VARCHAR2_TABLE_100
58 );
59 procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
60 , a1 out nocopy JTF_NUMBER_TABLE
61 , a2 out nocopy JTF_NUMBER_TABLE
62 , a3 out nocopy JTF_NUMBER_TABLE
63 , a4 out nocopy JTF_VARCHAR2_TABLE_100
64 , a5 out nocopy JTF_NUMBER_TABLE
65 , a6 out nocopy JTF_NUMBER_TABLE
66 , a7 out nocopy JTF_VARCHAR2_TABLE_100
67 );
68
69 procedure initialize_asset_rec(p0_a0 in out nocopy NUMBER
70 , p0_a1 in out nocopy NUMBER
71 , p0_a2 in out nocopy NUMBER
72 , p0_a3 in out nocopy VARCHAR2
73 , p0_a4 in out nocopy NUMBER
74 , p0_a5 in out nocopy NUMBER
75 , p0_a6 in out nocopy VARCHAR2
76 , p0_a7 in out nocopy DATE
77 , p0_a8 in out nocopy DATE
78 , p0_a9 in out nocopy NUMBER
79 , p0_a10 in out nocopy VARCHAR2
80 , p0_a11 in out nocopy VARCHAR2
81 , p0_a12 in out nocopy VARCHAR2
82 , p0_a13 in out nocopy VARCHAR2
83 , p0_a14 in out nocopy VARCHAR2
84 , p0_a15 in out nocopy VARCHAR2
85 , p0_a16 in out nocopy VARCHAR2
86 , p0_a17 in out nocopy VARCHAR2
87 , p0_a18 in out nocopy VARCHAR2
88 , p0_a19 in out nocopy VARCHAR2
89 , p0_a20 in out nocopy VARCHAR2
90 , p0_a21 in out nocopy DATE
91 , p0_a22 in out nocopy VARCHAR2
92 , p0_a23 in out nocopy VARCHAR2
93 , p0_a24 in out nocopy VARCHAR2
94 , p0_a25 in out nocopy NUMBER
95 , p0_a26 in out nocopy VARCHAR2
96 , p_inst_asset_hist_id NUMBER
97 , x_nearest_full_dump in out nocopy date
98 );
99 procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
100 , p0_a1 in out nocopy JTF_NUMBER_TABLE
101 , p0_a2 in out nocopy JTF_NUMBER_TABLE
102 , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
103 , p0_a4 in out nocopy JTF_NUMBER_TABLE
104 , p0_a5 in out nocopy JTF_NUMBER_TABLE
105 , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
106 , p0_a7 in out nocopy JTF_DATE_TABLE
107 , p0_a8 in out nocopy JTF_DATE_TABLE
108 , p0_a9 in out nocopy JTF_NUMBER_TABLE
109 , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
110 , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
111 , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112 , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113 , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114 , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115 , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116 , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
117 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
118 , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
119 , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
120 , p0_a21 in out nocopy JTF_DATE_TABLE
121 , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
122 , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
123 , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
124 , p0_a25 in out nocopy JTF_NUMBER_TABLE
125 , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
126 , p_time_stamp date
127 );
128 procedure get_asset_column_values(p_get_asset_cursor_id NUMBER
129 , p1_a0 out nocopy NUMBER
130 , p1_a1 out nocopy NUMBER
131 , p1_a2 out nocopy NUMBER
132 , p1_a3 out nocopy VARCHAR2
133 , p1_a4 out nocopy NUMBER
134 , p1_a5 out nocopy NUMBER
135 , p1_a6 out nocopy VARCHAR2
136 , p1_a7 out nocopy DATE
137 , p1_a8 out nocopy DATE
138 , p1_a9 out nocopy NUMBER
139 , p1_a10 out nocopy VARCHAR2
140 , p1_a11 out nocopy VARCHAR2
141 , p1_a12 out nocopy VARCHAR2
142 , p1_a13 out nocopy VARCHAR2
143 , p1_a14 out nocopy VARCHAR2
144 , p1_a15 out nocopy VARCHAR2
145 , p1_a16 out nocopy VARCHAR2
146 , p1_a17 out nocopy VARCHAR2
147 , p1_a18 out nocopy VARCHAR2
148 , p1_a19 out nocopy VARCHAR2
149 , p1_a20 out nocopy VARCHAR2
150 , p1_a21 out nocopy DATE
151 , p1_a22 out nocopy VARCHAR2
152 , p1_a23 out nocopy VARCHAR2
153 , p1_a24 out nocopy VARCHAR2
154 , p1_a25 out nocopy NUMBER
155 , p1_a26 out nocopy VARCHAR2
156 );
157 procedure bind_asset_variable(p_get_asset_cursor_id NUMBER
158 , p0_a0 NUMBER := 0-1962.0724
159 , p0_a1 NUMBER := 0-1962.0724
160 , p0_a2 NUMBER := 0-1962.0724
161 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
162 , p0_a4 NUMBER := 0-1962.0724
163 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
164 , p0_a6 NUMBER := 0-1962.0724
165 );
166 procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
167 , p0_a1 in out nocopy JTF_NUMBER_TABLE
168 , p0_a2 in out nocopy JTF_NUMBER_TABLE
169 , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
170 , p0_a4 in out nocopy JTF_NUMBER_TABLE
171 , p0_a5 in out nocopy JTF_NUMBER_TABLE
172 , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
173 , p0_a7 in out nocopy JTF_DATE_TABLE
174 , p0_a8 in out nocopy JTF_DATE_TABLE
175 , p0_a9 in out nocopy JTF_NUMBER_TABLE
176 , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
177 , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
178 , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179 , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180 , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181 , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182 , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183 , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
184 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
185 , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
186 , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
187 , p0_a21 in out nocopy JTF_DATE_TABLE
188 , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
189 , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
190 , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
191 , p0_a25 in out nocopy JTF_NUMBER_TABLE
192 , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
193 );
194 procedure gen_asset_where_clause(x_where_clause out nocopy VARCHAR2
195 , p0_a0 NUMBER := 0-1962.0724
196 , p0_a1 NUMBER := 0-1962.0724
197 , p0_a2 NUMBER := 0-1962.0724
198 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
199 , p0_a4 NUMBER := 0-1962.0724
200 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
201 , p0_a6 NUMBER := 0-1962.0724
202 );
203 procedure get_instance_assets(p_api_version NUMBER
204 , p_commit VARCHAR2
205 , p_init_msg_list VARCHAR2
206 , p_validation_level NUMBER
207 , p_resolve_id_columns VARCHAR2
208 , p_time_stamp date
209 , p7_a0 out nocopy JTF_NUMBER_TABLE
210 , p7_a1 out nocopy JTF_NUMBER_TABLE
211 , p7_a2 out nocopy JTF_NUMBER_TABLE
212 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
213 , p7_a4 out nocopy JTF_NUMBER_TABLE
214 , p7_a5 out nocopy JTF_NUMBER_TABLE
215 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
216 , p7_a7 out nocopy JTF_DATE_TABLE
217 , p7_a8 out nocopy JTF_DATE_TABLE
218 , p7_a9 out nocopy JTF_NUMBER_TABLE
219 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
220 , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
221 , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
227 , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
228 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
229 , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
230 , p7_a21 out nocopy JTF_DATE_TABLE
231 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
232 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
233 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
234 , p7_a25 out nocopy JTF_NUMBER_TABLE
235 , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
236 , x_return_status out nocopy VARCHAR2
237 , x_msg_count out nocopy NUMBER
238 , x_msg_data out nocopy VARCHAR2
239 , p4_a0 NUMBER := 0-1962.0724
240 , p4_a1 NUMBER := 0-1962.0724
241 , p4_a2 NUMBER := 0-1962.0724
242 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
243 , p4_a4 NUMBER := 0-1962.0724
244 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
245 , p4_a6 NUMBER := 0-1962.0724
246 );
247 procedure create_instance_asset(p_api_version NUMBER
248 , p_commit VARCHAR2
249 , p_init_msg_list VARCHAR2
250 , p_validation_level NUMBER
251 , p4_a0 in out nocopy NUMBER
252 , p4_a1 in out nocopy NUMBER
253 , p4_a2 in out nocopy NUMBER
254 , p4_a3 in out nocopy VARCHAR2
255 , p4_a4 in out nocopy NUMBER
256 , p4_a5 in out nocopy NUMBER
257 , p4_a6 in out nocopy VARCHAR2
258 , p4_a7 in out nocopy DATE
259 , p4_a8 in out nocopy DATE
260 , p4_a9 in out nocopy NUMBER
261 , p4_a10 in out nocopy VARCHAR2
262 , p4_a11 in out nocopy NUMBER
263 , p4_a12 in out nocopy VARCHAR2
264 , p4_a13 in out nocopy NUMBER
265 , p4_a14 in out nocopy VARCHAR2
266 , p4_a15 in out nocopy VARCHAR2
267 , p5_a0 in out nocopy NUMBER
268 , p5_a1 in out nocopy DATE
269 , p5_a2 in out nocopy DATE
270 , p5_a3 in out nocopy NUMBER
271 , p5_a4 in out nocopy NUMBER
272 , p5_a5 in out nocopy NUMBER
273 , p5_a6 in out nocopy VARCHAR2
274 , p5_a7 in out nocopy NUMBER
275 , p5_a8 in out nocopy VARCHAR2
276 , p5_a9 in out nocopy NUMBER
277 , p5_a10 in out nocopy VARCHAR2
278 , p5_a11 in out nocopy NUMBER
279 , p5_a12 in out nocopy NUMBER
280 , p5_a13 in out nocopy NUMBER
281 , p5_a14 in out nocopy NUMBER
282 , p5_a15 in out nocopy VARCHAR2
283 , p5_a16 in out nocopy NUMBER
284 , p5_a17 in out nocopy VARCHAR2
285 , p5_a18 in out nocopy VARCHAR2
286 , p5_a19 in out nocopy NUMBER
287 , p5_a20 in out nocopy VARCHAR2
288 , p5_a21 in out nocopy VARCHAR2
289 , p5_a22 in out nocopy VARCHAR2
290 , p5_a23 in out nocopy VARCHAR2
291 , p5_a24 in out nocopy VARCHAR2
292 , p5_a25 in out nocopy VARCHAR2
293 , p5_a26 in out nocopy VARCHAR2
294 , p5_a27 in out nocopy VARCHAR2
295 , p5_a28 in out nocopy VARCHAR2
296 , p5_a29 in out nocopy VARCHAR2
297 , p5_a30 in out nocopy VARCHAR2
298 , p5_a31 in out nocopy VARCHAR2
299 , p5_a32 in out nocopy VARCHAR2
300 , p5_a33 in out nocopy VARCHAR2
301 , p5_a34 in out nocopy VARCHAR2
302 , p5_a35 in out nocopy VARCHAR2
303 , p5_a36 in out nocopy NUMBER
304 , p5_a37 in out nocopy VARCHAR2
305 , p5_a38 in out nocopy DATE
306 , p5_a39 in out nocopy NUMBER
307 , x_return_status out nocopy VARCHAR2
308 , x_msg_count out nocopy NUMBER
309 , x_msg_data out nocopy VARCHAR2
310 , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
311 , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
312 , p10_a0 in out nocopy NUMBER
313 , p10_a1 in out nocopy NUMBER
314 , p10_a2 in out nocopy NUMBER
315 , p11_a0 in out nocopy JTF_NUMBER_TABLE
316 , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317 , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
318 , p12_a0 in out nocopy JTF_NUMBER_TABLE
319 , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
320 , p_called_from_grp VARCHAR2
321 );
322 procedure update_instance_asset(p_api_version NUMBER
323 , p_commit VARCHAR2
324 , p_init_msg_list VARCHAR2
325 , p_validation_level NUMBER
326 , p4_a0 in out nocopy NUMBER
327 , p4_a1 in out nocopy NUMBER
328 , p4_a2 in out nocopy NUMBER
329 , p4_a3 in out nocopy VARCHAR2
330 , p4_a4 in out nocopy NUMBER
331 , p4_a5 in out nocopy NUMBER
332 , p4_a6 in out nocopy VARCHAR2
333 , p4_a7 in out nocopy DATE
334 , p4_a8 in out nocopy DATE
335 , p4_a9 in out nocopy NUMBER
336 , p4_a10 in out nocopy VARCHAR2
337 , p4_a11 in out nocopy NUMBER
338 , p4_a12 in out nocopy VARCHAR2
339 , p4_a13 in out nocopy NUMBER
340 , p4_a14 in out nocopy VARCHAR2
341 , p4_a15 in out nocopy VARCHAR2
342 , p5_a0 in out nocopy NUMBER
343 , p5_a1 in out nocopy DATE
344 , p5_a2 in out nocopy DATE
345 , p5_a3 in out nocopy NUMBER
346 , p5_a4 in out nocopy NUMBER
347 , p5_a5 in out nocopy NUMBER
348 , p5_a6 in out nocopy VARCHAR2
349 , p5_a7 in out nocopy NUMBER
350 , p5_a8 in out nocopy VARCHAR2
351 , p5_a9 in out nocopy NUMBER
352 , p5_a10 in out nocopy VARCHAR2
353 , p5_a11 in out nocopy NUMBER
354 , p5_a12 in out nocopy NUMBER
355 , p5_a13 in out nocopy NUMBER
356 , p5_a14 in out nocopy NUMBER
357 , p5_a15 in out nocopy VARCHAR2
358 , p5_a16 in out nocopy NUMBER
359 , p5_a17 in out nocopy VARCHAR2
360 , p5_a18 in out nocopy VARCHAR2
361 , p5_a19 in out nocopy NUMBER
362 , p5_a20 in out nocopy VARCHAR2
363 , p5_a21 in out nocopy VARCHAR2
364 , p5_a22 in out nocopy VARCHAR2
365 , p5_a23 in out nocopy VARCHAR2
366 , p5_a24 in out nocopy VARCHAR2
367 , p5_a25 in out nocopy VARCHAR2
368 , p5_a26 in out nocopy VARCHAR2
369 , p5_a27 in out nocopy VARCHAR2
370 , p5_a28 in out nocopy VARCHAR2
371 , p5_a29 in out nocopy VARCHAR2
372 , p5_a30 in out nocopy VARCHAR2
373 , p5_a31 in out nocopy VARCHAR2
374 , p5_a32 in out nocopy VARCHAR2
375 , p5_a33 in out nocopy VARCHAR2
376 , p5_a34 in out nocopy VARCHAR2
377 , p5_a35 in out nocopy VARCHAR2
378 , p5_a36 in out nocopy NUMBER
379 , p5_a37 in out nocopy VARCHAR2
380 , p5_a38 in out nocopy DATE
381 , p5_a39 in out nocopy NUMBER
385 , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
382 , x_return_status out nocopy VARCHAR2
383 , x_msg_count out nocopy NUMBER
384 , x_msg_data out nocopy VARCHAR2
386 , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
387 , p10_a0 in out nocopy NUMBER
388 , p10_a1 in out nocopy NUMBER
389 , p10_a2 in out nocopy NUMBER
390 , p11_a0 in out nocopy JTF_NUMBER_TABLE
391 , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
392 , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
393 , p12_a0 in out nocopy JTF_NUMBER_TABLE
394 , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
395 );
396 procedure get_instance_asset_hist(p_api_version NUMBER
397 , p_commit VARCHAR2
398 , p_init_msg_list VARCHAR2
399 , p_validation_level NUMBER
400 , p_transaction_id NUMBER
401 , p5_a0 out nocopy JTF_NUMBER_TABLE
402 , p5_a1 out nocopy JTF_NUMBER_TABLE
403 , p5_a2 out nocopy JTF_NUMBER_TABLE
404 , p5_a3 out nocopy JTF_NUMBER_TABLE
405 , p5_a4 out nocopy JTF_NUMBER_TABLE
406 , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407 , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408 , p5_a7 out nocopy JTF_NUMBER_TABLE
409 , p5_a8 out nocopy JTF_NUMBER_TABLE
410 , p5_a9 out nocopy JTF_NUMBER_TABLE
411 , p5_a10 out nocopy JTF_NUMBER_TABLE
412 , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
413 , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
414 , p5_a13 out nocopy JTF_DATE_TABLE
415 , p5_a14 out nocopy JTF_DATE_TABLE
416 , p5_a15 out nocopy JTF_DATE_TABLE
417 , p5_a16 out nocopy JTF_DATE_TABLE
418 , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
419 , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
420 , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
421 , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422 , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423 , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424 , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425 , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426 , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427 , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428 , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429 , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430 , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431 , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432 , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433 , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434 , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435 , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436 , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
437 , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
438 , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
439 , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
440 , p5_a39 out nocopy JTF_DATE_TABLE
441 , p5_a40 out nocopy JTF_DATE_TABLE
442 , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
443 , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
444 , p5_a43 out nocopy JTF_VARCHAR2_TABLE_300
445 , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
446 , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
447 , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
448 , p5_a47 out nocopy JTF_NUMBER_TABLE
449 , p5_a48 out nocopy JTF_NUMBER_TABLE
450 , p5_a49 out nocopy JTF_NUMBER_TABLE
451 , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452 , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453 , p5_a52 out nocopy JTF_NUMBER_TABLE
454 , p5_a53 out nocopy JTF_NUMBER_TABLE
455 , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
456 , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100
457 , x_return_status out nocopy VARCHAR2
458 , x_msg_count out nocopy NUMBER
459 , x_msg_data out nocopy VARCHAR2
460 );
461 procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
462 , p0_a1 in out nocopy JTF_NUMBER_TABLE
463 , p0_a2 in out nocopy JTF_NUMBER_TABLE
464 , p0_a3 in out nocopy JTF_NUMBER_TABLE
465 , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466 , p0_a5 in out nocopy JTF_NUMBER_TABLE
467 , p0_a6 in out nocopy JTF_NUMBER_TABLE
468 , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469 , p1_a0 in out nocopy JTF_NUMBER_TABLE
470 , p1_a1 in out nocopy JTF_NUMBER_TABLE
471 , p1_a2 in out nocopy JTF_NUMBER_TABLE
472 , p1_a3 in out nocopy JTF_NUMBER_TABLE
473 , p1_a4 in out nocopy JTF_NUMBER_TABLE
474 , p2_a0 in out nocopy JTF_NUMBER_TABLE
475 , p2_a1 in out nocopy JTF_NUMBER_TABLE
476 , p2_a2 in out nocopy JTF_NUMBER_TABLE
477 , p2_a3 in out nocopy JTF_NUMBER_TABLE
478 , x_error_msg out nocopy VARCHAR2
479 , x_return_status out nocopy VARCHAR2
480 );
481 procedure get_attached_item_instances(p_api_version NUMBER
482 , p_init_msg_list VARCHAR2
483 , p2_a0 JTF_NUMBER_TABLE
484 , p2_a1 JTF_NUMBER_TABLE
485 , p2_a2 JTF_NUMBER_TABLE
486 , p2_a3 JTF_NUMBER_TABLE
487 , p2_a4 JTF_NUMBER_TABLE
488 , p3_a0 out nocopy JTF_NUMBER_TABLE
489 , p3_a1 out nocopy JTF_NUMBER_TABLE
490 , p3_a2 out nocopy JTF_NUMBER_TABLE
491 , p3_a3 out nocopy JTF_NUMBER_TABLE
492 , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
493 , p3_a5 out nocopy JTF_NUMBER_TABLE
494 , p3_a6 out nocopy JTF_NUMBER_TABLE
495 , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
496 , x_return_status out nocopy VARCHAR2
497 , x_msg_count out nocopy NUMBER
498 , x_msg_data out nocopy VARCHAR2
499 , p_source_system_name VARCHAR2
500 , p_called_from_grp VARCHAR2
501 );
502 procedure get_attached_asset_links(p_api_version NUMBER
503 , p_init_msg_list VARCHAR2
504 , p2_a0 JTF_NUMBER_TABLE
505 , p2_a1 JTF_NUMBER_TABLE
506 , p2_a2 JTF_NUMBER_TABLE
507 , p2_a3 JTF_NUMBER_TABLE
508 , p2_a4 JTF_VARCHAR2_TABLE_100
509 , p2_a5 JTF_NUMBER_TABLE
510 , p2_a6 JTF_NUMBER_TABLE
511 , p2_a7 JTF_VARCHAR2_TABLE_100
515 , p3_a3 out nocopy JTF_NUMBER_TABLE
512 , p3_a0 out nocopy JTF_NUMBER_TABLE
513 , p3_a1 out nocopy JTF_NUMBER_TABLE
514 , p3_a2 out nocopy JTF_NUMBER_TABLE
516 , p3_a4 out nocopy JTF_NUMBER_TABLE
517 , x_return_status out nocopy VARCHAR2
518 , x_msg_count out nocopy NUMBER
519 , x_msg_data out nocopy VARCHAR2
520 , p_source_system_name VARCHAR2
521 , p_called_from_grp VARCHAR2
522 );
523 procedure get_fa_asset_details(p_api_version NUMBER
524 , p_init_msg_list VARCHAR2
525 , p2_a0 JTF_NUMBER_TABLE
526 , p2_a1 JTF_NUMBER_TABLE
527 , p2_a2 JTF_NUMBER_TABLE
528 , p2_a3 JTF_NUMBER_TABLE
529 , p2_a4 JTF_NUMBER_TABLE
530 , p3_a0 out nocopy JTF_NUMBER_TABLE
531 , p3_a1 out nocopy JTF_NUMBER_TABLE
532 , p3_a2 out nocopy JTF_NUMBER_TABLE
533 , p3_a3 out nocopy JTF_NUMBER_TABLE
534 , x_return_status out nocopy VARCHAR2
535 , x_msg_count out nocopy NUMBER
536 , x_msg_data out nocopy VARCHAR2
537 , p_source_system_name VARCHAR2
538 , p_called_from_grp VARCHAR2
539 );
540 procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
541 , p0_a1 in out nocopy JTF_NUMBER_TABLE
542 , p0_a2 in out nocopy JTF_NUMBER_TABLE
543 , p0_a3 in out nocopy JTF_NUMBER_TABLE
544 , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545 , p0_a5 in out nocopy JTF_NUMBER_TABLE
546 , p0_a6 in out nocopy JTF_NUMBER_TABLE
547 , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548 , p1_a0 in out nocopy JTF_NUMBER_TABLE
549 , p1_a1 in out nocopy JTF_NUMBER_TABLE
550 , p1_a2 in out nocopy JTF_NUMBER_TABLE
551 , p1_a3 in out nocopy JTF_NUMBER_TABLE
552 , p1_a4 in out nocopy JTF_NUMBER_TABLE
553 , p2_a0 in out nocopy JTF_NUMBER_TABLE
554 , p2_a1 in out nocopy JTF_NUMBER_TABLE
555 , p2_a2 in out nocopy JTF_NUMBER_TABLE
556 , p2_a3 in out nocopy JTF_NUMBER_TABLE
557 , x_return_status out nocopy VARCHAR2
558 , x_error_msg out nocopy VARCHAR2
559 , p_source_system_name VARCHAR2
560 , p_called_from_grp VARCHAR2
561 );
562 procedure create_instance_assets(p_api_version NUMBER
563 , p_commit VARCHAR2
564 , p_init_msg_list VARCHAR2
565 , p_validation_level NUMBER
566 , p4_a0 in out nocopy JTF_NUMBER_TABLE
567 , p4_a1 in out nocopy JTF_NUMBER_TABLE
568 , p4_a2 in out nocopy JTF_NUMBER_TABLE
569 , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
570 , p4_a4 in out nocopy JTF_NUMBER_TABLE
571 , p4_a5 in out nocopy JTF_NUMBER_TABLE
572 , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
573 , p4_a7 in out nocopy JTF_DATE_TABLE
574 , p4_a8 in out nocopy JTF_DATE_TABLE
575 , p4_a9 in out nocopy JTF_NUMBER_TABLE
576 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
577 , p4_a11 in out nocopy JTF_NUMBER_TABLE
578 , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
579 , p4_a13 in out nocopy JTF_NUMBER_TABLE
580 , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
581 , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100
582 , p5_a0 in out nocopy NUMBER
583 , p5_a1 in out nocopy DATE
584 , p5_a2 in out nocopy DATE
585 , p5_a3 in out nocopy NUMBER
586 , p5_a4 in out nocopy NUMBER
587 , p5_a5 in out nocopy NUMBER
588 , p5_a6 in out nocopy VARCHAR2
589 , p5_a7 in out nocopy NUMBER
590 , p5_a8 in out nocopy VARCHAR2
591 , p5_a9 in out nocopy NUMBER
592 , p5_a10 in out nocopy VARCHAR2
593 , p5_a11 in out nocopy NUMBER
594 , p5_a12 in out nocopy NUMBER
595 , p5_a13 in out nocopy NUMBER
596 , p5_a14 in out nocopy NUMBER
597 , p5_a15 in out nocopy VARCHAR2
598 , p5_a16 in out nocopy NUMBER
599 , p5_a17 in out nocopy VARCHAR2
600 , p5_a18 in out nocopy VARCHAR2
601 , p5_a19 in out nocopy NUMBER
602 , p5_a20 in out nocopy VARCHAR2
603 , p5_a21 in out nocopy VARCHAR2
604 , p5_a22 in out nocopy VARCHAR2
605 , p5_a23 in out nocopy VARCHAR2
606 , p5_a24 in out nocopy VARCHAR2
607 , p5_a25 in out nocopy VARCHAR2
608 , p5_a26 in out nocopy VARCHAR2
609 , p5_a27 in out nocopy VARCHAR2
610 , p5_a28 in out nocopy VARCHAR2
611 , p5_a29 in out nocopy VARCHAR2
612 , p5_a30 in out nocopy VARCHAR2
613 , p5_a31 in out nocopy VARCHAR2
614 , p5_a32 in out nocopy VARCHAR2
615 , p5_a33 in out nocopy VARCHAR2
616 , p5_a34 in out nocopy VARCHAR2
617 , p5_a35 in out nocopy VARCHAR2
618 , p5_a36 in out nocopy NUMBER
619 , p5_a37 in out nocopy VARCHAR2
620 , p5_a38 in out nocopy DATE
621 , p5_a39 in out nocopy NUMBER
622 , p6_a0 in out nocopy JTF_VARCHAR2_TABLE_100
623 , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
624 , p7_a0 in out nocopy NUMBER
625 , p7_a1 in out nocopy NUMBER
626 , p7_a2 in out nocopy NUMBER
627 , p8_a0 in out nocopy JTF_NUMBER_TABLE
628 , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100
629 , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
630 , p9_a0 in out nocopy JTF_NUMBER_TABLE
631 , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
632 , x_return_status out nocopy VARCHAR2
633 , x_msg_count out nocopy NUMBER
634 , x_msg_data out nocopy VARCHAR2
635 );
636 procedure set_fa_sync_flag(p0_a0 in out nocopy NUMBER
637 , p0_a1 in out nocopy NUMBER
638 , p0_a2 in out nocopy NUMBER
639 , p0_a3 in out nocopy VARCHAR2
640 , p0_a4 in out nocopy NUMBER
641 , p0_a5 in out nocopy NUMBER
642 , p0_a6 in out nocopy VARCHAR2
643 , p0_a7 in out nocopy DATE
644 , p0_a8 in out nocopy DATE
645 , p0_a9 in out nocopy NUMBER
646 , p0_a10 in out nocopy VARCHAR2
647 , p0_a11 in out nocopy NUMBER
648 , p0_a12 in out nocopy VARCHAR2
649 , p0_a13 in out nocopy NUMBER
650 , p0_a14 in out nocopy VARCHAR2
651 , p0_a15 in out nocopy VARCHAR2
652 , p_location_id NUMBER
653 , x_return_status out nocopy VARCHAR2
654 , x_error_msg out nocopy VARCHAR2
655 );
656 end csi_asset_pvt_w;
[Home] [Help]