Search Results calp_set_alias_value

Overview

The IGSFV_CAL_PRD_EVNT_PAIRS view is a reporting and integration object within the Oracle EBS IGS — Student System module (now classified as obsolete). It presents the full entity representation of Calendar Period Event Pairs, a construct that stores the pairing of two date alias instances and enables the definition of a period of time inclusive of both date aliases. In the academic calendar model, this allows institutions to express span-based periods — for example, the interval between an enrolment open date and an enrolment close date, or between term start and term end — in terms of abstract date aliases rather than literal dates. Because the view resolves alias instances into actual (derived and absolute) date values, it serves as a convenient reporting source for downstream calendaring, scheduling, and integration logic. Note that the view is documented as not implemented in the supplied database, and the underlying IGS product line is obsolete, so it should be treated as a legacy artifact.

Underlying Base Objects

The view is defined over three base tables. The driving table is IGS_CA_DA_INST_PAIR (aliased DA), which physically stores each pairing of two date alias instances. It is joined twice to IGS_CA_DA_INST (aliased DA1 and DA2) to resolve the primary alias instance and its related alias instance respectively. The join predicates match on DT_ALIAS, SEQUENCE_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER for both sides. The query is declared WITH READ ONLY, confirming that the view is strictly a reporting surface over these tables. Resolution of the alias instances into calendar dates is delegated to two generated package functions: IGS_CA_GEN_001.CALP_SET_ALIAS_VALUE and IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI. Although ETRM documents no referenced base objects explicitly, these three tables and two package functions constitute the functional dependency chain.

Key Columns

DATE_ALIAS, DATE_ALIAS_INST_SEQ_NUM, CALENDAR_TYPE, CAL_INST_SEQ_NUM — identify the primary date alias instance (the "from" side of the pair).
RELATED_DATE_ALIAS, RELATE_DATE_ALIAS_INST_SEQ_NUM, RELATED_CALENDAR_TYPE, RELATED_CAL_INST_SEQ_NUM — identify the related date alias instance (the "to" side of the pair).
DATE_ALIAS_INST_ABSOLUTE_VALUE, DATE_ALIAS_INST_ALIAS_VALUE, DATE_ALIAS_INST_DERIVED_VALUE — the three resolved date values for the primary instance. The derived value comes from CALS_CLC_DT_FROM_DAI; the alias value is computed by CALP_SET_ALIAS_VALUE over that derived date.
REL_DATE_ALIAS_INST_ABSOLT_VAL, REL_DATE_ALIAS_INST_ALIAS_VAL, REL_DATE_ALIAS_INST_DERVD_VAL — the equivalent resolved date values for the related instance.
CREATED — the creation timestamp inherited from the underlying pair record (the view text also exposes CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE).

Common Use Cases and Queries

Typical uses include reporting on period definitions expressed between two date aliases, validating that a span falls within a calendar instance, and feeding integrations that require concrete dates for a named period. Because the view resolves values through package functions, callers should expect row-by-row function execution and plan queries with selective predicates on calendar type or alias.

SELECT DATE_ALIAS,
       DATE_ALIAS_INST_DERIVED_VALUE,
       RELATED_DATE_ALIAS,
       REL_DATE_ALIAS_INST_DERVD_VAL
  FROM IGSFV_CAL_PRD_EVNT_PAIRS
 WHERE CALENDAR_TYPE = :p_cal_type
   AND CAL_INST_SEQ_NUM = :p_seq_num;

A second common pattern filters by the primary alias to retrieve every related span that begins at that alias:

SELECT RELATED_DATE_ALIAS,
       REL_DATE_ALIAS_INST_DERVD_VAL
  FROM IGSFV_CAL_PRD_EVNT_PAIRS
 WHERE DATE_ALIAS = :p_date_alias
 ORDER BY REL_DATE_ALIAS_INST_DERVD_VAL;

Given the obsolete status of the IGS module and the note that the view is not implemented in the supplied database, consumers on 12.1.1 or 12.2.2 should verify object existence before relying on it, and should prefer the current Student System calendaring APIs where available.

