Search Results get_location_code

Overview

PAYRPENP is a PL/SQL package in the APPS schema (AUTHID CURRENT_USER) that supports the Oracle Payroll report PAYRPENP.rdf, titled "Employee Assignments Not Processed." The package supplies the supporting logic required by that report to identify payroll assignments that were not processed during a payroll run, and to resolve the government reporting entity attributed to a given assignment. It is classified as OTHER within the ETRM documentation, indicating that it is not a public, callable business API but rather an internal helper package backing a specific concurrent program. The bulk of the package is oriented towards United States legislative reporting requirements, since government reporting entity (GRE) resolution applies to US business groups. The header history records an initial creation in September 2000 by H. Maclean and a January 2004 revision (version 115.1, bug 3372714) made to render the package compliant with the Global Single Copy Customer (GSCC) data model, which is why the package references soft coding keyflex structures rather than older organization-based reporting tables.

Key Procedures and Functions

• GET_GRE_NAME — Returns the name of the government reporting entity associated with a supplied soft coding keyflex identifier. When the identifier is null, the function returns a single space rather than a null, which allows the report to avoid an outer join when handling non-US business groups that have no GRE attribution.
• GET_GRE_ID — Returns the identifier of the government reporting entity associated with the supplied soft coding keyflex identifier. In contrast to GET_GRE_NAME, this function returns NULL when the input is null, again avoiding the need for an outer join for non-US business groups.
• GET_LOCATION_CODE — Returns the location code associated with the entity being reported on. This is the function exposed in the ETRM metadata that corresponds to the searched term "get_location_code." Its result is used by the Employee Assignments Not Processed report to display the location at which a non-processed assignment sits.
• MISSING_ASSIGNMENT_ACTION — Supports the core purpose of the report by identifying assignment actions that are expected but absent for a payroll action, thereby distinguishing assignments that were not processed within a run or time period.

Only these four documented functions are exposed; the remainder of the package body contains private helpers. Parameter lists are intentionally not reproduced here.

Tables Accessed

The package reads through APPS synonyms for the following documented tables:

• HR_ORGANIZATION_INFORMATION — Provides the organization-level attributes used to resolve location and reporting entity details.
• HR_SOFT_CODING_KEYFLEX — Supplies the soft coding keyflex identifier from which the government reporting entity name and identifier are derived.
• PAY_ASSIGNMENT_ACTIONS — The primary source of assignment action records inspected to determine which assignments were processed or left unprocessed.
• PAY_PAYROLL_ACTIONS — Provides the payroll action context against which assignment actions are evaluated.
• PER_TIME_PERIODS — Supplies the payroll period boundaries used to constrain the population of assignments considered by the report.

Usage Notes

PAYRPENP is not intended for direct invocation by customers or by general application code. It is invoked indirectly when the concurrent program for PAYRPENP.rdf, Employee Assignments Not Processed, is submitted from the Payroll responsibility or via the standard concurrent request submission interface. The package is referenced by two other packages within the EBS codebase, indicating some reuse of its GRE and location resolution logic. Custom extensions should avoid calling these functions directly, since their signatures and behavior are tied to the report definition and to US legislative reporting rules; any custom use should be validated against the current 12.1.1 or 12.2.2 code level, particularly given the GSCC compliance changes introduced in the 115.1 revision.