Search Results drop_all_triggers




Overview
Explore in AI Chat

Overview

APPS.PO_UTF8TRIGGERS_PVT is a private (PVT) PL/SQL package belonging to the Oracle Purchasing (PO) module. Its name and structure indicate that it exists to manage database triggers associated with a UTF-8 conversion or remediation exercise affecting Purchasing data. The package is a utility wrapper: rather than performing business transactions on purchasing documents, it programmatically creates and removes the trigger set that the conversion process depends upon. The package header carries the revision marker $Header: POXVUTFS.pls 120.0 2005/06/02 00:06:25 appldev noship $, indicating a single, stable implementation with no significant rework since its original check-in. The noship designation confirms the package is not shipped as a standalone product deliverable but is instead an internal helper in the E-Business Suite application schema.

Because it is classified as PVT, the package is not a published integration point. It is not intended to be called directly by external systems, customers, or third-party extensions, and its interface is not covered by Oracle's public API compatibility guarantees. Its scope is narrow and operational: provisioning and tearing down triggers needed during a controlled data conversion window.

Key Procedures and Functions

The package exposes exactly two documented procedures, both parameterless at the interface level as recorded in the ETRM metadata. No formal parameter lists are documented, so callers should look to the package specification rather than assume an interface:

  • CREATE_ALL_TRIGGERS — Creates the complete set of database triggers required by the UTF-8 related conversion logic. This is the procedure most relevant to a search on "create_all_triggers." It is invoked to bring the trigger infrastructure into existence before conversion processing begins.
  • DROP_ALL_TRIGGERS — Removes the same trigger set, providing the inverse operation so the environment can be returned to its normal state after conversion completes.

Together the two procedures form a matched create/drop pair, which is a common pattern for temporary instrumentation used during one-time or infrequent data remediation activities.

Tables Accessed

The only table documented as referenced through APPS synonyms is PLITBLM. This is consistent with the package's role as a trigger-management utility rather than a data-processing routine. The package does not read or write purchasing transaction tables directly; its effect on the database is DDL-oriented, producing and removing trigger objects whose PL/SQL bodies reference Purchasing data structures. PLITBLM is the sole documented dependency, and no APPS synonyms beyond it are recorded in the ETRM metadata.

Usage Notes

APPS.PO_UTF8TRIGGERS_PVT is an internal implementation package and is not designed for direct invocation by application users, forms, or concurrent programs. It is typically called by other Purchasing conversion or patching code during a controlled upgrade or data-remediation window. The referenced-by count in the ETRM metadata is zero, indicating no other documented packages in the repository depend on it — reinforcing that it is a leaf-level helper invoked from non-package contexts or ad hoc deployment scripts. Because the procedures alter database objects, invocation requires appropriate DDL privileges in the APPS schema and should be performed during a maintenance window. The documented practice is to call create_all_triggers before the conversion step and drop_all_triggers afterward, leaving no persistent trigger overhead once the operation completes. Custom code should not depend on this package; it is subject to change without notice as part of internal EBS maintenance.