Search Results c_no_data_found_p

Overview

PA_PAXCCARS_XMLP_PKG is a report-supporting PL/SQL package body owned by APPS in Oracle E-Business Suite. It is the packaged companion to an Oracle Reports XML Publisher (XMLP) concurrent program in the Projects (PA) module — the naming convention PA_..._XMLP_PKG identifies it as the generated server-side package that Oracle Reports creates when a report is converted to, or run through, the XML Publisher engine. Its role is to supply the interface variables, header values, and before/after report logic that the report executable requires, rather than to implement the substantive business transaction itself.

The package exposes the standard Oracle Reports package structure: initialization logic in BEFOREREPORT, teardown in AFTERREPORT, and a set of getter functions that surface package-level constants to the report layout. The user search term "c_dummy_data_p" corresponds to one of these getter accessors, indicating that the person was tracing how a report-level dummy data flag is populated and returned.

Key Procedures and Functions

• GET_COVER_PAGE_VALUES — Returns a BOOLEAN indicating whether cover page values were successfully obtained; the body simply returns TRUE with an exception handler returning FALSE. It guards the report's cover page section.
• BEFOREREPORT — The main initialization routine. It captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, assigns the PA_RULE_BASED_OPTIMIZER profile value to P_RULE_OPTIMIZER, invokes GET_COMPANY_NAME, retrieves the NO_DATA_FOUND message text from PA_LOOKUPS into C_NO_DATA_FOUND, and calls PA_COST_PLUS.COMPILE_ALL. Its NO_DATA_FOUND handler sets C_DUMMY_DATA to 1, which is the flag surfaced by C_DUMMY_DATA_P.
• GET_COMPANY_NAME — Fetches the ledger name from GL_SETS_OF_BOOKS for the session's GL_SET_OF_BKS_ID and stores it in C_COMPANY_NAME_HEADER for the report header.
• AFTERREPORT — Teardown routine; returns TRUE after the (now commented) SRW SRWEXIT user exit.
• C_COMPANY_NAME_HEADER_P — Getter returning the company/ledger name header string.
• C_NO_DATA_FOUND_P — Getter returning the localized "no data found" message text.
• C_DUMMY_DATA_P — Getter returning the C_DUMMY_DATA flag, set to 1 when the lookup query in BEFOREREPORT raises NO_DATA_FOUND. This is the accessor associated with the search term.

Tables Accessed

The documented body references two tables through APPS synonyms. PA_LOOKUPS is queried for the MESSAGE lookup type with code NO_DATA_FOUND, supplying the display string stored in C_NO_DATA_FOUND. GL_SETS_OF_BOOKS is queried for the ledger NAME corresponding to the GL_SET_OF_BKS_ID profile option, populating the report header. Both are read-only lookups performed during initialization; no inserts, updates, or deletes are documented.

Usage Notes

This package is not invoked by other PL/SQL packages — the metadata records zero referencing packages. It is called implicitly by the Oracle Reports runtime when the associated PA XML Publisher concurrent program executes, with BEFOREREPORT firing before the report query and AFTERREPORT after output generation. The C_*_P getter functions are referenced as report formula or parameter columns so that layout elements can display the ledger name, the NO_DATA_FOUND message, and the dummy-data indicator. Because it is a generated-style XMLP wrapper, customization should be avoided; changes belong in the underlying report definition, and the package should be regenerated rather than patched by hand under EBS 12.1.1 or 12.2.2.