Search Results rp_condition_p




Overview
Explore in AI Chat

Overview

ONT_OEXDERUL_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It supports the Defaulting Rules Listing Report (internal name OEXDERUL), a concurrent program that presents the seeded and user-defined defaulting rules configured for Oracle Order Management. The "XMLP" suffix indicates that the package belongs to the XML Publisher (BI Publisher) generation of the report, in which report data is emitted as XML and formatted through an RTF or XSL-FO template rather than through the older Oracle Reports SRW engine.

The package performs two principal roles: it resolves runtime context for the concurrent request, and it supplies the report with display-ready descriptions for the defaulting-rule selection parameters. Because users select defaulting rules by internal identifiers or codes, the report must translate those selections into the descriptive text that appears in the report header and layout. The package also defines the report title and sub-title, and it derives a completion flag indicating whether the underlying query returned any rows.

Key Procedures and Functions

  • BEFOREREPORT — The Before Report trigger. Captures the concurrent request identifier from FND_GLOBAL, then resolves the concurrent program name from FND_CONCURRENT_PROGRAMS_VL and FND_CONCURRENT_REQUESTS, trims the "(XML)" suffix, and assigns the result to RP_REPORT_NAME. Defaults the title to 'Defaulting Rules Listing Report' when no row is found. It further resolves the object, attribute, condition, and seeded parameters into display values, substituting 'All Objects', 'All Attributes', 'All Conditions', and 'All Values' when the corresponding parameter is null.
  • AFTERREPORT — The After Report trigger, used for end-of-report processing.
  • AFTERPFORM — The After Parameter Form trigger, used to finalize values after the parameter form is submitted.
  • SOURCEVALUEFORMULA — Supplies a formula for a source value used by the report layout.
  • RP_REPORT_NAME_P — Returns the resolved report name for the layout.
  • RP_SUB_TITLE_P — Returns the report sub-title.
  • RP_DATA_FOUND_P — Returns a flag indicating whether report data was retrieved.
  • RP_CONDITION_P — Returns the resolved display name of the selected defaulting condition.
  • RP_OBJECT_P — Returns the resolved display name of the selected database object.
  • RP_ATTRIBUTE_P — Returns the resolved display name of the selected attribute.
  • RP_SEEDED_P — Returns the seeded/values indicator supplied through the parameter.

Tables Accessed

The documented table reference is FND_CONCURRENT_REQUESTS, read in BEFOREREPORT to link the active request to its program definition so that the report title can be derived. The body additionally queries the defaulting-rule dictionary views OE_DEF_AK_OBJ_EXT_V, OE_DEF_AK_ATTR_EXT_V, OE_DEF_CONDITIONS_VL, and FND_CONCURRENT_PROGRAMS_VL through APPS synonyms. These lookups are read-only and provide descriptive labels; no data is inserted, updated, or deleted.

Usage Notes

The package is invoked indirectly by the concurrent manager whenever the Defaulting Rules Listing Report is run. The user interface is the standard concurrent program parameter form, where the user selects object, attribute, condition, and seeded-value criteria; the values chosen there become the P_OBJECT, P_ATTRIBUTE, P_CONDITION, and P_SEEDED parameters consumed by BEFOREREPORT. The named RP_* functions are called by the XML Publisher template and by internal report triggers, and are not intended for direct invocation from custom code. ETRM lists no dependent packages, so the object is a leaf in the dependency graph and can be treated as self-contained. The header comment indicates the source file is OEXDERULB.pls with version 120.1 dated December 2007, which corresponds to the 12.1.1 code line and is carried forward unchanged into 12.2.2.