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_PRINTING_PKG dependencies on PON_BID_HEADERS

Line 872: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;

868:
869: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;
870: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;
871: l_start_price_from_prev_rnd VARCHAR2(1);
872: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;
873: l_contract_type pon_auction_headers_all.contract_type%TYPE;
874: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
875: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
876:

Line 882: l_bid_currency_code pon_bid_headers.bid_currency_code%type;

878: l_is_bidpdf VARCHAR2(1) := 'Y';
879: l_is_supplier_bidpdf VARCHAR2(1) := 'N';
880: l_is_buyer_negpdf VARCHAR2(1) := 'N';
881:
882: l_bid_currency_code pon_bid_headers.bid_currency_code%type;
883: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
884: -- bidpdf: address of supplier:
885: l_supplier_address_line1 hz_parties.address1%type;
886: l_supplier_address_line2 hz_parties.address2%type;

Line 883: l_bid_price_precision pon_bid_headers.number_price_decimals%type;

879: l_is_supplier_bidpdf VARCHAR2(1) := 'N';
880: l_is_buyer_negpdf VARCHAR2(1) := 'N';
881:
882: l_bid_currency_code pon_bid_headers.bid_currency_code%type;
883: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
884: -- bidpdf: address of supplier:
885: l_supplier_address_line1 hz_parties.address1%type;
886: l_supplier_address_line2 hz_parties.address2%type;
887: l_supplier_address_line3 hz_parties.address3%type;

Line 915: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;

911: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE; -- two-part flag
912: -- commercial lock status
913: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%TYPE;
914: -- technical shortlist status
915: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;
916: --added by Allen Yang for Surrogate Bid 2008/09/04
917: ---------------------------------------------------------------
918: l_tech_evaluation_status PON_AUCTION_HEADERS_ALL.Technical_Evaluation_Status%TYPE;
919: l_surrogate_bid_flag PON_BID_HEADERS.Surrog_Bid_Flag%TYPE;

Line 919: l_surrogate_bid_flag PON_BID_HEADERS.Surrog_Bid_Flag%TYPE;

915: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;
916: --added by Allen Yang for Surrogate Bid 2008/09/04
917: ---------------------------------------------------------------
918: l_tech_evaluation_status PON_AUCTION_HEADERS_ALL.Technical_Evaluation_Status%TYPE;
919: l_surrogate_bid_flag PON_BID_HEADERS.Surrog_Bid_Flag%TYPE;
920: CURSOR tech_surrogate_bid_cur IS
921: SELECT
922: paha.Technical_Evaluation_Status
923: , pbh.SURROG_BID_FLAG

Line 925: pon_auction_headers_all paha, pon_bid_headers pbh

921: SELECT
922: paha.Technical_Evaluation_Status
923: , pbh.SURROG_BID_FLAG
924: FROM
925: pon_auction_headers_all paha, pon_bid_headers pbh
926: WHERE paha.auction_header_id=pbh.auction_header_id
927: AND paha.auction_header_id=p_auction_header_id
928: AND pbh.bid_number = p_bid_number;
929: ----------------------------------------------------------------

Line 965: from pon_bid_headers

961: l_vendor_id,
962: l_trading_partner_id,
963: l_bid_rate,
964: l_tech_shortlist_flag
965: from pon_bid_headers
966: where bid_number = p_bid_number;
967: EXCEPTION
968: WHEN no_data_found THEN
969: l_is_bidpdf := 'N';

Line 1060: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)

1056: IF l_vendor_site_id <= 0 THEN
1057: BEGIN
1058: -- bidpdf: address/contact of supplier company
1059: select hz_parties.address1, hz_parties.address2, hz_parties.address3, hz_parties.city, hz_parties.state, hz_parties.postal_code, hz_parties.country, nvl(entity_terr.territory_short_name,hz_parties.country)
1060: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
1061: into l_supplier_address_line1,l_supplier_address_line2,l_supplier_address_line3,l_supplier_address_city,l_supplier_address_state,l_supplier_postal_code,l_supplier_country_code,l_supplier_country
1062: ,l_contact_details_name
1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id

Line 1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr

