Search Results create_property_locations

Overview

APPS.RRS_SITES_PKG is a PL/SQL package body in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments that supports the Oracle Retail Real Estate (RRS) module. Its principal business function is to manage the interface between RRS site records and Oracle Trading Community Architecture (TCA) location records, most notably by populating and reconciling the PN_LOCATIONS_ITF interface table during property location creation. The package provides the procedural logic behind the concurrent processing of property locations, including validation of input parameters, address propagation from HZ_LOCATIONS to the interface table, and error reporting for failed records. The package header revision noted in the source, RRSSTPKB.pls 120.7, indicates a stable, production-level object maintained under the APPS schema and classified as an OTHER API within the ETRM documentation set.

Key Procedures and Functions

The package exposes five documented procedures and functions:

• CREATE_PROPERTY_LOCATIONS — The core procedure that drives property location creation for a given batch. It accepts an error buffer, a return code, a batch name, and an organization identifier, then validates these parameters, propagates address attributes from HZ_LOCATIONS into PN_LOCATIONS_ITF, and reports failed records. This is the routine referenced by the search term "create_property_locations."
• CREATE_PROPERTY_LOCATIONS_WRP — A wrapper procedure that encapsulates the main logic, typically for standardized error handling and FND message stack management when called from forms or other PL/SQL APIs.
• CREATE_PROPERTY_LOCATIONS_CONC — The concurrent program entry point that adapts CREATE_PROPERTY_LOCATIONS to the concurrent manager calling convention, using the standard errbuf and retcode out parameters plus the batch and organization arguments.
• DELETE_TEMPLATE — Removes a template definition associated with RRS site setup, supporting maintenance of reusable site configuration data.
• GET_COUNTRYCODE — Returns a country code value, used to resolve or validate country information during address and location processing.

Parameter lists are intentionally not reproduced here; ETRM documents these entry points by name and purpose only.

Tables Accessed

The package reads and writes several RRS and TCA tables through APPS synonyms:

• HZ_LOCATIONS — Read as the authoritative source of address attributes (country, address lines, city, postal code, state, province, county, and address style) that are copied into the interface.
• PN_LOCATIONS_ITF — The primary interface table; it is read to identify failed records and updated with resolved address data and location identifiers.
• RRS_SITES_B, RRS_SITES_TL, RRS_SITES_EXT_B, and RRS_SITES_EXT_TL — The base, translated, extension base, and extension translation tables holding site definitions and descriptive attributes.
• RRS_SITE_USES — Stores the usage assignments that qualify how each site is applied within the retail real estate model.

Usage Notes

RRS_SITES_PKG is normally invoked through the RRS property location concurrent program, which calls CREATE_PROPERTY_LOCATIONS_CONC, or programmatically through the wrapper and core procedures when custom code must load or refresh site locations in batch. Referenced by zero other packages in the documented metadata, it sits at the top of its call hierarchy and is best treated as an entry-point API rather than a reusable utility. Callers must supply a non-null batch name and organization identifier; otherwise the package raises FND_API.G_EXC_ERROR after posting the RRS_INV_PARAMETER_PASSED message. Error handling follows the standard FND_MSG_PUB pattern, and failed rows are surfaced by joining RRS_SITES_VL to PN_LOCATIONS_ITF on batch name and site identifier. Address synchronization is performed cursor-driven with FOR UPDATE locking, so deployments should ensure the interface table is not concurrently processed by competing jobs.