Search Results xml_header

Overview

APPS.PAY_SE_PAYSLIP_REPORT is a server-side PL/SQL package that supports the generation of employee payslip output within the Oracle E-Business Suite Payroll (Payroll and Oracle HRMS) module. It belongs to the seed data delivered under the APPS schema and is classified as a non-API utility (classification OTHER). Its principal role is to resolve the runtime parameters of a payslip concurrent request, partition the qualifying assignment population for that payroll action, and emit the XML header, assignment-level XML body, and XML footer fragments consumed by the payslip reporting and electronic distribution process. In Oracle EBS 12.1.1 and 12.2.2 the package source header identifies revision 120.0.12010000.1, consistent with the standard 12.1.1 code line maintained across the 12.2.x upgrade, so behaviour is effectively identical on both releases.

Key Procedures and Functions

The package exposes four internal cursors and six documented program units, of which three are public procedures and one is a public function:

• GET_PARAMETER — a function that extracts a single named token from the concatenated parameter string passed to the payslip report, with an optional segment number to disambiguate repeated tokens.
• GET_ALL_PARAMETERS — a procedure that resolves the full set of runtime parameters for a given payroll action, returning the payroll, consolidation set, reporting period, report group and category, assignment set, assignment, effective date, business group, and legislation code through its OUT parameters.
• XML_HEADER — emits the opening XML fragment for the payslip document, including header-level data for the selected payroll action.
• XML_FOOTER — emits the closing XML fragment that completes the payslip document.
• XML_ASG — the core body generator; it produces the per-assignment XML block by driving the csr_asg cursor over PAY_TEMP_OBJECT_ACTIONS for the transfer payroll action derived from the TRANSFER_PAYROLL_ACTION_ID parameter. This is the unit associated with the user search term "xml_asg".
• QUALIFYING_PROC — a qualifier procedure that evaluates whether an assignment qualifies for inclusion in the payslip run, returning a qualifier value for use by the report driver.

The internal cursors csr_header (a DUAL stub), csr_asg, and csr_curr_act supply the parameter blocks written into the XML output; level_cnt is a package-level counter used for XML nesting.

Tables Accessed

The package reads across payroll, HR, and reporting metadata tables through APPS synonyms. Assignment and action eligibility is drawn from PER_ALL_ASSIGNMENTS_F, PAY_ASSIGNMENT_ACTIONS, and PAY_PAYROLL_ACTIONS. Parameter and reporting setup data come from PAY_ACTION_INFORMATION, PAY_REPORT_GROUPS, PAY_REPORT_CATEGORIES, PER_TIME_PERIODS, HR_ORGANIZATION_INFORMATION, HR_SOFT_CODING_KEYFLEX, and HR_ASSIGNMENT_SET_AMENDMENTS. PAY_TEMP_OBJECT_ACTIONS holds the transient transfer-action rows that drive cir_asg/XML_ASG. DUAL is used as a literal source, and DBMS_SQL supports dynamic SQL when resolving parameter values at runtime.

Usage Notes

PAY_SE_PAYSLIP_REPORT is invoked indirectly rather than from a form. It is called by the seeded payslip concurrent program and by the payroll action XML generation framework: the report driver calls GET_ALL_PARAMETERS to populate the request context, QUALIFYING_PROC to filter assignments, then XML_HEADER, XML_ASG, and XML_FOOTER to assemble the document. Because it is classified OTHER, it is not a supported public API and is not referenced by any other documented package. Custom developments should not call it directly; instead, custom payslip layouts should consume the generated XML, and any extension should treat PAY_TEMP_OBJECT_ACTIONS content and the parameter string format as internal implementation details subject to change between patch levels.