Search Results g_amount

Overview

HXT_TIME_PAY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Time and Labor (OTL) payroll integration. Its principal responsibility is to transform approved timecard information into payable time entries that can be interfaced with Oracle Payroll and, where applicable, Oracle Projects. The package is declared AUTHID CURRENT_USER, meaning its database objects and synonyms are resolved under the privileges of the invoking user rather than the package owner, a pattern consistent with other OTL APIs that must respect the security context of the calling application.

A notable element of the package specification, and the item most frequently associated with searches on the term g_amount, is the PAY function. Its parameter list includes g_AMOUNT IN NUMBER, which carries the monetary value to be applied when the time entry is compensated as an amount rather than strictly by hours and rate. The prefix convention g_ applied to these parameters mirrors the naming used for global and formal variables throughout the OTL technical stack, which is why g_amount surfaces as a query term when developers investigate how payable amounts are passed into payroll processing.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents two callable units within this package:

• PAY — A function returning a NUMBER. It is the primary entry point for creating or processing a payable time record. The signature accepts an extensive set of identifiers and attributes covering the employee, assignment, element type, timecard line, date worked, hours, time in and time out, premium and shift information, costing and labor account flexfield values, rate and rate multiple, and the g_AMOUNT monetary field. It also accepts tax rule, separate check, retro batch, and geographic (state, county, city, ZIP) attributes, along with standard WHO audit columns and effective dates. The width of the parameter list reflects the breadth of attributes that OTL must carry forward into a payroll element entry.
• GET_RETRO_FIELDS — A procedure that returns retroactive processing attributes. It accepts a timecard identifier together with optional batch name and batch reference values, and returns the pay status, projects (PA) status, retro batch identifier, and related fields as OUT parameters. It is used to determine whether a timecard is associated with retroactive payroll processing and to retrieve the relevant batch context.

Tables Accessed

The package reads and writes a defined set of OTL, payroll, and HR tables through APPS synonyms:

• HXT_TIMECARDS_F, HXT_DET_HOURS_WORKED_F, and HXT_SEQNO provide the source timecard, detailed hours, and sequence generation.
• HXT_BATCH_STATES supports batch state tracking during retro and payroll batch processing.
• HXC_ABSENCE_TYPE_ELEMENTS, HXT_PREM_ELIGBLTY_RULES, and HXT_PREM_INTERACT_RULES supply absence mapping and premium eligibility/interaction logic that influence payable amounts.
• PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPES_F_TL, PAY_ELEMENT_LINKS_F, and PAY_ASSIGNMENT_LINK_USAGES_F resolve the payroll element, its translated name, and the assignment-level link required to create an element entry.
• PER_ALL_ASSIGNMENTS_F validates the assignment context, while DUAL and PLITBLM support scalar and bulk PL/SQL operations.

Usage Notes

HXT_TIME_PAY is invoked indirectly rather than directly by end users. The Oracle Time and Labor timecard approval and payroll distribution processes call it when converting approved time into payable time and payroll element entries. Customizations that extend OTL-to-Payroll integration frequently call PAY directly from custom PL/SQL, supplying the g_AMOUNT parameter when compensation is expressed as a monetary value. The package is referenced by four other packages in the ETRM repository, confirming its role as a dependent service component. Developers should treat the parameter lists as fixed API contracts and avoid altering them, since the ordering and naming conventions are relied upon by the calling OTL subsystems.