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.10 2011/12/12 15:31:39 hgeorgi 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.10 2011/12/12 15:31:39 hgeorgi 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.10 2011/12/12 15:31:39 hgeorgi 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.10 2011/12/12 15:31:39 hgeorgi 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 2121: FROM fnd_descr_flex_contexts_tl

2117: END;
2118:
2119: BEGIN
2120: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2121: FROM fnd_descr_flex_contexts_tl
2122: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2123: AND application_id = application_id_i;
2124: println('deleted from fnd_descr_flex_contexts_tl');
2125: END;

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

2120: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2121: FROM fnd_descr_flex_contexts_tl
2122: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2123: AND application_id = application_id_i;
2124: println('deleted from fnd_descr_flex_contexts_tl');
2125: END;
2126:
2127: BEGIN
2128: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */

Line 2129: FROM fnd_descr_flex_contexts

2125: END;
2126:
2127: BEGIN
2128: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2129: FROM fnd_descr_flex_contexts
2130: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2131: AND application_id = application_id_i;
2132: println('deleted from fnd_descr_flex_contexts');
2133: END;

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

2128: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2129: FROM fnd_descr_flex_contexts
2130: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2131: AND application_id = application_id_i;
2132: println('deleted from fnd_descr_flex_contexts');
2133: END;
2134:
2135: BEGIN
2136: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */

Line 2205: fnd_descr_flex_contexts

2201: ELSE
2202: enabled_flag_i := 'N';
2203: END IF;
2204: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2205: fnd_descr_flex_contexts
2206: SET enabled_flag = enabled_flag_i
2207: WHERE descriptive_flex_context_code = context
2208: AND descriptive_flexfield_name = flexfield_name
2209: AND application_id = application_id_i;

Line 2231: l_dflex_contexts_tl fnd_descr_flex_contexts_tl%ROWTYPE;

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

Line 2232: l_enabled_flag fnd_descr_flex_contexts.enabled_flag%TYPE;

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

Line 2250: from fnd_descr_flex_contexts_tl

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

Line 2256: UPDATE fnd_descr_flex_contexts_tl

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

Line 2267: SELECT enabled_flag into l_enabled_flag from fnd_descr_flex_contexts

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

Line 2272: UPDATE fnd_descr_flex_contexts

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

Line 2349: FROM fnd_descr_flex_contexts_tl

2345: END;
2346:
2347: BEGIN
2348: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2349: FROM fnd_descr_flex_contexts_tl
2350: WHERE descriptive_flex_context_code = context
2351: AND descriptive_flexfield_name = delete_context.flexfield_name
2352: AND application_id = application_id_i;
2353: println('deleted from fnd_descr_flex_contexts_tl');

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

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

Line 2361: FROM fnd_descr_flex_contexts

2357: END;
2358:
2359: BEGIN
2360: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2361: FROM fnd_descr_flex_contexts
2362: WHERE descriptive_flex_context_code = context
2363: AND descriptive_flexfield_name = delete_context.flexfield_name
2364: AND application_id = application_id_i;
2365: println('deleted from fnd_descr_flex_contexts');

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

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

Line 2808: fnd_descr_flex_contexts

2804: WHERE application_id = l_old_application.application_id
2805: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2806:
2807: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2808: fnd_descr_flex_contexts
2809: SET application_id = l_new_application.application_id,
2810: descriptive_flexfield_name = p_new_dff_name,
2811: last_update_date = l_last_update_date,
2812: last_updated_by = l_last_updated_by,

Line 2818: fnd_descr_flex_contexts_tl

2814: WHERE application_id = l_old_application.application_id
2815: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2816:
2817: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2818: fnd_descr_flex_contexts_tl
2819: SET application_id = l_new_application.application_id,
2820: descriptive_flexfield_name = p_new_dff_name,
2821: last_update_date = l_last_update_date,
2822: last_updated_by = l_last_updated_by,