Search Results delete_ass_ref_int

Overview

APPS.HR_ASSIGNMENT is a server-side PL/SQL package within the Oracle E-Business Suite Human Resources (HR) module. Its principal business function is to encapsulate the core rules governing the creation, validation, maintenance, and termination of employee and applicant assignments stored in the PER_ALL_ASSIGNMENTS_F table. An assignment is the central HR construct that links a person to an organization, job, position, grade, payroll, and location, and it drives payroll processing, compensation, and reporting downstream. Because assignment integrity affects so many dependent modules, HR_ASSIGNMENT centralizes the business logic that would otherwise be duplicated across multiple forms, APIs, and concurrent programs.

The package is classified as an OTHER API in the ETRM repository and holds a VALID status in the APPS schema. It is one of the most heavily referenced HR packages in EBS Release 12.1.1 and 12.2.2, with nineteen dependent packages identified in the ETRM metadata.

Key Procedures and Functions

The package exposes twenty-six documented procedures and functions. The principal groups are:

• Assignment numbering and sequencing: GEN_NEW_ASS_NUMBER and GEN_NEW_ASS_SEQUENCE generate the unique internal assignment identifiers required when new assignment records are inserted into PER_ALL_ASSIGNMENTS_F.
• Primary assignment management: CHECK_FUTURE_PRIMARY, CHECK_ASS_FOR_PRIMARY, UPDATE_PRIMARY, UPDATE_PRIMARY_CWK, DO_PRIMARY_UPDATE, and GET_NEW_PRIMARY_ASSIGNMENT collectively enforce the rule that a person may have only one active primary assignment at a given point in time, and orchestrate the promotion of a secondary assignment to primary status when required.
• Termination and date handling: CHECK_TERM, WARN_DEL_TERM, GET_ACT_TERM_DATE, CALL_TERMINATE_ENTRIES, and TEST_FOR_CANCEL_RETERM evaluate and apply termination dates, guard against invalid terminations, and handle cancellation or re-termination scenarios.
• Probation: GEN_PROBATION_END computes or validates the probation end date for an assignment based on the applicable probation period.
• Validation: CHECK_HOURS validates working-hours-related attributes for the assignment.
• Budget and reference integrity: LOAD_BUDGET_VALUES retrieves budget information associated with an assignment, while DELETE_ASS_REF_INT, DEL_REF_INT_CHECK, and DEL_REF_INT_DELETE manage the deletion of assignment reference integrity records, ensuring dependent rows are handled correctly.

Tables Accessed

HR_ASSIGNMENT operates across a broad set of HR and Oracle Purchasing tables, all accessed through APPS synonyms. The primary datastore is PER_ALL_ASSIGNMENTS_F, which holds the effective-dated assignment records. PER_ALL_PEOPLE_F supplies person-level information, and PER_ASS_STATUS_TYPE_AMENDS and PER_ASS_STATUS_TYPE_AMENDS_TL supply assignment status amendment rules and their translated descriptions. Organizational context comes from HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, and HR_LOCATIONS_ALL_TL. Assignment classification and terms are derived from PER_JOBS_TL, PER_GRADES_TL, PER_CONTRACTS_F, PER_COLLECTIVE_AGREEMENTS, PER_PAY_BASES, PER_SPINAL_POINTS, and PER_SPINAL_POINT_STEPS_F. Payroll linkage uses PAY_ALL_PAYROLLS_F. Benefits linkage uses BEN_PGM_F, and the ledger is resolved via GL_SETS_OF_BOOKS. Additional references include HR_COMMENTS for assignment comments, and the Purchasing tables PO_HEADERS_ALL, PO_LINES_ALL, PO_VENDORS, and PO_VENDOR_SITES_ALL, which support assignment-related supplier or contract reference data.

Usage Notes

HR_ASSIGNMENT is not intended to be called directly by end users. It is typically invoked indirectly through the Oracle HRMS forms (such as the Assignment, Employee, and Termination windows), through the HR_ASSIGNMENT_API and related public APIs, and through concurrent processes that mass-maintain assignments. Custom code should prefer the documented public API HR_ASSIGNMENT_API rather than calling HR_ASSIGNMENT directly, because the internal procedures assume calling context established by the API layer. The ETRM metadata records that the package is referenced by nineteen packages, including HR_APPLICANT_API, HR_EMPLOYEE_API, HR_ASSIGNMENT_API, HR_CHANGE_START_DATE_API, and the PER_ASSIGNMENTS_F_PKG family, confirming its role as a shared internal service. Any modification to assignment logic in this package should be treated as high impact, since defects propagate to payroll, benefits, and downstream reporting across the enterprise.