Search Results get_assignment_status_id

Overview

PAY_AU_FOREIGN_WORKERS is an Oracle E-Business Suite payroll package body owned by the APPS schema and classified as OTHER within the ETRM repository. It encapsulates the Australian localization logic required to identify, monitor, and report on foreign workers employed by Australian legal entities. In Oracle EBS 12.1.1 and 12.2.2, foreign-worker treatment affects payroll calculations, payment handling, period-of-service tracking, assignment status, and end-of-employment reporting. The package centralises these determinations so that payroll processes, legislative reporting, and downstream calculations apply consistent rules rather than duplicating status and date logic across the application.

The object carries an API classification of OTHER, meaning Oracle does not publish it as a supported public interface. The header history shows an initial version in May 2010, followed by Phase II foreign-worker changes, corrections to status names, and enhancements covering accruals and leave. The user search term "get_assignment_status_id" relates directly to the package's status-handling design; the documented procedure POPULATE_ASG_STATUS_ID is the mechanism by which assignment status identifiers are resolved and applied.

Key Procedures and Functions

The documented interface comprises nine procedures and functions:

• POPULATE_ASG_STATUS_ID — Populates the assignment status identifier used to classify a foreign worker. The change history records that version 115.3 corrected status names, indicating that the status identifier is derived by matching against PER_ASSIGNMENT_STATUS_TYPES.
• CHECK_FOREIGN_WORKER — Determines whether a given assignment qualifies as a foreign worker under Australian rules.
• GET_FOREIGN_WORKER_DATES — Returns the relevant dates defining the foreign-worker period for an assignment.
• CHECK_FW_TERMINATED — Establishes whether a foreign worker's employment has terminated.
• GET_DEFINED_BALANCES — Retrieves defined balance records relevant to foreign-worker calculations.
• IS_LE_CHANGED — Detects whether a legal employer change has occurred, which affects foreign-worker status and reporting.
• GET_FOREIGN_PAYMENT_AMOUNTS — Returns foreign payment amounts; version 115.5 modified it to return gracefully when the balance table count is zero.
• GET_FW_BETWEEN_DATES — Added in version 115.4 to support accruals and leave calculations by returning foreign-worker data between two dates.

Tables Accessed

The package reads and writes through APPS synonyms. PAY_ASSIGNMENT_ACTIONS and PER_ASSIGNMENT_STATUS_TYPES support status resolution and the POPULATE_ASG_STATUS_ID procedure. PER_PERIODS_OF_SERVICE and PER_TIME_PERIODS supply employment and date information for the date and termination checks. PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, and PAY_BALANCE_DIMENSIONS are used by GET_DEFINED_BALANCES and GET_FOREIGN_PAYMENT_AMOUNTS. HR_SOFT_CODING_KEYFLEX supports payroll costing context, while PAY_PAYROLL_ACTIONS provides payroll run context. DUAL and PLITBLM are used for simple queries and PL/SQL table handling.

Usage Notes

Because the package is not a published API, it is typically invoked by Oracle Australian payroll processes, payroll concurrent programs, and FastFormula or seeded payroll functions rather than by customer code. ETRM records that it is referenced by five other packages, confirming its role as a shared internal utility. The presence of several status and date functions means it may be called repeatedly during a payroll run, so its graceful handling of empty balance sets is significant. Customers extending Australian payroll should treat direct calls as unsupported and rely on seeded processes wherever possible.