Search Results create_ext_attr_audit

Overview

CS_SR_EXTATTRIBUTES_PVT is an Oracle E-Business Suite private (PVT) PL/SQL package owned by the APPS schema that supports the Service (CS) module's handling of extended attributes on service requests. Extended attributes in Oracle Service allow customers to capture additional, customer-defined information on service requests and their related contacts beyond the standard seeded columns. Because these attributes are stored in dedicated extension tables, they require their own persistence, merge, and audit logic, which is exactly what this package encapsulates.

The package is classified as a private API, meaning it is intended for internal consumption by other Service packages rather than direct invocation by external integrations. It depends on the public foundation layers FND_API and FND_GLOBAL for standard API error handling and session context, and on CS_SERVICEREQUEST_PUB as the public service request interface it complements. Its documented status is VALID in the ETRM repository for both 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents seven procedures/functions within this package:

• GET_SR_EXT_ATTRS — Retrieves the extended attribute values associated with a service request, returning the descriptor and value sets used by callers.
• PROCESS_SR_EXT_ATTRS — The primary workhorse that applies create or update logic to extended attributes for a service request, routing values to the appropriate extension tables.
• CREATE_EXT_ATTR_AUDIT — Generates audit trail records capturing before-and-after extended attribute values.
• MERGE_EXT_ATTRS_DETAILS — Merges extended attribute detail rows, typically used during party merge or data consolidation scenarios.
• INSERT_SR_ROW — Inserts a new extended attribute row tied to a service request.
• INSERT_PR_ROW — Inserts a new extended attribute row tied to a related party or contact record.
• POPULATE_EXT_ATTR_AUDIT_TBL — Bulk-populates the extended attribute audit staging table with values requiring audit processing.

These routines are not documented as public API entry points; parameter lists are not exposed in the ETRM extract and should be treated as internal.

Tables Accessed

The package reads and writes several Service and Trading Community tables through APPS synonyms:

• CS_INCIDENTS_EXT and CS_INCIDENTS_ALL_B — the extension and base service request (incident) tables holding header-level extended attributes.
• CS_INCIDENTS_EXT_AUDIT and CS_INCIDENTS_EXT_AUDIT_S — the audit table and its sequence supporting CREATE_EXT_ATTR_AUDIT and POPULATE_EXT_ATTR_AUDIT_TBL.
• CS_SR_CONTACTS_EXT and CS_SR_CONTACTS_EXT_AUDIT with CS_SR_CONTACTS_EXT_AUDIT_S — contact-level extended attribute values and their audit trail.
• CS_HZ_SR_CONTACT_POINTS — links service requests to contact points used when resolving contact-level attributes.
• DUAL and PLITBLM — utility references for single-row selection and PL/SQL table indexing respectively.

Usage Notes

CS_SR_EXTATTRIBUTES_PVT is invoked indirectly. ETRM shows it is referenced by CS_SERVICEREQUEST_PVT (the cleanup/validation layer behind the public API), CS_ERES_INT_PKG (the e-Resources integration package), and CS_PARTYMERGE_PKG (the party merge handler), as well as by its own body and the CS_SR_EXTATTRIBUTES_PVT_W wrapper package used for OAF/forms invocation. This confirms it is called automatically whenever a service request is created, updated, or merged, and whenever extended attributes require audit capture. In Oracle EBS 12.1.1 and 12.2.2 deployments, customizations should call the public CS_SERVICEREQUEST_PUB API rather than this private package, because its signatures and behavior are not guaranteed across patches. Direct use is restricted to Oracle-internal Service code paths and controlled data-fix scripts in non-production environments.