Search Results check_line_no
Overview
PAY_PAYWSDAS_PKG is an Oracle EBS Application Object Library package owned by APPS and classified as OTHER in the ETRM 12.2.2 repository. The acronym PAY_PAYWSDAS denotes "Payroll — Payroll Work Structures — Assignment Sets," and the package supplies the server-side validation and maintenance logic underpinning the Assignment Set and formula-driven criteria functionality in Oracle Payroll. In 12.1.1 and 12.2.2, assignment sets are the mechanism by which payroll administrators group assignments for processing, and the criteria that define those groups can be expressed as Fast Formula rules. PAY_PAYWSDAS_PKG therefore mediates between the HR assignment set tables and the Oracle Fast Formula dictionary (FF_FORMULAS_F, FF_FORMULA_TYPES, FF_DATABASE_ITEMS), providing the PL/SQL logic that forms call when users create, amend, or remove formula-based assignment set criteria.
Key Procedures and Functions
The package declares fifteen documented entry points. GET_FORMULA_TYPE and GET_FORMULA_ID resolve the formula definition associated with an assignment set, returning the formula type identifier and the active formula identifier respectively. GET_ASSIGNMENT_SETS_S returns the assignment set sequence value used for key generation, while GET_MIN_MAX_LINE returns the lowest and highest line numbers currently defined for an assignment set, information used during criteria maintenance. NO_CRITERIA_EXISTS is a boolean check that determines whether any criteria have been defined for an assignment set. The CHECK_AMENDMENT_EXISTS, CHECK_UNQ_AMENDMENT, and CHECK_AMD_INC_EXC procedures enforce integrity rules around assignment set amendments, including uniqueness of amendment definitions and mutual exclusivity of include/exclude flags. CHECK_INCLUDE_EXCLUDE validates the include/exclude indicator for a criteria row, and CHECK_CRITERIA_EXISTS verifies that criteria exist for a given assignment set and line. CHECK_OPERAND validates a formula operand against business group, legislation, formula type, and data type, ensuring operands conform to the Fast Formula dictionary. CHECK_UNIQUE_NAME enforces uniqueness of an assignment set name per business group, formula type, and legislation. CHECK_LINE_NO validates line numbering within an assignment set. DELETE_FORMULA — the object of the user's search — removes the formula definition associated with an assignment set when criteria are deleted or redefined. FETCH_DBI_INFO retrieves database item information for a given assignment set, formula type, and operand value, replacing the legacy FF_DATABASE_ITEMS query path.
Tables Accessed
The package reads and writes Oracle Fast Formula dictionary tables including FF_FORMULAS_F, FF_FORMULA_TYPES, FF_FTYPE_CONTEXT_USAGES, FF_DATABASE_ITEMS, FF_DATABASE_ITEMS_TL, FF_ROUTES, FF_ROUTE_CONTEXT_USAGES, and FF_USER_ENTITIES, which together provide formula definitions, type metadata, and the database items available as operands. It also accesses the HR assignment set tables HR_ASSIGNMENT_SETS, HR_ASSIGNMENT_SETS_S, HR_ASSIGNMENT_SET_AMENDMENTS, and HR_ASSIGNMENT_SET_CRITERIA, which hold the set header, key sequence, amendment records, and criteria lines respectively. DUAL is used for singleton queries.
Usage Notes
PAY_PAYWSDAS_PKG is not referenced by any other documented package, indicating it is invoked directly from the Assignment Sets form (typically the "Define Assignment Sets" window in Oracle Payroll and the associated criteria/fast formula LOVs) and from related concurrent or maintenance programs rather than from a public PLS API layer. The DELETE_FORMULA procedure is called during criteria deletion, when a user removes a formula-driven criterion from an assignment set and the system must clean up the underlying formula definition. Custom code should not call this package directly; instead, use supported APIs or the form to manage assignment sets, because the package relies on AUTHID CURRENT_USER semantics and assumes APPS schema privileges.