Search Results close_otherbg_applications

Overview

The APPS.PER_OTHERBG_APL_API package is a server-side PL/SQL API within Oracle E-Business Suite Human Resources (Oracle HRMS). It provides a controlled, programmatic interface for managing the lifecycle of secondary and other business group applications associated with a primary assignment. In Oracle HRMS terminology, an "other business group" application allows a person who holds a primary assignment in one business group to be engaged concurrently by another business group, typically through a separate application record that carries its own assignment, status, and budget context. The package encapsulates the business rules that govern when such applications may be closed, reopened, reversed, or removed, shielding callers from the underlying normalization of the PER_ALL_ASSIGNMENTS_F and related application tables. It is classified as an API in the ETRM 12.2.2 metadata and was authored with the AUTHID CURRENT_USER directive, meaning that privilege resolution occurs under the invoking schema, which is a standard convention for Oracle EBS public APIs. A package-level global, g_otherbg_hire_in_process, tracks whether an other-business-group hire is mid-transaction, allowing the procedures to behave consistently across multi-step operations.

Key Procedures and Functions

The package exposes five documented program units. The close_otherbg_applications procedure terminates one or more other-business-group applications for a given primary assignment as of a supplied effective date, honoring a caller-specified close mode. The open_otherbg_applications procedure performs the inverse operation, reactivating or opening other-business-group applications for an assignment at a chosen effective date under an open mode. Together these two procedures form the primary state-transition interface for other-business-group applications.

The isMultiRegVac function returns a Boolean indicating whether the assignment participates in multi-region or multi-legislative vacation handling. This check allows the closing and reopening logic to apply jurisdiction-specific rules when an employee's other-business-group records span more than one vacation or legislative regime.

The reverse_terminate procedure reverses a prior termination of an other-business-group application, restoring the assignment's application state as of the given effective date. This supports correction of erroneously processed terminations without manual data repair.

The delete_row1 procedure performs a controlled physical or logical row deletion against the assignment row, using multiple date parameters to preserve date-track integrity across the effective start and end dates of the record. Its name indicates it is an internal helper invoked by the higher-level procedures rather than a primary entry point.

Tables Accessed

The package operates against a defined set of Oracle HRMS tables, accessed through APPS synonyms. PER_ALL_ASSIGNMENTS_F is the central date-tracked table holding assignment records, and is the principal read and write target for all procedures. PER_APPLICATIONS stores the business-group application records whose status is being manipulated. PER_ALL_PEOPLE_F supplies the person-level context, including effective dating and person type. IRC_ASSIGNMENT_STATUSES, PER_ASSIGNMENT_STATUS_TYPES, and PER_ASSIGNMENT_BUDGET_VALUES_F provide the status and budget attributes that must remain consistent when applications are closed or reopened. PER_PERSON_TYPES and PER_PERSON_TYPE_USAGES_F determine the person type applicable at a given date, which conditions whether other-business-group processing is permitted. PER_VAC_LINKED_ASSIGNMENTS supports the multi-region vacation linkage evaluated by isMultiRegVac.

Usage Notes

This package is typically invoked from Oracle HRMS forms, particularly the Assignment and Termination windows, and from concurrent programs that perform mass termination or end-dating of other-business-group assignments. It is also referenced by six other EBS packages, indicating that it functions as a shared lower-level service within the HRMS API stack rather than an end-user callable alone. Customizations should call these procedures rather than issuing direct DML against PER_ALL_ASSIGNMENTS_F, so that status, budget, and date-track integrity are maintained and downstream payroll and benefits processes are not corrupted. As the package resolves privileges under AUTHID CURRENT_USER, callers must ensure the invoking schema has appropriate grants on the underlying tables and on any supporting HRMS objects.