Search Results no_default_at_type




Overview
Explore in AI Chat

Overview

PAY_LINK_INPUT_VALUES_PKG is the table handler package for the PAY_LINK_INPUT_VALUES_F entity within Oracle Payroll. Its stated purpose, documented in the package header, is "to interface with the entity while maintaining its data integrity." In business terms, the package manages the rows that associate a specific input value with an element link, thereby defining which input values are available on a given link, their effective dating, and the validation rules that apply when the link is processed during payroll runs.

The package was originally created in January 1994 by N. Simpson and is declared with AUTHID CURRENT_USER, executing with the privileges of the calling user. It is classified in ETRM as an OTHER API rather than a public transactional API, which indicates it is primarily intended for internal use by Oracle Payroll forms, concurrent processes, and dependent packages rather than as a formally supported integration interface.

Key Procedures and Functions

The package exposes nine documented procedures and functions. Their purposes are as follows:

  • CREATE_LINK_INPUT_VALUE — The procedure most commonly associated with this package. Its documented comment states it "creates link input values for a new link," meaning it inserts the association rows that attach input values to a newly defined element link.
  • UPDATE_ROW — Updates an existing link input value row, including its effective dates, element link, input value, costed flag, default, maximum and minimum values, and the warning-or-error indicator.
  • DELETE_ROW — Deletes a link input value row identified by its rowid.
  • LOCK_ROW — Acquires a row-level lock on a link input value record and validates the current column values, supporting optimistic concurrency control in the forms layer.
  • CHECK_REQUIRED_DEFAULTS — Validates that required default values are present for the link input values under consideration.
  • NO_DEFAULT_AT_TYPE — Determines whether a default has been defined at the input value type level, supporting default-resolution logic.
  • PARENT_DELETED — Handles cascading behavior when a parent record (such as the element link) is removed.
  • LINK_END_DATE — Manages or derives the end date associated with a link, supporting effective-date integrity.

Tables Accessed

The package operates against the following tables via APPS synonyms:

  • PAY_LINK_INPUT_VALUES_F — The primary entity table holding the link input value definitions; the insert, update, delete, and lock operations act on this table.
  • PAY_LINK_INPUT_VALUES_S — The corresponding date-tracked (surrogate/effective date) table, maintained in parallel to preserve effective-dating history.
  • PAY_ELEMENT_LINKS_F — Read to validate and resolve the parent element link referenced by X_Element_Link_Id.
  • PAY_INPUT_VALUES_F — Read to resolve and validate the input value referenced by X_Input_Value_Id and to support default-value checks.

Usage Notes

PAY_LINK_INPUT_VALUES_PKG is invoked primarily from the Oracle Payroll element link maintenance forms, where it backs the create, update, delete, and lock operations performed by the user interface. It is also called from concurrent processes and from other PL/SQL packages; ETRM records that the package is referenced by five other packages, meaning customizations should avoid modifying the package signature.

Because the package is classified as OTHER rather than a public API, direct calls from custom code are not recommended for supported integrations. Where custom logic must manipulate link input values, the preferred approach is to operate through the supported element link APIs or to invoke CREATE_LINK_INPUT_VALUE in strict accordance with Oracle's documented behavior, while respecting effective dating across both the _F and _S tables.