Results for “call_validate_batch”

4 results




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

Overview

PAY_BEE_SS is a PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Self-Service payroll batch entry flow. It is an internal implementation package (ETRM API classification OTHER) with its header file annotated at version 120.0.12020000.2, indicating availability across the 12.1.1 and 12.2.2 code levels. Its principal responsibility is to create, populate, validate, and transfer payroll batches that originate from self-service web transactions, and to broker those operations through the HR Self-Service transaction framework (HR_API_TRANSACTIONS and HR_API_TRANSACTION_STEPS) rather than through direct inserts into the batch and element tables.

The package uses the package-level variable g_item_key to carry the transaction item key across procedure calls, and it derives a local procedure label (g_package) for diagnostic tracing via hr_utility. Batch records are created with an initial status of 'Unprocessed', an item type of 'HRSSA', and an activity identifier that is held in a local variable. Because the package is not referenced by any other documented package, it acts as a leaf-level integration point between the self-service UI layer and the Oracle Payroll batch APIs.

Key Procedures and Functions

Tables Accessed

The package reads and writes PAY_BATCH_HEADERS and PAY_BATCH_LINES in conjunction with their date-tracked _S shadow tables, which is why effective dating and corrective actions are reflected throughout the batch flow. Element and input value data are validated against PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, and PAY_ELEMENT_TYPES_F synonyms. Assignment context is derived from PER_ALL_ASSIGNMENTS_F. Transaction state is held in HR_API_TRANSACTIONS, HR_API_TRANSACTION_STEPS, and HR_API_TRANSACTION_VALUES, with approval and state history recorded in PQH_SS_APPROVAL_HISTORY and PQH_SS_TRANS_STATE_HISTORY. FND_CONCURRENT_REQUESTS is used to track any submitted concurrent request, DBMS_LOCK is used for serialization, and DUAL is queried for scalar values.

Usage Notes

PAY_BEE_SS is normally invoked indirectly from the Self-Service Payroll batch entry pages and from the associated approval and transfer workflow, not from SQL*Plus or ad hoc scripts. Because the package manipulates HR Self-Service transactions, callers must supply a valid item key and activity ID and must be operating within the correct business group context. The package calls the official Payroll batch API through PROCESS_API, so direct DML against PAY_BATCH_HEADERS or PAY_BATCH_LINES outside this flow is not recommended. For 12.2.2 deployments the package retains the 12.1.1 interface, so existing web-tier dependencies remain valid.