Search Results ozf_common_parameters_pvt




Overview
Explore in AI Chat

Overview

OZF_COMMON_PARAMETERS_PVT is a private PL/SQL package in the APPS schema that centralizes the retrieval and validation of global system parameters used throughout the Oracle Trade Management (OZF) application modules in Oracle E-Business Suite. The package is declared with AUTHID CURRENT_USER, meaning its executable code runs under the privileges of the invoking user rather than the package owner, and callers therefore require direct grants on any underlying objects. Its header, delivered under version ozfvcoms.pls 115.0, exposes a compact set of getter functions plus one validation routine, all oriented toward supplying consistent environmental settings — accounting period definitions, calendar start days, global effective dates, and parallel query configuration — to the broader OZF processing framework.

In the 12.1.1 and 12.2.2 releases, the package is classified by ETRM as an API of type PVT, indicating it is intended for internal consumption by other OZF packages rather than as a published extension point. It is referenced directly by one other package, and its retrieval functions act as a single source of truth so that reporting, scheduling, and period-based calculations across Trade Management remain synchronized.

Key Procedures and Functions

  • GET_PERIOD_SET_NAME — Returns the active accounting period set name configured for OZF processing, allowing downstream code to resolve period naming without hard-coding values.
  • GET_START_DAY_OF_WEEK_ID — Returns the identifier of the configured first day of the week. This is the function matched by the search term get_start_day_of_week_id; it lets weekly and calendar-based Trade Management logic honor the implementation's regional week-start convention.
  • GET_PERIOD_TYPE — Returns the accounting period type (for example, a monthly or weekly calendar type) used by the OZF period engine.
  • GET_GLOBAL_START_DATE — Returns a DATE representing the global start date for OZF data processing, commonly used to bound historical queries and purge routines.
  • CHECK_GLOBAL_PARAMETERS — Accepts a parameter list supplied as a DBMS_SQL.VARCHAR2_TABLE and validates that the required global parameters are populated and internally consistent, returning a BOOLEAN result. This is the package's principal validation entry point.
  • GET_DEGREE_OF_PARALLELISM — Returns a NUMBER indicating the configured degree of parallelism applied to parallel-enabled OZF operations, letting callers align their own DML or query hints with system settings.

Tables Accessed

The documented table references are limited and indirect. DBMS_SQL is the PL/SQL supplied package used as the collection type for the parameter list consumed by CHECK_GLOBAL_PARAMETERS. PLITBLM is the underlying dictionary support object associated with PL/SQL-supplied table types. V$PQ_SYSSTAT is the dynamic performance view used to observe parallel query server statistics, which supports the package's parallelism-related function. No application data tables are documented as directly referenced, consistent with the package's role as a parameter accessor that likely delegates to a profile or setup repository internally.

Usage Notes

Because this is a PVT-classified package, it should be invoked indirectly through standard Trade Management forms, concurrent programs, and higher-level OZF APIs rather than called from custom code. The getter functions are typically consumed at the start of a processing run to seed runtime variables, while CHECK_GLOBAL_PARAMETERS is invoked during setup verification or pre-execution validation. Customizations that do call it must account for the AUTHID CURRENT_USER behavior and ensure the invoking schema holds the necessary privileges. Implementations upgrading between 12.1.1 and 12.2.2 should note that the signature is unchanged, but the package remains unsupported for direct modification.