Search Results create_eit

Overview

HR_REGISTER_EITS is a public PL/SQL package in the APPS schema that provides a programmatic registration interface for Extra Information Types (EITs) in Oracle E-Business Suite. An EIT is a configurable extension to a standard Oracle HRMS entity—such as a person, assignment, job, position, organization, location, or payroll element—that allows an implementation to capture customer-specific attributes without altering the underlying base tables. The package exists to automate the creation of the descriptive Flexfield-based EIT definition and its associated context, which would otherwise require manual configuration steps through the application forms.

The package is classified in ETRM as OTHER (a general-purpose API rather than a full business-object API). Its sole documented entry point, CREATE_EIT, encapsulates the DML required to make an EIT available for data entry across multiple HRMS entities. The package is owned by APPS and, per the ETRM metadata, is not referenced by any other package, indicating that it is intended primarily for external invocation from concurrent programs, installation scripts, or custom code rather than internal dependency chains.

Key Procedures and Functions

The metadata documents one procedure:

• CREATE_EIT — Registers a new Extra Information Type by supplying the target entity (table name), the developer name of the information type, an active flag, a multi-row indicator, optional legislation code, a description, an organization class, and optional category and sub-category codes. Additional optional parameters control authorization requirements, a warning period, and the owning application identifier. The procedure follows the standard Oracle concurrent-program API contract, returning errbuf and retcode OUT parameters so that callers can interpret success or failure and surface a user-readable message. No other procedures or functions are exposed by this package.

Tables Accessed

The package writes to the family of EIT registration tables, one per supported HRMS entity. These include HR_ORG_INFO_TYPES_BY_CLASS, HR_LOCATION_INFO_TYPES, PER_ASSIGNMENT_INFO_TYPES with its translation table PER_ASSIGNMENT_INFO_TYPES_TL, PER_CONTACT_INFO_TYPES with PER_CONTACT_INFO_TYPES_TL, and PER_JOB_INFO_TYPES. It also supports benefit and compensation entities through BEN_ABR_INFO_TYPES, BEN_ELP_INFO_TYPES, BEN_LER_INFO_TYPES, BEN_OPT_INFO_TYPES, BEN_PGM_INFO_TYPES, and BEN_PL_INFO_TYPES, and payroll entities through PAY_ELEMENT_TYPE_INFO_TYPES.

Reference tables such as FND_LANGUAGES supply the installed language rows needed for translation (TL) inserts, ensuring the EIT description is available in every enabled language. The procedure resolves the destination table from the p_table_name argument and directs the insert accordingly. Because the EIT definition drives a Descriptive Flexfield context, these rows must exist before any application form or self-service page can display the new information type.

Usage Notes

CREATE_EIT is typically invoked from a concurrent program or a one-off setup script during an implementation, upgrade, or patching exercise, allowing EITs to be defined reproducibly rather than manually. Callers must supply a valid target table name, a unique information type name, and the organization class; legislation, category, and sub-category values should be consistent with the flexfield structure already configured for the target entity. Because the procedure commits DML and returns errbuf/retcode, it should be called with the standard concurrent-program error-handling pattern and, where multiple EITs are created, invoked sequentially with careful checking of the return code. It is not referenced by other packages, so there is no internal call path to consider. Testing in a non-production instance is recommended, as incorrect table or entity combinations can produce orphaned or unusable flexfield contexts.