Search Results update_request_status

Overview

IGS_DA_XML_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS that supports the Higher Education "Student Records / Degree Audit" (IGS) product family. Its primary business function is the generation, population, and error-handling of XML payloads exchanged with external degree-audit systems. The package assembles student academic data — grade point averages, earned and attempted credit, grades, marks, results, and personal details — into staging and request tables, and writes error codes and report messages back to those tables when processing fails. Because the package is classified as an "OTHER" API rather than a formal public API, it is intended for internal use within the IGS Degree Audit integration flow.

The package has an extensive change history spanning 2001 through 2006, reflecting ongoing maintenance of the XML submission logic. Notable fixes include enhancements to error reporting via UPDATE_STDNTS_ERR, the introduction of an error-code column on request-status updates, and support for either a single consolidated XML document or multiple per-student XML documents.

Key Procedures and Functions

The 26 documented routines fall into three functional groups.

Data population:

• POPULATE_SUA_TABLE and POPULATE_LOAD_TABLE — populate the staging structures with Student Unit Attempt (SUA) data used for XML assembly.
• STUDENT_TYPE_LIST — derives the list of student types considered in the extraction.
• GET_PERSON_DETAILS — retrieves the student's personal details for the payload.

Academic extraction functions:

• GET_SUA_GPA_CP, GET_SUA_GPA_QP, GET_SUA_EARNED_CP, GET_SUA_ATTEMPTED_CP — return GPA credit points, quality points, earned credit, and attempted credit at the Student Unit Attempt level.
• GET_CUM_GPA, GET_CUM_GPA_CP, GET_CUM_GPA_QP, GET_CUM_EARNED_CP, GET_CUM_ATTEMPTED_CP — return the equivalent cumulative academic figures.
• GET_SUA_GRADE, GET_SUA_MARK, GET_SUA_RESULT_TYPE — return grade, mark, and result type for a unit attempt.
• GET_COURSE_ABBR_NUM and GET_UNIT_REPEATABLE — return the course abbreviation/number and the repeatable indicator (the latter reflecting corrected behaviour of the IGS_PS_UNIT_VER column).

Error and request handling:

• UPDATE_STDNTS_ERR — writes error codes and report messages to the student request records.
• UPDATE_REQ_STUDENTS — updates request status, extended to include an error-code parameter and null-safety checks.
• SUBMIT_EVENT and UPDATE_REQUEST_STATUS (referenced in the change history) — drive submission of the request and update its status; PRE_SUBMIT_EVENT writes an error report and launches a workflow when pre-submission validation fails.

Tables Accessed

The package reads and writes through APPS synonyms. Staging and request tables IGS_DA_REQ_STDNTS, IGS_AS_GRD_SCH_GRADE, IGS_PR_SPA_COMPLETE_INT, IGS_PR_STU_ACAD_STAT_INT, IGS_PR_ORG_STAT, and IGS_PE_TYP_INSTANCES_ALL hold the student, grade, and status data assembled into the XML. HZ_PARTIES, HZ_PARTY_SITES, and IGS_PE_ALT_PERS_ID supply party and alternate identification details. FND_USER, FND_PROFILE_OPTIONS, and the ECX_* interface tables (ECX_TRANSACTIONS, ECX_TP_HEADERS, ECX_TP_DETAILS, ECX_EXT_PROCESSES) support user lookup, profile-driven configuration, and outbound XML transaction/transport processing.

Usage Notes

IGS_DA_XML_PKG is invoked internally by the IGS Degree Audit XML generation flow, typically through a concurrent program or workflow (the igsdaxmlgen.wft workflow process is referenced in the source history). It is referenced by five other packages, so any modification carries a downstream impact. Because it is not a public API, custom code should not call it directly; integrators should rely on the supported entry points. When diagnosing the "complete_error" condition, the most relevant routines are UPDATE_STDNTS_ERR and UPDATE_REQ_STUDENTS, which persist the error code and report message, together with PRE_SUBMIT_EVENT, which raises the error workflow.