Search Results get_deencrypt_string




Overview
Explore in AI Chat

Overview

AMS_IMPORT_SECURITY_PVT is a private PL/SQL package in the Oracle E-Business Suite APPS schema that supports the Oracle Marketing (AMS) import infrastructure by providing cryptographic and obfuscation services for data loaded through the AMS import process. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner, and it is classified as a PVT (private) API in the ETRM repository. Private APIs are internal implementation packages not intended as public integration surfaces, and they may change without notice between releases.

The header record dates the package's creation to 07-NOV-2002, with the source control header amsvimss.pls at version 115.1. The package addresses a specific requirement of the marketing import flow: when sensitive values such as passwords or credentials are stored in or passed through import list header records, those values must be either encrypted before persistence or decrypted for use during processing. The single exposed function encapsulates both directions of that operation behind a flag parameter, giving the import process a consistent, reusable security routine.

Key Procedures and Functions

Only one function is documented in the ETRM metadata:

  • GET_DEENCRYPT_STRING — A function returning a VARCHAR2 value. It takes an input string, a header identifier, and a boolean flag indicating whether the operation is an encryption or a decryption. The name and the comment on the encrypt flag indicate the function performs either encryption or decryption of the supplied string depending on the flag value, and the header identifier contextualizes the operation against an import list header record.

The function signature is deliberately narrow, exposing a single entry point for both directions of the transformation. Parameter lists are not reproduced here beyond what the documented signature shows, and no other functions or procedures are registered for this package.

Tables Accessed

The ETRM metadata records the following table and package dependencies, resolved through APPS synonyms where applicable:

  • AMS_IMP_LIST_HEADERS_ALL — The import list headers table for Oracle Marketing. This table holds header-level information for import lists, and the header identifier passed into GET_DEENCRYPT_STRING is used to locate or bind against the relevant header row.
  • DBMS_OBFUSCATION_TOOLKIT — The Oracle-supplied cryptographic toolkit used in earlier database releases to perform DES-based encryption and decryption. This package supplies the actual cipher operations that GET_DEENCRYPT_STRING wraps.
  • DBMS_UTILITY — A general-purpose PL/SQL utility package, typically used here for supporting functions such as string manipulation, formatting, or error handling within the encryption and decryption routine.

Usage Notes

Because AMS_IMPORT_SECURITY_PVT is classified as PVT, it is invoked by other AMS packages rather than by external callers; the ETRM metadata confirms it is referenced by two other packages. Those referencing packages are the internal consumers during the import of marketing list data. Typical invocation therefore occurs from concurrent programs and internal import processing logic that stage records into AMS_IMP_LIST_HEADERS_ALL, or from custom code that must interoperate with the same stored ciphertext.

The use of DBMS_OBFUSCATION_TOOLKIT is significant for release planning. That toolkit was deprecated in favor of DBMS_CRYPTO in later database versions, so on 12.1.1 and 12.2.2 installations the package continues to depend on a legacy cryptographic interface. Customizations should not call this private package directly; instead, any requirement to encrypt or decrypt import-related values should be implemented with DBMS_CRYPTO or handled through the supported AMS import APIs. Because it is private, its signature, behavior, and dependencies are subject to change in patching and are not covered by Oracle's public API compatibility guarantees.