Search Results igs_ps_gen_004




Overview
Explore in AI Chat

Overview

IGS_PS_GEN_004 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (IGS) product family. Its object name and dependencies indicate a role within the students and program delivery area, specifically supporting date and scheduling calculations for unit offerings, delivery calendars, and student unit attempts. The package is marked VALID and is documented as an OTHER classification API, meaning it is not a formally published public API but is instead an internal generation utility consumed by other IGS packages. It is referenced by IGS_FI_FND_SRC_RSTN_PKG, IGS_FI_GEN_008, IGS_PS_CREATE_GENERIC_PKG, and IGS_PS_GEN_001, and it in turn references itself, which is characteristic of a shared utility with internal recursion or re-use across sibling modules. In EBS 12.1.1 and 12.2.2, this package operates against standard APPS synonyms and relies on the ETRM-documented dependency chain rather than any EBS-specific schema changes.

Key Procedures and Functions

The documented package exposes twelve procedures and functions, primarily oriented toward calendar, offset, and constraint processing:

  • CRSP_INS_FSR_HIST — Inserts history records for funding source restriction processing.
  • CRSP_VAL_CALL_NBR — Validates a call number for restriction processing.
  • RECAL_DL_DATE — Recalculates delivery calendar dates, typically after offset or holiday changes.
  • CALPL_CONSTRAINT_RESOLVE — Resolves constraint conflicts during calendar planning.
  • F_RETENTION_OFFSET_DATE — Returns a retention offset date used in delivery calendar calculations.
  • GET_WEEKENDS — Retrieves weekend days applicable to a given calendar context.
  • POPULATE_HOLIDAYS — Populates holiday records for calendar generation.
  • DURATION_DAYS — Computes the duration in days between two dates, excluding non-teaching periods where applicable.
  • MEETING_DAYS — Determines valid meeting or teaching days for a unit offering.
  • SORT_DATE_ARRAY — Sorts an array of dates, supporting downstream date sequencing.
  • GET_INST_CONSTRAINT_ID — Retrieves the instance constraint identifier associated with a calendar instance.
  • ROUND_UP — Performs numeric round-up logic used in calendar or duration calculations.

Tables Accessed

The package reads and writes several IGS base tables through APPS synonyms. Delivery and offset logic draws on IGS_EN_DL_OFFSET_CONS, IGS_EN_NSTD_USEC_DL, IGS_EN_NSD_DLSTP_ALL, IGS_EN_NSU_DLSTP_ALL, and IGS_EN_DISC_DL_CONS for non-standard, offset, and discontinuation rules. Calendar instance data is sourced from IGS_CA_DA_INST, IGS_CA_DA_INST_PAIR, IGS_CA_INST_ALL, IGS_CA_STAT, and IGS_CA_TYPE. Unit offering and student unit attempt context comes from IGS_PS_UNIT_OFR_OPT_ALL, IGS_PS_NSUS_RTN, and IGS_PS_STAT. DUAL and PLITBLM support PL/SQL utility and array operations. These tables are used to resolve constraints, populate holidays, and calculate valid meeting and duration days.

Usage Notes

IGS_PS_GEN_004 is not intended for direct invocation by end users. It is typically called by higher-level IGS generation packages such as IGS_PS_GEN_001, IGS_PS_CREATE_GENERIC_PKG, IGS_FI_GEN_008, and IGS_FI_FND_SRC_RSTN_PKG, as well as indirectly from student system forms and concurrent programs that build or recalculate delivery calendars and unit offerings. Custom code extending IGS calendar logic should follow the same call pattern and treat the procedures as internal utilities, validating inputs against the documented table dependencies. Because the package is self-referencing and referenced by four other packages, changes to its signatures can ripple across the student system generation chain, so it should be treated as a controlled dependency during upgrades from 12.1.1 to 12.2.2.