Search Results get_fls_tax_type_values

Overview

APPS.PAY_US_FLS_REPORTING_PKG is a valid PL/SQL package body in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, classified as an OTHER API under the APPS schema. It supports U.S. federal and state tax reporting obligations, specifically the reporting of Federal Levy Source (FLS) data associated with payroll actions. The package assembles jurisdiction, agency, and tax-type reference information required to produce FLS reporting output, drawing on U.S. federal, state, city, county, and school district tax information views.

The package operates on payroll action records and their associated message lines, participating in the payroll action lifecycle rather than exposing a standalone user interface. It is not referenced by any other database object, indicating it is invoked directly by higher-level payroll processes, concurrent programs, or reporting entry points.

Key Procedures and Functions

The metadata documents eight procedures and functions within the package body:

• GET_TAX_EXISTS — Determines whether tax records exist for a given reporting context, allowing the reporting logic to proceed conditionally.
• GET_FLS_ORG_INFORMATION — Retrieves organization-level information relevant to the Federal Levy Source, resolving organizational attributes used in the report.
• GET_FLS_AGENCY_CODE — Returns the agency code tied to the FLS reporting record.
• GET_JURISDICTION_NAME — Resolves and returns the descriptive jurisdiction name associated with a tax record.
• GET_FLS_JD_VALUES — Retrieves jurisdiction-specific values needed for FLS reporting.
• GET_FLS_TAX_TYPE_VALUES — Returns tax-type values used to classify the FLS entries in the report.
• RANGE_CURSOR — Provides a cursor (or cursor-returning construct) used to iterate over the range of records under processing.
• ACTION_CREATION — Handles creation of the payroll action records, including related payroll action information and message lines, that carry the FLS reporting results.

Parameter lists are not exposed in the metadata and should not be assumed; invocation details are internal to the package.

Tables Accessed

The package references several tables through APPS synonyms:

• PAY_PAYROLL_ACTIONS, PAY_ACTION_INFORMATION, PAY_ACTION_INTERLOCKS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S — Payroll action and assignment action data driving the reporting run and the creation of downstream actions.
• PAY_MESSAGE_LINES, PAY_MESSAGE_LINES_S — Message line records that communicate payroll action results, including FLS reporting output. Users searching for these objects are frequently tracing how payroll messages are populated.
• PAY_US_FEDERAL_TAX_INFO_F, PAY_US_STATE_TAX_INFO_F, PAY_US_CITY_TAX_INFO_F, PAY_US_COUNTY_TAX_INFO_F, PAY_US_SCHOOL_DSTS_TAX_INFO_F — U.S. tax information tables used to resolve jurisdiction, agency, and tax-type attributes across federal through school district levels.
• HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION — Organization definitions and attributes referenced by FLS organization lookups.
• DUAL — Used for single-row lookups and value derivation.

Usage Notes

PAY_US_FLS_REPORTING_PKG is invoked during U.S. payroll processing and reporting cycles, where FLS data must be assembled and written back as payroll action and message line records. It is typically called from payroll concurrent programs or form-driven processes rather than by external custom code. Because it is not referenced by any other database object, developers extending FLS reporting should call the documented procedures explicitly. The dependency on PAY_US_EMPLOYEE_PAYSLIP_WEB indicates related payslip-facing logic, while HR_UTILITY and PAY_MAG_UTILS provide supporting utilities leveraged internally.