[Home] [Help]
PACKAGE: APPS.JTF_RS_RESOURCE_SKILLS_PUB
Source
1 PACKAGE JTF_RS_RESOURCE_SKILLS_PUB AS
2 /* $Header: jtfrsuks.pls 120.0 2005/05/11 08:22:47 appldev ship $ */
3 /*#
4 * Package containing procedures to maintain resource skills
5 * @rep:scope internal
6 * @rep:product JTF
7 * @rep:displayname Resource Skills Package
8 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE_SKILL
9 */
10
11 /*****************************************************************************************
12 This is a public API that will invoke private api.
13 It provides procedures for managing data of JTF_RS_RESOURCE_SKILLS table
14 create, update and delete rows
15 Its main procedures are as following:
16 Create resource skills
17 Update resource skills
18 Delete resource skills
19 Calls to these procedures will invoke procedures of JTF_RS_RESOURCE_SKILLS_PVT
20 to do business validations and to do actual inserts, updates and deletes into tables.
21
22 Modification history
23
24 Date Name Description
25 02-DEC-02 asachan Added two overloaded procedures create_resource_skills and
26 update_resource_skills for providing product skill
27 cascading capability.(bug#2002193)
28 ******************************************************************************************/
29
30
31 /* Procedure to create the resource skill
32 based on input values passed by calling routines. */
33
34 /*#
35 * Procedure to create a resource skill
36 * @param P_API_VERSION API version number
37 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
38 * @param P_COMMIT Flag to commit at the end of the procedure
39 * @param P_RESOURCE_ID internal unique id for the resource
40 * @param P_SKILL_LEVEL_ID internal unique id for the skill level
41 * @param P_CATEGORY_ID internal unique id for item(product) category
42 * @param P_SUBCATEGORY subcategory for the product category
43 * @param P_PRODUCT_ID internal unique id for product
44 * @param P_PRODUCT_ORG_ID Organization id for the product
45 * @param P_PLATFORM_ID internal unique id for platform
46 * @param P_PLATFORM_ORG_ID Organization id for the platform
47 * @param P_PROBLEM_CODE Problem code
48 * @param P_COMPONENT_ID Internal unique id for product component
49 * @param P_SUBCOMPONENT_ID Internal unique id for product sub-component
50 * @param P_ATTRIBUTE1 Descriptive flexfield Attribute 1
51 * @param P_ATTRIBUTE2 Descriptive flexfield Attribute 2
52 * @param P_ATTRIBUTE3 Descriptive flexfield Attribute 3
53 * @param P_ATTRIBUTE4 Descriptive flexfield Attribute 4
54 * @param P_ATTRIBUTE5 Descriptive flexfield Attribute 5
55 * @param P_ATTRIBUTE6 Descriptive flexfield Attribute 6
56 * @param P_ATTRIBUTE7 Descriptive flexfield Attribute 7
57 * @param P_ATTRIBUTE8 Descriptive flexfield Attribute 8
58 * @param P_ATTRIBUTE9 Descriptive flexfield Attribute 9
59 * @param P_ATTRIBUTE10 Descriptive flexfield Attribute 10
60 * @param P_ATTRIBUTE11 Descriptive flexfield Attribute 11
61 * @param P_ATTRIBUTE12 Descriptive flexfield Attribute 12
62 * @param P_ATTRIBUTE13 Descriptive flexfield Attribute 13
63 * @param P_ATTRIBUTE14 Descriptive flexfield Attribute 14
64 * @param P_ATTRIBUTE15 Descriptive flexfield Attribute 15
65 * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield attribute category
66 * @param X_RETURN_STATUS Output parameter for return status
67 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
68 * @param X_MSG_DATA Output parameter containing last user message from this procedure
69 * @param X_RESOURCE_SKILL_ID Output parameter containing internal unique id of the created resoure skill
70 * @rep:scope internal
71 * @rep:displayname Create Resource Skill
72 */
73 PROCEDURE create_resource_skills
74 (P_API_VERSION IN NUMBER,
75 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77 P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
78 P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
79 P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT NULL,
80 P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
81 P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT NULL,
82 P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT NULL,
83 P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT NULL,
84 P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT NULL,
85 P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT NULL,
86 P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT NULL,
87 P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT NULL,
88 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT NULL,
89 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT NULL,
90 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT NULL,
91 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT NULL,
92 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT NULL,
93 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT NULL,
94 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT NULL,
95 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT NULL,
96 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT NULL,
97 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT NULL,
98 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT NULL,
99 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT NULL,
100 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT NULL,
101 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT NULL,
102 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT NULL,
103 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
104 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105 X_MSG_COUNT OUT NOCOPY NUMBER,
106 X_MSG_DATA OUT NOCOPY VARCHAR2,
107 X_RESOURCE_SKILL_ID OUT NOCOPY JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE
108 );
109
110
111 /* Procedure to update resource skill
112 based on input values passed by calling routines. */
113 /*#
114 * Procedure to update a resource skill
115 * @param P_API_VERSION API version number
116 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
117 * @param P_COMMIT Flag to commit at the end of the procedure
118 * @param P_RESOURCE_SKILL_ID internal unique id for resource skill to update
119 * @param P_RESOURCE_ID internal unique id for the resource
120 * @param P_SKILL_LEVEL_ID internal unique id for the skill level
121 * @param P_CATEGORY_ID internal unique id for item(product) category
122 * @param P_SUBCATEGORY subcategory for the product category
123 * @param P_PRODUCT_ID internal unique id for product
124 * @param P_PRODUCT_ORG_ID Organization id for the product
125 * @param P_PLATFORM_ID internal unique id for platform
126 * @param P_PLATFORM_ORG_ID Organization id for the platform
127 * @param P_PROBLEM_CODE Problem code
128 * @param P_COMPONENT_ID Internal unique id for product component
129 * @param P_SUBCOMPONENT_ID Internal unique id for product sub-component
130 * @param P_OBJECT_VERSION_NUM Object version number for this resource skill record
131 * @param P_ATTRIBUTE1 Descriptive flexfield Attribute 1
132 * @param P_ATTRIBUTE2 Descriptive flexfield Attribute 2
133 * @param P_ATTRIBUTE3 Descriptive flexfield Attribute 3
134 * @param P_ATTRIBUTE4 Descriptive flexfield Attribute 4
135 * @param P_ATTRIBUTE5 Descriptive flexfield Attribute 5
136 * @param P_ATTRIBUTE6 Descriptive flexfield Attribute 6
137 * @param P_ATTRIBUTE7 Descriptive flexfield Attribute 7
138 * @param P_ATTRIBUTE8 Descriptive flexfield Attribute 8
139 * @param P_ATTRIBUTE9 Descriptive flexfield Attribute 9
140 * @param P_ATTRIBUTE10 Descriptive flexfield Attribute 10
141 * @param P_ATTRIBUTE11 Descriptive flexfield Attribute 11
142 * @param P_ATTRIBUTE12 Descriptive flexfield Attribute 12
143 * @param P_ATTRIBUTE13 Descriptive flexfield Attribute 13
144 * @param P_ATTRIBUTE14 Descriptive flexfield Attribute 14
145 * @param P_ATTRIBUTE15 Descriptive flexfield Attribute 15
146 * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield attribute category
147 * @param X_RETURN_STATUS Output parameter for return status
148 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
149 * @param X_MSG_DATA Output parameter containing last user message from this procedure
150 * @rep:scope internal
151 * @rep:displayname Update Resource Skill
152 */
153 PROCEDURE update_resource_skills
154 (P_API_VERSION IN NUMBER,
155 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157 P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
158 P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
159 P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
160 P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
161 P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
162 P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
163 P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
164 P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
165 P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
166 P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
167 P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
168 P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
169 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
170 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
171 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
172 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
173 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
174 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
175 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
176 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
177 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
178 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
179 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
180 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
181 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
182 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
183 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
184 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
185 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
186 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
187 X_MSG_COUNT OUT NOCOPY NUMBER,
188 X_MSG_DATA OUT NOCOPY VARCHAR2
189 );
190
191
192 /* Procedure to delete the resource skill */
193
194 /*#
195 * Procedure to delete a resource skill
196 * @param P_API_VERSION API version number
197 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
198 * @param P_COMMIT Flag to commit at the end of the procedure
199 * @param P_RESOURCE_SKILL_ID internal unique id for resource skill to update
200 * @param P_OBJECT_VERSION_NUM Object version number for this resource skill record
201 * @param X_RETURN_STATUS Output parameter for return status
202 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
203 * @param X_MSG_DATA Output parameter containing last user message from this procedure
204 * @rep:scope internal
205 * @rep:displayname Update Resource Skill With Cascade
206 */
207 PROCEDURE delete_resource_skills
208 (P_API_VERSION IN NUMBER,
209 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211 P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
212 P_OBJECT_VERSION_NUM IN JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
213 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
214 X_MSG_COUNT OUT NOCOPY NUMBER,
215 X_MSG_DATA OUT NOCOPY VARCHAR2
216 );
217
218
219 /* Procedure to create skill rating with cascading.
220 introduced as part of bug#2002193 */
221 /*#
222 * Procedure to create a resource skill and cascade it into products or
223 * components as per the P_CASCADE_OPTION parameter
224 * @param P_API_VERSION API version number
225 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
226 * @param P_COMMIT Flag to commit at the end of the procedure
227 * @param P_RESOURCE_ID internal unique id for the resource
228 * @param P_SKILL_LEVEL_ID internal unique id for the skill level
229 * @param P_CATEGORY_ID internal unique id for item(product) category
230 * @param P_SUBCATEGORY subcategory for the product category
231 * @param P_PRODUCT_ID internal unique id for product
232 * @param P_PRODUCT_ORG_ID Organization id for the product
233 * @param P_PLATFORM_ID internal unique id for platform
234 * @param P_PLATFORM_ORG_ID Organization id for the platform
235 * @param P_PROBLEM_CODE Problem code
236 * @param P_COMPONENT_ID Internal unique id for product component
237 * @param P_SUBCOMPONENT_ID Internal unique id for product sub-component
238 * @param P_ATTRIBUTE1 Descriptive flexfield Attribute 1
239 * @param P_ATTRIBUTE2 Descriptive flexfield Attribute 2
240 * @param P_ATTRIBUTE3 Descriptive flexfield Attribute 3
241 * @param P_ATTRIBUTE4 Descriptive flexfield Attribute 4
242 * @param P_ATTRIBUTE5 Descriptive flexfield Attribute 5
243 * @param P_ATTRIBUTE6 Descriptive flexfield Attribute 6
244 * @param P_ATTRIBUTE7 Descriptive flexfield Attribute 7
245 * @param P_ATTRIBUTE8 Descriptive flexfield Attribute 8
249 * @param P_ATTRIBUTE12 Descriptive flexfield Attribute 12
246 * @param P_ATTRIBUTE9 Descriptive flexfield Attribute 9
247 * @param P_ATTRIBUTE10 Descriptive flexfield Attribute 10
248 * @param P_ATTRIBUTE11 Descriptive flexfield Attribute 11
250 * @param P_ATTRIBUTE13 Descriptive flexfield Attribute 13
251 * @param P_ATTRIBUTE14 Descriptive flexfield Attribute 14
252 * @param P_ATTRIBUTE15 Descriptive flexfield Attribute 15
253 * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield attribute category
254 * @param X_RETURN_STATUS Output parameter for return status
255 * @param P_CASCADE_OPTION Option to indicate if cascade ? if yes, then into products or components
256 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
257 * @param X_MSG_DATA Output parameter containing last user message from this procedure
258 * @param X_RESOURCE_SKILL_ID Output parameter containing internal unique id of the created resoure skill
259 * @rep:scope internal
260 * @rep:displayname Create Resource Skill With Cascade
261 */
262 PROCEDURE create_resource_skills
263 (P_API_VERSION IN NUMBER,
264 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266 P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
267 P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
268 P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT NULL,
269 P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT NULL,
270 P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT NULL,
271 P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT NULL,
272 P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT NULL,
273 P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT NULL,
274 P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT NULL,
275 P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT NULL,
276 P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT NULL,
277 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT NULL,
278 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT NULL,
279 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT NULL,
280 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT NULL,
281 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT NULL,
282 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT NULL,
283 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT NULL,
284 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT NULL,
285 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT NULL,
286 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT NULL,
287 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT NULL,
288 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT NULL,
289 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT NULL,
290 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT NULL,
291 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT NULL,
292 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
293 P_CASCADE_OPTION IN NUMBER,
294 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
295 X_MSG_COUNT OUT NOCOPY NUMBER,
296 X_MSG_DATA OUT NOCOPY VARCHAR2,
297 X_RESOURCE_SKILL_ID OUT NOCOPY JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE
298 );
299
300
301 /* Procedure to update skill rating with cascading.
302 introduced as part of bug#2002193 */
303 /*#
304 * Procedure to update a resource skill and cascade it into products or
305 * components as per the P_CASCADE_OPTION parameter
306 * @param P_API_VERSION API version number
307 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
308 * @param P_COMMIT Flag to commit at the end of the procedure
309 * @param P_RESOURCE_SKILL_ID internal unique id for resource skill to update
310 * @param P_RESOURCE_ID internal unique id for the resource
311 * @param P_SKILL_LEVEL_ID internal unique id for the skill level
312 * @param P_CATEGORY_ID internal unique id for item(product) category
313 * @param P_SUBCATEGORY subcategory for the product category
314 * @param P_PRODUCT_ID internal unique id for product
315 * @param P_PRODUCT_ORG_ID Organization id for the product
316 * @param P_PLATFORM_ID internal unique id for platform
317 * @param P_PLATFORM_ORG_ID Organization id for the platform
318 * @param P_PROBLEM_CODE Problem code
319 * @param P_COMPONENT_ID Internal unique id for product component
320 * @param P_SUBCOMPONENT_ID Internal unique id for product sub-component
321 * @param P_OBJECT_VERSION_NUM Object version number for this resource skill record
322 * @param P_ATTRIBUTE1 Descriptive flexfield Attribute 1
323 * @param P_ATTRIBUTE2 Descriptive flexfield Attribute 2
324 * @param P_ATTRIBUTE3 Descriptive flexfield Attribute 3
325 * @param P_ATTRIBUTE4 Descriptive flexfield Attribute 4
326 * @param P_ATTRIBUTE5 Descriptive flexfield Attribute 5
327 * @param P_ATTRIBUTE6 Descriptive flexfield Attribute 6
328 * @param P_ATTRIBUTE7 Descriptive flexfield Attribute 7
329 * @param P_ATTRIBUTE8 Descriptive flexfield Attribute 8
330 * @param P_ATTRIBUTE9 Descriptive flexfield Attribute 9
331 * @param P_ATTRIBUTE10 Descriptive flexfield Attribute 10
332 * @param P_ATTRIBUTE11 Descriptive flexfield Attribute 11
333 * @param P_ATTRIBUTE12 Descriptive flexfield Attribute 12
334 * @param P_ATTRIBUTE13 Descriptive flexfield Attribute 13
335 * @param P_ATTRIBUTE14 Descriptive flexfield Attribute 14
336 * @param P_ATTRIBUTE15 Descriptive flexfield Attribute 15
337 * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield attribute category
338 * @param P_CASCADE_OPTION Option to indicate if cascade ? if yes, then into products or components
339 * @param X_RETURN_STATUS Output parameter for return status
340 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
341 * @param X_MSG_DATA Output parameter containing last user message from this procedure
342 * @rep:scope internal
343 * @rep:displayname Update Resource Skill With Cascade
344 */
345 PROCEDURE update_resource_skills
346 (P_API_VERSION IN NUMBER,
347 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
348 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
349 P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
350 P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
351 P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
352 P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
353 P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
354 P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
355 P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
356 P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
357 P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
358 P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
359 P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
360 P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
361 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
362 P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
363 P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
364 P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
365 P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
366 P_ATTRIBUTE5 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
367 P_ATTRIBUTE6 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
368 P_ATTRIBUTE7 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
369 P_ATTRIBUTE8 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
370 P_ATTRIBUTE9 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
371 P_ATTRIBUTE10 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
372 P_ATTRIBUTE11 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
373 P_ATTRIBUTE12 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
374 P_ATTRIBUTE13 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
375 P_ATTRIBUTE14 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
376 P_ATTRIBUTE15 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
377 P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
378 P_CASCADE_OPTION IN NUMBER,
379 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
380 X_MSG_COUNT OUT NOCOPY NUMBER,
381 X_MSG_DATA OUT NOCOPY VARCHAR2
382 );
383
384 END JTF_RS_RESOURCE_SKILLS_PUB;