1 PACKAGE ego_ext_fwk_pub AUTHID DEFINER AS
2 /* $Header: EGOPEFMS.pls 120.23.12020000.2 2012/07/13 01:33:57 mshirkol ship $ */
3
4 ----------------------
5 -- Global Constants --
6 ----------------------
7
8 G_TRANS_TEXT_DATA_TYPE CONSTANT VARCHAR2(1) := 'A';
9 G_CHAR_DATA_TYPE CONSTANT VARCHAR2(1) := 'C';
10 G_NUMBER_DATA_TYPE CONSTANT VARCHAR2(1) := 'N';
11 G_DATE_DATA_TYPE CONSTANT VARCHAR2(1) := 'X';
12 G_DATE_TIME_DATA_TYPE CONSTANT VARCHAR2(1) := 'Y';
13
14 G_TRANS_IND_VALIDATION_CODE CONSTANT VARCHAR2(1) := 'X';
15 G_INDEPENDENT_VALIDATION_CODE CONSTANT VARCHAR2(1) := 'I';
16 G_NONE_VALIDATION_CODE CONSTANT VARCHAR2(1) := 'N';
17 G_TABLE_VALIDATION_CODE CONSTANT VARCHAR2(1) := 'F';
18
19 G_ATTACH_DISP_TYPE CONSTANT VARCHAR2(1) := 'A';
20 G_CHECKBOX_DISP_TYPE CONSTANT VARCHAR2(1) := 'C';
21 G_DYN_URL_DISP_TYPE CONSTANT VARCHAR2(1) := 'D';
22 G_HIDDEN_DISP_TYPE CONSTANT VARCHAR2(1) := 'H';
23 G_RADIO_DISP_TYPE CONSTANT VARCHAR2(1) := 'R';
24 G_STATIC_URL_DISP_TYPE CONSTANT VARCHAR2(1) := 'S';
25 G_TEXT_FIELD_DISP_TYPE CONSTANT VARCHAR2(1) := 'T';
26
27 G_LOV_LONGLIST_FLAG CONSTANT VARCHAR2(1) := 'N';
28 G_POPLIST_LONGLIST_FLAG CONSTANT VARCHAR2(1) := 'X';
29
30 G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31 G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
32
33
34 ------------------
35 -- Custom Types --
36 ------------------
37
38 TYPE EGO_ATTR_USG_METADATA IS RECORD(
39 application_id NUMBER
40 ,attr_grp_type VARCHAR2(40)
41 ,attr_grp_name VARCHAR2(30)
42 ,attr_name VARCHAR2(30)
43 ,data_level VARCHAR2(30)
44 ,is_multi_row VARCHAR2(1)
45 ,data_type VARCHAR2(1)
46 );
47
48 TYPE EGO_VALUE_SET_VALUE_IDS IS VARRAY(100)
49 OF EGO_VS_VALUES_DISP_ORDER.value_set_value_id%TYPE;
50
51 TYPE EGO_VS_VALUES_DISP_ORDER_TBL IS TABLE
52 OF EGO_VS_VALUES_DISP_ORDER%ROWTYPE;
53
54 ------------------------
55 -- Miscellaneous APIs --
56 ------------------------
57
58 -- signature to use if caller has ATTR_GROUP_ID
59 FUNCTION Get_Privilege_For_Attr_Group (
60 p_attr_group_id IN NUMBER
61 ,p_which_priv_to_return IN VARCHAR2
62 )
63 RETURN VARCHAR2;
64
65 -- signature to use if caller doesn't have ATTR_GROUP_ID
66 FUNCTION Get_Privilege_For_Attr_Group (
67 p_application_id IN NUMBER
68 ,p_attr_group_type IN VARCHAR2
69 ,p_attr_group_name IN VARCHAR2
70 ,p_which_priv_to_return IN VARCHAR2
71 )
72 RETURN VARCHAR2;
73
74 FUNCTION Is_Column_Indexed (
75 p_column_name IN VARCHAR2
76 ,p_table_name IN VARCHAR2
77 ,p_application_id IN NUMBER DEFAULT NULL
78 ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
79 )
80 RETURN VARCHAR2;
81
82 FUNCTION Get_Attr_Group_Id_From_PKs (
83 p_application_id IN NUMBER
84 ,p_attr_group_type IN VARCHAR2
85 ,p_attr_group_name IN VARCHAR2
86 )
87 RETURN NUMBER;
88
89 FUNCTION Does_Attr_Have_Data (
90 p_application_id IN NUMBER DEFAULT NULL
91 ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
92 ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
93 ,p_attr_name IN VARCHAR2 DEFAULT NULL
94 ,p_attr_id IN NUMBER DEFAULT NULL
95 )
96 RETURN VARCHAR2;
97
98 FUNCTION Get_Application_Owner (
99 p_appl_id IN NUMBER
100 )
101 RETURN VARCHAR2 ;
102
103 FUNCTION Get_Oracle_UserName
104 RETURN VARCHAR2 ;
105
106 FUNCTION Check_Supported_Attr_Usages (
107 p_support_api IN VARCHAR2
108 ,p_application_id IN NUMBER
109 ,p_attr_grp_type IN VARCHAR2
110 ,p_attr_grp_name IN VARCHAR2
111 ,p_attr_name IN VARCHAR2
112 ,p_data_level IN VARCHAR2
113 ,p_is_multi_row IN VARCHAR2
114 ,p_data_type IN VARCHAR2
115 )
116 RETURN VARCHAR2;
117
118
119
120
121 /*
122 NOTE: WE DON'T USE THESE ANYMORE, BUT WE'LL KEEP THEM JUST IN CASE
123
124 -- signature to use if caller has ATTR_GROUP_ID
125 PROCEDURE Get_Available_AttrDBCol (
126 p_api_version IN NUMBER
127 ,p_attr_group_id IN NUMBER
128 ,p_data_type IN VARCHAR2
129 ,x_database_column OUT NOCOPY VARCHAR2
130 );
131
132 -- signature to use if caller doesn't have ATTR_GROUP_ID
133 PROCEDURE Get_Available_AttrDBCol (
134 p_api_version IN NUMBER
135 ,p_application_id IN NUMBER
136 ,p_attr_group_type IN VARCHAR2
137 ,p_attr_group_name IN VARCHAR2
138 ,p_data_type IN VARCHAR2
139 ,x_database_column OUT NOCOPY VARCHAR2
140 );
141
142 -- signature to use if caller has ATTR_GROUP_ID
143 PROCEDURE Get_Available_AttrDBCols (
144 p_api_version IN NUMBER
145 ,p_attr_group_id IN NUMBER
146 ,p_data_type IN VARCHAR2
147 ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
148 );
149
150 -- signature to use if caller doesn't have ATTR_GROUP_ID
151 PROCEDURE Get_Available_AttrDBCols (
152 p_api_version IN NUMBER
153 ,p_application_id IN NUMBER
154 ,p_attr_group_type IN VARCHAR2
155 ,p_attr_group_name IN VARCHAR2
156 ,p_data_type IN VARCHAR2
157 ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
158 );
159 */
160 ------------------------------------------------------------------------------------------
161 -- Function: To return the pending transalatable table name for a given attribute group type
162 -- an the application id
163 -- If the table is not defined, NULL is returned
164 --
165 -- Parameters:
166 -- IN
167 -- p_attr_group_type: attribute_group_type
168 -- p_attr_group_type application_id
169 -- OUT
170 -- l_table_name : translatable table for attribute_changes
171 ------------------------------------------------------------------------------------------
172 FUNCTION Get_Attr_Changes_TL_Table (
173 p_application_id IN NUMBER
174 ,p_attr_group_type IN VARCHAR2
175 )
176 RETURN VARCHAR2;
177
178 ------------------------------------------------------------------------------------------
179 -- Function: To return the pending base table name for a given attribute group type
180 -- an the application id
181 -- If the table is not defined, NULL is returned
182 --
183 -- Parameters:
184 -- IN
185 -- p_attr_group_type: attribute_group_type
186 -- p_attr_group_type application_id
187 -- OUT
188 -- l_table_name : base table for attribute_changes
189 ------------------------------------------------------------------------------------------
190
191 FUNCTION Get_Attr_Changes_B_Table (
192 p_application_id IN NUMBER
193 ,p_attr_group_type IN VARCHAR2
194 )
195 RETURN VARCHAR2;
196
197 FUNCTION Get_Table_Name (
198 p_application_id IN NUMBER
199 ,p_attr_group_type IN VARCHAR2
200 )
201 RETURN VARCHAR2;
202
203 FUNCTION Get_TL_Table_Name (
204 p_application_id IN NUMBER
205 ,p_attr_group_type IN VARCHAR2
206 )
207 RETURN VARCHAR2;
208
209 FUNCTION Get_Object_Id_From_Name (
210 p_object_name IN VARCHAR2
211 )
212 RETURN NUMBER;
213
214 FUNCTION Get_Object_Id_For_AG_Type (
215 p_application_id IN NUMBER
216 ,p_attr_group_type IN VARCHAR2
217 ) RETURN NUMBER;
218
219 FUNCTION Get_Class_Meaning (
220 p_object_name IN VARCHAR2
221 ,p_class_code IN VARCHAR2
222 )
223 RETURN VARCHAR2;
224
225 FUNCTION Get_Class_Meaning (
226 p_object_id IN NUMBER
227 ,p_class_code IN VARCHAR2
228 )
229 RETURN VARCHAR2;
230
231 PROCEDURE Get_Pk_Columns (
232 p_api_version IN NUMBER
233 ,p_obj_name IN VARCHAR2
234 ,x_pkcolumn1_name OUT NOCOPY VARCHAR2
235 ,x_pkcolumn1_type OUT NOCOPY VARCHAR2
236 ,x_pkcolumn2_name OUT NOCOPY VARCHAR2
237 ,x_pkcolumn2_type OUT NOCOPY VARCHAR2
238 ,x_pkcolumn3_name OUT NOCOPY VARCHAR2
239 ,x_pkcolumn3_type OUT NOCOPY VARCHAR2
240 ,x_pkcolumn4_name OUT NOCOPY VARCHAR2
241 ,x_pkcolumn4_type OUT NOCOPY VARCHAR2
242 ,x_pkcolumn5_name OUT NOCOPY VARCHAR2
243 ,x_pkcolumn5_type OUT NOCOPY VARCHAR2
244 );
245
246 --
247 -- This API is used to get the attribute changes table
248 -- for a given attribute group type.
249 --
250 PROCEDURE Get_Attr_Changes_Table (
251 p_attr_group_type IN VARCHAR2
252 ,x_base_table OUT NOCOPY VARCHAR2
253 ,x_tl_table OUT NOCOPY VARCHAR2
254 );
255
256
257 --------------------------
258 -- Attribute Group APIs --
259 --------------------------
260
261 -- Wrapper for JSPs that aren't set up to take ATTR_GROUP_ID --
262 PROCEDURE Create_Attribute_Group (
263 p_api_version IN NUMBER
264 ,p_application_id IN NUMBER
265 ,p_attr_group_type IN VARCHAR2
266 ,p_internal_name IN VARCHAR2
267 ,p_display_name IN VARCHAR2
268 ,p_attr_group_desc IN VARCHAR2
269 ,p_security_type IN VARCHAR2
270 ,p_multi_row_attrib_group IN VARCHAR2
271 ,p_variant_attrib_group IN VARCHAR2
272 ,p_num_of_cols IN NUMBER DEFAULT NULL
273 ,p_num_of_rows IN NUMBER DEFAULT NULL
274 ,p_owning_company_id IN NUMBER
275 ,p_region_code IN VARCHAR2 DEFAULT NULL
276 ,p_view_privilege_id IN NUMBER DEFAULT NULL
277 ,p_edit_privilege_id IN NUMBER DEFAULT NULL
278 ,p_business_event_flag IN VARCHAR2 DEFAULT NULL
279 ,p_pre_business_event_flag IN VARCHAR2 DEFAULT NULL
280 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
281 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
282 ,x_return_status OUT NOCOPY VARCHAR2
283 ,x_errorcode OUT NOCOPY NUMBER
284 ,x_msg_count OUT NOCOPY NUMBER
285 ,x_msg_data OUT NOCOPY VARCHAR2
286 );
287
288 PROCEDURE Create_Attribute_Group (
289 p_api_version IN NUMBER
290 ,p_application_id IN NUMBER
291 ,p_attr_group_type IN VARCHAR2
292 ,p_internal_name IN VARCHAR2
293 ,p_display_name IN VARCHAR2
294 ,p_attr_group_desc IN VARCHAR2
295 ,p_security_type IN VARCHAR2
296 ,p_multi_row_attrib_group IN VARCHAR2
297 ,p_variant_attrib_group IN VARCHAR2
298 ,p_num_of_cols IN NUMBER DEFAULT NULL
299 ,p_num_of_rows IN NUMBER DEFAULT NULL
300 ,p_owning_company_id IN NUMBER
301 ,p_region_code IN VARCHAR2 DEFAULT NULL
302 ,p_view_privilege_id IN NUMBER DEFAULT NULL
303 ,p_edit_privilege_id IN NUMBER DEFAULT NULL
304 ,p_business_event_flag IN VARCHAR2 DEFAULT NULL
305 ,p_pre_business_event_flag IN VARCHAR2 DEFAULT NULL
306 ,p_owner IN NUMBER DEFAULT NULL
307 ,p_lud IN DATE DEFAULT SYSDATE
308 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
309 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
310 ,x_attr_group_id OUT NOCOPY NUMBER
314 ,x_msg_data OUT NOCOPY VARCHAR2
311 ,x_return_status OUT NOCOPY VARCHAR2
312 ,x_errorcode OUT NOCOPY NUMBER
313 ,x_msg_count OUT NOCOPY NUMBER
315 );
316
317 -- Wrapper for JSPs that aren't set up to take ATTR_GROUP_ID --
318 PROCEDURE Copy_Attribute_Group (
319 p_api_version IN NUMBER
320 ,p_source_ag_app_id IN NUMBER
321 ,p_source_ag_type IN VARCHAR2
322 ,p_source_ag_name IN VARCHAR2
323 ,p_dest_ag_app_id IN NUMBER
324 ,p_dest_ag_type IN VARCHAR2
325 ,p_dest_ag_name IN VARCHAR2
326 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
327 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
328 ,x_return_status OUT NOCOPY VARCHAR2
329 ,x_errorcode OUT NOCOPY NUMBER
330 ,x_msg_count OUT NOCOPY NUMBER
331 ,x_msg_data OUT NOCOPY VARCHAR2
332 );
333
334 -- Wrapper for OA to pass source ATTR_GROUP_ID instead of Application Id, AG Type and AG Name--
335 PROCEDURE Copy_Attribute_Group (
336 p_api_version IN NUMBER
337 ,p_source_attr_group_id IN NUMBER
338 ,p_dest_ag_app_id IN NUMBER
339 ,p_dest_ag_type IN VARCHAR2
340 ,p_dest_ag_name IN VARCHAR2
341 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
342 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
343 ,x_attr_group_id OUT NOCOPY NUMBER
344 ,x_return_status OUT NOCOPY VARCHAR2
345 ,x_errorcode OUT NOCOPY NUMBER
346 ,x_msg_count OUT NOCOPY NUMBER
347 ,x_msg_data OUT NOCOPY VARCHAR2
348 );
349
350
351 PROCEDURE Copy_Attribute_Group (
352 p_api_version IN NUMBER
353 ,p_source_ag_app_id IN NUMBER
354 ,p_source_ag_type IN VARCHAR2
355 ,p_source_ag_name IN VARCHAR2
356 ,p_dest_ag_app_id IN NUMBER
357 ,p_dest_ag_type IN VARCHAR2
358 ,p_dest_ag_name IN VARCHAR2
359 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
360 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
361 ,x_attr_group_id OUT NOCOPY NUMBER
362 ,x_return_status OUT NOCOPY VARCHAR2
363 ,x_errorcode OUT NOCOPY NUMBER
364 ,x_msg_count OUT NOCOPY NUMBER
365 ,x_msg_data OUT NOCOPY VARCHAR2
366 );
367
368 -- signature to use if caller has ATTR_GROUP_ID
369 PROCEDURE Update_Attribute_Group (
370 p_api_version IN NUMBER
371 ,p_attr_group_id IN NUMBER
372 ,p_display_name IN VARCHAR2
373 ,p_attr_group_desc IN VARCHAR2
374 ,p_security_type IN VARCHAR2
375 ,p_multi_row_attrib_group IN VARCHAR2
376 ,p_variant_attrib_group IN VARCHAR2
377 ,p_num_of_cols IN NUMBER DEFAULT NULL
378 ,p_num_of_rows IN NUMBER DEFAULT NULL
379 ,p_owning_company_id IN NUMBER
380 ,p_region_code IN VARCHAR2 DEFAULT NULL
381 ,p_view_privilege_id IN NUMBER DEFAULT NULL
382 ,p_edit_privilege_id IN NUMBER DEFAULT NULL
383 ,p_business_event_flag IN VARCHAR2 DEFAULT NULL
384 ,p_pre_business_event_flag IN VARCHAR2 DEFAULT NULL
385 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
386 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
387 ,x_return_status OUT NOCOPY VARCHAR2
388 ,x_errorcode OUT NOCOPY NUMBER
389 ,x_msg_count OUT NOCOPY NUMBER
390 ,x_msg_data OUT NOCOPY VARCHAR2
391 );
392
393 -- signature to use if caller doesn't have ATTR_GROUP_ID
394 PROCEDURE Update_Attribute_Group (
395 p_api_version IN NUMBER
396 ,p_application_id IN NUMBER
397 ,p_attr_group_type IN VARCHAR2
398 ,p_internal_name IN VARCHAR2
399 ,p_display_name IN VARCHAR2
400 ,p_attr_group_desc IN VARCHAR2
401 ,p_security_type IN VARCHAR2
402 ,p_multi_row_attrib_group IN VARCHAR2
403 ,p_variant_attrib_group IN VARCHAR2
404 ,p_num_of_cols IN NUMBER DEFAULT NULL
405 ,p_num_of_rows IN NUMBER DEFAULT NULL
406 ,p_owning_company_id IN NUMBER
407 ,p_region_code IN VARCHAR2 DEFAULT NULL
408 ,p_view_privilege_id IN NUMBER DEFAULT NULL
409 ,p_edit_privilege_id IN NUMBER DEFAULT NULL
410 ,p_business_event_flag IN VARCHAR2 DEFAULT NULL
411 ,p_pre_business_event_flag IN VARCHAR2 DEFAULT NULL
412 ,p_owner IN NUMBER DEFAULT NULL
413 ,p_lud IN DATE DEFAULT SYSDATE
414 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
415 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
416 ,p_is_nls_mode IN VARCHAR2 DEFAULT FND_API.G_FALSE
420 ,x_msg_data OUT NOCOPY VARCHAR2
417 ,x_return_status OUT NOCOPY VARCHAR2
418 ,x_errorcode OUT NOCOPY NUMBER
419 ,x_msg_count OUT NOCOPY NUMBER
421 );
422
423 -- signature to use if caller has ATTR_GROUP_ID
424 PROCEDURE Delete_Attribute_Group (
425 p_api_version IN NUMBER
426 ,p_attr_group_id IN NUMBER
427 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
428 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
429 ,x_return_status OUT NOCOPY VARCHAR2
430 ,x_errorcode OUT NOCOPY NUMBER
431 ,x_msg_count OUT NOCOPY NUMBER
432 ,x_msg_data OUT NOCOPY VARCHAR2
433 );
434
435 -- signature to use if caller doesn't have ATTR_GROUP_ID
436 PROCEDURE Delete_Attribute_Group (
437 p_api_version IN NUMBER
438 ,p_application_id IN NUMBER
439 ,p_attr_group_type IN VARCHAR2
440 ,p_attr_group_name IN VARCHAR2
441 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
442 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
443 ,x_return_status OUT NOCOPY VARCHAR2
444 ,x_errorcode OUT NOCOPY NUMBER
445 ,x_msg_count OUT NOCOPY NUMBER
446 ,x_msg_data OUT NOCOPY VARCHAR2
447 );
448
449 PROCEDURE Compile_Attr_Group_Views (
450 ERRBUF OUT NOCOPY VARCHAR2
451 ,RETCODE OUT NOCOPY VARCHAR2
452 ,p_attr_group_id_list IN VARCHAR2
453 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
454 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
455 );
456
457 PROCEDURE Validate_Unique_Key_Attrs (
458 p_application_id IN NUMBER
459 ,p_attr_group_type IN VARCHAR2
460 ,p_attr_group_name IN VARCHAR2
461 ,p_id_list IN VARCHAR2
462 ,x_is_valid_key OUT NOCOPY VARCHAR2
463 );
464
465 ---------------------
466 -- Data Level APIs --
467 ---------------------
468
469 PROCEDURE Sync_Data_Level (
470 p_api_version IN NUMBER
471 ,p_init_msg_list IN VARCHAR2
472 ,p_commit IN VARCHAR2
473 ,p_transaction_type IN VARCHAR2
474 ,p_application_id IN NUMBER
475 ,p_attr_group_type IN VARCHAR2
476 ,p_data_level_name IN VARCHAR2
477 ,p_user_data_level_name IN VARCHAR2
478 ,p_pk1_column_name IN VARCHAR2
479 ,p_pk1_column_type IN VARCHAR2
480 ,p_pk2_column_name IN VARCHAR2
481 ,p_pk2_column_type IN VARCHAR2
482 ,p_pk3_column_name IN VARCHAR2
483 ,p_pk3_column_type IN VARCHAR2
484 ,p_pk4_column_name IN VARCHAR2
485 ,p_pk4_column_type IN VARCHAR2
486 ,p_pk5_column_name IN VARCHAR2
487 ,p_pk5_column_type IN VARCHAR2
488 ,p_enable_defaulting IN VARCHAR2
489 ,p_enable_view_priv IN VARCHAR2
490 ,p_enable_edit_priv IN VARCHAR2
491 ,p_enable_pre_event IN VARCHAR2
492 ,p_enable_post_event IN VARCHAR2
493 ,p_last_updated_by IN VARCHAR2
494 ,p_last_update_date IN DATE
495 ,p_is_nls_mode IN VARCHAR2
496 ,x_data_level_id IN OUT NOCOPY NUMBER
497 ,x_return_status OUT NOCOPY VARCHAR2
498 ,x_msg_count OUT NOCOPY NUMBER
499 ,x_msg_data OUT NOCOPY VARCHAR2
500 );
501
502 ---------------------------------
503 -- Data Level Association APIs --
504 ---------------------------------
505 PROCEDURE Sync_dl_assoc (
506 p_api_version IN NUMBER
507 ,p_init_msg_list IN VARCHAR2
508 ,p_commit IN VARCHAR2
509 ,p_transaction_type IN VARCHAR2
510 ,p_attr_group_id IN NUMBER
511 ,p_application_id IN NUMBER
512 ,p_attr_group_type IN VARCHAR2
513 ,p_attr_group_name IN VARCHAR2
514 ,p_data_level_id IN NUMBER
515 ,p_data_level_name IN VARCHAR2
516 ,p_defaulting IN VARCHAR2
517 ,p_defaulting_name IN VARCHAR2
518 ,p_view_priv_id IN NUMBER
519 ,p_view_priv_name IN VARCHAR2
520 ,p_user_view_priv_name IN VARCHAR2
521 ,p_edit_priv_id IN NUMBER
522 ,p_edit_priv_name IN VARCHAR2
523 ,p_user_edit_priv_name IN VARCHAR2
524 ,p_raise_pre_event IN VARCHAR2
525 ,p_raise_post_event IN VARCHAR2
526 ,p_last_updated_by IN VARCHAR2
527 ,p_last_update_date IN DATE
528 ,x_return_status OUT NOCOPY VARCHAR2
529 ,x_msg_count OUT NOCOPY NUMBER
530 ,x_msg_data OUT NOCOPY VARCHAR2
531 );
532
533 --------------------
534 -- Attribute APIs --
535 --------------------
536
537 PROCEDURE Create_Attribute (
538 p_api_version IN NUMBER
539 ,p_application_id IN NUMBER
540 ,p_attr_group_type IN VARCHAR2
544 ,p_description IN VARCHAR2
541 ,p_attr_group_name IN VARCHAR2
542 ,p_internal_name IN VARCHAR2
543 ,p_display_name IN VARCHAR2
545 ,p_sequence IN NUMBER
546 ,p_data_type IN VARCHAR2
547 ,p_required IN VARCHAR2
548 ,p_searchable IN VARCHAR2
549 ,p_column IN VARCHAR2
550 ,p_is_column_indexed IN VARCHAR2
551 ,p_value_set_id IN NUMBER
552 ,p_info_1 IN VARCHAR2 DEFAULT NULL
553 ,p_default_value IN VARCHAR2
554 ,p_unique_key_flag IN VARCHAR2
555 ,p_enabled IN VARCHAR2
556 ,p_display IN VARCHAR2
557 ,p_uom_class IN VARCHAR2
558 ,p_control_level IN NUMBER DEFAULT 1 --JDEJESU: NULL for 11.5.10E
559 ,p_attribute_code IN VARCHAR2 DEFAULT NULL
560 ,p_view_in_hierarchy_code IN VARCHAR2 DEFAULT 'A'
561 ,p_edit_in_hierarchy_code IN VARCHAR2 DEFAULT 'A'
562 ,p_customization_level IN VARCHAR2 DEFAULT 'A'
563 ,p_owner IN NUMBER DEFAULT NULL
564 ,p_lud IN DATE DEFAULT SYSDATE
565 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
566 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
567 ,x_return_status OUT NOCOPY VARCHAR2
568 ,x_errorcode OUT NOCOPY NUMBER
569 ,x_msg_count OUT NOCOPY NUMBER
570 ,x_msg_data OUT NOCOPY VARCHAR2
571 );
572
573 PROCEDURE Create_Attribute (
574 p_api_version IN NUMBER
575 ,p_application_id IN NUMBER
576 ,p_attr_group_type IN VARCHAR2
577 ,p_attr_group_name IN VARCHAR2
578 ,p_internal_name IN VARCHAR2
579 ,p_display_name IN VARCHAR2
580 ,p_description IN VARCHAR2
581 ,p_sequence IN NUMBER
582 ,p_data_type IN VARCHAR2
583 ,p_required IN VARCHAR2
584 ,p_searchable IN VARCHAR2
585 ,p_read_only_flag IN VARCHAR2
586 ,p_column IN VARCHAR2
587 ,p_is_column_indexed IN VARCHAR2
588 ,p_value_set_id IN NUMBER
589 ,p_info_1 IN VARCHAR2 DEFAULT NULL
590 ,p_default_value IN VARCHAR2
591 ,p_unique_key_flag IN VARCHAR2
592 ,p_enabled IN VARCHAR2
593 ,p_display IN VARCHAR2
594 ,p_uom_class IN VARCHAR2
595 ,p_control_level IN NUMBER DEFAULT 1 --JDEJESU: NULL for 11.5.10E
596 ,p_attribute_code IN VARCHAR2 DEFAULT NULL
597 ,p_view_in_hierarchy_code IN VARCHAR2 DEFAULT 'A'
598 ,p_edit_in_hierarchy_code IN VARCHAR2 DEFAULT 'A'
599 ,p_customization_level IN VARCHAR2 DEFAULT 'A'
600 ,p_owner IN NUMBER DEFAULT NULL
601 ,p_lud IN DATE DEFAULT SYSDATE
602 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
603 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
604 ,x_return_status OUT NOCOPY VARCHAR2
605 ,x_errorcode OUT NOCOPY NUMBER
606 ,x_msg_count OUT NOCOPY NUMBER
607 ,x_msg_data OUT NOCOPY VARCHAR2
608 );
609 PROCEDURE Update_Attribute (
610 p_api_version IN NUMBER
611 ,p_application_id IN NUMBER
612 ,p_attr_group_type IN VARCHAR2
613 ,p_attr_group_name IN VARCHAR2
614 ,p_internal_name IN VARCHAR2
615 ,p_display_name IN VARCHAR2
616 ,p_description IN VARCHAR2
617 ,p_sequence IN NUMBER
618 ,p_required IN VARCHAR2
619 ,p_searchable IN VARCHAR2
620 ,p_column IN VARCHAR2
621 ,p_value_set_id IN NUMBER DEFAULT G_MISS_NUM
622 ,p_info_1 IN VARCHAR2 DEFAULT NULL
623 ,p_default_value IN VARCHAR2
624 ,p_unique_key_flag IN VARCHAR2 DEFAULT NULL
625 ,p_enabled IN VARCHAR2
626 ,p_display IN VARCHAR2
627 ,p_control_level IN NUMBER DEFAULT -1
628 ,p_attribute_code IN VARCHAR2 DEFAULT G_MISS_CHAR
629 ,p_view_in_hierarchy_code IN VARCHAR2 DEFAULT G_MISS_CHAR
630 ,p_edit_in_hierarchy_code IN VARCHAR2 DEFAULT G_MISS_CHAR
631 ,p_customization_level IN VARCHAR2 DEFAULT G_MISS_CHAR
632 ,p_owner IN NUMBER DEFAULT NULL
633 ,p_lud IN DATE DEFAULT SYSDATE
634 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
635 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
636 ,p_is_nls_mode IN VARCHAR2 DEFAULT FND_API.G_FALSE
637 ,p_uom_class IN VARCHAR2 DEFAULT G_MISS_CHAR
638 ,x_return_status OUT NOCOPY VARCHAR2
642 );
639 ,x_errorcode OUT NOCOPY NUMBER
640 ,x_msg_count OUT NOCOPY NUMBER
641 ,x_msg_data OUT NOCOPY VARCHAR2
643
644 PROCEDURE Update_Attribute (
645 p_api_version IN NUMBER
646 ,p_application_id IN NUMBER
647 ,p_attr_group_type IN VARCHAR2
648 ,p_attr_group_name IN VARCHAR2
649 ,p_internal_name IN VARCHAR2
650 ,p_display_name IN VARCHAR2
651 ,p_description IN VARCHAR2
652 ,p_sequence IN NUMBER
653 ,p_required IN VARCHAR2
654 ,p_searchable IN VARCHAR2
655 ,p_read_only_flag IN VARCHAR2
656 ,p_column IN VARCHAR2
657 ,p_value_set_id IN NUMBER DEFAULT G_MISS_NUM
658 ,p_info_1 IN VARCHAR2 DEFAULT NULL
659 ,p_default_value IN VARCHAR2
660 ,p_unique_key_flag IN VARCHAR2 DEFAULT NULL
661 ,p_enabled IN VARCHAR2
662 ,p_display IN VARCHAR2
663 ,p_control_level IN NUMBER DEFAULT -1
664 ,p_attribute_code IN VARCHAR2 DEFAULT G_MISS_CHAR
665 ,p_view_in_hierarchy_code IN VARCHAR2 DEFAULT G_MISS_CHAR
666 ,p_edit_in_hierarchy_code IN VARCHAR2 DEFAULT G_MISS_CHAR
667 ,p_customization_level IN VARCHAR2 DEFAULT G_MISS_CHAR
668 ,p_owner IN NUMBER DEFAULT NULL
669 ,p_lud IN DATE DEFAULT SYSDATE
670 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
671 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
672 ,p_is_nls_mode IN VARCHAR2 DEFAULT FND_API.G_FALSE
673 ,p_uom_class IN VARCHAR2 DEFAULT G_MISS_CHAR
674 ,x_return_status OUT NOCOPY VARCHAR2
675 ,x_errorcode OUT NOCOPY NUMBER
676 ,x_msg_count OUT NOCOPY NUMBER
677 ,x_msg_data OUT NOCOPY VARCHAR2
678 );
679
680 PROCEDURE Delete_Attribute (
681 p_api_version IN NUMBER
682 ,p_application_id IN NUMBER
683 ,p_attr_group_type IN VARCHAR2
684 ,p_attr_group_name IN VARCHAR2
685 ,p_attr_name IN VARCHAR2
686 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
687 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
688 ,x_return_status OUT NOCOPY VARCHAR2
689 ,x_errorcode OUT NOCOPY NUMBER
690 ,x_msg_count OUT NOCOPY NUMBER
691 ,x_msg_data OUT NOCOPY VARCHAR2
692 );
693
694 --------------------
695 -- Value Set APIs --
696 --------------------
697
698 -- signature to use if caller wants to specify OWNER
699 PROCEDURE Create_Value_Set (
700 p_api_version IN NUMBER
701 -- ,p_application_id IN NUMBER
702 ,p_value_set_name IN VARCHAR2
703 ,p_description IN VARCHAR2
704 ,p_format_code IN VARCHAR2
705 ,p_maximum_size IN NUMBER DEFAULT 0
706 ,p_maximum_value IN VARCHAR2
707 ,p_minimum_value IN VARCHAR2
708 ,p_long_list_flag IN VARCHAR2
709 ,p_validation_code IN VARCHAR2
710 ,p_owner IN NUMBER DEFAULT NULL
711 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
712 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
713 ,x_value_set_id OUT NOCOPY NUMBER
714 ,x_return_status OUT NOCOPY VARCHAR2
715 ,x_msg_count OUT NOCOPY NUMBER
716 ,x_msg_data OUT NOCOPY VARCHAR2
717 );
718
719 PROCEDURE REVERT_TO_AN_EARLIER_VERSION(
720 p_api_version IN NUMBER
721 ,p_value_set_id IN NUMBER
722 ,p_version_number IN NUMBER
723 ,x_return_status OUT NOCOPY VARCHAR2
724 ,x_msg_count OUT NOCOPY number
725 ,x_msg_data OUT NOCOPY VARCHAR2
726 );
727
728 --Signature for converting non-versioned value set to an versioned value set.
729 PROCEDURE CONVERT_TO_VERSIONED_VALUE_SET(
730 p_api_version IN NUMBER
731 ,p_value_set_id IN NUMBER
732 ,p_description IN VARCHAR2
733 ,x_return_status OUT NOCOPY VARCHAR2
734 ,x_msg_count OUT NOCOPY number
735 ,x_msg_data OUT NOCOPY VARCHAR2
736 );
737
738
739 --API signature to delete the value from versioned value set.
740
741 PROCEDURE Delete_Value_Set_val(
742 p_value_set_id IN NUMBER
743 ,p_value_id IN NUMBER
744 ,x_return_status OUT NOCOPY VARCHAR2
745 );
746
747 PROCEDURE get_version_number(
748 p_api_version IN NUMBER
749 ,p_value_set_id IN NUMBER
750 ,p_start_effective_date IN TIMESTAMP
751 ,p_creation_date IN TIMESTAMP
752 ,p_version_number OUT NOCOPY NUMBER
756
753 ,x_return_status OUT NOCOPY VARCHAR2
754 );
755
757
758 PROCEDURE RELEASE_VALUE_SET_VERSION(
759 p_api_version IN NUMBER
760 ,p_value_set_id IN NUMBER
761 ,p_description IN VARCHAR2
762 ,p_start_date IN TIMESTAMP
763 ,p_version_seq_id IN number
764 , x_return_status OUT NOCOPY VARCHAR2
765 ,x_msg_count OUT NOCOPY VARCHAR2
766 ,x_msg_data OUT NOCOPY varchar2
767 ) ;
768
769
770 /* changes For PIM For Telco Feature */
771 PROCEDURE Create_Value_Set (
772 p_api_version IN NUMBER
773 -- ,p_application_id IN NUMBER
774 ,p_value_set_name IN VARCHAR2
775 ,p_description IN VARCHAR2
776 ,p_format_code IN VARCHAR2
777 ,p_maximum_size IN NUMBER DEFAULT 0
778 ,p_maximum_value IN VARCHAR2
779 ,p_minimum_value IN VARCHAR2
780 ,p_long_list_flag IN VARCHAR2
781 ,p_validation_code IN VARCHAR2
782 ,p_owner IN NUMBER DEFAULT NULL
783 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
784 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
785 ,x_value_set_id OUT NOCOPY NUMBER
786 ,x_return_status OUT NOCOPY VARCHAR2
787 ,x_msg_count OUT NOCOPY NUMBER
788 ,x_msg_data OUT NOCOPY VARCHAR2
789 ,p_versioning_enabled IN VARCHAR2
790 );
791
792
793
794 PROCEDURE Create_Child_Value_Set (
795 p_api_version IN NUMBER := 1.0
796 ,p_value_set_name IN VARCHAR2 -- Child Value Set Name
797 ,p_description IN VARCHAR2
798 ,p_parent_vs_id IN NUMBER
799 ,p_owner IN NUMBER
800 ,child_vs_value_ids IN EGO_VALUE_SET_VALUE_IDS := NULL
801 -- collection of value set value IDS
802 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
803 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
804 ,x_child_vs_id OUT NOCOPY NUMBER -- child value set ID
805 ,x_return_status OUT NOCOPY VARCHAR2
806 ,x_msg_count OUT NOCOPY NUMBER
807 ,x_msg_data OUT NOCOPY VARCHAR2
808 );
809
810 PROCEDURE Delete_Child_Value_Set (
811 p_api_version IN NUMBER
812 ,p_application_id IN NUMBER
813 ,p_child_vs_id IN NUMBER
814 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
815 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
816 ,x_return_status OUT NOCOPY VARCHAR2
817 ,x_errorcode OUT NOCOPY NUMBER
818 ,x_msg_count OUT NOCOPY NUMBER
819 ,x_msg_data OUT NOCOPY VARCHAR2
820 );
821
822 PROCEDURE Update_Child_Value_Set (
823 p_api_version IN NUMBER
824 ,p_value_set_id IN NUMBER
825 ,p_description IN VARCHAR2
826 ,p_format_code IN VARCHAR2
827 -- ,p_maximum_size IN NUMBER
828 -- ,p_maximum_value IN VARCHAR2
829 -- ,p_minimum_value IN VARCHAR2
830 -- ,p_long_list_flag IN VARCHAR2
831 -- ,p_validation_code IN VARCHAR2
832 ,p_owner IN NUMBER DEFAULT NULL
833 ,child_vs_value_ids IN EGO_VALUE_SET_VALUE_IDS
834 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
835 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
836 ,x_return_status OUT NOCOPY VARCHAR2
837 ,x_msg_count OUT NOCOPY NUMBER
838 ,x_msg_data OUT NOCOPY VARCHAR2
839 );
840
841 -- signature to use if caller wants to specify OWNER
842 PROCEDURE Update_Value_Set (
843 p_api_version IN NUMBER
844 ,p_value_set_id IN NUMBER
845 ,p_description IN VARCHAR2
846 ,p_format_code IN VARCHAR2
847 ,p_maximum_size IN NUMBER
848 ,p_maximum_value IN VARCHAR2
849 ,p_minimum_value IN VARCHAR2
850 ,p_long_list_flag IN FND_FLEX_VALUE_SETS.LONGLIST_FLAG%TYPE
851 -- VARCHAR2
852 ,p_validation_code IN VARCHAR2
853 ,p_owner IN NUMBER DEFAULT NULL
854 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
855 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
856 ,x_return_status OUT NOCOPY VARCHAR2
857 -- ,x_errorcode OUT NOCOPY NUMBER
858 ,x_msg_count OUT NOCOPY NUMBER
859 ,x_msg_data OUT NOCOPY VARCHAR2
860 --changes for P4T
861 ,x_versioned_vs OUT NOCOPY VARCHAR2
862
863 );
864
865 PROCEDURE Insert_Value_Set_Table_Inf (
866 p_api_version IN NUMBER
867 ,p_value_set_id IN NUMBER
871 ,p_value_column_type IN VARCHAR2
868 ,p_table_application_id IN NUMBER
869 ,p_table_name IN VARCHAR2
870 ,p_value_column_name IN VARCHAR2
872 ,p_value_column_size IN NUMBER
873 ,p_meaning_column_name IN VARCHAR2
874 ,p_meaning_column_type IN VARCHAR2
875 ,p_meaning_column_size IN NUMBER
876 ,p_id_column_name IN VARCHAR2
877 ,p_id_column_type IN VARCHAR2
878 ,p_id_column_size IN NUMBER
879 ,p_where_order_by IN VARCHAR2
880 ,p_additional_columns IN VARCHAR2
881 ,p_owner IN NUMBER DEFAULT NULL
882 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
883 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
884 ,x_return_status OUT NOCOPY VARCHAR2
885 ,x_msg_count OUT NOCOPY NUMBER
886 ,x_msg_data OUT NOCOPY VARCHAR2
887 );
888
889 PROCEDURE Update_Value_Set_Table_Inf (
890 p_api_version IN NUMBER
891 ,p_value_set_id IN NUMBER
892 ,p_table_application_id IN NUMBER
893 ,p_table_name IN VARCHAR2
894 ,p_value_column_name IN VARCHAR2
895 ,p_value_column_type IN VARCHAR2
896 ,p_value_column_size IN NUMBER
897 ,p_meaning_column_name IN VARCHAR2
898 ,p_meaning_column_type IN VARCHAR2
899 ,p_meaning_column_size IN NUMBER
900 ,p_id_column_name IN VARCHAR2
901 ,p_id_column_type IN VARCHAR2
902 ,p_id_column_size IN NUMBER
903 ,p_where_order_by IN VARCHAR2
904 ,p_additional_columns IN VARCHAR2
905 ,p_owner IN NUMBER DEFAULT NULL
906 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
907 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
908 ,x_return_status OUT NOCOPY VARCHAR2
909 ,x_msg_count OUT NOCOPY NUMBER
910 ,x_msg_data OUT NOCOPY VARCHAR2
911 );
912
913 FUNCTION has_flex_binding (cp_value_set_id IN NUMBER)
914 RETURN VARCHAR2;
915
916 FUNCTION is_vs_editable (cp_value_set_id IN NUMBER)
917 RETURN VARCHAR2;
918
919 --------------------------
920 -- Value Set Value APIs --
921 --------------------------
922
923 PROCEDURE Create_Value_Set_Val (
924 p_api_version IN NUMBER
925 ,p_value_set_name IN VARCHAR2
926 ,p_internal_name IN VARCHAR2
927 ,p_display_name IN VARCHAR2
928 ,p_description IN VARCHAR2
929 ,p_sequence IN NUMBER
930 ,p_start_date IN DATE
931 ,p_end_date IN DATE
932 ,p_enabled IN VARCHAR2
933 ,p_owner IN NUMBER DEFAULT NULL
934 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
935 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
936 ,x_return_status OUT NOCOPY VARCHAR2
937 ,x_msg_count OUT NOCOPY NUMBER
938 ,x_msg_data OUT NOCOPY VARCHAR2
939 ,x_is_versioned OUT NOCOPY VARCHAR2
940 ,x_valueSetId OUT NOCOPY VARCHAR2
941
942 );
943
944
945 PROCEDURE Create_Value_Set_Val (
946 p_api_version IN NUMBER
947 ,p_value_set_name IN VARCHAR2
948 ,p_internal_name IN VARCHAR2
949 ,p_display_name IN VARCHAR2
950 ,p_description IN VARCHAR2
951 ,p_sequence IN NUMBER
952 ,p_start_date IN DATE
953 ,p_end_date IN DATE
954 ,p_enabled IN VARCHAR2
955 ,p_owner IN NUMBER DEFAULT NULL
956 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
957 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
958 ,x_return_status OUT NOCOPY VARCHAR2
959 ,x_msg_count OUT NOCOPY NUMBER
960 ,x_msg_data OUT NOCOPY VARCHAR2
961
962 );
963
964
965 PROCEDURE Update_Value_Set_Val (
966 p_api_version IN NUMBER
967 ,p_value_set_name IN VARCHAR2
968 ,p_internal_name IN VARCHAR2
969 ,p_display_name IN VARCHAR2
970 ,p_description IN VARCHAR2
971 ,p_sequence IN NUMBER
972 ,p_start_date IN DATE
973 ,p_end_date IN DATE
974 ,p_enabled IN VARCHAR2
975 ,p_owner IN NUMBER DEFAULT NULL
976 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
977 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
978 ,x_return_status OUT NOCOPY VARCHAR2
979 ,x_msg_count OUT NOCOPY NUMBER
980 ,x_msg_data OUT NOCOPY VARCHAR2
981 ,x_is_versioned OUT NOCOPY VARCHAR2
985
982 ,x_valueSetId OUT NOCOPY VARCHAR2
983
984 );
986
987
988
989 PROCEDURE Translate_Value_Set_Val
990 (p_api_version IN NUMBER
991 ,p_value_set_name IN VARCHAR2
992 ,p_internal_name IN VARCHAR2
993 ,p_display_name IN VARCHAR2
994 ,p_description IN VARCHAR2
995 ,p_last_update_date IN VARCHAR2
996 ,p_last_updated_by IN NUMBER
997 ,p_init_msg_list IN VARCHAR2
998 ,p_commit IN VARCHAR2
999 ,x_return_status OUT NOCOPY VARCHAR2
1000 ,x_msg_count OUT NOCOPY NUMBER
1001 ,x_msg_data OUT NOCOPY VARCHAR2
1002 );
1003
1004
1005 PROCEDURE Process_VS_Value_Sequence
1006 (p_api_version IN NUMBER
1007 ,p_transaction_type IN VARCHAR2
1008 ,p_value_set_id IN NUMBER DEFAULT NULL
1009 ,p_value_set_name IN VARCHAR2 DEFAULT NULL
1010 ,p_value_set_value_id IN NUMBER DEFAULT NULL
1011 ,p_value_set_value IN VARCHAR2 DEFAULT NULL
1012 ,p_sequence IN NUMBER
1013 ,p_owner IN NUMBER DEFAULT NULL
1014 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1015 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1016 ,x_return_status OUT NOCOPY VARCHAR2
1017 ,x_msg_count OUT NOCOPY NUMBER
1018 ,x_msg_data OUT NOCOPY VARCHAR2
1019 );
1020
1021
1022 FUNCTION is_vs_value_editable (cp_vs_value_id IN NUMBER)
1023 RETURN VARCHAR2;
1024
1025 -----------------------------
1026 -- Object Association APIs --
1027 -----------------------------
1028
1029 -- signature to use if caller has OBJECT_ID and ATTR_GROUP_ID
1030 PROCEDURE Create_Association (
1031 p_api_version IN NUMBER
1032 ,p_association_id IN NUMBER DEFAULT NULL
1033 ,p_object_id IN NUMBER
1034 ,p_classification_code IN VARCHAR2
1035 ,p_data_level IN VARCHAR2
1036 ,p_attr_group_id IN NUMBER
1037 ,p_enabled_flag IN VARCHAR2
1038 ,p_view_privilege_id IN NUMBER --ignored for now
1039 ,p_edit_privilege_id IN NUMBER --ignored for now
1040 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1041 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1042 ,x_association_id OUT NOCOPY NUMBER
1043 ,x_return_status OUT NOCOPY VARCHAR2
1044 ,x_errorcode OUT NOCOPY NUMBER
1045 ,x_msg_count OUT NOCOPY NUMBER
1046 ,x_msg_data OUT NOCOPY VARCHAR2
1047 );
1048
1049 -- signature to use if caller has OBJECT_ID but not ATTR_GROUP_ID
1050 PROCEDURE Create_Association (
1051 p_api_version IN NUMBER
1052 ,p_association_id IN NUMBER DEFAULT NULL
1053 ,p_object_id IN NUMBER
1054 ,p_classification_code IN VARCHAR2
1055 ,p_data_level IN VARCHAR2
1056 ,p_application_id IN NUMBER
1057 ,p_attr_group_type IN VARCHAR2
1058 ,p_attr_group_name IN VARCHAR2
1059 ,p_enabled_flag IN VARCHAR2
1060 ,p_view_privilege_id IN NUMBER --ignored for now
1061 ,p_edit_privilege_id IN NUMBER --ignored for now
1062 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1063 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1064 ,x_association_id OUT NOCOPY NUMBER
1065 ,x_return_status OUT NOCOPY VARCHAR2
1066 ,x_errorcode OUT NOCOPY NUMBER
1067 ,x_msg_count OUT NOCOPY NUMBER
1068 ,x_msg_data OUT NOCOPY VARCHAR2
1069 );
1070
1071 -- signature to use if caller doesn't have OBJECT_ID or ATTR_GROUP_ID
1072 PROCEDURE Create_Association (
1073 p_api_version IN NUMBER
1074 ,p_object_name IN VARCHAR2
1075 ,p_classification_code IN VARCHAR2
1076 ,p_data_level IN VARCHAR2
1077 ,p_application_id IN NUMBER
1078 ,p_attr_group_type IN VARCHAR2
1079 ,p_attr_group_name IN VARCHAR2
1080 ,p_enabled_flag IN VARCHAR2
1081 ,p_view_privilege_id IN NUMBER --ignored for now
1082 ,p_edit_privilege_id IN NUMBER --ignored for now
1083 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1084 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1085 ,x_association_id OUT NOCOPY NUMBER
1086 ,x_return_status OUT NOCOPY VARCHAR2
1087 ,x_errorcode OUT NOCOPY NUMBER
1088 ,x_msg_count OUT NOCOPY NUMBER
1089 ,x_msg_data OUT NOCOPY VARCHAR2
1090 );
1091
1092 -- signature to use if caller has ASSOCIATION_ID
1093 PROCEDURE Update_Association (
1094 p_api_version IN NUMBER
1095 ,p_association_id IN NUMBER
1096 ,p_enabled_flag IN VARCHAR2
1097 ,p_view_privilege_id IN NUMBER --ignored for now
1101 ,x_return_status OUT NOCOPY VARCHAR2
1098 ,p_edit_privilege_id IN NUMBER --ignored for now
1099 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1100 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1102 ,x_errorcode OUT NOCOPY NUMBER
1103 ,x_msg_count OUT NOCOPY NUMBER
1104 ,x_msg_data OUT NOCOPY VARCHAR2
1105 );
1106
1107 -- signature to use if caller doesn't have ASSOCIATION_ID but has ATTR_GROUP_ID
1108 PROCEDURE Update_Association (
1109 p_api_version IN NUMBER
1110 ,p_object_id IN NUMBER
1111 ,p_classification_code IN VARCHAR2
1112 ,p_attr_group_id IN NUMBER
1113 ,p_enabled_flag IN VARCHAR2
1114 ,p_view_privilege_id IN NUMBER --ignored for now
1115 ,p_edit_privilege_id IN NUMBER --ignored for now
1116 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1117 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1118 ,x_return_status OUT NOCOPY VARCHAR2
1119 ,x_errorcode OUT NOCOPY NUMBER
1120 ,x_msg_count OUT NOCOPY NUMBER
1121 ,x_msg_data OUT NOCOPY VARCHAR2
1122 );
1123
1124 -- signature to use if caller doesn't have ASSOCIATION_ID or ATTR_GROUP_ID
1125 PROCEDURE Update_Association (
1126 p_api_version IN NUMBER
1127 ,p_object_id IN NUMBER
1128 ,p_classification_code IN VARCHAR2
1129 ,p_application_id IN NUMBER
1130 ,p_attr_group_type IN VARCHAR2
1131 ,p_attr_group_name IN VARCHAR2
1132 ,p_enabled_flag IN VARCHAR2
1133 ,p_view_privilege_id IN NUMBER --ignored for now
1134 ,p_edit_privilege_id IN NUMBER --ignored for now
1135 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1136 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1137 ,x_return_status OUT NOCOPY VARCHAR2
1138 ,x_errorcode OUT NOCOPY NUMBER
1139 ,x_msg_count OUT NOCOPY NUMBER
1140 ,x_msg_data OUT NOCOPY VARCHAR2
1141 );
1142
1143 PROCEDURE Delete_Association (
1144 p_api_version IN NUMBER
1145 ,p_association_id IN NUMBER
1146 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1147 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1148 ,p_force IN VARCHAR2 := fnd_api.g_FALSE
1149 ,x_return_status OUT NOCOPY VARCHAR2
1150 ,x_errorcode OUT NOCOPY NUMBER
1151 ,x_msg_count OUT NOCOPY NUMBER
1152 ,x_msg_data OUT NOCOPY VARCHAR2
1153 );
1154
1155 -------------------------------
1156 -- Attribute Group Page APIs --
1157 -------------------------------
1158
1159 PROCEDURE Create_Page (
1160 p_api_version IN NUMBER
1161 ,p_page_id IN NUMBER DEFAULT NULL
1162 ,p_object_id IN NUMBER
1163 ,p_classification_code IN VARCHAR2
1164 ,p_data_level IN VARCHAR2
1165 ,p_internal_name IN VARCHAR2
1166 ,p_display_name IN VARCHAR2
1167 ,p_description IN VARCHAR2
1168 ,p_sequence IN NUMBER
1169 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1170 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1171 ,x_page_id OUT NOCOPY NUMBER
1172 ,x_return_status OUT NOCOPY VARCHAR2
1173 ,x_errorcode OUT NOCOPY NUMBER
1174 ,x_msg_count OUT NOCOPY NUMBER
1175 ,x_msg_data OUT NOCOPY VARCHAR2
1176 );
1177
1178 -- signature to use if caller has PAGE_ID
1179 PROCEDURE Update_Page (
1180 p_api_version IN NUMBER
1181 ,p_page_id IN NUMBER
1182 ,p_internal_name IN VARCHAR2
1183 ,p_display_name IN VARCHAR2
1184 ,p_description IN VARCHAR2
1185 ,p_sequence IN NUMBER
1186 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1187 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1188 ,p_is_nls_mode IN VARCHAR2 DEFAULT FND_API.G_FALSE
1189 ,x_return_status OUT NOCOPY VARCHAR2
1190 ,x_errorcode OUT NOCOPY NUMBER
1191 ,x_msg_count OUT NOCOPY NUMBER
1192 ,x_msg_data OUT NOCOPY VARCHAR2
1193 );
1194
1195 -- signature to use if caller doesn't have PAGE_ID
1196 -- the caller can set p_new_internal_name to null, in which case it will not be updated
1197 PROCEDURE Update_Page (
1198 p_api_version IN NUMBER
1199 ,p_object_id IN NUMBER
1200 ,p_classification_code IN VARCHAR2
1201 ,p_data_level IN VARCHAR2
1202 ,p_old_internal_name IN VARCHAR2
1203 ,p_new_internal_name IN VARCHAR2
1204 ,p_display_name IN VARCHAR2
1205 ,p_description IN VARCHAR2
1206 ,p_sequence IN NUMBER
1210 ,x_errorcode OUT NOCOPY NUMBER
1207 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1208 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1209 ,x_return_status OUT NOCOPY VARCHAR2
1211 ,x_msg_count OUT NOCOPY NUMBER
1212 ,x_msg_data OUT NOCOPY VARCHAR2
1213 );
1214
1215 -- signature to use if caller has PAGE_ID
1216 PROCEDURE Delete_Page (
1217 p_api_version IN NUMBER
1218 ,p_page_id IN NUMBER
1219 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1220 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1221 ,x_return_status OUT NOCOPY VARCHAR2
1222 ,x_errorcode OUT NOCOPY NUMBER
1223 ,x_msg_count OUT NOCOPY NUMBER
1224 ,x_msg_data OUT NOCOPY VARCHAR2
1225 );
1226
1227 -- signature to use if caller doesn't have PAGE_ID
1228 PROCEDURE Delete_Page (
1229 p_api_version IN NUMBER
1230 ,p_object_id IN NUMBER
1231 ,p_classification_code IN VARCHAR2
1232 ,p_internal_name IN VARCHAR2
1233 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1234 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1235 ,x_return_status OUT NOCOPY VARCHAR2
1236 ,x_errorcode OUT NOCOPY NUMBER
1237 ,x_msg_count OUT NOCOPY NUMBER
1238 ,x_msg_data OUT NOCOPY VARCHAR2
1239 );
1240
1241 -- A "group by" function for SQL queries
1242 FUNCTION Group_Page_Regions (
1243 p_association_id IN NUMBER
1244 ,p_object_id IN NUMBER
1245 ,p_object_name IN VARCHAR2
1246 ,p_classification_code IN VARCHAR2
1247 ,p_data_level IN VARCHAR2
1248 ,p_application_id IN NUMBER
1249 ,p_attr_group_type IN VARCHAR2
1250 ,p_attr_group_name IN VARCHAR2
1251 ,p_attr_group_disp_name IN VARCHAR2
1252 ,p_attr_group_description IN VARCHAR2
1253 ,p_enabled_code IN VARCHAR2
1254 )
1255 RETURN VARCHAR2;
1256
1257 ---------------------
1258 -- Page Entry APIs --
1259 ---------------------
1260
1261 PROCEDURE Create_Page_Entry (
1262 p_api_version IN NUMBER
1263 ,p_page_id IN NUMBER
1264 ,p_association_id IN NUMBER
1265 ,p_sequence IN NUMBER
1266 ,p_classification_code IN VARCHAR2
1267 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1268 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1269 ,x_return_status OUT NOCOPY VARCHAR2
1270 ,x_errorcode OUT NOCOPY NUMBER
1271 ,x_msg_count OUT NOCOPY NUMBER
1272 ,x_msg_data OUT NOCOPY VARCHAR2
1273 );
1274
1275 PROCEDURE Update_Page_Entry (
1276 p_api_version IN NUMBER
1277 ,p_page_id IN NUMBER
1278 ,p_new_association_id IN NUMBER --2995435: Doesnt update association id
1279 ,p_old_association_id IN NUMBER --2995435: Doesnt update association id
1280 ,p_sequence IN NUMBER
1281 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1282 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1283 ,x_return_status OUT NOCOPY VARCHAR2
1284 ,x_errorcode OUT NOCOPY NUMBER
1285 ,x_msg_count OUT NOCOPY NUMBER
1286 ,x_msg_data OUT NOCOPY VARCHAR2
1287 );
1288
1289 PROCEDURE Delete_Page_Entry (
1290 p_api_version IN NUMBER
1291 ,p_page_id IN NUMBER
1292 ,p_association_id IN NUMBER
1293 ,p_classification_code IN VARCHAR2 -- Bug 3871440
1294 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1295 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1296 ,x_return_status OUT NOCOPY VARCHAR2
1297 ,x_errorcode OUT NOCOPY NUMBER
1298 ,x_msg_count OUT NOCOPY NUMBER
1299 ,x_msg_data OUT NOCOPY VARCHAR2
1300 );
1301
1302 -------------------
1303 -- Function APIs --
1304 -------------------
1305
1306 PROCEDURE Create_Function (
1307 p_api_version IN NUMBER
1308 ,p_internal_name IN VARCHAR2
1309 ,p_function_type IN VARCHAR2
1310 ,p_function_info_1 IN VARCHAR2
1311 ,p_function_info_2 IN VARCHAR2
1312 ,p_display_name IN VARCHAR2
1313 ,p_description IN VARCHAR2
1314 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1315 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1316 ,x_function_id OUT NOCOPY NUMBER
1317 ,x_return_status OUT NOCOPY VARCHAR2
1318 ,x_errorcode OUT NOCOPY NUMBER
1319 ,x_msg_count OUT NOCOPY NUMBER
1320 ,x_msg_data OUT NOCOPY VARCHAR2
1321 );
1322
1326 ,p_internal_name IN VARCHAR2
1323 PROCEDURE Update_Function (
1324 p_api_version IN NUMBER
1325 ,p_function_id IN NUMBER
1327 ,p_function_info_1 IN VARCHAR2
1328 ,p_function_info_2 IN VARCHAR2
1329 ,p_display_name IN VARCHAR2
1330 ,p_description IN VARCHAR2
1331 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1332 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1333 ,x_return_status OUT NOCOPY VARCHAR2
1334 ,x_errorcode OUT NOCOPY NUMBER
1335 ,x_msg_count OUT NOCOPY NUMBER
1336 ,x_msg_data OUT NOCOPY VARCHAR2
1337 );
1338
1339 PROCEDURE Delete_Function (
1340 p_api_version IN NUMBER
1341 ,p_function_id IN NUMBER
1342 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1343 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1344 ,x_return_status OUT NOCOPY VARCHAR2
1345 ,x_errorcode OUT NOCOPY NUMBER
1346 ,x_msg_count OUT NOCOPY NUMBER
1347 ,x_msg_data OUT NOCOPY VARCHAR2
1348 );
1349
1350 ------------------------------------
1351 -- Action and Action Display APIs --
1352 ------------------------------------
1353
1354 -- signature to use if caller has ATTR_GROUP_ID
1355 PROCEDURE Create_Action (
1356 p_api_version IN NUMBER
1357 ,p_object_id IN NUMBER
1358 ,p_classification_code IN VARCHAR2
1359 ,p_attr_group_id IN NUMBER DEFAULT NULL
1360 ,p_sequence IN NUMBER
1361 ,p_action_name IN VARCHAR2
1362 ,p_description IN VARCHAR2
1363 ,p_function_id IN NUMBER
1364 ,p_enable_key_attrs IN VARCHAR2 DEFAULT NULL
1365 ,p_security_privilege_id IN NUMBER
1366 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1367 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1368 ,x_action_id OUT NOCOPY NUMBER
1369 ,x_return_status OUT NOCOPY VARCHAR2
1370 ,x_errorcode OUT NOCOPY NUMBER
1371 ,x_msg_count OUT NOCOPY NUMBER
1372 ,x_msg_data OUT NOCOPY VARCHAR2
1373 );
1374
1375 -- signature to use if caller doesn't have ATTR_GROUP_ID
1376 PROCEDURE Create_Action (
1377 p_api_version IN NUMBER
1378 ,p_object_id IN NUMBER
1379 ,p_classification_code IN VARCHAR2
1380 ,p_attr_grp_application_id IN NUMBER
1381 ,p_attr_group_type IN VARCHAR2
1382 ,p_attr_group_name IN VARCHAR2
1383 ,p_sequence IN NUMBER
1384 ,p_action_name IN VARCHAR2
1385 ,p_description IN VARCHAR2
1386 ,p_function_id IN NUMBER
1387 ,p_enable_key_attrs IN VARCHAR2 DEFAULT NULL
1388 ,p_security_privilege_id IN NUMBER
1389 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1390 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1391 ,x_action_id OUT NOCOPY NUMBER
1392 ,x_return_status OUT NOCOPY VARCHAR2
1393 ,x_errorcode OUT NOCOPY NUMBER
1394 ,x_msg_count OUT NOCOPY NUMBER
1395 ,x_msg_data OUT NOCOPY VARCHAR2
1396 );
1397
1398 PROCEDURE Update_Action (
1399 p_api_version IN NUMBER
1400 ,p_action_id IN NUMBER
1401 ,p_sequence IN NUMBER
1402 ,p_action_name IN VARCHAR2
1403 ,p_description IN VARCHAR2
1404 ,p_function_id IN NUMBER
1405 ,p_enable_key_attrs IN VARCHAR2 DEFAULT NULL
1406 ,p_security_privilege_id IN NUMBER
1407 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1408 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1409 ,x_return_status OUT NOCOPY VARCHAR2
1410 ,x_errorcode OUT NOCOPY NUMBER
1411 ,x_msg_count OUT NOCOPY NUMBER
1412 ,x_msg_data OUT NOCOPY VARCHAR2
1413 );
1414
1415 PROCEDURE Delete_Action (
1416 p_api_version IN NUMBER
1417 ,p_action_id IN NUMBER
1418 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1419 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1420 ,x_return_status OUT NOCOPY VARCHAR2
1421 ,x_errorcode OUT NOCOPY NUMBER
1422 ,x_msg_count OUT NOCOPY NUMBER
1423 ,x_msg_data OUT NOCOPY VARCHAR2
1424 );
1425
1426 -- call this API to create an Action that is executed by a user action
1427 PROCEDURE Create_Action_Display (
1428 p_api_version IN NUMBER
1429 ,p_action_id IN NUMBER
1430 ,P_EXEC_CODE IN VARCHAR2 := 'U'
1431 ,p_display_style IN VARCHAR2
1432 ,p_prompt_application_id IN NUMBER
1433 ,p_prompt_message_name IN VARCHAR2
1434 ,p_visibility_flag IN VARCHAR2
1438 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1435 ,p_prompt_function_id IN NUMBER
1436 ,p_visibility_func_id IN NUMBER
1437 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1439 ,x_return_status OUT NOCOPY VARCHAR2
1440 ,x_errorcode OUT NOCOPY NUMBER
1441 ,x_msg_count OUT NOCOPY NUMBER
1442 ,x_msg_data OUT NOCOPY VARCHAR2
1443 );
1444
1445 -- call this API to create an Action that is executed by a trigger
1446 PROCEDURE Create_Action_Display (
1447 p_api_version IN NUMBER
1448 ,p_action_id IN NUMBER
1449 ,p_trigger_code IN VARCHAR2
1450 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1451 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1452 ,x_return_status OUT NOCOPY VARCHAR2
1453 ,x_errorcode OUT NOCOPY NUMBER
1454 ,x_msg_count OUT NOCOPY NUMBER
1455 ,x_msg_data OUT NOCOPY VARCHAR2
1456 );
1457
1458 -- call this API to update an Action that is executed by a user action
1459 PROCEDURE Update_Action_Display (
1460 p_api_version IN NUMBER
1461 ,p_action_id IN NUMBER
1462 ,P_EXEC_CODE IN VARCHAR2 := 'U'
1463 ,p_display_style IN VARCHAR2
1464 ,p_prompt_application_id IN NUMBER
1465 ,p_prompt_message_name IN VARCHAR2
1466 ,p_visibility_flag IN VARCHAR2
1467 ,p_prompt_function_id IN NUMBER
1468 ,p_visibility_func_id IN NUMBER
1469 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1470 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1471 ,x_return_status OUT NOCOPY VARCHAR2
1472 ,x_errorcode OUT NOCOPY NUMBER
1473 ,x_msg_count OUT NOCOPY NUMBER
1474 ,x_msg_data OUT NOCOPY VARCHAR2
1475 );
1476
1477 -- call this API to update an Action that is executed by a trigger
1478 PROCEDURE Update_Action_Display (
1479 p_api_version IN NUMBER
1480 ,p_action_id IN NUMBER
1481 ,p_trigger_code IN VARCHAR2
1482 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1483 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1484 ,x_return_status OUT NOCOPY VARCHAR2
1485 ,x_errorcode OUT NOCOPY NUMBER
1486 ,x_msg_count OUT NOCOPY NUMBER
1487 ,x_msg_data OUT NOCOPY VARCHAR2
1488 );
1489
1490 PROCEDURE Delete_Action_Display (
1491 p_api_version IN NUMBER
1492 ,p_action_id IN NUMBER
1493 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1494 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1495 ,x_return_status OUT NOCOPY VARCHAR2
1496 ,x_errorcode OUT NOCOPY NUMBER
1497 ,x_msg_count OUT NOCOPY NUMBER
1498 ,x_msg_data OUT NOCOPY VARCHAR2
1499 );
1500
1501 -----------------------------
1502 -- Function Parameter APIs --
1503 -----------------------------
1504
1505 PROCEDURE Create_Function_Param (
1506 p_api_version IN NUMBER
1507 ,p_function_id IN NUMBER
1508 ,p_sequence IN NUMBER
1509 ,p_internal_name IN VARCHAR2
1510 ,p_data_type IN VARCHAR2
1511 ,p_param_type IN VARCHAR2
1512 ,p_display_name IN VARCHAR2
1513 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1514 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1515 ,x_function_param_id OUT NOCOPY NUMBER
1516 ,x_return_status OUT NOCOPY VARCHAR2
1517 ,x_errorcode OUT NOCOPY NUMBER
1518 ,x_msg_count OUT NOCOPY NUMBER
1519 ,x_msg_data OUT NOCOPY VARCHAR2
1520 );
1521
1522 PROCEDURE Update_Function_Param (
1523 p_api_version IN NUMBER
1527 ,p_display_name IN VARCHAR2
1524 ,p_function_param_id IN NUMBER
1525 ,p_sequence IN NUMBER
1526 ,p_internal_name IN VARCHAR2
1528 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1529 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1530 ,x_return_status OUT NOCOPY VARCHAR2
1531 ,x_errorcode OUT NOCOPY NUMBER
1532 ,x_msg_count OUT NOCOPY NUMBER
1533 ,x_msg_data OUT NOCOPY VARCHAR2
1534 );
1535
1536 PROCEDURE Delete_Function_Param (
1537 p_api_version IN NUMBER
1538 ,p_function_param_id IN NUMBER
1539 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1540 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1541 ,x_return_status OUT NOCOPY VARCHAR2
1542 ,x_errorcode OUT NOCOPY NUMBER
1543 ,x_msg_count OUT NOCOPY NUMBER
1544 ,x_msg_data OUT NOCOPY VARCHAR2
1545 );
1546
1547 -------------------------
1548 -- Action Mapping APIs --
1549 -------------------------
1550
1551 PROCEDURE Create_Mapping (
1552 p_api_version IN NUMBER
1553 ,p_function_id IN NUMBER
1554 ,p_mapped_obj_type IN VARCHAR2
1555 ,p_mapped_obj_pk1_value IN VARCHAR2
1556 ,p_func_param_id IN NUMBER
1557 ,p_mapping_group_type IN VARCHAR2
1558 ,p_mapping_group_pk1 IN VARCHAR2
1559 ,p_mapping_group_pk2 IN VARCHAR2
1560 ,p_mapping_group_pk3 IN VARCHAR2
1561 ,p_mapping_value IN VARCHAR2
1562 ,p_mapped_uom_parameter IN VARCHAR2 := NULL
1563 ,p_value_uom_source IN VARCHAR2 := NULL
1564 ,p_fixed_uom IN VARCHAR2 := NULL
1565 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1566 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1567 ,x_return_status OUT NOCOPY VARCHAR2
1568 ,x_errorcode OUT NOCOPY NUMBER
1569 ,x_msg_count OUT NOCOPY NUMBER
1570 ,x_msg_data OUT NOCOPY VARCHAR2
1571 );
1572
1573
1574 PROCEDURE Create_Mapping (
1575 p_api_version IN NUMBER
1576 ,p_function_id IN NUMBER
1577 ,p_mapped_obj_type IN VARCHAR2
1578 ,p_mapped_obj_pk1_value IN VARCHAR2
1579 ,p_func_param_id IN NUMBER
1580 ,p_attr_group_id IN NUMBER
1581 ,p_mapping_value IN VARCHAR2
1582 ,p_mapped_uom_parameter IN VARCHAR2 := NULL
1583 ,p_value_uom_source IN VARCHAR2 := NULL
1584 ,p_fixed_uom IN VARCHAR2 := NULL
1585 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1586 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1587 ,x_return_status OUT NOCOPY VARCHAR2
1588 ,x_errorcode OUT NOCOPY NUMBER
1589 ,x_msg_count OUT NOCOPY NUMBER
1590 ,x_msg_data OUT NOCOPY VARCHAR2
1591 );
1592
1593
1594
1595 PROCEDURE Update_Mapping (
1596 p_api_version IN NUMBER
1597 ,p_function_id IN NUMBER
1598 ,p_mapped_obj_type IN VARCHAR2
1599 ,p_mapped_obj_pk1_value IN VARCHAR2
1600 ,p_func_param_id IN NUMBER
1601 ,p_mapping_group_type IN VARCHAR2
1602 ,p_mapping_group_pk1 IN VARCHAR2
1603 ,p_mapping_group_pk2 IN VARCHAR2
1604 ,p_mapping_group_pk3 IN VARCHAR2
1605 ,p_mapping_value IN VARCHAR2
1606 ,p_new_func_param_id IN NUMBER := NULL
1607 ,p_new_mapping_group_pk1 IN VARCHAR2 := NULL
1608 ,p_new_mapping_group_pk2 IN VARCHAR2 := NULL
1609 ,p_new_mapping_group_pk3 IN VARCHAR2 := NULL
1610 ,p_new_mapping_value IN VARCHAR2 := NULL
1611 ,p_mapped_uom_parameter IN VARCHAR2 := NULL
1612 ,p_value_uom_source IN VARCHAR2 := NULL
1613 ,p_fixed_uom IN VARCHAR2 := NULL
1614 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1615 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1616 ,x_return_status OUT NOCOPY VARCHAR2
1617 ,x_errorcode OUT NOCOPY NUMBER
1618 ,x_msg_count OUT NOCOPY NUMBER
1619 ,x_msg_data OUT NOCOPY VARCHAR2
1620 );
1621
1622
1623 PROCEDURE Update_Mapping (
1624 p_api_version IN NUMBER
1625 ,p_function_id IN NUMBER
1626 ,p_mapped_obj_type IN VARCHAR2
1627 ,p_mapped_obj_pk1_value IN VARCHAR2
1628 ,p_func_param_id IN NUMBER
1629 ,p_attr_group_id IN NUMBER
1630 ,p_mapping_value IN VARCHAR2
1631 ,p_mapping_group_pk1 IN VARCHAR2 := NULL
1632 ,p_mapping_group_pk2 IN VARCHAR2 := NULL
1633 ,p_mapping_group_pk3 IN VARCHAR2 := NULL
1634 ,p_new_func_param_id IN NUMBER := NULL
1635 ,p_new_mapping_value IN VARCHAR2 := NULL
1639 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1636 ,p_mapped_uom_parameter IN VARCHAR2 := NULL
1637 ,p_value_uom_source IN VARCHAR2 := NULL
1638 ,p_fixed_uom IN VARCHAR2 := NULL
1640 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1641 ,x_return_status OUT NOCOPY VARCHAR2
1642 ,x_errorcode OUT NOCOPY NUMBER
1643 ,x_msg_count OUT NOCOPY NUMBER
1644 ,x_msg_data OUT NOCOPY VARCHAR2
1645 );
1646
1647
1648 -- call this API to delete all mappings for a given action and function
1649 PROCEDURE Delete_Func_Mapping (
1650 p_api_version IN NUMBER
1651 ,p_function_id IN NUMBER
1652 ,p_mapped_obj_type IN VARCHAR2
1653 ,p_mapped_obj_pk1_value IN VARCHAR2
1654 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1655 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1656 ,x_return_status OUT NOCOPY VARCHAR2
1657 ,x_errorcode OUT NOCOPY NUMBER
1658 ,x_msg_count OUT NOCOPY NUMBER
1659 ,x_msg_data OUT NOCOPY VARCHAR2
1660 );
1661
1662 -- call this API to delete an individual parameter mapping
1663 PROCEDURE Delete_Func_Param_Mapping (
1664 p_api_version IN NUMBER
1665 ,p_function_id IN NUMBER
1666 ,p_mapped_obj_type IN VARCHAR2
1667 ,p_mapped_obj_pk1_value IN VARCHAR2
1668 ,p_func_param_id IN NUMBER
1669 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1670 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1671 ,x_return_status OUT NOCOPY VARCHAR2
1672 ,x_errorcode OUT NOCOPY NUMBER
1673 ,x_msg_count OUT NOCOPY NUMBER
1674 ,x_msg_data OUT NOCOPY VARCHAR2
1675 );
1676
1677 -----------------------
1678 -- Action Group APIs --
1679 -----------------------
1680
1681 PROCEDURE Create_Action_Group (
1682 p_api_version IN NUMBER
1683 ,p_object_id IN NUMBER
1684 ,p_classification_code IN VARCHAR2
1685 ,p_sequence IN NUMBER
1686 ,p_internal_name IN VARCHAR2
1687 ,p_display_name IN VARCHAR2
1688 ,p_description IN VARCHAR2
1689 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1690 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1691 ,x_action_group_id OUT NOCOPY NUMBER
1692 ,x_return_status OUT NOCOPY VARCHAR2
1693 ,x_errorcode OUT NOCOPY NUMBER
1694 ,x_msg_count OUT NOCOPY NUMBER
1695 ,x_msg_data OUT NOCOPY VARCHAR2
1696 );
1697
1698 PROCEDURE Update_Action_Group (
1699 p_api_version IN NUMBER
1700 ,p_action_group_id IN NUMBER
1701 ,p_sequence IN NUMBER
1702 ,p_internal_name IN VARCHAR2
1703 ,p_display_name IN VARCHAR2
1704 ,p_description IN VARCHAR2
1705 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1706 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1707 ,x_return_status OUT NOCOPY VARCHAR2
1708 ,x_errorcode OUT NOCOPY NUMBER
1709 ,x_msg_count OUT NOCOPY NUMBER
1710 ,x_msg_data OUT NOCOPY VARCHAR2
1711 );
1712
1713 PROCEDURE Delete_Action_Group (
1714 p_api_version IN NUMBER
1715 ,p_action_group_id IN NUMBER
1716 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1717 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1718 ,x_return_status OUT NOCOPY VARCHAR2
1719 ,x_errorcode OUT NOCOPY NUMBER
1720 ,x_msg_count OUT NOCOPY NUMBER
1721 ,x_msg_data OUT NOCOPY VARCHAR2
1722 );
1723
1724 -----------------------------
1725 -- Action Group Entry APIs --
1726 -----------------------------
1727
1728 PROCEDURE Create_Action_Group_Entry (
1729 p_api_version IN NUMBER
1730 ,p_action_group_id IN NUMBER
1731 ,p_action_id IN NUMBER
1732 ,p_sequence IN NUMBER
1733 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1734 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1735 ,x_return_status OUT NOCOPY VARCHAR2
1736 ,x_errorcode OUT NOCOPY NUMBER
1737 ,x_msg_count OUT NOCOPY NUMBER
1738 ,x_msg_data OUT NOCOPY VARCHAR2
1739 );
1740
1741 PROCEDURE Update_Action_Group_Entry (
1742 p_api_version IN NUMBER
1743 ,p_action_group_id IN NUMBER
1744 ,p_action_id IN NUMBER
1745 ,p_sequence IN NUMBER
1746 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1747 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1748 ,x_return_status OUT NOCOPY VARCHAR2
1752 );
1749 ,x_errorcode OUT NOCOPY NUMBER
1750 ,x_msg_count OUT NOCOPY NUMBER
1751 ,x_msg_data OUT NOCOPY VARCHAR2
1753
1754 PROCEDURE Delete_Action_Group_Entry (
1755 p_api_version IN NUMBER
1756 ,p_action_group_id IN NUMBER
1757 ,p_action_id IN NUMBER
1758 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1759 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1760 ,x_return_status OUT NOCOPY VARCHAR2
1761 ,x_errorcode OUT NOCOPY NUMBER
1762 ,x_msg_count OUT NOCOPY NUMBER
1763 ,x_msg_data OUT NOCOPY VARCHAR2
1764 );
1765
1766
1767 PROCEDURE ADD_LANGUAGE (
1768 p_tl_table_name IN VARCHAR2
1769 );
1770
1771
1772 FUNCTION Return_Association_Existance (
1773 p_application_id IN NUMBER
1774 ,p_attr_group_type IN VARCHAR2
1775 ,p_attr_group_name IN VARCHAR2
1776 ) return VARCHAR2;
1777
1778 PROCEDURE Update_AGV_Name(
1779 P_API_VERSION IN NUMBER
1780 ,P_APPLICATION_ID IN NUMBER
1781 ,P_ATTR_GROUP_TYPE IN VARCHAR2
1782 ,P_ATTR_GROUP_NAME IN VARCHAR2
1783 ,P_AGV_NAME IN VARCHAR2
1784 ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1785 ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1786 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
1787 ,X_ERRORCODE OUT NOCOPY NUMBER
1788 ,X_MSG_COUNT OUT NOCOPY NUMBER
1789 ,X_MSG_DATA OUT NOCOPY VARCHAR2
1790 );
1791
1792 PROCEDURE Update_Attribute_Control_Level (
1793 p_api_version IN NUMBER
1794 ,p_application_id IN NUMBER
1795 ,p_descriptive_flexfield_name IN VARCHAR2
1796 ,p_application_column_name IN VARCHAR2
1797 ,p_control_level IN NUMBER
1798 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1799 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1800 ,x_return_status OUT NOCOPY VARCHAR2
1801 ,x_msg_count OUT NOCOPY NUMBER
1802 ,x_msg_data OUT NOCOPY VARCHAR2
1803 );
1804
1805
1806 FUNCTION Convert_Class_Code_To_Name (
1807 p_object_name IN VARCHAR2
1808 ,p_class_code IN VARCHAR2
1809 ) RETURN VARCHAR2;
1810
1811
1812 FUNCTION Convert_Name_To_Class_Code (
1813 p_object_name IN VARCHAR2
1814 ,p_class_name IN VARCHAR2
1815 ) RETURN VARCHAR2;
1816
1817
1818
1819 PROCEDURE Sync_Up_Attr_Metadata (
1820 p_source_ag_name IN VARCHAR2,
1821 p_source_ag_type IN VARCHAR2,
1822 p_source_appl_id IN VARCHAR2,
1823 p_target_ag_name IN VARCHAR2,
1824 p_target_ag_type IN VARCHAR2,
1825 p_target_appl_id IN VARCHAR2,
1826 x_return_status OUT NOCOPY VARCHAR2,
1827 x_errorcode OUT NOCOPY VARCHAR2,
1828 x_msg_count OUT NOCOPY NUMBER,
1829 x_msg_data OUT NOCOPY VARCHAR2
1830 );
1831 --R12C
1832 PROCEDURE Create_Action_Data_Level (
1833 p_api_version IN NUMBER
1834 ,p_action_id IN NUMBER
1835 ,p_data_level_id IN NUMBER
1836 ,p_visibility_flag IN VARCHAR2 DEFAULT 'Y'
1837 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1838 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1839 ,x_return_status OUT NOCOPY VARCHAR2
1840 ,x_errorcode OUT NOCOPY NUMBER
1841 ,x_msg_count OUT NOCOPY NUMBER
1842 ,x_msg_data OUT NOCOPY VARCHAR2
1843 );
1844 PROCEDURE Delete_Action_Data_Level (
1845 p_api_version IN NUMBER
1846 ,p_action_id IN NUMBER
1847 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1848 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1849 ,x_return_status OUT NOCOPY VARCHAR2
1850 ,x_errorcode OUT NOCOPY NUMBER
1851 ,x_msg_count OUT NOCOPY NUMBER
1852 ,x_msg_data OUT NOCOPY VARCHAR2
1853 );
1854
1855 FUNCTION Concat_Data_Level_DisplayNames (p_attr_grp_id IN NUMBER)
1856 RETURN VARCHAR2;
1857
1858 FUNCTION Get_Association_Id_From_PKs (
1859 p_object_id IN NUMBER
1860 ,p_classification_code IN VARCHAR2
1861 ,p_attr_group_id IN NUMBER
1862 ) RETURN NUMBER;
1863
1864 /*
1865 * This Procedure is for invocation of User-Defined Functions from pl/sql side.
1866 * Currently ONLY type of PL/SQL user-defined function is supported.
1867 * @param p_ActionId, Indicates the Action Id to which the User-defined Function associated.
1868 * @param p_pk_col_value_pairs, Contains the Primary Key column names and
1869 * values that identify the specific source object instance whose data is to be processed.
1870 * @param p_dtlevel_col_value_pairs, If the attribute group type has data
1871 * levels defined and the source object instance contains any attribute
1872 * groups that are associated at a data level other than the highest level
1876 * data level column names and values up to and including those for the
1873 * defined for the attribute group type (e.g., if the attribute group type
1874 * is 'EGO_ITEMMGMT_GROUP' and the EGO_ITEM has at least one attribute
1875 * group associated at the ITEM_REVISION_LEVEL), then this will contain
1877 * lowest data level at which any attribute group is associated.
1878 * @param x_attributes_row_table, Contains row-level data and metadata about
1879 * each attribute group whose data is being returned.
1880 * @param x_attributes_data_table, Contains data and metadata about each attribute
1881 * whose data is being returned.
1882 * @param p_external_attrs_value_pairs, Since we can map any Attributes to
1883 * User-defined Function parameters, this param store
1884 * the External Attributes(different to AG in p_attributes_row_table) names and values pair.
1885 * @param x_return_status Returns one of three values indicating the
1886 * most serious error encountered during processing:
1887 * FND_API.G_RET_STS_SUCCESS if no errors occurred,
1888 * FND_API.G_RET_STS_ERROR if at least one error occurred, and
1889 * FND_API.G_RET_STS_UNEXP_ERROR if at least one unexpected error occurred.
1890 * @param x_errorcode Reserved for future use.
1891 * @param x_msg_count Indicates how many messages exist on ERROR_HANDLER
1892 * message stack upon completion of processing.
1893 * @param x_msg_data If exactly one message exists on ERROR_HANDLER
1894 * message stack upon completion of processing, then this parameter
1895 * contains that message.
1896 */
1897 PROCEDURE Execute_Function(
1898 p_Action_Id IN Number
1899 ,p_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1900 ,p_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1901 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
1902 ,x_attributes_data_table IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1903 ,x_external_attrs_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
1904 ,x_return_status OUT NOCOPY VARCHAR2
1905 ,x_errorcode OUT NOCOPY NUMBER
1906 ,x_msg_count OUT NOCOPY NUMBER
1907 ,x_msg_data OUT NOCOPY VARCHAR2
1908 );
1909
1910 ------------------------------------------------------------
1911 --Bug Fix : 10103483 API for deleting Attribute Group View--
1912 ------------------------------------------------------------
1913 PROCEDURE Delete_Attr_Group_Views(p_view_name IN VARCHAR2) ;
1914
1915
1916 ------------------------------------------------------------------------------------------
1917 --Bug 10097736
1918 -- Method :Method to Check for view is present or not,
1919 -- if not present update agv_name in EGO_FND_DSC_FLX_CTX_EXT with null
1920 -- parameter : Attribute Groups Id
1921 ------------------------------------------------------------------------------------------
1922
1923 PROCEDURE Check_Attr_Group_View(p_attr_grp_id IN NUMBER);
1924
1925 END EGO_EXT_FWK_PUB;