Search Results create_org_contact_ord

Overview

APPS.ASO_PARTY_INT is a PL/SQL integration package within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases that bridges Oracle Order Capture / Quoting (ASO) functionality with the Trading Community Architecture (TCA) data model. Its principal role is to create, validate, and maintain TCA registry entities — parties, party sites, customer accounts, account sites, contacts, and the relationships among them — on behalf of quoting and ordering processes. Because quoting requires consistent customer master data, ASO_PARTY_INT isolates the TCA manipulation logic behind a stable API layer so that other ASO packages do not need to call HZ_* APIs directly.

The package is documented as VALID in both releases and is classified under the "OTHER" API classification. The ETRM metadata records 15 documented procedures/functions and confirms the package references APPS.ASO_QUOTE_PUB and FND_API. It is itself referenced by ASO_CHECK_TCA_PVT, ASO_MAP_QUOTE_ORDER_INT, ASO_ORDER_INT, ASO_PARTY_INT, ASO_PRICING_INT, ASO_QUOTE_HEADERS_PVT, ASO_QUOTE_PUB, and ASO_UTILITY_PVT (listed twice). This reference set confirms the package is a foundational dependency for the wider ASO utility and integration stack, including the ASO_UTILITY_PVT object cited by the search term.

Key Procedures and Functions

The 15 documented procedures/functions cover the principal TCA objects needed to stand up a quoting or ordering party:

• CREATE_PARTY — creates a new party record in the TCA registry.
• CREATE_PARTY_SITE — creates a party site associated with an existing party.
• UPDATE_PARTY — updates attributes of an existing party.
• VALIDATE_CUSTACCOUNT — validates a customer account number or account identifier before use.
• CREATE_CUSTOMER_ACCOUNT — creates a customer account for a party.
• CREATE_ACCT_SITE — creates a customer account site.
• CREATE_ACCT_SITE_USES — creates site use assignments for an account site.
• CREATE_CONTACT — creates a contact record. (The metadata lists 15 entries but the excerpt names 14 distinct procedures/functions; CREATE_PARTY_SITE_USE is the additional entry.)
• CREATE_ORG_CONTACT_ORD — creates an organization contact in the context of an order.
• CREATE_CONTACT_ROLE — assigns a role to a contact.
• GET_ACCT_SITE_USES — retrieves the site uses configured for an account site.
• CREATE_CUST_ACCT_RELATIONSHIP — establishes a relationship between customer accounts.
• UPDATE_CUST_ACCT_RELATIONSHIP — modifies an existing customer account relationship.
• CREATE_PARTY_SITE_USE — creates a party site use record.

The procedure names imply that each accepts parameters describing the party, site, account, or contact attributes to be persisted, and that the procedures return identifiers or status via out parameters consistent with the FND_API error-handling convention.

Tables Accessed

ASO_PARTY_INT reads and writes the core TCA tables via APPS synonyms. HZ_PARTIES, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES support party and site creation. HZ_LOCATIONS holds address data. HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, and HZ_CUST_ACCOUNT_ROLES store customer account and site-use information. HZ_CUST_ACCT_RELATE_ALL stores account-to-account relationships. HZ_ORG_CONTACTS and HZ_ROLE_RESPONSIBILITY support contact and role creation. HZ_RELATIONSHIPS holds party relationships. AR_SYSTEM_PARAMETERS and AMS_SOURCE_CODES provide reference data such as system defaults and source codes, while ASO_ACCOUNT_NUMBER_S is the ASO sequence used to generate account numbers.

Usage Notes

ASO_PARTY_INT is invoked indirectly rather than from end-user forms. Quoting and ordering flows (ASO_QUOTE_PUB, ASO_ORDER_INT, ASO_QUOTE_HEADERS_PVT, ASO_PRICING_INT) call the package when a quote or order must create or refresh a TCA customer. Custom extensions should call ASO_PARTY_INT rather than HZ_* APIs directly to preserve ASO validation and sequencing. Because the package is a documented dependency of ASO_UTILITY_PVT, developers tracing utility or validation logic should expect ASO_PARTY_INT to appear in the call chain.