Results for “igs_ps_gen_006”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_GEN_006 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified within ETRM as an OTHER API rather than a public or private API. It belongs to the Student System (IGS) product family, specifically the Academic and Student Services modules that manage unit offerings, unit versions, and student unit attempts. The package encapsulates reusable generation and maintenance logic used across the student records and program specification schemas, which is evidenced by its wide reuse: the package is referenced by eight other database objects, including the views IGS_AS_SUAH_LOAD_V and IGS_AS_SUA_ASS_V, and the packages IGS_EN_SU_ATTEMPT_PKG, IGS_EN_UNIT_SET_PKG, IGS_PS_GEN_003, IGS_PS_TCH_RESP_OVRD_PKG, IGS_PS_UNIT_VER_PKG, and IGS_PS_UNT_OFR_OPT_N_PKG. It also references itself, indicating recursive or internal helper invocation. Its dependency base is minimal: only the SYS.STANDARD package is directly referenced, so all table access is performed through APPS synonyms.

Key Procedures and Functions

The ETRM documentation records eight procedures and functions. Their naming follows the CRSP (student records process) convention common to the IGS_PS_GEN series, which historically denotes callable subroutines generated to support student program and unit administration.

  • CRSP_GET_UCL_MODE — Retrieves the unit class or unit career level mode indicator used to drive downstream processing decisions.
  • CRSP_GET_UOO_ID — Returns the primary key identifier of the unit offering option record, providing the numeric key needed to join or update dependent data.
  • CRSP_GET_UOO_KEY — Returns the concatenated or composite business key of the unit offering option, used where the numeric identifier alone is insufficient.
  • CRSP_GET_US_ADMIN — Retrieves administrative attributes associated with the unit set, such as the administrative status held against a student record.
  • CRSP_GET_US_SYS_STS — Retrieves the system status of a unit set, supporting validation and status-transition logic.
  • CRSP_INS_CI_UOP_UOO — Performs an insert operation linking a unit offering pattern to a unit offering option; an internal write-based subroutine.
  • CRSP_INS_US_HIST — Inserts a unit set history record, preserving an audit trail of unit set activity.
  • CRSP_INS_UV_HIST — Inserts a unit version history record, maintaining the version trail for unit definitions.

Parameter lists are not published in the available metadata and must be confirmed from the package source in the instance.

Tables Accessed

Access is made through APPS synonyms to the following documented tables:

Usage Notes

Because IGS_PS_GEN_006 has no direct form or concurrent program binding recorded, it is best regarded as an internal helper package invoked by the higher-level student system packages and views listed in its dependency tree. Typical invocations occur during unit offering generation, unit version creation, and unit attempt processing, where callers need consistent key derivation, status lookup, or history insertion without re-implementing that logic. Custom extensions that manipulate unit offerings or unit sets should call the wrapped packages such as IGS_PS_UNIT_VER_PKG or IGS_PS_UNT_OFR_OPT_N_PKG rather than IGS_PS_GEN_006 directly, preserving the supported call path. As the status is VALID in 12.1.1 and 12.2.2, the object remains available for compilation and reference, but it is not intended as a public integration point.