1059: select hz_parties.address1, hz_parties.address2, hz_parties.address3, hz_parties.city, hz_parties.state, hz_parties.postal_code, hz_parties.country, nvl(entity_terr.territory_short_name,hz_parties.country)
1060: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
1061: into l_supplier_address_line1,l_supplier_address_line2,l_supplier_address_line3,l_supplier_address_city,l_supplier_address_state,l_supplier_postal_code,l_supplier_country_code,l_supplier_country
1062: ,l_contact_details_name
1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id
1065: and pon_bid_headers.bid_number = p_bid_number
1066: and entity_terr.territory_code(+) = hz_parties.country
1067: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')

Line 1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id

1060: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
1061: into l_supplier_address_line1,l_supplier_address_line2,l_supplier_address_line3,l_supplier_address_city,l_supplier_address_state,l_supplier_postal_code,l_supplier_country_code,l_supplier_country
1062: ,l_contact_details_name
1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id
1065: and pon_bid_headers.bid_number = p_bid_number
1066: and entity_terr.territory_code(+) = hz_parties.country
1067: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')
1068: and entity_terr.language(+) = l_printing_language

Line 1065: and pon_bid_headers.bid_number = p_bid_number

1061: into l_supplier_address_line1,l_supplier_address_line2,l_supplier_address_line3,l_supplier_address_city,l_supplier_address_state,l_supplier_postal_code,l_supplier_country_code,l_supplier_country
1062: ,l_contact_details_name
1063: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
1064: where pon_bid_headers.trading_partner_id = hz_parties.party_id
1065: and pon_bid_headers.bid_number = p_bid_number
1066: and entity_terr.territory_code(+) = hz_parties.country
1067: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')
1068: and entity_terr.language(+) = l_printing_language
1069: and rownum = 1;

Line 1194: FROM pon_bid_headers pbh

1190:
1191: BEGIN
1192: SELECT pbh.bid_number
1193: INTO l_prev_rnd_bid_number
1194: FROM pon_bid_headers pbh
1195: WHERE pbh.auction_header_id = l_auction_header_id_prev_round
1196: AND pbh.bid_status = 'ACTIVE'
1197: AND pbh.trading_partner_id = p_trading_partner_id
1198: AND pbh.trading_partner_contact_id = p_trading_partner_contact_id

Line 1509: -- for bidpdf, the Company Name comes from pon_bid_headers.trading_partner_name

1505: nvl2(pah.source_doc_msg_app, nvl2(pah.source_doc_msg, fnd_message.get_string(pah.source_doc_msg_app, pah.source_doc_msg), null), null) source_doc_msg_text,
1506: nvl2(pah.source_doc_msg_app, nvl2(pah.source_doc_line_msg, fnd_message.get_string(pah.source_doc_msg_app, pah.source_doc_line_msg), null), null) source_doc_msg_line_text,
1507: fpg.multi_org_flag,
1508: p_user_view_type as user_view_type,
1509: -- for bidpdf, the Company Name comes from pon_bid_headers.trading_partner_name
1510: decode(l_is_bidpdf, 'Y', pbhs.trading_partner_name,decode(p_trading_partner_id, null, p_requested_supplier_name, p_trading_partner_name)) as user_trading_partner_name,
1511: l_award_approval_enabled as award_approval_enabled,
1512: ns.style_name,
1513: pah.progress_payment_type,

Line 2706: ad.entity_name IN ('PON_BID_HEADERS',

2702: fnd_document_categories categories,
2703: fnd_document_categories_tl categories_tl
2704: where d.document_id = ad.document_id
2705: and
2706: ad.entity_name IN ('PON_BID_HEADERS',
2707: 'PON_BID_ITEM_PRICES')
2708: and ad.pk1_value = to_char(p_auction_header_id)
2709: and ad.pk2_value = to_char(pbhs.bid_number)
2710: --and categories.name=pon_auction_pkg.g_supplier_attachment

Line 3161: pon_bid_headers pbhs,

3157: pa_projects_all proj,
3158: fnd_user buyer_user,
3159: per_phones buyer_phone,
3160: per_phones buyer_fax,
3161: pon_bid_headers pbhs,
3162: fnd_lookup_values fl_bid
3163: where pah.auction_header_id = p_auction_header_id
3164: and pbhs.auction_header_id (+) = pah.auction_header_id
3165: and pbhs.bid_number (+) = p_bid_number