Search Results create_import

Overview

IGS_OR_INST_IMP_003_PKG is the third component package body in the Oracle EBS Student Systems "Import Institutions" facility. It belongs to the Oracle Higher Education / Institutional Research (IGS) product family and is installed under the APPS schema. The package header comment block identifies its purpose explicitly: "This is the third part of Import Institutions Package." Its role is to process the staged institution data that has already been loaded into the IGS interface tables and to propagate that data into the canonical Oracle Trading Community Architecture (TCA) entities — parties, party sites, locations, contacts, contact points, and relationships.

The TCA-centric design is significant. When the importing institution record is promoted, the package resolves the corresponding hz_parties row (the party representing the institution or the contact person) and then creates the dependent TCA children: party sites, organization contacts, contact points, and relationship records. Change history entries confirm this evolution — for example, "In cursor cur_get_oss_contacts customer_id is removed and org_party_id is added," and several insert/update calls to igs_or_contacts_v and igs_or_phones_v had "all the attributes that references to customer … removed." This reflects the 11i-to-R12 migration away from the legacy customer model toward the unified HZ_PARTIES model, which is why a user searching for "hz_partie" surfaces this object.

Key Procedures and Functions

Four procedures are documented in the ETRM metadata:

• PROCESS_INSTITUTION_NOTES — Moves institution note records from the interface table into the target institution notes structures, handling the create-by/update-by audit columns and import-mode semantics.
• PROCESS_INSTITUTION_STATISTICS — Processes institution statistical data staged in IGS_OR_INST_STAT_INT. Change history records that stat_type_id was converted to stat_type_cd (Bug 2613704), so this procedure validates and maps the statistics type code against FND_LOOKUP_VALUES before insert.
• PROCESS_INSTITUTION_ADDRESS — Creates and maintains institution address records, resolving territory codes via FND_TERRITORIES and writing to the HZ location / party-site tables (HZ_LOCATIONS, HZ_PARTY_SITES, HZ_PARTY_SITE_USES).
• PROCESS_INSTITUTION_CONTACTS — Handles institution contact persons and their telephone/electronic details. Change history notes a validation added for contact party id (Bug 2730137) and the switch to relationship party id (rel_party_id_cur) so that contacts are attached to the correct relationship rather than a customer account role. Phone records are read from HZ_CONTACT_POINTS using owner_table_id, and country dialing codes are validated against HZ_PHONE_COUNTRY_CODES.

Tables Accessed

Interface (staging) tables consumed by this package include IGS_OR_INST_NTS_INT, IGS_OR_INST_STAT_INT, IGS_OR_INST_CON_INT, IGS_OR_ADR_INT, and IGS_OR_ADRUSGE_INT. Reference/lookup tables include FND_LOOKUP_VALUES and FND_TERRITORIES. Target TCA tables written or queried are HZ_PARTIES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_LOCATIONS, HZ_ORG_CONTACTS, HZ_CONTACT_POINTS, HZ_RELATIONSHIPS, and HZ_PHONE_COUNTRY_CODES. The interface views igs_or_contacts_v and igs_or_phones_v are invoked for insert_row/update_row operations.

Usage Notes

This package is invoked indirectly rather than directly by end users. It is referenced by one other package (the parent Import Institutions orchestrator) and is executed as part of the institution import process, typically triggered from the Institution Import form or a related concurrent program. Developers extending institution import should not call the procedures directly without first ensuring the interface tables are populated and the parent orchestration has run; interface table integrity and the CREATE_IMPORT create-mode convention (introduced per change history for IGS localization) are assumed. Error handling uses FND_MESSAGE-based message retrieval rather than FND_MESSAGE.GET, consistent with the 2003 changes.