Search Results igs_pe_language_cd_pkg




Overview
Explore in AI Chat

Overview

IGS_PE_LANGUAGE_CD_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in the ETRM repository as an "OTHER" API within the People Enterprise (IGS_PE) product family. It encapsulates the data-access and maintenance logic for the IGS_PE_LANGUAGE_CD entity, which stores language code definitions used by the student systems and related person-entity modules. Its central role is to provide a controlled, reusable layer between the language code table and the many components that must create, modify, validate, or delete language records without issuing direct DML. By centralizing row-level locking, constraint validation, and primary/foreign key resolution, the package enforces data integrity consistently and isolates callers from schema-level changes.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions in this package. Their purposes are as follows:

  • INSERT_ROW — Inserts a new language code record into the underlying table, applying the package's standard column derivation and validation logic.
  • LOCK_ROW — Acquires a row-level lock on an existing language code record to serialize concurrent updates and prevent lost-update conditions.
  • UPDATE_ROW — Modifies an existing language code record, typically invoked after LOCK_ROW has secured the row.
  • ADD_ROW — Provides the higher-level entry point for adding a language code, orchestrating key resolution and validation before the physical insert.
  • DELETE_ROW — Removes a language code record, subject to the referential and business validation checks applied by the package.
  • GET_PK_FOR_VALIDATION — Resolves the primary key of the language code record so that callers can validate its existence and pass the correct identifier downstream.
  • GET_FK_IGS_PE_GOV_LANG_CD — Returns the foreign key linking a language code to its corresponding government language code record, supporting cross-entity validation.
  • CHECK_CONSTRAINTS — Verifies the business and referential constraints associated with a language code row prior to committing DML.
  • BEFORE_DML — Executes the standard pre-DML processing, such as auditing column population and WHO-column handling, before any insert, update, or delete is applied.

Tables Accessed

The package operates on a single documented table, IGS_PE_LANGUAGE_CD, accessed through the APPS synonyms. This table holds the language code definitions against which inserts, updates, deletes, locks, and validation lookups are performed. The foreign-key accessor GET_FK_IGS_PE_GOV_LANG_CD indicates a logical relationship to the government language code entity (IGS_PE_GOV_LANG_CD), which the package uses when validating that a language code is consistent with its government-level counterpart.

Usage Notes

IGS_PE_LANGUAGE_CD_PKG is referenced by two other packages: IGS_AD_TER_EDU_PKG and IGS_PE_GOV_LANG_CD_PKG. This dependency pattern shows that language code maintenance is consumed both by admissions/terminal-education processing and by the government language code package, meaning any modification to this package can affect downstream academic and regulatory data flows. Its dependency on SYS.STANDARD is limited to Oracle's built-in PL/SQL package, reflecting a self-contained implementation. Typical invocation paths include Oracle Forms-based setup windows that maintain language code lists, concurrent programs that load or reconcile language data, and custom extensions that require validated language lookups. Because the package is a public APPS schema object with status VALID, customizations should call its documented procedures rather than issuing direct DML against IGS_PE_LANGUAGE_CD; direct table manipulation bypasses the locking, constraint checking, and BEFORE_DML logic that preserve data integrity. Any modification should be regression-tested against the two dependent packages, and the "show dependent code" references in ETRM should be reviewed to confirm the complete call graph before changes are promoted between 12.1.1 and 12.2.2 environments.