Search Results igs_ad_imp_off_resp_data




Overview
Explore in AI Chat

Overview

IGS_AD_IMP_OFF_RESP_DATA is an Oracle EBS Advanced Product Catalog (formerly Oracle Product Hub / iSupplier) PL/SQL package owned by the APPS schema. Its documented purpose is tied to the Oracle internal reference "2395510," which places it in the admissions/enrollment (IGS_AD) family of packages governing applicant and offering responsibility data. Based on the package name (imp = import, off_resp = offering responsibility), the package fulfills the business function of importing offering responsibility records into the IGS_AD schema from an intermediate staging area. It is not a general-purpose data loader; it is scoped to processing a pre-validated batch of offering responsibility data represented by a batch identifier. The package executes with AUTHID CURRENT_USER, meaning that at runtime its unqualified references resolve to the calling user's schema, and privileges are checked against the invoker rather than the definer.

Key Procedures and Functions

The package exposes a single documented procedure, IMP_OFF_RESP. Consistent with the standard Oracle EBS concurrent-program entry point convention, the procedure accepts the two mandatory OUT NOCOPY parameters errbuf (VARCHAR2) and retcode (NUMBER) so it can be registered as a concurrent program, plus a batch identifier argument typed against IGS_AD_OFFRESP_BATCH.BATCH_ID and an optional p_yes_no parameter defaulting to '2'. The procedure's role is to drive the import of offering responsibility data associated with that batch. No other procedures or functions are documented for this package, and the parameter list shown is the documented signature — additional parameters should not be assumed.

Tables Accessed

The package reads from and writes to several IGS_AD and IGS_CA tables through APPS synonyms:

  • IGS_AD_OFFRESP_BATCH — the batch control table; the batch_id parameter keys the set of records to process.
  • IGS_AD_OFFRESP_INT — the interface/staging table holding incoming offering responsibility rows.
  • IGS_AD_OFFRESP_ERR and IGS_AD_OFFRESP_ERR_S — error logging tables and sequence used to record rows rejected during import.
  • IGS_AD_APPL_ALL and IGS_AD_PS_APPL_INST_ALL — application and application-instance tables validated against during import.
  • IGS_AD_PRD_AD_PRC_CA — offer/decision context data supporting the responsibility records.
  • IGS_CA_INST_REL, IGS_CA_TYPE — calendar/instance relationship and type reference data.
  • PLITBLM — the standard Oracle Applications PL/SQL character table, typically used for in-memory string collections.

These references indicate the procedure performs validation joins, moves staged rows to the application tables, and writes errors for failed rows.

Usage Notes

Because IMP_OFF_RESP follows the errbuf/retcode concurrent program signature, it is most commonly invoked as a concurrent program submitted from an Oracle EBS responsibility, typically after a batch has been loaded into IGS_AD_OFFRESP_INT and registered in IGS_AD_OFFRESP_BATCH. The p_yes_no parameter (default '2') controls processing behavior, though the documented metadata does not enumerate its permitted values or meaning, so its semantics should be confirmed against implementation code before use. The package is referenced by one other package within the ETRM catalog, indicating it also participates in a larger import pipeline rather than being invoked only standalone. Custom code may call the procedure directly, but callers must supply a valid batch_id and handle the retcode and errbuf outputs as with any concurrent program. This package is documented for EBS 12.1.1 and remains applicable to 12.2.2 unless superseded by a later IGS_AD release.