Search Results create_terms

Overview

APPS.PN_LEASE_PUB is the public application programming interface package for Oracle Property Manager (PN), the Oracle E-Business Suite module responsible for real estate lease administration and accounting. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package exposes the supported, externally callable entry points for creating, modifying, and terminating lease records held in the Property Manager schema. The package body (PNLSPUBB.pls, version 120.4) wraps an underlying private layer, PN_LEASE_PVT, which contains the detailed validation and processing logic, while PN_LEASE_PUB presents a stable, FND_API-compliant interface to forms, concurrent programs, and custom integrations.

The package follows the standard Oracle Applications API conventions: each procedure accepts an API version, init message list flag, commit and validation flags, an IN OUT lease record, associated detail tables, and standard OUT parameters for message count, message data, and return status. Global constants capture the runtime context — responsibility application, responsibility identifier, user, login, and the current operating unit obtained from the ORG_ID profile option — scoping all transactions to the caller's organization.

Key Procedures and Functions

• CREATE_LEASE — Establishes a new lease in Property Manager. It accepts the lease header record together with associated detail collections covering expense and revenue accounts, accrual accounts, liability and receivable accounts, contacts, tenancies, insurance, rights, obligations, options, lease payment terms, and notes. It returns the standard FND_API message and status outputs.
• UPDATE_LEASE — Modifies an existing lease and its associated detail records, applying the same validation and account-handling conventions as the create path.
• CREATE_TERMS — Adds payment terms to a lease. This procedure is the object returned by the user's "create_terms" search and is the supported programmatic route for inserting lease term and payment schedule information.
• UPDATE_TERMS — Modifies existing lease payment terms previously created through the terms API.
• UPDATE_STATUS — Changes the status of a lease, supporting lifecycle transitions such as activation, termination, or other state changes managed by Property Manager.

Tables Accessed

The documented table reference for this package is PN_LEASES_ALL, the base lease table in the Property Manager schema, accessed through the APPS synonym. The API reads and writes lease headers here when leases are created, updated, or have their status changed; the detail collections passed as parameters ultimately populate the dependent Property Manager entities (accounts, contacts, tenancies, insurance, obligations, options, terms, and notes) through the private layer. Because the package is APPS-owned and uses synonyms, it is org-striped by the operating unit context established at initialization.

Usage Notes

PN_LEASE_PUB is the recommended integration point for customers and partners extending Property Manager. It is invoked by Oracle's own UI layers, by concurrent processes that create or adjust leases in batch, and by custom PL/SQL that must insert leases or lease terms without writing directly to the base tables. Callers should supply a valid API version, pass fnd_api.g_true for validation when testing, and inspect x_return_status and the message stack rather than relying on exceptions. The documented metadata records no other packages referencing PN_LEASE_PUB, indicating it is a top-level public API rather than an internal dependency.