Search Results csd_wf_item_key_s

Overview

The APPS.CSD_RO_BULLETINS_PVT package body is a private (PVT) PL/SQL API within the Oracle EBS Depot Repair / Service module (CSD schema). It provides the core processing logic for managing repair order (RO) bulletins — reusable informational or instructional records that are attached to repair orders, service codes, and repair lines. Bulletins communicate warranty terms, inspection requirements, safety notes, or procedural instructions to technicians and service personnel. This package encapsulates creation, maintenance, linking, and application of bulletins to the repair workflow, shielding callers from the underlying data structures in CSD_RO_BULLETINS, CSD_BULLETINS_B, and related tables. As a PVT package, it is intended for internal use by the CSD public APIs and related private packages rather than direct customer invocation. It sits within the repair order management stack alongside CSD_RO_BULLETINS_PKG, CSD_REPAIRS_PVT, and CSD_RO_SERVICE_CODES_PVT, and participates in the rules engine flow through CSD_RULES_ENGINE_PVT.

Key Procedures and Functions

• CREATE_RO_BULLETIN — Creates a new repair order bulletin record, inserting into the bulletin base tables with validation of bulletin data.
• UPDATE_RO_BULLETIN — Modifies attributes of an existing RO bulletin, preserving referential integrity.
• DELETE_RO_BULLETIN — Removes an RO bulletin and handles dependent link records.
• LOCK_RO_BULLETIN — Acquires a lock on a bulletin record for concurrency control during edit operations.
• LINK_BULLETINS_TO_RO — Associates one or more bulletins with a repair order, creating entries in the RO bulletin link table.
• CREATE_NEW_RO_BULLETIN_LINK — Inserts a new association record linking a bulletin to a repair order or repair line.
• GET_CSD_REPAIRS_OBJ_VER_NUM — Retrieves the object version number for a repair record, supporting optimistic locking on CSD_REPAIRS.
• LINK_BULLETINS_TO_REPAIRS_CP — Concurrent-program-oriented routine that links bulletins to repair records in bulk.
• LINK_BULLETIN_FOR_RULE — Applies bulletins to repairs as determined by rules engine evaluation.
• APPLY_BULLETIN_SCS_TO_RO — Applies bulletin service charges (SCS) to a repair order, driving cost or charge capture associated with bulletin-driven work.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• CSD_BULLETINS_B — Bulletin master base table (definitions).
• CSD_BULLETIN_SCS — Bulletin-to-service-code/charge associations.
• CSD_REPAIRS — Repair order header/line records to which bulletins are linked.
• CSD_RO_BULLETINS — The RO bulletin repository and its links.
• CSD_RO_SERVICE_CODES — Service codes driving repair activity.
• CSD_RULES_B — Rule definitions used to conditionally link bulletins.
• CSD_WF_ITEM_KEY_S — Workflow item key sequence, providing item keys typically for repairing workflow or event notification.
• DUAL / PLITBLM — Utility and PL/SQL index-by table support.

It also references CSD_REPAIRS_PUB, CSD_REPAIRS_PVT, CSD_RO_SERVICE_CODES_PVT, CSD_RULES_ENGINE_PVT, CSD_SC_DOMAINS_V, MTL_ITEM_CATEGORIES_V, and standard FND/Workflow APIs (FND_API, FND_GLOBAL, FND_MSG_PUB, WF_ENGINE, JTF_PLSQL_API).

Usage Notes

This private package is invoked by the CSD public APIs and by sibling private packages within Depot Repair, and is not referenced by any database object outside the APPS schema per the documented dependency listing. It is typically triggered from the Depot Repair forms (Repair Order entry), from the concurrent program performing bulk bulletin-to-repair linking, or indirectly through rules engine evaluation during repair order processing. The presence of CSD_WF_ITEM_KEY_S and WF_ENGINE dependencies indicates integration with Oracle Workflow for notification or approval routing on bulletin events. Customizations should call the corresponding public API rather than CSD_RO_BULLETINS_PVT directly to preserve upgrade safety.