Search Results lock_ro_bulletin

Overview

CSD_RO_BULLETINS_PVT_W is a private PL/SQL package in the APPS schema that implements the business logic for Rosetta "bulletins" within Oracle E-Business Suite. Bulletins are reusable content objects surfaced through the Rosetta/Oracle iSupport and TeleService frameworks, where they are used to present scripted guidance, resolution text, and knowledge that agents or customers can retrieve against a service request or interaction. The package belongs to the CSD (Customer Service/Support) module family and carries the "_PVT_W" suffix, indicating it is a generated private worker package whose public-facing API is exposed through a companion wrapper. Its header signature (csdwrobs.pls) and API classification places it in the "OTHER" category rather than a UMX or standard CRUD API tier, meaning it is intended for internal orchestration by the Rosetta runtime rather than as a general integration point.

Key Procedures and Functions

Nine documented entry points exist, divided between table-conversion utilities and transactional concerns:

• ROSETTA_TABLE_COPY_IN_P6 / ROSETTA_TABLE_COPY_OUT_P6 — Bulk marshalling routines that translate the internal collection type csd_ro_sc_ids_tbl_type to and from the generic JTF_NUMBER_TABLE. These are auto-generated Rosetta plumbing used to pass arrays of service-request identifiers across the API boundary.
• ROSETTA_TABLE_COPY_IN_P9 / ROSETTA_TABLE_COPY_OUT_P9 — The equivalent conversion pair for the ro_bulletin_tbl_type collection, spanning thirteen parallel JTF number, date, and varchar2 tables that mirror the column shape of the bulletin record structure.
• CREATE_RO_BULLETIN — Inserts a new bulletin record, accepting the standard EBS API envelope (p_api_version_number, p_init_msg_list, p_commit, p_validation_level) plus the bulletin attribute set, and returning the generated bulletin identifier together with return status, message count, and message data.
• UPDATE_RO_BULLETIN — Modifies an existing bulletin using the same API envelope and out-parameter convention as the create routine.
• LOCK_RO_BULLETIN — Acquires a concurrency lock on a bulletin record to prevent conflicting updates, supporting the "lock_ro_bulletin" search term that surfaced this object. It is the standard optimistic-locking step performed before an edit.
• LINK_BULLETINS_TO_RO — Establishes the association between bulletins and a Rosetta repository object, wiring content into the object hierarchy.
• CREATE_NEW_RO_BULLETIN_LINK — Creates a fresh linkage record, complementing the link routine for cases where no prior relationship exists.

Tables Accessed

The only documented table reference is PLITBLM, an attribute-table pattern historically used to store extended or multi-row column data associated with the parent entity. The package reads and writes this table when persisting and retrieving bulletin detail, while the bulk of bulletin master data is manipulated through the collection types and underlying CSD base tables. Because the referenced name appears via an APPS synonym, the actual object resides in another schema.

Usage Notes

The package is not referenced by any other documented package, confirming its role as a leaf-level worker invoked directly rather than through package-to-package calls. In practice it is called by the Rosetta administrative and agent-facing UIs, by the CSD bulletin maintenance forms, and by any concurrent or custom extension that needs to create, lock, update, or link bulletins programmatically. Callers should always supply the standard API envelope parameters, check x_return_status, and invoke LOCK_RO_BULLETIN before UPDATE_RO_BULLETIN to avoid lost updates. On EBS 12.1.1 and 12.2.2 the package behaves identically; the 12.2 online patching infrastructure simply recompiles it during adop phases, so no code changes are required between releases.