DBA Data[Home] [Help]

APPS.FND_FLEX_DSC_API dependencies on FND_DESCR_FLEX_COL_USAGE_TL

Line 762: INTO fnd_descr_flex_col_usage_tl(application_id,

758: BEGIN
759: FOR lang_rec IN lang_cur
760: LOOP
761: INSERT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
762: INTO fnd_descr_flex_col_usage_tl(application_id,
763: descriptive_flexfield_name,
764: descriptive_flex_context_code,
765: application_column_name,
766: form_left_prompt,

Line 2104: FROM fnd_descr_flex_col_usage_tl

2100: application_id_i := application_id_f(appl_short_name);
2101:
2102: BEGIN
2103: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2104: FROM fnd_descr_flex_col_usage_tl
2105: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2106: AND application_id = application_id_i;
2107: println('deleted from fnd_descr_col_usage_tl');
2108: END;

Line 2324: FROM fnd_descr_flex_col_usage_tl

2320: END IF;
2321:
2322: BEGIN
2323: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2324: FROM fnd_descr_flex_col_usage_tl
2325: WHERE descriptive_flex_context_code = context
2326: AND descriptive_flexfield_name = delete_context.flexfield_name
2327: AND application_id = application_id_i;
2328: println('deleted from fnd_descr_col_usage_tl');

Line 2388: FROM fnd_descr_flex_col_usage_tl t

2384: application_id_i := application_id_f(appl_short_name);
2385:
2386: BEGIN
2387: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2388: FROM fnd_descr_flex_col_usage_tl t
2389: WHERE
2390: EXISTS (SELECT *
2391: FROM fnd_descr_flex_column_usages cu
2392: WHERE cu.end_user_column_name = segment

Line 2837: fnd_descr_flex_col_usage_tl

2833: WHERE application_id = l_old_application.application_id
2834: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2835:
2836: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2837: fnd_descr_flex_col_usage_tl
2838: SET application_id = l_new_application.application_id,
2839: descriptive_flexfield_name = p_new_dff_name,
2840: last_update_date = l_last_update_date,
2841: last_updated_by = l_last_updated_by,