Search Results c_job_name_p

Overview

PA_PAXPEEMO_XMLP_PKG is the generated PL/SQL package body behind the Oracle Projects (PA) XML Publisher concurrent program PAXPEEMO, an "Employee/Organization" style report executed inside Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates the report's data-initialization logic and exposes report parameter bindings used by Oracle Reports/BI Publisher through the standard FND SRWINIT / SRW integration pattern. Its primary business purpose is to resolve and publish contextual header information for the report — company name, starting organization name, and job name — based on concurrent program parameters such as P_START_ORGANIZATION_ID, JOB_ID, and P_CONC_REQUEST_ID. The package is owned by APPS and is classified as OTHER (not a callable business API), meaning it is designed solely to support a single concurrent program rather than to expose reusable functionality to other components.

Key Procedures and Functions

• GET_COVER_PAGE_VALUES — Returns a BOOLEAN used to signal successful initialization for the report cover page; it always returns TRUE and traps exceptions by returning FALSE.
• BEFOREREPORT — The main before-report trigger. It captures FND_GLOBAL.CONC_REQUEST_ID into P_CONC_REQUEST_ID, retrieves the PA_DEBUG_MODE profile option into P_DEBUG_MODE, resolves organization, job, and company names, and raises init_failure if downstream lookups (GET_COMPANY_NAME, GET_START_ORG) fail.
• GET_COMPANY_NAME — Queries GL_SETS_OF_BOOKS joined to PA_IMPLEMENTATIONS to load the company/ledger name into C_COMPANY_NAME_HEADER.
• GET_START_ORG — Determines the starting organization ID, substituting the implementation default when P_START_ORGANIZATION_ID is null, and resolves related organization data from PA_ORG_REPORTING_SESSIONS.
• AFTERREPORT — Post-report cleanup/handoff routine invoked after the report finishes rendering.
• C_COMPANY_NAME_HEADER_P — Returns the company name header binding to the report layout.
• C_ORG_NAME_P — Returns the resolved organization name for the report layout.
• C_JOB_NAME_P — Returns the resolved job name (corresponding to the C_JOB_NAME variable populated from PER_JOBS based on JOB_ID); this is the function matching the user's search term "c_job_name_p" and is the lexical accessor used by the XML/RTF template to display the job name on the output.

Tables Accessed

• PA_IMPLEMENTATIONS — Used to determine the set of books (SET_OF_BOOKS_ID) for the current Projects implementation; joined to GL_SETS_OF_BOOKS to obtain the company/ledger name.
• PA_ORG_REPORTING_SESSIONS — Used by GET_START_ORG to derive the appropriate start organization when the parameter is null.
• PER_JOBS — Used to translate JOB_ID into JOB_NAME for the report header. HR_ORGANIZATION_UNITS is also referenced for the organization name via the ORG_NAME variable.

Usage Notes

This package is invoked automatically by the Oracle Reports runtime when the PAXPEEMO concurrent program is submitted; it is not intended for direct invocation. The BEFOREREPORT function executes the same initialization steps historically performed by FND SRWINIT and FND GETPROFILE user exits, which are present as commented stubs. Report designers or developers customizing the PAXPEEMO layout can reference the C_*_P functions (such as C_JOB_NAME_P, C_ORG_NAME_P, and C_COMPANY_NAME_HEADER_P) directly within the XML/RTF template to display resolved descriptive names instead of raw IDs. Because the package is registered as OTHER and is not referenced by any other package, it should be treated as program-private code; modifications must be carefully regression tested through the concurrent program rather than through ad hoc PL/SQL calls. In 12.2.2 the same package body is used, with behavior governed by the PA_DEBUG_MODE profile option for diagnostics.