DBA Data[Home] [Help]

APPS.PON_AUCTION_HEADERS_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 1033: INSERT INTO pon_bid_attribute_values (

1029: FROM pon_bid_item_prices
1030: WHERE auction_header_id = p_auctionHeaderId
1031: AND bid_number = p_bidNumber;
1032: --
1033: INSERT INTO pon_bid_attribute_values (
1034: auction_header_id,
1035: auction_line_number,
1036: bid_number,
1037: line_number,

Line 1068: FROM pon_bid_attribute_values

1064: weighted_score,
1065: sequence_number,
1066: attr_group_seq_number,
1067: attr_disp_seq_number
1068: FROM pon_bid_attribute_values
1069: WHERE auction_header_id = p_auctionHeaderId
1070: AND bid_number = p_bidNumber;
1071: --
1072: INSERT INTO pon_bid_price_elements (

Line 1582: from PON_BID_ATTRIBUTE_VALUES b1,PON_BID_ATTRIBUTE_VALUES b2

1578: print_log(l_api_name, 'x_lineNumber=' || x_lineNumber);
1579:
1580: select count(*)
1581: into return_value
1582: from PON_BID_ATTRIBUTE_VALUES b1,PON_BID_ATTRIBUTE_VALUES b2
1583: where b1.bid_number = x_oldBidNumber
1584: and b1.line_number = x_lineNumber
1585: and b2.bid_number = x_newBidNumber
1586: and b2.line_number = b1.line_number