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

Line 397: SELECT PON_LOCALE_PKG.get_party_display_name(PTR.TO_ID, PON_LOCALE_PKG.DEFAULT_NAME_DISPLAY_PATTERN, userenv('LANG')) as name

393: v_member_list VARCHAR2(2500);
394: l_module_name VARCHAR2(40) := 'GET_REPLIED_BY_LIST';
395:
396: CURSOR memberlist(x_entry_id NUMBER,x_auctioneer_tp_id NUMBER, x_to_id NUMBER, x_message_type VARCHAR2) IS
397: SELECT PON_LOCALE_PKG.get_party_display_name(PTR.TO_ID, PON_LOCALE_PKG.DEFAULT_NAME_DISPLAY_PATTERN, userenv('LANG')) as name
398: FROM PON_TE_RECIPIENTS PTR
399: WHERE PTR.REPLIED_FLAG='Y'
400: AND PTR.ENTRY_ID = x_entry_id
401: AND PTR.TO_COMPANY_ID = x_auctioneer_tp_id -- auctioneer's trading partner id

Line 459: SELECT PON_LOCALE_PKG.get_party_display_name(PTR.TO_ID, PON_LOCALE_PKG.DEFAULT_NAME_DISPLAY_PATTERN, userenv('LANG')) || DECODE(x_message_type,'EXTERNAL',' - '|| PTR.TO_COMPANY_NAME) as name

455: l_module_name VARCHAR2(40) := 'GET_RECIPIENTS_LIST';
456: l_from_company_id NUMBER;
457:
458: CURSOR memberlist(x_entry_id NUMBER, x_from_id NUMBER, x_message_type VARCHAR2, x_from_company_id NUMBER) IS
459: SELECT PON_LOCALE_PKG.get_party_display_name(PTR.TO_ID, PON_LOCALE_PKG.DEFAULT_NAME_DISPLAY_PATTERN, userenv('LANG')) || DECODE(x_message_type,'EXTERNAL',' - '|| PTR.TO_COMPANY_NAME) as name
460: FROM PON_TE_RECIPIENTS PTR
461: WHERE PTR.ENTRY_ID = x_entry_id
462: AND PTR.TO_ID <> x_from_id
463: AND ((x_message_type='EXTERNAL' AND PTR.TO_COMPANY_ID <> x_from_company_id)