Search Results hz_certifications_s

Overview

APPS.HZ_ORG_INFO_PUB is a public PL/SQL API package body within the Oracle E-Business Suite Trading Community Architecture (TCA) schema, specifically associated with the Oracle Receivables / Customers Online module. Its primary business function is to provide a centralized, programmatic interface for creating and maintaining the non-address, attribute-level information of an organization party. This encompasses commercial profile data such as stock market listings, securities issued, financial reports and financial numbers, certifications (for example, minority- or women-owned business certifications), and industrial classification data (SIC, NAICS, and the associated industrial reference and application records). In the context of EBS 12.1.1 and 12.2.2, HZ_ORG_INFO_PUB serves as the boundary through which forms, concurrent programs, and custom extensions manipulate the child tables that hang off the HZ_PARTIES organization record, ensuring that the corresponding _S (sequence) columns, business events, and validation logic are consistently applied. The user search term hz_certifications_s corresponds directly to one of the documented dependencies of this package: HZ_CERTIFICATIONS_S is the sequence object referenced by the certification-related procedures, confirming that certification records created through this API receive their primary keys from that sequence.

Key Procedures and Functions

The documented package exposes seventeen public procedures and functions, organized as paired create/update operations for each supported entity type. The CREATE_ and UPDATE_ pairs cover: STOCK_MARKETS (organization stock exchange listings), SECURITY_ISSUED (securities issued by the organization), FINANCIAL_REPORTS and FINANCIAL_NUMBERS (financial statement headers and line items), CERTIFICATIONS (certification types and status, keyed via HZ_CERTIFICATIONS_S), INDUSTRIAL_REFERENCE, INDUSTRIAL_CLASSES, and INDUSTRIAL_CLASS_APP (industry classification codes and their application to the party). Each create procedure inserts a new record for the given organization party, while each update procedure modifies an existing record. In addition, GET_CURRENT_FINANCIAL_REPORT is an accessor function that retrieves the organization's currently effective financial report, typically the most recent record as of a given date.

Tables Accessed

The package operates through APPS synonyms over the TCA base tables. For certifications it references HZ_CERTIFICATIONS and HZ_CERTIFICATIONS_S; for financial data, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_REPORTS_S, HZ_FINANCIAL_NUMBERS, and HZ_FINANCIAL_NUMBERS_S; for securities, HZ_SECURITY_ISSUED and HZ_SECURITY_ISSUED_S; for industry 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; and for stock markets, HZ_STOCK_MARKETS and HZ_STOCK_MARKETS_S. The _S objects are sequences used to generate unique identifiers; the base tables store the actual rows.

Usage Notes

HZ_ORG_INFO_PUB is typically invoked by the Customers/Organization forms and by concurrent programs that load or synchronize organization profile data, rather than being called directly by end users. The package depends on the TCA infrastructure packages FND_API, FND_MESSAGE, FND_MSG_PUB, HZ_BUSINESS_EVENT_V2PVT, HZ_UTILITY_PUB, HZ_UTILITY_V2PUB, HZ_ORG_INFO_VALIDATE, and HZ_POPULATE_BOT_PKG, which provide the standard API result handling, message stack, business event publication, and validation services. Custom code extending organization data should call these public procedures rather than performing direct DML, so that sequences, validation, and business events remain synchronized. Note that the package is documented as not referenced by any other database object, so it acts as an entry point rather than an internal dependency.