Search Results update_awards_from_ss

Overview

IGF_AW_SS_GEN_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as a supporting API of type OTHER within the Oracle Student System Financial Aid (IGF) module. Its name and dependencies place it squarely in the award management area of the financial aid subsystem, specifically the component that synchronizes award records with the self-service (SS) layer. The package is valid and is one of the objects that bridges the base award data model, anchored on IGF_AW_AWARD_ALL and its related detail tables, with the display and transactional logic required by award self-service pages where students and administrators view, accept, or decline award offers.

The package is internally referenced, meaning its procedures are called by other entry points (typically Oracle Forms or OAF-based pages) rather than being a standalone concurrent program. It exposes thirteen documented program units that fall into three broad categories: award synchronization routines (UPDATE_AWARDS_FROM_SS, UPDATE_AWARDS_BY_TERM_FROM_SS, UPDATE_AWARD_STATUS), display-mode resolution functions (GET_ACCEPT_DISPLAY_MODE, GET_DECLINE_DISPLAY_MODE, GET_ACCEPT_AMT_DISPLAY_MODE, GET_ACC_AMT_DISPLAY_MODE_TERM, GET_ACC_DISPLAY_MODE_TERM, GET_DEC_DISPLAY_MODE_TERM), and supporting helpers (GET_AWD_ACTION, APPLY_CERTF_RESP, SUBMIT_BUSINESS_EVENT, GET_TERM_AWARD_STATUS).

Key Procedures and Functions

• UPDATE_AWARDS_FROM_SS — Persists award changes originating from the self-service tier back to the base award tables, reconciling what the student or administrator submitted with stored records.
• UPDATE_AWARDS_BY_TERM_FROM_SS — A term-scoped variant of the above, processing accept/decline or adjustment activity limited to a specific academic period.
• UPDATE_AWARD_STATUS — Updates award status values, driving the state transitions that govern whether an award is offered, accepted, or declined.
• GET_AWD_ACTION — Returns the action applicable to an award, used to determine which self-service operation is permitted.
• GET_ACCEPT_DISPLAY_MODE, GET_DECLINE_DISPLAY_MODE — Determine how the accept and decline controls should render for a given award context.
• GET_ACCEPT_AMT_DISPLAY_MODE, GET_ACC_AMT_DISPLAY_MODE_TERM, GET_ACC_DISPLAY_MODE_TERM, GET_DEC_DISPLAY_MODE_TERM — Amount- and term-sensitive display-mode resolvers that govern partial accept/decline and per-term award presentation.
• APPLY_CERTF_RESP — Applies certification responsibility attributes to an award, linking award actions to certification requirements.
• SUBMIT_BUSINESS_EVENT — Raises or submits the business event associated with the self-service award action, integrating with the EBS Business Event System.
• GET_TERM_AWARD_STATUS — Retrieves the award status at the term level for display and validation.

Tables Accessed

Via APPS synonyms the package reads and writes IGF_AW_AWARD_ALL (master award records), IGF_AW_AWD_CERT_RESPS (certification responsibility detail), IGF_AW_AWD_DISB_ALL (award disbursement lines), IGF_AW_AWD_PRD_TERM (award period-term breakdown), IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL (fund category and fund master reference data), IGF_SL_LOANS_ALL (student loan awards), IGS_PE_RES_CHG_S (person residence change records) and IGS_PS_VER_ALL (program version reference). DUAL is used for single-row lookups and constants. The award, disbursement, and period-term tables carry the transactional state; the fund tables supply attributes needed for display and eligibility decisions.

Usage Notes

IGF_AW_SS_GEN_PKG is not invoked directly by end users. It is called from the financial aid self-service UI — Oracle Forms or OAF pages in 12.1.1 and 12.2.2 — when a student accepts, declines, or modifies an award offer, and from administrative award-maintenance screens that share the same display logic. The GET_*DISPLAY_MODE functions are typically queried before rendering controls, while the UPDATE_* routines execute on save. SUBMIT_BUSINESS_EVENT indicates integration with the Workflow/Business Event System, so downstream subscribers receive award self-service notifications. Because the package is referenced by no other packages, customizations should call it as a shared API rather than modify its body, preserving supportability across the 12.1.1 to 12.2.2 upgrade path.