DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_DISCUSSIONS

Line 3456: l_discussion_id PON_DISCUSSIONS.DISCUSSION_ID%TYPE;

3452: ) IS
3453:
3454:
3455: l_module_name VARCHAR2 (30);
3456: l_discussion_id PON_DISCUSSIONS.DISCUSSION_ID%TYPE;
3457:
3458:
3459: BEGIN
3460:

Line 3474: FROM pon_discussions

3470:
3471: BEGIN
3472: SELECT discussion_id
3473: INTO l_discussion_id
3474: FROM pon_discussions
3475: WHERE pk1_value = p_auction_header_id;
3476:
3477: EXCEPTION WHEN NO_DATA_FOUND THEN
3478: RETURN;

Line 3532: PON_DISCUSSIONS

3528: message => 'PON_THREADS records deleted');
3529: END IF;
3530:
3531: DELETE FROM
3532: PON_DISCUSSIONS
3533: WHERE
3534: DISCUSSION_ID = l_discussion_id;
3535:
3536: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 3539: message => 'PON_DISCUSSIONS records deleted');

3535:
3536: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3537: FND_LOG.string (log_level => FND_LOG.level_statement,
3538: module => g_module_prefix || l_module_name,
3539: message => 'PON_DISCUSSIONS records deleted');
3540: END IF;
3541:
3542: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3543: FND_LOG.string (log_level => FND_LOG.level_procedure,