Results for “igs_ad_appl_int”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_AD_IMP_017 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the OTHER API category. Its header comment block and the accompanying change history establish that it belonged to the Admissions (IGS_AD) product family and was originally written to support import and data-conversion routines for admissions applications. The earliest documented purpose was to process applicant application data against the IGS_AD_APPL_INT interface table, but the package was progressively reshaped by a sequence of enhancements and bug fixes. Notably, a comment dated 31-Jan-2001 records that the table IGS_AD_APPL_INT itself was obsoleted, which fundamentally changed the package's role. A later comment dated 2003 (Bug 3191401) states that the procedures and functions were removed as part of Import Process enhancements, and the body was reduced to a comment-only implementation ending with END Igs_Ad_Imp_017. In the 12.1.1 and 12.2.2 environments, the package therefore survives as a deprecated shell that preserves compilation integrity for legacy references while providing no executable business logic.
Key Procedures and Functions
ETRM documents zero procedures and functions for this package in the 12.1.1 release. This is consistent with the source: line 26 explicitly notes that the procedures and functions were removed as part of Import Process enhancements under Bug 3191401, leaving only the package specification and an empty body. The earlier change history nonetheless indicates the historical scope of the removed logic. Those routines read application interface records, resolved credential data, performed lookups against credential-related lookup types (with the spelling of 'CREDENTAILS' corrected per Bug 2217104), inserted/updated rows in IGS_AD_PS_APPL_INST including six columns added for deferments handling (Bug 2395510), and evaluated applicant ratings with a closed-indicator check in a cursor named c_apcs_ratings_man_ind (Bug 2871426). References to IGS_AD_CREDENTIALS were redirected to IGS_PE_CREDENTIALS under Bug 2177686, and additional parameters were introduced into function calls under Bug 1964478. None of these procedures or functions remain callable in the current body.
Tables Accessed
The only explicitly documented table is IGS_AD_APPL_INT, the applications interface table, which the change history records as obsoleted in January 2001. Because the executable code was subsequently removed, the package performs no current reads or writes against any table. The historical logic also touched IGS_AD_PS_APPL_INST (applicant instances, including the six deferment-related columns), IGS_AD_CREDENTIALS prior to its replacement, and the successor IGS_PE_CREDENTIALS for credential data. ETRM lists no APPS synonyms by which the package currently references these objects, and no other packages are recorded as referencing it.
Usage Notes
Because the body contains no executable statements, IGS_AD_IMP_017 should not be invoked by concurrent programs, forms, or custom code in a supported 12.1.1 or 12.2.2 instance. Its continued presence in the APPS schema is best understood as a legacy stub kept for backward compatibility; any legacy caller that still references it will compile and run without effect. Implementations replacing the original import functionality should use the superseding Import Process components delivered after Bug 3191401. Administrators auditing the IGS_AD_APPL_INT interface should treat this package as historical evidence only and verify current data flows against the replacement import program and the IGS_PE_CREDENTIALS and IGS_AD_PS_APPL_INST tables.