Search Results take_action

Overview

IGS_FI_PRC_STDNT_DPSTS is a Student System (IGS) financials package body owned by APPS that implements the business logic behind the Process Deposits concurrent request. Its header comment states the purpose explicitly: the process either transfers a deposit to the student account as a payment, forfeits the deposit, or takes no action on the deposit transaction. This three-way outcome model is the core of the package. The package is classified in ETRM as API classification OTHER, indicating it is a process-oriented code unit rather than a callable public API for external consumers. The script identifier in the header is IGSFI77B.pls, version 120.1, with the last change dated 10-Feb-2006.

Key Procedures and Functions

The ETRM metadata documents a limited number of program units relative to the procedures named in the source header. The documented entry point is:

• CHECK_ACAD_LOAD_ADM_REL — validates the relationship between academic load and admission-related criteria for the student being processed. It is the gate that determines whether a deposit transaction is eligible for transfer, forfeiture, or no action, based on the student's admission and enrollment context.

Additional procedures referenced in the embedded header include validate_person (modified in 12-Feb-2006 under Bug#5018036 for R12 SQL Repository tuning of cursor c_person), prc_stdnt_deposit (the main processing driver, which received a call to chk_manage_account under Enh 2831569 and was modified under Enh#2831554), and generate_log (modified under Enh#2831554 and Bug# 2729927 to log deposit number and amount only when values exist). Bug fixes 2729935, 2729984, 2730010, and 2729948 refined token handling, enrollment-status message selection, and the message name used when the person identifier group is null. No parameter lists are documented in the ETRM metadata.

Tables Accessed

The package reads and writes the following documented objects through APPS synonyms:

• IGS_FI_CREDITS_ALL and IGS_FI_CR_TYPES_ALL — deposit and credit transaction records and their type definitions, the primary data acted upon.
• IGS_FI_CONTROL_ALL — financials control parameters governing deposit processing behavior.
• IGS_AD_DEPLVL_PRG, IGS_AD_DEPLVL_PRGTY, IGS_AD_OFRDFRMT_STAT, IGS_AD_OFR_RESP_STAT, IGS_AD_SS_APPL_TYP — admissions offer, response, and application-type data used to determine eligibility.
• IGS_CA_INST_REL and IGS_CA_TYPE — calendar instance relationship and calendar type context for the enrollment period.
• IGS_PE_PRSID_GRP_MEM_ALL, HZ_PARTIES — person and party identification used by validate_person.
• FND_NEW_MESSAGES — message lookup for log output.
• DUAL and PLITBLM — standard utility references.

Usage Notes

The package is invoked through the Process Deposits concurrent program rather than directly by forms. Users submit the request for a person or person group, and the package drives the transfer, forfeiture, or no-action decision per deposit. It is referenced by zero other packages, so it functions as a terminal process unit. The 12-Feb-2006 cursor modification was made specifically for R12 SQL Repository tuning, and the commercial receivables enhancements (Enh 2831569, Enh#2831554) integrate deposit processing with the manage-account and internal-credits logic. Custom code should not call this package directly; the supported entry point remains the concurrent request.