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_BID_HEADERS

Line 523: FROM pon_bid_headers bh

519:
520: -- Determine if the bid header was modified
521: SELECT decode(count(bh.bid_number), 0, 'N', 'Y')
522: INTO l_header_modified
523: FROM pon_bid_headers bh
524: WHERE bh.bid_number = p_bid_number
525: AND ((bh.old_note_to_auction_owner IS null
526: AND bh.note_to_auction_owner IS NOT null
527: OR bh.old_note_to_auction_owner IS NOT null

Line 599: 'PON_BID_HEADERS',

595: BID_NUMBER,
596: EXPIRATION_DATE)
597: VALUES
598: (p_interface_type,
599: 'PON_BID_HEADERS',
600: p_batch_id,
601: 'PON_BID_NO_CHANGES',
602: p_userid,
603: sysdate,

Line 629: 'PON_BID_HEADERS',

625: BID_NUMBER,
626: EXPIRATION_DATE)
627: VALUES
628: (p_interface_type,
629: 'PON_BID_HEADERS',
630: p_batch_id,
631: 'PON_MUST_BIDALL_ITEMS' || p_suffix,
632: p_userid,
633: sysdate,

Line 665: 'PON_BID_HEADERS',

661: BID_NUMBER,
662: EXPIRATION_DATE)
663: VALUES
664: (p_interface_type,
665: 'PON_BID_HEADERS',
666: p_batch_id,
667: 'PON_MUST_BID_ATLEAST_ONE' || p_suffix,
668: p_userid,
669: sysdate,

Line 712: pon_bid_headers pbh

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
716: bl.line_number = paip.line_number

Line 862: , pon_bid_headers pbh

858: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
859: al.line_num_display s_clm_line_num_display
860: FROM pon_bid_item_prices bl
861: , pon_auction_item_prices_all al
862: , pon_bid_headers pbh
863: WHERE bl.bid_number = p_bid_number
864: AND al.auction_header_id = bl.auction_header_id
865: AND al.line_number = bl.line_number
866: AND al.auction_header_id = p_auc_header_id

Line 880: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

876: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
877: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
878: p_interface_type IN pon_interface_errors.interface_type%TYPE,
879: p_userid IN pon_interface_errors.created_by%TYPE,
880: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
881: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
882: p_spreadsheet IN VARCHAR2,
883: p_blanket IN VARCHAR2,
884: p_global IN VARCHAR2,

Line 881: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

877: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
878: p_interface_type IN pon_interface_errors.interface_type%TYPE,
879: p_userid IN pon_interface_errors.created_by%TYPE,
880: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
881: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
882: p_spreadsheet IN VARCHAR2,
883: p_blanket IN VARCHAR2,
884: p_global IN VARCHAR2,
885: p_trans_view IN VARCHAR2,

Line 893: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,

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,
897: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,

Line 894: p_rate IN pon_bid_headers.rate%TYPE,

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,
897: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
898: p_suffix IN VARCHAR2,

Line 895: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

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,
897: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
898: p_suffix IN VARCHAR2,
899: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 897: p_bid_curr_code IN pon_bid_headers.bid_currency_code%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,
897: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
898: p_suffix IN VARCHAR2,
899: p_batch_id IN pon_interface_errors.batch_id%TYPE,
900: p_request_id IN pon_interface_errors.request_id%TYPE
901: --added by Allen Yang for Surrogate Bid 2008/09/03

Line 2157: , pon_bid_headers pbh

2153: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
2154: al.line_num_display s_clm_line_num_display
2155: FROM pon_auction_item_prices_all al
2156: , pon_bid_item_prices bl
2157: , pon_bid_headers pbh
2158: WHERE al.auction_header_id = p_auc_header_id
2159: AND bl.bid_number = p_bid_number
2160: AND al.line_number = bl.line_number
2161: AND bl.is_changed_line_flag = 'Y'

Line 3129: pon_bid_headers bh

3125: al.line_num_display s_clm_line_num_display,
3126: nvl(bl.clm_cost_constraint,'X') s_clm_cost_constraint, -- CLM QA Bug : 9835426
3127: al.order_type_lookup_code s_order_type_lookup_code --For clm bug : 10136754
3128: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,
3129: pon_bid_headers bh
3130: WHERE al.auction_header_id = p_auc_header_id
3131: AND bh.bid_number = p_bid_number
3132: AND bl.bid_number = p_bid_number
3133: AND al.line_number = bl.line_number

Line 3970: , pon_bid_headers pbh

3966: ---------------------------------------------------
3967: , pon_auction_sections pas
3968: ---------------------------------------------------
3969: ---- Supplier Management: Supplier Evaluation -----
3970: , pon_bid_headers pbh
3971: ---------------------------------------------------
3972: WHERE ba.bid_number = p_bid_number
3973: AND ba.line_number = -1
3974: AND aa.auction_header_id = ba.auction_header_id

Line 4140: , pon_bid_headers pbh

4136: FROM pon_bid_attribute_values ba
4137: , pon_auction_attributes aa
4138: , pon_auction_item_prices_all al
4139: , pon_bid_item_prices bl
4140: , pon_bid_headers pbh
4141: WHERE ba.bid_number = p_bid_number
4142: AND ba.line_number <> -1
4143: AND aa.auction_header_id = ba.auction_header_id
4144: AND aa.line_number = ba.line_number

Line 4164: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

4160: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4161: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4162: p_userid IN pon_interface_errors.created_by%TYPE,
4163: p_spreadsheet IN VARCHAR2,
4164: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4165: p_amt_precision IN fnd_currencies.precision%TYPE,
4166: p_suffix IN VARCHAR2,
4167: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4168: p_request_id IN pon_interface_errors.request_id%TYPE

Line 4498: , pon_bid_headers pbh

4494: FROM pon_bid_price_elements bpf
4495: , pon_auction_item_prices_all al
4496: , pon_bid_item_prices bl
4497: , pon_price_element_types_tl pft
4498: , pon_bid_headers pbh
4499: WHERE bpf.bid_number = p_bid_number
4500: AND bpf.pf_type = 'SUPPLIER' -- only validate SUPPLIER cost factors
4501: AND al.auction_header_id = bpf.auction_header_id
4502: AND al.line_number = bpf.line_number

Line 4521: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

4517: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4518: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4519: p_userid IN pon_interface_errors.created_by%TYPE,
4520: p_spreadsheet IN VARCHAR2,
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,

Line 5629: , pon_bid_headers pbh

5625: al.line_num_display s_clm_line_num_display
5626: FROM pon_bid_shipments bpb
5627: , pon_bid_item_prices bl
5628: , pon_auction_item_prices_all al
5629: , pon_bid_headers pbh
5630: WHERE bpb.bid_number = p_bid_number
5631: AND bl.bid_number = bpb.bid_number
5632: AND bl.line_number = bpb.line_number
5633: AND al.auction_header_id = bpb.auction_header_id

Line 5665: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

5661: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
5662: p_interface_type IN pon_interface_errors.interface_type%TYPE,
5663: p_userid IN pon_interface_errors.created_by%TYPE,
5664: p_spreadsheet IN VARCHAR2,
5665: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
5666: p_batch_id IN pon_interface_errors.batch_id%TYPE,
5667: p_request_id IN pon_interface_errors.request_id%TYPE,
5668: p_contract_type IN pon_bid_headers.contract_type%TYPE
5669: ) IS

Line 5668: p_contract_type IN pon_bid_headers.contract_type%TYPE

5664: p_spreadsheet IN VARCHAR2,
5665: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
5666: p_batch_id IN pon_interface_errors.batch_id%TYPE,
5667: p_request_id IN pon_interface_errors.request_id%TYPE,
5668: p_contract_type IN pon_bid_headers.contract_type%TYPE
5669: ) IS
5670:
5671: BEGIN
5672:

