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_VALUES

Line 8: SUBTYPE value_type IS fnd_flex_values_vl%ROWTYPE;

4:
5: chr_newline CONSTANT VARCHAR2(8) := fnd_global.newline;
6:
7: SUBTYPE vset_type IS fnd_flex_value_sets%ROWTYPE;
8: SUBTYPE value_type IS fnd_flex_values_vl%ROWTYPE;
9:
10: TYPE bind_record_type IS RECORD
11: (pos number,
12: type VARCHAR2(1));

Line 1426: FROM fnd_flex_values_tl

1422: --
1423:
1424: <>
1425: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1426: FROM fnd_flex_values_tl
1427: WHERE flex_value_id IN
1428: (SELECT flex_value_id FROM fnd_flex_values
1429: WHERE flex_value_set_id = l_value_set_id);
1430:

Line 1428: (SELECT flex_value_id FROM fnd_flex_values

1424: <>
1425: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1426: FROM fnd_flex_values_tl
1427: WHERE flex_value_id IN
1428: (SELECT flex_value_id FROM fnd_flex_values
1429: WHERE flex_value_set_id = l_value_set_id);
1430:
1431: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1432: FROM fnd_flex_values

Line 1432: FROM fnd_flex_values

1428: (SELECT flex_value_id FROM fnd_flex_values
1429: WHERE flex_value_set_id = l_value_set_id);
1430:
1431: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1432: FROM fnd_flex_values
1433: WHERE flex_value_set_id = l_value_set_id;
1434:
1435: --
1436: -- Delete Value rules.

Line 1504: -- Delete the FND_FLEX_VALUES Descriptive Flexfield context associated

1500: FROM fnd_flex_value_sets
1501: WHERE flex_value_set_id = l_value_set_id;
1502:
1503: --
1504: -- Delete the FND_FLEX_VALUES Descriptive Flexfield context associated
1505: -- to this value set.
1506: --
1507: -- At this point it is better to call
1508: -- fnd_flex_dsc_api.delete_context('FND',value_set);

Line 1514: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'

1510: --
1511: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1512: FROM fnd_descr_flex_contexts
1513: WHERE application_id = 0
1514: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'
1515: AND descriptive_flex_context_code = p_value_set;
1516:
1517: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1518: FROM fnd_descr_flex_contexts_TL

Line 1520: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'

1516:
1517: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1518: FROM fnd_descr_flex_contexts_TL
1519: WHERE application_id = 0
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

Line 1526: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'

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:
1529: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1530: FROM fnd_descr_flex_col_usage_TL

Line 1532: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'

1528:
1529: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1530: FROM fnd_descr_flex_col_usage_TL
1531: WHERE application_id = 0
1532: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'
1533: AND descriptive_flex_context_code = p_value_set;
1534:
1535: EXCEPTION
1536: WHEN OTHERS THEN

Line 2139: l_tvset.application_table_name := 'FND_FLEX_VALUES_VL';

2135: x_success := g_ret_others;
2136: RETURN;
2137: END;
2138: ELSIF (l_vset.validation_type IN ('I','D')) THEN
2139: l_tvset.application_table_name := 'FND_FLEX_VALUES_VL';
2140:
2141: l_tvset.value_column_name := 'FLEX_VALUE';
2142: l_tvset.value_column_type := 'V';
2143: l_tvset.value_column_size := 150;

Line 2760: FROM fnd_flex_values

2756: BEGIN
2757: IF (p_vset.validation_type = 'I') THEN
2758: SELECT COUNT(*)
2759: INTO l_count
2760: FROM fnd_flex_values
2761: WHERE flex_value_set_id = p_vset.flex_value_set_id
2762: AND flex_value = p_flex_value
2763: AND ROWNUM = 1;
2764:

Line 2768: FROM fnd_flex_values

2764:
2765: ELSIF (p_vset.validation_type = 'D') THEN
2766: SELECT COUNT(*)
2767: INTO l_count
2768: FROM fnd_flex_values
2769: WHERE flex_value_set_id = p_vset.flex_value_set_id
2770: AND parent_flex_value_low = p_parent_value
2771: AND flex_value = p_flex_value
2772: AND ROWNUM = 1;

Line 2800: FROM fnd_flex_values_vl

2796: IF (p_vset.validation_type = 'I') THEN
2797: BEGIN
2798: SELECT *
2799: INTO px_value
2800: FROM fnd_flex_values_vl
2801: WHERE flex_value_set_id = p_vset.flex_value_set_id
2802: AND flex_value = p_flex_value;
2803: EXCEPTION
2804: WHEN OTHERS THEN

Line 2813: FROM fnd_flex_values_vl

2809: ELSIF (p_vset.validation_type = 'D') THEN
2810: BEGIN
2811: SELECT *
2812: INTO px_value
2813: FROM fnd_flex_values_vl
2814: WHERE flex_value_set_id = p_vset.flex_value_set_id
2815: AND parent_flex_value_low = p_parent_value
2816: AND flex_value = p_flex_value;
2817: EXCEPTION

Line 2921: fnd_flex_values_pkg.load_row

2917:
2918: -- Ready to insert/update
2919:
2920: BEGIN
2921: fnd_flex_values_pkg.load_row
2922: (x_flex_value_set_name => p_vset.flex_value_set_name,
2923: x_parent_flex_value_low => p_value.parent_flex_value_low,
2924: x_flex_value => p_value.flex_value,
2925: x_who => l_who,