Search Results igs_ad_prd_ps_of_opt_seq_num_s

Overview

IGS_AD_INS_ADMPERD is a PL/SQL package body owned by the APPS schema that supports the Oracle E-Business Suite Student System (Student Information / Admissions) module. Its name reflects its role: IGS_AD_INStance ADMinistration PERioD processing. The package encapsulates the business logic used to create and maintain admission period instance records and the related optional-pattern sequence and category data that drive admissions processing.

The package is classified as an OTHER API, indicating it is primarily an internal engine consulted by other Student System components rather than a public, documented integration interface. It is not referenced by any other database object, and the object is reported as VALID in the 12.1.1 ETRM repository, which confirms that all cited dependencies resolve correctly in that release.

The search term "igs_ad_prd_ps_of_opt_seq_num_s" corresponds to one of the tables the package touches, IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S, which stores sequence numbers for optional admission program-of-study patterns. The package reads and maintains this table through its associated handler package.

Key Procedures and Functions

• ADMP_INS_ACADCI_ROLL — Handles the insertion of academic career instance / roll data for an administration period. It drives career-instance associations that link applicants to the correct academic career for the admission period being processed.
• ADMP_INS_APAPC_APCOO — Processes the association between application and applicant program-of-study choices against the admission period. This routine is the primary path through which optional program patterns and their sequence references are created or refreshed.
• ADMP_INS_ADM_CI_ROLL — Inserts admission career-instance roll records for the administration period, completing the career-level instantiation for the admission cycle.

All three procedures share a common naming convention (ADMP_INS_*) that denotes insertion of administration-period data. The package relies on the shared validation packages IGS_AD_PERD_AD_CAT_PKG, IGS_AD_PRD_AD_PRC_CA_PKG, and IGS_AD_PRD_PS_OF_OPT_PKG to enforce categorisation, category association, and optional-pattern rules, and on IGS_GE_MSG_STACK, APP_EXCEPTION, and FND_MESSAGE for error handling.

Tables Accessed

• IGS_AD_PECRS_OFOP_DT — period-of-study optional offering detail used during admission processing.
• IGS_AD_PERD_AD_CAT — admission period to admission category mapping, validated via its handler package.
• IGS_AD_PRD_AD_PRC_CA — program-of-study to admission category association.
• IGS_AD_PRD_PS_OF_OPT — optional program-of-study patterns.
• IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S — sequence numbers for optional patterns; the target of the searched identifier.
• IGS_AD_APPL — the applicant/master admissions record.
• IGS_CA_INST and IGS_CA_INST_REL — calendar instance and instance relationship definitions used to resolve academic periods.
• IGS_CA_TYPE — calendar type lookup providing the valid instance types.
• IGS_PS_OFR_PAT — program offering pattern, providing the pattern context for the optional sequence numbers.
• IGS_GE_S_LOG — system log table used for audit and diagnostic messages.
• DUAL — used for PL/SQL scalar evaluation and lookup validation.

Usage Notes

The package is invoked from Student System admissions forms and concurrent processes when an admission period instance is created or rolled, for example during admission-cycle roll forward. It is not intended for direct external calls; customisations should treat it as an internal API and instead call the documented validation and handler packages. Because it is not referenced by any other object and carries an OTHER classification, integrators should exercise particular care with upgrade testing across 12.1.1 and 12.2.2, where the underlying table structures and validation packages may differ. Error conditions are surfaced through IGS_GE_MSG_STACK and FND_MESSAGE, and processing activity is recorded in IGS_GE_S_LOG.