Search Results fpt_check_future_apl

Overview

APPS.PER_PEOPLE3_PKG is a server-side PL/SQL package in the Oracle E-Business Suite Human Resources (PER) module, declared with AUTHID CURRENT_USER and shipped under the Oracle Online Help / Forms support layer of the People and Assignment forms. It encapsulates the business logic that drives the People form (PERWSWPE) and related entry windows, particularly around person type resolution, number generation, legislative age validation, and Data Descriptive Flexfield (DDF) detection. The package header carries the 120.3.12020000.2 version stamp, confirming its presence in both 12.1.1 and 12.2.2 environments.

Its principal role is to centralize the initialization logic executed by the People form when querying or entering an employee or applicant record. In the context of the FORM_POST_QUERY trigger, PER_PEOPLE3_PKG supplies the routine that re-evaluates form state after a query has executed, reconciling database values with the current block and ensuring legislative and business-group rules are applied consistently.

Key Procedures and Functions

• GET_NUMBER_GENERATION_PROPERTY — Determines whether number generation properties are enabled for employees and applicants within a business group.
• GET_LEGISLATIVE_AGES — Retrieves the minimum and maximum allowed ages for a business group, based on the governing legislation.
• GET_DEFAULT_PERSON_TYPE — Returns the default person type applicable for a given required type, business group, and legislation code.
• GET_DDF_EXISTS — Checks whether a descriptive flexfield definition exists for a legislation code.
• GET_PEOPLE_DDF_EXISTS — Variant check (referenced by bug #1799586) for People-related DDF existence.
• INITIALIZE — Overloaded procedure that hydrates the form's working variables: DDF flags, number-generation properties, required employee/applicant types, resolved person types, and optionally minimum/maximum ages.
• CHECK_FUTURE_APL / FPT_CHECK_FUTURE_APL — Validate future-dated applicant information.
• UPDATE_PERIOD — Updates period-of-service related data.
• RUN_ALU_EE — Executes the Assignment/Leave Update for an employee.
• VACANCY_CHK — Validates vacancy status against the people form.
• GET_ACCEPTED_APPLS / GET_ALL_CURRENT_APPLS — Retrieve accepted and current applicant applications.
• GET_DATE_RANGE / GET_ASG_DATE_RANGE — Provide effective date ranges for the entity and assignment.
• FORM_POST_QUERY — The routine most directly associated with the form_post_query search term; executed by the Forms POST-QUERY trigger to synchronize form state with retrieved row values.
• CHK_EVENTS_EXIST — Verifies whether PER_EVENTS records exist for the person.

Tables Accessed

• FND_DESCR_FLEX_COLUMN_USAGES / FND_DESCR_FLEX_CONTEXTS — Support the DDF existence checks.
• PER_ALL_ASSIGNMENTS_F — Primary assignment source for applicant and period logic.
• PER_ALL_VACANCIES — Consumed by VACANCY_CHK.
• PER_ASSIGNMENT_STATUS_TYPES / PER_ASS_STATUS_TYPE_AMENDS — Status validation for assignments.
• PER_EVENTS — Referenced by CHK_EVENTS_EXIST.
• PER_PERIODS_OF_SERVICE — Updated by UPDATE_PERIOD.
• HR_ORGANIZATION_INFORMATION — Provides business group / legislation context.
• PLITBLM — PL/SQL internal table load mechanism used to bulk-fetch rows.

Usage Notes

PER_PEOPLE3_PKG is invoked predominantly from Oracle Forms libraries attached to the People form (PERWSWPE), where INITIALIZE is called from WHEN-NEW-FORM-INSTANCE and FORM_POST_QUERY from the block-level POST-QUERY trigger. It is also referenced by thirteen other database packages, indicating reuse across HRMS APIs and concurrent processing. Custom code should not modify the package body, as it is a shipped Oracle module; extensions should be applied through supported personalization or wrapper packages.