Search Results cf_ret_unassignedformula

Overview

PA_PAXCPGAL_XMLP_PKG is an Oracle EBS Projects (PA) package that supports the concurrent program "Project Capital Events Report" and its XML Publisher output. The package acts as the PL/SQL library for the report, encapsulating the data retrieval and formatting logic that converts project capital event data into a structured XML report. The report targets user-supplied selection criteria, including a from/to project number range, an "as of" PA through date, and a separate DPIS (Date Placed In Service) through date. It also exposes an option to include common tasks and can be scoped to a specific capital event identifier, event number, or event name.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user, which aligns with the report's dependency on APPS synonyms and its role inside the standard concurrent manager execution model. A governance header comment pins the source version to 120.1 (2008), reflecting the long-standing, mostly static nature of this report library across 11i and R12 releases.

Key Procedures and Functions

• GET_COVER_PAGE_VALUES – Populates header and cover-page values that appear at the top of the report, such as company name and reporting parameters, preparing the context before the formatted output is generated.
• BEFOREREPORT – Standard XML Publisher before-report trigger. It performs one-time initialization, parsing the concurrent request parameters and setting up package state prior to the query phase.
• GET_COMPANY_NAME – Resolves the company/organization name to be printed in the header, populating C_COMPANY_NAME_HEADER.
• UNASSIGNEDFORMULA – Formats the display of capital events that have no asset assignment, given an asset name input.
• CF_RET_UNASSIGNEDFORMULA – Companion formatting function returning the "unassigned" indicator for a given asset name.
• CF_FORMAT_MASKFORMULA – Supplies the XML Publisher format mask used for numeric or date columns in the report template.
• CURR_CODEFORMULA – Resolves and returns the currency code applied to monetary amounts on the report, based on the project set of books / reporting configuration.
• AFTERREPORT – Standard after-report trigger for cleanup and final return-code handling.
• C_COMPANY_NAME_HEADER_P, C_NO_DATA_FOUND_P, C_DUMMY_DATA_P, C_RETCODE_P, CURR_CODE_P – Accessor (getter) functions that expose the package globals C_COMPANY_NAME_HEADER, C_NO_DATA_FOUND, C_DUMMY_DATA, C_RETCODE, and CURR_CODE respectively. These support XML Publisher's ability to read package variables from the data model, and C_NO_DATA_FOUND / C_RETCODE provide the "no rows returned" message and execution status.

Tables Accessed

• PA_CAPITAL_EVENTS – The primary source of capital event records reported, filtered by event id, name, or number.
• PA_IMPLEMENTATIONS – Supplies implementation-level setup, including currency and organizational defaults used by CURR_CODEFORMULA and the company header.
• PA_PERIODS – Drives period-based filtering and DPIS/PA through-date logic.
• PA_REPORTING_EXCEPTIONS – Provides reporting exception information surfaced in the report output.
• DUAL – Used for single-row lookups and constant derivation.

All access occurs through APPS synonyms within the APPS schema.

Usage Notes

This package is not a general-purpose API. It is invoked exclusively by the concurrent program that generates the Project Capital Events XML report, executed by the Concurrent Manager under the APPS schema. It is not referenced by any other package (referenced by 0 objects in the ETRM catalog), so custom code should not call it directly. The CURR_CODEFORMULA function is significant to users who search for "curr_codeformula": it is the formatting placeholder that XML Publisher evaluates to print the currency code on each monetary line of the capital events report. Any modification should be treated as a report-template customization rather than an API-level change.