Search Results evaluate_subposition_formula

Overview

The APPS.GHR_NFC_POSITION_EXTRACTS package is a PL/SQL program unit within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments that supports the extraction of position and assignment data for Benefits and related HR processes. The "NFC" prefix in Oracle EBS commonly denotes "Non-Flexfield Criteria" or "Net-to-Full Cost" style configuration engines; in this context the package is associated with the Benefits extract framework, as evidenced by its dependency on the BEN_EXT_* family of tables. It provides the procedural backbone for extracting position records, evaluating position-based eligibility criteria, and populating extract results and result details used downstream by external carriers and reporting consumers. The package is owned by the APPS schema and holds a VALID status in the ETRM 12.2.2 registry, with an API classification of OTHER (not a public API). It is documented as referencing multiple HR and Benefits tables and is not itself referenced by any other packages, indicating it functions as a top-level extract driver rather than a shared utility.

Key Procedures and Functions

Twelve procedures and functions are documented for this package. Their purposes are as follows:

• NFC_JCL_EXTRACT_PROCESS — Drives the extract process using Job/Position/Criteria logic, orchestrating the overall run for a given extract definition.
• NFC_POSITION_EXTRACT_PROCESS — The core position extract routine that iterates over eligible positions and produces extract records.
• BUILD_ELEMENT_VALUES — Constructs the element (data field) values required for each extract record.
• GET_INTERFACE_ATTRIBUTE_VALUE — Retrieves the value of a specific interface attribute associated with an extract definition.
• CHECK_POSITION_TYPE — Validates the position type against the extract criteria before processing.
• POSITION_SUB_HEADER_CRITERIA — Evaluates sub-header level criteria applied to position records.
• EVALUATE_SUBHEADER_FORMULA — Executes the configured formula that determines sub-header qualification.
• EVALUATE_SUBPOSITION_FORMULA — Executes the configured formula that determines sub-position qualification.
• DEL_POST_PROCESS_RECS — Removes records that fail post-processing rules after extraction.
• EVALUATE_DETAIL_RCD_FORMULA — Evaluates the formula governing detail-level extract records.
• POSITION_PERSON_MAIN_CRITERIA — Applies the main person-position criteria used to qualify assignments for extraction.
• GET_NFC_CONCPROG_INFORMATION — Retrieves concurrent program information associated with the extract run.

Tables Accessed

The package reads and writes several documented tables. It queries PER_ALL_POSITIONS, HR_ALL_POSITIONS_F, and PER_ALL_ASSIGNMENTS_F to obtain position and assignment data, and PER_BUSINESS_GROUPS for business group context. The Benefits extract framework tables — BEN_EXT_DFN, BEN_EXT_RCD, BEN_EXT_RSLT, and BEN_EXT_RSLT_DTL — are used to read extract definitions and write result and result-detail records. Supporting tables include BEN_BENEFIT_ACTIONS, BEN_EXT_RCD_IN_FILE, and BEN_EXT_RSLT_DTL_S. HR configuration tables PER_GRADES and PER_JOBS supply grade and job values for criteria evaluation, while GHR_PA_HISTORY and GHR_POS_INTERFACE_ERR_DTLS support position history and interface error tracking. FND_CONCURRENT_REQUESTS records the concurrent program run context.

Usage Notes

This package is typically invoked from a Benefits extract concurrent program rather than from a form or public API. It is not referenced by any other package, which confirms its role as an internal driver invoked directly by the concurrent manager. Customizations should avoid direct calls to its procedures; instead, extensions should target the underlying extract definitions and formulas, which the package evaluates. Because it writes to BEN_EXT_RSLT and related tables, it should be run only in scheduled extract windows, and any modification must respect the concurrent program's restart and error-handling semantics as recorded in GHR_POS_INTERFACE_ERR_DTLS.