Results for “fnd_language”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.HR_ACCRUAL_PLAN_TL package body provides the multilingual (translation) maintenance layer for absence accrual plans in Oracle E-Business Suite human resources. Accrual plans define how absence balances such as vacation, sick leave, and personal time accrue over time, and each plan carries a user-facing name and description. Because these attributes must be presented to end users in their own language, Oracle stores them in the translation table PAY_ACCRUAL_PLANS_TL rather than in the base PAY_ACCRUAL_PLANS table. This package encapsulates the DML required to insert, update, and delete translated rows, to propagate rows to every installed language, and to validate the integrity of those translations. It is classified in ETRM as a non-API (OTHER) package, meaning it is an internal helper used by the translation framework rather than a published integration interface. The header perpaptl.pkb 120.0.12020000.2 confirms the object is delivered in the 12.1.1 through 12.2.2 code lines and is owned by the APPS schema.

Key Procedures and Functions

• INS — Inserts a new translated row into PAY_ACCRUAL_PLANS_TL for the specified accrual plan, seeded across all installed or base languages returned by FND_LANGUAGES. A NOT EXISTS guard prevents duplicate rows for a plan/language combination, making the procedure safe to re-run. The plan name and optional description are written at this point.
• UPD — Updates the description of an existing translated row, setting source_lang to the current session language (USERENV('LANG')). The update is restricted to rows whose language or source_lang matches the logged-in language, preventing a user from overwriting a translation they are not entitled to maintain.
• DEL — Removes all translated rows for a given accrual plan identifier. Because translations are language-scoped, this deletes the entire translation set for the plan rather than a single language row.
• ADD_LANGUAGE — The standard multilingual seeding routine. It first deletes orphaned translation rows that no longer have a matching row in PAY_ACCRUAL_PLANS, then copies the plan name and description from the source-language row to rows for each newly installed language, keeping the translation table synchronized when a new language is added to the instance.
• VALIDATE_TRANSLATIONS — Verifies that translation rows are complete and consistent for each defined language, supporting the translation verification framework.

Tables Accessed

• PAY_ACCRUAL_PLANS_TL — The primary target of all insert, update, delete, and language-propagation operations; stores language-specific accrual plan name and description.
• FND_LANGUAGES — Read during INS to enumerate the languages whose installed_flag is 'I' (installed) or 'B' (base), driving row population for every active language.
• PAY_ACCRUAL_PLANS — Referenced by ADD_LANGUAGE (and validation) as the base, language-independent plan table; orphan deletion and source-language copying depend on it.

Usage Notes

This package is not intended for direct customer invocation. It is invoked indirectly whenever accrual plans are created or maintained through the Oracle HRMS absence management forms, and it is reached by the generic multilingual seeding infrastructure that calls ADD_LANGUAGE when a new language is installed or patched. The related table PAY_ACCRUAL_PLANS_TL is the object users typically search for as pay_accrual_plans_tl; because it is registered in the translation framework, sites extending Oracle should use the seeded translation APIs or the DDF (document definition file) rather than inserting into the table directly, so that source_lang and language coverage remain valid. ETRM records show the package is referenced by one other package, consistent with its role as a subordinate translation helper.