Search Results hz_security_issued_s

Overview

HZ_ORG_INFO_PUB is a public PL/SQL API package in the Oracle E-Business Suite Release 12.1.1 / 12.2.2 Trading Community Architecture (TCA) schema, owned by APPS and classified as a public (PUB) API. Its business function is to maintain the supplementary organization information that extends the core party and organization model — specifically the financial, industrial classification, certification, stock market, and security issuance data associated with an organization party. These attributes support supplier qualification, customer profiling, regulatory reporting, and risk assessment processes that depend on accurate corporate financial and industrial data.

The package body acts as a thin procedural layer that delegates persistence to the corresponding _PKG packages and _S sequence-backed tables, while standardizing error handling through FND_API, FND_MESSAGE, and FND_MSG_PUB, and publishing business events via HZ_BUSINESS_EVENT_V2PVT. The presence of the related HZ_ORG_INFO_VALIDATE and HZ_UTILITY_PUB dependencies indicates that validation and messaging conform to the TCA API conventions.

Key Procedures and Functions

The documented interface exposes 17 procedures and functions, organized as create/update pairs plus one retrieval function:

• CREATE_STOCK_MARKETS / UPDATE_STOCK_MARKETS — create and maintain stock market records associated with an organization.
• CREATE_SECURITY_ISSUED / UPDATE_SECURITY_ISSUED — create and maintain records of securities issued by the organization.
• CREATE_FINANCIAL_REPORTS / UPDATE_FINANCIAL_REPORTS — create and maintain financial report headers for the organization.
• CREATE_FINANCIAL_NUMBERS / UPDATE_FINANCIAL_NUMBERS — create and maintain the individual financial figures reported for the organization.
• CREATE_CERTIFICATIONS / UPDATE_CERTIFICATIONS — create and maintain certifications such as minority- or women-owned business designations.
• CREATE_INDUSTRIAL_REFERENCE / UPDATE_INDUSTRIAL_REFERENCE — create and maintain industrial reference data.
• CREATE_INDUSTRIAL_CLASSES / UPDATE_INDUSTRIAL_CLASSES — create and maintain the industrial classification (SIC/NAICS-style) assignments for the organization.
• CREATE_INDUSTRIAL_CLASS_APP / UPDATE_INDUSTRIAL_CLASS_APP — create and maintain industrial classification application records that link a classification to its usage context.
• GET_CURRENT_FINANCIAL_REPORT — retrieve the current financial report for an organization.

Each create/update routine follows the standard TCA pattern: validate input, persist to the underlying _S table, and raise standardized API errors through the FND message stack.

Tables Accessed

The package reads and writes the following TCA tables through APPS synonyms: HZ_STOCK_MARKETS, HZ_SECURITY_ISSUED, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS, HZ_CERTIFICATIONS, HZ_INDUSTRIAL_REFERENCE, HZ_INDUSTRIAL_CLASSES, and HZ_INDUSTRIAL_CLASS_APP, along with their corresponding _S (sequence) tables used to generate primary keys. The _S tables are referenced by the create routines for surrogate key generation, while the base tables hold the descriptive data. HZ_INDUSTRIAL_CLASSES_S in particular is the sequence source that the user's search term reflects.

Usage Notes

HZ_ORG_INFO_PUB is typically invoked from the Oracle Forms-based organization and supplier maintenance screens, from concurrent programs that import or refresh organization profile data, and from custom PL/SQL integrations that extend TCA. Because it is a PUB API and referenced by four other packages, custom code should call these procedures rather than inserting directly into the underlying tables, so that validation, key generation, and business event publication remain consistent. Callers should initialize the FND message stack and check the return status before committing.