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 2023: DEFAULT fnd_api.g_miss_char,

2019:
2020: PROCEDURE get_valueset_select
2021: (p_validation_type IN VARCHAR2,
2022: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2023: DEFAULT fnd_api.g_miss_char,
2024: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2025: DEFAULT fnd_api.g_miss_num,
2026: p_independent_value IN VARCHAR2 DEFAULT NULL,
2027: --

Line 2025: DEFAULT fnd_api.g_miss_num,

2021: (p_validation_type IN VARCHAR2,
2022: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2023: DEFAULT fnd_api.g_miss_char,
2024: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2025: DEFAULT fnd_api.g_miss_num,
2026: p_independent_value IN VARCHAR2 DEFAULT NULL,
2027: --
2028: -- Do you want to include these columns in SELECT statement?
2029: -- VALUE column is always included.

Line 2079: IF(p_value_set_name = fnd_api.g_miss_char AND

2075: x_mapping_code := NULL;
2076: --
2077: -- We really need XOR.
2078: --
2079: IF(p_value_set_name = fnd_api.g_miss_char AND
2080: p_value_set_id = fnd_api.g_miss_num)
2081: OR
2082: (p_value_set_name <> fnd_api.g_miss_char AND
2083: p_value_set_id <> fnd_api.g_miss_num)

Line 2080: p_value_set_id = fnd_api.g_miss_num)

2076: --
2077: -- We really need XOR.
2078: --
2079: IF(p_value_set_name = fnd_api.g_miss_char AND
2080: p_value_set_id = fnd_api.g_miss_num)
2081: OR
2082: (p_value_set_name <> fnd_api.g_miss_char AND
2083: p_value_set_id <> fnd_api.g_miss_num)
2084: OR

Line 2082: (p_value_set_name <> fnd_api.g_miss_char AND

2078: --
2079: IF(p_value_set_name = fnd_api.g_miss_char AND
2080: p_value_set_id = fnd_api.g_miss_num)
2081: OR
2082: (p_value_set_name <> fnd_api.g_miss_char AND
2083: p_value_set_id <> fnd_api.g_miss_num)
2084: OR
2085: (p_value_set_id IS NULL OR p_value_set_name IS NULL) THEN
2086: message(l_func_name || 'Invalid value set name or id is passed.');

Line 2083: p_value_set_id <> fnd_api.g_miss_num)

2079: IF(p_value_set_name = fnd_api.g_miss_char AND
2080: p_value_set_id = fnd_api.g_miss_num)
2081: OR
2082: (p_value_set_name <> fnd_api.g_miss_char AND
2083: p_value_set_id <> fnd_api.g_miss_num)
2084: OR
2085: (p_value_set_id IS NULL OR p_value_set_name IS NULL) THEN
2086: message(l_func_name || 'Invalid value set name or id is passed.');
2087: x_success := g_ret_invalid_parameter;

Line 2099: WHERE ( (p_value_set_id = fnd_api.g_miss_num

2095: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
2096: *
2097: INTO l_vset
2098: FROM fnd_flex_value_sets
2099: WHERE ( (p_value_set_id = fnd_api.g_miss_num
2100: AND flex_value_set_name = p_value_set_name)
2101: OR (p_value_set_name = fnd_api.g_miss_char
2102: AND flex_value_set_id = p_value_set_id));
2103: EXCEPTION

Line 2101: OR (p_value_set_name = fnd_api.g_miss_char

2097: INTO l_vset
2098: FROM fnd_flex_value_sets
2099: WHERE ( (p_value_set_id = fnd_api.g_miss_num
2100: AND flex_value_set_name = p_value_set_name)
2101: OR (p_value_set_name = fnd_api.g_miss_char
2102: AND flex_value_set_id = p_value_set_id));
2103: EXCEPTION
2104: WHEN no_data_found THEN
2105: message(l_func_name || 'Value set does not exist.');

Line 2306: DEFAULT fnd_api.g_miss_char,

2302: END get_valueset_select;
2303:
2304: PROCEDURE get_table_vset_select
2305: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2306: DEFAULT fnd_api.g_miss_char,
2307: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2308: DEFAULT fnd_api.g_miss_num,
2309: --
2310: -- Do you want to include these columns in SELECT statement?

Line 2308: DEFAULT fnd_api.g_miss_num,

2304: PROCEDURE get_table_vset_select
2305: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2306: DEFAULT fnd_api.g_miss_char,
2307: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2308: DEFAULT fnd_api.g_miss_num,
2309: --
2310: -- Do you want to include these columns in SELECT statement?
2311: -- VALUE column is always included.
2312: -- ID and MEANING columns are included by default.

Line 2384: DEFAULT fnd_api.g_miss_char,

2380: END get_table_vset_select;
2381:
2382: PROCEDURE get_independent_vset_select
2383: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2384: DEFAULT fnd_api.g_miss_char,
2385: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2386: DEFAULT fnd_api.g_miss_num,
2387: --
2388: -- Do you want to include these columns in SELECT statement?

Line 2386: DEFAULT fnd_api.g_miss_num,

2382: PROCEDURE get_independent_vset_select
2383: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2384: DEFAULT fnd_api.g_miss_char,
2385: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2386: DEFAULT fnd_api.g_miss_num,
2387: --
2388: -- Do you want to include these columns in SELECT statement?
2389: -- VALUE column is always included.
2390: -- ID and MEANING columns are included by default.

Line 2458: DEFAULT fnd_api.g_miss_char,

2454: END get_independent_vset_select;
2455:
2456: PROCEDURE get_dependent_vset_select
2457: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2458: DEFAULT fnd_api.g_miss_char,
2459: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2460: DEFAULT fnd_api.g_miss_num,
2461: p_independent_value IN VARCHAR2 DEFAULT NULL,
2462: --

Line 2460: DEFAULT fnd_api.g_miss_num,

2456: PROCEDURE get_dependent_vset_select
2457: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2458: DEFAULT fnd_api.g_miss_char,
2459: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2460: DEFAULT fnd_api.g_miss_num,
2461: p_independent_value IN VARCHAR2 DEFAULT NULL,
2462: --
2463: -- Do you want to include these columns in SELECT statement?
2464: -- VALUE column is always included.