Search Results hr_assignment_sets_s




Overview
Explore in AI Chat

Overview

APPS.PAY_PAYWSDAS_PKG is a payroll package body classified under the ETRM API taxonomy as OTHER. The object name and its dependency footprint indicate that it supports the Assignment Set definition and maintenance features of Oracle Payroll, specifically the functionality exposed through the Web/Professional Forms-based "Assignment Set" (WSDAS) user interface. An assignment set is a named grouping of assignments, defined either by direct inclusion/exclusion or by criteria, that payroll processes use to restrict the population of employees processed by a run, a report, or a batch element entry operation.

The package body is not a public API: it is not referenced by any other database object, and its consumers are the OAF/Forms layers that drive the assignment set maintenance and formula-route association screens. Its role is to encapsulate the validation, lookup, and deletion logic that those screens require, spanning both the HR assignment set tables and the FastFormula metadata tables.

Key Procedures and Functions

The documented interface comprises fifteen procedures and functions:

  • GET_FORMULA_TYPE — Retrieves the formula type associated with a formula, driving context and route selection logic.
  • GET_FORMULA_ID — Resolves the surrogate formula identifier for a given formula definition.
  • GET_ASSIGNMENT_SETS_S — Returns the assignment set summary record from HR_ASSIGNMENT_SETS_S; this is the routine most directly relevant to the search term "hr_assignment_sets_s".
  • GET_MIN_MAX_LINE — Determines the minimum and maximum line numbers used within an assignment set, typically to allocate the next sequence number for a new criteria or amendment line.
  • NO_CRITERIA_EXISTS — Boolean check indicating that an assignment set has no criteria rows defined.
  • CHECK_AMENDMENT_EXISTS — Verifies whether amendment records exist for a given assignment set.
  • CHECK_UNQ_AMENDMENT — Validates the uniqueness of an amendment entry.
  • CHECK_AMD_INC_EXC — Validates amendment inclusion/exclusion indicators.
  • CHECK_INCLUDE_EXCLUDE — Enforces consistency of the include/exclude flag on set definitions.
  • CHECK_CRITERIA_EXISTS — Confirms the presence of criteria rows.
  • CHECK_OPERAND — Validates the operand used within a criterion expression.
  • CHECK_UNIQUE_NAME — Ensures the assignment set name is unique within the business group.
  • CHECK_LINE_NO — Validates line numbering for criteria and amendment sequencing.
  • DELETE_FORMULA — Removes a formula association, including dependent route and context usage records.
  • FETCH_DBI_INFO — Retrieves FastFormula database item information for criteria-driven assignment set definitions.

No parameter lists are documented in the ETRM extract and are therefore not restated here.

Tables Accessed

The package reads and writes the HR assignment set tables: HR_ASSIGNMENT_SETS, HR_ASSIGNMENT_SETS_S (the summary table referenced by the user's search), HR_ASSIGNMENT_SET_AMENDMENTS, and HR_ASSIGNMENT_SET_CRITERIA. These hold the set header, its translated/summary row, amendment history, and the criteria that define dynamic membership.

On the FastFormula side it accesses FF_FORMULAS_F, FF_FORMULA_TYPES, FF_FTYPE_CONTEXT_USAGES, FF_ROUTES, FF_ROUTE_CONTEXT_USAGES, FF_USER_ENTITIES, FFDICT, FF_DATABASE_ITEMS, and FF_DATABASE_ITEMS_TL, with FF_DBI_UTILS_PKG used as a helper. FND_MESSAGE supplies translatable error and warning text. PER_BUSINESS_GROUPS_PERF and DUAL complete the dependency list.

Usage Notes

PAY_PAYWSDAS_PKG is invoked from the Payroll assignment set maintenance forms and associated OAF pages, where it performs server-side validation before insert or update. Because ETRM records no inbound package references, it should be treated as an internal implementation package rather than a supported integration point. Custom code requiring assignment set data should query HR_ASSIGNMENT_SETS_S directly or use the documented HR Assignment Set APIs, and should not depend on the internal signatures or behaviour of this package, which may change between 12.1.1 and 12.2.2 maintenance levels.