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_AUCTION_HEADERS_ALL

Line 180: p_outcome IN pon_auction_headers_all.contract_type%TYPE,

176:
177: FUNCTION calculate_supplier_bid_total
178: (p_auction_header_id IN NUMBER,
179: p_bid_number IN NUMBER,
180: p_outcome IN pon_auction_headers_all.contract_type%TYPE,
181: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
182: p_tpid IN NUMBER,
183: p_site IN NUMBER) RETURN NUMBER
184:

Line 181: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,

177: FUNCTION calculate_supplier_bid_total
178: (p_auction_header_id IN NUMBER,
179: p_bid_number IN NUMBER,
180: p_outcome IN pon_auction_headers_all.contract_type%TYPE,
181: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
182: p_tpid IN NUMBER,
183: p_site IN NUMBER) RETURN NUMBER
184:
185: IS

Line 289: v_outcome pon_auction_headers_all.contract_type%TYPE;

285:
286: IS
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);

Line 290: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

286: IS
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);

Line 304: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

300: END IF;
301:
302: SELECT auh.trading_partner_id, auh.contract_type, auh.supplier_view_type,dt.doctype_group_name
303: INTO v_buyer_tpid, v_outcome, v_supplier_view_type,v_doctype_group_name
304: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
305: WHERE auction_header_id = p_auction_header_id
306: AND auh.doctype_id = dt.doctype_id;
307:
308:

Line 419: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

415: p_site IN NUMBER,
416: p_requested_supplier_id IN NUMBER)
417: RETURN NUMBER
418: IS
419: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
420: v_buyer_tpid pon_auction_headers_all.trading_partner_id %TYPE;
421:
422: BEGIN
423:

Line 420: v_buyer_tpid pon_auction_headers_all.trading_partner_id %TYPE;

416: p_requested_supplier_id IN NUMBER)
417: RETURN NUMBER
418: IS
419: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
420: v_buyer_tpid pon_auction_headers_all.trading_partner_id %TYPE;
421:
422: BEGIN
423:
424: -- QUESTION: do I have to worry about the case where the following query

Line 429: FROM pon_auction_headers_all

425: -- returns NO rows??
426:
427: SELECT supplier_view_type, trading_partner_id
428: INTO v_supplier_view_type, v_buyer_tpid
429: FROM pon_auction_headers_all
430: WHERE auction_header_id = p_auction_header_id;
431:
432: IF v_supplier_view_type = 'TRANSFORMED' OR
433: v_buyer_tpid = p_tpid OR

Line 521: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,

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)
525: RETURN NUMBER

Line 522: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,

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)
525: RETURN NUMBER
526: IS

Line 662: from pon_auction_headers_all ah,

658:
659:
660: select ah.currency_code, 1 rate, ah.number_price_decimals, fc.precision, -1 site_id, -1 bid_number, null
661: into x_currency, x_rate, x_precision, x_currency_precision, x_site_id, x_bid_number, x_bid_status
662: from pon_auction_headers_all ah,
663: fnd_currencies fc
664: where ah.auction_header_id = p_auction_header_id and
665: ah.currency_code = fc.currency_code;
666:

Line 682: pon_auction_headers_all ah,

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
686: where auction_header_id = p_auction_header_id) and

Line 685: from pon_auction_headers_all

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
686: where auction_header_id = p_auction_header_id) and
687: bh.auction_header_id = ah.auction_header_id and
688: bh.trading_partner_id = p_trading_partner_id and
689: bh.vendor_site_id like nvl(to_char(p_vendor_site_id), '%') and

Line 726: pon_auction_headers_all ah

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
730: bh.auction_header_id = ah.auction_header_id and

Line 728: from pon_auction_headers_all

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
730: bh.auction_header_id = ah.auction_header_id and
731: bh.trading_partner_id = p_trading_partner_id and
732: bh.vendor_site_id = x_site_id

Line 760: v_outcome pon_auction_headers_all.contract_type%TYPE;

756:
757: IS
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);

Line 761: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

757: IS
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);

Line 775: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

771: END IF;
772:
773: SELECT auh.trading_partner_id, auh.contract_type, auh.supplier_view_type,dt.doctype_group_name
774: INTO v_buyer_tpid, v_outcome, v_supplier_view_type,v_doctype_group_name
775: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
776: WHERE auction_header_id = p_auction_header_id
777: AND auh.doctype_id = dt.doctype_id;
778:
779:

Line 850: p_outcome IN pon_auction_headers_all.contract_type%TYPE,

846:
847: FUNCTION calc_sup_btotal_with_out_ol
848: (p_auction_header_id IN NUMBER,
849: p_bid_number IN NUMBER,
850: p_outcome IN pon_auction_headers_all.contract_type%TYPE,
851: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
852: p_tpid IN NUMBER,
853: p_site IN NUMBER) RETURN NUMBER
854:

Line 851: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,

847: FUNCTION calc_sup_btotal_with_out_ol
848: (p_auction_header_id IN NUMBER,
849: p_bid_number IN NUMBER,
850: p_outcome IN pon_auction_headers_all.contract_type%TYPE,
851: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
852: p_tpid IN NUMBER,
853: p_site IN NUMBER) RETURN NUMBER
854:
855: IS