[Home] [Help]
637: line_number <= l_batch_end;
638:
639: -- Delete the special attributes (quantity and need by date)
640: DELETE FROM
641: pon_auction_attributes
642: WHERE
643: auction_header_id = p_auction_header_id AND
644: sequence_number < 0 AND
645: line_number >= l_batch_start AND
646: line_number <= l_batch_end;
647:
648: -- Set the scoring type as null and the weight as null for all the attributes
649: UPDATE
650: pon_auction_attributes
651: SET
652: scoring_type = 'NONE',
653: weight = 0,
654: last_update_date = sysdate,
1537: -- is added
1538: -- Above condition is built into the batching
1539: -- condition as we start from 1
1540: DELETE FROM
1541: pon_auction_attributes
1542: WHERE
1543: auction_header_id = p_auction_header_id AND
1544: line_number >= l_batch_start AND
1545: line_number <= l_batch_end;
2029: message => 'Deleted the entry in pon_attribute_scores');
2030: END IF;
2031:
2032: DELETE FROM
2033: pon_auction_attributes
2034: WHERE
2035: auction_header_id = p_auction_header_id and
2036: line_number = p_line_number;
2037:
2037:
2038: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2039: FND_LOG.string (log_level => FND_LOG.level_statement,
2040: module => g_module_prefix || l_module_name,
2041: message => 'Entry in pon_auction_attributes deleted');
2042: END IF;
2043:
2044: DELETE FROM
2045: pon_pf_supplier_values
2363:
2364: -- Delete the attributes that belong to this lot/group
2365: -- and also its children
2366: DELETE FROM
2367: pon_auction_attributes paa
2368: WHERE
2369: paa.auction_header_id = p_auction_header_id AND
2370: (
2371: paa.line_number = p_line_number OR