Search Results active_asg_in_oth_bg

Overview

APPS.PER_OTHERBG_APL_API is a public PL/SQL API package in Oracle E-Business Suite Human Resources (Oracle HRMS). Its name reflects its purpose: PER (People), OtherBG (Other Business Group), and APL (Applicant / Application). The package manages assignment records created for people whose applicant or placement activity spans more than one business group — that is, records where an applicant or employee holds an assignment in a business group other than the one that owns their person record. This is a common scenario in multi-business-group implementations where centralized recruiting or shared-services models place candidates across legal entities.

The package provides the server-side logic that backs the "Other Business Group Application" flow. It encapsulates opening and closing these cross-business-group assignments, validating whether a person can hold multiple active recruitment vacancies, reversing terminations, and removing orphaned rows. The package body header identifies it as source file peobgpkg.pkb, version 120.9, dated 18-Aug-2011, confirming it is shipped with EBS 12.1.1 and largely unchanged through 12.2.2.

Key Procedures and Functions

• CLOSE_OTHERBG_APPLICATIONS — Terminates or closes the cross-business-group assignment record. The body shows a related internal routine, close_application, which accepts an assignment identifier and an effective date, resolves the person and assignment rows through PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F, and applies the appropriate assignment status. Status resolution distinguishes an in-other-business-group active status (ACTIVE_ASG_IN_OTH_BG) from a terminated-applicant status (TERM_APL).
• OPEN_OTHERBG_APPLICATIONS — Creates the cross-business-group assignment that links the applicant to the hiring business group. It is the counterpart to the close routine and establishes the assignment with the correct status type from PER_ASSIGNMENT_STATUS_TYPES.
• ISMULTIREGVAC — A validation function that reports whether a person is associated with multiple active recruitment vacancies. It supports the business rule that restricts a person from being simultaneously active on multiple requisitions where control logic or vacancy-linking is enabled, using PER_VAC_LINKED_ASSIGNMENTS.
• REVERSE_TERMINATE — Reverses a prior termination of an other-business-group assignment, restoring the record to an active state. This is used when a termination was entered in error, or when an applicant is reinstated.
• DELETE_ROW1 — A row-deletion routine used to remove the underlying assignment or linkage record, typically during cleanup of orphaned or invalid other-business-group rows.

Tables Accessed

• PER_ALL_ASSIGNMENTS_F — The primary table read and written; holds the cross-business-group assignment row, its dates, status, and object version number.
• PER_ALL_PEOPLE_F — Supplies the person record, business group, and object version number for locking and validation.
• PER_ASSIGNMENT_STATUS_TYPES — Resolves the seeded system statuses ACTIVE_ASG_IN_OTH_BG and TERM_APL that drive open and close behavior.
• IRC_ASSIGNMENT_STATUSES — iRecruitment assignment status lookups used to synchronize applicant status.
• PER_APPLICATIONS — The application record underlying the assignment.
• PER_ASSIGNMENT_BUDGET_VALUES_F — Budget value rows attached to the assignment.
• PER_PERSON_TYPES / PER_PERSON_TYPE_USAGES_F — Define and assign the person type used when creating the record.
• PER_VAC_LINKED_ASSIGNMENTS — Links assignments to vacancies, used by ISMULTIREGVAC.

Usage Notes

This package is an API-classified public interface (per ETRM 12.2.2), meaning customers and partners may call it directly from custom PL/SQL with the standard HRMS API pattern: hr_api.initialize_api, invoke the procedure, check hr_api.g_success or handle hr_api.g_error_message in the OTHERS block. It is invoked indirectly by the Oracle HRMS Applicant and iRecruitment forms and by concurrent processes that manage cross-business-group placement, and it is referenced by six other packages in the EBS schema. Because it writes to date-tracked tables such as PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F, callers should supply a valid effective date and expect date-track row splitting. The package should not be modified; sites requiring alternate behavior should wrap it in custom code.