Search Results imp_headers_rec_type

Overview

APPS.CN_IMP_HEADERS_PVT is a private (PVT-classified) PL/SQL package within the Oracle EBS Channel Management / Incentive Compensation module (CN schema prefix). It encapsulates the business logic for managing import header definitions used during bulk data import operations into the Channel Management import framework. Import headers act as the control record that describes an entire inbound data file or dataset — capturing the import type, source file names, delimiter and enclosure characters, header-row handling, and the mapping to a target import map.

The package centralizes create, update, and delete operations against the import header entity and provides a standardized mechanism to retrieve Oracle Error Stack messages. Because it is declared AUTHID CURRENT_USER and classified as a private API, it is not intended as a public integration entry point; rather, it is consumed internally by other CN packages and by the concurrent processing framework that orchestrates Channel Management imports. The module’s packaging pattern — separating a private worker package from a public wrapper — allows the framework to enforce validation, concurrency control through the OBJECT_VERSION_NUMBER column, and consistent error handling across all header-manipulation paths.

Key Procedures and Functions

Four documented routines make up the package surface:

• CREATE_IMP_HEADER — Inserts a new import header definition. It accepts a record based on the IMP_HEADERS_REC_TYPE structure, validates the incoming attributes, and persists a new row to CN_IMP_HEADERS, generating the surrogate IMP_HEADER_ID.
• UPDATE_IMP_HEADER — Modifies an existing import header. It applies changeable attributes (name, description, delimiters, file names, status, mappings) while relying on OBJECT_VERSION_NUMBER for optimistic locking so that concurrent updates do not silently overwrite one another.
• DELETE_IMP_HEADER — Removes an import header record, supporting cleanup when an import definition is obsolete or after processing completes.
• GET_OERR_MSG — Returns the message text from the Oracle Error Stack (OERR) for a given error code, providing a consistent mechanism for translating raised errors into readable messages.

No parameter lists are reproduced here, as the public documentation exposes only naming and purpose.

Tables Accessed

• CN_IMP_HEADERS — The primary table holding import header definitions; this is the principal target of the create, update, and delete operations.
• CN_IMP_HEADERS_S — The corresponding audit/shadow table, used to capture historical versions of header rows for audit and version tracking.
• CN_IMP_LINES — Child import line definitions associated with a header; referenced to validate or cascade header-level operations.
• CN_IMP_MAPS — Import map definitions; the header stores an IMP_MAP_ID linking the header to its column mapping.
• CN_PROCESS_AUDITS — Process audit records used to track import activity and outcomes for troubleshooting and audit purposes.

Usage Notes

Because ETRM classifies this package as PVT, it is normally invoked indirectly. Typical callers are other CN private and public packages (referenced by eight packages in the ETRM metadata) — for example, the import-processing and mapping-validation packages that orchestrate a Channel Management import run. The package may also be invoked from concurrent programs that stage and process inbound data files, and from Oracle Forms or OA Framework pages that let users define and edit import headers interactively.

Custom code should avoid calling this private package directly; instead, use the supported public wrapper that delegates to CN_IMP_HEADERS_PVT. Callers passing the IMP_HEADERS_REC_TYPE record must be aware of FND_API.G_MISS_* sentinel defaults, which signal “attribute not supplied” — this is critical especially during UPDATE to avoid overwriting existing values with nulls. The presence of OBJECT_VERSION_NUMBER supports optimistic locking, and proper exception handling using GET_OERR_MSG should be included in any consumer to surface meaningful diagnostics.