Search Results update_org_contact

Overview

APPS.IES_TCA_BP_PKG is a PL/SQL package belonging to the Oracle E-Business Suite Internet Expenses (IES) application. It was originally designed as a bridging layer between Internet Expenses and the Trading Community Architecture (TCA) model, providing APIs to create and maintain party, organization, person, location, and contact records used for expense-related business processes. The package is classified as an "OTHER" API type in the ETRM metadata and is owned by the APPS schema.

In Oracle EBS 12.1.1 and 12.2.2, the functionality of this package is obsolete. The package header and body retain their public signatures so that any legacy callers compile and run without error, but each procedure returns a forced failure status and an associated message indicating retirement. The header comment "$Header: iestcbpb.pls 120.2 2005/08/05" reflects the last substantive revision, which predates the current 12.x code lines and underscores that no active development maintains this package.

Key Procedures and Functions

The ETRM metadata documents seven procedures exposed by this package. All follow the same deprecated pattern: they set x_return_status to 'F', populate x_msg_count and x_msg_data from the FND message IES_TCA_API_OBSOLETE, and return zero values for identifier outputs.

• CREATE_ORGANIZATION — historically created an organization party record within TCA, accepting organization name, user name, and content source type, and returning party identifiers and a profile identifier.
• CREATE_PERSON — historically created a person party record, accepting first, middle, and last names plus title and user name, and returning party and profile identifiers.
• CREATE_LOCATION — historically created an address/location record for subsequent association with a party site.
• CREATE_PARTY_SITE — historically created a party site linking a party to a location.
• CREATE_ORG_CONTACT — the user's stated search term; this procedure historically created a contact (contact point or contact role) associated with an organization party. Its parameters are not reproduced here, as the excerpt does not enumerate them.
• UPDATE_ORG_CONTACT — historically modified an existing organization contact record.
• UPDATE_PARTY_SITE — historically modified an existing party site, including its associated location details.

Tables Accessed

The ETRM metadata for this package does not list any tables referenced through APPS synonyms. This is consistent with the current obsolete implementation: the body contains only control-flow statements, FND message calls, and OUT parameter assignments, with no DML against HZ_ or other TCA tables. Historically the create/update procedures would have written to TCA entities such as HZ_PARTIES, HZ_LOCATIONS, HZ_PARTY_SITES, and HZ_ORG_CONTACTS, but those dependencies are no longer present in the shipped code and cannot be confirmed from the metadata provided.

Usage Notes

Because all procedures return x_return_status = 'F' with the message IES_TCA_API_OBSOLETE, callers should treat the package as defunct. Any code path still invoking IES_TCA_BP_PKG.Create_org_contact or its sibling procedures will receive a hard failure and must be redirected to the supported TCA public APIs, such as HZ_PARTY_V2PUB.Create_organization_contact or HZ_CONTACT_POINT_V2PUB, depending on the specific business requirement.

The package is not referenced by any other documented packages in ETRM, indicating that standard Oracle EBS flows have already been re-pointed to TCA APIs. Typical historical invocation points — Expense Report forms, supplier/employee synchronization routines, and custom extensions — should be reviewed to eliminate residual calls. No concurrent program or form in 12.1.1 or 12.2.2 should rely on this package for new development.