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 234: pon_locale_pkg.get_party_display_name(trading_partner_contact_id) trading_partner_contact_name,

230: union
231: select distinct trading_partner_name,
232: trading_partner_id,
233: trading_partner_contact_id,
234: pon_locale_pkg.get_party_display_name(trading_partner_contact_id) trading_partner_contact_name,
235: null additional_contact_email,
236: null wf_user_name,
237: to_number(null) registration_id,
238: vendor_site_id,

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

11031: p_discussion_id NUMBER)
11032: IS
11033: SELECT
11034: hz.party_id TO_PARTY_ID,
11035: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11036: hz.person_first_name FIRST_NAME,
11037: hz.person_last_name LAST_NAME
11038: FROM pon_neg_team_members pntm,
11039: HZ_PARTIES hz,

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

11045: AND pntm.auction_header_id = p_auction_header_id
11046: UNION
11047: SELECT
11048: distinct pte.from_id TO_PARTY_ID,
11049: PON_LOCALE_PKG.get_party_display_name(pte.from_id,2, userenv('LANG')) TO_PARTY_NAME,
11050: pte.from_first_name FIRST_NAME, pte.from_last_name LAST_NAME
11051: FROM pon_threads pt,
11052: pon_thread_entries pte
11053: WHERE pt.discussion_id = p_discussion_id

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

11061: p_auctioneer_tpc_id NUMBER)
11062: IS
11063: SELECT DISTINCT
11064: PBP.TRADING_PARTNER_CONTACT_ID TO_PARTY_ID,
11065: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PBP.TRADING_PARTNER_CONTACT_ID, 2 , USERENV('LANG'))||' - '||NVL(HZ.PARTY_NAME,'') TO_PARTY_NAME,
11066: HZ1.PERSON_FIRST_NAME FIRST_NAME,
11067: HZ1.PERSON_LAST_NAME LAST_NAME,
11068: HZ.PARTY_ID COMPANY_ID,
11069: HZ.PARTY_NAME COMPANY_NAME

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

11075: AND HZ1.PARTY_ID= PBP.TRADING_PARTNER_CONTACT_ID
11076: UNION
11077: SELECT DISTINCT
11078: PBH.TRADING_PARTNER_CONTACT_ID TO_PARTY_ID,
11079: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PBH.TRADING_PARTNER_CONTACT_ID,2,USERENV('LANG'))||' - '||NVL(HZ.PARTY_NAME,'') TO_PARTY_NAME,
11080: HZ1.PERSON_FIRST_NAME FIRST_NAME,
11081: HZ1.PERSON_LAST_NAME LAST_NAME,
11082: HZ.PARTY_ID COMPANY_ID,
11083: HZ.PARTY_NAME COMPANY_NAME

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

11090: AND PBH.BID_STATUS NOT IN ('ARCHIVED','DISQUALIFIED')
11091: UNION
11092: SELECT DISTINCT
11093: PTE.FROM_ID TO_PARTY_ID,
11094: PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(PTE.FROM_ID, 2,USERENV('LANG')) ||' - '||NVL(PTE.FROM_COMPANY_NAME,'') TO_PARTY_NAME,
11095: PTE.FROM_FIRST_NAME FIRST_NAME,
11096: PTE.FROM_LAST_NAME LAST_NAME,
11097: PTE.FROM_COMPANY_ID COMPANY_ID,
11098: PTE.FROM_COMPANY_NAME COMPANY_NAME

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

11112: p_team_id NUMBER)
11113: IS
11114: SELECT
11115: hz.party_id TO_PARTY_ID,
11116: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11117: hz.person_first_name FIRST_NAME,
11118: hz.person_last_name LAST_NAME
11119: FROM pon_scoring_team_members pntm,
11120: HZ_PARTIES hz,

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

11130: p_auction_header_id NUMBER)
11131: IS
11132: SELECT distinct
11133: hz.party_id TO_PARTY_ID,
11134: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11135: hz.person_first_name FIRST_NAME,
11136: hz.person_last_name LAST_NAME
11137: FROM pon_scoring_team_members pntm,
11138: HZ_PARTIES hz,

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

11146: CURSOR GROUP_MEMBERS (p_sender_id NUMBER,
11147: p_entryId NUMBER)
11148: IS
11149: SELECT ptr.to_id TO_PARTY_ID,
11150: PON_LOCALE_PKG.get_party_display_name(ptr.to_id,2, userenv('LANG')) TO_PARTY_NAME,
11151: ptr.to_first_name FIRST_NAME,
11152: ptr.to_last_name LAST_NAME
11153: FROM pon_te_recipients ptr
11154: WHERE ptr.entry_id = p_entryId

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

11858: INTO l_lang_code
11859: FROM FND_LANGUAGES
11860: WHERE NLS_LANGUAGE = l_language;
11861:
11862: l_recipient_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_userPartyId, 2 ,l_lang_code) ;
11863: l_sender_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_from_id, 2 ,l_lang_code);
11864:
11865: --
11866: -- Subject should be retrieved from seed message

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

11859: FROM FND_LANGUAGES
11860: WHERE NLS_LANGUAGE = l_language;
11861:
11862: l_recipient_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_userPartyId, 2 ,l_lang_code) ;
11863: l_sender_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_from_id, 2 ,l_lang_code);
11864:
11865: --
11866: -- Subject should be retrieved from seed message
11867: --

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

12503: WHERE
12504: auction_header_id = p_auction_header_id;
12505:
12506: x_time_left := TIME_REMAINING(p_auction_header_id);
12507: x_buyer_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_trading_partner_contact_id);
12508: x_carrier := PON_PRINTING_PKG.GET_CARRIER_DESCRIPTION(v_org_id,v_carrier_code);
12509: x_unlocked_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unlock_tp_contact_id);
12510: x_unsealed_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unseal_tp_contact_id);
12511:

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

12505:
12506: x_time_left := TIME_REMAINING(p_auction_header_id);
12507: x_buyer_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_trading_partner_contact_id);
12508: x_carrier := PON_PRINTING_PKG.GET_CARRIER_DESCRIPTION(v_org_id,v_carrier_code);
12509: x_unlocked_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unlock_tp_contact_id);
12510: x_unsealed_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unseal_tp_contact_id);
12511:
12512: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12513: FND_LOG.string( log_level => FND_LOG.level_statement,

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

12506: x_time_left := TIME_REMAINING(p_auction_header_id);
12507: x_buyer_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_trading_partner_contact_id);
12508: x_carrier := PON_PRINTING_PKG.GET_CARRIER_DESCRIPTION(v_org_id,v_carrier_code);
12509: x_unlocked_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unlock_tp_contact_id);
12510: x_unsealed_by_display := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(v_sealed_unseal_tp_contact_id);
12511:
12512: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12513: FND_LOG.string( log_level => FND_LOG.level_statement,
12514: module => g_module_prefix || '.get_negotiation_details',