Search Results cs_servicerequest_pub




Overview
Explore in AI Chat

Overview

CS_SERVICEREQUEST_PUB is the primary public PL/SQL package in Oracle EBS Service (TeleService) responsible for creating and maintaining Service Requests. In Release 12.1.1 and 12.2.2, it acts as the application programming interface layer through which forms, concurrent programs, and external integrations manipulate service request data without writing directly to the base tables.

The package encapsulates the business validation and defaulting logic that Service Request processing requires: resolution of value IDs and value names, conversion of user-entered attribute values into their corresponding IDs, enforcement of API-level validation, and persistence to the CS_INCIDENTS tables. It exposes a stable interface for both Oracle-provided modules and customer extensions, shielding callers from the underlying table structure.

The package body declares package-level constants including G_PKG_NAME (set to 'CS_ServiceRequest_PUB'), G_INITIALIZED ('R'), and G_SR_SUBTYPE ('INC'), and defines local types such as Request_Conversion_Rec_Type. That record deliberately carries both value-ID and value-name pairs — type_id/type_name, status_id/status_name, severity_id/severity_name, urgency_id/urgency_name, employee_id/employee_number — so that the internal conversion routine can resolve whichever form the caller supplied. Fields default to the Sentinel values FND_API.G_MISS_NUM and FND_API.G_MISS_CHAR, consistent with the standard Oracle API programming model in which an unset attribute is distinguishable from an explicit NULL. Runtime error handling is performed through the FND_MSG_PUB message stack and the returned x_return_status code.

Key Procedures and Functions

The documented API surface comprises fifteen procedures and functions grouped by purpose:

Additional internal routines, including the value-name-to-ID conversion routine referenced by Request_Conversion_Rec_Type, are forward-declared within the body and are not part of the published interface.

Tables Accessed

The APIs read and write the core Service Request schema through APPS synonyms:

Usage Notes

CS_SERVICEREQUEST_PUB is invoked by the TeleService Service Request form, by concurrent programs that process or import requests, and by custom extensions and external integrations. It is referenced by thirty-eight other packages, making it a foundational dependency within the Service module.

In the context of the searched term “trunc_string_length,” this package should be understood as the Service Request API layer rather than as a string utility: it is the entry point into which externally supplied values — including any caller-truncated strings — are passed for validation, conversion, and persistence. Custom code that supplies request attributes should observe the declared column widths, particularly VARCHAR2(30) fields such as the value-name elements of Request_Conversion_Rec_Type, and should check the returned x_return_status and inspect the FND_MSG_PUB message stack after every call. Because the package is a public API with a long-standing signature, callers should invoke it rather than writing directly to the CS_INCIDENTS tables, ensuring that validation, value conversion, and audit behaviour remain consistent across releases.