[Home] [Help]
1582: END IF;
1583:
1584: -- Delete the price breaks/shipments
1585: DELETE FROM
1586: pon_auction_shipments_all
1587: WHERE
1588: auction_header_id = p_auction_header_id AND
1589: line_number >= l_batch_start AND
1590: line_number <= l_batch_end;
2010: message => 'Deleted the entry in pon_price_differentials');
2011: END IF;
2012:
2013: DELETE FROM
2014: pon_auction_shipments_all
2015: WHERE
2016: auction_header_id = p_auction_header_id AND
2017: line_number = p_line_number;
2018:
2018:
2019: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2020: FND_LOG.string (log_level => FND_LOG.level_statement,
2021: module => g_module_prefix || l_module_name,
2022: message => 'Deleted the entry in pon_auction_shipments_all');
2023: END IF;
2024:
2025: IF ( 'STANDARD' = l_contract_type AND 'NONE' <> l_progress_payment_type) --{
2026: THEN
2381:
2382: -- Delete the price breaks that belong to this
2383: -- lot/group and also its children
2384: DELETE FROM
2385: pon_auction_shipments_all pasa
2386: WHERE
2387: pasa.auction_header_id = p_auction_header_id AND
2388: (
2389: pasa.line_number = p_line_number OR
3794: 'Y'
3795: INTO
3796: x_has_price_tiers
3797: FROM
3798: pon_auction_shipments_all
3799: WHERE
3800: auction_header_id = p_auction_header_id AND
3801: rownum = 1;
3802:
3852: * 2. x_error_code - error code
3853: * 3. x_error_message - The actual error message
3854: * 4. p_auction_header_id - The auction header id
3855: * 5. p_delete_price_tiers -- Flag to indicate if price tiers to be removed or not
3856: * COMMENT : This methods deletes all the lines in the DB table PON_AUCTION_SHIPMENTS_ALL,
3857: * for the given auction header id, sets the modify falg for new round and amendments
3858: * and sets the default price break settings.
3859: *======================================================================*/
3860:
4028: || ' and line_number between ' || l_batch_start ||' and ' || l_batch_end );
4029: END IF;
4030:
4031: DELETE FROM
4032: pon_auction_shipments_all
4033: WHERE
4034: auction_header_id = p_auction_header_id AND
4035: line_number >= l_batch_start AND
4036: line_number <= l_batch_end;
4062:
4063: --
4064: --Check if the auction is a new round or an amendment. in that case,
4065: --we need to mark all the lines with price tiers (having rows in
4066: --PON_AUCTION_SHIPMENTS_ALL table) from the previous/parent auction
4067: --as modified and set the flag has_price_tiers as 'N'.
4068: --
4069: IF (l_is_new_round OR l_is_new_amendment) THEN
4070: