[Home] [Help]
PACKAGE: APPS.WIP_EAMWORKORDER_PVT
Source
1 PACKAGE WIP_EAMWORKORDER_PVT AS
2 /* $Header: WIPVEWOS.pls 120.0 2005/05/24 18:01:46 appldev noship $ */
3
4 TYPE work_order_interface_rec_type is RECORD
5 (
6 last_update_date DATE , --NOT NULL,
7 last_updated_by NUMBER,
8 creation_date DATE , --NOT NULL,
9 created_by NUMBER,
10 last_update_login NUMBER,
11 request_id NUMBER,
12 program_id NUMBER,
13 program_application_id NUMBER,
14 program_update_date DATE,
15 group_id NUMBER,
16 source_code VARCHAR2(30),
17 source_line_id NUMBER,
18 -- process_type NUMBER,
19 organization_id NUMBER,
20 load_type NUMBER, -- NOT NULL,
21 status_type NUMBER,
22 -- old_status_type NUMBER,
23 last_unit_completion_date DATE,
24 -- old_completion_date DATE,
25 processing_work_days NUMBER,
26 daily_production_rate NUMBER,
27 line_id NUMBER,
28 primary_item_id NUMBER,
29 bom_reference_id NUMBER,
30 routing_reference_id NUMBER,
31 bom_revision_date DATE,
32 routing_revision_date DATE,
33 wip_supply_type NUMBER,
34 class_code VARCHAR2(10),
35 lot_number VARCHAR2(80),
36 -- lot_control_code NUMBER,
37 job_name VARCHAR2(240),
38 description VARCHAR2(240),
39 firm_planned_flag NUMBER,
40 alternate_routing_designator VARCHAR2(10),
41 alternate_bom_designator VARCHAR2(10),
42 demand_class VARCHAR2(30),
43 start_quantity NUMBER,
44 -- old_start_quantity NUMBER,
45 wip_entity_id NUMBER,
46 repetitive_schedule_id NUMBER,
47 -- error VARCHAR2(240),
48 -- parent_group_id NUMBER,
49 attribute_category VARCHAR2(30),
50 attribute1 VARCHAR2(150),
51 attribute2 VARCHAR2(150),
52 attribute3 VARCHAR2(150),
53 attribute4 VARCHAR2(150),
54 attribute5 VARCHAR2(150),
55 attribute6 VARCHAR2(150),
56 attribute7 VARCHAR2(150),
57 attribute8 VARCHAR2(150),
58 attribute9 VARCHAR2(150),
59 attribute10 VARCHAR2(150),
60 attribute11 VARCHAR2(150),
61 attribute12 VARCHAR2(150),
62 attribute13 VARCHAR2(150),
63 attribute14 VARCHAR2(150),
64 attribute15 VARCHAR2(150),
65 interface_id NUMBER,
66 last_updated_by_name VARCHAR2(100),
67 created_by_name VARCHAR2(100),
68 process_phase NUMBER,
69 process_status NUMBER,
70 organization_code VARCHAR2(3),
71 first_unit_start_date DATE,
72 first_unit_completion_date DATE,
73 last_unit_start_date DATE,
74 scheduling_method NUMBER,
75 line_code VARCHAR2(10),
76 primary_item_segments VARCHAR2(2000),
77 bom_reference_segments VARCHAR2(2000),
78 routing_reference_segments VARCHAR2(2000),
79 routing_revision VARCHAR2(3),
80 bom_revision VARCHAR2(3),
81 completion_subinventory VARCHAR2(10),
82 completion_locator_id NUMBER,
83 completion_locator_segments VARCHAR2(2000),
84 schedule_group_id NUMBER,
85 schedule_group_name VARCHAR2(30),
86 build_sequence NUMBER,
87 project_id NUMBER,
88 -- project_name VARCHAR2(30),
89 task_id NUMBER,
90 -- task_name VARCHAR2(20),
91 net_quantity NUMBER,
92 -- descriptive_flex_segments VARCHAR2(2000),
93 project_number VARCHAR2(25),
94 task_number VARCHAR2(25),
95 --project_costed NUMBER,
96 end_item_unit_number VARCHAR2(30),
97 overcompletion_tolerance_type NUMBER,
98 overcompletion_tolerance_value NUMBER,
99 kanban_card_id NUMBER,
100 priority NUMBER,
101 due_date DATE,
102 allow_explosion VARCHAR2(1),
103 header_id NUMBER,
104 delivery_id NUMBER,
105 coproducts_supply NUMBER,
106 due_date_penalty NUMBER,
107 due_date_tolerance NUMBER,
108 xml_document_id VARCHAR2(240),
109 parent_wip_entity_id NUMBER,
110 parent_job_name VARCHAR2(240),
111 asset_number VARCHAR2(30),
112 asset_group_id NUMBER,
113 asset_group_segments VARCHAR2(2000),
114 pm_schedule_id NUMBER,
115 rebuild_item_id NUMBER,
116 rebuild_item_segments VARCHAR2(2000),
117 rebuild_serial_number VARCHAR2(30),
118 manual_rebuild_flag VARCHAR2(1),
119 shutdown_type VARCHAR2(30),
120 notification_required VARCHAR2(1),
121 work_order_type VARCHAR2(30),
122 owning_department NUMBER,
123 owning_department_code VARCHAR2(10),
124 activity_type VARCHAR2(30),
125 activity_cause VARCHAR2(30),
126 tagout_required VARCHAR2(1),
127 plan_maintenance VARCHAR2(1),
128 date_released DATE,
129 requested_start_date DATE,
130 maintenance_object_id NUMBER,
131 maintenance_object_type NUMBER,
132 maintenance_object_source NUMBER,
133 activity_source VARCHAR2(30),
134 serialization_start_op NUMBER
135 );
136
137
138 -- Start of comments
139 -- API name : Create_EAM_Work_Order
140 -- Type : Private.
141 -- Function :
142 -- Pre-reqs : None.
143 -- Parameters :
144 -- IN : p_api_version IN NUMBER Required
145 -- p_init_msg_list IN VARCHAR2 Optional
146 -- Default = FND_API.G_FALSE
147 -- p_commit IN VARCHAR2 Optional
148 -- Default = FND_API.G_FALSE
149 -- p_validation_level IN NUMBER Optional
150 -- Default = FND_API.G_VALID_LEVEL_FULL
151 -- parameter1
152 -- parameter2
153 -- .
154 -- .
155 -- OUT : x_return_status OUT VARCHAR2(1)
156 -- x_msg_count OUT NUMBER
157 -- x_msg_data OUT VARCHAR2(2000)
158 -- parameter1
159 -- parameter2
160 -- .
161 -- .
162 -- Version : Initial version 1.0
163 --
164 -- Notes : Note text
165 --
166 -- End of comments
167
168 PROCEDURE Create_EAM_Work_Order
169 ( p_api_version IN NUMBER ,
170 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
171 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
173 x_return_status OUT NOCOPY VARCHAR2 ,
174 x_msg_count OUT NOCOPY NUMBER ,
175 x_msg_data OUT NOCOPY VARCHAR2 ,
176 p_work_order_rec IN work_order_interface_rec_type,
177 x_group_id OUT NOCOPY NUMBER,
178 x_request_id OUT NOCOPY NUMBER
179 );
180
181 --Procedure to return the log directory path to workorder api
182 --x_output_dir will be null if no directory is found
183 --else it will be the directory name
184 PROCEDURE log_path(
185 x_output_dir OUT NOCOPY VARCHAR2
186 );
187
188
189 -- Start of comments
190 -- API name : Get_EAM_Activity_Cause_Default
191 -- Type : Private.
192 -- Function :
193 -- Pre-reqs : None.
194 -- Parameters :
195 -- IN : p_api_version IN NUMBER Required
196 -- p_init_msg_list IN VARCHAR2 Optional
197 -- Default = FND_API.G_FALSE
198 -- p_commit IN VARCHAR2 Optional
199 -- Default = FND_API.G_FALSE
200 -- p_validation_level IN NUMBER Optional
201 -- Default = FND_API.G_VALID_LEVEL_FULL
202 -- parameter1
203 -- parameter2
204 -- .
205 -- .
206 -- OUT : x_return_status OUT VARCHAR2(1)
207 -- x_msg_count OUT NUMBER
208 -- x_msg_data OUT VARCHAR2(2000)
209 -- parameter1
210 -- parameter2
211 -- .
212 -- .
213 -- Version : Initial version 1.0
214 --
215 -- Notes : Note text
216 --
217 -- End of comments
218
219 PROCEDURE Get_EAM_Act_Cause_Default
220 ( p_api_version IN NUMBER ,
221 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
222 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
223 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
224 x_return_status OUT NOCOPY VARCHAR2 ,
225 x_msg_count OUT NOCOPY NUMBER ,
226 x_msg_data OUT NOCOPY VARCHAR2 ,
227 p_primary_item_id IN NUMBER ,
228 p_organization_id IN NUMBER ,
229 p_maintenance_object_type IN NUMBER ,
230 p_maintenance_object_id IN NUMBER ,
231 p_rebuild_item_id IN NUMBER ,
232 x_activity_cause_code OUT NOCOPY NUMBER
233 );
234
235
236 -- Start of comments
237 -- API name : Get_EAM_Activity_Type_Default
238 -- Type : Private.
239 -- Function :
240 -- Pre-reqs : None.
241 -- Parameters :
242 -- IN : p_api_version IN NUMBER Required
243 -- p_init_msg_list IN VARCHAR2 Optional
244 -- Default = FND_API.G_FALSE
245 -- p_commit IN VARCHAR2 Optional
246 -- Default = FND_API.G_FALSE
247 -- p_validation_level IN NUMBER Optional
248 -- Default = FND_API.G_VALID_LEVEL_FULL
249 -- parameter1
250 -- parameter2
251 -- .
252 -- .
253 -- OUT : x_return_status OUT VARCHAR2(1)
254 -- x_msg_count OUT NUMBER
255 -- x_msg_data OUT VARCHAR2(2000)
256 -- parameter1
257 -- parameter2
258 -- .
259 -- .
260 -- Version : Initial version 1.0
261 --
262 -- Notes : Note text
263 --
264 -- End of comments
265
266 PROCEDURE Get_EAM_Act_Type_Default
267 ( p_api_version IN NUMBER ,
268 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
269 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
270 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
271 x_return_status OUT NOCOPY VARCHAR2 ,
272 x_msg_count OUT NOCOPY NUMBER ,
273 x_msg_data OUT NOCOPY VARCHAR2 ,
274 p_primary_item_id IN NUMBER ,
275 p_organization_id IN NUMBER ,
276 p_maintenance_object_type IN NUMBER ,
277 p_maintenance_object_id IN NUMBER ,
278 p_rebuild_item_id IN NUMBER ,
279 x_activity_type_code OUT NOCOPY NUMBER
280 );
281
282
283 -- Start of comments
284 -- API name : Get_EAM_Act_Source_Default
285 -- Type : Private.
286 -- Function :
287 -- Pre-reqs : None.
288 -- Parameters :
289 -- IN : p_api_version IN NUMBER Required
290 -- p_init_msg_list IN VARCHAR2 Optional
291 -- Default = FND_API.G_FALSE
292 -- p_commit IN VARCHAR2 Optional
293 -- Default = FND_API.G_FALSE
294 -- p_validation_level IN NUMBER Optional
295 -- Default = FND_API.G_VALID_LEVEL_FULL
296 -- parameter1
297 -- parameter2
298 -- .
299 -- .
300 -- OUT : x_return_status OUT VARCHAR2(1)
301 -- x_msg_count OUT NUMBER
302 -- x_msg_data OUT VARCHAR2(2000)
303 -- parameter1
304 -- parameter2
305 -- .
306 -- .
307 -- Version : Initial version 1.0
308 --
309 -- Notes : Note text
310 --
311 -- End of comments
312
313 PROCEDURE Get_EAM_Act_Source_Default
314 ( p_api_version IN NUMBER ,
315 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
316 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
317 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
318 x_return_status OUT NOCOPY VARCHAR2 ,
319 x_msg_count OUT NOCOPY NUMBER ,
320 x_msg_data OUT NOCOPY VARCHAR2 ,
321 p_primary_item_id IN NUMBER ,
325 p_rebuild_item_id IN NUMBER ,
322 p_organization_id IN NUMBER ,
323 p_maintenance_object_type IN NUMBER ,
324 p_maintenance_object_id IN NUMBER ,
326 x_activity_source_code OUT NOCOPY NUMBER
327 );
328
329
330 -- Start of comments
331 -- API name : Get_EAM_Shutdown_Default
332 -- Type : Private.
333 -- Function :
334 -- Pre-reqs : None.
335 -- Parameters :
336 -- IN : p_api_version IN NUMBER Required
337 -- p_init_msg_list IN VARCHAR2 Optional
338 -- Default = FND_API.G_FALSE
339 -- p_commit IN VARCHAR2 Optional
340 -- Default = FND_API.G_FALSE
341 -- p_validation_level IN NUMBER Optional
342 -- Default = FND_API.G_VALID_LEVEL_FULL
343 -- parameter1
344 -- parameter2
345 -- .
346 -- .
347 -- OUT : x_return_status OUT VARCHAR2(1)
348 -- x_msg_count OUT NUMBER
349 -- x_msg_data OUT VARCHAR2(2000)
350 -- parameter1
351 -- parameter2
352 -- .
353 -- .
354 -- Version : Initial version 1.0
355 --
356 -- Notes : Note text
357 --
358 -- End of comments
359
360 PROCEDURE Get_EAM_Shutdown_Default
361 ( p_api_version IN NUMBER ,
362 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
363 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
364 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
365 x_return_status OUT NOCOPY VARCHAR2 ,
366 x_msg_count OUT NOCOPY NUMBER ,
367 x_msg_data OUT NOCOPY VARCHAR2 ,
368 p_primary_item_id IN NUMBER ,
369 p_organization_id IN NUMBER ,
370 p_maintenance_object_type IN NUMBER ,
371 p_maintenance_object_id IN NUMBER ,
372 p_rebuild_item_id IN NUMBER ,
373 x_shutdown_type_code OUT NOCOPY NUMBER
374 );
375
376
377 -- Start of comments
378 -- API name : Get_EAM_Notification_Default
379 -- Type : Private.
380 -- Function :
381 -- Pre-reqs : None.
382 -- Parameters :
383 -- IN : p_api_version IN NUMBER Required
384 -- p_init_msg_list IN VARCHAR2 Optional
385 -- Default = FND_API.G_FALSE
386 -- p_commit IN VARCHAR2 Optional
387 -- Default = FND_API.G_FALSE
388 -- p_validation_level IN NUMBER Optional
389 -- Default = FND_API.G_VALID_LEVEL_FULL
390 -- parameter1
391 -- parameter2
395 -- x_msg_count OUT NUMBER
392 -- .
393 -- .
394 -- OUT : x_return_status OUT VARCHAR2(1)
396 -- x_msg_data OUT VARCHAR2(2000)
397 -- parameter1
398 -- parameter2
399 -- .
400 -- .
401 -- Version : Initial version 1.0
402 --
403 -- Notes : Note text
404 --
405 -- End of comments
406
407 PROCEDURE Get_EAM_Notification_Default
408 ( p_api_version IN NUMBER ,
409 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
410 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
411 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
412 x_return_status OUT NOCOPY VARCHAR2 ,
413 x_msg_count OUT NOCOPY NUMBER ,
414 x_msg_data OUT NOCOPY VARCHAR2 ,
415 p_primary_item_id IN NUMBER ,
416 p_organization_id IN NUMBER ,
417 p_maintenance_object_type IN NUMBER ,
418 p_maintenance_object_id IN NUMBER ,
419 p_rebuild_item_id IN NUMBER ,
420 x_notification_flag OUT NOCOPY VARCHAR2
421 );
422
423
424
425 -- Start of comments
426 -- API name : Get_EAM_Nitification_Default
427 -- Type : Private.
428 -- Function :
429 -- Pre-reqs : None.
430 -- Parameters :
431 -- IN : p_api_version IN NUMBER Required
432 -- p_init_msg_list IN VARCHAR2 Optional
433 -- Default = FND_API.G_FALSE
434 -- p_commit IN VARCHAR2 Optional
435 -- Default = FND_API.G_FALSE
436 -- p_validation_level IN NUMBER Optional
437 -- Default = FND_API.G_VALID_LEVEL_FULL
438 -- parameter1
439 -- parameter2
440 -- .
441 -- .
442 -- OUT : x_return_status OUT VARCHAR2(1)
443 -- x_msg_count OUT NUMBER
444 -- x_msg_data OUT VARCHAR2(2000)
445 -- parameter1
446 -- parameter2
447 -- .
448 -- .
449 -- Version : Initial version 1.0
450 --
451 -- Notes : Note text
452 --
453 -- End of comments
454
455 PROCEDURE Get_EAM_Tagout_Default
456 ( p_api_version IN NUMBER ,
457 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
458 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
459 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
460 x_return_status OUT NOCOPY VARCHAR2 ,
461 x_msg_count OUT NOCOPY NUMBER ,
462 x_msg_data OUT NOCOPY VARCHAR2 ,
463 p_primary_item_id IN NUMBER ,
464 p_organization_id IN NUMBER ,
465 p_maintenance_object_type IN NUMBER ,
466 p_maintenance_object_id IN NUMBER ,
467 p_rebuild_item_id IN NUMBER ,
468 x_tagout_required OUT NOCOPY VARCHAR2
469 );
470
471
472 -- Start of comments
473 -- API name : Get_EAM_Owning_Dept_Default
474 -- Type : Private.
475 -- Function :
476 -- Pre-reqs : None.
477 -- Parameters :
478 -- IN : p_api_version IN NUMBER Required
479 -- p_init_msg_list IN VARCHAR2 Optional
480 -- Default = FND_API.G_FALSE
481 -- p_commit IN VARCHAR2 Optional
482 -- Default = FND_API.G_FALSE
483 -- p_validation_level IN NUMBER Optional
484 -- Default = FND_API.G_VALID_LEVEL_FULL
485 -- parameter1
486 -- parameter2
487 -- .
488 -- .
489 -- OUT : x_return_status OUT VARCHAR2(1)
490 -- x_msg_count OUT NUMBER
491 -- x_msg_data OUT VARCHAR2(2000)
492 -- parameter1
493 -- parameter2
494 -- .
495 -- .
496 -- Version : Initial version 1.0
497 --
498 -- Notes : Note text
499 --
500 -- End of comments
501
502 PROCEDURE Get_EAM_Owning_Dept_Default
503 ( p_api_version IN NUMBER ,
504 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
505 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
506 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
507 x_return_status OUT NOCOPY VARCHAR2 ,
508 x_msg_count OUT NOCOPY NUMBER ,
509 x_msg_data OUT NOCOPY VARCHAR2 ,
510 p_primary_item_id IN NUMBER ,
511 p_organization_id IN NUMBER ,
512 p_maintenance_object_type IN NUMBER ,
513 p_maintenance_object_id IN NUMBER ,
514 p_rebuild_item_id IN NUMBER ,
515 x_owning_department_id OUT NOCOPY NUMBER
516 );
517
518 END WIP_EAMWORKORDER_PVT;
519