Search Results upd_reversal_gl_date

Overview

ARP_MISC_CD is a PL/SQL package body owned by APPS that supports the Oracle Receivables subsystem responsible for miscellaneous cash distributions. Miscellaneous cash receipts represent funds received that are not tied to a specific customer invoice or standard receipt application, such as interest income, bank charges, or sundry deposits. The package encapsulates the database-level logic required to record and maintain the distribution lines that allocate such receipts across accounting flexfield combinations. It centralises the generation of primary keys, the insertion of distribution rows into the base table, and the maintenance of reversal-related general ledger dates, thereby insulating calling modules from direct Data Manipulation Language against the underlying schema objects. It is classified as OTHER in the ETRM metadata, indicating that it is an internal implementation package rather than a formally published public API, and it exposes two documented program units.

Key Procedures and Functions

• INS_MISC_CASH_DISTRIBUTIONS — Inserts a new row into the AR_MISC_CASH_DISTRIBUTIONS table. The function accepts the full audit and business attribute set for a distribution, including audit columns (who and when columns), the cash receipt identifier, the accounting code combination, the set of books, general ledger and apply dates, percentage and amount values, comments, posting control and concurrent program identifiers, accounted amount, USSGL transaction code and context, the created-from indicator, and a reversal GL date. A defaulted parameter for the cash receipt history identifier was added under Bug#5201086. The function internally obtains a unique identifier before performing the insert and returns that identifier as a NUMBER, allowing callers to reference the newly created distribution.
• UPD_REVERSAL_GL_DATE — Updates the reversal general ledger date associated with a miscellaneous cash distribution, supporting correction or adjustment of the GL date used when a distribution is subsequently reversed.

The private cursor get_id, referenced within the insert function, selects the next value from the AR_MISC_CASH_DISTRIBUTIONS_S sequence over DUAL to derive the primary key. This is the object most closely associated with the search term "get_id".

Tables Accessed

• AR_MISC_CASH_DISTRIBUTIONS — the primary base table into which the insert function writes distribution records and against which the reversal GL date update is applied.
• AR_MISC_CASH_DISTRIBUTIONS_S — the sequence used by the get_id cursor to supply unique primary key values.
• AR_SYSTEM_PARAMETERS — system-level Receivables setup information referenced for defaulting and validation behaviour.
• DUAL — the single-row pseudo-table used to retrieve the sequence next value.

Usage Notes

Because ARP_MISC_CD is an internal implementation package, it is not intended for direct invocation by external integrations. It is typically called by the Receivables miscellaneous cash receipt forms, by concurrent programs that process or reverse miscellaneous receipts, and by other APPS packages that require distribution records to be created consistently. The metadata records that this package is referenced by one other package, confirming its role as a subordinate utility rather than a top-level entry point. Custom code should avoid calling the internal functions directly; developers requiring this behaviour ought to use the supported Receivables APIs that in turn drive this package, thereby preserving audit column integrity, sequence-generated identifiers, and correct general ledger date handling.