Search Results plan_lines

Overview

CSC_PLAN_LINES_PUB is a public PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that provides the supported programmatic interface for maintaining records in the CSC_PLAN_LINES table. As stated in the package header comments, its stated purpose is to be a "Public package to insert, update and delete records from CSC_PLAN_LINES table." It belongs to the Customer Care / Service (CSC) product family, which manages service plans, contracts, and related service-delivery structures within the EBS enterprise data model.

The package is classified as a PUB (public) API in the ETRM registry, meaning it is sanctioned for external invocation by other application modules and by custom extensions. It follows the standard Oracle EBS public/private API architecture: the _PUB layer exposes the documented, supported entry points and delegates work to an accompanying private package, CSC_PLAN_LINES_PVT. The package body carries a long change history dating to 1999, with its last recorded modification in November 2002 (version 115.12), a typical vintage for a long-stable seed product package that has rarely required change since the initial 11i releases.

A notable structural element of the body is the private conversion routine CONVERT_CSC_PLAN_LINES. This routine accepts a public PLAN_LINES record type (which may carry either display values or internal IDs) and converts it into the private record type used by the underlying PVT API call. Its documented rules are that IDs take precedence over values: if both an ID and a value are supplied for a field, the ID is used, the value parameter is ignored, and a warning message is raised.

Key Procedures and Functions

ETRM documents three public procedures within this package body. (The header count of five includes the internal conversion routine and package-scope declarations.)

• CREATE_PLAN_LINES — Inserts one or more new plan line records into CSC_PLAN_LINES. This is the entry point targeted by the search term "create_plan_lines" and is the procedure invoked when new service plan lines must be established through the supported API rather than by direct DML.
• UPDATE_PLAN_LINES — Modifies existing plan line records, allowing attributes of previously created lines to be maintained through the same validated, public interface.
• DELETE_PLAN_LINES — Removes plan line records from the table, providing the supported deletion path for the entity.

Because the public package performs conversion of values to IDs before delegating to the private layer, callers are expected to supply the public record type and let the API resolve foreign-key references. No parameter lists are reproduced here, in keeping with ETRM's documented metadata.

Tables Accessed

The package reads and writes CSC_PLAN_LINES, the primary table for service plan line data. All insert, update, and delete activity is directed at this table, accessed through the APPS synonym. The conversion routine implies indirect lookups against the code and reference tables that translate user-entered values into the IDs stored on CSC_PLAN_LINES, together with validation of any foreign keys on the converted ID columns. No additional tables are enumerated in the ETRM metadata.

Usage Notes

Typical invocation paths include the Service/Contracts forms that maintain plan lines, concurrent programs that bulk-load or migrate plan line data, and custom PL/SQL extensions that must create or maintain plan lines. Because the package is classified PUB, Oracle supports calling it from custom code; direct DML against CSC_PLAN_LINES is not advisable, since the API enforces value-to-ID conversion, warning generation, and the private-layer validations. The 2002 comment noting removal of FND_API defaults and addition of WHENEVER OSERROR EXIT FAILURE ROLLBACK reflects the standard EBS pattern of exception-safe transactional control. No other packages reference CSC_PLAN_LINES_PUB per the ETRM metadata, indicating it is primarily an external integration surface rather than an internal dependency of the CSC suite.