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 291: v_bid_status pon_bid_headers.bid_status%TYPE;

287:
288: v_buyer_tpid NUMBER;
289: v_outcome pon_auction_headers_all.contract_type%TYPE;
290: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
291: v_bid_status pon_bid_headers.bid_status%TYPE;
292: v_buyer_bid_total NUMBER;
293: v_has_est_qty_on_all_bid_lines VARCHAR2(1);
294: v_doctype_group_name VARCHAR2(80);
295:

Line 311: FROM pon_bid_headers

307:
308:
309: SELECT bid_status, buyer_bid_total
310: INTO v_bid_status, v_buyer_bid_total
311: FROM pon_bid_headers
312: WHERE auction_header_id = p_auction_header_id AND
313: bid_number = p_bid_number;
314:
315: -- Check to see if we can use buyer_bid_total

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

514: -- which are group line quantity * group line bid price for each group lineline
515: -- ------------------------------------------------------------------------
516:
517: FUNCTION calculate_quote_amount
518: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
519: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
521: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
522: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,

Line 520: p_bid_number IN pon_bid_headers.bid_number%TYPE,

516:
517: FUNCTION calculate_quote_amount
518: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
519: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
521: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
522: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
523: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
524: p_site IN pon_bid_headers.vendor_site_id%TYPE)

Line 523: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

519: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
521: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
522: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
523: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
524: p_site IN pon_bid_headers.vendor_site_id%TYPE)
525: RETURN NUMBER
526: IS
527: v_quote_amount NUMBER;

Line 524: p_site IN pon_bid_headers.vendor_site_id%TYPE)

520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
521: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
522: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
523: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
524: p_site IN pon_bid_headers.vendor_site_id%TYPE)
525: RETURN NUMBER
526: IS
527: v_quote_amount NUMBER;
528: v_group_type pon_auction_item_prices_all.group_type%TYPE;

Line 681: from pon_bid_headers bh,

677:
678: select vendor_site_id, bid_currency_code, rate, number_price_decimals, precision
679: into x_site_id, x_currency, x_rate, x_precision, x_currency_precision
680: from (select bh.vendor_site_id, bh.bid_currency_code, bh.rate, bh.number_price_decimals, fc.precision
681: from pon_bid_headers bh,
682: pon_auction_headers_all ah,
683: fnd_currencies fc
684: where ah.auction_header_id_orig_amend = (select auction_header_id_orig_amend
685: from pon_auction_headers_all

Line 725: from pon_bid_headers bh,

721:
722: select bid_number, bid_status
723: into x_bid_number, x_bid_status
724: from (select bh.bid_number, bh.bid_status
725: from pon_bid_headers bh,
726: pon_auction_headers_all ah
727: where ah.auction_header_id_orig_amend = (select auction_header_id_orig_amend
728: from pon_auction_headers_all
729: where auction_header_id = p_auction_header_id) and

Line 762: v_bid_status pon_bid_headers.bid_status%TYPE;

758:
759: v_buyer_tpid NUMBER;
760: v_outcome pon_auction_headers_all.contract_type%TYPE;
761: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
762: v_bid_status pon_bid_headers.bid_status%TYPE;
763: v_buyer_bid_total NUMBER;
764: v_has_est_qty_on_all_bid_lines VARCHAR2(1);
765: v_doctype_group_name VARCHAR2(80);
766:

Line 782: FROM pon_bid_headers

778:
779:
780: SELECT bid_status, buyer_bid_total
781: INTO v_bid_status, v_buyer_bid_total
782: FROM pon_bid_headers
783: WHERE auction_header_id = p_auction_header_id AND
784: bid_number = p_bid_number;
785:
786: -- Check to see if we can use buyer_bid_total