[Home] [Help]
PACKAGE: APPS.AHL_UMP_UNITMAINT_PVT_W
Source
1 package ahl_ump_unitmaint_pvt_w as
2 /* $Header: AHLVUMWS.pls 120.1 2005/08/17 09:01:58 pbarman noship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_DATE_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_VARCHAR2_TABLE_4000
27 , a24 JTF_DATE_TABLE
28 , a25 JTF_DATE_TABLE
29 , a26 JTF_DATE_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_VARCHAR2_TABLE_200
35 , a32 JTF_VARCHAR2_TABLE_200
36 , a33 JTF_VARCHAR2_TABLE_200
37 , a34 JTF_VARCHAR2_TABLE_200
38 , a35 JTF_VARCHAR2_TABLE_200
39 , a36 JTF_VARCHAR2_TABLE_200
40 , a37 JTF_VARCHAR2_TABLE_200
41 , a38 JTF_VARCHAR2_TABLE_200
42 , a39 JTF_VARCHAR2_TABLE_200
43 , a40 JTF_VARCHAR2_TABLE_200
44 , a41 JTF_VARCHAR2_TABLE_200
45 , a42 JTF_VARCHAR2_TABLE_200
46 , a43 JTF_VARCHAR2_TABLE_200
47 , a44 JTF_VARCHAR2_TABLE_200
48 , a45 JTF_VARCHAR2_TABLE_200
49 );
50 procedure rosetta_table_copy_out_p3(t ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51 , a1 out nocopy JTF_NUMBER_TABLE
52 , a2 out nocopy JTF_DATE_TABLE
53 , a3 out nocopy JTF_NUMBER_TABLE
54 , a4 out nocopy JTF_DATE_TABLE
55 , a5 out nocopy JTF_NUMBER_TABLE
56 , a6 out nocopy JTF_NUMBER_TABLE
57 , a7 out nocopy JTF_NUMBER_TABLE
58 , a8 out nocopy JTF_VARCHAR2_TABLE_100
59 , a9 out nocopy JTF_NUMBER_TABLE
60 , a10 out nocopy JTF_NUMBER_TABLE
61 , a11 out nocopy JTF_NUMBER_TABLE
62 , a12 out nocopy JTF_VARCHAR2_TABLE_100
63 , a13 out nocopy JTF_NUMBER_TABLE
64 , a14 out nocopy JTF_VARCHAR2_TABLE_100
65 , a15 out nocopy JTF_VARCHAR2_TABLE_100
66 , a16 out nocopy JTF_DATE_TABLE
67 , a17 out nocopy JTF_NUMBER_TABLE
68 , a18 out nocopy JTF_NUMBER_TABLE
69 , a19 out nocopy JTF_VARCHAR2_TABLE_100
70 , a20 out nocopy JTF_VARCHAR2_TABLE_100
71 , a21 out nocopy JTF_VARCHAR2_TABLE_100
72 , a22 out nocopy JTF_NUMBER_TABLE
73 , a23 out nocopy JTF_VARCHAR2_TABLE_4000
74 , a24 out nocopy JTF_DATE_TABLE
75 , a25 out nocopy JTF_DATE_TABLE
76 , a26 out nocopy JTF_DATE_TABLE
77 , a27 out nocopy JTF_NUMBER_TABLE
78 , a28 out nocopy JTF_NUMBER_TABLE
79 , a29 out nocopy JTF_NUMBER_TABLE
80 , a30 out nocopy JTF_VARCHAR2_TABLE_100
81 , a31 out nocopy JTF_VARCHAR2_TABLE_200
82 , a32 out nocopy JTF_VARCHAR2_TABLE_200
83 , a33 out nocopy JTF_VARCHAR2_TABLE_200
84 , a34 out nocopy JTF_VARCHAR2_TABLE_200
85 , a35 out nocopy JTF_VARCHAR2_TABLE_200
86 , a36 out nocopy JTF_VARCHAR2_TABLE_200
87 , a37 out nocopy JTF_VARCHAR2_TABLE_200
88 , a38 out nocopy JTF_VARCHAR2_TABLE_200
89 , a39 out nocopy JTF_VARCHAR2_TABLE_200
90 , a40 out nocopy JTF_VARCHAR2_TABLE_200
91 , a41 out nocopy JTF_VARCHAR2_TABLE_200
92 , a42 out nocopy JTF_VARCHAR2_TABLE_200
93 , a43 out nocopy JTF_VARCHAR2_TABLE_200
94 , a44 out nocopy JTF_VARCHAR2_TABLE_200
95 , a45 out nocopy JTF_VARCHAR2_TABLE_200
96 );
97
98 procedure rosetta_table_copy_in_p4(t out nocopy ahl_ump_unitmaint_pvt.unit_threshold_tbl_type, a0 JTF_NUMBER_TABLE
99 , a1 JTF_NUMBER_TABLE
100 , a2 JTF_DATE_TABLE
101 , a3 JTF_NUMBER_TABLE
102 , a4 JTF_DATE_TABLE
103 , a5 JTF_NUMBER_TABLE
104 , a6 JTF_NUMBER_TABLE
105 , a7 JTF_NUMBER_TABLE
106 , a8 JTF_NUMBER_TABLE
107 , a9 JTF_VARCHAR2_TABLE_100
108 , a10 JTF_NUMBER_TABLE
109 , a11 JTF_VARCHAR2_TABLE_100
110 , a12 JTF_VARCHAR2_TABLE_100
111 , a13 JTF_VARCHAR2_TABLE_200
112 , a14 JTF_VARCHAR2_TABLE_200
113 , a15 JTF_VARCHAR2_TABLE_200
114 , a16 JTF_VARCHAR2_TABLE_200
115 , a17 JTF_VARCHAR2_TABLE_200
116 , a18 JTF_VARCHAR2_TABLE_200
117 , a19 JTF_VARCHAR2_TABLE_200
118 , a20 JTF_VARCHAR2_TABLE_200
119 , a21 JTF_VARCHAR2_TABLE_200
120 , a22 JTF_VARCHAR2_TABLE_200
121 , a23 JTF_VARCHAR2_TABLE_200
122 , a24 JTF_VARCHAR2_TABLE_200
123 , a25 JTF_VARCHAR2_TABLE_200
124 , a26 JTF_VARCHAR2_TABLE_200
125 , a27 JTF_VARCHAR2_TABLE_200
126 , a28 JTF_NUMBER_TABLE
127 );
128 procedure rosetta_table_copy_out_p4(t ahl_ump_unitmaint_pvt.unit_threshold_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129 , a1 out nocopy JTF_NUMBER_TABLE
130 , a2 out nocopy JTF_DATE_TABLE
131 , a3 out nocopy JTF_NUMBER_TABLE
132 , a4 out nocopy JTF_DATE_TABLE
133 , a5 out nocopy JTF_NUMBER_TABLE
134 , a6 out nocopy JTF_NUMBER_TABLE
135 , a7 out nocopy JTF_NUMBER_TABLE
136 , a8 out nocopy JTF_NUMBER_TABLE
137 , a9 out nocopy JTF_VARCHAR2_TABLE_100
138 , a10 out nocopy JTF_NUMBER_TABLE
139 , a11 out nocopy JTF_VARCHAR2_TABLE_100
140 , a12 out nocopy JTF_VARCHAR2_TABLE_100
141 , a13 out nocopy JTF_VARCHAR2_TABLE_200
142 , a14 out nocopy JTF_VARCHAR2_TABLE_200
143 , a15 out nocopy JTF_VARCHAR2_TABLE_200
144 , a16 out nocopy JTF_VARCHAR2_TABLE_200
145 , a17 out nocopy JTF_VARCHAR2_TABLE_200
146 , a18 out nocopy JTF_VARCHAR2_TABLE_200
147 , a19 out nocopy JTF_VARCHAR2_TABLE_200
148 , a20 out nocopy JTF_VARCHAR2_TABLE_200
149 , a21 out nocopy JTF_VARCHAR2_TABLE_200
150 , a22 out nocopy JTF_VARCHAR2_TABLE_200
151 , a23 out nocopy JTF_VARCHAR2_TABLE_200
152 , a24 out nocopy JTF_VARCHAR2_TABLE_200
153 , a25 out nocopy JTF_VARCHAR2_TABLE_200
154 , a26 out nocopy JTF_VARCHAR2_TABLE_200
155 , a27 out nocopy JTF_VARCHAR2_TABLE_200
156 , a28 out nocopy JTF_NUMBER_TABLE
157 );
158
159 procedure rosetta_table_copy_in_p5(t out nocopy ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type, a0 JTF_NUMBER_TABLE
160 , a1 JTF_NUMBER_TABLE
161 , a2 JTF_DATE_TABLE
162 , a3 JTF_NUMBER_TABLE
163 , a4 JTF_DATE_TABLE
164 , a5 JTF_NUMBER_TABLE
165 , a6 JTF_NUMBER_TABLE
166 , a7 JTF_NUMBER_TABLE
167 , a8 JTF_NUMBER_TABLE
168 , a9 JTF_VARCHAR2_TABLE_100
169 , a10 JTF_NUMBER_TABLE
170 , a11 JTF_VARCHAR2_TABLE_100
171 , a12 JTF_VARCHAR2_TABLE_100
172 , a13 JTF_VARCHAR2_TABLE_200
173 , a14 JTF_VARCHAR2_TABLE_200
174 , a15 JTF_VARCHAR2_TABLE_200
175 , a16 JTF_VARCHAR2_TABLE_200
176 , a17 JTF_VARCHAR2_TABLE_200
177 , a18 JTF_VARCHAR2_TABLE_200
178 , a19 JTF_VARCHAR2_TABLE_200
179 , a20 JTF_VARCHAR2_TABLE_200
180 , a21 JTF_VARCHAR2_TABLE_200
181 , a22 JTF_VARCHAR2_TABLE_200
182 , a23 JTF_VARCHAR2_TABLE_200
183 , a24 JTF_VARCHAR2_TABLE_200
184 , a25 JTF_VARCHAR2_TABLE_200
185 , a26 JTF_VARCHAR2_TABLE_200
186 , a27 JTF_VARCHAR2_TABLE_200
187 );
188 procedure rosetta_table_copy_out_p5(t ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189 , a1 out nocopy JTF_NUMBER_TABLE
190 , a2 out nocopy JTF_DATE_TABLE
191 , a3 out nocopy JTF_NUMBER_TABLE
192 , a4 out nocopy JTF_DATE_TABLE
193 , a5 out nocopy JTF_NUMBER_TABLE
194 , a6 out nocopy JTF_NUMBER_TABLE
195 , a7 out nocopy JTF_NUMBER_TABLE
196 , a8 out nocopy JTF_NUMBER_TABLE
197 , a9 out nocopy JTF_VARCHAR2_TABLE_100
198 , a10 out nocopy JTF_NUMBER_TABLE
199 , a11 out nocopy JTF_VARCHAR2_TABLE_100
200 , a12 out nocopy JTF_VARCHAR2_TABLE_100
201 , a13 out nocopy JTF_VARCHAR2_TABLE_200
202 , a14 out nocopy JTF_VARCHAR2_TABLE_200
203 , a15 out nocopy JTF_VARCHAR2_TABLE_200
204 , a16 out nocopy JTF_VARCHAR2_TABLE_200
205 , a17 out nocopy JTF_VARCHAR2_TABLE_200
206 , a18 out nocopy JTF_VARCHAR2_TABLE_200
207 , a19 out nocopy JTF_VARCHAR2_TABLE_200
208 , a20 out nocopy JTF_VARCHAR2_TABLE_200
209 , a21 out nocopy JTF_VARCHAR2_TABLE_200
210 , a22 out nocopy JTF_VARCHAR2_TABLE_200
211 , a23 out nocopy JTF_VARCHAR2_TABLE_200
212 , a24 out nocopy JTF_VARCHAR2_TABLE_200
213 , a25 out nocopy JTF_VARCHAR2_TABLE_200
214 , a26 out nocopy JTF_VARCHAR2_TABLE_200
215 , a27 out nocopy JTF_VARCHAR2_TABLE_200
216 );
217
218 procedure capture_mr_updates(p_api_version NUMBER
219 , p_init_msg_list VARCHAR2
220 , p_commit VARCHAR2
221 , p_validation_level NUMBER
222 , p_default VARCHAR2
223 , p_module_type VARCHAR2
224 , p6_a0 JTF_NUMBER_TABLE
225 , p6_a1 JTF_NUMBER_TABLE
226 , p6_a2 JTF_DATE_TABLE
227 , p6_a3 JTF_NUMBER_TABLE
228 , p6_a4 JTF_DATE_TABLE
229 , p6_a5 JTF_NUMBER_TABLE
230 , p6_a6 JTF_NUMBER_TABLE
231 , p6_a7 JTF_NUMBER_TABLE
232 , p6_a8 JTF_VARCHAR2_TABLE_100
233 , p6_a9 JTF_NUMBER_TABLE
234 , p6_a10 JTF_NUMBER_TABLE
235 , p6_a11 JTF_NUMBER_TABLE
236 , p6_a12 JTF_VARCHAR2_TABLE_100
237 , p6_a13 JTF_NUMBER_TABLE
238 , p6_a14 JTF_VARCHAR2_TABLE_100
239 , p6_a15 JTF_VARCHAR2_TABLE_100
240 , p6_a16 JTF_DATE_TABLE
241 , p6_a17 JTF_NUMBER_TABLE
242 , p6_a18 JTF_NUMBER_TABLE
243 , p6_a19 JTF_VARCHAR2_TABLE_100
244 , p6_a20 JTF_VARCHAR2_TABLE_100
245 , p6_a21 JTF_VARCHAR2_TABLE_100
246 , p6_a22 JTF_NUMBER_TABLE
247 , p6_a23 JTF_VARCHAR2_TABLE_4000
248 , p6_a24 JTF_DATE_TABLE
249 , p6_a25 JTF_DATE_TABLE
250 , p6_a26 JTF_DATE_TABLE
251 , p6_a27 JTF_NUMBER_TABLE
252 , p6_a28 JTF_NUMBER_TABLE
253 , p6_a29 JTF_NUMBER_TABLE
254 , p6_a30 JTF_VARCHAR2_TABLE_100
255 , p6_a31 JTF_VARCHAR2_TABLE_200
256 , p6_a32 JTF_VARCHAR2_TABLE_200
257 , p6_a33 JTF_VARCHAR2_TABLE_200
258 , p6_a34 JTF_VARCHAR2_TABLE_200
259 , p6_a35 JTF_VARCHAR2_TABLE_200
260 , p6_a36 JTF_VARCHAR2_TABLE_200
261 , p6_a37 JTF_VARCHAR2_TABLE_200
262 , p6_a38 JTF_VARCHAR2_TABLE_200
263 , p6_a39 JTF_VARCHAR2_TABLE_200
264 , p6_a40 JTF_VARCHAR2_TABLE_200
265 , p6_a41 JTF_VARCHAR2_TABLE_200
266 , p6_a42 JTF_VARCHAR2_TABLE_200
267 , p6_a43 JTF_VARCHAR2_TABLE_200
268 , p6_a44 JTF_VARCHAR2_TABLE_200
269 , p6_a45 JTF_VARCHAR2_TABLE_200
270 , p7_a0 in out nocopy JTF_NUMBER_TABLE
271 , p7_a1 in out nocopy JTF_NUMBER_TABLE
272 , p7_a2 in out nocopy JTF_DATE_TABLE
273 , p7_a3 in out nocopy JTF_NUMBER_TABLE
274 , p7_a4 in out nocopy JTF_DATE_TABLE
275 , p7_a5 in out nocopy JTF_NUMBER_TABLE
276 , p7_a6 in out nocopy JTF_NUMBER_TABLE
277 , p7_a7 in out nocopy JTF_NUMBER_TABLE
278 , p7_a8 in out nocopy JTF_NUMBER_TABLE
279 , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100
280 , p7_a10 in out nocopy JTF_NUMBER_TABLE
281 , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_100
282 , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
283 , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_200
284 , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_200
285 , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_200
286 , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_200
287 , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
288 , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
289 , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
290 , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
291 , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_200
292 , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
293 , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_200
294 , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_200
295 , p7_a25 in out nocopy JTF_VARCHAR2_TABLE_200
296 , p7_a26 in out nocopy JTF_VARCHAR2_TABLE_200
297 , p7_a27 in out nocopy JTF_VARCHAR2_TABLE_200
298 , p7_a28 in out nocopy JTF_NUMBER_TABLE
299 , p8_a0 in out nocopy JTF_NUMBER_TABLE
300 , p8_a1 in out nocopy JTF_NUMBER_TABLE
301 , p8_a2 in out nocopy JTF_DATE_TABLE
302 , p8_a3 in out nocopy JTF_NUMBER_TABLE
303 , p8_a4 in out nocopy JTF_DATE_TABLE
304 , p8_a5 in out nocopy JTF_NUMBER_TABLE
305 , p8_a6 in out nocopy JTF_NUMBER_TABLE
306 , p8_a7 in out nocopy JTF_NUMBER_TABLE
307 , p8_a8 in out nocopy JTF_NUMBER_TABLE
308 , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_100
309 , p8_a10 in out nocopy JTF_NUMBER_TABLE
310 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
311 , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_100
312 , p8_a13 in out nocopy JTF_VARCHAR2_TABLE_200
313 , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_200
314 , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
315 , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
316 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
317 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
318 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
319 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
320 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
321 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
322 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
323 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
324 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
325 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
326 , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
327 , x_return_status out nocopy VARCHAR2
328 , x_msg_count out nocopy NUMBER
329 , x_msg_data out nocopy VARCHAR2
330 );
331 end ahl_ump_unitmaint_pvt_w;