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_AUCTION_PKG dependencies on PON_LOCALE_PKG

Line 251: pon_locale_pkg.get_party_display_name(trading_partner_contact_id) trading_partner_contact_name,

247: union
248: select distinct trading_partner_name,
249: trading_partner_id,
250: trading_partner_contact_id,
251: pon_locale_pkg.get_party_display_name(trading_partner_contact_id) trading_partner_contact_name,
252: null additional_contact_email,
253: null wf_user_name,
254: to_number(null) registration_id,
255: vendor_site_id,

Line 11871: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,

11867: p_discussion_id NUMBER)
11868: IS
11869: SELECT
11870: hz.party_id TO_PARTY_ID,
11871: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11872: hz.person_first_name FIRST_NAME,
11873: hz.person_last_name LAST_NAME
11874: FROM pon_neg_team_members pntm,
11875: HZ_PARTIES hz,

Line 11885: PON_LOCALE_PKG.get_party_display_name(pte.from_id,2, userenv('LANG')) TO_PARTY_NAME,

11881: AND pntm.auction_header_id = p_auction_header_id
11882: UNION
11883: SELECT
11884: distinct pte.from_id TO_PARTY_ID,
11885: PON_LOCALE_PKG.get_party_display_name(pte.from_id,2, userenv('LANG')) TO_PARTY_NAME,
11886: pte.from_first_name FIRST_NAME, pte.from_last_name LAST_NAME
11887: FROM pon_threads pt,
11888: pon_thread_entries pte
11889: WHERE pt.discussion_id = p_discussion_id

Line 11901: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PBP.TRADING_PARTNER_CONTACT_ID, 2 , USERENV('LANG'))||' - '||NVL(HZ.PARTY_NAME,'') TO_PARTY_NAME,

11897: p_auctioneer_tpc_id NUMBER)
11898: IS
11899: SELECT DISTINCT
11900: PBP.TRADING_PARTNER_CONTACT_ID TO_PARTY_ID,
11901: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PBP.TRADING_PARTNER_CONTACT_ID, 2 , USERENV('LANG'))||' - '||NVL(HZ.PARTY_NAME,'') TO_PARTY_NAME,
11902: HZ1.PERSON_FIRST_NAME FIRST_NAME,
11903: HZ1.PERSON_LAST_NAME LAST_NAME,
11904: HZ.PARTY_ID COMPANY_ID,
11905: HZ.PARTY_NAME COMPANY_NAME

Line 11915: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PBH.TRADING_PARTNER_CONTACT_ID,2,USERENV('LANG'))||' - '||NVL(HZ.PARTY_NAME,'') TO_PARTY_NAME,

11911: AND HZ1.PARTY_ID= PBP.TRADING_PARTNER_CONTACT_ID
11912: UNION
11913: SELECT DISTINCT
11914: PBH.TRADING_PARTNER_CONTACT_ID TO_PARTY_ID,
11915: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PBH.TRADING_PARTNER_CONTACT_ID,2,USERENV('LANG'))||' - '||NVL(HZ.PARTY_NAME,'') TO_PARTY_NAME,
11916: HZ1.PERSON_FIRST_NAME FIRST_NAME,
11917: HZ1.PERSON_LAST_NAME LAST_NAME,
11918: HZ.PARTY_ID COMPANY_ID,
11919: HZ.PARTY_NAME COMPANY_NAME

Line 11930: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PTE.FROM_ID, 2,USERENV('LANG')) ||' - '||NVL(PTE.FROM_COMPANY_NAME,'') TO_PARTY_NAME,

11926: AND PBH.BID_STATUS NOT IN ('ARCHIVED','DISQUALIFIED')
11927: UNION
11928: SELECT DISTINCT
11929: PTE.FROM_ID TO_PARTY_ID,
11930: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PTE.FROM_ID, 2,USERENV('LANG')) ||' - '||NVL(PTE.FROM_COMPANY_NAME,'') TO_PARTY_NAME,
11931: PTE.FROM_FIRST_NAME FIRST_NAME,
11932: PTE.FROM_LAST_NAME LAST_NAME,
11933: PTE.FROM_COMPANY_ID COMPANY_ID,
11934: PTE.FROM_COMPANY_NAME COMPANY_NAME

