Results for “check_unique_party_number”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.HZ_ACCT_CREATE_PKG package belongs to the Oracle E-Business Suite Trading Community Architecture (TCA) foundation. It provides the backend PL/SQL logic used to register new customer accounts within the HZ_CUST_ACCOUNTS model, which is the central repository for the trading community data model shared across Receivables, Order Management, and other modules. In Oracle EBS 12.1.1 and 12.2.2, this package serves as the account-creation engine invoked when a user or process needs to establish a new Account (ACO) record tied to an existing party. The package header retains a CVS revision tag (ARHACTFS.pls 120.2, dated 2005), indicating the object is a stable, legacy-era TCA API that has persisted largely unchanged across releases. It is classified as an OTHER API in the ETRM registry, meaning it is an internal or semi-public interface rather than a fully supported public API, though it remains callable within the EBS data model.
Key Procedures and Functions
The ETRM metadata documents five procedures and functions within this package. Their documented purposes are as follows:
INSERT_ROW— The principal account-creation routine. It accepts the customer account identifier, party identifier, and account number as IN OUT parameters (allowing the package to generate or return these values), together with the descriptive, attribute, and global-attribute flexfield columns, original system reference, status, customer type, class code, sales channel, and related classification data. Its role is to insert the new account row into the customer accounts table.INSERT_PERSON_ROW— A variant of the insert logic tailored to person-type parties, used when the customer account is created for an individual (person) rather than an organization.UPDATE_ROW— Modifies an existing customer account record, applying changes to the DFF/global attribute and profile-level columns held on the account.CHECK_UNIQUE_PARTY_NUMBER— A validation function that verifies the uniqueness of a party number before an account is created, preventing duplicate party references in the TCA model.- The package exposes these routines collectively to support the create/update lifecycle of an account.
Because the ETRM excerpt is truncated, the exact parameter signatures beyond the documented columns are not enumerated here; the attribute and global-attribute parameters follow the standard 20-column TCA descriptive flexfield pattern.
Tables Accessed
The package operates against the core TCA account and party tables, accessed through APPS synonyms:
HZ_CUST_ACCOUNTS— The primary target, holding the account record being inserted or updated.HZ_PARTIES— The party record (organization or person) to which the account is linked.HZ_CUSTOMER_PROFILES— Customer-level profile data associated with the account.HZ_ORGANIZATION_PROFILESandHZ_PERSON_PROFILES— Organization- or person-specific profile attributes, selected based on the party type.HZ_RELATIONSHIPSandHZ_RELATIONSHIP_TYPES— Used to establish or validate the relationship context between parties and accounts.DUAL— Used for single-row evaluations such as uniqueness checks.
Usage Notes
HZ_ACCT_CREATE_PKG is typically invoked indirectly. In standard EBS flows, the Accounts form and the Customer Standard concurrent processes drive TCA account creation through this and related TCA packages rather than exposing it as a user-facing interface. The ETRM registry records that no other packages reference it directly, reinforcing its role as a lower-level implementation routine reached through forms or higher-level TCA APIs. Custom code that needs to create an ACO should generally prefer the supported public TCA APIs; where direct invocation of this package is used, callers must supply a valid party identifier and handle the IN OUT account number and identifier parameters so the generated keys are returned correctly. Because the package is classified as OTHER, upgrade impact should be assessed against each target release.
-
PACKAGE: APPS.HZP_CUST_PKG 12.2.2
-
PACKAGE: APPS.HZP_CUST_PKG 12.1.1
-
PACKAGE: APPS.HZP_CUST_PKG 12.2.2
-
PACKAGE: APPS.HZP_CUST_PKG 12.1.1