Results for “get_eit_data_from_tt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PQP_GENERIC_EIT_SS is a database package body in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, residing in the APPS schema with a status of VALID. The package resides in the staffing application, which manages workforce scheduling, shift patterns, and the deployment of personnel and equipment to operational assignments. Its central purpose is to manage Generic Extra Information Types (EITs) associated with staffing-related entities—principally assignments, vehicles, and vehicle allocations. EITs in EBS provide a configurable, attribute-based extension mechanism that allows implementers to attach customer-specific data fields to standard entities without modifying the underlying schema. PQP_GENERIC_EIT_SS supports this capability by creating, populating, retrieving, and deleting EIT data through the HR API transaction framework. As an API classification of OTHER, the package is a supporting utility rather than a primary public interface, though it exposes callable procedures used by transactional and integration routines.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within the package:

• CREATE_GENERIC_EIT — Creates a generic EIT record for a staffing-relevant entity, establishing the structure and values required for an extra information type instance.
• SET_EXTRA_INFO — Writes or updates the attribute values held in a generic EIT, allowing application logic to populate EIT fields at runtime.
• GET_EIT_DATA_FROM_TT — Retrieves EIT data from a PL/SQL table type (PLITBLM), providing a mechanism to return multiple EIT attribute values to the caller in bulk.
• DEL_TRANSACTION_DATA — Removes transaction-related data, typically cleaning up staging or intermediate records once an HR API transaction has completed or been superseded.
• PROCESS_API — Drives the HR API transaction processing flow, coordinating the creation, update, or deletion of EIT information as a single transactional unit.
• CLEAR_DELETE_TRANS — Clears delete-transaction state, ensuring that pending delete operations are handled and residual transaction markers are removed.

No parameter signatures are documented; the procedures operate through the HR API transaction framework and are intended for use alongside the transaction API rather than as standalone query calls.

Tables Accessed

The package references several tables via APPS synonyms. HR_API_TRANSACTION_STEPS and HR_API_TRANSACTION_VALUES hold the step definitions and value rows consumed by the HR API transaction mechanism. PER_ALL_ASSIGNMENTS_F provides the assignment records to which EIT data is attached. PQP_CONFIGURATION_VALUES stores staffing configuration settings. PQP_VEHICLE_ALLOCATIONS_F and PQP_VEHICLE_REPOSITORY_F hold vehicle allocation and repository records, while PQP_VEH_ALLOC_EXTRA_INFO and PQP_VEH_REPOS_EXTRA_INFO persist the extra information attached to allocations and repository entries respectively. WF_ITEM_ATTRIBUTES and the PLITBLM PL/SQL table type support workflow attribute storage and bulk data transport. Supporting API dependencies include HR_API, HR_TRANSACTION_API, HR_TRANSACTION_SS, HR_EIT_STRUCTURE_TYPE, HR_JAVA_CONV_UTIL_SS, HR_UTILITY, HR_UTIL_MISC_WEB, FND_DATE, WF_ENGINE, and the PQP_VEH_ALLOC_EXTRA_INFO_API and PQP_VEH_REPOS_EXTRA_INFO_API packages.

Usage Notes

PQP_GENERIC_EIT_SS is typically invoked from staffing forms, concurrent programs, or custom integration code that needs to read or write Generic EIT data against assignments, vehicles, or vehicle allocations. Because it depends on the HR API transaction framework, callers should build transaction steps and values before invoking PROCESS_API, then use DEL_TRANSACTION_DATA and CLEAR_DELETE_TRANS to finalize or reverse an operation. The package is not referenced by any other database object, indicating it is a terminal consumer rather than a shared lower-level component. Developers extending staffing EIT behavior should call the documented procedures rather than writing directly to the underlying EIT tables, preserving transaction integrity and validation. Its dependencies on FND_DATE and HR_UTIL_MISC_WEB confirm that date conversion and web utility handling are performed internally, reducing the burden on calling code.