Search Results psb_hr_extract_data_pvt




Overview
Explore in AI Chat

Overview

APPS.PSB_HR_EXTRACT_DATA_PVT is a private PL/SQL package in Oracle EBS Human Resources that supports the extraction of HR and payroll data for external reporting, benefits carriers, and third-party interfaces. The package is declared AUTHID CURRENT_USER and carries a public synonym under the APPS schema, with the header comment indicating an origin in the HR extract subsystem (PSBVHRXS.pls). It is an internal (PVT) utility rather than a published business API, and the ETRM registry classifies it accordingly.

The package contains the types g_ldcostmap_rec_type and g_ldcostmap_tbl_type, which model labor distribution cost map rows, together with the package-global record g_psb_rec used to accumulate cost distribution data during processing. Two private cursors, G_Employee_Details and G_Position_Details, resolve person and position names from PER_ALL_PEOPLE and PER_ALL_POSITIONS respectively. The bulk of the package logic is exposed through 16 documented procedures and functions.

Key Procedures and Functions

  • INIT — Initialises package state and returns the effective as-of date used by subsequent calls.
  • GET_POSITION_INFORMATION — Extracts position-level data, accepting an API version, message-list and commit flags, validation level, return status and message outputs, data extract identifier, extract-by-organization indicator, extract method, ID flex number, date, business group and set of books. This is the primary entry point for position-oriented extract runs.
  • GET_EMPLOYEE_INFORMATION — Extracts person/assignment-level attributes for the requested extract.
  • GET_SALARY_INFORMATION — Gathers pay rate and salary information from PAY_RATES and assignment records.
  • GET_COSTING_INFORMATION — Collects costing and labor distribution details, populating the cost map record type.
  • GET_ATTRIBUTES and GET_EMPLOYEE_ATTRIBUTES — Resolve person and assignment attributes through descriptive flexfield metadata.
  • VALIDATE_ATTRIBUTE_MAPPING — Validates that the attribute mapping configuration defined for the extract is internally consistent before data is written. This is the routine most commonly referenced by developers diagnosing extract configuration errors.
  • UPDATE_REENTRY, CHECK_REENTRY, REENTRANT_PROCESS — Manage restartability: recording progress, detecting a prior partial run, and resuming or reprocessing the extract.
  • FINAL_PROCESS — Performs closing steps after all extract rows are generated.
  • GET_LD_SCHEDULE — Retrieves labor distribution schedule information.
  • GET_DEBUG — Returns debug/diagnostic state.
  • GET_SEGMENT_VAL — Resolves key flexfield segment values for costing and payroll mapping.
  • IS_LD_ENABLED — Boolean check determining whether labor distribution processing is enabled for the operating context.

Tables Accessed

The package reads and writes across HR, Payroll, and Flexfields schemas. Person and position source data come from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ALL_POSITIONS, HR_ALL_POSITIONS_F, and HR_ALL_ORGANIZATION_UNITS. Costing data uses PSB_COST_DISTRIBUTIONS_I, PAY_COST_ALLOCATIONS_F, PAY_COST_ALLOCATION_KEYFLEX, and PAY_PAYROLL_GL_FLEX_MAPS. Payroll and rate data come from PAY_ALL_PAYROLLS_F and PAY_RATES. Flexfield definition tables FND_ID_FLEXS, FND_ID_FLEX_STRUCTURES, and FND_DESCR_FLEX_COLUMN_USAGES are used to resolve the extract's attribute and segment mappings, while FND_SESSIONS provides session context. These reads support attribute resolution and costing validation; writes are generally confined to the extract staging structures managed by the calling process.

Usage Notes

PSB_HR_EXTRACT_DATA_PVT is not intended for direct customer invocation. It is called by HR extract concurrent programs and by the four packages that reference it in the ETRM dependency list. Standard practice is to run the extract concurrent program and let this package handle data gathering, validation, and restartability internally. Custom code should not call VALIDATE_ATTRIBUTE_MAPPING or the GET_* procedures directly unless the calling program also sets up the extract record and API control parameters expected by the FND_API message-handling convention. Because the package is AUTHID CURRENT_USER, privileges are evaluated against the invoking schema, so any custom caller must hold appropriate grants on the underlying HR, Payroll, and Flexfield tables.