Search Results per_jp_validations




Overview
Explore in AI Chat

Overview

APPS.PER_JP_VALIDATIONS is a Japan-specific validation package within the Oracle E-Business Suite Human Resources (Oracle HRMS) product family. It is owned by the APPS schema and is classified as an OTHER API in the ETRM metadata for releases 12.1.1 and 12.2.2. The package header declares AUTHID CURRENT_USER, meaning execution privileges are evaluated against the invoking schema rather than the defining schema, a common pattern for utility validation libraries that are called from multiple entry points.

The package provides reusable, stateless validation routines for data elements that are unique to Japanese localization requirements. These include character-set and pattern validation, Japanese date formatting, district code integrity and existence, organization and organization class existence, half-width kana checking, and vehicle allocation validation. The header comment carries a legacy revision identifier (pejpvald.pkh 115.6), indicating the package has been stable since the early 2000s and is carried forward relatively unchanged into the 12.x code lines.

Key Procedures and Functions

  • CHECK_FORMAT — Validates an input string against a caller-supplied format mask and returns a result indicator. The header documents the mask characters: 0 and 9 for mandatory and optional numeric characters; A and P for mandatory and optional uppercase alphabetic characters; a and p for mandatory and optional lowercase alphabetic characters; L and C for mandatory and optional uppercase alphanumeric characters; and l and c for mandatory and optional lowercase alphanumeric characters.
  • CHECK_DATE_FORMAT — Validates a date value against a specified format pattern, supporting Japanese date conventions used in HRMS data entry.
  • DISTRICT_CODE_CHECK_DIGIT — Computes and returns the check digit for a Japanese district code. This supports integrity verification of address and registration data.
  • DISTRICT_CODE_EXISTS — Verifies that a given district code exists in the Japanese address lookup data. An optional parameter controls whether the check digit is also validated.
  • ORG_EXISTS — Determines whether an organization exists for a given business group, effective date, organization identifier, and organization class.
  • CHECK_HALF_KANA — Validates that an input value consists of half-width katakana characters, a frequent requirement for Japanese name and address fields.
  • VEHICLE_EXISTS — Checks the existence of a vehicle allocation record for a business group, assignment, effective date, and vehicle allocation identifier.

Tables Accessed

Usage Notes

PER_JP_VALIDATIONS is a server-side validation library rather than a business transaction API. It does not commit data; its functions return indicator values that calling code interprets. It is typically invoked from Oracle Forms personalizations and validations within Japanese HRMS windows, from concurrent programs that load or verify Japanese employee and address data, and from custom PL/SQL that must enforce Japanese format and district code rules before insert or update. The package is referenced by one other documented package, confirming its role as a shared dependency. Because the functions are pure validation routines with restricted references, they are safe to call repeatedly within a session. Release differences between 12.1.1 and 12.2.2 are not reflected in the documented metadata; the signature set is identical across both.