Search Results agency_address

Overview

OKL_IN_TPP_PVT is a private PL/SQL package body in the Oracle E-Business Suite Lease Management (OKL) module, part of the ETRM (Enterprise Transaction and Reporting Management) application family. The package encapsulates address resolution logic for third-party participants associated with lease and insurance transactions. Its name reflects its role in the "TPP" (Third Party Participant) domain, handling the retrieval of party address information for agencies and agents involved in lease financing and insurance arrangements. As a private ("PVT") API classification package, it is intended for internal consumption by other OKL components rather than direct invocation by external integrations. The package belongs to the 11.5.3 header revision lineage (as indicated by the source header comment referencing version 115.3), and remains documented in the 12.1.1 and 12.2.2 releases. It centralises the mapping between Oracle Trading Community Architecture (TCA) party records and the structured address fields that OKL downstream processes expect.

Key Procedures and Functions

The package exposes two documented functions, both of which follow a consistent pattern: they accept an internal entity identifier and a site identifier, and return a status code while populating a set of OUT NOCOPY VARCHAR2 parameters representing individual address components.

• AGENCY_ADDRESS — Retrieves the name and full structured address of an insurance agency associated with a given insurer and agency site. It accepts an insurer/party identifier (p_isu_id) and an agency site identifier (p_agency_site_id), and returns agency name, address lines 1 through 4, city, county, province, state, postal code, and country. The function returns a standard OKL API status indicator (success or unexpected error).
• AGENT_ADDRESS — The parallel function for individual agents. It accepts an intermediary identifier (p_int_id) and an agent site identifier (p_agent_site_id) and returns analogous agent name and address component outputs. This function follows the same error-handling and return-status conventions as AGENCY_ADDRESS.

Tables Accessed

The package queries two TCA base tables through APPS synonyms:

• HZ_PARTIES — The central TCA registry of parties. The AGENCY_ADDRESS cursor filters on CATEGORY_CODE = 'INSURER' and matches PARTY_ID to the supplied insurer identifier, establishing that only insurer-category parties are eligible.
• HZ_PARTY_SITES — The site-level address table linked to HZ_PARTIES via PARTY_ID and further constrained by party_site_id, ensuring the specific location requested is returned rather than a default address.

Both tables are read-only in this package; no inserts, updates, or deletes are performed.

Usage Notes

Because OKL_IN_TPP_PVT is classified as a private API and is referenced by zero other documented packages, it is invoked internally by OKL business logic — typically from other OKL PL/SQL units, concurrent programs, or OAF/Forms-based pages that must display or print third-party participant addresses on lease documents, insurance certificates, and correspondence. Typical invocation occurs during lease origination, insurance schedule generation, or document printing, where the calling code supplies a known party and site identifier and consumes the returned address fields for display or formatting. Developers extending OKL should not call this package directly unless replicating its parent internal flow; instead the public OKL APIs or TCA address utilities should generally be preferred. Error conditions are surfaced through OKC_API.SET_MESSAGE using standard token substitution for SQLCODE and SQLERRM, returning OKC_API.G_RET_STS_UNEXP_ERROR on failure. Note that a corresponding AGENT_ADDRESS function exists in the same body, so any reliance on this package should account for both functions sharing the same coding conventions.