DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_PRICE_DIFFERENTIALS

Line 1606: pon_price_differentials

1602: IF (l_doctype_group_name <> PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION OR
1603: NVL (l_global_agreement_flag, 'Y') = 'Y') THEN
1604: -- Delete the price differentials
1605: DELETE FROM
1606: pon_price_differentials
1607: WHERE
1608: auction_header_id = p_auction_header_id AND
1609: line_number >= l_batch_start AND
1610: line_number <= l_batch_end;

Line 2002: pon_price_differentials

1998: message => 'Deleted the entry in pon_price_elements');
1999: END IF;
2000:
2001: DELETE FROM
2002: pon_price_differentials
2003: WHERE
2004: auction_header_id = p_auction_header_id AND
2005: line_number = p_line_number;
2006:

Line 2010: message => 'Deleted the entry in pon_price_differentials');

2006:
2007: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2008: FND_LOG.string (log_level => FND_LOG.level_statement,
2009: module => g_module_prefix || l_module_name,
2010: message => 'Deleted the entry in pon_price_differentials');
2011: END IF;
2012:
2013: DELETE FROM
2014: pon_auction_shipments_all

Line 2425: pon_price_differentials ppd

2421:
2422: -- Delete the price differentials that belong to this
2423: -- lot/group and also its children
2424: DELETE FROM
2425: pon_price_differentials ppd
2426: WHERE
2427: ppd.auction_header_id = p_auction_header_id AND
2428: (
2429: ppd.line_number = p_line_number OR

Line 4054: pon_price_differentials

4050: || ' and line_number between ' || l_batch_start ||' and ' || l_batch_end );
4051: END IF;
4052:
4053: DELETE FROM
4054: pon_price_differentials
4055: WHERE
4056: auction_header_id = p_auction_header_id AND
4057: shipment_number > -1 AND
4058: line_number >= l_batch_start AND