Search Results create_es_cwk

Overview

PER_ES_CREATE_CWK is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. The ES component of its name reflects its association with the Spanish (España) localization of Oracle Human Resources, and the CWK suffix identifies it as a utility responsible for generating or maintaining a "create work" (creation) structure, typically a payroll or statutory reporting construct required by Spanish legislative rules. Its API classification is OTHER, meaning it is not registered as a public, versioned HRMS interface such as the HR_API family; it is a supporting internal routine leveraged by other Spanish localization components. The package is documented as VALID in both ETRM 12.1.1 and 12.2.2 metadata, and it is referenced by exactly one other database object, indicating that it sits near the top of a narrow dependency chain rather than acting as a broadly called utility. Itself, it depends on the HRMS foundation layer — HR_API, HR_ES_UTILITY, HR_GENERAL, HR_LOOKUPS, and HR_UTILITY — which confirms that its logic is HR-focused and that it honors standard HRMS date-tracking and lookup conventions.

Key Procedures and Functions

ETRM documents a single program unit within this package body:

• CREATE_ES_CWK — The sole documented procedure. Its name indicates that it creates the Spanish "CWK" record or structure. Based on the package's HR localization context, it produces the localized statutory artifact required for Spanish HR and payroll reporting, drawing the employee-level data needed for that artifact and persisting the resulting construct. Because no parameter list is documented in the ETRM metadata, no signature should be assumed; callers should treat it as an internal entry point rather than a public API.

No functions are documented for this package. The absence of a registered API name and the presence of a single procedure reinforce that this is a private, purpose-built routine rather than a reusable interface.

Tables Accessed

The documented table reference is PER_ALL_PEOPLE_F, accessed through an APPS synonym. This is the core, date-effective employee record in Oracle HRMS, and its use confirms that CREATE_ES_CWK reads person-level data — such as employee identifiers and effective-dated attributes — as the input to the Spanish CWK creation logic. Because the package delegates most work to HR_API, HR_ES_UTILITY, and HR_UTILITY, additional data manipulation may occur inside those routines; however, only PER_ALL_PEOPLE_F is documented as directly referenced by this package body. No inserts, updates, or deletes are documented at this level, so the package's write behavior should be assessed by reviewing the dependent code.

Usage Notes

PER_ES_CREATE_CWK is not referenced by any database object per the ETRM dependency listing, and it is referenced by one other package. This pattern indicates it is invoked from within a sibling Spanish localization package rather than exposed directly to forms, concurrent programs, or user-facing flows. Typical invocation scenarios include Spanish statutory reporting processes that must assemble a CWK structure from PER_ALL_PEOPLE_F data before submission, executed as an internal step of a larger localized routine. Because it relies on HR_GENERAL and HR_LOOKUPS, callers should ensure that HR security profiles, business group context, and the FND_PROFILE settings that the package consults are correctly initialized before invocation. Custom code should not call CREATE_ES_CWK directly unless the caller reproduces the initialization performed by the referencing package; dependency on HR_API further implies that the standard HRMS API validation and date-tracking rules are enforced during execution. In 12.2.2 the object remains VALID, so no remediation is required for online patching compatibility.