Search Results process_calculate_type




Overview
Explore in AI Chat

Overview

PN_VARIABLE_AMOUNT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the variable rent (variable amount) processing features of Oracle Property Manager (PN). Variable rent arrangements allow lease terms to be billed based on actual usage—commonly sales volume, unit volume, or a percentage of receipts—rather than fixed scheduled amounts. The package encapsulates the calculation, constraint application, backup retention, and invoicing logic required to translate reported variable activity into billable rent amounts and ultimately into invoices.

The package is declared with AUTHID CURRENT_USER and is classified generically (OTHER) rather than as a public API, indicating it is intended primarily for internal use by Property Manager forms, concurrent programs, and other PN packages rather than for direct customer invocation. It is referenced by five other packages, confirming its role as a shared component within the variable rent subsystem.

Key Procedures and Functions

  • PROCESS_VARIABLE_RENT — Primary driver that processes a variable rent record for a given period, line item, cumulative flag, invoice-on option, and calculation type.
  • PROCESS_RENT — Performs the rent processing for a group date, accepting volume, deduction, and date parameters that drive the computed variable rent amount.
  • INSERT_INVOICE — Creates invoice records for processed variable rent, driven by calculation type, period, and variable rent identifier.
  • GET_RENT_APPLICABLE — Returns the applicable rent amount based on cumulative flag, net volume, and percentage of days open.
  • PROCESS_CALCULATE_TYPE — Applies the calculation type logic for a line item, period, cumulative setting, and invoice date.
  • GET_CUM_VOL_BY_GRPDT — Returns cumulative actual volume, forecast volume, and cumulative deductions for a group date.
  • GET_BKP_DETAILS — Retrieves backup detail information for a given line item.
  • FIND_VARRENT_EXISTS — Checks whether a variable rent record exists for a line item and group date.
  • CALCULATE_VAR_RENT — Computes the variable rent from volume, cumulative volume, cumulative deductions, cumulative flag, and calculation type inputs.
  • GET_VARRENT_DETAILS — Returns detailed variable rent information used by downstream processing and display.
  • APPLY_CONSTRAINTS — Applies variable rent constraints configured against the arrangement.
  • GET_TRANSFERRED_FLAG / GET_PRIOR_TRANSFER_FLAG — Return transfer status indicators used to determine processing eligibility.
  • GET_PREV_INV_AMT — Retrieves the previously invoiced amount, typically to avoid duplicate billing.
  • FIND_IF_TERM_EXISTS — Determines whether a payment term (variable term) exists for the given context; this is the function associated with the user's search. It is commonly used to validate that a variable term is defined before calculation or invoicing proceeds.
  • FIND_VOLUME_EXISTS — Checks whether volume data exists for the applicable context.
  • GET_DEDUCTIONS — Returns deduction amounts applicable to variable rent calculations.
  • GET_PERCENT_OPEN — Returns the percentage of the period that is open, used for proration logic.
  • GET_CUMULATIVE_VOLUME — Returns cumulative volume used in tiered or cumulative calculation methods.
  • PUT_LOG — Writes diagnostic or processing log entries.

Tables Accessed

The package operates across the core Property Manager variable rent schema via APPS synonyms. Lease and location context is drawn from PN_LEASES, PN_LEASE_DETAILS_ALL, and PN_LOCATIONS_ALL. Payment terms are read from PN_PAYMENT_TERMS_ALL, supporting FIND_IF_TERM_EXISTS. Variable line definitions reside in PN_VAR_LINES_ALL, with period definitions in PN_VAR_PERIODS and PN_VAR_PERIODS_ALL. Group date scheduling uses PN_VAR_GRP_DATES and PN_VAR_GRP_DATES_ALL. Deduction data is held in PN_VAR_DEDUCTIONS and PN_VAR_DEDUCTIONS_ALL, while constraint definitions are stored in PN_VAR_CONSTRAINTS_ALL. Backup and audit snapshots are maintained in PN_VAR_BKPTS_DET_ALL, PN_VAR_BKPTS_HEAD, and PN_VAR_BKPTS_HEAD_ALL, which support the backup detail retrieval routines.

Usage Notes

PN_VARIABLE_AMOUNT_PKG is typically invoked indirectly. Variable rent entry and processing forms in Oracle Property Manager call these procedures when users submit, calculate, or generate invoices for variable rent. Concurrent programs that process variable rent on a scheduled basis also invoke PROCESS_VARIABLE_RENT and related routines. Because the package is not classified as a public API, custom extensions should exercise caution: signature changes between releases are possible, and the package relies on AUTHID CURRENT_USER with APPS synonyms, so calling schema privileges must be appropriate. Developers extending variable rent behavior should prefer wrapping calls to the documented functions such as FIND_IF_TERM_EXISTS and GET_RENT_APPLICABLE rather than reimplementing term, volume, or constraint validation. Note that FIND_IF_TERM_EXISTS corresponds to checking whether a variable payment term exists for the given context; it is a validation helper rather than a data-changing routine.