Search Results get_assignment_set

Overview

APPS.PAY_PAYROLL_ACTIONS_PKG is a server-side PL/SQL package body in the Oracle Payroll module of Oracle E-Business Suite 12.1.1 and 12.2.2. It contains the supporting logic for the Payroll Action level window and the Payroll Process Results form, both of which present the outcome of payroll runs, pre-payments, archiving, purge, and balance adjustment processes to the payroll administrator. The package originated in the early Oracle*Payroll releases and its header trace (pypra02t.pkb) documents a long maintenance history spanning flexible date conversion, archiving performance fixes, purge phase support, BEE status handling, and voided payment status detail. Its documented API classification is OTHER, indicating it is not a public open interface but an internal utility layer invoked primarily by Oracle Payroll forms and by other payroll packages. The header records that the package has been referenced by five other packages, confirming its role as a shared service for name resolution, query construction, and result presentation across the payroll process results family of windows.

Key Procedures and Functions

• UPDATE_ROW, DELETE_ROW, LOCK_ROW — row-level DML and concurrency routines that let the Payroll Process Results form commit, remove, or select-for-update a payroll action record.
• V_ACTION_STATUS — returns the displayable status of a payroll action, including the additional detail required for voided payment process actions.
• V_MESSAGES_EXIST — determines whether message lines exist for an action so the form can enable or suppress message navigation.
• V_NAME — resolves the descriptive name of a payroll action, including archive processes, purge phases, and balance adjustments; several historical bug fixes (full-name hints, rewritten balance adjustment select, BEE status type) were applied to this routine for performance and correctness.
• SET_QUERY_BINDVAR, GET_NUM_BINDVAR, GET_DATE_BINDVAR, GET_CHAR_BINDVAR — bind variable handling routines added for the query-by-example behaviour of the results window.
• SET_WHERE — constructs the dynamic WHERE clause used by the results block; it was rewritten to correct truncated lines in an earlier release.
• LATEST_BALANCE_EXISTS — a performance-support function introduced for the pay_balances_v view, allowing the form to test for the existence of a latest balance before attempting to display it.
• DECODE_CHEQUE_TYPE — translates cheque (check) type codes into their display values for payment-related payroll actions.

Tables Accessed

The package reads and writes the core payroll action and assignment action tables. PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS supply the action rows and their assignment-level detail; PAY_ASSIGNMENT_LATEST_BALANCES and PAY_LATEST_BALANCES support the balance existence check; PAY_MESSAGE_LINES backs V_MESSAGES_EXIST; and FND_CONCURRENT_REQUESTS links actions to their submitting concurrent request. Organizational and grouping context comes from HR_ALL_ORGANIZATION_UNITS, HR_ASSIGNMENT_SETS, PAY_CONSOLIDATION_SETS, PAY_ELEMENT_SETS, PAY_ELEMENT_SETS_TL, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPES_F_TL, PAY_BATCH_HEADERS, and PAY_LEGISLATIVE_FIELD_INFO.

Usage Notes

PAY_PAYROLL_ACTIONS_PKG is normally invoked indirectly. The Payroll Process Results form and the Payroll Action window call its routines as the user queries, views, and maintains action records, while the concurrency and DML procedures enforce row-level integrity during updates and deletes. Concurrent programs that archive, purge, or roll back payroll data rely on the naming and status routines to render meaningful descriptions. Custom code in 12.1.1 or 12.2.2 should treat the package as an internal dependency rather than a supported integration point, because its signature and behaviour are tied to the forms layer; the documented procedures should be referenced only for diagnostics or extensions that follow Oracle's existing calling conventions.