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_BID_VALIDATIONS_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 516: l_allow_unsol_lines pon_auction_headers_all.ALLOW_UNSOL_OFFER_LINES%TYPE;

512: ) IS
513: l_header_modified VARCHAR2(1);
514:
515: --Unsolicited Lines Project
516: l_allow_unsol_lines pon_auction_headers_all.ALLOW_UNSOL_OFFER_LINES%TYPE;
517: l_changed_unsol_line_count NUMBER;
518: BEGIN
519:
520: -- Determine if the bid header was modified

Line 555: FROM pon_auction_headers_all

551: BEGIN
552:
553: SELECT Nvl(ALLOW_UNSOL_OFFER_LINES,'N')
554: INTO l_allow_unsol_lines
555: FROM pon_auction_headers_all
556: WHERE auction_header_id = p_auc_header_id;
557:
558: IF p_rebid = 'Y' AND l_allow_unsol_lines = 'Y' THEN
559: l_changed_unsol_line_count := 0;

Line 711: , pon_auction_headers_all paha,

707: FROM pon_bid_item_prices bl,
708: pon_auction_item_prices_all paip
709: -- added by Allen Yang for surrogate bid bug 7703665, #8220778 2009/02/03
710: ---------------------------------------------------------------
711: , pon_auction_headers_all paha,
712: pon_bid_headers pbh
713: ---------------------------------------------------------------
714: WHERE bl.bid_number = p_bid_number and
715: bl.auction_header_id = paip.auction_header_id and

Line 891: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,

887: p_full_qty_reqd IN VARCHAR2,
888: p_header_disp_pf IN VARCHAR2,
889: p_price_driven IN VARCHAR2,
890: p_percent_decr IN VARCHAR2,
891: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,
892: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
893: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
894: p_rate IN pon_bid_headers.rate%TYPE,
895: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 892: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,

888: p_header_disp_pf IN VARCHAR2,
889: p_price_driven IN VARCHAR2,
890: p_percent_decr IN VARCHAR2,
891: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,
892: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
893: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
894: p_rate IN pon_bid_headers.rate%TYPE,
895: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
896: p_amt_precision IN fnd_currencies.precision%TYPE,

Line 3458: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah

3454: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
3455: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
3456: al.line_num_display s_clm_line_num_display,
3457: Nvl(al.clm_info_flag, 'N') s_clm_info_flag
3458: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
3459: WHERE al.auction_header_id = p_auc_header_id
3460: AND bl.bid_number = p_bid_number
3461: AND pah.auction_header_id = p_auc_header_id
3462: AND al.line_number = bl.line_number

Line 3798: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah

3794: FROM pon_bid_payments_shipments pbps
3795: WHERE pbps.auction_header_id = p_auc_header_id
3796: AND pbps.bid_number = p_bid_number
3797: AND pbps.bid_line_number = bl.line_number) s_sum_pymt_amt --bug 14657112
3798: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
3799: WHERE al.auction_header_id = p_auc_header_id
3800: AND bl.bid_number = p_bid_number
3801: AND pah.auction_header_id = p_auc_header_id
3802: AND al.line_number = bl.line_number

Line 4525: p_po_start_date IN pon_auction_headers_all.po_start_date%TYPE,

4521: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4522: p_trans_view IN VARCHAR2,
4523: p_blanket IN VARCHAR2,
4524: p_header_disp_pf IN VARCHAR2,
4525: p_po_start_date IN pon_auction_headers_all.po_start_date%TYPE,
4526: p_po_end_date IN pon_auction_headers_all.po_end_date%TYPE,
4527: p_auc_close_date IN pon_auction_headers_all.close_bidding_date%TYPE,
4528: p_suffix IN VARCHAR2,
4529: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 4526: p_po_end_date IN pon_auction_headers_all.po_end_date%TYPE,

