Search Results hz_orig_system_ref_pvt_jw

Overview

APPS.HZ_ORIG_SYSTEM_REF_PVT_JW is a private PL/SQL package body within the Oracle E-Business Suite Trading Community Architecture (TCA) schema. Its purpose is to support the maintenance and retrieval of original system reference data, which underpins how TCA records the relationship between a party or entity in Oracle EBS and its corresponding identifier in an external or legacy source system. The "JW" suffix in the package name indicates that this is a wrapper package generated or maintained to bridge the public API layer with the underlying private implementation, typically to enforce consistent validation, error handling, and API processing conventions.

The package depends on FND_API, HZ_ORIG_SYSTEM_REF_PUB, HZ_ORIG_SYSTEM_REF_PVT, and itself as part of the standard TCA API stack. This layered structure is characteristic of TCA, where public packages expose user-callable APIs while private ("_PVT") packages contain the core business logic that must not be invoked directly.

Key Procedures and Functions

The package body exposes seven documented procedures that cover the standard create, update, and query lifecycle for the original system reference entity and its associated entity mappings. They are:

CREATE_ORIG_SYS_ENTITY_MAPP_1 — Creates a mapping record linking an original system entity to its corresponding TCA entity representation.
UPDATE_ORIG_SYS_ENTITY_MAPP_2 — Updates an existing entity mapping record, typically to reflect corrections or changed source identifiers.
CREATE_ORIG_SYSTEM_REFERENC_3 — Creates a new original system reference record, capturing the external identifier and its association to the target TCA entity.
UPDATE_ORIG_SYSTEM_REFERENC_4 — Updates an existing original system reference record.
GET_ORIG_SYS_REFERENCE_REC_5 — Retrieves an original system reference record, used to resolve an external identifier back to its Oracle entity.
CREATE_ORIG_SYSTEM_6 — Creates an original system definition entry, establishing the source system identifier itself.
UPDATE_ORIG_SYSTEM_7 — Updates an existing original system definition.

Parameter lists are not documented and should be confirmed against the actual package source in the target environment before use.

Tables Accessed

Direct table references are not enumerated in the ETRM metadata for this package body. In practice, the procedures operate against the TCA original system reference tables, primarily HZ_ORIG_SYSTEMS, HZ_ORIG_SYSTEMS_REF, and HZ_ORIG_SYS_ENTITY_MAP, which hold system definitions, reference identifiers, and entity mappings respectively. Access is typically mediated through APPS synonyms and the underlying private package logic.

Usage Notes

This is a private implementation package and is not referenced by any other database object per the dependency documentation. It is not intended for direct invocation by end users or custom code. Typical invocation occurs indirectly through HZ_ORIG_SYSTEM_REF_PUB and its TCA public API counterparts, which are called from Oracle forms, concurrent programs, and intercompany or data-migration routines that register external system references during party, account, and contact imports. Developers extending TCA should call the public API layer rather than this package, and should verify the exact parameter signatures from the deployed source in 12.1.1 or 12.2.2, as the metadata here does not define them.

PACKAGE BODY: APPS.HZ_ORIG_SYSTEM_REF_PVT_JW 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_ORIG_SYSTEM_REF_PVT_JW, status:VALID,
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PVT_JW 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_ORIG_SYSTEM_REF_PVT_JW, status:VALID,
PACKAGE BODY: APPS.HZ_ORIG_SYSTEM_REF_PVT_JW 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_ORIG_SYSTEM_REF_PVT_JW, status:VALID,
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PVT_JW 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_ORIG_SYSTEM_REF_PVT_JW, status:VALID,
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_ORIG_SYSTEM_REF_PVT, status:VALID,
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_ORIG_SYSTEM_REF_PVT, status:VALID,
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_ORIG_SYSTEM_REF_PUB, status:VALID,
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_ORIG_SYSTEM_REF_PUB, status:VALID,
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PVT_JW 12.2.2
PACKAGE: APPS.HZ_ORIG_SYSTEM_REF_PVT_JW 12.1.1
PACKAGE BODY: APPS.HZ_ORIG_SYSTEM_REF_PVT_JW 12.2.2
PACKAGE BODY: APPS.HZ_ORIG_SYSTEM_REF_PVT_JW 12.1.1
APPS.HZ_ORIG_SYSTEM_REF_PVT_JW dependencies on HZ_ORIG_SYSTEM_REF_PVT_JW 12.2.2
APPS.HZ_ORIG_SYSTEM_REF_PVT_JW dependencies on HZ_ORIG_SYSTEM_REF_PVT_JW 12.1.1
APPS.HZ_ORIG_SYSTEM_REF_PVT_JW dependencies on HZ_ORIG_SYSTEM_REF_PVT 12.1.1
APPS.HZ_ORIG_SYSTEM_REF_PVT_JW dependencies on HZ_ORIG_SYSTEM_REF_PVT 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.FND_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
PACKAGE: APPS.FND_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,