Search Results calpl_constraint_resolve

Overview

IGS_CA_GEN_002 is a public PL/SQL package body owned by APPS within the Oracle E-Business Suite calendar (IGS) schema, classified under the ETRM registry as OTHER. It provides the core date-derivation and constraint-resolution engine for the academic calendar subsystem. Its principal responsibility is to accept a calendar date value derived from an offset definition and to resolve any alias offset constraints that apply to that offset, returning the corrected date. Constraint evaluation covers positive and negative conditions such as MUST and MUST NOT, day-of-week restrictions (MONDAY through SUNDAY), and related calendar rules drawn from the S_DT_OFFSET_CONSTRAINT_TYPE lookup. The package is heavily reused: the ETRM metadata records references from 33 other packages, placing it among the foundational utilities of the Student Systems calendar architecture in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

Seven documented program units are exposed by the package:

• CALP_CLC_DAIO_CNSTRT — the primary constraint resolver. It accepts a date-instance value derived from a date offset, resolves any date alias offset constraints registered against that offset, and returns the modified date. The header comments show that a performance enhancement (Bug #2442220) replaced two complex cursors with four simpler cursors and refined the local functions calpl_holiday_resolve and calpl_inst_break_resolve.
• CALP_CLC_DAO_CNSTRT — applies date offset constraint resolution logic, complementing CALP_CLC_DAIO_CNSTRT in the offset processing path.
• CALP_CLC_DT_FROM_DA — computes a concrete date from a date-alias definition.
• CALP_CLC_DT_FROM_DAI — computes a concrete date from a date-alias-instance definition, incorporating instance-specific context.
• CALS_CLC_DT_FROM_DAI — a wrapper form of the date-alias-instance calculation, typically exposing the same logic without the private-package prefix for external callers.
• CALP_CLC_WK_OF_MONTH — derives the ordinal week-of-month position for a given date, which is required when resolving constraints such as "third Monday of the month".
• CALP_VAL_CI_CAT — validates calendar instance category values, ensuring the calling context supplies a legitimate category before date resolution proceeds.

Tables Accessed

The package reads and writes the core calendar and date-instance tables through APPS synonyms. IGS_CA_DA_INST and IGS_CA_DA_INST_OFST store date-instance rows and their offset relationships; IGS_CA_DA_INST_OFCNT and IGS_CA_DA_OFFCNT hold offset constraint records; IGS_CA_DA_INST_PAIR supports paired date-instance definitions. IGS_CA_DA_OFST provides the offset definitions themselves, while IGS_CA_STAT and IGS_CA_TYPE supply the calendar status and calendar type reference data used to scope a resolution request. Together these tables form the persistent model against which the constraint engine evaluates holidays, institutional breaks, and alias offset rules.

Usage Notes

IGS_CA_GEN_002 is invoked indirectly rather than end-user-facing. Calendar maintenance forms, calendar generation concurrent programs, enrolment and scheduling logic, and custom extensions that need a resolved teaching or census date all call into this package or into one of the 33 packages that depend on it. Because calendar dates are a prerequisite for term-based processing, the package executes during high-volume batch windows, which explains the historical emphasis on cursor simplification and performance tuning noted in the source header. Callers should supply a valid calendar type, sequence number, and alias value, and must handle the output message parameter that reports constraint-resolution failures. As with all APPS-owned IGS packages, custom code should reference it by synonym and avoid direct modification.