[Home] [Help]
PACKAGE: APPS.AHL_PRD_WORKORDER_PVT
Source
1 PACKAGE AHL_PRD_WORKORDER_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPRJS.pls 120.8.12020000.2 2012/12/07 13:22:13 sareepar ship $ */
3 TYPE PRD_WORKOPERATION_REC IS RECORD
4 (
5 WORKORDER_OPERATION_ID NUMBER,
6 ORGANIZATION_ID NUMBER,
7 OPERATION_SEQUENCE_NUM NUMBER,
8 OPERATION_DESCRIPTION VARCHAR2(500),
9 WORKORDER_ID NUMBER,
10 WIP_ENTITY_ID NUMBER,
11 ROUTE_ID NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 LAST_UPDATE_DATE DATE ,
14 LAST_UPDATED_BY NUMBER,
15 CREATION_DATE DATE,
16 CREATED_BY NUMBER,
17 LAST_UPDATE_LOGIN NUMBER,
18 DEPARTMENT_ID NUMBER,
19 DEPARTMENT_NAME VARCHAR2(240),
20 STATUS_CODE VARCHAR2(30),
21 STATUS_MEANING VARCHAR2(80),
22 OPERATION_ID NUMBER,
23 OPERATION_CODE VARCHAR2(500),
24 OPERATION_TYPE_CODE VARCHAR2(30),
25 OPERATION_TYPE VARCHAR2(80),
26 REPLENISH VARCHAR2(1),
27 MINIMUM_TRANSFER_QUANTITY NUMBER,
28 COUNT_POINT_TYPE NUMBER,
29 SCHEDULED_START_DATE DATE,
30 SCHEDULED_START_HR NUMBER,
31 SCHEDULED_START_MI NUMBER,
32 SCHEDULED_END_DATE DATE,
33 SCHEDULED_END_HR NUMBER,
34 SCHEDULED_END_MI NUMBER,
35 ACTUAL_START_DATE DATE,
36 ACTUAL_START_HR NUMBER,
37 ACTUAL_START_MI NUMBER,
38 ACTUAL_END_DATE DATE,
39 ACTUAL_END_HR NUMBER,
40 ACTUAL_END_MI NUMBER,
41 PLAN_ID NUMBER,
42 COLLECTION_ID NUMBER,
43 PROPAGATE_FLAG VARCHAR2(1),
44 SECURITY_GROUP_ID NUMBER,
45 ATTRIBUTE_CATEGORY VARCHAR2(30),
46 ATTRIBUTE1 VARCHAR2(150),
47 ATTRIBUTE2 VARCHAR2(150),
48 ATTRIBUTE3 VARCHAR2(150),
49 ATTRIBUTE4 VARCHAR2(150),
50 ATTRIBUTE5 VARCHAR2(150),
51 ATTRIBUTE6 VARCHAR2(150),
52 ATTRIBUTE7 VARCHAR2(150),
53 ATTRIBUTE8 VARCHAR2(150),
54 ATTRIBUTE9 VARCHAR2(150),
55 ATTRIBUTE10 VARCHAR2(150),
56 ATTRIBUTE11 VARCHAR2(150),
57 ATTRIBUTE12 VARCHAR2(150),
58 ATTRIBUTE13 VARCHAR2(150),
59 ATTRIBUTE14 VARCHAR2(150),
60 ATTRIBUTE15 VARCHAR2(150),
61 DML_OPERATION VARCHAR2(1)
62 );
63
64 TYPE PRD_WORKOPER_TBL IS TABLE OF PRD_WORKOPERATION_REC INDEX BY BINARY_INTEGER;
65
66 TYPE PRD_WORKORDER_REC IS RECORD
67 (
68 BATCH_ID NUMBER,
69 HEADER_ID NUMBER,
70 WORKORDER_ID NUMBER,
71 WIP_ENTITY_ID NUMBER,
72 OBJECT_VERSION_NUMBER NUMBER,
73 JOB_NUMBER VARCHAR2(80),
74 JOB_DESCRIPTION VARCHAR2(240),
75 ORGANIZATION_ID NUMBER,
76 ORGANIZATION_NAME VARCHAR2(240),
77 ORGANIZATION_CODE VARCHAR2(10),
78 DEPARTMENT_NAME VARCHAR2(240),
79 DEPARTMENT_ID NUMBER,
80 DEPARTMENT_CLASS_CODE VARCHAR2(10),
81 STATUS_CODE VARCHAR2(30),
82 STATUS_MEANING VARCHAR2(80),
83 SCHEDULED_START_DATE DATE,
84 SCHEDULED_START_HR NUMBER,
85 SCHEDULED_START_MI NUMBER,
86 SCHEDULED_END_DATE DATE,
87 SCHEDULED_END_HR NUMBER,
88 SCHEDULED_END_MI NUMBER,
89 ACTUAL_START_DATE DATE,
90 ACTUAL_START_HR NUMBER,
91 ACTUAL_START_MI NUMBER,
92 ACTUAL_END_DATE DATE,
93 ACTUAL_END_HR NUMBER,
94 ACTUAL_END_MI NUMBER,
95 INVENTORY_ITEM_ID NUMBER,
96 ITEM_INSTANCE_ID NUMBER,
97 UNIT_NAME VARCHAR2(80),
98 ITEM_INSTANCE_NUMBER VARCHAR2(30),
99 WO_PART_NUMBER VARCHAR2(40),
100 ITEM_DESCRIPTION VARCHAR2(240),
101 SERIAL_NUMBER VARCHAR2(30),
102 ITEM_INSTANCE_UOM VARCHAR2(3),
103 COMPLETION_SUBINVENTORY VARCHAR2(10),
104 COMPLETION_LOCATOR_ID NUMBER,
105 COMPLETION_LOCATOR_NAME VARCHAR2(204),
106 WIP_SUPPLY_TYPE NUMBER,
107 WIP_SUPPLY_MEANING VARCHAR2(80),
108 FIRM_PLANNED_FLAG NUMBER,
109 MASTER_WORKORDER_FLAG VARCHAR2(1),
110 VISIT_ID NUMBER,
111 VISIT_NUMBER NUMBER,
112 VISIT_NAME VARCHAR2(80),
113 VISIT_TASK_ID NUMBER,
114 MR_HEADER_ID NUMBER,
115 VISIT_TASK_NUMBER NUMBER,
116 MR_TITLE VARCHAR2(80),
117 MR_ROUTE_ID NUMBER,
118 ROUTE_ID NUMBER,
119 CONFIRM_FAILURE_FLAG VARCHAR2(1),
120 PROPAGATE_FLAG VARCHAR2(1),
121 SERVICE_ITEM_ID NUMBER,
122 SERVICE_ITEM_ORG_ID NUMBER,
123 SERVICE_ITEM_DESCRIPTION VARCHAR2(240),
124 SERVICE_ITEM_NUMBER VARCHAR2(40),
125 SERVICE_ITEM_UOM VARCHAR2(3),
126 PROJECT_ID NUMBER,
127 PROJECT_TASK_ID NUMBER,
128 QUANTITY NUMBER,
129 MRP_QUANTITY NUMBER,
130 INCIDENT_ID NUMBER,
131 ORIGINATION_TASK_ID NUMBER,
132 PARENT_ID NUMBER,
133 TASK_MOTIVE_STATUS_ID NUMBER,
134 ALLOW_EXPLOSION VARCHAR2(1),
135 CLASS_CODE VARCHAR2(10),
136 JOB_PRIORITY NUMBER,
137 JOB_PRIORITY_MEANING VARCHAR2(30),
138 CONFIRMED_FAILURE_FLAG NUMBER,
139 UNIT_EFFECTIVITY_ID NUMBER,
140 PLAN_ID NUMBER,
141 COLLECTION_ID NUMBER,
142 SUB_INVENTORY VARCHAR2(10),
143 LOCATOR_ID NUMBER,
144 SECURITY_GROUP_ID NUMBER,
145 ATTRIBUTE_CATEGORY VARCHAR2(30),
146 ATTRIBUTE1 VARCHAR2(150),
147 ATTRIBUTE2 VARCHAR2(150),
148 ATTRIBUTE3 VARCHAR2(150),
149 ATTRIBUTE4 VARCHAR2(150),
150 ATTRIBUTE5 VARCHAR2(150),
151 ATTRIBUTE6 VARCHAR2(150),
152 ATTRIBUTE7 VARCHAR2(150),
153 ATTRIBUTE8 VARCHAR2(150),
154 ATTRIBUTE9 VARCHAR2(150),
155 ATTRIBUTE10 VARCHAR2(150),
156 ATTRIBUTE11 VARCHAR2(150),
157 ATTRIBUTE12 VARCHAR2(150),
158 ATTRIBUTE13 VARCHAR2(150),
159 ATTRIBUTE14 VARCHAR2(150),
160 ATTRIBUTE15 VARCHAR2(150),
161 LAST_UPDATE_DATE DATE,
162 LAST_UPDATED_BY NUMBER,
163 CREATION_DATE DATE,
164 CREATED_BY NUMBER,
165 LAST_UPDATE_LOGIN NUMBER,
166 DML_OPERATION VARCHAR2(1),
167 HOLD_REASON_CODE VARCHAR2(30),
168 HOLD_REASON VARCHAR2(80),
169 -- ER#10257011 Supplier Warranty manisaga
170 CONTRACT_NUMBER NUMBER,
171 WARRANTY_STATUS_CODE VARCHAR2(30),
172
173 -- sansatpa - added AOG flag for marshalling
174 AOG_FLAG VARCHAR2(1),
175 SET_MR_PRIORITY VARCHAR2(1)
176 );
177
178 TYPE PRD_WORKORDER_TBL IS TABLE OF PRD_WORKORDER_REC INDEX BY BINARY_INTEGER;
179
180 TYPE PRD_WORKORDER_REL_REC IS RECORD
181 (
182 batch_id NUMBER,
183 wo_relationship_id NUMBER,
184 parent_header_id NUMBER,
185 parent_wip_entity_id NUMBER,
186 child_header_id NUMBER,
187 child_wip_entity_id NUMBER,
188 relationship_type NUMBER,
189 dml_operation VARCHAR2(1)
190 );
191
192 TYPE PRD_WORKORDER_REL_TBL IS TABLE OF PRD_WORKORDER_REL_REC INDEX BY BINARY_INTEGER;
193
194 PROCEDURE process_jobs
195 (
196 p_api_version IN NUMBER := 1.0,
197 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
198 p_commit IN VARCHAR2 := FND_API.G_FALSE,
199 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200 p_default IN VARCHAR2 := FND_API.G_FALSE,
201 p_module_type IN VARCHAR2,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_x_prd_workorder_tbl IN OUT NOCOPY PRD_WORKORDER_TBL,
206 p_prd_workorder_rel_tbl IN PRD_WORKORDER_REL_TBL
207 );
208
209 PROCEDURE update_job
210 (
211 p_api_version IN NUMBER := 1.0,
212 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
213 p_commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215 p_default IN VARCHAR2 := FND_API.G_FALSE,
216 p_module_type IN VARCHAR2,
217 x_return_status OUT NOCOPY VARCHAR2,
221 p_x_prd_workorder_rec IN OUT NOCOPY PRD_WORKORDER_REC,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_wip_load_flag IN VARCHAR2 := 'Y',
222 p_x_prd_workoper_tbl IN OUT NOCOPY PRD_WORKOPER_TBL
223 );
224
225 -- MANESING::NR Analysis, 03-Jun-2011, added following procedure
226 -- Start of Comments
227 -- Procedure name : process_stage_jobs
228 -- Type : Public
229 -- Description : This procedure updates the Resource Requirements for the Stage Workorders
230 -- in the following cases:
231 -- Case 1: When a Visit is Planned i.e. Visit status changes from Draft to Planning.
232 -- Case 2: When a Visit is Pushed to Production i.e. Visit status changes from Planning to Implemented.
233 -- Case 3: When MR(s) is added to a Visit (MR workorder(s) should be in Draft status).
234 -- Case 4: When MR(s) is removed from a Visit (MR workorder(s) should be in Draft status).
235 --
236 -- Note: This procedure is useful only in above mentioned cases, otherwise the stage workorders
237 -- will be created and updated using APIs create_job and update_job respectively.
238 -- Pre-reqs :
239 -- Parameters : p_workorder_tbl IN PRD_WORKORDER_TBL Required
240 --
241 -- End of Comments
242 PROCEDURE process_stage_jobs
243 (
244 p_api_version IN NUMBER := 1.0,
245 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
246 p_commit IN VARCHAR2 := FND_API.G_FALSE,
247 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
248 p_module_type IN VARCHAR2,
249 p_workorder_tbl IN PRD_WORKORDER_TBL,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2
253 );
254
255 PROCEDURE release_visit_jobs
256 (
257 p_api_version IN NUMBER := 1.0,
258 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
259 p_commit IN VARCHAR2 := FND_API.G_FALSE,
260 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261 p_default IN VARCHAR2 := FND_API.G_FALSE,
262 p_module_type IN VARCHAR2 := NULL,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2,
266 p_visit_id IN NUMBER,
267 p_unit_effectivity_id IN NUMBER,
268 p_workorder_id IN NUMBER
269 );
270
271 PROCEDURE cancel_visit_jobs
272 (
273 p_api_version IN NUMBER := 1.0,
274 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
275 p_commit IN VARCHAR2 := FND_API.G_FALSE,
276 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277 p_default IN VARCHAR2 := FND_API.G_FALSE,
278 p_module_type IN VARCHAR2 := NULL,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 p_visit_id IN NUMBER,
283 p_unit_effectivity_id IN NUMBER,
284 p_workorder_id IN NUMBER
285 );
286
287 PROCEDURE validate_dependencies
288 (
289 p_api_version IN NUMBER := 1.0,
290 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
291 p_commit IN VARCHAR2 := FND_API.G_FALSE,
292 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293 p_default IN VARCHAR2 := FND_API.G_FALSE,
294 p_module_type IN VARCHAR2 := NULL,
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2,
298 p_visit_id IN NUMBER,
299 p_unit_effectivity_id IN NUMBER,
300 p_workorder_id IN NUMBER
301 );
302
303 PROCEDURE reschedule_visit_jobs
304 (
305 p_api_version IN NUMBER := 1.0 ,
306 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
307 p_commit IN VARCHAR2 := FND_API.G_FALSE,
308 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309 p_default IN VARCHAR2 := FND_API.G_FALSE,
310 p_module_type IN VARCHAR2 := Null,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_visit_id IN NUMBER,
315 p_x_scheduled_start_date IN OUT NOCOPY DATE,
316 p_x_scheduled_end_date IN OUT NOCOPY DATE
317 );
318
319 TYPE TURNOVER_NOTES_REC_TYPE IS RECORD
320 (
321 jtf_note_id NUMBER,
322 source_object_id NUMBER,
323 source_object_code VARCHAR2(30),
324 notes VARCHAR2(2000),
325 employee_id NUMBER,--PERSON ID in PER_PEOPLE_F
326 employee_name VARCHAR2(240),--FULL_NAME in PER_PEOPLE_F
327 entered_date DATE,
328 org_id NUMBER
329 );
330
331 TYPE TURNOVER_NOTES_TBL_TYPE IS TABLE OF TURNOVER_NOTES_REC_TYPE INDEX BY BINARY_INTEGER;
332
333 PROCEDURE INSERT_TURNOVER_NOTES
334 (
335 p_api_version IN NUMBER := 1.0 ,
336 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
337 p_commit IN VARCHAR2 := FND_API.G_FALSE,
338 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339 p_default IN VARCHAR2 := FND_API.G_FALSE,
340 p_module_type IN VARCHAR2 := Null,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2,
347
344 p_trunover_notes_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type
345
346 );
348 -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- start
349 --------------------------------------------------------------------------------------------------
350 -- Procedure added for Bug # 8329755 (FP for Bug # 7697909)
351 -- This procedure updates master work order scheduled dates by deriving
352 -- it from underlying child work orders. This procedure does this logic
353 -- by only looking at immediate children of any MWO instead of drilling
354 -- down the entire hierarchy of children as done by update_job API.
355 --
356 -- Parameters
357 -- p_workorder_id IN NUMBER -- child work order id. The parent of this child work order will be
358 -- updated with derived scheduled dates.
359 --------------------------------------------------------------------------------------------------
360 PROCEDURE Update_Master_Wo_Dates(
361
362 p_workorder_id IN NUMBER
363 );
364 -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- end
365
366 -- JKJain, ER 9283136
367 PROCEDURE Unclose_Workorder
368 (
369 p_api_version IN NUMBER := 1.0,
370 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
371 p_commit IN VARCHAR2 := FND_API.G_FALSE,
372 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373 p_default IN VARCHAR2 := FND_API.G_FALSE,
374 p_module_type IN VARCHAR2 := NULL,
375 x_return_status OUT NOCOPY VARCHAR2,
376 x_msg_count OUT NOCOPY NUMBER,
377 x_msg_data OUT NOCOPY VARCHAR2,
378 p_x_prd_workorder_rec IN OUT NOCOPY prd_workorder_rec
379 );
380
381 -------------------------------------------------------------------------------------------------
382 -- Start of Comments
383 -- Procedure name : Synch_Wo_Projtask_Times
384 -- Type : Private
385 -- Pre-reqs :
386 -- Function : None
387 -- Description : Procedure added for project integration ER.
388 -- Procedure to synchronize work order scheduled dates
389 -- with corresponding project task dates.
390 -- Parameters :
391 --
392 -- Standard IN Parameters :
393 -- p_api_version NUMBER Required
394 --
395 -- Standard OUT Parameters :
396 -- errbuf VARCHAR2 Required
397 -- retcode NUMBER Required
398 --
399 -- IN parameters:
400 -- p_visit_id NUMBER Required
401 -- p_organization_id NUMBER Required
402 -- p_department_id NUMBER Required
403 --
404 -- IN OUT parameters:
405 -- None
406 --
407 -- OUT parameters:
408 -- None.
409 --
410 -- Version :
411 -- Current version 1.0
412 --
413 -- Return Parameter
414 -- None
415 -- End of Comments
416 --------------------------------------------------------------------------------------------------
417 PROCEDURE Synch_Wo_Projtask_Times(
418 errbuf OUT NOCOPY VARCHAR2,
419 retcode OUT NOCOPY NUMBER,
420 p_api_version IN NUMBER,
421 p_visit_id IN NUMBER,
422 p_organization_id IN NUMBER,
423 p_department_id IN NUMBER
424 );
425
426 --ER#10257011 Supplier Warranty manisaga
427 PROCEDURE populate_entitlements
428 (
429 p_api_version IN NUMBER := 1.0,
430 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
431 p_commit IN VARCHAR2 := FND_API.G_FALSE,
432 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433 p_contract_number IN NUMBER,
434 p_warranty_entl_rec IN OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type,
435 p_user_role IN VARCHAR2,
436 x_return_status OUT NOCOPY VARCHAR2,
437 x_msg_count OUT NOCOPY NUMBER,
438 x_msg_data OUT NOCOPY VARCHAR2
439 );
440 --sukhwsin::VEE Enhancement - Added following procedure for checking wo/Op status change and inserting turnover notes.
441 PROCEDURE ADD_WO_OPER_TURNOVER_NOTES
442 (
443 p_workorder_id IN NUMBER := NULL,
444 p_workorder_op_id IN NUMBER := NULL,
445 p_new_status_code IN VARCHAR2,
446 --sukhwsin::Bug 12915297. Added new nullable parameter for hold reason.
447 p_hold_reason_code IN VARCHAR2 := NULL,
448 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
449 p_default IN VARCHAR2 := FND_API.G_FALSE,
450 p_module_type IN VARCHAR2 := Null,
451 x_return_status OUT NOCOPY VARCHAR2
452 );
453 --sukhwsin::Complex Assembly enhancements - Added following procedure for WO turnover notes for instance routing.
454 PROCEDURE Add_Inst_Rtng_Notes_To_WO(
455 p_api_version IN NUMBER := 1.0,
456 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
457 p_commit IN VARCHAR2 := FND_API.G_FALSE,
458 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
459 x_return_status OUT NOCOPY VARCHAR2,
460 x_msg_count OUT NOCOPY NUMBER,
461 x_msg_data OUT NOCOPY VARCHAR2,
462 p_workorder_id IN NUMBER,
463 p_old_inst_rtng IN VARCHAR2 := NULL,
464 p_new_inst_rtng IN VARCHAR2 := NULL
465 );
466
467 TYPE WORKORDER_ID_REC_TYPE IS RECORD(
468 WORKORDER_ID NUMBER,
469 obj_ver_num NUMBER
470 );
471
472 TYPE WORKORDER_ID_TBL_TYPE IS TABLE OF WORKORDER_ID_REC_TYPE INDEX BY BINARY_INTEGER;
473
474 -- sansatpa - created for marshalling - to update WO AOG status when material aog status changes.
478 ---------------------------------------------------------------------------------------------------------
475
476 ---------------------------------------------------------------------------------------------------------
477 -- SANSATPA:: Adding the following function for updating Work Order AOG Status
479 -----------------------
480 -- Define procedures --
481 -----------------------
482 -- Start of Comments --
483 --
484 -- Procedure name : UPDATE_WO_AOG_STATUS
485 -- Type : Private
486 -- Description : This procedure is called for updating Work Order AOG Status.
487 -- Pre-reqs :
488 --
489 -- Standard IN Parameters :
490 -- p_api_version NUMBER := 1.0
491 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
492 -- p_commit VARCHAR2 := FND_API.G_FALSE
493 --
494 -- Standard OUT Parameters :
495 -- x_return_status VARCHAR2 Required
496 -- x_msg_count NUMBER Required
497 -- x_msg_data VARCHAR2 Required
498 --
499 --
500 -- Procedure -- IN Parameters :
501 -- p_workorder_id_tbl WORKORDER_ID_TBL_TYPE, Required: The table of Work Order IDs and corresponding Object version Numbers
502 --
503 -- Procedure -- OUT Parameters :
504 --
505 -- End of Comments --
506 PROCEDURE UPDATE_WO_AOG_STATUS(
507 P_API_VERSION IN NUMBER := 1.0,
508 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
509 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
510 --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511 P_WORKORDER_ID_TBL IN WORKORDER_ID_TBL_TYPE,
512 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
513 X_MSG_COUNT OUT NOCOPY NUMBER,
514 X_MSG_DATA OUT NOCOPY varchar2 );
515
516 END AHL_PRD_WORKORDER_PVT;