1 PACKAGE EGO_EXT_FWK_PUB AUTHID DEFINER AS
2 /* $Header: EGOPEFMS.pls 120.13 2007/07/05 23:04:15 ssarnoba 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 ------------------------
56 -- Miscellaneous APIs --
57 ------------------------
58
59 -- signature to use if caller has ATTR_GROUP_ID
60 FUNCTION Get_Privilege_For_Attr_Group (
61 p_attr_group_id IN NUMBER
62 ,p_which_priv_to_return IN VARCHAR2
63 )
64 RETURN VARCHAR2;
65
66 -- signature to use if caller doesn't have ATTR_GROUP_ID
67 FUNCTION Get_Privilege_For_Attr_Group (
68 p_application_id IN NUMBER
69 ,p_attr_group_type IN VARCHAR2
70 ,p_attr_group_name IN VARCHAR2
71 ,p_which_priv_to_return IN VARCHAR2
72 )
73 RETURN VARCHAR2;
74
75 FUNCTION Is_Column_Indexed (
76 p_column_name IN VARCHAR2
77 ,p_table_name IN VARCHAR2
78 ,p_application_id IN NUMBER DEFAULT NULL
79 ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
80 )
81 RETURN VARCHAR2;
82
83 FUNCTION Get_Attr_Group_Id_From_PKs (
84 p_application_id IN NUMBER
85 ,p_attr_group_type IN VARCHAR2
86 ,p_attr_group_name IN VARCHAR2
87 )
88 RETURN NUMBER;
89
90 FUNCTION Does_Attr_Have_Data (
91 p_application_id IN NUMBER DEFAULT NULL
92 ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
93 ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
94 ,p_attr_name IN VARCHAR2 DEFAULT NULL
95 ,p_attr_id IN NUMBER DEFAULT NULL
96 )
97 RETURN VARCHAR2;
98
99 FUNCTION Get_Application_Owner (
100 p_appl_id IN NUMBER
101 )
102 RETURN VARCHAR2 ;
103
104 FUNCTION Get_Oracle_UserName
105 RETURN VARCHAR2 ;
106
107 FUNCTION Check_Supported_Attr_Usages (
108 p_support_api IN VARCHAR2
109 ,p_application_id IN NUMBER
110 ,p_attr_grp_type IN VARCHAR2
111 ,p_attr_grp_name IN VARCHAR2
112 ,p_attr_name IN VARCHAR2
113 ,p_data_level IN VARCHAR2
114 ,p_is_multi_row IN VARCHAR2
115 ,p_data_type IN VARCHAR2
116 )
117 RETURN VARCHAR2;
118
119
120
121
122 /*
123 NOTE: WE DON'T USE THESE ANYMORE, BUT WE'LL KEEP THEM JUST IN CASE
124
125 -- signature to use if caller has ATTR_GROUP_ID
126 PROCEDURE Get_Available_AttrDBCol (
127 p_api_version IN NUMBER
128 ,p_attr_group_id IN NUMBER
129 ,p_data_type IN VARCHAR2
130 ,x_database_column OUT NOCOPY VARCHAR2
131 );
132
133 -- signature to use if caller doesn't have ATTR_GROUP_ID
134 PROCEDURE Get_Available_AttrDBCol (
135 p_api_version IN NUMBER
136 ,p_application_id IN NUMBER
137 ,p_attr_group_type IN VARCHAR2
138 ,p_attr_group_name IN VARCHAR2
139 ,p_data_type IN VARCHAR2
140 ,x_database_column OUT NOCOPY VARCHAR2
141 );
142
143 -- signature to use if caller has ATTR_GROUP_ID
144 PROCEDURE Get_Available_AttrDBCols (
145 p_api_version IN NUMBER
146 ,p_attr_group_id IN NUMBER
147 ,p_data_type IN VARCHAR2
148 ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
149 );
150
151 -- signature to use if caller doesn't have ATTR_GROUP_ID
152 PROCEDURE Get_Available_AttrDBCols (
153 p_api_version IN NUMBER
154 ,p_application_id IN NUMBER
155 ,p_attr_group_type IN VARCHAR2
156 ,p_attr_group_name IN VARCHAR2
157 ,p_data_type IN VARCHAR2
158 ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
159 );
160 */
161 ------------------------------------------------------------------------------------------
162 -- Function: To return the pending transalatable table name for a given attribute group type
163 -- an the application id
164 -- If the table is not defined, NULL is returned
165 --
166 -- Parameters:
167 -- IN
168 -- p_attr_group_type: attribute_group_type
169 -- p_attr_group_type application_id
170 -- OUT
171 -- l_table_name : translatable table for attribute_changes
172 ------------------------------------------------------------------------------------------
173 FUNCTION Get_Attr_Changes_TL_Table (
174 p_application_id IN NUMBER
175 ,p_attr_group_type IN VARCHAR2
176 )
177 RETURN VARCHAR2;
178
179 ------------------------------------------------------------------------------------------
180 -- Function: To return the pending base table name for a given attribute group type
181 -- an the application id
182 -- If the table is not defined, NULL is returned
183 --
184 -- Parameters:
185 -- IN
186 -- p_attr_group_type: attribute_group_type
187 -- p_attr_group_type application_id
188 -- OUT
189 -- l_table_name : base table for attribute_changes
190 ------------------------------------------------------------------------------------------
191
192 FUNCTION Get_Attr_Changes_B_Table (
193 p_application_id IN NUMBER
194 ,p_attr_group_type IN VARCHAR2
195 )
196 RETURN VARCHAR2;
197
198 FUNCTION Get_Table_Name (
199 p_application_id IN NUMBER
200 ,p_attr_group_type IN VARCHAR2
201 )
202 RETURN VARCHAR2;
203
204 FUNCTION Get_TL_Table_Name (
205 p_application_id IN NUMBER
206 ,p_attr_group_type IN VARCHAR2
207 )
208 RETURN VARCHAR2;
209
210 FUNCTION Get_Object_Id_From_Name (
211 p_object_name IN VARCHAR2
212 )
213 RETURN NUMBER;
214
215 FUNCTION Get_Object_Id_For_AG_Type (
216 p_application_id IN NUMBER
217 ,p_attr_group_type IN VARCHAR2
218 ) RETURN NUMBER;
219
220 FUNCTION Get_Class_Meaning (
221 p_object_name IN VARCHAR2
222 ,p_class_code IN VARCHAR2
223 )
224 RETURN VARCHAR2;
225
226 FUNCTION Get_Class_Meaning (
227 p_object_id IN NUMBER
228 ,p_class_code IN VARCHAR2
229 )
230 RETURN VARCHAR2;
231
232 PROCEDURE Get_Pk_Columns (
233 p_api_version IN NUMBER
234 ,p_obj_name IN VARCHAR2
235 ,x_pkcolumn1_name OUT NOCOPY VARCHAR2
236 ,x_pkcolumn1_type OUT NOCOPY VARCHAR2
237 ,x_pkcolumn2_name OUT NOCOPY VARCHAR2
238 ,x_pkcolumn2_type OUT NOCOPY VARCHAR2
239 ,x_pkcolumn3_name OUT NOCOPY VARCHAR2
240 ,x_pkcolumn3_type OUT NOCOPY VARCHAR2
241 ,x_pkcolumn4_name OUT NOCOPY VARCHAR2
242 ,x_pkcolumn4_type OUT NOCOPY VARCHAR2
243 ,x_pkcolumn5_name OUT NOCOPY VARCHAR2
244 ,x_pkcolumn5_type OUT NOCOPY VARCHAR2
245 );
246
247 --
248 -- This API is used to get the attribute changes table
249 -- for a given attribute group type.
250 --
251 PROCEDURE Get_Attr_Changes_Table (
252 p_attr_group_type IN VARCHAR2
253 ,x_base_table OUT NOCOPY VARCHAR2
254 ,x_tl_table OUT NOCOPY VARCHAR2
255 );
256
257
258 --------------------------
259 -- Attribute Group APIs --
260 --------------------------
261
262 -- Wrapper for JSPs that aren't set up to take ATTR_GROUP_ID --
263 PROCEDURE Create_Attribute_Group (
264 p_api_version IN NUMBER
265 ,p_application_id IN NUMBER
266 ,p_attr_group_type IN VARCHAR2
267 ,p_internal_name IN VARCHAR2
268 ,p_display_name IN VARCHAR2
269 ,p_attr_group_desc IN VARCHAR2
270 ,p_security_type IN VARCHAR2
271 ,p_multi_row_attrib_group IN VARCHAR2
272 ,p_variant_attrib_group IN VARCHAR2
273 ,p_num_of_cols IN NUMBER DEFAULT NULL
274 ,p_num_of_rows IN NUMBER DEFAULT NULL
275 ,p_owning_company_id IN NUMBER
276 ,p_region_code IN VARCHAR2 DEFAULT NULL
277 ,p_view_privilege_id IN NUMBER DEFAULT NULL
278 ,p_edit_privilege_id IN NUMBER DEFAULT NULL
279 ,p_business_event_flag IN VARCHAR2 DEFAULT NULL
280 ,p_pre_business_event_flag IN VARCHAR2 DEFAULT NULL
281 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
282 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
283 ,x_return_status OUT NOCOPY VARCHAR2
284 ,x_errorcode OUT NOCOPY NUMBER
285 ,x_msg_count OUT NOCOPY NUMBER
286 ,x_msg_data OUT NOCOPY VARCHAR2
287 );
288
289 PROCEDURE Create_Attribute_Group (
290 p_api_version IN NUMBER
291 ,p_application_id IN NUMBER
292 ,p_attr_group_type IN VARCHAR2
293 ,p_internal_name IN VARCHAR2
294 ,p_display_name IN VARCHAR2
295 ,p_attr_group_desc IN VARCHAR2
296 ,p_security_type IN VARCHAR2
297 ,p_multi_row_attrib_group IN VARCHAR2
298 ,p_variant_attrib_group IN VARCHAR2
299 ,p_num_of_cols IN NUMBER DEFAULT NULL
300 ,p_num_of_rows IN NUMBER DEFAULT NULL
301 ,p_owning_company_id IN NUMBER
302 ,p_region_code IN VARCHAR2 DEFAULT NULL
303 ,p_view_privilege_id IN NUMBER DEFAULT NULL
304 ,p_edit_privilege_id IN NUMBER DEFAULT NULL
305 ,p_business_event_flag IN VARCHAR2 DEFAULT NULL
306 ,p_pre_business_event_flag IN VARCHAR2 DEFAULT NULL
307 ,p_owner IN NUMBER DEFAULT NULL
308 ,p_lud IN DATE DEFAULT SYSDATE
309 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
310 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
311 ,x_attr_group_id OUT NOCOPY NUMBER
312 ,x_return_status OUT NOCOPY VARCHAR2
313 ,x_errorcode OUT NOCOPY NUMBER
314 ,x_msg_count OUT NOCOPY NUMBER
315 ,x_msg_data OUT NOCOPY VARCHAR2
316 );
317
318 -- Wrapper for JSPs that aren't set up to take ATTR_GROUP_ID --
319 PROCEDURE Copy_Attribute_Group (
320 p_api_version IN NUMBER
321 ,p_source_ag_app_id IN NUMBER
322 ,p_source_ag_type IN VARCHAR2
323 ,p_source_ag_name IN VARCHAR2
324 ,p_dest_ag_app_id IN NUMBER
325 ,p_dest_ag_type IN VARCHAR2
326 ,p_dest_ag_name IN VARCHAR2
327 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
328 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
329 ,x_return_status OUT NOCOPY VARCHAR2
330 ,x_errorcode OUT NOCOPY NUMBER
331 ,x_msg_count OUT NOCOPY NUMBER
332 ,x_msg_data OUT NOCOPY VARCHAR2
333 );
334
335 -- Wrapper for OA to pass source ATTR_GROUP_ID instead of Application Id, AG Type and AG Name--
336 PROCEDURE Copy_Attribute_Group (
337 p_api_version IN NUMBER
338 ,p_source_attr_group_id IN NUMBER
339 ,p_dest_ag_app_id IN NUMBER
340 ,p_dest_ag_type IN VARCHAR2
341 ,p_dest_ag_name IN VARCHAR2
342 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
343 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
344 ,x_attr_group_id OUT NOCOPY NUMBER
345 ,x_return_status OUT NOCOPY VARCHAR2
346 ,x_errorcode OUT NOCOPY NUMBER
347 ,x_msg_count OUT NOCOPY NUMBER
348 ,x_msg_data OUT NOCOPY VARCHAR2
349 );
350
351
352 PROCEDURE Copy_Attribute_Group (
353 p_api_version IN NUMBER
354 ,p_source_ag_app_id IN NUMBER
355 ,p_source_ag_type IN VARCHAR2
356 ,p_source_ag_name IN VARCHAR2
357 ,p_dest_ag_app_id IN NUMBER
358 ,p_dest_ag_type IN VARCHAR2
359 ,p_dest_ag_name IN VARCHAR2
360 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
361 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
362 ,x_attr_group_id OUT NOCOPY NUMBER
363 ,x_return_status OUT NOCOPY VARCHAR2
364 ,x_errorcode OUT NOCOPY NUMBER
365 ,x_msg_count OUT NOCOPY NUMBER
369 -- signature to use if caller has ATTR_GROUP_ID
366 ,x_msg_data OUT NOCOPY VARCHAR2
367 );
368
370 PROCEDURE Update_Attribute_Group (
371 p_api_version IN NUMBER
372 ,p_attr_group_id IN NUMBER
373 ,p_display_name IN VARCHAR2
374 ,p_attr_group_desc IN VARCHAR2
375 ,p_security_type IN VARCHAR2
376 ,p_multi_row_attrib_group IN VARCHAR2
377 ,p_variant_attrib_group IN VARCHAR2
378 ,p_num_of_cols IN NUMBER DEFAULT NULL
379 ,p_num_of_rows IN NUMBER DEFAULT NULL
380 ,p_owning_company_id IN NUMBER
381 ,p_region_code IN VARCHAR2 DEFAULT NULL
382 ,p_view_privilege_id IN NUMBER DEFAULT NULL
383 ,p_edit_privilege_id IN NUMBER DEFAULT NULL
384 ,p_business_event_flag IN VARCHAR2 DEFAULT NULL
385 ,p_pre_business_event_flag IN VARCHAR2 DEFAULT NULL
386 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
387 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
388 ,x_return_status OUT NOCOPY VARCHAR2
389 ,x_errorcode OUT NOCOPY NUMBER
390 ,x_msg_count OUT NOCOPY NUMBER
391 ,x_msg_data OUT NOCOPY VARCHAR2
392 );
393
394 -- signature to use if caller doesn't have ATTR_GROUP_ID
395 PROCEDURE Update_Attribute_Group (
396 p_api_version IN NUMBER
397 ,p_application_id IN NUMBER
398 ,p_attr_group_type IN VARCHAR2
399 ,p_internal_name IN VARCHAR2
400 ,p_display_name IN VARCHAR2
401 ,p_attr_group_desc IN VARCHAR2
402 ,p_security_type IN VARCHAR2
403 ,p_multi_row_attrib_group IN VARCHAR2
404 ,p_variant_attrib_group IN VARCHAR2
405 ,p_num_of_cols IN NUMBER DEFAULT NULL
406 ,p_num_of_rows IN NUMBER DEFAULT NULL
407 ,p_owning_company_id IN NUMBER
408 ,p_region_code IN VARCHAR2 DEFAULT NULL
409 ,p_view_privilege_id IN NUMBER DEFAULT NULL
410 ,p_edit_privilege_id IN NUMBER DEFAULT NULL
411 ,p_business_event_flag IN VARCHAR2 DEFAULT NULL
412 ,p_pre_business_event_flag IN VARCHAR2 DEFAULT NULL
413 ,p_owner IN NUMBER DEFAULT NULL
414 ,p_lud IN DATE DEFAULT SYSDATE
415 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
416 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
417 ,p_is_nls_mode IN VARCHAR2 DEFAULT FND_API.G_FALSE
418 ,x_return_status OUT NOCOPY VARCHAR2
419 ,x_errorcode OUT NOCOPY NUMBER
420 ,x_msg_count OUT NOCOPY NUMBER
421 ,x_msg_data OUT NOCOPY VARCHAR2
422 );
423
424 -- signature to use if caller has ATTR_GROUP_ID
425 PROCEDURE Delete_Attribute_Group (
426 p_api_version IN NUMBER
427 ,p_attr_group_id IN NUMBER
428 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
429 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
430 ,x_return_status OUT NOCOPY VARCHAR2
431 ,x_errorcode OUT NOCOPY NUMBER
432 ,x_msg_count OUT NOCOPY NUMBER
433 ,x_msg_data OUT NOCOPY VARCHAR2
434 );
435
436 -- signature to use if caller doesn't have ATTR_GROUP_ID
437 PROCEDURE Delete_Attribute_Group (
438 p_api_version IN NUMBER
439 ,p_application_id IN NUMBER
440 ,p_attr_group_type IN VARCHAR2
441 ,p_attr_group_name IN VARCHAR2
442 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
443 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
444 ,x_return_status OUT NOCOPY VARCHAR2
445 ,x_errorcode OUT NOCOPY NUMBER
446 ,x_msg_count OUT NOCOPY NUMBER
447 ,x_msg_data OUT NOCOPY VARCHAR2
448 );
449
450 PROCEDURE Compile_Attr_Group_Views (
451 ERRBUF OUT NOCOPY VARCHAR2
452 ,RETCODE OUT NOCOPY VARCHAR2
453 ,p_attr_group_id_list IN VARCHAR2
454 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
455 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
456 );
457
458 PROCEDURE Validate_Unique_Key_Attrs (
459 p_application_id IN NUMBER
460 ,p_attr_group_type IN VARCHAR2
461 ,p_attr_group_name IN VARCHAR2
462 ,p_id_list IN VARCHAR2
463 ,x_is_valid_key OUT NOCOPY VARCHAR2
464 );
465
466 ---------------------
467 -- Data Level APIs --
468 ---------------------
469
473 ,p_commit IN VARCHAR2
470 PROCEDURE Sync_Data_Level (
471 p_api_version IN NUMBER
472 ,p_init_msg_list IN VARCHAR2
474 ,p_transaction_type IN VARCHAR2
475 ,p_application_id IN NUMBER
476 ,p_attr_group_type IN VARCHAR2
477 ,p_data_level_name IN VARCHAR2
478 ,p_user_data_level_name IN VARCHAR2
479 ,p_pk1_column_name IN VARCHAR2
480 ,p_pk1_column_type IN VARCHAR2
481 ,p_pk2_column_name IN VARCHAR2
482 ,p_pk2_column_type IN VARCHAR2
483 ,p_pk3_column_name IN VARCHAR2
484 ,p_pk3_column_type IN VARCHAR2
485 ,p_pk4_column_name IN VARCHAR2
486 ,p_pk4_column_type IN VARCHAR2
487 ,p_pk5_column_name IN VARCHAR2
488 ,p_pk5_column_type IN VARCHAR2
489 ,p_enable_defaulting IN VARCHAR2
490 ,p_enable_view_priv IN VARCHAR2
491 ,p_enable_edit_priv IN VARCHAR2
492 ,p_enable_pre_event IN VARCHAR2
493 ,p_enable_post_event IN VARCHAR2
494 ,p_last_updated_by IN VARCHAR2
495 ,p_last_update_date IN DATE
496 ,p_is_nls_mode IN VARCHAR2
497 ,x_data_level_id IN OUT NOCOPY NUMBER
498 ,x_return_status OUT NOCOPY VARCHAR2
499 ,x_msg_count OUT NOCOPY NUMBER
500 ,x_msg_data OUT NOCOPY VARCHAR2
501 );
502
503 ---------------------------------
504 -- Data Level Association APIs --
505 ---------------------------------
506 PROCEDURE Sync_dl_assoc (
507 p_api_version IN NUMBER
508 ,p_init_msg_list IN VARCHAR2
509 ,p_commit IN VARCHAR2
510 ,p_transaction_type IN VARCHAR2
511 ,p_attr_group_id IN NUMBER
512 ,p_application_id IN NUMBER
513 ,p_attr_group_type IN VARCHAR2
514 ,p_attr_group_name IN VARCHAR2
515 ,p_data_level_id IN NUMBER
516 ,p_data_level_name IN VARCHAR2
517 ,p_defaulting IN VARCHAR2
518 ,p_defaulting_name IN VARCHAR2
519 ,p_view_priv_id IN NUMBER
520 ,p_view_priv_name IN VARCHAR2
521 ,p_user_view_priv_name IN VARCHAR2
522 ,p_edit_priv_id IN NUMBER
523 ,p_edit_priv_name IN VARCHAR2
524 ,p_user_edit_priv_name IN VARCHAR2
525 ,p_raise_pre_event IN VARCHAR2
526 ,p_raise_post_event IN VARCHAR2
527 ,p_last_updated_by IN VARCHAR2
528 ,p_last_update_date IN DATE
529 ,x_return_status OUT NOCOPY VARCHAR2
530 ,x_msg_count OUT NOCOPY NUMBER
531 ,x_msg_data OUT NOCOPY VARCHAR2
532 );
533
534 --------------------
535 -- Attribute APIs --
536 --------------------
537
538 PROCEDURE Create_Attribute (
539 p_api_version IN NUMBER
540 ,p_application_id IN NUMBER
541 ,p_attr_group_type IN VARCHAR2
542 ,p_attr_group_name IN VARCHAR2
543 ,p_internal_name IN VARCHAR2
544 ,p_display_name IN VARCHAR2
545 ,p_description IN VARCHAR2
546 ,p_sequence IN NUMBER
547 ,p_data_type IN VARCHAR2
548 ,p_required IN VARCHAR2
549 ,p_searchable IN VARCHAR2
550 ,p_column IN VARCHAR2
551 ,p_is_column_indexed IN VARCHAR2
552 ,p_value_set_id IN NUMBER
553 ,p_info_1 IN VARCHAR2 DEFAULT NULL
554 ,p_default_value IN VARCHAR2
555 ,p_unique_key_flag IN VARCHAR2
556 ,p_enabled IN VARCHAR2
557 ,p_display IN VARCHAR2
558 ,p_uom_class IN VARCHAR2
559 ,p_control_level IN NUMBER DEFAULT 1 --JDEJESU: NULL for 11.5.10E
560 ,p_attribute_code IN VARCHAR2 DEFAULT NULL
561 ,p_view_in_hierarchy_code IN VARCHAR2 DEFAULT 'A'
562 ,p_edit_in_hierarchy_code IN VARCHAR2 DEFAULT 'A'
563 ,p_customization_level IN VARCHAR2 DEFAULT 'A'
564 ,p_owner IN NUMBER DEFAULT NULL
565 ,p_lud IN DATE DEFAULT SYSDATE
566 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
567 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
568 ,x_return_status OUT NOCOPY VARCHAR2
569 ,x_errorcode OUT NOCOPY NUMBER
570 ,x_msg_count OUT NOCOPY NUMBER
571 ,x_msg_data OUT NOCOPY VARCHAR2
572 );
573
574 PROCEDURE Update_Attribute (
575 p_api_version IN NUMBER
576 ,p_application_id IN NUMBER
577 ,p_attr_group_type IN VARCHAR2
578 ,p_attr_group_name IN VARCHAR2
582 ,p_sequence IN NUMBER
579 ,p_internal_name IN VARCHAR2
580 ,p_display_name IN VARCHAR2
581 ,p_description IN VARCHAR2
583 ,p_required IN VARCHAR2
584 ,p_searchable IN VARCHAR2
585 ,p_column IN VARCHAR2
586 ,p_value_set_id IN NUMBER DEFAULT G_MISS_NUM
587 ,p_info_1 IN VARCHAR2 DEFAULT NULL
588 ,p_default_value IN VARCHAR2
589 ,p_unique_key_flag IN VARCHAR2 DEFAULT NULL
590 ,p_enabled IN VARCHAR2
591 ,p_display IN VARCHAR2
592 ,p_control_level IN NUMBER DEFAULT -1
593 ,p_attribute_code IN VARCHAR2 DEFAULT G_MISS_CHAR
594 ,p_view_in_hierarchy_code IN VARCHAR2 DEFAULT G_MISS_CHAR
595 ,p_edit_in_hierarchy_code IN VARCHAR2 DEFAULT G_MISS_CHAR
596 ,p_customization_level IN VARCHAR2 DEFAULT G_MISS_CHAR
597 ,p_owner IN NUMBER DEFAULT NULL
598 ,p_lud IN DATE DEFAULT SYSDATE
599 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
600 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
601 ,p_is_nls_mode IN VARCHAR2 DEFAULT FND_API.G_FALSE
602 ,p_uom_class IN VARCHAR2 DEFAULT G_MISS_CHAR
603 ,x_return_status OUT NOCOPY VARCHAR2
604 ,x_errorcode OUT NOCOPY NUMBER
605 ,x_msg_count OUT NOCOPY NUMBER
606 ,x_msg_data OUT NOCOPY VARCHAR2
607 );
608
609 PROCEDURE Delete_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_attr_name IN VARCHAR2
615 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
616 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
617 ,x_return_status OUT NOCOPY VARCHAR2
618 ,x_errorcode OUT NOCOPY NUMBER
619 ,x_msg_count OUT NOCOPY NUMBER
620 ,x_msg_data OUT NOCOPY VARCHAR2
621 );
622
623 --------------------
624 -- Value Set APIs --
625 --------------------
626
627 -- signature to use if caller wants to specify OWNER
628 PROCEDURE Create_Value_Set (
629 p_api_version IN NUMBER
630 -- ,p_application_id IN NUMBER
631 ,p_value_set_name IN VARCHAR2
632 ,p_description IN VARCHAR2
633 ,p_format_code IN VARCHAR2
634 ,p_maximum_size IN NUMBER DEFAULT 0
635 ,p_maximum_value IN VARCHAR2
636 ,p_minimum_value IN VARCHAR2
637 ,p_long_list_flag IN VARCHAR2
638 ,p_validation_code IN VARCHAR2
639 ,p_owner IN NUMBER DEFAULT NULL
640 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
641 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
642 ,x_value_set_id OUT NOCOPY NUMBER
643 ,x_return_status OUT NOCOPY VARCHAR2
644 ,x_msg_count OUT NOCOPY NUMBER
645 ,x_msg_data OUT NOCOPY VARCHAR2
646 );
647
648
649 PROCEDURE Create_Child_Value_Set (
650 p_api_version IN NUMBER := 1.0
651 ,p_value_set_name IN VARCHAR2 -- Child Value Set Name
652 ,p_description IN VARCHAR2
653 ,p_parent_vs_id IN NUMBER
654 ,p_owner IN NUMBER
655 ,child_vs_value_ids IN EGO_VALUE_SET_VALUE_IDS := NULL
656 -- collection of value set value IDS
657 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
658 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
659 ,x_child_vs_id OUT NOCOPY NUMBER -- child value set ID
660 ,x_return_status OUT NOCOPY VARCHAR2
661 ,x_msg_count OUT NOCOPY NUMBER
662 ,x_msg_data OUT NOCOPY VARCHAR2
663 );
664
665 PROCEDURE Delete_Child_Value_Set (
666 p_api_version IN NUMBER
667 ,p_application_id IN NUMBER
668 ,p_child_vs_id IN NUMBER
669 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
670 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
671 ,x_return_status OUT NOCOPY VARCHAR2
672 ,x_errorcode OUT NOCOPY NUMBER
673 ,x_msg_count OUT NOCOPY NUMBER
674 ,x_msg_data OUT NOCOPY VARCHAR2
675 );
676
677 PROCEDURE Update_Child_Value_Set (
678 p_api_version IN NUMBER
679 ,p_value_set_id IN NUMBER
683 -- ,p_maximum_value IN VARCHAR2
680 ,p_description IN VARCHAR2
681 ,p_format_code IN VARCHAR2
682 -- ,p_maximum_size IN NUMBER
684 -- ,p_minimum_value IN VARCHAR2
685 -- ,p_long_list_flag IN VARCHAR2
686 -- ,p_validation_code IN VARCHAR2
687 ,p_owner IN NUMBER DEFAULT NULL
688 ,child_vs_value_ids IN EGO_VALUE_SET_VALUE_IDS
689 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
690 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
691 ,x_return_status OUT NOCOPY VARCHAR2
692 ,x_msg_count OUT NOCOPY NUMBER
693 ,x_msg_data OUT NOCOPY VARCHAR2
694 );
695
696 -- signature to use if caller wants to specify OWNER
697 PROCEDURE Update_Value_Set (
698 p_api_version IN NUMBER
699 ,p_value_set_id IN NUMBER
700 ,p_description IN VARCHAR2
701 ,p_format_code IN VARCHAR2
702 ,p_maximum_size IN NUMBER
703 ,p_maximum_value IN VARCHAR2
704 ,p_minimum_value IN VARCHAR2
705 ,p_long_list_flag IN FND_FLEX_VALUE_SETS.LONGLIST_FLAG%TYPE
706 -- VARCHAR2
707 ,p_validation_code IN VARCHAR2
708 ,p_owner IN NUMBER DEFAULT NULL
709 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
710 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
711 ,x_return_status OUT NOCOPY VARCHAR2
712 -- ,x_errorcode OUT NOCOPY NUMBER
713 ,x_msg_count OUT NOCOPY NUMBER
714 ,x_msg_data OUT NOCOPY VARCHAR2
715 );
716
717 PROCEDURE Insert_Value_Set_Table_Inf (
718 p_api_version IN NUMBER
719 ,p_value_set_id IN NUMBER
720 ,p_table_application_id IN NUMBER
721 ,p_table_name IN VARCHAR2
722 ,p_value_column_name IN VARCHAR2
723 ,p_value_column_type IN VARCHAR2
724 ,p_value_column_size IN NUMBER
725 ,p_meaning_column_name IN VARCHAR2
726 ,p_meaning_column_type IN VARCHAR2
727 ,p_meaning_column_size IN NUMBER
728 ,p_id_column_name IN VARCHAR2
729 ,p_id_column_type IN VARCHAR2
730 ,p_id_column_size IN NUMBER
731 ,p_where_order_by IN VARCHAR2
732 ,p_additional_columns IN VARCHAR2
733 ,p_owner IN NUMBER DEFAULT NULL
734 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
735 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
736 ,x_return_status OUT NOCOPY VARCHAR2
737 ,x_msg_count OUT NOCOPY NUMBER
738 ,x_msg_data OUT NOCOPY VARCHAR2
739 );
740
741 PROCEDURE Update_Value_Set_Table_Inf (
742 p_api_version IN NUMBER
743 ,p_value_set_id IN NUMBER
744 ,p_table_application_id IN NUMBER
745 ,p_table_name IN VARCHAR2
746 ,p_value_column_name IN VARCHAR2
747 ,p_value_column_type IN VARCHAR2
748 ,p_value_column_size IN NUMBER
749 ,p_meaning_column_name IN VARCHAR2
750 ,p_meaning_column_type IN VARCHAR2
751 ,p_meaning_column_size IN NUMBER
752 ,p_id_column_name IN VARCHAR2
753 ,p_id_column_type IN VARCHAR2
754 ,p_id_column_size IN NUMBER
755 ,p_where_order_by IN VARCHAR2
756 ,p_additional_columns IN VARCHAR2
757 ,p_owner IN NUMBER DEFAULT NULL
758 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
759 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
760 ,x_return_status OUT NOCOPY VARCHAR2
761 ,x_msg_count OUT NOCOPY NUMBER
762 ,x_msg_data OUT NOCOPY VARCHAR2
763 );
764
765 FUNCTION has_flex_binding (cp_value_set_id IN NUMBER)
766 RETURN VARCHAR2;
767
768 FUNCTION is_vs_editable (cp_value_set_id IN NUMBER)
769 RETURN VARCHAR2;
770
771 --------------------------
772 -- Value Set Value APIs --
773 --------------------------
774
775 PROCEDURE Create_Value_Set_Val (
776 p_api_version IN NUMBER
777 ,p_value_set_name IN VARCHAR2
778 ,p_internal_name IN VARCHAR2
779 ,p_display_name IN VARCHAR2
780 ,p_description IN VARCHAR2
781 ,p_sequence IN NUMBER
782 ,p_start_date IN DATE
783 ,p_end_date IN DATE
784 ,p_enabled IN VARCHAR2
788 ,x_return_status OUT NOCOPY VARCHAR2
785 ,p_owner IN NUMBER DEFAULT NULL
786 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
787 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
789 ,x_msg_count OUT NOCOPY NUMBER
790 ,x_msg_data OUT NOCOPY VARCHAR2
791 );
792
793 PROCEDURE Update_Value_Set_Val (
794 p_api_version IN NUMBER
795 ,p_value_set_name IN VARCHAR2
796 ,p_internal_name IN VARCHAR2
797 ,p_display_name IN VARCHAR2
798 ,p_description IN VARCHAR2
799 ,p_sequence IN NUMBER
800 ,p_start_date IN DATE
801 ,p_end_date IN DATE
802 ,p_enabled IN VARCHAR2
803 ,p_owner IN NUMBER DEFAULT NULL
804 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
805 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
806 ,x_return_status OUT NOCOPY VARCHAR2
807 ,x_msg_count OUT NOCOPY NUMBER
808 ,x_msg_data OUT NOCOPY VARCHAR2
809 );
810
811 PROCEDURE Translate_Value_Set_Val
812 (p_api_version IN NUMBER
813 ,p_value_set_name IN VARCHAR2
814 ,p_internal_name IN VARCHAR2
815 ,p_display_name IN VARCHAR2
816 ,p_description IN VARCHAR2
817 ,p_last_update_date IN VARCHAR2
818 ,p_last_updated_by IN NUMBER
819 ,p_init_msg_list IN VARCHAR2
820 ,p_commit IN VARCHAR2
821 ,x_return_status OUT NOCOPY VARCHAR2
822 ,x_msg_count OUT NOCOPY NUMBER
823 ,x_msg_data OUT NOCOPY VARCHAR2
824 );
825
826
827 PROCEDURE Process_VS_Value_Sequence
828 (p_api_version IN NUMBER
829 ,p_transaction_type IN VARCHAR2
830 ,p_value_set_id IN NUMBER DEFAULT NULL
831 ,p_value_set_name IN VARCHAR2 DEFAULT NULL
832 ,p_value_set_value_id IN NUMBER DEFAULT NULL
833 ,p_value_set_value IN VARCHAR2 DEFAULT NULL
834 ,p_sequence IN NUMBER
835 ,p_owner IN NUMBER DEFAULT NULL
836 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
837 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
838 ,x_return_status OUT NOCOPY VARCHAR2
839 ,x_msg_count OUT NOCOPY NUMBER
840 ,x_msg_data OUT NOCOPY VARCHAR2
841 );
842
843
844 FUNCTION is_vs_value_editable (cp_vs_value_id IN NUMBER)
845 RETURN VARCHAR2;
846
847 -----------------------------
848 -- Object Association APIs --
849 -----------------------------
850
851 -- signature to use if caller has OBJECT_ID and ATTR_GROUP_ID
852 PROCEDURE Create_Association (
853 p_api_version IN NUMBER
854 ,p_association_id IN NUMBER DEFAULT NULL
855 ,p_object_id IN NUMBER
856 ,p_classification_code IN VARCHAR2
857 ,p_data_level IN VARCHAR2
858 ,p_attr_group_id IN NUMBER
859 ,p_enabled_flag IN VARCHAR2
860 ,p_view_privilege_id IN NUMBER --ignored for now
861 ,p_edit_privilege_id IN NUMBER --ignored for now
862 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
863 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
864 ,x_association_id OUT NOCOPY NUMBER
865 ,x_return_status OUT NOCOPY VARCHAR2
866 ,x_errorcode OUT NOCOPY NUMBER
867 ,x_msg_count OUT NOCOPY NUMBER
868 ,x_msg_data OUT NOCOPY VARCHAR2
869 );
870
871 -- signature to use if caller has OBJECT_ID but not ATTR_GROUP_ID
872 PROCEDURE Create_Association (
873 p_api_version IN NUMBER
874 ,p_association_id IN NUMBER DEFAULT NULL
875 ,p_object_id IN NUMBER
876 ,p_classification_code IN VARCHAR2
877 ,p_data_level IN VARCHAR2
878 ,p_application_id IN NUMBER
879 ,p_attr_group_type IN VARCHAR2
880 ,p_attr_group_name IN VARCHAR2
881 ,p_enabled_flag IN VARCHAR2
882 ,p_view_privilege_id IN NUMBER --ignored for now
883 ,p_edit_privilege_id IN NUMBER --ignored for now
884 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
885 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
886 ,x_association_id OUT NOCOPY NUMBER
887 ,x_return_status OUT NOCOPY VARCHAR2
888 ,x_errorcode OUT NOCOPY NUMBER
889 ,x_msg_count OUT NOCOPY NUMBER
893 -- signature to use if caller doesn't have OBJECT_ID or ATTR_GROUP_ID
890 ,x_msg_data OUT NOCOPY VARCHAR2
891 );
892
894 PROCEDURE Create_Association (
895 p_api_version IN NUMBER
896 ,p_object_name IN VARCHAR2
897 ,p_classification_code IN VARCHAR2
898 ,p_data_level IN VARCHAR2
899 ,p_application_id IN NUMBER
900 ,p_attr_group_type IN VARCHAR2
901 ,p_attr_group_name IN VARCHAR2
902 ,p_enabled_flag IN VARCHAR2
903 ,p_view_privilege_id IN NUMBER --ignored for now
904 ,p_edit_privilege_id IN NUMBER --ignored for now
905 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
906 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
907 ,x_association_id OUT NOCOPY NUMBER
908 ,x_return_status OUT NOCOPY VARCHAR2
909 ,x_errorcode OUT NOCOPY NUMBER
910 ,x_msg_count OUT NOCOPY NUMBER
911 ,x_msg_data OUT NOCOPY VARCHAR2
912 );
913
914 -- signature to use if caller has ASSOCIATION_ID
915 PROCEDURE Update_Association (
916 p_api_version IN NUMBER
917 ,p_association_id IN NUMBER
918 ,p_enabled_flag IN VARCHAR2
919 ,p_view_privilege_id IN NUMBER --ignored for now
920 ,p_edit_privilege_id IN NUMBER --ignored for now
921 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
922 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
923 ,x_return_status OUT NOCOPY VARCHAR2
924 ,x_errorcode OUT NOCOPY NUMBER
925 ,x_msg_count OUT NOCOPY NUMBER
926 ,x_msg_data OUT NOCOPY VARCHAR2
927 );
928
929 -- signature to use if caller doesn't have ASSOCIATION_ID but has ATTR_GROUP_ID
930 PROCEDURE Update_Association (
931 p_api_version IN NUMBER
932 ,p_object_id IN NUMBER
933 ,p_classification_code IN VARCHAR2
934 ,p_attr_group_id IN NUMBER
935 ,p_enabled_flag IN VARCHAR2
936 ,p_view_privilege_id IN NUMBER --ignored for now
937 ,p_edit_privilege_id IN NUMBER --ignored for now
938 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
939 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
940 ,x_return_status OUT NOCOPY VARCHAR2
941 ,x_errorcode OUT NOCOPY NUMBER
942 ,x_msg_count OUT NOCOPY NUMBER
943 ,x_msg_data OUT NOCOPY VARCHAR2
944 );
945
946 -- signature to use if caller doesn't have ASSOCIATION_ID or ATTR_GROUP_ID
947 PROCEDURE Update_Association (
948 p_api_version IN NUMBER
949 ,p_object_id IN NUMBER
950 ,p_classification_code IN VARCHAR2
951 ,p_application_id IN NUMBER
952 ,p_attr_group_type IN VARCHAR2
953 ,p_attr_group_name IN VARCHAR2
954 ,p_enabled_flag IN VARCHAR2
955 ,p_view_privilege_id IN NUMBER --ignored for now
956 ,p_edit_privilege_id IN NUMBER --ignored for now
957 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
958 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
959 ,x_return_status OUT NOCOPY VARCHAR2
960 ,x_errorcode OUT NOCOPY NUMBER
961 ,x_msg_count OUT NOCOPY NUMBER
962 ,x_msg_data OUT NOCOPY VARCHAR2
963 );
964
965 PROCEDURE Delete_Association (
966 p_api_version IN NUMBER
967 ,p_association_id IN NUMBER
968 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
969 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
970 ,p_force IN VARCHAR2 := fnd_api.g_FALSE
971 ,x_return_status OUT NOCOPY VARCHAR2
972 ,x_errorcode OUT NOCOPY NUMBER
973 ,x_msg_count OUT NOCOPY NUMBER
974 ,x_msg_data OUT NOCOPY VARCHAR2
975 );
976
977 -------------------------------
978 -- Attribute Group Page APIs --
979 -------------------------------
980
981 PROCEDURE Create_Page (
982 p_api_version IN NUMBER
983 ,p_page_id IN NUMBER DEFAULT NULL
984 ,p_object_id IN NUMBER
985 ,p_classification_code IN VARCHAR2
986 ,p_data_level IN VARCHAR2
987 ,p_internal_name IN VARCHAR2
988 ,p_display_name IN VARCHAR2
989 ,p_description IN VARCHAR2
990 ,p_sequence IN NUMBER
991 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
992 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
996 ,x_msg_count OUT NOCOPY NUMBER
993 ,x_page_id OUT NOCOPY NUMBER
994 ,x_return_status OUT NOCOPY VARCHAR2
995 ,x_errorcode OUT NOCOPY NUMBER
997 ,x_msg_data OUT NOCOPY VARCHAR2
998 );
999
1000 -- signature to use if caller has PAGE_ID
1001 PROCEDURE Update_Page (
1002 p_api_version IN NUMBER
1003 ,p_page_id IN NUMBER
1004 ,p_internal_name IN VARCHAR2
1005 ,p_display_name IN VARCHAR2
1006 ,p_description IN VARCHAR2
1007 ,p_sequence IN NUMBER
1008 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1009 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1010 ,p_is_nls_mode IN VARCHAR2 DEFAULT FND_API.G_FALSE
1011 ,x_return_status OUT NOCOPY VARCHAR2
1012 ,x_errorcode OUT NOCOPY NUMBER
1013 ,x_msg_count OUT NOCOPY NUMBER
1014 ,x_msg_data OUT NOCOPY VARCHAR2
1015 );
1016
1017 -- signature to use if caller doesn't have PAGE_ID
1018 -- the caller can set p_new_internal_name to null, in which case it will not be updated
1019 PROCEDURE Update_Page (
1020 p_api_version IN NUMBER
1021 ,p_object_id IN NUMBER
1022 ,p_classification_code IN VARCHAR2
1023 ,p_data_level IN VARCHAR2
1024 ,p_old_internal_name IN VARCHAR2
1025 ,p_new_internal_name IN VARCHAR2
1026 ,p_display_name IN VARCHAR2
1027 ,p_description IN VARCHAR2
1028 ,p_sequence IN NUMBER
1029 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1030 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1031 ,x_return_status OUT NOCOPY VARCHAR2
1032 ,x_errorcode OUT NOCOPY NUMBER
1033 ,x_msg_count OUT NOCOPY NUMBER
1034 ,x_msg_data OUT NOCOPY VARCHAR2
1035 );
1036
1037 -- signature to use if caller has PAGE_ID
1038 PROCEDURE Delete_Page (
1039 p_api_version IN NUMBER
1040 ,p_page_id IN NUMBER
1041 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1042 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
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 doesn't have PAGE_ID
1050 PROCEDURE Delete_Page (
1051 p_api_version IN NUMBER
1052 ,p_object_id IN NUMBER
1053 ,p_classification_code IN VARCHAR2
1054 ,p_internal_name IN VARCHAR2
1055 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1056 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1057 ,x_return_status OUT NOCOPY VARCHAR2
1058 ,x_errorcode OUT NOCOPY NUMBER
1059 ,x_msg_count OUT NOCOPY NUMBER
1060 ,x_msg_data OUT NOCOPY VARCHAR2
1061 );
1062
1063 -- A "group by" function for SQL queries
1064 FUNCTION Group_Page_Regions (
1065 p_association_id IN NUMBER
1066 ,p_object_id IN NUMBER
1067 ,p_object_name IN VARCHAR2
1068 ,p_classification_code IN VARCHAR2
1069 ,p_data_level IN VARCHAR2
1070 ,p_application_id IN NUMBER
1071 ,p_attr_group_type IN VARCHAR2
1072 ,p_attr_group_name IN VARCHAR2
1073 ,p_attr_group_disp_name IN VARCHAR2
1074 ,p_attr_group_description IN VARCHAR2
1075 ,p_enabled_code IN VARCHAR2
1076 )
1077 RETURN VARCHAR2;
1078
1079 ---------------------
1080 -- Page Entry APIs --
1081 ---------------------
1082
1083 PROCEDURE Create_Page_Entry (
1084 p_api_version IN NUMBER
1085 ,p_page_id IN NUMBER
1086 ,p_association_id IN NUMBER
1087 ,p_sequence IN NUMBER
1088 ,p_classification_code IN VARCHAR2
1089 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1090 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1091 ,x_return_status OUT NOCOPY VARCHAR2
1092 ,x_errorcode OUT NOCOPY NUMBER
1093 ,x_msg_count OUT NOCOPY NUMBER
1094 ,x_msg_data OUT NOCOPY VARCHAR2
1095 );
1096
1097 PROCEDURE Update_Page_Entry (
1098 p_api_version IN NUMBER
1099 ,p_page_id IN NUMBER
1100 ,p_new_association_id IN NUMBER --2995435: Doesnt update association id
1104 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1101 ,p_old_association_id IN NUMBER --2995435: Doesnt update association id
1102 ,p_sequence IN NUMBER
1103 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1105 ,x_return_status OUT NOCOPY VARCHAR2
1106 ,x_errorcode OUT NOCOPY NUMBER
1107 ,x_msg_count OUT NOCOPY NUMBER
1108 ,x_msg_data OUT NOCOPY VARCHAR2
1109 );
1110
1111 PROCEDURE Delete_Page_Entry (
1112 p_api_version IN NUMBER
1113 ,p_page_id IN NUMBER
1114 ,p_association_id IN NUMBER
1115 ,p_classification_code IN VARCHAR2 -- Bug 3871440
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 -------------------
1125 -- Function APIs --
1126 -------------------
1127
1128 PROCEDURE Create_Function (
1129 p_api_version IN NUMBER
1130 ,p_internal_name IN VARCHAR2
1131 ,p_function_type IN VARCHAR2
1132 ,p_function_info_1 IN VARCHAR2
1133 ,p_function_info_2 IN VARCHAR2
1134 ,p_display_name IN VARCHAR2
1135 ,p_description IN VARCHAR2
1136 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1137 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1138 ,x_function_id OUT NOCOPY NUMBER
1139 ,x_return_status OUT NOCOPY VARCHAR2
1140 ,x_errorcode OUT NOCOPY NUMBER
1141 ,x_msg_count OUT NOCOPY NUMBER
1142 ,x_msg_data OUT NOCOPY VARCHAR2
1143 );
1144
1145 PROCEDURE Update_Function (
1146 p_api_version IN NUMBER
1147 ,p_function_id IN NUMBER
1148 ,p_internal_name IN VARCHAR2
1149 ,p_function_info_1 IN VARCHAR2
1150 ,p_function_info_2 IN VARCHAR2
1151 ,p_display_name IN VARCHAR2
1152 ,p_description IN VARCHAR2
1153 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1154 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1155 ,x_return_status OUT NOCOPY VARCHAR2
1156 ,x_errorcode OUT NOCOPY NUMBER
1157 ,x_msg_count OUT NOCOPY NUMBER
1158 ,x_msg_data OUT NOCOPY VARCHAR2
1159 );
1160
1161 PROCEDURE Delete_Function (
1162 p_api_version IN NUMBER
1163 ,p_function_id IN NUMBER
1164 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1165 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1166 ,x_return_status OUT NOCOPY VARCHAR2
1167 ,x_errorcode OUT NOCOPY NUMBER
1168 ,x_msg_count OUT NOCOPY NUMBER
1169 ,x_msg_data OUT NOCOPY VARCHAR2
1170 );
1171
1172 ------------------------------------
1173 -- Action and Action Display APIs --
1174 ------------------------------------
1175
1176 -- signature to use if caller has ATTR_GROUP_ID
1177 PROCEDURE Create_Action (
1178 p_api_version IN NUMBER
1179 ,p_object_id IN NUMBER
1180 ,p_classification_code IN VARCHAR2
1181 ,p_attr_group_id IN NUMBER DEFAULT NULL
1182 ,p_sequence IN NUMBER
1183 ,p_action_name IN VARCHAR2
1184 ,p_description IN VARCHAR2
1185 ,p_function_id IN NUMBER
1186 ,p_enable_key_attrs IN VARCHAR2 DEFAULT NULL
1187 ,p_security_privilege_id IN NUMBER
1188 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1189 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1190 ,x_action_id OUT NOCOPY NUMBER
1191 ,x_return_status OUT NOCOPY VARCHAR2
1192 ,x_errorcode OUT NOCOPY NUMBER
1193 ,x_msg_count OUT NOCOPY NUMBER
1194 ,x_msg_data OUT NOCOPY VARCHAR2
1195 );
1196
1197 -- signature to use if caller doesn't have ATTR_GROUP_ID
1198 PROCEDURE Create_Action (
1199 p_api_version IN NUMBER
1200 ,p_object_id IN NUMBER
1201 ,p_classification_code IN VARCHAR2
1202 ,p_attr_grp_application_id IN NUMBER
1203 ,p_attr_group_type IN VARCHAR2
1204 ,p_attr_group_name IN VARCHAR2
1205 ,p_sequence IN NUMBER
1206 ,p_action_name IN VARCHAR2
1207 ,p_description IN VARCHAR2
1211 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1208 ,p_function_id IN NUMBER
1209 ,p_enable_key_attrs IN VARCHAR2 DEFAULT NULL
1210 ,p_security_privilege_id IN NUMBER
1212 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1213 ,x_action_id OUT NOCOPY NUMBER
1214 ,x_return_status OUT NOCOPY VARCHAR2
1215 ,x_errorcode OUT NOCOPY NUMBER
1216 ,x_msg_count OUT NOCOPY NUMBER
1217 ,x_msg_data OUT NOCOPY VARCHAR2
1218 );
1219
1220 PROCEDURE Update_Action (
1221 p_api_version IN NUMBER
1222 ,p_action_id IN NUMBER
1223 ,p_sequence IN NUMBER
1224 ,p_action_name IN VARCHAR2
1225 ,p_description IN VARCHAR2
1226 ,p_function_id IN NUMBER
1227 ,p_enable_key_attrs IN VARCHAR2 DEFAULT NULL
1228 ,p_security_privilege_id IN NUMBER
1229 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1230 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1231 ,x_return_status OUT NOCOPY VARCHAR2
1232 ,x_errorcode OUT NOCOPY NUMBER
1233 ,x_msg_count OUT NOCOPY NUMBER
1234 ,x_msg_data OUT NOCOPY VARCHAR2
1235 );
1236
1237 PROCEDURE Delete_Action (
1238 p_api_version IN NUMBER
1239 ,p_action_id IN NUMBER
1240 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1241 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1242 ,x_return_status OUT NOCOPY VARCHAR2
1243 ,x_errorcode OUT NOCOPY NUMBER
1244 ,x_msg_count OUT NOCOPY NUMBER
1245 ,x_msg_data OUT NOCOPY VARCHAR2
1246 );
1247
1248 -- call this API to create an Action that is executed by a user action
1249 PROCEDURE Create_Action_Display (
1250 p_api_version IN NUMBER
1251 ,p_action_id IN NUMBER
1252 ,p_display_style IN VARCHAR2
1253 ,p_prompt_application_id IN NUMBER
1254 ,p_prompt_message_name IN VARCHAR2
1255 ,p_visibility_flag IN VARCHAR2
1256 ,p_prompt_function_id IN NUMBER
1257 ,p_visibility_func_id IN NUMBER
1258 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1259 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1260 ,x_return_status OUT NOCOPY VARCHAR2
1261 ,x_errorcode OUT NOCOPY NUMBER
1262 ,x_msg_count OUT NOCOPY NUMBER
1263 ,x_msg_data OUT NOCOPY VARCHAR2
1264 );
1265
1266 -- call this API to create an Action that is executed by a trigger
1267 PROCEDURE Create_Action_Display (
1268 p_api_version IN NUMBER
1269 ,p_action_id IN NUMBER
1270 ,p_trigger_code IN VARCHAR2
1271 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1272 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1273 ,x_return_status OUT NOCOPY VARCHAR2
1274 ,x_errorcode OUT NOCOPY NUMBER
1275 ,x_msg_count OUT NOCOPY NUMBER
1276 ,x_msg_data OUT NOCOPY VARCHAR2
1277 );
1278
1279 -- call this API to update an Action that is executed by a user action
1280 PROCEDURE Update_Action_Display (
1281 p_api_version IN NUMBER
1282 ,p_action_id IN NUMBER
1283 ,p_display_style IN VARCHAR2
1284 ,p_prompt_application_id IN NUMBER
1285 ,p_prompt_message_name IN VARCHAR2
1286 ,p_visibility_flag IN VARCHAR2
1287 ,p_prompt_function_id IN NUMBER
1288 ,p_visibility_func_id IN NUMBER
1289 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1290 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1291 ,x_return_status OUT NOCOPY VARCHAR2
1292 ,x_errorcode OUT NOCOPY NUMBER
1293 ,x_msg_count OUT NOCOPY NUMBER
1294 ,x_msg_data OUT NOCOPY VARCHAR2
1295 );
1296
1297 -- call this API to update an Action that is executed by a trigger
1298 PROCEDURE Update_Action_Display (
1299 p_api_version IN NUMBER
1300 ,p_action_id IN NUMBER
1301 ,p_trigger_code IN VARCHAR2
1302 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1303 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1304 ,x_return_status OUT NOCOPY VARCHAR2
1305 ,x_errorcode OUT NOCOPY NUMBER
1306 ,x_msg_count OUT NOCOPY NUMBER
1307 ,x_msg_data OUT NOCOPY VARCHAR2
1308 );
1309
1310 PROCEDURE Delete_Action_Display (
1311 p_api_version IN NUMBER
1315 ,x_return_status OUT NOCOPY VARCHAR2
1312 ,p_action_id IN NUMBER
1313 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1314 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1316 ,x_errorcode OUT NOCOPY NUMBER
1317 ,x_msg_count OUT NOCOPY NUMBER
1318 ,x_msg_data OUT NOCOPY VARCHAR2
1319 );
1320
1321 -----------------------------
1322 -- Function Parameter APIs --
1323 -----------------------------
1324
1325 PROCEDURE Create_Function_Param (
1326 p_api_version IN NUMBER
1327 ,p_function_id IN NUMBER
1328 ,p_sequence IN NUMBER
1329 ,p_internal_name IN VARCHAR2
1330 ,p_data_type IN VARCHAR2
1331 ,p_param_type IN VARCHAR2
1332 ,p_display_name IN VARCHAR2
1333 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1334 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1335 ,x_function_param_id OUT NOCOPY NUMBER
1336 ,x_return_status OUT NOCOPY VARCHAR2
1337 ,x_errorcode OUT NOCOPY NUMBER
1338 ,x_msg_count OUT NOCOPY NUMBER
1339 ,x_msg_data OUT NOCOPY VARCHAR2
1340 );
1341
1342 PROCEDURE Update_Function_Param (
1343 p_api_version IN NUMBER
1344 ,p_function_param_id IN NUMBER
1345 ,p_sequence IN NUMBER
1346 ,p_internal_name IN VARCHAR2
1347 ,p_display_name IN VARCHAR2
1348 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1349 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1350 ,x_return_status OUT NOCOPY VARCHAR2
1351 ,x_errorcode OUT NOCOPY NUMBER
1352 ,x_msg_count OUT NOCOPY NUMBER
1353 ,x_msg_data OUT NOCOPY VARCHAR2
1354 );
1355
1356 PROCEDURE Delete_Function_Param (
1357 p_api_version IN NUMBER
1358 ,p_function_param_id IN NUMBER
1359 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1360 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1361 ,x_return_status OUT NOCOPY VARCHAR2
1362 ,x_errorcode OUT NOCOPY NUMBER
1363 ,x_msg_count OUT NOCOPY NUMBER
1364 ,x_msg_data OUT NOCOPY VARCHAR2
1365 );
1366
1367 -------------------------
1368 -- Action Mapping APIs --
1369 -------------------------
1370
1371 PROCEDURE Create_Mapping (
1372 p_api_version IN NUMBER
1373 ,p_function_id IN NUMBER
1374 ,p_mapped_obj_type IN VARCHAR2
1375 ,p_mapped_obj_pk1_value IN VARCHAR2
1376 ,p_func_param_id IN NUMBER
1377 ,p_mapping_group_type IN VARCHAR2
1378 ,p_mapping_group_pk1 IN VARCHAR2
1379 ,p_mapping_group_pk2 IN VARCHAR2
1380 ,p_mapping_group_pk3 IN VARCHAR2
1381 ,p_mapping_value IN VARCHAR2
1382 ,p_mapped_uom_parameter IN VARCHAR2 := NULL
1383 ,p_value_uom_source IN VARCHAR2 := NULL
1384 ,p_fixed_uom IN VARCHAR2 := NULL
1385 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1386 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1387 ,x_return_status OUT NOCOPY VARCHAR2
1388 ,x_errorcode OUT NOCOPY NUMBER
1389 ,x_msg_count OUT NOCOPY NUMBER
1390 ,x_msg_data OUT NOCOPY VARCHAR2
1391 );
1392
1393
1394 PROCEDURE Create_Mapping (
1395 p_api_version IN NUMBER
1396 ,p_function_id IN NUMBER
1397 ,p_mapped_obj_type IN VARCHAR2
1398 ,p_mapped_obj_pk1_value IN VARCHAR2
1399 ,p_func_param_id IN NUMBER
1400 ,p_attr_group_id IN NUMBER
1401 ,p_mapping_value IN VARCHAR2
1402 ,p_mapped_uom_parameter IN VARCHAR2 := NULL
1403 ,p_value_uom_source IN VARCHAR2 := NULL
1404 ,p_fixed_uom IN VARCHAR2 := NULL
1405 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1406 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1407 ,x_return_status OUT NOCOPY VARCHAR2
1408 ,x_errorcode OUT NOCOPY NUMBER
1409 ,x_msg_count OUT NOCOPY NUMBER
1410 ,x_msg_data OUT NOCOPY VARCHAR2
1411 );
1412
1413
1414
1415 PROCEDURE Update_Mapping (
1416 p_api_version IN NUMBER
1417 ,p_function_id IN NUMBER
1418 ,p_mapped_obj_type IN VARCHAR2
1419 ,p_mapped_obj_pk1_value IN VARCHAR2
1420 ,p_func_param_id IN NUMBER
1424 ,p_mapping_group_pk3 IN VARCHAR2
1421 ,p_mapping_group_type IN VARCHAR2
1422 ,p_mapping_group_pk1 IN VARCHAR2
1423 ,p_mapping_group_pk2 IN VARCHAR2
1425 ,p_mapping_value IN VARCHAR2
1426 ,p_new_func_param_id IN NUMBER := NULL
1427 ,p_new_mapping_group_pk1 IN VARCHAR2 := NULL
1428 ,p_new_mapping_group_pk2 IN VARCHAR2 := NULL
1429 ,p_new_mapping_group_pk3 IN VARCHAR2 := NULL
1430 ,p_new_mapping_value IN VARCHAR2 := NULL
1431 ,p_mapped_uom_parameter IN VARCHAR2 := NULL
1432 ,p_value_uom_source IN VARCHAR2 := NULL
1433 ,p_fixed_uom IN VARCHAR2 := NULL
1434 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1435 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1436 ,x_return_status OUT NOCOPY VARCHAR2
1437 ,x_errorcode OUT NOCOPY NUMBER
1438 ,x_msg_count OUT NOCOPY NUMBER
1439 ,x_msg_data OUT NOCOPY VARCHAR2
1440 );
1441
1442
1443 PROCEDURE Update_Mapping (
1444 p_api_version IN NUMBER
1445 ,p_function_id IN NUMBER
1446 ,p_mapped_obj_type IN VARCHAR2
1447 ,p_mapped_obj_pk1_value IN VARCHAR2
1448 ,p_func_param_id IN NUMBER
1449 ,p_attr_group_id IN NUMBER
1450 ,p_mapping_value IN VARCHAR2
1451 ,p_mapping_group_pk1 IN VARCHAR2 := NULL
1452 ,p_mapping_group_pk2 IN VARCHAR2 := NULL
1453 ,p_mapping_group_pk3 IN VARCHAR2 := NULL
1454 ,p_new_func_param_id IN NUMBER := NULL
1455 ,p_new_mapping_value IN VARCHAR2 := NULL
1456 ,p_mapped_uom_parameter IN VARCHAR2 := NULL
1457 ,p_value_uom_source IN VARCHAR2 := NULL
1458 ,p_fixed_uom IN VARCHAR2 := NULL
1459 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1460 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1461 ,x_return_status OUT NOCOPY VARCHAR2
1462 ,x_errorcode OUT NOCOPY NUMBER
1463 ,x_msg_count OUT NOCOPY NUMBER
1464 ,x_msg_data OUT NOCOPY VARCHAR2
1465 );
1466
1467
1468 -- call this API to delete all mappings for a given action and function
1469 PROCEDURE Delete_Func_Mapping (
1470 p_api_version IN NUMBER
1471 ,p_function_id IN NUMBER
1472 ,p_mapped_obj_type IN VARCHAR2
1473 ,p_mapped_obj_pk1_value IN VARCHAR2
1474 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1475 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1476 ,x_return_status OUT NOCOPY VARCHAR2
1477 ,x_errorcode OUT NOCOPY NUMBER
1478 ,x_msg_count OUT NOCOPY NUMBER
1479 ,x_msg_data OUT NOCOPY VARCHAR2
1480 );
1481
1482 -- call this API to delete an individual parameter mapping
1483 PROCEDURE Delete_Func_Param_Mapping (
1484 p_api_version IN NUMBER
1485 ,p_function_id IN NUMBER
1486 ,p_mapped_obj_type IN VARCHAR2
1487 ,p_mapped_obj_pk1_value IN VARCHAR2
1488 ,p_func_param_id IN NUMBER
1492 ,x_errorcode OUT NOCOPY NUMBER
1489 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1490 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1491 ,x_return_status OUT NOCOPY VARCHAR2
1493 ,x_msg_count OUT NOCOPY NUMBER
1494 ,x_msg_data OUT NOCOPY VARCHAR2
1495 );
1496
1497 -----------------------
1498 -- Action Group APIs --
1499 -----------------------
1500
1501 PROCEDURE Create_Action_Group (
1502 p_api_version IN NUMBER
1503 ,p_object_id IN NUMBER
1504 ,p_classification_code IN VARCHAR2
1505 ,p_sequence IN NUMBER
1506 ,p_internal_name IN VARCHAR2
1507 ,p_display_name IN VARCHAR2
1508 ,p_description IN VARCHAR2
1509 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1510 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1511 ,x_action_group_id OUT NOCOPY NUMBER
1512 ,x_return_status OUT NOCOPY VARCHAR2
1513 ,x_errorcode OUT NOCOPY NUMBER
1514 ,x_msg_count OUT NOCOPY NUMBER
1515 ,x_msg_data OUT NOCOPY VARCHAR2
1516 );
1517
1518 PROCEDURE Update_Action_Group (
1519 p_api_version IN NUMBER
1520 ,p_action_group_id IN NUMBER
1521 ,p_sequence IN NUMBER
1522 ,p_internal_name IN VARCHAR2
1523 ,p_display_name IN VARCHAR2
1524 ,p_description IN VARCHAR2
1525 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1526 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1527 ,x_return_status OUT NOCOPY VARCHAR2
1528 ,x_errorcode OUT NOCOPY NUMBER
1529 ,x_msg_count OUT NOCOPY NUMBER
1530 ,x_msg_data OUT NOCOPY VARCHAR2
1531 );
1532
1533 PROCEDURE Delete_Action_Group (
1534 p_api_version IN NUMBER
1535 ,p_action_group_id IN NUMBER
1536 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1537 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1538 ,x_return_status OUT NOCOPY VARCHAR2
1539 ,x_errorcode OUT NOCOPY NUMBER
1540 ,x_msg_count OUT NOCOPY NUMBER
1541 ,x_msg_data OUT NOCOPY VARCHAR2
1542 );
1543
1544 -----------------------------
1545 -- Action Group Entry APIs --
1546 -----------------------------
1547
1548 PROCEDURE Create_Action_Group_Entry (
1549 p_api_version IN NUMBER
1550 ,p_action_group_id IN NUMBER
1551 ,p_action_id IN NUMBER
1552 ,p_sequence IN NUMBER
1553 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1554 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1555 ,x_return_status OUT NOCOPY VARCHAR2
1556 ,x_errorcode OUT NOCOPY NUMBER
1557 ,x_msg_count OUT NOCOPY NUMBER
1558 ,x_msg_data OUT NOCOPY VARCHAR2
1559 );
1560
1561 PROCEDURE Update_Action_Group_Entry (
1562 p_api_version IN NUMBER
1563 ,p_action_group_id IN NUMBER
1564 ,p_action_id IN NUMBER
1565 ,p_sequence IN NUMBER
1566 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1567 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1568 ,x_return_status OUT NOCOPY VARCHAR2
1569 ,x_errorcode OUT NOCOPY NUMBER
1570 ,x_msg_count OUT NOCOPY NUMBER
1571 ,x_msg_data OUT NOCOPY VARCHAR2
1572 );
1573
1574 PROCEDURE Delete_Action_Group_Entry (
1575 p_api_version IN NUMBER
1576 ,p_action_group_id IN NUMBER
1577 ,p_action_id IN NUMBER
1578 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1579 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1580 ,x_return_status OUT NOCOPY VARCHAR2
1581 ,x_errorcode OUT NOCOPY NUMBER
1582 ,x_msg_count OUT NOCOPY NUMBER
1583 ,x_msg_data OUT NOCOPY VARCHAR2
1584 );
1585
1586
1587 PROCEDURE ADD_LANGUAGE (
1588 p_tl_table_name IN VARCHAR2
1589 );
1590
1591
1592 FUNCTION Return_Association_Existance (
1593 p_application_id IN NUMBER
1594 ,p_attr_group_type IN VARCHAR2
1595 ,p_attr_group_name IN VARCHAR2
1596 ) return VARCHAR2;
1597
1598 PROCEDURE Update_AGV_Name(
1599 P_API_VERSION IN NUMBER
1600 ,P_APPLICATION_ID IN NUMBER
1601 ,P_ATTR_GROUP_TYPE IN VARCHAR2
1602 ,P_ATTR_GROUP_NAME IN VARCHAR2
1603 ,P_AGV_NAME IN VARCHAR2
1604 ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1605 ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1606 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
1607 ,X_ERRORCODE OUT NOCOPY NUMBER
1608 ,X_MSG_COUNT OUT NOCOPY NUMBER
1609 ,X_MSG_DATA OUT NOCOPY VARCHAR2
1610 );
1611
1612 PROCEDURE Update_Attribute_Control_Level (
1613 p_api_version IN NUMBER
1614 ,p_application_id IN NUMBER
1615 ,p_descriptive_flexfield_name IN VARCHAR2
1616 ,p_application_column_name IN VARCHAR2
1617 ,p_control_level IN NUMBER
1618 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1619 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1620 ,x_return_status OUT NOCOPY VARCHAR2
1621 ,x_msg_count OUT NOCOPY NUMBER
1622 ,x_msg_data OUT NOCOPY VARCHAR2
1623 );
1624
1625
1626 FUNCTION Convert_Class_Code_To_Name (
1627 p_object_name IN VARCHAR2
1628 ,p_class_code IN VARCHAR2
1629 ) RETURN VARCHAR2;
1630
1631
1632 FUNCTION Convert_Name_To_Class_Code (
1633 p_object_name IN VARCHAR2
1634 ,p_class_name IN VARCHAR2
1635 ) RETURN VARCHAR2;
1636
1637
1638
1639 PROCEDURE Sync_Up_Attr_Metadata (
1640 p_source_ag_name IN VARCHAR2,
1641 p_source_ag_type IN VARCHAR2,
1642 p_source_appl_id IN VARCHAR2,
1643 p_target_ag_name IN VARCHAR2,
1644 p_target_ag_type IN VARCHAR2,
1645 p_target_appl_id IN VARCHAR2,
1646 x_return_status OUT NOCOPY VARCHAR2,
1647 x_errorcode OUT NOCOPY VARCHAR2,
1648 x_msg_count OUT NOCOPY NUMBER,
1649 x_msg_data OUT NOCOPY VARCHAR2
1650 );
1651 --R12C
1652 PROCEDURE Create_Action_Data_Level (
1653 p_api_version IN NUMBER
1654 ,p_action_id IN NUMBER
1655 ,p_data_level_id IN NUMBER
1656 ,p_visibility_flag IN VARCHAR2 DEFAULT 'Y'
1657 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1658 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1659 ,x_return_status OUT NOCOPY VARCHAR2
1660 ,x_errorcode OUT NOCOPY NUMBER
1661 ,x_msg_count OUT NOCOPY NUMBER
1662 ,x_msg_data OUT NOCOPY VARCHAR2
1663 );
1664 PROCEDURE Delete_Action_Data_Level (
1665 p_api_version IN NUMBER
1666 ,p_action_id IN NUMBER
1667 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1668 ,p_commit IN VARCHAR2 := fnd_api.g_FALSE
1669 ,x_return_status OUT NOCOPY VARCHAR2
1670 ,x_errorcode OUT NOCOPY NUMBER
1671 ,x_msg_count OUT NOCOPY NUMBER
1672 ,x_msg_data OUT NOCOPY VARCHAR2
1673 );
1674
1675 FUNCTION Concat_Data_Level_DisplayNames (p_attr_grp_id IN NUMBER)
1676 RETURN VARCHAR2;
1677
1678
1679
1680 END EGO_EXT_FWK_PUB;
1681