Results for “per_get_organization_employees”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PER_VIEWS_PKG is a PL/SQL package within the Oracle E-Business Suite Human Resources (PER) product family that supplies shared computational and lookup logic for the Oracle HRMS salary, grade, and payroll accrual model. Rather than presenting a public API for transactional processing, it exposes reusable server-side functions that views, forms, and other packages call to derive calculated values — grade step placements, salary comparatio, hierarchical organization relationships, and net accrual components. The package sits in the APPS schema and is categorized in ETRM as an OTHER-class API, indicating that it is an internal utility package rather than a formally published, supported interface. Its header comments date to the 11i/12.0 code line (peronvew.pkh 120.0.12010000.3), and the same object is present in both EBS 12.1.1 and 12.2.2 with twelve documented procedures and functions.

Key Procedures and Functions

Twelve procedures and functions are documented. The header excerpt confirms several of them directly:

• PER_GET_GRADE_STEP — returns the grade step derived from grade step placement information, resolving the step associated with a grade spine and parent spine for an effective date.
• PER_CALC_COMPARATIO — calculates the salary comparatio for a given assignment, using salary, hours, frequency, grade, rate, and business group context. Its restricted-references pragma was removed under Bug 5945278, so it is not constrained to read-only purity.
• PER_GET_PARENT_ORG — returns the parent organization of a given organization within a specified hierarchy version.
• per_get_net_accrual — the function associated with the search term; it computes an assignment's net accrual position by combining accrual plan and band definitions with element entry and net calculation rule data.

The remaining documented entries follow the same pattern of retrieval and calculation helpers used by HRMS accrual and salary views. Parameter lists should be taken from the package specification in the target instance, as signatures vary between patch levels.

Tables Accessed

The package reads a broad set of payroll and HR tables through APPS synonyms; no direct writes are documented. Accrual-related logic draws on PAY_ACCRUAL_PLANS and PAY_ACCRUAL_BANDS (plan and band definitions), PAY_NET_CALCULATION_RULES (net entitlement rules), and the element entry tables PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F to obtain the entries and input values that feed the calculation. Salary and grade processing uses PAY_GRADE_RULES_F and PER_PAY_BASES, supplemented by PER_PAY_PROPOSALS. Assignment context comes from PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES, PER_PERIODS_OF_SERVICE, and PER_ORG_STRUCTURE_ELEMENTS, the last supporting the parent-organization hierarchy lookups.

Usage Notes

PER_VIEWS_PKG is invoked indirectly. Oracle HRMS salary and accrual views defined on these base tables call the functions to expose derived columns, and Oracle Forms in the HRMS salary and grade administration flows use them to display comparatio and step values. The package is also referenced by three other packages, which rely on it as a shared calculation layer, and it may be called from custom PL/SQL or Fast Formula-adjacent code when a client requires the same accrual or comparatio logic. Because it is classified OTHER rather than as a supported public API, customizations should call it defensively: confirm the signature in the target instance, avoid dependence on internal behavior across upgrades, and prefer documented HRMS public APIs where equivalent functionality exists.