Search Results location_rec

Overview

AP_WEB_LOCATIONS_PKG is a private PL/SQL package body owned by APPS that supports address validation and geographic location management within the Oracle Payables Internet Expenses (OIE) and Oracle iProcurement expense-entry flows. Its central responsibility is to reconcile a user-entered or imported address against the master list of expense locations held in AP_EXP_LOCATIONS. When an identical address already exists, the package takes no action; when it does not, the package inserts a new location record and can invoke the eLocations service to obtain spatial coordinates (latitude and longitude) for the new address. The package body header references a file name of apwelocb.pls with a version of 120.2, reflecting maintenance in the 12.x release line, and it is relevant to both EBS 12.1.1 and 12.2.2 since the expense-location infrastructure remained stable across those releases.

Key Procedures and Functions

• GET_LOCATION — The primary public entry point, overloaded to accept either a single location record (location_rec) or a collection of locations (loc_array). Both variants return status, message count, and message data parameters. The single-record form simply wraps the record in a collection and delegates to the array form. The procedure checks whether an identical address already exists in AP_EXP_LOCATIONS; if so it performs no insert, otherwise it populates the table and calls out to eLocations to populate spatial coordinates. Its documentation explicitly notes that AP_EXP_LOCATIONS is only populated when MERCHANT_COUNTRY_CODE is non-null.
• DEFAULT_COUNTRY — A function that returns a default country code based on a card program identifier. It is used to supply a country when the user or calling process does not provide one, relying on the card program configuration.

Several private procedures and functions support these public routines, including the private overloads of get_location, default_org_id, set_address_key, the get_geometry overloads, and default_country_pvt. The package also declares a private associative array type (t_string_array) and a country cache (g_country_cache) used to avoid repeated lookups of country data.

Tables Accessed

• AP_EXP_LOCATIONS / AP_EXP_LOCATIONS_S — The primary target of the package. The base table stores validated expense locations and the _S synonym provides the secure (MLS) view used for reads. Rows are inserted here only when MERCHANT_COUNTRY_CODE is non-null.
• AP_CARD_PROGRAMS_ALL — Read to resolve card program configuration, including the default country used by DEFAULT_COUNTRY.
• AP_CREDIT_CARD_TRXNS_ALL — Referenced to relate card transactions to their locations and to drive the card-program-based defaults.
• AP_SUPPLIER_SITES_ALL — Used to associate or validate supplier site address information against expense locations.
• FND_CURRENCIES — Consulted for currency-related validation and defaults.
• HR_ALL_ORGANIZATION_UNITS — Used by default_org_id to derive the operating unit or organization context for the location.
• DUAL and PLITBLM — Utility references for single-row selects and PL/SQL table manipulation.

Usage Notes

AP_WEB_LOCATIONS_PKG is part of the Internet Expenses (AP_WEB) private API layer and is not intended for direct invocation by external applications. It is called from the OIE and iProcurement user interface flows when an expense line is created or when an address is captured, and it may also be invoked by concurrent programs that import or validate expense addresses in bulk. Because it is classified as an OTHER API rather than a public API, customizations should avoid calling it directly; customer code needing equivalent behavior should use supported public APIs or the OIE business logic that invokes this package. The package is documented as referenced by one other package, indicating its role as a shared internal utility. Callers should expect the standard x_return_status, x_msg_count, and x_msg_data out parameters for error handling, and should be aware of the country-code prerequisite before relying on persistence to AP_EXP_LOCATIONS.