Search Results c_organization_hierarchy

Overview

The PL/SQL package body APPS.PER_PERUSADA_XMLP_PKG is the server-side generator package for the Oracle E-Business Suite US ADA (Americans with Disabilities Act) reporting extract, a US legislative report produced from Oracle Human Resources (PER) and Oracle Payroll legislative rule data. The package name follows the standard Oracle Reports XML Publisher integration convention (PER_<report>_XMLP_PKG), in which a database package is bound to a report definition and its BeforeReport trigger is used to initialize global package variables that the report query and layout subsequently reference.

The business purpose of the package is to assemble the runtime context for the ADA report: the effective session date, the business group name, the organization and organization hierarchy names, the descriptive flexfield structure identifiers that hold US disability data, and dynamic WHERE-clause fragments that filter the extract by person, assignment, disability status, or organization hierarchy. It is classified as OTHER in the ETRM repository and is not an open public API; it is an internal, report-private implementation unit. The header comment ($Header: PERUSADAB.pls 120.0 2007/12/28) indicates a relatively old file baseline that has shipped unchanged through the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The ETRM metadata documents 18 procedures and functions. Their roles are as follows:

• BEFOREREPORT — The primary initialization routine, bound to the report's Before Report trigger. It formats the session date, seeds FND_SESSIONS, resolves the business group, organization, and organization hierarchy names, loads the ADA flexfield structure numbers from PAY_LEGISLATION_RULES, and builds the dynamic filter fragments.
• G_1GROUPFILTER — Group filter used to control the grouping/selection of records in the first report group.
• G_DISABILITIESGROUPFILTER — Group filter applied specifically to the disabilities data group.
• G_2GROUPFILTER — Group filter for the second report group.
• AFTERPFORM — Parameter form post-processing function, executed after the report parameter form is submitted, typically used to validate or transform parameter values before the main query runs.
• AFTERREPORT — Post-report processing function, conventionally used for cleanup or closing cursor handling.
• C_*_P — Getter/setter functions for the package's global variables: C_BUSINESS_GROUP_NAME_P, C_REPORT_TYPE_P, C_ORGANIZATION_HIERARCHY_P, C_ORGANIZATION_P, C_DISABILITY_ID_FLEX_NUM_P, C_DISABILITY_ACC_ID_FLEX_NUM_P, C_LEX_ASSIGN_WHERE_P, C_LEX_ASSIGN_ORDER_P, C_FULL_NAME_P, C_EMPLOYEE_NUMBER_P, C_JOB_NAME_P, and C_LOCATION_CODE_P. These expose the values computed in BEFOREREPORT to the report layout.

The variable c_organization_hierarchy is populated by calling hr_us_reports.get_org_hierarchy_name using the organization structure version id; when the version id is null it defaults to -1 and the hierarchy name is set to null.

Tables Accessed

• FND_SESSIONS — An INSERT is issued to register the current session id with the truncated system date if no row already exists for that session; this satisfies the standard Oracle Reports session-date dependency.
• PAY_LEGISLATION_RULES — Two single-row SELECTs read the rule_mode values for legislation US and rule types ADA_DIS and ADA_DIS_ACC, yielding the descriptive flexfield structure numbers for the disability and disability accommodation segments.
• PER_ALL_PEOPLE_F — Queried by person_id to retrieve the employee number when an employee number parameter is supplied.
• DUAL — Used as the source for the FND_SESSIONS insert-select and for scalar conversions.

Usage Notes

PER_PERUSADA_XMLP_PKG is invoked exclusively through the XML Publisher/Oracle Reports runtime. The report's Before Report trigger calls BeforeReport; the parameter form logic calls AFTERPFORM; and the layout invokes the C_*_P accessors to render column values. It is not referenced by any other PL/SQL package in the ETRM repository, confirming its role as a private report implementation. Because the dynamic filter fragments (c_lex_assign_where) are assembled by string concatenation into the report SQL, the package expects the calling report parameters (person, employee number, registered disabled flag, organization structure version) to be supplied by the standard ADA report concurrent program. Customizations should avoid modifying the shipped body directly; extensions are more safely implemented by wrapping or cloning the report definition.