Search Results get_fk_igs_or_unit

Overview

IGS_OR_ADDR_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in the ETRM as an "OTHER" API. It belongs to the Oracle Student System (IGS) module and, based on its naming and structure, supports validation of organizational unit address data. The package is defined with AUTHID CURRENT_USER and, per its header comment, carries a version identifier of 115.4 dated 2002/02/12. It is a validation-oriented package: its declared members exist to confirm that foreign-key relationships and primary-key combinations hold true before dependent address records are inserted, updated, or processed. The package does not itself perform DML; instead it exposes assertion-style calls that raise errors or return status when the referenced data is missing or inconsistent.

Key Procedures and Functions

The package exposes four documented members, one function and three procedures.

• GET_PK_FOR_VALIDATION — a function that validates a composite primary key for an organizational unit address record. Its parameter set (organization unit code, organization unit start date, address type, and start date) indicates it checks the uniqueness/existence of a full key combination before a record is accepted. It returns a BOOLEAN.
• GET_FK_IGS_CO_ADDR_TYPE — a procedure that validates a foreign-key reference to the IGS_CO_ADDR_TYPE entity, confirming the supplied address type is defined.
• GET_FK_IGS_OR_UNIT — a procedure that validates a foreign-key reference to the IGS_OR_UNIT entity (the organization unit), using an organization unit code and start date. This is the member most commonly associated with the "get_fk_igs_or_unit" search term.
• GET_FK_IGS_PE_SUBURB_POSTCD — a procedure that validates a foreign-key reference to a suburb/postcode entity, taking a numeric postcode.

No invented parameter lists are attributed to these members; the documented signatures are as shown in the source comment lines.

Tables Accessed

The ETRM metadata does not enumerate specific base tables accessed via APPS synonyms. However, the validation targets referenced in the procedure names imply dependencies on the organization unit table (IGS_OR_UNIT), the address type table (IGS_CO_ADDR_TYPE), and a suburb/postcode table associated with the IGS_PE prefix. These are read during validation to confirm the existence of the referenced keys; the package is not documented as writing to any table.

Usage Notes

IGS_OR_ADDR_PKG is referenced by zero other packages according to the documented metadata, indicating it is invoked at the application layer rather than being called by other PL/SQL APIs. Typical invocation would be from Oracle Forms or custom validation code that manages organizational unit addresses within the Student System, calling the FK validation procedures before committing a record, or invoking GET_PK_FOR_VALIDATION to confirm a candidate primary key. Because these are validation helpers, callers must handle the raised exceptions or BOOLEAN return values themselves. The same package definition is expected to remain valid across EBS 12.1.1 and 12.2.2, as the IGS module schema is largely shared between these releases.