Search Results create_waivers

Overview

IGS_FI_PRC_WAIVERS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) financials product family. Its purpose is to support the creation and processing of fee waivers within the Oracle Student System, allowing institutions to grant discounts or full/partial relief on charges assessed to students. Functionally, it sits within the financial aid and fee processing domain and works collaboratively with other fee and charge packages rather than as a purely standalone component. The package depends on the generic Application Programming Interface infrastructure supplied by FND_API, and it is documented as VALID in both ETRM 12.1.1 and 12.2.2.

Key Procedures and Functions

Two procedures are documented for this package:

• CREATE_WAIVERS — Establishes waiver records against the applicable student, program, and charge context. It is responsible for instantiating the waiver data that downstream processing relies upon, referencing waiver program and prerequisite metadata held in the IGS_FI_WAIVER_* and IGS_FI_WAV_* tables.
• PROCESS_WAIVERS — Applies the previously created waivers to the relevant charges and balances, producing the resulting credit or adjustment entries and updating the associated application, balance rule, and credit type records.

Both procedures operate over the party and person identifier structures defined by HZ_PARTIES and IGS_PE_PERSID_GROUP, which identifies the student (party) to whom the waiver applies. The metadata does not expose explicit parameter lists, so callers should consult the package specification or the Oracle repository for the exact signatures.

Tables Accessed

The package reads and writes a broad set of Student System financial tables through APPS synonyms, including:

• HZ_PARTIES — the trading community party record that identifies the person or organization receiving the waiver.
• IGS_FI_WAIVER_PGMS and IGS_FI_WAV_STD_PGMS, IGS_FI_WAV_PR_PREQS — waiver program definitions, standard program eligibility, and prerequisite rules.
• IGS_FI_APPLICATIONS, IGS_FI_CHARGES_API_PVT-related charge context — the application and charge records against which waivers are applied.
• IGS_FI_BALANCE_RULES, IGS_FI_CONTROL_ALL — balance determination and financial control configuration.
• IGS_FI_CREDITS_ALL, IGS_FI_CR_TYPES_ALL — credit records and credit type definitions created as a result of waiver processing.
• IGS_FI_FEE_TYPE_ALL, IGS_FI_INV_INT_ALL, IGS_CA_INST_ALL — fee type definitions, invoice interest data, and calendar instance/term context.
• FND_NEW_MESSAGES — message lookup used for error and informational reporting.

Usage Notes

IGS_FI_PRC_WAIVERS is an internal processing package, not a self-service API intended for direct end-user invocation. It is referenced by APPS.IGS_FI_CHARGES_API_PVT and APPS.IGS_FI_PRC_FEE_ASS, and it also references itself, indicating recursive or internal helper logic. Typical invocation therefore occurs through the fee assessment and charges processing flow, whether triggered from Oracle Student System forms, from concurrent programs that run fee assessment or waiver processing, or from custom extensions built on the packaged procedures. Developers extending waiver behaviour should call CREATE_WAIVERS followed by PROCESS_WAIVERS in the documented sequence, and should rely on the FND_API messaging and error conventions that the package inherits.