APPS.PON_OA_UTIL_PKG dependencies on PON_BID_HEADERS

Line 1520: from pon_bid_headers

1516: v_return_string VARCHAR2(1000) := NULL;
1517:
1518: CURSOR bids IS
1519: select bid_number
1520: from pon_bid_headers
1521: where auction_header_id = p_auction_header_id and
1522: trading_partner_id = p_trading_partner_id and
1523: bid_status = 'ACTIVE';
1524:

Line 1528: from pon_bid_headers

1524:
1525: CURSOR counteroffers IS
1526: select substrb(to_char(bid_number)||(decode (bid_revision_number,null,'','-'||to_char(bid_revision_number))),0,10) bid_number_display,
1527: bid_number
1528: from pon_bid_headers
1529: where auction_header_id = p_auction_header_id and
1530: trading_partner_id = p_trading_partner_id and
1531: bid_status = 'ACTIVE' and
1532: nvl(award_status,'NONE') <> 'COMMITTED';

Line 1611: FROM pon_bid_headers

1607:
1608: IF (g_offer_rules(p_doctype_id) = 'Y') THEN
1609: SELECT count(*)
1610: INTO v_number_of_bids
1611: FROM pon_bid_headers
1612: WHERE auction_header_id = p_auction_header_id and
1613: trading_partner_id = p_trading_partner_id and
1614: bid_status = 'ACTIVE' and
1615: nvl(award_status,'NONE') <> 'COMMITTED';

Line 1625: FROM pon_bid_headers

1621: END IF;
1622: ELSE
1623: SELECT count(*)
1624: INTO v_number_of_bids
1625: FROM pon_bid_headers
1626: WHERE auction_header_id = p_auction_header_id and
1627: trading_partner_id = p_trading_partner_id and
1628: bid_status = 'ACTIVE';
1629: END IF;

Line 1672: FROM pon_bid_headers bh

1668: v_active_bids_count NUMBER := 0;
1669: BEGIN
1670: SELECT count(*)
1671: INTO v_active_bids_count
1672: FROM pon_bid_headers bh
1673: , pon_bid_item_prices bl
1674: WHERE bh.auction_header_id = p_auction_header_id
1675: and bh.bid_status = 'ACTIVE'
1676: --added by Allen Yang for Surrogate Bid 2008/09/26