1 PACKAGE AHL_VWP_VISITS_STAGES_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSTGS.pls 120.0.12020000.2 2012/12/07 14:52:32 sareepar ship $ */
3 -----------------------------------------------------------
4 -- PACKAGE
5 -- AHL_VWP_VISITS_STAGES_PVT
6 --
7 -- PURPOSE
8 -- This package specification is a Private API for managing
9 -- Planning --> Visit Work Package --> VISITS --> STAGES
10 -- related procedures in Complex Maintainance, Repair and Overhauling(CMRO).
11 --
12 -- It defines used pl/sql records and tables datatypes
13 --
14 -- Process_Visit (see below for specification)
15 -- Get_Visit_Details (see below for specification)
16 -- Create_Visit (see below for specification)
17 -- Copy_Visit (see below for specification)
18 -- Update_Visit (see below for specification)
19 -- Delete_Visit (see below for specification)
20 -- UMP_Visit_Info (see below for specification)
21 -- Close_Visit (see below for specification)
22 -- Get_Visit_STAGE_Number (see below for specification)
23 -- UPDATE_STAGES_HIERARICHY (see below for specification)
24 -- UPDATE_STG_RUL_HIERARCHY (see below for specification)
25 -- UPDATE_AS_STAGE_RULE_DEL (see below for specification)
26 -- VALIDATE_STAGE_DATES (see below for specification)
27 -- Compute_Stage_End_Date (see below for specification)
28 --
29 -- NOTES
30 --
31 --
32 -- HISTORY
33 -- 04-FEB-2004 ADHARIA POST 11.5.10 Created.
34 -----------------------------------------------------------
35
36 ---------------------------------------------------------------------
37 -- Define Record Types for record structures needed by the APIs --
38 ---------------------------------------------------------------------
39
40 -- Record type for visit stages
41 TYPE Visit_Stages_Rec_Type IS RECORD (
42 Stage_Id NUMBER,
43 Stage_Num NUMBER,
44 Stage_Name VARCHAR2(80):= NULL,
45 Duration NUMBER:= NULL,
46 Stage_Planned_Start_Time DATE:= NULL,
47 Stage_Planned_End_Time DATE:= NULL,
48 Stage_Actual_End_Time DATE:= NULL,
49
50 -- PRAKKUM :: 15/03/2011 :: VWPE :: START
51 STAGE_STATUS_CODE VARCHAR2(30) := NULL,
52 PREV_STAGE_NUM NUMBER := NULL,
53 EARLIEST_START_DATE DATE := NULL,
54 -- PRAKKUM :: 15/03/2011 :: VWPE :: END
55
56 OBJECT_VERSION_NUMBER NUMBER := NULL,
57
58 ATTRIBUTE_CATEGORY VARCHAR2(30) := NULL,
59 ATTRIBUTE1 VARCHAR2(150) := NULL,
60 ATTRIBUTE2 VARCHAR2(150) := NULL,
61 ATTRIBUTE3 VARCHAR2(150) := NULL,
62 ATTRIBUTE4 VARCHAR2(150) := NULL,
63 ATTRIBUTE5 VARCHAR2(150) := NULL,
64 ATTRIBUTE6 VARCHAR2(150) := NULL,
65 ATTRIBUTE7 VARCHAR2(150) := NULL,
66 ATTRIBUTE8 VARCHAR2(150) := NULL,
67 ATTRIBUTE9 VARCHAR2(150) := NULL,
68 ATTRIBUTE10 VARCHAR2(150) := NULL,
69 ATTRIBUTE11 VARCHAR2(150) := NULL,
70 ATTRIBUTE12 VARCHAR2(150) := NULL,
71 ATTRIBUTE13 VARCHAR2(150) := NULL,
72 ATTRIBUTE14 VARCHAR2(150) := NULL,
73 ATTRIBUTE15 VARCHAR2(150) := NULL
74 );
75
76 TYPE Visit_Stages_Times_Rec_Type IS RECORD (
77 STAGE_ID NUMBER := NULL, -- Id of the visit's task stage
78 Stage_Num NUMBER,
79 Stage_Name VARCHAR2(80):= NULL,
80 Duration NUMBER:= NULL,
81
82 stage_START_HOUR NUMBER := NULL, -- Normalized start hour for this stage (w.r.t visit)
83 stage_END_HOUR NUMBER := NULL, -- Normalized end hour for this stage
84 PLANNED_START_TIME DATE:= NULL,
85 Planned_End_Time DATE:= NULL,
86 Actual_End_Time DATE:= NULL
87 );
88
89 --VWPE :: tchimira :: 16-FEB -2011 :: start
90 --Record type for visit stage - stage type association.
91 TYPE Stage_Type_Assoc_Rec_Type IS RECORD (
92 STAGE_TYPE_ASSOC_ID NUMBER := NULL,
93 STAGE_ID NUMBER := NULL, -- Id of the visit's task stage
94 STAGE_TYPE_CODE VARCHAR2(30) := NULL,
95 DML_OPERATION VARCHAR2(1) := NULL
96 );
97
98 --Record type for stage rules.
99 TYPE Stage_Rule_Rec_Type IS RECORD (
100 OBJECT_STAGE_ID NUMBER := NULL,
101 SUBJECT_STAGE_ID NUMBER := NULL,
102 RELATION_TYPE VARCHAR2(30) := NULL
103 );
104 --VWPE :: tchimira :: 16-FEB -2011 :: end
105
106 --VWPE 12730539:: PRAKKUM :: 08-JUL-2011 :: start
107 -- Record type for visit stages
108 TYPE Stages_Updated_OVN_Rec_Type IS RECORD (
109 STAGE_ID NUMBER := NULL, -- Id of the visit's task stage
110 UPDATED_OBJ_VERSION_NO_COUNT NUMBER := 0
111 );
112 --VWPE 12730539:: PRAKKUM :: 08-JUL-2011 :: end
113
114 ---------------------------------------------
115 -- Define Table Type for Rwecords Structures --
116 ----------------------------------------------
117
118 -- Declare Visit table type for record
119 TYPE Visit_Stages_Tbl_Type IS TABLE OF Visit_Stages_Rec_Type
120 INDEX BY BINARY_INTEGER;
121
122
123 TYPE Visit_Stages_Times_Tbl_Type IS TABLE OF Visit_Stages_Times_Rec_Type
124 INDEX BY BINARY_INTEGER;
125
126 --VWPE :: tchimira :: 16-FEB -2011 :: start
127 -- Declare Visit stage - stage type association table type
128 TYPE Stage_Type_Assoc_Tbl_Type IS TABLE OF Stage_Type_Assoc_Rec_Type
129 INDEX BY BINARY_INTEGER;
130
131 -- Declare stage rule table type
132 TYPE Stage_Rule_Tbl_Type IS TABLE OF Stage_Rule_Rec_Type
133 INDEX BY BINARY_INTEGER;
134 --VWPE :: tchimira :: 16-FEB -2011 :: end
135
136 --VWPE 12730539:: PRAKKUM :: 08-JUL-2011 :: start
137 -- Declare visit stage object version number updated details type
138 TYPE Visit_Stages_OVN_Tbl_Type IS TABLE OF Stages_Updated_OVN_Rec_Type
139 INDEX BY BINARY_INTEGER;
140 --VWPE 12730539:: PRAKKUM :: 08-JUL-2011 :: end
141 -------------------------------------------------------------------
142 -- Declare Procedures --
143 -------------------------------------------------------------------
144
145 --------------------------------------------------------------------
146 -- Procedure Name : Update_Stages
147 -- Type : Public
148 -- Function : To update a visit stages related attributes to update the visit
149 -- Parameters :
150 --
151 -- Standard IN Parameters :
152 -- p_api_version IN NUMBER Required
153 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
154 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
155 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
157 -- p_module_type IN VARCHAR2 Default NULL.
158 --
159 -- Standard OUT Parameters :
160 -- x_return_status OUT VARCHAR2 Required
161 -- x_msg_count OUT NUMBER Required
162 -- x_msg_data OUT VARCHAR2 Required
163 --
164 -- Update_Stages Parameters:
165 -- p_visit_id IN NUMBER Required
166 -- p_x_Visit_Stages_tbl IN OUT AHL_VWP_VISITS_STAGES_PVT.Visit_Tbl_Type Required
167 -- p_x_stages_ovn_tbl IN OUT AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_OVN_Tbl_Type Optional
168 -- The table of visit records type for which Update operation is to be performed.
169 --
170 -- Version :
171 -- Initial Version 1.0
172 --------------------------------------------------------------------
173 PROCEDURE Update_Stages (
174 p_api_version IN NUMBER :=1.0,
175 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
176 p_commit IN VARCHAR2 := FND_API.g_false,
177 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
178 p_module_type IN VARCHAR2 := 'JSP',
179 p_visit_id IN NUMBER,
180 p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type,
181 p_x_stages_ovn_tbl IN OUT NOCOPY Visit_Stages_OVN_Tbl_Type,--VWPE 12730539:: PRAKKUM :: 08-JUL-2011
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2
185 );
186
187 ---------------------------------------------------------------------
188 -- Procedure name : Get_Stages_Details
189 -- Type : Public
190 -- Function : To get a visit stage details
191 -- Parameters :
192 --
193 -- Standard IN Parameters :
194 -- p_api_version IN NUMBER Required
195 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
196 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
197 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
198 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
199 -- p_module_type IN VARCHAR2 Default NULL.
200 --
201 -- Standard OUT Parameters :
202 -- x_return_status OUT VARCHAR2 Required
203 -- x_msg_count OUT NUMBER Required
204 -- x_msg_data OUT VARCHAR2 Required
205 --
206 -- Get_Visit_Details Parameters:
207 -- p_visit_id IN NUMBER Required
208 -- The visit id whose details are to be displayed
209 -- x_Visit_rec OUT AHL_VWP_VISITS_PVT.Visit_Rec_Type Required
210 -- The record of visit attributes whose details are to be displayed
211 --
212 -- Version :
213 -- Initial Version 1.0
214 -------------------------------------------------------------------
215 PROCEDURE Get_Stages_Details (
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
218 p_commit IN VARCHAR2 := Fnd_Api.g_false,
219 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
220 p_module_type IN VARCHAR2 := 'JSP',
221 p_visit_id IN NUMBER,
222 p_start_row IN NUMBER,
223 p_rows_per_page IN NUMBER,
224
225 x_Stages_Tbl OUT NOCOPY Visit_Stages_Tbl_Type,
226 x_row_count OUT NOCOPY NUMBER,
227
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2
231 );
232
233 --------------------------------------------------------------------
234 -- Procedure Name : Create_Stages
235 -- Type : Public
236 -- Function : To create a visit stages related attributes to update the visit
237 -- Parameters :
238 --
239 -- Standard IN Parameters :
240 -- p_api_version IN NUMBER Required
241 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
242 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
243 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
244 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
245 -- p_module_type IN VARCHAR2 Default NULL.
246 --
247 -- Standard OUT Parameters :
248 -- x_return_status OUT VARCHAR2 Required
249 -- x_msg_count OUT NUMBER Required
250 -- x_msg_data OUT VARCHAR2 Required
251 --
252 -- Process_Visit Parameters:
253 -- p_visit_id IN NUMBER Required
254 -- The visit id for which to create the stages
255 --
256 -- Version :
257 -- Initial Version 1.0
258 --------------------------------------------------------------------
259 PROCEDURE Create_Stages (
260 p_api_version IN NUMBER :=1.0,
261 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
262 p_commit IN VARCHAR2 := FND_API.g_false,
263 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
264 p_module_type IN VARCHAR2 := 'JSP',
265 p_visit_id IN NUMBER,
266 p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type, -- PRAKKUM :: 15/03/2011 :: VWPE
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2
270 );
271
272 --------------------------------------------------------------------
273 -- Procedure Name : Delete_Stages
274 -- Type : Public
275 -- Function : To delete selected stages from a visit.
276 -- Parameters :
277 --
278 -- Standard IN Parameters :
279 -- p_api_version IN NUMBER Required
280 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
281 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
282 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
283 -- p_module_type IN VARCHAR2 Default NULL.
284 --
285 -- Standard OUT Parameters :
286 -- x_return_status OUT VARCHAR2 Required
287 -- x_msg_count OUT NUMBER Required
288 -- x_msg_data OUT VARCHAR2 Required
289 --
290 -- Delete_Stages Parameters:
291 -- p_visit_id IN NUMBER Required
292 -- p_x_stages_tbl IN Visit_Stages_Tbl_Type Required
293 --------------------------------------------------------------------
294 PROCEDURE Delete_Stages (
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
297 p_commit IN VARCHAR2 := Fnd_Api.g_false,
298 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
299 p_module_type IN VARCHAR2 := 'JSP',
300 p_visit_id IN NUMBER,
301 p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type, -- PRAKKUM :: 15/03/2011 :: VWPE
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2
305 );
306
307 --------------------------------------------------------------------
308 -- Procedure Name : Delete_All_Stages
309 -- Type : Public
310 -- Function : To delete all stages of a visit ( Hard Delete).
311 -- Parameters :
312 --
313 -- Standard IN Parameters :
314 -- p_api_version IN NUMBER Required
315 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
316 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
317 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
318 -- p_module_type IN VARCHAR2 Default NULL.
319 --
320 -- Standard OUT Parameters :
321 -- x_return_status OUT VARCHAR2 Required
322 -- x_msg_count OUT NUMBER Required
323 -- x_msg_data OUT VARCHAR2 Required
324 --
325 -- Delete_All_Stages Parameters:
326 -- p_visit_id IN NUMBER Required
327 --------------------------------------------------------------------
328 PROCEDURE Delete_All_Stages (
329 p_api_version IN NUMBER,
330 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
331 p_commit IN VARCHAR2 := Fnd_Api.g_false,
335 p_visit_id IN NUMBER,
332 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
333 p_module_type IN VARCHAR2 := 'JSP',
334
336 x_return_status OUT NOCOPY VARCHAR2,
337 x_msg_count OUT NOCOPY NUMBER,
338 x_msg_data OUT NOCOPY VARCHAR2
339 );
340
341 --------------------------------------------------------------------
342 -- Procedure Name : Validate_stage_update
343 -- Type : Public
344 -- Function : To validate the update of task stages.
345 -- Parameters :
346 --
347 -- Standard IN Parameters :
348 -- p_api_version IN NUMBER Required
349 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
350 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
351 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
352 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
353 -- p_module_type IN VARCHAR2 Default NULL.
354 --
355 -- Standard OUT Parameters :
356 -- x_return_status OUT VARCHAR2 Required
357 -- x_msg_count OUT NUMBER Required
358 -- x_msg_data OUT VARCHAR2 Required
359 --
360 -- Process_Visit Parameters:
361 -- p_visit_id IN NUMBER Required
362 -- The visit id for which to create the stages
363 --
364 -- Version :
365 -- Initial Version 1.0
366 --------------------------------------------------------------------
367 PROCEDURE VALIDATE_STAGE_UPDATES(
368 p_api_version IN NUMBER,
369 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
370 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
371 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
372 p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
373 p_module_type IN VARCHAR2 := NULL,
374
375 p_visit_id IN NUMBER,
376 p_visit_task_id IN NUMBER,
377 p_stage_name IN VARCHAR2 := NULL, -- defaulted as u may pass id or num
378
379 x_stage_id OUT NOCOPY NUMBER ,
380 x_return_status OUT NOCOPY VARCHAR2,
381 x_msg_count OUT NOCOPY NUMBER,
382 x_msg_data OUT NOCOPY VARCHAR2
383 );
384
385 --------------------------------------------------------------------
386 -- Procedure name : Check_Stage_Name_Or_Id
387 -- Type : Private
388 -- Function : Stage Number to ID conversion
389 -- Parameters :
390 --
391 -- IN Parameters :
392 -- p_visit_id IN NUMBER
393 -- p_Stage_Num IN NUMBER
394
395
396 -- OUT Parameters :
397 -- x_Stage_id OUT NOCOPY NUMBER
398 -- x_return_status OUT NOCOPY VARCHAR2
399 -- x_error_msg_code OUT NOCOPY VARCHAR2
400
401 -- Version :
402 -- Initial Version 1.0
403 --------------------------------------------------------------------
404 PROCEDURE Check_Stage_Name_Or_Id
405 (p_visit_id IN NUMBER,
406 p_Stage_Name IN VARCHAR2,
407 x_Stage_id OUT NOCOPY NUMBER,
408 x_return_status OUT NOCOPY VARCHAR2,
409 x_error_msg_code OUT NOCOPY VARCHAR2
410 );
411
412 --VWPE :: tchimira :: 16-FEB -2011 :: start
413 --------------------------------------------------------------------
414 -- Procedure Name : Process_StageTyp_Assoc
415 -- Type : Public
416 -- Function : To create or delete associations between stage and stagetypes in a visit.
417 -- Parameters :
418 --
419 -- Standard IN Parameters :
420 -- p_api_version IN NUMBER Required
421 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
422 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
423 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
424 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
425 -- p_module_type IN VARCHAR2 Default NULL.
426 --
427 -- Standard OUT Parameters :
428 -- x_return_status OUT VARCHAR2 Required
429 -- x_msg_count OUT NUMBER Required
430 -- x_msg_data OUT VARCHAR2 Required
431 --
432 -- Process_Visit Parameters:
433 -- p_visit_id IN NUMBER Required
434 -- The visit id for which association has to be created/deleted.
435 -- p_stage_type_assoc_tbl IN Stage_Type_Assoc_Tbl_Type Required
436 -- The table of stage type-stage assoc records type for which DML operation is to be performed
437 --
438 -- Version :
439 -- Initial Version 1.0
440 --------------------------------------------------------------------
441 PROCEDURE Process_StageTyp_Assoc (
442 p_api_version IN NUMBER,
443 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
444 p_commit IN VARCHAR2 := Fnd_Api.g_false,
445 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
446 p_stage_type_assoc_tbl IN Stage_Type_Assoc_Tbl_Type,
447 x_return_status OUT NOCOPY VARCHAR2,
448 x_msg_count OUT NOCOPY NUMBER,
449 x_msg_data OUT NOCOPY VARCHAR2
450 );
451
455 -- Function : To validate stage rules
452 --------------------------------------------------------------------
453 -- Procedure Name : VALIDATE_STAGE_RULES
454 -- Type : Public
456 -- Parameters :
457 --
458 -- Standard OUT Parameters :
459 -- x_return_status OUT VARCHAR2 Required
460 -- x_msg_count OUT NUMBER Required
461 -- x_msg_data OUT VARCHAR2 Required
462 --
463 -- Process_Visit Parameters:
464 -- p_visit_id IN NUMBER Required
465 -- The visit id for which association has to be created/deleted.
466 -- p_stage_rule_tbl IN Stage_Rule_Tbl_Type Required
467 -- The table of stage rules type.
468 --
469 -- Version :
470 -- Initial Version 1.0
471 --------------------------------------------------------------------
472 PROCEDURE VALIDATE_STAGE_RULES(
473 p_stage_rule_rec IN Stage_Rule_Rec_Type,
474 x_return_status OUT NOCOPY VARCHAR2,
475 x_msg_count OUT NOCOPY NUMBER,
476 x_msg_data OUT NOCOPY VARCHAR2
477 );
478
479
480 ------------------------------------------------------------------------------------------
481 -- PROCEDURE
482 -- Assoc_VisitType_to_Visit
483 --
484 -- PURPOSE
485 -- To create stages and stage rules in a visit when visit type is associated to a visit.
486 ------------------------------------------------------------------------------------------
487 PROCEDURE Assoc_VisitType_to_Visit (
488 p_api_version IN NUMBER,
489 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
490 p_commit IN VARCHAR2 := Fnd_Api.g_false,
491 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
492 p_visit_id IN NUMBER,
493 p_visit_type_code IN VARCHAR2,
494 x_return_status OUT NOCOPY VARCHAR2,
495 x_msg_count OUT NOCOPY NUMBER,
496 x_msg_data OUT NOCOPY VARCHAR2
497 );
498
499
500 --VWPE :: tchimira :: 16-FEB -2011 :: end
501
502 -- PRAKKUM :: 15/03/2011 :: VWPE :: START
503 --------------------------------------------------------------------
504 -- Function name : Get_Visit_STAGE_Number
505 -- Type : Public
506 -- Purpose : To generate next stage number
507 -- Parameters :
508 --
509 -- Get_Visit_Stage_Number IN Parameters:
510 -- p_visit_id IN NUMBER Required,
511 --
512 -- Get_Visit_Stage_Number OUT Parameters:
513 -- x_Visit_stage_Number OUT NUMBER Required,
514 --
515 -- Version :
516 -- Initial Version 1.0
517 --------------------------------------------------------------------
518 FUNCTION Get_Visit_Stage_Number (p_visit_id IN NUMBER)
519 RETURN NUMBER;
520
521 --------------------------------------------------------------------
522 -- Procedure name : UPDATE_STAGES_HIERARICHY
523 -- Type : Public
524 -- Purpose : To recalculate planned start and end date of all stages of a visit considering duration as a base
525 -- Parameters :
526 --
527 -- Standard IN Parameters :
528 -- p_api_version IN NUMBER Required
529 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
530 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
531 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
532 -- p_module_type IN VARCHAR2 Default NULL.
533 --
534 -- Standard OUT Parameters :
535 -- x_return_status OUT VARCHAR2 Required
536 -- x_msg_count OUT NUMBER Required
537 -- x_msg_data OUT VARCHAR2 Required
538 --
539 -- UPDATE_STAGES_HIERARICHY Parameters:
540 -- p_visit_id IN NUMBER Required
541 --
542 -- Version :
543 -- Initial Version 1.0
544 --------------------------------------------------------------------
545 PROCEDURE UPDATE_STAGES_HIERARICHY (
546 p_api_version IN NUMBER,
547 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
548 p_commit IN VARCHAR2 := Fnd_Api.g_false,
549 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
550 p_module_type IN VARCHAR2 := 'JSP',
551 p_visit_id IN NUMBER,
552
553 x_return_status OUT NOCOPY VARCHAR2,
554 x_msg_count OUT NOCOPY NUMBER,
555 x_msg_data OUT NOCOPY VARCHAR2
556 );
557
558 --------------------------------------------------------------------
559 -- Procedure name : UPDATE_STG_RUL_HIERARCHY
560 -- Type : Public
561 -- Purpose : To recalculate planned start and end date of all successor stages of a stages that involve dependency considering duration as a base
562 -- Parameters :
563 --
564 -- Standard IN Parameters :
565 -- p_api_version IN NUMBER Required
566 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
567 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
568 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
569 -- p_module_type IN VARCHAR2 Default NULL.
570 --
571 -- Standard OUT Parameters :
572 -- x_return_status OUT VARCHAR2 Required
573 -- x_msg_count OUT NUMBER Required
577 -- p_stage_link_id IN NUMBER Required
574 -- x_msg_data OUT VARCHAR2 Required
575 --
576 -- UPDATE_STG_RUL_HIERARCHY Parameters:
578 -- p_visit_id IN NUMBER Required
579 --
580 -- Version :
581 -- Initial Version 1.0
582 --------------------------------------------------------------------
583 PROCEDURE UPDATE_STG_RUL_HIERARCHY (
584 p_api_version IN NUMBER,
585 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
586 p_commit IN VARCHAR2 := Fnd_Api.g_false,
587 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
588 p_module_type IN VARCHAR2 := 'JSP',
589 p_stage_link_id IN NUMBER,
590 p_visit_id IN NUMBER,
591 x_return_status OUT NOCOPY VARCHAR2,
592 x_msg_count OUT NOCOPY NUMBER,
593 x_msg_data OUT NOCOPY VARCHAR2
594 );
595
596 --------------------------------------------------------------------
597 -- Procedure name : UPDATE_AS_STAGE_RULE_DEL
598 -- Type : Public
599 -- Purpose : To recalculate planned start and end date of all successor stages of a stages that involve in dependency deletion considering duration as a base
600 -- Parameters :
601 --
602 -- Standard IN Parameters :
603 -- p_api_version IN NUMBER Required
604 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
605 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
606 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
607 -- p_module_type IN VARCHAR2 Default NULL.
608 --
609 -- Standard OUT Parameters :
610 -- x_return_status OUT VARCHAR2 Required
611 -- x_msg_count OUT NUMBER Required
612 -- x_msg_data OUT VARCHAR2 Required
613 --
614 -- UPDATE_AS_STAGE_RULE_DEL Parameters:
615 -- p_object_id IN NUMBER Required
616 -- p_subject_id IN NUMBER Required
617 -- p_relation_type IN VARCHAR2 Required
618 -- p_visit_id IN NUMBER Required
619 --
620 -- Version :
621 -- Initial Version 1.0
622 --------------------------------------------------------------------
623 PROCEDURE UPDATE_AS_STAGE_RULE_DEL (
624 p_api_version IN NUMBER,
625 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
626 p_commit IN VARCHAR2 := Fnd_Api.g_false,
627 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
628 p_module_type IN VARCHAR2 := 'JSP',
629
630 p_object_id IN NUMBER,
631 p_subject_id IN NUMBER,
632 p_relation_type IN VARCHAR2,
633
634 p_visit_id IN NUMBER,
635
636 x_return_status OUT NOCOPY VARCHAR2,
637 x_msg_count OUT NOCOPY NUMBER,
638 x_msg_data OUT NOCOPY VARCHAR2
639 );
640 -- PRAKKUM :: 15/03/2011 :: VWPE :: END
641
642 -- PRAKKUM :: 13-FEB-2011 :: Bug 13711800 :: START
643 --------------------------------------------------------------------
644 -- Procedure name : VALIDATE_STAGE_DATES
645 -- Type : Public
646 -- Purpose : To validate stage dates against visit dates
647 -- Parameters :
648 --
649 -- Standard OUT Parameters :
650 -- x_return_status OUT VARCHAR2 Required
651 -- x_msg_count OUT NUMBER Required
652 -- x_msg_data OUT VARCHAR2 Required
653 --
654 -- VALIDATE_STAGE_DATES Parameters:
655 -- p_visit_id IN NUMBER Required
656 --
657 -- Version :
658 -- Initial Version 1.0
659 --------------------------------------------------------------------
660 PROCEDURE VALIDATE_STAGE_DATES(
661 p_visit_id IN NUMBER,
662 x_return_status OUT NOCOPY VARCHAR2,
663 x_msg_count OUT NOCOPY NUMBER,
664 x_msg_data OUT NOCOPY VARCHAR2
665 );
666 -- PRAKKUM :: 13-FEB-2011 :: Bug 13711800 :: END
667
668
669 -- PRAKKUM :: 23-FEB-2011 :: Bug 13711800 :: START
670 --------------------------------------------------------------------
671 -- Procedure name : Compute_Stage_End_Date
672 -- Type : Public
673 -- Purpose : To calculate stage end date based on type of visit ( operational / normal visit)
674 -- Parameters :
675 --
676 -- Compute_Stage_End_Date Parameters:
677 -- p_visit_id IN NUMBER Required
678 -- p_is_operational_visit IN VARCHAR2 Optional
679 -- p_start_date IN DATE Required
680 -- p_dept_id IN NUMBER Required
681 -- p_duration IN NUMBER Required
682 --
683 -- Version :
684 -- Initial Version 1.0
685 --------------------------------------------------------------------
686 FUNCTION Compute_Stage_End_Date(
687 p_visit_id NUMBER,
688 p_is_operational_visit VARCHAR2,
689 p_start_date DATE,
690 p_dept_id NUMBER,
691 p_duration NUMBER)
692 RETURN DATE;
693 -- PRAKKUM :: 23-FEB-2011 :: Bug 13711800 :: END
694
695 END AHL_VWP_VISITS_STAGES_PVT;
696