Search Results igs_fi_prc_stdnt_dpsts
Overview
IGS_FI_PRC_STDNT_DPSTS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API object. It belongs to the Oracle Student System (formerly Oracle iLearning/Student System) product family and supports the Financials (IGS_FI) module, specifically the processing of student deposits and their interaction with academic load and admissions-related relationship data. The package operates as a server-side processing component rather than a public callable API, meaning it is referenced internally by other constructs rather than being exposed as a standalone interface for external integration. It is documented in both EBS 12.1.1 and 12.2.2, where it holds a VALID status in the APPS schema. Its role centers on validating and processing student deposit records in relation to academic enrollment and admission status, ensuring that financial deposit transactions are consistent with the student's academic program level, offer response status, and institutional configuration.
Key Procedures and Functions
The ETRM metadata documents a total of two procedures/functions within this package. The principal documented program unit is:
- CHECK_ACAD_LOAD_ADM_REL — This procedure performs a validation check that relates a student's academic load to admission-relevant relationship data. In practice, this is used to determine whether a student's academic load (for example, the number of enrolled credit hours or registered units) is consistent with their admission relationship status and program level before deposit processing proceeds. It acts as a rules-based gate that confirms the student's academic and admission context is valid for the financial deposit being processed.
The second documented program unit is not separately detailed in the excerpted dependency metadata. Consistent with ETRM documentation practices, parameter lists for both units are intentionally withheld here; the package signature should be inspected directly in the database or via the "show dependent code" reference flagged in the ETRM dependency section. The dependency listing shows the package is self-referencing (APPS.IGS_FI_PRC_STDNT_DPSTS references itself), indicating internal recursion or helper routine reuse within the package body.
Tables Accessed
The package reads and writes the following tables via APPS synonyms, which reveal its functional scope:
- IGS_FI_CONTROL_ALL, IGS_FI_CREDITS_ALL, IGS_FI_CR_TYPES_ALL — Financials control, credit, and credit type configuration tables that define deposit rules, credit application logic, and credit type definitions used when processing student deposits.
- IGS_AD_DEPLVL_PRG, IGS_AD_DEPLVL_PRGTY, IGS_AD_OFRDFRMT_STAT, IGS_AD_OFR_RESP_STAT, IGS_AD_SS_APPL_TYP — Admissions tables covering departmental program levels, program types, offer formats, offer response status, and application types that establish the student's admission context.
- IGS_CA_INST_REL, IGS_CA_TYPE — Calendar instance relationship and calendar type tables, used to resolve the academic period relevant to the deposit.
- HZ_PARTIES — The Trading Community Architecture party table, used to resolve student identity.
- IGS_PE_PRSID_GRP_MEM_ALL — Person identifier group membership, used for grouping and eligibility checks.
- FND_NEW_MESSAGES — Oracle Application Object Library message table, used to retrieve user-facing error or warning messages.
- DUAL, PLITBLM — The standard dual table and the PL/SQL integer table type used for set-based operations.
Usage Notes
The ETRM dependency data shows that, as of the documented release, IGS_FI_PRC_STDNT_DPSTS is referenced by no other packages and is listed as being referenced only by itself. This indicates the package is a leaf-level processing unit that is invoked directly by Oracle Student System forms, concurrent programs, or Student System Financials setup flows rather than through a wider chain of dependent APIs. When extending or customizing, developers should not treat it as a supported public API, since its classification is OTHER rather than a designated public interface. Any wrapper code should call it only after confirming the parameter signatures via the database, and should respect the admission, calendar, and financials configuration assumptions embedded in the tables it accesses.
-
PACKAGE: APPS.IGS_FI_PRC_STDNT_DPSTS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_PRC_STDNT_DPSTS, status:VALID,
-
PACKAGE BODY: APPS.IGS_FI_PRC_STDNT_DPSTS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_FI_PRC_STDNT_DPSTS, status:VALID,
-
PACKAGE: APPS.IGS_FI_PRC_STDNT_DPSTS
12.1.1
-
SYNONYM: APPS.IGS_AD_DEPLVL_PRGTY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_DEPLVL_PRGTY, status:VALID,
-
SYNONYM: APPS.IGS_AD_DEPLVL_PRG
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_DEPLVL_PRG, status:VALID,
-
PACKAGE: APPS.IGS_FI_DEPOSITS_PRCSS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_DEPOSITS_PRCSS, status:VALID,
-
SYNONYM: APPS.IGS_AD_OFRDFRMT_STAT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_OFRDFRMT_STAT, 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_AD_SS_APPL_TYP
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_SS_APPL_TYP, status:VALID,
-
SYNONYM: APPS.IGS_AD_OFR_RESP_STAT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_OFR_RESP_STAT, status:VALID,
-
SYNONYM: APPS.IGS_PE_PRSID_GRP_MEM_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PE_PRSID_GRP_MEM_ALL, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_001
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_001, 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,
-
PACKAGE: APPS.IGS_FI_GEN_GL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_GL, status:VALID,
-
VIEW: APPS.IGS_PE_PRSID_GRP_MEM
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PE_PRSID_GRP_MEM, object_name:IGS_PE_PRSID_GRP_MEM, status:VALID,
-
VIEW: APPS.IGS_FI_PARTIES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_PARTIES_V, object_name:IGS_FI_PARTIES_V, 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_CR_TYPES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_CR_TYPES_V, object_name:IGS_FI_CR_TYPES_V, status:VALID,
-
SYNONYM: APPS.IGS_CA_INST_REL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_CA_INST_REL, 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,
-
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_CA_LOAD_TO_TEACH_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_CA_LOAD_TO_TEACH_V, object_name:IGS_CA_LOAD_TO_TEACH_V, status:VALID,
-
VIEW: APPS.IGS_AD_APPL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_AD_APPL, object_name:IGS_AD_APPL, 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_FI_CREDITS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_CREDITS, object_name:IGS_FI_CREDITS, status:VALID,
-
SYNONYM: APPS.IGS_CA_TYPE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_CA_TYPE, status:VALID,
-
VIEW: APPS.IGS_LOOKUP_VALUES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_LOOKUP_VALUES, object_name:IGS_LOOKUP_VALUES, status:VALID,
-
VIEW: APPS.IGS_AD_PS_APPL_INST
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_AD_PS_APPL_INST, object_name:IGS_AD_PS_APPL_INST, status:VALID,
-
VIEW: APPS.IGS_PS_VER
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PS_VER, object_name:IGS_PS_VER, status:VALID,
-
APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_FI_PRC_STDNT_DPSTS
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,
-
VIEW: APPS.IGS_PE_PERSON
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PE_PERSON, object_name:IGS_PE_PERSON, status:VALID,
-
VIEW: APPS.IGS_EN_SU_ATTEMPT
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_EN_SU_ATTEMPT, object_name:IGS_EN_SU_ATTEMPT, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
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
-
SYNONYM: APPS.FND_NEW_MESSAGES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_NEW_MESSAGES, status:VALID,
-
VIEW: APPS.IGS_EN_STDNT_PS_ATT
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_EN_STDNT_PS_ATT, object_name:IGS_EN_STDNT_PS_ATT, status:VALID,
-
APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_GE_MSG_STACK
12.1.1
-
PACKAGE BODY: APPS.IGS_FI_PRC_STDNT_DPSTS
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,
-
SYNONYM: APPS.HZ_PARTIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_PARTIES, status:VALID,
-
eTRM - IGS Tables and Views
12.1.1
description: Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'. ,
-
PACKAGE: APPS.FND_FILE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_FILE, status:VALID,
-
APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on FND_FILE
12.1.1
-
SYNONYM: PUBLIC.DUAL
12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
-
SYNONYM: PUBLIC.PLITBLM
12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
-
12.1.1 DBA Data
12.1.1