[Home] [Help]
PACKAGE: APPS.AHL_LTP_SIMUL_PLAN_PVT
Source
1 PACKAGE AHL_LTP_SIMUL_PLAN_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSPNS.pls 115.8 2003/09/08 21:32:07 ssurapan noship $*/
3 --
4 -----------------------------------------------------------
5 -- PACKAGE
6 -- AHL_LTP_SIMUL_PLAN_PVT
7 --
8 -- PURPOSE
9 -- This package is a Private API for managing Simulation plan information in
10 -- Advanced Services Online. It contains specification for pl/sql records and tables
11 --
12 -- AHL_SPACE_UNAVIALABLE_VL:
13 -- Create_Simulation_plan (see below for specification)
14 -- Update_Simulation_plan (see below for specification)
15 -- Delete_Simulation_plan (see below for specification)
16 --
17 --
18 -- NOTES
19 --
20 --
21 -- HISTORY
22 -- 23-Apr-2002 ssurapan Created.
23 -----------------------------------------------------------
24
25 -------------------------------------
26 ----- SIMULATION PLANS ----------------
27 -------------------------------------
28 TYPE Simulation_Plan_Rec IS RECORD (
29 simulation_plan_id NUMBER,
30 last_update_date DATE,
31 last_updated_by NUMBER,
32 creation_date DATE,
33 created_by NUMBER,
34 last_update_login NUMBER,
35 object_version_number NUMBER,
36 simulation_plan_name VARCHAR2(80),
37 primary_plan_flag VARCHAR2(1),
38 description VARCHAR2(250),
39 attribute_category VARCHAR2(30),
40 attribute1 VARCHAR2(150),
41 attribute2 VARCHAR2(150),
42 attribute3 VARCHAR2(150),
43 attribute4 VARCHAR2(150),
44 attribute5 VARCHAR2(150),
45 attribute6 VARCHAR2(150),
46 attribute7 VARCHAR2(150),
47 attribute8 VARCHAR2(150),
48 attribute9 VARCHAR2(150),
49 attribute10 VARCHAR2(150),
50 attribute11 VARCHAR2(150),
51 attribute12 VARCHAR2(150),
52 attribute13 VARCHAR2(150),
53 attribute14 VARCHAR2(150),
54 attribute15 VARCHAR2(150),
55 operation_flag VARCHAR2(1)
56 );
57
58 --Declare table type
59 TYPE simulation_plan_tbl IS TABLE OF Simulation_Plan_Rec
60 INDEX BY BINARY_INTEGER;
61
62 -----------------------------------------------------------
63 -- SIMULATION VISIT
64 -----------------------------------------------------------
65
66 -- Record for AHL_SIMULATION_VISIT
67 TYPE Simulation_Visit_Rec IS RECORD (
68 visit_id NUMBER,
69 visit_number NUMBER,
70 plan_id NUMBER,
71 last_update_date DATE,
72 last_updated_by NUMBER,
73 creation_date DATE,
74 created_by NUMBER,
75 last_update_login NUMBER,
76 organization_id NUMBER,
77 department_id NUMBER,
78 start_date_time DATE,
79 item_instance_id NUMBER,
80 inventory_item_id NUMBER,
81 asso_primary_visit_id NUMBER,
82 primary_visit_number NUMBER,
83 object_version_number NUMBER,
84 attribute_category VARCHAR2(30),
85 attribute1 VARCHAR2(150),
86 attribute2 VARCHAR2(150),
87 attribute3 VARCHAR2(150),
88 attribute4 VARCHAR2(150),
89 attribute5 VARCHAR2(150),
90 attribute6 VARCHAR2(150),
91 attribute7 VARCHAR2(150),
92 attribute8 VARCHAR2(150),
93 attribute9 VARCHAR2(150),
94 attribute10 VARCHAR2(150),
95 attribute11 VARCHAR2(150),
96 attribute12 VARCHAR2(150),
97 attribute13 VARCHAR2(150),
98 attribute14 VARCHAR2(150),
99 attribute15 VARCHAR2(150)
100 );
101
102 --Declare table type
103 TYPE Simulation_Visit_Tbl IS TABLE OF Simulation_Visit_Rec
104 INDEX BY BINARY_INTEGER;
105
106 --------------------------------------------------------------------
107 -- PROCEDURE
108 -- Create_Simulation_plan
109 --
110 -- PURPOSE
111 -- Create Simulation plan Record
112 --
113 -- PARAMETERS
114 -- p_simulation_plan_rec: the record representing AHL_SIMULATION_PLANS_VL view..
115 --
116 -- NOTES
117 --------------------------------------------------------------------
118 PROCEDURE Create_Simulation_plan (
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
121 p_commit IN VARCHAR2 := FND_API.g_false,
122 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123 p_module_type IN VARCHAR2 := 'JSP',
124 p_x_simulation_plan_rec IN OUT NOCOPY ahl_ltp_simul_plan_pub.Simulation_Plan_Rec,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2
128 );
129
130 --------------------------------------------------------------------
131 -- PROCEDURE
132 -- Update_Simulation_plan
133 --
134 -- PURPOSE
135 -- Update Simulation plan Record.
136 --
137 -- PARAMETERS
138 -- p_simulation_plan_rec: the record representing AHL_SIMULATION_PLAN_VL
139 --
140 -- NOTES
141 --------------------------------------------------------------------
142 PROCEDURE Update_Simulation_plan (
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
145 p_commit IN VARCHAR2 := FND_API.g_false,
146 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
147 p_module_type IN VARCHAR2 := 'JSP',
148 p_simulation_plan_rec IN ahl_ltp_simul_plan_pub.Simulation_Plan_Rec,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154
155 --------------------------------------------------------------------
156 -- PROCEDURE
157 -- Delete_Simulation_plan
158 --
159 -- PURPOSE
160 -- Delete Simulation plan Record.
161 --
162 -- PARAMETERS
163 -- p_simulation_plan_rec: the record representing AHL_SIMULATION_PLAN_VL
164 --
165 -- ISSUES
166 --
167 -- NOTES
168 -- 1. Raise exception if the object_version_number doesn't match.
169 --------------------------------------------------------------------
170 PROCEDURE Delete_Simulation_plan (
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
173 p_commit IN VARCHAR2 := FND_API.g_false,
174 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
175 p_simulation_plan_rec IN ahl_ltp_simul_plan_pub.Simulation_plan_Rec,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2
179
180 );
181
182
183
184 --------------------------------------------------------------------
185 -- PROCEDURE
186 -- Copy_Visits_To_Plan
187 --
188 -- PURPOSE
189 -- Copy Visits from primary plan to Simulation Plan and one simulation plan
190 -- to another
191 --
192 --
193 -- PARAMETERS
194 -- p_visit_rec Record representing AHL_VISITS_VL
195 --
196 -- NOTES
197 --------------------------------------------------------------------
198 PROCEDURE Copy_Visits_To_Plan (
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
201 p_commit IN VARCHAR2 := FND_API.g_false,
202 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
203 p_module_type IN VARCHAR2 := 'JSP',
204 p_visit_id IN NUMBER ,
205 p_visit_number IN NUMBER ,
206 p_plan_id IN NUMBER,
207 p_v_ovn IN NUMBER,
208 p_p_ovn IN NUMBER,
209 x_visit_id OUT NOCOPY NUMBER,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2
213 );
214
215 --------------------------------------------------------------------
216 -- PROCEDURE
217 -- Remove_Visits_FR_Plan
218 --
219 -- PURPOSE
220 -- Remove Visits from Simulation Plan
221 --
222 --
223 -- PARAMETERS
224 -- p_visit_rec Record representing AHL_VISITS_VL
225 --
226 -- NOTES
227 --------------------------------------------------------------------
228 PROCEDURE Remove_Visits_FR_Plan (
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231 p_commit IN VARCHAR2 := FND_API.g_false,
232 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233 p_module_type IN VARCHAR2 := 'JSP',
234 p_visit_id IN NUMBER,
235 p_plan_id IN NUMBER,
236 p_v_ovn IN NUMBER,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2
240 );
241
242 --------------------------------------------------------------------
243 -- PROCEDURE
244 -- Toggle_Simulation_Delete
245 --
246 -- PURPOSE
247 -- Toggle Simulation Delete/Undelete
248 --
249 -- PARAMETERS
250 -- p_visit_id : Visit Id
251 -- p_visit_object_version_number : Visit Object Version Number
252 --
253 -- NOTES
254 --------------------------------------------------------------------
255 PROCEDURE Toggle_Simulation_Delete (
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
258 p_commit IN VARCHAR2 := FND_API.g_false,
259 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
260 p_module_type IN VARCHAR2 := 'JSP',
261 p_visit_id IN NUMBER,
262 p_visit_object_version_number IN NUMBER,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2
266 );
267
268 --------------------------------------------------------------------
269 -- PROCEDURE
270 -- Set_Plan_As_Primary
271 --
272 -- PURPOSE
273 -- Set Plan As Primary
274 --
275 -- PARAMETERS
276 -- p_plan_id : Simulation Plan Id
277 -- p_object_version_number : Plan Object Version Number
278 --
279 -- NOTES
280 --------------------------------------------------------------------
281 PROCEDURE Set_Plan_As_Primary (
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_plan_id IN NUMBER,
288 p_object_version_number IN NUMBER,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2
292 );
293
294 --------------------------------------------------------------------
295 -- PROCEDURE
296 -- Set_Visit_As_Primary
297 --
298 -- PURPOSE
299 -- Set Visit As Primary
300 --
301 -- PARAMETERS
302 -- p_visit_id : Simulation Visit Id
303 -- p_object_version_number : Visit Object Version Number
304 --
305 -- NOTES
306 --------------------------------------------------------------------
307 PROCEDURE Set_Visit_As_Primary (
308 p_api_version IN NUMBER,
309 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
310 p_commit IN VARCHAR2 := FND_API.g_false,
311 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
312 p_module_type IN VARCHAR2 := 'JSP',
313 p_visit_id IN NUMBER,
317 x_msg_count OUT NOCOPY NUMBER,
314 p_plan_id IN NUMBER,
315 p_object_version_number IN NUMBER,
316 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_data OUT NOCOPY VARCHAR2
319 );
320 --
321 --------------------------------------------------------------------
322 -- PROCEDURE
323 -- Delet_Simul_Visits
324 --
325 -- PURPOSE
326 -- Procedure will be used to remove all the simulated visits. Will be
327 -- Called from VWP beofre visit has been pushed to production
328 --
329 -- PARAMETERS
330 -- p_visit_id : Primary Visit Id
331 --
332 -- NOTES
333 --------------------------------------------------------------------
334
335 PROCEDURE Delete_Simul_Visits (
336 p_api_version IN NUMBER,
337 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
338 p_commit IN VARCHAR2 := FND_API.g_false,
339 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
340 p_visit_id IN NUMBER,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2
344 );
345
346 END AHL_LTP_SIMUL_PLAN_PVT;