Search Results create_imp_header

Overview

APPS.CN_IMP_HEADERS_PVT is a private PL/SQL package body within the Oracle EBS Channel Management (CN) module, specifically associated with the Trade Management / Channel Revenue Management importer framework. The package encapsulates the business logic required to manipulate import header records that drive the CN_IMP_HEADERS import staging mechanism, which is used to load external transaction data into the E-Business Suite for downstream processing by channel and trade management programs.

The package body carries the source file designation cnvimhrb.pls and is maintained under the APPS schema in both Oracle EBS 12.1.1 and 12.2.2. It is classified as a Private (PVT) API, meaning it is intended for internal consumption by other packaged APIs rather than being called directly by external applications or integration code. The API versioning comment block documents the primary entry point at version 1.0, with standard FND_API-compliant parameters including p_api_version, p_init_msg_list, p_commit, and p_validation_level, along with the standard output parameters x_return_status, x_msg_count, and x_msg_data. This conformance to the Oracle Application Object Library API standard ensures consistent error handling, savepoint management, and message stack behavior.

Key Procedures and Functions

The package exposes four documented procedures:

• CREATE_IMP_HEADER — The primary procedure invoked by callers to create a new import header record. It accepts a record of type imp_headers_rec_type and returns the newly generated header identifier through x_imp_header_id. The procedure follows the standard API template, opening a savepoint, verifying API compatibility, initializing the message list when requested, and delegating to FND_MSG_PUB for error messaging.
• UPDATE_IMP_HEADER — Updates an existing import header record, supporting modifications to header attributes that flow through the importer staging process.
• DELETE_IMP_HEADER — Removes an import header record, typically used during cleanup or rollback scenarios within the importer workflow.
• GET_OERR_MSG — A helper routine that retrieves Oracle Error (OERR) message text, used to translate error codes into readable diagnostic messages during exception handling.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• CN_IMP_HEADERS — The main import header table storing header-level staging data.
• CN_IMP_HEADERS_S — The sequence or shadow/security table associated with the header structure, used to generate or validate header identifiers.
• CN_IMP_LINES — Import line records linked to headers, accessed as part of header validation and cascading operations.
• CN_IMP_MAPS — Mapping definitions that translate external column data to internal column structures during import processing.
• CN_PROCESS_AUDITS — Audit records capturing processing history for traceability and compliance.

Usage Notes

As a private package, CN_IMP_HEADERS_PVT is not intended for direct invocation from forms or concurrent programs. It is referenced by eight other packages, which act as the public-facing layer that orchestrates header creation, update, and deletion as part of the broader Channel Management import workflow. Custom code should call the corresponding public wrapper APIs rather than this package directly. When troubleshooting the "create_imp_header" search term, developers should verify that the calling package passes a correctly populated imp_headers_rec_type and observes the standard x_return_status and message count outputs to surface validation and processing errors.