4522: p_trans_view IN VARCHAR2,
4523: p_blanket IN VARCHAR2,
4524: p_header_disp_pf IN VARCHAR2,
4525: p_po_start_date IN pon_auction_headers_all.po_start_date%TYPE,
4526: p_po_end_date IN pon_auction_headers_all.po_end_date%TYPE,
4527: p_auc_close_date IN pon_auction_headers_all.close_bidding_date%TYPE,
4528: p_suffix IN VARCHAR2,
4529: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4530: p_request_id IN pon_interface_errors.request_id%TYPE

Line 4527: p_auc_close_date IN pon_auction_headers_all.close_bidding_date%TYPE,

4523: p_blanket IN VARCHAR2,
4524: p_header_disp_pf IN VARCHAR2,
4525: p_po_start_date IN pon_auction_headers_all.po_start_date%TYPE,
4526: p_po_end_date IN pon_auction_headers_all.po_end_date%TYPE,
4527: p_auc_close_date IN pon_auction_headers_all.close_bidding_date%TYPE,
4528: p_suffix IN VARCHAR2,
4529: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4530: p_request_id IN pon_interface_errors.request_id%TYPE
4531: ) IS

Line 7441: from pon_auction_headers_all pah

7437:
7438: --Added by Chaoqun on Jan-8-2009 begin
7439: select pah.emd_enable_flag
7440: into l_emd_enable_flag
7441: from pon_auction_headers_all pah
7442: where pah.auction_header_id = p_auc_header_id;
7443:
7444: IF l_emd_enable_flag = 'Y' then
7445: --Added by Chaoqun on Jan-8-2009 end

Line 7528: l_min_bid_decr pon_auction_headers_all.min_bid_decrement%TYPE;

7524: l_amt_precision fnd_currencies.precision%TYPE;
7525:
7526: l_source_bid pon_bid_headers.bid_number%TYPE;
7527: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;
7528: l_min_bid_decr pon_auction_headers_all.min_bid_decrement%TYPE;
7529: l_percent_decr VARCHAR2(1);
7530: l_bid_decr_method pon_auction_headers_all.bid_decrement_method%TYPE;
7531:
7532: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;

Line 7530: l_bid_decr_method pon_auction_headers_all.bid_decrement_method%TYPE;

7526: l_source_bid pon_bid_headers.bid_number%TYPE;
7527: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;
7528: l_min_bid_decr pon_auction_headers_all.min_bid_decrement%TYPE;
7529: l_percent_decr VARCHAR2(1);
7530: l_bid_decr_method pon_auction_headers_all.bid_decrement_method%TYPE;
7531:
7532: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
7533: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
7534: l_auc_close_date pon_auction_headers_all.close_bidding_date%TYPE;

Line 7532: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;

7528: l_min_bid_decr pon_auction_headers_all.min_bid_decrement%TYPE;
7529: l_percent_decr VARCHAR2(1);
7530: l_bid_decr_method pon_auction_headers_all.bid_decrement_method%TYPE;
7531:
7532: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
7533: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
7534: l_auc_close_date pon_auction_headers_all.close_bidding_date%TYPE;
7535: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
7536: l_contract_type pon_auction_headers_all.contract_type%TYPE;

Line 7533: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;

7529: l_percent_decr VARCHAR2(1);
7530: l_bid_decr_method pon_auction_headers_all.bid_decrement_method%TYPE;
7531:
7532: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
7533: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
7534: l_auc_close_date pon_auction_headers_all.close_bidding_date%TYPE;
7535: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
7536: l_contract_type pon_auction_headers_all.contract_type%TYPE;
7537:

Line 7534: l_auc_close_date pon_auction_headers_all.close_bidding_date%TYPE;

7530: l_bid_decr_method pon_auction_headers_all.bid_decrement_method%TYPE;
7531:
7532: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
7533: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
7534: l_auc_close_date pon_auction_headers_all.close_bidding_date%TYPE;
7535: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
7536: l_contract_type pon_auction_headers_all.contract_type%TYPE;
7537:
7538: l_tpid pon_bid_headers.trading_partner_id%TYPE;

