Search Results hz_certifications_pkg




Overview
Explore in AI Chat

Overview

HZ_CERTIFICATIONS_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It provides the low-level data access layer for the HZ_CERTIFICATIONS entity within the Oracle Trading Community Architecture (TCA) and, more specifically, the Customer Relationship Management certification functionality. Certifications in TCA record the qualifications, licenses, and accreditations held by parties, organizations, and their contacts — for example, minority-owned business status, ISO certifications, or professional licenses — and are commonly consumed by supplier diversity, trade compliance, and customer profiling processes.

The package is classified as an OTHER API rather than a public TCA interface, meaning it is intended for internal use by higher-level certification APIs and generated forms. Its role is to encapsulate single-row DML operations against the HZ_CERTIFICATIONS table, including concurrency control through row locking and standard exception translation via FND_API and FND_MESSAGE.

Key Procedures and Functions

The package body exposes four documented procedures:

  • INSERT_ROW — Inserts a new certification record into HZ_CERTIFICATIONS, populating the entity's persistent columns and returning the generated primary key to the caller.
  • LOCK_ROW — Acquires a row-level lock on an existing certification record, supporting optimistic concurrency control before an update or delete. This prevents concurrent modification of certification data.
  • UPDATE_ROW — Modifies the mutable attributes of an existing certification row, such as status, dates, or descriptive fields, after the row has been locked.
  • DELETE_ROW — Removes a certification record from HZ_CERTIFICATIONS, typically invoked when a certification expires or is withdrawn.

All four follow the standard Oracle EBS API pattern of returning a success or error status and surfacing messages through FND_MESSAGE, with exceptions raised via APP_EXCEPTION and FND_API.

Tables Accessed

The package operates on a single documented table, HZ_CERTIFICATIONS, accessed through the APPS synonym. This table stores the certification records themselves — the association between a party (or party site/contact) and the certification type, along with validity dates and status information. All four CRUD procedures are scoped to this table; INSERT_ROW and UPDATE_ROW write to it, LOCK_ROW and DELETE_ROW operate against it by primary key, and the procedures read pre-existing values to drive locking and validation logic. No other application tables are documented as direct dependencies, confirming the package's narrow, single-entity responsibility.

Usage Notes

HZ_CERTIFICATIONS_PKG is not referenced by any other database object, which indicates it is the bottom of the certification call stack rather than a reusable public interface. Conversely, it is documented as being referenced by one other package, reflecting that a higher-level certification API or an Oracle Forms module calls these procedures to persist certification data entered by users.

In practice the package is invoked from the TCA certification maintenance forms and from any custom PL/SQL or concurrent program that needs to create, amend, or expire certification records for a party. Because it is an internal OTHER-class API, direct calls should be treated as unsupported customization; developers extending TCA certification behavior are advised to use the supported public certification APIs where available. When calling the procedures directly, consumers must supply the party identifier and certification attributes as expected by the underlying HZ_CERTIFICATIONS columns, check the returned status, and handle errors surfaced through FND_MESSAGE rather than relying on unhandled exceptions. The dependencies on FND_API, FND_MESSAGE, APP_EXCEPTION, and STANDARD confirm that the package participates fully in the EBS error-handling framework and should be invoked within a properly managed transaction context.