[Home] [Help]
PACKAGE BODY: APPS.EAM_ITEM_ACTIVITIES_PUB_W
Source
1 package body eam_item_activities_pub_w as
2 /* $Header: EAMWIAAB.pls 120.0 2005/05/25 16:32:37 appldev noship $ */
3 procedure insert_item_activities(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status out nocopy VARCHAR2
8 , x_msg_count out nocopy NUMBER
9 , x_msg_data out nocopy VARCHAR2
10 , p_asset_activity_id NUMBER
11 , p_inventory_item_id NUMBER
12 , p_organization_id NUMBER
13 , p_owningdepartment_id NUMBER
14 , p_maintenance_object_id NUMBER
15 , p_creation_organization_id NUMBER
16 , p_start_date_active DATE
17 , p_end_date_active DATE
18 , p_priority_code VARCHAR2
19 , p_activity_cause_code VARCHAR2
20 , p_activity_type_code VARCHAR2
21 , p_shutdown_type_code VARCHAR2
22 , p_maintenance_object_type NUMBER
23 , p_tmpl_flag VARCHAR2
24 , p_class_code VARCHAR2
25 , p_activity_source_code VARCHAR2
26 , p_serial_number VARCHAR2
27 , p_attribute_category VARCHAR2
28 , p_attribute1 VARCHAR2
29 , p_attribute2 VARCHAR2
30 , p_attribute3 VARCHAR2
31 , p_attribute4 VARCHAR2
32 , p_attribute5 VARCHAR2
33 , p_attribute6 VARCHAR2
34 , p_attribute7 VARCHAR2
35 , p_attribute8 VARCHAR2
36 , p_attribute9 VARCHAR2
37 , p_attribute10 VARCHAR2
38 , p_attribute11 VARCHAR2
39 , p_attribute12 VARCHAR2
40 , p_attribute13 VARCHAR2
41 , p_attribute14 VARCHAR2
42 , p_attribute15 VARCHAR2
43 , p_tagging_required_flag VARCHAR2
44 , p_last_service_start_date DATE
45 , p_last_service_end_date DATE
46 , p_prev_service_start_date DATE
47 , p_prev_service_end_date DATE
48 , p_last_scheduled_start_date DATE
49 , p_last_scheduled_end_date DATE
50 , p_prev_scheduled_start_date DATE
51 , p_prev_scheduled_end_date DATE
52 , p_wip_entity_id NUMBER
53 , p_source_tmpl_id NUMBER
54 , p46_a0 JTF_NUMBER_TABLE
55 , p46_a1 JTF_NUMBER_TABLE
56 , p46_a2 JTF_NUMBER_TABLE
57 , p46_a3 JTF_NUMBER_TABLE
58 )
59
60 as
61 ddp_pm_last_service_tbl eam_pm_last_service_pub.pm_last_service_tbl;
62 ddindx binary_integer; indx binary_integer;
63 begin
64
65 -- copy data to the local IN or IN-OUT args, if any
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112 eam_pm_last_service_pub_w.rosetta_table_copy_in_p1(ddp_pm_last_service_tbl, p46_a0
113 , p46_a1
114 , p46_a2
115 , p46_a3
116 );
117
118 -- here's the delegated call to the old PL/SQL routine
119 eam_item_activities_pub.insert_item_activities(p_api_version,
120 p_init_msg_list,
121 p_commit,
122 p_validation_level,
123 x_return_status,
124 x_msg_count,
125 x_msg_data,
126 p_asset_activity_id,
127 p_inventory_item_id,
128 p_organization_id,
129 p_owningdepartment_id,
130 p_maintenance_object_id,
131 p_creation_organization_id,
132 p_start_date_active,
133 p_end_date_active,
134 p_priority_code,
135 p_activity_cause_code,
136 p_activity_type_code,
137 p_shutdown_type_code,
138 p_maintenance_object_type,
139 p_tmpl_flag,
140 p_class_code,
141 p_activity_source_code,
142 p_serial_number,
143 p_attribute_category,
144 p_attribute1,
145 p_attribute2,
146 p_attribute3,
147 p_attribute4,
148 p_attribute5,
149 p_attribute6,
150 p_attribute7,
151 p_attribute8,
152 p_attribute9,
153 p_attribute10,
154 p_attribute11,
155 p_attribute12,
156 p_attribute13,
157 p_attribute14,
158 p_attribute15,
159 p_tagging_required_flag,
160 p_last_service_start_date,
161 p_last_service_end_date,
162 p_prev_service_start_date,
163 p_prev_service_end_date,
164 p_last_scheduled_start_date,
165 p_last_scheduled_end_date,
166 p_prev_scheduled_start_date,
167 p_prev_scheduled_end_date,
168 p_wip_entity_id,
169 p_source_tmpl_id,
170 ddp_pm_last_service_tbl);
171
172 -- copy data back from the local variables to OUT or IN-OUT args, if any
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219 end;
220
221 procedure update_item_activities(p_api_version NUMBER
222 , p_init_msg_list VARCHAR2
223 , p_commit VARCHAR2
224 , p_validation_level NUMBER
225 , x_return_status out nocopy VARCHAR2
226 , x_msg_count out nocopy NUMBER
227 , x_msg_data out nocopy VARCHAR2
228 , p_activity_association_id NUMBER
229 , p_asset_activity_id NUMBER
230 , p_inventory_item_id NUMBER
231 , p_organization_id NUMBER
232 , p_owningdepartment_id NUMBER
233 , p_maintenance_object_id NUMBER
234 , p_creation_organization_id NUMBER
235 , p_start_date_active DATE
236 , p_end_date_active DATE
237 , p_priority_code VARCHAR2
238 , p_activity_cause_code VARCHAR2
239 , p_activity_type_code VARCHAR2
240 , p_shutdown_type_code VARCHAR2
241 , p_maintenance_object_type NUMBER
242 , p_tmpl_flag VARCHAR2
243 , p_class_code VARCHAR2
244 , p_activity_source_code VARCHAR2
245 , p_serial_number VARCHAR2
246 , p_attribute_category VARCHAR2
247 , p_attribute1 VARCHAR2
248 , p_attribute2 VARCHAR2
249 , p_attribute3 VARCHAR2
250 , p_attribute4 VARCHAR2
251 , p_attribute5 VARCHAR2
252 , p_attribute6 VARCHAR2
253 , p_attribute7 VARCHAR2
254 , p_attribute8 VARCHAR2
255 , p_attribute9 VARCHAR2
256 , p_attribute10 VARCHAR2
257 , p_attribute11 VARCHAR2
258 , p_attribute12 VARCHAR2
259 , p_attribute13 VARCHAR2
260 , p_attribute14 VARCHAR2
261 , p_attribute15 VARCHAR2
262 , p_tagging_required_flag VARCHAR2
263 , p_last_service_start_date DATE
264 , p_last_service_end_date DATE
265 , p_prev_service_start_date DATE
266 , p_prev_service_end_date DATE
267 , p_last_scheduled_start_date DATE
268 , p_last_scheduled_end_date DATE
269 , p_prev_scheduled_start_date DATE
270 , p_prev_scheduled_end_date DATE
271 , p_wip_entity_id NUMBER
272 , p_source_tmpl_id NUMBER
273 , p47_a0 JTF_NUMBER_TABLE
274 , p47_a1 JTF_NUMBER_TABLE
275 , p47_a2 JTF_NUMBER_TABLE
276 , p47_a3 JTF_NUMBER_TABLE
277 )
278
279 as
280 ddp_pm_last_service_tbl eam_pm_last_service_pub.pm_last_service_tbl;
281 ddindx binary_integer; indx binary_integer;
282 begin
283
284 -- copy data to the local IN or IN-OUT args, if any
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332 eam_pm_last_service_pub_w.rosetta_table_copy_in_p1(ddp_pm_last_service_tbl, p47_a0
333 , p47_a1
334 , p47_a2
335 , p47_a3
336 );
337
338 -- here's the delegated call to the old PL/SQL routine
339 eam_item_activities_pub.update_item_activities(p_api_version,
340 p_init_msg_list,
341 p_commit,
342 p_validation_level,
343 x_return_status,
344 x_msg_count,
345 x_msg_data,
346 p_activity_association_id,
347 p_asset_activity_id,
348 p_inventory_item_id,
349 p_organization_id,
350 p_owningdepartment_id,
351 p_maintenance_object_id,
352 p_creation_organization_id,
353 p_start_date_active,
354 p_end_date_active,
355 p_priority_code,
356 p_activity_cause_code,
357 p_activity_type_code,
358 p_shutdown_type_code,
359 p_maintenance_object_type,
360 p_tmpl_flag,
361 p_class_code,
362 p_activity_source_code,
363 p_serial_number,
364 p_attribute_category,
365 p_attribute1,
366 p_attribute2,
367 p_attribute3,
368 p_attribute4,
369 p_attribute5,
370 p_attribute6,
371 p_attribute7,
372 p_attribute8,
373 p_attribute9,
374 p_attribute10,
375 p_attribute11,
376 p_attribute12,
377 p_attribute13,
378 p_attribute14,
379 p_attribute15,
380 p_tagging_required_flag,
381 p_last_service_start_date,
382 p_last_service_end_date,
383 p_prev_service_start_date,
384 p_prev_service_end_date,
385 p_last_scheduled_start_date,
386 p_last_scheduled_end_date,
387 p_prev_scheduled_start_date,
388 p_prev_scheduled_end_date,
389 p_wip_entity_id,
390 p_source_tmpl_id,
391 ddp_pm_last_service_tbl);
392
393 -- copy data back from the local variables to OUT or IN-OUT args, if any
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441 end;
442
443 end eam_item_activities_pub_w;