Search Results c_assignment_set

Overview

APPS.PAY_PYGBNICV_XMLP_PKG is the Oracle Reports PL/SQL package body generated for the "View NI Consolidation" XML Publisher report (PGYBNICV), a statutory payroll reporting component in Oracle E-Business Suite HRMS/Payroll. The package drives the report's BeforeReport and AfterReport triggers and exposes the report placeholder columns through accessor functions so that the XML Publisher template can substitute runtime values. In the context of Oracle EBS 12.1.1 and 12.2.2, this object resides in the APPS schema and is classified as an "OTHER" API rather than a public or private supported API, meaning it is intended for internal use by the report definition rather than as a callable integration interface. Its principal business role is to resolve and cache descriptive names — payroll name, business group name, consolidation set name, and assignment set name — based on the parameters entered by the user at the time the concurrent request is submitted, and to establish the sort order applied to the report's data query.

Key Procedures and Functions

• BEFOREREPORT — Executes before the report data query and serves as the initialization routine. It populates the package-level global variables: it calls HR_REPORTS.GET_PAYROLL_NAME and HR_REPORTS.GET_BUSINESS_GROUP to derive the payroll and business group descriptive text, constructs the ORDER BY clause from the p_sort_order parameter, and looks up the consolidation set name and assignment set name from their respective base tables. It also assigns the effective date parameter to the LP_EFFECTIVE_DATE global used by the report. The routine returns TRUE to signal successful completion.
• AFTERREPORT — Executes after report completion, providing an ordered exit point for cleanup. In this package it performs no substantive processing and simply returns TRUE.
• C_BUSINESS_GROUP_NAME_P — Accessor function that returns the cached business group name for use as a report placeholder.
• C_REPORT_SUBTITLE_P — Accessor function returning the report subtitle placeholder value.
• C_PAYROLL_NAME_P — Accessor function returning the resolved payroll name.
• C_CONSOLIDATION_SET_P — Accessor function returning the resolved consolidation set name.
• C_ASSIGNMENT_SET_P — Accessor function returning the resolved assignment set name; this is the object most directly associated with the searched term "c_assignment_set," which is the package global populated in BEFOREREPORT and surfaced through this placeholder function.

Tables Accessed

The package reads two tables through APPS synonyms. HR_ASSIGNMENT_SETS is queried in BEFOREREPORT to translate the p_assignment_set parameter (an ID) into its descriptive ASSIGNMENT_SET_NAME, stored in the c_assignment_set global. PAY_CONSOLIDATION_SETS is queried in BEFOREREPORT to translate the p_consolidation_set parameter into its CONSOLIDATION_SET_NAME. Both lookups are protected by NO_DATA_FOUND exception handlers that leave the corresponding global null if no matching row exists. Additional descriptive data is obtained indirectly through the HR_REPORTS package rather than by direct table access. No inserts, updates, or deletes are performed; the package is strictly read-only.

Usage Notes

This package is invoked exclusively by the Oracle Reports runtime when the View NI Consolidation concurrent program is executed. Users do not call its procedures directly, and it is not referenced by any other documented package. Because it is an "OTHER"-classified component, it is not a supported API and should not be called from custom forms, concurrent programs, or integration code. Customizations requiring additional placeholder values should be implemented by extending the underlying report definition and its PL/SQL library in a supported fashion, preserving the generated package structure. The parameter p_sort_order drives dynamic ORDER BY construction; values supplied to it should be validated at the report parameter level, since the package concatenates the string directly into the sort clause.