APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 1606: pon_auction_shipments_all

1602: END IF;
1603:
1604: -- Delete the price breaks/shipments
1605: DELETE FROM
1606: pon_auction_shipments_all
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 2081: pon_auction_shipments_all

2077: message => 'Deleted the entry in pon_price_differentials');
2078: END IF;
2079:
2080: DELETE FROM
2081: pon_auction_shipments_all
2082: WHERE
2083: auction_header_id = p_auction_header_id AND
2084: line_number = p_line_number;
2085:

Line 2089: message => 'Deleted the entry in pon_auction_shipments_all');

2085:
2086: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2087: FND_LOG.string (log_level => FND_LOG.level_statement,
2088: module => g_module_prefix || l_module_name,
2089: message => 'Deleted the entry in pon_auction_shipments_all');
2090: END IF;
2091:
2092: IF ( 'STANDARD' = l_contract_type AND 'NONE' <> l_progress_payment_type) --{
2093: THEN

Line 2517: pon_auction_shipments_all pasa

2513:
2514: -- Delete the price breaks that belong to this
2515: -- lot/group and also its children
2516: DELETE FROM
2517: pon_auction_shipments_all pasa
2518: WHERE
2519: pasa.auction_header_id = p_auction_header_id AND
2520: (
2521: pasa.line_number = p_line_number OR

Line 3942: pon_auction_shipments_all

3938: 'Y'
3939: INTO
3940: x_has_price_tiers
3941: FROM
3942: pon_auction_shipments_all
3943: WHERE
3944: auction_header_id = p_auction_header_id AND
3945: rownum = 1;
3946:

Line 4000: * COMMENT : This methods deletes all the lines in the DB table PON_AUCTION_SHIPMENTS_ALL,

3996: * 2. x_error_code - error code
3997: * 3. x_error_message - The actual error message
3998: * 4. p_auction_header_id - The auction header id
3999: * 5. p_delete_price_tiers -- Flag to indicate if price tiers to be removed or not
4000: * COMMENT : This methods deletes all the lines in the DB table PON_AUCTION_SHIPMENTS_ALL,
4001: * for the given auction header id, sets the modify falg for new round and amendments
4002: * and sets the default price break settings.
4003: *======================================================================*/
4004:

Line 4176: pon_auction_shipments_all

4172: || ' and line_number between ' || l_batch_start ||' and ' || l_batch_end );
4173: END IF;
4174:
4175: DELETE FROM
4176: pon_auction_shipments_all
4177: WHERE
4178: auction_header_id = p_auction_header_id AND
4179: line_number >= l_batch_start AND
4180: line_number <= l_batch_end;

Line 4210: --PON_AUCTION_SHIPMENTS_ALL table) from the previous/parent auction

4206:
4207: --
4208: --Check if the auction is a new round or an amendment. in that case,
4209: --we need to mark all the lines with price tiers (having rows in
4210: --PON_AUCTION_SHIPMENTS_ALL table) from the previous/parent auction
4211: --as modified and set the flag has_price_tiers as 'N'.
4212: --
4213: IF (l_is_new_round OR l_is_new_amendment) THEN
4214: