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_DISCUSSION_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 24: FROM pon_auction_headers_all ah

20: -- else fetch unread message count.
21: BEGIN
22: SELECT 1
23: INTO row_found
24: FROM pon_auction_headers_all ah
25: WHERE ah.AUCTION_HEADER_ID = p_auction_header_id and
26: (ah.bid_list_type = 'PUBLIC_BID_LIST'
27: OR
28: ah.trading_partner_id = p_company_id

Line 62: AND pd.entity_name = 'PON_AUCTION_HEADERS_ALL' ;

58: select discussion_id
59: into l_discussion_id
60: from pon_discussions pd
61: where pd.pk1_value = to_char(p_auction_header_id)
62: AND pd.entity_name = 'PON_AUCTION_HEADERS_ALL' ;
63: EXCEPTION
64: WHEN TOO_MANY_ROWS THEN
65: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
66: FND_LOG.string (log_level => FND_LOG.level_procedure,

Line 75: AND pd.entity_name = 'PON_AUCTION_HEADERS_ALL'

71: select discussion_id
72: into l_discussion_id
73: from pon_discussions pd
74: where pd.pk1_value = to_char(p_auction_header_id)
75: AND pd.entity_name = 'PON_AUCTION_HEADERS_ALL'
76: AND ROWNUM = 1;
77: END;
78:
79: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 90: pon_auction_headers_all ah

86:
87: SELECT count(1)
88: INTO unread_message_count
89: FROM pon_thread_entries pte,
90: pon_auction_headers_all ah
91: WHERE ah.auction_header_id = p_auction_header_id
92: AND pte.discussion_id = l_discussion_id
93: AND (((pte.broadcast_flag = 'N' OR pte.broadcast_flag = 'G')
94: AND