Search Results update_stdnts_err

Overview

APPS.IGS_DA_XML_PKG is a PL/SQL package that forms part of the Oracle Student System (formerly Oracle iLearning/OWS) within the Oracle E-Business Suite, specifically in the academic records and student achievement processing domain. The package provides a programmatic layer for assembling and exposing student unit attempt (SUA) and cumulative academic performance data in an XML-friendly structure. It is classified under ETRM as an OTHER API, indicating that it is primarily an internal processing package rather than a formally published open interface.

The package defines several PL/SQL record and collection types — r_sua_record, r_load_record, and r_student_type_rec, together with their associated indexed-by tables — that model grade, mark, grade point average (GPA), grade point (QP), and credit point (CP) values at both the individual unit attempt level and the cumulative load level. These structures underpin the package's role in generating status data consumed by external processes registered in the Oracle e-Commerce Gateway (ECX) tables.

Key Procedures and Functions

The package exposes twenty-six documented procedures and functions. The core data-assembly routines are POPULATE_SUA_TABLE and POPULATE_LOAD_TABLE, which populate the collection structures with unit attempt and cumulative load records respectively, based on a supplied person identifier. The getter functions retrieve individual attributes from these populated collections: GET_SUA_GPA_CP, GET_SUA_GPA_QP, GET_SUA_EARNED_CP, GET_SUA_ATTEMPTED_CP, GET_SUA_GRADE, GET_SUA_MARK, and GET_SUA_RESULT_TYPE return per-attempt values; GET_CUM_GPA, GET_CUM_GPA_CP, GET_CUM_GPA_QP, GET_CUM_EARNED_CP, and GET_CUM_ATTEMPTED_CP return cumulative equivalents. Users searching for get_cum_earned_cp are directed to the GET_CUM_EARNED_CP function, which returns the cumulative earned credit points for a student.

Supporting routines include GET_COURSE_ABBR_NUM (course abbreviation and number derivation), STUDENT_TYPE_LIST (student type classification), GET_UNIT_REPEATABLE (repeatability determination for a unit), and GET_PERSON_DETAILS (person biographical retrieval). The package also contains maintenance procedures: UPDATE_STDNTS_ERR for recording error status against requested students, and UPDATE_REQ_STUDENTS for updating the request student records processed by the package.

Tables Accessed

Data is gathered from academic and person tables referenced through APPS synonyms: IGS_EN_SU_ATTEMPT, IGS_AS_SU_STMPTOUT, IGS_AS_GRD_SCH_GRADE, IGS_PS_UNIT_VER, IGS_PE_TYP_INSTANCES_ALL, IGS_PE_ALT_PERS_ID, IGS_PR_ORG_STAT, IGS_PR_SPA_COMPLETE_INT, and IGS_PR_STU_ACAD_STAT_INT. Person and party information is drawn from HZ_PARTIES and HZ_PARTY_SITES.

The package interacts with Oracle e-Commerce Gateway metadata through ECX_EXT_PROCESSES, ECX_TP_DETAILS, ECX_TP_HEADERS, and ECX_TRANSACTIONS, reflecting its role in generating outbound XML transactions for an external student-data or achievement-reporting process. It also reads FND_PROFILE_OPTIONS and FND_USER for environment and user context, and reads and writes IGS_DA_REQ_STDNTS, the requested-students staging table that drives the processing run.

Usage Notes

IGS_DA_XML_PKG is normally invoked indirectly rather than called directly by end users. It is referenced by five other packages, indicating that it functions as a shared service layer within the student achievement XML generation flow. Typical invocation occurs through a concurrent program that selects pending rows from IGS_DA_REQ_STDNTS, calls POPULATE_SUA_TABLE and POPULATE_LOAD_TABLE for each person, assembles the XML payload from the getter functions, and records outcomes via UPDATE_REQ_STUDENTS and UPDATE_STDNTS_ERR.

The package is not documented as an open or multi-org API, and no formal parameter lists should be assumed from the ETRM metadata. Customizations should treat it as an internal dependency and prefer the higher-level calling programs. The cumulative getter functions, including GET_CUM_EARNED_CP, are meaningful only after the corresponding load table has been populated for the person in question, and results reflect the snapshot of data held in the package's PL/SQL collections for the duration of the session.