View: IGSFV_CAL_PRD_EVNT_PAIRS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSFV_CAL_PRD_EVNT_PAIRS, object_name:IGSFV_CAL_PRD_EVNT_PAIRS, status:VALID, product: IGS - Student System , description: This is the full view for the entity Calendar Period Event Pairs that stores the pairing of two date alias instances and enables the definition of a period of time inclusive of the two date aliases. , implementation_dba_data: APPS.IGSFV_CAL_PRD_EVNT_PAIRS ,
View: IGSBV_CAL_PRD_EVNT_PAIRS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSBV_CAL_PRD_EVNT_PAIRS, object_name:IGSBV_CAL_PRD_EVNT_PAIRS, status:VALID, product: IGS - Student System , description: This is the base view for the entity Calendar Period Event Pairs that stores the pairing of two date alias instances and enables the definition of a period of time inclusive of the two date aliases. , implementation_dba_data: APPS.IGSBV_CAL_PRD_EVNT_PAIRS ,
View: IGSFV_CAL_PRD_EVNT_OFSTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSFV_CAL_PRD_EVNT_OFSTS, object_name:IGSFV_CAL_PRD_EVNT_OFSTS, status:VALID, product: IGS - Student System , description: This is the full view for the entity Calendar Period Event Offset that describes the relationship between two date alias instances. , implementation_dba_data: APPS.IGSFV_CAL_PRD_EVNT_OFSTS ,
View: IGSBV_CAL_PRD_EVNT_OFSTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSBV_CAL_PRD_EVNT_OFSTS, object_name:IGSBV_CAL_PRD_EVNT_OFSTS, status:VALID, product: IGS - Student System , description: This is the base view for the entity Calendar Period Event Offset that describes the relationship between two date alias instances. , implementation_dba_data: APPS.IGSBV_CAL_PRD_EVNT_OFSTS ,
View: IGS_CA_DA_INST_ALIAS_VAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_CA_DA_INST_ALIAS_VAL_V, object_name:IGS_CA_DA_INST_ALIAS_VAL_V, status:VALID, product: IGS - Student System , description: This view is used to provide derived, absolute and effective dates for the date alias instance. , implementation_dba_data: APPS.IGS_CA_DA_INST_ALIAS_VAL_V ,
View: IGSBV_CALENDAR_PERIOD_EVENTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSBV_CALENDAR_PERIOD_EVENTS, object_name:IGSBV_CALENDAR_PERIOD_EVENTS, status:VALID, product: IGS - Student System , description: This is the base view for the entity Calendar Period Event that describes an instance of a date alias in a calendar instance. , implementation_dba_data: APPS.IGSBV_CALENDAR_PERIOD_EVENTS ,
View: IGSFV_CALENDAR_PERIOD_EVENTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSFV_CALENDAR_PERIOD_EVENTS, object_name:IGSFV_CALENDAR_PERIOD_EVENTS, status:VALID, product: IGS - Student System , description: This is the full view for the entity Calendar Period Event, describes an instance of a date alias in a calendar instance. , implementation_dba_data: APPS.IGSFV_CALENDAR_PERIOD_EVENTS ,
View: IGS_CA_DA_INST_DISPLAY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_CA_DA_INST_DISPLAY_V, object_name:IGS_CA_DA_INST_DISPLAY_V, status:VALID, product: IGS - Student System , description: Used to provide derived, absolute and effective dates for the date alias instance. It is used in conjunction with the inquire on date alias instance form to provide a meaningful description when displaying date alias instance values. , implementation_dba_data: APPS.IGS_CA_DA_INST_DISPLAY_V ,
View: IGS_CA_DA_INST_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_CA_DA_INST_V, object_name:IGS_CA_DA_INST_V, status:VALID, product: IGS - Student System , description: This view is used to provide derived, absolute and effective dates for the date alias instance. It also resolves any offset constraints which apply to the date alias instance. , implementation_dba_data: APPS.IGS_CA_DA_INST_V ,