Line 6492: , pon_bid_headers pbh

6488: FROM pon_bid_shipments shipments
6489: WHERE shipments.bid_number = p_bid_number
6490: GROUP BY shipments.bid_number,
6491: shipments.line_number) max_bid_shipments
6492: , pon_bid_headers pbh
6493: WHERE bpb.bid_number = p_bid_number
6494: AND bpb.bid_number = max_bid_shipments.bid_number
6495: AND bpb.line_number = max_bid_shipments.line_number
6496: AND bl.bid_number = bpb.bid_number

Line 6555: , pon_bid_headers pbh

6551: 'LINENUM',
6552: al.document_disp_line_number
6553: From pon_bid_item_prices bl
6554: , pon_auction_item_prices_all al
6555: , pon_bid_headers pbh
6556: where bl.bid_number = p_bid_number
6557: AND al.auction_header_id = bl.auction_header_id
6558: AND al.line_number = bl.line_number
6559: AND bl.is_changed_line_flag = 'Y'

Line 7011: , pon_bid_headers pbh

7007: , pon_auction_item_prices_all al
7008: , pon_price_differentials apd
7009: , pon_auction_shipments_all apb
7010: , po_price_diff_lookups_v pdl
7011: , pon_bid_headers pbh
7012: WHERE bpd.bid_number = p_bid_number
7013: AND bl.bid_number = bpd.bid_number
7014: AND bl.line_number = bpd.line_number
7015: AND al.auction_header_id = bpd.auction_header_id

