Results for “igs_ps_val_coo”

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

Overview

IGS_PS_VAL_COO is a PL/SQL validation package in the APPS schema of Oracle E-Business Suite, part of the Student System (IGS) product family. The "PS" segment identifies it as belonging to the Prospect/Programs/Student curriculum and offering infrastructure, while the "VAL" convention marks it as a validation routine library rather than a transactional or processing engine. As implied by the "COO" suffix, the package concentrates on validation logic associated with course offerings (COO), which in Oracle Student System are the concrete, scheduled instances of a course or program version delivered in a given term, at a given location, and under a given attendance mode.

The package is classified in ETRM as API classification OTHER, meaning it is not a registered public API with a published interface contract. It is an internal utility used across the Student System validation layer.

Key Procedures and Functions

ETRM documents two procedures or functions within this package:

• CRSP_VAL_COO_AM — A validation routine associated with the course offering "AM" context. Based on the naming convention and its placement in the IGS_PS_VAL_COO family, it applies validation rules to course offering records in this domain. The "AM" token reflects a specific validation dimension (such as attendance mode or attribute-level checks) carried through the Student System validation packages.
• CRSP_VAL_COO_ATT — A companion validation routine associated with the course offering "ATT" context. The "ATT" token denotes an attribute-oriented validation dimension, validating course offering attribute data before persistence. Both routines operate as building blocks invoked by higher-level validation drivers rather than being called directly by end users.

Only names and purposes are documented; no parameter signatures are published.

Tables Accessed

The ETRM excerpt for this object does not enumerate specific base tables referenced through APPS synonyms. The only dependency recorded at the SQL level is on SYS.STANDARD, the Oracle-supplied package specification underlying all PL/SQL. Because the package is a validation library, its runtime table access is expected to occur indirectly through the calling packages listed in Usage Notes below, rather than through direct DML within IGS_PS_VAL_COO itself.

Usage Notes

IGS_PS_VAL_COO is not intended for direct invocation by forms, concurrent programs, or custom code. It participates in the internal validation chain of the Student System: ETRM shows the package is referenced by four other APPS packages — IGS_PS_GEN_003, IGS_PS_OFR_OPT_PKG, IGS_PS_VAL_COP, and IGS_PS_VAL_CRV — and it also appears in its own dependency list, indicating recursive or self-referential calls within the validation tree. Validations resolve through these parent packages whenever course offering data is created or amended, whether through the Student System forms, the standard concurrent processes, or self-service flows.

For release 12.1.1 and 12.2.2, no online patching or editioning impact applies to the body itself. Customizations should never call or modify IGS_PS_VAL_COO directly; extensions belong in the calling layer or in user-defined validation hooks. Because the package carries OTHER classification, Oracle does not guarantee interface stability across patches, and any reliance on its internal logic is unsupported.