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.

[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 1378: FROM fnd_descr_flex_column_usages

1374: -- Is this value set used by a descriptive flexfield segment.
1375: --
1376: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1377: count(*) INTO l_row_count
1378: FROM fnd_descr_flex_column_usages
1379: WHERE flex_value_set_id = l_value_set_id;
1380:
1381: -- IF (l_row_count <> 0) THEN
1382: -- message('This value set is used in at least one of the descriptive ');

Line 1393: FROM fnd_descr_flex_column_usages

1389: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1390: application_id || ':' || descriptive_flexfield_name || ':' ||
1391: end_user_column_name
1392: INTO l_dummy_vc2
1393: FROM fnd_descr_flex_column_usages
1394: WHERE flex_value_set_id = l_value_set_id
1395: AND ROWNUM = 1;
1396: END IF;
1397: EXCEPTION

Line 1535: FROM fnd_descr_flex_column_usages

1531: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'
1532: AND descriptive_flex_context_code = p_value_set;
1533:
1534: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1535: FROM fnd_descr_flex_column_usages
1536: WHERE application_id = 0
1537: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'
1538: AND descriptive_flex_context_code = p_value_set;
1539:

Line 4142: fnd_flex_value_sets v, fnd_descr_flex_column_usages u

4138: u.column_seq_num, v.parent_flex_value_set_id
4139: INTO
4140: l_column_seq_num, l_parent_value_set_id
4141: FROM
4142: fnd_flex_value_sets v, fnd_descr_flex_column_usages u
4143: WHERE
4144: v.flex_value_set_id = p_value_set_id and
4145: -- Bug#4410208, In SRS agruments form there is no context code
4146: (p_desc_flex_context_code is null or

Line 4331: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,

4327: -- certain segment. Now we have a separate procedure for DFF/SRS.
4328:
4329: PROCEDURE is_value_set_allowed_dff
4330: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4331: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4332: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4333: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4334: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4335: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,

Line 4332: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,

4328:
4329: PROCEDURE is_value_set_allowed_dff
4330: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4331: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4332: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4333: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4334: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4335: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4336: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)

Line 4333: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,

4329: PROCEDURE is_value_set_allowed_dff
4330: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4331: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4332: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4333: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4334: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4335: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4336: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)
4337: IS

Line 4334: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,

4330: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4331: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4332: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4333: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4334: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4335: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4336: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)
4337: IS
4338: l_validation_type VARCHAR2(1);

Line 4335: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,

4331: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4332: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4333: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4334: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4335: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4336: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)
4337: IS
4338: l_validation_type VARCHAR2(1);
4339: l_format_type VARCHAR2(1);

Line 4336: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)

4332: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4333: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4334: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,
4335: p_end_user_column_name IN fnd_descr_flex_column_usages.end_user_column_name%TYPE,
4336: p_column_seq_num IN fnd_descr_flex_column_usages.column_seq_num%TYPE)
4337: IS
4338: l_validation_type VARCHAR2(1);
4339: l_format_type VARCHAR2(1);
4340: l_maximum_size NUMBER(3);

Line 4458: fnd_flex_value_sets v, fnd_descr_flex_column_usages u

4454: min(u.column_seq_num), v.parent_flex_value_set_id
4455: INTO
4456: l_column_seq_num, l_parent_value_set_id
4457: FROM
4458: fnd_flex_value_sets v, fnd_descr_flex_column_usages u
4459: WHERE
4460: v.flex_value_set_id = p_flex_value_set_id
4461: -- Bug#4564981
4462: AND u.application_id = p_application_id