Search Results valid_org

Overview

The PL/SQL package body APPS.PAY_FR_PAY_FILE implements the French localized payment output file generation logic within Oracle E-Business Suite Payroll. Its principal business function is to derive and validate the identification data required by French statutory payment formats, most notably the Prélèvement (direct debit) and establishment-level banking identifiers used by French payroll disbursements. The package is classified as an OTHER API in the ETRM repository, indicating that it is an internal, localization-specific implementation object rather than a published or supported public API.

The package maintains private global caches — a PL/SQL table (g_estab_tbl) keyed by establishment records, together with g_org_id and g_org_class scalars — to avoid repeated queries against organization and classification information during a payment run. The header comment identifies the source file as pyfrpfcr.pkb, version 115.2, dated 16-Oct-2002, and describes the package as the "French Payment Output File."

Key Procedures and Functions

• GET_PAYERS_ID — Resolves the French payer identifier for a given organization and payment context. The function queries HR_ORGANIZATION_INFORMATION joined to HR_ALL_ORGANIZATION_UNITS to derive the correct identifier segment based on the organization classification: for FR_SOCIETE organizations it retrieves org_information15, and for FR_ETABLISSEMENT organizations it retrieves org_information2 (the SIRET number). The lookup is driven through the FR_DYN_PAYMETH_MAPPING_INFO organization information context, which maps the organization payment method to an internal organization identifier. The resulting values are cached in the package globals for reuse.
• VALID_ORG — Validates that a given organization qualifies as a valid French paying entity for payment file generation purposes. It shares the private global cache (g_estab_tbl, g_org_id, g_org_class) with GET_PAYERS_ID, confirming that both functions operate over the same establishment and classification data set and are intended to be invoked together during a payment process.

Tables Accessed

• HR_ALL_ORGANIZATION_UNITS — Provides the organization identifier and organization unit definition for the paying establishment.
• HR_ORGANIZATION_INFORMATION — Supplies the French statutory classification (FR_SOCIETE, FR_ETABLISSEMENT) and the associated SIRET/SIREN identifier segments via multiple org_information_context rows, including FR_DYN_PAYMETH_MAPPING_INFO.
• PAY_PAYROLL_ACTIONS — Represents the payroll action (payment run) context associated with the output file.
• PAY_ASSIGNMENT_ACTIONS — Represents the assignment-level action records processed during the payment run.
• PAY_PRE_PAYMENTS — Stores the pre-payment records that are extracted and formatted into the French payment output file.
• DBMS_UTILITY — Utility package used for supporting PL/SQL operations.
• PLITBLM — PL/SQL table maintenance utility package, consistent with the package's use of index-by tables for caching.

Usage Notes

PAY_FR_PAY_FILE is a French localization implementation object. It is not referenced by any other documented package in ETRM (referenced by 0 other packages), which indicates that it is invoked directly by the French payment output concurrent program or by localization-specific code paths rather than being exposed as a reusable API surface.

Because the documented API classification is OTHER, the procedures should be treated as internal and unsupported for direct customer invocation. The package was created under bug 2610927 and received only minor maintenance (removal of a GSCC warning) across its documented versions, suggesting a stable, narrowly scoped role. The private caching mechanism implies that the functions are expected to be called repeatedly within a single payment run, and that values computed by VALID_ORG may be reused by GET_PAYERS_ID (or vice versa) within the same session.