Search Results fii_rolling_qtr

Overview

HRI_OLTP_PTL_PARAM is an Oracle E-Business Suite package body owned by the APPS schema and classified under the "OTHER" API category. Its business function is to resolve and return the parameter substitution strings used by Oracle HRMS self-service and manager dashboards (the "HR Intelligence" / Daily Business Intelligence portal regions). When a portal region is rendered, Oracle EBS requires a set of bind parameters (such as the signed-in manager's identifier, the analysis dimension, and the period range) to be passed to the underlying OBI/OLTP query. This package performs exactly that translation: it accepts a region identifier and returns an ampersand-delimited parameter string that the region framework expands at runtime.

The package is a thin, security-aware utility layer. It derives the identity of the current user from hri_bpl_security.get_apps_signin_person_id, resolves that person to a display name, and constructs the appropriate parameter payload. Because the package reads the effective-dated person record, it respects HRMS date-tracking semantics and returns safely when no current row exists.

Key Procedures and Functions

• GET_PARAMS — The primary entry point. It accepts a region identifier and returns a concatenated parameter string. The function first resolves the signed-in person's employee_name from PER_ALL_PEOPLE_F by matching person_id against employee_id and confirming the row is current as of TRUNC(SYSDATE). A NO_DATA_FOUND handler sets the name to NULL. It then branches on region_id, emitting the appropriate name/value pairs for each known dashboard region (for example, salary-above-supervisor, above-hire-action-supervisor, above-change, above-turnover-supervisor-separation, above-turnover-supervisor-low, above-separation-supervisor, and salary-above-new-hire-job regions). Emitted tokens include HRI_P_SUP_LNAME_CN, HRI_P_SUP_ID, HRI_P_ABV_ID (typically set to 'Head Count'), HRI_P_PDRNG_ID and PERIOD (typically set to 'Quarter').
• GET_DBI_PARAMS — The Daily Business Intelligence counterpart. It follows the same pattern but additionally declares a currency variable typed against FII_CURRENCIES_V.VALUE, and protects the person lookup with NVL(..., -1) (bug fix 3886182) so that a NULL person identifier cannot silently corrupt the generated parameter string.
• GET_DBI_MGR_ID — Returns the manager identifier parameter used by DBI dashboard regions, resolving the manager context from the signed-in user.
• GET_DBI_CURR — Returns the currency parameter for DBI regions, derived from the FII currency view.
• GET_DBI_DATE — Returns the date or period parameter required by DBI regions to scope the reporting window.

Tables Accessed

The single documented table reference is PER_ALL_PEOPLE_F, accessed through an APPS synonym. The package reads full_name and the effective start/end dates, filtering on person_id and current effective date. No inserts, updates, or deletes are performed; the access is strictly read-only and supports the personalization of portal output for the signed-in employee.

Usage Notes

The package is invoked indirectly rather than called by end users or custom code. HRMS portal and DBI region definitions reference it as their parameter source, and the region framework calls GET_PARAMS or GET_DBI_PARAMS with the region's identifier to obtain the substitution string. It is not referenced by any other documented package, and it is not exposed as a concurrent program interface. Because the parameter string embeds the employee name and supervisor identifier, the package inherits the security posture of hri_bpl_security; the signed-in person resolution is the sole mechanism preventing one user's dashboard from displaying another's data. Customizations should avoid hard-coding region identifiers beyond those recognised in the branch logic, since unrecognised regions return no parameter string and the region will render without scoping.