1 PACKAGE PA_RESOURCE_PUB AUTHID DEFINER AS
2 /*$Header: PAPMREPS.pls 120.3 2006/07/05 10:18:16 sunkalya noship $*/
3 /*#
4 * You can use the resource APIs to export your resource lists and the resources they include to Oracle Projects.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Create Resources
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJ_PLANNING_RESOURCE
11 * @rep:category BUSINESS_ENTITY PA_BUDGET
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14 -- -------------------------------------------------------------------------------------------------------
15 -- Globals
16 -- -------------------------------------------------------------------------------------------------------
17
18 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_RESOURCE_PUB';
19
20 G_HEADER_CODE CONSTANT VARCHAR2(6) := 'LIST';
21 G_LINE_CODE CONSTANT VARCHAR2(6) := 'MEMBER';
22 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
23
24 ROW_ALREADY_LOCKED EXCEPTION;
25 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
26
27 -- -------------------------------------------------------------------------------------------------------
28 -- Record/Table Definitions
29 -- -------------------------------------------------------------------------------------------------------
30
31 TYPE resource_list_rec IS RECORD
32
33 ( resource_list_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
34 description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35 group_resource_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
36 start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37 end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38 resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39 new_list_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40 job_group_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Added for bug 2486405.
41 );
42
43 TYPE resource_list_out_rec IS RECORD
44
45 ( resource_list_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46 return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
47
48 TYPE member_rec IS RECORD
49
50 ( resource_group_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
51 resource_group_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
52 resource_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53 resource_attr_value VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54 resource_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55 sort_order NUMBER := NULL,
56 resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
57 new_alias VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
58 enabled_flag VARCHAR2(1) := 'Y' );
59
60 TYPE member_out_rec IS RECORD
61
62 ( resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
63 return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
64
65 TYPE member_tbl IS TABLE OF member_rec
66 INDEX BY BINARY_INTEGER;
67
68 TYPE member_out_tbl IS TABLE OF member_out_rec
69 INDEX BY BINARY_INTEGER;
70
71
72 g_resource_list_rec resource_list_rec;
73 g_resource_list_out_rec resource_list_out_rec;
74 g_member_tbl member_tbl;
75 g_member_out_tbl member_out_tbl;
76 g_member_tbl_count NUMBER := 0;
77
78 g_miss_resource_list_rec resource_list_rec;
79 g_miss_resource_list_out_rec resource_list_out_rec;
80
81 g_load_resource_list_id NUMBER := 0;
82 g_load_member_tbl member_tbl;
83 g_load_member_out_tbl member_out_tbl;
84 g_load_member_tbl_count NUMBER := 0;
85
86 g_update_resource_list_id NUMBER := 0;
87 g_update_member_tbl member_tbl;
88 g_update_member_out_tbl member_out_tbl;
89 g_update_member_tbl_count NUMBER := 0;
90
91 -- -------------------------------------------------------------------------------------------------------
92 -- Procedures
93 -- -------------------------------------------------------------------------------------------------------
94 /*#
95 * This API creates a resource list and optionally creates the resource list members.
96 * @param p_commit API standard (default = F): indicates if the transaction will be committed
97 * @rep:paraminfo {@rep:precision 1}
98 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
99 * @param p_api_version_number API standard: version number
100 * @rep:paraminfo {@rep:required}
101 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
102 * @rep:paraminfo {@rep:required}
103 * @param p_msg_count API standard: number of error messages
104 * @rep:paraminfo {@rep:required}
105 * @param p_msg_data API standard: error message
106 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
107 * @param p_resource_list_rec Resource list input structure
108 * @rep:paraminfo {@rep:required}
109 * @param p_resource_list_out_rec Resource list output structure
110 * @rep:paraminfo {@rep:required}
111 * @param p_member_tbl Resource list members input structure
112 * @rep:paraminfo {@rep:required}
113 * @param p_member_out_tbl Resource list members output structure
114 * @rep:paraminfo {@rep:required}
115 * @rep:scope public
116 * @rep:lifecycle active
117 * @rep:displayname Create Resource List
118 * @rep:compatibility S
119 */
120 PROCEDURE Create_Resource_List
121 (p_commit IN VARCHAR2 := FND_API.G_FALSE,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_api_version_number IN NUMBER,
124 p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
125 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
126 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
127 p_resource_list_rec IN resource_list_rec,
128 p_resource_list_out_rec OUT NOCOPY resource_list_out_rec, --File.Sql.39 bug 4440895
129 p_member_tbl IN member_tbl,
130 p_member_out_tbl OUT NOCOPY member_out_tbl ); --File.Sql.39 bug 4440895
131
132 PROCEDURE Process_Members
133 (p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
134 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
135 p_member_tbl IN member_tbl,
136 p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
137 p_job_group_id IN NUMBER, -- Added for bug 2486405
138 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
139 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140 p_member_out_tbl OUT NOCOPY member_out_tbl ); --File.Sql.39 bug 4440895
141
142 /*#
143 * This API sets up the global data structures used by other Load-Execute-Fetch procedures.
144 * In order to execute this API the following list of API's should be executed in the following order.
145 * INIT_CREATE_RESOURCE_LIST,
146 * LOAD_RESOURCE_LIST,
147 * INIT_UPDATE_MEMBERS,
148 * LOAD_MEMBERS,
149 * EXEC_CREATE_RESOURCE_LIST / EXEC_UPDATE_RESOURCE_LIST,
150 * FETCH_RESOURCE_LIST,
151 * FETCH_MEMBERS,
152 * CLEAR_UPDATE_MEMBERS and
153 * CLEAR_CREATE_RESOURCE_LIST
154 * @rep:scope public
155 * @rep:lifecycle active
156 * @rep:displayname Create Multiple Resource Lists-Initialize
157 * @rep:compatibility S
158 */
159 PROCEDURE Init_Create_Resource_List ;
160 /*#
161 * This API loads the resource list global input structure.
162 * In order to execute this API the following list of API's should be executed in the following order.
163 * INIT_CREATE_RESOURCE_LIST,
164 * LOAD_RESOURCE_LIST,
165 * INIT_UPDATE_MEMBERS,
166 * LOAD_MEMBERS,
167 * EXEC_CREATE_RESOURCE_LIST / EXEC_UPDATE_RESOURCE_LIST,
168 * FETCH_RESOURCE_LIST,
169 * FETCH_MEMBERS,
170 * CLEAR_UPDATE_MEMBERS and
171 * CLEAR_CREATE_RESOURCE_LIST
172 * @param p_api_version_number API standard: version number
173 * @rep:paraminfo {@rep:required}
174 * @param p_resource_list_name Name of the resource list
175 * @param p_description Description of the resource list
176 * @param p_group_resource_type Type of the resource group
177 * @param p_start_date Start date of the resource list
178 * @param p_end_date End date of the resource list
179 * @param p_resource_list_id Identifier of the resource list
180 * @param p_new_list_name New name of the resource list
181 * @param p_job_group_id Job group identifier of the job associated with the resource list. System generated primary key
182 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
183 * @rep:paraminfo {@rep:required}
184 * @rep:scope public
185 * @rep:lifecycle active
186 * @rep:displayname Create Multiple Resource Lists-Load
187 * @rep:compatibility S
188 */
189 PROCEDURE Load_Resource_List
190 ( p_api_version_number IN NUMBER,
191 p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
192 p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
193 p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194 p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195 p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
197 p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
198 p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Added for bug 2486405.
199 p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
200 /*#
201 * This API loads the resource list member global input structure.
202 * In order to execute this API the following list of API's should be executed in the following order.
203 * INIT_CREATE_RESOURCE_LIST,
204 * LOAD_RESOURCE_LIST,
205 * INIT_UPDATE_MEMBERS,
206 * LOAD_MEMBERS,
207 * EXEC_CREATE_RESOURCE_LIST / EXEC_UPDATE_RESOURCE_LIST,
208 * FETCH_RESOURCE_LIST,
209 * FETCH_MEMBERS,
210 * CLEAR_UPDATE_MEMBERS and
211 * CLEAR_CREATE_RESOURCE_LIST
212 * @param p_api_version_number API standard: version number
213 * @rep:paraminfo {@rep:required}
214 * @param p_resource_group_alias Alias of the resource group
215 * @param p_resource_group_name Name of the resource group
216 * @param p_resource_type_code Type code of the resource
217 * @param p_resource_attr_value Attribute value of the resource
218 * @param p_resource_alias Alias of the resource member
219 * @param p_resource_list_member_id Identifier of the resource list member
220 * @param p_new_alias New alias of the resource member
221 * @param p_sort_order Sort order of the resource member
222 * @param p_enabled_flag Flag indicating whether the resource list member is enabled
223 * @rep:paraminfo {@rep:precision 1}
224 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
225 * @rep:paraminfo {@rep:required}
226 * @rep:scope public
227 * @rep:lifecycle active
228 * @rep:displayname Update Mulitple Members-Load
229 * @rep:compatibility S
230 */
231 PROCEDURE Load_Members
232 ( p_api_version_number IN NUMBER,
233 p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
234 p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235 p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236 p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
237 p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238 p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
239 p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
240 p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
241 p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
242 p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
243 /*#
244 * This API executes the composite API CREATE_RESOURCE_LIST.
245 * In order to execute this API the following list of API's should be executed in the following order.
246 * INIT_CREATE_RESOURCE_LIST,
247 * LOAD_RESOURCE_LIST,
248 * INIT_UPDATE_MEMBERS,
249 * LOAD_MEMBERS,
250 * EXEC_CREATE_RESOURCE_LIST,
251 * FETCH_RESOURCE_LIST,
252 * FETCH_MEMBERS,
253 * CLEAR_UPDATE_MEMBERS and
254 * CLEAR_CREATE_RESOURCE_LIST
255 * @param p_commit API standard (default = F): indicates if the transaction will be committed
256 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
257 * @param p_api_version_number API standard: version number
258 * @rep:paraminfo {@rep:required}
259 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
260 * @rep:paraminfo {@rep:required}
261 * @param p_msg_count API standard: number of error messages
262 * @rep:paraminfo {@rep:required}
263 * @param p_msg_data API standard: error message
264 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
265 * @rep:scope public
266 * @rep:lifecycle active
267 * @rep:displayname Create Multiple Resource Lists-Execute Create
268 * @rep:compatibility S
269 */
270 PROCEDURE Exec_Create_Resource_List
271 (p_commit IN VARCHAR2 := FND_API.G_FALSE,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273 p_api_version_number IN NUMBER,
274 p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
275 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
276 p_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
277
278 /*#
279 * This API fetches one resource list identifier at a time from the global output structure for resource lists.
280 * In order to execute this API the following list of API's should be executed in the following order.
281 * INIT_CREATE_RESOURCE_LIST,
282 * LOAD_RESOURCE_LIST,
283 * INIT_UPDATE_MEMBERS,
284 * LOAD_MEMBERS,
285 * EXEC_CREATE_RESOURCE_LIST / EXEC_UPDATE_RESOURCE_LIST,
286 * FETCH_RESOURCE_LIST,
287 * FETCH_MEMBERS,
288 * CLEAR_UPDATE_MEMBERS and
289 * CLEAR_CREATE_RESOURCE_LIST
290 * @param p_api_version_number API standard: version number
291 * @rep:paraminfo {@rep:required}
292 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
293 * @rep:paraminfo {@rep:required}
294 * @param p_resource_list_id Identifier of the resource list
295 * @rep:paraminfo {@rep:required}
296 * @param p_list_return_status Return status of the specific resource list
297 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
298 * @rep:scope public
299 * @rep:lifecycle active
300 * @rep:displayname Create Multiple Resource Lists-Fetch
301 * @rep:compatibility S
302 */
303 PROCEDURE Fetch_Resource_List
304 (p_api_version_number IN NUMBER,
305 p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
306 p_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
307 p_list_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
308
309
310 /*#
311 * This API fetches resource members from the global output structure for resource list members.
312 * In order to execute this API the following list of API's should be executed in the following order.
313 * INIT_CREATE_RESOURCE_LIST,
314 * LOAD_RESOURCE_LIST,
315 * INIT_UPDATE_MEMBERS,
316 * LOAD_MEMBERS,
317 * EXEC_CREATE_RESOURCE_LIST / EXEC_UPDATE_RESOURCE_LIST,
318 * FETCH_RESOURCE_LIST,
319 * FETCH_MEMBERS,
320 * CLEAR_UPDATE_MEMBERS and
321 * CLEAR_CREATE_RESOURCE_LIST
322 * @param p_api_version_number API standard: version number
323 * @rep:paraminfo {@rep:required}
324 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
325 * @rep:paraminfo {@rep:required}
326 * @param p_member_index Member index (default = 1)
327 * @param p_resource_list_member_id Identifier of the resource list member
328 * @rep:paraminfo {@rep:required}
329 * @param p_member_return_status Return status of the specific resource list member
330 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
331 * @rep:scope public
332 * @rep:lifecycle active
333 * @rep:displayname Update Multiple Members-Fetch
334 * @rep:compatibility S
335 */
336 PROCEDURE Fetch_Members
337 ( p_api_version_number IN NUMBER,
338 p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
339 p_member_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
340 p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
341 p_member_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
342 /*#
343 * This API clears the global data structures created during the initialize process.
344 * In order to execute this API the following list of API's should be executed in the following order.
345 * INIT_CREATE_RESOURCE_LIST,
346 * LOAD_RESOURCE_LIST,
347 * INIT_UPDATE_MEMBERS,
348 * LOAD_MEMBERS,
349 * EXEC_CREATE_RESOURCE_LIST / EXEC_UPDATE_RESOURCE_LIST,
350 * FETCH_RESOURCE_LIST,
351 * FETCH_MEMBERS,
352 * CLEAR_UPDATE_MEMBERS and
353 * CLEAR_CREATE_RESOURCE_LIST
354 * @rep:scope public
355 * @rep:lifecycle active
356 * @rep:displayname Create Multiple Resource Lists-Clear
357 * @rep:compatibility S
358 */
359 PROCEDURE Clear_Create_Resource_List ;
360 -- ----------------------------------------------------------
361 /*#
362 * This API updates an existing resource list, including updating existing or adding new resource list members.
363 * @param p_commit API standard (default = F): indicates if the transaction will be committed
364 * @param p_api_version_number API standard: version number
365 * @rep:paraminfo {@rep:required}
366 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
367 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
368 * @rep:paraminfo {@rep:required}
369 * @param p_msg_count API standard: number of error messages
370 * @rep:paraminfo {@rep:required}
371 * @param p_msg_data API standard: error message
372 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
373 * @param p_resource_list_name Name of the resource list
374 * @param p_resource_list_id Identifier of the resource list
375 * @param p_new_list_name New name of the existing resource list
376 * @param p_grouped_by_type Group by type of the resource list
377 * @param p_description Description of the resource list
378 * @param p_start_date Start date of the resource list
379 * @param p_end_date End date of the resource list
380 * @param p_member_tbl Resource list members input structure
381 * @rep:paraminfo {@rep:required}
382 * @param p_member_out_tbl Resource list members output structure
383 * @rep:paraminfo {@rep:required}
384 * @rep:scope public
385 * @rep:lifecycle active
386 * @rep:displayname Update Resource List
387 * @rep:compatibility S
388 */
389 PROCEDURE Update_Resource_List
390 (p_commit IN VARCHAR2 := FND_API.G_FALSE,
391 p_api_version_number IN NUMBER,
392 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
393 p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
394 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
395 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
396 p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
397 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
398 p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399 p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400 p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401 p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
402 p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
403 p_member_tbl IN member_tbl,
404 p_member_out_tbl OUT NOCOPY member_out_tbl --File.Sql.39 bug 4440895
405 );
406
407 /*#
408 * This API sets up the global data structures used by other Load-Execute-Fetch procedures.
409 * In order to execute this API the following list of API's should be executed in the following order.
410 * INIT_CREATE_RESOURCE_LIST,
411 * LOAD_RESOURCE_LIST,
412 * INIT_UPDATE_MEMBERS,
413 * LOAD_MEMBERS,
414 * EXEC_CREATE_RESOURCE_LIST / EXEC_UPDATE_RESOURCE_LIST,
415 * FETCH_RESOURCE_LIST,
416 * FETCH_MEMBERS,
417 * CLEAR_UPDATE_MEMBERS and
418 * CLEAR_CREATE_RESOURCE_LIST
419 * @rep:scope public
420 * @rep:lifecycle active
421 * @rep:displayname Update Multiple Members-Initialize
422 * @rep:compatibility S
423 */
424 PROCEDURE Init_Update_Members ;
425
426 /*#
427 * This API executes the composite API UPDATE_RESOURCE_LIST.
428 * In order to execute this API the following list of API's should be executed in the following order.
429 * INIT_CREATE_RESOURCE_LIST,
430 * LOAD_RESOURCE_LIST,
431 * INIT_UPDATE_MEMBERS,
432 * LOAD_MEMBERS,
433 * EXEC_UPDATE_RESOURCE_LIST,
434 * FETCH_RESOURCE_LIST,
435 * FETCH_MEMBERS and
436 * CLEAR_UPDATE_MEMBERS
437 * CLEAR_CREATE_RESOURCE_LIST
438 * @param p_commit API standard (default = F): indicates if the transaction will be committed
439 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
440 * @param p_api_version_number API standard: version number
441 * @rep:paraminfo {@rep:required}
442 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
443 * @rep:paraminfo {@rep:required}
444 * @param p_msg_count API standard: number of error messages
445 * @rep:paraminfo {@rep:required}
446 * @param p_msg_data API standard: error message
447 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
448 * @rep:scope public
449 * @rep:lifecycle active
450 * @rep:displayname Update Multiple Resource Lists
451 * @rep:compatibility S
452 */
453 PROCEDURE Exec_Update_Resource_List
454 (p_commit IN VARCHAR2 := FND_API.G_FALSE,
455 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
456 p_api_version_number IN NUMBER,
457 p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
458 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
459 p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
460 );
461
462 /*#
463 * This API clears the global data structures that were created during the initialize step for
464 * the Load-Execute-Fetch update APIs.
465 * In order to execute this API the following list of API's should be executed in the following order.
466 * INIT_CREATE_RESOURCE_LIST,
467 * LOAD_RESOURCE_LIST,
468 * INIT_UPDATE_MEMBERS,
469 * LOAD_MEMBERS,
470 * EXEC_CREATE_RESOURCE_LIST / EXEC_UPDATE_RESOURCE_LIST,
471 * FETCH_RESOURCE_LIST,
472 * FETCH_MEMBERS,
473 * CLEAR_UPDATE_MEMBERS and
474 * CLEAR_CREATE_RESOURCE_LIST
475 * @rep:scope public
476 * @rep:lifecycle active
477 * @rep:displayname Update Multiple Members-Clear
478 * @rep:compatibility S
479 */
480 PROCEDURE Clear_Update_Members ;
481 -- ---------------------------------------------------------
482 /*#
483 * This API deletes a resource member from an existing resource list.
484 * @param p_commit API standard (default = F): indicates if the transaction will be committed
485 * @param p_api_version_number API standard: version number
486 * @rep:paraminfo {@rep:required}
487 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
488 * @param p_resource_list_name Name of the resource list
489 * @param p_resource_list_id Identification code of resource list
490 * @param p_msg_count API standard: number of error messages
491 * @rep:paraminfo {@rep:required}
492 * @param p_msg_data API standard: error message
493 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
494 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
495 * @rep:paraminfo {@rep:required}
496 * @param x_err_code The error handling code
497 * @rep:paraminfo {@rep:required}
498 * @param x_err_stage The point of occurrence of an error
499 * @rep:paraminfo {@rep:required}
500 * @rep:scope public
501 * @rep:lifecycle active
502 * @rep:displayname Delete Resource List
503 * @rep:compatibility S
504 */
505 PROCEDURE Delete_Resource_List
506 ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
507 p_api_version_number IN NUMBER,
508 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509 p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
510 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
511 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
512 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
513 p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
514 x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
515 x_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
516 );
517
518 -- ----------------------------------------------------------
519 /*#
520 * This API adds a resource member to an existing resource list.
521 * @param p_commit API standard (default = F): indicates if the transaction will be committed
522 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
523 * @param p_api_version_number API standard: version number
524 * @rep:paraminfo {@rep:required}
525 * @param p_resource_list_name Name of the resource list
526 * @param p_resource_list_id Identifier of the resource list
527 * @param p_resource_group_alias Alias of the resource group
528 * @param p_resource_group_name Name of the resource group
529 * @param p_resource_type_code Type of the resource
530 * @param p_resource_attr_value Attribute value of the resource
531 * @param p_resource_alias Alias of the resource list member
532 * @rep:paraminfo {@rep:required}
533 * @param p_sort_order Sort order of the resource list member
534 * @param p_enabled_flag Flag indicating that whether the resource list member is enabled
535 * @param p_resource_list_member_id Identifier of the resource list member
536 * @rep:paraminfo {@rep:required}
537 * @param p_msg_count API standard: number of error messages
538 * @rep:paraminfo {@rep:required}
539 * @param p_msg_data API standard: error message
540 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
541 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
542 * @rep:paraminfo {@rep:required}
543 * @rep:scope public
544 * @rep:lifecycle active
545 * @rep:displayname Create Resource List Member
546 * @rep:compatibility S
547 */
548 PROCEDURE Add_Resource_List_Member
549 (p_commit IN VARCHAR2 := FND_API.G_FALSE,
550 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551 p_api_version_number IN NUMBER,
552 p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
553 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
554 p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
555 p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
556 p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
557 p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
558 p_resource_alias IN VARCHAR2 ,
559 p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
560 p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
561 p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
562 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
563 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
564 p_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
565
566 /*#
567 * This API updates the alias and enables or disables the resource list members.
568 * @param p_commit API standard (default = F): indicates if the transaction will be committed
569 * @param p_api_version_number API standard: version number
570 * @rep:paraminfo {@rep:required}
571 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
572 * @param p_resource_list_name Name of the resource list
573 * @param p_resource_list_id Identifier of the resource list
574 * @param p_resource_alias Alias of the resource list member
575 * @param p_resource_list_member_id Identifier of the resource list member
576 * @param p_new_alias New alias of the resource list member
577 * @param p_sort_order Sort order of the resource list member
578 * @param p_enabled_flag Flag indicating whether the resource list member is enabled
579 * @param p_msg_count API standard: number of error messages
580 * @rep:paraminfo {@rep:required}
581 * @param p_msg_data API standard: error message
582 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
583 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
584 * @rep:paraminfo {@rep:required}
585 * @rep:scope public
586 * @rep:lifecycle active
587 * @rep:displayname Update Resource List Member
588 * @rep:compatibility S
589 */
590 PROCEDURE Update_Resource_List_Member
591 ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
592 p_api_version_number IN NUMBER,
593 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594 p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
595 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
596 p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
597 p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
598 p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
599 p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
600 p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
601 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
602 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
603 p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
604 ) ;
605
606 /*#
607 * This API deletes a resource list member.
608 * @param p_commit API standard (default = F): indicates if the transaction will be committed
609 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
610 * @param p_api_version_number API standard: version number
611 * @rep:paraminfo {@rep:required}
612 * @param p_resource_list_name Name of the resource list
613 * @param p_resource_list_id Identifier of the resource list
614 * @param p_resource_alias Alias of the resource list member
615 * @param p_resource_list_member_id Identifier of the resource list member
616 * @param p_msg_count API standard: number of error messages
617 * @rep:paraminfo {@rep:required}
618 * @param p_msg_data API standard: error message
619 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
620 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
621 * @rep:paraminfo {@rep:required}
622 * @param x_err_code The error handling code
623 * @rep:paraminfo {@rep:required}
624 * @param x_err_stage The point of occurrence of an error
625 * @rep:paraminfo {@rep:required}
626 * @rep:scope public
627 * @rep:lifecycle active
628 * @rep:displayname Delete Resource List Member
629 * @rep:compatibility S
630 */
631 PROCEDURE Delete_Resource_List_Member
632 ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
633 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634 p_api_version_number IN NUMBER,
635 p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
636 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
637 p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
638 p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
639 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
640 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
641 p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
642 x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
643 x_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
644 ) ;
645
646 /*#
647 * This API updates the sort order for resource members in a given resource list
648 * @param p_commit API standard (default = F): indicates if the transaction will be committed
649 * @param p_api_version_number API standard: version number
650 * @rep:paraminfo {@rep:required}
651 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
652 * @param p_resource_list_name Name of the resource list
653 * @param p_resource_list_id Identifier of the resource list
654 * @param p_resource_group_alias Alias of the resource group
655 * @param p_sort_by Sort by code
656 * @rep:paraminfo {@rep:required}
657 * @param p_msg_count API standard: number of error messages
658 * @rep:paraminfo {@rep:required}
659 * @param p_msg_data API standard: error message
660 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
661 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
662 * @rep:paraminfo {@rep:required}
663 * @rep:scope public
664 * @rep:lifecycle active
665 * @rep:displayname Update Multiple Members-Sort
666 * @rep:compatibility S
667 */
668 PROCEDURE Sort_Resource_List_Members
669 ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
670 p_api_version_number IN NUMBER,
671 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
672 p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
673 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
674 p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
675 p_sort_by IN VARCHAR2,
676 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
677 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
678 p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
679 );
680
681 -- ----------------------------------------------------------
682 PROCEDURE Convert_List_Name_To_Id
683 (p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
684 p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
685 p_out_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
686 p_return_status OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
687
688 PROCEDURE Convert_Alias_To_Id
689 (
690 p_resource_list_id IN NUMBER,
691 p_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
692 p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
693 p_project_id IN NUMBER DEFAULT NULL,
694 p_out_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
695 p_return_status OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
696
697 FUNCTION is_planning_resource(p_resource_list_member_id IN NUMBER) RETURN VARCHAR2;
698 FUNCTION is_planning_resource_list(p_resource_list_id IN NUMBER) RETURN VARCHAR2;
699
700 END PA_RESOURCE_PUB ;