Results for “jl_br_ap_associate_coll_doc”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.JL_BR_AP_ASSOCIATE_COLLECTION package is a Brazilian localization (JL_BR) component within Oracle E-Business Suite Payables. Its business purpose is to establish and manage the association between bank collection documents and the corresponding Payables transactions — specifically invoices, payment schedules, and trade notes (duplicatas). In the Brazilian receivables and collections model, banks issue collection documents (boletos and collection notices) against which customer or supplier transactions must be reconciled. This package provides the programmatic mechanism for creating that linkage, allowing Oracle Payables to reflect which invoices or trade notes are covered by a given bank collection document, and conversely which collection document corresponds to a given transaction. In EBS 12.1.1 and 12.2.2 the package retains the same interface, with the header version lineage indicating an older, stable code line (120.1) that continues to be shipped unchanged.
Key Procedures and Functions
The package exposes two documented procedures. No additional overloads or private helpers are part of the published interface.
- JL_BR_AP_ASSOCIATE_COLL_DOC — Associates a bank collection document with a Payables transaction. The procedure accepts a bank collection identifier and an association method as inputs, and returns or updates the associated invoice identifier, payment number, and an association status flag. It is the entry point used when the driver is the collection document itself.
- JL_BR_AP_ASSOCIATE_TRADE_NOTE — Performs the reverse-direction association, starting from an invoice and payment number and resolving or recording the bank collection document. It accepts the invoice identifier, payment number, and association method as inputs and returns the bank collection identifier and association flag.
Together these procedures support bidirectional linking, so callers can drive the association from either the collection document or the transaction side depending on the business event being processed.
Tables Accessed
The package reads and writes several core Payables and Brazilian localization tables through APPS synonyms:
- JL_BR_AP_COLLECTION_DOCS and JL_BR_AP_COLLECTION_DOCS_ALL — the primary localization tables holding bank collection document records; these are the principal targets of insert and update activity.
- AP_INVOICES and AP_INVOICES_ALL — provide invoice header and line-level context for validation and association.
- AP_PAYMENT_SCHEDULES and AP_PAYMENT_SCHEDULES_ALL — supply the scheduled payment rows that tie an invoice to a payment number, essential for correct matching.
- AP_SYSTEM_PARAMETERS — supplies organizational and functional configuration defaults.
- FND_LOG_MESSAGES — used for diagnostic logging of the association process.
Usage Notes
This is classified as an OTHER API rather than a fully public, supported interface. It is referenced by one other package in the ETRM metadata, indicating it is called internally by related Brazilian localization logic rather than by customer code directly. Typical invocation occurs from the Oracle Payables forms that manage bank collections and trade notes, and potentially from concurrent programs or localization batch processes that perform bulk association. Because the parameters use IN OUT NOCOPY semantics for the identifier and flag arguments, callers must supply initialized variables and inspect the returned flag to confirm successful association. Custom code should treat the package as internal, invoke it only within an APPS-initialized session, and expect that its signature remains fixed for this release. The user's original query about editing collection case priority in BYD is unrelated to this EBS object; priority editing in a different product is not governed by this package.