3333: EXCEPTION WHEN NO_DATA_FOUND THEN
3334: RETURN;
3335: END;
3336:
3337: --delete from PON_TE_RECIPIENTS
3338: DELETE FROM
3339: PON_TE_RECIPIENTS
3340: WHERE
3341: ENTRY_ID IN ( SELECT ENTRY_ID
3335: END;
3336:
3337: --delete from PON_TE_RECIPIENTS
3338: DELETE FROM
3339: PON_TE_RECIPIENTS
3340: WHERE
3341: ENTRY_ID IN ( SELECT ENTRY_ID
3342: FROM PON_THREAD_ENTRIES
3343: WHERE DISCUSSION_ID = l_discussion_id);
3344:
3345: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3346: FND_LOG.string (log_level => FND_LOG.level_statement,
3347: module => g_module_prefix || l_module_name,
3348: message => 'PON_TE_RECIPIENTS records deleted');
3349: END IF;
3350:
3351: --delete from PON_TE_VIEW_AUDIT
3352: DELETE FROM