eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_TRANSFORM_BIDDING_PKG dependencies on PON_BID_HEADERS

Line 45: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

41: -- he will not have any price factor values to use...
42: -- ------------------------------------------------------------------------
43:
44: FUNCTION find_user_site
45: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)
48: RETURN NUMBER
49: IS

Line 46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

42: -- ------------------------------------------------------------------------
43:
44: FUNCTION find_user_site
45: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)
48: RETURN NUMBER
49: IS
50: v_site_id pon_bid_headers.vendor_site_id%TYPE;

Line 47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)

43:
44: FUNCTION find_user_site
45: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)
48: RETURN NUMBER
49: IS
50: v_site_id pon_bid_headers.vendor_site_id%TYPE;
51: v_num_invited_sites NUMBER;

Line 50: v_site_id pon_bid_headers.vendor_site_id%TYPE;

46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)
48: RETURN NUMBER
49: IS
50: v_site_id pon_bid_headers.vendor_site_id%TYPE;
51: v_num_invited_sites NUMBER;
52: BEGIN
53:
54: SELECT vendor_site_id

Line 199: v_bid_status pon_bid_headers.bid_status%TYPE;

195:
196: v_buyer_tpid NUMBER;
197: v_outcome pon_auction_headers_all.contract_type%TYPE;
198: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
199: v_bid_status pon_bid_headers.bid_status%TYPE;
200: v_buyer_bid_total NUMBER;
201: v_has_est_qty_on_all_bid_lines VARCHAR2(1);
202: v_doctype_group_name VARCHAR2(80);
203:

Line 219: FROM pon_bid_headers

215:
216:
217: SELECT bid_status, buyer_bid_total
218: INTO v_bid_status, v_buyer_bid_total
219: FROM pon_bid_headers
220: WHERE auction_header_id = p_auction_header_id AND
221: bid_number = p_bid_number;
222:
223: -- Check to see if we can use buyer_bid_total

Line 426: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

422: -- which are group line quantity * group line bid price for each group lineline
423: -- ------------------------------------------------------------------------
424:
425: FUNCTION calculate_quote_amount
426: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
427: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
428: p_bid_number IN pon_bid_headers.bid_number%TYPE,
429: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
430: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,

Line 428: p_bid_number IN pon_bid_headers.bid_number%TYPE,

424:
425: FUNCTION calculate_quote_amount
426: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
427: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
428: p_bid_number IN pon_bid_headers.bid_number%TYPE,
429: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
430: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
431: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
432: p_site IN pon_bid_headers.vendor_site_id%TYPE)

Line 431: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

427: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
428: p_bid_number IN pon_bid_headers.bid_number%TYPE,
429: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
430: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
431: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
432: p_site IN pon_bid_headers.vendor_site_id%TYPE)
433: RETURN NUMBER
434: IS
435: v_quote_amount NUMBER;

Line 432: p_site IN pon_bid_headers.vendor_site_id%TYPE)

428: p_bid_number IN pon_bid_headers.bid_number%TYPE,
429: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
430: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
431: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
432: p_site IN pon_bid_headers.vendor_site_id%TYPE)
433: RETURN NUMBER
434: IS
435: v_quote_amount NUMBER;
436: v_group_type pon_auction_item_prices_all.group_type%TYPE;

Line 589: from pon_bid_headers bh,

585:
586: select vendor_site_id, bid_currency_code, rate, number_price_decimals, precision
587: into x_site_id, x_currency, x_rate, x_precision, x_currency_precision
588: from (select bh.vendor_site_id, bh.bid_currency_code, bh.rate, bh.number_price_decimals, fc.precision
589: from pon_bid_headers bh,
590: pon_auction_headers_all ah,
591: fnd_currencies fc
592: where ah.auction_header_id_orig_amend = (select auction_header_id_orig_amend
593: from pon_auction_headers_all

Line 633: from pon_bid_headers bh,

629:
630: select bid_number, bid_status
631: into x_bid_number, x_bid_status
632: from (select bh.bid_number, bh.bid_status
633: from pon_bid_headers bh,
634: pon_auction_headers_all ah
635: where ah.auction_header_id_orig_amend = (select auction_header_id_orig_amend
636: from pon_auction_headers_all
637: where auction_header_id = p_auction_header_id) and