Line 11952: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,

11948: p_team_id NUMBER)
11949: IS
11950: SELECT
11951: hz.party_id TO_PARTY_ID,
11952: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11953: hz.person_first_name FIRST_NAME,
11954: hz.person_last_name LAST_NAME
11955: FROM pon_scoring_team_members pntm,
11956: HZ_PARTIES hz,

Line 11970: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,

11966: p_auction_header_id NUMBER)
11967: IS
11968: SELECT distinct
11969: hz.party_id TO_PARTY_ID,
11970: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11971: hz.person_first_name FIRST_NAME,
11972: hz.person_last_name LAST_NAME
11973: FROM pon_scoring_team_members pntm,
11974: HZ_PARTIES hz,

Line 11986: PON_LOCALE_PKG.get_party_display_name(ptr.to_id,2, userenv('LANG')) TO_PARTY_NAME,

11982: CURSOR GROUP_MEMBERS (p_sender_id NUMBER,
11983: p_entryId NUMBER)
11984: IS
11985: SELECT ptr.to_id TO_PARTY_ID,
11986: PON_LOCALE_PKG.get_party_display_name(ptr.to_id,2, userenv('LANG')) TO_PARTY_NAME,
11987: ptr.to_first_name FIRST_NAME,
11988: ptr.to_last_name LAST_NAME
11989: FROM pon_te_recipients ptr
11990: WHERE ptr.entry_id = p_entryId

Line 12717: l_recipient_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_userPartyId, 2 ,l_lang_code) ;

12713: INTO l_lang_code
12714: FROM FND_LANGUAGES
12715: WHERE NLS_LANGUAGE = l_language;
12716:
12717: l_recipient_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_userPartyId, 2 ,l_lang_code) ;
12718: l_sender_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_from_id, 2 ,l_lang_code);
12719:
12720: --
12721: -- Subject should be retrieved from seed message

Line 12718: l_sender_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_from_id, 2 ,l_lang_code);

12714: FROM FND_LANGUAGES
12715: WHERE NLS_LANGUAGE = l_language;
12716:
12717: l_recipient_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_userPartyId, 2 ,l_lang_code) ;
12718: l_sender_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_from_id, 2 ,l_lang_code);
12719:
12720: --
12721: -- Subject should be retrieved from seed message
12722: --

Line 13363: x_buyer_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_trading_partner_contact_id);

13359: WHERE
13360: auction_header_id = p_auction_header_id;
13361:
13362: x_time_left := TIME_REMAINING(p_auction_header_id);
13363: x_buyer_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_trading_partner_contact_id);
13364: x_carrier := PON_PRINTING_PKG.GET_CARRIER_DESCRIPTION(v_org_id,v_carrier_code);
13365: x_unlocked_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unlock_tp_contact_id);
13366: x_unsealed_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unseal_tp_contact_id);
13367:

Line 13365: x_unlocked_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unlock_tp_contact_id);

13361:
13362: x_time_left := TIME_REMAINING(p_auction_header_id);
13363: x_buyer_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_trading_partner_contact_id);
13364: x_carrier := PON_PRINTING_PKG.GET_CARRIER_DESCRIPTION(v_org_id,v_carrier_code);
13365: x_unlocked_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unlock_tp_contact_id);
13366: x_unsealed_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unseal_tp_contact_id);
13367:
13368: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13369: FND_LOG.string( log_level => FND_LOG.level_statement,

Line 13366: x_unsealed_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unseal_tp_contact_id);

13362: x_time_left := TIME_REMAINING(p_auction_header_id);
13363: x_buyer_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_trading_partner_contact_id);
13364: x_carrier := PON_PRINTING_PKG.GET_CARRIER_DESCRIPTION(v_org_id,v_carrier_code);
13365: x_unlocked_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unlock_tp_contact_id);
13366: x_unsealed_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unseal_tp_contact_id);
13367:
13368: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13369: FND_LOG.string( log_level => FND_LOG.level_statement,
13370: module => g_module_prefix || '.get_negotiation_details',