1 PACKAGE PA_LIFECYCLES_PVT AUTHID CURRENT_USER AS
2 /* $Header: PALCDFVS.pls 120.1 2005/08/19 16:35:36 mwasowic noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_LIFECYCLES_PVT';
5 G_MISS_NUM CONSTANT NUMBER := 9.99E125;
6 G_MISS_CHAR CONSTANT VARCHAR2(1) := chr(0);
7 G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
8
9
10 -- Start of comments
11 -- API name : create_lifecycle
12 -- Type : Private
13 -- Pre-reqs : None.
14 -- Purpose : Creates a lifecycle for the given name and short name
15 -- Parameters :
16 -- p_api_version IN NUMBER Optional Default 1.0
17 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
18 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
19 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
20 -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
21 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
22 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
23 -- P_lifecycle_short_name IN VARCHAR2 Required
24 -- P_lifecycle_name IN VARCHAR2 Required
25 -- P_lifecycle_description IN VARCHAR2 Required
26 -- P_lifecycle_project_usage_type IN VARCHAR2 Required
27 -- P_lifecycle_product_usage_type IN VARCHAR2 Required
28 -- X_lifecycle_id OUT NUMBER
29 -- X_return_status OUT VARCHAR2
30 -- X_msg_count OUT NUMBER
31 -- X_msg_data OUT VARCHAR2
32 --
33 -- History :
34 -- 15-OCT-02 amksingh Created
35 -- End of comments
36
37 PROCEDURE create_lifecycle (
38 P_api_version IN NUMBER :=1.0 ,
39 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
40 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
41 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
42 p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
43 p_debug_mode IN VARCHAR2 :='N' ,
44 p_max_msg_count IN NUMBER :=G_MISS_NUM ,
45 P_lifecycle_short_name IN VARCHAR2 ,
46 P_lifecycle_name IN VARCHAR2 ,
47 P_lifecycle_description IN VARCHAR2 ,
48 P_lifecycle_project_usage_type IN VARCHAR2 ,
49 P_lifecycle_product_usage_type IN VARCHAR2 ,
50 X_lifecycle_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
51 X_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
52 X_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
53 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
54 );
55
56
57 -- Start of comments
58 -- API name : create_lifecycle_phase
59 -- Type : Private
60 -- Pre-reqs : None.
61 -- Purpose : Creates a lifecycle phase the given name and short name
62 -- Parameters :
63 -- p_api_version IN NUMBER Optional Default a1.0
64 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
65 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
66 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
67 -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
68 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
69 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
70 -- P_lifecycle_id IN NUMBER Required
71 -- P_phase_code IN VARCHAR2 Required
72 -- P_phase_short_name IN VARCHAR2 Required
73 -- P_phase_name IN VARCHAR2 Required
74 -- P_phase_display_sequence IN NUMBER Required
75 -- P_phase_description IN VARCHAR2 Required
76 -- X_lifecycle_phase_id OUT NUMBER
77 -- X_return_status OUT VARCHAR2
78 -- X_msg_count OUT NUMBER
79 -- X_msg_data OUT VARCHAR2
80 --
81 -- History :
82 -- 15-OCT-02 amksingh Created
83 -- End of comments
84
85
86 Procedure create_lifecycle_phase (
87 P_api_version IN NUMBER :=1.0 ,
88 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
89 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
90 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
91 p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
92 p_debug_mode IN VARCHAR2 :='N' ,
93 P_max_msg_count IN NUMBER :=G_MISS_NUM ,
94 P_lifecycle_id IN NUMBER ,
95 P_phase_display_sequence IN NUMBER ,
96 P_phase_code IN VARCHAR2 ,
97 P_phase_short_name IN VARCHAR2 ,
98 P_phase_name IN VARCHAR2 ,
99 P_phase_description IN VARCHAR2 ,
100 X_lifecycle_phase_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
101 X_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
102 X_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
103 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
104 );
105
106 -- Start of comments
107 -- API name : update_lifecycle
108 -- Type : Private
109 -- Pre-reqs : None.
110 -- Purpose : Updates a lifecycle for the given name and short name
111 -- Parameters :
112 -- p_api_version IN NUMBER Optional Default a1.0
113 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
114 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
115 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
116 -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
117 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
118 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
119 -- P_lifecycle_id IN NUMBER Required
120 -- P_lifecycle_short_name IN VARCHAR2 Required
121 -- P_lifecycle_name IN VARCHAR2 Required
122 -- P_lifecycle_description IN VARCHAR2 Required
123 -- P_lifecycle_project_usage_type IN VARCHAR2 Required
124 -- P_lifecycle_product_usage_type IN VARCHAR2 Required
125 -- P_record_version_number IN NUMBER Required
126 -- X_return_status OUT VARCHAR2
127 -- X_msg_count OUT NUMBER
128 -- X_msg_data OUT VARCHAR2
129 --
130 -- History :
131 -- 15-OCT-02 amksingh Created
132 -- End of comments
133
134 PROCEDURE update_lifecycle (
135 p_api_version IN NUMBER :=1.0 ,
136 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
137 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
138 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
139 p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
140 p_debug_mode IN VARCHAR2 :='N' ,
141 p_max_msg_count IN NUMBER :=G_MISS_NUM ,
142 P_lifecycle_id IN NUMBER ,
143 P_lifecycle_short_name IN VARCHAR2 ,
144 P_lifecycle_name IN VARCHAR2 ,
145 P_lifecycle_description IN VARCHAR2 ,
146 P_lifecycle_project_usage_type IN VARCHAR2 ,
147 P_lifecycle_product_usage_type IN VARCHAR2 ,
148 P_record_version_number IN NUMBER ,
149 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
150 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
151 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152 );
153
154 -- Start of comments
155 -- API name : update_lifecycle_phase
156 -- Type : Private
157 -- Pre-reqs : None.
158 -- Purpose : Updates a lifecycle phase after checking the constraints.
159 -- Parameters :
160 -- p_api_version IN NUMBER Optional Default a1.0
161 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
162 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
163 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
164 -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
165 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
166 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
167 -- P_lifecycle_id IN NUMBER Required
168 -- P_lifecycle_phase_id IN NUMBER Required
169 -- P_phase_display_sequence IN NUMBER Required
170 -- P_phase_code IN VARCHAR2 Required
171 -- P_phase_short_name IN VARCHAR2 Required
172 -- P_phase_name IN VARCHAR2 Required
173 -- P_phase_description IN VARCHAR2 Required
174 -- P_record_version_number IN NUMBER Required
175 -- X_return_status OUT VARCHAR2
176 -- X_msg_count OUT NUMBER
177 -- X_msg_data OUT VARCHAR2
178 --
179 -- History :
180 -- 15-OCT-02 amksingh Created
181 -- End of comments
182
183
184 PROCEDURE update_lifecycle_phase (
185 P_api_version IN NUMBER :=1.0 ,
186 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
187 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
188 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
189 p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
190 p_debug_mode IN VARCHAR2 :='N' ,
191 P_max_msg_count IN NUMBER :=G_MISS_NUM ,
192 P_lifecycle_id IN NUMBER ,
193 P_lifecycle_phase_id IN NUMBER ,
194 P_phase_display_sequence IN NUMBER ,
195 P_phase_code IN VARCHAR2 ,
196 P_phase_short_name IN VARCHAR2 ,
197 P_phase_name IN VARCHAR2 ,
198 P_phase_description IN VARCHAR2 ,
199 P_record_version_number IN NUMBER ,
200 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
201 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
202 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
203 );
204
205
206 -- Start of comments
207 -- API name : delete_lifecycle
208 -- Type : Private
209 -- Pre-reqs : None.
210 -- Purpose : deletes a given lifecycle
211 -- Parameters :
212 -- p_api_version IN NUMBER Optional Default 1.0
213 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
214 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
215 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
216 -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
217 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
218 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
219 -- P_lifecycle_id IN NUMBER Required
220 -- P_record_version_number IN NUMBER Required
221 -- X_return_status OUT VARCHAR2
222 -- X_msg_count OUT NUMBER
223 -- X_msg_data OUT VARCHAR2
224 --
225 -- History :
226 -- 15-OCT-02 amksingh Created
227 -- End of comments
228
229 PROCEDURE delete_lifecycle (
230 P_api_version IN NUMBER := 1.0 ,
231 P_commit IN VARCHAR2 := FND_API.G_FALSE ,
232 P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
233 P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
234 P_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
235 P_debug_mode IN VARCHAR2 := 'N' ,
236 P_max_msg_count IN NUMBER := G_MISS_NUM ,
237 P_lifecycle_id IN NUMBER ,
238 p_record_version_number IN NUMBER ,
239 X_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
240 X_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
241 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
242 );
243
244
245 -- Start of comments
246 -- API name : delete_lifecycle_phase
247 -- Type : Private
248 -- Pre-reqs : None.
249 -- Purpose : deletes a given lifecycle phase
250 -- Parameters :
251 -- p_api_version IN NUMBER Optional Default 1.0
252 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
253 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
254 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
255 -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
256 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
257 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
258 -- P_phase_id IN NUMBER Required
259 -- P_record_version_number IN NUMBER Required
260 -- X_return_status OUT VARCHAR2
261 -- X_msg_count OUT NUMBER
262 -- X_msg_data OUT VARCHAR2
263 --
264 -- History :
265 -- 15-OCT-02 amksingh Created
266 -- End of comments
267
268
269 PROCEDURE delete_lifecycle_phase (
270 P_api_version IN NUMBER := 1.0 ,
271 P_commit IN VARCHAR2 := FND_API.G_FALSE ,
272 P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
273 P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
274 P_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
275 P_debug_mode IN VARCHAR2 := 'N' ,
276 P_max_msg_count IN NUMBER := G_MISS_NUM ,
277 P_phase_id IN NUMBER ,
278 p_record_version_number IN NUMBER ,
279 X_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
280 X_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
281 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
282 );
283
284 -- Start of comments
285 -- API name : check_delete_lifecycle_ok
286 -- Type : Private
287 -- Pre-reqs : None.
288 -- Purpose : checks for the constraints before deleting a given lifecycle
289 -- Parameters :
290 -- p_api_version IN NUMBER Optional Default 1.0
291 -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
292 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
293 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
294 -- P_lifecycle_id IN NUMBER Required
295 -- P_lifecycle_version_id IN NUMBER Required
296 -- X_return_status OUT VARCHAR2
297 -- X_msg_count OUT NUMBER
298 -- X_msg_data OUT VARCHAR2
299 --
300 -- History :
301 -- 15-OCT-02 amksingh Created
302 -- End of comments
303
304 PROCEDURE check_delete_lifecycle_ok(
305 P_api_version IN NUMBER := 1.0 ,
306 p_calling_module in VARCHAR2 := 'SELF_SERVICE' ,
307 p_debug_mode in VARCHAR2 := 'N' ,
308 p_max_msg_count in NUMBER := G_MISS_NUM ,
309 p_lifecycle_id in NUMBER ,
310 P_lifecycle_version_id IN NUMBER ,
311 X_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
312 X_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
313 X_msg_data OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
314 X_del_lifecycle_ok OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
315 );
316
317 -- Start of comments
318 -- API name : check_delete_lcyl_phase_ok
319 -- Type : Private
320 -- Pre-reqs : None.
321 -- Purpose : checks for the constraints before deleting a given lifecycle
322 -- Parameters :
323 -- p_api_version IN NUMBER Optional Default 1.0
324 -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
325 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
326 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
327 -- P_lifecycle_id IN NUMBER Required
328 -- P_lifecycle_phase_id IN NUMBER Required
329 -- x_delete_ok OUT VARCHAR2
330 -- X_return_status OUT VARCHAR2
331 -- X_msg_count OUT NUMBER
332 -- X_msg_data OUT VARCHAR2
333 --
334 -- History :
335 -- 15-OCT-02 amksingh Created
336 -- End of comments
337
338 PROCEDURE check_delete_lcyl_phase_ok(
339 P_api_version IN NUMBER := 1.0 ,
340 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
341 p_debug_mode IN VARCHAR2 := 'N' ,
342 P_max_msg_count IN NUMBER := G_MISS_NUM ,
343 P_lifecycle_id IN NUMBER ,
344 P_lifecycle_phase_id IN NUMBER ,
345 x_delete_ok OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
346 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
347 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
348 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
349 );
350
351 END PA_LIFECYCLES_PVT;