DBA Data[Home] [Help]

APPS.FND_FLEX_DSC_API dependencies on FND_COMPILED_DESCRIPTIVE_FLEXS

Line 2175: FROM fnd_compiled_descriptive_flexs

2171: AND descriptive_flexfield_name = flexfield_name;
2172: println('deleted from fnd_default_context_fields');
2173:
2174: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2175: FROM fnd_compiled_descriptive_flexs
2176: WHERE application_id = application_id_i
2177: AND descriptive_flexfield_name = flexfield_name;
2178: println('deleted fnd_compiled_descriptive_flexs');
2179:

Line 2178: println('deleted fnd_compiled_descriptive_flexs');

2174: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2175: FROM fnd_compiled_descriptive_flexs
2176: WHERE application_id = application_id_i
2177: AND descriptive_flexfield_name = flexfield_name;
2178: println('deleted fnd_compiled_descriptive_flexs');
2179:
2180:
2181: println('deleted flexfield:' || flexfield_name);
2182: END;

Line 2860: FROM fnd_compiled_descriptive_flexs

2856: AND flexfield_name = l_old_dff.descriptive_flexfield_name
2857: AND flexfield_usage_code IN ('C','D');
2858:
2859: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2860: FROM fnd_compiled_descriptive_flexs
2861: WHERE application_id = l_old_application.application_id
2862: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2863:
2864: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */

Line 2865: FROM fnd_compiled_descriptive_flexs

2861: WHERE application_id = l_old_application.application_id
2862: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2863:
2864: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2865: FROM fnd_compiled_descriptive_flexs
2866: WHERE application_id = l_new_application.application_id
2867: AND descriptive_flexfield_name = l_new_dff.descriptive_flexfield_name;
2868: EXCEPTION
2869: WHEN OTHERS THEN