Search Results lns_import_loan_pub

Overview

APPS.LNS_IMPORT_LOAN_PUB is a public PL/SQL API package within the Oracle E-Business Suite Lease Management (LNS) module. Its principal business function is to support the bulk import and creation of lease and loan contracts from external data sources into the ETRM lease repository. Rather than requiring users to enter each contract manually through the Lease Management forms, organizations can stage loan and lease data externally and invoke this API to programmatically instantiate loan headers, loan lines, disbursement structures, rate schedules, and amortization schedules. The package encapsulates the validation, defaulting, and insertion logic required to create a coherent lease contract across the many related tables that comprise the LNS data model. Because it is classified as a PUB (public) API and owned by the APPS schema, it is intended for external invocation by custom code, integration layers, or batch programs rather than being restricted to internal package use.

Key Procedures and Functions

The package exposes a single documented public procedure, IMPORT_LOAN. This entry point performs the end-to-end import of a single loan or lease record. Internally it validates the incoming data against the referenced master tables, applies defaults, writes the loan header and its associated lines and schedules, and captures any failures into the error interface table so that the caller can report on rejected records. The procedure relies on the standard error-handling mechanism common to ETRM public APIs, allowing partial success and detailed diagnostics. Because parameter lists are not enumerated in the available metadata, they are intentionally not reproduced here; callers should consult the package specification directly for the exact signature.

Tables Accessed

The package reads and writes a broad set of ETRM and Oracle master tables through APPS synonyms:

LNS_LOAN_HEADERS_ALL — the primary loan/lease contract header, inserted or updated during import.
LNS_LOAN_LINES — the individual asset or line-level details attached to a contract.
LNS_DISB_HEADERS_S and LNS_DISB_LINES_S — disbursement header and line records associated with the loan structure.
LNS_RATE_SCHEDULES, LNS_TERMS, and LNS_AMORTIZATION_SCHEDS — interest rate, contractual term, and amortization data used to build the financial profile.
LNS_LOAN_PRODUCTS_ALL and LNS_LOAN_TYPES — reference/validation sources for product and loan type classification.
HZ_PARTIES — the trading partner or counterparty lookup.
JTF_RS_ROLES_B and JTF_RS_ROLE_RELATIONS — resource role assignment for the sales team or responsible parties.
LNS_LOAN_CREATE_ERRORS_GT and LNS_LOAN_API_ERRORS_GT — global temporary tables used to stage creation errors and API diagnostics.
DUAL — used for standard single-row operations and defaulting.

Usage Notes

LNS_IMPORT_LOAN_PUB is typically invoked from custom PL/SQL integration scripts, data-conversion routines during implementation, or batch mechanisms that load lease contracts from legacy or third-party systems. It may also be called indirectly by concurrent programs that process staged import data. Because it is a PUB API, it forms part of the supported integration surface for ETRM and should be preferred over direct table inserts, which bypass validation logic. Callers should populate the relevant interface or staging structures, invoke IMPORT_LOAN, then query the error tables (LNS_LOAN_CREATE_ERRORS_GT and LNS_LOAN_API_ERRORS_GT) to detect and resolve rejected records. The package is documented as being referenced by zero other packages, indicating it is a top-level integration entry point rather than an internal dependency, and it is valid in both EBS 12.1.1 and 12.2.2.

PACKAGE: APPS.LNS_IMPORT_LOAN_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_IMPORT_LOAN_PUB, status:VALID,
SYNONYM: APPS.LNS_LOAN_CREATE_ERRORS_GT 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_LOAN_CREATE_ERRORS_GT, status:VALID,
SYNONYM: APPS.LNS_DISB_LINES_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_DISB_LINES_S, status:VALID,
SYNONYM: APPS.LNS_LOAN_PRODUCTS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_LOAN_PRODUCTS_ALL, status:VALID,
PACKAGE: APPS.LNS_REP_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_REP_UTILS, status:VALID,
SYNONYM: APPS.LNS_LOAN_API_ERRORS_GT 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_LOAN_API_ERRORS_GT, status:VALID,
PACKAGE: APPS.LNS_LOAN_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_LOAN_PUB, status:VALID,
PACKAGE BODY: APPS.LNS_IMPORT_LOAN_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_IMPORT_LOAN_PUB, status:VALID,
SYNONYM: APPS.LNS_LOAN_TYPES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_LOAN_TYPES, status:VALID,
PACKAGE: APPS.LNS_DISTRIBUTIONS_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_DISTRIBUTIONS_PUB, status:VALID,
PACKAGE: APPS.LNS_BILLING_BATCH_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_BILLING_BATCH_PUB, status:VALID,
SYNONYM: APPS.LNS_RATE_SCHEDULES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_RATE_SCHEDULES, status:VALID,
PACKAGE: APPS.LNS_LOAN_HEADER_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_LOAN_HEADER_PUB, status:VALID,
SYNONYM: APPS.LNS_DISB_HEADERS_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_DISB_HEADERS_S, status:VALID,
PACKAGE: APPS.LNS_INDEX_RATES_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_INDEX_RATES_PUB, status:VALID,
PACKAGE: APPS.LNS_TERMS_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_TERMS_PUB, status:VALID,
SYNONYM: APPS.LNS_LOAN_LINES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_LOAN_LINES, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.LNS_FUNDING_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:LNS_FUNDING_PUB, status:VALID,
SYNONYM: APPS.LNS_TERMS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_TERMS, status:VALID,
SYNONYM: APPS.LNS_AMORTIZATION_SCHEDS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_AMORTIZATION_SCHEDS, status:VALID,
SYNONYM: APPS.LNS_LOAN_HEADERS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_LOAN_HEADERS_ALL, status:VALID,
PACKAGE: APPS.AR_RECEIPT_API_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_RECEIPT_API_PUB, status:VALID,
PACKAGE: APPS.LNS_IMPORT_LOAN_PUB 12.2.2
SYNONYM: APPS.JTF_RS_ROLES_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JTF_RS_ROLES_B, status:VALID,
SYNONYM: APPS.JTF_RS_ROLE_RELATIONS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JTF_RS_ROLE_RELATIONS, status:VALID,
APPS.LNS_IMPORT_LOAN_PUB dependencies on LNS_IMPORT_LOAN_PUB 12.2.2
PACKAGE BODY: APPS.LNS_IMPORT_LOAN_PUB 12.2.2
SYNONYM: APPS.HZ_PARTIES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_PARTIES, status:VALID,
PACKAGE: APPS.FND_LOG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_LOG, status:VALID,
SYNONYM: PUBLIC.DUAL 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
PACKAGE: APPS.FND_MSG_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_MSG_PUB, status:VALID,
PACKAGE: APPS.FND_PROFILE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.FND_MESSAGE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_MESSAGE, status:VALID,
PACKAGE: APPS.FND_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,