180: 'AFTER_CTD_PARAM_VALUES_BULK_DELETE',
181: 'CTD Param Values deleted successfully!!'
182: );
183:
184: -- delete from AMS_CTD_ADHOC_PARAM_VALUES
185: FORALL i in l_not_associated_ctd_list.FIRST .. l_not_associated_ctd_list.LAST
186: DELETE FROM AMS_CTD_ADHOC_PARAM_VALUES
187: WHERE CTD_ID = l_not_associated_ctd_list(i);
188:
182: );
183:
184: -- delete from AMS_CTD_ADHOC_PARAM_VALUES
185: FORALL i in l_not_associated_ctd_list.FIRST .. l_not_associated_ctd_list.LAST
186: DELETE FROM AMS_CTD_ADHOC_PARAM_VALUES
187: WHERE CTD_ID = l_not_associated_ctd_list(i);
188:
189: write_debug_message(FND_LOG.LEVEL_EVENT,
190: PROCEDURE_NAME,