[Home] [Help]
PACKAGE: APPS.JTF_PERZ_LF_PVT
Source
1 PACKAGE JTF_PERZ_LF_PVT as
2 /* $Header: jtfzvlfs.pls 120.2 2005/11/02 22:31:47 skothe ship $ */
3 --
4 --
5 -- Start of Comments
6 --
7 -- NAME
8 -- JTF_PERZ_LF_PVT
9 --
10 -- PURPOSE
11 -- Private API for the look and feel objects.
12 --
13 -- NOTES
14 -- This is a pulicly accessible pacakge. It should be used by all
15 -- sources for creating, getting and updating look and feel objects
16 -- in the Personalization framework.
17 --
18 --
19 -- HISTORY
20 --
21 --
22 -- 06/15/99 SMATTEGU Created
23 -- 08/10/99 SMATTEGU Modified Personalize and Update APIs to remove
24 -- object_child_flag and include active_flag,
25 -- p_context_id, p_context as IN parameters
26 -- 08/11/99 SMATTEGU Modified Create API to remove
27 -- object_child_flag and include p_context_id,
28 -- p_context as IN parameters
29 -- 08/11/99 SMATTEGU Modified Get API to include p_context_id,
30 -- p_context as IN parameters
31 -- 08/18/99 SMATTEGU Added
32 -- create_lf_object_type()
33 -- get_lf_object_type()
34 -- 08/18/99 SMATTEGU Changed
35 -- update_lf_object() to reflect pub spec changes
36 -- personalize_lf_object() to reflect pub spec changes
37 -- create_lf_object()to reflect pub spec changes
38 -- get_le_object()to reflect pub spec changes
39 --
40 -- 08/31/99 SMATTEGU added
41 -- save_lf_object_type() method
42 --
43 --
44 -- 09/01/99 SMATTEGU, CCHANDRA Changed
45 -- 1. get_lf_object_type()
46 -- 2. save_lf_object()
47 -- (renamed personalize_lf_object to save_lf_object)
48 --
49 --
50 --
51 -- End of Comments
52 --
53 -- *****************************************************************************
54 -- Start of Comments
55 --
56 -- OBJ_TYPE_MAP_REC_TYPE
57 --
58 -- Parameters
59 --
60 -- TYPE_MAP_ID NUMBER
61 -- OBJECT_TYPE_ID NUMBER
62 -- ATTRIBUTE ID NUMBER
63 --
64 -- End of Comments
65
66 TYPE OBJ_TYPE_MAP_REC_TYPE IS RECORD
67 (
68 TYPE_MAP_ID NUMBER := FND_API.G_MISS_NUM,
69 OBJECT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
70 ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
71 );
72
73 -- Start of Comments
74 --
75 -- OBJ_TYPE_MAP_REC_TYPE Table: OBJ_TYPE_MAP_TBL_TYPE
76 --
77 TYPE OBJ_TYPE_MAP_TBL_TYPE IS TABLE OF OBJ_TYPE_MAP_REC_TYPE
78 INDEX BY BINARY_INTEGER;
79
80 -- G_MISS definition for table
81 G_MISS_OBJ_TYPE_MAP_TBL OBJ_TYPE_MAP_TBL_TYPE ;
82
83 --
84 -- *****************************************************************************
85 -- *****************************************************************************
86
87 -- Start of Comments
88 --
89 -- API name : Update_lf_object
90 -- Type : Public
91 -- Function : Update attribute-value pairs for a given LF object and profile
92 --
93 -- Paramaeters :
94 -- IN :
95 -- p_api_version_number IN NUMBER Required
96 -- p_init_msg_list IN VARCHAR2 Optional
97 -- Default = FND_API.G_FALSE
98 -- p_commit IN VARCHAR2
99 -- Default = FND_API.G_FALSE
100 --
101 -- p_profile_id IN NUMBER Optional
102 -- p_profile_name IN VARCHAR2 Optional
103 --
104 -- p_application_id IN NUMBER Required
105 -- p_parent_id IN NUMBER Required
106 -- p_object_id IN NUMBER Optional
107 -- p_object_name IN VARCHAR2 Optional
108 -- p_active_flag IN VARCHAR2 Optional
109
110 -- p_object_type_id IN NUMBER Optional
111 -- p_object_type IN VARCHAR2 Optional
112 -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
113 -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
114 --
115 -- OUT :
116 -- x_object_id OUT NUMBER
117 -- x_return_status OUT VARCHAR2(1)
118 -- x_msg_count OUT NUMBER
119 -- x_msg_data OUT VARCHAR2(2000)
120 --
121 --
122 --
123 -- Version : Current version 1.0
124 -- Initial version 1.0
125 --
126 -- Notes: Object id or name must be specified.
127 -- Profile id or name must be specified.
128 --
129 -- *****************************************************************************
130
131 PROCEDURE Update_lf_object
132 ( p_api_version_number IN NUMBER,
133 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134 p_commit IN VARCHAR2 := FND_API.G_FALSE,
135
136 p_profile_id IN NUMBER,
137 p_profile_name IN VARCHAR2 := NULL,
138
139 p_application_id IN NUMBER,
140 p_parent_id IN NUMBER := NULL,
141 p_object_Id IN NUMBER,
142 p_object_name IN VARCHAR2 := NULL,
143 p_active_flag IN VARCHAR2,
144
145 p_object_type_id IN NUMBER,
146 p_object_type IN VARCHAR2 := NULL,
147
148 p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
149 := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
150
151 x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
152 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
153 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
154 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 );
156
157 -- *****************************************************************************
158 -- *****************************************************************************
159 -- Start of Comments
160 --
161 -- API name : save_lf_object
162 -- Type : Public
163 -- Function : Create and update if exists, attribute value pairs for
164 -- a given object and profile in an application_id domain.
165 --
166 -- Paramaeters :
167 -- IN :
168 -- p_api_version_number IN NUMBER Required
169 -- p_init_msg_list IN VARCHAR2 Optional
170 -- Default = FND_API.G_FALSE
171 -- p_application_id IN NUMBER Required
172 -- p_profile_id IN NUMBER Required
173 -- p_profile_name IN VARCHAR2 Optional
174 -- p_profile_type IN VARCHAR2,
175 -- p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE Optional
176 -- p_parent_id IN NUMBER Required
177 -- p_object_id IN NUMBER Optional
178 -- p_object_name IN VARCHAR2 Required
179 -- p_object_description IN VARCHAR2 Optional
180 -- p_object_type_id IN NUMBER Optional
181 -- p_object_type IN VARCHAR2 Required
182 -- p_active_flag IN VARCHAR2 Optional
183 -- Default = NO
184 -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
185 -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL Optional
186 -- p_commit IN VARCHAR2 Optional
187 --
188 -- OUT :
189 -- x_object_id OUT NUMBER
190 -- x_return_status OUT VARCHAR2(1)
191 -- x_msg_count OUT NUMBER
192 -- x_msg_data OUT VARCHAR2(2000)
193 --
194 --
195 -- Version : Current version 1.0
196 -- Initial version 1.0
197 --
198 -- Notes:
199 --
200 -- *****************************************************************************
201
202 PROCEDURE save_lf_object
203 ( p_api_version_number IN NUMBER,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205 p_commit IN VARCHAR2 := FND_API.G_FALSE,
206
207 p_profile_id IN NUMBER,
208 p_profile_name IN VARCHAR2,
209 p_profile_type IN VARCHAR2,
210 p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
211 := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
212
213 p_application_id IN NUMBER,
214 p_parent_id IN NUMBER,
215 p_object_type_id IN NUMBER,
216 p_object_type IN VARCHAR2,
217
218 p_object_id IN NUMBER,
219 p_object_name IN VARCHAR2,
220 p_object_description IN VARCHAR2,
221
222 p_active_flag IN VARCHAR2,
223 p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
224 := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
225
226 x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
227 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
228 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
229 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
230 );
231
232 -- *****************************************************************************
233 -- *****************************************************************************
234
235 -- Start of Comments
236 --
237 -- API name : Create_lf_object
238 -- Type : Public
239 -- Function : Create attribute value pairs for a given object and profile
240 --
241 -- Paramaeters :
242 -- IN :
243 -- p_api_version_number IN NUMBER Required
244 -- p_init_msg_list IN VARCHAR2 Optional
245 -- Default = FND_API.G_FALSE
246 -- p_commit IN VARCHAR2 Optional
247
248 -- p_profile_id IN NUMBER Optional
249 -- p_profile_name IN VARCHAR2 Required
250
251 -- p_application_id IN NUMBER Required
252 -- p_parent_id IN NUMBER Optional
253 -- p_object_id IN NUMBER Optional
254 -- p_object_name IN VARCHAR2 Required
255
256 -- p_object_type_id IN NUMBER Optional
257 -- p_object_type IN VARCHAR2 Optional
258
259 -- p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
260 -- := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL
261
262 -- OUT :
263 -- x_object_id OUT NUMBER
264 -- x_return_status OUT VARCHAR2(1)
265 -- x_msg_count OUT NUMBER
266 -- x_msg_data OUT VARCHAR2(2000)
267 --
268 --
269 -- Version : Current version 1.0
270 -- Initial version 1.0
271 --
272 -- Notes: Personalization Framework API to create the Object attrib-
273 -- Value pair with their corresponding profile.
274 --
275 --
276 -- *****************************************************************************
277
278 PROCEDURE Create_lf_object
279 ( p_api_version_number IN NUMBER,
280 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281 p_commit IN VARCHAR2 := FND_API.G_FALSE,
282
283 p_profile_id IN NUMBER,
284 p_profile_name IN VARCHAR2,
285
286 p_application_id IN NUMBER,
287 p_parent_id IN NUMBER,
288 p_object_id IN NUMBER,
289 p_object_name IN VARCHAR2,
290
291 p_object_type_id IN NUMBER,
292 p_object_type IN VARCHAR2,
293
294 p_attrib_value_tbl IN JTF_PERZ_LF_PUB.ATTRIB_VALUE_TBL_TYPE
295 := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_VALUE_TBL,
296
297 x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
298 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
299 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
300 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
301 );
302
303
304 -- *****************************************************************************
305 -- *****************************************************************************
306
307 -- Start of Comments
308 --
309 -- API name : Get_lf_object
310 -- Type : Public
311 -- Function : Get attribute value pairs for a given LF object and profile
312 --
313 -- Paramaeters :
314 -- IN :
315 -- p_api_version_number IN NUMBER Required
316 -- p_init_msg_list IN VARCHAR2 Optional
317 -- Default = FND_API.G_FALSE
318 -- p_profile_id IN NUMBER Optional
319 -- p_profile_name IN VARCHAR2 Optional
320 -- p_parent_id IN NUMBER Optional
321 -- p_object_id IN NUMBER Optional
322 -- p_object_name IN VARCHAR2 Optional
323 -- p_obj_active_flag IN VARCHAR2 Optional
324 -- p_get_children_flag IN VARCHAR2 Optional
325 --
326 -- OUT :
327 -- x_object_id OUT NUMBER Optional
328 -- x_Object_Tbl OUT JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,
329 -- x_return_status OUT VARCHAR2(1)
330 -- x_msg_count OUT NUMBER
331 -- x_msg_data OUT VARCHAR2(2000)
332 --
333 --
334 --
335 -- Version : Current version 1.0
336 -- Initial version 1.0
337 --
338 -- Notes:
339 --
340 -- *****************************************************************************
341
342 PROCEDURE Get_lf_object
343 ( p_api_version_number IN NUMBER,
344 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345
346 p_application_id IN NUMBER,
347 p_priority IN NUMBER,
348 p_profile_id IN NUMBER,
349 p_profile_name IN VARCHAR2,
350 P_Object_Id IN NUMBER,
351 p_Object_Name IN VARCHAR,
352 p_obj_active_flag IN VARCHAR2,
353 p_get_children_flag IN VARCHAR2,
354 x_Object_Tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.LF_OBJECT_OUT_TBL_TYPE,
355 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
356 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
357 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
358 );
359
360 -- *****************************************************************************
361 -- *****************************************************************************
362
363 -- Start of Comments
364 --
365 -- API name : Get_lf_object_type
366 -- Type : Public
367 -- Function : Get attribute pairs for a given LF object_type
368 --
369 -- Paramaeters :
370 -- IN :
371 -- p_api_version_number IN NUMBER Required
372 -- p_init_msg_list IN VARCHAR2 Optional
373 -- Default = FND_API.G_FALSE
374 --
375 -- p_object_type IN VARCHAR2 Optional
376 -- p_object_type_desc IN VARCHAR2 Optional
377 -- p_object_type_id IN NUMBER Optional
378 --
379
380 -- OUT :
381 -- x_object_type_id OUT NUMBER
382 -- x_object_type_desc OUT VARCHAR,
383 -- x_attrib_rec_tbl OUT JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
384 -- x_return_status OUT VARCHAR2(1)
385 -- x_msg_count OUT NUMBER
386 -- x_msg_data OUT VARCHAR2(2000)
387 --
388 --
389 --
390 -- Version : Current version 1.0
391 -- Initial version 1.0
392 --
393 -- Notes:
394 --
395 -- *****************************************************************************
396
397 PROCEDURE Get_lf_object_type
398 ( p_api_version_number IN NUMBER,
399 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400
401 p_Object_type IN VARCHAR,
402 p_Object_type_Id IN NUMBER,
403
404 x_Object_type_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
405 x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
406
407 x_attrib_rec_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE,
408 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
409 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
410 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
411 );
412
413 -- *****************************************************************************
414 -- *****************************************************************************
415
416 -- Start of Comments
417 --
418 -- API name : save_lf_object_type
419 -- Type : Public
420 -- Function : This procedure will create or update the given lf
421 -- object type.
422 --
423 -- Paramaeters :
424 -- IN :
425 -- p_api_version_number IN NUMBER Required
426 -- p_init_msg_list IN VARCHAR2 Optional
427 -- Default = FND_API.G_FALSE
428 -- p_commit IN VARCHAR2 Optional
429
430 -- p_object_type_id IN NUMBER Optional
431 -- p_object_type IN VARCHAR2 Optional
432 -- p_object_type_desc IN VARCHAR2 Optional
433
434 -- p_attribute_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE Required
435 --
436 -- OUT :
437 -- x_object_type_id OUT NUMBER
438 -- x_obj_type_map_tbl OUT JTF_PERZ_LF_PUB.OBJ_TYPE_MAP_TBL_TYPE
439 -- x_return_status OUT VARCHAR2
440 -- x_msg_count OUT NUMBER
441 -- x_msg_data OUT VARCHAR2(2000)
442 --
443 --
444 -- Version : Current version 1.0
445 -- Initial version 1.0
446 --
447 -- Notes:
448 --
449 -- *****************************************************************************
450
451 PROCEDURE save_lf_object_type
452 ( p_api_version_number IN NUMBER,
453 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
454 p_commit IN VARCHAR2 := FND_API.G_FALSE,
455
456 p_object_type_id IN NUMBER,
457 p_object_type IN VARCHAR2,
458 p_object_type_desc IN VARCHAR2,
459
460 p_attrib_rec_tbl IN JTF_PERZ_LF_PUB.ATTRIB_REC_TBL_TYPE
461 := JTF_PERZ_LF_PUB.G_MISS_ATTRIB_REC_TBL,
462
463 x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
464 x_obj_type_map_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_LF_PVT.OBJ_TYPE_MAP_TBL_TYPE,
465 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
466 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
467 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
468 );
469 -- *****************************************************************************
470 END JTF_PERZ_LF_PVT ;