DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_LOCALE_PKG

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 1078: 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

1074: ELSE
1075: BEGIN
1076: -- get supplier site address/contact, reference from java/poplist/server/VendorSitesAllVO.xml
1077: 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),
1078: 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
1079: 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
1080: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr
1081: WHERE
1082: pah.auction_header_id = p_auction_header_id

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

1282: nvl(pah.two_part_flag,'N') two_part_flag,
1283: l_hide_comm_part hide_comm_part,
1284: l_is_super_large_neg is_super_large_neg,
1285: pah.proxy_bidding_enabled_flag,
1286: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(pah.trading_partner_contact_id) auctioneer_display_name,
1287: pah.bill_to_location_id,
1288: bill_territories_tl.territory_short_name bill_country_name,
1289: loc_bill.location_code bill_address_name,
1290: loc_bill.address_line_1 bill_address1,

Line 1975: 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,

1971: CURSOR(
1972: SELECT
1973: decode(pbp.trading_partner_id, null, pbp.requested_supplier_name, pbp.trading_partner_name) trading_partner_name,
1974: pbp.vendor_site_code,
1975: 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,
1976: pbp.additional_contact_email,
1977: pbp.bid_currency_code,
1978: pbp.rate_dsp,
1979: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as rate_dsp_display,