1 PACKAGE AHL_VWP_TASKS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVTSKS.pls 120.0.12020000.2 2012/12/07 15:35:47 sareepar ship $ */
3
4 -----------------------------------------------------------
5 -- PACKAGE
6 -- Ahl_VWP_Tasks_Pvt
7 --
8 -- PURPOSE
9 -- This package specification is a Private API for managing
10 -- Planning --> Visit Work Package --> Visit's TASKS
11 -- related procedures in Complex Maintainance, Repair and Overhauling(CMRO).
12 --
13 -- It defines used pl/sql records and tables datatypes
14 --
15 -- Create_Task (see below for specification)
16 -- Update_Task (see below for specification)
17 -- Delete_Task (see below for specification)
18 -- Search_Task (see below for specification)
19 -- Get_Task_Details (see below for specification)
20 --
21 --
22 -- NOTES
23 --
24 --
25 -- HISTORY
26 -- 17-MAY-2002 SHBHANDA Created.
27 -- 06-AUG-2003 SHBHANDA 11.5.10 Changes.
28 -----------------------------------------------------------
29
30 -- Record for Search Tasks
31 TYPE Srch_Task_Rec_Type IS RECORD (
32 Task_ID NUMBER,
33 Task_Start_Time DATE,
34 Task_End_Time DATE
35 );
36
37 --Declare Task table type for search task record
38 TYPE Srch_Task_Tbl_Type IS TABLE OF Srch_Task_Rec_Type
39 INDEX BY BINARY_INTEGER;
40
41 -------------------------------------------------------------------
42 -- Declare Procedures --
43 -------------------------------------------------------------------
44 -- Procedure name : Get_Task_Details
45 -- Type : Private
46 -- Function : To display task details associated with a visit for update UI screen
47 -- Parameters :
48 --
49 -- Standard IN Parameters :
50 -- p_api_version IN NUMBER Required
51 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
52 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
53 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
54 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
55 -- p_module_type IN VARCHAR2 Default NULL.
56 --
57 -- Standard OUT Parameters :
58 -- x_return_status OUT VARCHAR2 Required
59 -- x_msg_count OUT NUMBER Required
60 -- x_msg_data OUT VARCHAR2 Required
61 --
62 -- Get_Task_Details Parameters:
63 -- p_task_id IN NUMBER Required
64 -- The id of the visit tasks whose details are displayed
65 -- x_task_rec OUT AHL_VWP_RULES_PVT.Task_Rec_Type
66 -- The record containing details about the tasks associated with a visit
67 --
68 -- Version :
69 -- Initial Version 1.0
70 -------------------------------------------------------------------
71
72 PROCEDURE Get_Task_Details (
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
75 p_commit IN VARCHAR2 := Fnd_Api.g_false,
76 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
77 p_module_type IN VARCHAR2 := 'JSP',
78 p_task_id IN NUMBER,
79 x_task_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85 -------------------------------------------------------------------
86 -- Procedure name : Create_Task
87 -- Type : Private
88 -- Function : To create Unassociated/Summary/Non-Routine task for a visit
89 -- Parameters :
90 --
91 -- Standard IN Parameters :
92 -- p_api_version IN NUMBER Required
93 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
94 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
95 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
96 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
97 -- p_module_type IN VARCHAR2 Default NULL.
98 --
99 -- Standard OUT Parameters :
100 -- x_return_status OUT VARCHAR2 Required
101 -- x_msg_count OUT NUMBER Required
102 -- x_msg_data OUT VARCHAR2 Required
103 --
104 -- Create_Task Parameters:
105 -- p_x_Task_Rec IN OUT AHL_VWP_RULES_PVT.Task_Rec_Type Required
106 -- The record of visit's task attributes for which task is created.
107 --
108 -- Version :
109 -- Initial Version 1.0
110 -------------------------------------------------------------------
111 PROCEDURE Create_Task (
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
114 p_commit IN VARCHAR2 := Fnd_Api.g_false,
115 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
116 p_module_type IN VARCHAR2 := 'JSP',
117 p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
118
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2
122 );
123
124 -------------------------------------------------------------------
125 -- Procedure name : Update_Task
126 -- Type : Private
127 -- Function : To update various different types of tasks in a visit.
128 -- Parameters :
129 --
130 -- Standard IN Parameters :
131 -- p_api_version IN NUMBER Required
132 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
133 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
134 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
135 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
136 -- p_module_type IN VARCHAR2 Default NULL.
137 --
138 -- Standard OUT Parameters :
139 -- x_return_status OUT VARCHAR2 Required
140 -- x_msg_count OUT NUMBER Required
141 -- x_msg_data OUT VARCHAR2 Required
142 --
143 -- Update_Task Parameters:
144 -- p_x_Task_Rec IN OUT AHL_VWP_RULES_PVT.Task_Rec_Type Required
145 -- The record of visit's task attributes for which task is updated.
146 --
147 -- Version :
148 -- Initial Version 1.0
149 -------------------------------------------------------------------
150
151 PROCEDURE Update_Task (
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
154 p_commit IN VARCHAR2 := Fnd_Api.g_false,
155 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
156 p_module_type IN VARCHAR2 := 'JSP',
157 p_x_Task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
158
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2
162 );
163
164 -------------------------------------------------------------------
165 -- Procedure name : Delete_Task
166 -- Type : Private
167 -- Function : To delete various different types of tasks in a visit.
168 -- Parameters :
169 --
170 -- Standard IN Parameters :
171 -- p_api_version IN NUMBER Required
172 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
173 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
174 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
175 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
176 -- p_module_type IN VARCHAR2 Default NULL.
177 --
178 -- Standard OUT Parameters :
179 -- x_return_status OUT VARCHAR2 Required
180 -- x_msg_count OUT NUMBER Required
181 -- x_msg_data OUT VARCHAR2 Required
182 --
183 -- Delete_Task Parameters:
184 -- p_Visit_Task_ID IN NUMBER Required
185 -- The Id of visit's task which has to be deleted.
186 --
187 -- Version :
188 -- Initial Version 1.0
189 -------------------------------------------------------------------
190
191 PROCEDURE Delete_Task (
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
194 p_commit IN VARCHAR2 := Fnd_Api.g_false,
195 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
196 p_module_type IN VARCHAR2 := 'JSP',
197 p_Visit_Task_Id IN NUMBER,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2
201 );
202
203 -------------------------------------------------------------------
204 -- Procedure name : Search_Task
205 -- Type : Private
206 -- Function : To create planned task for all MR/Routes
207 -- Parameters :
208 --
209 -- Standard IN Parameters :
210 -- p_api_version IN NUMBER Required
211 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
212 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
214 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
215 -- p_module_type IN VARCHAR2 Default NULL.
216 --
217 -- Standard OUT Parameters :
218 -- x_return_status OUT VARCHAR2 Required
219 -- x_msg_count OUT NUMBER Required
220 -- x_msg_data OUT VARCHAR2 Required
221 --
222 -- Search_Task Parameters:
223 -- p_visit_id IN NUMBER Required
224 -- The ID of visit for which tasks are created.
225 -- x_srch_task_tbl OUT AHL_VWP_TASKS_PVT.Srch_Task_Tbl_Type Required
226 -- The table with all tasks id and results for search criteria with start datetime and end datetime.
227 --
228 -- Version :
229 -- Initial Version 1.0
230 -------------------------------------------------------------------
231 PROCEDURE Search_Task (
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
234 p_commit IN VARCHAR2 := Fnd_Api.g_false,
235 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
236 p_module_type IN VARCHAR2:='JSP',
237 p_visit_id IN NUMBER,
238 p_x_srch_task_tbl IN OUT NOCOPY Srch_Task_Tbl_Type,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2
242 );
243
244 PROCEDURE Delete_Summary_Task (
245 p_api_version IN NUMBER,
246 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
247 p_commit IN VARCHAR2 := Fnd_Api.g_false,
248 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
249 p_module_type IN VARCHAR2 :='JSP',
250 p_Visit_Task_Id IN NUMBER,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2
254 );
255 -------------------------------------------------------------------
256 -- Procedure name : Create_PUP_Tasks
257 -- Type : Private
258 -- Function : To create Unassociated/Summary/Non-Routine task for a visit
259 -- Parameters :
260 --
261 -- Standard IN Parameters :
262 -- p_api_version IN NUMBER Required
263 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
264 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
265 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
266 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
267 -- p_module_type IN VARCHAR2 Default NULL.
268 --
269 -- Standard OUT Parameters :
270 -- x_return_status OUT VARCHAR2 Required
271 -- x_msg_count OUT NUMBER Required
272 -- x_msg_data OUT VARCHAR2 Required
273 --
274 -- Create_Task Parameters:
275 -- p_x_Task_Tbl IN OUT AHL_VWP_RULES_PVT.Task_Tbl_Type Required
276 -- The record of visit's task attributes for which task is created.
277 --
278 -- Version :
279 -- Initial Version 1.0
280 -------------------------------------------------------------------
281 PROCEDURE Create_PUP_Tasks (
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
284 p_commit IN VARCHAR2 := Fnd_Api.g_false,
285 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
286 p_module_type IN VARCHAR2 := 'JSP',
287 p_x_task_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2
291 );
292
293 -------------------------------------------------------------------
294 -- Procedure name : Associate_Default_MRs
295 -- Type : Private
296 -- Function : To create Unassociated/Summary/Non-Routine task for a visit
297 -- Parameters :
298 --
299 -- Standard IN Parameters :
300 -- p_api_version IN NUMBER Required
301 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
302 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
303 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
304 -- p_module_type IN VARCHAR2 Default NULL.
305 -- p_visit_rec IN AHL_VWP_VISITS_PVT.Visit_Rec_Type,
306 --
307 -- Standard OUT Parameters :
308 -- x_return_status OUT VARCHAR2 Required
309 -- x_msg_count OUT NUMBER Required
310 -- x_msg_data OUT VARCHAR2 Required
311 --
312 -- Purpose:
313 -- To associate default MR's during Transit Check Visit creation.
314 -- Version :
315 -- Initial Version 1.0
316 -------------------------------------------------------------------
317
318 PROCEDURE associate_default_mrs (
319 p_api_version IN NUMBER,
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 := 'JSP',
324 x_return_status OUT NOCOPY VARCHAR2,
325 x_msg_count OUT NOCOPY NUMBER,
326 x_msg_data OUT NOCOPY VARCHAR2,
327 p_visit_rec IN AHL_VWP_VISITS_PVT.Visit_Rec_Type
328 );
329
330 -- SKPATHAK :: 02-MAY-2011 :: VWPE :: Added this new procedure
331 --------------------------------------------------------------------
332 -- PROCEDURE
333 -- Create_Stage_Tasks
334 -- PURPOSE
335 -- To create visit tasks for visit stages
336 --------------------------------------------------------------------
337 PROCEDURE Create_Stage_Tasks (
338 p_api_version IN NUMBER,
339 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
340 p_commit IN VARCHAR2 := Fnd_Api.g_false,
341 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
342 p_module_type IN VARCHAR2 := null,
343 p_stage_id IN NUMBER,
344 p_visit_id IN NUMBER,
345 x_return_status OUT NOCOPY VARCHAR2,
346 x_msg_count OUT NOCOPY NUMBER,
347 x_msg_data OUT NOCOPY VARCHAR2
348 );
349
350
351 END AHL_VWP_TASKS_PVT;
352