Search Results update_status_type_apl_asg

Overview

HR_ASSIGNMENT_INTERNAL is a private implementation package in the APPS schema that underpins Oracle E-Business Suite's assignment management functionality within Oracle HRMS. Assignment records, stored primarily in PER_ALL_ASSIGNMENTS_F, represent the relationship between a person (employee, contingent worker, or applicant) and an organization, position, job, and payroll. Because assignment creation and maintenance involve complex validation, date-tracked record handling, payroll linkage, and status derivation across many dependent entities, Oracle encapsulates the low-level logic in this package and exposes the supported entry points through the public HR_ASSIGNMENT_API wrapper.

The package is classified as an internal API (API classification OTHER) and is not intended for direct customer invocation. It serves as the shared engine that other HRMS APIs and business processes call to create default assignments, terminate assignments, manage spinal point placements, and enforce deletion preconditions. Its widespread reuse — referenced by seventeen other packages including HR_EMPLOYEE_API, HR_CONTINGENT_WORKER_API, HR_APPLICANT_API, HR_PERIODS_OF_SERVICE_API, PQH_ASG_WRAPPER, and IRC_OFFERS_API — demonstrates that it is a foundational component of the HRMS data model.

Key Procedures and Functions

The documented 24 procedures and functions cluster into several functional groups:

• Assignment creation: CREATE_EMP_ASG, CREATE_CWK_ASG, CREATE_APL_ASG, and the corresponding CREATE_DEFAULT_EMP_ASG, CREATE_DEFAULT_CWK_ASG, and CREATE_DEFAULT_APL_ASG build assignment rows for employees, contingent workers, and applicants, applying defaulting rules when attributes are not supplied.
• Status management: UPDATE_STATUS_TYPE_EMP_ASG, UPDATE_STATUS_TYPE_CWK_ASG, and UPDATE_STATUS_TYPE_APL_ASG propagate assignment status changes for each person type.
• Termination processing: ACTUAL_TERM_EMP_ASG_SUP, FINAL_PROCESS_EMP_ASG_SUP, ACTUAL_TERM_CWK_ASG, and FINAL_PROCESS_CWK_ASG handle the supervisory and final processing steps that end an assignment, including date-effective updates and dependent record closure.
• Spinal point placements: MAINTAIN_SPP_ASG, DELETE_FIRST_SPP, CLEANUP_SPP, and CHK_VALID_PLACEMENT_ID manage PER_SPINAL_POINT_PLACEMENTS_F records tied to grade and progression processing.
• Validation and deletion: PRE_DELETE, BEN_DELETE_ASSGT_CHECKS, and IRC_DELETE_ASSGT_CHECKS enforce referential and business-rule checks before an assignment can be removed, covering benefits enrollment and iRecruitment assignment status dependencies.

Tables Accessed

The package reads and writes PER_ALL_ASSIGNMENTS_F, the core date-tracked assignment table, and PER_SPINAL_POINT_PLACEMENTS_F for grade placement data. It consults PER_ALL_PEOPLE_F for person attributes and PER_ASG_SHD (a shadow table for concurrent processing). Payroll integration relies on 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. Benefits checks reference BEN_PER_IN_LER, recruitment checks reference IRC_ASSIGNMENT_STATUSES, and vacancy and budget validation use PER_ALL_VACANCIES and PER_ASSIGNMENT_BUDGET_VALUES_F. FND_NEW_MESSAGES supplies user-facing error messages.

Usage Notes

HR_ASSIGNMENT_INTERNAL is invoked indirectly. Standard callers include the Assignment and Employee forms, the Hire Applicant and Terminate Employee concurrent programs, the HR_ASSIGNMENT_API public wrapper, and Payroll and Benefits processes that reconcile assignment actions. Custom integrations should call HR_ASSIGNMENT_API or HR_EMPLOYEE_API rather than this internal package, since its signatures and behavior are not part of Oracle's supported public interface and may change between releases such as 12.1.1 and 12.2.2.