Search Results c_org_name_p

Overview

PA_PAXRWSBR_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is an Oracle Reports XML Publisher (XMLP) integration package, generated to support a concurrent report within the Projects (PA) module. The package is classified as OTHER in the ETRM metadata, meaning it is not a formal public API but rather a report support library that supplies runtime data and formatting logic to an underlying report definition.

The "RWSBR" naming element indicates that the report concerns bill rate schedules or a related billing-rate report. The package declares global variables such as ORGANIZATION_ID, STD_BILL_RATE_SCHEDULE, EFFECTIVE_DATE, P_CONC_REQUEST_ID, and P_rule_optimizer, which are populated from concurrent program parameters before the report executes. Additional variables store display values such as C_COMPANY_NAME_HEADER, C_org_name, and EFFECTIVE_DATE1. The package executes with AUTHID CURRENT_USER, so any SQL it issues is resolved against the privileges of the calling user.

Key Procedures and Functions

• BEFOREREPORT — The standard report entry point invoked by the Reports engine before data retrieval. It orchestrates setup, likely calling the other helper functions to populate globals and header values.
• GET_COVER_PAGE_VALUES — Returns a Boolean and populates the cover-page elements of the report, drawing on the organization, company, and effective-date globals.
• GET_COMPANY_NAME — Returns a Boolean and retrieves the company name used in the report header, storing it in C_COMPANY_NAME_HEADER.
• CF_ACCT_CURRENCY_CODEFORMULA — A formula column returning varchar2 that supplies the accounting currency code value. This is the object the user searched for under "cf_acct_currency_codeformula," and it resolves the currency code displayed per row in the report output.
• AFTERREPORT — The standard post-report hook returning Boolean, used to release resources or finalize formatting.
• C_COMPANY_NAME_HEADER_P — Returns varchar2; a getter that exposes the stored company name header value to the report layout.
• C_ORG_NAME_P — Returns varchar2; a getter that exposes the stored organization name to the report layout.

Tables Accessed

The metadata documents a single referenced table via APPS synonym: PA_IMPLEMENTATIONS. This table stores organization-level implementation options for the Projects module. The package reads it to retrieve the organization name (C_org_name) and related configuration context that appears on the report cover page and header. No write operations are documented.

Usage Notes

This package is invoked indirectly by the Reports engine when the associated bill-rate schedule concurrent program is run from the standard Projects request submission interface. It is not referenced by any other packages (0 dependents), confirming it is a terminal report-support artifact rather than a shared library. Customizations should not call these functions directly; instead, changes are typically made by modifying the report definition or the underlying PL/SQL. Because the package uses AUTHID CURRENT_USER, access relies on the invoking user's Projects and general ledger privileges. Administrators troubleshooting currency-code display issues on the report should review CF_ACCT_CURRENCY_CODEFORMULA alongside the effective-date and standard-bill-rate globals.