eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_VALUE_SETS

Line 206: maxsize IN fnd_flex_value_sets.maximum_size%TYPE);

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: --------------------------------------------------------------

Line 277: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

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: --

Line 279: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

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.

Line 309: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

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,

Line 311: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

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?

Line 342: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

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
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,
346: --

Line 344: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

340:
341: PROCEDURE get_table_vset_select
342: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
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,
346: --
347: -- Do you want to include these columns in SELECT statement?
348: -- VALUE column is always included.

Line 503: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,

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,

Line 514: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%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,

Line 523: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%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,