Search Results get_fk_igs_ad_prd_ad_prc_ca




Overview
Explore in AI Chat

Overview

IGS_AD_PRD_PS_OF_OPT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API taxonomy as OTHER. The package name resolves to "IGS Admissions Product Program of Study Option," indicating that it belongs to the Oracle Student System (OSS) admissions family of modules. Its business purpose is to manage the association records that link an admissions program of study to the options available within it, persisting these combinations in the IGS_AD_PRD_PS_OF_OPT table.

Functionally, the package exposes a standard Oracle Forms-generated table handler interface (INSERT_ROW, LOCK_ROW, UPDATE_ROW, ADD_ROW, DELETE_ROW, CHECK_CONSTRAINTS, BEFORE_DML) alongside a set of foreign key resolution routines. The header source indicates an AUTHID CURRENT_USER declaration, meaning the package executes with the privileges of the calling user rather than the definer, and the code base dates to the 11i era (Header IGSAI31S.pls 115.4, 2002) while remaining deployed in 12.1.1 and 12.2.2 instances. The package is referenced by seven other packages, confirming it as a shared dependency within the admissions data model.

Key Procedures and Functions

  • INSERT_ROW — Creates a new association record. Accepts the full composite key (admissions calendar type, calendar instance sequence, admission category, admission process type, course code, version number, academic calendar type, sequence number, location, attendance mode, attendance type) plus a rollover inclusion indicator, and returns the generated ROWID. A default mode parameter ('R') governs the insert behavior.
  • LOCK_ROW — Acquires a row-level lock using the ROWID and the composite key, providing optimistic concurrency control for Forms-based editing.
  • UPDATE_ROW — Modifies an existing association record identified by ROWID, applying the same key set and the mode parameter.
  • ADD_ROW — A wrapper-style insert routine that mirrors INSERT_ROW's signature and returns the ROWID, typically used where the forms layer must add a row without a pre-existing key.
  • DELETE_ROW — Removes the association record.
  • GET_PK_FOR_VALIDATION — Returns the primary key attributes so the calling form can validate that a complete, unique key exists before DML.
  • CHECK_CONSTRAINTS — Validates the record against required and referential constraints prior to committing.
  • BEFORE_DML — A pre-DML hook invoked by the Forms transaction trigger to perform housekeeping and derived-value logic.
  • GET_FK_IGS_EN_ATD_MODE — Resolves the foreign key to attendance mode.
  • GET_FK_IGS_AD_PRD_AD_PRC_CA — Resolves the foreign key to the admissions process category; this is the routine surfaced by the search term "get_fk_igs_ad_prd_ad_prc_ca."
  • GET_FK_IGS_EN_ATD_TYPE — Resolves the foreign key to attendance type.
  • GET_FK_IGS_PS_OFR — Resolves the foreign key to the program of study offering.
  • GET_FK_IGS_AD_LOCATION — Resolves the foreign key to the admissions location.

Tables Accessed

The package reads and writes a single documented base table, IGS_AD_PRD_PS_OF_OPT, accessed through the APPS synonym. This table stores the admissions program-of-study option combinations, keyed by admissions calendar and instance information, course and version, academic calendar, location, attendance mode and type, and the rollover inclusion indicator. The GET_FK_* routines additionally perform lookups against the parent reference tables implied by their names — attendance mode, attendance type, location, program of study offering, and the admissions process category — to validate and translate foreign key values into descriptive data for the forms layer.

Usage Notes

This package is a Forms-generated table handler and is invoked primarily from the Oracle Forms UI that maintains admissions program-of-study option setup. The forms call BEFORE_DML, CHECK_CONSTRAINTS, INSERT_ROW, UPDATE_ROW, LOCK_ROW, and DELETE_ROW through standard block-level triggers, while the GET_FK_* functions populate non-database foreign key display items. Because seven other packages reference it, direct calls may also originate from higher-level admissions APIs or concurrent programs that propagate option data. In 12.1.1 and 12.2.2 environments the package is not a public, supported integration API; custom code should generally avoid calling it directly and instead use the surrounding admissions product APIs, treating the GET_FK_* routines as read-only validation helpers. Any modification requires the APPS schema and should be validated against the seven dependent packages.