Search Results cparty_name1formula

Overview

The APPS.XTR_XTRMTCPY_XMLP_PKG package is a generated PL/SQL package associated with an Oracle E-Business Suite concurrent program that produces an XML Publisher (BI Publisher) report. The _XMLP_PKG naming convention identifies it as a report-support package auto-created when a concurrent program is defined against an XML Publisher template. In the ETRM (Enterprise Territory and Transaction Management) product family, the object name suggests the report concerns a copy or transfer operation tied to transaction management, likely a data-movement or counterparty extract. The package is owned by the APPS schema, is registered with API classification OTHER, and its status is VALID in the 12.2.2 data dictionary. Its primary business function is to supply the runtime logic and report-parameter handling required by the associated XML report, bridging the concurrent manager request with the data returned to the report template.

Key Procedures and Functions

The package exposes eleven documented procedures and functions, which fall into three functional groupings.

• Report lifecycle: BEFOREREPORT, AFTERREPORT, and AFTERPFORM are the standard XML Publisher report plug points. BEFOREREPORT executes before the report data model is built, AFTERREPORT runs once the report completes, and AFTERPFORM runs after the parameter form is submitted.
• Parameter derivation: COMPANY_NAME_P, CPARTY_NAME_P, and CP_PARA_P derive the values used for the company name, counterparty name, and related report parameters.
• Formula functions: COMPANY_NAMEFORMULA, COMPANY_NAME1FORMULA, CPARTY_NAMEFORMULA, CPARTY_NAME1FORMULA, and CF_SET_PARAFORMULA provide the formulas invoked by the report template to resolve company, counterparty, and setup-parameter values at display time.

Tables Accessed

The package references three tables through APPS synonyms:

• FND_CONCURRENT_REQUESTS — the concurrent manager request table, used to resolve request-specific context such as the request identifier and submission parameters.
• FND_NEW_MESSAGES — the Oracle Application Object Library message table, used to fetch translated message text for the report.
• DUAL — the standard single-row pseudo-table, used for formula and parameter evaluation where no physical table read is required.

No other application tables are documented as direct dependencies.

Usage Notes

This package is invoked automatically by the Oracle EBS concurrent manager when the associated XML Publisher report is run; it is not intended for direct invocation by end users. The report template calls the *FORMULA functions during rendering, while BEFOREREPORT and AFTERPFORM fire at their respective points in the concurrent request lifecycle to populate parameter and setup values. The package is referenced by no other package, indicating it sits at the leaf of the dependency chain. Customizations should be confined to the report definition and template rather than editing the generated package body, since the object is regenerated whenever the report definition is modified. Copying or transferring the report to another environment requires the concurrent program, template, and this support package to be migrated together.