Search Results emp_range

Overview

PA_PARCPRJR_XMLP_PKG is the generated PL/SQL package body behind the Oracle Projects XML Publisher concurrent program "Project Resource Report" (short name PARCPRJR). In Oracle EBS 12.1.1 and 12.2.2, this package is registered as an OTHER classified API in the APPS schema, meaning it is not a public extension API but the runtime implementation of a BI Publisher-based report. Its principal responsibilities are to initialize report-level bind parameters, validate the user-supplied selection criteria defined by the p_selection_option parameter, resolve organization and employee-range values, invoke the public Project Resources API to populate the denormalized resource tables, and set the concurrent request completion status when the report finishes.

The p_selection_option parameter is central to the package's control flow. It drives which prerequisite parameters must be present before the report can execute, and the BEFOREREPORT function branches on four valid values: EMP_RANGE, EMP_RANGE_ORG, SINGLE_ORG, and START_ORG.

Key Procedures and Functions

• AFTERREPORT — Invoked after the XML data template has been rendered. If the internal flag P_RET_STATUS is 'Y', it calls FND_CONCURRENT.SET_COMPLETION_STATUS to mark the request as WARNING, ensuring partial or empty results are visible to the user running the report.
• BEFOREREPORT — The core startup routine. Assigns the concurrent request ID from FND_GLOBAL, formats P_TERM_RANGE_DATE, and validates p_selection_option. For EMP_RANGE it requires P_FROM_EMP_NUM and P_TO_EMP_NUM; for EMP_RANGE_ORG it additionally requires P_ORGANIZATION_ID; for SINGLE_ORG it requires P_ORGANIZATION_ID; for START_ORG it requires P_ORG_STR_VERSION_ID and P_START_ORGANIZATION_ID. Each failure sets a corresponding CP_CHK_* flag and returns early. It also reads the PA_DEBUG_MODE profile and calls PA_R_PROJECT_RESOURCES_PUB.CREATE_RESOURCE to populate the resource data set.
• CP_CHK_EMP_RANGE_P, CP_CHK_ORG_AND_EMP_RANGE_P, CP_CHK_SINGLE_ORG_P, CP_CHK_START_ORG_P — Validation functions returning the CP_CHK_* flags set by BEFOREREPORT for each p_selection_option branch.
• CP_CHK_ORG_OR_EMP_P, CP_NODATAFOUND_P, CP_COUNT_P — Supporting boolean/count functions that expose organization-versus-employee validation state, the no-data condition, and record counts to the report layout.
• CF_*FORMULA functions — CF_SELECTION_OPTIONFORMULA, CF_ORGANIZATION_NAMEFORMULA, CF_ORG_STR_VERSION_IDFORMULA, CF_START_ORG_IDFORMULA, CF_PULL_TERM_RESFORMULA, CF_PERSON_TYPEFORMULA, and CF_REFRESHFORMULA are XML Publisher formula columns that translate internal IDs and codes into display text for the report output.

Tables Accessed

The package queries FND_LOOKUP_VALUES for descriptive flexfield and lookup code resolution, and DUAL for SYSDATE. Organization context is derived from HR_ALL_ORGANIZATION_UNITS, PER_ORGANIZATION_STRUCTURES, and PER_ORG_STRUCTURE_VERSIONS, which are required to resolve the P_ORGANIZATION_ID and P_ORG_STR_VERSION_ID parameters. Resource data is written to and read from PA_RESOURCES and PA_RESOURCES_DENORM through the Project Resources public API rather than by direct DML.

Usage Notes

PA_PARCPRJR_XMLP_PKG is not referenced by any other package in the APPS schema, confirming it is invoked exclusively by the Oracle Reports/BI Publisher concurrent program runtime. Administrators define the report under Projects concurrent programs with p_selection_option as the primary parameter; the pairing of p_selection_option with the required employee, organization, or structure-version parameters must be respected or the report terminates early with a validation warning. Custom code should not call this package's procedures directly; extension developers interacting with the same data should use PA_R_PROJECT_RESOURCES_PUB, which this package itself relies upon.