APPS.PON_OA_UTIL_PKG dependencies on PON_DISCUSSIONS

Line 413: from pon_discussions

409: v_discussion_id NUMBER;
410:
411: CURSOR discussion_id IS
412: select discussion_id
413: from pon_discussions
414: where entity_name = 'PON_AUCTION_HEADERS_ALL' and
415: pk1_value = to_char(p_auction_id);
416:
417: BEGIN

Line 426: RETURN 'javascript:openDiscussionWindow(''/OA_HTML/jsp/pon/discussions/ThreadedNegotiationSummary.jsp?app=' || p_app || '&'

422: close discussion_id;
423:
424: -- error handling if discussin id is null?
425:
426: RETURN 'javascript:openDiscussionWindow(''/OA_HTML/jsp/pon/discussions/ThreadedNegotiationSummary.jsp?app=' || p_app || '&'
427: || 'SubTab=' || p_subtab_pos || '&' || 'discussion_id=' || v_discussion_id || ''',''discussion_' || v_discussion_id || '_user_' || p_viewer_party_id || '_depth_'' + (parseInt(getDiscussionWindowDepth()) + 1))';
428:
429: END DISCUSSION_URL;
430: