DBA Data[Home] [Help]

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