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: SUBTYPE noview_value_type IS fnd_flex_values%ROWTYPE;
10:
11: TYPE bind_record_type IS RECORD
12: (pos number,

Line 9: SUBTYPE noview_value_type IS fnd_flex_values%ROWTYPE;

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: SUBTYPE noview_value_type IS fnd_flex_values%ROWTYPE;
10:
11: TYPE bind_record_type IS RECORD
12: (pos number,
13: type VARCHAR2(1));

Line 1437: FROM fnd_flex_values_tl

1433: --
1434:
1435: <>
1436: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1437: FROM fnd_flex_values_tl
1438: WHERE flex_value_id IN
1439: (SELECT flex_value_id FROM fnd_flex_values
1440: WHERE flex_value_set_id = l_value_set_id);
1441:

Line 1439: (SELECT flex_value_id FROM fnd_flex_values

1435: <>
1436: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1437: FROM fnd_flex_values_tl
1438: WHERE flex_value_id IN
1439: (SELECT flex_value_id FROM fnd_flex_values
1440: WHERE flex_value_set_id = l_value_set_id);
1441:
1442: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1443: FROM fnd_flex_values

Line 1443: FROM fnd_flex_values

1439: (SELECT flex_value_id FROM fnd_flex_values
1440: WHERE flex_value_set_id = l_value_set_id);
1441:
1442: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1443: FROM fnd_flex_values
1444: WHERE flex_value_set_id = l_value_set_id;
1445:
1446: --
1447: -- Delete Value rules.

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

1511: FROM fnd_flex_value_sets
1512: WHERE flex_value_set_id = l_value_set_id;
1513:
1514: --
1515: -- Delete the FND_FLEX_VALUES Descriptive Flexfield context associated
1516: -- to this value set.
1517: --
1518: -- At this point it is better to call
1519: -- fnd_flex_dsc_api.delete_context('FND',value_set);

Line 1525: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'

1521: --
1522: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1523: FROM fnd_descr_flex_contexts
1524: WHERE application_id = 0
1525: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'
1526: AND descriptive_flex_context_code = p_value_set;
1527:
1528: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1529: FROM fnd_descr_flex_contexts_TL

Line 1531: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'

1527:
1528: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1529: FROM fnd_descr_flex_contexts_TL
1530: WHERE application_id = 0
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

Line 1537: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'

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:
1540: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1541: FROM fnd_descr_flex_col_usage_TL

Line 1543: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'

1539:
1540: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1541: FROM fnd_descr_flex_col_usage_TL
1542: WHERE application_id = 0
1543: AND descriptive_flexfield_name = 'FND_FLEX_VALUES'
1544: AND descriptive_flex_context_code = p_value_set;
1545:
1546: EXCEPTION
1547: WHEN OTHERS THEN

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

2146: x_success := g_ret_others;
2147: RETURN;
2148: END;
2149: ELSIF (l_vset.validation_type IN ('I','D')) THEN
2150: l_tvset.application_table_name := 'FND_FLEX_VALUES_VL';
2151:
2152: l_tvset.value_column_name := 'FLEX_VALUE';
2153: l_tvset.value_column_type := 'V';
2154: l_tvset.value_column_size := 150;

Line 2771: FROM fnd_flex_values

2767: BEGIN
2768: IF (p_vset.validation_type = 'I') THEN
2769: SELECT COUNT(*)
2770: INTO l_count
2771: FROM fnd_flex_values
2772: WHERE flex_value_set_id = p_vset.flex_value_set_id
2773: AND flex_value = p_flex_value
2774: AND ROWNUM = 1;
2775:

Line 2779: FROM fnd_flex_values

2775:
2776: ELSIF (p_vset.validation_type = 'D') THEN
2777: SELECT COUNT(*)
2778: INTO l_count
2779: FROM fnd_flex_values
2780: WHERE flex_value_set_id = p_vset.flex_value_set_id
2781: AND parent_flex_value_low = p_parent_value
2782: AND flex_value = p_flex_value
2783: AND ROWNUM = 1;

Line 2801: When a value record exists in fnd_flex_values table, but not in

2797:
2798: END check_value_existance;
2799:
2800: /*-------------------------------------------------------------------
2801: When a value record exists in fnd_flex_values table, but not in
2802: fnd_flex_values_tl, the record also does not exist in the view,
2803: fnd_flex_values_vl. We read the existing value from fnd_flex_values,
2804: then copy the column contents to the view record for further processing
2805: --------------------------------------------------------------------*/

Line 2802: fnd_flex_values_tl, the record also does not exist in the view,

2798: END check_value_existance;
2799:
2800: /*-------------------------------------------------------------------
2801: When a value record exists in fnd_flex_values table, but not in
2802: fnd_flex_values_tl, the record also does not exist in the view,
2803: fnd_flex_values_vl. We read the existing value from fnd_flex_values,
2804: then copy the column contents to the view record for further processing
2805: --------------------------------------------------------------------*/
2806: PROCEDURE copy_to_px_value(v_value IN noview_value_type,

Line 2803: fnd_flex_values_vl. We read the existing value from fnd_flex_values,

2799:
2800: /*-------------------------------------------------------------------
2801: When a value record exists in fnd_flex_values table, but not in
2802: fnd_flex_values_tl, the record also does not exist in the view,
2803: fnd_flex_values_vl. We read the existing value from fnd_flex_values,
2804: then copy the column contents to the view record for further processing
2805: --------------------------------------------------------------------*/
2806: PROCEDURE copy_to_px_value(v_value IN noview_value_type,
2807: px_value IN OUT nocopy value_type)

Line 2899: FROM fnd_flex_values_vl

2895: IF (p_vset.validation_type = 'I') THEN
2896: BEGIN
2897: SELECT *
2898: INTO px_value
2899: FROM fnd_flex_values_vl
2900: WHERE flex_value_set_id = p_vset.flex_value_set_id
2901: AND flex_value = p_flex_value;
2902: EXCEPTION
2903: WHEN no_data_found THEN

Line 2907: FROM fnd_flex_values

2903: WHEN no_data_found THEN
2904: BEGIN
2905: SELECT *
2906: INTO v_value
2907: FROM fnd_flex_values
2908: WHERE flex_value_set_id = p_vset.flex_value_set_id
2909: AND flex_value = p_flex_value;
2910: copy_to_px_value(v_value, px_value);
2911: EXCEPTION

Line 2926: FROM fnd_flex_values_vl

2922: ELSIF (p_vset.validation_type = 'D') THEN
2923: BEGIN
2924: SELECT *
2925: INTO px_value
2926: FROM fnd_flex_values_vl
2927: WHERE flex_value_set_id = p_vset.flex_value_set_id
2928: AND parent_flex_value_low = p_parent_value
2929: AND flex_value = p_flex_value;
2930: EXCEPTION

Line 2935: FROM fnd_flex_values

2931: WHEN no_data_found THEN
2932: BEGIN
2933: SELECT *
2934: INTO v_value
2935: FROM fnd_flex_values
2936: WHERE flex_value_set_id = p_vset.flex_value_set_id
2937: AND parent_flex_value_low = p_parent_value
2938: AND flex_value = p_flex_value;
2939: copy_to_px_value(v_value, px_value);

Line 3049: fnd_flex_values_pkg.load_row

3045:
3046: -- Ready to insert/update
3047:
3048: BEGIN
3049: fnd_flex_values_pkg.load_row
3050: (x_flex_value_set_name => p_vset.flex_value_set_name,
3051: x_parent_flex_value_low => p_value.parent_flex_value_low,
3052: x_flex_value => p_value.flex_value,
3053: x_who => l_who,