Search Results prog_appl_id

Overview

AR_GDF_VALIDATION is a public PL/SQL package owned by APPS in the Oracle E-Business Suite Receivables module. Its business purpose is to perform global descriptive flexfield (GDF) validation during AutoInvoice processing and related receipt post-batch operations. The package is deliberately implemented as a stub: the shipped header declares the public interfaces, but the substantive validation logic is installed only when the Oracle Localizations (JL) product is licensed and present. This design allows the core Receivables code to call a stable, predictable API regardless of whether global descriptive flexfield validation is required for a given installation.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling user rather than the package owner. This is a consideration for any custom code that invokes it, since synonym resolution and privilege checks follow the invoker's schema. The header comment identifies the file as ARXGDVHS.pls and dates the shipped version to November 2008 for the 12.1.1 code line; the same package remains in place in 12.2.2.

Key Procedures and Functions

• IS_GDF_VALID — Validates global descriptive flexfield data for an AutoInvoice run. It accepts the request identifier of the AutoInvoice concurrent request and returns 1 when validation succeeds or 0 when an error occurs.
• IS_GDF_POSTBATCH_VALID — Performs the equivalent global descriptive flexfield validation for post-batch processing, scoped by batch and cash receipt identifiers, returning the same 1/0 success indicator.
• IS_GDF_TAXID_VALID — Validates global descriptive flexfield tax identifier data; the shipped body is again a stub whose real implementation is supplied by the localization layer.
• IS_CUST_IMP_VALID — Supports customer import validation in the same global descriptive flexfield context.
• COPY_GDF_ATTRIBUTES — Copies global descriptive flexfield attribute values, typically when records are duplicated or staged between processing steps.
• INSERT_GLOBAL_TABLE — Inserts data into the global descriptive flexfield storage structure maintained for localization purposes.
• IS_JG_INSTALLED — Determines whether the JG (localization) product is installed; this check governs whether the stub behavior or the full validation logic applies.

Tables Accessed

Documented table references resolve through APPS synonyms and include AR_SYSTEM_PARAMETERS, used to read Receivables system option settings that affect processing behavior. ALL_SOURCE appears because the package inspects the data dictionary to determine which implementation of the validation logic is present, and DBMS_SQL is used for dynamic SQL execution associated with that determination. The package is referenced by three other packages in the ETRM inventory, indicating it participates in a small call graph rather than being an isolated utility.

Usage Notes

AR_GDF_VALIDATION is not intended to be called directly by end users. It is invoked programmatically by AutoInvoice, post-batch receipt processing, and customer import routines within Receivables, and by the other packages that reference it. Developers searching on PROG_APPL_ID typically encounter this package while tracing AutoInvoice execution: the request identifier passed to IS_GDF_VALID ties the validation call back to the concurrent request record, which in turn links to the program application identifier in the concurrent program definitions. Custom code should treat these functions as read-only validators returning 1 or 0, check IS_JG_INSTALLED before assuming validation logic exists, and avoid modifying the package body, since the shipped version is a stub that Oracle replaces or overlays when localization products are applied.