Search Results pay_link_input_values_pkg




Overview
Explore in AI Chat

Overview

PAY_LINK_INPUT_VALUES_PKG is an Oracle EBS Payroll (PAY) package body owned by the APPS schema. It encapsulates the business logic that governs link input values — the values assigned to input values of an element link between a payroll element and a specific organization, assignment set, or other link criterion. Element links determine where a payroll element is available and how its inputs default or are constrained; the link-level input values stored by this package therefore control the configuration of payroll processing at the link granularity. The package is classified as an OTHER API in ETRM 12.2.2, indicating it is a supporting form-driven package rather than a public, fully supported PL/SQL API.

The package body is currently VALID and is not referenced by any other database object directly, though it participates in the broader payroll element-link data flow alongside the tables it maintains. Five other packages reference it in the documented dependency graph, confirming its role as a shared internal utility for link input value maintenance.

Key Procedures and Functions

  • DELETE_ROW — Removes a link input value record from the underlying table, supporting the deletion of link-level input value configuration.
  • LOCK_ROW — Issues a locking read against the target row, ensuring concurrency control when a form or caller is about to modify an existing link input value.
  • UPDATE_ROW — Persists changes to an existing link input value record, applying the modified attributes back to the database.
  • CREATE_LINK_INPUT_VALUE — Inserts a new link input value, establishing the relationship between an element link and one of its input values.
  • CHECK_REQUIRED_DEFAULTS — Validates that required default values are present and consistent for the link input value being processed.
  • NO_DEFAULT_AT_TYPE — Determines or enforces that no default value applies at the type (element type) level, differentiating link-level behaviour from element-type-level defaults.
  • PARENT_DELETED — Handles cascading logic when the parent element link is deleted, cleaning up associated link input values.
  • LINK_END_DATE — Manages or validates the end date of the associated element link, which bounds the effective period of the input value.

Tables Accessed

  • PAY_LINK_INPUT_VALUES_F — The primary table this package maintains; stores the link-level input value records created, updated, and deleted by the procedures above.
  • PAY_LINK_INPUT_VALUES_S — The corresponding sequence used to generate primary keys for new link input value rows.
  • PAY_INPUT_VALUES_F — Holds the input value definitions referenced by link input values, providing validation context.
  • PAY_ELEMENT_LINKS_F — Holds the parent element link records whose existence and dates constrain link input values.

All access is performed through APPS synonyms, with supporting calls to HR_API, HR_GENERAL, HR_UTILITY, FND_MESSAGE, and APP_EXCEPTION for validation, error messaging, and exception handling.

Usage Notes

The package is typically invoked by the Oracle Payroll element link configuration forms, where users define and maintain element links and their associated input values. Because it is classified as an OTHER API and is not externally referenced, it should be treated as an internal implementation package: custom code should generally manipulate link input values through supported APIs or the standard forms rather than calling these procedures directly. The LOCK_ROW, UPDATE_ROW, and DELETE_ROW routines follow the conventional Oracle Forms server-side pattern for row-level operations, so the package is tightly coupled to form-based editing. Any direct invocation in custom code must respect the locking and valid default logic implemented in CHECK_REQUIRED_DEFAULTS and NO_DEFAULT_AT_TYPE to avoid corrupting element link configuration.