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 505: FROM pon_bid_headers bh

501:
502: -- Determine if the bid header was modified
503: SELECT decode(count(bh.bid_number), 0, 'N', 'Y')
504: INTO l_header_modified
505: FROM pon_bid_headers bh
506: WHERE bh.bid_number = p_bid_number
507: AND ((bh.old_note_to_auction_owner IS null
508: AND bh.note_to_auction_owner IS NOT null
509: OR bh.old_note_to_auction_owner IS NOT null

Line 551: 'PON_BID_HEADERS',

547: BID_NUMBER,
548: EXPIRATION_DATE)
549: VALUES
550: (p_interface_type,
551: 'PON_BID_HEADERS',
552: p_batch_id,
553: 'PON_BID_NO_CHANGES',
554: p_userid,
555: sysdate,

Line 580: 'PON_BID_HEADERS',

576: BID_NUMBER,
577: EXPIRATION_DATE)
578: VALUES
579: (p_interface_type,
580: 'PON_BID_HEADERS',
581: p_batch_id,
582: 'PON_MUST_BIDALL_ITEMS' || p_suffix,
583: p_userid,
584: sysdate,

Line 609: 'PON_BID_HEADERS',

605: BID_NUMBER,
606: EXPIRATION_DATE)
607: VALUES
608: (p_interface_type,
609: 'PON_BID_HEADERS',
610: p_batch_id,
611: 'PON_MUST_BID_ATLEAST_ONE' || p_suffix,
612: p_userid,
613: sysdate,

Line 646: pon_bid_headers pbh

642: pon_auction_item_prices_all paip
643: -- added by Allen Yang for surrogate bid bug 7703665, #8220778 2009/02/03
644: ---------------------------------------------------------------
645: , pon_auction_headers_all paha,
646: pon_bid_headers pbh
647: ---------------------------------------------------------------
648: WHERE bl.bid_number = p_bid_number and
649: bl.auction_header_id = paip.auction_header_id and
650: bl.line_number = paip.line_number

Line 791: , pon_bid_headers pbh

787: to_number(null)) s_worksheet_sequence_number,
788: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
789: FROM pon_bid_item_prices bl
790: , pon_auction_item_prices_all al
791: , pon_bid_headers pbh
792: WHERE bl.bid_number = p_bid_number
793: AND al.auction_header_id = bl.auction_header_id
794: AND al.line_number = bl.line_number
795: AND al.auction_header_id = p_auc_header_id

Line 809: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

805: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
806: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
807: p_interface_type IN pon_interface_errors.interface_type%TYPE,
808: p_userid IN pon_interface_errors.created_by%TYPE,
809: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
810: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
811: p_spreadsheet IN VARCHAR2,
812: p_blanket IN VARCHAR2,
813: p_global IN VARCHAR2,

Line 810: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

806: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
807: p_interface_type IN pon_interface_errors.interface_type%TYPE,
808: p_userid IN pon_interface_errors.created_by%TYPE,
809: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
810: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
811: p_spreadsheet IN VARCHAR2,
812: p_blanket IN VARCHAR2,
813: p_global IN VARCHAR2,
814: p_trans_view IN VARCHAR2,

Line 822: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,

818: p_price_driven IN VARCHAR2,
819: p_percent_decr IN VARCHAR2,
820: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,
821: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
822: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
823: p_rate IN pon_bid_headers.rate%TYPE,
824: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
825: p_amt_precision IN fnd_currencies.precision%TYPE,
826: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,

Line 823: p_rate IN pon_bid_headers.rate%TYPE,

819: p_percent_decr IN VARCHAR2,
820: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,
821: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
822: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
823: p_rate IN pon_bid_headers.rate%TYPE,
824: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
825: p_amt_precision IN fnd_currencies.precision%TYPE,
826: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
827: p_suffix IN VARCHAR2,

Line 824: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

820: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,
821: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
822: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
823: p_rate IN pon_bid_headers.rate%TYPE,
824: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
825: p_amt_precision IN fnd_currencies.precision%TYPE,
826: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
827: p_suffix IN VARCHAR2,
828: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 826: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,

822: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
823: p_rate IN pon_bid_headers.rate%TYPE,
824: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
825: p_amt_precision IN fnd_currencies.precision%TYPE,
826: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
827: p_suffix IN VARCHAR2,
828: p_batch_id IN pon_interface_errors.batch_id%TYPE,
829: p_request_id IN pon_interface_errors.request_id%TYPE
830: --added by Allen Yang for Surrogate Bid 2008/09/03

Line 1602: , pon_bid_headers pbh

1598: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
1599: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
1600: FROM pon_auction_item_prices_all al
1601: , pon_bid_item_prices bl
1602: , pon_bid_headers pbh
1603: WHERE al.auction_header_id = p_auc_header_id
1604: AND bl.bid_number = p_bid_number
1605: AND al.line_number = bl.line_number
1606: AND bl.is_changed_line_flag = 'Y'

Line 2477: pon_bid_headers bh

2473: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
2474: bh.rate s_rate,
2475: bh.number_price_decimals s_precision
2476: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,
2477: pon_bid_headers bh
2478: WHERE al.auction_header_id = p_auc_header_id
2479: AND bh.bid_number = p_bid_number
2480: AND bl.bid_number = p_bid_number
2481: AND al.line_number = bl.line_number

Line 3438: , pon_bid_headers pbh

3434: FROM pon_bid_attribute_values ba
3435: , pon_auction_attributes aa
3436: , pon_auction_item_prices_all al
3437: , pon_bid_item_prices bl
3438: , pon_bid_headers pbh
3439: WHERE ba.bid_number = p_bid_number
3440: AND ba.line_number <> -1
3441: AND aa.auction_header_id = ba.auction_header_id
3442: AND aa.line_number = ba.line_number

Line 3462: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

3458: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3459: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3460: p_userid IN pon_interface_errors.created_by%TYPE,
3461: p_spreadsheet IN VARCHAR2,
3462: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3463: p_amt_precision IN fnd_currencies.precision%TYPE,
3464: p_suffix IN VARCHAR2,
3465: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3466: p_request_id IN pon_interface_errors.request_id%TYPE

Line 3790: , pon_bid_headers pbh

3786: FROM pon_bid_price_elements bpf
3787: , pon_auction_item_prices_all al
3788: , pon_bid_item_prices bl
3789: , pon_price_element_types_tl pft
3790: , pon_bid_headers pbh
3791: WHERE bpf.bid_number = p_bid_number
3792: AND bpf.pf_type = 'SUPPLIER' -- only validate SUPPLIER cost factors
3793: AND al.auction_header_id = bpf.auction_header_id
3794: AND al.line_number = bpf.line_number

Line 3813: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

3809: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3810: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3811: p_userid IN pon_interface_errors.created_by%TYPE,
3812: p_spreadsheet IN VARCHAR2,
3813: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3814: p_trans_view IN VARCHAR2,
3815: p_blanket IN VARCHAR2,
3816: p_header_disp_pf IN VARCHAR2,
3817: p_po_start_date IN pon_auction_headers_all.po_start_date%TYPE,

Line 4901: , pon_bid_headers pbh

4897: ) s_entity_name
4898: FROM pon_bid_shipments bpb
4899: , pon_bid_item_prices bl
4900: , pon_auction_item_prices_all al
4901: , pon_bid_headers pbh
4902: WHERE bpb.bid_number = p_bid_number
4903: AND bl.bid_number = bpb.bid_number
4904: AND bl.line_number = bpb.line_number
4905: AND al.auction_header_id = bpb.auction_header_id

