Search Results curr_emp_id

Overview

OKE_UTILS is a shared utility package in the Oracle E-Business Suite ETRM (Enterprise Contracts) module. It is classified as an OTHER API under the APPS schema and provides a centralized set of low-level helper functions used throughout the Oracle Contracts (OKE/OKC) code base. Rather than enforcing a single business transaction, the package supplies reusable primitives for employee and user resolution, Yes/No lookup values, contract number and item attribute retrieval, unique-value checking, organizational security context, and general-purpose debugging. Its scope is deliberately broad because it is referenced by 26 other packages, making it a foundational dependency for contract authoring, terms, and project-related processing.

Key Procedures and Functions

Twenty-four documented procedures and functions are exposed by OKC_UTILS. The user search term curr_emp_id maps directly to CURR_EMP_ID, one of the most frequently invoked utilities.

• CURR_EMP_ID – Returns the employee ID associated with the current FND user. It caches the result in package globals (G_Emp_ID, G_User_ID) to avoid repeated lookups, refreshing the cache only when the session user ID changes, and returns NULL on exception.
• CURR_EMP_NAME – Returns the full name of the current employee, complementing CURR_EMP_ID.
• YES_NO and SYS_YES_NO – Return localized Yes/No values, with SYS_YES_NO supplying the system-level equivalents.
• CHG_REQUEST_NUM – Retrieves a change request number used in contract change management.
• ITEM_NUMBER and ITEM_DESCRIPTION – Resolve inventory item number and description for contract lines.
• CHECK_UNIQUE – Performs a uniqueness validation against contract data.
• GET_LOCATION_DESCRIPTION – Returns a descriptive location string used on contract documents.
• GET_TERM_VALUES, GET_TERM_VALUE – Retrieve term values from contract terms tables.
• GET_USERENV_LANG – Returns the cached USERENV('LANG') language code.
• GET_K_CURR_FMT_MASK – Returns the current formatting mask (G_Fmt_Mask) to avoid repeated format lookups.
• SET_ORG_CONTEXT, ORG_ID, CROSS_ORG_ACCESS – Manage Multi-Org security context and report the active operating unit and cross-org access flag.
• ENABLE_DEBUG, DISABLE_DEBUG, DEBUG_MODE, DEBUG – Provide diagnostic tracing utilities used during development and support.

Tables Accessed

The package reads from a defined set of APPS synonyms: FND_USER for employee and user resolution; FND_LANGUAGES for language codes; PER_ALL_PEOPLE_F for employee names; HZ_LOCATIONS and HR_LOCATIONS_ALL for location descriptions; AP_TERMS, RA_TERMS, and ORG_FREIGHT for term and freight values; OKE_TERMS_B, OKE_K_TERMS, and OKE_K_HEADERS for contract terms and headers; OKC_K_HEADERS_B for contract header base data; MTL_SYSTEM_ITEMS for item number and description; PA_PROJECTS_ALL and PA_PROJECT_PARTIES for project-related context. These tables support the employee, item, term, location, and project lookups exposed by the functions above.

Usage Notes

OKE_UTILS is designed to be called after FND_GLOBAL.INITIALIZE so that user and org context are available. It is typically invoked from Oracle Forms, concurrent programs, and custom PL/SQL within the Contracts module, and its results are cached in package globals to reduce database round-trips. Because CURR_EMP_ID returns NULL on exception, callers should handle a NULL return defensively. The debug procedures are intended for controlled use, since they enable tracing that may impact performance if left active.