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_API

Line 2034: DEFAULT fnd_api.g_miss_char,

2030:
2031: PROCEDURE get_valueset_select
2032: (p_validation_type IN VARCHAR2,
2033: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2034: DEFAULT fnd_api.g_miss_char,
2035: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2036: DEFAULT fnd_api.g_miss_num,
2037: p_independent_value IN VARCHAR2 DEFAULT NULL,
2038: --

Line 2036: DEFAULT fnd_api.g_miss_num,

2032: (p_validation_type IN VARCHAR2,
2033: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2034: DEFAULT fnd_api.g_miss_char,
2035: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2036: DEFAULT fnd_api.g_miss_num,
2037: p_independent_value IN VARCHAR2 DEFAULT NULL,
2038: --
2039: -- Do you want to include these columns in SELECT statement?
2040: -- VALUE column is always included.

Line 2090: IF(p_value_set_name = fnd_api.g_miss_char AND

2086: x_mapping_code := NULL;
2087: --
2088: -- We really need XOR.
2089: --
2090: IF(p_value_set_name = fnd_api.g_miss_char AND
2091: p_value_set_id = fnd_api.g_miss_num)
2092: OR
2093: (p_value_set_name <> fnd_api.g_miss_char AND
2094: p_value_set_id <> fnd_api.g_miss_num)

Line 2091: p_value_set_id = fnd_api.g_miss_num)

2087: --
2088: -- We really need XOR.
2089: --
2090: IF(p_value_set_name = fnd_api.g_miss_char AND
2091: p_value_set_id = fnd_api.g_miss_num)
2092: OR
2093: (p_value_set_name <> fnd_api.g_miss_char AND
2094: p_value_set_id <> fnd_api.g_miss_num)
2095: OR

Line 2093: (p_value_set_name <> fnd_api.g_miss_char AND

2089: --
2090: IF(p_value_set_name = fnd_api.g_miss_char AND
2091: p_value_set_id = fnd_api.g_miss_num)
2092: OR
2093: (p_value_set_name <> fnd_api.g_miss_char AND
2094: p_value_set_id <> fnd_api.g_miss_num)
2095: OR
2096: (p_value_set_id IS NULL OR p_value_set_name IS NULL) THEN
2097: message(l_func_name || 'Invalid value set name or id is passed.');

Line 2094: p_value_set_id <> fnd_api.g_miss_num)

2090: IF(p_value_set_name = fnd_api.g_miss_char AND
2091: p_value_set_id = fnd_api.g_miss_num)
2092: OR
2093: (p_value_set_name <> fnd_api.g_miss_char AND
2094: p_value_set_id <> fnd_api.g_miss_num)
2095: OR
2096: (p_value_set_id IS NULL OR p_value_set_name IS NULL) THEN
2097: message(l_func_name || 'Invalid value set name or id is passed.');
2098: x_success := g_ret_invalid_parameter;

Line 2110: WHERE ( (p_value_set_id = fnd_api.g_miss_num

2106: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
2107: *
2108: INTO l_vset
2109: FROM fnd_flex_value_sets
2110: WHERE ( (p_value_set_id = fnd_api.g_miss_num
2111: AND flex_value_set_name = p_value_set_name)
2112: OR (p_value_set_name = fnd_api.g_miss_char
2113: AND flex_value_set_id = p_value_set_id));
2114: EXCEPTION

Line 2112: OR (p_value_set_name = fnd_api.g_miss_char

2108: INTO l_vset
2109: FROM fnd_flex_value_sets
2110: WHERE ( (p_value_set_id = fnd_api.g_miss_num
2111: AND flex_value_set_name = p_value_set_name)
2112: OR (p_value_set_name = fnd_api.g_miss_char
2113: AND flex_value_set_id = p_value_set_id));
2114: EXCEPTION
2115: WHEN no_data_found THEN
2116: message(l_func_name || 'Value set does not exist.');

Line 2317: DEFAULT fnd_api.g_miss_char,

2313: END get_valueset_select;
2314:
2315: PROCEDURE get_table_vset_select
2316: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2317: DEFAULT fnd_api.g_miss_char,
2318: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2319: DEFAULT fnd_api.g_miss_num,
2320: --
2321: -- Do you want to include these columns in SELECT statement?

Line 2319: DEFAULT fnd_api.g_miss_num,

2315: PROCEDURE get_table_vset_select
2316: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2317: DEFAULT fnd_api.g_miss_char,
2318: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2319: DEFAULT fnd_api.g_miss_num,
2320: --
2321: -- Do you want to include these columns in SELECT statement?
2322: -- VALUE column is always included.
2323: -- ID and MEANING columns are included by default.

Line 2395: DEFAULT fnd_api.g_miss_char,

2391: END get_table_vset_select;
2392:
2393: PROCEDURE get_independent_vset_select
2394: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2395: DEFAULT fnd_api.g_miss_char,
2396: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2397: DEFAULT fnd_api.g_miss_num,
2398: --
2399: -- Do you want to include these columns in SELECT statement?

Line 2397: DEFAULT fnd_api.g_miss_num,

2393: PROCEDURE get_independent_vset_select
2394: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2395: DEFAULT fnd_api.g_miss_char,
2396: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2397: DEFAULT fnd_api.g_miss_num,
2398: --
2399: -- Do you want to include these columns in SELECT statement?
2400: -- VALUE column is always included.
2401: -- ID and MEANING columns are included by default.

Line 2469: DEFAULT fnd_api.g_miss_char,

2465: END get_independent_vset_select;
2466:
2467: PROCEDURE get_dependent_vset_select
2468: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2469: DEFAULT fnd_api.g_miss_char,
2470: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2471: DEFAULT fnd_api.g_miss_num,
2472: p_independent_value IN VARCHAR2 DEFAULT NULL,
2473: --

Line 2471: DEFAULT fnd_api.g_miss_num,

2467: PROCEDURE get_dependent_vset_select
2468: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2469: DEFAULT fnd_api.g_miss_char,
2470: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2471: DEFAULT fnd_api.g_miss_num,
2472: p_independent_value IN VARCHAR2 DEFAULT NULL,
2473: --
2474: -- Do you want to include these columns in SELECT statement?
2475: -- VALUE column is always included.