Line 7535: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;

7531:
7532: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
7533: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
7534: l_auc_close_date pon_auction_headers_all.close_bidding_date%TYPE;
7535: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
7536: l_contract_type pon_auction_headers_all.contract_type%TYPE;
7537:
7538: l_tpid pon_bid_headers.trading_partner_id%TYPE;
7539: l_vensid pon_bid_headers.vendor_site_id%TYPE;

Line 7536: l_contract_type pon_auction_headers_all.contract_type%TYPE;

7532: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
7533: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
7534: l_auc_close_date pon_auction_headers_all.close_bidding_date%TYPE;
7535: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
7536: l_contract_type pon_auction_headers_all.contract_type%TYPE;
7537:
7538: l_tpid pon_bid_headers.trading_partner_id%TYPE;
7539: l_vensid pon_bid_headers.vendor_site_id%TYPE;
7540: l_bid_curr_code pon_bid_headers.bid_currency_code%TYPE;

Line 7556: l_price_tiers_indicator pon_auction_headers_all.PRICE_TIERS_INDICATOR%TYPE;

7552: l_auc_has_items VARCHAR2(1);
7553: l_suffix VARCHAR2(2);
7554:
7555: l_has_errors VARCHAR2(1);
7556: l_price_tiers_indicator pon_auction_headers_all.PRICE_TIERS_INDICATOR%TYPE;
7557: --added by Allen Yang for Surrogate Bid 2008/09/03
7558: --------------------------------------------------------------------------------------
7559: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
7560: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;

Line 7559: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

7555: l_has_errors VARCHAR2(1);
7556: l_price_tiers_indicator pon_auction_headers_all.PRICE_TIERS_INDICATOR%TYPE;
7557: --added by Allen Yang for Surrogate Bid 2008/09/03
7558: --------------------------------------------------------------------------------------
7559: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
7560: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
7561: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
7562: l_two_part_tech_surrogate_flag VARCHAR2(1);
7563: --------------------------------------------------------------------------------------

Line 7560: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;

7556: l_price_tiers_indicator pon_auction_headers_all.PRICE_TIERS_INDICATOR%TYPE;
7557: --added by Allen Yang for Surrogate Bid 2008/09/03
7558: --------------------------------------------------------------------------------------
7559: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
7560: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
7561: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
7562: l_two_part_tech_surrogate_flag VARCHAR2(1);
7563: --------------------------------------------------------------------------------------
7564:

Line 7565: l_doctype_id PON_AUCTION_HEADERS_ALL.doctype_id%TYPE;

7561: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
7562: l_two_part_tech_surrogate_flag VARCHAR2(1);
7563: --------------------------------------------------------------------------------------
7564:
7565: l_doctype_id PON_AUCTION_HEADERS_ALL.doctype_id%TYPE;
7566:
7567: l_evaluation_flag VARCHAR2(1); -- Added for ER: Supplier Management: Supplier Evaluation
7568:
7569: BEGIN

Line 7573: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auc_header_id;

7569: BEGIN
7570:
7571: BEGIN
7572:
7573: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auc_header_id;
7574:
7575: SELECT
7576: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

Line 7664: FROM pon_auction_headers_all ah, pon_bid_headers bh,

7660: l_technical_evaluation_status,
7661: l_surrogate_bid_flag,
7662: --------------------------------------------------
7663: l_evaluation_flag -- Added for ER: Supplier Management: Supplier Evaluation
7664: FROM pon_auction_headers_all ah, pon_bid_headers bh,
7665: fnd_currencies fc, pon_bid_headers old_bh
7666: WHERE ah.auction_header_id = p_auc_header_id
7667: AND ah.auction_header_id = bh.auction_header_id
7668: AND bh.bid_number = p_bid_number