[Home] [Help]
PACKAGE: APPS.AMW_PROCESS_PVT
Source
1 PACKAGE AMW_Process_PVT AUTHID CURRENT_USER AS
2 /* $Header: amwvprls.pls 115.2 2003/06/18 05:05:20 npanandi noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMW_Process_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- process_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- last_update_date
26 -- last_updated_by
27 -- creation_date
28 -- created_by
29 -- last_update_login
30 -- item_type
31 -- name
32 -- created_from
33 -- request_id
34 -- program_application_id
35 -- program_id
36 -- program_update_date
37 -- attribute_category
38 -- attribute1
39 -- attribute2
40 -- attribute3
41 -- attribute4
42 -- attribute5
43 -- attribute6
44 -- attribute7
45 -- attribute8
46 -- attribute9
47 -- attribute10
48 -- attribute11
49 -- attribute12
50 -- attribute13
51 -- attribute14
52 -- attribute15
53 -- security_group_id
54 -- object_version_number
55 -- process_id
56 --
57 -- Required
58 --
59 -- Defaults
60 --
61 -- Note: This is automatic generated record definition, it includes all columns
62 -- defined in the table, developer must manually add or delete some of the attributes.
63 --
64 -- End of Comments
65
66 --===================================================================
67 TYPE process_rec_type IS RECORD
68 (
69 significant_process_flag VARCHAR2(1),
70 standard_process_flaG VARCHAR2(1),
71 approval_status VARCHAR2(30),
72 certification_status VARCHAR2(30),
73 process_owner_id NUMBER,
74 last_update_date DATE ,
75 last_updated_by NUMBER ,
76 creation_date DATE ,
77 created_by NUMBER ,
78 last_update_login NUMBER ,
79 item_type VARCHAR2(8) ,
80 name VARCHAR2(30) ,
81 created_from VARCHAR2(30) ,
82 request_id NUMBER ,
83 program_application_id NUMBER ,
84 program_id NUMBER ,
85 program_update_date DATE ,
86 attribute_category VARCHAR2(30) ,
87 attribute1 VARCHAR2(150) ,
88 attribute2 VARCHAR2(150) ,
89 attribute3 VARCHAR2(150) ,
90 attribute4 VARCHAR2(150) ,
91 attribute5 VARCHAR2(150) ,
92 attribute6 VARCHAR2(150) ,
93 attribute7 VARCHAR2(150) ,
94 attribute8 VARCHAR2(150) ,
95 attribute9 VARCHAR2(150) ,
96 attribute10 VARCHAR2(150) ,
97 attribute11 VARCHAR2(150) ,
98 attribute12 VARCHAR2(150) ,
99 attribute13 VARCHAR2(150) ,
100 attribute14 VARCHAR2(150) ,
101 attribute15 VARCHAR2(150) ,
102 security_group_id NUMBER ,
103 object_version_number NUMBER ,
104 process_id NUMBER,
105 CONTROL_COUNT NUMBER,
106 RISK_COUNT NUMBER,
107 ORG_COUNT NUMBER,
108 PROCESS_REV_ID NUMBER
109 );
110
111 g_miss_process_rec process_rec_type;
112 TYPE process_tbl_type IS TABLE OF process_rec_type INDEX BY BINARY_INTEGER;
113 g_miss_process_tbl process_tbl_type;
114
115 -- ==============================================================================
116 -- Start of Comments
117 -- ==============================================================================
118 -- API Name
119 -- Create_Process
120 -- Type
121 -- Private
122 -- Pre-Req
123 --
124 -- Parameters
125 --
126 -- IN
127 -- p_api_version_number IN NUMBER Required
128 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131 -- p_process_rec IN process_rec_type Required
132 --
133 -- OUT NOCOPY
134 -- x_return_status OUT NOCOPY VARCHAR2
135 -- x_msg_count OUT NOCOPY NUMBER
136 -- x_msg_data OUT NOCOPY VARCHAR2
137 -- Version : Current version 1.0
138 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
139 -- and basic operation, developer must manually add parameters and business logic as necessary.
140 --
141 -- End of Comments
142 -- ==============================================================================
143 --
144
145 PROCEDURE Create_Process_rec(
146 p_api_version_number IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148 p_commit IN VARCHAR2 := FND_API.G_FALSE,
149 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154
155 p_process_rec IN process_rec_type := g_miss_process_rec,
156 x_process_id OUT NOCOPY NUMBER
157 );
158
159 -- ==============================================================================
160 -- Start of Comments
161 -- ==============================================================================
162 -- API Name
163 -- Create_Process
164 -- Type
165 -- Private
166 -- Pre-Req
167 --
168 -- Parameters
169 --
170 -- IN
171 -- p_api_version_number IN NUMBER Required
172 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175 -- p_process_tbl IN process_tbl_type Required
176 --
177 -- OUT NOCOPY
178 -- x_return_status OUT NOCOPY VARCHAR2
179 -- x_msg_count OUT NOCOPY NUMBER
180 -- x_msg_data OUT NOCOPY VARCHAR2
181 -- Version : Current version 1.0
182 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
183 -- and basic operation, developer must manually add parameters and business logic as necessary.
184 --
185 -- End of Comments
186 -- ==============================================================================
187 --
188
189 PROCEDURE Create_Process(
190 p_api_version_number IN NUMBER,
191 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192 p_commit IN VARCHAR2 := FND_API.G_FALSE,
193 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198
199 p_process_tbl IN process_tbl_type := g_miss_process_tbl
200 );
201
202 -- ==============================================================================
203 -- Start of Comments
204 -- ==============================================================================
205 -- API Name
206 -- Update_Process
207 -- Type
208 -- Private
209 -- Pre-Req
210 --
211 -- Parameters
212 --
213 -- IN
214 -- p_api_version_number IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218 -- p_process_rec IN process_rec_type Required
219 --
220 -- OUT NOCOPY
221 -- x_return_status OUT NOCOPY VARCHAR2
222 -- x_msg_count OUT NOCOPY NUMBER
223 -- x_msg_data OUT NOCOPY VARCHAR2
224 -- Version : Current version 1.0
225 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
226 -- and basic operation, developer must manually add parameters and business logic as necessary.
227 --
228 -- End of Comments
229 -- ==============================================================================
230 --
231
232 PROCEDURE Update_Process_rec(
233 p_api_version_number IN NUMBER,
234 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235 p_commit IN VARCHAR2 := FND_API.G_FALSE,
236 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
237
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241
242 p_process_rec IN process_rec_type,
243 x_object_version_number OUT NOCOPY NUMBER
244 );
245
246
247 -- ==============================================================================
248 -- Start of Comments
249 -- ==============================================================================
250 -- API Name
251 -- Update_Process
252 -- Type
253 -- Private
254 -- Pre-Req
255 --
256 -- Parameters
257 --
258 -- IN
259 -- p_api_version_number IN NUMBER Required
260 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
261 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
262 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
263 -- p_process_rec IN process_rec_type Required
264 --
265 -- OUT NOCOPY
266 -- x_return_status OUT NOCOPY VARCHAR2
267 -- x_msg_count OUT NOCOPY NUMBER
268 -- x_msg_data OUT NOCOPY VARCHAR2
269 -- Version : Current version 1.0
270 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
271 -- and basic operation, developer must manually add parameters and business logic as necessary.
272 --
273 -- End of Comments
274 -- ==============================================================================
275 --
276 PROCEDURE Update_Process(
277 p_api_version_number IN NUMBER,
278 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279 p_commit IN VARCHAR2 := FND_API.G_FALSE,
280 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2,
285
286 p_process_tbl IN process_tbl_type := g_miss_process_tbl
287 );
288
289 -- ==============================================================================
290 -- Start of Comments
291 -- ==============================================================================
292 -- API Name
293 -- Delete_Process
294 -- Type
295 -- Private
296 -- Pre-Req
297 --
298 -- Parameters
299 --
300 -- IN
301 -- p_api_version_number IN NUMBER Required
302 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
303 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
304 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
305 -- p_PROCESS_ID IN NUMBER
306 -- p_object_version_number IN NUMBER Optional Default = NULL
307 --
308 -- OUT NOCOPY
309 -- x_return_status OUT NOCOPY VARCHAR2
310 -- x_msg_count OUT NOCOPY NUMBER
311 -- x_msg_data OUT NOCOPY VARCHAR2
312 -- Version : Current version 1.0
313 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
314 -- and basic operation, developer must manually add parameters and business logic as necessary.
315 --
316 -- End of Comments
317 -- ==============================================================================
318 --
319
320 PROCEDURE Delete_Process(
321 p_api_version_number IN NUMBER,
322 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323 p_commit IN VARCHAR2 := FND_API.G_FALSE,
324 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325 x_return_status OUT NOCOPY VARCHAR2,
326 x_msg_count OUT NOCOPY NUMBER,
327 x_msg_data OUT NOCOPY VARCHAR2,
328 p_process_rev_id IN NUMBER,
329 p_object_version_number IN NUMBER
330 );
331
332 -- ==============================================================================
333 -- Start of Comments
334 -- ==============================================================================
335 -- API Name
336 -- Lock_Process
337 -- Type
338 -- Private
339 -- Pre-Req
340 --
341 -- Parameters
342 --
343 -- IN
344 -- p_api_version_number IN NUMBER Required
345 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
346 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
347 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
348 -- p_process_rec IN process_rec_type Required
349 --
350 -- OUT NOCOPY
351 -- x_return_status OUT NOCOPY VARCHAR2
352 -- x_msg_count OUT NOCOPY NUMBER
353 -- x_msg_data OUT NOCOPY VARCHAR2
357 --
354 -- Version : Current version 1.0
355 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
356 -- and basic operation, developer must manually add parameters and business logic as necessary.
358 -- End of Comments
359 -- ==============================================================================
360 --
361
362 PROCEDURE Lock_Process(
363 p_api_version_number IN NUMBER,
364 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365
366 x_return_status OUT NOCOPY VARCHAR2,
367 x_msg_count OUT NOCOPY NUMBER,
368 x_msg_data OUT NOCOPY VARCHAR2,
369
370 p_process_id IN NUMBER,
371 p_object_version IN NUMBER
372 );
373
374
375 -- Start of Comments
376 --
377 -- validation procedures
378 --
379 -- p_validation_mode is a constant defined in AMW_UTILITY_PVT package
380 -- For create: G_CREATE, for update: G_UPDATE
381 -- Note: 1. This is automated generated item level validation procedure.
382 -- The actual validation detail is needed to be added.
383 -- 2. We can also validate table instead of record. There will be an option for user to choose.
384 -- End of Comments
385
386 PROCEDURE Validate_process(
387 p_api_version_number IN NUMBER,
388 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390 p_process_rec IN process_rec_type,
391 x_return_status OUT NOCOPY VARCHAR2,
392 x_msg_count OUT NOCOPY NUMBER,
393 x_msg_data OUT NOCOPY VARCHAR2
394 );
395
396 -- Start of Comments
397 --
398 -- validation procedures
399 --
400 -- p_validation_mode is a constant defined in AMW_UTILITY_PVT package
401 -- For create: G_CREATE, for update: G_UPDATE
402 -- Note: 1. This is automated generated item level validation procedure.
403 -- The actual validation detail is needed to be added.
404 -- 2. Validate the unique keys, lookups here
405 -- End of Comments
406
407 PROCEDURE Check_process_Items (
408 P_process_rec IN process_rec_type,
409 p_validation_mode IN VARCHAR2,
410 x_return_status OUT NOCOPY VARCHAR2
411 );
412
413 -- Start of Comments
414 --
415 -- Record level validation procedures
416 --
417 -- p_validation_mode is a constant defined in AMW_UTILITY_PVT package
418 -- For create: G_CREATE, for update: G_UPDATE
419 -- Note: 1. This is automated generated item level validation procedure.
420 -- The actual validation detail is needed to be added.
421 -- 2. Developer can manually added inter-field level validation.
422 -- End of Comments
423
424 PROCEDURE Validate_process_rec(
425 p_api_version_number IN NUMBER,
426 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
427 x_return_status OUT NOCOPY VARCHAR2,
428 x_msg_count OUT NOCOPY NUMBER,
429 x_msg_data OUT NOCOPY VARCHAR2,
430 p_process_rec IN process_rec_type
431 );
432 END AMW_Process_PVT;