1 PACKAGE PO_UDA_TEMPLATES_UTIL AUTHID CURRENT_USER AS
2 /* $Header: PO_UDA_TEMPLATES_UTIL.pls 120.10 2011/05/04 10:10:00 swvyamas ship $ */
3
4 --Global Variables used for saving the template_id used for
5 --view page and update/create revision page
6 TYPE action_template_id_tbl IS TABLE OF NUMBER INDEX BY VARCHAR2(200);
7 g_action_template_id action_template_id_tbl;
8
9 g_delimiter VARCHAR2(2) := '_';
10
11 PROCEDURE SYNC_PAGE_ENTRIES
12 (
13 p_template_id IN NUMBER
14 ,x_return_status OUT NOCOPY VARCHAR2
15 ,x_errorcode OUT NOCOPY NUMBER
16 ,x_msg_count OUT NOCOPY NUMBER
17 ,x_msg_data OUT NOCOPY VARCHAR2
18 );
19
20
21 PROCEDURE COMPILE_TEMPLATES
22 (
23 errbuf out NOCOPY varchar2
24 ,retcode out NOCOPY number
25 ,p_functional_area_code in varchar2
26 ,p_uda_dummy1 in varchar2
27 ,p_document_type_code in varchar2
28 ,p_uda_dummy2 in varchar2
29 ,p_document_style_id in number
30 ,p_level_code in varchar2
31 ,p_revision in number
32 ,p_template_id in number
33 );
34
35 PROCEDURE COMPILE_TEMPLATE
36 (
37 p_template_id in number
38 ,errbuf out NOCOPY varchar2
39 ,retcode out NOCOPY number
40 ,x_return_status out NOCOPY varchar2
41 );
42
43 FUNCTION can_update_delete(p_template_id NUMBER) RETURN VARCHAR2;
44
45 PROCEDURE sync_attribute_group
46 (
47 p_glb_api_version IN NUMBER
48 ,p_glb_application_id IN NUMBER
49 ,p_attribute_group_type IN VARCHAR2
50 ,p_attribute_group_name IN VARCHAR2
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_errorcode OUT NOCOPY NUMBER
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE is_read_only_dummy_attr_group
58 (
59 p_attribute_group_type IN VARCHAR2
60 ,p_attribute_group_name IN VARCHAR2
61 ,p_source IN VARCHAR2 DEFAULT 'UI'
62 ,x_return_status OUT NOCOPY VARCHAR2
63 );
64
65 PROCEDURE is_read_only_attribute_group
66 (
67 p_attribute_group_type IN VARCHAR2
68 ,p_attribute_group_id IN NUMBER
69 ,p_source IN VARCHAR2 DEFAULT 'UI'
70 ,x_return_status OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE sync_attribute_group
74 (
75 p_glb_api_version IN NUMBER
76 ,p_glb_application_id IN NUMBER
77 ,p_attribute_group_id IN NUMBER
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_errorcode OUT NOCOPY NUMBER
80 ,x_msg_count OUT NOCOPY NUMBER
81 ,x_msg_data OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE sync_real_data_levels
85 (
86 p_glb_api_version IN NUMBER
87 ,p_glb_application_id IN NUMBER
88 ,p_dummy_attr_group_id IN NUMBER
89 ,p_real_attr_group_id IN NUMBER
90 ,p_attr_group_type IN VARCHAR2
91 ,p_data_level_name IN VARCHAR2
92 ,p_user_data_level_name IN VARCHAR2
93 ,x_data_level_id OUT NOCOPY NUMBER
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE sync_data_level_attr_group
100 (
101 p_attr_group_id IN NUMBER
102 ,p_data_level_id IN NUMBER
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_errorcode OUT NOCOPY NUMBER
105 ,x_msg_count OUT NOCOPY NUMBER
106 ,x_msg_data OUT NOCOPY VARCHAR2
107 );
108
109 PROCEDURE update_real_meta_attr_group
110 (
111 p_glb_api_version IN NUMBER
112 ,p_glb_application_id IN NUMBER
113 ,p_dummy_attribute_group_id IN NUMBER
114 ,p_real_attribute_group_id IN NUMBER
115 ,p_real_attribute_group_type IN VARCHAR2
116 );
117
118 PROCEDURE delete_real_attr_group
119 (
120 p_glb_api_version IN NUMBER
121 ,p_real_attribute_group_id IN NUMBER
122 );
123
124 FUNCTION sync_real_attribute_groups
125 (
126 p_glb_api_version IN NUMBER
127 ,p_glb_application_id IN NUMBER,
128 p_attribute_group_id IN NUMBER,
129 p_attribute_group_type IN VARCHAR2
130 ) RETURN VARCHAR2;
131
132 FUNCTION update_map_table
133 (
134 p_attribute_group_id IN NUMBER,
135 p_data_level_type IN VARCHAR2
136 ) RETURN VARCHAR2;
137
138 FUNCTION get_map_table_details
139 (
140 p_attribute_group_id IN NUMBER,
141 p_data_level_type IN VARCHAR2
142 ) RETURN NUMBER;
143
144 FUNCTION is_data_level_present
145 (
146 p_attribute_group_id IN NUMBER
147 ,p_data_level IN VARCHAR2
148 ,x_internal_name OUT NOCOPY VARCHAR2
149 ) RETURN VARCHAR2;
150
151 FUNCTION is_attribute_present
152 (
153 p_real_attr_grp_type IN VARCHAR2,
154 p_real_internal_name IN VARCHAR2,
155 p_attribute_name IN VARCHAR2
156 ) RETURN VARCHAR2;
157
158 PROCEDURE DELETE_TEMP_USAGES
159 ( p_api_version IN NUMBER,
160 p_template_id IN NUMBER,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166 PROCEDURE DELETE_TEMP_SINGLE_USAGE
167 ( p_api_version IN NUMBER,
168 p_template_id IN NUMBER,
169 p_usage_name IN VARCHAR2,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 PROCEDURE generate_template_view
176 (
177 p_api_version IN NUMBER,
178 p_template_id IN NUMBER,
179 x_template_view_name OUT NOCOPY VARCHAR2,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2
183 );
184
185 PROCEDURE generate_entity_view
186 (
187 p_api_version IN NUMBER,
188 p_entity_code IN VARCHAR2,
189 x_template_view_name OUT NOCOPY VARCHAR2,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2
193 );
194
195 PROCEDURE get_template_view_name
196 (
197 p_api_version IN NUMBER,
198 p_template_id IN NUMBER,
199 x_template_view_name OUT NOCOPY VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2
203 );
204
205 PROCEDURE get_template_view_name
206 (
207 p_api_version IN NUMBER,
208 p_template_code IN VARCHAR2 ,
209 p_entity_code IN VARCHAR2,
210 x_template_view_name OUT NOCOPY VARCHAR2,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2
214 );
215
216 PROCEDURE get_query_for_temp_view
217 ( p_api_version IN NUMBER,
218 p_template_id IN NUMBER,
219 p_hist_view IN VARCHAR2,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 x_select_query OUT NOCOPY VARCHAR2,
224 x_user_col_name OUT NOCOPY VARCHAR2
225 );
226
227 PROCEDURE get_query_for_entity_view(p_api_version IN NUMBER,
228 p_entity_code IN VARCHAR2,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 x_select_query OUT NOCOPY VARCHAR2,
233 x_user_col_name OUT NOCOPY VARCHAR2);
234
235 FUNCTION ATTR_DISP_COL_NAME
236 ( P_ATTR_GRP_ID in NUMBER,
237 P_APP_COL_NAME IN VARCHAR2
238 ) RETURN VARCHAR2 ;
239
240 PROCEDURE copy_uda_actions(p_api_version IN NUMBER,
241 p_attr_group_id IN VARCHAR2,
242 p_new_template_code IN VARCHAR2,
243 p_src_template_id IN NUMBER,
244 p_object_id IN NUMBER,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2);
248
249 PROCEDURE get_template_hist_view_name
250 (
251 p_api_version IN NUMBER,
252 p_template_id IN NUMBER,
253 x_template_view_name OUT NOCOPY VARCHAR2,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2
257 );
258
259 PROCEDURE decode_value_set_meaning
260 (
261 p_api_version IN NUMBER,
262 p_usage_id IN NUMBER,
263 p_attr_col IN VARCHAR2,
264 p_attr_value IN VARCHAR2,
265 x_attr_meaning OUT NOCOPY VARCHAR2,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2
269 );
270
271 FUNCTION get_flex_segment_meaning(
272 p_api_version IN NUMBER,
273 p_usage_id IN NUMBER,
274 p_attr_col IN VARCHAR2,
275 p_attr_value IN VARCHAR2
276 ) RETURN VARCHAR2 ;
277
278 FUNCTION get_action_type(p_functional_area VARCHAR2,
279 p_document_type VARCHAR2,
280 p_document_style_id NUMBER,
281 p_document_level VARCHAR2,
282 p_template_id NUMBER DEFAULT NULL)
283 RETURN VARCHAR2;
284
285 FUNCTION get_view_template_id(p_functional_area VARCHAR2,
286 p_document_type VARCHAR2,
287 p_document_style_id NUMBER,
288 p_document_level VARCHAR2)
289 RETURN NUMBER;
290
291 FUNCTION get_action_template_id(p_functional_area VARCHAR2,
292 p_document_type VARCHAR2,
293 p_document_style_id NUMBER,
294 p_document_level VARCHAR2)
295 RETURN NUMBER;
296
297 PROCEDURE DELETE_USAGE
298 ( p_api_version IN NUMBER,
299 p_usage_id IN NUMBER,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2
303 );
304
305 PROCEDURE copy_uda_temp_usages(p_api_version IN NUMBER,
306 p_new_template_id IN NUMBER,
307 p_src_template_id IN NUMBER,
311
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2);
312 PROCEDURE copy_uda_temp_single_usage(p_api_version IN NUMBER,
313 p_dest_template_id IN NUMBER,
314 p_src_template_id IN NUMBER,
315 p_usage_name IN VARCHAR2 ,
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2);
319
320 PROCEDURE copy_uda_temp_header(p_api_version IN NUMBER,
321 p_src_template_id IN NUMBER,
322 x_new_template_id OUT NOCOPY NUMBER,
323 x_return_status OUT NOCOPY VARCHAR2,
324 x_msg_count OUT NOCOPY NUMBER,
325 x_msg_data OUT NOCOPY VARCHAR2);
326
327 PROCEDURE validate_usages(p_api_version IN NUMBER,
328 p_template_id IN NUMBER,
329 p_attribute_category IN VARCHAR2,
330 p_attribute_group_id IN NUMBER,
331 p_sequence IN NUMBER,
332 p_concatenated_segments IN VARCHAR2,
333 x_uctxag_yn OUT NOCOPY VARCHAR2,
334 x_uctxseq_yn OUT NOCOPY VARCHAR2,
335 x_return_status OUT NOCOPY VARCHAR2,
336 x_msg_count OUT NOCOPY NUMBER,
337 x_msg_data OUT NOCOPY VARCHAR2);
338
339 PROCEDURE validate_template( p_api_version IN NUMBER,
340 p_template_id IN NUMBER,
341 x_return_status OUT NOCOPY VARCHAR2,
345
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2
344 ) ;
346 PROCEDURE is_function_seeded
347 (
348 p_glb_api_version IN NUMBER
349 ,p_glb_application_id IN NUMBER
350 ,p_function_id IN VARCHAR2
351 ,x_is_seeded OUT NOCOPY VARCHAR2
352 ,x_return_status OUT NOCOPY VARCHAR2
353 ,x_errorcode OUT NOCOPY NUMBER
354 ,x_msg_count OUT NOCOPY NUMBER
355 ,x_msg_data OUT NOCOPY VARCHAR2
356 );
357
358 PROCEDURE is_action_seeded
359 (
360 p_glb_api_version IN NUMBER
361 ,p_glb_application_id IN NUMBER
362 ,p_action_id IN VARCHAR2
363 ,x_is_seeded OUT NOCOPY VARCHAR2
364 ,x_return_status OUT NOCOPY VARCHAR2
365 ,x_errorcode OUT NOCOPY NUMBER
366 ,x_msg_count OUT NOCOPY NUMBER
367 ,x_msg_data OUT NOCOPY VARCHAR2
368 );
369 PROCEDURE Create_Association (
370 p_api_version IN NUMBER
371 ,p_association_id IN NUMBER DEFAULT NULL
372 ,p_object_id IN NUMBER
373 ,p_classification_code IN VARCHAR2
374 ,p_data_level IN VARCHAR2
375 ,p_attr_group_id IN NUMBER
376 ,p_enabled_flag IN VARCHAR2
377 ,p_view_privilege_id IN NUMBER --ignored for now
378 ,p_edit_privilege_id IN NUMBER --ignored for now
379 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
380 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
381 ,x_association_id OUT NOCOPY NUMBER
382 ,x_return_status OUT NOCOPY VARCHAR2
383 ,x_errorcode OUT NOCOPY NUMBER
384 ,x_msg_count OUT NOCOPY NUMBER
385 ,x_msg_data OUT NOCOPY VARCHAR2
386 );
387
388 PROCEDURE Delete_Association (
389 p_api_version IN NUMBER
390 ,p_association_id IN NUMBER
391 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
392 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
393 ,p_force IN VARCHAR2 := fnd_api.g_FALSE
394 ,x_return_status OUT NOCOPY VARCHAR2
395 ,x_errorcode OUT NOCOPY NUMBER
396 ,x_msg_count OUT NOCOPY NUMBER
397 ,x_msg_data OUT NOCOPY VARCHAR2
398 );
399
400
401 END PO_UDA_TEMPLATES_UTIL;