Search Results cs_servicerequest_pub_w




Overview
Explore in AI Chat

Overview

The package body APPS.CS_SERVICEREQUEST_PUB_W is the public wrapper layer for the Service Request business API in Oracle E-Business Suite. Its counterpart, CS_SERVICEREQUEST_PUB, contains the substantive service request logic, while this "_W" package exposes a stable, external-facing entry point that shields callers from internal implementation details. It belongs to the Service (CS) module and supports the creation, modification, and status management of service requests — the core transactional entity of Oracle TeleService and the Service Request center. The package is documented as OTHER in the API classification and is currently VALID under the APPS schema in both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents 25 procedures. These divide into two functional groups.

  • ROSETTA_TABLE_COPY_IN_Pn / ROSETTA_TABLE_COPY_OUT_Pn: Paired "copy-in" and "copy-out" routines (P1, P3, P8, P10, P11, P13, P17, P19) that translate between the API's external parameter representation and internal PL/SQL collection types. The copy-in variants marshal incoming data from the standardized nested-table parameters into the working structures used by the underlying API, while the copy-out variants perform the reverse translation on return. The Rosetta naming reflects the role of these routines as the interface "translation" layer between the client-visible parameter contract and the internal engine.
  • INITIALIZE_REC: Initializes the service request record structure with default values prior to population and processing.
  • CREATE_SERVICEREQUEST: The primary public entry point for creating a new service request.
  • UPDATE_SERVICEREQUEST: Applies modifications to an existing service request.
  • UPDATE_STATUS: Transitions the status of a service request (for example, open, closed, or cancelled) through the standard status model.

Tables Accessed

The dependency listing identifies the PL/SQL table (collection) types used by this package: JTF_DATE_TABLE, JTF_NUMBER_TABLE, and the JTF_VARCHAR2_TABLE_100/200/300/1000/2000/32767 family. These are the standard JTF array types used throughout the EBS Service APIs to pass multi-row, indexed data in a single call rather than row-by-row. The package also references the PLITBLM object, which is a standard Oracle database synonym for the DBMS_SQL PL/SQL table index-by binary_integer type used for dynamic SQL processing. No application tables are listed directly in the metadata; the underlying DML against the service request and related transactional tables is performed by the CS_SERVICEREQUEST_PUB package that this wrapper invokes.

Usage Notes

This package is typically invoked from Service module forms, concurrent programs, and custom extensions that need to create or maintain service requests programmatically without calling internal APIs directly. Because it is the public ("_W") wrapper, custom code should reference it rather than CS_SERVICEREQUEST_PUB. The API follows the standard EBS design pattern, using FND_API return status and message handling together with the JTF nested-table parameters. In 12.2.2 the object retains the same structure and dependency set as in 12.1.1, so upgrade impact is minimal. The metadata notes that this package is not referenced by any database object, indicating it is a terminal external interface.