Search Results loan_request_amount

Overview

LNS_OCM_ADP_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Loans (LNS) module. Its naming convention identifies it as belonging to the Origination and Credit Management (OCM) component of the Loans product, with the ADP segment indicating an Application Data Provider role and the PUB suffix designating it as a public API intended for invocation by other Oracle EBS modules, external integrations, or custom extensions. The package encapsulates the business rules used to evaluate loan request attributes, creditworthiness indicators, collateral positions, and portfolio-level loan statistics. In Oracle EBS 12.1.1 and 12.2.2, the package status is VALID, confirming it is compiled and available in the database.

Functionally, LNS_OCM_ADP_PUB supports origination and credit-management decisioning by exposing derived loan metrics and qualification checks. These values are typically consumed by Oracle Loans setup screens, workflow-enabled approval processes, and any integration that must assess whether a loan request is secured, fully collateralized, or within acceptable delinquency thresholds.

Key Procedures and Functions

The documented interface exposes twenty-nine procedures and functions in total. The published members include the following:

• LOAN_REQUEST_AMOUNT — Returns the requested principal amount associated with a loan request.
• IS_SECURED_LOAN — Determines whether a given loan qualifies as secured.
• LOAN_COLLATERAL_PERCENTAGE — Derives the ratio of collateral value to loan exposure.
• INITIAL_INTREST_RATE — Returns the initial interest rate applicable to the loan.
• NUMBER_OF_COBORROWERS / IS_HAVING_COBORROWERS — Provide the count of co-borrowers and a boolean indicator of their presence.
• NUMBER_OF_GUARANTORS / IS_HAVING_GUARANTORS — Provide the count of guarantors and a boolean indicator of their presence.
• REQUIRED_COLLATERAL_AMOUNT — Returns the minimum collateral required to satisfy policy.
• TOTAL_COLLATERAL_AMOUNT — Returns the aggregate collateral pledged to the facility.
• DELIQUENCY_COND_AMOUNT — Returns the monetary threshold applicable to delinquency conditions.
• TOTAL_ASSETS_VALUATION_AMT / TOTAL_ASSETS_PLEDGED_AMT / TOTAL_ASSETS_AVAILABLE_AMT — Report the valuation, pledged value, and unencumbered value of the borrower's asset base.
• NUMBER_ACTIVE_LOANS / BALANCE_AMT_ACTIVE_LOANS — Return the count and outstanding balance of active loans.
• NUMBER_PENDING_LOANS / BALANCE_AMT_PENDING_LOANS — Return the count and balance of pending loans.
• NUMBER_DELINQUENT_LOANS / BALANCE_AMT_DELINQUENT_LOANS — Return the count and balance of delinquent loans.

Parameter lists are not documented in the ETRM metadata and should be confirmed in the installed package specification before use.

Tables Accessed

The package resolves the following base tables through APPS synonyms: AR_CMGT_SETUP_OPTIONS (credit management setup defaults), LNS_ASSETS and LNS_ASSET_ASSIGNMENTS (asset inventory and allocation used for collateral and pledged-asset calculations), LNS_LOAN_HEADERS_ALL (primary loan records), LNS_PARTICIPANTS (borrowers, co-borrowers, and guarantors), LNS_RATE_SCHEDULES (interest rate derivation), LNS_TERMS (loan terms and conditions), and DUAL for scalar evaluations.

Usage Notes

LNS_OCM_ADP_PUB is a read-oriented provider API. It is typically invoked from Oracle Loans forms and workflow functions to populate credit and collateral fields, from concurrent programs that generate portfolio or delinquency reporting, and from custom PL/SQL integrations extending loan origination. The dependency metadata indicates no other APPS packages reference it directly, so consumers are limited to forms, concurrent programs, and external or custom code. Because it reads using APPS synonyms, it must be called in an environment where the APPS schema grants are valid; direct invocation from non-APPS schemas requires appropriate synonyms and grants.