1 PACKAGE AHL_VWP_PROJ_PROD_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPRDS.pls 120.7.12020000.2 2012/12/07 13:18:30 sareepar ship $ */
3 -----------------------------------------------------------
4 -- PACKAGE
5 -- AHL_VWP_PROJ_PROD_PVT
6 --
7 -- PURPOSE
8 -- This package specification is a Private API for managing
9 -- Planning --> Visit Work Package --> Visit's PROJECTS and Pushing to PRODUCTION
10 -- related procedures in Complex Maintainance, Repair and Overhauling(CMRO).
11 --
12 -- It contains specification for pl/sql records and tables
13 --
14 -- Integrate_to_Project (see below for specification)
15 -- Add_Task_to_Project (see below for specification)
16 -- Delete_Task_to_Project (see below for specification)
17 -- Create_Project (see below for specification)
18 -- Update_Project (see below for specification)
19 -- Delete_Project (see below for specification)
20 --
21 --
22 -- Validate_Before_Production (see below for specification)
23 -- Push_to_Production (see below for specification)
24 -- Create_Job_Tasks (see below for specification)
25 -- Release_Visit (see below for specification)
26 -- Release_MR (see below for specification)
27 -- Release_Tasks (see below for specification)
28 --
29 -- NOTES
30 --
31 --
32 -- HISTORY
33 -- 14-JAN-2003 SHBHANDA Created.
34 -----------------------------------------------------------
35
36 ---------------------------------------------------------------------
37 -- Define Record Types for record structures needed by the APIs --
38 ---------------------------------------------------------------------
39
40 -- Record for Error while Validating before pushing to Production
41 TYPE Error_Rec_Type IS RECORD (
42 Msg_Index NUMBER := NULL,
43 Msg_Data VARCHAR2(2000) := NULL
44 );
45
46 ---------------------------------------------
47 -- Define Table Type for Records Structures --
48 ----------------------------------------------
49
50 -- Declare Error table type for record record type
51 TYPE Error_Tbl_Type IS TABLE OF Error_Rec_Type
52 INDEX BY BINARY_INTEGER;
53
54 --Declare Task table type for task record type for create job tasks API
55 TYPE Task_Tbl_Type IS TABLE OF AHL_VWP_RULES_PVT.Task_Rec_Type
56 INDEX BY BINARY_INTEGER;
57
58 -----------------------------------------------------------------
59 -- Declare Procedures --
60 -------------------------------------------------------------------
61
62 -------------------------------------------------------------------
63 -- Procedure name : Integrate_to_Projects
64 -- Type : Private
65 -- Function : To create/update a project and its project tasks
66 -- for a Visit and its tasks in VWP
67 -- Parameters :
68 --
69 -- Standard IN Parameters :
70 -- p_api_version IN NUMBER Required
71 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
72 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
73 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
74 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
75 -- p_module_type IN VARCHAR2 Default NULL.
76 --
77 -- Standard OUT Parameters :
78 -- x_return_status OUT VARCHAR2 Required
79 -- x_msg_count OUT NUMBER Required
80 -- x_msg_data OUT VARCHAR2 Required
81 --
82 -- Integrate_to_Projects Parameters:
83 -- p_visit_id IN NUMBER Required
84 -- The visit id which is to be integrated for Projects
85 --
86 -- Version :
87 -- Initial Version 1.0
88 -------------------------------------------------------------------
89 PROCEDURE Integrate_to_Projects(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
92 p_commit IN VARCHAR2 := Fnd_Api.g_false,
93 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
94 p_module_type IN VARCHAR2 := Null,
95 p_visit_id IN NUMBER,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 -- PRAKKUM :: PIE :: 13-OCT-2010
102 -- Commented out this procedure as it is no longer in use
103 /*
104 -------------------------------------------------------------------
105 -- Procedure name : Add_Task_to_Project
106 -- Type : Private
107 -- Function : To add Project Task for non_routines jobs when task is created in VWP
108 -- Parameters :
109 --
110 -- Standard IN Parameters :
111 -- p_api_version IN NUMBER Required
112 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
114 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
115 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
116 -- p_module_type IN VARCHAR2 Default NULL.
117 --
118 -- Standard OUT Parameters :
119 -- x_return_status OUT VARCHAR2 Required
120 -- x_msg_count OUT NUMBER Required
121 -- x_msg_data OUT VARCHAR2 Required
122 --
123 -- Add_Task_to_Project Parameters:
124 -- p_visit_task_id IN NUMBER Required
125 -- The visit task id which is integrated to Add tasks to Projects
126 --
127 -- Version :
128 -- Initial Version 1.0
129 -------------------------------------------------------------------
130 PROCEDURE Add_Task_to_Project(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
133 p_commit IN VARCHAR2 := Fnd_Api.g_false,
134 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
135 p_module_type IN VARCHAR2 := Null,
136 p_visit_task_id IN NUMBER,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141 */
142 -------------------------------------------------------------------
143 -- Procedure name : Delete_Task_to_Project
144 -- Type : Private
145 -- Function : To Delete Project Tasks when tasks in VWP is created
146 -- Parameters :
147 --
148 -- Standard IN Parameters :
149 -- p_api_version IN NUMBER Required
150 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
151 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
152 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
153 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
154 -- p_module_type IN VARCHAR2 Default NULL.
155 --
156 -- Standard OUT Parameters :
157 -- x_return_status OUT VARCHAR2 Required
158 -- x_msg_count OUT NUMBER Required
159 -- x_msg_data OUT VARCHAR2 Required
160 --
161 -- Delete_Task_to_Project Parameters:
162 -- p_visit_task_id IN NUMBER Required
163 -- The visit task id which is integrated to Delete tasks to Projects
164 --
165 -- Version :
166 -- Initial Version 1.0
167 -------------------------------------------------------------------
168 PROCEDURE Delete_Task_to_Project(
169 p_visit_task_id IN NUMBER,
170 x_return_status OUT NOCOPY VARCHAR2
171 );
172
173 -------------------------------------------------------------------
174 -- Procedure name : Update_Project
175 -- Type : Private
176 -- Function : To update Project status to CLOSED when visit is set as Closed/Canceled OR
177 -- To call update when the project created is again pushed to projects.
178 -- Parameters :
179 --
180 -- Standard IN Parameters :
181 -- p_api_version IN NUMBER Required
182 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
183 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
184 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
185 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
186 -- p_module_type IN VARCHAR2 Default NULL.
187 --
188 -- Standard OUT Parameters :
189 -- x_return_status OUT VARCHAR2 Required
190 -- x_msg_count OUT NUMBER Required
191 -- x_msg_data OUT VARCHAR2 Required
192 --
193 -- Update_Project Parameters:
194 -- p_visit_id IN NUMBER Required
195 -- The visit id which is integrated to Update Projects
196 --
197 -- Version :
198 -- Initial Version 1.0
199 -------------------------------------------------------------------
200
201 PROCEDURE Update_Project(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
204 p_commit IN VARCHAR2 := Fnd_Api.g_false,
205 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
206 p_module_type IN VARCHAR2 := Null,
207 p_visit_id IN NUMBER,
208
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2
212 );
213
214 -------------------------------------------------------------------
215 -- Procedure name : Delete_Project
216 -- Type : Private
217 -- Function : To delete a Project when a Visit is deleted
218 -- Parameters :
219 --
220 -- Standard IN Parameters :
221 -- p_api_version IN NUMBER Required
222 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
223 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
224 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
225 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
226 -- p_module_type IN VARCHAR2 Default NULL.
227 --
228 -- Standard OUT Parameters :
229 -- x_return_status OUT VARCHAR2 Required
230 -- x_msg_count OUT NUMBER Required
231 -- x_msg_data OUT VARCHAR2 Required
232 --
233 -- Delete_Project Parameters:
234 -- p_visit_id IN NUMBER Required
235 -- The visit id which is to be integrated to Delete Projects
236 --
237 -- Version :
238 -- Initial Version 1.0
239 -------------------------------------------------------------------
240 PROCEDURE Delete_Project(
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
243 p_commit IN VARCHAR2 := Fnd_Api.g_false,
244 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
245 p_module_type IN VARCHAR2 := Null,
246 p_visit_id IN NUMBER,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2
250 );
251
252 --------------------------------------------------------
253 -- Procedure name : Validate_Before_Production
254 -- Type : Private
255 -- Function : To create unassociated task for a visit
256 -- Parameters :
257 --
258 -- Standard IN Parameters :
259 -- p_api_version IN NUMBER Required
260 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
261 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
262 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
263 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
264 -- p_module_type IN VARCHAR2 Default NULL.
265 --
266 -- Standard OUT Parameters :
267 -- x_return_status OUT VARCHAR2 Required
268 -- x_msg_count OUT NUMBER Required
269 -- x_msg_data OUT VARCHAR2 Required
270 --
271 -- Validate_Before_Production Parameters:
272 -- x_visit_id IN NUMBER Required
273 -- The visit id which is to be validated before pushing to production.
274 --
275 -- Version :
276 -- Initial Version 1.0
277 -------------------------------------------------------------------
278 PROCEDURE Validate_Before_Production
279 (p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
281 p_commit IN VARCHAR2 := Fnd_Api.g_false,
282 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
283 p_module_type IN VARCHAR2 := 'JSP',
284 p_visit_id IN NUMBER,
285 x_error_tbl OUT NOCOPY error_tbl_type,
286 x_return_status OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_msg_data OUT NOCOPY VARCHAR2
289 );
290
291
292 -------------------------------------------------------------------
293 -- Procedure name : Create_Job_Tasks
294 -- Type : Private
295 -- Function : To Add Tasks for non_routines jobs
296 -- Parameters :
297 --
298 -- Standard IN Parameters :
299 -- p_api_version IN NUMBER Required
300 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
301 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
302 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
303 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
304 -- p_module_type IN VARCHAR2 Default NULL.
305 --
306 -- Standard OUT Parameters :
307 -- x_return_status OUT VARCHAR2 Required
308 -- x_msg_count OUT NUMBER Required
309 -- x_msg_data OUT VARCHAR2 Required
310 --
311 -- Create_Job_Tasks Parameters:
312 -- p_x_task_Tbl IN OUT Task_Tbl_Type Required,
313 -- The table of task records for which non-routine jobs are created.
314 --
315 -- Version :
316 -- Initial Version 1.0
317 -------------------------------------------------------------------
318 PROCEDURE Create_Job_Tasks(
319 p_api_version IN NUMBER :=1.0,
320 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
321 p_commit IN VARCHAR2 := Fnd_Api.g_false,
322 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
323 p_module_type IN VARCHAR2 := Null,
324 p_x_task_Tbl IN OUT NOCOPY Task_Tbl_Type,
325 x_return_status OUT NOCOPY VARCHAR2,
326 x_msg_count OUT NOCOPY NUMBER,
327 x_msg_data OUT NOCOPY VARCHAR2
328 );
329
330 -- Start of Comments --
331 -- Procedure name : Release_Visit
332 -- Type : Private
333 -- Function :To Validate before pushing visit and its tasks to production
334 -- Pre-reqs :
335 -- Parameters :
336 --
337 -- Standard IN Parameters :
338 -- p_api_version IN NUMBER Required
339 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
340 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
341 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
342 --
343 -- Standard OUT Parameters :
344 -- x_return_status OUT VARCHAR2 Required
345 -- x_msg_count OUT NUMBER Required
346 -- x_msg_data OUT VARCHAR2 Required
347 --
348 -- Release visit Parameters:
349 -- p_visit_id IN NUMBER Required
350 -- p_release_flag IN VARCHAR2 Required
351 --
352 -- Version :
353 -- 09/09/2003 SSURAPAN Initial Creation
354 --
355 -- End of Comments.
356 --
357 PROCEDURE Release_Visit (
358 p_api_version IN NUMBER,
359 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
360 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
361 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
362 p_module_type IN VARCHAR2 := NULL,
363 p_visit_id IN NUMBER,
364 p_release_flag IN VARCHAR2 := 'N',
365 p_orig_visit_id IN NUMBER := NULL, -- By yazhou 08/06/04 for TC changes
366 x_return_status OUT NOCOPY VARCHAR2,
367 x_msg_count OUT NOCOPY NUMBER,
368 x_msg_data OUT NOCOPY VARCHAR2
369 );
370
371 --TCHIMIRA::P2P CP ER 9151144::02-DEC-2009::BEGIN
372 -------------------------------------------------------------------
373 -- Procedure name : BG_Release_visit
374 -- Type : Private
375 -- Function : To launch background p2p
376 -- Parameters :
377
378 -- Standard IN Parameters :
379 -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
380 --
381 -- Standard OUT Parameters :
382 -- x_return_status OUT VARCHAR2 Required
383 -- x_msg_count OUT NUMBER Required
384 -- x_msg_data OUT VARCHAR2 Required
385
386 -- BG_Release_visit Parameters :
387 -- p_visit_id IN NUMBER Required
388 -- visit id is required to get visit number and passed to concurrent program
389 -- p_release_flag IN VARCHAR2 Required
390 -- This is passed to concurrent program as an argument
391 -- x_request_id OUT NUMBER Required
392 -- Stores request id that is passed from concurrent program
393
394 -- Version :
395 -- 02 Dec, 2009 P2P CP ER 9151144 TCHIMIRA Initial Version - 1.0
396 -------------------------------------------------------------------
397 PROCEDURE BG_Release_visit(
398 p_api_version IN NUMBER,
399 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
400 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
401 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
402 p_module_type IN VARCHAR2 := NULL,
403 p_visit_id IN NUMBER,
404 p_release_flag IN VARCHAR2 := 'U',
405 x_request_id OUT NOCOPY NUMBER,
406 x_return_status OUT NOCOPY VARCHAR2,
407 x_msg_count OUT NOCOPY NUMBER,
408 x_msg_data OUT NOCOPY VARCHAR2
409 ) ;
410
411 -------------------------------------------------------------------
412 -- Procedure name : BG_Push_to_Production
413 -- Type : Private
414 -- Function : Made as an executable for the P2P CP
415 -- BG_Push_to_Production Parameters :
416 -- p_visit_number IN NUMBER
417 -- errbuf OUT VARCHAR2 Required
418 -- Defines in pl/sql to store procedure to get error messages into log file
419 -- retcode OUT NUMBER Required
420 -- To get the status of the concurrent program
421
422 -- Version :
423 -- 02 Dec, 2009 P2P CP ER 9151144 TCHIMIRA Initial Version - 1.0
424 -------------------------------------------------------------------
425 PROCEDURE BG_Push_to_Production(
426 errbuf OUT NOCOPY VARCHAR2,
427 retcode OUT NOCOPY NUMBER,
428 p_api_version IN NUMBER,
429 p_visit_number IN NUMBER,
430 p_release_flag IN VARCHAR2 := 'U',
431 -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: Added a new parameter
432 p_caller IN VARCHAR2 := NULL
433 );
434
435 --TCHIMIRA::P2P CP ER 9151144::02-DEC-2009::END
436
437 -- Start of Comments --
438 -- Procedure name : Release_MR
439 -- Type : Private
440 -- Function :To release all MRs associated to a given UE and return
441 -- workorder ID for the root task. Requested by MEL/CDL.
442 -- Pre-reqs :
443 -- Parameters :
444 --
445 -- Standard IN Parameters :
446 -- p_api_version IN NUMBER Required
447 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
448 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
449 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
450 --
451 -- Standard OUT Parameters :
452 -- x_return_status OUT VARCHAR2 Required
453 -- x_msg_count OUT NUMBER Required
454 -- x_msg_data OUT VARCHAR2 Required
455 -- x_workorder_id OUT NUMBER Required
456 --
457 -- Release visit Parameters:
458 -- p_visit_id IN NUMBER Required
459 -- p_unit_effectivity_id IN NUMBER Required
460 -- p_release_flag IN VARCHAR2 optional
461 -- p_recalculate_dates IN VARCHAR2 Optional (default 'Y', Added for bug 8343599)
462 --
463 -- Version :
464 -- 07/21/2005 YAZHOU Initial Creation
465 --
466 -- End of Comments.
467 --
468 PROCEDURE Release_MR (
469 p_api_version IN NUMBER,
470 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
471 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
472 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
473 p_module_type IN VARCHAR2 := NULL,
474 p_visit_id IN NUMBER,
475 p_unit_effectivity_id IN NUMBER,
476 p_release_flag IN VARCHAR2 := 'N',
477 -- SKPATHAK :: Bug 8343599 :: 14-APR-2009
478 -- Added an optional parameter to prevent date recalculation
479 p_recalculate_dates IN VARCHAR2 := 'Y',
480 --TCHIMIRA::ER 9368251 ::15-JUN-2010 :: Added to include firm-planned flag(1 is Firm and 2 is Planned)as entered by user
481 p_firm_planned_flag IN NUMBER,
482 x_workorder_id OUT NOCOPY NUMBER,
483 x_return_status OUT NOCOPY VARCHAR2,
484 x_msg_count OUT NOCOPY NUMBER,
485 x_msg_data OUT NOCOPY VARCHAR2
486 );
487
488 -- Start of Comments --
489 -- Procedure name : Release_Tasks
490 -- Type : Private
491 -- Function : Validate the tasks and then prush tasks to production
492 -- Pre-reqs :
493 -- Parameters :
494 --
495 -- Standard IN Parameters :
496 -- p_api_version IN NUMBER Required
497 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
498 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
499 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
500 -- p_module_type IN VARCHAR2 Default Null
501 --
502 -- Standard OUT Parameters :
503 -- x_return_status OUT VARCHAR2 Required
504 -- x_msg_count OUT NUMBER Required
505 -- x_msg_data OUT VARCHAR2 Required
506 --
507 -- Release_Tasks Parameters:
508 -- p_visit_id IN NUMBER Required
509 -- p_release_flag IN VARCHAR2 Default 'N'
510 -- p_tasks_tbl IN Task_Tbl_Type Required
511 --
512 -- Version :
513 -- 30 November, 2007 RNAHATA Initial Creation
514 -- End of Comments.
515 --
516 PROCEDURE Release_Tasks(
517 p_api_version IN NUMBER,
518 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
519 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
520 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
521 p_module_type IN VARCHAR2 := Null,
522 p_visit_id IN NUMBER,
523 p_tasks_tbl IN Task_Tbl_Type,
524 p_release_flag IN VARCHAR2 := 'N',
525 x_return_status OUT NOCOPY VARCHAR2,
526 x_msg_count OUT NOCOPY NUMBER,
527 x_msg_data OUT NOCOPY VARCHAR2
528 );
529
530 -- PRAKKUM :: FP:PIE :: 13-OCT-2010 :: START
531 -- Added new procedures
532 -------------------------------------------------------------------
533 -- Procedure name : Update_Project_Task
534 -- Type : Private
535 -- Function : To update the project tasks hierarchy
536 -- whenever visit task's cost parent is updated.
537 -- Parameters :
538 -- Update_Project_Task_Times Parameters
539 -- p_task_id IN NUMBER Required
540 --
541 -- Standard OUT Parameters :
542 -- x_return_status OUT VARCHAR2 Required
543 -- x_msg_count OUT NUMBER Required
544 -- x_msg_data OUT VARCHAR2 Required
545 --
546 -- Version :
547 -------------------------------------------------------------------
548 PROCEDURE Update_Project_Task(
549 p_task_id IN NUMBER,
550 x_return_status OUT NOCOPY VARCHAR2,
551 x_msg_count OUT NOCOPY NUMBER,
552 x_msg_data OUT NOCOPY VARCHAR2
553 );
554
555 -------------------------------------------------------------------
556 -- Procedure name : Update_Project_Task_Times
557 -- Type : Private
558 -- Function : Update the project task start/end dates
559 -- with the workorder schedule start/end dates
560 -- Parameters :
561 -- Standard IN Parameters :
562 -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
563 --
564 -- Update_Project_Task_Times Parameters :
565 -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required
566 --
567 -- Standard OUT Parameters :
568 -- x_return_status OUT VARCHAR2 Required
569 -- x_msg_count OUT NUMBER Required
570 -- x_msg_data OUT VARCHAR2 Required
571 --
572 -- Version :
573 -------------------------------------------------------------------
574
575 PROCEDURE Update_Project_Task_Times
576 ( p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL,
577 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
578 x_return_status OUT NOCOPY VARCHAR2,
579 x_msg_count OUT NOCOPY NUMBER,
580 x_msg_data OUT NOCOPY VARCHAR2
581 ) ;
582 -------------------------------------------------------------------
583 -- Procedure name : Use_New_Task_Structure
584 -- Type : Private
585 -- Function : To determine whether the new structure should be used for
586 -- the project tasks. It is a helper function that will be
587 -- used by other APIs in this package.
588 -- Version :
589
590 -------------------------------------------------------------------
591 PROCEDURE Use_New_Task_Structure
592 ( p_visit_id IN NUMBER,
593 x_new_structure_flag OUT NOCOPY VARCHAR2
594 ) ;
595 -- PRAKKUM :: FP:PIE :: 13-OCT-2010 :: END
596
597 -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: STARTS
598 -------------------------------------------------------------------
599 -- Procedure name : Push_stages_to_production
600 -- Type : Private
601 -- Function : Push the selected stages to production.
602 -- Parameters :
603 --
604 -- Standard IN Parameters :
605 -- p_api_version IN NUMBER Required
606 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
607 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
608 -- p_module_type IN VARCHAR2 Default Null
609 --
610 -- Standard OUT Parameters :
611 -- x_return_status OUT VARCHAR2 Required
612 -- x_msg_count OUT NUMBER Required
613 -- x_msg_data OUT VARCHAR2 Required
614 --
615 -- Push_tasks_to_production Parameters:
616 -- p_visit_id IN NUMBER Required
617 -- p_stages_tbl IN Task_Tbl_Type Required
618 -- p_release_flag IN VARCHAR2 Default = 'N'
619 --
620 -------------------------------------------------------------------
621
622 PROCEDURE Push_stages_to_production(
623 p_api_version IN NUMBER,
624 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
625 p_commit IN VARCHAR2 := FND_API.G_FALSE,
626 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
627 p_module_type IN VARCHAR2 := Null,
628 p_visit_id IN NUMBER,
629 p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,
630 p_release_flag IN VARCHAR2 ,
631 x_return_status OUT NOCOPY VARCHAR2,
632 x_msg_count OUT NOCOPY NUMBER,
633 x_msg_data OUT NOCOPY VARCHAR2
634 ) ;
635
636 -------------------------------------------------------------------
637 -- Procedure name : Plan_visit
638 -- Type : Private
639 -- Function : Procedure to plan a visit i.e. to move the visit from draft to planning status
640 -- Parameters :
641 --
642 -- Standard IN Parameters :
643 -- p_api_version IN NUMBER Required
644 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
645 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
646 -- p_caller IN VARCHAR2 Default Null
647 --
648 -- Standard OUT Parameters :
649 -- x_return_status OUT VARCHAR2 Required
650 -- x_msg_count OUT NUMBER Required
651 -- x_msg_data OUT VARCHAR2 Required
652 --
653 -- plan_visit Parameters:
654 -- p_visit_id IN NUMBER Required
655 --
656 -------------------------------------------------------------------
657
658 PROCEDURE plan_visit(
659 p_api_version IN NUMBER := 1.0,
660 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661 p_commit IN VARCHAR2 := FND_API.G_FALSE,
662 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
663 p_caller IN VARCHAR2 := NULL,
664 p_visit_id IN NUMBER,
665 x_return_status OUT NOCOPY VARCHAR2,
666 x_msg_count OUT NOCOPY NUMBER,
667 x_msg_data OUT NOCOPY VARCHAR2);
668
669 -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: ENDS
670
671
672 --------------------------------------------------------------------
673 -- Function name : Get_RB_Transaction_Task
674 -- Type : Public
675 -- Purpose : Fetches project transaction task id through given
676 -- given repair batch task id and project id
677 --
678 -- Parameters :
679 -- p_project_id IN NUMBER Required
680 -- p_repair_batch_task_id IN NUMBER Required
681 -- p_visit_id IN NUMBER Required
682 --
683 -- Version :
684 -- 12 June, 2012 PRAKKUM Initial Version - 1.0
685 --
686 -- Added for Bug 14068468
687 --------------------------------------------------------------------
688
689 FUNCTION Get_RB_Transaction_Task(
690 p_project_id IN NUMBER,
691 p_repair_batch_task_id IN NUMBER,
692 p_visit_id IN NUMBER)
693 RETURN NUMBER;
694
695
696 END AHL_VWP_PROJ_PROD_PVT;
[Home] [Help]