Search Results get_county_name

Overview

PAY_GTNLOD_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to define the cursors and loading routines required by the Oracle Payroll Global Tax Notification (GTN) process when it executes in a multi-threaded mode. The package supports the payroll action mechanics that parallelize the retrieval of report totals needed to produce statutory U.S. tax notifications and related tax reporting output. The header revision references version 120.1.12010000.1, with earlier change history tracing creation to November 1999 and subsequent enhancements through 2006.

Because the largest payroll processing workloads must be partitioned into chunks and dispatched across concurrent workers, PAY_GTNLOD_PKG abstracts the data access layer so that each thread can assemble its portion of the result set independently. In the ETRM classification the package is registered as an OTHER API, meaning it is not a public transactional interface but an internal helper package used by the payroll concurrent program infrastructure.

Key Procedures and Functions

• LOAD_DATA — The central loading routine. It is overloaded across multiple signatures, reflecting successive redesigns. The earliest documented form accepts a payroll action identifier, a chunk number, and a payroll action finder. A later overload, introduced under Bug 4942114, accepts a numeric payroll action identifier, a numeric chunk, a numeric finder, and a series of status and control parameters governing deduction balances, earnings balances, federal, state, local, and federal/state liability balances, FUTA status and defined balance identifiers, employer liability and workers' compensation statuses, and an assignment flag. An additional commented variant illustrates an alternative interface passing view names and FROM/WHERE fragments for deduction, earnings, federal, state, local, and liability data sets, together with FUTA and employer liability clauses. LOAD_DATA is responsible for populating the package-level totals table with the rows each chunk is to process.
• GET_STATE_NAME — Resolves a state identifier to its descriptive state name for inclusion in GTN output and reporting.
• GET_COUNTY_NAME — Returns the county name corresponding to a given jurisdiction code, used where tax reporting requires county-level identification.
• GET_CITY_NAME — Returns the city name associated with a locality, supporting city-level tax notification and reporting requirements.

The package also declares a PL/SQL associative array type, SUM_TABLE, based on the PAY_US_RPT_TOTALS row structure, and a package global variable of that type used to hold accumulated report totals during processing.

Tables Accessed

According to the documented metadata, the package references the following tables through APPS synonyms:

• PAY_US_RPT_TOTALS — Primary staging table whose row type defines the SUM_TABLE collection populated by LOAD_DATA.
• PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS — Balance definition and dimension data used to identify and evaluate deduction, earnings, tax, and liability balances.
• PAY_ELEMENT_TYPES_F, PAY_ELEMENT_CLASSIFICATIONS, PAY_INPUT_VALUES_F — Element and input value metadata needed to interpret balance results.
• PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INTERLOCKS — Payroll action and assignment action records that drive chunk partitioning and thread coordination.
• PAY_EXTERNAL_ACCOUNTS, PAY_ORG_PAYMENT_METHODS_F — Organization payment and account information used in the reporting output.
• FF_DATABASE_ITEMS, FF_USER_ENTITIES — FastFormula entity and database item definitions referenced by the balance and view logic.
• HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL — Organization and location details, including the address hierarchy used by GET_STATE_NAME, GET_COUNTY_NAME, and GET_CITY_NAME.

Usage Notes

PAY_GTNLOD_PKG is invoked indirectly rather than from a user-facing form. It is called during execution of the Global Tax Notification payroll process when that process runs in multi-threaded mode, with the payroll action infrastructure invoking LOAD_DATA once per chunk to seed the totals collection. The package is referenced by one other package in the ETRM repository, confirming its role as a dependent utility rather than an entry point. Customizations should treat the overloaded LOAD_DATA signatures as version-sensitive: the input parameters changed materially at Bug 4942114, and any custom caller must match the signature appropriate to the installed patch level. Because the package relies on APPS synonyms, custom code referencing it should be compiled in the APPS schema or with equivalent synonym access. No direct concurrent program or form is registered against the package itself; it executes within the payroll concurrent manager environment under the privileges of the requesting payroll action.