Line 7040: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

7036: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7037: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7038: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7039: p_userid IN pon_interface_errors.created_by%TYPE,
7040: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
7041: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7042: p_request_id IN pon_interface_errors.request_id%TYPE
7043: ) IS
7044: l_loginid NUMBER;

Line 7428: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

7424: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7425: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7426: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7427: p_userid IN pon_interface_errors.created_by%TYPE,
7428: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
7429: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7430: p_request_id IN pon_interface_errors.request_id%TYPE
7431: )
7432: IS

Line 7458: pon_bid_headers pbh,

7454: 'RECEIVE_ERROR', 'NOT_PAID',
7455: petr.status_lookup_code)
7456: into l_emd_status
7457: from pon_emd_transactions petr,
7458: pon_bid_headers pbh,
7459: pon_bidding_parties pbp
7460: where pbh.bid_number = p_bid_number
7461: and pbh.auction_header_id=p_auc_header_id
7462: and pbp.trading_partner_id = pbh.trading_partner_id

Line 7522: l_rate pon_bid_headers.rate%TYPE;

7518: p_spreadsheet IN VARCHAR2,
7519: x_return_status OUT NOCOPY NUMBER,
7520: x_return_code OUT NOCOPY VARCHAR2
7521: ) IS
7522: l_rate pon_bid_headers.rate%TYPE;
7523: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
7524: l_amt_precision fnd_currencies.precision%TYPE;
7525:
7526: l_source_bid pon_bid_headers.bid_number%TYPE;

Line 7523: l_price_precision pon_bid_headers.number_price_decimals%TYPE;

7519: x_return_status OUT NOCOPY NUMBER,
7520: x_return_code OUT NOCOPY VARCHAR2
7521: ) IS
7522: l_rate pon_bid_headers.rate%TYPE;
7523: l_price_precision pon_bid_headers.number_price_decimals%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;

Line 7526: l_source_bid pon_bid_headers.bid_number%TYPE;

7522: l_rate pon_bid_headers.rate%TYPE;
7523: l_price_precision pon_bid_headers.number_price_decimals%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;

Line 7527: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;

7523: l_price_precision pon_bid_headers.number_price_decimals%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:

Line 7538: l_tpid pon_bid_headers.trading_partner_id%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;
7541:
7542: l_mas VARCHAR2(1);

Line 7539: l_vensid pon_bid_headers.vendor_site_id%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;
7541:
7542: l_mas VARCHAR2(1);
7543: l_blanket VARCHAR2(1);

Line 7540: l_bid_curr_code pon_bid_headers.bid_currency_code%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;
7541:
7542: l_mas VARCHAR2(1);
7543: l_blanket VARCHAR2(1);
7544: l_global VARCHAR2(1);

Line 7561: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%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:
7565: l_doctype_id PON_AUCTION_HEADERS_ALL.doctype_id%TYPE;

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

Line 7665: fnd_currencies fc, pon_bid_headers old_bh

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
7669: AND fc.currency_code = bh.bid_currency_code