Search Results validate_between_dates

Overview

APPS.HR_GENERAL_UTILITIES is a shared PL/SQL utility package in the Oracle E-Business Suite HRMS (Human Resources) schema. It is defined with AUTHID CURRENT_USER and is intended to be invoked from within other packages rather than directly as a standalone entry point. Its header comment explicitly states that the package must not contain print calls (to htp.p or procedures that invoke it, or any JavaScript alerts), and that errors must be raised as exceptions to be handled by the calling package. The package was assembled in part from earlier web utility packages, including hr_util_web and per_cm_util_web, and retains the original header comments for cross-referencing. It provides generic helper capabilities such as record type definitions, date conversion and validation, lookup-meaning resolution, string manipulation, and person-record retrieval used broadly across HRMS web and self-service flows.

Key Procedures and Functions

The package exposes 41 documented procedures and functions. The most frequently searched entry point is GET_PERSON_RECORD, which retrieves a person record from the PER_ALL_PEOPLE_F table, returning person details into the g_person_details_rec_type record structure (last name, first name, full name, middle names, previous last name, and related attributes). GET_PERSON_DETAILS complements this by returning person detail information, and GET_BUSINESS_GROUP supplies the current business group context.

General-purpose utilities include RESET_GLOBALS, which reinitializes package-level global variables; IFNOTNULL, which conditionally substitutes a value when the input is null; and SUBSTITUTE_VALUE, which performs value substitution. Date handling is served by DATE2CHAR and CHAR2DATE for conversions, ISDATEVALID for format validation, VALIDATE_BETWEEN_DATES for range checks, and FORCE_DATE_FORMAT for applying a consistent date format. Lookup support is provided by GET_LOOKUP_MEANING, GET_LOOKUP_VALUES, and DOLOOKUPSEXIST. Metadata-oriented routines include GET_COLUMN_DATA and USE_MESSAGE. String utilities include ADD_SEPARATORS and LOCATE_ITEM_IN_SEPARATED_STR for delimiter-based text processing, and SCRIPTOPEN and SCRIPTCLOSE for script block handling.

Tables Accessed

The package references several underlying objects through APPS synonyms. PER_ALL_PEOPLE_F is the primary person datastore, read to populate person record and person detail structures. ALL_TAB_COLUMNS supports GET_COLUMN_DATA, which inspects column precision and datatype metadata (mirrored in the r_column_data_rec type). WF_ITEMS is accessed in the context of workflow item lookup. The package also calls DBMS_SQL for dynamic SQL, HTP for web output generation (despite the header restriction against direct print calls, helper routines may reference it), and PLITBLM for table-based lookup handling.

Usage Notes

This package is a foundational utility that is referenced by roughly 20 other packages. It is typically invoked indirectly through HRMS self-service pages, Oracle Forms, and custom PL/SQL extensions that require standardized person lookups, date parsing, or lookup-meaning resolution. Because errors are expected to propagate as exceptions, callers must implement their own exception handling and output rendering. Customizations that call GET_PERSON_RECORD should treat the returned record as read-only and avoid embedding direct htp.p calls in dependent code, consistent with the package's documented design constraints across EBS 12.1.1 and 12.2.2.