DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_DISCUSSIONS

Line 3312: l_discussion_id PON_DISCUSSIONS.DISCUSSION_ID%TYPE;

3308: ) IS
3309:
3310:
3311: l_module_name VARCHAR2 (30);
3312: l_discussion_id PON_DISCUSSIONS.DISCUSSION_ID%TYPE;
3313:
3314:
3315: BEGIN
3316:

Line 3330: FROM pon_discussions

3326:
3327: BEGIN
3328: SELECT discussion_id
3329: INTO l_discussion_id
3330: FROM pon_discussions
3331: WHERE pk1_value = p_auction_header_id;
3332:
3333: EXCEPTION WHEN NO_DATA_FOUND THEN
3334: RETURN;

Line 3388: PON_DISCUSSIONS

3384: message => 'PON_THREADS records deleted');
3385: END IF;
3386:
3387: DELETE FROM
3388: PON_DISCUSSIONS
3389: WHERE
3390: DISCUSSION_ID = l_discussion_id;
3391:
3392: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

3391:
3392: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3393: FND_LOG.string (log_level => FND_LOG.level_statement,
3394: module => g_module_prefix || l_module_name,
3395: message => 'PON_DISCUSSIONS records deleted');
3396: END IF;
3397:
3398: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3399: FND_LOG.string (log_level => FND_LOG.level_procedure,