DBA Data[Home] [Help]

APPS.FND_FLEX_DSC_API dependencies on FND_COMPILED_DESCRIPTIVE_FLEXS

Line 2176: FROM fnd_compiled_descriptive_flexs

2172: AND descriptive_flexfield_name = flexfield_name;
2173: println('deleted from fnd_default_context_fields');
2174:
2175: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2176: FROM fnd_compiled_descriptive_flexs
2177: WHERE application_id = application_id_i
2178: AND descriptive_flexfield_name = flexfield_name;
2179: println('deleted fnd_compiled_descriptive_flexs');
2180:

Line 2179: println('deleted fnd_compiled_descriptive_flexs');

2175: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2176: FROM fnd_compiled_descriptive_flexs
2177: WHERE application_id = application_id_i
2178: AND descriptive_flexfield_name = flexfield_name;
2179: println('deleted fnd_compiled_descriptive_flexs');
2180:
2181:
2182: println('deleted flexfield:' || flexfield_name);
2183: END;

Line 2861: FROM fnd_compiled_descriptive_flexs

2857: AND flexfield_name = l_old_dff.descriptive_flexfield_name
2858: AND flexfield_usage_code IN ('C','D');
2859:
2860: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2861: FROM fnd_compiled_descriptive_flexs
2862: WHERE application_id = l_old_application.application_id
2863: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2864:
2865: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */

Line 2866: FROM fnd_compiled_descriptive_flexs

2862: WHERE application_id = l_old_application.application_id
2863: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2864:
2865: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2866: FROM fnd_compiled_descriptive_flexs
2867: WHERE application_id = l_new_application.application_id
2868: AND descriptive_flexfield_name = l_new_dff.descriptive_flexfield_name;
2869: EXCEPTION
2870: WHEN OTHERS THEN