[Home] [Help]
PACKAGE: APPS.AHL_COMPLETIONS_PVT_W
Source
1 package ahl_completions_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWPRCS.pls 120.5.12020000.2 2012/12/14 03:39:15 shnatu ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_DATE_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
26 , a23 JTF_NUMBER_TABLE
27 );
28 procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29 , a1 out nocopy JTF_NUMBER_TABLE
30 , a2 out nocopy JTF_VARCHAR2_TABLE_100
31 , a3 out nocopy JTF_VARCHAR2_TABLE_100
32 , a4 out nocopy JTF_NUMBER_TABLE
33 , a5 out nocopy JTF_NUMBER_TABLE
34 , a6 out nocopy JTF_NUMBER_TABLE
35 , a7 out nocopy JTF_NUMBER_TABLE
36 , a8 out nocopy JTF_DATE_TABLE
37 , a9 out nocopy JTF_DATE_TABLE
38 , a10 out nocopy JTF_DATE_TABLE
39 , a11 out nocopy JTF_DATE_TABLE
40 , a12 out nocopy JTF_VARCHAR2_TABLE_100
41 , a13 out nocopy JTF_VARCHAR2_TABLE_100
42 , a14 out nocopy JTF_NUMBER_TABLE
43 , a15 out nocopy JTF_NUMBER_TABLE
44 , a16 out nocopy JTF_NUMBER_TABLE
45 , a17 out nocopy JTF_VARCHAR2_TABLE_100
46 , a18 out nocopy JTF_NUMBER_TABLE
47 , a19 out nocopy JTF_VARCHAR2_TABLE_100
48 , a20 out nocopy JTF_VARCHAR2_TABLE_100
49 , a21 out nocopy JTF_VARCHAR2_TABLE_100
50 , a22 out nocopy JTF_VARCHAR2_TABLE_100
51 , a23 out nocopy JTF_NUMBER_TABLE
52 );
53
54 procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
55 , a1 JTF_NUMBER_TABLE
56 , a2 JTF_NUMBER_TABLE
57 , a3 JTF_VARCHAR2_TABLE_100
58 , a4 JTF_NUMBER_TABLE
59 , a5 JTF_NUMBER_TABLE
60 , a6 JTF_NUMBER_TABLE
61 , a7 JTF_VARCHAR2_TABLE_2000
62 , a8 JTF_NUMBER_TABLE
63 , a9 JTF_NUMBER_TABLE
64 , a10 JTF_DATE_TABLE
65 , a11 JTF_DATE_TABLE
66 , a12 JTF_DATE_TABLE
67 , a13 JTF_DATE_TABLE
68 , a14 JTF_VARCHAR2_TABLE_100
69 , a15 JTF_VARCHAR2_TABLE_100
70 );
71 procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72 , a1 out nocopy JTF_NUMBER_TABLE
73 , a2 out nocopy JTF_NUMBER_TABLE
74 , a3 out nocopy JTF_VARCHAR2_TABLE_100
75 , a4 out nocopy JTF_NUMBER_TABLE
76 , a5 out nocopy JTF_NUMBER_TABLE
77 , a6 out nocopy JTF_NUMBER_TABLE
78 , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79 , a8 out nocopy JTF_NUMBER_TABLE
80 , a9 out nocopy JTF_NUMBER_TABLE
81 , a10 out nocopy JTF_DATE_TABLE
82 , a11 out nocopy JTF_DATE_TABLE
83 , a12 out nocopy JTF_DATE_TABLE
84 , a13 out nocopy JTF_DATE_TABLE
85 , a14 out nocopy JTF_VARCHAR2_TABLE_100
86 , a15 out nocopy JTF_VARCHAR2_TABLE_100
87 );
88
89 procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
90 , a1 JTF_NUMBER_TABLE
91 , a2 JTF_VARCHAR2_TABLE_100
92 , a3 JTF_VARCHAR2_TABLE_100
93 , a4 JTF_NUMBER_TABLE
94 , a5 JTF_NUMBER_TABLE
95 , a6 JTF_VARCHAR2_TABLE_100
96 , a7 JTF_VARCHAR2_TABLE_200
97 , a8 JTF_NUMBER_TABLE
98 , a9 JTF_NUMBER_TABLE
99 , a10 JTF_NUMBER_TABLE
100 , a11 JTF_DATE_TABLE
101 );
102 procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103 , a1 out nocopy JTF_NUMBER_TABLE
104 , a2 out nocopy JTF_VARCHAR2_TABLE_100
105 , a3 out nocopy JTF_VARCHAR2_TABLE_100
106 , a4 out nocopy JTF_NUMBER_TABLE
107 , a5 out nocopy JTF_NUMBER_TABLE
108 , a6 out nocopy JTF_VARCHAR2_TABLE_100
109 , a7 out nocopy JTF_VARCHAR2_TABLE_200
110 , a8 out nocopy JTF_NUMBER_TABLE
111 , a9 out nocopy JTF_NUMBER_TABLE
112 , a10 out nocopy JTF_NUMBER_TABLE
113 , a11 out nocopy JTF_DATE_TABLE
114 );
115
116 procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
117 , a1 JTF_NUMBER_TABLE
118 , a2 JTF_NUMBER_TABLE
119 , a3 JTF_NUMBER_TABLE
120 , a4 JTF_NUMBER_TABLE
121 , a5 JTF_NUMBER_TABLE
122 , a6 JTF_VARCHAR2_TABLE_100
123 , a7 JTF_NUMBER_TABLE
124 );
125 procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126 , a1 out nocopy JTF_NUMBER_TABLE
127 , a2 out nocopy JTF_NUMBER_TABLE
128 , a3 out nocopy JTF_NUMBER_TABLE
129 , a4 out nocopy JTF_NUMBER_TABLE
130 , a5 out nocopy JTF_NUMBER_TABLE
131 , a6 out nocopy JTF_VARCHAR2_TABLE_100
132 , a7 out nocopy JTF_NUMBER_TABLE
133 );
134
135 procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);
136 procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
137
138 procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139 , a1 JTF_VARCHAR2_TABLE_100
140 , a2 JTF_NUMBER_TABLE
141 , a3 JTF_NUMBER_TABLE
142 , a4 JTF_NUMBER_TABLE
143 , a5 JTF_NUMBER_TABLE
144 , a6 JTF_VARCHAR2_TABLE_100
145 , a7 JTF_NUMBER_TABLE
146 , a8 JTF_NUMBER_TABLE
147 , a9 JTF_NUMBER_TABLE
148 , a10 JTF_NUMBER_TABLE
149 , a11 JTF_VARCHAR2_TABLE_100
150 , a12 JTF_NUMBER_TABLE
151 , a13 JTF_NUMBER_TABLE
152 );
153 procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154 , a1 out nocopy JTF_VARCHAR2_TABLE_100
155 , a2 out nocopy JTF_NUMBER_TABLE
156 , a3 out nocopy JTF_NUMBER_TABLE
157 , a4 out nocopy JTF_NUMBER_TABLE
158 , a5 out nocopy JTF_NUMBER_TABLE
159 , a6 out nocopy JTF_VARCHAR2_TABLE_100
160 , a7 out nocopy JTF_NUMBER_TABLE
161 , a8 out nocopy JTF_NUMBER_TABLE
162 , a9 out nocopy JTF_NUMBER_TABLE
163 , a10 out nocopy JTF_NUMBER_TABLE
164 , a11 out nocopy JTF_VARCHAR2_TABLE_100
165 , a12 out nocopy JTF_NUMBER_TABLE
166 , a13 out nocopy JTF_NUMBER_TABLE
167 );
168
169 procedure complete_mr_instance(p_api_version NUMBER
170 , p_init_msg_list VARCHAR2
171 , p_commit VARCHAR2
172 , p_validation_level NUMBER
173 , p_default VARCHAR2
174 , p_module_type VARCHAR2
175 , x_return_status out nocopy VARCHAR2
176 , x_msg_count out nocopy NUMBER
177 , x_msg_data out nocopy VARCHAR2
178 , p9_a0 in out nocopy NUMBER
179 , p9_a1 in out nocopy NUMBER
180 , p9_a2 in out nocopy VARCHAR2
181 , p9_a3 in out nocopy VARCHAR2
182 , p9_a4 in out nocopy NUMBER
183 , p9_a5 in out nocopy NUMBER
184 , p9_a6 in out nocopy VARCHAR2
185 , p9_a7 in out nocopy VARCHAR2
186 , p9_a8 in out nocopy NUMBER
187 , p9_a9 in out nocopy NUMBER
188 , p9_a10 in out nocopy NUMBER
189 , p9_a11 in out nocopy DATE
190 );
191 procedure signoff_mr_instance(p_api_version NUMBER
192 , p_init_msg_list VARCHAR2
193 , p_commit VARCHAR2
194 , p_validation_level NUMBER
195 , p_default VARCHAR2
196 , p_module_type VARCHAR2
197 , x_return_status out nocopy VARCHAR2
198 , x_msg_count out nocopy NUMBER
199 , x_msg_data out nocopy VARCHAR2
200 , p9_a0 NUMBER
201 , p9_a1 NUMBER
202 , p9_a2 VARCHAR2
203 , p9_a3 VARCHAR2
204 , p9_a4 VARCHAR2
205 , p9_a5 DATE
206 , p9_a6 DATE
207 , p9_a7 VARCHAR2
208 , p9_a8 VARCHAR2
209 , p9_a9 VARCHAR2
210 , p9_a10 VARCHAR2
211 , p9_a11 VARCHAR2
212 );
213 procedure close_visit(p_api_version NUMBER
214 , p_init_msg_list VARCHAR2
215 , p_commit VARCHAR2
216 , p_validation_level NUMBER
217 , p_default VARCHAR2
218 , p_module_type VARCHAR2
219 , x_return_status out nocopy VARCHAR2
220 , x_msg_count out nocopy NUMBER
221 , x_msg_data out nocopy VARCHAR2
222 , p9_a0 NUMBER
223 , p9_a1 NUMBER
224 , p9_a2 VARCHAR2
225 , p9_a3 VARCHAR2
226 , p9_a4 VARCHAR2
227 , p9_a5 DATE
228 , p9_a6 DATE
229 , p9_a7 VARCHAR2
230 , p9_a8 VARCHAR2
231 , p9_a9 VARCHAR2
232 , p9_a10 VARCHAR2
233 , p9_a11 VARCHAR2
234 , p9_a12 VARCHAR2
235 );
236 procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
237 , x_msg_count out nocopy NUMBER
238 , x_msg_data out nocopy VARCHAR2
239 , p3_a0 in out nocopy JTF_NUMBER_TABLE
240 , p3_a1 in out nocopy JTF_NUMBER_TABLE
241 , p3_a2 in out nocopy JTF_NUMBER_TABLE
242 , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
243 , p3_a4 in out nocopy JTF_NUMBER_TABLE
244 , p3_a5 in out nocopy JTF_NUMBER_TABLE
245 , p3_a6 in out nocopy JTF_NUMBER_TABLE
246 , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
247 , p3_a8 in out nocopy JTF_NUMBER_TABLE
248 , p3_a9 in out nocopy JTF_NUMBER_TABLE
249 , p3_a10 in out nocopy JTF_DATE_TABLE
250 , p3_a11 in out nocopy JTF_DATE_TABLE
251 , p3_a12 in out nocopy JTF_DATE_TABLE
252 , p3_a13 in out nocopy JTF_DATE_TABLE
253 , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
254 , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
255 );
256 procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
257 , p1_a0 in out nocopy JTF_NUMBER_TABLE
258 , p1_a1 in out nocopy JTF_NUMBER_TABLE
259 , p1_a2 in out nocopy JTF_NUMBER_TABLE
260 , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
261 , p1_a4 in out nocopy JTF_NUMBER_TABLE
262 , p1_a5 in out nocopy JTF_NUMBER_TABLE
263 , p1_a6 in out nocopy JTF_NUMBER_TABLE
264 , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
265 , p1_a8 in out nocopy JTF_NUMBER_TABLE
266 , p1_a9 in out nocopy JTF_NUMBER_TABLE
267 , p1_a10 in out nocopy JTF_DATE_TABLE
268 , p1_a11 in out nocopy JTF_DATE_TABLE
269 , p1_a12 in out nocopy JTF_DATE_TABLE
270 , p1_a13 in out nocopy JTF_DATE_TABLE
271 , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
272 , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
273 );
274 function is_signoff_date_overlapping(p_actual_start_date date
275 , p_actual_end_date date
276 , p_unit_effectivity_id NUMBER
277 , p_visit_id NUMBER
278 ) return varchar2;
279 function get_reset_counters(p_mr_header_id NUMBER
280 , p_item_instance_id NUMBER
281 , p_actual_date date
282 , p3_a0 out nocopy JTF_NUMBER_TABLE
283 , p3_a1 out nocopy JTF_NUMBER_TABLE
284 , p3_a2 out nocopy JTF_NUMBER_TABLE
285 , p3_a3 out nocopy JTF_NUMBER_TABLE
286 , p3_a4 out nocopy JTF_NUMBER_TABLE
287 , p3_a5 out nocopy JTF_NUMBER_TABLE
288 , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
289 , p3_a7 out nocopy JTF_NUMBER_TABLE
290 ) return varchar2;
291 function reset_counters(p0_a0 NUMBER
292 , p0_a1 NUMBER
293 , p0_a2 VARCHAR2
294 , p0_a3 VARCHAR2
295 , p0_a4 NUMBER
296 , p0_a5 NUMBER
297 , p0_a6 VARCHAR2
298 , p0_a7 VARCHAR2
299 , p0_a8 NUMBER
300 , p0_a9 NUMBER
301 , p0_a10 NUMBER
302 , p0_a11 DATE
303 , p1_a0 in out nocopy JTF_NUMBER_TABLE
304 , p1_a1 in out nocopy JTF_NUMBER_TABLE
305 , p1_a2 in out nocopy JTF_NUMBER_TABLE
306 , p1_a3 in out nocopy JTF_NUMBER_TABLE
307 , p1_a4 in out nocopy JTF_NUMBER_TABLE
308 , p1_a5 in out nocopy JTF_NUMBER_TABLE
309 , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
310 , p1_a7 in out nocopy JTF_NUMBER_TABLE
311 , p_actual_end_date date
312 , x_msg_count out nocopy VARCHAR2
313 , x_msg_data out nocopy VARCHAR2
314 ) return varchar2;
315 function get_cp_counters(p_item_instance_id NUMBER
316 , p_wip_entity_id NUMBER
317 , p_actual_date date
318 , p3_a0 out nocopy JTF_NUMBER_TABLE
319 , p3_a1 out nocopy JTF_NUMBER_TABLE
320 , p3_a2 out nocopy JTF_NUMBER_TABLE
321 , p3_a3 out nocopy JTF_NUMBER_TABLE
322 , p3_a4 out nocopy JTF_NUMBER_TABLE
323 , p3_a5 out nocopy JTF_NUMBER_TABLE
324 , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
325 , p3_a7 out nocopy JTF_NUMBER_TABLE
326 ) return varchar2;
327 function update_ump(p_unit_effectivity_id NUMBER
328 , p_ue_object_version NUMBER
329 , p_actual_end_date date
330 , p3_a0 JTF_NUMBER_TABLE
331 , p3_a1 JTF_NUMBER_TABLE
332 , p3_a2 JTF_NUMBER_TABLE
333 , p3_a3 JTF_NUMBER_TABLE
334 , p3_a4 JTF_NUMBER_TABLE
335 , p3_a5 JTF_NUMBER_TABLE
336 , p3_a6 JTF_VARCHAR2_TABLE_100
337 , p3_a7 JTF_NUMBER_TABLE
338 , p_dml_flag VARCHAR2
339 , x_msg_count out nocopy VARCHAR2
340 , x_msg_data out nocopy VARCHAR2
341 ) return varchar2;
342 end ahl_completions_pvt_w;