Search Results prc_pe_addr

Overview

IGS_AD_IMP_005 is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the ETRM as an "OTHER" API. It forms part of the Oracle Student System (formerly Oracle Student Systems / IGS) inbound interface layer, responsible for importing and validating person-level address, visa, passport, and related statutory data into the EBS foundation tables (typically via the Trading Community Architecture / HZ and IGS person entities). The package is closely associated with the IGS_AD_IMP_002 package, since the documented change history shows IGS_AD_IMP_005 calling IGS_AD_IMP_002.create_address to persist address records. The heading date (IGSAD83B.pls 115.80) and the accumulated change history entries confirm that this package was actively maintained through multiple statutory and migration builds, including the SEVIS (Student and Exchange Visitor Information System) build and the RCT build. It is a foundational component in the person data inbound flow rather than a user-facing screen or reporting object.

Key Procedures and Functions

The ETRM metadata records no separately documented procedures or functions for this package body (0 total), so the following is drawn from the embedded source header comments. The most directly relevant routine, given the user's search term, is prc_pe_addr — the person address processing procedure. Its documented behaviour includes the following:

• It processes inbound person address interface records, selecting records with interface status values of '1' and '4' only (Bug 2327077).
• It calls IGS_AD_IMP_002.create_address to create the address, and does not pass cust_account_id to that call (SWCR008 / Bug 2225917).
• A check for obtaining cust_acct_id was removed from the procedure, and calls to HZ_CUSTOMER_ACCOUNTS.CREATE_ACCT_SITE_USES and HZ_CUSTOMER_ACCOUNTS.UPDATE_ACCT_SITE_USES were removed.
• An incorrect join between interface_addr_id and interface_id was corrected (Bug 2381539).
• Cursor C1 and its references, along with the p_acct_site_uses_rec variable, were removed.

Other documented procedures within the package handle deletion of records for statistics source categories (a new interface table race was introduced under person statistics), and processing of inquiry lines (RCT build).

Tables Accessed

The ETRM metadata lists no APPS synonyms for this object, but the change history explicitly names the interface tables whose references were added or removed:

• igs_pe_visa_int — inbound visa data interface table (added in the SEVIS build).
• igs_pe_vst_hist_int — visa history interface table (added in the SEVIS build).
• igs_pe_passport_int — passport data interface table (added in the SEVIS build).
• igs_pe_eit_int — employment/eligibility interface table (added in the SEVIS build).
• References to igs_ad_intl_int and igs_pe_fund_dep_int were removed.
• An interface table race was created under person statistics source category, with a corresponding delete procedure.

Address creation is delegated to IGS_AD_IMP_002, which writes to the underlying HZ person address structures; IGS_AD_IMP_005 does not itself call the HZ account-site-uses APIs.

Usage Notes

IGS_AD_IMP_005 is not typically invoked directly by end users. It is designed to be driven by the person inbound interface process — normally executed as part of the IGS person import concurrent program, in batch, after source data has been staged in the relevant igs_pe_*_int interface tables. Status-driven record selection means the calling process must set the interface status flag appropriately ('1' or '4') for prc_pe_addr to pick up a row. Because the package interfaces with Trading Community Architecture / HZ error handling, callers should expect more than one HZ error to be reported per record (Bug 2338473). Custom extensions should generally call the parent import concurrent program rather than prc_pe_addr directly, and any re-use must respect the interface status and join semantics corrected under Bug 2381539.