131: -- Create a new key flexfield
132: -- @return a handle to the flexfield
133: --
134: FUNCTION new_flexfield
135: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
136: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
138: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
132: -- @return a handle to the flexfield
133: --
134: FUNCTION new_flexfield
135: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
136: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
138: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
133: --
134: FUNCTION new_flexfield
135: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
136: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
138: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: FUNCTION new_flexfield
135: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
136: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
138: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
136: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
138: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
136: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
138: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
138: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
145: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
138: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
145: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
146: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
139: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
145: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
146: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
147: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
140: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
145: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
146: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
147: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
148: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
141: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
145: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
146: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
147: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
148: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
149: RETURN flexfield_type;
142: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
145: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
146: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
147: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
148: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
149: RETURN flexfield_type;
150:
143: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
145: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
146: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
147: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
148: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
149: RETURN flexfield_type;
150:
151:
144: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
145: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
146: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
147: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
148: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
149: RETURN flexfield_type;
150:
151:
152: -- find a flexfield
287: -- create a new flexfield structure.
288: FUNCTION new_structure
289: (flexfield IN flexfield_type,
290:
291: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
294: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
288: FUNCTION new_structure
289: (flexfield IN flexfield_type,
290:
291: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
294: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
289: (flexfield IN flexfield_type,
290:
291: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
294: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
290:
291: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
294: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
294: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
294: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
300: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
294: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
300: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
301: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
294: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
300: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
301: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
302: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
300: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
301: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
302: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
303: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
296: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
300: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
301: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
302: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
303: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
304: RETURN structure_type;
297: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
300: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
301: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
302: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
303: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
304: RETURN structure_type;
305:
298: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
300: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
301: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
302: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
303: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
304: RETURN structure_type;
305:
306:
299: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
300: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
301: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
302: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
303: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
304: RETURN structure_type;
305:
306:
307: -- find a flexfield structure
343: FUNCTION new_segment
344: (flexfield IN flexfield_type,
345: structure IN structure_type,
346:
347: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
348: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
349: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
350: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
351: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
344: (flexfield IN flexfield_type,
345: structure IN structure_type,
346:
347: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
348: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
349: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
350: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
351: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
352: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
345: structure IN structure_type,
346:
347: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
348: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
349: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
350: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
351: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
352: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
353: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
346:
347: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
348: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
349: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
350: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
351: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
352: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
353: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
354:
347: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
348: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
349: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
350: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
351: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
352: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
353: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
354:
355: /* validation */
348: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
349: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
350: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
351: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
352: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
353: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
354:
355: /* validation */
356: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
349: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
350: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
351: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
352: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
353: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
354:
355: /* validation */
356: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
357: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
352: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
353: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
354:
355: /* validation */
356: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
357: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
358: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
359: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
360: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
353: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
354:
355: /* validation */
356: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
357: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
358: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
359: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
360: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
361: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
354:
355: /* validation */
356: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
357: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
358: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
359: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
360: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
361: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
362:
355: /* validation */
356: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
357: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
358: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
359: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
360: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
361: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
362:
363: /* sizes */
356: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
357: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
358: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
359: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
360: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
361: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
362:
363: /* sizes */
364: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
357: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
358: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
359: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
360: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
361: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
362:
363: /* sizes */
364: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
365: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
360: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
361: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
362:
363: /* sizes */
364: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
365: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
366: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
367:
368: /* prompts */
361: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
362:
363: /* sizes */
364: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
365: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
366: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
367:
368: /* prompts */
369: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
362:
363: /* sizes */
364: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
365: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
366: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
367:
368: /* prompts */
369: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
370: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
365: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
366: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
367:
368: /* prompts */
369: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
370: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
371: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
372: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
373: RETURN segment_type;
366: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
367:
368: /* prompts */
369: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
370: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
371: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
372: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
373: RETURN segment_type;
374:
367:
368: /* prompts */
369: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
370: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
371: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
372: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
373: RETURN segment_type;
374:
375:
368: /* prompts */
369: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
370: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
371: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
372: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
373: RETURN segment_type;
374:
375:
376: -- locate a segment by its name.