[Home] [Help]
1052: FROM pon_bid_item_prices
1053: WHERE auction_header_id = p_auctionHeaderId
1054: AND bid_number = p_bidNumber;
1055: --
1056: INSERT INTO pon_bid_attribute_values (
1057: auction_header_id,
1058: auction_line_number,
1059: bid_number,
1060: line_number,
1087: weighted_score,
1088: sequence_number,
1089: attr_group_seq_number,
1090: attr_disp_seq_number
1091: FROM pon_bid_attribute_values
1092: WHERE auction_header_id = p_auctionHeaderId
1093: AND bid_number = p_bidNumber;
1094: --
1095: INSERT INTO pon_bid_price_elements (
1635: print_log(l_api_name, 'x_lineNumber=' || x_lineNumber);
1636:
1637: select count(*)
1638: into return_value
1639: from PON_BID_ATTRIBUTE_VALUES b1,PON_BID_ATTRIBUTE_VALUES b2
1640: where b1.bid_number = x_oldBidNumber
1641: and b1.line_number = x_lineNumber
1642: and b2.bid_number = x_newBidNumber
1643: and b2.line_number = b1.line_number