Search Results c_organization_p

Overview

APPS.PER_PERUSADA_XMLP_PKG is a report-support package that backs the Oracle HRMS Person/Assignment XML Publisher (BI Publisher) concurrent report identified by the PERUSADA short name. The package was last refreshed under version 120.1 (header date 28 December 2007) and is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer. Its purpose is to hold the bind parameters, report-level globals, and the before/after report logic required by the XML Publisher template associated with the Person Usada (Workforce/Person listing) report. The parameter and global variables it declares, together with the getter functions, drive the SQL query and layout of the resulting XML output.

Key Procedures and Functions

The package exposes 18 documented program units, all tied to report execution and parameter resolution.

• BeforeReport — Initializes report state before the main data query fires; typically sets the business group and session context used by the report.
• AfterPForm — Executes after the parameter form is populated, allowing defaulting or validation of user-entered parameters.
• AfterReport — Cleanup or post-processing logic run once the report body has been generated.
• G_1groupfilter — Group filter applied to the establishment section of the report.
• G_2GroupFilter — Second group-level filter controlling row inclusion for a report section.
• G_DisabilitiesGroupFilter — Group filter governing the disabilities/registered-disabled subsection of the report.
• C_BUSINESS_GROUP_NAME_p, C_REPORT_TYPE_p, C_ORGANIZATION_HIERARCHY_p, C_ORGANIZATION_p — Getter functions returning the corresponding report globals. C_ORGANIZATION_HIERARCHY_p, the object matched by the user's search term, returns the organization hierarchy selection used to scope the report.
• C_DISABILITY_ID_FLEX_NUM_p, C_DISABILITY_ACC_ID_FLEX_NUM_p — Getter functions returning the flexfield numbers for the disability and disability-accommodation descriptive flexfields.
• C_lex_assign_where_p, C_lex_assign_order_p — Return the dynamically constructed WHERE and ORDER BY fragments used to filter and sort assignment rows; the defaults are 'and 1 = 1' and 'initcap(peo.full_name)'.
• C_full_name_p, C_employee_number_p, C_job_name_p, C_location_code_p — Getters for the person name, employee number, job name, and location code display columns.

Tables Accessed

The package references four objects through APPS synonyms:

• PER_ALL_PEOPLE_F — The primary HR person datestamped table, supplying name, employee number, and person identifiers for the report rows.
• FND_SESSIONS — Read to obtain session information such as the session date used to constrain effective-dated person records.
• PAY_LEGISLATION_RULES — Consulted for legislation-specific rules that influence report behavior across business groups.
• DUAL — Used for single-row computations and defaulting of parameters.

Usage Notes

PER_PERUSADA_XMLP_PKG is invoked indirectly by the Oracle HRMS XML Publisher concurrent program that shares the PERUSADA short name; it is not intended as a public API. The ETRM metadata records zero referencing packages, confirming it sits at the top of its call chain as report infrastructure rather than a shared library. The BeforeReport function is called by the XML Publisher engine at report startup, AfterPForm following parameter entry, and the G_* filter functions from within the report's data model groups. Getter functions such as C_ORGANIZATION_HIERARCHY_p expose globals to the XML template. Customizations should not modify this seeded package directly; the supported approach is to copy the report definition and its data template. Because it is AUTHID CURRENT_USER, the invoking concurrent program must run under a responsibility whose user has execute privilege on the package and select privilege on the referenced tables.