[Home] [Help]
PACKAGE: APPS.AHL_VWP_VISITS_PVT
Source
1 PACKAGE AHL_VWP_VISITS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVVSTS.pls 120.6.12020000.2 2012/12/11 05:38:29 prakkum ship $ */
3 -----------------------------------------------------------
4 -- PACKAGE
5 -- Ahl_VWP_Visit_Pvt
6 --
7 -- PURPOSE
8 -- This package specification is a Private API for managing
9 -- Planning --> Visit Work Package --> VISITS
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 -- Update_Visit (see below for specification)
18 -- Delete_Visit (see below for specification)
19 -- Close_Visit (see below for specification)
20 -- Is_Old_Visit (see below for specification)
21 --
22 -- NOTES
23 --
24 --
25 -- HISTORY
26 -- 29-APR-2002 SHBHANDA 11.5.9 Created.
27 -- 06-AUG-2003 SHBHANDA 11.5.10 Changes.
28 -- 23-JUN-2011 PRAKKUM Added new method VWPE: ER:12730539
29 -----------------------------------------------------------
30
31 ---------------------------------------------------------------------
32 -- Define Record Types for record structures needed by the APIs --
33 ---------------------------------------------------------------------
34
35 -- Record type for visits
36 TYPE Visit_Rec_Type IS RECORD (
37 VISIT_ID NUMBER := NULL,
38 VISIT_NAME VARCHAR2(80) := NULL,
39 VISIT_NUMBER NUMBER := NULL,
40
41 OBJECT_VERSION_NUMBER NUMBER := NULL,
42 LAST_UPDATE_DATE DATE := NULL,
43 LAST_UPDATED_BY NUMBER := NULL,
44 CREATION_DATE DATE := NULL,
45 CREATED_BY NUMBER := NULL,
46 LAST_UPDATE_LOGIN NUMBER := NULL,
47
48 ORGANIZATION_ID NUMBER := NULL,
49 ORG_NAME VARCHAR2(240) := NULL,
50
51 DEPARTMENT_ID NUMBER := NULL,
52 DEPT_NAME VARCHAR2(240) := NULL,
53
54 SERVICE_REQUEST_ID NUMBER := NULL,
55 SERVICE_REQUEST_NUMBER VARCHAR2(80) := NULL,
56
57 SPACE_CATEGORY_CODE VARCHAR2(30) := NULL,
58 SPACE_CATEGORY_NAME VARCHAR2(80) := NULL,
59
60 START_DATE DATE := NULL,
61 START_HOUR NUMBER := NULL,
62 START_MIN NUMBER := NULL,
63
64 PLAN_END_DATE DATE := NULL,
65 PLAN_END_HOUR NUMBER := NULL,
66 PLAN_END_MIN NUMBER := NULL,
67
68 END_DATE DATE := NULL,
69 DUE_BY_DATE DATE := NULL,
70
71 VISIT_TYPE_CODE VARCHAR2(30) := NULL,
72 VISIT_TYPE_NAME VARCHAR2(80) := NULL,
73
74 STATUS_CODE VARCHAR2(30) := NULL,
75 STATUS_NAME VARCHAR2(80) := NULL,
76
77 SIMULATION_PLAN_ID NUMBER := NULL,
78 SIMULATION_PLAN_NAME VARCHAR2(80) := NULL,
79
80 ASSO_PRIMARY_VISIT_ID NUMBER := NULL,
81
82 UNIT_NAME VARCHAR2(80) := NULL,
83 ITEM_INSTANCE_ID NUMBER := NULL,
84 SERIAL_NUMBER VARCHAR2(30) := NULL,
85
86 INVENTORY_ITEM_ID NUMBER := NULL,
87 ITEM_ORGANIZATION_ID NUMBER := NULL,
88 ITEM_NAME VARCHAR2(40) := NULL,
89
90 SIMULATION_DELETE_FLAG VARCHAR2(1) := NULL,
91 TEMPLATE_FLAG VARCHAR2(1) := NULL,
92 OUT_OF_SYNC_FLAG VARCHAR2(1) := NULL,
93
94 PROJECT_FLAG VARCHAR2(30) := NULL,
95 PROJECT_FLAG_CODE VARCHAR2(30) := NULL,
96
97 PROJECT_ID NUMBER := NULL,
98 PROJECT_NUMBER NUMBER := NULL,
99
100 DESCRIPTION VARCHAR2(4000) := NULL,
101 DURATION NUMBER := NULL,
102
103 ATTRIBUTE_CATEGORY VARCHAR2(30) := NULL,
104 ATTRIBUTE1 VARCHAR2(150) := NULL,
105 ATTRIBUTE2 VARCHAR2(150) := NULL,
106 ATTRIBUTE3 VARCHAR2(150) := NULL,
107 ATTRIBUTE4 VARCHAR2(150) := NULL,
108 ATTRIBUTE5 VARCHAR2(150) := NULL,
109 ATTRIBUTE6 VARCHAR2(150) := NULL,
110 ATTRIBUTE7 VARCHAR2(150) := NULL,
111 ATTRIBUTE8 VARCHAR2(150) := NULL,
112 ATTRIBUTE9 VARCHAR2(150) := NULL,
113 ATTRIBUTE10 VARCHAR2(150) := NULL,
114 ATTRIBUTE11 VARCHAR2(150) := NULL,
115 ATTRIBUTE12 VARCHAR2(150) := NULL,
116 ATTRIBUTE13 VARCHAR2(150) := NULL,
117 ATTRIBUTE14 VARCHAR2(150) := NULL,
118 ATTRIBUTE15 VARCHAR2(150) := NULL,
119 OPERATION_FLAG VARCHAR2(1) := NULL,
120 OUTSIDE_PARTY_FLAG VARCHAR2(1) := NULL,
121 JOB_NUMBER VARCHAR2(255) := NULL,
122
123 -- Post 11.5.10 Enhancements
124 -- Added Priority and Project Template
125 PROJ_TEMPLATE_NAME VARCHAR2(30) := NULL,
126 PROJ_TEMPLATE_ID NUMBER := NULL,
127 PRIORITY_VALUE VARCHAR2(80) := NULL,
128 PRIORITY_CODE VARCHAR2(30) := NULL,
129 -- For Transit Check
130 UNIT_SCHEDULE_ID NUMBER := NULL,
131 VISIT_CREATE_TYPE VARCHAR2(30) := NULL,
132 VISIT_CREATE_MEANING VARCHAR2(80) := NULL,
133 UNIT_HEADER_ID NUMBER := NULL,
134
135 --Arvind Rupakula - Flight Number changes
136 FLIGHT_NUMBER VARCHAR2(30) := NULL,
137 --End
138
139 -- PRAKKUM :: PIE :: 20-OCT-2010
140 -- Added two new attributes project_name and top_project_task_id
141 PROJECT_NAME VARCHAR2(30) := NULL,
142 TOP_PROJECT_TASK_ID NUMBER := NULL,
143
144
145 /*Added by sowsubra */
146 SUBINVENTORY VARCHAR2(10) := NULL,
147 LOCATOR_SEGMENT VARCHAR2(240) := NULL,
148 INV_LOCATOR_ID NUMBER := NULL,
149
150 --TCHIMIRA::P2P CP ER 9151144::02-DEC-2009
151 --Added four columns
152 CP_REQUEST_ID NUMBER :=NULL,
153 CP_PHASE_CODE VARCHAR2(80) :=NULL,
154 CP_STATUS_CODE VARCHAR2(80) :=NULL,
155 CP_REQUEST_DATE DATE :=NULL,
156
157 --SKPATHAK :: 19-MAY-2010 :: Enigma Job Card Changes
158 JC_EXIST VARCHAR2(10) :=NULL,
159 VIEW_JC_URL VARCHAR2(2000) :=NULL,
160 JC_GEN_STATUS VARCHAR2(30) :=NULL,
161 JC_GEN_ERROR_TEXT VARCHAR2(4000) :=NULL,
162 --VWPE ER-12424063:: tchimira :: 15-FEB -2011 :: start
163 PAST_DATED_VISIT_FLAG VARCHAR2(1) := NULL,
164 LOCKED_FLAG VARCHAR2(1) := NULL,
165 FIRMED_FLAG VARCHAR2(1) := NULL,
166 --VWPE ER-12424063:: tchimira :: 15-FEB -2011 :: end
167 TASKS_OVN_UPDATED_COUNT NUMBER := NULL, --VWPE :: prakkum :: 08-APR-2011
168 STAGES_OVN_UPDATED_COUNT NUMBER := NULL, --VWPE ER 12730539 :: prakkum :: 06-JUL-2011
169
170 -- SATHAPLI::Component Maintenance Planning Project, 27-Oct-2011
171 -- Add columns for Planning and In-Repair locators
172 COMP_PLANNING_SUBINV VARCHAR2(10) := NULL,
173 COMP_PLANNING_LOC_SEG VARCHAR2(240) := NULL,
174 COMP_PLANNING_LOC_ID NUMBER := NULL,
175 COMP_INREPAIR_SUBINV VARCHAR2(10) := NULL,
176 COMP_INREPAIR_LOC_SEG VARCHAR2(240) := NULL,
177 COMP_INREPAIR_LOC_ID NUMBER := NULL,
178
179 -- ARUNJK Added Columns for Marshalling
180 ITEM_OWNER_FLAG VARCHAR2(1) := NULL,
181
182 --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
183 -- added below column to support same org for arrival and departing organization of a flight schedule
184 AUTO_VISIT_TYPE_FLAG VARCHAR2(1) := NULL
185 );
186
187 -- Record for UMP Requirement
188 TYPE Srch_UMP_Rec_Type IS RECORD (
189 ASSIGN_STATUS_MEANING VARCHAR2(80) := NULL,
190 ASSIGN_STATUS_CODE VARCHAR2(30) := NULL,
191 VISIT_NUMBER_MEANING VARCHAR2(80) := NULL,
192 VISIT_NUMBER_CODE VARCHAR2(30) := NULL,
193 VISIT_STATUS_MEANING VARCHAR2(80) := NULL,
194 VISIT_STATUS_CODE VARCHAR2(30) := NULL,
195 VISIT_START_DATE DATE := NULL,
196 VISIT_END_DATE DATE := NULL
197 );
198
199 -- Record for Error while Validating before cancelling the Visit.
200 -- Post 11.5.10
201 -- Reema Start
202 TYPE Error_Rec_Type IS RECORD (
203 JOB_ID NUMBER := NULL,
204 JOB_NUMBER VARCHAR2(40) := NULL,
205 SERVICE_REQUEST VARCHAR2(64) := NULL,
206 TASK_NUMBER VARCHAR2(80) := NULL,
207 PRIORITY VARCHAR2(80) := NULL,
208 SCHEDULED_START_DATE DATE := NULL,
209 SCHEDULED_END_DATE DATE := NULL,
210 JOB_STATUS VARCHAR2(80) := NULL
211 );
212 -- Reema End
213
214 ---------------------------------------------
215 -- Define Table Type for Records Structures --
216 ----------------------------------------------
217
218 -- Declare Visit table type for record
219 TYPE Visit_Tbl_Type IS TABLE OF Visit_Rec_Type
220 INDEX BY BINARY_INTEGER;
221
222 -- Declare Error table type for record
223 TYPE Error_Tbl_Type IS TABLE OF Error_Rec_Type
224 INDEX BY BINARY_INTEGER;
225
226 -------------------------------------------------------------------
227 -- Declare Procedures --
228 -------------------------------------------------------------------
229
230 /*
231
232 Commented out Jul-28-04 by yazhou
233 using AHL_UTIL_UC_PKG API instead
234
235 -- To find unit configuration name for a given item instance.
236 FUNCTION get_unitName (p_csi_item_instance_id IN NUMBER)
237 RETURN VARCHAR2;
238
239 */
240 --------------------------------------------------------------------
241 -- Procedure Name : Process_Visit
242 -- Type : Private
243 -- Function : To process a visit related attributes to create/update/delete the visit
244 -- Parameters :
245 --
246 -- Standard IN Parameters :
247 -- p_api_version IN NUMBER Required
248 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252 -- p_module_type IN VARCHAR2 Default NULL.
253 --
254 -- Standard OUT Parameters :
255 -- x_return_status OUT VARCHAR2 Required
256 -- x_msg_count OUT NUMBER Required
257 -- x_msg_data OUT VARCHAR2 Required
258 --
259 -- Process_Visit Parameters:
260 -- p_x_Visit_tbl IN OUT AHL_VWP_VISITS_PVT.Visit_Tbl_Type Required
261 -- The table of visit records type for which DML operation is to be performed.
262 --
263 -- Version :
264 -- Initial Version 1.0
265 --------------------------------------------------------------------
266 PROCEDURE Process_Visit (
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 p_module_type IN VARCHAR2 := 'JSP',
272 p_x_Visit_tbl IN OUT NOCOPY Visit_Tbl_Type,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2
276 );
277
278 ---------------------------------------------------------------------
279 -- Procedure name : Get_Visit_Details
280 -- Type : Private
281 -- Function : To get a visit details
282 -- Parameters :
283 --
284 -- Standard IN Parameters :
285 -- p_api_version IN NUMBER Required
286 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290 -- p_module_type IN VARCHAR2 Default NULL.
291 --
292 -- Standard OUT Parameters :
293 -- x_return_status OUT VARCHAR2 Required
294 -- x_msg_count OUT NUMBER Required
295 -- x_msg_data OUT VARCHAR2 Required
296 --
297 -- Get_Visit_Details Parameters:
298 -- p_visit_id IN NUMBER Required
299 -- The visit id whose details are to be displayed
300 -- x_Visit_rec OUT AHL_VWP_VISITS_PVT.Visit_Rec_Type Required
301 -- The record of visit attributes whose details are to be displayed
302 --
303 -- Version :
304 -- Initial Version 1.0
308 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
305 -------------------------------------------------------------------
306 PROCEDURE Get_Visit_Details (
307 p_api_version IN NUMBER,
309 p_commit IN VARCHAR2 := Fnd_Api.g_false,
310 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
311 p_module_type IN VARCHAR2 := 'JSP',
312 p_visit_id IN NUMBER,
313 x_Visit_rec OUT NOCOPY Visit_Rec_Type,
314 x_return_status OUT NOCOPY VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2
317 );
318
319 /*
320 -------------------------------------------------------------------
321 -- Procedure name : UMP_Visit_Info (OBSOLETED)
322 -- Type : Private
323 -- Function : To derive UMP Visit Information
324 -- Parameters :
325 --
326 -- Standard IN Parameters :
327 -- p_api_version IN NUMBER Required
328 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
330 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
331 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
332 -- p_module_type IN VARCHAR2 Default NULL.
333 --
334 -- Standard OUT Parameters :
335 -- x_return_status OUT VARCHAR2 Required
336 -- x_msg_count OUT NUMBER Required
337 -- x_msg_data OUT VARCHAR2 Required
338 --
339 -- UMP_Visit_Info Parameters:
340 -- p_unit_effectivity IN NUMBER Required
341 -- The unit effectivity for which all visits and task displayed.
342 --
343 -- Version :
344 -- Initial Version 1.0
345 -------------------------------------------------------------------
346 PROCEDURE UMP_Visit_Info (
347 p_api_version IN NUMBER,
348 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
349 p_commit IN VARCHAR2 := Fnd_Api.g_false,
350 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
351 p_module_type IN VARCHAR2 := Null,
352 p_unit_effectivity_id IN NUMBER,
353
354 x_ump_visit_rec OUT NOCOPY Srch_UMP_Rec_Type,
355 x_return_status OUT NOCOPY VARCHAR2,
356 x_msg_count OUT NOCOPY NUMBER,
357 x_msg_data OUT NOCOPY VARCHAR2
358 );
359 */
360 -------------------------------------------------------------------
361 -- Procedure name : Close_Visit
362 -- Type : Private
363 -- Function : To close a particular visit
364 -- Parameters :
365 --
366 -- Standard IN Parameters :
367 -- p_api_version IN NUMBER Required
368 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
370 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
371 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
372 -- p_module_type IN VARCHAR2 Default NULL.
373 --
374 -- Standard OUT Parameters :
375 -- x_return_status OUT VARCHAR2 Required
376 -- x_msg_count OUT NUMBER Required
377 -- x_msg_data OUT VARCHAR2 Required
378 --
379 -- Close_Visit Parameters:
380 -- p_visit_id IN NUMBER Required
381 -- The visit id which is going to be Closed.
382 --
383 -- Version :
384 -- Initial Version 1.0
385 -- Added by Srini p_x_cost_session, p_x_mr_session to support costing functionality
386 -------------------------------------------------------------------
387 PROCEDURE Close_Visit(
388 p_api_version IN NUMBER,
389 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
390 p_commit IN VARCHAR2 := Fnd_Api.g_false,
391 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
392 p_module_type IN VARCHAR2 := Null,
393 p_visit_id IN NUMBER,
394 p_x_cost_session_id IN OUT NOCOPY NUMBER,
395 p_x_mr_session_id IN OUT NOCOPY NUMBER,
396 x_return_status OUT NOCOPY VARCHAR2,
397 x_msg_count OUT NOCOPY NUMBER,
398 x_msg_data OUT NOCOPY VARCHAR2
399 );
400
401 -- Post 11.5.10
402 -- Reema Start
403 -------------------------------------------------------------------
404 -- Procedure name : Cancel_Visit
405 -- Type : Private
406 -- Function : To cancel a particular visit
407 -- Parameters :
408 --
409 -- Standard IN Parameters :
410 -- p_api_version IN NUMBER Required
411 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
412 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
413 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
414 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
415 -- p_module_type IN VARCHAR2 Default NULL.
416 --
417 -- Standard OUT Parameters :
418 -- x_return_status OUT VARCHAR2 Required
419 -- x_msg_count OUT NUMBER Required
420 -- x_msg_data OUT VARCHAR2 Required
421 --
422 -- Cancel_Visit Parameters:
423 -- p_visit_id IN NUMBER Required
427 --
424 -- The visit id which is going to be cancelled.
425 -- x_error_flag OUT VARCHAR2 Required
426 -- The boolean flag keeps track of Unreleased jobs.
428 -- Version :
429 -- Initial Version 1.0
430 -------------------------------------------------------------------
431 PROCEDURE Cancel_Visit(
432 p_api_version IN NUMBER := 1.0,
433 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
434 p_commit IN VARCHAR2 := Fnd_Api.g_false,
435 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
436 p_module_type IN VARCHAR2 := Null,
437 p_visit_id IN NUMBER,
438 p_obj_ver_num IN NUMBER,
439 x_return_status OUT NOCOPY VARCHAR2,
440 x_msg_count OUT NOCOPY NUMBER,
441 x_msg_data OUT NOCOPY VARCHAR2
442 );
443 -- Reema End
444
445 -- pbarman begin
446 -------------------------------------------------------------------
447 -- Procedure name : DELETE_FLIGHT_ASSOC
448 -- Type : Private
449 -- Function : to delete the Unit Schedule Id from Visits records
450 -- when the Flight schedule is deleted.
451 -- Parameters :
452 --
453 -- Standard IN Parameters :
454 --
455 -- Standard OUT Parameters :
456 -- x_return_status OUT VARCHAR2 Required
457 --
458 -- UMP_Visit_Info Parameters:
459 -- p_unit_effectivity IN NUMBER Required
460 -- The unit effectivity for which all visits and task displayed.
461 --
462 -- Version :
463 -- Initial Version 1.0
464 -------------------------------------------------------------------
465 -- procedure to delete the Unit Schedule Id from Visits records
466 --when the Flight schedule is deleted.
467
468 PROCEDURE DELETE_FLIGHT_ASSOC(
469 p_unit_schedule_id IN NUMBER,
470 x_return_status OUT NOCOPY VARCHAR2
471 );
472 -- pbarman end
473
474 -- PRAKKUM :: BEGIN :: VWPE :: 01-FEB-2011
475 -- To find out Due_by_Date for the visit update screen.
476 -------------------------------------------------------------------
477 -- Function name : Get_Due_by_Date
478 -- Type : Public
479 -- Function : To find out least due by date among all tasks of a visit
480 -- Parameters :
481 --
482 -- Standard IN Parameters :
483 -- p_visit_id IN NUMBER Required
484 --
485 -- Standard OUT Parameters :
486 --
487 -- Version :
488 -- Initial Version 12.0
489 -------------------------------------------------------------------
490 FUNCTION Get_Due_by_Date(
491 p_visit_id IN NUMBER
492 )
493 RETURN DATE;
494
495 -- PRAKKUM :: END :: VWPE :: 01-FEB-2011
496
497 -- PRAKKUM :: VWPE: ER:12730539 :: 23-JUN-2011 :: START
498 -- To find out whether visit got created earlier to enhancements (ER:12424063) or not
499 -------------------------------------------------------------------
500 -- Function name : Is_Old_Visit
501 -- Type : Public
502 -- Function : To find out whether visit got created earlier to enhancements (ER:12424063) or not
503 -- Parameters :
504 --
505 -- Standard IN Parameters :
506 -- p_visit_id IN NUMBER Required
507 --
508 -- Standard OUT Parameters :
509 --
510 -- Version :
511 -- Initial Version 12.0
512 -------------------------------------------------------------------
513 FUNCTION Is_Old_Visit(p_visit_id IN NUMBER)
514 RETURN VARCHAR2;
515 -- PRAKKUM :: VWPE: ER:12730539 :: 23-JUN-2011 :: END
516
517 ------------------------------------------------------------------------------------
518 -- MANESING::Component Maintenance Planning Project, 05-Jul-2011, added following procedure
519 -- Start of Comments
520 -- Procedure name : Validate_Component_Visit
521 -- Type : Public
522 -- Function : Procedure to validate a Component Visit. Basically it checks for all the
523 -- mandatory attributes required for a Component Visit.
524 --
525 -- Pre-reqs :
526 -- Parameters :
527 --
528 -- Validate_Component_Visit Parameters:
529 -- p_visit_rec IN Given Component Visit record. Required
530 --
531 -- End of Comments
532
533 PROCEDURE Validate_Component_Visit
534 (
535 p_api_version IN NUMBER := 1.0,
536 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
537 p_commit IN VARCHAR2 := FND_API.G_FALSE,
538 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
539 p_module_type IN VARCHAR2,
540 p_visit_rec IN VISIT_REC_TYPE,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2
544 );
545
546 -- SKPATHAK :: AVF ER: 13416865 :: 25-NOV-2011 :: START
547 -- To Create a Maintenance Visit
548 PROCEDURE Create_Visit (
549 p_api_version IN NUMBER,
550 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
551 p_commit IN VARCHAR2 := Fnd_Api.g_false,
552 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
553 p_module_type IN VARCHAR2 := 'JSP',
554 p_x_visit_rec IN OUT NOCOPY visit_rec_type,
555 x_return_status OUT NOCOPY VARCHAR2,
556 x_msg_count OUT NOCOPY NUMBER,
557 x_msg_data OUT NOCOPY VARCHAR2
558 );
559
560
561 PROCEDURE Update_Visit (
562 p_api_version IN NUMBER,
563 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
564 p_commit IN VARCHAR2 := Fnd_Api.g_false,
565 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
566 p_module_type IN VARCHAR2 := 'JSP',
567 p_x_visit_rec IN OUT NOCOPY Visit_Rec_Type,
568 x_return_status OUT NOCOPY VARCHAR2,
569 x_msg_count OUT NOCOPY NUMBER,
570 x_msg_data OUT NOCOPY VARCHAR2
571 );
572 -- SKPATHAK :: AVF ER: 13416865 :: 25-NOV-2011 :: END
573
574 -- TCHIMIRA :: AVF ER: 13416865 :: 14-DEC-2011 :: Adding the below since it is now called from another package
575 PROCEDURE Delete_Visit (
576 p_api_version IN NUMBER,
577 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
578 p_commit IN VARCHAR2 := Fnd_Api.g_false,
579 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
580 p_visit_id IN NUMBER,
581 x_return_status OUT NOCOPY VARCHAR2,
582 x_msg_count OUT NOCOPY NUMBER,
583 x_msg_data OUT NOCOPY VARCHAR2
584 );
585
586 -------------------------------------------------------------------
587
588 END AHL_VWP_VISITS_PVT;
589