Search Results arpt_sql_func_util




Overview
Explore in AI Chat

Overview

ARPT_SQL_FUNC_UTIL is a utility package body in the APPS schema of Oracle E-Business Suite Release 12.1.1 and 12.2.2. The name reflects its heritage: the "PT" component ties it to Oracle Receivables' period-to-date (PTD) reporting and collections infrastructure, while the "SQL_FUNC_UTIL" suffix indicates its role as a shared library of small, single-purpose query functions. Rather than implementing a business transaction API, the package encapsulates repetitive SQL lookups that would otherwise be duplicated across Receivables forms, reports, and concurrent programs.

The package is classified as a UTIL object in ETRM and carries a VALID status in the APPS schema. It exposes 47 documented procedures and functions, the vast majority of which are parameterized SELECT statements returning a single value: a flag, a date, an amount, or a reference string. This design makes it a low-level building block, referenced by 147 other packages, which confirms its role as foundational shared code across the Receivables module and its extensions.

Key Procedures and Functions

The documented entry points fall into several functional clusters:

All functions are read-oriented utilities; none represent a transactional API with a standard IN/OUT parameter convention documented in ETRM beyond the return value.

Tables Accessed

The package references a broad slice of the Receivables and Trading Community data model through APPS synonyms. Core transaction tables include RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_TYPES, RA_CUST_TRX_LINE_GL_DIST, and AR_PAYMENT_SCHEDULES. Receipt and adjustment processing relies on AR_CASH_RECEIPT_HISTORY, AR_INTERIM_CASH_RECEIPTS, AR_INTERIM_CASH_RECEIPT_LINES, AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, AR_RECEIVABLE_APPLICATIONS, AR_ADJUSTMENTS, and AR_ADJUSTMENTS_ALL. Dispute and correspondence logic touches AR_DISPUTE_HISTORY, AR_CORRESPONDENCES, and AR_CORRESPONDENCE_PAY_SCHED.

Customer and party data is drawn from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_PARTY_SITES, HZ_LOCATIONS, HZ_CONTACT_POINTS, HZ_CUSTOMER_PROFILES, and HZ_CUST_ACCT_RELATE. Financial context comes from GL_PERIOD_STATUSES, GL_SETS_OF_BOOKS, and GL_IMPORT_REFERENCES, while terms and agreements use RA_TERMS, RA_TERMS_LINES, SO_AGREEMENTS, and OZF_CLAIM_INSTALL. Lookups and setup are read from AR_LOOKUPS, FND_LOOKUPS, and FND_TERRITORIES_VL.

Usage Notes

ARPT_SQL_FUNC_UTIL is invoked indirectly rather than through user-facing entry points. Oracle Receivables forms, collections workbench components, dunning and correspondence concurrent programs, and the 147 dependent packages call its functions to resolve dispute amounts, payment flags, due dates, and territory attributes without reimplementing the underlying SQL. Custom extensions and RICE objects that need consistent Receivables lookup semantics should call these functions rather than duplicating queries against AR_PAYMENT_SCHEDULES or HZ tables directly. Because the package depends on ARP_GLOBAL, ARP_STANDARD, AR_BFB_UTILS_PVT, FND_API, and DBMS_UTILITY, callers must ensure those dependencies are valid. It is not referenced by any database object, confirming it is a leaf utility relied upon by higher-level code only.