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_DESCR_FLEX_COLUMN_USAGES

Line 1367: FROM fnd_descr_flex_column_usages

1363: -- Is this value set used by a descriptive flexfield segment.
1364: --
1365: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1366: count(*) INTO l_row_count
1367: FROM fnd_descr_flex_column_usages
1368: WHERE flex_value_set_id = l_value_set_id;
1369:
1370: -- IF (l_row_count <> 0) THEN
1371: -- message('This value set is used in at least one of the descriptive ');

Line 1382: FROM fnd_descr_flex_column_usages

1378: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1379: application_id || ':' || descriptive_flexfield_name || ':' ||
1380: end_user_column_name
1381: INTO l_dummy_vc2
1382: FROM fnd_descr_flex_column_usages
1383: WHERE flex_value_set_id = l_value_set_id
1384: AND ROWNUM = 1;
1385: END IF;
1386: EXCEPTION

Line 1524: FROM fnd_descr_flex_column_usages

1520: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'
1521: AND descriptive_flex_context_code = p_value_set;
1522:
1523: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1524: FROM fnd_descr_flex_column_usages
1525: WHERE application_id = 0
1526: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'
1527: AND descriptive_flex_context_code = p_value_set;
1528:

Line 4014: fnd_flex_value_sets v, fnd_descr_flex_column_usages u

4010: u.column_seq_num, v.parent_flex_value_set_id
4011: INTO
4012: l_column_seq_num, l_parent_value_set_id
4013: FROM
4014: fnd_flex_value_sets v, fnd_descr_flex_column_usages u
4015: WHERE
4016: v.flex_value_set_id = p_value_set_id and
4017: -- Bug#4410208, In SRS agruments form there is no context code
4018: (p_desc_flex_context_code is null or

Line 4203: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,

4199: -- certain segment. Now we have a separate procedure for DFF/SRS.
4200:
4201: PROCEDURE is_value_set_allowed_dff
4202: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4203: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4204: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4205: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4206: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4207: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,

Line 4204: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,

4200:
4201: PROCEDURE is_value_set_allowed_dff
4202: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4203: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4204: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4205: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4206: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4207: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4208: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)

Line 4205: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,

4201: PROCEDURE is_value_set_allowed_dff
4202: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4203: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4204: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4205: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4206: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4207: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4208: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)
4209: IS

Line 4206: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,

4202: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4203: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4204: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4205: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4206: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4207: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4208: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)
4209: IS
4210: l_validation_type VARCHAR2(1);

Line 4207: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,

4203: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4204: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4205: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4206: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4207: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4208: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)
4209: IS
4210: l_validation_type VARCHAR2(1);
4211: l_format_type VARCHAR2(1);

Line 4208: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)

4204: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4205: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4206: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4207: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4208: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)
4209: IS
4210: l_validation_type VARCHAR2(1);
4211: l_format_type VARCHAR2(1);
4212: l_maximum_size NUMBER(3);

Line 4330: fnd_flex_value_sets v, fnd_descr_flex_column_usages u

4326: min(u.column_seq_num), v.parent_flex_value_set_id
4327: INTO
4328: l_column_seq_num, l_parent_value_set_id
4329: FROM
4330: fnd_flex_value_sets v, fnd_descr_flex_column_usages u
4331: WHERE
4332: v.flex_value_set_id = p_flex_value_set_id
4333: -- Bug#4564981
4334: AND u.application_id = p_application_id