Search Results cleanup_spp

Overview

APPS.HR_ASSIGNMENT_INTERNAL is an internal Oracle E-Business Suite package body that encapsulates the core assignment-creation, maintenance, and termination logic used by Oracle Human Resources and its dependent modules. The package is classified as OTHER within the ETRM inventory, meaning it is not a published public API but an internal implementation unit consumed by other HR and payroll packages. Its source header (peasgbsi.pkb) and lineage indicate that it has been maintained across the 11i and R12 code lines, with the 12.2.2 version retaining the same functional scope as 12.1.1.

The package primarily serves as the internal engine behind assignment lifecycle management: creating employee, contingent worker, and applicant assignments; applying status-type changes; maintaining spinal point placements; and performing final termination processing. It also provides referential-integrity checks to prevent deletion of assignments that are still referenced by Benefits or iRecruitment. The search term "cleanup_spp" maps directly to the package's CLEANUP_SPP procedure, which supports removal of orphaned or obsolete spinal point placement rows.

Key Procedures and Functions

The package exposes 24 documented program units. The assignment-creation routines include CREATE_EMP_ASG, CREATE_DEFAULT_EMP_ASG, CREATE_CWK_ASG, CREATE_DEFAULT_CWK_ASG, CREATE_APL_ASG, and CREATE_DEFAULT_APL_ASG, which build employee, contingent worker, and applicant assignments respectively, including "default" variants that seed standard values when minimal input is supplied.

• UPDATE_STATUS_TYPE_EMP_ASG, UPDATE_STATUS_TYPE_CWK_ASG, and UPDATE_STATUS_TYPE_APL_ASG apply status-type transitions across the three assignment categories.
• ACTUAL_TERM_EMP_ASG, ACTUAL_TERM_CWK_ASG, FINAL_PROCESS_EMP_ASG_SUP, and FINAL_PROCESS_CWK_ASG perform and finalize termination processing.
• MAINTAIN_SPP_ASG and CLEANUP_SPP manage spinal point placement assignment data, with CLEANUP_SPP responsible for purging invalid or stale SPP records.
• DELETE_FIRST_SPP supports deletion ordering for spinal point placements.
• CHK_VALID_PLACEMENT_ID validates placement identifiers prior to use.
• BEN_DELETE_ASSGT_CHECKS and IRC_DELETE_ASSGT_CHECKS verify Benefits and iRecruitment dependencies before allowing assignment deletion.
• PRE_DELETE performs preparatory validation and cascade logic ahead of physical deletion.

An additional helper, GET_MAX_ASG_FUT_CHANGE_END_DT, returns the maximum effective end date of future assignment changes after a given effective date, returning null when no future changes exist.

Tables Accessed

The package reads and writes via APPS synonyms, anchored on PER_ALL_ASSIGNMENTS_F for the primary assignment record and PER_SPINAL_POINT_PLACEMENTS_F for spinal point data. Payroll-related writes touch PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_LINK_USAGES_F, PAY_COST_ALLOCATIONS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_GRADE_RULES_F, and PAY_PERSONAL_PAYMENT_METHODS_F. Supporting tables include PER_ALL_PEOPLE_F, PER_ALL_VACANCIES, PER_ASSIGNMENT_BUDGET_VALUES_F, BEN_PER_IN_LER, IRC_ASSIGNMENT_STATUSES, and FND_NEW_MESSAGES for messaging. These accesses support consistent assignment, costing, and eligibility propagation.

Usage Notes

Because the package is classified as internal development use only, it is invoked indirectly by HR forms (for example the Assignment and Termination windows), by concurrent processes that finalize terminations, and by 17 documented dependent packages. Custom code should not call HR_ASSIGNMENT_INTERNAL directly; developers should instead use the public HR_ASSIGNMENT_API or related published APIs. When troubleshooting cleanup_spp behavior, DBAs can enable the package's debug flag (g_debug, driven by HR_UTILITY.DEBUG_ENABLED) and inspect HR_UTILITY.SET_LOCATION output to trace execution paths.