[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,
1517: -- is added
1518: -- Above condition is built into the batching
1519: -- condition as we start from 1
1520: DELETE FROM
1521: pon_auction_attributes
1522: WHERE
1523: auction_header_id = p_auction_header_id AND
1524: line_number >= l_batch_start AND
1525: line_number <= l_batch_end;
1962: message => 'Deleted the entry in pon_attribute_scores');
1963: END IF;
1964:
1965: DELETE FROM
1966: pon_auction_attributes
1967: WHERE
1968: auction_header_id = p_auction_header_id and
1969: line_number = p_line_number;
1970:
1970:
1971: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1972: FND_LOG.string (log_level => FND_LOG.level_statement,
1973: module => g_module_prefix || l_module_name,
1974: message => 'Entry in pon_auction_attributes deleted');
1975: END IF;
1976:
1977: DELETE FROM
1978: pon_pf_supplier_values
2231:
2232: -- Delete the attributes that belong to this lot/group
2233: -- and also its children
2234: DELETE FROM
2235: pon_auction_attributes paa
2236: WHERE
2237: paa.auction_header_id = p_auction_header_id AND
2238: (
2239: paa.line_number = p_line_number OR