Search Results get_fls_agency_code

Overview

PAY_US_FLS_REPORTING_PKG is an Oracle E-Business Suite payroll package that resides in the APPS schema and belongs to the Oracle Payroll (PAY) product family, specifically the United States legislative (US) module. Its stated purpose, per the embedded header comments, is to "Generate FLS periodic magnetic reports according to FLS requirements." FLS in this context refers to federal, state, and local tax reporting obligations that U.S. employers must satisfy through periodic magnetic-media or electronic filings. The package therefore abstracts the extraction and formatting logic required to assemble the wage, tax, jurisdiction, and agency information that these filings demand.

In ETRM, the package is classified as API classification OTHER, meaning it is a supporting internal utility package rather than a formally published open interface. It is not referenced by any other package in the ETRM inventory, which indicates it functions as a leaf-level reporting utility consumed by external callers rather than as a shared library.

The package header carries a change history spanning 2001 through 2006, documenting iterative fixes to driving cursors, cursor renames, performance tuning, and a significant change (bug 4969824) that switched an action cursor from an assignment identifier to a person identifier. This lineage reflects its long-standing role in the U.S. payroll reporting stack.

Key Procedures and Functions

ETRM documents eight procedures and functions within this package:

• GET_TAX_EXISTS — Determines whether a tax record exists for the reporting context, allowing the reporting logic to distinguish taxable from non-taxable situations and avoid generating spurious report lines.
• GET_FLS_ORG_INFORMATION — Retrieves organization-level information (such as tax identifiers and reporting attributes) associated with the legal entity or organization being reported. This is the object most directly tied to the user search term and is a central accessor for organization classification data used throughout the FLS report generation.
• GET_FLS_AGENCY_CODE — Returns the agency code for the relevant taxing authority, as referenced in the change history where function behaviors were modified alongside cursor cleanups.
• GET_JURISDICTION_NAME — Added in version 115.9, this function resolves a jurisdiction identifier to its human-readable name for report output.
• GET_FLS_JD_VALUES — Supplies jurisdiction-and-district values required by the FLS report layout.
• GET_FLS_TAX_TYPE_VALUES — Returns tax type values used to classify and format the tax components appearing on the report.
• RANGE_CURSOR — A cursor construct used to drive the range of records processed during report generation.
• ACTION_CREATION — Supports the creation of payroll actions, enabling the reporting process to record or stage actions as part of the FLS workflow.

Tables Accessed

The package reads from a well-defined set of APPS synonyms reflecting its dual reliance on HR organization data and Payroll action/tax data:

• HR_ORGANIZATION_INFORMATION and HR_ALL_ORGANIZATION_UNITS — source the organization-level attributes consumed by GET_FLS_ORG_INFORMATION.
• PAY_ACTION_INFORMATION, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_PAYROLL_ACTIONS, PAY_ACTION_INTERLOCKS, and PAY_MESSAGE_LINES / PAY_MESSAGE_LINES_S — provide the action, assignment-action, and message infrastructure underpinning ACTION_CREATION and the report-driving cursors.
• PAY_US_CITY_TAX_INFO_F, PAY_US_COUNTY_TAX_INFO_F, PAY_US_FEDERAL_TAX_INFO_F, PAY_US_SCHOOL_DSTS_TAX_INFO_F, and PAY_US_STATE_TAX_INFO_F — the U.S. tax information flexfield tables that supply federal, state, city, county, and school district tax data used by GET_TAX_EXISTS and GET_FLS_TAX_TYPE_VALUES.
• DUAL — used for scalar evaluations such as existence checks and constant returns.

Usage Notes

PAY_US_FLS_REPORTING_PKG is an internal payroll reporting utility. It is not referenced by other packaged APIs in ETRM, so invocation originates from concurrent programs, report drivers, or custom extensions that need to produce FLS-compliant periodic filings. Because GET_FLS_ORG_INFORMATION depends on HR_ORGANIZATION_INFORMATION, callers must ensure the relevant organization classification and information types are populated before invocation. As with all APPS-schema payroll utilities, the package should be treated as version-sensitive across 12.1.1 and 12.2.2; it should not be called directly from custom code without confirming the signature contract in the target instance, since the documented metadata intentionally omits parameter lists.