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_DSC_API dependencies on FND_DESCR_FLEX_CONTEXTS

Line 289: FROM fnd_descr_flex_contexts

285: dummy NUMBER(1);
286: BEGIN
287: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
288: NULL INTO dummy
289: FROM fnd_descr_flex_contexts
290: WHERE application_id = application_id_in
291: AND descriptive_flexfield_name = descriptive_flexfield_name_in
292: AND descriptive_flex_context_code = descr_flex_context_code_in;
293: EXCEPTION

Line 543: INTO fnd_descr_flex_contexts(application_id,

539: created_by fnd_flex_value_sets.created_by%TYPE
540: := created_by_f;
541: BEGIN
542: INSERT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
543: INTO fnd_descr_flex_contexts(application_id,
544: descriptive_flexfield_name,
545: descriptive_flex_context_code,
546: last_update_date,
547: last_updated_by,

Line 605: INTO fnd_descr_flex_contexts_tl(application_id,

601: println('lang_rec.language_code=' ||
602: lang_rec.language_code);
603: -- println('userenv('LANG')=' || userenv('LANG'));
604: INSERT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
605: INTO fnd_descr_flex_contexts_tl(application_id,
606: descriptive_flexfield_name,
607: descriptive_flex_context_code,
608: descriptive_flex_context_name,
609: description,

Line 632: message('insert to fnd_descr_flex_contexts failed - ' ||

628: userenv('LANG'));
629: END LOOP;
630: EXCEPTION
631: WHEN dup_val_on_index THEN
632: message('insert to fnd_descr_flex_contexts failed - ' ||
633: 'duplicate value on index');
634: RAISE bad_parameter;
635: WHEN value_too_large THEN
636: message('insert to fnd_descr_flex_contexts failed - ' ||

Line 636: message('insert to fnd_descr_flex_contexts failed - ' ||

632: message('insert to fnd_descr_flex_contexts failed - ' ||
633: 'duplicate value on index');
634: RAISE bad_parameter;
635: WHEN value_too_large THEN
636: message('insert to fnd_descr_flex_contexts failed - ' ||
637: 'value too large');
638: RAISE bad_parameter;
639: WHEN OTHERS THEN
640: message('insmul_descr_flex_contexts_tl: ' || Sqlerrm);

Line 853: fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

849: descr_flex_context_code_in IN VARCHAR2,
850: application_column_name_in IN VARCHAR2)
851: IS
852: global_context_code_i
853: fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
854: srsprefix VARCHAR2(10) := '$SRS$.';
855: dummy NUMBER(1);
856: BEGIN
857: -- check whether the column name is usable with this

Line 893: FROM fnd_descr_flex_contexts

889: BEGIN
890: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
891: descriptive_flex_context_code
892: INTO global_context_code_i
893: FROM fnd_descr_flex_contexts
894: WHERE application_id = application_id_in
895: AND descriptive_flexfield_name = descriptive_flexfield_name_in
896: AND global_flag = 'Y';
897: EXCEPTION

Line 2120: FROM fnd_descr_flex_contexts_tl

2116: END;
2117:
2118: BEGIN
2119: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2120: FROM fnd_descr_flex_contexts_tl
2121: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2122: AND application_id = application_id_i;
2123: println('deleted from fnd_descr_flex_contexts_tl');
2124: END;

Line 2123: println('deleted from fnd_descr_flex_contexts_tl');

2119: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2120: FROM fnd_descr_flex_contexts_tl
2121: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2122: AND application_id = application_id_i;
2123: println('deleted from fnd_descr_flex_contexts_tl');
2124: END;
2125:
2126: BEGIN
2127: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */

Line 2128: FROM fnd_descr_flex_contexts

2124: END;
2125:
2126: BEGIN
2127: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2128: FROM fnd_descr_flex_contexts
2129: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2130: AND application_id = application_id_i;
2131: println('deleted from fnd_descr_flex_contexts');
2132: END;

Line 2131: println('deleted from fnd_descr_flex_contexts');

2127: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2128: FROM fnd_descr_flex_contexts
2129: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2130: AND application_id = application_id_i;
2131: println('deleted from fnd_descr_flex_contexts');
2132: END;
2133:
2134: BEGIN
2135: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */

Line 2204: fnd_descr_flex_contexts

2200: ELSE
2201: enabled_flag_i := 'N';
2202: END IF;
2203: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2204: fnd_descr_flex_contexts
2205: SET enabled_flag = enabled_flag_i
2206: WHERE descriptive_flex_context_code = context
2207: AND descriptive_flexfield_name = flexfield_name
2208: AND application_id = application_id_i;

Line 2230: l_dflex_contexts_tl fnd_descr_flex_contexts_tl%ROWTYPE;

2226: IS
2227: l_application_id fnd_application.application_id%TYPE;
2228: l_boolean_flag1 BOOLEAN;
2229: l_lang_exists NUMBER;
2230: l_dflex_contexts_tl fnd_descr_flex_contexts_tl%ROWTYPE;
2231: l_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
2232: BEGIN
2233: begin
2234: select 1 into l_lang_exists from fnd_languages where

Line 2231: l_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;

2227: l_application_id fnd_application.application_id%TYPE;
2228: l_boolean_flag1 BOOLEAN;
2229: l_lang_exists NUMBER;
2230: l_dflex_contexts_tl fnd_descr_flex_contexts_tl%ROWTYPE;
2231: l_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;
2232: BEGIN
2233: begin
2234: select 1 into l_lang_exists from fnd_languages where
2235: language_code = p_language and installed_flag in ('B','I') and rownum < 2;

Line 2249: from fnd_descr_flex_contexts_tl

2245: IF (not(p_desc_flex_context_name is NULL AND p_description is NULL and p_enabled_flag is NULL)) THEN
2246: l_application_id := application_id_f(p_appl_short_name);
2247: IF (not(p_desc_flex_context_name is NULL AND p_description is NULL)) THEN
2248: SELECT * into l_dflex_contexts_tl
2249: from fnd_descr_flex_contexts_tl
2250: WHERE descriptive_flex_context_code = p_desc_flex_context_code
2251: AND descriptive_flexfield_name = p_flexfield_name
2252: AND application_id = l_application_id
2253: AND language = p_language;

Line 2255: UPDATE fnd_descr_flex_contexts_tl

2251: AND descriptive_flexfield_name = p_flexfield_name
2252: AND application_id = l_application_id
2253: AND language = p_language;
2254:
2255: UPDATE fnd_descr_flex_contexts_tl
2256: SET descriptive_flex_context_name = nvl(p_desc_flex_context_name, l_dflex_contexts_tl.descriptive_flex_context_name),
2257: description = nvl(p_description, l_dflex_contexts_tl.description)
2258: WHERE descriptive_flex_context_code = p_desc_flex_context_code
2259: AND descriptive_flexfield_name = p_flexfield_name

Line 2266: SELECT enabled_flag into l_enabled_flag from fnd_descr_flex_contexts

2262: END IF;
2263:
2264: IF (p_enabled_flag is not NULL) THEN
2265: IF (p_enabled_flag in ('Y','N')) THEN
2266: SELECT enabled_flag into l_enabled_flag from fnd_descr_flex_contexts
2267: WHERE descriptive_flex_context_code = p_desc_flex_context_code
2268: AND descriptive_flexfield_name = p_flexfield_name
2269: AND application_id = l_application_id;
2270:

Line 2271: UPDATE fnd_descr_flex_contexts

2267: WHERE descriptive_flex_context_code = p_desc_flex_context_code
2268: AND descriptive_flexfield_name = p_flexfield_name
2269: AND application_id = l_application_id;
2270:
2271: UPDATE fnd_descr_flex_contexts
2272: SET enabled_flag = nvl(p_enabled_flag, l_enabled_flag)
2273: WHERE descriptive_flex_context_code = p_desc_flex_context_code
2274: AND descriptive_flexfield_name = p_flexfield_name
2275: AND application_id = l_application_id;

Line 2348: FROM fnd_descr_flex_contexts_tl

2344: END;
2345:
2346: BEGIN
2347: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2348: FROM fnd_descr_flex_contexts_tl
2349: WHERE descriptive_flex_context_code = context
2350: AND descriptive_flexfield_name = delete_context.flexfield_name
2351: AND application_id = application_id_i;
2352: println('deleted from fnd_descr_flex_contexts_tl');

Line 2352: println('deleted from fnd_descr_flex_contexts_tl');

2348: FROM fnd_descr_flex_contexts_tl
2349: WHERE descriptive_flex_context_code = context
2350: AND descriptive_flexfield_name = delete_context.flexfield_name
2351: AND application_id = application_id_i;
2352: println('deleted from fnd_descr_flex_contexts_tl');
2353: EXCEPTION
2354: WHEN no_data_found THEN
2355: NULL;
2356: END;

Line 2360: FROM fnd_descr_flex_contexts

2356: END;
2357:
2358: BEGIN
2359: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2360: FROM fnd_descr_flex_contexts
2361: WHERE descriptive_flex_context_code = context
2362: AND descriptive_flexfield_name = delete_context.flexfield_name
2363: AND application_id = application_id_i;
2364: println('deleted from fnd_descr_flex_contexts');

Line 2364: println('deleted from fnd_descr_flex_contexts');

2360: FROM fnd_descr_flex_contexts
2361: WHERE descriptive_flex_context_code = context
2362: AND descriptive_flexfield_name = delete_context.flexfield_name
2363: AND application_id = application_id_i;
2364: println('deleted from fnd_descr_flex_contexts');
2365: EXCEPTION
2366: WHEN no_data_found THEN
2367: NULL;
2368: END;

Line 2807: fnd_descr_flex_contexts

2803: WHERE application_id = l_old_application.application_id
2804: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2805:
2806: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2807: fnd_descr_flex_contexts
2808: SET application_id = l_new_application.application_id,
2809: descriptive_flexfield_name = p_new_dff_name,
2810: last_update_date = l_last_update_date,
2811: last_updated_by = l_last_updated_by,

Line 2817: fnd_descr_flex_contexts_tl

2813: WHERE application_id = l_old_application.application_id
2814: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2815:
2816: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2817: fnd_descr_flex_contexts_tl
2818: SET application_id = l_new_application.application_id,
2819: descriptive_flexfield_name = p_new_dff_name,
2820: last_update_date = l_last_update_date,
2821: last_updated_by = l_last_updated_by,