Search Results ies_deployed_scripts_pvt




Overview
Explore in AI Chat

Overview

IES_DEPLOYED_SCRIPTS_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle iSetup / Enterprise Scripting (IES) product family. Its name and API classification (PVT, private) indicate that it is an internal worker package concerned with the deployment of IES scripts — the stored configuration and data-migration scripts used to copy setup and transactional data between E-Business Suite environments during implementation, cloning, and upgrade activities.

The package is marked VALID in the ETRM 12.2.2 repository and exists in the standard APPS schema shared by 12.1.1 and 12.2.2. It exposes only DECLARED-GLOBAL level subprograms — three DML helpers — and is not a public API. The ETRM dependency listing shows that it references only SYS.STANDARD and is referenced by APPS.IES_DEPLOYED_SCRIPTS_PVT itself, and it is referenced by zero other packages. This confirms a self-contained, private implementation rather than a reusable entry point. No public synonym or grant is documented, and callers outside the IES codebase should treat it as subject to change without notice.

Key Procedures and Functions

ETRM documents three procedures, all conforming to a standard insert/update/delete triad for the deployed scripts repository:

  • INSERT_DEPLOYED_SCRIPTS — Inserts a new deployed-script record, persisting the definition of a script that has been deployed to the current instance.
  • UPDATE_DEPLOYED_SCRIPTS — Updates an existing deployed-script record, reflecting changes to the script definition or its deployment attributes.
  • DELETE_DEPLOYED_SCRIPTS — Removes a deployed-script record, typically when a script is undeployed or superseded.

No parameter lists are published in the ETRM metadata; signature details should be obtained from the package specification on the target instance. The procedures are intended to be invoked only by the parent IES deployment layer, not by external callers.

Tables Accessed

Per the documented table references (resolved through APPS synonyms), the package operates across the IES data model:

Together these reads support validation and contextual resolution at insert, update, and delete time, while the deployed-scripts tables are the DML targets.

Usage Notes

IES_DEPLOYED_SCRIPTS_PVT is not exposed to end users. It is invoked indirectly by the IES framework — typically from the Oracle iSetup / Enterprise Scripting forms and the concurrent programs that load and deploy scripts — and should not be called from custom code. Because it is a PVT package with no documented grants and is referenced by zero other packages, any direct dependency carries upgrade risk. Administrators troubleshooting deployment issues should query the underlying IES tables and review concurrent program log files rather than call these procedures directly. The package should be assumed present and valid on both 12.1.1 and 12.2.2, with behaviour consistent with the ETRM 12.2.2 documentation above.