Search Results cp_request_time

Overview

INV_INVORGES_XMLP_PKG is a generated Oracle Reports support package that resides in the APPS schema and backs the XML Publisher (BI Publisher) report commonly associated with the Inventory Organization Setup / Organization Listing concurrent program. As with other packages carrying the _XMLP_PKG suffix, its primary business function is to serve as the report's PL/SQL execution shell: it initializes the reporting environment, populates the global package variables that the report layout references as bind parameters, and returns those values through dedicated getter functions during the report's execution cycles. The package does not contain application business logic; rather, it is the plumbing that connects the Oracle Reports runtime to the concurrent manager request context so that the printed output can display standard "run-time" header information such as responsibility, request date, application, and the submitting user.

Key Procedures and Functions

The package exposes six documented program units, all of which are simple entry points rather than parameterized APIs.

• BEFOREREPORT — The report-level BeforeReport trigger. It captures the concurrent request ID into the P_CONC_REQUEST_ID global and queries the request metadata into the package variables CP_RESPONSIBILITY, CP_REQUEST_TIME, CP_APPLICATION, and CP_REQUESTED_BY. It returns BOOLEAN and includes exception handlers for NO_DATA_FOUND and OTHERS so that a missing request row does not halt the report.
• AFTERREPORT — The report-level AfterReport trigger. It performs clean-up at the end of report execution and returns BOOLEAN.
• CP_RESPONSIBILITY_P — Getter function that returns the responsibility name captured in BEFOREREPORT as VARCHAR2.
• CP_REQUEST_TIME_P — Getter function that returns the formatted request submission timestamp as VARCHAR2.
• CP_APPLICATION_P — Getter function that returns the application name associated with the responsibility as VARCHAR2.
• CP_REQUESTED_BY_P — Getter function that returns the user name of the person who submitted the concurrent request as VARCHAR2.

Tables Accessed

All reads are performed inside BEFOREREPORT against four FND views accessed through APPS synonyms:

• FND_CONCURRENT_REQUESTS — The driving table, filtered by REQUEST_ID = P_CONC_REQUEST_ID. It supplies the request date, responsibility identifier, and the requesting user ID.
• FND_RESPONSIBILITY_VL — Joined on responsibility and application to resolve the responsibility name.
• FND_APPLICATION_VL — Joined to derive the application name for the responsibility context.
• FND_USER — Joined on USER_ID = FCR.REQUESTED_BY to resolve the submitting user's name.

No INSERT, UPDATE, or DELETE operations are performed; the package is strictly read-only with respect to the database.

Usage Notes

This package is invoked exclusively by the Oracle Reports runtime when the associated Inventory organization report is submitted as a concurrent program. It is not called from Oracle Forms or from custom application code, and the ETRM metadata records zero inbound package references. The public getter functions are referenced from the report's data model and layout so that the run-time attributes (responsibility, request time, application, requested by) can be displayed on the output. Customizations should not modify this package directly, because it is auto-generated from the report definition and may be regenerated; any display changes should be made in the report layout itself. The typical customization point is the CP_REQUESTED_BY variable, which is surfaced in the user's search for cp_requested_by_p and represents the "Requested By" value rendered on the report output.