DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_PRICE_DIFFERENTIALS

Line 1626: pon_price_differentials

1622: IF (l_doctype_group_name <> PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION OR
1623: NVL (l_global_agreement_flag, 'Y') = 'Y') THEN
1624: -- Delete the price differentials
1625: DELETE FROM
1626: pon_price_differentials
1627: WHERE
1628: auction_header_id = p_auction_header_id AND
1629: line_number >= l_batch_start AND
1630: line_number <= l_batch_end;

Line 2069: pon_price_differentials

2065: message => 'Deleted the entry in pon_price_elements');
2066: END IF;
2067:
2068: DELETE FROM
2069: pon_price_differentials
2070: WHERE
2071: auction_header_id = p_auction_header_id AND
2072: line_number = p_line_number;
2073:

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

2073:
2074: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2075: FND_LOG.string (log_level => FND_LOG.level_statement,
2076: module => g_module_prefix || l_module_name,
2077: message => 'Deleted the entry in pon_price_differentials');
2078: END IF;
2079:
2080: DELETE FROM
2081: pon_auction_shipments_all

Line 2557: pon_price_differentials ppd

2553:
2554: -- Delete the price differentials that belong to this
2555: -- lot/group and also its children
2556: DELETE FROM
2557: pon_price_differentials ppd
2558: WHERE
2559: ppd.auction_header_id = p_auction_header_id AND
2560: (
2561: ppd.line_number = p_line_number OR

Line 4198: pon_price_differentials

4194: || ' and line_number between ' || l_batch_start ||' and ' || l_batch_end );
4195: END IF;
4196:
4197: DELETE FROM
4198: pon_price_differentials
4199: WHERE
4200: auction_header_id = p_auction_header_id AND
4201: shipment_number > -1 AND
4202: line_number >= l_batch_start AND