Search Results get_vendor_site

Overview

APPS.PNRX_RENT_INCREASE_DETAIL is a PL/SQL package within the Oracle Property Manager (PN) module of Oracle E-Business Suite. Its principal responsibility is to support the "Rent Increase Detail" reporting and processing workflow, which allows property managers to review scheduled rent increases across the lease portfolio. The package extracts and formats rent increase data for a defined range of leases, rent increase numbers, and assessment dates, resolving the various foreign key identifiers stored on rent increase records into user-readable values.

In ETRM terms, the package is classified as an API of type OTHER, meaning it is not part of the certified public API set but is commonly called by Oracle Reports, Oracle Forms, and custom extensions. Its header, last modified in 2008, shows a typical utility structure: a single public procedure (RENT_INCREASE_DETAIL) and a suite of getter functions used to translate surrogate IDs into descriptive attributes.

Key Procedures and Functions

• RENT_INCREASE_DETAIL — the core entry point. It accepts lease number, rent increase number, assessment date, lease class, property, building, location, include-draft, and rent type filters. It also receives the standard concurrent request parameters (request ID and user ID) and returns retcode and errbuf. It drives selection of rent increase records for the report or concurrent program.
• get_vendor — returns a vendor_rec record containing vendor name and vendor number (segment1) for a supplied vendor ID, sourced from PO_VENDORS.
• get_vendor_site — resolves a vendor site ID to a printable vendor site identifier.
• get_customer — returns a customer_rec record containing customer name and account number for a supplied customer ID.
• get_customer_bill_site and get_customer_ship_site — resolve site use IDs to bill-to and ship-to site descriptions respectively.
• get_location_code — converts a location ID to its location code.
• get_index_name — resolves an index ID to its index (escalation) name.
• get_project_number and get_task_number — convert project and task IDs to displayable numbers.
• get_lookup_meaning — returns the meaning for a given lookup code and lookup type from FND_LOOKUPS.

Tables Accessed

The package reads from a set of Property Manager and shared Oracle tables via APPS synonyms. PN_RENT_INCREASE_DETAIL_ITF is the rent increase detail interface/table holding the primary records. PN_INDEX_HISTORY_HEADERS and PN_INDEX_LEASE_PERIODS_ALL supply index and escalation history. PN_LOCATIONS_ALL and PN_PAYMENT_TERMS provide location and payment term data. HZ_PARTIES and HZ_CUST_ACCOUNTS supply customer name and account number for the get_customer function, while HZ_CUST_SITE_USES_ALL supports the bill-to and ship-to site lookups. PO_VENDORS supplies vendor name and number for get_vendor. PA_PROJECTS and PA_TASKS provide project and task data. DUAL is used for single-row utility queries.

Usage Notes

PNRX_RENT_INCREASE_DETAIL is typically invoked from an Oracle Reports concurrent program or an Oracle Forms-based rent increase detail form, where RENT_INCREASE_DETAIL acts as the report trigger procedure. The getter functions are also exposed for custom code that needs to resolve IDs to descriptive values consistently with the standard report. Because the package is classified as OTHER rather than a certified public API, Oracle does not guarantee interface stability across patch levels; custom integrations should call it with caution and avoid reliance on the exact return record structures. It is referenced by three other packages in the APPS schema, indicating reuse as a shared utility within the Property Manager module.