Results for “hr_jp_general_pkg”

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

Overview

APPS.HR_JP_GENERAL_PKG is a Japanese localization utility package within the Oracle E-Business Suite Human Resources (HRMS) module. Its principal role is to centralize reusable logic required by Japanese statutory reporting, address formatting, and organization-derived descriptive data. The package header, identified by the CVS revision string hrjpgen.pkh 115.5, declares the unit with AUTHID CURRENT_USER, meaning executing privileges are resolved against the invoking schema rather than the definer. This design is consistent with ETRM classification of the object as OTHER rather than a formal public API, indicating it primarily supports internal processing and dependant packages rather than being a standalone integration endpoint. The package returns formatted Japanese character data, session-aware dates, and lookup-derived text used in legal and payroll extracts. Originally shipped in the 11i era and carried forward into EBS 12.1.1 and 12.2.2, the logic remains largely unchanged, though the pragma RESTRICT_REFERENCES directives visible in the source are now inert in modern PL/SQL compilers.

Key Procedures and Functions

• GET_SESSION_DATE — Returns the effective session date by querying FND_SESSIONS, allowing callers to align processing with the user's current application session rather than the server clock. This is the function associated with the search term "get_session_date."
• DECODE_ORG — Accepts an organization identifier and returns the corresponding descriptive name for display or reporting.
• DECODE_DISTRICT — Translates a Japanese district code into its human-readable description.
• GET_ADDRESS — Retrieves a formatted address string for a given person, address type, and effective date.
• GET_DISTRICT_CODE — Returns the district code associated with a person's address at a specified effective date.
• RUN_ASSACT_EXISTS — Evaluates whether a payroll assignment action exists for a given assignment and element set within optional validation and effective date ranges.
• GET_ORG_SHORT_NAME — Produces the short name of an organization unit for compact display contexts.
• DATE_TO_JP_CHAR — Converts a DATE value into a Japanese-formatted character representation, supporting era- and locale-specific output.
• DECODE_VEHICLE — Decodes vehicle allocation information into a descriptive label.

Tables Accessed

The package reads from FND_SESSIONS to resolve session dates, and from HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, and HR_ORGANIZATION_INFORMATION to derive organization names and short names. Address processing depends on PER_ADDRESSES and the Japanese-specific lookup PER_JP_ADDRESS_LOOKUPS, while PER_TIME_PERIODS supports date-range logic. Payroll and assignment checks query PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_SETS, and PAY_PAYROLL_ACTIONS. Vehicle decoding uses PQP_VEHICLE_ALLOCATIONS_F and PQP_VEHICLE_REPOSITORY_F. DUAL is referenced for scalar evaluation. All access is performed through APPS synonyms.

Usage Notes

HR_JP_GENERAL_PKG is referenced by seven other packages, reflecting its role as a shared localization library. It is typically invoked from Japanese HRMS forms (for example, address and organization display blocks), from concurrent programs that generate Japanese statutory reports, and from custom PL/SQL where consistent Japanese formatting or session-aware dating is required. Because it is classified as OTHER and carries no documented API contract, developers should treat its signatures as stable-but-internal and avoid building external integrations directly against it; the safest practice is to call it only from within the APPS schema or from objects that already depend on the HRMS Japanese localization set.