Search Results get_obj_id

Overview

PQP_EARNINGS_TEMPLATE is an Oracle E-Business Suite PL/SQL package body owned by APPS that supports the Earnings and Deductions element template framework within Oracle Payroll and Oracle Human Resources. Its principal business function is to instantiate the metadata structure that defines a payroll element from a predefined earnings template. When a template is applied, the package creates the underlying element type, input values, balance feeds, and associated core objects required for the element to calculate correctly. It abstracts a complex multi-table creation sequence into a controlled API so that element generation remains consistent across legislations.

The package maintains session-level context through globals such as a business group identifier and a legislation code, ensuring that all objects it creates are scoped correctly to the operating business group and legal environment. It is classified as a general API (OTHER), indicating it is not restricted to a single product's internal use and may be called by other packages or setup utilities. The documented header identifies the source file as pqeetdrv.pkb, with release metadata reflecting maintenance through the 12.x code line.

Key Procedures and Functions

• CREATE_ELE_TEMPLATE_OBJECTS — The central creation routine. It accepts the element definition attributes (name, reporting name, description, classification, category, processing type, priority, calculation formula, deduction processing, effective dates, supplementary category, legislation code, and business group) and returns a numeric identifier. It drives the population of element types, input values, balance types, and template core objects, and populates internal index-by tables used to track generated identifiers.
• GET_OBJ_ID — A retrieval function used to resolve the identifier of an object created or referenced during template processing. This is the routine most commonly associated with the get_obj_id search term, and it provides the caller with the surrogate key needed to link dependent records without re-querying the base tables.
• ADD_FLSA_REDUCE_REG_FEEDS — Adds the balance feeds required for FLSA (Fair Labor Standards Act) hours handling and regular earnings reduction. It supports earnings configurations where premium or overtime elements must reduce regular pay and feed the appropriate hours balances.
• DELETE_ELE_TEMPLATE_OBJECTS — The complementary cleanup routine, removing the objects created for an element template when the template is reversed or the generated element is discarded.

Tables Accessed

The package reads and writes the core payroll setup tables through APPS synonyms. PAY_ELEMENT_TEMPLATES and PAY_TEMPLATE_CORE_OBJECTS define the template definition and its associated generated artifacts. PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_SHADOW_ELEMENT_TYPES, and PAY_BALANCE_TYPES store the created element, its inputs, shadow elements, and balances. PAY_BALANCE_FEEDS_F records how the element's outputs feed balances, and PAY_BALANCE_DIMENSIONS provides the dimensional context for those balance definitions. Together these tables form the persistent footprint of a generated earnings element.

Usage Notes

PQP_EARNINGS_TEMPLATE is typically invoked from the Earnings and Deductions element template setup forms when a user applies a template to generate an element, and it may also be called by other PL/SQL packages; the metadata notes it is referenced by two other packages. Custom code should treat CREATE_ELE_TEMPLATE_OBJECTS and DELETE_ELE_TEMPLATE_OBJECTS as a matched pair to avoid orphaned setup rows, and GET_OBJ_ID should be used to obtain generated identifiers rather than querying the base tables directly. Because operations span multiple payroll tables, callers should expect the package to participate in the surrounding transaction and should not assume autonomous commits. Correct business group and legislation context must be supplied so generated objects land in the intended payroll environment.