Search Results element_categoryformula

Overview

APPS.PAY_PAYUSRRS_XMLP_PKG is an Oracle E-Business Suite PL/SQL package that backs the XML Publisher (BI Publisher) concurrent program associated with the Oracle Payroll user-defined report "PAYUSRRS." It is a generated report package of the classic <report>_XMLP_PKG pattern, in which Oracle Reports-style triggers—BeforeReport, AfterReport, AfterPForm, and named group/column formulas—are re-implemented as PL/SQL functions that the XML Publisher engine invokes while rendering the report data model. The package is declared AUTHID CURRENT_USER and thus executes with the privileges of the calling user rather than the APPS owner, which is the standard convention for report packaging in R12.

The package exposes the report's runtime parameters as public variables (business group, session date, report title and subtitle, concurrent request ID, person ID, tax unit, assignment number, start and end dates, classification, assignment set, and the dynamically constructed WHERE, FROM, and hint clauses), together with cached output values such as business group name, person name, classification name, GRE name, and assignment set name. This structure indicates that the report accepts flexible, user-driven selection criteria and formats them into a dynamic SQL clause for the underlying query.

Key Procedures and Functions

The ETRM classification lists fourteen documented program units. The following describes their documented purpose:

• BeforeReport — Executes before the main report query; initializes report context, populates cached names, and finalizes the dynamic clauses used by the data model.
• AfterReport — Executes after the report completes; used for post-processing or cleanup of report state.
• AfterPForm — Runs after the parameter form (parameter entry) phase; typically derives dependent values from user-entered parameters.
• GET_BUSINESS_GROUP_NAME — Returns the business group name for a given business group identifier.
• GRE_NAMEFORMULA — Group/row-level formula resolving the GRE (Government Reporting Entity) name from the tax unit identifier.
• ELEMENT_CATEGORYFORMULA — Formula returning a derived element category value from element information category and information context.
• CF_CON_DATEFORMULA — Conditional formatting formula, returning a formatted date string for display.
• RVALUEFORMULA — Documented as "Added as a fix"; converts a result value into a numeric return value, typically to satisfy XML Publisher's type expectations.
• C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P, C_PERSON_NAME_P, C_CLASSIFICATION_NAME_P, CP_GRE_NAME_P, CP_ASG_SET_NAME_P — Accessor functions that return the corresponding cached column/parameter value to the report layout.

The parameter CP_asg_set_name, the subject of the user's search, is the cached string holding the descriptive name of the assignment set identified by the report's assignment set parameter; it is exposed through the CP_ASG_SET_NAME_P function so that the XML layout can print the set name rather than its numeric identifier.

Tables Accessed

The package reads from three documented tables via APPS synonyms:

• HR_ASSIGNMENT_SETS — Resolves the assignment set identifier to its name for the CP_asg_set_name value and validates the selected set.
• PER_ALL_ASSIGNMENTS_F — The primary assignment and person datastore supplying assignment number and person details filtered by the dynamic WHERE clause.
• PAY_ELEMENT_CLASSIFICATIONS — Provides element classification information used by the element category formula and related report columns.

Usage Notes

PAY_PAYUSRRS_XMLP_PKG is invoked by the XML Publisher concurrent program that owns the PAYUSRRS report definition; the report engine calls its trigger functions and formulas during layout generation rather than through direct application calls. It is not referenced by any other documented package (referenced by 0 packages), confirming its role as a leaf-level report library. Customizations typically occur in the report's data model or in the AfterPForm/BeforeReport logic where clause construction takes place. The assignment set name is surfaced for the report layout through the CP_ASG_SET_NAME_P accessor. Because the package uses AUTHID CURRENT_USER and dynamic SQL clauses, it relies on the invoking user's access to the HR and PAY synonym objects; in 12.2.2 online patching environments, modifications to the package must be applied in the correct edition and run edition context to avoid runtime invalidation.