Search Results csfw_req_pub




Overview
Explore in AI Chat

Overview

APPS.CSFW_REQ_PUB is a public PL/SQL package body in the Oracle E-Business Suite Applications schema. It provides the programmatic interface for creating and deleting requirement headers and requirement lines within the Oracle Field Service / Telecommunications Service Fulfillment data model that is built on the CSP (Customer Service Product) requirement schema. In EBS 12.1.1 and 12.2.2 the object is documented as VALID and is classified as a PUB (public) API, indicating that it is intended for invocation by external callers such as forms, concurrent programs, and custom extensions rather than being restricted to internal use.

The package acts as a thin public wrapper over the private CSP requirement business logic. It depends on CSP_REQUIREMENT_HEADERS_PVT and CSP_REQUIREMENT_LINES_PVT, which encapsulate the actual DML and validation rules, and it relies on FND_API and FND_MSG_PUB for the standard EBS API error-handling and message-stack conventions. This dependency pattern is characteristic of the EBS API architecture, in which a _PUB package exposes a stable public contract while the _PVT packages hold the implementation.

Key Procedures and Functions

The ETRM metadata documents four procedures in the package body:

  • CREATE_REQUIREMENT_HEADER — Inserts a new requirement header record, establishing the parent entity to which requirement lines are subsequently attached. It delegates to CSP_REQUIREMENT_HEADERS_PVT and returns status and message information through the FND_API message stack.
  • DELETE_REQUIREMENT_HEADER — Removes an existing requirement header, including the cascading handling of its dependent requirement lines. Deletion logic is delegated to CSP_REQUIREMENT_HEADERS_PVT.
  • CREATE_REQUIREMENT_LINE — Inserts a new requirement line associated with an existing requirement header, delegating validation and DML to CSP_REQUIREMENT_LINES_PVT.
  • DELETE_REQUIREMENT_LINE — Removes a single requirement line, with validation and DML performed by CSP_REQUIREMENT_LINES_PVT.

The parameter lists are not enumerated in the available metadata and are therefore not reproduced here; callers should reference the package specification for exact signatures.

Tables Accessed

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

  • CSP_REQUIREMENT_HEADERS_S1 — The sequence-backed surrogate key source for requirement header primary keys, referenced during header creation.
  • CSP_REQUIREMENT_LINES_S1 — The sequence-backed surrogate key source for requirement line primary keys; this is the object the user searched for and is the direct dependency that links the search term to CSFW_REQ_PUB.
  • CSP_REQUIREMENT_LINES — The base requirement line table into which line records are inserted and from which they are deleted.
  • DUAL — Used for scalar sequence value retrieval (for example, SELECT sequence.NEXTVAL FROM DUAL) during key generation.

Direct references to CSP_REQUIREMENT_HEADERS (the base header table) are not listed; header DML is performed indirectly through CSP_REQUIREMENT_HEADERS_PVT.

Usage Notes

CSFW_REQ_PUB is a leaf-level API: the ETRM metadata confirms that it is not referenced by any other database object, so it is always invoked from outside the database — typically from Oracle Forms, OAF pages, concurrent programs, or custom PL/SQL. Because it is classified as a public API, customizations and integrations should call CSFW_REQ_PUB rather than manipulating the CSP requirement tables directly, ensuring that validations and sequence-based key generation are performed consistently.

In 12.1.1 and 12.2.2 the package behaves identically with respect to the documented dependencies. Callers should inspect FND_MSG_PUB after each invocation to retrieve error messages, and should treat any non-success FND_API return status as a rollback condition in the calling transaction, since the package follows standard EBS API transactional semantics.