APPS.FND_FLEX_DSC_API dependencies on FND_DESCR_FLEX_CONTEXTS_TL

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 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 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 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 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 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,