Search Results delete_field

Overview

PON_FIELDS_PVT is a private PL/SQL package in the Oracle EBS Procurement (PON) module, classified as a PVT (private) API. It provides the internal programmatic interface for maintaining user-defined field definitions used by Oracle Sourcing and related procurement components. The package encapsulates the create, update, and delete logic for these field records, keeping the underlying base tables hidden behind a controlled API layer. In Oracle EBS 12.1.1 and 12.2.2, the PON_FIELDS_PVT package works in tandem with the public-facing field APIs to enforce business rules — such as uniqueness of the field code, mandatory naming, and language-dependent descriptive data — before any DML reaches the tables. Because it is a PVT package, it is not intended as a supported integration point; it is invoked by other PON packages rather than directly by customers.

Key Procedures and Functions

• INSERT_FIELD — Creates a new field definition. It accepts the field code, name, and description, returning a result status plus error code and message. This is the procedure associated with the user's search term "insert_field," and it is the entry point for adding a field to the PON field repository.
• DELETE_FIELD — Removes a field definition identified by its code. It returns the standard result/error indicators, and would typically be invoked only after dependent references have been cleared.
• UPDATE_FIELD — Modifies an existing field's name and description. It accepts the field code, new name, new description, a last-update timestamp for optimistic concurrency, and the old code, which allows the field code itself to be changed. It also returns result, error code, and error message.
• ADD_LANGUAGE — Populates language-specific rows for the translatable field data, generating entries for each installed language. This supports the multi-language requirements stored in the translation table.

Tables Accessed

• PON_FIELDS_TL — The translation table for PON field definitions. The package inserts, updates, and deletes rows here; it is the primary persistent store for the field code, name, description, and associated language information. ADD_LANGUAGE specifically seeds the per-language rows in this table.
• FND_LANGUAGES — The Oracle Application Object Library table of installed and active languages. ADD_LANGUAGE reads this table to determine which languages require translation rows.

All access is performed through APPS synonyms, consistent with standard EBS API packaging conventions.

Usage Notes

PON_FIELDS_PVT is a dependent package, not a user-facing API. In a typical Oracle EBS deployment it is invoked indirectly by higher-level PON logic and by the Sourcing setup forms that manage configurable field definitions. Developers working with the standard "insert_field" behavior should invoke the corresponding public API rather than call PON_FIELDS_PVT directly, because direct invocation bypasses any validation that the caller normally performs. Error handling follows the EBS message dictionary convention: the result out parameter indicates success or failure, while the error code and error message parameters supply the diagnostic detail for the calling routine. The header comment date (2006) indicates the package has been stable across the 12.1.1 and 12.2.2 releases. Customizations should treat this package as read-only reference and rely on supported public APIs to avoid invalidating Oracle's support for the underlying procurement data.