Search Results get_children_info




Overview
Explore in AI Chat

Overview

APPS.PER_HU_ABS_REP_ARCHIVE_PKG is a PL/SQL package in Oracle E-Business Suite (12.1.1 and 12.2.2) that supports absence reporting and archiving for a legislative/statutory reporting requirement, indicated by the "HU" identifier (Hungary). The package operates with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling schema. Its header comment ($Header: pehuarep.pkh 115.3) reflects legacy Oracle HRMS coding conventions. The package supplies the parameter resolution, range generation, and action-creation logic required by an Oracle Payroll-Based DateTrack or "Payroll Action" concurrent process that produces an absence report and archives the results. It also exposes helper functions for accrual plan validation, working-day counting, child/dependent data, and payroll period derivation, all of which are consumed while building the report's action parameters and while filtering the population of assignments to be processed.

Key Procedures and Functions

Thirteen documented program units exist; the metadata for GET_PAYROLL_PERIOD is excerpted, and the remaining are known by name only. Do not assume parameter lists beyond those shown.

  • GET_PARAMETER — Parses a token value out of the raw parameter string, used for ad-hoc parameter extraction.
  • GET_ABS_REP_PARAMETER — Returns the absence report parameter string associated with an action ID.
  • GET_ALL_PARAMETERS — Populates the core report parameters (business group, effective and reporting dates, payroll, assignment set, employee) from a payroll action ID.
  • RANGE_CODE — Generates the range code (SQL fragment) that defines the chunk of assignments processed by the action.
  • ACTION_CREATION_CODE — Creates the assignment actions for a range of persons handled in a given chunk.
  • GET_CHILDREN_INFO — Returns child/dependent counts and dates of birth for an assignment, used in absence eligibility.
  • GET_PAYROLL_PERIOD — Derives the payroll period relevant to a payroll and calculation date, and returns accrual frequency and multiplier.
  • WORKING_DAY_COUNT — Calculates working days between dates for absence duration calculations.
  • GET_PERSON_DOB — Retrieves a person's date of birth.
  • GET_PREV_EMP_SICKNESS_LEAVE — Retrieves prior sickness leave history.
  • GET_DISABILITY — Returns disability information relevant to the absence entitlement.
  • GET_JOB_INFO — Retrieves job information for the assignment.
  • CHK_ENTRY_IN_ACCRUAL_PLAN — Validates whether the assignment participates in an accrual plan.

Tables Accessed

Through APPS synonyms, the package reads foundational HR and Payroll entities: PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F (person/assignment data); PAY_PAYROLL_ACTIONS, PAY_ACTION_INFORMATION, and PAY_ASSIGNMENT_ACTIONS_S (action definition, parameter storage, and assignment action rows); PAY_ALL_PAYROLLS_F (payroll definition); HR_ASSIGNMENT_SETS and HR_ASSIGNMENT_SET_AMENDMENTS (population selection); HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION (business group/organization attributes); PAY_ACCRUAL_PLANS (accrual validation); and PAY_USER_TABLES, PAY_USER_COLUMNS, PAY_USER_COLUMN_INSTANCES_F, and PAY_USER_ROWS_F (the user-defined "flexfield" data the report and its parameters depend on). These are consistent with a payroll action that stores parameters as user-defined columns and selects an assignment set.

Usage Notes

The package is invoked by the absence report/archive concurrent program associated with the Hungarian legislative report area, and it is referenced by no other packages (0 inbound references). Because it is not a public API, it should not be called directly from custom code; instead, invoke the concurrent program or the payroll action that drives it. Database administrators may query it for diagnostics and for historical absence/accrual data. Customizations should avoid modifying the package body, as it is a seeded Oracle object subject to patch overwrite — use a separate custom package if additional logic is required.