Search Results igs_pe_country_cd_pkg




Overview
Explore in AI Chat

Overview

IGS_PE_COUNTRY_CD_PKG is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite, belonging to the Oracle Student System (IGS) product family. It provides the core data access and manipulation logic for the IGS_PE_COUNTRY_CD entity, which stores country code reference data used across person, admissions, and academic records. In ETRM it is classified as a non-public API ("OTHER"), meaning it is intended primarily for internal consumption by other IGS packages and forms rather than as a documented public interface for external integrators. The package owns the standard Table API pattern — insert, update, delete, lock, and validation routines — that Oracle EBS generates for base tables, and it enforces the row-level constraints and foreign key relationships associated with the country code table. It carries a VALID status in both EBS 12.1.1 and 12.2.2, and its dependency graph is limited to SYS.STANDARD, confirming it relies on no other application packages for its own operation.

Key Procedures and Functions

The package exposes nine documented procedures and functions, consistent with an Oracle-generated Table API:

  • INSERT_ROW — Inserts a new record into the country code table, applying default and derived column values.
  • LOCK_ROW — Acquires a row-level lock on an existing country code record, typically used before a subsequent update to preserve concurrency control.
  • UPDATE_ROW — Modifies an existing country code record.
  • ADD_ROW — Performs a combined validation-and-insert operation, adding a row only after the associated business rules are satisfied.
  • DELETE_ROW — Removes an existing country code record from the table.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of the country code row so that it can be passed into validation logic.
  • GET_FK_IGS_PE_GOV_COUNTRYCD — Returns the foreign key reference linking the country code table to the government country code entity (stored in IGS_PE_GOV_COUNTRYCD).
  • CHECK_CONSTRAINTS — Validates that a proposed row satisfies the table's constraints, including uniqueness and referential integrity, before DML is committed.
  • BEFORE_DML — A pre-DML hook that performs last-mile validation, defaulting, and audit-stamping immediately prior to insert, update, or delete operations.

Tables Accessed

The package operates against a single documented base table, IGS_PE_COUNTRY_CD, referenced through its APPS synonym. This table holds the country code values consumed by person and admissions processing. The package reads rows to satisfy validation and lookup requests (GET_PK_FOR_VALIDATION, GET_FK_IGS_PE_GOV_COUNTRYCD) and writes rows through the insert, update, add, and delete procedures. No other application tables are directly accessed, simplifying the dependency footprint and making the package a self-contained data layer for this entity.

Usage Notes

IGS_PE_COUNTRY_CD_PKG is referenced by four other packages: IGS_PE_COUNTRY_CD_PKG itself (self-reference, arising from the generated Table API), IGS_PE_GOV_COUNTRYCD_PKG, IGS_AD_OS_SEC_EDU_PKG, and IGS_AD_OS_SEC_EDU_QF_PKG. These callers use the package when maintaining or validating country code data in the context of secondary education and government country code processing. In practice the package is invoked indirectly through Oracle Forms and OAF-based IGS user interfaces, from concurrent programs that maintain reference data, and from custom PL/SQL code that needs to read or modify country code records. Because the procedures form a Table API rather than a business-rule API, custom code should call the higher-level business packages (such as IGS_PE_GOV_COUNTRYCD_PKG) wherever possible and reserve direct use of this package for low-level data maintenance. Any modifications should respect the constraint-checking and BEFORE_DML sequencing to avoid corrupting the country code reference data that downstream person and admissions records depend upon.