Search Results get_orig_sys_reference_rec_5




Overview
Explore in AI Chat

Overview

The APPS.HZ_ORIG_SYSTEM_REF_PVT_JW package is a private PL/SQL API in the Oracle E-Business Suite Trading Community Architecture (TCA) model, specifically governing the creation and maintenance of Original System References and their entity mappings. In Oracle EBS 12.1.1 and 12.2.2, the TCA data model stores parties, locations, and contacts alongside "original system references" that track the source system and source identifier from which each record was imported. This package provides the underlying business logic — declared with AUTHID CURRENT_USER — that validates and persists those references and their mappings between the originating (legacy) key and the TCA entity key. The _JW suffix identifies it as an internal implementation package (the "JW" wrapper), whose public procedures are invoked by the corresponding _PVT layer rather than directly by end users.

Key Procedures and Functions

ETRM documents seven procedures in this package, all of which follow the standard TCA API return convention (return status, message count, and message data). They fall into two logical groups.

  • CREATE_ORIG_SYS_ENTITY_MAPP_1 — Creates an original system entity mapping record, associating an originating system reference with its TCA entity.
  • UPDATE_ORIG_SYS_ENTITY_MAPP_2 — Updates an existing original system entity mapping. This is the procedure matched by the search term update_orig_sys_entity_mapp_2. It carries an in-out p_object_version_number for optimistic locking, alongside the standard message-list, validation-level, and return-status parameters.
  • CREATE_ORIG_SYSTEM_REFERENC_3 — Creates an original system reference record capturing the source system and source identifier.
  • UPDATE_ORIG_SYSTEM_REFERENC_4 — Updates an existing original system reference.
  • GET_ORIG_SYS_REFERENCE_REC_5 — Retrieves an original system reference record by its key.
  • CREATE_ORIG_SYSTEM_6 — Creates an original system definition used to register a source system.
  • UPDATE_ORIG_SYSTEM_7 — Updates an existing original system definition.

Each creation and update procedure includes a p_init_msg_list flag controlling message-stack initialization and a p_validation_level parameter governing the depth of validation applied.

Tables Accessed

The ETRM metadata does not enumerate the underlying tables accessed through APPS synonyms. By function, the procedures operate against the TCA original-system reference structures — principally HZ_ORIG_SYSTEM_REFERENCES and the entity mapping table HZ_ORIG_SYS_ENTITY_MAPPINGS — together with HZ_ORIG_SYSTEMS for the CREATE_ORIG_SYSTEM_6 and UPDATE_ORIG_SYSTEM_7 procedures. The mapping procedures read and write the mapping rows that link each source-system identifier to the corresponding TCA party, location, or contact entity.

Usage Notes

As a private (_PVT family) implementation package, HZ_ORIG_SYSTEM_REF_PVT_JW is not intended for direct invocation by customers. It is called by the public TCA API layer and by concurrent programs and forms that import or reconcile legacy data into the Trading Community model. Typical scenarios include bulk migration of customer or party records from a legacy ERP, where the original system reference preserves traceability to the source record. The metadata records that this package is referenced by zero other packages and references no documented APPS synonyms, indicating it sits beneath the public TCA API surface. Customizations should call the corresponding public HZ APIs rather than this private layer, since its signature and internal behavior are subject to change across patch levels and point releases.