Search Results ar_bills_maintain_lib_pvt
Overview
APPS.AR_BILLS_MAINTAIN_LIB_PVT is a private PL/SQL library package in Oracle Receivables that supports the maintenance and lifecycle management of billing transactions, adjustments, receipts, and receipt applications. The package is classified as PVT (private) within the ETRM repository, indicating that it is an internal implementation library rather than a published public API. Its procedures are invoked by other Receivables packages, forms, and concurrent processes to perform the underlying database operations that drive transaction generation, adjustment creation and reversal, receipt application and unapplication, and document sequence assignment.
The header comment ($Header: ARBRMALS.pls 120.4 2005/10/30) reflects the file's origin in the AutoInvoice / Bills Receivable maintenance area, and the package remains present and documented in both Oracle EBS 12.1.1 and 12.2.2. Because it is private, it should not be called directly from customer extensions; Oracle does not guarantee backward compatibility for private packages.
Key Procedures and Functions
The package exposes 23 documented procedures. The procedure most relevant to the search term get_doc_seq is GET_DOC_SEQ, which assigns the document sequence value to a transaction record based on the application, ledger (set of books), and transaction method code supplied by the caller.
- GET_DOC_SEQ — Retrieves and assigns the next document sequence number for a customer transaction, honoring the transaction method and set of books.
- GET_REMITTANCE_BATCH — Returns the batch record associated with a given customer transaction identifier.
- UPDATE_RESERVED_COLUMNS — Maintains reserved (internal-use) columns on the payment schedule for a specified schedule and reservation type/value.
- DEFAULT_ACTION_DATES — Defaults the transaction date and GL date values used during transaction maintenance.
- COMPLETE_ACC_REQUIRED — Completes the accounting-required step associated with a customer transaction.
- COMPLETE_OR_ACCEPT — Completes or accepts a transaction history record during the transaction workflow.
- CREATE_ADJUSTMENT — Creates an adjustment against a transaction and payment schedule, returning the new adjustment identifier.
- FIND_LAST_ADJUSTMENT — Locates the most recent adjustment for a given customer transaction.
- APPROVE_ADJUSTMENT, MODIFY_ADJUSTMENT, REVERSE_ADJUSTMENT — Manage the approval, modification, and reversal stages of an adjustment's lifecycle.
- REVERSE_ASSIGNMENTS_ADJUSTMENT — Reverses adjustments linked to assignment transactions.
- FIND_LAST_RECEIPT, FIND_LAST_STD — Locate the most recent receipt or standard (cash) transaction record.
- REVERSE_RECEIPT, APPLY_RECEIPT, UNAPPLY_RECEIPT — Reverse receipts and manage receipt application and unapplication logic.
- APPLY_STD, UNAPPLY_STD — Apply and unapply standard (cash) transactions.
- FACTORE_RECOURSE — Handles recourse factoring logic for factored transactions.
Tables Accessed
The package reads and writes the core Receivables transaction and receipt tables through APPS synonyms, including:
- RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_TYPES — Transaction headers, lines, and transaction type definitions used in document sequencing and adjustment creation.
- AR_ADJUSTMENTS — Creation, approval, modification, and reversal of adjustments.
- AR_PAYMENT_SCHEDULES — Payment schedule updates tied to adjustments and reserved column maintenance.
- AR_TRANSACTION_HISTORY — Transaction workflow and action date tracking.
- AR_CASH_RECEIPTS, AR_RECEIVABLE_APPLICATIONS — Receipt handling, application, and unapplication processing.
- AR_BATCHES, RA_BATCH_SOURCES — Remittance batch retrieval and batch source validation.
- AR_RECEIVABLES_TRX, AR_RECEIPT_METHODS, AR_RECEIPT_METHOD_ACCOUNTS — Adjustment activity types and receipt method configuration.
- DUAL — Used for single-row selection and default computations.
Usage Notes
Because AR_BILLS_MAINTAIN_LIB_PVT is a private package, it is not intended to be called directly from customer-developed code. It is invoked internally by Oracle Receivables forms and by other Receivables packages — the ETRM metadata records that it is referenced by one other package. Typical invocation contexts include the Transactions and Receipts forms, adjustment approval workflows, and concurrent programs that process receipts and adjustments. When a user searches for get_doc_seq, the relevant entry point is the GET_DOC_SEQ procedure, which populates the transaction document sequence during transaction creation and completion. Developers should reference public Receivables APIs (such as AR_RECEIPT_API_PUB or AR_ADJUSTMENT_API_PUB) rather than this private library, and should treat its behavior as subject to change across patch levels.
-
PACKAGE: APPS.AR_BILLS_MAINTAIN_LIB_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_BILLS_MAINTAIN_LIB_PVT, status:VALID,
-
PACKAGE: APPS.AR_BILLS_MAINTAIN_LIB_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_BILLS_MAINTAIN_LIB_PVT, status:VALID,
-
PACKAGE BODY: APPS.AR_BILLS_MAINTAIN_LIB_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_BILLS_MAINTAIN_LIB_PVT, status:VALID,
-
PACKAGE BODY: APPS.AR_BILLS_MAINTAIN_LIB_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_BILLS_MAINTAIN_LIB_PVT, status:VALID,
-
SYNONYM: APPS.AR_TRANSACTION_HISTORY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_TRANSACTION_HISTORY, status:VALID,
-
SYNONYM: APPS.AR_TRANSACTION_HISTORY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_TRANSACTION_HISTORY, status:VALID,
-
SYNONYM: APPS.AR_RECEIVABLES_TRX
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIVABLES_TRX, status:VALID,
-
SYNONYM: APPS.AR_RECEIVABLES_TRX
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIVABLES_TRX, status:VALID,
-
PACKAGE: APPS.AR_BILLS_CREATION_VAL_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_BILLS_CREATION_VAL_PVT, status:VALID,
-
PACKAGE: APPS.AR_BILLS_CREATION_LIB_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_BILLS_CREATION_LIB_PVT, status:VALID,
-
SYNONYM: APPS.AR_BATCHES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_BATCHES, status:VALID,
-
PACKAGE: APPS.ARP_TRANSACTION_HISTORY_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_TRANSACTION_HISTORY_PKG, status:VALID,
-
SYNONYM: APPS.AR_BATCHES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_BATCHES, status:VALID,
-
PACKAGE: APPS.AR_BILLS_CREATION_VAL_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_BILLS_CREATION_VAL_PVT, status:VALID,
-
PACKAGE: APPS.AR_BILLS_MAINTAIN_STATUS_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_BILLS_MAINTAIN_STATUS_PUB, status:VALID,
-
PACKAGE: APPS.ARP_BR_REMIT_BATCHES
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_BR_REMIT_BATCHES, status:VALID,
-
PACKAGE: APPS.ARP_BR_REMIT_BATCHES
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_BR_REMIT_BATCHES, status:VALID,
-
PACKAGE: APPS.ARP_APP_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_APP_PKG, status:VALID,
-
PACKAGE: APPS.AR_ADJUST_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_ADJUST_PUB, status:VALID,
-
PACKAGE: APPS.ARP_CR_BATCHES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_CR_BATCHES_PKG, status:VALID,
-
PACKAGE: APPS.ARP_CR_BATCHES_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_CR_BATCHES_PKG, status:VALID,
-
PACKAGE: APPS.AR_ADJUST_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_ADJUST_PUB, status:VALID,
-
PACKAGE: APPS.ARP_APP_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_APP_PKG, status:VALID,
-
PACKAGE: APPS.ARP_CTL_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_CTL_PKG, status:VALID,
-
PACKAGE: APPS.AR_BILLS_CREATION_LIB_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_BILLS_CREATION_LIB_PVT, status:VALID,
-
PACKAGE: APPS.AR_BILLS_MAINTAIN_STATUS_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_BILLS_MAINTAIN_STATUS_PUB, status:VALID,
-
PACKAGE: APPS.ARP_TRANSACTION_HISTORY_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_TRANSACTION_HISTORY_PKG, status:VALID,
-
PACKAGE: APPS.ARP_PROC_TRANSACTION_HISTORY
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_PROC_TRANSACTION_HISTORY, status:VALID,
-
PACKAGE: APPS.ARP_PROC_TRANSACTION_HISTORY
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_PROC_TRANSACTION_HISTORY, status:VALID,
-
PACKAGE: APPS.AR_MO_CACHE_UTILS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_MO_CACHE_UTILS, status:VALID,
-
PACKAGE: APPS.ARP_DET_DIST_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_DET_DIST_PKG, status:VALID,
-
PACKAGE: APPS.ARP_CTL_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_CTL_PKG, status:VALID,
-
PACKAGE: APPS.ARP_CASH_RECEIPTS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_CASH_RECEIPTS_PKG, status:VALID,
-
PACKAGE: APPS.AR_BILLS_MAINTAIN_LIB_PVT
12.2.2
-
PACKAGE: APPS.AR_MO_CACHE_UTILS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_MO_CACHE_UTILS, status:VALID,
-
PACKAGE BODY: APPS.AR_BILLS_MAINTAIN_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AR_BILLS_MAINTAIN_PUB, status:VALID,
-
PACKAGE: APPS.ARP_CT_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_CT_PKG, status:VALID,
-
PACKAGE: APPS.ARP_CASH_RECEIPTS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_CASH_RECEIPTS_PKG, status:VALID,
-
PACKAGE: APPS.ARP_CT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_CT_PKG, status:VALID,
-
PACKAGE: APPS.ARP_PS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_PS_PKG, status:VALID,
-
PACKAGE: APPS.AR_BILLS_MAINTAIN_LIB_PVT
12.1.1
-
PACKAGE BODY: APPS.AR_BILLS_MAINTAIN_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AR_BILLS_MAINTAIN_PUB, status:VALID,
-
SYNONYM: APPS.AR_ADJUSTMENTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_ADJUSTMENTS, status:VALID,
-
SYNONYM: APPS.AR_ADJUSTMENTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_ADJUSTMENTS, status:VALID,
-
SYNONYM: APPS.AR_RECEIPT_METHOD_ACCOUNTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIPT_METHOD_ACCOUNTS, status:VALID,
-
PACKAGE: APPS.ARP_PS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_PS_PKG, status:VALID,
-
SYNONYM: APPS.AR_RECEIPT_METHOD_ACCOUNTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIPT_METHOD_ACCOUNTS, status:VALID,
-
PACKAGE: APPS.FND_SEQNUM
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_SEQNUM, status:VALID,
-
PACKAGE: APPS.FND_SEQNUM
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_SEQNUM, status:VALID,
-
SYNONYM: APPS.AR_CASH_RECEIPTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CASH_RECEIPTS, status:VALID,