Search Results client_extn_driver

Overview

The APPS.PA_AR_INST_CLIENT_EXTN package body is a client extension hook within the Oracle E-Business Suite Projects (PA) module, specifically tied to the Accounts Receivable installation mode determination for Project Accounting. Its role is to provide a controlled extension point through which customers may override or influence the AR installation mode flag used by Project Accounting integration processes. The package name itself, containing the "CLIENT_EXTN" token, signals that it is intended as a customer-modifiable extension rather than a purely internal Oracle routine.

The package body carries the header identifier PAVARICB.pls 120.3, dated 2005/08/19, which indicates its lineage predates the 12.1.1 and 12.2.2 releases but remains active in both. The noship designation in the header confirms it is not delivered as a shipped, supported seeding object under normal versioning, reinforcing its status as an extension template.

Key Procedures and Functions

The package body documents a single procedure: CLIENT_EXTN_DRIVER (also referenced by the search term "client_extn_driver").

• CLIENT_EXTN_DRIVER — This is the sole entry point of the package and functions as a driver that determines the effective AR installation mode. It delegates the core lookup to PA_OVERRIDE_AR_INST.GET_INSTALLATION_MODE, retrieving a single-character installation mode into a local variable. It then applies business logic: if the retrieved mode is anything other than 'I' (with a default of 'S' applied via NVL), the output mode is set to 'S' (Standard); otherwise it is preserved as 'I' (Integrated). An exception handler wraps the logic; when any error occurs, the output mode is nulled and the exception is re-raised, consistent with ATG (Application Technology Group) changes noted in the source comments. No parameter list is documented in the ETRM metadata beyond the source, so parameter details are not asserted here.

Tables Accessed

The ETRM metadata does not list any directly referenced tables via APPS synonyms for this package. The procedure obtains its data indirectly through the call to PA_OVERRIDE_AR_INST.GET_INSTALLATION_MODE, which encapsulates whatever configuration or setup table lookups are required to resolve the AR installation mode. Because the package itself performs no direct SQL against base tables, its behavior is fully dependent on the override package it invokes.

Usage Notes

This package is typically invoked during Project Accounting AR integration processing wherever the installation mode flag must be resolved, allowing a client to customize the standard-versus-integrated decision without modifying Oracle-owned code. Organizations implementing a custom AR integration or a non-standard installation posture would modify the body of CLIENT_EXTN_DRIVER to embed their own logic in place of the delivered trivial passthrough.

The ETRM metadata records that this package is referenced by one other package, confirming its role as a subordinate extension module rather than a top-level driver. It is not exposed through a concurrent program or form directly; rather, it is called programmatically by parent PA packages. Because the object is marked as a client extension and carries the noship indicator, it is generally preserved across patches, but customers should re-verify customizations after applying upgrades to 12.1.1 or 12.2.2. The exception block nulling the output mode and re-raising ensures that failures propagate to the caller rather than silently defaulting, so callers must be prepared to handle a NULL installation mode in the event of an error.