Search Results token_tab

Overview

IGF_SL_CL_CHG_PRC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Student Financial Aid / Student Loan (IGF) product family, which supports the administration of federal and institutional student aid, including Direct Lending change processing. The package is documented as a supporting validation unit within the change-record workflow rather than as a public API; its ETRM classification is OTHER. Its header comment states that it was created on 10 October 2004 by Sanil Madathil (Oracle IDC) and that its purpose is to be invoked from the igf_sl_cl_create_chg process to validate a change record. The process is described as being invoked automatically for each change record created, meaning the package acts as a rules gate that evaluates student-loan change data before that data is committed or transmitted downstream. In Oracle EBS 12.1.1 and 12.2.2, the package is registered in the APPS schema and is executed with the privileges of the calling application user through standard APPS synonym resolution.

Key Procedures and Functions

The package declares two documented procedures.

• VALIDATE_CHG — The primary entry point. It accepts a change-send identifier that ties the call to a specific row in the change-send detail table, and returns a Boolean status, a message name, and a PL/SQL table of message tokens. The procedure evaluates the change record and reports the outcome through these output parameters, allowing the caller to decide whether processing continues.
• PARSE_TOKENS — Accepts the token table returned by VALIDATE_CHG and resolves the tokens, typically so that message text retrieved from the message repository can be assembled with runtime values substituted into placeholders. Separating token construction from token parsing keeps validation logic independent of message rendering.

The package defines two PL/SQL types in its specification. token_rec_type is a record with a token name and a token value; token_tab_type is an index-by-binary-integer table of that record type. The global variable g_message_tokens uses this table type. These public types are the reason users search for the identifier token_tab: it is the parameter type through which validation messages are passed between the package and its callers.

Tables Accessed

The documented table references show the breadth of the validation. IGF_SL_CLCHSN_DTLS is the driving change-send detail table, joined by the identifier passed to VALIDATE_CHG. Award and disbursement context comes from IGF_AW_AWARD_ALL, IGF_AW_FUND_CAT_ALL, and IGF_AP_FA_BASE_REC_ALL. Loan-level records are read from IGF_SL_LOANS_ALL, IGF_SL_LOR_ALL, IGF_SL_LENDER, IGF_SL_GUARANTOR, and IGF_SL_CL_RECIPIENT. Alternate person identifiers are resolved through IGS_PE_ALT_PERS_ID. FND_NEW_MESSAGES and PLITBLM supply Oracle Application Object Library message and token infrastructure used to build and parse validation messages. The package is referenced by five other packages, indicating that it is a shared validation dependency within the IGF change-processing chain.

Usage Notes

IGF_SL_CL_CHG_PRC is not intended for direct invocation by end users. It is called automatically from the igf_sl_cl_create_chg process as each change record is created, and it may also be reached indirectly through the five packages that reference it. Customizations should treat VALIDATE_CHG as the supported contract: callers pass the change-send identifier, inspect the returned status, and use PARSE_TOKENS together with the returned token table to render a user-facing message. The NOCOPY output parameters and the public token_tab type mean callers must declare variables of the package-defined type. Because the package source carries an old revision header, implementers on 12.1.1 or 12.2.2 should verify the installed version before relying on behavior, and should avoid modifying the package directly, since it is an Oracle-owned object in the APPS schema.