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 1807: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;

1803:
1804: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;
1805: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;
1806: l_start_price_from_prev_rnd VARCHAR2(1);
1807: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;
1808: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1809: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
1810: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
1811:

Line 1817: l_bid_currency_code pon_bid_headers.bid_currency_code%type;

1813: l_is_bidpdf VARCHAR2(1) := 'Y';
1814: l_is_supplier_bidpdf VARCHAR2(1) := 'N';
1815: l_is_buyer_negpdf VARCHAR2(1) := 'N';
1816:
1817: l_bid_currency_code pon_bid_headers.bid_currency_code%type;
1818: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
1819: -- bidpdf: address of supplier:
1820: l_supplier_address_line1 hz_parties.address1%type;
1821: l_supplier_address_line2 hz_parties.address2%type;

Line 1818: l_bid_price_precision pon_bid_headers.number_price_decimals%type;

1814: l_is_supplier_bidpdf VARCHAR2(1) := 'N';
1815: l_is_buyer_negpdf VARCHAR2(1) := 'N';
1816:
1817: l_bid_currency_code pon_bid_headers.bid_currency_code%type;
1818: l_bid_price_precision pon_bid_headers.number_price_decimals%type;
1819: -- bidpdf: address of supplier:
1820: l_supplier_address_line1 hz_parties.address1%type;
1821: l_supplier_address_line2 hz_parties.address2%type;
1822: l_supplier_address_line3 hz_parties.address3%type;

Line 1850: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;

1846: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE; -- two-part flag
1847: -- commercial lock status
1848: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%TYPE;
1849: -- technical shortlist status
1850: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;
1851: --added by Allen Yang for Surrogate Bid 2008/09/04
1852: ---------------------------------------------------------------
1853: l_tech_evaluation_status PON_AUCTION_HEADERS_ALL.Technical_Evaluation_Status%TYPE;
1854: l_surrogate_bid_flag PON_BID_HEADERS.Surrog_Bid_Flag%TYPE;

Line 1854: l_surrogate_bid_flag PON_BID_HEADERS.Surrog_Bid_Flag%TYPE;

1850: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;
1851: --added by Allen Yang for Surrogate Bid 2008/09/04
1852: ---------------------------------------------------------------
1853: l_tech_evaluation_status PON_AUCTION_HEADERS_ALL.Technical_Evaluation_Status%TYPE;
1854: l_surrogate_bid_flag PON_BID_HEADERS.Surrog_Bid_Flag%TYPE;
1855: CURSOR tech_surrogate_bid_cur IS
1856: SELECT
1857: paha.Technical_Evaluation_Status
1858: , pbh.SURROG_BID_FLAG

Line 1860: pon_auction_headers_all paha, pon_bid_headers pbh

1856: SELECT
1857: paha.Technical_Evaluation_Status
1858: , pbh.SURROG_BID_FLAG
1859: FROM
1860: pon_auction_headers_all paha, pon_bid_headers pbh
1861: WHERE paha.auction_header_id=pbh.auction_header_id
1862: AND paha.auction_header_id=p_auction_header_id
1863: AND pbh.bid_number = p_bid_number;
1864: ----------------------------------------------------------------

Line 1912: from pon_bid_headers

1908: l_vendor_id,
1909: l_trading_partner_id,
1910: l_bid_rate,
1911: l_tech_shortlist_flag
1912: from pon_bid_headers
1913: where bid_number = p_bid_number;
1914: EXCEPTION
1915: WHEN no_data_found THEN
1916: l_is_bidpdf := 'N';

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

2003: IF l_vendor_site_id <= 0 THEN
2004: BEGIN
2005: -- bidpdf: address/contact of supplier company
2006: 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)
2007: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
2008: 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
2009: ,l_contact_details_name
2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id

Line 2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr

