Results for “igs_ad_cancel_reconsider”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_CANCEL_RECONSIDER is an Oracle EBS Student System (Advanced Degree / Admissions) PL/SQL package owned by the APPS schema. Its business function is to support the cancellation and reconsideration of admission applications — specifically, to reverse a prior admission decision, reactivate a previously cancelled or incomplete application, and reinstate the associated application instance status and calendar/instructional context. The package therefore sits at the intersection of admissions decision management, application instance tracking, and party (person) records within the Oracle Student System data model.

The package header carries a package-level global, g_cancel_recons_on (VARCHAR2(1)), which acts as an internal flag or switch indicating whether the cancel/reconsider processing is active or enabled during a given session or run. This variable is referenced internally by the package body to gate behavior; it is not typically set by external callers.

The header identifies only a single documented procedure, CANCEL_RECONSIDER_APPL, making this a narrowly focused utility package rather than a broad admissions API. The source header ($Header: IGSADC9S.pls 120.3 2005/10/07) indicates the file was last shipped in patch form in 2005, so its lineage predates later 12.2.x ETRM releases, though the package remains documented under 12.1.1 policy metadata.

Key Procedures and Functions

CANCEL_RECONSIDER_APPL — This is the sole documented procedure and the functional core of the package. Its purpose is to process a cancellation or reconsideration action against a single admission application (and its related instance records), based on a person/group identifier, calendar details, an application type, and a set of future-dated reconsideration controls.

The procedure exposes a standard concurrent-program-style signature: Errbuf OUT NOCOPY VARCHAR2 and Retcode OUT NOCOPY NUMBER, which return an error message and a numeric status/return code respectively. The remaining parameters are input controls: P_person_id_group (a numeric identifier selecting the person or group of applicants to process), P_calendar_details (VARCHAR2 carrying calendar context used to resolve the applicable instructional period), P_application_type (VARCHAR2 restricting the operation to a particular application/entry type), and three future-related switch parameters (p_recon_no_future, p_recon_future, p_pend_future) that govern how reconsideration and pending statuses already scheduled for future dates are treated. Collectively these determine whether future reconsideration or pending actions are cleared, preserved, or re-applied.

Because the procedure returns Errbuf/Retcode rather than raising unhandled exceptions, it is designed for batch or scheduled invocation where the caller inspects the return code to determine success or failure. No functions are documented, and no additional procedures are exposed in the header.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• HZ_PARTIES — the TCA trading community party record, used to resolve the person associated with the application.
• IGS_AD_APPL_ALL — the central admissions application table; the application being cancelled or reconsidered.
• IGS_AD_APPL_STAT — application status history/records; updated as the cancellation or reconsideration changes the application's status.
• IGS_AD_OU_STAT — organizational-unit status for the application, tied to the academic unit handling the applicant.
• IGS_AD_PS_APPL_INST_ALL — application instances (the scheduled/section-level manifestations of an application across calendars).
• IGS_AD_PS_APLINSTHST_ALL — the history table for application instances, capturing the before/after state of instance changes.
• IGS_AD_SS_APPL_TYP — application type definitions, used to validate or filter by P_application_type.
• IGS_CA_INST_ALL — calendar instance definitions, used to resolve P_calendar_details to the applicable teaching/instructional period.
• PLITBLM — a PL/SQL internal table/temporary structure used for in-memory batch processing.

Together these tables indicate the procedure cancels or reconsiders an application across its status, organizational unit, instance, and history records while preserving an audit trail.

Usage Notes

Given the Errbuf/Retcode signature, CANCEL_RECONSIDER_APPL is most typically invoked from a concurrent program or a scheduled batch process rather than interactively, though it may also be called from custom PL/SQL or from an Oracle Forms-based admissions maintenance screen using a standard host/submit pattern. The package is referenced by one other package, suggesting it is reused as a subordinate utility in a larger admissions process flow rather than being a top-level entry point.

Because the metadata documents only the modern 12.1.1/12.2.2 behavior and the header dates from the 2005 code line, developers should treat the parameter list as the authoritative interface and avoid assuming undocumented overloads. Any direct invocation must supply the correct calendar and application type context, since these drive the resolution of application instances and calendar instances through IGS_CA_INST_ALL and the IGS_AD instance tables. The three future-control parameters give callers fine control over whether future-dated reconsideration or pending statuses are cleared; when integrating, confirm their correct values against the business process to avoid unintended removal of scheduled reconsideration rows. Finally, because HZ_PARTIES is involved, callers should ensure the person is identifiable in TCA before execution.