Search Results igs_fi_prc_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.
-
PACKAGE: APPS.IGS_FI_PRC_WAIVERS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_PRC_WAIVERS, status:VALID,
-
SYNONYM: APPS.IGS_FI_WAIVER_PGMS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_WAIVER_PGMS, status:VALID,
-
PACKAGE BODY: APPS.IGS_FI_PRC_WAIVERS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_FI_PRC_WAIVERS, status:VALID,
-
PACKAGE: APPS.IGS_FI_PRC_WAIVERS
12.1.1
-
PACKAGE: APPS.IGS_FI_WAV_UTILS_002
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_WAV_UTILS_002, status:VALID,
-
SYNONYM: APPS.IGS_FI_CR_TYPES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_CR_TYPES_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_WAV_PR_PREQS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_WAV_PR_PREQS, status:VALID,
-
PACKAGE: APPS.IGS_FI_PRC_FEE_ASS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_PRC_FEE_ASS, status:VALID,
-
PACKAGE: APPS.IGS_FI_WAV_DTLS_WF
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_WAV_DTLS_WF, status:VALID,
-
SYNONYM: APPS.IGS_FI_WAV_STD_PGMS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_WAV_STD_PGMS, status:VALID,
-
PACKAGE: APPS.IGS_FI_CRDAPI_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_CRDAPI_UTIL, status:VALID,
-
PACKAGE: APPS.IGS_FI_WAV_UTILS_001
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_WAV_UTILS_001, status:VALID,
-
SYNONYM: APPS.IGS_FI_BALANCE_RULES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_BALANCE_RULES, status:VALID,
-
VIEW: APPS.IGS_PE_PERSID_GROUP
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PE_PERSID_GROUP, object_name:IGS_PE_PERSID_GROUP, status:VALID,
-
SYNONYM: APPS.IGS_FI_FEE_TYPE_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_FEE_TYPE_ALL, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_008
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_008, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_007
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_007, status:VALID,
-
SYNONYM: APPS.IGS_FI_APPLICATIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_APPLICATIONS, status:VALID,
-
PACKAGE: APPS.IGS_PE_DYNAMIC_PERSID_GROUP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PE_DYNAMIC_PERSID_GROUP, status:VALID,
-
PACKAGE BODY: APPS.IGS_FI_CHARGES_API_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_FI_CHARGES_API_PVT, status:VALID,
-
PACKAGE: APPS.IGS_FI_COM_REC_INTERFACE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_COM_REC_INTERFACE, status:VALID,
-
SYNONYM: APPS.IGS_FI_CONTROL_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_CONTROL_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_CREDITS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_CREDITS_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_INV_INT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_INV_INT_ALL, status:VALID,
-
PACKAGE BODY: APPS.IGS_FI_PRC_FEE_ASS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_FI_PRC_FEE_ASS, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_GL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_GL, status:VALID,
-
PACKAGE: APPS.IGS_CA_GEN_001
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_CA_GEN_001, status:VALID,
-
VIEW: APPS.IGS_FI_GL_PERIODS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_GL_PERIODS_V, object_name:IGS_FI_GL_PERIODS_V, status:VALID,
-
VIEW: APPS.IGS_FI_FEE_TYPE
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_FEE_TYPE, object_name:IGS_FI_FEE_TYPE, status:VALID,
-
VIEW: APPS.IGS_FI_CR_TYPES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_CR_TYPES, object_name:IGS_FI_CR_TYPES, status:VALID,
-
VIEW: APPS.IGS_PE_PERSID_GROUP_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PE_PERSID_GROUP_V, object_name:IGS_PE_PERSID_GROUP_V, status:VALID,
-
VIEW: APPS.IGS_FI_CONTROL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_CONTROL, object_name:IGS_FI_CONTROL, status:VALID,
-
VIEW: APPS.IGS_FI_INV_INT
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_INV_INT, object_name:IGS_FI_INV_INT, status:VALID,
-
PACKAGE: APPS.IGS_GE_DATE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_DATE, status:VALID,
-
VIEW: APPS.IGS_PE_PERSON_BASE_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PE_PERSON_BASE_V, object_name:IGS_PE_PERSON_BASE_V, status:VALID,
-
SYNONYM: APPS.IGS_CA_INST_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_CA_INST_ALL, status:VALID,
-
APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_PRC_WAIVERS
12.1.1
-
APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_FI_PRC_WAIVERS
12.1.1
-
APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_FI_PRC_WAIVERS
12.1.1
-
VIEW: APPS.IGS_CA_INST
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_CA_INST, object_name:IGS_CA_INST, status:VALID,
-
PACKAGE: APPS.IGS_GE_GEN_003
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_GEN_003, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
SYNONYM: APPS.FND_NEW_MESSAGES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_NEW_MESSAGES, status:VALID,
-
APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_FI_WAIVER_PGMS
12.1.1
-
APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_GE_MSG_STACK
12.1.1
-
SYNONYM: APPS.HZ_PARTIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_PARTIES, status:VALID,
-
PACKAGE BODY: APPS.IGS_FI_PRC_WAIVERS
12.1.1
-
PACKAGE: APPS.IGS_GE_MSG_STACK
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_MSG_STACK, status:VALID,
-
PACKAGE: APPS.FND_FILE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_FILE, status:VALID,