2006: 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)
2007: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
2008: 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
2009: ,l_contact_details_name
2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id
2012: and pon_bid_headers.bid_number = p_bid_number
2013: and entity_terr.territory_code(+) = hz_parties.country
2014: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')

Line 2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id

2007: ,PON_LOCALE_PKG.get_party_display_name(pon_bid_headers.trading_partner_contact_id)
2008: 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
2009: ,l_contact_details_name
2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id
2012: and pon_bid_headers.bid_number = p_bid_number
2013: and entity_terr.territory_code(+) = hz_parties.country
2014: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')
2015: and entity_terr.language(+) = l_printing_language

Line 2012: and pon_bid_headers.bid_number = p_bid_number

2008: 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
2009: ,l_contact_details_name
2010: from hz_parties, pon_bid_headers, fnd_territories_tl entity_terr
2011: where pon_bid_headers.trading_partner_id = hz_parties.party_id
2012: and pon_bid_headers.bid_number = p_bid_number
2013: and entity_terr.territory_code(+) = hz_parties.country
2014: and entity_terr.territory_code(+) NOT IN ('ZR','FX','LX')
2015: and entity_terr.language(+) = l_printing_language
2016: and rownum = 1;

Line 2141: FROM pon_bid_headers pbh

2137:
2138: BEGIN
2139: SELECT pbh.bid_number
2140: INTO l_prev_rnd_bid_number
2141: FROM pon_bid_headers pbh
2142: WHERE pbh.auction_header_id = l_auction_header_id_prev_round
2143: AND pbh.bid_status = 'ACTIVE'
2144: AND pbh.trading_partner_id = p_trading_partner_id
2145: AND pbh.trading_partner_contact_id = p_trading_partner_contact_id

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

2457: 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,
2458: 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,
2459: fpg.multi_org_flag,
2460: p_user_view_type as user_view_type,
2461: -- for bidpdf, the Company Name comes from pon_bid_headers.trading_partner_name
2462: 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,
2463: l_award_approval_enabled as award_approval_enabled,
2464: ns.style_name,
2465: pah.progress_payment_type,

Line 2582: pon_bid_headers pbhs,

2578: pa_projects_all proj,
2579: fnd_user buyer_user,
2580: per_phones buyer_phone,
2581: per_phones buyer_fax,
2582: pon_bid_headers pbhs,
2583: fnd_lookup_values fl_bid
2584: where pah.auction_header_id = p_auction_header_id
2585: and pbhs.auction_header_id (+) = pah.auction_header_id
2586: and pbhs.bid_number (+) = p_bid_number

Line 4285: from pon_bid_headers pbhs,

4281: ad.pk1_value,
4282: ad.pk2_value,
4283: ad.pk3_value,
4284: categories_tl.user_name category_name
4285: from pon_bid_headers pbhs,
4286: fnd_documents_vl d,
4287: fnd_attached_documents ad,
4288: fnd_document_categories categories,
4289: fnd_document_categories_tl categories_tl

Line 4294: AND ad.entity_name IN ('PON_BID_HEADERS',

4290: where d.document_id = ad.document_id
4291: AND
4292: pbhs.auction_header_id (+) = p_auction_header_id
4293: and pbhs.bid_number (+) = p_bid_number
4294: AND ad.entity_name IN ('PON_BID_HEADERS',
4295: 'PON_BID_ITEM_PRICES')
4296: and ad.pk1_value = to_char(p_auction_header_id)
4297: and ad.pk2_value = to_char(pbhs.bid_number)
4298: --and categories.name=pon_auction_pkg.g_supplier_attachment

Line 4318: from pon_bid_headers pbhs,

4314: ad.pk1_value,
4315: ad.pk2_value,
4316: ad.pk3_value,
4317: categories_tl.user_name category_name
4318: from pon_bid_headers pbhs,
4319: fnd_documents_vl d,
4320: fnd_attached_documents ad,
4321: fnd_document_categories categories,
4322: fnd_document_categories_tl categories_tl