Search Results insert_pon_discussions

Overview

PON_THREAD_DISC_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the discussion and messaging infrastructure used within Oracle Sourcing and Oracle Negotiations. Its role is to manage the threaded discussion records that buyers and suppliers exchange during a negotiation event. In EBS 12.1.1 and 12.2.2, negotiation participants use discussion threads to post clarifications, questions, and responses tied to a specific negotiation. This package encapsulates the database operations required to create discussion headers, create the threads themselves, append thread entries (individual messages), track recipient read status, and expose display-oriented views of message status.

The package is classified as OTHER in the ETRM documentation, indicating that it is an internal implementation package rather than a published public API. It is referenced directly by PON_NEGOTIATION_COPY_GRP and by the package body of PON_THREAD_DISC_PKG itself, and it in turn depends on SYS.STANDARD and the APPS schema. This dependency chain reflects its position as a supporting component of the broader negotiation management subsystem.

Key Procedures and Functions

The ETRM documentation records nine procedures and functions:

• INSERT_PON_DISCUSSIONS — Creates a discussion record, establishing the container under which one or more threads are organized for a negotiation.
• INSERT_PON_THREADS — Creates an individual thread within an existing discussion, providing the grouping key for related entries.
• INSERT_THREAD_ENTRY — Inserts a new message into a thread, capturing the content contributed by a participant.
• INSERT_OR_UPDATE_RECIPIENT — Adds a recipient to a thread entry or refreshes an existing recipient row, ensuring the distribution list remains accurate.
• UPDATE_RECIPIENT_TO_READ — Marks a recipient's copy of a thread entry as read.
• RECORD_READ — Records read activity for a message, feeding the read-audit and status tracking tables.
• GET_REPLIED_BY_LIST — Returns the list of participants who have replied to a given entry or thread.
• GET_RECIPIENTS_LIST — Returns the set of recipients associated with an entry or thread.
• GET_MESSAGE_STATUS_DISP — Retrieves message status information formatted for display in the negotiation UI.

Tables Accessed

The package reads and writes through APPS synonyms across the negotiation messaging data model:

• PON_DISCUSSIONS and PON_DISCUSSIONS_S — store discussion headers and their translated/denormalized variants.
• PON_THREADS — stores thread definitions belonging to discussions.
• PON_THREAD_ENTRIES and PON_THREAD_ENTRIES_S — store the individual messages composing a thread.
• PON_TE_RECIPIENTS — stores the recipient list for each thread entry, including read-status flags.
• PON_TE_VIEW_AUDIT — records audit information for thread-entry view and read events.
• FND_NEW_MESSAGES — the Oracle Workflow notification/message table, used for message delivery integration.
• DUAL — used for scalar lookups and date/value sourcing.

Usage Notes

PON_THREAD_DISC_PKG is invoked indirectly through negotiation-facing forms, the Oracle Sourcing negotiation UI, and the PON_NEGOTIATION_COPY_GRP package during negotiation copy or duplication scenarios. It is not intended for direct invocation by end users. Customizations that interact with negotiation discussions should treat this package as an internal dependency and prefer supported APIs where available. Because the package writes to PON_DISCUSSIONS, PON_THREADS, and PON_THREAD_ENTRIES and their audit counterparts, any extension or troubleshooting activity should account for the possibility of partial commits and the subsequent impact on thread visibility and read-status reporting.