Search Results cf_from_dateformula

Overview

APPS.PA_PAXCCGLA_XMLP_PKG is the generated PL/SQL package associated with an Oracle Projects XML Publisher (BI Publisher) concurrent program in Oracle E-Business Suite 12.1.1 and 12.2.2. The package name follows the standard EBS report package convention: the PA prefix identifies Oracle Projects, PAXCCGLA identifies the specific report definition, and the XMLP_PKG suffix indicates that the package was generated by the XML Publisher report builder to expose report parameter values and formula logic to the underlying data model and template. The report covers Project Accounting general ledger account activity across a range of periods and accounts, using the GL interface dates and chart of accounts identifier as selection criteria. The package is defined with AUTHID CURRENT_USER and executes in the APPS schema, giving report logic the privileges of the invoking user.

Key Procedures and Functions

The package exposes a set of documented procedures and functions that support report execution and the retrieval of parameter and computed values.

• GET_COVER_PAGE_VALUES — populates the cover page values used when the report output is rendered, drawing on the report parameters and header data.
• BEFOREREPORT — standard report trigger executed before the main query runs; initializes report-level state and derived values.
• AFTERREPORT — standard report trigger executed after the main query completes; performs cleanup and final assignments.
• GET_COMPANY_NAME — resolves the company name header used on the printed report output.
• CF_ACCT_CURRENCY_CODEFORMULA — returns the account currency code for the reported account.
• CF_FROM_DATEFORMULA and CF_TO_DATEFORMULA — return the from and to dates used in the report header, derived from the interface date parameters.
• ACCOUNT_IDFORMULA — accepts a code combination identifier and returns the corresponding account string.
• AFTERPFORM — trigger executed after the parameter form is processed; used to set parameter-dependent values before the query fires.
• C_COMPANY_NAME_HEADER_P, C_NO_DATA_FOUND_P, C_DUMMY_DATA_P, CP_WHERE_P, CP_GL_START_P, CP_GL_END_P, and CP_USR_JE_SNAME_P — accessor functions returning the current values of the corresponding package globals: the company name header, the no-data-found message, the dummy data indicator, the dynamically constructed WHERE clause, the GL start and end dates, and the user journal entry source name. The user search term cp_gl_end_p resolves to the accessor for the CP_GL_END global, which returns the GL end date used to bound the report's accounting period range.

Tables Accessed

The package's data model reads two GL tables through APPS synonyms:

• GL_JE_SOURCES — the journal entry source definitions, consulted to resolve the user journal entry source name (CP_USR_JE_SNAME) used to restrict the reported GL activity.
• GL_PERIODS — the accounting period calendar, used to derive the GL start and end dates (CP_GL_START and CP_GL_END) that bound the period range reported.

Usage Notes

This package is invoked indirectly whenever the associated Project Accounting GL account report is submitted as a concurrent program or executed through the standard report submission framework. It is not called directly by forms or custom code; rather, the Oracle Reports runtime and XML Publisher engine call BEFOREREPORT, AFTERPFORM, the CF_* formula functions, and the accessor functions as the report executes. The package is referenced by zero other packages according to the ETRM metadata, confirming that it is a leaf-level report artifact. Customizations should avoid modifying this generated package, since regeneration by the XML Publisher report builder will overwrite changes; report logic extensions are more appropriately placed in the report definition or its data model.