Search Results get_legislation_code




Overview
Explore in AI Chat

Overview

APPS.PAY_SEED_SOE_PKG is a seed data maintenance package in the Oracle E-Business Suite Payroll (PAY) module. Its sole documented procedure, UPDATE_PROFILE, manages the configuration state of the Statement of Earnings (SOE) display option — specifically the ONLINE_SOE field — on a per-legislation basis. The package writes to PAY_LEGISLATIVE_FIELD_INFO, which governs how legislative fields behave at runtime within Oracle Payroll forms and self-service pages. In effect, the package is a controlled seeder: it toggles or inserts the DISPLAY rule that determines whether the online Statement of Earnings is presented to users for a given legislation and business group.

The object header (paysesoe.pkb 120.0, dated 2005) indicates it is a long-standing shipped component, and the seed/configuration nature of its work is consistent with that lineage. Application, not end-user, invocation is implied throughout.

Key Procedures and Functions

Only one procedure is documented in the ETRM metadata:

  • UPDATE_PROFILE — Accepts a business group identifier and an action indicator, resolves the associated legislation, reads the current DISPLAY rule mode for ONLINE_SOE, and either updates the existing rule or inserts a new one so that the rule mode reflects the requested action. It returns the standard EBS concurrent-style errbuf and retcode OUT parameters, signalling that it is designed to be callable from a concurrent program or a host wrapper.

No functions are documented, and the package exposes no public API beyond this procedure. The limited surface area reflects its single, narrowly scoped purpose.

Tables Accessed

  • PER_BUSINESS_GROUPS — Read to derive the legislative code from the supplied business group identifier. This is the lookup step that anchors all subsequent work to a specific legislation.
  • PAY_LEGISLATIVE_FIELD_INFO — Both queried and written. The procedure inspects the existing row for field_name = 'ONLINE_SOE' and rule_type = 'DISPLAY' to determine whether the rule is already present, then updates its rule_mode or inserts a fresh row as needed. Values are encoded in the conventional EBS style: 'Y' for ENABLE and 'N' for DISABLE.
  • DUAL — Used as the source for the INSERT ... SELECT construction, a standard PL/SQL idiom for single-row inserts with derived literals.

The metadata lists PER_BUSINESS_GROUPS implicitly through the get_legislation_code cursor, alongside the two documented references PAY_LEGISLATIVE_FIELD_INFO and DUAL.

Usage Notes

The package is invoked when an administrator or implementation team needs to change whether the online Statement of Earnings is displayed for a particular business group's legislation. Typical triggers include:

  • Concurrent program submission during implementation or configuration of Oracle Payroll, where the procedure is called with a business group ID and an action of ENABLE or DISABLE.
  • Seed or patching scripts that must reconcile legislative field configuration across environments.
  • Custom deployment scripts written by implementation partners that call the packaged procedure directly to align SOE visibility with local statutory requirements.

Because the package is owned by APPS and classified as OTHER, direct invocation from custom code is technically possible but should follow Oracle's supported patterns — passing valid business group IDs and accepted action strings. The procedure is idempotent in intent: repeated calls with the same action leave the configuration unchanged, while a differing action updates or inserts the appropriate row. No other packages in the documented metadata reference this object, confirming that it is a leaf-level configuration utility rather than a shared library.

The searched token get_legislation_code corresponds to a private cursor within UPDATE_PROFILE rather than a public API; it is not directly callable from outside the package body.