Search Results jl_br_ar_collection_docs




Overview
Explore in AI Chat

Overview

The APPS.JL_BR_AR_COLLECTION_DOCS_PKG package body is a Brazilian Localization (JL_BR) component within Oracle E-Business Suite, delivered in the APPS schema and validated in both release 12.1.1 and 12.2.2. Its functional domain is Oracle Receivables, specifically the management of collection documents — the Brazilian banking instruments (such as boletos and related cobrança records) used to formalize and track customer collections through authorized banks. The package encapsulates the data-manipulation logic required to persist and maintain these collection document records in the underlying JL_BR_AR_COLLECTION_DOCS table, isolating the localization's insert and update rules behind a stable PL/SQL API.

Because it is a localization package body rather than a public Oracle API, it carries an ETRM classification of OTHER. It is not part of a published, fully documented interface, but it is a first-class dependency of the Brazilian Receivables collection flow. The body depends on APP_EXCEPTION for error signaling, FND_MESSAGE for translatable error text, and the STANDARD package for base PL/SQL types and constructs.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package body:

  • INSERT_ROW — Creates a new collection document record. It is the entry point used when a new Brazilian collection instrument is generated or imported and must be registered in the AR localization tables.
  • UPDATE_ROW — Modifies an existing collection document record. It supports lifecycle changes to a document already persisted, such as status, bank return, or reconciliation-related attributes.

Parameter lists and detailed signatures are not reproduced here; callers should inspect the package specification in the database for exact arguments. Both routines rely on APP_EXCEPTION and FND_MESSAGE to raise and translate errors consistently with Oracle's localization coding standards.

Tables Accessed

The package body references a single documented table:

  • JL_BR_AR_COLLECTION_DOCS — the Brazilian AR collection documents table. INSERT_ROW writes new rows into it, and UPDATE_ROW modifies existing ones. This table stores the localization-specific attributes of collection documents that are not held in the standard Receivables tables.

The table is referenced through the APPS synonym, meaning the package operates within the standard APPS schema context rather than against a private schema object. No other application tables are documented as direct dependencies.

Usage Notes

The package is invoked from within the Brazilian Receivables localization flow rather than as an end-user-facing API. Typical callers include the localization forms and concurrent programs that manage cobrança and collection documents, which delegate their row-level DML to INSERT_ROW and UPDATE_ROW so that validation and error messaging remain centralized. Custom extensions that need to programmatically create or amend Brazilian collection documents should call these procedures instead of performing direct DML on JL_BR_AR_COLLECTION_DOCS, preserving the package's integrity checks and standard exception handling.

The ETRM metadata records that APPS.JL_BR_AR_COLLECTION_DOCS_PKG is not referenced by any other database object. It is therefore a leaf-level dependency: nothing else in the schema calls it, which means it is only exercised through direct invocation by forms, concurrent programs, or bespoke code. It should be treated as a localization-specific internal package — stable within the 12.1.1 and 12.2.2 code lines but not a supported public interface — so any client extension should be regression-tested against each localization patch level.