Search Results lns_transfer_loans_concur




Overview
Explore in AI Chat

Overview

APPS.LNS_REP_UTILS is a shared PL/SQL utility package in the Oracle Loans (LNS) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. The package acts as a common repository of report and processing helpers used across the Oracle Loans reporting and concurrent processing infrastructure. It is declared AUTHID CURRENT_USER, so it executes with the privileges of the invoking schema rather than the definer, and it maintains a set of package-global date variables—g_loan_start_date_from, g_loan_start_date_to, g_bill_due_date_from, and g_bill_due_date_to—that carry loan start date and bill due date range selections between the user interface and downstream report logic. Accessor functions (get_loan_start_date_from, get_loan_start_date_to, get_bill_due_date_from, get_bill_due_date_to) expose these values to other packages, of which nine are documented as referencing LNS_REP_UTILS.

Key Procedures and Functions

  • PRINT_CLOB — The public procedure corresponding to the searched term. It writes CLOB content to an output destination, typically a concurrent program log or report output file, enabling large text bodies to be emitted without the size restrictions of standard DBMS_OUTPUT calls.
  • WHICH — A utility function whose name implies selection or dispatch logic; it is used to determine which processing path or report variant applies.
  • PROCESS_PORTFOLIO_REPORT — Generates the loan portfolio report for the selected date range.
  • PROCESS_RECON_REPORT — Produces the reconciliation report covering loan activity.
  • PROCESS_AGREEMENT_REPORT — Produces the loan agreement report output.
  • STORE_LOAN_AGREEMENT — Persists loan agreement content generated by the reporting process.
  • STORE_LOAN_AGREEMENT_CP — Concurrent-program entry wrapper for storing loan agreements.
  • LNS_TRANSFER_LOANS_CONCUR — Concurrent wrapper supporting transfer of loans between portfolios or organizations.
  • LNS_SET_ACCESS_LEVEL_CONCUR — Concurrent wrapper that applies access-level security settings to loan records.
  • LNS_EXPORT_AM_SCHEDS_CONCUR — Concurrent wrapper that exports amortization schedules.
  • REPLACE_SPECIAL_CHARS — Sanitizes text by replacing characters that would break report formatting or XML/HTML output.

The package also defines the four date accessor functions described above. ETRM records fourteen documented procedures and functions in total; the remainder are internal or overloaded variants. Parameter lists are intentionally not enumerated here.

Tables Accessed

References to tables are made through APPS synonyms. Lookup and reference tables include FND_LANGUAGES, FND_TERRITORIES_TL, IBY_PAYMENT_METHODS_TL, HR_ALL_ORGANIZATION_UNITS_TL, and JTF_RS_RESOURCE_EXTNS, which supply language, territory, payment method, organization, and resource descriptions for report output. Customer data is joined from HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS, and HZ_CONTACT_POINTS to present borrower and contact details. Loan-specific data comes from LNS_ASSETS and LNS_ASSET_ASSIGNMENTS, while LNS_AMORT_SCHEDS_GT and LNS_AM_SCHEDS_EXPORTS support amortization schedule generation and export, including the global temporary table used to stage schedule rows during concurrent processing.

Usage Notes

LNS_REP_UTILS is typically invoked from Oracle Loans concurrent programs and from custom report code within the LNS module. Report submission forms populate the package globals via the date range selections, and the processing procedures are then called by concurrent program drivers. Because PRINT_CLOB is public and addressable, it is commonly reused in custom concurrent programs to emit CLOB-based report bodies to the log or output file. Implementers extending Oracle Loans reports should call LNS_REP_UTILS rather than reimplementing date-range handling or text sanitization, and should be aware that package state persists for the life of the session, so global date values must be reset before each report run.