Search Results delete_ss_appl_stg

Overview

IGS_AD_SS_GEN_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (formerly Oracle Higher Education / Student Systems, product family IGS) admissions module. The package name identifies it as a generated staging and self-service utility for the IGS_AD (Admissions) application. Its primary business function is to support the self-service admissions flow by staging application data captured through web-based, one-stop, or applicant-facing channels into the core admissions tables, performing lookups against academic calendars and admissions units, and transferring staged records into the destination application, offer, and fee structures.

In ETRM 12.1.1 the package is reported as VALID with an API classification of OTHER, meaning it is not a formally published public API but is instead an internal utility invoked by forms, concurrent processes, or other IGS packages. It carries 35 documented procedures and functions and is referenced directly by another package, IGS_AD_GEN_014, with which it shares the generated-code naming convention (the _001 suffix indicates a machine-generated or regenerated artifact).

Key Procedures and Functions

Among the 35 documented routines, the following are representative of the package's role:

• SET_ADM_SECUR_ON / SET_ADM_SECUR_OFF — toggle admissions security context on and off for the duration of processing, ensuring staged records are handled under the caller's security profile.
• TRANSFER_DATA — the central routine that moves validated staged applicants into the live admissions tables.
• INSERT_SS_APPL_STG, DELETE_SS_APPL_STG, INSERT_SS_APPL_PERSTAT_STG — manage the self-service application staging area, including personal-status staging rows.
• GET_ACAD_CAL, GET_DFLT_ADM_CAL — retrieve academic calendar and default admissions calendar values used to date-stamp applications.
• CHECK_FEEEXISTS — determines whether an application fee already exists for the applicant, avoiding duplicate charges.
• CHECK_ONESTOP, PROCESS_ONESTOP, PROCESS_ONESTOP2 — support the one-stop (integrated) admissions service flow, validating and processing one-stop submissions.
• UPDATE_AD_OFFER_RESP_AND_FEE, UPDATE_APPL_EQDO_INST, UPDATE_APPL_OFR_INST, UPDATE_APPL_OFRES_INST — update offer responses, equivalent-do qualifications, offer instances, and offer-response instances on the applicant record.
• INSERT_APPL_SECTION_STAT, VALIDATE_PROG_INST, GET_MAJOR — insert application section status, validate program-instance eligibility, and resolve major code values.
• DATESTR — a utility routine for date string formatting used throughout staging and transfer logic.

Tables Accessed

The package reads and writes admissions base tables and supporting reference data through APPS synonyms. Core admissions tables include IGS_AD_APPL_ALL (the applicant master), IGS_AD_PS_APPL_INST and IGS_AD_UNIT_SETS (admissions unit and program-instance data), IGS_AD_SS_LOOKUPS (self-service lookup values), IGS_AD_SS_LOOKUPS and IGS_CA_INST / IGS_CA_TYPE (calendar and calendar-type reference data). It also touches FND_DOCUMENT_CATEGORIES_TL, FND_LOBS, FND_LOBS_S, FND_LOOKUP_VALUES, and FND_NEW_MESSAGES for attachment handling, lookups, and workflow messaging. Human-resources registry data comes from HZ_CITIZENSHIP, HZ_CONTACT_POINTS, HZ_EDUCATION, HZ_EMPLOYMENT_HISTORY, HZ_PERSON_INTEREST, and HZ_PERSON_LANGUAGE, and workflow events use WF_EVENT_T.

Usage Notes

IGS_AD_SS_GEN_001 is an internal generated package rather than a supported public API; direct calls should be avoided. It is normally invoked indirectly through self-service admissions forms or concurrent programs in the IGS Admissions responsibility, most notably during one-stop applicant submissions and staging transfers. Because it is referenced by IGS_AD_GEN_014, any modification must preserve the existing call interfaces. As with all APPS-owned IGS packages, it is subject to patch and regeneration by Oracle Student System maintenance, so customization inside the package body is not advisable. In both EBS 12.1.1 and 12.2.2, the package resides under the same APPS owner with the same VALID status and dependency set.