Search Results lookup_desc

Overview

IGS_PE_SET_REM_HOLDS is an Oracle E-Business Suite package body owned by the APPS schema and classified as OTHER within the ETRM repository. It belongs to the Oracle Student System / People Enterprise (IGS_PE) family of objects, which manage person-level records for higher-education institutions. The package encapsulates the logic required to apply and release holds, or encumbrances, against person records. These holds may be internal to the institution or external, and the package supports both individual person identifiers and person identifier groups.

The body was authored by Sanil Madathil at Oracle IDC in September 2001 and has been maintained across multiple bug fixes, including external hold design changes, dynamic person id group support, and the handling of non-existent holds during release. The package body also contains private helper routines, most notably lookup_desc, which resolves a lookup meaning from a lookup code given a lookup type. This helper is used internally to translate stored codes into descriptive text for display or processing, which explains why a user searching for "lookup_desc" would surface this object.

Key Procedures and Functions

• SET_PRSID_GRP_HOLDS — Applies holds to a set of person identifiers, including dynamic person id groups. The procedure was modified to introduce dynamic person id groups and to add rollback and savepoint handling so that partial failures can be reversed. It uses a SUBSTR call to derive a sequence number during hold creation.
• REL_PRSID_GRP_HOLDS — Releases holds previously applied to a set of person identifiers. Later revisions ensured that the process does not error out when a hold does not exist, and TRIM was applied to the calendar type. Rollback statements were also added to support transactional integrity.
• lookup_desc (private) — A function that returns the meaning from a lookup table for a supplied lookup type and code. It is private to the package body and is not exposed through the specification. It supports the display and interpretation of codes used by the hold procedures.

Tables Accessed

The package references several application tables through APPS synonyms:

• IGS_PE_PERS_ENCUMB — The primary encumbrance table where person holds are created, updated, and removed.
• HZ_PARTIES and HZ_PERSON_PROFILES — Used to resolve person identifiers and profile information when associating holds with the correct individual.
• FND_USER — Provides the application user context, typically to record who applied or released a hold.
• FND_RESPONSIBILITY — Supplies responsibility context, often used for security and audit purposes when processing holds.

Lookup values resolved by lookup_desc are stored in the standard FND lookup tables, though the excerpt does not enumerate the exact lookup type names.

Usage Notes

The package is invoked from Student System forms and processes that manage person holds, particularly the encumbrance or hold maintenance screens. It may also be called from concurrent programs or custom PL/SQL that needs to apply or release holds in bulk for a group of persons. Because the documented procedures are classified as OTHER rather than a public API, direct custom invocation should be undertaken with care, respecting the rollback and savepoint behavior built into the procedures. The change history indicates that holds can be internal or external and that the ENCUMB parameter was introduced for external hold designs.