DBA Data[Home] [Help]

APPS.PON_CONSOLE_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 1149: UPDATE pon_auction_headers_all ah

1145: -- Update the count on the negotiation to the last value
1146: -- last_update_login field is missing in the table. Add the update to
1147: -- that column after the column is introduced
1148:
1149: UPDATE pon_auction_headers_all ah
1150: SET ah.max_bid_color_sequence_id = l_color_sequence_id,
1151: ah.last_update_date = sysdate,
1152: ah.last_updated_by = fnd_global.user_id
1153: WHERE ah.auction_header_id = p_auction_header_id;

Line 1516: pon_auction_headers_all ah,

1512: nvl(ai.quantity,1) auction_qty
1513: BULK COLLECT INTO l_line_number_tbl, l_bid_price_tbl, l_bid_qty_tbl, l_current_price_tbl, l_auction_qty_tbl
1514: FROM pon_bid_headers bh,
1515: pon_bid_item_prices bl,
1516: pon_auction_headers_all ah,
1517: pon_auction_item_prices_all ai
1518: WHERE ah.auction_header_id = bh.auction_header_id
1519: and bh.auction_header_id = bl.auction_header_id
1520: and bh.bid_number = bl.bid_number