Search Results create_us_employee

Overview

GHR_EMPLOYEE_API is an Oracle EBS public API package body owned by the APPS schema and classified as an API within the ETRM repository. In Oracle EBS 12.1.1 and 12.2.2, it exists to provide a programmatic, validation-aware interface for employee record creation and maintenance, sitting in front of the Human Resources (HR) and Oracle Human Resources Management System (HRMS) base tables rather than requiring direct DML. The package originated in the legacy Oracle HRMS "GHR" naming convention and is retained for backward compatibility with earlier releases of the HRMS APIs.

The package body carries an internal package-level variable, g_package varchar2(33), which is initialized with the string 'ghr_employee_api.' and is used throughout the body to prefix error and message text. The header comment (ghempapi.pkb 115.5 2003/01/30) indicates the package body has been stable since the early 2000s, so its behavior is consistent across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

Only one procedure is documented for this package body: CREATE_US_EMPLOYEE.

• CREATE_US_EMPLOYEE — Creates a United States employee record. It accepts a hire date, business group, name components, sex, and person type, plus a broad set of optional US-specific attributes covering personal details (date of birth, marital status, nationality, Social Security number, previous last name, registered disabled flag, title), contact details (email address, work telephone, expense check send-to address), vendor linkage, and descriptive flexfield segments (attribute category and attributes 1 through 11). The employee number (p_employee_number) is an IN OUT NOCOPY parameter, allowing the API to generate or return the assigned number to the caller. A p_validate boolean defaults to FALSE, enabling callers to roll back the creation when only validation is required.

Tables Accessed

The ETRM metadata does not enumerate the specific base tables referenced through APPS synonyms, and the excerpt provided does not expose the internal INSERT or cursor bodies. Based on the procedure's declared parameters and standard HRMS API design, the procedural logic operates on the core HR person and employee entities — the PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F family — with the descriptive flexfield values supporting the corresponding attribute columns. Callers should treat all writes as indirect and routed through the API rather than issued directly against those tables.

Usage Notes

CREATE_US_EMPLOYEE is typically invoked from custom PL/SQL, Oracle Forms personalizations, or concurrent programs that must create US employees without going through the standard HR forms. Because the procedure exposes p_validate, it is commonly called twice in a validation-then-commit pattern: once with p_validate => TRUE to confirm that the supplied data passes the API's business rules, and again with p_validate => FALSE to persist the record.

ETRM reports zero packages referencing this one, so it is a leaf-level dependency used only by external (customer) code. A single documented procedure also means customizations should route all employee creation through this API rather than performing direct inserts on HR tables, preserving validation and audit behavior across 12.1.1 and 12.2.2.