DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_PARTY_LINE_EXCLUSIONS

Line 1625: pon_party_line_exclusions

1621: IF (nvl (l_large_neg_enabled_flag, 'N') = 'N') THEN
1622:
1623: -- Delete the party line exclusions
1624: DELETE FROM
1625: pon_party_line_exclusions
1626: WHERE
1627: auction_header_id = p_auction_header_id AND
1628: line_number >= l_batch_start AND
1629: line_number <= l_batch_end;

Line 1701: FROM pon_party_line_exclusions

1697: auction_header_id = p_auction_header_id AND
1698: access_type = 'RESTRICTED' AND
1699: (trading_partner_id, vendor_site_id) NOT IN
1700: (SELECT trading_partner_id, vendor_site_id
1701: FROM pon_party_line_exclusions
1702: WHERE auction_header_id = p_auction_header_id);
1703:
1704: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1705: FND_LOG.string (log_level => FND_LOG.level_statement,

Line 2062: pon_party_line_exclusions

2058: END IF;
2059: END IF;--if neg has payments }
2060:
2061: DELETE FROM
2062: pon_party_line_exclusions
2063: WHERE
2064: auction_header_id = p_auction_header_id AND
2065: line_number = p_line_number;
2066:

Line 2070: message => 'Deleted the entry in PON_PARTY_LINE_EXCLUSIONS');

2066:
2067: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2068: FND_LOG.string (log_level => FND_LOG.level_statement,
2069: module => g_module_prefix || l_module_name,
2070: message => 'Deleted the entry in PON_PARTY_LINE_EXCLUSIONS');
2071: END IF;
2072:
2073: DELETE FROM
2074: pon_auction_item_prices_all

Line 2457: pon_party_line_exclusions pple

2453: message => 'This is not large so deleting the exclusion entries.');
2454: END IF;
2455:
2456: DELETE FROM
2457: pon_party_line_exclusions pple
2458: WHERE
2459: pple.auction_header_id = p_auction_header_id AND
2460: (
2461: pple.line_number = p_line_number OR

Line 2596: FROM pon_party_line_exclusions

2592: auction_header_id = p_auction_header_id AND
2593: access_type = 'RESTRICTED' AND
2594: (trading_partner_id, vendor_site_id) NOT IN
2595: (SELECT distinct trading_partner_id, vendor_site_id
2596: FROM pon_party_line_exclusions
2597: WHERE auction_header_id = p_auction_header_id);
2598:
2599: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2600: FND_LOG.string (log_level => FND_LOG.level_procedure,