1 PACKAGE fnd_flex_val_api AUTHID CURRENT_USER AS
2 /* $Header: AFFFVAIS.pls 120.8 2011/10/19 20:45:00 hgeorgi ship $ */
3
4
5 --
6 -- Following are the return codes for get_*_vset_select functions.
7 --
8
9 g_ret_no_error NUMBER := 0;
10 g_ret_invalid_parameter NUMBER := 1;
11 g_ret_others NUMBER := 9;
12 g_ret_no_value_set NUMBER := 11;
13 g_ret_vtype_mismatch NUMBER := 12;
14 g_ret_vtype_not_supported NUMBER := 13;
15 g_ret_not_indep_validated NUMBER := 21;
16 g_ret_not_dep_validated NUMBER := 31;
17 g_ret_no_parent_value NUMBER := 32;
18 g_ret_not_table_validated NUMBER := 51;
19 g_ret_no_table_info NUMBER := 52;
20
21 --
22 -- Rename FND_API constants.
23 --
24 -- In Update APIs
25 -- NULL means "ignore this field, do not update it", and
26 -- Following constants mean "set the field to NULL."
27 --
28 g_null_number NUMBER := fnd_api.g_miss_num;
29 g_null_varchar2 VARCHAR2(10) := fnd_api.g_miss_char;
30 g_null_date DATE := fnd_api.g_miss_date;
31
32
33 PROCEDURE debug_on ;
34
35
36 PROCEDURE debug_off ;
37
38
39 PROCEDURE set_session_mode(session_mode IN VARCHAR2);
40
41
42 FUNCTION version RETURN VARCHAR2 ;
43
44 FUNCTION message RETURN VARCHAR2 ;
45
46
47
48 PROCEDURE create_valueset_none(
49 /* basic parameters */
50 value_set_name IN VARCHAR2,
51 description IN VARCHAR2,
52 security_available IN VARCHAR2,
53 enable_longlist IN VARCHAR2,
54 format_type IN VARCHAR2,
55 maximum_size IN NUMBER,
56 precision IN NUMBER DEFAULT NULL,
57 numbers_only IN VARCHAR2,
58 uppercase_only IN VARCHAR2,
59 right_justify_zero_fill IN VARCHAR2,
60 min_value IN VARCHAR2,
61 max_value IN VARCHAR2);
62
63
64
65
66 PROCEDURE create_valueset_independent(
67 /* basic parameters */
68 value_set_name IN VARCHAR2,
69 description IN VARCHAR2,
70 security_available IN VARCHAR2,
71 enable_longlist IN VARCHAR2,
72 format_type IN VARCHAR2,
73 maximum_size IN NUMBER,
74 precision IN NUMBER DEFAULT NULL,
75 numbers_only IN VARCHAR2,
76 uppercase_only IN VARCHAR2,
77 right_justify_zero_fill IN VARCHAR2,
78 min_value IN VARCHAR2,
79 max_value IN VARCHAR2);
80
81
82
83
84 PROCEDURE create_valueset_dependent(
85 /* basic parameters */
86 value_set_name IN VARCHAR2,
87 description IN VARCHAR2,
88 security_available IN VARCHAR2,
89 enable_longlist IN VARCHAR2,
90 format_type IN VARCHAR2,
91 maximum_size IN NUMBER,
92 precision IN NUMBER DEFAULT NULL,
93 numbers_only IN VARCHAR2,
94 uppercase_only IN VARCHAR2,
95 right_justify_zero_fill IN VARCHAR2,
96 min_value IN VARCHAR2,
97 max_value IN VARCHAR2,
98
99 parent_flex_value_set IN VARCHAR2,
100 dependent_default_value IN VARCHAR2,
101 dependent_default_meaning IN VARCHAR2);
102
103
104
105
106
107 PROCEDURE create_valueset_table(
108 /* basic parameters */
109 value_set_name IN VARCHAR2,
110 description IN VARCHAR2,
111 security_available IN VARCHAR2,
112 enable_longlist IN VARCHAR2,
113 format_type IN VARCHAR2,
114 maximum_size IN NUMBER,
115 precision IN NUMBER DEFAULT NULL,
116 numbers_only IN VARCHAR2,
117 uppercase_only IN VARCHAR2,
118 right_justify_zero_fill IN VARCHAR2,
119 min_value IN VARCHAR2,
120 max_value IN VARCHAR2,
121
122 table_application IN VARCHAR2 DEFAULT NULL,
123 table_appl_short_name IN VARCHAR2 DEFAULT NULL,
124 table_name IN VARCHAR2,
125 allow_parent_values IN VARCHAR2,
126 value_column_name IN VARCHAR2,
127 value_column_type IN VARCHAR2,
128 value_column_size IN NUMBER,
129 meaning_column_name IN VARCHAR2 DEFAULT NULL,
130 meaning_column_type IN VARCHAR2 DEFAULT NULL,
131 meaning_column_size IN NUMBER DEFAULT NULL,
132 id_column_name IN VARCHAR2 DEFAULT NULL,
133 id_column_type IN VARCHAR2 DEFAULT NULL,
134 id_column_size IN NUMBER DEFAULT NULL,
135 where_order_by IN VARCHAR2 DEFAULT NULL,
136 additional_columns IN VARCHAR2 DEFAULT NULL);
137
138
139
140
141
142
143 PROCEDURE create_valueset_special(
144 /* basic parameters */
145 value_set_name IN VARCHAR2,
146 description IN VARCHAR2,
147 security_available IN VARCHAR2,
148 enable_longlist IN VARCHAR2,
149 format_type IN VARCHAR2,
150 maximum_size IN NUMBER,
151 precision IN NUMBER DEFAULT NULL,
152 numbers_only IN VARCHAR2,
153 uppercase_only IN VARCHAR2,
154 right_justify_zero_fill IN VARCHAR2,
155 min_value IN VARCHAR2,
156 max_value IN VARCHAR2);
157
158
159
160 PROCEDURE create_valueset_pair(
161 /* basic parameters */
162 value_set_name IN VARCHAR2,
163 description IN VARCHAR2,
164 security_available IN VARCHAR2,
165 enable_longlist IN VARCHAR2,
166 format_type IN VARCHAR2,
167 maximum_size IN NUMBER,
168 precision IN NUMBER DEFAULT NULL,
169 numbers_only IN VARCHAR2,
170 uppercase_only IN VARCHAR2,
171 right_justify_zero_fill IN VARCHAR2,
172 min_value IN VARCHAR2,
173 max_value IN VARCHAR2);
174
175
176 PROCEDURE add_event(value_set_name IN VARCHAR2,
177 event IN VARCHAR2,
178 function_text IN clob);
179
180
181 PROCEDURE delete_valueset(value_set IN VARCHAR2);
182
183
184
185 PROCEDURE destructive_rename(old_value_set IN VARCHAR2,
186 new_value_set IN VARCHAR2);
187
188
189
190 FUNCTION valueset_exists(value_set IN VARCHAR2) RETURN BOOLEAN;
191
192
193
194 PROCEDURE update_table_sizes(
195 value_set_name IN VARCHAR2,
196 id_size IN fnd_flex_validation_tables.id_column_size%TYPE
197 DEFAULT NULL,
198 value_size IN fnd_flex_validation_tables.value_column_size%TYPE
199 DEFAULT NULL,
200 meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE
201 DEFAULT NULL);
202
203
204 PROCEDURE update_maxsize(
205 value_set_name IN VARCHAR2,
206 maxsize IN fnd_flex_value_sets.maximum_size%TYPE);
207
208 --------------------------------------------------------------
209 -- Get Select Statements.
210 --------------------------------------------------------------
211 -- Usage :
212 -- - Pass Only Flex Value Set Id or Flex Value Set Name, not both.
213 -- - You can control what to include in SELECT clause. (i.e. column names)
214 -- - VALUE column is always included.
215 -- - WHERE clause always has (1 = 1) condition which is always true and
216 -- does not effect the SELECT statement.
217 -- - ID and MEANING columns are included by default, can be excluded.
218 -- - p_inc_* parameters controls what to include in SELECT or WHERE parts.
219 -- - Passing a p_inc_* parameter as 'Y' doesn't guarantee this column will
220 -- be included in either SELECT column list or in WHERE clause.
221 -- - In the select list each column name is seperated by a newline char.
222 -- - Value column name is just after the SELECT clause.
223 -- - You can check what was included by parsing x_mapping_code.
224 -- Mapping Codes :
225 -- ---------------
226 -- Select part starts with S: and Where part starts with W:
227 -- Each column name or where clause has two char code. This code is
228 -- followed by a number. 0 means not included, 1 means included.
229 -- These are for SELECT column name list:
230 -- --------------------------------------
231 -- VA : VALUE column, (you will always see VA1).
232 -- ID : ID columns,
233 -- ME : MEANING column,
234 -- EN : ENABLED column,
235 -- SD : START_DATE column,
239 -- HL : HIERARCHY_LEVEL column,
236 -- ED : END_DATE column,
237 -- SM : SUMMARY column,
238 -- CA : COMPILED_ATTRIBUTE column,
240 -- AU : Additional User Columns,
241 -- AQ : Additional Quickpick Columns.
242 -- You can add additional user columns in Select list, if you know
243 -- these column names. Ex. : 'COL1, COL2'
244 -- Note: Seperate col names with comma, but do not add comma
245 -- after the last column name.
246 -- Make sure these columns exist in the table.
247 -- Do not include newline char in your column list.
248 -- - AQ is last in the select statement if it is included.
249 --
250 -- These are for WHERE conditions:
251 -- --------------------------------------
252 -- WW : (1 = 1) part. (you will always see WW1)
253 -- EF : Enabled Flag check,
254 -- VD : Validation Date check: This code may have 4 different values.
255 -- 0 : not checked.
256 -- 1 : only start date is checked.
257 -- 2 : only end date is checked.
258 -- 3 : both start date and end date are checked.
259 -- In general it is either 0 or 3.
260 -- Each date check is in seperate line.
261 -- By default these dates are checked against SYSDATE.
262 -- You can pass fixed dates in p_validation_date_char.
263 -- Do not forget to pass single quotes if you are passing
264 -- dates in char format.
265 -- Ex. : 'to_date(''01-01-1998'',''DD-MM-YYYY'')'
266 -- UW : User Where Clause, You can pass additional where clause.
267 -- It will be ANDed to the rest of where clause.
268 -- AW : Additional Where clause, This is the where clause defined in
269 -- Table validated value set.
270 -- - Pass independent_value (or parent value) for dependent value sets.
271 -- You don't need to use extra single quotes. Value will be single quoted.
272 -- NULL is not a valid parent value.
273 -- - Check x_success first. For return codes see g_ret_* codes above.
274 --
275 --------------------------------------------------------------
276 PROCEDURE get_independent_vset_select
277 (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
278 DEFAULT fnd_api.g_miss_char,
279 p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
280 DEFAULT fnd_api.g_miss_num,
281 --
282 -- Do you want to include these columns in SELECT statement?
283 -- VALUE column is always included.
284 -- ID and MEANING columns are included by default.
285 --
286 p_inc_id_col IN VARCHAR2 DEFAULT 'Y',
287 p_inc_meaning_col IN VARCHAR2 DEFAULT 'Y',
288 p_inc_enabled_col IN VARCHAR2 DEFAULT 'N',
289 p_inc_start_date_col IN VARCHAR2 DEFAULT 'N',
290 p_inc_end_date_col IN VARCHAR2 DEFAULT 'N',
291 p_inc_summary_col IN VARCHAR2 DEFAULT 'N',
292 p_inc_compiled_attribute_col IN VARCHAR2 DEFAULT 'N',
293 p_inc_hierarchy_level_col IN VARCHAR2 DEFAULT 'N',
294 --
295 -- Do you want to add extra checks in SELECT?
296 --
297 p_check_enabled_flag IN VARCHAR2 DEFAULT 'Y',
298 p_check_validation_date IN VARCHAR2 DEFAULT 'Y',
299 p_validation_date_char IN VARCHAR2 DEFAULT 'SYSDATE',
300 p_inc_user_where_clause IN VARCHAR2 DEFAULT 'N',
301 p_user_where_clause IN VARCHAR2 DEFAULT NULL,
302
303 x_select OUT NOCOPY VARCHAR2,
304 x_mapping_code OUT NOCOPY VARCHAR2,
305 x_success OUT NOCOPY NUMBER);
306
307
308 PROCEDURE get_dependent_vset_select
309 (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
310 DEFAULT fnd_api.g_miss_char,
311 p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
312 DEFAULT fnd_api.g_miss_num,
313 p_independent_value IN VARCHAR2 DEFAULT NULL,
314 --
315 -- Do you want to include these columns in SELECT statement?
316 -- VALUE column is always included.
317 -- ID and MEANING columns are included by default.
318 --
319 p_inc_id_col IN VARCHAR2 DEFAULT 'Y',
320 p_inc_meaning_col IN VARCHAR2 DEFAULT 'Y',
321 p_inc_enabled_col IN VARCHAR2 DEFAULT 'N',
322 p_inc_start_date_col IN VARCHAR2 DEFAULT 'N',
323 p_inc_end_date_col IN VARCHAR2 DEFAULT 'N',
324 p_inc_summary_col IN VARCHAR2 DEFAULT 'N',
325 p_inc_compiled_attribute_col IN VARCHAR2 DEFAULT 'N',
326 p_inc_hierarchy_level_col IN VARCHAR2 DEFAULT 'N',
327 --
328 -- Do you want to add extra checks in SELECT?
329 --
330 p_check_enabled_flag IN VARCHAR2 DEFAULT 'Y',
331 p_check_validation_date IN VARCHAR2 DEFAULT 'Y',
332 p_validation_date_char IN VARCHAR2 DEFAULT 'SYSDATE',
333 p_inc_user_where_clause IN VARCHAR2 DEFAULT 'N',
334 p_user_where_clause IN VARCHAR2 DEFAULT NULL,
335
336 x_select OUT NOCOPY VARCHAR2,
337 x_mapping_code OUT NOCOPY VARCHAR2,
338 x_success OUT NOCOPY NUMBER);
339
340
341 PROCEDURE get_table_vset_select
342 (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
346 --
343 DEFAULT fnd_api.g_miss_char,
344 p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
345 DEFAULT fnd_api.g_miss_num,
347 -- Do you want to include these columns in SELECT statement?
348 -- VALUE column is always included.
349 -- ID and MEANING columns are included by default.
350 --
351 p_inc_id_col IN VARCHAR2 DEFAULT 'Y',
352 p_inc_meaning_col IN VARCHAR2 DEFAULT 'Y',
353 p_inc_enabled_col IN VARCHAR2 DEFAULT 'N',
354 p_inc_start_date_col IN VARCHAR2 DEFAULT 'N',
355 p_inc_end_date_col IN VARCHAR2 DEFAULT 'N',
356 p_inc_summary_col IN VARCHAR2 DEFAULT 'N',
357 p_inc_compiled_attribute_col IN VARCHAR2 DEFAULT 'N',
358 p_inc_hierarchy_level_col IN VARCHAR2 DEFAULT 'N',
359 p_inc_addtl_user_columns IN VARCHAR2 DEFAULT 'N',
360 p_additional_user_columns IN VARCHAR2 DEFAULT NULL,
361 p_inc_addtl_quickpick_cols IN VARCHAR2 DEFAULT 'N',
362 --
363 -- Do you want to add extra checks in SELECT?
364 --
365 p_check_enabled_flag IN VARCHAR2 DEFAULT 'Y',
366 p_check_validation_date IN VARCHAR2 DEFAULT 'Y',
367 p_validation_date_char IN VARCHAR2 DEFAULT 'SYSDATE',
368 p_inc_user_where_clause IN VARCHAR2 DEFAULT 'N',
369 p_user_where_clause IN VARCHAR2 DEFAULT NULL,
370 p_inc_addtl_where_clause IN VARCHAR2 DEFAULT 'Y',
371
372 x_select OUT NOCOPY VARCHAR2,
373 x_mapping_code OUT NOCOPY VARCHAR2,
374 x_success OUT NOCOPY NUMBER);
375
376 --------------------------------------------------------------
377 -- These APIs are used mostly by AD to find out if a given TABLE, and/or
378 -- COLUMN is used by flexfield value sets.
379 --
380 -- If a table/column is in use these APIs return TRUE.
381 --
382 --------------------------------------------------------------
383 FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
384 p_table_name IN fnd_tables.table_name%TYPE,
385 x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
386
387 FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
388 p_table_name IN fnd_tables.table_name%TYPE,
389 p_column_name IN fnd_columns.column_name%TYPE,
390 x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
391
392
393 --------------------------------------------------------------
394 -- This API is used to get the hierarchy_id, when hierarchy_code
395 -- is given. These are known as Rollup Groups.
396 --
397 --------------------------------------------------------------
398 PROCEDURE get_hierarchy_id(p_flex_value_set_name IN VARCHAR2,
399 p_hierarchy_code IN VARCHAR2,
400 x_hierarchy_id OUT NOCOPY NUMBER);
401
402 --------------------------------------------------------------
403 -- These APIs are used to create/update independent/dependent value set
404 -- values.
405 --
406 -- p_flex_value_set_name - name of the value set
407 -- p_flex_value - display version of the value
408 -- p_description - description of the value
412 -- p_summary_flag - summary flag. 'Y' or 'N'
409 -- p_enabled_flag - enabled flag. 'Y' or 'N'
410 -- p_start_date_active - start date active
411 -- p_end_date_active - end date active
413 -- p_structured_hierarchy_id - rollup group id, see get_hierarchy_id
414 -- p_hierarchy_level - hierarhcy level
415 -- x_storage_value - storage version of the value.
416 --
417 -- p_parent_flex_value - parent value for a dependent vset value
418 --------------------------------------------------------------
419 PROCEDURE create_independent_vset_value
420 (p_flex_value_set_name IN VARCHAR2,
421 p_flex_value IN VARCHAR2,
422 p_description IN VARCHAR2 DEFAULT NULL,
423 p_enabled_flag IN VARCHAR2 DEFAULT 'Y',
424 p_start_date_active IN DATE DEFAULT NULL,
425 p_end_date_active IN DATE DEFAULT NULL,
426 p_summary_flag IN VARCHAR2 DEFAULT 'N',
427 p_structured_hierarchy_level IN NUMBER DEFAULT NULL,
428 p_hierarchy_level IN VARCHAR2 DEFAULT NULL,
429 x_storage_value OUT NOCOPY VARCHAR2);
430
431 PROCEDURE create_dependent_vset_value
432 (p_flex_value_set_name IN VARCHAR2,
433 p_parent_flex_value IN VARCHAR2,
434 p_flex_value IN VARCHAR2,
435 p_description IN VARCHAR2 DEFAULT NULL,
436 p_enabled_flag IN VARCHAR2 DEFAULT 'Y',
437 p_start_date_active IN DATE DEFAULT NULL,
438 p_end_date_active IN DATE DEFAULT NULL,
439 p_hierarchy_level IN VARCHAR2 DEFAULT NULL,
440 x_storage_value OUT NOCOPY VARCHAR2);
441
442 PROCEDURE update_independent_vset_value
443 (p_flex_value_set_name IN VARCHAR2,
444 p_flex_value IN VARCHAR2,
445 p_description IN VARCHAR2 DEFAULT NULL,
446 p_enabled_flag IN VARCHAR2 DEFAULT NULL,
447 p_start_date_active IN DATE DEFAULT NULL,
448 p_end_date_active IN DATE DEFAULT NULL,
449 p_summary_flag IN VARCHAR2 DEFAULT NULL,
450 p_structured_hierarchy_level IN NUMBER DEFAULT NULL,
451 p_hierarchy_level IN VARCHAR2 DEFAULT NULL,
452 x_storage_value OUT NOCOPY VARCHAR2);
453
454 PROCEDURE update_dependent_vset_value
455 (p_flex_value_set_name IN VARCHAR2,
456 p_parent_flex_value IN VARCHAR2,
457 p_flex_value IN VARCHAR2,
458 p_description IN VARCHAR2 DEFAULT NULL,
459 p_enabled_flag IN VARCHAR2 DEFAULT NULL,
460 p_start_date_active IN DATE DEFAULT NULL,
461 p_end_date_active IN DATE DEFAULT NULL,
462 p_hierarchy_level IN VARCHAR2 DEFAULT NULL,
463 x_storage_value OUT NOCOPY VARCHAR2);
464
465 --------------------------------------------------------------
466 -- This API is used to create a value hierarchy for independent value
467 -- set values
468 --
469 -- p_flex_value_set_name - name of the value set
470 -- p_parent_flex_value - the parent value (i.e. summary flag is 'Y')
471 -- p_range_attribute - 'C' for Child only, and 'P' for Parent only ranges
472 -- p_child_flex_value_low - Low value for the range
473 -- p_child_flex_value_high - High value for the range
474 --------------------------------------------------------------
475 PROCEDURE create_value_hierarchy
476 (p_flex_value_set_name IN VARCHAR2,
477 p_parent_flex_value IN VARCHAR2,
478 p_range_attribute IN VARCHAR2,
479 p_child_flex_value_low IN VARCHAR2,
480 p_child_flex_value_high IN VARCHAR2);
481
485 PROCEDURE submit_vset_hierarchy_compiler
482 --------------------------------------------------------------
483 -- This API submits Value Set Hierarchy Compiler Concurrent Program.
484 --------------------------------------------------------------
486 (p_flex_value_set_name IN VARCHAR2,
487 x_request_id OUT NOCOPY NUMBER);
488
489
490
491 PROCEDURE is_valueset_allowed(p_flex_field in VARCHAR2,
492 p_value_set_id in NUMBER,
493 p_allow_id_valuesets in VARCHAR2,
494 p_segment_name in VARCHAR2,
495 p_id_flex_num in NUMBER,
496 p_segment_num in NUMBER,
497 p_desc_flex_context_code in VARCHAR2,
498 p_column_seq_num in NUMBER,
499 p_application_column_type in VARCHAR2,
500 p_application_column_size in NUMBER);
501
502 PROCEDURE validate_table_vset(
503 p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
504 p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
505 p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
506 p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
507 p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
508 p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
509 p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
510 x_result OUT NOCOPY VARCHAR2,
511 x_message OUT NOCOPY VARCHAR2);
512
513 PROCEDURE is_value_set_allowed_dff
514 (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
515 p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
516 p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
517 p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
518 p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
519 p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
520 p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE);
521
522 PROCEDURE is_value_set_allowed_kff
523 (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
524 p_application_id IN fnd_id_flex_segments.application_id%TYPE,
525 p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
526 p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
527 p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
528 p_segment_name IN fnd_id_flex_segments.segment_name%TYPE,
529 p_segment_num IN fnd_id_flex_segments.segment_num%TYPE);
530
531 END fnd_flex_val_api;