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,
3352: DELETE FROM
3353: PON_TE_VIEW_AUDIT
3354: WHERE
3355: ENTRY_ID IN ( SELECT ENTRY_ID
3356: FROM PON_THREAD_ENTRIES
3357: WHERE DISCUSSION_ID = l_discussion_id);
3358:
3359: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3360: FND_LOG.string (log_level => FND_LOG.level_statement,
3362: message => 'PON_TE_VIEW_AUDIT records deleted');
3363: END IF;
3364:
3365: DELETE FROM
3366: PON_THREAD_ENTRIES
3367: WHERE
3368: DISCUSSION_ID = l_discussion_id;
3369:
3370: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3369:
3370: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3371: FND_LOG.string (log_level => FND_LOG.level_statement,
3372: module => g_module_prefix || l_module_name,
3373: message => 'PON_THREAD_ENTRIES records deleted');
3374: END IF;
3375:
3376: DELETE FROM
3377: PON_THREADS