eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_PARTY_LINE_EXCLUSIONS

Line 1645: pon_party_line_exclusions

1641: IF (nvl (l_large_neg_enabled_flag, 'N') = 'N') THEN
1642:
1643: -- Delete the party line exclusions
1644: DELETE FROM
1645: pon_party_line_exclusions
1646: WHERE
1647: auction_header_id = p_auction_header_id AND
1648: line_number >= l_batch_start AND
1649: line_number <= l_batch_end;

Line 1762: FROM pon_party_line_exclusions

1758: auction_header_id = p_auction_header_id AND
1759: access_type = 'RESTRICTED' AND
1760: (trading_partner_id, vendor_site_id) NOT IN
1761: (SELECT trading_partner_id, vendor_site_id
1762: FROM pon_party_line_exclusions
1763: WHERE auction_header_id = p_auction_header_id);
1764:
1765: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1766: FND_LOG.string (log_level => FND_LOG.level_statement,

Line 2129: pon_party_line_exclusions

2125: END IF;
2126: END IF;--if neg has payments }
2127:
2128: DELETE FROM
2129: pon_party_line_exclusions
2130: WHERE
2131: auction_header_id = p_auction_header_id AND
2132: line_number = p_line_number;
2133:

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

2133:
2134: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2135: FND_LOG.string (log_level => FND_LOG.level_statement,
2136: module => g_module_prefix || l_module_name,
2137: message => 'Deleted the entry in PON_PARTY_LINE_EXCLUSIONS');
2138: END IF;
2139:
2140: -- Federal Fields project : Delete line uda's
2141: IF PON_CLM_UTIL_PKG.IS_UDA_ENABLED(l_doctype_id) = 1 THEN

Line 2589: pon_party_line_exclusions pple

2585: message => 'This is not large so deleting the exclusion entries.');
2586: END IF;
2587:
2588: DELETE FROM
2589: pon_party_line_exclusions pple
2590: WHERE
2591: pple.auction_header_id = p_auction_header_id AND
2592: (
2593: pple.line_number = p_line_number OR

Line 2740: FROM pon_party_line_exclusions

2736: auction_header_id = p_auction_header_id AND
2737: access_type = 'RESTRICTED' AND
2738: (trading_partner_id, vendor_site_id) NOT IN
2739: (SELECT distinct trading_partner_id, vendor_site_id
2740: FROM pon_party_line_exclusions
2741: WHERE auction_header_id = p_auction_header_id);
2742:
2743: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2744: FND_LOG.string (log_level => FND_LOG.level_procedure,