Search Results get_promotion_ind

Overview

HRI_BPL_WRKFC_EVT is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. In the ETRM repository, the package is classified as an OTHER API type rather than a public or private business API, which indicates that it is an internal helper component rather than a formally exposed integration interface. The name follows the conventions used by Oracle's Human Resources Intelligence (HRI) family of packages: "BPL" denotes Business Process Library, "WRKFC" denotes workforce, and "EVT" denotes events. Consistent with this naming, the package exists to support workforce-related event processing within the Oracle HRMS intelligence and analytics layer.

The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. The ETRM excerpt lists only the package and package body stubs, and no SQL statement detail beyond its dependency list. Its dependencies are limited to SYS and the STANDARD package, meaning it relies on core PL/SQL runtime facilities rather than other application packages. Within the APPS schema it is referenced by itself and by HRI_OPL_ASGN_EVENTS, which is the event-handling package for assignment-related workforce events.

Key Procedures and Functions

The documented package exposes one procedure or function: GET_PROMOTION_IND. No parameter list is provided in the ETRM metadata, and none should be assumed. Based solely on its name and its placement within the HRI_BPL_WRKFC_EVT package, GET_PROMOTION_IND returns a promotion indicator — that is, a value that identifies whether a given workforce event represents, or should be treated as, a promotion for the employee concerned. The function is a read-only lookup helper; it supplies a flag that downstream event-processing logic can evaluate when classifying or reporting on workforce changes.

Because it is the only documented subprogram, GET_PROMOTION_IND should be regarded as the package's principal public surface. Any additional private helpers in the package body are not documented in the ETRM repository and are not described here. The absence of a parameter list in the metadata means integrators and support analysts should inspect the package specification directly before calling it, rather than relying on assumptions about its signature.

Tables Accessed

Via APPS synonyms, HRI_BPL_WRKFC_EVT references four tables: PER_ALL_POSITIONS, PER_GRADES, PER_JOBS, and PLITBLM. These are all core Oracle HRMS objects. PER_ALL_POSITIONS, PER_GRADES, and PER_JOBS hold the position, grade, and job definitions used by Oracle HR. The presence of these three tables strongly suggests that GET_PROMOTION_IND derives its promotion determination by comparing job, grade, or position attributes associated with a workforce event. PLITBLM is the PL/SQL integer table type used for passing numeric collections between PL/SQL and calling environments; its inclusion indicates the package uses collection-based buffering or bulk processing rather than exposing only scalar results.

All four objects are accessed through APPS synonyms, so no direct cross-schema privileges are required of callers. The package does not appear in the dependency list of any other published package, confirming that its table access is confined to the HRI event-processing path.

Usage Notes

HRI_BPL_WRKFC_EVT is invoked from within the HRI event-processing framework rather than from Oracle Forms or from standard concurrent programs. Its sole caller of record, HRI_OPL_ASGN_EVENTS, is the assignment events package in the same HRMS intelligence family, which calls into HRI_BPL_WRKFC_EVT to determine promotion status while processing assignment changes. Custom code should therefore treat the package as an internal dependency of HRI_OPL_ASGN_EVENTS and avoid direct invocation unless the caller is prepared to depend on the HRI event pipeline.

There is no documented concurrent program or form that calls the package directly. Because the ETRM entry is marked OTHER and provides no parameter documentation, organizations extending or troubleshooting promotion-related event behavior should review the package specification and body in the APPS schema in the target environment before relying on it. In both 12.1.1 and 12.2.2 the object is reported VALID, so no manual recompilation is expected under normal patching conditions.