Search Results csc_plan_lines_pub




Overview
Explore in AI Chat

Overview

CSC_PLAN_LINES_PUB is a public PL/SQL API package owned by the APPS schema in Oracle E-Business Suite. It belongs to the CSC (Customer Service / Service Contracts) product family and is classified as a PUB (public) API, indicating that it is intended for external invocation by other application modules, forms, concurrent programs, or custom extensions rather than being restricted to internal use. The package provides the business logic layer for creating, maintaining, and removing plan line records associated with service planning activities. In functional terms, plan lines represent the individual schedule or resource entries that make up a service or maintenance plan, and this API encapsulates the validation and DML operations required to keep those lines synchronized with their parent plan structures. The ETRM metadata confirms the object is VALID in the 12.2.2 environment and originates from the APPS schema, consistent with standard Oracle EBS API design conventions.

Key Procedures and Functions

The ETRM documentation lists five documented program units in total, with the following named procedures identified:

  • CREATE_PLAN_LINES — Inserts one or more new plan line records. This procedure encapsulates the validation required before a plan line can be persisted, including checks against the parent plan and any mandatory descriptive attributes.
  • UPDATE_PLAN_LINES — Modifies existing plan line records. It is used to change attributes such as scheduling, quantities, or status information on lines already attached to a plan.
  • DELETE_PLAN_LINES — Removes plan line records. This procedure handles the deletion of lines, typically applying the same referential and status checks required to keep the plan structure consistent.

The metadata reports five documented procedures or functions in total, but only the three above are named in the excerpt. Parameter lists are not published in the available ETRM content and are deliberately not reconstructed here; callers should obtain exact signatures from the package specification in the target instance before use. The three named procedures follow the conventional pattern of a create/update/delete API set, which is the standard design for Oracle EBS public packages.

Tables Accessed

The ETRM metadata does not enumerate specific base tables accessed through APPS synonyms for this package. The documented dependency information shows only core database dependencies on SYS and the STANDARD package, which is typical of compiled PL/SQL units and does not describe application-level table usage. Functionally, a plan lines API of this name operates against the CSC plan line base tables and their associated plan header tables, reading parent plan records for validation and writing line-level details. Because the metadata does not list the underlying tables explicitly, integrators should inspect the package body or the ETRM table dependency report for the exact object list in their instance.

Usage Notes

CSC_PLAN_LINES_PUB is a public API and is intended to be invoked by external callers rather than through direct table DML. Typical invocation paths include Oracle Forms user interfaces within the Service/Contracts modules, concurrent programs that generate or refresh plan lines in bulk, and custom PL/SQL code developed for implementation-specific extensions. The ETRM dependency report records that this package is referenced by no other packages, which indicates it is a top-level API rather than a helper called by other PL/SQL units. When integrating, developers should call the CREATE, UPDATE, and DELETE procedures rather than writing directly to the underlying plan line tables, so that the package's validation logic and any seeded business rules are preserved. As with all APPS public APIs, the procedures should be invoked within a properly managed transaction, with commit or rollback controlled by the calling program rather than assumed by the API.