Search Results set_do_commit

Overview

HXT_INTERFACE_UTILITIES is a shared PL/SQL utility package residing in the APPS schema that supports the Oracle E-Business Suite time and labor interface infrastructure. Its primary responsibility is to provide common helper routines used by the Oracle Time and Labor (OTL / HXT) interface programs when transferring timecard data into the Oracle Payroll and supporting cost allocation structures. The package is classified as an OTHER API in the ETRM documentation, meaning it is not a public, externally facing interface but rather an internal support library invoked by other packages within the time and labor stack.

The utility package centralizes batching, caching, naming, and commit management logic that would otherwise be duplicated across retrieval and interface programs. It abstracts configuration concerns such as batch sizing, batch name generation, suffix handling, and the choice between legacy and current retro-processing batch behavior. By consolidating this logic, it ensures consistent behavior across the HXT_OTC_RETRIEVAL_INTERFACE and PAY_HR_OTC_RETRIEVAL_INTERFACE packages, both of which reference this utility package.

Key Procedures and Functions

The documented interface exposes 69 procedures and functions. The most prominent groupings are as follows:

• Commit control procedures: DO_COMMIT, SET_DO_COMMIT, and PERFORM_COMMIT manage whether and when the calling interface should issue database commits. SET_DO_COMMIT configures the commit behavior, DO_COMMIT executes the conditional commit, and PERFORM_COMMIT carries out the actual commit operation.
• Retro batch processing: USE_OLD_RETRO_BATCHES and SET_USE_OLD_RETRO_BATCHES provide a switch controlling whether retroactive timecard adjustments are handled using the legacy batch mechanism or the newer approach.
• Batch naming and suffix configuration: BATCH_NAME, BATCHNAME_SUFFIX_CONNECTOR, SET_BATCHNAME_SUFFIX_CONNECTOR, and CONC_REQUEST_ID_SUFFIX influence how batch identifiers are constructed, including the connector used between batch name components and the suffix derived from the concurrent request identifier.
• Batch sizing and line counting: MAX_BATCH_SIZE, MAX_BATCH_ID, COUNT_BATCH_LINES, TOTAL_BATCH_LINES, and MAX_LINES_EXCEEDED manage batching boundaries and detect when configured line thresholds are surpassed.
• Cache management: EMPTY_ASG_CACHE, EMPTY_BATCH_SUFFIX_CACHE, and EMPTY_CACHE reset in-memory caches used to reduce repeated database lookups for assignments, batch suffixes, and related values.
• Data validation and status helpers: ISNUMBER validates numeric content, while DETAIL_LINES_RETRIEVED and related retrieval indicators expose counts and flags describing the outcome of a retrieval run.

Additional undocumented-in-excerpt helpers (the GRE prefix and other members) follow the same internal support pattern.

Tables Accessed

• FND tables: FND_APPLICATION, FND_CONCURRENT_REQUESTS, FND_PROFILE_OPTIONS, FND_FLEX_VALUES, FND_FLEX_VALUE_SETS, FND_DESCR_FLEX_COLUMN_USAGES, and FND_ID_FLEX_SEGMENTS supply application identifiers, concurrent request context, profile option settings, and key flexfield segment definitions used for validation and naming.
• HXC time tables: HXC_TIME_BUILDING_BLOCKS, HXC_TIME_ATTRIBUTES, HXC_MAPPING_COMPONENTS, and HXC_GENERIC_RETRIEVAL_PKG underpin timecard composition, attribute handling, and mapping.
• PAY tables: PAY_BATCH_HEADERS, PAY_BATCH_LINES, PAY_ACCRUAL_PLANS, PAY_COST_ALLOCATION_KEYFLEX, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F provide payroll batch state, accrual plan definitions, cost allocation structures, and element input values required for cost and pay processing.
• PER and HR tables: PER_ALL_ASSIGNMENTS_F, PER_ALL_ORGANIZATION_UNITS, PER_ASSIGNMENT_STATUS_TYPES, PER_BUSINESS_GROUPS_PERF, PER_PEOPLE_F, HR_LOOKUPS, and HR_SOFT_CODING_KEYFLEX resolve assignment, person, organization, status, and soft-coding key flexfield data.

Usage Notes

This package is invoked indirectly by concurrent programs and interface routines rather than directly by end users. Its callers include HXT_OTC_RETRIEVAL_INTERFACE and PAY_HR_OTC_RETRIEVAL_INTERFACE, both of which rely on it for batching, commit management, and naming logic during timecard retrieval into BEE and payroll batch structures. Custom extensions that replicate OTL-to-Payroll workflows may reference the same utility routines where consistent batch behavior is required. Settings such as USE_OLD_RETRO_BATCHES, batch name suffix connectors, and maximum batch size are effectively controlled through the utility's setter procedures or profile options, allowing administrators to tune processing without code changes. Because the package is classified as OTHER and manages shared state, developers should treat it as internal infrastructure and avoid direct modification.