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.

[Home] [Help]

APPS.PON_TRANSFORM_BIDDING_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 133: p_outcome IN pon_auction_headers_all.contract_type%TYPE,

129:
130: FUNCTION calculate_supplier_bid_total
131: (p_auction_header_id IN NUMBER,
132: p_bid_number IN NUMBER,
133: p_outcome IN pon_auction_headers_all.contract_type%TYPE,
134: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
135: p_tpid IN NUMBER,
136: p_site IN NUMBER) RETURN NUMBER
137:

Line 134: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,

130: FUNCTION calculate_supplier_bid_total
131: (p_auction_header_id IN NUMBER,
132: p_bid_number IN NUMBER,
133: p_outcome IN pon_auction_headers_all.contract_type%TYPE,
134: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
135: p_tpid IN NUMBER,
136: p_site IN NUMBER) RETURN NUMBER
137:
138: IS

Line 197: v_outcome pon_auction_headers_all.contract_type%TYPE;

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

Line 198: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

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

Line 212: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

208: END IF;
209:
210: SELECT auh.trading_partner_id, auh.contract_type, auh.supplier_view_type,dt.doctype_group_name
211: INTO v_buyer_tpid, v_outcome, v_supplier_view_type,v_doctype_group_name
212: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
213: WHERE auction_header_id = p_auction_header_id
214: AND auh.doctype_id = dt.doctype_id;
215:
216:

Line 327: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

323: p_site IN NUMBER,
324: p_requested_supplier_id IN NUMBER)
325: RETURN NUMBER
326: IS
327: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
328: v_buyer_tpid pon_auction_headers_all.trading_partner_id %TYPE;
329:
330: BEGIN
331:

Line 328: v_buyer_tpid pon_auction_headers_all.trading_partner_id %TYPE;

324: p_requested_supplier_id IN NUMBER)
325: RETURN NUMBER
326: IS
327: v_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
328: v_buyer_tpid pon_auction_headers_all.trading_partner_id %TYPE;
329:
330: BEGIN
331:
332: -- QUESTION: do I have to worry about the case where the following query

Line 337: FROM pon_auction_headers_all

333: -- returns NO rows??
334:
335: SELECT supplier_view_type, trading_partner_id
336: INTO v_supplier_view_type, v_buyer_tpid
337: FROM pon_auction_headers_all
338: WHERE auction_header_id = p_auction_header_id;
339:
340: IF v_supplier_view_type = 'TRANSFORMED' OR
341: v_buyer_tpid = p_tpid OR

Line 429: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,

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

Line 430: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,

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)
433: RETURN NUMBER
434: IS

Line 570: from pon_auction_headers_all ah,

566:
567:
568: select ah.currency_code, 1 rate, ah.number_price_decimals, fc.precision, -1 site_id, -1 bid_number, null
569: into x_currency, x_rate, x_precision, x_currency_precision, x_site_id, x_bid_number, x_bid_status
570: from pon_auction_headers_all ah,
571: fnd_currencies fc
572: where ah.auction_header_id = p_auction_header_id and
573: ah.currency_code = fc.currency_code;
574:

Line 590: pon_auction_headers_all ah,

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

Line 593: from pon_auction_headers_all

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
594: where auction_header_id = p_auction_header_id) and
595: bh.auction_header_id = ah.auction_header_id and
596: bh.trading_partner_id = p_trading_partner_id and
597: bh.vendor_site_id like nvl(to_char(p_vendor_site_id), '%') and

Line 634: pon_auction_headers_all ah

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

Line 636: from pon_auction_headers_all

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
638: bh.auction_header_id = ah.auction_header_id and
639: bh.trading_partner_id = p_trading_partner_id and
640: bh.vendor_site_id = x_site_id