Results for “as_of_date”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PJI_PMV_DFLT_PARAMS is a public PL/SQL package body in the APPS schema belonging to the Oracle E-Business Suite Project Manufacturing (PJI) module, specifically the Project Management and Verification (PMV) reporting component. Its stated purpose, visible in the embedded header comments, is to supply "Project Default Parameter Values," a responsibility captured under the internal banner "Project Default Parameter Values." The package consolidates the default values for report selection parameters, such as organization dimension level, organization hierarchy, comparison type, revenue-at-risk indicator, duration type, and as-of date, so that every Project Management verification report draws them from a single authoritative location rather than hard-coding them per report. Because the package references PJI_REP_DIM_2 and delegates organization resolution to the companion package PJI_PMV_DFLT_PARAMS_PVT, it functions as a thin default-value layer over the operational logic that derives organization identifiers from the reporting hierarchy. The version indicator in the source header ($Header: PJIRX02B.pls 115.29 2004/06/04) shows the object has been stable since the earlier 11i development cycle and continues to ship unchanged through Oracle EBS 12.1.1 and 12.2.2, where it remains classified as an OTHER API rather than a supported open interface.

Key Procedures and Functions

The ETRM metadata for this object records no formally documented procedures or functions, so the following are taken from the source excerpt itself.

  • PJI_REP_DIM_2 — returns a VARCHAR2 organization dimension identifier. It declares a local variable, calls PJI_PMV_DFLT_PARAMS_PVT.Derive_Organization_ID to resolve the correct organization dimension, and returns the result. This is the function associated with the G_Default_Org_Dimension_Level constant, which initializes to 'PJI_REP_DIM_2', indicating this function supplies the default value for the organization dimension level parameter used across all Project Management reports.
  • AS_OF_DATE — returns a VARCHAR2 date string. It simply returns the package-level constant G_As_Of_Date, which is initialized with to_char(SYSDATE,'DD-MON-YYYY'). This supplies the default as-of date for reports that do not receive an explicit date from the user.

Package-level constants that support these functions include G_Org_Hierarchy_Name ('ORGANIZATION^PJI_ORGANIZATIONS'), G_Default_Compare_To ('TIME_COMPARISON_TYPE+YEARLY'), G_Default_Revenue_At_Risk_Only ('N'), G_Duration_Type ('CUMULATIVE'), and G_SQL_Error_Message. These globals define the out-of-the-box report behavior for the profitability reporting family referenced in the source annotations.

Tables Accessed

The documented metadata lists no tables referenced via APPS synonyms. Based on the source, the package itself performs no direct SQL against base tables; the only data resolution occurs through the call to PJI_PMV_DFLT_PARAMS_PVT.Derive_Organization_ID, which encapsulates whatever organization hierarchy lookups are required. All other operations are in-memory assignments of constants. Consequently, the object carries no direct read or write dependencies on Project Manufacturing reporting tables such as PJI_ORG_DENORM or the PMV report definition tables.

Usage Notes

PJI_PMV_DFLT_PARAMS is invoked indirectly as a default-value source rather than being called directly by users. Oracle EBS concurrent programs and Oracle Reports executables in the Project Manufacturing reporting suite reference these functions to populate parameter defaults when the report is launched without explicit values, ensuring consistent defaults across releases. Custom code and extensions should avoid hard-coding the same literals and instead call the package functions, because the defaults are centralized here by design. The package is not registered as a public open interface API, so modifications to its constants should be treated as unsupported customizations. Notably, the string "fii_time_ent_period_from" does not appear in this package; that token relates to subledger accounting period parameters, and the closest functional analogue here is the AS_OF_DATE function, which governs date defaults for Project Management verification reports.