Search Results get_payment_summary




Overview
Explore in AI Chat

Overview

The APPS.OKL_AM_CALC_QUOTE_PYMNT_PVT_W package is a private PL/SQL wrapper within the Oracle E-Business Suite Lease and Finance Management (OKL) module. Its header comment (OKLECQPS.pls 120.2) confirms it belongs to the quote payment calculation layer introduced in the 11i/12.x code line and carried forward through 12.1.1 and 12.2.2. The package exposes a single public business procedure, GET_PAYMENT_SUMMARY, that returns an aggregated payment schedule summary for a given quote. Its remaining routines are PL/SQL-to-Java "Rosetta" bridge procedures that marshal data between Oracle collections and Java-side table types, allowing the payment summary result set to be passed through the EBS Java stack (typically a BC4J view object invoked from a quote entry form). The "PRIVATE" and "_W" (wrapper) naming conventions indicate the package is not part of the supported public API surface and should only be called internally by EBS code.

Key Procedures and Functions

  • rosetta_table_copy_in_p23 — Copies inbound JTF collection parameters (number and varchar2 tables) into the package-level pymt_smry_uv_tbl_type structure defined in okl_am_calc_quote_pymnt_pvt. This is the entry point used when a caller must pass a populated payment summary table into PL/SQL.
  • rosetta_table_copy_out_p23 — The counterpart routine; it decomposes an okl_am_calc_quote_pymnt_pvt.pymt_smry_uv_tbl_type record set back into individual JTF number and varchar2 tables so the result can be consumed by Java. Both Rosetta procedures exist solely to support the Java wrapper class of the same logical operation.
  • get_payment_summary — The functional procedure. Given a quote identifier (p_qte_id) plus the standard API version and message-list parameters, it returns a payment summary table along with out-bind table parameters and summary totals (x_pymt_smry_tbl_count, x_total_curr_amt, x_total_prop_amt). The p6_* out parameters are the flattened Rosetta collections that the Java layer unmarshals.

Tables Accessed

The documented metadata lists a single referenced table: PLITBLM (accessed through an APPS synonym). PLITBLM is the standard EBS interim/interface table used by PL/SQL table-to-Java bridging utilities and by concurrent request processing. Its presence here is consistent with the Rosetta pattern: intermediate payment summary rows are staged in PLITBLM so they can be streamed to or from the Java client. The package does not directly read or write OKL transactional tables such as OKC_QUOTES in the documented surface; quote-level data is supplied by the caller through the p_qte_id argument and resolved internally by the underlying okl_am_calc_quote_pymnt_pvt package body.

Usage Notes

  • Primary invocation path: The Oracle Lease Management quote entry form (or its Java/BC4J view object) calls get_payment_summary to display the payment schedule summary lines for a quote. The Java layer binds the p6_* out collections directly.
  • Not a public API: The package is marked private (_PVT_W). Oracle support does not guarantee its signature across patches; custom code should not call it directly.
  • No upstream dependents: ETRM metadata reports zero referencing packages, confirming its narrow, form-driven scope.
  • Version scope: Behavior is identical in 12.1.1 and 12.2.2, as the file header (120.2, dated 2005) predates the 12.1 release; no recompilation logic changes were documented between the two releases.
  • "rosetta_table_copy_in_p23" search context: Users searching this term are typically tracing a Java-to-PLSQL collection handoff. The "_p23" suffix is a generated index identifying this particular pair of copy procedures; it does not carry business meaning beyond distinguishing the generated wrappers in the EBS code generator output.