[Home] [Help]
PACKAGE: APPS.PA_LIFECYCLES_PUB
Source
1 PACKAGE PA_LIFECYCLES_PUB AUTHID CURRENT_USER AS
2 /* $Header: PALCDFPS.pls 120.1 2005/08/19 16:35:29 mwasowic noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_LIFECYCLES_PUB';
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 : Public
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_init_msg_list IN VARCHAR2 Optional Default FND_API.G_TRUE
18 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
19 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
20 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
21 -- P_calling_module IN VARCHAR2 Optional Default 'SELF-SERVICE'
22 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
23 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
24 -- P_lifecycle_short_name IN VARCHAR2 Required
25 -- P_lifecycle_name IN VARCHAR2 Required
26 -- P_lifecycle_description IN VARCHAR2 Optional Default G_MISS_CHAR
27 -- P_lifecycle_project_usage_type IN VARCHAR2 Optional Default 'Y'
28 -- P_lifecycle_product_usage_type IN VARCHAR2 Optional Default G_MISS_CHAR
29 -- X_lifecycle_id OUT NUMBER
30 -- X_return_status OUT VARCHAR2
31 -- X_msg_count OUT NUMBER
32 -- X_msg_data OUT VARCHAR2
33 --
34 -- History :
35 -- 15-OCT-02 amksingh Created
36 -- End of comments
37
38
39 PROCEDURE create_lifecycle (
40 P_api_version IN NUMBER := 1.0 ,
41 P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
42 P_commit IN VARCHAR2 := FND_API.G_FALSE ,
43 P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
44 P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
45 P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
46 P_debug_mode IN VARCHAR2 := 'N' ,
47 P_max_msg_count IN NUMBER := G_MISS_NUM ,
48 P_lifecycle_short_name IN VARCHAR2 ,
49 P_lifecycle_name IN VARCHAR2 ,
50 P_lifecycle_description IN VARCHAR2 := G_MISS_CHAR ,
51 P_lifecycle_project_usage_type IN VARCHAR2 := 'Y' ,
52 P_lifecycle_product_usage_type IN VARCHAR2 := G_MISS_CHAR ,
53 X_lifecycle_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
54 X_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
55 X_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
56 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57 );
58
59
60 -- Start of comments
61 -- API name : create_lifecycle_phase
62 -- Type : Public
63 -- Pre-reqs : None.
64 -- Purpose : Creates a lifecycle phase for the given lifecycle
65 -- Parameters :
66 -- p_api_version IN NUMBER Optional Default 1.0
67 -- P_init_msg_list IN VARCHAR2 Optional Default FND_API.G_TRUE
68 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
69 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
70 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
71 -- P_calling_module IN VARCHAR2 Optional Default 'SELF-SERVICE'
72 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
73 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
74 -- P_lifecycle_id IN NUMBER Required
75 -- P_phase_status_name IN VARCHAR2 Required
76 -- P_phase_short_name IN VARCHAR2 Required
77 -- P_phase_name IN VARCHAR2 Required
78 -- P_phase_display_sequence IN NUMBER Required
79 -- P_phase_description IN VARCHAR2 Optional Default G_MISS_CHAR
80 -- X_lifecycle_phase_id OUT NUMBER
81 -- X_return_status OUT VARCHAR2
82 -- X_msg_count OUT NUMBER
83 -- X_msg_data OUT VARCHAR2
84 --
85 -- History :
86 -- 15-OCT-02 amksingh Created
87 -- End of comments
88
89
90 PROCEDURE create_lifecycle_phase(
91 P_api_version IN NUMBER := 1.0 ,
92 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
93 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
94 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
95 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
96 p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
97 p_debug_mode IN VARCHAR2 :='N' ,
98 P_max_msg_count IN NUMBER :=G_MISS_NUM ,
99 P_lifecycle_id IN NUMBER ,
100 P_phase_status_name IN VARCHAR2 ,
101 P_phase_short_name IN VARCHAR2 ,
102 P_phase_name IN VARCHAR2 ,
103 P_phase_display_sequence IN NUMBER ,
104 P_phase_description IN VARCHAR2 :=G_MISS_CHAR ,
105 X_lifecycle_phase_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
106 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
107 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
108 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
109 );
110
111
112 -- Start of comments
113 -- API name : update_lifecycle
114 -- Type : Public
115 -- Pre-reqs : None.
116 -- Purpose : updates a lifecycle. Lifecycle name, short name, description, and usage can be updated
117 -- Parameters :
118 -- p_api_version IN NUMBER Optional Default 1.0
119 -- P_init_msg_list IN VARCHAR2 Optional Default FND_API.G_TRUE
120 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
121 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
122 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
123 -- P_calling_module IN VARCHAR2 Optional Default 'SELF-SERVICE'
124 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
125 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
126 -- P_lifecycle_id IN NUMBER Required
127 -- P_lifecycle_short_name IN VARCHAR2 Optional Default G_MISS_CHAR
128 -- P_lifecycle_name IN VARCHAR2 Optional Default G_MISS_CHAR
129 -- P_lifecycle_description IN VARCHAR2 Optional Default G_MISS_CHAR
130 -- P_lifecycle_project_usage_type IN VARCHAR2 Optional Default G_MISS_CHAR
131 -- P_lifecycle_product_usage_type IN VARCHAR2 Optional Default G_MISS_CHAR
132 -- X_lifecycle_id OUT NUMBER
133 -- X_return_status OUT VARCHAR2
134 -- X_msg_count OUT NUMBER
135 -- X_msg_data OUT VARCHAR2
136 --
137 -- History :
138 -- 15-OCT-02 amksingh Created
139 -- End of comments
140
141 PROCEDURE update_lifecycle (
142 p_api_version IN NUMBER :=1.0 ,
143 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
144 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
145 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
146 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
147 p_calling_module IN VARCHAR2 :='SELF SERVICE' ,
148 p_debug_mode IN VARCHAR2 :='N' ,
149 p_max_msg_count IN NUMBER :=G_MISS_NUM ,
150 P_lifecycle_id IN NUMBER ,
151 P_lifecycle_short_name IN VARCHAR2 :=G_MISS_CHAR ,
152 P_lifecycle_name IN VARCHAR2 :=G_MISS_CHAR ,
153 P_lifecycle_description IN VARCHAR2 :=G_MISS_CHAR ,
154 P_lifecycle_project_usage_type IN VARCHAR2 :=G_MISS_CHAR ,
155 P_lifecycle_product_usage_type IN VARCHAR2 :=G_MISS_CHAR ,
156 P_record_version_number IN NUMBER ,
157 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
158 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
159 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
160 );
161
162 -- Start of comments
163 -- API name : update_lifecycle_phase
164 -- Type : Public
165 -- Pre-reqs : None.
166 -- Purpose : Updates a lifecycle phase for the given lifecycle
167 -- Parameters :
168 -- p_api_version IN NUMBER Optional Default 1.0
169 -- P_init_msg_list IN VARCHAR2 Optional Default FND_API.G_TRUE
170 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
171 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
172 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
173 -- P_calling_module IN VARCHAR2 Optional Default 'SELF-SERVICE'
174 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
175 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
176 -- P_lifecycle_id IN NUMBER Required
177 -- P_lifecycle_phase_id IN NUMBER Required
178 -- P_phase_code IN VARCHAR2 Optional Default G_MISS_CHAR
179 -- P_phase_short_name IN VARCHAR2 Optional Default G_MISS_CHAR
180 -- P_phase_name IN VARCHAR2 Optional Default G_MISS_CHAR
181 -- P_phase_display_sequence IN NUMBER Optional Default G_MISS_NUM
182 -- P_phase_description IN VARCHAR2 Optional Default G_MISS_CHAR
183 -- X_lifecycle_phase_id OUT NUMBER
184 -- X_return_status OUT VARCHAR2
185 -- X_msg_count OUT NUMBER
186 -- X_msg_data OUT VARCHAR2
187 --
188 -- History :
189 -- 15-OCT-02 amksingh Created
190 -- End of comments
191
192
193 PROCEDURE update_lifecycle_phase (
194 P_api_version IN NUMBER :=1.0 ,
195 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
196 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
197 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
198 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
199 p_calling_module IN VARCHAR2 :='SELF SERVICE' ,
200 p_debug_mode IN VARCHAR2 :='N' ,
201 P_max_msg_count IN NUMBER :=G_MISS_NUM ,
202 P_lifecycle_id IN NUMBER ,
203 P_lifecycle_phase_id IN NUMBER ,
204 P_phase_status_name IN VARCHAR2 :=G_MISS_CHAR ,
205 P_phase_short_name IN VARCHAR2 :=G_MISS_CHAR ,
206 P_phase_name IN VARCHAR2 :=G_MISS_CHAR ,
207 P_phase_display_sequence IN NUMBER :=G_MISS_NUM ,
208 P_phase_description IN VARCHAR2 :=G_MISS_CHAR ,
209 P_record_version_number IN NUMBER ,
210 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
211 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
212 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
213 );
214
215
216
217 -- Start of comments
218 -- API name : delete_lifecycle
219 -- Type : Public
220 -- Pre-reqs : None.
221 -- Purpose : deletes a given lifecycle
222 -- Parameters :
223 -- p_api_version IN NUMBER Optional Default 1.0
224 -- P_init_msg_list IN VARCHAR2 Optional Default FND_API.G_TRUE
225 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
226 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
227 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
228 -- P_calling_module IN VARCHAR2 Optional Default 'SELF-SERVICE'
229 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
230 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
231 -- P_lifecycle_id IN NUMBER Required
232 -- P_record_version_number IN NUMBER Required
233 -- X_return_status OUT VARCHAR2
234 -- X_msg_count OUT NUMBER
235 -- X_msg_data OUT VARCHAR2
236 --
237 -- History :
238 -- 15-OCT-02 amksingh Created
239 -- End of comments
240
241 PROCEDURE delete_lifecycle (
242 P_api_version IN NUMBER := 1.0 ,
243 P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
244 P_commit IN VARCHAR2 := FND_API.G_FALSE ,
245 P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
246 P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
247 P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
248 P_debug_mode IN VARCHAR2 := 'N' ,
249 P_max_msg_count IN NUMBER := G_MISS_NUM ,
250 P_lifecycle_id IN NUMBER ,
251 p_record_version_number IN NUMBER ,
252 X_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
253 X_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
254 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
255 );
256
257 -- Start of comments
258 -- API name : delete_lifecycle_phase
259 -- Type : Public
260 -- Pre-reqs : None.
261 -- Purpose : deletes a given lifecycle phase
262 -- Parameters :
263 -- p_api_version IN NUMBER Optional Default 1.0
264 -- P_init_msg_list IN VARCHAR2 Optional Default FND_API.G_TRUE
265 -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
266 -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
267 -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
268 -- P_calling_module IN VARCHAR2 Optional Default 'SELF-SERVICE'
269 -- P_debug_mode IN VARCHAR2 Optional Default 'N'
270 -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
271 -- P_lifecycle_id IN NUMBER Required
272 -- P_phase_id IN NUMBER Required
273 -- P_record_version_number IN NUMBER Required
274 -- X_return_status OUT VARCHAR2
275 -- X_msg_count OUT NUMBER
276 -- X_msg_data OUT VARCHAR2
277 --
278 -- History :
279 -- 15-OCT-02 amksingh Created
280 -- End of comments
281
282
283 PROCEDURE delete_lifecycle_phase (
284 P_api_version IN NUMBER := 1.0 ,
285 P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
286 P_commit IN VARCHAR2 := FND_API.G_FALSE ,
287 P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
288 P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
289 P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
290 P_debug_mode IN VARCHAR2 := 'N' ,
291 P_max_msg_count IN NUMBER := G_MISS_NUM ,
292 P_lifecycle_id IN NUMBER ,
293 P_phase_id IN NUMBER ,
294 p_record_version_number IN NUMBER ,
295 X_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
296 X_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
297 X_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
298 );
299
300 END PA_LIFECYCLES_PUB;