Results for “hr_de_org_info”

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

Overview

HR_DE_ORG_INFO is a German localization package in the Oracle E-Business Suite Human Resources (HRMS) module, delivered under the APPS schema with AUTHID CURRENT_USER privileges. Its purpose is to expose organization-level statutory and reporting data required by German payroll and workplace-incident legislation, particularly information tied to employer and payroll Betriebsnummern, chamber contributions, insurance providers, and liability association (Berufsgenossenschaft) details. The package acts primarily as a service layer consumed by views and other PL/SQL units rather than as a standalone user-facing API. In the HRMS localization architecture this package is classified as OTHER, indicating it is not a public or business-process API but a supporting utility that resolves organizational hierarchy context and retrieves stored German-specific attributes for an organization or assignment.

Key Procedures and Functions

• NAMED_HIERARCHY – Returns the current named hierarchy identifier for a given organization, establishing the structural context used by downstream lookups.
• LATEST_NAMED_HIERARCHY_VERS – Returns the current version of the named hierarchy for an organization, ensuring date-effective consistency.
• ORG_EXISTS_IN_HIERARCHY – Determines whether an organization belongs to the current primary hierarchy.
• CHK_FOR_ORG_IN_HIERARCHY – Procedural variant of the above membership check, returning existence through an output parameter.
• GET_ORG_DATA_ITEMS – Retrieves core German organization attributes: chamber contribution, employer Betriebsnummer, and payroll Betriebsnummer.
• GET_INSURANCE_PROVIDERS – Returns a PL/SQL table of insurance provider records (status, child organization, class of risk, membership number, name).
• GET_LIAB_PROV_DETAILS / GET_LIAB_PROV_NAME / GET_LIAB_PROV_MEMBERSHIP_NO – Return liability provider details, name, and membership number for an assignment, optionally filtered by incident date.
• GET_LIAB_PROV_DETAILS2 – Alternate/overloaded retrieval of liability provider information.
• GET_LOCATION, GET_ADDR_LINE1–3, GET_TOWN, GET_COUNTRY, GET_POSTAL_CODE – Address component accessors used to assemble formatted location information for an assignment.
• GET_SUPERVISING_OFF / GET_SUPERVISING_OFF_NAME – Return the supervising office and its name associated with an assignment.

Tables Accessed

The package reads HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION for organization definitions and descriptive attributes; HR_DE_ORGANIZATION_LINKS and HR_DE_ORGANIZATION_INFO_* structures for German localization data; PER_ORG_STRUCTURE_ELEMENTS and PER_ORG_STRUCTURE_VERSIONS for hierarchy membership and version resolution; and HR_SOFT_CODING_KEYFLEX for key flexfield segments. FND_SESSIONS is referenced for session context, and DUAL is used for scalar utility evaluations. All access is through APPS synonyms, and the package is read-only with respect to these objects.

Usage Notes

HR_DE_ORG_INFO is typically invoked indirectly. Its functions back the view HR_DE_WORK_INCIDENTS_REPORT, supplying liability provider, location, and supervising office columns to German workplace-incident reporting. Other packages (one documented referrer) call it to resolve organization hierarchy context. Because it is classified OTHER rather than a public API, Oracle does not guarantee interface stability; customizations should call it only with awareness of upgrade impact. It is not generally exposed through Oracle Forms or concurrent programs directly. When troubleshooting German localization reporting, verifying that organizations are linked to the correct named hierarchy and that insurance and liability provider records exist is the primary diagnostic path.