Search Results get_default_imp_date

Overview

APPS.PER_MX_SSAFFL_ARCHIVE is a Mexican localization package within Oracle E-Business Suite Human Resources (Oracle HRMS). It supports the archiving and reconstruction of social security affiliation (Seguro Social affiliation, SSS) data processed through the Mexican payroll and event-based processing framework. The package header, created in 2004 and maintained through several versions, is declared AUTHID CURRENT_USER, meaning the package executes with the privileges of the invoking schema. Its principal business purpose is to archive dated-tracked events related to Mexican social security affiliation and to retrieve the reference dates (implementation date and archive run start date) required to drive that archival process. In the context of EBS 12.1.1 and 12.2.2, it operates alongside the Payroll event and action infrastructure rather than standing alone.

Key Procedures and Functions

The documented API surface comprises eight procedures and functions:

• GET_DEFAULT_IMP_DATE — Returns the default Implementation date, sourced from PAY_MX_LEGISLATION_INFO_F. This is the function the user searched for; it establishes the baseline date used when the archive process must determine an implementation reference for Mexican legislation records.
• GET_START_DATE — Returns the archive run start date. It accepts parameters for legal employer, transaction GRE, and GRE identifiers, so callers can resolve the correct effective start date associated with the given business entities.
• DERIVE_GRE_FROM_LOC_SCL — Derives a GRE (Government Reporting Entity) from a location and school context. A business group parameter was added in version 115.6, enabling use across multiple business groups.
• GET_PAYROLL_ACTION_INFO — Returns payroll action information relevant to the archival run.
• RANGE_CURSOR — A cursor-based routine that establishes the range of data to be processed in the archive operation.
• ACTION_CREATION — Creates the payroll action records that drive the archive execution.
• ARCHIVE_DATA — Performs the actual archival of affiliation event data.
• ARCHINIT — Initializes the archive process, setting up the working context before data movement.

Internally the package also defines an internal assignment event record type and table type (t_int_asg_event_rec, t_int_asg_event_table), introduced to support event-range handling.

Tables Accessed

The package reads and writes a wide set of APPS synonyms. PAY_MX_LEGISLATION_INFO_F is the source of the default implementation date. Event processing relies on PAY_DATETRACKED_EVENTS, PAY_EVENT_UPDATES, PAY_PROCESS_EVENTS, PAY_TRIGGER_EVENTS, and PAY_EVENT_GROUPS. Payroll actions and assignment actions draw on PAY_PAYROLL_ACTIONS, PAY_ACTION_INFORMATION, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S. Government reporting entity resolution uses HR_ORGANIZATION_INFORMATION, HR_SOFT_CODING_KEYFLEX, PAY_FUNCTIONAL_AREAS, PAY_FUNCTIONAL_TRIGGERS, and PAY_USER_COLUMNS.

Usage Notes

PER_MX_SSAFFL_ARCHIVE is typically invoked from background processes and from custom extension code supporting Mexican social security affiliation archiving. Because GET_DEFAULT_IMP_DATE and GET_START_DATE expose reference dates, custom archival routines commonly call these functions to align their processing windows with the standard run. The package is referenced by three other packages, indicating reuse within the Mexican localization layer. It is not a public user-facing API; invocation is controlled through the payroll action and concurrent processing framework, and callers should observe the AUTHID CURRENT_USER behaviour, ensuring the executing schema has the required synonym access under APPS.