Search Results igs_ad_imp_005

Overview

IGS_AD_IMP_005 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. The IGS prefix associates the package with the Oracle Student System (formerly known as the Student Systems / Higher Education product line), where the AD segment of the name conventionally denotes Admissions-related functionality and IMP denotes import processing. The package therefore participates in the batch import of admissions data into the student information model — typically loading external applicant, application, or admission decision records into IGS staging and transaction tables.

The ETRM documentation for this object at 12.1.1 records a status of VALID, confirming it is a compiled and active database object in the APPS schema. It is classified as API type OTHER, meaning Oracle does not publish it as a supported public API and it is not intended for direct customer invocation. The documentation lists no independent database object references, indicating that the package performs no direct SQL against base tables through its own parsed statements and instead relies on other program units or is invoked purely as an orchestration or stub routine.

Key Procedures and Functions

ETRM records zero documented procedures or functions for IGS_AD_IMP_005. This is a significant characteristic: the package exposes no published, named entry points in the reference documentation, and any internal program units are undocumented. In practice, packages of the IGS_AD_IMP_00x series are generated as members of a numbered family of import modules, each handling a discrete slice of admissions data, and are called from a common driver rather than individually by end users. Because no procedure signatures are documented, no parameter lists can be asserted here, and integrators must not assume a callable contract without inspecting the deployed package body in the target instance.

Tables Accessed

The ETRM dependency report states explicitly that APPS.IGS_AD_IMP_005 does not reference any database object. Consequently there are no documented tables read or written by this package through direct SQL. This pattern is common in ETRM listings where the dependency extractor captures only static references resolved at compile time; dynamic SQL, references resolved through other packages, or data manipulation executed indirectly by called routines would not appear. The absence of documented table dependencies should be treated as a documentation limitation rather than proof that the package performs no data manipulation. Any admissions import logic attributed to this family of packages would ordinarily target IGS admissions staging and application tables, but the provided metadata does not corroborate specific table names for this object.

Usage Notes

IGS_AD_IMP_005 is invoked from within the Student System admissions import framework, not from a user-facing form and not as a standalone concurrent program in its own right. The typical invocation path is through the parent admissions import process, where the numbered IMP modules are executed in sequence or selected by parameter. Because the package is owned by APPS and classified OTHER, it is not a supported extension point: customers and integrators should not call it directly from custom code, as Oracle may alter or remove it without notice. The "referenced by" listing likewise shows no downstream dependents beyond itself, so no other shipped object depends on its interface remaining stable. When troubleshooting admissions import failures in a 12.1.1 or 12.2.2 instance, this package should be reviewed in the context of the full import driver and its sibling modules rather than in isolation, and the deployed package body in the specific instance should be inspected directly, since the published metadata provides no procedural or table-level detail.