Search Results assp_ins_dflt_evsa

Overview

IGS_AS_GEN_004 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an "OTHER" API within the ETRM repository. It forms part of the Student Systems assessment and grading subsystem (the IGS_AS module family), and its documented procedures indicate it supports the generation and maintenance of assessment records — specifically student marksheets, transcript entries, attempt outcomes, and standing or progression computations. The package collates data drawn from grading schemes, program and unit set configurations, and student attempt records to produce derived assessment results.

The object is reported as VALID in the 12.1.1 metadata, and its dependencies confirm it sits within a tightly coupled group of assessment packages, including IGS_AS_GEN_004 itself (internal recursion), IGS_AS_GEN_005, IGS_AS_SU_ATMPT_PAT_PKG, and IGS_SS_FACULTY_PKG. It in turn depends on APPS.IGS_AS_SPL_CONS_APPL, indicating that special consideration applications feed the assessment generation logic.

Key Procedures and Functions

Eleven documented procedures and functions are exposed. Descriptions follow from their naming conventions and the tables they touch:

• ASSP_GET_UAP_CD — retrieves a unit attempt/progression code, supplying the coded value used to classify a student's unit attempt for subsequent processing.
• ASSP_GET_UAPI_AP — obtains the unit attempt item applicable to a given assessment point, complementing ASSP_GET_UAP_CD.
• ASSP_INS_DFLT_EVSA — inserts default exam/assessment outcome records for a student attempt, establishing baseline result rows.
• ASSP_INS_GET — a generic insert routine supporting creation of assessment records.
• ASSP_INS_MARK_SHEET — creates student marksheet entries in IGS_AS_MARK_SHEET_ALL, the core artefact for recording awarded marks.
• ASSP_INS_SCAP_LOVALL — populates or validates a list-of-values source for special consideration application data.
• ASSP_INS_SUAAI_DFLT — inserts default student unit attempt assessment item rows, defaulting assessment item instances per attempt.
• ASSP_INS_SUAAP_DFLT — inserts default student unit attempt assessment pattern rows.
• ASSP_INS_SUAAP_SUAAI — links attempt assessment patterns to attempt assessment items, maintaining referential consistency between the two.
• ASSP_INS_TRANSCRIPT and ASSS_INS_TRANSCRIPT — insert transcript records reflecting finalised assessment results.

Tables Accessed

The package reads and writes via APPS synonyms across the assessment schema:

• IGS_AS_MARK_SHEET_ALL and its sequence IGS_AS_MARK_SHEET_GRPSEQNUM_S — storage of marksheet rows and generation of group sequence numbers.
• IGS_AS_MSHT_SU_ATMPT and IGS_AS_SU_ATMPT_ITM — the linkage between marksheets and individual student unit attempts and their items.
• IGS_AS_SU_SETATMPT, IGS_AS_SUA_AI_GROUP — set attempts and assessment item grouping.
• IGS_AS_INS_GRD_ENTRY — institution grade entry, supplying grade values for results.
• IGS_AS_GPC_* tables (ACA_STNDG, CLS_STNDG, PE_ID_GRP, PROGRAMS, UNIT_SETS) — configuration of progression and award standing rules and the unit sets to which they apply.
• HZ_PARTIES — the party/student identity record.
• IGS_AS_SPCL_CONS_CAT and IGS_AS_SPL_CONS_APPL — special consideration category and application data feeding adjusted outcomes.

Usage Notes

IGS_AS_GEN_004 is typically invoked indirectly rather than directly by end users. It is referenced by IGS_AS_GEN_005, IGS_AS_SU_ATMPT_PAT_PKG, and IGS_SS_FACULTY_PKG, meaning forms and concurrent programs in the assessment and faculty areas call it during marksheet generation, result defaulting, and transcript production. Customisations that extend assessment processing should call these procedures through the documented entry points rather than replicating logic, since the package enforces the defaulting and grouping rules that keep marksheet and attempt data consistent. In 12.1.1 and 12.2.2 the package is deployed identically under the APPS schema; any patching of the IGS assessment modules should be validated against the dependencies listed above to avoid invalidating dependent packages.