Search Results hz_industrial_reference_s

Overview

HZ_ORG_INFO_PUB is a public PL/SQL API package in the Oracle E-Business Suite Trading Community Architecture (TCA) schema. Its business purpose is to provide a programmatic interface for maintaining the supplementary informational attributes of organizations and persons beyond their core party records. Specifically, the package manages stock market listings, issued securities, financial reports, financial numbers, certifications, industrial references, industrial classes, and the association of industrial classes to organizations. These attributes are used by customers, suppliers, and other trading partners for classification, compliance, credit assessment, and regulatory reporting.

The package follows standard TCA API conventions: it wraps the corresponding private implementation packages (such as HZ_INDUSTRIAL_REFERENCE_PKG and HZ_CERTIFICATIONS_PKG), calls the FND_API error and message stack, and raises business events through HZ_BUSINESS_EVENT_V2PVT. This aligns it with the broader EBS 12.1.1 and 12.2.2 architecture, where public APIs insulate consumers from changes in underlying validation and persistence logic.

Key Procedures and Functions

The documented interface exposes seventeen procedures and functions, organized as create/update pairs for each entity type plus a retrieval function.

• CREATE_STOCK_MARKETS and UPDATE_STOCK_MARKETS manage records describing stock exchanges on which an organization's securities are traded.
• CREATE_SECURITY_ISSUED and UPDATE_SECURITY_ISSUED maintain details of securities issued by an organization.
• CREATE_FINANCIAL_REPORTS and UPDATE_FINANCIAL_REPORTS handle periodic financial reporting records.
• CREATE_FINANCIAL_NUMBERS and UPDATE_FINANCIAL_NUMBERS capture individual financial figures associated with reports.
• CREATE_CERTIFICATIONS and UPDATE_CERTIFICATIONS maintain certifications held by an organization or person.
• CREATE_INDUSTRIAL_REFERENCE and UPDATE_INDUSTRIAL_REFERENCE manage references to industrial classification schemes.
• CREATE_INDUSTRIAL_CLASSES and UPDATE_INDUSTRIAL_CLASSES maintain the catalog of industrial classes.
• CREATE_INDUSTRIAL_CLASS_APP and UPDATE_INDUSTRIAL_CLASS_APP manage the application of an industrial class to a specific organization.
• GET_CURRENT_FINANCIAL_REPORT retrieves the current financial report for a subject organization.

Each create and update procedure performs validation through HZ_ORG_INFO_VALIDATE and raises the appropriate TCA business event on success.

Tables Accessed

All tables are referenced through APPS synonyms and include both the base entity tables and their corresponding _S (sequence) tables used to generate primary keys.

• HZ_STOCK_MARKETS and HZ_STOCK_MARKETS_S support stock market maintenance.
• HZ_SECURITY_ISSUED and HZ_SECURITY_ISSUED_S support issued securities.
• HZ_FINANCIAL_REPORTS and HZ_FINANCIAL_REPORTS_S, plus HZ_FINANCIAL_NUMBERS and HZ_FINANCIAL_NUMBERS_S, store reporting hierarchies and values.
• HZ_CERTIFICATIONS and HZ_CERTIFICATIONS_S store certification data.
• HZ_INDUSTRIAL_REFERENCE, HZ_INDUSTRIAL_REFERENCE_S, HZ_INDUSTRIAL_CLASSES, HZ_INDUSTRIAL_CLASSES_S, HZ_INDUSTRIAL_CLASS_APP, and HZ_INDUSTRIAL_CLASS_APP_S provide the industrial classification model.

Writes typically use the _S tables for key generation before inserting or updating the base tables.

Usage Notes

HZ_ORG_INFO_PUB is normally invoked from TCA-related Oracle Forms, concurrent programs, and custom integrations whenever supplemental organizational information must be created or changed programmatically. It is also referenced by four other packages, indicating reuse within the TCA code stack. Developers should call the public procedures rather than manipulating the underlying tables directly, because the procedures enforce validation, publish business events, and maintain message-stack consistency. In 12.1.1 and 12.2.2 deployments, the package remains valid and unchanged in interface; the difference between releases lies in the surrounding file system and online patching architecture rather than in this API signature. Note that the package itself is not referenced by any database object, so it serves as a top-level entry point for external callers. The search term hz_industrial_reference_s corresponds to the sequence table used by the industrial reference create and update procedures.