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

2101: application_id_i := application_id_f(appl_short_name);
2102:
2103: BEGIN
2104: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2105: FROM fnd_descr_flex_col_usage_tl
2106: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2107: AND application_id = application_id_i;
2108: println('deleted from fnd_descr_col_usage_tl');
2109: END;

Line 2325: FROM fnd_descr_flex_col_usage_tl

2321: END IF;
2322:
2323: BEGIN
2324: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2325: FROM fnd_descr_flex_col_usage_tl
2326: WHERE descriptive_flex_context_code = context
2327: AND descriptive_flexfield_name = delete_context.flexfield_name
2328: AND application_id = application_id_i;
2329: println('deleted from fnd_descr_col_usage_tl');

Line 2389: FROM fnd_descr_flex_col_usage_tl t

2385: application_id_i := application_id_f(appl_short_name);
2386:
2387: BEGIN
2388: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2389: FROM fnd_descr_flex_col_usage_tl t
2390: WHERE
2391: EXISTS (SELECT *
2392: FROM fnd_descr_flex_column_usages cu
2393: WHERE cu.end_user_column_name = segment

Line 2838: fnd_descr_flex_col_usage_tl

2834: WHERE application_id = l_old_application.application_id
2835: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2836:
2837: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2838: fnd_descr_flex_col_usage_tl
2839: SET application_id = l_new_application.application_id,
2840: descriptive_flexfield_name = p_new_dff_name,
2841: last_update_date = l_last_update_date,
2842: last_updated_by = l_last_updated_by,