1 PACKAGE AHL_LTP_REQST_MATRL_PVT AS
2 /* $Header: AHLVRMTS.pls 120.1 2008/03/20 10:28:28 rnahata ship $*/
3 --
4 TYPE Visit_Task_Route_Rec_Type IS RECORD (
5 VISIT_TASK_ID NUMBER,
6 MR_ROUTE_ID NUMBER,
7 ROUTE_ID NUMBER,
8 INSTANCE_ID NUMBER,
9 TASK_START_DATE DATE);
10
11 TYPE Visit_Task_Route_Tbl_Type IS TABLE OF Visit_Task_Route_Rec_Type
12 INDEX BY BINARY_INTEGER;
13
14 -- Start of Comments --
15 -- Procedure name : Process_Planned_Materials
16 -- Type : Private
17 -- Function : This procedure Creates, Updates and Removes Planned materials information associated to scheduled
18 -- visit, which are defined at Route Operation and Disposition level
19 -- Pre-reqs :
20 -- Parameters :
21 --
22 -- Standard IN Parameters :
23 -- p_api_version IN NUMBER Required
24 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
25 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
26 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
27 -- Based on this flag, the API will set the default attributes.
28 -- p_module_type In VARCHAR2 Default NULL
29 -- This will be null.
30 -- Standard out Parameters :
31 -- x_return_status OUT VARCHAR2 Required
32 -- x_msg_count OUT NUMBER Required
33 -- x_msg_data OUT VARCHAR2 Required
34 --
35 -- Process_Planned_Materials Parameters :
36 --
37 --
38 PROCEDURE Process_Planned_Materials (
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41 p_commit IN VARCHAR2 := FND_API.g_false,
42 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43 p_visit_id IN NUMBER,
44 p_visit_task_id IN NUMBER := NULL,
45 p_org_id IN NUMBER := NULL,
46 p_start_date IN DATE := NULL,
47 p_visit_status IN VARCHAR2 := NULL,
48 p_operation_flag IN VARCHAR2,
49 x_planned_order_flag OUT NOCOPY VARCHAR2 ,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2);
53
54 -- Start of Comments --
55 -- Procedure name : Update_Planned_Materials
56 -- Type : Private
57 -- Function : This procedure Updates Planned materials information associated to scheduled
58 -- visit, which are defined at Route Operation and Disposition level
59 -- Pre-reqs :
60 -- Parameters :
61 --
62 -- Standard IN Parameters :
63 -- p_api_version IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67 -- Based on this flag, the API will set the default attributes.
68 -- p_module_type In VARCHAR2 Default NULL
69 -- This will be null.
70 -- Standard out Parameters :
71 -- x_return_status OUT VARCHAR2 Required
72 -- x_msg_count OUT NUMBER Required
73 -- x_msg_data OUT VARCHAR2 Required
74 --
75 -- Update_Planned_Materials Parameters :
76 -- p_planned_materials_tbl IN Planned_Materials_Tbl,Required
77 --
78 --
79 PROCEDURE Update_Planned_Materials (
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82 p_commit IN VARCHAR2 := FND_API.g_false,
83 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84 p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2);
88 --
89 --
90 -- Start of Comments --
91 -- Procedure name : Unschedule_Visit_task_Items
92 -- Type : Private
93 -- Function : This procedure Checks any items scheduled
94 -- which are defined at Route Operation and Disposition level
95 -- Pre-reqs :
96 -- Parameters :
97 --
98 -- Standard IN Parameters :
99 -- p_api_version IN NUMBER Required
100 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
102 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
103 -- Based on this flag, the API will set the default attributes.
104 -- This will be null.
105 -- Standard out Parameters :
106 -- x_return_status OUT VARCHAR2 Required
107 -- x_msg_count OUT NUMBER Required
108 -- x_msg_data OUT VARCHAR2 Required
109 --
110 -- Unschedule_Visit_Task_Items Parameters :
111 -- p_visit_id IN NUMBER, Required
112 -- p_visit_task_id IN NUMBER, Optional
113 --
114 PROCEDURE Unschedule_visit_Task_Items
115 (p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
117 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
118 p_visit_id IN NUMBER,
119 p_visit_task_id IN NUMBER := NULL,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125 -- Start of Comments --
126 -- Procedure name : Create_Task_Materials
127 -- Type : Private
128 -- Function : This procedure Created Planned materials information associated to scheduled
129 -- visit, which are defined at Route Operation and Disposition level
130 -- Pre-reqs :
131 -- Parameters :
132 --
133 -- Standard IN Parameters :
134 -- p_api_version IN NUMBER Required
135 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
136 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
137 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138 -- Based on this flag, the API will set the default attributes.
139 -- p_module_type In VARCHAR2 Default NULL
140 -- This will be null.
141 -- Standard out Parameters :
142 -- x_return_status OUT VARCHAR2 Required
143 -- x_msg_count OUT NUMBER Required
144 -- x_msg_data OUT VARCHAR2 Required
145 --
146 -- Create_Planned_Materials Parameters :
147 -- p_visit_id IN NUMBER,Required
148 --
149 --
150 PROCEDURE Create_Task_Materials (
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
153 p_commit IN VARCHAR2 := FND_API.g_false,
154 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
155 p_visit_id IN NUMBER,
156 p_visit_task_id IN NUMBER := NULL,
157 p_start_time IN DATE := NULL,
158 p_org_id IN NUMBER := NULL,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2);
162
163 -- Start of Comments --
164 -- Procedure name : Modify_Visit_Task_Matrls
165 -- Type : Private
166 -- Function : This procedure Created Planned materials information associated to scheduled
167 -- visit, which are defined at Route Operation and Disposition level
168 -- Pre-reqs :
169 -- Parameters :
170 --
171 -- Standard IN Parameters :
172 -- p_api_version IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
174 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
175 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
176 -- Based on this flag, the API will set the default attributes.
177 -- p_module_type In VARCHAR2 Default NULL
178 -- This will be null.
179 -- Standard out Parameters :
180 -- x_return_status OUT VARCHAR2 Required
181 -- x_msg_count OUT NUMBER Required
182 -- x_msg_data OUT VARCHAR2 Required
183 --
184 -- Modify_Visit_Task_Matrls Parameters :
185 -- p_visit_id IN NUMBER,Required
186 --
187 --
188 PROCEDURE Modify_Visit_Task_Matrls (
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191 p_commit IN VARCHAR2 := FND_API.g_false,
192 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193 p_visit_id IN NUMBER,
194 p_visit_task_id IN NUMBER := NULL,
195 p_start_time IN DATE := NULL,
196 p_org_id IN NUMBER := NULL,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2);
200
201 -- Start of Comments --
202 -- Procedure name : Remove_Visit_Task_Matrls
203 -- Type : Private
204 -- Function : This procedure Created Planned materials information associated to scheduled
205 -- visit, which are defined at Route Operation and Disposition level
206 -- Pre-reqs :
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 -- Based on this flag, the API will set the default attributes.
215 -- p_module_type In VARCHAR2 Default NULL
216 -- This will be null.
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 -- Remove_Planned_Materials Parameters :
223 -- p_visit_id IN NUMBER,Required
224 --
225 --
226 PROCEDURE Remove_Visit_Task_Matrls (
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
229 p_commit IN VARCHAR2 := FND_API.g_false,
230 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231 p_visit_id IN NUMBER,
232 p_visit_task_id IN NUMBER := NULL,
233 x_planned_order_flag OUT NOCOPY VARCHAR2 ,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2);
237
238 -- Start of Comments --
239 -- Procedure name : Update_Unplanned_Matrls
240 -- Type : Private
241 -- Function : This procedure Created Planned materials information associated to scheduled
242 -- visit, which are defined at Route Operation and Disposition level
243 -- Pre-reqs :
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 -- Based on this flag, the API will set the default attributes.
252 -- p_module_type In VARCHAR2 Default NULL
253 -- This will be null.
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 -- Update_Unplanned_Materials Parameters :
260 -- p_visit_id IN NUMBER,Required
261 --
262 --
263 PROCEDURE Update_Unplanned_Matrls (
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
266 p_commit IN VARCHAR2 := FND_API.g_false,
267 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
268 p_visit_id IN NUMBER,
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2);
272
273 -------------------------------------------------------------------
274 -- Procedure name : Update_Material_Reqrs_status
275 -- Type : Private
276 --
277 -- Function : To update all the material requirement status
278 -- for the workorder that is being cancelled.
279 -- Pre-reqs :
280 -- Parameters :
281 --
282 -- Standard IN Parameters :
283 -- p_api_version IN NUMBER Required
284 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
285 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
286 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
287 --
288 -- Standard OUT Parameters :
289 -- x_return_status OUT VARCHAR2 Required
290 -- x_msg_count OUT NUMBER Required
291 -- x_msg_data OUT VARCHAR2 Required
292 -- x_workorder_id OUT NUMBER Required
293 --
294 -- Release visit Parameters:
295 -- p_visit_task_id IN NUMBER Required
296 --
297 -- Version :
298 -- 19/03/2008 Richa Bug#6898408 Initial Creation
299 -------------------------------------------------------------------
300
301 PROCEDURE Update_Material_Reqrs_status
302 ( p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
304 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
305 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
306 p_module_type IN VARCHAR2 := NULL,
307 p_visit_task_id IN NUMBER,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2
311 );
312
313 END AHL_LTP_REQST_MATRL_PVT;