Line 4937: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

4933: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4934: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4935: p_userid IN pon_interface_errors.created_by%TYPE,
4936: p_spreadsheet IN VARCHAR2,
4937: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4938: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4939: p_request_id IN pon_interface_errors.request_id%TYPE,
4940: p_contract_type IN pon_bid_headers.contract_type%TYPE
4941: ) IS

Line 4940: p_contract_type IN pon_bid_headers.contract_type%TYPE

4936: p_spreadsheet IN VARCHAR2,
4937: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4938: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4939: p_request_id IN pon_interface_errors.request_id%TYPE,
4940: p_contract_type IN pon_bid_headers.contract_type%TYPE
4941: ) IS
4942:
4943: BEGIN
4944:

Line 5751: , pon_bid_headers pbh

5747: FROM pon_bid_shipments shipments
5748: WHERE shipments.bid_number = p_bid_number
5749: GROUP BY shipments.bid_number,
5750: shipments.line_number) max_bid_shipments
5751: , pon_bid_headers pbh
5752: WHERE bpb.bid_number = p_bid_number
5753: AND bpb.bid_number = max_bid_shipments.bid_number
5754: AND bpb.line_number = max_bid_shipments.line_number
5755: AND bl.bid_number = bpb.bid_number

Line 5814: , pon_bid_headers pbh

5810: 'LINENUM',
5811: al.document_disp_line_number
5812: From pon_bid_item_prices bl
5813: , pon_auction_item_prices_all al
5814: , pon_bid_headers pbh
5815: where bl.bid_number = p_bid_number
5816: AND al.auction_header_id = bl.auction_header_id
5817: AND al.line_number = bl.line_number
5818: AND bl.is_changed_line_flag = 'Y'

Line 6263: , pon_bid_headers pbh

6259: , pon_auction_item_prices_all al
6260: , pon_price_differentials apd
6261: , pon_auction_shipments_all apb
6262: , po_price_diff_lookups_v pdl
6263: , pon_bid_headers pbh
6264: WHERE bpd.bid_number = p_bid_number
6265: AND bl.bid_number = bpd.bid_number
6266: AND bl.line_number = bpd.line_number
6267: AND al.auction_header_id = bpd.auction_header_id

Line 6292: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

6288: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6289: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6290: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6291: p_userid IN pon_interface_errors.created_by%TYPE,
6292: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
6293: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6294: p_request_id IN pon_interface_errors.request_id%TYPE
6295: ) IS
6296: l_loginid NUMBER;

Line 6679: l_rate pon_bid_headers.rate%TYPE;

