Search Results jl_br_ar_occurrence_docs_s




Overview
Explore in AI Chat

Overview

JL_BR_AR_REMIT_COLL_OCCUR is an Oracle EBS Applications (APPS) PL/SQL package body that supports Brazilian localizations for Accounts Receivable collections and bank remittance processing. Its primary business function is to remit collection occurrences — that is, to transmit accounts receivable transactions to a bank for collection (cobrança) — and to manage the accounting and document records associated with those remittance events. The package is integral to the Brazilian borderô (bank collection batch) workflow, which groups receivable transactions, generates collection documents, and interfaces with banking institutions for settlement.

The object resides in the APPS schema with a status of VALID and is classified as an "OTHER" API type. It does not reference or get referenced by other database objects at the package level, though it depends on numerous tables and subprograms at the code level.

Key Procedures and Functions

The package exposes four documented subprograms:

  • REMIT_COLLECTION — Drives the remittance of a collection, coordinating the submission of collection documents and related occurrences to the bank. This is the primary entry point for initiating a collection remittance process.
  • REMIT_OCCURRENCE — Handles the remittance of an individual occurrence (a single receivable item within a collection), likely used when occurrences are processed one at a time rather than as a full batch.
  • GET_ACCT_LINE_TYPE_NAME — A utility function that returns the descriptive name of an accounting line type, used in generating accounting entries and reports.
  • GET_TRX_CLASS_NAME — A utility function that returns the transaction class name for a given receivable transaction, supporting classification and reporting logic.

Parameter lists are not documented in the ETRM metadata and are intentionally omitted.

Tables Accessed

The package reads and writes a substantial set of tables, organized into functional groups:

Usage Notes

This package is typically invoked during the Brazilian AR collection remittance cycle, often from concurrent programs or forms that manage borderô generation and bank file transmission. It may also be called from custom code extending the standard localization. The presence of JL_BR_AR_OCCURRENCE_DOCS_S in the referenced table list — matching the user's search term — indicates the package queries this sequence or table when creating occurrence document records. Because the package is not referenced by other database objects, it should be treated as a top-level driver invoked by application logic rather than as a shared utility.