DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_LOCALE_PKG

Line 1126: PON_LOCALE_PKG.party_display_name(hz.person_first_name,

1122: where flv.lookup_type = 'PON_EMD_SUPPLIER_STATUS'
1123: AND flv.language = USERENV('LANG')
1124: AND flv.lookup_code = l_emd_current_status
1125: ) as EMD_CURRENT_STATUS,
1126: PON_LOCALE_PKG.party_display_name(hz.person_first_name,
1127: hz.PERSON_LAST_NAME,
1128: hz.person_middle_name,
1129: fl1.MEANING,
1130: hz.PERSON_NAME_SUFFIX,

Line 1201: PON_LOCALE_PKG.party_display_name(hz.person_first_name,

1197: where flv.lookup_type = 'PON_EMD_SUPPLIER_STATUS'
1198: AND flv.language = USERENV('LANG')
1199: AND flv.lookup_code = l_emd_current_status
1200: ) as EMD_CURRENT_STATUS, --Modify by Chaoqun 09-Mar-2009
1201: PON_LOCALE_PKG.party_display_name(hz.person_first_name,
1202: hz.PERSON_LAST_NAME,
1203: hz.person_middle_name,
1204: fl1.MEANING,
1205: hz.PERSON_NAME_SUFFIX,

Line 1524: PON_LOCALE_PKG.party_display_name(hz.person_first_name,

1520: --pbp.bid_currency_code as EMD_CURR_CODE,
1521: paha.currency_code as EMD_CURR_CODE, --Modify by Chaoqun on 19-Mar-2009
1522: --l_emd_current_status as EMD_CURRENT_STATUS,
1523: pbp.exempt_flag as EMD_EXEMPTED_FLAG,
1524: PON_LOCALE_PKG.party_display_name(hz.person_first_name,
1525: hz.PERSON_LAST_NAME,
1526: hz.person_middle_name,
1527: f1.MEANING,
1528: hz.PERSON_NAME_SUFFIX,

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 2025: decode(pbp.trading_partner_contact_id, null, pbp.requested_supp_contact_name, PON_LOCALE_PKG.get_party_display_name(pbp.trading_partner_contact_id)) contact_name

2021: ELSE
2022: BEGIN
2023: -- get supplier site address/contact, reference from java/poplist/server/VendorSitesAllVO.xml
2024: SELECT pvsa.address_line1,pvsa.address_line2,pvsa.address_line3,pvsa.city,pvsa.state,pvsa.zip,pvsa.country, nvl(entity_terr.territory_short_name,pvsa.country),
2025: decode(pbp.trading_partner_contact_id, null, pbp.requested_supp_contact_name, PON_LOCALE_PKG.get_party_display_name(pbp.trading_partner_contact_id)) contact_name
2026: 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,l_contact_details_name
2027: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr
2028: WHERE
2029: pah.auction_header_id = p_auction_header_id

Line 2235: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(pah.trading_partner_contact_id) auctioneer_display_name,

2231: nvl(pah.two_part_flag,'N') two_part_flag,
2232: l_hide_comm_part hide_comm_part,
2233: l_is_super_large_neg is_super_large_neg,
2234: pah.proxy_bidding_enabled_flag,
2235: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(pah.trading_partner_contact_id) auctioneer_display_name,
2236: pah.bill_to_location_id,
2237: bill_territories_tl.territory_short_name bill_country_name,
2238: loc_bill.location_code bill_address_name,
2239: loc_bill.address_line_1 bill_address1,

Line 3898: decode(pbp.trading_partner_contact_id, null, pbp.requested_supp_contact_name, PON_LOCALE_PKG.get_party_display_name(pbp.trading_partner_contact_id)) contact_name,

3894: OPEN invited_supp_cursor FOR
3895: SELECT
3896: decode(pbp.trading_partner_id, null, pbp.requested_supplier_name, pbp.trading_partner_name) trading_partner_name,
3897: pbp.vendor_site_code,
3898: decode(pbp.trading_partner_contact_id, null, pbp.requested_supp_contact_name, PON_LOCALE_PKG.get_party_display_name(pbp.trading_partner_contact_id)) contact_name,
3899: pbp.additional_contact_email,
3900: pbp.bid_currency_code,
3901: pbp.rate_dsp,
3902: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as rate_dsp_display,