Search Results set_order_by

Overview

APPS.PAY_FR_PAY_FILE is a French localization package within the Oracle E-Business Suite Payroll module. Its principal business function is the generation of the French payment output file, the electronic transfer file that a French payroll installation delivers to its bank so that employee net pay can be disbursed by direct credit. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the defining schema, a standard construct for seeded localization code that relies on APPS synonyms for data access.

The package header carries the source identifier pyfrpfcr.pkh and a change history that reaches back to its creation in November 2001, with subsequent modifications in February and October 2002. The October 2002 revision (version 115.4, bug 2610927) is described as a cursor change, indicating that the record-selection logic for the output file has been revisited over the product lifecycle. The header reserves a package-level variable, level_cnt, for internal control of record or level sequencing during file assembly.

Key Procedures and Functions

ETRM documents two callable units for this package: GET_PAYERS_ID and VALID_ORG.

• GET_PAYERS_ID — resolves the payer identifier associated with the payroll run being processed. In French payroll, the payer identity is a required attribute of the bank transfer file, so this routine supplies the organizational identifier that links the payment instruction set to the correct disbursing entity.
• VALID_ORG — performs validation of an organization, confirming that the organization supplied is a legitimate payer or payment-related entity before it is used in file generation. This guards the output process against invalid organization references that would cause the bank to reject the transmission.

The package also declares two explicit cursors that define the structure of the output file: fr_payfile_header, which retrieves header record information such as the transfer process date, date earned, organization payment method identifier, and business group identifier from PAY_PAYROLL_ACTIONS, and fr_payfile_body, which assembles the individual payment records. The body cursor multiplies the prepayment value by one hundred, reflecting the French convention of expressing amounts in centimes, and emits context values for the personal payment method, tax unit, and assignment action.

Tables Accessed

The documented tables accessed through APPS synonyms are:

• PAY_PAYROLL_ACTIONS — source of payroll action attributes, including the overriding direct deposit date, effective date, organization payment method, and business group used to build the file header.
• PAY_ASSIGNMENT_ACTIONS — provides the assignment-level action rows and the tax unit identifier for each payment record.
• PAY_PRE_PAYMENTS — holds the calculated prepayment amounts that become the transfer values in the body of the file.
• HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION — supply the organization definitions and descriptive information used by GET_PAYERS_ID and VALID_ORG to resolve and validate the payer entity.
• DBMS_UTILITY and PLITBLM — Oracle-supplied utilities used for formatting and internal PL/SQL table handling during file construction.

Usage Notes

PAY_FR_PAY_FILE is invoked as part of the French payroll disbursement cycle, typically in the final stages of a payroll run once prepayments have been calculated. It is not referenced by any other documented package, so its callers are the concurrent programs and localization routines that produce and transmit the French bank file rather than other PL/SQL APIs. When troubleshooting a user query such as set_order_by, note that this package does not expose a procedure of that name; ordering of the output records is governed by the internal cursor definitions rather than by a public ordering routine. Customizations that require a specific record sequence must therefore be applied to the cursor logic itself, and any such change should be revalidated against the bank file specification, since both the header and body cursor layouts are fixed by the French payment file format.