Results for “validation_procedure”

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

Overview

IGSFV_CAL_PRD_EVNT_TYP_CONFIGS is a read-only view owned by the APPS schema in the Oracle E-Business Suite IGS (Student System) product family. It exposes the seeded system date types that drive date type configurations within the academic calendar model. The view consolidates date alias configuration data with the associated date alias definitions, presenting a single row per configured system date type. Because the database definition terminates with the WITH READ ONLY clause, the view is strictly a reporting and inquiry construct; it cannot be used as a DML target.

In EBS 12.1.1 and 12.2.2 the object remains a compatibility view. It is primarily consumed by calendar setup forms, validation routines, and downstream reporting where the seeded date type catalogue must be resolved. The view text also applies descriptive flexfield–style attribute references (the "_LA:..." tokens), which the Oracle Forms/BC4J layer resolves as list-of-values descriptors rather than as literal column data. This means column names appearing with the "_LA:" prefix in the underlying SQL are presentation-layer lookups, while the physical columns exposed to SQL are the friendly names listed in the view's column catalogue.

Underlying Base Objects

The view is defined over two IGS calendar base tables joined on the date alias:

• IGS_CA_DA_CONFIGS DA — the date alias configuration table, supplying SYS_DATE_TYPE, VALIDATION_PROC, ONE_PER_CAL_FLAG, OWNER_MODULE_CODE, RES_CAL_CAT1, RES_CAL_CAT2, DATE_ALIAS, DESCRIPTION, and the standard WHO audit columns.
• IGS_CA_DA CA — the date alias definition table, supplying DT_ALIAS and its description.

The join predicate is DA.DATE_ALIAS = CA.DT_ALIAS. The ETRM entry lists no further documented referenced objects; the lookup value sets referenced by the "_LA:" tokens (IGS_LOOKUP_VALUES for IGS_MODULES and CAL_CAT) are resolved by the application tier and are not part of the view's SQL join graph.

Key Columns

• SYSTEM_DATE_TYPE — the seeded system date type code. This is the column most commonly targeted by searches for "system_date_type" against this view.
• OWNER_MODULE ("_LA:OWNER_MODULE") — the owning IGS module, resolved through IGS_LOOKUP_VALUES for module meanings.
• VALIDATION_PROCEDURE — the name of the validation procedure bound to the date type.
• ONE_PER_CAL_FLAG — indicates whether the date type may occur only once per calendar.
• RESTRICTED_CAL_CATEGORY and ALTERNATE_CAL_CATEGORY — calendar category restrictions resolved through the CAL_CAT lookup type.
• DATE_ALIAS — the key link to the date alias definition.
• SYSTEM_DATE_TYPE_DESC — description of the system date type (aliased from DA.DESCRIPTION).
• DATE_ALIAS_DESCRIPTION — description of the associated date alias (aliased from CA.DESCRIPTION).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit columns.

Common Use Cases and Queries

The principal scenario is resolving the catalogue of seeded system date types and their validation and category restrictions, for example when troubleshooting calendar date entry or building a reporting extract. A representative query is:

• SELECT system_date_type, system_date_type_desc, validation_procedure, one_per_cal_flag FROM igsfv_cal_prd_evnt_typ_configs ORDER BY system_date_type; — enumerates all seeded date types.
• SELECT date_alias, date_alias_description, system_date_type FROM igsfv_cal_prd_evnt_typ_configs WHERE system_date_type = :p_type; — isolates the aliases bound to a specific date type.
• SELECT DISTINCT owner_module, restricted_cal_category FROM igsfv_cal_prd_evnt_typ_configs; — summarises module and category coverage.

Because the view is read-only, it is appropriate for query-only responsibilities and personalisations; updates to configuration must target the underlying IGS_CA_DA_CONFIGS table through the supported IGS application forms.