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:

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.