Results for “get_previous_page”
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
- CREATE_BATCH — Establishes the batch header and opens or resumes the associated HR Self-Service transaction; accepts the batch name, effective date, action-if-exists, purge and rejection flags, item key, activity ID, login person ID, business group, and batch status.
- CREATE_BATCH_ASSIGNMENT_LINES and CREATE_BATCH_ELEMENT_LINES — Populate the assignment-level and element-level detail rows belonging to the batch.
- SET_INPUT_VALUES and SET_ELEMENT_INPUT_VALUES — Populate the element input value entries associated with batch element lines, resolving input values against the defined element input value definitions.
- GET_TRANSACTION_ID_BATCH_NAME, GET_ITEM_KEY, and SET_ITEM_KEY — Retrieve and assign the identifiers that link the batch to the self-service transaction context.
- UPDATE_DELETE_FLAG, UPDATE_BATCH_HEADER_TABLE, UPDATE_BATCH_LINES_TABLE, and UPDATE_ELEMENT_LINES_TABLE — Maintain the delete indicator and persist changes to the header, line, and element line records.
- VALIDATE_BATCH and CALL_VALIDATE_BATCH — Execute batch and element validation logic prior to transfer.
- GET_PREVIOUS_PAGE and RELEASE_APPROVAL_BLOCK — Support navigation and release the approval block once the batch is ready.
- UPDATE_TRANSACTION_ID, DELETE_ASSIGNMENT_INFORMATION, PROCESS_API, and TRANSFER_BATCH — Finalize processing: update the transaction identifier, remove obsolete assignment data, invoke the appropriate Payroll API, and submit the batch for transfer.
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.
-
PACKAGE: APPS.PAY_BEE_SS 12.2.2
-
PACKAGE: APPS.PAY_BEE_SS 12.2.2