6675: p_spreadsheet IN VARCHAR2,
6676: x_return_status OUT NOCOPY NUMBER,
6677: x_return_code OUT NOCOPY VARCHAR2
6678: ) IS
6679: l_rate pon_bid_headers.rate%TYPE;
6680: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
6681: l_amt_precision fnd_currencies.precision%TYPE;
6682:
6683: l_source_bid pon_bid_headers.bid_number%TYPE;

Line 6680: l_price_precision pon_bid_headers.number_price_decimals%TYPE;

6676: x_return_status OUT NOCOPY NUMBER,
6677: x_return_code OUT NOCOPY VARCHAR2
6678: ) IS
6679: l_rate pon_bid_headers.rate%TYPE;
6680: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
6681: l_amt_precision fnd_currencies.precision%TYPE;
6682:
6683: l_source_bid pon_bid_headers.bid_number%TYPE;
6684: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;

Line 6683: l_source_bid pon_bid_headers.bid_number%TYPE;

6679: l_rate pon_bid_headers.rate%TYPE;
6680: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
6681: l_amt_precision fnd_currencies.precision%TYPE;
6682:
6683: l_source_bid pon_bid_headers.bid_number%TYPE;
6684: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;
6685: l_min_bid_decr pon_auction_headers_all.min_bid_decrement%TYPE;
6686: l_percent_decr VARCHAR2(1);
6687: l_bid_decr_method pon_auction_headers_all.bid_decrement_method%TYPE;

Line 6684: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;

6680: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
6681: l_amt_precision fnd_currencies.precision%TYPE;
6682:
6683: l_source_bid pon_bid_headers.bid_number%TYPE;
6684: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;
6685: l_min_bid_decr pon_auction_headers_all.min_bid_decrement%TYPE;
6686: l_percent_decr VARCHAR2(1);
6687: l_bid_decr_method pon_auction_headers_all.bid_decrement_method%TYPE;
6688:

Line 6695: l_tpid pon_bid_headers.trading_partner_id%TYPE;

6691: l_auc_close_date pon_auction_headers_all.close_bidding_date%TYPE;
6692: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
6693: l_contract_type pon_auction_headers_all.contract_type%TYPE;
6694:
6695: l_tpid pon_bid_headers.trading_partner_id%TYPE;
6696: l_vensid pon_bid_headers.vendor_site_id%TYPE;
6697: l_bid_curr_code pon_bid_headers.bid_currency_code%TYPE;
6698:
6699: l_mas VARCHAR2(1);

Line 6696: l_vensid pon_bid_headers.vendor_site_id%TYPE;

6692: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
6693: l_contract_type pon_auction_headers_all.contract_type%TYPE;
6694:
6695: l_tpid pon_bid_headers.trading_partner_id%TYPE;
6696: l_vensid pon_bid_headers.vendor_site_id%TYPE;
6697: l_bid_curr_code pon_bid_headers.bid_currency_code%TYPE;
6698:
6699: l_mas VARCHAR2(1);
6700: l_blanket VARCHAR2(1);

Line 6697: l_bid_curr_code pon_bid_headers.bid_currency_code%TYPE;

6693: l_contract_type pon_auction_headers_all.contract_type%TYPE;
6694:
6695: l_tpid pon_bid_headers.trading_partner_id%TYPE;
6696: l_vensid pon_bid_headers.vendor_site_id%TYPE;
6697: l_bid_curr_code pon_bid_headers.bid_currency_code%TYPE;
6698:
6699: l_mas VARCHAR2(1);
6700: l_blanket VARCHAR2(1);
6701: l_global VARCHAR2(1);

Line 6718: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;

6714: --added by Allen Yang for Surrogate Bid 2008/09/03
6715: --------------------------------------------------------------------------------------
6716: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
6717: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
6718: l_surrogate_bid_flag pon_bid_headers.SURROG_BID_FLAG%TYPE;
6719: l_two_part_tech_surrogate_flag VARCHAR2(1);
6720: --------------------------------------------------------------------------------------
6721: BEGIN
6722:

Line 6795: FROM pon_auction_headers_all ah, pon_bid_headers bh,

6791: , l_two_part_flag,
6792: l_technical_evaluation_status,
6793: l_surrogate_bid_flag
6794: --------------------------------------------------
6795: FROM pon_auction_headers_all ah, pon_bid_headers bh,
6796: fnd_currencies fc, pon_bid_headers old_bh
6797: WHERE ah.auction_header_id = p_auc_header_id
6798: AND ah.auction_header_id = bh.auction_header_id
6799: AND bh.bid_number = p_bid_number

Line 6796: fnd_currencies fc, pon_bid_headers old_bh

6792: l_technical_evaluation_status,
6793: l_surrogate_bid_flag
6794: --------------------------------------------------
6795: FROM pon_auction_headers_all ah, pon_bid_headers bh,
6796: fnd_currencies fc, pon_bid_headers old_bh
6797: WHERE ah.auction_header_id = p_auc_header_id
6798: AND ah.auction_header_id = bh.auction_header_id
6799: AND bh.bid_number = p_bid_number
6800: AND fc.currency_code = bh.bid_currency_code