Search Results chk_for_payment_reqd_fields

Overview

PN_INDEX_LEASE_COMMON_PKG is an Oracle Property Manager (PN) PL/SQL package owned by APPS and classified as an OTHER API within Oracle E-Business Suite. It consolidates the shared logic supporting the index lease feature of Property Manager, which is used to periodically adjust lease payment terms based on an index such as the Consumer Price Index. The package was originally created in April 2001 and has been progressively enhanced to accommodate new parameters such as carry-forward flags, aggregation flags, index finder months, index multipliers, proration rules, and proration period start dates. It is declared with AUTHID CURRENT_USER, meaning that it executes with the privileges of the invoking user and relies on APPS synonyms for all data access. Because it is referenced by eight other packages, it functions as a central library of index-lease utilities rather than as a standalone end-user program.

Key Procedures and Functions

The package exposes a broad set of procedures and functions, documented as 45 total entries. The core retrieval routines include GET_INDEX_LEASE and GET_INDEX_PERIOD, which return index lease and period information and accept parameters controlling carry-forward, aggregation, index finder months, index multipliers, proration rules, and proration period start dates. GET_INDEX_DETAILS, GET_INDEX_PERIOD_DETAILS, GET_INDEX_START_END_DATES, and GET_INDEX_PERIOD_DETAILS support the calculation and presentation of index period boundaries and detail rows. GET_MAX_SCHEDULE_DATE returns the latest schedule date applicable to an index lease.

The package also provides reference-data lookups: GET_PROJECT_NAME (added in August 2001 and later overloaded for MOAC), GET_AR_PAYMENT_TERM, GET_AP_PAYMENT_TERM, GET_AR_TRX_TYPE, GET_AP_ORGANIZATION_NAME, GET_SALESPERSON, GET_LEASE_CHANGE_ID, and GET_TERM_STATUS. Validation routines include CHK_FOR_APPROVED_INDEX_PERIODS, CHK_FOR_PAYMENT_REQD_FIELDS, CHK_FOR_EXPORTED_ITEMS, FIND_IF_PERIOD_EXISTS, FIND_IF_TERM_EXISTS, FIND_IF_NORM_TERM_EXISTS, and FIND_IF_TEMPLATE_USED. Maintenance procedures include DELETE_INDEX_PAYMENT_TERM and UPDATE_LOCATION_FOR_IR_TERMS. Utility and diagnostic procedures include PUT_LOG and PUT_OUTPUT. Historical notes indicate that GET_AP_TAX_DETAILS, GET_AR_TAX_CODE, and GET_TAX_GROUP were removed in March 2006.

Tables Accessed

The package reads and writes Property Manager index lease tables, including PN_INDEX_LEASES_ALL, PN_INDEX_LEASE_PERIODS, PN_INDEX_LEASE_PERIODS_ALL, PN_INDEX_EXCLUDE_TERM_ALL, PN_INDEX_HISTORY_HEADERS, PN_INDEX_HISTORY_LINES, PN_LEASES_ALL, and PN_LEASE_CHANGES_ALL. These support the index lease definition, period generation, exclusion terms, history tracking, and lease change records. Reference data is obtained from AP_TERMS, AP_DISTRIBUTION_SETS_ALL, AP_TAX_CODES, AP_AWT_GROUPS, AR_RECEIPT_METHODS, PA_PROJECTS_ALL (used by GET_PROJECT_NAME), and FND_USER.

Usage Notes

PN_INDEX_LEASE_COMMON_PKG is typically invoked indirectly rather than directly by end users. Property Manager forms and concurrent programs that generate or adjust index lease payments call its routines to retrieve index periods, validate approved periods and required payment fields, resolve payment terms, transaction types, distribution sets, and project names, and to log diagnostic output. Because it is referenced by eight other packages, customizations and extensions should treat it as a shared dependency and avoid modifying its signatures. The MOAC overloads added in June 2005 mean that callers operating in a multi-org context must supply the appropriate organization identifier where the overloaded versions require it. The GET_PROJECT_NAME function, in particular, is used to resolve a PA_PROJECTS_ALL project name for display and validation in index lease processing.