Search Results igs_as_mark_sheet_grpseqnum_s

Overview

IGS_AS_GEN_004 is a general-purpose PL/SQL package body in the APPS schema belonging to the Oracle E-Business Suite Student Systems (Advanced Studies / Assessment) module. Its documented API classification is OTHER, indicating it is an internal processing package rather than a formally published public API. The package is primarily concerned with the maintenance and defaulting of assessment-related entities: marking sheets, student unit attempt assessment items, special consideration applications, and transcript/grade entry support. It operates against the assessment data model, populating and deriving default values needed when assessment records are created or processed by forms and concurrent programs.

The package body is VALID and depends on a broad range of IGS assessment and enrollment objects, including IGS_AS_MARK_SHEET_PKG, IGS_AS_INS_GRD_ENTRY_PKG, IGS_AS_SU_ATMPT_ITM_PKG, IGS_AS_SPL_CONS_APPL_PKG, and IGS_AS_SUA_AI_GROUP_PKG, together with shared utilities such as FND_API, FND_MESSAGE, FND_LOG, and FND_GLOBAL. It is referenced by three other database objects, confirming that it acts as a helper layer for higher-level assessment processing.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions:

• ASSP_GET_UAP_CD — Retrieves a unit attempt identifier or code used to key subsequent assessment processing.
• ASSP_INS_MARK_SHEET — Inserts a marking sheet record, drawing on the marking sheet group sequence source IGS_AS_MARK_SHEET_GRPSEQNUM_S to supply the group sequence number. This is the routine most directly associated with the search term cited by the user.
• ASSP_INS_DFLT_EVSA — Inserts default exam session availability records, using IGS_AS_EXAM_SESSION and the exam venue session availability entity.
• ASSP_INS_GET — Performs insertion and retrieval of an assessment record in a single call, typically used where a row must exist before further processing continues.
• ASSP_INS_SCAP_LOVALL — Inserts special consideration application rows derived from an LOV-driven selection list.
• ASSP_INS_SUAAI_DFLT — Inserts default student unit attempt assessment item rows for a given student attempt.
• ASSP_INS_SUAAP_DFLT — Inserts default student unit attempt assessment application or placement detail.
• ASSP_INS_SUAAP_SUAAI — Links student unit attempt assessment application records to their corresponding assessment items.
• ASSP_INS_SUAAI_DFLT and ASSP_GET_UAPI_AP — Support retrieval of assessment item and application identifiers that precede default insertion.
• ASSP_INS_TRANSCRIPT and ASSS_INS_TRANSCRIPT — Insert transcript or grade entry data, coordinating with IGS_AS_INS_GRD_ENTRY and IGS_AS_INS_GRD_ENTRY_PKG.

Tables Accessed

The package reads and writes a wide set of assessment tables through APPS synonyms. Marking sheet data is handled via IGS_AS_MARK_SHEET_ALL and IGS_AS_MARK_SHEET_GRPSEQNUM_S, the latter supplying the group sequence numbers that identify marking sheet groupings. Student assessment items and attempts are managed through IGS_AS_SU_ATMPT_ITM, IGS_AS_MSHT_SU_ATMPT, and IGS_AS_SU_SETATMPT. Special consideration is handled by IGS_AS_SPCL_CONS_CAT and IGS_AS_SPL_CONS_APPL. Defaulting and grouping logic references IGS_AS_SUA_AI_GROUP, IGS_AS_UNIT_AI_GRP, IGS_AS_UNIT_CLASS, IGS_AS_GPC_ACA_STNDG, IGS_AS_GPC_CLS_STNDG, IGS_AS_GPC_PROGRAMS, IGS_AS_GPC_UNIT_SETS, and IGS_AS_GPC_PE_ID_GRP. Grade entry and transcript support use IGS_AS_INS_GRD_ENTRY. Person data is resolved from HZ_PARTIES.

Usage Notes

IGS_AS_GEN_004 is an internal helper package rather than a client-called API. It is normally invoked indirectly by the assessment forms and by the higher-level assessment packages that reference it, particularly during marking sheet creation and assessment item defaulting. Because ASSP_INS_MARK_SHEET relies on IGS_AS_MARK_SHEET_GRPSEQNUM_S, administrators troubleshooting marking sheet group sequence issues should confirm that this sequence object is valid and accessible in the APPS schema. Custom extensions should generally call the published assessment package APIs rather than this package directly, since its interface is not externally guaranteed and may change between 12.1.1 and 12.2.2.