Search Results get_pid

Overview

IGF_AP_SS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM taxonomy as OTHER. Its name and signature indicate that it belongs to the Oracle iGovernment (IGF) financial aid processing family, specifically the student aid (SS) subsystem that supports loan, grant, and award processing for educational institutions and government disbursing agencies. The package operates at the intersection of student identification records (ISIR, the Institutional Student Information Record used in Title IV federal student aid processing) and award year computation logic that the institution uses to determine eligibility, disbursement dates, and expected family contribution. In Oracle EBS 12.1.1 and 12.2.2 it is deployed as a compiled package in the APPS schema and is referenced by 26 other packages, which confirms that it acts as a shared utility rather than a standalone entry point. The package header carries a $Header revision string dated 2006, indicating it is a long-established component of the IGF product line that has been carried forward across releases.

Key Procedures and Functions

The documented public interface contains eight callable units. SET_INTERNAL_ISIR assigns or resolves an internal ISIR identifier, taking an ISIR ID and returning the resolved ISIR ID. GET_PID is a function that resolves a person or party identifier given a person identification group; it returns the identifier as a VARCHAR2 and returns the group status and group type through OUT parameters. The user search term "get_pid" corresponds directly to this function, which is the most commonly referenced element of the package. SAVE_AS_CORRECTION_ISIR persists a correction ISIR derived from a source organization ISIR, accepting the original and modified ISIR IDs together with calendar type and sequence number, plus a default correction status of READY and the standard message/return status OUT parameters. CREATE_SIMULATION_ISIR generates a simulation ISIR from a modified ISIR ID, again returning the standard message count, message data, and return status. COMPUTE_EFC calculates the Expected Family Contribution for a given ISIR, award year, and warning-suppression flag. GET_DYNAMIC_DATES derives a set of date values — current year, next year, award year, legal residence date, first bachelor date, and born-before date — from a system award year input. GET_INTERNAL_ISIR_ID resolves an internal ISIR ID from a supplied ISIR ID using an IN OUT parameter. INSERT_INTO_TODO writes an entry into a work-list or task table using a base ID, sequence number, and status.

Tables Accessed

Three tables are documented as accessed through APPS synonyms. IGF_AP_ISIR_MATCHED_ALL is the central ISIR matching table and is read and written by SET_INTERNAL_ISIR, SAVE_AS_CORRECTION_ISIR, CREATE_SIMULATION_ISIR, COMPUTE_EFC, and GET_INTERNAL_ISIR_ID; it holds the ISIR records that the package manipulates. IGF_AP_FA_BASE_REC_ALL supplies the financial aid base record, and its calendar type and sequence columns are used by SAVE_AS_CORRECTION_ISIR to anchor the corrected ISIR to the correct award period. IGF_FC_SAR_CD_MST is a master table (SAR code master) consulted during EFC-related processing. GET_PID additionally reads the person identification group tables IGS_PE_PERSID_GROUP and IGS_PE_PERSID_GROUP_V.

Usage Notes

OraclE EBS forms, concurrent programs, and custom extensions in the IGF student aid module call this package indirectly. GET_PID is frequently invoked to resolve a party identifier from a person identification group when a form or batch process needs to cross-reference a student. COMPUTE_EFC and GET_DYNAMIC_DATES are typically called during award year rollover and eligibility processing. Because the package is referenced by 26 other packages, developers should treat it as an internal dependency and avoid direct modification; use the documented OUT parameters for error handling.